$EventMonthEnd = GMTimeChange("m", $TimeSOut, 0, 0, "off"); $EventDay = GMTimeChange("d", $TimeSIn, 0, 0, "off"); $EventDayEnd = GMTimeChange("d", $TimeSOut, 0, 0, "off"); $EventYear = GMTimeChange("Y", $TimeSIn, 0, 0, "off"); $EventYearEnd = GMTimeChange("Y", $TimeSOut, 0, 0, "off"); $User1ID = $MyUserID; $User1IP = $_SERVER['REMOTE_ADDR']; if ($_SESSION['UserGroup'] == $Settings['GuestGroup']) { $User1Name = $_POST['GuestName']; } if ($_SESSION['UserGroup'] != $Settings['GuestGroup']) { $User1Name = $_SESSION['MemberName']; } $query = sql_pre_query("INSERT INTO " . $Settings['sqltable'] . "events (\"UserID\", \"GuestName\", \"EventName\", \"EventText\", \"TimeStamp\", \"TimeStampEnd\", \"EventMonth\", \"EventMonthEnd\", \"EventDay\", \"EventDayEnd\", \"EventYear\", \"EventYearEnd\", \"IP\") VALUES\n" . "(%i, '%s', '%s', '%s', %i, %i, %i, %i, %i, %i, %i, %i, '%s')", array($User1ID, $User1Name, $_POST['EventName'], $_POST['EventText'], $TimeSIn, $TimeSOut, $EventMonth, $EventMonthEnd, $EventDay, $EventDayEnd, $EventYear, $EventYearEnd, $User1IP)); sql_query($query, $SQLStat); $eventid = sql_get_next_id($Settings['sqltable'], "events", $SQLStat); redirect("refresh", $rbasedir . url_maker($exfile['event'], $Settings['file_ext'], "act=event&id=" . $eventid, $Settings['qstr'], $Settings['qsep'], $prexqstr['event'], $exqstr['event'], FALSE), "3"); ?> <tr> <td><span class="TableMessage"><br /> Event <?php echo $_POST['EventName']; ?> was started.<br /> Click <a href="<?php echo url_maker($exfile['event'], $Settings['file_ext'], "act=event&id=" . $eventid, $Settings['qstr'], $Settings['qsep'], $prexqstr['event'], $exqstr['event']); ?> ">here</a> to continue to event.<br /> </span><br /></td> </tr> <?php
</span><br /></td> </tr> <?php } if ($Error != "Yes") { $LastActive = GMTimeStamp(); if ($_SESSION['UserGroup'] == $Settings['GuestGroup']) { $User1Name = $_POST['GuestName']; } if ($_SESSION['UserGroup'] != $Settings['GuestGroup']) { $User1Name = $_SESSION['MemberName']; } $User1IP = $_SERVER['REMOTE_ADDR']; $query = sql_pre_query("INSERT INTO \"" . $Settings['sqltable'] . "messenger\" (\"SenderID\", \"ReciverID\", \"GuestName\", \"MessageTitle\", \"MessageText\", \"Description\", \"DateSend\", \"Read\", \"IP\") VALUES \n(%i, %i, '%s', '%s', '%s', '%s', %i, %i, '%s')", array($_SESSION['UserID'], $SendMessageToID, $_SESSION['MemberName'], $_POST['MessageName'], $_POST['Message'], $_POST['MessageDesc'], $LastActive, 0, $User1IP)); sql_query($query, $SQLStat); $messageid = sql_get_next_id($Settings['sqltable'], "messenger", $SQLStat); ?> <tr> <td><span class="TableMessage"><br /> Message sent to user <?php echo $_POST['SendMessageTo']; ?> .<br /> Click <a href="<?php echo url_maker($exfile['index'], $Settings['file_ext'], "act=view", $Settings['qstr'], $Settings['qsep'], $prexqstr['index'], $exqstr['index']); ?> ">here</a> to go back to index.<br /> </span><br /></td> </tr> <?php }
$NewPostCount = $PostCount; } $gquery = sql_pre_query("SELECT * FROM \"" . $Settings['sqltable'] . "groups\" WHERE \"id\"=%i LIMIT 1", array($User1GroupID)); $gresult = sql_query($gquery, $SQLStat); $User1Group = sql_result($gresult, 0, "Name"); sql_free_result($gresult); $User1IP = $_SERVER['REMOTE_ADDR']; ++$rei; } sql_free_result($reresult); $query = sql_pre_query("INSERT INTO \"" . $Settings['sqltable'] . "topics\" (\"PollID\", \"ForumID\", \"CategoryID\", \"OldForumID\", \"OldCategoryID\", \"UserID\", \"GuestName\", \"TimeStamp\", \"LastUpdate\", \"TopicName\", \"Description\", \"NumReply\", \"NumViews\", \"Pinned\", \"Closed\") VALUES\n" . "(0, %i, %i, %i, %i, %i, '%s', %i, %i, '%s', '%s', 0, 0, 0, 0)", array($ForumID, $ForumCatID, $ForumID, $ForumCatID, $User1ID, $User1Name, $LastActive, $LastActive, $_POST['TopicName'], $_POST['TopicDesc'])); sql_query($query, $SQLStat); $topicid = sql_get_next_id($Settings['sqltable'], "topics", $SQLStat); $query = sql_pre_query("INSERT INTO \"" . $Settings['sqltable'] . "posts\" (\"TopicID\", \"ForumID\", \"CategoryID\", \"UserID\", \"GuestName\", \"TimeStamp\", \"LastUpdate\", \"EditUser\", \"EditUserName\", \"Post\", \"Description\", \"IP\", \"EditIP\") VALUES\n" . "(" . $topicid . ", %i, %i, %i, '%s', %i, %i, 0, '', '%s', '%s', '%s', '0')", array($ForumID, $ForumCatID, $User1ID, $User1Name, $LastActive, $LastActive, $_POST['TopicPost'], $_POST['TopicDesc'], $User1IP)); sql_query($query, $SQLStat); $postid = sql_get_next_id($Settings['sqltable'], "posts", $SQLStat); $_SESSION['LastPostTime'] = GMTimeStamp() + $GroupInfo['FloodControl']; if ($User1ID != 0 && $User1ID != -1) { $queryupd = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "members\" SET \"LastActive\"=%i,\"IP\"='%s',\"PostCount\"=%i,\"LastPostTime\"=%i WHERE \"id\"=%i", array($LastActive, $User1IP, $NewPostCount, $_SESSION['LastPostTime'], $User1ID)); sql_query($queryupd, $SQLStat); } $NewNumPosts = $NumberPosts + 1; $NewNumTopics = $NumberTopics + 1; $queryupd = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "forums\" SET \"NumPosts\"=%i,\"NumTopics\"=%i WHERE \"id\"=%i", array($NewNumPosts, $NewNumTopics, $ForumID)); sql_query($queryupd, $SQLStat); redirect("refresh", $rbasedir . url_maker($exfile['topic'], $Settings['file_ext'], "act=view&id=" . $topicid . "&page=1", $Settings['qstr'], $Settings['qsep'], $prexqstr['topic'], $exqstr['topic'], FALSE), "3"); ?> <tr> <td><span class="TableMessage"><br /> Topic <?php echo $_POST['TopicName'];
if ($_POST['YourOffSet'] < -12) { $_POST['YourOffSet'] = "-12"; } if (!is_numeric($_POST['MinOffSet'])) { $_POST['MinOffSet'] = "00"; } if ($_POST['MinOffSet'] > 59) { $_POST['MinOffSet'] = "59"; } if ($_POST['MinOffSet'] < 0) { $_POST['MinOffSet'] = "00"; } $_POST['YourOffSet'] = $_POST['YourOffSet'] . ":" . $_POST['MinOffSet']; $query = sql_pre_query("INSERT INTO \"" . $Settings['sqltable'] . "members\" (\"Name\", \"UserPassword\", \"HashType\", \"Email\", \"GroupID\", \"Validated\", \"HiddenMember\", \"WarnLevel\", \"Interests\", \"Title\", \"Joined\", \"LastActive\", \"LastPostTime\", \"BanTime\", \"BirthDay\", \"BirthMonth\", \"BirthYear\", \"Signature\", \"Notes\", \"Avatar\", \"AvatarSize\", \"Website\", \"Gender\", \"PostCount\", \"Karma\", \"KarmaUpdate\", \"RepliesPerPage\", \"TopicsPerPage\", \"MessagesPerPage\", \"TimeZone\", \"DateFormat\", \"TimeFormat\", \"DST\", \"UseTheme\", \"IP\", \"Salt\") VALUES\n" . "('%s', '%s', '%s', '%s', '%s', '%s', '%s', %i, '%s', '%s', %i, %i, '0', '0', '0', '0', '0', '%s', '%s', '%s', '%s', '%s', '%s', %i, 0, 0, 10, 10, 10, '%s', '%s', '%s', '%s', '%s', '%s', '%s')", array($Name, $NewPassword, $iDBHash, $_POST['Email'], $yourgroup, $ValidateStats, $HideMe, "0", $_POST['Interests'], $_POST['Title'], $_POST['Joined'], $_POST['LastActive'], $NewSignature, 'Your Notes', $Avatar, "100x100", $Website, $_POST['YourGender'], $_POST['PostCount'], $_POST['YourOffSet'], $Settings['idb_date_format'], $Settings['idb_time_format'], $_POST['DST'], $Settings['DefaultTheme'], $_POST['UserIP'], $HashSalt)); sql_query($query, $SQLStat); $yourid = sql_get_next_id($Settings['sqltable'], "members", $SQLStat); $idquery = sql_pre_query("SELECT * FROM \"" . $Settings['sqltable'] . "members\" WHERE \"Name\"='%s' AND \"UserPassword\"='%s' AND \"Email\"='%s' AND \"IP\"='%s' AND \"Salt\"='%s' LIMIT 1", array($Name, $NewPassword, $_POST['Email'], $_POST['UserIP'], $HashSalt)); $idresult = sql_query($idquery, $SQLStat); $idnum = sql_num_rows($idresult); $idcheck = $yourid; if ($idnum >= 1) { $idncheck = sql_result($idresult, 0, "id"); $idncheck = intval($idncheck); } sql_free_result($idresult); if ($yourid != $idncheck) { $yourid = $idncheck; } $query = sql_pre_query("INSERT INTO \"" . $Settings['sqltable'] . "mempermissions\" (\"id\", \"PermissionID\", \"CanViewBoard\", \"CanViewOffLine\", \"CanEditProfile\", \"CanAddEvents\", \"CanPM\", \"CanSearch\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBags\", \"CanModForum\", \"CanViewIPAddress\", \"CanViewUserAgent\", \"FloodControl\", \"SearchFlood\", \"HasModCP\", \"HasAdminCP\", \"ViewDBInfo\") VALUES\n" . "(%i, %i, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %i, %i, '%s', '%s', '%s')", array($yourid, 0, "group", "group", "group", "group", "group", "group", "group", "group", "group", "group", "group", "group", -1, -1, "group", "group", "group")); //"(%i, %i, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %i, %i, '%s', '%s', '%s')", array($yourid, 0, $PreUserPer['CanViewBoard'], $PreUserPer['CanViewOffLine'], $PreUserPer['CanEditProfile'], $PreUserPer['CanAddEvents'], $PreUserPer['CanPM'], $PreUserPer['CanSearch'], $PreUserPer['CanExecPHP'], $PreUserPer['CanDoHTML'], $PreUserPer['CanUseBBags'], $PreUserPer['CanModForum'], $PreUserPer['FloodControl'], $PreUserPer['SearchFlood'], $PreUserPer['HasModCP'], $PreUserPer['HasAdminCP'], $PreUserPer['ViewDBInfo'])); sql_query($query, $SQLStat);