[Mod] Show user's lightbox to admin.

[Jasondavis]

are u sure that u redid Step 1.? I dont think so, because if there was some problem, u'd get atleast this: Show user's Favorites ()
and this is the actual line, that supposed to print on display (X)

Code: [Select]

"lang_show_user_lightbox" => $lang['show_user_lightbox']." (".$num_rows_all.")",

this is just weird then!  It is in the code I did it and it is still the same even the

"lang_show_user_lightbox" => $lang['show_user_lightbox']." (".$num_rows_all.")",

is there

[V@no]

ok, would u pm me your code with like 10 extra lines (on top and bottom) from the original member.php ?

[Jasondavis]

I finally got it! I had it in the top section of the memeber.php file instead of the bottom section!  

1 more idea...would it be hard to have it display the number on the meberlist page as well for just admins?

[Bomba]

hello, this mod sounds really cool but isn't possible to make all users seing the other user lightbox? only admin can see the lightbox?

thanks

[V@no]

hello, this mod sounds really cool but isn't possible to make all users seing the other user lightbox? only admin can see the lightbox?

thanks

sure, I just thought that I wouldnt like if anyone could watch me while I'm taking shower...I think of lightbox as private zone...
but here what u need to do:
in step 1 change line:

Code: [Select]

     "url_show_user_lightbox" => ($user_info['user_level'] == ADMIN) ? $site_sess->url(ROOT_PATH."search.php?search_lightbox=".$user_row['user_id']) : "",
to this:

Code: [Select]

     "url_show_user_lightbox" => $site_sess->url(ROOT_PATH."search.php?search_lightbox=".$user_row['user_id']),

and in step 2.2. this code:

Code: [Select]

if ($user_info['user_level'] == ADMIN){;
  if ($search_lightbox != ""){
$sql = "SELECT *
  FROM ".LIGHTBOXES_TABLE."
  WHERE ".get_user_table_field("", "user_id")." = $search_lightbox";
 $search_lightbox_info = $site_db->query_firstrow($sql);
 $search_lightbox_ids = str_replace(" ", ",", trim($search_lightbox_info['lightbox_image_ids']));
  $search_id['image_ids'] = $search_lightbox_ids;
  }
}to this:

Code: [Select]

 if ($search_lightbox != ""){
$sql = "SELECT *
  FROM ".LIGHTBOXES_TABLE."
  WHERE ".get_user_table_field("", "user_id")." = $search_lightbox";
 $search_lightbox_info = $site_db->query_firstrow($sql);
 $search_lightbox_ids = str_replace(" ", ",", trim($search_lightbox_info['lightbox_image_ids']));
  $search_id['image_ids'] = $search_lightbox_ids;
  }

[Bomba]

thanks v@no

[Der_Nick]

Step 1.
Open member.php

Find: Code:
    $site_template->register_vars(array(
      "user_id" => $user_row['user_id'],
      "user_name" => (isset($user_row['user_name'])) ? htmlspecialchars($user_row['user_name']) : REPLACE_EMPTY,

Replace with: Code:
     $sql = "SELECT *
         FROM ".LIGHTBOXES_TABLE."
         WHERE ".get_user_table_field("", "user_id")." = ".$user_row['user_id'];
     $user_lightbox_info = $site_db->query_firstrow($sql);
     $num_rows_all = 0;
     if (!empty($user_lightbox_info['lightbox_image_ids'])) {
     $image_id_sql = str_replace(" ", ",", trim($user_lightbox_info['lightbox_image_ids']));
     $sql = "SELECT COUNT(image_id) AS images
          FROM ".IMAGES_TABLE."
          WHERE image_active = 1 AND image_id IN ($image_id_sql)";
     $result = $site_db->query_firstrow($sql);
     $num_rows_all = $result['images'];
    }
    $site_template->register_vars(array(
      "lang_show_user_lightbox" => $lang['show_user_lightbox']." (".$num_rows_all.")",
      "url_show_user_lightbox" => ($user_info['user_level'] == ADMIN) ? $site_sess->url(ROOT_PATH."search.php?search_lightbox=".$user_row['user_id']) : "",
      "user_id" => $user_row['user_id'],
      "user_name" => (isset($user_row['user_name'])) ? htmlspecialchars($user_row['user_name']) : REPLACE_EMPTY,

i have the avater mod!and so,the first code to find is another!how must i change the first step?

[V@no]

just insert this:

Code: [Select]

$sql = "SELECT *
FROM ".LIGHTBOXES_TABLE."
WHERE ".get_user_table_field("", "user_id")." = ".$user_row['user_id'];
$user_lightbox_info = $site_db->query_firstrow($sql);
$num_rows_all = 0;
if (!empty($user_lightbox_info['lightbox_image_ids'])) {
$image_id_sql = str_replace(" ", ",", trim($user_lightbox_info['lightbox_image_ids']));
$sql = "SELECT COUNT(image_id) AS images
FROM ".IMAGES_TABLE."
WHERE image_active = 1 AND image_id IN ($image_id_sql)";
$result = $site_db->query_firstrow($sql);
$num_rows_all = $result['images'];
}
before

Code: [Select]

$site_template->register_vars(array(
and this:

Code: [Select]

"lang_show_user_lightbox" => $lang['show_user_lightbox']." (".$num_rows_all.")",
"url_show_user_lightbox" => ($user_info['user_level'] == ADMIN) ? $site_sess->url(ROOT_PATH."search.php?search_lightbox=".$user_row['user_id']) : "",after:

Code: [Select]

$site_template->register_vars(array(

[Caelestis]

well i asked for help or an idea how to do this several months ago and was told no and that it couldn't be done... now since it has been done do you know a way to show the number of times an image has been added to a lightbox...

[V@no]

well i asked for help or an idea how to do this several months ago and was told no and that it couldn't be done... now since it has been done do you know a way to show the number of times an image has been added to a lightbox...

not really. unless u want create new field in "4images_images" table, that will store how many times the image was added to lightbox.

[Caelestis]

well i asked for help or an idea how to do this several months ago and was told no and that it couldn't be done... now since it has been done do you know a way to show the number of times an image has been added to a lightbox...

not really. unless u want create new field in "4images_images" table, that will store how many times the image was added to lightbox.

so by not really you mean yeah it's easy... ok

[V@no]

so by not really you mean yeah it's easy... ok

well, it's not too hard, I have an idea how to do so, but...dont have enough time...

[Caelestis]

so by not really you mean yeah it's easy... ok

well, it's not too hard, I have an idea how to do so, but...dont have enough time...

hum... i've got it working with the phpBB intergration if anyone want's to know how just let me know...

EX: http://www.0-gravity.com/forums/profile.php?mode=viewprofile&u=2

[pilotdoc]

Hi, Thanks for this mod, but it does not work on my site with php4.3.1 and apache2.  I do not know php, but I did a quick search for $HTTP_GET_VARS and $HTTP_POST_VARS on google and it seems they have been replaced by other commands $_GET and $_POST.  (?)

I tried to change over all of these in my search.php file, but still will not work.  "Show user's lightbox (3)" works, but when clicked through, it leads to a new blank search page.  

Any ideas?

[Chris]

Best to refer to www.php.net for all php documentation.  That's the official php site.