Changeset 307 for minimanager/forum.php

Timestamp:

Mar 13, 2008, 8:18:42 PM (17 years ago)

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

• minimanager/forum.php (modified) (4 diffs)

minimanager/forum.php

@@ -97 +97 @@
 if (isset($_COOKIE["lang"])){
         $forumlang = $_COOKIE["lang"];
-        if (!file_exists("lang/forum_$forumlang.php")) $forumlang = $language;
+        if (!file_exists("lang/Forum_$forumlang.php")) $forumlang = $language;
         } else $forumlang = $language;
-require_once("lang/forum_$forumlang.php");
+require_once("lang/Forum_$forumlang.php");
 
 foreach($forum_skeleton as $cid => $category){
@@ -120 +120 @@
         global $enablesidecheck, $forum_skeleton, $forum_lang, $user_lvl, $output, $realm_db;
         if($enablesidecheck)
-                $side = get_side();
-        $mysql = new SQL;
-        $mysql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
-        $result = $mysql->query("SELECT `authorname`,`id`,`name`,`forum` FROM `posts` WHERE `id` IN (SELECT MAX(`id`) FROM `posts` GROUP BY `forum`) ORDER BY `forum`;");
-        $lasts = array();
-        if($mysql->num_rows($result) > 0){
-                while($row = $mysql->fetch_row($result))
-                        $lasts[$row[3]] = $row;
-        }
-        $output .= "<div class=\"top\"><h1>{$forum_lang["forums"]}</h1>{$forum_lang["you_are_here"]} : <a href=\"forum.php\">{$forum_lang["forum_index"]}</a></div><center><table class=\"lined\">";
-        foreach($forum_skeleton as $category){
-                if(($category["level_read"] > $user_lvl))
+        $side = get_side();
+    $mysql = new SQL;
+    $mysql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
+    $result = $mysql->query("SELECT `authorname`,`id`,`name`,`time`,`forum` FROM `posts` WHERE `id` IN (SELECT MAX(`id`) FROM `posts` GROUP BY `forum`) ORDER BY `forum`;");
+    $lasts = array();
+    if($mysql->num_rows($result) > 0){
+        while($row = $mysql->fetch_row($result))
+            $lasts[$row[4]] = $row;
+    }
+    $output .= "<div class=\"top\"><h1>{$forum_lang["forums"]}</h1>{$forum_lang["you_are_here"]} : <a href=\"forum.php\">{$forum_lang["forum_index"]}</a></div><center><table class=\"lined\">";
+    foreach($forum_skeleton as $category){              if(($category["level_read"] > $user_lvl))
                         continue;
                 if($user_lvl == 0 && $enablesidecheck){
@@ -138 +137 @@
                                         continue;
                                 else if($category["side_access"] != $side) // Forumside different of the user side
-                                        continue;
-                        }
-                }
-                $output .= "<tr><td class=\"head\" align=\"left\" colspan=\"2\">".$category["name"]."</td></tr>";
-                foreach($category["forums"] as $id => $forum){
-                        if($forum["level_read"] > $user_lvl)
-                                continue;
-                        if($user_lvl == 0 && $enablesidecheck){
+                    continue;
+            }
+        }
+        $output .= "<tr><td class=\"head\" align=\"left\">".$category["name"]."</td>
+                    <td class=\"head\">{$forum_lang["topics"]}</td>
+                    <td class=\"head\">{$forum_lang["replies"]}</td>
+                    <td class=\"head\" align=\"right\">".$forum_lang["last_post"]."</td></tr>";
+        foreach($category["forums"] as $id => $forum){
+            if($forum["level_read"] > $user_lvl)
+                continue;                       if($user_lvl == 0 && $enablesidecheck){
                                 if($forum["side_access"] != "ALL"){ // Not an all side forum
                                         if($side == "NO") // No char
                                                 continue;
                                         else if($forum["side_access"] != $side) // Forumside different of the user side
-                                                continue;
-                                }
-                        }
-                        $output .= "<tr><td align=\"left\"><a href=\"forum.php?action=view_forum&amp;id=$id\">{$forum["name"]}</a><br />{$forum["desc"]}</td>";
-                        if(isset($lasts[$id])){
-                                $lasts[$id][2] = htmlspecialchars($lasts[$id][2]);
-                                $output .= "<td align=\"right\">{$forum_lang["last_post_by"]} {$lasts[$id][0]} {$forum_lang["in"]} <a href=\"forum.php?action=view_topic&amp;postid={$lasts[$id][1]}\">{$lasts[$id][2]}</a></td></tr>";
-                        }
-                        else{
-                                $output .= "<td align=\"right\">{$forum_lang["no_topics"]}</td></tr>";
-                        }
+                        continue;
+                }
+            }
+            $totaltopics = $mysql->query("SELECT id FROM posts WHERE forum = '$id' AND id = `topic`;");
+            $numtopics = $mysql->num_rows($totaltopics);
+            $totalreplies = $mysql->query("SELECT id FROM posts WHERE forum = '$id';");
+            $numreplies = $mysql->num_rows($totalreplies);
+            $output .= "<tr><td align=\"left\"><a href=\"forum.php?action=view_forum&amp;id=$id\">{$forum["name"]}</a><br />{$forum["desc"]}</td>
+                        <td>{$numtopics}</td>
+                        <td>{$numreplies}</td>";
+            if(isset($lasts[$id])){
+                $lasts[$id][2] = htmlspecialchars($lasts[$id][2]);
+                $output .= "<td align=\"right\"><a href=\"forum.php?action=view_topic&amp;postid={$lasts[$id][1]}\">{$lasts[$id][2]}</a><br />by {$lasts[$id][0]} <br /> {$lasts[$id][3]} </td></tr>";
+            }
+            else{
+                $output .= "<td align=\"right\">{$forum_lang["no_topics"]}</td></tr>";
+                }
                 }
         }
@@ -294 +301 @@
 // Thx qsa for the query structure
 $query = "SELECT account,name,SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ', 37),' ',-1) AS gen,race,class,
-SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',35),' ',-1) AS level,(SELECT gmlevel FROM `{$realm_db['name']}`.account WHERE `{$realm_db['name']}`.account.id = `{$characters_db[$realm_id]['name']}`.character.account) as gmlevel
-FROM `{$characters_db[$realm_id]['name']}`.character WHERE totaltime IN ( SELECT MAX(totaltime) FROM `{$characters_db[$realm_id]['name']}`.character WHERE account IN (";
+SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',35),' ',-1) AS level,(SELECT gmlevel FROM `{$realm_db['name']}`.account WHERE `{$realm_db['name']}`.account.id = `{$characters_db[$realm_id]['name']}`.characters.account) as gmlevel
+FROM `{$characters_db[$realm_id]['name']}`.characters WHERE totaltime IN ( SELECT MAX(totaltime) FROM `{$characters_db[$realm_id]['name']}`.characters WHERE account IN (";
 while($post = $mysql->fetch_row($posts)){
         $query .= "$post[1],";