Changeset 132 for db/character.php

Timestamp:

Nov 17, 2007, 7:51:18 PM (17 years ago)

Author:

hosiplan

Message:

+ Heartstone - Funkce, díky které se může hráč sám portnout "domů"
+ XP restarter - Funkce, která umí nastavit XP na 0
+ Vylepšen export characteru

File:

• db/character.php (modified) (3 diffs)

db/character.php

@@ -41 +41 @@
 /* ############### Konec Nastavení scriptu ############### */ 
 
-
-  
-  $nick = $_POST['username']; $heslo = $_POST['pass'];
-  $zakodovane_heslo = sha1(STRTOUPPER($nick).":".STRTOUPPER($heslo)); 
-
-  SwitchDB(2); // nastavení databáze na realmd
-  $sql_acc = @mysql_query("SELECT * FROM `account` WHERE (`username`='$nick' AND `I`='$zakodovane_heslo') LIMIT 1 "); 
-  if( mysql_num_rows($sql_acc) == 1 ) {
-    $sql_acc = mysql_fetch_array($sql_acc);
-
-    SwitchDB(1); // nastavení databáze na mangos
-    $sql_user = @mysql_query("SELECT * FROM `character` WHERE `guid`='".addslashes($_POST['char'])."' AND `account`='".$sql_acc['id']."' LIMIT 1 "); 
+    $sql_user = @mysql_query("SELECT * FROM `character` WHERE `guid`='".addslashes($_GET['char'])."' AND `account`='".$user['acc']."' LIMIT 1 ");
     if( mysql_num_rows($sql_user) == 1 ) {
       $sql_user = mysql_fetch_array($sql_user);
@@ -58 +47 @@
       SwitchDB(3); // nastavení databáze na web
       $limit_sql = mysql_query("SELECT * FROM `acc_down_char` WHERE (`acc`='".$sql_user['account']."' AND `char`='".$sql_user['guid']."') ORDER BY `date` DESC");
-      if( mysql_num_rows($limit_sql) > 0 ){ 
+      if( mysql_num_rows($limit_sql) > 0 ){
         $limit_sql = mysql_fetch_array($limit_sql);
         if( date("d-m-Y", $limit_sql['date']) == date("d-m-Y", time()) ){ 
@@ -140 +129 @@
 
       } else { echo "Nemůžete stahovat cizí postavu !"; exit; };
-    } else { echo "Špatný account nebo heslo ! "; exit; };