1
Mods & Plugins (Requests & Discussions) / Re: [MOD] Hot or Not Rating
« on: January 13, 2007, 02:46:16 PM »
is it possible to show the last voting and the upcomin as an thumb ?
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 i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM album_images i, album_categories c LEFT JOIN album_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id LIMIT 4325, 1
Unknown column 'i.user_id' in 'on clause'
your red line in my code looks likeCode: [Select]<img src=\"".TEMPLATE_PATH."/images/gender".$row['user_sex'].".gif\" alt=\"\">
remember to add user_sex, to sql querry
it works for me
//-----------------------------------------------------
//--- Last active User --------------------------------
//-----------------------------------------------------
$sql = "SELECT user_name, user_id, user_lastaction, user_gender, userpic FROM ".USERS_TABLE."
WHERE user_level > '".GUEST."' AND user_invisible = 0
ORDER BY user_lastaction DESC
LIMIT 12";
$result = $site_db->query($sql);
$site_template->register_vars(array(
));
$bgcounter = 1;
while ($row = $site_db->fetch_array($result)) {
if(date("dmy", $row['user_lastaction']) == date("dmy")) {
$last_user_date = $lang['lang_user_last_today']." ".format_date($config['time_format'], $row['user_lastaction']);
}
else {
$last_user_date = format_date($config['date_format']." ".$config['time_format'], $row['user_lastaction']);
}
$row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;
$last_action_user_list .= "<TR class=\"row".$row_bg_number."\"><TD><a href =\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&user_id=".$row['user_id'])."\"><img src=\"".ROOT_PATH."/data/userpic/".((!empty($row['userpic'])) ? $row['userpic'] : "member.jpg")." \" name=\"icons\" border=\"1\" alt=\"\" width=\"35\" height=\"40\"/></a></TD><TD><a href =\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&user_id=".$row['user_id'])."\"><b>".$row['user_name']."</b></a> <img src=\"".TEMPLATE_PATH."/images/gender".$row['user_gender'].".gif\" alt=\"\"><br /><span class=\"smalltext\">".$last_user_date."</span><br /></TD></TR> ";
}
$user_last_action_box = $site_template->parse_template("user_last_action_box");
$site_template->register_vars(array(
"user_last_action_box" => $user_last_action_box,
"lang_user_last_action" => $lang['lang_user_last_action'],
"user_last_action_list" => $last_action_user_list
));
unset($user_last_action_box);
unset($last_action_user_list);
?>
Hey guys, how can i display the gender *.gif form my memberlist in my page_header.phpQuote$last_action_user_list .= '<table border="0" width="100%" id="table1" bordercolor="#808080">
<tr><td width="36"><a href="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><p align="center">
<img src="'.ROOT_PATH.'/data/userpic/'.((empty($userpic)) ? "member.jpg" : $row['userpic']).'" width="35" height="35" border="1" style="border: 1px solid #000066"></td><td><b>
<a href="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'">'.$row['user_name'].'</a></b>
<img src=\"".TEMPLATE_PATH."/images/gender".htmlspecialchars($user_row['user_gender']).".gif\">
<br>'.$last_user_date.'</td></tr></table>
$last_action_user_list .= '<table border="0" width="100%" id="table1" bordercolor="#808080"><tr><td width="50"><a href="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><p align="center"><img src="'.ROOT_PATH.'/data/userpic/'.((empty($userpic)) ? "member.jpg" : $row['userpic']).'" height="35" border="1" style="border: 1px solid #000066"></td><td><b><a href="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'">'.$row['user_name'].'</a></b><img src=\"".TEMPLATE_PATH."/images/gender".$row['user_gender'].".gif\"><span class="smalltext"><br>'.$last_user_date.'</span></td></tr></table>';
$sql = "SELECT user_name, user_id, user_lastaction, user_gender, userpic FROM ".USERS_TABLE."
$last_action_user_list .= '<table border="0" width="100%" id="table1" bordercolor="#808080">
<tr><td width="36"><a href="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><p align="center">
<img src="'.ROOT_PATH.'/data/userpic/'.((empty($userpic)) ? "member.jpg" : $row['userpic']).'" width="35" height="35" border="1" style="border: 1px solid #000066"></td><td><b>
<a href="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'">'.$row['user_name'].'</a></b>
<img src=\"".TEMPLATE_PATH."/images/gender".htmlspecialchars($user_row['user_gender']).".gif\">
<br>'.$last_user_date.'</td></tr></table>
My problem is that members cannot delete their picture to upload an new one.
Is it possible to overwrite a picture without deleting? :