1
Discussion & Troubleshooting / phpbb user problem?
« on: May 19, 2003, 03:20:32 PM »
hello?
4images code on GitHub Click here to visit GitHub.
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