Life is Feudal Official Forum

[Cogollops]

Using the parameter "$ Server" on mysql_connect, do not connect properly, and when I change the ip directly connecting chips but I error: Parse error: syntax .....
And when I use the parameter that should be properly, I jump with this error:

Deprecated: mysql_connect (): The mysql extension is deprecated and will be removed in the future: Instead use mysqli or PDO in /home/xxxxxxxx/public_html/map/map.php on line 7

Warning: mysql_connect (): Access denied for user 'lif_1'@'xx.xxx.xxx.xx' (using password: YES) in /home/xxxxxxxx/public_html/map/map.php on line 7
cant connect to DB: Access denied for user 'lif_1'@'xx.xxx.xxx.xx' (using password: YES)

The funny thing is that I ip appears in lif_1@xx.xxx.xxx.xx, does not correspond with my MariaDB ip, ip displayed is the web hosting that hosts the map.php archive and no longer what to do...

It may be due to some configuration MariaDB does not accept external connections well ????
There are some command settings for MariaDB in the my.ini file or some other?

Thank you for your patience.

[MacDante]

Warning: mysql_connect (): Access denied for user 'lif_1'@'xx.xxx.xxx.xx'

That mean you don't have access to DB from this user from External connect. Only you can enter to DB via local connection.

You must change for this user privileges on SQL server.

[Cogollops]

I work anymore map online!; visit it, please: Clic here!

Now I just have to figure out why I get this error:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/xxxxxxxxx/public_html/map/index.php on line 7

I can only fix this error .
I would also like to know if you can add other information on the map ( players , weather conditions or other details of the server) , or bring the cursor on a guild , which appeared a list of members within the guild .

I hope your answer , thank you very much !

[Kortal]

Thanks MacDante for your great work.
I have updated a bit the code and added some more other things.

+ updated to mysqli
+ migrated config to a separated file
+ grid on mouse over the map
+ guild members list on mouse over the guild claim
+ optional online count: need to have lifdscp (lif-dedicated-server-control-panel-lifds-cp-t15168/)
+ optional online player list: need to have lifdscp (lif-dedicated-server-control-panel-lifds-cp-t15168/)
+ optional weather display (today and tomorrow): need to copy the cm_weather1.xml file into map folder

css by Jakommo.



download: https://mega.nz/#!k84kwbJI!yet-vK3qqPAh ... RZjPb-XXSY

[Cogollops]

OMG, thank you very much!

[Cogollops]

Other error:

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in /home/u898016643/public_html/map/index.php on line 87

Please, help!

[Cogollops]

Since it was discovered , it works perfectly , thanks also!

[MacDante]

Some players ask me how show players position on map. Ok i show how, but this isnfo is TOP METAGAMING info nad can broke any fair play.

Code: Select all

<?

$sql = "select *, (GeoID >> 18) as terID,(GeoID & ((1 << 9) - 1)) as `x`, ((GeoID >> 9) & ((1 << (9)) - 1)) as `y`  from `character` where IsActive=1";

$res = mysql_query($sql) or die("sql error: " . mysql_error());
$sum_players = mysql_num_rows($res);
      $sum_players=0;
   while( $row = mysql_fetch_array($res) ) {
      $x=0;
      $y=0;
      $size = $_POST['size'];
      $name = $row['Name']." ".$row['LastName'];
   
      if ($row['terID'] == 442) {
         $y=1533-$row['y'];
         $x=$row['x'];
      }
      else if ($row['terID'] == 443) {
         $y=1533-$row['y'];
         $x=$row['x']+511;         
      }
      else if ($row['terID'] == 444) {
         $y=1533-$row['y'];
         $x=$row['x']+1022;         
      }
      else if ($row['terID'] == 445) {
         $y=1022-$row['y'];
         $x=$row['x'];         
      }
      else if ($row['terID'] == 446) {
         $y=1022-$row['y'];
         $x=$row['x']+511;         
      }
      else if ($row['terID'] == 447) {
         $y=1022-$row['y'];
         $x=$row['x']+1022;         
      }
      else if ($row['terID'] == 448) {
         $y=511-$row['y'];
         $x=$row['x'];         
      }
      else if ($row['terID'] == 449) {
         $y=511-$row['y'];
         $x=$row['x']+511;         
      }            
      else if ($row['terID'] == 450) {
         $y=511-$row['y'];
         $x=$row['x']+1022;         
      }                                 
      print "<div style='border: 1px; background: red;' class='player' title='player: $name' style='left:".($x-(2))."px; top: ".($y-(2))."px; ' ></div>";
   }
   print "<div style='position: absolute; margin:0; padding: 0; background: green; width: 1px; height: 1px; left: 1px; top:1533px'></div>";
