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;
}
示例#2
0
    <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;