ssih wrote: So it was a simple matter of copying them from one ubb file to another.
Code: Select all
if ($ubb_vars_config = file($classic_vars_path . '/vars_config.cgi'))Code: Select all
$post_subject = $topic_subject;
$post_text = undo_classic_markup($post_info[6], $classic_smilies);
if ($post_text != '')
{
$bbcode_uid = ( $board_config['allow_bbcode'] ) ? make_bbcode_uid() : '';
$post_text = addslashes($post_text);
// Undo the line breaks
$post_text = str_replace('<br />', '\\n ', $post_text);
$post_text = prepare_message($post_text, $board_config['allow_html'], $board_config['allow_bbcode'], $board_config['allow_smilies'], $bbcode_uid);
}Code: Select all
if ($post_text != '')
{
$bbcode_uid = ( $board_config['allow_bbcode'] ) ? make_bbcode_uid() : '';
$post_text = addslashes($post_text);
// Undo the line breaks
$post_text = str_replace('<br />', '\n ', $post_text);
$post_text = prepare_message($post_text, $board_config['allow_html'], $board_config['allow_bbcode'], $board_config['allow_smilies'], $bbcode_uid);
}
Code: Select all
$post_text = str_replace('<br />', "\n ", $post_text);
Code: Select all
// Now lets handle the first post
// Check whether the post was made by a registered user. If it was, we want to
// store the user_id, if not just record it as a guest post
if ($post_info[8] == 'reg')
{
// Check that there is something in this field, if there is, we use it as there is
// no need to do any lookups
if ($post_info[11] != '')
{
$poster_id = intval($post_info[11])+1;
$post_username = '';
}
// If there wasn't then this must be an old upgraded post so we need to fall back to
// looking it up based on something which should be in every post
else
{
$sql = "SELECT user_id FROM " . USERS_TABLE . " WHERE username = '" . sql_addslashes($post_info[2]) . "'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result); // This really needs testing
$poster_id = $row['user_id'];
$post_username = '';
}
}
else
{
$post_username = sql_addslashes($post_info[10]);
$poster_id = -1;
}
Code: Select all
if ($post_info[11] != '')
{
$poster_id = intval($post_info[11])+1;
// Make sure this ID is valid to prevent phantom posts
$sql = "SELECT user_id FROM " . USERS_TABLE . " WHERE user_id = $poster_id";
$result = $db->sql_query($sql);
$rows = mysql_num_rows($result);
if (!$rows)
{
$post_username = sql_addslashes($post_info[10]);
$poster_id = -1;
}
else
{
$post_username = '';
}
}
I didn't see many others who also had it either. It's probably something to do with settings or changes in recent versions of php.D¡cky wrote:I don't recall there being a problem with posts not displaying correctly.
I was just about to tell you that you need to check the poster_id in the topics table as well as the posts table.fround wrote:Update: The code change successfully detected the right posts, assigning -1 to poster_id and the correct username to post_username. The posts are verified in the database with this information, but they still don't show up in topics... Will have to look into this more.
That's what I was thinking, so I went and added a check to the else block where the script checks the poster id of a topic:D¡cky wrote:I was just about to tell you that you need to check the poster_id in the topics table as well as the posts table.
Code: Select all
else
{
$poster_id = $poster_id + 1;
$sql = "SELECT user_id FROM " . USERS_TABLE . " WHERE user_id = $poster_id";
$result = $db->sql_query($sql);
$rows = mysql_num_rows($result);
if (!$rows)
{
$poster_id = -1;
}
}No, I just wasn't being clear. The posts within topics are in order, for the reason you mentioned. It's the topics that were out of order, but the display fix you pointed me to did the trick. The only hurdle I've got left now is dealing with these phantom posts.D¡cky wrote:As far as the posts not displaying in order, I don't understand how that is possible since they are sorted by time.
Code: Select all
$sql = "UPDATE " . TOPICS_TABLE . " SET topic_last_post_id = $post_id[color=#FF8000], topic_first_post_id[/color] = $post_id WHERE topic_id = $topic_id";
[The extension zip has been deactivated and can no longer be displayed.]
Code: Select all
%vars_config = (
CGIURL => q!../ubb/boards/cgi-bin/!,
NonCGIURL => q!../ubb/boards/data!,
CGIPath => q!../ubb/boards/cgi-bin/!,
NonCGIPath => q!../ubb/boards/data!,
MembersPath => q!../ubb/boards/cgi-bin/Members!,
VariablesPath => q!../ubb/boards/cgi-bin/!,
cache_pw => "2MPD238U",
Cookie_Number => "2452201.0231",
BBName => q~AILA Message Center~,
DataSource => q!aila!,
UserName => q!aila!,
Password => q!eeshyct!
);
1;
I am unsure what to do next.Checking PHP Configuration
SUCCEEDED Your server is running a version of PHP which will support this convertor
SUCCEEDED Your server is not running in safe mode. Script timeouts will be disabled for the duration of the conversion process
Checking access to UBB.classic forum
SUCCEEDED Loading UBB.classic configuration file (vars_config.cgi)
FAILED Checking UBB.classic CGI path (ultimatebb.cgi)
FAILED Checking UBB.classic members path (memberslist.cgi)
FAILED Checking UBB.classic non-CGI path (on.gif)
A fatal error has occurred and the conversion process is unable to start. Please check the information above for details of the error(s), and correct them and try again.
Nope. Hard to believe.edsager wrote:Hello All,
Can you believe this topic is being resurrected again?