Changeset 555

Timestamp:

Mar 29, 2009, 4:21:14 PM (16 years ago)

Author:

george

Message:

• Přidáno: Mimo RSS kanál článků přidány kanály ticketů a finančních příspěvků.

Location:

trunk

Files:

• inc/html.php (modified) (3 diffs)
• rss.php (modified) (1 diff)
• sql/structure.sql (modified) (5 diffs)

trunk/inc/html.php

@@ -12 +12 @@
     $this->html_cfg = array
     (
-      "charset" => "utf-8",
+/*      "charset" => "utf-8",
       "author" => "Zork",
       "copyright" => "(C) 2008 Heroes of Fantasy, All rights reserved.",
@@ -19 +19 @@
       "description" => "Heroes of Fantasy free WoW server běžící na programu MaNGOS",
       "keywords" => "wowserver, world of warcraft, free, wow, server, hof, heroes of fantasy, zdechov, mangos"
-    );
+*/    );
 
     if((count($values) > 1) or ($values[0] != 0) and ($values[0] != 0))
@@ -63 +63 @@
     '<link href="inc/teamspeakdisplay/teamspeakdisplay.css" rel="stylesheet" type="text/css" />'.
     '<link rel="alternate" title="Články" href="rss.php?category=articles" type="application/rss+xml" />'.
+    '<link rel="alternate" title="Finanční přispěvky" href="rss.php?category=finance" type="application/rss+xml" />'.
     '<script type="text/javascript" src="styles/global.js"></script>'.
     '<!--[if IE]><link rel="stylesheet" type="text/css" href="styles/ie.css" /><![endif]-->'.

trunk/rss.php

@@ -9 +9 @@
 $Items = array();
 
-$DbResult = $db->query('SELECT UNIX_TIMESTAMP(date), articles.* FROM articles ORDER BY date DESC LIMIT '.$NewsCount);
-while($Row = $DbResult->fetch_array())
+if(array_key_exists('category', $_GET))
 {
-  $Items[] = array(
-    'Title' => $Row['title'],
-    'Link' => 'http://'.$_SERVER['SERVER_NAME'].$Config['Web']['BaseURL'],
-    'Description' => $Row['text']." (".$Row['autor'].")",
-    'Time' => $Row['UNIX_TIMESTAMP(date)'],
-  );
+  if($_GET['category'] == 'articles')
+  {
+    $Config['Web']['Title'] .= ' - články';
+    $DbResult = $db->query('SELECT UNIX_TIMESTAMP(date), articles.* FROM articles ORDER BY date DESC LIMIT '.$NewsCount);
+    while($Row = $DbResult->fetch_array())
+    {
+      $Items[] = array(
+        'Title' => $Row['title'],
+        'Link' => 'http://'.$_SERVER['SERVER_NAME'].$Config['Web']['BaseURL'],
+        'Description' => $Row['text']." (".$Row['autor'].")",
+        'Time' => $Row['UNIX_TIMESTAMP(date)'],
+      );
+    }
+  } else
+  if($_GET['category'] == 'tickets')
+  {
+    $Config['Web']['Title'] .= ' - žádosti hráčů';
+    $db->select_db($Config['Mangos']['DatabaseCharacters']);
+    $DbResult = $db->query("SELECT `character_ticket`.`ticket_text` AS `text`, `characters`.`name` AS `name` FROM `character_ticket` JOIN `characters` ON `characters`.`guid` = `character_ticket`.`guid`");
+    while($Row = $DbResult->fetch_array())
+    {
+      $Items[] = array(
+        'Title' => $Row['name'].': '.$Row['text'],
+        'Link' => '',
+        'Description' => $Row['name'].': '.$Row['text'],
+        'Time' => 0,
+      );
+    }
+  } 
+  if($_GET['category'] == 'finance')
+  {
+    $Config['Web']['Title'] .= ' - finanční příspěvky';
+    $DbResult = $db->query('SELECT UNIX_TIMESTAMP(time), operation, description, money FROM finance ORDER BY time DESC LIMIT '.$NewsCount);
+    while($Row = $DbResult->fetch_array())
+    {
+      $Items[] = array
+      (
+        'Title' => $OperationType[$Row['operation']].' '.$Row['description'].' ('.$Row['money'].' Kč)',
+        'Link' => 'http://'.$_SERVER['SERVER_NAME'].$Config['Web']['BaseURL'].'finance/',
+        'Description' => $OperationType[$Row['operation']].' '.$Row['description']."<br>".$Row['money']." Kč",
+        'Time' => $Row['UNIX_TIMESTAMP(time)'],
+      );
+    }    
+  }
 }
 

trunk/sql/structure.sql

@@ -83 +83 @@
   `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=115 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=117 ;
 
 -- --------------------------------------------------------
@@ -117 +117 @@
   `ip` varchar(16) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=91 ;
 
 -- --------------------------------------------------------
@@ -132 +132 @@
   PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `debug`
+--
+
+CREATE TABLE IF NOT EXISTS `debug` (
+  `Id` int(11) NOT NULL auto_increment,
+  `Time` datetime NOT NULL,
+  `Backtrace` mediumtext collate latin2_czech_cs NOT NULL,
+  `Log` text collate latin2_czech_cs NOT NULL,
+  `MangosVersion` varchar(255) collate latin2_czech_cs NOT NULL,
+  `DbVersion` varchar(255) collate latin2_czech_cs NOT NULL,
+  `MaxPlayerCount` int(11) NOT NULL,
+  `Uptime` int(11) NOT NULL,
+  `ErrorLog` text collate latin2_czech_cs NOT NULL,
+  `DbErrors` text collate latin2_czech_cs NOT NULL,
+  `Configuration` text collate latin2_czech_cs NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
@@ -147 +168 @@
   `ip` varchar(16) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=18 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=41 ;
 
 -- --------------------------------------------------------
@@ -174 +195 @@
   `odmena` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
   KEY `ID` (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=127 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=128 ;
 
 -- --------------------------------------------------------