$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);
