[trurl3]

Originally Posted by KRoCk85

that did not work for me, my added, editedats have multiple counts and are on different lines, could you post your forums.php

Your welcome. THis is my forums.php
[code]<?
/*ob_start("ob_gzhandler");*/

require "include/bittorrent.php";

dbconn(false);
// maxsysop ();

loggedinorreturn();
parked();

$action = htmlspecialchars(trim($_GET["action"]));

$forums = mysql_query("select id from forums");
while ($forum = mysql_fetch_assoc($forums))
{
$postcount = 0;
$topiccount = 0;
$topics = mysql_query("select id from topics where forumid=$forum[id]");
while ($topic = mysql_fetch_assoc($topics))
{
$res = mysql_query("select count(*) from posts where topicid=$topic[id]");
$arr = mysql_fetch_row($res);
$postcount += $arr[0];
++$topiccount;
}
mysql_query("update forums set postcount=$postcount, topiccount=$topiccount where id=$forum[id]");
}
function catch_up()
{
global $CURUSER;

$userid = $CURUSER["id"];

$res = mysql_query("SELECT id, lastpost FROM topics") or sqlerr(__FILE__, __LINE__);

while ($arr = mysql_fetch_assoc($res))
{
$topicid = $arr["id"];

$postid = $arr["lastpost"];

$r = mysql_query("SELECT id,lastpostread FROM readposts WHERE userid=$userid and topicid=$topicid") or sqlerr(__FILE__, __LINE__);

if (mysql_num_rows($r) == 0)
mysql_query("INSERT INTO readposts (userid, topicid, lastpostread) VALUES($userid, $topicid, $postid)") or sqlerr(__FILE__, __LINE__);

else
{
$a = mysql_fetch_assoc($r);

if ($a["lastpostread"] < $postid)
mysql_query("UPDATE readposts SET lastpostread=$postid WHERE id=" . $a["id"]) or sqlerr(__FILE__, __LINE__);
}
}
}

//-------- Returns the minimum read/write class levels of a forum

function get_forum_access_levels($forumid)
{
$res = mysql_query("SELECT minclassread, minclasswrite, minclasscreate FROM forums WHERE id=".mysql_real_escape_string($forumid)) or sqlerr(__FILE__, __LINE__);

if (mysql_num_rows($res) != 1)
return false;

$arr = mysql_fetch_assoc($res);

return array("read" => $arr["minclassread"], "write" => $arr["minclasswrite"], "create" => $arr["minclasscreate"]);
}

//-------- Returns the forum ID of a topic, or false on error

function get_topic_forum($topicid)
{
$res = mysql_query("SELECT forumid FROM topics WHERE id=".mysql_real_escape_string($topicid)) or sqlerr(__FILE__, __LINE__);

if (mysql_num_rows($res) != 1)
return false;

$arr = mysql_fetch_row($res);

return $arr[0];
}

//-------- Returns the ID of the last post of a forum

function update_topic_last_post($topicid)
{
$res = mysql_query("SELECT id FROM posts WHERE topicid=".mysql_real_escape_string($topicid)." ORDER BY id DESC LIMIT 1") or sqlerr(__FILE__, __LINE__);

$arr = mysql_fetch_row($res) or die("No post found");

$postid = $arr[0];

mysql_query("UPDATE topics SET lastpost=$postid WHERE id=".mysql_real_escape_string($topicid)) or sqlerr(__FILE__, __LINE__);
}

function get_forum_last_post($forumid)
{
$res = mysql_query("SELECT lastpost FROM topics WHERE forumid=".mysql_real_escape_string($forumid)." ORDER BY lastpost DESC LIMIT 1") or sqlerr(__FILE__, __LINE__);

$arr = mysql_fetch_row($res);

$postid = $arr[0];

if ($postid)
return $postid;

else
return 0;
}

//-------- Inserts a quick jump menu

function insert_quick_jump_menu($currentforum = 0)
{
print("<p align=center><form method=get action=? name=jump>\n");

print("<input type=hidden name=action value=viewforum>\n");

print("Id? do: ");

print("<select name=forumid onchange=\"if(this.options[this.selectedIndex].value != -1){ forms['jump'].submit() }\">\n");

$res = mysql_query("SELECT * FROM forums ORDER BY name") or sqlerr(__FILE__, __LINE__);

while ($arr = mysql_fetch_assoc($res))
{
if (get_user_class() >= $arr["minclassread"])
print("<option value=" . $arr["id"] . ($currentforum == $arr["id"] ? " selected>" : ">") . $arr["name"] . "\n");
}

print("</select>\n");

print("<input type=submit value='Id?!'>\n");

print("</form>\n</p>");
}

//-------- Inserts a compose frame

function insert_compose_frame($id, $newtopic = true, $quote = false)
{
global $maxsubjectlength, $CURUSER;

if ($newtopic)
{
$res = mysql_query("SELECT name FROM forums WHERE id=".mysql_real_escape_string($id)) or sqlerr(__FILE__, __LINE__);

$arr = mysql_fetch_assoc($res) or die("Bad forum id");

$forumname = $arr["name"];

print("<p align=center>Nowy temat w <a href=?action=viewforum&forumid=$id>$forumname</a> forum</p>\n");
}
else
{
$res = mysql_query("SELECT * FROM topics WHERE id=$id") or sqlerr(__FILE__, __LINE__);

$arr = mysql_fetch_assoc($res) or stderr("B?