Changeset 597

Timestamp:

May 20, 2009, 12:52:52 PM (15 years ago)

Author:

george

Message:

• Přidáno: Rozšířená databázová třída pro potřeby zobrazení SQL povelů a jejich chyb.
• Opraveno: Chyba výběru databáze realmd na stránce registrace.

Location:

trunk

Files:

• inc/config.sample.php (modified) (2 diffs)
• inc/database.php (added)
• inc/db.php (modified) (1 diff)
• pages/register.php (modified) (2 diffs)
• sql/updates/596.sql (modified) (1 diff)

trunk/inc/config.sample.php

@@ -27 +27 @@
     'DatabaseScriptDev2' => 'scriptdev2',
     'GMCommandsLog' => 'gm_commands.log',
-    'MaxAccountCount' => 13000,
     'CharacterDataOffset' => array
     (
@@ -47 +46 @@
     'Admin' => 'Admin',
     'AdminEmail' => 'admin@localhost',
-    'ShowError' => 0,
+    'ShowError' => false,
     'ErrorLogFile' => 'php_script_error.log',
+    'ShowSQLError' => false,
+    'ShowSQLQuery' => false,
   ),
   'CheckRegistration' => array

trunk/inc/db.php

@@ -2 +2 @@
 
 include('config.php');
+include('database.php');
 
-$db = new mysqli($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password'], $Config['Database']['Database']);
-if(mysqli_connect_errno()) 
+$db = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password'], $Config['Database']['Database']);
+if(mysqli_connect_error()) 
 {
-  die('Přihlášení k MySQL selhalo. '.mysqli_connect_error());
+  die('Přihlášení k databázi selhalo. '.mysqli_connect_error());
 }
-$db->query('SET NAMES '.$Config['Database']['Charset']);
+$db->charset($Config['Database']['Charset']);
 
 ?>

trunk/pages/register.php

@@ -39 +39 @@
   '<br />');
 
-$db->select_db($Config['Mangos']['DatabaseRealmd']);
 if($RegistrationLimit->GetFreeRegistrationCount() == 0)
 {
@@ -62 +61 @@
       $heslo = sha_password($account, $password);
 
+      $db->select_db($Config['Mangos']['DatabaseRealmd']);
       $DbResult = $db->query('SELECT `id`, `username`, `sha_pass_hash` FROM `account` WHERE `username`="'.$account.'"');
       if($DbResult->num_rows > 0)

trunk/sql/updates/596.sql

@@ -2 +2 @@
 `Date` DATE NOT NULL ,
 `Min` INT NOT NULL ,
-`Max` INT NOT NULL
+`Max` INT NOT NULL ,
 `AccountCount` int(11) NOT NULL,
 PRIMARY KEY  (`Date`)