Changeset 109 for db

Timestamp:

Oct 14, 2007, 1:35:47 PM (17 years ago)

Author:

hosiplan

Message:

+ možnost přihlásit se jako v minimanageru tzn. na herní ACC
+ jednoduchá administrace
+ správa bugů z bugreporter
+ export characteru
+ hledání creepů + jejich drop
+ úprava databáze

Location:

db

Files:

• admin (added)
• admin/bugreporter.php (added)
• admin/komentare.php (added)
• admin/obsah.php (added)
• admin/uvod.php (added)
• character.php (added)
• check_database.php (added)
• config.sample.php (modified) (3 diffs)
• css/css.php (modified) (1 diff)
• css/horiz-menu_css.css (added)
• css/zakladni_css.css (modified) (9 diffs)
• databaze_tabulky/sql.sql (modified) (3 diffs)
• hlavni.php (modified) (1 diff)
• include/bug_report.php (modified) (1 diff)
• include/creep.php (modified) (4 diffs)
• include/creeps.php (modified) (1 diff)
• include/login.php (added)
• include/myacc.php (modified) (1 diff)
• index.php (modified) (5 diffs)
• obsah.php (modified) (5 diffs)
• post_read.php (modified) (5 diffs)

db/config.sample.php

@@ -22 +22 @@
     'Description' => 'Neoficiální herní server hry World of Warcraft',
     'Title' => 'Heroes of Fantasy - Databáze',
+    'Abbr' => 'HoF',
     'Admin' => 'Chronos',
     'SubAdmin' => 'HosipLan',
@@ -31 +32 @@
 $Database = array(
   'class' => array(
-    1 => "",
-    2 => ""
+    1 => "Warrior",
+    2 => "Paladin",
+    3 => "Hunter",
+    4 => "Rogue",
+    5 => "Priest",
+    6 => "",
+    7 => "Shaman",
+    8 => "Mage",
+    9 => "Warlock",
+    10 => "",
+    11 => "Druid"
     ),
-  'race' => array(
-    1 => "",
-    2 => ""
+  'race' => array( 
+    1 => "Human",
+    2 => "Orc",
+    3 => "Dwarf",
+    4 => "Night Elf",
+    5 => "Undead",
+    6 => "Tauren",
+    7 => "Gnome",
+    8 => "Troll",
+    9 => "",
+    10 => "Blood Elf",
+    11 => "Dranei"
     ),
   'item' => array(
@@ -46 +65 @@
     2 => ""
     ),
+  'creep' => array(
+    'type' => array(
+      1 => "Beast",
+      2 => "Dragonkin",
+      3 => "Demon",
+      4 => "Elemental",
+      5 => "Giant",
+      6 => "Undead",
+      7 => "Humanoid",
+      8 => "Critter",
+      9 => "Mechanical",
+      10 => "Not specified",
+      11 => "Totem" ),
+    )
 );
 

db/css/css.php

@@ -5 +5 @@
 
 readfile("zakladni_css.css");
+readfile("horiz-menu_css.css");
 readfile("cotojatka.css");
 

db/css/zakladni_css.css

@@ -15 +15 @@
 
 h1, h2, h3, h4, h5, h6   {
-        font-size: 18px;
+        font-size: 16px;
         font-weight: bold;
-        text-decoration: underline;
   margin-top: 5px; margin-bottom: 5px;
-  padding-left: 30px; }
-h2   { font-size: 17px; } 
-h3   { font-size: 16px; }
+  padding-left: 20px; }
+h2   { font-size: 16px; } 
+h3   { font-size: 15px; }
 h4   { font-size: 15px; }
 h5   { font-size: 14px; }
-h6   { font-size: 13px; }
+h6   { font-size: 14px; }
 
 h3.dkc { 
@@ -43 +42 @@
 input { 
   display: inline;
-  background: white; }
+  border: 1px solid black;
+  background: white;
+  color: black; }
 input.hidden { 
   display: none; }
@@ -76 +77 @@
   color: #000000;
   text-decoration: none; background-color: #ffffff; } 
+a.graylink { font-weight: bold; padding: 1px; color: gray; text-decoration: none; }
+a.whitelink { font-weight: bold; padding: 1px; color: white; text-decoration: none; }
+a.whitelink:hover { color: black; }
+a.greenlink { font-weight: bold; padding: 1px; color: #23e64c; text-decoration: none; }
+a.bluelink { font-weight: bold; padding: 1px; color: #239fe6; text-decoration: none; }
+a.purplelink { font-weight: bold; padding: 1px; color: #ba55d3; text-decoration: none; }
+a.orangelink { font-weight: bold; padding: 1px; color: #e6b623; text-decoration: none; }
+a.redlink { font-weight: bold; padding: 1px; color: #e62323; text-decoration: none; }
 
 #center { 
@@ -98 +107 @@
   float: left;
   width: 120px; }
-#left ul { 
-  display: block; } 
-#left ul li {
+#left ul#hlavni_menu { 
+  display: block;
+  margin-bottom: 25px; } 
+#left ul#hlavni_menu li {
   display: block;
   overflow: hidden;
   list-style-type: none; }
-#left ul li a { 
+#left ul#hlavni_menu li a { 
   display: block;
   width: 100%;
@@ -113 +123 @@
   text-decoration: none;
   background-color: #e0e0e0; }
-#left ul li a:hover {
+#left ul#hlavni_menu li a:hover {
   color: #ffffff;
   background-color: #545454; }
-#left ul li ul { 
+#left ul#hlavni_menu li ul { 
   display: block; } 
-#left ul li ul li {
+#left ul#hlavni_menu li ul li {
   display: block;
   border: 0px;
   overflow: hidden;
   list-style-type: none; }
-#left ul li  ul li a { 
+#left ul#hlavni_menu li  ul li a { 
   display: block;
   width: 100%;
@@ -131 +141 @@
   color: #ffffff;
   background-color: #000000; }
-#left ul li ul li .search { 
+#left ul#hlavni_menu li ul li .search { 
   width: 110px;
   border: 1px solid white;
@@ -162 +172 @@
   padding: 8px; }
 #right p { 
-  margin-bottom: 8px; }
+  margin-top: 2px;
+  margin-bottom: 6px; }
 #right .back { 
   display: block;
@@ -207 +218 @@
   border-right: 0px;
   border-bottom: 2px solid white; }
