1
Discussion & Troubleshooting / phpbb user problem?
« on: May 19, 2003, 03:20:32 PM »
hello?
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
DB Error: Bad SQL Query: SELECT u.*, l.* FROM 4images_users u, 4images_lightboxes l WHERE u.user_id = XippiX AND l.user_id = u.user_id
Unknown column 'XippiX' in 'where clause'
DB Error: Bad SQL Query: SELECT * FROM 4images_users WHERE user_id = XippiX
Unknown column 'XippiX' in 'where clause'
Warning: Cannot add header information - headers already sent by (output started at /home/XippiX/HTML/includes/db_mysql.php:188) in /home/XippiX/HTML/includes/sessions.php on line 85
Warning: Cannot add header information - headers already sent by (output started at /home/XippiX/HTML/includes/db_mysql.php:188) in /home/XippiX/HTML/includes/sessions.php on line 85
Warning: Cannot add header information - headers already sent by (output started at /home/XippiX/HTML/includes/db_mysql.php:188) in /home/XippiX/HTML/includes/sessions.php on line 85
//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$additional_sql = "";
$table_fields = $site_db->get_table_fields(USERS_TABLE);
foreach ($additional_user_fields as $key => $val) {
if (isset($HTTP_POST_VARS[$key]) && isset($table_fields[$key])) {
$additional_sql .= ", $key = '".un_htmlspecialchars(trim($HTTP_POST_VARS[$key]))."'";
}
}
$sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").$additional_sql."
FROM ".COMMENTS_TABLE." c
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = c.user_id)
ORDER BY c.comment_date DESC
LIMIT 14";
$result = $site_db->query($sql);
$comment_row = array();
while ($row = $site_db->fetch_array($result)) {
$comment_row[] = $row;
}
c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").$additional_sql."
Fatal error: Call to undefined function: get_user_table_field() in /home/zippie/HTML/index.php on line 131