Changeset 309

Timestamp:

Mar 13, 2008, 8:45:46 PM (17 years ago)

Author:

george

Message:

Opravy související s přejmenování sloupce character na characters.

Files:

• events.php (modified) (3 diffs)
• guildy.php (modified) (4 diffs)
• honor.php (modified) (2 diffs)
• minimanager/pomm_public/pomm_run.php (modified) (5 diffs)
• online_player.php (modified) (2 diffs)

events.php

@@ -38 +38 @@
   
   // Add already started events
-  $DbResult = $Database->select('game_event', '*, UNIX_TIMESTAMP(start) as start', 'end > NOW() AND start < NOW()');
+  $DbResult = $Database->select('game_event', '*, UNIX_TIMESTAMP(start_time) as start', 'end_time > NOW() AND start_time < NOW()');
   while($Row = $DbResult->fetch_array())
   { 
@@ -54 +54 @@
 
   // Add events not started so far
-  $DbResult = $Database->select('game_event', '*, UNIX_TIMESTAMP(start) as start', 'start > NOW()');
+  $DbResult = $Database->select('game_event', '*, UNIX_TIMESTAMP(start_time) as start', 'start_time > NOW()');
   while($Row = $DbResult->fetch_array())
   { 
@@ -81 +81 @@
 ShowHeader();
 
-echo('<h3>Události ve høe:</h3><div align="center">');
+echo('<h3>Ud�losti ve h�e:</h3><div align="center">');
 
 $Events = Events();
 echo('<table class="TableGuilda" border="1" cellpadding="3" cellspacing="0">');
-echo('<tr><th>Název</th><th>Zaèátek</th><th>Konec</th><th>Informace</th><th>Informace</th></tr>');
-echo('<tr><td colspan="5"><strong style="color: yellow;">Aktuálnì bì¾ící akce</strong></td></tr>');
+echo('<tr><th>N�zev</th><th>Za��tek</th><th>Konec</th><th>Informace</th><th>Informace</th></tr>');
+echo('<tr><td colspan="5"><strong style="color: yellow;">Aktu�ln� b���c� akce</strong></td></tr>');
 ShowEventList($Events['Running']);
-echo('<tr><td colspan="5"><strong style="color: yellow;">Plánované akce</strong></td></tr>');
+echo('<tr><td colspan="5"><strong style="color: yellow;">Pl�novan� akce</strong></td></tr>');
 ShowEventList($Events['Planned']);
 echo('</table></div>');

guildy.php

@@ -39 +39 @@
   echo('</tr>');
 //  DB_Query(' COUNT(guild_member.guildid) as member_count FROM guild JOIN guild_member ON guild_member.guildid = guild.guildid GROUP BY guild.name ORDER BY member_count DESC');
-  $Result = $Database->query('SELECT `guild`.homepage, `guild`.name, guild.guildid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", '.(CHAR_DATA_OFFSET_HONOR_POINTS+1).'), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` GROUP BY guild.name ORDER BY '.$order_by.' '.$order_dir);
+  $Result = $Database->query('SELECT `guild`.homepage, `guild`.name, guild.guildid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, " ", 35), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, " ", '.(CHAR_DATA_OFFSET_HONOR_POINTS+1).'), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `characters` ON `characters`.`guid`= `guild_member`.`guid` GROUP BY guild.name ORDER BY '.$order_by.' '.$order_dir);
   while($Guild = $Result->fetch_array())
   {
@@ -49 +49 @@
 } else {
   $GuildId = addslashes($_GET['guild']);
-  $Result = $Database->query('SELECT `guild`.name, guild.guildid, guild.leaderguid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", '.(CHAR_DATA_OFFSET_LEVEL+1).'), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`character`.`data`, " ", '.(CHAR_DATA_OFFSET_HONOR_POINTS+1).'), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `character` ON `character`.`guid`= `guild_member`.`guid` WHERE guild.guildid='.$GuildId.' GROUP BY guild.name');
+  $Result = $Database->query('SELECT `guild`.name, guild.guildid, guild.leaderguid, COUNT(`guild_member`.`guildid`) as member_count, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, " ", '.(CHAR_DATA_OFFSET_LEVEL+1).'), " ", -1)) as guild_level, SUM(SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, " ", '.(CHAR_DATA_OFFSET_HONOR_POINTS+1).'), " ", -1)) as guild_honor FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `characters` ON `characters`.`guid`= `guild_member`.`guid` WHERE guild.guildid='.$GuildId.' GROUP BY guild.name');
   if($Result->num_rows > 0)
   {
@@ -56 +56 @@
     //if($Guild['info'] != '') $Guild['info'] = ''.$Guild['info'].'</i>';
     echo('<h3>Seznam èlenù spolku '.$Guild['name'].'</h3><div align="center">');
-    $Result = $Database->select('character', 'name', $Guild['leaderguid'].'=guid');
+    $Result = $Database->select('characters', 'name', $Guild['leaderguid'].'=guid');
     $GuildMaster = $Result->fetch_array();
     echo('Vedoucí spolku: '.$GuildMaster['name'].'<br>');
@@ -72 +72 @@
     while($GuildRank = $Result->fetch_array()) $GuildRanks[$GuildRank['rid']] = $GuildRank;
   
-    $Result = $Database->query('SELECT guild_member.rank, guild_member.guid, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", '.(CHAR_DATA_OFFSET_LEVEL+1).'), " ", -1)*1 as level, SUBSTRING_INDEX(SUBSTRING_INDEX(character.data," ", '.(CHAR_DATA_OFFSET_HONOR_POINTS+1).'), " ", -1)*1 as honor, character.name FROM guild_member JOIN `character` ON guild_member.guid = character.guid AND guild_member.guildid='.$Guild['guildid'].' ORDER BY '.$order_by.' '.$order_dir);
+    $Result = $Database->query('SELECT guild_member.rank, guild_member.guid, SUBSTRING_INDEX(SUBSTRING_INDEX(characters.data," ", '.(CHAR_DATA_OFFSET_LEVEL+1).'), " ", -1)*1 as level, SUBSTRING_INDEX(SUBSTRING_INDEX(characters.data," ", '.(CHAR_DATA_OFFSET_HONOR_POINTS+1).'), " ", -1)*1 as honor, characters.name FROM guild_member JOIN `characters` ON guild_member.guid = characters.guid AND guild_member.guildid='.$Guild['guildid'].' ORDER BY '.$order_by.' '.$order_dir);
     while($Member = $Result->fetch_array())
     {

honor.php

@@ -34 +34 @@
         $order_dir = ($dir) ? "ASC" : "DESC";
         
-        $result = $Database->query("SELECT count(*) FROM `character`");
+        $result = $Database->query("SELECT count(*) FROM `characters`");
         $Row = $result->fetch_array();
         $total_online = $Row[0];
@@ -48 +48 @@
                         CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS highest_rank,
                         CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1).'), " ", -1) AS UNSIGNED) AS level,account
-                        FROM `character` WHERE 1 '.$order_side.' ORDER BY '.$order_by.' '.$order_dir.' LIMIT '.$Page*$PerPage.','.$PerPage);
+                        FROM `characters` WHERE 1 '.$order_side.' ORDER BY '.$order_by.' '.$order_dir.' LIMIT '.$Page*$PerPage.','.$PerPage);
 
         require_once("minimanager/lang/enUS.php");

minimanager/pomm_public/pomm_run.php

@@ -3 +3 @@
  * Project Name: MiniManager for Mangos Server
  * Date: 17.10.2006 inital version (0.0.1a)
- * Author: Q.SA (thanks to mirage666 for the original idea) 
+ * Author: Q.SA (thanks to mirage666 for the original idea)
  * Copyright: Q.SA
  * Email: *****
@@ -18 +18 @@
 
 if( !$user_lvl && !$server[$realm_id]['both_factions']){
-        $result = $sql->query("SELECT race FROM `character` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `character` WHERE account = '$user_id') LIMIT 1");
+        $result = $sql->query("SELECT race FROM `characters` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `characters` WHERE account = '$user_id') LIMIT 1");
         if ($sql->num_rows($result)){
                 $order_side = (in_array($sql->result($result, 0, 'race'),array(2,5,6,8,10))) ?
@@ -27 +27 @@
 $result = $sql->query("SELECT name,race,class,position_x,position_y,map,SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1),
                 SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 37), ' ', -1),zone
-                FROM `character` WHERE `online`= 1 $order_side");
+                FROM `characters` WHERE `online`= 1 $order_side");
 
 $i = 0;
@@ -33 +33 @@
         $char_gender = str_pad(dechex($char[7]),8, 0, STR_PAD_LEFT);
 
-        $pos = get_player_position($char[3],$char[4],$char[5],$char[8]); 
+        $pos = get_player_position($char[3],$char[4],$char[5],$char[8]);
         $arr[$i]['x'] = $pos['x'];
         $arr[$i]['y'] = $pos['y'];
@@ -48 +48 @@
 $sql->close();
 
-$_RESULT =$arr; 
+$_RESULT =$arr;
 ?>

online_player.php

@@ -13 +13 @@
         $dir = ($dir) ? 0 : 1;
         
-        $result = $Database->query("SELECT count(*) FROM `character` WHERE `online`= 1");
+        $result = $Database->query("SELECT count(*) FROM `characters` WHERE `online`= 1");
         $Row = $result->fetch_array();
         $total_online = $Row[0];
@@ -23 +23 @@
                         CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS highest_rank,
                         CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1) AS UNSIGNED) AS level,account
-                        FROM `character` WHERE `online`= 1 $order_side ORDER BY $order_by $order_dir");
+                        FROM `characters` WHERE `online`= 1 $order_side ORDER BY $order_by $order_dir");
 
         require_once("minimanager/lang/enUS.php");