function CreateTopic($username, $topicname, $content, $sectionid, $topictype) { $row = ExeSQLFirstRow("SELECT * FROM Topics WHERE Topicname='" . $topicname . "'"); $okay = true; if ($row[0] == "") { ExeSQL("INSERT INTO Topics VALUES(NULL, " . $sectionid . ", -1, '" . $topicname . "', '" . $username . "', '" . $topictype . "', 0, now())") or exit; $row = ExeSQLFirstRow("SELECT * FROM Topics WHERE Topicname='" . $topicname . "'"); ExeSQL("INSERT INTO Posts VALUES(NULL, " . $row[0] . ", '" . $username . "', now(), '" . $content . "')"); $row = ExeSQLFirstRow("SELECT * FROM Posts WHERE TOPICID=" . $row[0]); ExeSQL("UPDATE ForumSection SET LASTPOSTID=" . $row[0] . ", Topiccount=Topiccount+1 WHERE INDEXID=" . $sectionid); $user = GetUser($username); $user->AddExp(Points::$createtopic); $user->CommitUpdate(); } else { $okay = false; } return $okay; }
<ul id="sddm"> <li><a href="#" onmouseover="mopen('maildiv')" onmouseout="mclosetime()"><img src="TemplateImages/Icons/MailPNG.png" width="30" alt="HomePNG" align="center"> Inbox(<?php $result = ExeSQLFirstRow("SELECT COUNT(*) FROM Mail WHERE 5=0 AND 2='" . $_SESSION['MM_Username'] . "'"); echo $result[0]; ?> )<img src="TemplateImages/Icons/view-sort-descending.png" width="30" alt="Dropdown" align="center"></a> <div id="maildiv" onmouseover="mcancelclosetime()" onmouseout="mclosetime()" style="width: 308px;"> <?php $result = ExeSQL("SELECT * FROM Mail WHERE 2='" . $_SESSION['MM_Username'] . "' ORDER BY 6 DESC LIMIT 10"); $continue = true; while ($continue) { $row = mysql_fetch_row($result); if ($row[3] != "") { ?> <a href="#"><span style="color:#06F"><?php echo $row[1]; ?> </span> - <?php echo $row[1]; ?> </a> <?php } else { $continue = false;