Changeset 380

Timestamp:

Sep 23, 2008, 7:40:43 AM (16 years ago)

Author:

george

Message:

• Přidáno: Stránka ticketů beta webu.
• Přidáno: Export guild.

Location:

beta

Files:

• export (added)
• export/guilda.php (added)
• inc/player.php (modified) (13 diffs)
• inc/server.php (modified) (5 diffs)
• pages/tickets.php (added)

beta/inc/player.php

@@ -3 +3 @@
   var $SessionTimeout = 30;
   private $db;
-      // --
+      // -- done
       function __construct ($db)
       {
         $this -> db = &$db;
       }
-      // --
+      // -- done
       private function Msg($text,$err)
       {
@@ -20 +20 @@
         }
       }
-      // --
+      // -- err
       public function Register ($acc_name , $pass , $email , $tbc)
       {
@@ -30 +30 @@
           $sql = $this -> db -> query("
           INSERT INTO `account` ( `id` , `username` , `sha_pass_hash` , `gmlevel` , `sessionkey` , `v` , `s` , `email` , `joindate` , `last_ip` , `failed_logins` , `locked` , `last_login` , `online` , `tbc` , `mutetime` , `locale` )
-          VALUES (NULL , '".$acc_name."', '".$sha_pass."', '0', NULL , NULL , NULL , '".$email."',CURRENT_TIMESTAMP , '".$_SERVER['REMOTE_ADDR']."', '0', '0', '0000-00-00 00:00:00', '0', '".$tbc."', '0', '0'
+          VALUES (NULL , '".$acc_name."', '".$sha_pass."', '0', NULL , NULL , NULL , '".$email."',CURRENT_TIMESTAMP , '".$_SERVER['REMOTE_ADDR']."', '0', '0', '0000-00-00 00:00:00', '0', '".$tbc."', '0', '0');
           ");
           $this -> Msg ("Účet založen úspěšně",0);
@@ -42 +42 @@
       
       }
-      // --
+      // -- done
       public function Login ($username,$pass)
       {
@@ -62 +62 @@
         }
       }
-      // --
+      // -- done
       public function Logout ()
       {
@@ -70 +70 @@
         $this -> Recall(1);
       }
-      // --
+      // -- done
       public function Check ()
       {
@@ -82 +82 @@
         return($_SESSION["UserId"] != 0);
       }
-      // --
+      // -- done
       public function LoginForm()
       {
@@ -112 +112 @@
         return $row["level"];
       }
-      // --
+      // -- done
       public function GetGmLvl ()
       {
@@ -120 +120 @@
         return $row["gmlevel"];
       }
-      // --
+      // -- done
       public function GetPlayerClass($id)
       {
@@ -156 +156 @@
         }
       }
-      // --
+      // -- done
       public function GetPlayerRace($id)
       {
@@ -198 +198 @@
         }
       }
-      // --
+      // -- done
       public function ResetXP ($guid)
       {
@@ -218 +218 @@
         {$this -> Msg ("Tato postava není vaše.",1);}
       }
-      // --
+      // -- done
       public function ResetPosition ($guid)
       {
@@ -248 +248 @@
         {$this -> Msg ("Tato postava není vaše.",1);}
       }
-      // --
+      // -- done
       public function IsOnline ($guid)
       {

beta/inc/server.php

@@ -5 +5 @@
       {
         $this -> db = $db;
+      }
+      // --
+      public function HumanDate ($date)
+      {
+        // input date is 0000-00-00 00:00:00
+        $date_arr = explode(" ",$date);
+        $date = explode("-",$date_arr[0]);
+        $time_stp = explode(":",$date_arr[1]);
+        $time = mktime($time_stp[0],$time_stp[1],$time_stp[2],$date[1],$date[2],$date[0]);
+        $human_date = date ("d.m.Y H:i:s",$time);
+        return $human_date;
       }
       // --
@@ -78 +89 @@
         $row = $this -> db -> query("SELECT COUNT(*) FROM account") -> fetch_array();
         return($row[0]);
-      }
-      // --
-      public function FindDrop ($item)
-      {
-        $this -> db -> select_db("mangos");
-        $sql = $this -> db -> query("SELECT * FROM `creature_loot_template` WHERE `item` = '".$item."' ORDER BY ;");
-        while ($row = $sql -> fetch_array())
-        {
-        echo "
-              <table>
-                <tr>
-                  <td>Šance</td>
-                  <td></td>
-                </tr>
-              </table>
-        ";
-        }
-        
-      
-      }
-      // --
-      public function FindNpc ($npc)
-      {
-        $this -> db -> select_db("mangos");
       }
       // --
@@ -141 +128 @@
             else
             {$sel_name = "";}
-              $date_arr = explode(" ",$edited_arr[0]);
-              $date = explode("-",$date_arr[0]);
-              $time_stp = explode(":",$date_arr[1]);
-              $time = mktime($time_stp[0],$time_stp[1],$time_stp[2],$date[1],$date[2],$date[0]);
-              $human_date = date ("d.m.Y H:i:s",$time);
+              $human_date = $this -> HumanDate ($edited_arr[0]);
            echo "
           <tr>
@@ -163 +146 @@
             $edited = str_replace(")", "", $edited);
             $edited_arr = explode(";",$edited);
-            
-              $date_arr = explode(" ",$edited_arr[0]);
-              $date = explode("-",$date_arr[0]);
-              $time_stp = explode(":",$date_arr[1]);
-              $time = mktime($time_stp[0],$time_stp[1],$time_stp[2],$date[1],$date[2],$date[0]);
-              $human_date = date ("d.m.Y H:i:s",$time);
-
+              $human_date = $this -> HumanDate ($edited_arr[0]);
           echo "
           <tr>
@@ -189 +166 @@
             $edited_arr = explode(";",$edited);
             
-              $date_arr = explode(" ",$edited_arr[0]);
-              $date = explode("-",$date_arr[0]);
-              $time_stp = explode(":",$date_arr[1]);
-              $time = mktime($time_stp[0],$time_stp[1],$time_stp[2],$date[1],$date[2],$date[0]);
-              $human_date = date ("d.m.Y H:i:s",$time);
+            $human_date = $this -> HumanDate ($edited_arr[0]);
           echo "
           <tr>