Reply to thread

Message

[QUOTE=&quot;N.B., post: 19364, member: 1&quot;][PHP]&lt;?php$sql_id_forum=sql_connect(&quot;HOSTNAME&quot;,&quot;USERNAME&quot;,&quot;PASSWORD&quot;,&quot;DATABASENAME&quot;);$query = &quot;SELECT threadid, title FROM thread WHERE forumid != 3 AND forumid != 21 AND forumid != 22 AND forumid !=44 ORDER BY threadid DESC limit 0,10&quot;;$result = sql_query($query,$sql_id_forum);$numrows = sql_num_rows($result);$content = &quot;&lt;table border=\&quot;0\&quot; cellspacing=\&quot;0\&quot; cellpadding=\&quot;0\&quot; valign=\&quot;top\&quot;&gt;&quot;;while(list($threadid, $posttitle) = sql_fetch_row($result, $dbi)) {&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $posttitle = str_replace (&quot;_&quot;, &quot; &quot;, $posttitle);&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $posttitle = str_replace (&quot;.&quot;, &quot; &quot;, $posttitle);&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $content .= &quot;&lt;strong&gt;&lt;b&gt;·&lt;/b&gt;&lt;/strong&gt; &lt;a href=\&quot;http://forum.cdrsoft.cc/showthread.php?threadid=$threadid\&quot; target=\&quot;_blank\&quot;&gt;$posttitle&lt;/a&gt;&lt;br&gt;&quot;;}$query = &quot;SELECT userid, lastactivity FROM session&quot;;$result = mysql_query($query,$sql_id_forum);$users = 0;while(list($userid, $lastactivity) = sql_fetch_row($result, $dbi)) {&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $date = time()+160;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if($lastactivity &gt;= ($date - 15*60))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $users++;}$content .= &quot;&lt;br&gt;&lt;br&gt;$users users online&quot;;$content .= &quot;&lt;/table&gt;&quot;;sql_logout($sql_id_forum);?&gt;[/PHP][/QUOTE]

[QUOTE="N.B., post: 19364, member: 1"] [PHP] <?php $sql_id_forum=sql_connect("HOSTNAME","USERNAME","PASSWORD","DATABASENAME"); $query = "SELECT threadid, title FROM thread WHERE forumid != 3 AND forumid != 21 AND forumid != 22 AND forumid !=44 ORDER BY threadid DESC limit 0,10"; $result = sql_query($query,$sql_id_forum); $numrows = sql_num_rows($result); $content = "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" valign=\"top\">"; while(list($threadid, $posttitle) = sql_fetch_row($result, $dbi)) { $posttitle = str_replace ("_", " ", $posttitle); $posttitle = str_replace (".", " ", $posttitle); $content .= "· <a href=\"http://forum.cdrsoft.cc/showthread.php?threadid=$threadid\" target=\"_blank\">$posttitle</a> "; } $query = "SELECT userid, lastactivity FROM session"; $result = mysql_query($query,$sql_id_forum); $users = 0; while(list($userid, $lastactivity) = sql_fetch_row($result, $dbi)) { $date = time()+160; if($lastactivity >= ($date - 15*60)) $users++; } $content .= " $users users online"; $content .= "</table>"; sql_logout($sql_id_forum); ?> [/PHP] [/QUOTE]

Name

Verification