<?

$dbserver = "localhost";
#$dbserver = "";
$dbuser = "";
$dbpassword = "";
#$dbpassword = "";
$dbname = "RC_WORLD"; # rc5world;
$dbrealm = "RC_REALM";
$dbchar = "RC_CHAR";
#$dbchar = "";

$link=mysql_connect ($dbserver,$dbuser,$dbpassword) or die ("spojenie neuspesne.");
$db = mysql_select_db($dbname, $link) or die ("nepodarilo sa otvorit databazu.");
#$db = mysql_select_db($dbchar, $link) or die ("nepodarilo sa otvorit databazu.");


$action = $_GET['action'];

if ($action == 'get_coords') {
   $guid = mysql_escape_string($_GET['guid']);

   $query="SELECT position_x,position_y FROM $dbchar.`characters` WHERE guid='".$guid."'";

   $result=mysql_query($query, $link) or die ("zly sql dotaz, ziadny vysledok");
   $num=mysql_num_rows($result);
#   $zones=count($zone_name);
   $row=mysql_fetch_array($result);

   echo $row['position_x'] . "|" . $row['position_y'] . "\n";

} elseif ($action == 'get_ip') {
   $guid = mysql_escape_string($_GET['guid']);

   $query="SELECT rdb.id,rdb.last_ip FROM $dbrealm.`account` AS rdb INNER JOIN $dbchar.`characters` AS db ON (rdb.id=db.account) WHERE db.guid='".$guid."'";
   $result=mysql_query($query, $link) or die ("zly sql dotaz, ziadny vysledok");
   $num=mysql_num_rows($result);
#   $zones=count($zone_name);
   $row=mysql_fetch_array($result);

   echo $row['id'] . "|" . $row['last_ip'] . "\n";


} else {
#   $query="SELECT db.name,db.race,db.class,db.map,db.zone,db.level, SUBSTRING_INDEX(SUBSTRING_INDEX(db.`data`, ' ', 133), ' ', -1) AS gender,position_x,position_y,raa.gmlevel,db.guid,db2.instance,db4.leaderGuid=db.guid AS leader,rdb.id AS account_id,rdb.last_ip,bp.bg_guid,bp.bg_type FROM $dbrealm.`account` AS rdb INNER JOIN $dbchar.`characters` AS db ON (rdb.id=db.account) LEFT JOIN $dbchar.`character_instance` AS db2 ON (db.guid=db2.guid) LEFT JOIN $dbchar.`instance` AS db3 ON (db2.instance=db3.id) LEFT JOIN $dbchar.`group_instance` AS db4 ON (db2.instance=db4.instance) LEFT JOIN $dbchar.`bg_players` AS bp ON (db.guid=bp.pl_guid) LEFT JOIN RC_REALM.`account_access` AS raa ON (raa.id=db.account)  WHERE db.online=1 GROUP BY db.guid";
   $query="SELECT db.name,db.race,db.class,db.map,db.zone,db.level,db.gender,position_x,position_y,raa.gmlevel,db.guid,0 AS instance,0 AS leader,rdb.id AS account_id,rdb.last_ip,0 AS bg_guid,0 AS bg_type FROM $dbrealm.`account` AS rdb INNER JOIN $dbchar.`characters` AS db ON (rdb.id=db.account) LEFT JOIN $dbchar.`character_instance` AS db2 ON (db.guid=db2.guid) LEFT JOIN $dbchar.`instance` AS db3 ON (db2.instance=db3.id) LEFT JOIN $dbchar.`group_instance` AS db4 ON (db2.instance=db4.instance) LEFT JOIN $dbchar.`bg_players` AS bp ON (db.guid=bp.pl_guid) LEFT JOIN RC_REALM.`account_access` AS raa ON (raa.id=db.account)  WHERE db.online=1 GROUP BY db.guid";
#print $query;
#   $query="SELECT db.name,db.race,db.class,db.map,db.zone,SUBSTRING_INDEX(SUBSTRING_INDEX(db.`data`, ' ', 54), ' ', -1) AS level, SUBSTRING_INDEX(SUBSTRING_INDEX(db.`data`, ' ', 133), ' ', -1) AS gender,position_x,position_y,'0' AS gmlevel,db.guid,db2.instance,db4.leaderGuid=db.guid AS leader,'-1' AS account_id,'0.0.0.0' AS last_ip,bp.bg_guid,bp.bg_type FROM $dbchar.`characters` AS db LEFT JOIN $dbchar.`character_instance` AS db2 ON (db.guid=db2.guid) LEFT JOIN $dbchar.`instance` AS db3 ON (db2.instance=db3.id) LEFT JOIN $dbchar.`group_instance` AS db4 ON (db2.instance=db4.instance) LEFT JOIN $dbchar.`bg_players` AS bp ON (db.guid=bp.pl_guid) WHERE db.online=1 GROUP BY db.guid";

#print $query;



   $result=mysql_query($query, $link) or die ("zly sql dotaz, ziadny vysledok");
   $num=mysql_num_rows($result);
#   $zones=count($zone_name);
   while ($row=mysql_fetch_array($result)) {
     echo $row['level'] . "|" . $row['name'] . "|" . $row['race'] . "|" . $row['class'] . "|" . $row['map'] . "|" . $row['zone'] . "|" . $row['gmlevel'] . "|" . $row['guid'] . "|" . $row['instance'] . "|" . $row['leader'] . "|" . $row['bg_guid'] . "|" . $row['bg_type'] . "\n";
  }

}
mysql_free_result($result);

?>