I was slow to read MG's advice in http://www.phpBBXS.eu/viewtopic.php?t=243&highlight=cback and have "installed" the new Cracker Tracker. I ran the install and it seemed OK, I modified each file meticulously but now when trying to open any message the following error appears:
General Error
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'u.ct_miserable_user' in 'field list'
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_rank2, u.user_rank3, u.user_rank4, u.user_rank5, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.ct_miserable_user, u.user_allow_viewonline, u.user_session_time, u.user_warnings, u.user_level, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, u.user_personal_pics_count, u.user_style, u.user_lang, p.*, pt.post_text, pt.post_text_compiled, pt.post_subject, pt.bbcode_uid, pt.edit_notes, t.topic_poster, t.title_compl_infos, u.ct_miserable_user FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, phpbb_topics t WHERE p.topic_id = 491 AND t.topic_id = p.topic_id AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 742
File : viewtopic.php
DEBUG MODE
SQL Error : 1054 Unknown column 'u.ct_miserable_user' in 'field list'
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_rank2, u.user_rank3, u.user_rank4, u.user_rank5, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.ct_miserable_user, u.user_allow_viewonline, u.user_session_time, u.user_warnings, u.user_level, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, u.user_personal_pics_count, u.user_style, u.user_lang, p.*, pt.post_text, pt.post_text_compiled, pt.post_subject, pt.bbcode_uid, pt.edit_notes, t.topic_poster, t.title_compl_infos, u.ct_miserable_user FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt, phpbb_topics t WHERE p.topic_id = 491 AND t.topic_id = p.topic_id AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 742
File : viewtopic.php
Instructions on what to change in viewtopic.php:
#-----[ OPEN ]------------------------------------------
#
viewtopic.php
#
#-----[ FIND ]------------------------------------------
#
# the original line is longer!
//
// Go ahead and pull all data for this topic
//
$sql = "SELECT u.username, u.user_id, u.user_posts,
#
#-----[ IN-LINE FIND ]------------------------------------------
#
u.user_allowsmile
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, u.ct_miserable_user
#
#-----[ FIND ]------------------------------------------
#
$message = $postrow[$i]['post_text'];
#
#-----[ REPLACE WITH ]------------------------------------------
#
// CrackerTracker v5.x
if ( $postrow[$i]['ct_miserable_user'] == 1 && $postrow[$i]['user_id'] != $userdata['user_id'] && $userdata['user_level'] == 0)
{
$message = $lang['ctracker_message_dialog_title'] . '<br /><br />' . $lang['ctracker_ipb_deleted'];
}
else
{
$message = $postrow[$i]['post_text'];
if ( $postrow[$i]['ct_miserable_user'] == 1 && $userdata['user_level'] == ADMIN )
{
$message .= '<br /><br />' . $lang['ctracker_mu_success'];
}
}
#
viewtopic.php
#
#-----[ FIND ]------------------------------------------
#
# the original line is longer!
//
// Go ahead and pull all data for this topic
//
$sql = "SELECT u.username, u.user_id, u.user_posts,
#
#-----[ IN-LINE FIND ]------------------------------------------
#
u.user_allowsmile
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, u.ct_miserable_user
#
#-----[ FIND ]------------------------------------------
#
$message = $postrow[$i]['post_text'];
#
#-----[ REPLACE WITH ]------------------------------------------
#
// CrackerTracker v5.x
if ( $postrow[$i]['ct_miserable_user'] == 1 && $postrow[$i]['user_id'] != $userdata['user_id'] && $userdata['user_level'] == 0)
{
$message = $lang['ctracker_message_dialog_title'] . '<br /><br />' . $lang['ctracker_ipb_deleted'];
}
else
{
$message = $postrow[$i]['post_text'];
if ( $postrow[$i]['ct_miserable_user'] == 1 && $userdata['user_level'] == ADMIN )
{
$message .= '<br /><br />' . $lang['ctracker_mu_success'];
}
}
(the whole file doesn't fit in here sorry)
I made 2 backups of the forum prior to starting this job but neither of them will restore! Plus I saved a copy of each individual file before I modified it.
I don't know what to do now. Try to fix the new errors or delete this version and just keep the old one?
Thanks in advance for responses.
Cheers,
Julie