?>      


You should add this code between start <div class='map> and end </div>

remember its show last known player position, if you want show actual you should refresh browser (its not dynamical)

[Cogollops]

Thank, very much!

[Cogollops]

It does not work correctly!

[MacDante]

any error ? or what ?

[Cogollops]

No, excuse me for not specifying the problem.
Php error does not appear on the page, just only see the guild's me as before, the players do not appear.

Web: http://cogollops.es/MAP

[MacDante]

its simple my scrip is to MYSQL and you use script to MYSQLI.

Propobably correct script to MYSQLII should be this:

Code: Select all

$sql = "select *, (GeoID >> 18) as terID,(GeoID & ((1 << 9) - 1)) as `x`, ((GeoID >> 9) & ((1 << (9)) - 1)) as `y`  from `character` where IsActive=1";


$res = mysqli_query($db_handle, $sql) or die("error: " . mysqli_error($db_handle));
$sum_players=0;
   while( $row = mysqli_fetch_array($res) ) {
      $x=0;
      $y=0;
      $size = $_POST['size'];
      $name = $row['Name']." ".$row['LastName'];
   
      if ($row['terID'] == 442) {
         $y=1533-$row['y'];
         $x=$row['x'];
      }
      else if ($row['terID'] == 443) {
         $y=1533-$row['y'];
         $x=$row['x']+511;         
      }
      else if ($row['terID'] == 444) {
         $y=1533-$row['y'];
         $x=$row['x']+1022;         
      }
      else if ($row['terID'] == 445) {
         $y=1022-$row['y'];
         $x=$row['x'];         
      }
      else if ($row['terID'] == 446) {
         $y=1022-$row['y'];
         $x=$row['x']+511;         
      }
      else if ($row['terID'] == 447) {
         $y=1022-$row['y'];
         $x=$row['x']+1022;         
      }
      else if ($row['terID'] == 448) {
         $y=511-$row['y'];
         $x=$row['x'];         
      }
      else if ($row['terID'] == 449) {
         $y=511-$row['y'];
         $x=$row['x']+511;         
      }           
      else if ($row['terID'] == 450) {
         $y=511-$row['y'];
         $x=$row['x']+1022;         
      }                                 
      print "<div style='border: 1px; background: red;' class='player' title='player: $name' style='left:".($x-(2))."px; top: ".($y-(2))."px; ' ></div>";
   }
   print "<div style='position: absolute; margin:0; padding: 0; background: green; width: 1px; height: 1px; left: 1px; top:1533px'></div>";

[Cogollops]

I does not work, you pass a link to the code used:

http://pastebin.com/b5Ps1JmZ


I do not understand why

[MacDante]

i dont know how it happen but is error inline

is

Code: Select all

print "<div style='border: 1px; background: red;' class='player' title='player: $name' style='left:".($x-(2))."px; top: ".($y-(2))."px; ' ></div>";

sholud be:

Code: Select all

print "<div style='border: 1px solid yellow; background: yellow; left:".($x-(2))."px; top: ".($y-(2))."px; width: 2px; height: 2px; position: absolute;' class='player' title='player: $name' ></div>";


PS: i dont use table 'lifdscp_online_character', but if is in this table position with player last position, this script can show only online players. But now show all active players registered on server.

[Cogollops]

Thanks, it works!

So you could have this same map, showing the guilds and players unused -> lifdscp_online_character ???

Could you tell me how to change that please?

And one thing I also wanted to comment on, the player that are within the radius of the guild, when I put the cursor over the player's information for the guild but I get Player.

Again, thanks for everything, I hope your answer.

[MacDante]

in player line in style add: z-index: 100;

print "<div style='z-index: 100; border: 1px solid yellow; background: yellow; left:".($x-(2))."px; top: ".($y-(2))."px; width: 2px; height: 2px; position: absolute;' class='player' title='player: $name' ></div>";

[Cogollops]

Okay , now how you could use this script without using lifdscp_online_character ???

I imagine and it makes sense to connect this script with the database, but any configuration changes lifdscp_online_character ???

