[2023-01-23] 4images 1.10 released
0 Members and 1 Guest are viewing this topic.
?>
$sql = "SELECT user_t_images, user_name, user_id FROM ".USERS_TABLE."WHERE user_level >= '".USER."'ORDER BY user_t_images DESCLIMIT 25";$result = $site_db->query($sql);while ($row = $site_db->fetch_array($result)) {$last_action_user_list .= '<a href ="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><b>'.$row['user_name'].'</b></a> <span class="smalltext">'.$row['user_t_images'].'</span><br>';}$site_template->register_vars(array("user_uploaders_list" => $last_action_user_list,));unset($user_uploaders_list);
<table border="0" cellspacing="1" cellpadding="1" background="{template_url}/images/cat.gif" width="100%"> <tr> <td height="20" background="{template_url}/images/back1.gif"> <b>Top 25 Usuarios</b></td> </tr> <tr> <td class="row1">{user_uploaders_list}<br></td> </tr></table>
LIMIT 25";
LIMIT 10";
$sql = "SELECT user_t_images, user_name, user_id FROM ".USERS_TABLE."
$sql = "SELECT user_t_images, user_gender, user_name, user_id FROM ".USERS_TABLE."
$last_action_user_list .= '<a href ="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><b>'.$row['user_name'].'</b></a> <span class="smalltext">'.$row['user_t_images'].'</span><br>';
$last_action_user_list .= '<img src="'.TEMPLATE_PATH.'/images/'.$row['user_gender'].'.gif"> <a href ="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><b>'.$row['user_name'].' </b></a><span class="smalltext">'.$row['user_t_images'].'</span><br>';
Las instruciones tienen que ser las mismas o muy parecidas,, pero no he trabajado el MOD ese de las fotos personales y por lo tanto no se las variables ni los campos de las tablas. Es cuestión de darle un vistazo.
<img src="'.ROOT_PATH.'/data/userpic/'.$row['user_id'].'.jpg" width="37" height="39">
$sql = "SELECT user_t_images, user_gender, userpic, user_name, user_id FROM ".USERS_TABLE."
<img src="'.ROOT_PATH.'/data/userpic/'.$row['userpic'].'" width="37" height="39">
$last_action_user_list .= '<tr><td class="row1"><a href="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><b>'.$row['user_name'].' </b></a></td><td class="row1"><span class="smalltext">'.$row['user_t_images'].'</span></td><td class="row1"><img src="'.TEMPLATE_PATH.'/images/'.$row['user_gender'].'.gif"></td></tr>';}