Changeset 445

Timestamp:

Feb 22, 2009, 5:46:24 PM (16 years ago)

Author:

george

Message:

• Přidáno: Skript pro import financí a aktualit ze starého webu.
• Opraveno: Ukázkový skript db_sample.php nebyl řádné upravený!
• Opraveno: U zobrazování aktualit se všude zobrazoval jako autor Zork.
• Upraveno: Javascript kódy umísťujte do souboru styles/global.js.

Location:

beta

Files:

• import_old_data.php (added)
• inc/db_sample.php (modified) (1 diff)
• inc/html.php (modified) (4 diffs)
• index.php (modified) (1 diff)
• sql/structure.sql (modified) (3 diffs)
• styles/global.js (added)

beta/inc/db_sample.php

@@ -3 +3 @@
 $db_user    = "web";
 $db_pass    = "";
+
+$db_mangos = "mangos";
+$db_realmd = "realmd";
+$db_characters = "characters";
+$db_ghsystem = "wow_web";
+$db_webu = "wow_web";
+
 $db = new mysqli($db_server, $db_user, $db_pass);
   if (mysqli_connect_errno()) 

beta/inc/html.php

@@ -62 +62 @@
   <meta name=\"keywords\" content=\"".$this->CfgChck("keywords")."\" />
   <link rel=\"stylesheet\" type=\"text/css\" href=\"styles/style.css\" />
+  <script type=\"text/javascript\" src=\"styles/global.js\"></script>
   <!--[if IE]><link rel=\"stylesheet\" type=\"text/css\" href=\"styles/ie.css\" /><![endif]-->
   </head>
@@ -207 +208 @@
       public function ShowNews ($kategorie)
       {
+                global $db_webu;
+                
         if ($kategorie == "all")
         {
@@ -215 +218 @@
           $where = "WHERE `category` = '".$kategorie."'";
         }
-        $this -> db -> select_db("wow_web");
+        $this -> db -> select_db($db_webu);
         $sql = $this -> db -> query("SELECT * FROM `articles`".$where."ORDER BY `date` DESC;");
         if ($sql -> num_rows > 0)
@@ -258 +261 @@
               <tr>
                 <td>Sekce : <a href=\"?page=".$link."\">".$cat."</a></td>
-                <td>Zork</td>
+                <td>".$row["autor"]."</td>
               </tr>
             </table>

beta/index.php

@@ -1 @@
-<script>
-function popup(url, wid, hei) {
-left = (window.screen.availWidth-wid)/2;
-shora = (window.screen.availHeight-hei)/2;
-window.open(url,"_blank","left="+left+",top="+shora+",scrollbars=yes,resiza ble=no,toolbar=no,menubar=no,status=no,location=0,width="+wid+",height ="+hei);
-}
-</script>
-<?php
-  session_start();
+<?php
+session_start();
 include_once("./inc/db.php");
 include_once("./inc/html.php");

beta/sql/structure.sql

@@ +1 @@
+-- phpMyAdmin SQL Dump
+-- version 3.1.2
+-- http://www.phpmyadmin.net
+--
+-- Počítač: localhost
+-- Vygenerováno: Neděle 22. února 2009, 17:17
+-- Verze MySQL: 5.0.51
+-- Verze PHP: 5.2.6
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+--
+-- Databáze: `wow_web`
+--
+
+-- --------------------------------------------------------
 
 --
@@ -12 +28 @@
   `date` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ;
 
 -- --------------------------------------------------------
@@ -72 +88 @@
 
 --
+-- Struktura tabulky `finance`
+--
+
+CREATE TABLE IF NOT EXISTS `finance` (
+  `id` int(11) NOT NULL auto_increment,
+  `time` datetime default NULL,
+  `money` int(11) default NULL,
+  `operation` enum('contribution','consumption','buy','internet','sell') collate latin2_czech_cs NOT NULL default 'contribution',
+  `description` varchar(255) collate latin2_czech_cs default NULL,
+  KEY `ID` (`id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=113 ;
+
+-- --------------------------------------------------------
+
+--
 -- Struktura tabulky `guildy`
 --