+#right table#quest table#drop td { 
+  border-bottom:1px solid white; } 
+#right table#quest table#drop thead td { 
+  padding-top: 3px;
+  border-bottom: 2px solid white; } 
 #right table#quest table td { 
   border: 0px; }
@@ -228 +244 @@
   border: 0px; }
 #right table#sendbug td.text {
-  overflow-x: auto;
+  overflow: auto;
   padding:4px;
   border: 1px solid white; }
+#right table#login {
+  empty-cells: show;
+  margin-top: 15px;
+  text-align: left;
+  border: 0px; }
+#right table#login input { 
+  display: inline;
+  border: 1px solid white;
+  background: black;
+  color: white; }
+#right table#acc {
+  display: block;
+  width: 60%;
+  empty-cells: show;
+  margin-top: 15px;
+  text-align: left;
+  border: 1px solid white; }
+#right table#acc td {
+  padding: 5px; }
+#right table#acc h2 { 
+  margin: 0px;
+  padding-left: 10px; }
+
 
 #pata { 

db/databaze_tabulky/sql.sql

@@ -21 +21 @@
 
 CREATE TABLE `bug_report` (
-  `id` int(11) unsigned NOT NULL auto_increment,
-  `nick` varchar(50) NOT NULL,
-  `typ` varchar(250) NOT NULL,
-  `vlozeno` bigint(20) unsigned NOT NULL,
+  `id` int( 11 ) unsigned NOT NULL auto_increment,
+  `nick` varchar( 50 ) NOT NULL,
+  `typ` varchar( 250 ) NOT NULL,
+  `vlozeno` bigint( 20 ) unsigned NOT NULL,
   `popis` text NOT NULL,
   `opraveno` enum('0','1') NOT NULL default '0',
   `popis_opravy` text NOT NULL,
-  `opravil` bigint(20) unsigned NOT NULL,
-  `opravil_nick` varchar(50) NOT NULL,
+  `opravil` bigint( 20 ) unsigned NOT NULL,
+  `opravil_nick` varchar( 50 ) NOT NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Bug report system' AUTO_INCREMENT=1 ;
@@ -41 +41 @@
 
 CREATE TABLE `komentare` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `vlozil` text NOT NULL,
-  `vlozil_nick` varchar(50) NOT NULL,
-  `prava` varchar(100) NOT NULL default 'Hráč',
-  `kdy` text NOT NULL,
+  `id` BIGINT( 20 ) unsigned NOT NULL auto_increment,
+  `vlozil_nick` varchar( 50 ) NOT NULL,
+  `prava` varchar( 100 ) NOT NULL default 'Hráč',
+  `kdy` BIGINT( 20 ) NOT NULL,
   `komentar` text NOT NULL,
-  `ceho` text NOT NULL,
-  `ceho_id` bigint(20) unsigned NOT NULL,
+  `ceho` varchar( 50 ) NOT NULL,
+  `ceho_id` BIGINT( 20 ) unsigned NOT NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
@@ -60 +59 @@
 
 CREATE TABLE `klice` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `klic` varchar(20) NOT NULL,
+  `id` int( 10 ) unsigned NOT NULL auto_increment,
+  `klic` varchar( 20 ) NOT NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `klic` (`klic`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+-- 
+-- Struktura tabulky `acc_online`
+-- 
+-- Vytvoření: Sobota 13. října 2007, 12:45
+-- Poslední změna: Sobota 13. října 2007, 12:45
+-- 
+
+CREATE TABLE `acc_online` (
+`id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`nick` VARCHAR( 50 ) NOT NULL ,
+`phpsession` VARCHAR( 32 ) NOT NULL ,
+`hodnost` SMALLINT( 3 ) UNSIGNED NOT NULL ,
+`dateoflogin` BIGINT( 20 ) UNSIGNED NOT NULL
+) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
+
+-- 
+-- Struktura tabulky `acc_down_char`
+-- 
+-- Vytvoření: Sobota 13. října 2007, 13:47
+-- Poslední změna: Sobota 13. října 2007, 13:47
+-- 
+
+CREATE TABLE `acc_down_char` (
+`id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`acc` VARCHAR( 20 ) NOT NULL ,
+`char` VARCHAR( 20 ) NOT NULL ,
+`date` BIGINT( 20 ) UNSIGNED NOT NULL ,
+`ip` VARCHAR( 15 ) UNSIGNED NOT NULL
+) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

db/hlavni.php

@@ -6 +6 @@
   <head>
     <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
-    
-    <meta name="Description" content="<?php echo $Config['DB_read']['Description']; ?>">
+<?php if( $id == "logout" OR ($id == "login" AND !empty($SID) ) ){ ?>
+    <meta http-equiv="refresh" content="2;url=./index.php?id=uvod<?php echo $SID; ?>" />
+<?php }; ?>
+    <meta name="Description" content="<?php echo $Config['DB_read']['DB_read']['Description']; ?>">
     <meta name="robots" content="all, follow">
     <link rel="stylesheet" type="text/css" href="css/css.php"> 
     <link rel="shortcut icon" href="img/favicon.ico">
     <script src="js/scripty.js" type="text/javascript"></script>
-    <title><?php echo $Config['DB_read']['Title']; ?></title>
+    <title><?php echo $Config['DB_read']['DB_read']['Title']; ?></title>
   </head>
   <body>

db/include/bug_report.php

@@ -25 +25 @@
 <?php } elseif( $id=="sendbug" ){ ?>
   <?php echo $sql_insert['result']; ?>
+  <p>Příspěvky, které se netýkají chyb v databázi, budou nemilosrdně mazány.</p>
   <form action="./index.php?id=sendbug" method="post" accept-charset="utf-8">
     <table id="sendbug" border="0" cellspacing="0" cellpadding="2">

db/include/creep.php

@@ -2 +2 @@
 if($vlozeni_souboru == "OK"){ 
 ?>
+
+  <script type="text/javascript">
+    function Show_drop_drop(){ 
+      document.getElementById('item_drop').style.display='table';
+      document.getElementById('item_pickpocket').style.display='none';
+      document.getElementById('item_skin').style.display='none';
+      };
+    function Show_drop_pickpocket(){ 
+      document.getElementById('item_drop').style.display='none';
+      document.getElementById('item_pickpocket').style.display='table';
+      document.getElementById('item_skin').style.display='none';
+      };
+    function Show_drop_skin(){ 
+      document.getElementById('item_drop').style.display='none';
+      document.getElementById('item_pickpocket').style.display='none';
+      document.getElementById('item_skin').style.display='table';
+      };
+  </script>
 
 <?php if( empty($sql_select['error']) ){ ?>
@@ -7 +25 @@
     <tr><td width="20%"><table width="100%" border="0" cellspacing="0" cellpadding="0">
       <tr><td>ID Creepa: <?php echo $sql_select['creature']['entry']; ?></td></tr>
+<?php if( $sql_select['creature']['rank'] != 3 ){ ?>
       <tr><td><?php echo "Level od ".$sql_select['creature']['minlevel']." do ".$sql_select['creature']['maxlevel']; ?></td></tr>
+<?php }; ?>
+      <tr><td>Typ: <?php echo $Database['creep']['type'][$sql_select['creature']['type']]; ?></td></tr>
+      <tr><td style="padding-left: 15px;"><?php echo $sql_select['other']['creature_type']; ?></td></tr>
+      <tr><td><?php echo $sql_select['creature']['maxhealth']; ?> HP</td></tr>
+<?php if( !empty($sql_select['creature']['maxmana']) AND $sql_select['creature']['maxmana'] != 0 ){ ?>
+      <tr><td><?php echo $sql_select['creature']['maxmana']; ?> Many</td></tr>
+<?php }; ?>
       <tr><td>Rychlost: <?php echo $sql_select['creature']['speed']."x"; ?></td></tr>
 <?php if( !empty($sql_select['other']['creature_quests']) ){ ?>
@@ -14 +40 @@
 <?php }; ?>
     </table></td><td width="80%" style="padding-bottom:20px;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
-      <p>Zde se bude zobrazovat brázek s lokací.</p>
-    </table></td></tr><tr><td colspan='2'>
-      <p>Zde se bude zobrazovat seznam dropú.</p>
-    </td></tr>
+      <p>Zde se bude zobrazovat brázek s lokací a screen creepa.</p>
+    </table></td></tr><tr><td colspan='2'><table width="90%" id="drop" border="0" cellspacing="0" cellpadding="0">
+        <tr><td colspan='2'><input type="radio" name="item_set_drop" onclick="Show_drop_drop();" id="item_set_drop_drop" value="item_drop" checked="true"> &nbsp; <label for="item_set_drop_drop"> Drop </label> &nbsp; 
+        <input type="radio" name="item_set_drop" onclick="Show_drop_pickpocket();" id="item_set_drop_pickpocket" value="item_pickpocket"> &nbsp; <label for="item_set_drop_pickpocket"> Pickpocket </label> &nbsp;
+        <input type="radio" name="item_set_drop" onclick="Show_drop_skin();" id="item_set_drop_skin" value="item_skin"> &nbsp; <label for="item_set_drop_skin"> Skinning </label></td></tr>
+        <tr><td colspan='2'><table style="width:90%;border-left:2px solid white;" id="item_drop" border="0" cellspacing="0" cellpadding="2">
+        <thead><tr><td>Item</td><td>Šance na drop</td></tr></thead>
+<?php echo $sql_select['other']['creature_drop']; ?>
+        </table><noscript></td</tr><tr><td colspan='2' style="padding-top:20px;"><b>Pickpocket:</b> </td></tr><tr><td colspan='2'></noscript>
+        <table style="width:90%;border-left:2px solid white;" id="item_pickpocket" border="0" cellspacing="0" cellpadding="2">
+        <thead><tr><td>Item</td><td>Šance na drop</td></tr></thead>
+<?php echo $sql_select['other']['creature_pickpocket']; ?>
+        </table><noscript></td</tr><tr><td colspan='2' style="padding-top:20px;"><b>Skinning:</b> </td></tr><tr><td colspan='2'></noscript>
+        <table style="width:90%;border-left:2px solid white;" id="item_skin" border="0" cellspacing="0" cellpadding="2">
+        <thead><tr><td>Item</td><td>Šance na drop</td></tr></thead>
+<?php echo $sql_select['other']['creature_skin']; ?>
+        </table></td></tr>
+    </table></td></tr>
   </table>
 <?php } elseif( !empty($sql_select['error']) ){ ?>
@@ -23 +63 @@
 <?php }; ?> 
 
+<script type="text/javascript">
+  document.getElementById('item_pickpocket').style.display='none';
+  document.getElementById('item_skin').style.display='none';
+</script>
 
 <?php

db/include/creeps.php

@@ -3 +3 @@
 ?>
 
-<p>Nezprovozněno.</p>
+  <form action=" " method="get" class="search_form">
+  <input type="hidden" name="id" value="creeps" class="hidden">
+  <table class="search_form" border="0" cellspacing="0" cellpadding="2">
+    <tr><td><label for="q">Hledat:</label></td><td colspan='3'><input type="text" name="q" id="q" value="<?php echo $q; ?>"></td><td><input type="submit" value="Hledat" name="quest_find"></td></tr>
+</table><?php if(!empty($session_id)){ ?><input type="hidden" name="PHPSESSID" value="<?php echo $session; ?>" class="hidden"><?php }; ?></form>
+<?php if( !empty($sql_select['result']) ){ ?>
+  <?php echo $sql_select['result']; ?>
+<?php } elseif( !empty($sql_select['error']) ){ ?>
+  <?php echo $sql_select['error']; ?>
+<?php }; ?>
+
 
 <?php

db/include/myacc.php

@@ -1 +1 @@
 <?php
-if($vlozeni_souboru == "OK"){
+if($vlozeni_souboru == "OK" AND $user['loged'] == 1 ){ 
 ?>
 
-<p>Nezprovozněno.</p>
+<table border="0" id="acc" cellspacing="0">
+  <tr><td colspan='2'><h2><?php echo $user['nick']; ?></h2></td></tr>
+  <tr><td>Oprávnění:</td><td><?php echo $sql_select['result']['other']['opravneni']; ?></td></tr>
+  <tr><td>E-mail:</td><td><?php echo $sql_select['result']['acc']['email']; ?></td></tr>
+  <tr><td>Typ účtu:</td><td><?php echo $sql_select['result']['other']['version']; ?></td></tr>
+  <tr><td colspan='2' style="padding-left: 15px;border-top: 1px solid white;">
+  <b>Postavy:</b>
+  <?php echo $sql_select['result']['other']['chars']; ?></td></tr>
+</table>
+
+<p>Pokud chcete údaje měnit musíte navštívit <a href="./../minimanager/">Minimanager</a></p>
 
 <?php

db/index.php

@@ -6 +6 @@
 /* =========== Config aj. =========== */
   require_once "./config.php";
-  require_once "./menu.php";
-
-  require_once "./language/".$Config['DB_read']['language'].".php";
+  require_once "./check_database.php";
 
 /* =========== Připojení k Databázi =========== */
-
   @mysql_connect( $Config['DB_read']['Database']['Host'], $Config['DB_read']['Database']['User'], $Config['DB_read']['Database']['Password'] ) 
     OR DIE("<p>Vyskytla se chyba a nelze se připojit k databázi.<br> Zkuste to později.</p>"); 
-  @mysql_select_db($Config['DB_read']['DB_read']['Database_mangos'])
-    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_mangos']."!</p>"); 
-/*  $DB_realmd = mysql_select_db($Config['DB_read']['DB_read']['Database_realmd']);
-    if( !$DB_realmd ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_realmd']."!</p>"); };
-  $DB_web = mysql_select_db($Config['DB_read']['DB_read']['Database_web']);
-    if( !$DB_web ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>"); }; */
-  @mysql_query("SET CHARACTER SET utf8");  
+
+/* =========== Login / Logout =========== */
+  @mysql_select_db($Config['DB_read']['DB_read']['Database_realmd'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_realmd']."!</p>"); 
+  @mysql_query("SET CHARACTER SET utf8"); 
+
+  if( !empty($_POST['username']) AND !empty($_POST['pass']) ){
+    $nick = $_POST['username'];
+    $heslo = $_POST['pass'];
+    $zakodovane_heslo = sha1(STRTOUPPER($nick).":".STRTOUPPER($heslo)); 
+  
+    /* přihlášení proběhne pouze pokud bylo odesláno heslo a jméno */ 
+      $sql_user = @mysql_query("SELECT * FROM `account` WHERE (`username`='$nick' AND `I`='$zakodovane_heslo') LIMIT 1 "); 
+      if( mysql_num_rows($sql_user) == 1 ) { 
+        $login_info = @MySQL_Fetch_Array($sql_user);
+
+      @mysql_select_db($Config['DB_read']['DB_read']['Database_web'])
+        OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>"); 
+      @mysql_query("SET CHARACTER SET utf8"); 
+      
+          $sql_active_id_dotaz = @mysql_query("SELECT * FROM `acc_online` WHERE `nick`='".$login_info['username']."' LIMIT 1");
+          if( @mysql_num_rows($sql_active_id_dotaz) == 1 ) { 
+            $active = @MySQL_Fetch_Array($sql_active_id_dotaz);
+            } else{ unset($active); };
+
+          if( empty($active['id']) ){ 
+            @mysql_query("INSERT INTO `acc_online` ( `nick`, `phpsession`, `hodnost`, `dateoflogin` ) VALUES ( '".$login_info['username']."', '".$session."', '".$login_info['gmlevel']."', '".time()."' )");
+            $login_err = "Přihlášení proběhlo úspěšně.";
+            } 
+          elseif( !empty($active['id']) ){ 
+            @mysql_query("DELETE FROM `acc_online` WHERE id='".$active['id']."' LIMIT 1 ");
+            @mysql_query("INSERT INTO `acc_online` ( `nick`, `phpsession`, `hodnost`, `dateoflogin` ) VALUES ( '".$login_info['username']."', '".$session."', '".$login_info['gmlevel']."', '".time()."' )");
+            $login_err = "Přihlášení proběhlo úspěšně.";
+            } 
+          else{ $login_err = "Chyba: Nelze se přihlásit! <br> Zkuste to znovu. "; };
+
+        } 
+      else{ $login_err = "Nejste registrovaný uživatel nebo byly špaťně zadány údaje,<br /> přihlásit se proto nemůžete! "; };
+    }
+    elseif( isset($_POST['login']) AND ( empty($prijaty_nick) OR empty($prijate_heslo) ) ){
+      $login_err = "Jeden z údajů chybí! Vyplňte Prosím jméno i heslo!";
+      };
+
+  @mysql_select_db($Config['DB_read']['DB_read']['Database_web'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>"); 
+  @mysql_query("SET CHARACTER SET utf8"); 
+  
+  if( $_GET['id'] == "logout" ){
+    session_destroy(); session_regenerate_id();
+    @mysql_query("DELETE FROM `acc_online` WHERE `phpsession`='$session' LIMIT 1"); 
+    unset($user); unset($SID);
+    };
+
+  $user_sql = mysql_query("SELECT * FROM `acc_online` WHERE `phpsession`='".$session."' LIMIT 1 ");
+  if( @mysql_num_rows($user_sql) == 1 ) { 
+    $user = @MySQL_Fetch_Array($user_sql);
+    $user['loged'] = 1; 
+    $get = count($_GET);
+      if( $get < 1 ){ $SID = "?PHPSESSID=".$session; } 
+      else{ $SID = "&amp;PHPSESSID=".$session; }; 
+    $time_login = $user['dateoflogin']+(60*20); $time_now = time(); 
+    if( $time_login <= $time_now ){  
+      session_destroy(); session_regenerate_id();
+      @mysql_query("DELETE FROM `acc_online` WHERE `phpsession`='$session' LIMIT 1"); unset($user); unset($SID);
+      } else{ mysql_query("UPDATE `acc_online` SET `dateoflogin` = '".$time_now."' WHERE `id`='".$user['id']."' LIMIT 1"); };
+
+    } else{ unset($user); }; 
+
+/* =========== Definice Menu =========== */
+  $Menu = array(
+      /*  0 => array("Typ - 1/2/3","Odkaz","Popisek");
+      // typ: 1- kategorie
+      //      2- položka
+      //      3- jiné */
+  
+          1 => array(1,"index.php?id=uvod$SID","Hlavni"),
+          2 => array(2,"./../","Zpět na web"),
+          3 => array(2,"./../minimanager/","Minimanager"),
+          4 => array(2,"./../forum/","Forum"),
+          5 => array(2,"./../registrace/","Registrace"),
+          6 => array(2,"./index.php?id=bugreport$SID","Hlášení chyb"),
+  //        7 => array(2,"./index.php?id=stats$SID","Statistiky"),
+  //        8 => array(2,"./index.php?id=races$SID","Rasy"),
+  //        9 => array(2,"./index.php?id=classes$SID","Povolání"),
+  //        10 => array(1,"#","Obecné Hledání"),
+  //        11 => array(3,"<span style=\"padding-left: 5px;\">\n                <input type=\"text\" name=\"search\" maxlength=\"255\" class=\"search\" title=\"Pro Odeslání stiskněte Enter\">\n              </span>",""),
+          );
+  if( $user['loged'] == 1 ){ 
+      $Menu_add = array( 
+          12 => array(1,"#",$user['nick']),
+          13 => array(2,"./index.php?id=myacc$SID","Muj účet"),
+          14 => array(2,"./../guildy.php","Guildy"),
+          15 => array(2,"./../honor.php","Honor"),
+          ); $Menu = array_merge($Menu, $Menu_add);
+    if( $user['hodnost'] == 3 ){ 
+      $Menu_add = array( 
+          16 => array(2,"./index.php?id=admin$SID","Administrace"),
+          ); $Menu = array_merge($Menu, $Menu_add);
+      };
+      $Menu_add = array( 17 => array(2,"./index.php?id=logout$SID","Logout") ); $Menu = array_merge($Menu, $Menu_add);
+    } else { 
+      $Menu_add = array( 
+          12 => array(1,"#","Uživatelé"),
+          13 => array(2,"./index.php?id=login","Login"),
+          14 => array(2,"./../guildy.php","Guildy"),
+          15 => array(2,"./../honor.php","Honor"),
+          ); $Menu = array_merge($Menu, $Menu_add);
+    }; 
+  $Menu_add = array( 
+  //        18 => array(1,"./index.php?id=items$SID","Itemy"),
+  //        19 => array(2,"./index.php?id=items$SID","Hledání"),
+  //        20 => array(2,"./index.php?id=itemsets$SID","Sety"),
+          21 => array(1,"./index.php?id=questy$SID","Questy"),
+          22 => array(2,"./index.php?id=questy$SID","Hledání"),
+  //        23 => array(2,"./index.php?id=qzone$SID","Zóny"),
+  //        24 => array(2,"./index.php?id=qtrskill$SID","Profese"),
+  //        25 => array(2,"./index.php?id=qspecial$SID","Speciální"),
+          26 => array(1,"./index.php?id=creeps$SID","Bestiář"),
+          27 => array(2,"./index.php?id=creeps$SID","Hledání"),
+  //        28 => array(2,"./index.php?id=czone$SID","Zóny"),
+  //        29 => array(2,"./index.php?id=ctype$SID","Typy"),
+  //        30 => array(2,"./index.php?id=crare$SID","Unikátní"),
+  //        31 => array(1,"#","Geografie"),
+  //        32 => array(2,"./index.php?id=glevel$SID","Podle levelu"),
+  //        33 => array(2,"./index.php?id=gzone$SID","Zóny"),
+  //        34 => array(1,"./index.php?id=spells$SID","Spell"),
+  //        35 => array(2,"./index.php?id=spells$SID","Hledání"),
+  //        36 => array(2,"./index.php?id=sclass$SID","Podle tříd"),
+  //        37 => array(1,"./index.php?id=talents$SID","Talenty"),
+  //        38 => array(2,"./index.php?id=talents$SID","Prohlížet"),
+  //        39 => array(1,"./index.php?id=profes$SID","Profese"),
+  //        40 => array(2,"./index.php?id=profes$SID","Prohlížet"),
+  //        41 => array(2,"./index.php?id=pteach$SID","Učitelé"),
+          );
+  $Menu = array_merge($Menu, $Menu_add);
 
 /* =========== Speciální FCE =========== */
@@ -118 +243 @@
     };
 
+  function GenerateMenu(){ 
+    global $Menu;
+
+    $klice = array_keys($Menu);
+    $klice_count = count($klice);
+
+    for($i=0; $i <= $klice_count ;$i++){
+        if($Menu[$klice[$i]][0] == 1){  
+        if( $inside_submenu == 1 ){ $Generated_Menu .= "          </ul></li>\n"; }
+        elseif( !empty($Generated_Menu) ){ $Generated_Menu .= "</li>\n"; } unset($inside_submenu);
+          $Generated_Menu .= "          <li><a href=\"".$Menu[$klice[$i]][1]."\">".$Menu[$klice[$i]][2]."</a>";
+        $submenu = 1;
+        } 
+      elseif($Menu[$klice[$i]][0] == 2){ 
+        if( $submenu == 1 ){ $Generated_Menu .= "<ul>\n"; }; unset($submenu);
+          $Generated_Menu .= "            <li><a href=\"".$Menu[$klice[$i]][1]."\">".$Menu[$klice[$i]][2]."</a></li>\n";
+        $inside_submenu = 1;
+        } 
+      elseif($Menu[$klice[$i]][0] == 3){ 
+        if( $submenu == 1 ){ $Generated_Menu .= "<ul>"; }; unset($submenu); 
+          $Generated_Menu .= "          <li>".$Menu[$klice[$i]][1]."</li>\n";
+        $inside_submenu = 1;
+        } 
+      elseif( !empty($Menu[$klice[$i]][0]) AND !empty($Menu[$klice[$i]][1]) AND !empty($Menu[$klice[$i]][2]) ){ 
+        $Generated_Menu .= "          <li><a href=\"#\">Chyba !!</a>"; }
+      else{ $Generated_Menu .= "          </ul></li>\n"; };
+      };
+
+    return $Generated_Menu;
+    };
+
 /* =========== END_TOP =========== */
   $vlozeni_souboru = "OK";
@@ -124 +280 @@
     /* =========== GET hodnoty =========== */
     $id = $_GET['id']; // tady získá id z adresy
+    $str = $_GET['str']; // tady získá str z adresy
+    $char = $_GET['char']; // tady získá str z adresy
     $q = addslashes($_GET['q']); 
     $limit = $_GET['list']; // tady získá list z adresy
@@ -134 +292 @@
     $creature = addslashes($_GET['creature']);
       if( is_numeric($creature) == FALSE ){ unset($creature); };
+    $item = addslashes($_GET['item']);
+      if( is_numeric($item) == FALSE ){ unset($item); };
     $lvl_d = addslashes($_GET['lvl_d']);
       if( is_numeric($lvl_d) == FALSE ){ unset($lvl_d); };
@@ -139 +299 @@
       if( is_numeric($lvl_h) == FALSE ){ unset($lvl_h); };
 
+    /* =========== Výchozí databáze =========== */ 
+    @mysql_select_db($Config['DB_read']['DB_read']['Database_mangos'])
+      OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_mangos']."!</p>"); 
+    @mysql_query("SET CHARACTER SET utf8"); 
+    
     /* =========== Vložení základního souboru =========== */ 
+    require_once "./language/".$Config['DB_read']['language'].".php";
+
     require_once "./post_read.php";
     require_once "./hlavni.php";

db/obsah.php

@@ -4 +4 @@
           if( !empty($id) ){
             if( $id == "uvod" ){ $file = "uvod"; $nadpis = "Úvod"; } 
+            elseif( $id == "login" ){ $file = "login"; $nadpis = "Přihlášení"; } 
+            elseif( $id == "admin" ){ $file = "../admin/obsah"; $nadpis = "Administrace"; } 
+            elseif( $id == "getchar" ){ $file = "getchar"; $nadpis = "Export postavy z databáze"; } 
             elseif( $id == "stats" ){ $file = "stats"; $nadpis = "Statistiky"; } 
             elseif( $id == "bugreport" ){ $file = "bug_report"; $nadpis = "Systém na opravu chyb"; } 
@@ -31 +34 @@
             else{ $file = "uvod"; $nadpis = "Úvod"; };
 
-            if( File_Exists("./include/".$file.".php") ){
-              $file = "./include/".$file.".php"; 
-              }; 
+            $file = "./include/".$file.".php";
             }
           elseif( !empty($quest) ){ 
@@ -46 +47 @@
           elseif( !empty($creature) ){ 
             $creature_dotaz_nadpis =  mysql_query("SELECT `name`,`subname` FROM `creature_template` WHERE `entry`='".$creature."' LIMIT 1"); 
-            if( mysql_num_rows($creature_dotaz_nadpis) == "1" ) { $i = "0";
+            if( mysql_num_rows($creature_dotaz_nadpis) == "1" ) { 
               $result = @MySQL_Fetch_Array($creature_dotaz_nadpis);
                 $nadpis_creature = $result["name"]; 
@@ -52 +53 @@
               } else{ $creature_quest = "Chyba !"; };
             $file = "./include/creep.php"; $nadpis = "Creep: ".$nadpis_creature;
+            if( !File_Exists($file) ){ $file = "./include/uvod.php"; };
+            } 
+          elseif( !empty($item) ){ 
+            $item_dotaz_nadpis =  mysql_query("SELECT `name` FROM `item_template` WHERE `entry`='".$item."' LIMIT 1"); 
+            if( mysql_num_rows($item_dotaz_nadpis) == 1 ) { 
+              $result = @MySQL_Fetch_Array($item_dotaz_nadpis);
+                $nadpis_item = $result["name"]; 
+              } else{ $creature_quest = "Chyba !"; };
+            $file = "./include/item.php"; $nadpis = "Item: ".$nadpis_item;
             if( !File_Exists($file) ){ $file = "./include/uvod.php"; };
             } 
@@ -60 +70 @@
 
 <?php
-        require_once $file;
+        if( !File_exists($file) ){ echo "<p>Chyba! Nebyl nalezen kořenový soubor.</p>"; };
+        @require_once $file;
 ?>
 

db/post_read.php

@@ -1 +1 @@
 <?php
 if($vlozeni_souboru == "OK"){ 
-?>
-
-<?php
 
 if( !empty($q) AND !empty($id) ){ 
-  if( !empty($lvl_d) AND !empty($lvl_h) ){ $where = "(`MinLevel`>='$lvl_d' AND `MinLevel`<='$lvl_h') AND "; };
-  $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q%' )", $limit, 20, "?id=questy&amp;q=".$q."&amp;lvl_d=".$lvl_d."&amp;lvl_h=".$lvl_h, $SID);
-  if( @mysql_num_rows($sql_select[1]) > 0 ){ $i = 0; 
-    $sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
-    $sql_select['result'] .= "<thead><tr><td>Název úkolu</td><td>Min level</td><td>Úkol zadává</td><td>Úkol</td></tr></thead>\n<col width=\"180px\"><col width=\"70px\">";
-
-    while( $result = MySQL_Fetch_Array($sql_select[1]) ){ 
-      $sql_select['result'] .= "  <tr valign='top'>";
-      $sql_select['result'] .= "<td><a href=\"index.php?quest=".$result['entry']."\">".$result['Title']."</a></td>";
-      $sql_select['result'] .= "<td>".$result['MinLevel']."</td>";
-      $sql_select['result'] .= "<td>";
-
-        $startovni_creature_dotaz = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$result['entry']." ");
-        while( $start_creature = @MySQL_Fetch_Array($startovni_creature_dotaz) ){ 
-          $sql_select['result'] .= "<a href=\"index.php?creature=".$start_creature['entry']."\">".$start_creature['name']."</a><br>";
+  if( $id == "questy" ){
+    if( !empty($lvl_d) AND !empty($lvl_h) ){ $where = "(`MinLevel`>='$lvl_d' AND `MinLevel`<='$lvl_h') AND "; };
+    $sql_select = SQLselect_Strankovani("SELECT * FROM `quest_template` WHERE ( $where`Title` LIKE '%$q%' ) ORDER BY `entry` ASC", $limit, 20, "?id=questy&amp;q=".$q."&amp;lvl_d=".$lvl_d."&amp;lvl_h=".$lvl_h, $SID);
+    if( @mysql_num_rows($sql_select[1]) > 0 ){ $i = 0; 
+      $sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
+      $sql_select['result'] .= "<thead><tr><td>Název úkolu</td><td>Min level</td><td>Úkol zadává</td><td>Úkol</td></tr></thead>\n<col width=\"180px\"><col width=\"70px\">";
+  
+      while( $result = MySQL_Fetch_Array($sql_select[1]) ){ 
+        $sql_select['result'] .= "  <tr valign='top'>";
+        $sql_select['result'] .= "<td><a href=\"index.php?quest=".$result['entry']."\">".$result['Title']."</a></td>";
+        $sql_select['result'] .= "<td>".$result['MinLevel']."</td>";
+        $sql_select['result'] .= "<td>";
+  
+          $startovni_creature_dotaz = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$result['entry']." ");
+          while( $start_creature = @MySQL_Fetch_Array($startovni_creature_dotaz) ){ 
+            $sql_select['result'] .= "<a href=\"index.php?creature=".$start_creature['entry']."\">".$start_creature['name']."</a><br>";
+            };
+          $startovni_gameobject_dotaz = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$result['entry']." ");
+          while( $start_gameobject = @MySQL_Fetch_Array($startovni_gameobject_dotaz) ){ 
+            $sql_select['result'] .= "<a href=\"index.php?gameobject=".$start_gameobject['entry']."\">".$start_gameobject['name']."</a><br>";
+            };
+  
+        $sql_select['result'] .= "</td>";
+        $sql_select['result'] .= "<td>".$result['Objectives']."</td>";
+        $sql_select['result'] .= "</tr>\n";
+        };
+      
+      $sql_select['result'] .= "</table>\n";
+      }  else{ $sql_select['error'] = "<p>Nebyly nalezeny žádné questy.</p>"; };
+    
+    } 
+  elseif( $id == "creeps" ){ 
+    $sql_select = SQLselect_Strankovani("SELECT * FROM `creature_template` WHERE ( `name` LIKE '%$q%' OR `subname` LIKE '%$q%' ) ORDER BY `entry` ASC", $limit, 20, "?id=creeps&amp;q=".$q, $SID);
+    if( @mysql_num_rows($sql_select[1]) > 0 ){ $i = 0; 
+      $sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
+      $sql_select['result'] .= "<thead><tr><td>Název creepa</td><td>Level</td></tr></thead>\n<col><col width=\"70px\">";
+  
+      while( $result = MySQL_Fetch_Array($sql_select[1]) ){ 
+        $sql_select['result'] .= "  <tr valign='top'>";
+        $sql_select['result'] .= "<td><a href=\"index.php?creature=".$result['entry']."\">".$result['name']."</a></td>";
+        if( $result['rank'] != 3 ){
+          $sql_select['result'] .= "<td align='center'>".$result['minlevel']." - ".$result['maxlevel']."</td>";
+          }
+        else{
+          $sql_select['result'] .= "<td align='center'>Boss</td>";
           };
-        $startovni_gameobject_dotaz = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$result['entry']." ");
-        while( $start_gameobject = @MySQL_Fetch_Array($startovni_gameobject_dotaz) ){ 
-          $sql_select['result'] .= "<a href=\"index.php?gameobject=".$start_gameobject['entry']."\">".$start_gameobject['name']."</a><br>";
-          };
-
-      $sql_select['result'] .= "</td>";
-      $sql_select['result'] .= "<td>".$result['Objectives']."</td>";
-      $sql_select['result'] .= "</tr>\n";
-      };
-    
-    $sql_select['result'] .= "</table>\n";
-    }  else{ $sql_select['error'] = "<p>Nebyly nalezeny žádné questy.</p>"; };
-  
+        $sql_select['result'] .= "</tr>\n";
+        };
+      
+      $sql_select['result'] .= "</table>\n";
+      }  else{ $sql_select['error'] = "<p>Nebyly nalezeny žádní creepové.</p>"; };
+
+    };
   } 
 elseif( !empty($quest) AND empty($id) ){ 
@@ -111 +132 @@
     $result = MySQL_Fetch_Array($sql_select['sql']);
     $sql_select['creature'] = $result;
+    
+    switch($sql_select['creature']['rank']){ 
+      case 0: $sql_select['other']['creature_type'] = "Normal"; break;
+      case 1: $sql_select['other']['creature_type'] = "Elite"; break;
+      case 2: $sql_select['other']['creature_type'] = "Rare Elite"; break;
+      case 3: $sql_select['other']['creature_type'] = "World Boss"; break;
+      case 4: $sql_select['other']['creature_type'] = "Rare"; break;
+      };
 
     $questy_dotaz_creature = mysql_query("SELECT * FROM `creature_questrelation` LEFT JOIN `quest_template` ON `creature_questrelation`.`quest` = `quest_template`.`entry` WHERE (`creature_questrelation`.`id` =".$sql_select['creature']['entry']." AND `quest_template`.`PrevQuestId`=0 ) ");
@@ -117 +146 @@
           $sql_select['other']['creature_quests'] .= "<a href=\"index.php?quest=".$quest_NPC['entry']."\">".$quest_NPC['Title']."</a><br>\n";
         }; }; 
+
+    $drop_creature = mysql_query("SELECT * FROM `creature_loot_template` LEFT JOIN `item_template` ON `creature_loot_template`.`item` = `item_template`.`entry` WHERE `creature_loot_template`.`entry`='".$sql_select['creature']['lootid']."' ORDER BY `Quality` DESC, `ChanceOrRef` DESC ");
+      if( @mysql_num_rows($drop_creature) > 0 ){ 
+        while($drop_NPC = @MySQL_Fetch_Array($drop_creature)){ 
+          switch($drop_NPC['Quality']){
+            case 0: $sql_select['other']['item_color'] = "class=\"graylink\""; break;
+            case 1: $sql_select['other']['item_color'] = "class=\"whitelink\""; break;
+            case 2: $sql_select['other']['item_color'] = "class=\"greenlink\""; break;
+            case 3: $sql_select['other']['item_color'] = "class=\"bluelink\""; break;
+            case 4: $sql_select['other']['item_color'] = "class=\"purplelink\""; break;
+            case 5: $sql_select['other']['item_color'] = "class=\"orangelink\""; break;
+            case 6: $sql_select['other']['item_color'] = "class=\"redlink\""; break;
+            }; 
+          $sql_select['other']['creature_drop'] .= "<tr><td><a href=\"index.php?item=".$drop_NPC['entry']."\" ".$sql_select['other']['item_color'].">".$drop_NPC['name']."</a></td>";
+          $sql_select['other']['creature_drop'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
+        }; } else{ $sql_select['other']['creature_drop'] = "<tr><td colspan='2'>Tento creep nemá žádný drop !</td></tr>"; };
+
+    $pickpocket_creature = mysql_query("SELECT * FROM `pickpocketing_loot_template` LEFT JOIN `item_template` ON `pickpocketing_loot_template`.`item` = `item_template`.`entry` WHERE `pickpocketing_loot_template`.`entry`='".$sql_select['creature']['pickpocketloot']."' ORDER BY `Quality` DESC, `ChanceOrRef` DESC ");
+      if( @mysql_num_rows($pickpocket_creature) > 0 ){ 
+        while($drop_NPC = @MySQL_Fetch_Array($pickpocket_creature)){ 
+          switch($drop_NPC['Quality']){
+            case 0: $sql_select['other']['item_color'] = "class=\"graylink\""; break;
+            case 1: $sql_select['other']['item_color'] = "class=\"whitelink\""; break;
+            case 2: $sql_select['other']['item_color'] = "class=\"greenlink\""; break;
+            case 3: $sql_select['other']['item_color'] = "class=\"bluelink\""; break;
+            case 4: $sql_select['other']['item_color'] = "class=\"purplelink\""; break;
+            case 5: $sql_select['other']['item_color'] = "class=\"orangelink\""; break;
+            case 6: $sql_select['other']['item_color'] = "class=\"redlink\""; break;
+            }; 
+          $sql_select['other']['creature_pickpocket'] .= "<tr><td><a href=\"index.php?item=".$drop_NPC['entry']."\" ".$sql_select['other']['item_color'].">".$drop_NPC['name']."</a></td>";
+          $sql_select['other']['creature_pickpocket'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
+        }; } else{ $sql_select['other']['creature_pickpocket'] = "<tr><td colspan='2'>Tento creep nemá žádný Pickpocket !</td></tr>"; };
+
+    $skin_creature = mysql_query("SELECT * FROM `skinning_loot_template` LEFT JOIN `item_template` ON `skinning_loot_template`.`item` = `item_template`.`entry` WHERE `skinning_loot_template`.`entry`='".$sql_select['creature']['skinloot']."' ORDER BY `Quality` DESC, `ChanceOrRef` DESC ");
+      if( @mysql_num_rows($skin_creature) > 0 ){ 
+        while($drop_NPC = @MySQL_Fetch_Array($skin_creature)){ 
+          switch($drop_NPC['Quality']){
+            case 0: $sql_select['other']['item_color'] = "class=\"graylink\""; break;
+            case 1: $sql_select['other']['item_color'] = "class=\"whitelink\""; break;
+            case 2: $sql_select['other']['item_color'] = "class=\"greenlink\""; break;
+            case 3: $sql_select['other']['item_color'] = "class=\"bluelink\""; break;
+            case 4: $sql_select['other']['item_color'] = "class=\"purplelink\""; break;
+            case 5: $sql_select['other']['item_color'] = "class=\"orangelink\""; break;
+            case 6: $sql_select['other']['item_color'] = "class=\"redlink\""; break;
+            }; 
+          $sql_select['other']['creature_skin'] .= "<tr><td><a href=\"index.php?item=".$drop_NPC['entry']."\" ".$sql_select['other']['item_color'].">".$drop_NPC['name']."</a></td>";
+          $sql_select['other']['creature_skin'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
+        }; } else{ $sql_select['other']['creature_skin'] = "<tr><td colspan='2'>Tento creep nemá žádný Skin !</td></tr>"; };
 
     } else{ $sql_select['error'] = "<p>Creep nebyl nalezen.</p>"; };
@@ -167 +244 @@
 
   }
-elseif( $id == "sendbug" ANd isset($_POST['send']) ){ 
+elseif( $id == "sendbug" AND isset($_POST['send']) ){ 
   mysql_select_db($Config['DB_read']['DB_read']['Database_web'])
     OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>");
@@ -178 +255 @@
   else{ $sql_insert['result'] = "<p>Bug se nepodařilo uložit do databáze.<br>Zkuste to později znovu prosím.</p>"; };
   
+  }
+elseif( $id == "myacc" ){ 
+  mysql_select_db($Config['DB_read']['DB_read']['Database_realmd'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_realmd']."!</p>");
+    @mysql_query("SET CHARACTER SET utf8");  
+
+  $sql_select['sql'] = mysql_query("SELECT * FROM `account` WHERE `username`='".$user['nick']."' LIMIT 1");
+  $sql_select['result']['acc'] = @mysql_fetch_array($sql_select['sql']);
+
+  mysql_select_db($Config['DB_read']['DB_read']['Database_mangos'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_mangos']."!</p>");
+    @mysql_query("SET CHARACTER SET utf8");  
+
+  $sql_select['sql'] = mysql_query("SELECT * FROM `character` WHERE `account`='".$sql_select['result']['acc']['id']."' "); 
+  $sql_select['result']['char_count'] = @mysql_num_rows($sql_select['sql']);
+  for($i=0;$sql_select['result']['char'][$i] = @mysql_fetch_array($sql_select['sql']) ;$i++){ 
+    $sql_select['result']['char'][$i]['data'] = explode(" ", $sql_select['result']['char'][$i]['data']);
+    };
+
+  switch($sql_select['result']['acc']['gmlevel']){
+    case 0: $sql_select['result']['other']['opravneni'] = "Player"; break;
+    case 1: $sql_select['result']['other']['opravneni'] = "Moderator"; break;
+    case 2: $sql_select['result']['other']['opravneni'] = "GameMaster"; break;
+    case 3: $sql_select['result']['other']['opravneni'] = "Administrator"; break;
+    default: $sql_select['result']['other']['opravneni'] = "unknown";
+    };
+
+  switch($sql_select['result']['acc']['tbc']){
+    case 0: $sql_select['result']['other']['version'] = "Normal"; break;
+    case 1: $sql_select['result']['other']['version'] = "Burning Crusade"; break;
+    };
+
+  $sql_select['result']['other']['chars'] .= "<table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">\n";
+  for($i=0; $i < $sql_select['result']['char_count'] ;$i++){
+    $sql_select['result']['other']['chars'] .= "<tr><td>".$sql_select['result']['char'][$i]['name']."</td>";
+    $sql_select['result']['other']['chars'] .= "<td title=\"Level\">".$sql_select['result']['char'][$i]['data'][34]."</td>";
+    $sql_select['result']['other']['chars'] .= "<td title=\"Rasa\">".$Database['race'][$sql_select['result']['char'][$i]['race']]."</td>";
+    $sql_select['result']['other']['chars'] .= "<td title=\"Povolání\">".$Database['class'][$sql_select['result']['char'][$i]['class']]."</td>\n";
+    $sql_select['result']['other']['chars'] .= "<td> - <a href=\"./character.php?char=".$sql_select['result']['char'][$i]['guid']."\">Exportovat</a></td></tr>\n";
+    }; $sql_select['result']['other']['chars'] .= "</table>";
+
+
   };
 
 
+
+
+  }; // vložení souboru
 ?>
-
-
-<?php
-  };
-?>
-