Changeset 7

Timestamp:

Jun 4, 2008, 11:02:50 AM (16 years ago)

Author:

george

Message:

Opraveno: Nemožnost editace serveru s názvem obsaženým v jiném názvu.

Files:

• includes/classes.php (modified) (1 diff)
• scripts/online.php (modified) (1 diff)
• sql/updates/6_servers.sql (modified) (1 diff)

includes/classes.php

@@ -147 +147 @@
     }
   else {
-    $exist = $db->query_result("SELECT count(*) as pocet FROM `servers` where (`name` like '%".$posted['name']."%' AND NOT `id`=$server_id)");
+    $exist = $db->query_result("SELECT count(*) as pocet FROM `servers` where (`name` like TRIM('".$posted['name']."') AND NOT `id`=$server_id)");
   if ($exist==1)
     {

scripts/online.php

@@ -1 +1 @@
 <?php
 
-require ('../includes/config.php');
+include('../includes/config.php');
 
-$Database = new mysqli($db_config['host'], $db_config['user'], $db_config['pass']);
-$Database->select_db($db_config['name']);
+$Database = new mysqli($db_config['host'], $db_config['user'], $db_config['pass'], $db_config['name']);
+
+if(mysqli_connect_errno()) 
+{
+  printf("Connect failed: %s\n", mysqli_connect_error());
+  exit();
+}
 
 function CheckPortStatus($Ip, $Port)

sql/updates/6_servers.sql

@@ -9 +9 @@
   `players_count` int(11) NOT NULL,
   KEY `server` (`server`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8_czech_ci;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;