Changeset 132 for db

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

Location:

db

Files:

• character.php (modified) (3 diffs)
• databaze_tabulky/sql.sql (modified) (1 diff)
• include/myacc.php (modified) (1 diff)
• include/position_reset.php (added)
• include/xp_reset.php (added)
• index.php (modified) (1 diff)
• post_read.php (modified) (1 diff)

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; };
 
 

db/databaze_tabulky/sql.sql

@@ -187 +187 @@
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
+
+-- 
+-- Struktura tabulky `acc_heartstone`
+-- 
+-- Vytvoření: Sobota 17. listopadu 2007, 19:00
+-- Poslední změna: Sobota 17. listopadu 2007, 19:00
+-- 
+
+CREATE TABLE `acc_heartstone` (
+`id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`acc` BIGINT( 20 ) UNSIGNED NOT NULL ,
+`char` BIGINT( 20 ) UNSIGNED NOT NULL ,
+`date` BIGINT( 20 ) UNSIGNED NOT NULL ,
+`ip` VARCHAR( 15 ) NOT NULL
+) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

db/include/myacc.php

@@ -1 +1 @@
 <?php
 if (!defined('IN_CODE') OR $user['loged'] != 1 ){ exit; };
+  
+  $sql_select = $BasicWiewer->myAcc();
 
-  $sql_select = $BasicWiewer->myAcc();
+  require_once './include/position_reset.php';
+  require_once './include/xp_reset.php';
+
+  if( !empty($_GET['heartstone']) AND is_numeric($_GET['heartstone']) )
+  {
+    SwitchDB(3); // nastavení databáze na web
+    $limit_sql = mysql_query("SELECT * FROM `acc_heartstone` WHERE (`acc`='".$sql_select['result']['acc']['id']."' AND `char`='".$_GET['heartstone']."') ORDER BY `date` DESC LIMIT 1");
+    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()) ){ 
+        SwitchDB(1); // nastavení databáze na mangos
+        $PosRess = new PosRess($_GET['heartstone']);
+        if( $PosRess->char_name != false ){
+          $PosRess->GoHome();
+          $PosRess->GoHomeDone();
+          SwitchDB(3); // nastavení databáze na web
+          mysql_query("INSERT INTO `acc_heartstone` (`acc`,`char`,`date`,`ip`) VALUES ('".$sql_select['result']['acc']['id']."','".$_GET['heartstone']."','".time()."','".$_SERVER["REMOTE_ADDR"]."')  ");
+          };
+        };
+      };
+  };
+
+  if( !empty($_GET['resetxp']) AND is_numeric($_GET['resetxp']) )
+  {
+    SwitchDB(1); // nastavení databáze na mangos
+    $XpRess = new XpRess(4);
+    $XpRess->ShowXp();
+    $XpRess->XpRestart();
+    $XpRess->XpRestartDone();
+  };
+  
+
 ?>
 

db/index.php

@@ -195 +195 @@
 
     switch($id){ 
-      case 'character': $general_include = "./character.php"; break;
+      case 'char': $general_include = "./character.php"; break;
       default: $general_include = "./hlavni.php"; break;
       };

db/post_read.php

@@ -694 +694 @@
           $this->sql_select['result']['other']['chars'] .= "<td title=\"Rasa\">".$Database['race'][$this->sql_select['result']['char'][$i]['race']]."</td>";
           $this->sql_select['result']['other']['chars'] .= "<td title=\"Povolání\">".$Database['class'][$this->sql_select['result']['char'][$i]['class']]."</td>\n";
-          $this->sql_select['result']['other']['chars'] .= "<td> - <a href=\"./character.php?char=".$this->sql_select['result']['char'][$i]['guid'].$this->sid."\">Exportovat</a></td></tr>\n";
+          $this->sql_select['result']['other']['chars'] .= "<td> - <a href=\"./index.php?char=".$this->sql_select['result']['char'][$i]['guid'].$this->sid."\" target=\"_blank\">Exportovat</a></td>\n";
+          $this->sql_select['result']['other']['chars'] .= "<td> - <a href=\"./index.php?id=myacc&amp;heartstone=".$this->sql_select['result']['char'][$i]['guid'].$this->sid."\">Heartstone</a></td>\n";
+          $this->sql_select['result']['other']['chars'] .= "<td> - <a href=\"./index.php?id=myacc&amp;resetxp=".$this->sql_select['result']['char'][$i]['guid'].$this->sid."\">ResetXP</a></td></tr>\n";
           }; 
         if( $this->sql_select['result']['char_count'] == 0 ){