For the ones who need it, simple php script I made to reset guild time:
PHP Code:
<?php
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
if(isset($_SESSION['reset']))
{
echo "Dont spam my reset script nubcake!";
}
else
{
$connect = mssql_connect('localhost', 'username', 'password');
mssql_select_db('kal_db', $connect);
$update = mssql_query("UPDATE GuildMember SET [Date] ='0' WHERE [Date] != '0' ");
if($update)
{
$_SESSION['reset'] = 'done';
echo "Succesfully reset all guild timers.";
}
else
{
echo"Something went wrong, timers not reset.";
}
}
}
?>
<form method="POST" action="">
<table>
<tr>
<td><input type="submit" name="POST" value="Reset" /></td>
</tr>
</table>
</form>