I await your response with many thanks.

[MacDante]

i don't use 'lifdscp_online_character' and i can't see actual online players (Jugadores Conectados)
And i don't know what is stored in 'lifdscp_online_character ' and when is saved.

I dont have anny idea whether in this table is store last player position or not (if is then you can use this table to show only online players on the map).

[Cogollops]

You could replace the lifdscp_online_character, for this other script baron_players, I found these forums also:

http://pastebin.com/ht8TxHxm

Whichever way is and tell me what you think, thanks.

[Nathorus]

Pls help me,

i dont understand , in need the PHP script pls

Thx for Help

[Nathorus]

Okay sry Guys,

my map is Online, thx for this nice Simple Map

[Kortal]

@MacDante, would it be possible to add the player ip in the tables lifdscp_online_character and lifdscp_online_character ?

[MacDante]

Probably is this possibility, but not from my side. I don't use this table on my server and don't change it.

[Halvdal]

If you want to show online players you should use this:
http://lifeisfeudal.com/forum/lif-baron-script-get-all-currently-active-players-t3364/

Here you find the script: http://pastebin.com/h2t5yev4
(Save it as baron.cs)

You have to create a new table named "baron_players" and in this table you create a column named "CharacterID". Then you can upload the baron.cs into your LiF server main directory, open your main.cs and add exec("baron.cs"); at the end of the file.

Then you have to edit the index.php and edit the line $sql = "SELECT * FROM `lifdscp_online_character`"; into $sql = "SELECT * FROM `baron_players`";.


Thats it!

[Kortal]

Probably is this possibility, but not from my side. I don't use this table on my server and don't change it.

yeah sorry, was just an example, any table would be fine lol
a new table, or the "account" table for example

Halvdal, thanks, but this doesnt match ip to a player, or ... did i miss something ?

[K475u]

Thanks MacDante for your great work.
I have updated a bit the code and added some more other things.

+ updated to mysqli
+ migrated config to a separated file
+ grid on mouse over the map
+ guild members list on mouse over the guild claim
+ optional online count: need to have lifdscp (lif-dedicated-server-control-panel-lifds-cp-t15168/)
+ optional online player list: need to have lifdscp (lif-dedicated-server-control-panel-lifds-cp-t15168/)
+ optional weather display (today and tomorrow): need to copy the cm_weather1.xml file into map folder

css by Jakommo.



download: https://mega.nz/#!k84kwbJI!yet-vK3qqPAh ... RZjPb-XXSY

Hey There,

Thanks for the map! Is it possible to Print the Ingame Time and Date on it instead of the RL Time and Date ?

[Seregaman]

Thank you for Live MAP.
Everything works fine.
But the weather is not displayed.
(cm_weather1.xml file is in the folder MAP)

Code: Select all

if (file_exists('./cm_weather1.xml')) {
   $data = file_get_contents('./cm_weather1.xml', true);
   $pos = strpos($data, "=" . $daynumber .">");
   $weather=substr($data, $pos+2+strlen($daynumber), 15);
   $weather=substr($weather, 0, strpos($weather,"<"));

   $daynumber2 = $daynumber + 1;
   if ($daynumber == 364) { $daynumber2 = 1;}
   $pos = strpos($data, "=" . $daynumber2 .">");
   $weather2=substr($data, $pos+2+strlen($daynumber2), 15);
   $weather2=substr($weather2, 0, strpos($weather2,"<"));

   $infos = $infos . "Погода: " . $weather ." (завтра:". $weather2 . ")<br />";

Help please, what could be wrong.

[Dragodor]

Hello,
it works fine!

But 2 questions:

1. I can't find the "cm_weather1.xml". Where do I have to download it?
2. How can I deactivate the player names in the claim-tooltips?

Best Wishes,
Dragodor

[SnowSharky]

Hello,
it works fine!

But 2 questions:

1. I can't find the "cm_weather1.xml". Where do I have to download it?
2. How can I deactivate the player names in the claim-tooltips?

Best Wishes,
Dragodor

1. Its found in

Steam\steamapps\common\Life is Feudal Your Own Dedicated Server\data\weather

Tried messing around with the weather, assuming the format must have been changed as it doesnt seem to work anymore.

2. Go into the index.php and remove

{$guildmembers = $guildmembers . $db_field['Name'] . " " . $db_field['LastName'] . ", "; }

Should remove the names from being displayed, tho the popup will still show up