Changeset 307 for minimanager/ticket.php

Timestamp:

Mar 13, 2008, 8:18:42 PM (17 years ago)

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

• minimanager/ticket.php (modified) (2 diffs)

minimanager/ticket.php

@@ -47 +47 @@
 
  $query = $sql->query("SELECT character_ticket.ticket_id, character_ticket.guid,SUBSTRING_INDEX(character_ticket.ticket_text,' ',6),
-                                                character_ticket.ticket_category,`character`.name
-                                                FROM character_ticket,`character`
-                                                LEFT JOIN character_ticket k1 ON k1.`guid`=`character`.`guid`
-                                                WHERE character_ticket.guid = `character`.`guid`
+                                                character_ticket.ticket_category,`characters`.name
+                                                FROM character_ticket,`characters`
+                                                LEFT JOIN character_ticket k1 ON k1.`guid`=`characters`.`guid`
+                                                WHERE character_ticket.guid = `characters`.`guid`
                                                 ORDER BY $order_by $order_dir LIMIT $start, $itemperpage");
  $this_page = $sql->num_rows($query);
@@ -139 +139 @@
 
  $query = $sql->query("SELECT character_ticket.guid, character_ticket.ticket_text,
-                                                character_ticket.ticket_category,`character`.name
-                                                FROM character_ticket,`character`
-                                                LEFT JOIN character_ticket k1 ON k1.`guid`=`character`.`guid`
-                                                WHERE character_ticket.guid = `character`.`guid` AND character_ticket.ticket_id = '$id'");
+                                                character_ticket.ticket_category,`characters`.name
+                                                FROM character_ticket,`characters`
+                                                LEFT JOIN character_ticket k1 ON k1.`guid`=`characters`.`guid`
+                                                WHERE character_ticket.guid = `characters`.`guid` AND character_ticket.ticket_id = '$id'");
 
  if ($ticket = $sql->fetch_row($query)) {