Sort user by upload in CPA

[ascanio]

Hi, is there any way in the control panel in the option edit users to sort the user in order of how many pictures have they upload?

[V@no]

try this:
in admin/users.php find:

Code: [Select]

  <option value="<?php echo get_user_table_field("", "user_lastaction"); ?>"><?php echo $lang['field_lastaction']; ?></option>insert below:

Code: [Select]

  <option value="num"><?php echo $lang['images']; ?></option>
Then find:

Code: [Select]

$condition = "1=1";below that u will find bunch of get_user_table_field("" started with

Code: [Select]

    $condition .= " AND ".get_user_table_field("", "user_level")." = $user_level"; and ended with

Code: [Select]

    $orderby = get_user_table_field("", "user_name");in every instance insert u. inside the empty quotes:

    $orderby = get_user_table_field("u.", "user_name");

(u should change 8 lines.

Next, find:

Code: [Select]

  $sql = "SELECT COUNT(*) AS users
          FROM ".USERS_TABLE."
          WHERE $condition AND ".get_user_table_field("", "user_id")." <> ".GUEST;Replace it with:

Code: [Select]

  $sql = "SELECT COUNT(*) AS users
          FROM ".USERS_TABLE." u
          WHERE $condition AND ".get_user_table_field("u.", "user_id")." <> ".GUEST;
And last find:

Code: [Select]

    $sql = "SELECT ".get_user_table_field("", "user_id").get_user_table_field(", ", "user_name").get_user_table_field(", ", "user_email").get_user_table_field(", ", "user_joindate").get_user_table_field(", ", "user_lastaction")."
            FROM ".USERS_TABLE."
            WHERE $condition AND ".get_user_table_field("", "user_id")." <> ".GUEST."
            ORDER BY $orderby $direction
            LIMIT $limitstart, $limitnumber";Replace it with:

Code: [Select]

    $sql = "SELECT COUNT(i.image_id) AS num, ".get_user_table_field("u.", "user_id").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").get_user_table_field(", u.", "user_joindate").get_user_table_field(", u.", "user_lastaction")."
            FROM ".USERS_TABLE." u
            LEFT JOIN ".IMAGES_TABLE." i ON (i.user_id = u.user_id)
            WHERE $condition AND ".get_user_table_field("u.", "user_id")." <> ".GUEST."
            GROUP BY u.user_id
            ORDER BY $orderby $direction
            LIMIT $limitstart, $limitnumber";

[ascanio]

Hey V@no thanks a lot and can we sort the images en edit images by size? i'm getting close to my megasbytes limit in my server so i wanna delete the biggers ones

[V@no]

sorry, no, its not possible, because image dimentions an sizes not being saved in the database.

[ascanio]

oooh ok i understand , i have a problem modifiging what u just told me ...

Code: [Select]

$condition = "1=1";

  $user_level = intval($HTTP_POST_VARS['user_level']);
  if ($user_level == 0) {
     $user_level = intval($HTTP_GET_VARS['user_level']);
  }
  if ($user_level != GUEST) {
    $condition .= " AND ".get_user_table_field("", "user_level")." = $user_level";
  }
  $user_name = trim($HTTP_POST_VARS['user_name']);
  if ($user_name != "") {
    $condition .= " AND INSTR(LCASE(".get_user_table_field("", "user_name")."),'".strtolower($user_name)."')>0";
  }
  $user_email = trim($HTTP_POST_VARS['user_email']);
  if ($user_email != "") {
    $condition .= " AND INSTR(LCASE(".get_user_table_field("", "user_email")."),'".strtolower($user_email)."')>0";
  }
  $dateafter = trim($HTTP_POST_VARS['dateafter']);
  if ($dateafter != "") {

that what i find after

Code: [Select]

$condition = "1=1"; and i just see one

Code: [Select]

$orderby = trim($HTTP_POST_VARS['orderby']);
  if ($orderby == "") {
    $orderby = get_user_table_field("", "user_name");


[V@no]

yes, replace them all.

[ascanio]

ok V@no that worked like always and i have other question is there any way to have another colum  showing the number of pics that the have uploaded??

[V@no]

try replace

Code: [Select]

      echo "<td><b>".$show_user_name."</b></td>\n";with

Code: [Select]

      echo "<td><b>".$show_user_name."</b> (".$user_row['num'].")</td>\n"; it will show number of images next to their name.

[ascanio]

awesome!!!!!