Oke het probleem is opgelost en maak er een reactie op omdat het misschien ook makkelijk is voor anderen die hetzelfde probleem hebben.
Ik heb dit van phpbb.com:
Problem
Your server time was incorrect and in the future and upon correcting it you find that you can no longer post due to a flood time limit.
Solution
1. Create a fix.php file with the following:
Code: Selecteer alles
<?php
define('IN_PHPBB', true);
include('./extension.inc');
include('./common.'.$phpEx);
$page_title = 'phpBB Fix';
//time in seconds to roll back
$time = intval(18000);
$sql = " SELECT post_id FROM " . POSTS_TABLE . " ORDER BY post_id DESC LIMIT 1 ";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'could not return max post id', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$max_post_id = $row['post_id'];
$db->sql_freeresult($result);
for ($a=1; $a<=$max_post_id; $a++)
{
$sql = " SELECT post_time FROM " . POSTS_TABLE . " WHERE post_id = $a ";
if( !($result = $db->sql_query($sql)) )
{
continue;
}
else
{
$row = $db->sql_fetchrow($result);
$post_time = $row['post_time'];
$db->sql_freeresult($result);
$new_post_time = ($post_time - $time);
$sql = " UPDATE " . POSTS_TABLE . " SET post_time = $new_post_time WHERE post_id = $a ";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in updating post time', '', __LINE__, __FILE__, $sql);
}
}
}
$sql = " SELECT topic_id FROM " . TOPICS_TABLE . " ORDER BY topic_id DESC LIMIT 1 ";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'could not return max topic id', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$max_topic_id = $row['topic_id'];
$db->sql_freeresult($result);
for ($b=1; $b<=$max_topic_id; $b++)
{
$sql = " SELECT topic_time FROM " . TOPICS_TABLE . " WHERE topic_id = $b ";
if( !($result = $db->sql_query($sql)) )
{
continue;
}
else
{
$row = $db->sql_fetchrow($result);
$topic_time = $row['topic_time'];
$db->sql_freeresult($result);
$new_topic_time = ($topic_time - $time);
$sql = " UPDATE " . TOPICS_TABLE . " SET topic_time = $new_topic_time WHERE topic_id = $b ";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in updating post time', '', __LINE__, __FILE__, $sql);
}
}
}
$sql = " SELECT privmsgs_id FROM " . PRIVMSGS_TABLE . " ORDER BY privmsgs_id DESC LIMIT 1 ";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'could not return max pm id', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$max_pm_id = $row['privmsgs_id'];
$db->sql_freeresult($result);
for ($c=1; $c<=$max_pm_id; $c++)
{
$sql = " SELECT privmsgs_date FROM " . PRIVMSGS_TABLE . " WHERE privmsgs_id = $c ";
if( !($result = $db->sql_query($sql)) )
{
continue;
}
else
{
$row = $db->sql_fetchrow($result);
$pm_time = $row['privmsgs_date'];
$db->sql_freeresult($result);
$new_pm_time = ($pm_time - $time);
$sql = " UPDATE " . PRIVMSGS_TABLE . " SET privmsgs_date = $new_pm_time WHERE privmsgs_id = $c ";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in updating post time', '', __LINE__, __FILE__, $sql);
}
}
}
$sql = " SELECT user_id FROM " . USERS_TABLE . " ORDER BY user_id DESC LIMIT 1 ";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'could not return max user id', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$max_pm_id = $row['user_id'];
$db->sql_freeresult($result);
for ($d=1; $d<=$max_pm_id; $d++)
{
$sql = " SELECT user_last_privmsg FROM " . USERS_TABLE . " WHERE user_id = $d ";
if( !($result = $db->sql_query($sql)) )
{
continue;
}
else
{
$row = $db->sql_fetchrow($result);
$pm_time = $row['user_last_privmsg'];
$db->sql_freeresult($result);
$new_pm_time = ($pm_time - $time);
$sql = " UPDATE " . USERS_TABLE . " SET user_last_privmsg = $new_pm_time WHERE user_id = $d ";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in updating last pm time', '', __LINE__, __FILE__, $sql);
}
}
}
message_die(GENERAL_MESSAGE, 'Completed');
?>
en het werkt echt want ik heb het uitgetest. Het zijn de tijd van je laatste posten terug maar niet de tijd van je forum.
