Advanced search  

News:

cpg1.5.46 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter recently discovered vulnerabilities. It is important that all users who run version cpg1.5.44 or older update to this latest version as soon as possible.
[more]

Pages: 1 2 3 4 5 [6] 7 8 9 10 ... 17   Go Down

Author Topic: "Who is online" plugin (onlinestats)  (Read 327982 times)

0 Members and 1 Guest are viewing this topic.

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1608
  • Paul Van Rompay
Re: "Who is online" plugin *experimental*
« Reply #100 on: June 26, 2006, 01:39:38 am »

Ok.  There's a block in codebase.php that looks like this:
Code: [Select]
        $result = cpg_db_query("SELECT user_id, user_name FROM {$CONFIG['TABLE_ONLINE']} WHERE user_id <> 0");

        $logged_in_array = array();

        while ($row = mysql_fetch_assoc($result)) {
                $logged_in_array[] = "<a href=\"profile.php?uid={$row['user_id']}\">{$row['user_name']}</a>";
        }

        $logged_in_names = implode(', ', array_unique($logged_in_array));

Replace this block with this one (which has the same first and last lines):
Code: [Select]
$result = cpg_db_query("SELECT user_id, user_name FROM {$CONFIG['TABLE_ONLINE']} WHERE user_id <> 0");

// MOD - get groups & color names
$logged_in_array = array();
$online_rowset = cpg_db_fetch_rowset($result);
mysql_free_result($result);

$online_idset = '';
foreach ($online_rowset as $row) {
$online_idset .= ($online_idset ? ',' : '') . $row['user_id'];
}
if ($online_idset) {
$result = cpg_db_query("SELECT user_id,user_name,user_group,user_group_list FROM {$CONFIG['TABLE_USERS']} WHERE user_id IN ($online_idset)");
$user_rowset = cpg_db_fetch_rowset($result);
mysql_free_result($result);


foreach ($user_rowset as $row) {
$online_name = $row['user_name'];
$online_groupset = ($row['user_group_list'] ? explode(',',$row['user_group_list']) : array());
$online_groupset[] = $row['user_group'];
if (in_array('1',$online_groupset)) {
$online_name = '<span style="color:red;font-weight:bold;">'.$online_name.'</span>';
} else {
$online_name = '<span style="color:green;">'.$online_name.'</span>';
}
$logged_in_array[] = USER_ID ? "<a href=\"profile.php?uid={$row['user_id']}\">{$online_name}</a>" : $online_name;
}
}
// MOD - end

$logged_in_names = implode(', ', array_unique($logged_in_array));

This example puts the admin name in red and bold, all others in green.  It should be obvious where to modify the code to add more groups.  I'd recommend an elseif(in_array('NUM',$online_groupset)) for each NUM group.  There might be a more efficient way to do this, but this'll work.

edit: Corrected code above to deal properly with no Registered users online.
« Last Edit: June 26, 2006, 01:36:19 pm by Paver »
Logged

Justttt

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 170
    • Trippy-ILLusion.Co.Uk
Re: "Who is online" plugin *experimental*
« Reply #101 on: June 26, 2006, 12:17:25 pm »

this is exactly what i have been looking for ages. works just right when loged in but when loged out
"There was an error while processing a database query "

Code: [Select]
While executing query "SELECT user_id,user_name,user_group,user_group_list FROM `yidols_copper`.cpg146_users WHERE user_id IN ()" on 0

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

plus a thousand more

Code: [Select]
Notices
/plugins/file2albummover/codebase.php
Warning line 52: copy(albums/3folder/Administrator_Uploads/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/3folder/Administrator_Uploads/): No such file or directory
Warning line 56: copy(albums/3normal_folder/Administrator_Uploads/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/3normal_folder/Administrator_Uploads/): No such file or directory
Warning line 61: copy(albums/3thumb_folder/Administrator_Uploads/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/3thumb_folder/Administrator_Uploads/): No such file or directory
Warning line 52: copy(albums/3folder/Administrator_Uploads/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/3folder/Administrator_Uploads/): No such file or directory
Warning line 56: copy(albums/3normal_folder/Administrator_Uploads/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/3normal_folder/Administrator_Uploads/): No such file or directory
Warning line 61: copy(albums/3thumb_folder/Administrator_Uploads/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/3thumb_folder/Administrator_Uploads/): No such file or directory
Warning line 52: copy(albums/3folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/3folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/3normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/3normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/3thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/3thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/3userpics/10001/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/3userpics/10001/): No such file or directory
Warning line 56: copy(albums/3normal_userpics/10001/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/3normal_userpics/10001/): No such file or directory
Warning line 61: copy(albums/3thumb_userpics/10001/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/3thumb_userpics/10001/): No such file or directory
Warning line 52: copy(albums/5folder/buddy_Gall/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/5folder/buddy_Gall/): No such file or directory
Warning line 56: copy(albums/5normal_folder/buddy_Gall/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/5normal_folder/buddy_Gall/): No such file or directory
Warning line 61: copy(albums/5thumb_folder/buddy_Gall/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/5thumb_folder/buddy_Gall/): No such file or directory
Warning line 52: copy(albums/7userpics/10001/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/7userpics/10001/): No such file or directory
Warning line 56: copy(albums/7normal_userpics/10001/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/7normal_userpics/10001/): No such file or directory
Warning line 61: copy(albums/7thumb_userpics/10001/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/7thumb_userpics/10001/): No such file or directory
Warning line 52: copy(albums/2folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/2folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/2normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/2normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/2thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/2thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/2folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/2folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/2normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/2normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/2thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/2thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/2folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/2folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/2normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/2normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/2thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/2thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/2wpw-20060625/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/2wpw-20060625/): No such file or directory
Warning line 56: copy(albums/2normal_wpw-20060625/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/2normal_wpw-20060625/): No such file or directory
Warning line 61: copy(albums/2thumb_wpw-20060625/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/2thumb_wpw-20060625/): No such file or directory
Warning line 52: copy(albums/2wpw-20060625/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/2wpw-20060625/): No such file or directory
Warning line 56: copy(albums/2normal_wpw-20060625/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/2normal_wpw-20060625/): No such file or directory
Warning line 61: copy(albums/2thumb_wpw-20060625/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/2thumb_wpw-20060625/): No such file or directory
Warning line 52: copy(albums/2wpw-20060625/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/2wpw-20060625/): No such file or directory
Warning line 56: copy(albums/2normal_wpw-20060625/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/2normal_wpw-20060625/): No such file or directory
Warning line 61: copy(albums/2thumb_wpw-20060625/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/2thumb_wpw-20060625/): No such file or directory
Warning line 52: copy(albums/4folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/4folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/4normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/4normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/4thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/4thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/4folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/4folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/4normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/4normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/4thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/4thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/4folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/4folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/4normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/4normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/4thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/4thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/4folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/4folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/4normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/4normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/4thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/4thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/4folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/4folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/4normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/4normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/4thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/4thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/4folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/4folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/4normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/4normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/4thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/4thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/4folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/4folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/4normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/4normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/4thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/4thumb_folder/Public_Gallery/): No such file or directory
Warning line 52: copy(albums/4folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 53: unlink(albums/4folder/Public_Gallery/): No such file or directory
Warning line 56: copy(albums/4normal_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 57: unlink(albums/4normal_folder/Public_Gallery/): No such file or directory
Warning line 61: copy(albums/4thumb_folder/Public_Gallery/): failed to open stream: No such file or directory
Warning line 62: unlink(albums/4thumb_folder/Public_Gallery/): No such file or directory
/bridge/udb_base.inc.php
Notice line 114: Undefined variable: row
/themes/oranje/theme.php
Notice line 593: Use of undefined constant AUTHOR_ID - assumed 'AUTHOR_ID'
Notice line 793: Undefined variable: charset
Notice line 793: Undefined variable: charset
/include/themes.inc.php
Notice line 129: Undefined index: allowed_albums
/lang/english.php
Notice line 1181: Undefined index: user_field_num
/include/functions.inc.php
Notice line 88: Undefined variable: cpg_show_private_album
/include/plugin_api.inc.php
Notice line 651: Only variable references should be returned by reference
 


Logged
J U S T T T T

Justttt

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 170
    • Trippy-ILLusion.Co.Uk
Re: "Who is online" plugin *experimental*
« Reply #102 on: June 26, 2006, 12:26:33 pm »

Code: [Select]
USER:
------------------
Array
(
    [ID] => e03913c74c811780b39bde0143d2fd9a
    [am] => 1
    [lang] => english
    [liv] => Array
        (
        )

    [theme] => oranje
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
            [0] => 3
        )

    [group_quota] => 0
    [can_rate_pictures] => 0
    [can_send_ecards] => 0
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [upload_form_config] => 0
    [num_file_upload] => 0
    [num_URI_upload] => 0
    [custom_user_upload] => 0
    [disk_max] => 0
    [disk_min] => 0
    [ufc_max] => 0
    [ufc_min] => 0
    [has_admin_access] => 0
    [group_name] => Guests
    [can_see_all_albums] => 0
    [group_id] => 3
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg146_filetypes; (0s)
    [1] => select * from cpg146_plugins order by priority asc; (0s)
    [2] => SELECT * FROM cpg146_albums,cpg146_pictures
WHERE cpg146_albums.aid=cpg146_pictures.aid
ORDER BY cpg146_albums.title (0s)
    [3] => UPDATE cpg146_pictures SET filepath='folder/Administrators_Randoms/' WHERE pid=0 (0.001s)
    [4] => UPDATE cpg146_pictures SET filepath='folder/Administrators_Randoms/' WHERE pid=0 (0s)
    [5] => UPDATE cpg146_pictures SET filepath='folder/Administrators_Randoms/' WHERE pid=0 (0s)
    [6] => UPDATE cpg146_pictures SET filepath='folder/Administrators_Randoms/' WHERE pid=0 (0s)
    [7] => UPDATE cpg146_pictures SET filepath='folder/buddy_Gall/' WHERE pid=0 (0s)
    [8] => UPDATE cpg146_pictures SET filepath='folder/Help_&_Tutorials/' WHERE pid=0 (0s)
    [9] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=0 (0s)
    [10] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=0 (0s)
    [11] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=0 (0s)
    [12] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=0 (0s)
    [13] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=0 (0s)
    [14] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=0 (0.14s)
    [15] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=7 (0s)
    [16] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=7 (0s)
    [17] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=7 (0s)
    [18] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=7 (0s)
    [19] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=7 (0s)
    [20] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=7 (0s)
    [21] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=7 (0s)
    [22] => UPDATE cpg146_pictures SET filepath='folder/Public_Gallery/' WHERE pid=7 (0s)
    [23] => delete from `yidols_copper`.cpg146_sessions where time<1151313611 and remember=0; (0.001s)
    [24] => delete from `yidols_copper`.cpg146_sessions where time<1150107611; (0s)
    [25] => select user_id from `yidols_copper`.cpg146_sessions where session_id=md5("97b6378b1612a544f07eecc38cb99445d4c13f73747b408db8852354f02c25c6"); (0s)
    [26] => select user_id as id, user_password as password from `yidols_copper`.cpg146_users where user_id=0 (0s)
    [27] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg146_usergroups WHERE group_id in (3) (0s)
    [28] => SELECT group_name FROM  cpg146_usergroups WHERE group_id= 3 (0s)
    [29] => update `yidols_copper`.cpg146_sessions set time='1151317211' where session_id=md5('97b6378b1612a544f07eecc38cb99445d4c13f73747b408db8852354f02c25c6'); (0.07s)
    [30] => SELECT DISTINCT(aid) FROM cpg146_albums WHERE moderator_group='3' (0s)
    [31] => SELECT name, value FROM cpg146_config where name REGEXP '^plugin_displayfields_' (0s)
    [32] => SHOW TABLES LIKE 'cpg146_cms_config' (0.001s)
    [33] => SELECT * FROM cpg146_cms_config (0s)
    [34] => DELETE FROM cpg146_mod_online WHERE last_action < NOW() - INTERVAL 10 MINUTE (0.001s)
    [35] => SELECT user_ip FROM cpg146_mod_online WHERE user_ip LIKE '62.254%' (0s)
    [36] => UPDATE cpg146_mod_online SET last_action = NOW() WHERE user_ip = '62.254.64.13' LIMIT 1 (0.001s)
    [37] => DELETE FROM cpg146_banned WHERE expiry < '2006-06-26 10:20:11' (0.001s)
    [38] => SELECT * FROM cpg146_banned WHERE (ip_addr='62.254.64.13' OR ip_addr='82.20.102.71' OR user_id=0) AND brute_force=0 (0s)
    [39] => SELECT aid FROM cpg146_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0s)
    [40] => SELECT aid FROM cpg146_albums (0s)
    [41] => SELECT cid, name, description, thumb FROM cpg146_categories WHERE parent = ''  ORDER BY name (0.001s)
    [42] => SELECT aid FROM cpg146_albums WHERE category = 2 (0s)
    [43] => SELECT count(*) FROM cpg146_pictures as p, cpg146_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0s)
    [44] => SELECT count(*) FROM cpg146_albums as a WHERE category = '2' (0s)
    [45] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg146_albums as a LEFT JOIN cpg146_pictures as p ON a.thumb=p.pid WHERE category=2 ORDER BY a.pos LIMIT 0,4 (0s)
    [46] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg146_albums AS a  LEFT JOIN cpg146_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (3, 4, 6, 7)GROUP BY a.aid (0s)
    [47] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg146_pictures WHERE pid='21' (0s)
    [48] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg146_pictures WHERE pid='14' (0s)
    [49] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg146_pictures WHERE pid='20' (0s)
    [50] => SELECT aid FROM cpg146_albums as a WHERE category>=10000 (0s)
    [51] => SELECT count(*) FROM cpg146_pictures as p, cpg146_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
    [52] => SELECT aid FROM cpg146_albums as a WHERE category = '0' (0s)
    [53] => SELECT count(*) FROM cpg146_albums as a WHERE 1 (0s)
    [54] => SELECT count(*) FROM cpg146_categories WHERE 1 (0s)
    [55] => SELECT count(*) FROM cpg146_pictures (0s)
    [56] => SELECT sum(hits) FROM cpg146_pictures (0s)
    [57] => SELECT count(*) FROM cpg146_comments (0s)
    [58] => SELECT COUNT(*) FROM `yidols_copper`.cpg146_users (0s)
    [59] => SELECT COUNT(*) FROM cpg146_mod_online (0s)
    [60] => SELECT COUNT(*) FROM cpg146_mod_online WHERE user_id <> 0 (0s)
    [61] => SELECT user_id, user_name FROM `yidols_copper`.cpg146_users ORDER BY user_id DESC LIMIT 1 (0s)
    [62] => SELECT user_id, user_name FROM cpg146_mod_online WHERE user_id <> 0 (0s)
    [63] => SELECT user_id,user_name,user_group,user_group_list FROM `yidols_copper`.cpg146_users WHERE user_id IN () (0s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
Page generated in 0.667 seconds - 64 queries in 0.217 seconds - Album set : ; Meta set: AND aid IN (2,3,4,5,6,7) ;
Logged
J U S T T T T

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1608
  • Paul Van Rompay
Re: "Who is online" plugin *experimental*
« Reply #103 on: June 26, 2006, 01:37:25 pm »

Yeah, I forgot to check the case where no registered users are online.  I corrected the code above.  You basically put in a:
Code: [Select]
if ($online_idset) {bracketting the part that pulls the user data in.
Logged

Justttt

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 170
    • Trippy-ILLusion.Co.Uk
Re: "Who is online" plugin *experimental*
« Reply #104 on: June 26, 2006, 02:07:18 pm »

yeah works great now thanks for all your help  ;D  ;)
Logged
J U S T T T T

BuLLy__BoY

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
Re: "Who is online" plugin *experimental*
« Reply #105 on: July 05, 2006, 04:19:36 pm »

Well... you did more and more corrections... Why someone don't make all the corrections and put the Finished plugin in Internet?

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: "Who is online" plugin *experimental*
« Reply #106 on: July 05, 2006, 04:31:49 pm »

check the name , it says :"Who is online" plugin *experimental*
« Last Edit: July 06, 2006, 09:19:01 am by bmossavari »
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Pascal YAP

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 13833
  • Hello World :-)
    • CPG 1.5.x ExperiMental website
Re: "Who is online" plugin *experimental*
« Reply #107 on: July 06, 2006, 09:11:04 am »

Good Day, Today,
Quote
Well... you did more and more corrections... Why someone don't make all the corrections and put the Finished plugin in Internet?
Hey you are someone too, maybe you can produce something, is'nt it ?  ;)

PYAP
Logged

JohannM

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 223
Re: "Who is online" plugin *experimental*
« Reply #108 on: August 10, 2006, 03:29:29 am »

Hi there

I also installed this plugin in a Mod vesion of 1.4 (Stramm). - http://www.4teenboyz.com

I created a "Home" page (01-start.php).  How do I pull in the "onlinestats" to this page to show it as well ?
Logged

pszone

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
Re: "Who is online" plugin *experimental*
« Reply #109 on: August 13, 2006, 05:55:57 pm »

Is there any way to make translation with cyrrilic text, becouse when I trie to translate the text from codebase.php I gat some strange symbolse?
Logged

pszone

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
Re: "Who is online" plugin *experimental*
« Reply #110 on: August 13, 2006, 07:26:59 pm »

Nevermind I solved the Problem ;)
Logged

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1608
  • Paul Van Rompay
Re: "Who is online" plugin *experimental*
« Reply #111 on: August 14, 2006, 02:36:29 pm »

Well... you did more and more corrections... Why someone don't make all the corrections and put the Finished plugin in Internet?

Keep in mind that most of the "corrections" you mention are actually mods to the plugin and are hardcoded mods at that so cannot be configured (or disabled) with settings.  Since each person wants something different, it wouldn't make sense to combine all the mods together into a new release of the plugin, unless you add a configuration setting for each mod.  That takes time and probably wouldn't be that useful for most people.  The idea with people discussing mods here is so others can see how certain things are done and then can do what they want using the information learned here.  That's the point.
Logged

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1608
  • Paul Van Rompay
Re: "Who is online" plugin *experimental*
« Reply #112 on: August 31, 2006, 04:25:14 pm »

There is a bug in version 1.2 of the onlinestats plugin.  See this thread for details: http://forum.coppermine-gallery.net/index.php?topic=35563.0

I plan to look at the plugin carefully and put together a version 1.3 when I have time.  For now, apply the fix in the thread above if you see this problem. 
Logged

natrlhy

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 77
Re: "Who is online" plugin *experimental*
« Reply #113 on: September 28, 2006, 08:24:41 pm »

I LOVE this plugin and thank you for providing it! I couldn't live without it.

However, I have always noticed that when users that have AOL login to my coppermine gallery, it shows an invalid number of users logged in.  For instance, I am logged in and it shows:

In total there are 2 users online :: 1 Registered, and 1 Guest

Once users the users that have AOL login(they utilize proxy servers, etc) it shows something like this:

In total there are 15 users online :: 14 Registered, and 1 Guest

When there really are only 2 Registered users logged in.

I'm just wondering if there is something that can be done to reflect the correct number of users logged in with these types of services like AOL.
Logged

Senator

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 59
Re: "Who is online" plugin *experimental*
« Reply #114 on: October 01, 2006, 10:18:58 am »

I use this plugin, and it works great.

the table is showing only on the indexpage.

what can i change, so that this table is visable on each page, like displayimage.php etc.

Logged

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1608
  • Paul Van Rompay
Re: "Who is online" plugin *experimental*
« Reply #115 on: October 02, 2006, 06:45:57 am »

Senator has carried the support question above to a new thread:
http://forum.coppermine-gallery.net/index.php?topic=36873.0

Please use the new thread for all discussion of this question (and look there for any solutions).
Logged

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1608
  • Paul Van Rompay
Re: "Who is online" plugin *experimental*
« Reply #116 on: October 02, 2006, 11:13:35 pm »

@natrlhy: Take a look at your cpg_mod_online table (using a tool like phpMyAdmin) to see what users it lists and see how it compares to your onlinestats block and the AOL users you have.  I'm not sure what it will show, but it might give you an idea about how the users are being logged and counted.
Logged

natrlhy

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 77
Re: "Who is online" plugin *experimental*
« Reply #117 on: October 03, 2006, 12:18:14 am »

Thanks Paver,

I'll take a look at that table and see what I see there  ;)
Logged

natrlhy

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 77
Re: "Who is online" plugin *experimental*
« Reply #118 on: November 02, 2006, 07:41:24 am »

So I finally was online at the same time I see the AOL users logged in.

Here is the info from the plugin:

Registered Users logged in: natrlhy, sngim, aimhigher38, geeznutts

We have 45 registered users
In total there are 26 users online :: 24 Registered, and 2 Guests

Here is the data in the MySQL table:

Full Texts      user_id       user_name       user_ip       last_action
   Edit    Delete    70    geeznutts    207.200.116.131    2006-11-01 22:37:05
   Edit    Delete    70    geeznutts    207.200.116.197    2006-11-01 22:37:11
   Edit    Delete    70    geeznutts    207.200.116.132    2006-11-01 22:37:26
   Edit    Delete    70    geeznutts    207.200.116.130    2006-11-01 22:36:02
   Edit    Delete    70    geeznutts    207.200.116.196    2006-11-01 22:36:45
   Edit    Delete    70    geeznutts    207.200.116.139    2006-11-01 22:36:39
   Edit    Delete    17    aimhigher38    207.200.116.199    2006-11-01 22:35:15
   Edit    Delete    17    aimhigher38    207.200.116.12    2006-11-01 22:28:04
   Edit    Delete    17    aimhigher38    207.200.116.132    2006-11-01 22:34:22
   Edit    Delete    17    aimhigher38    207.200.116.131    2006-11-01 22:34:15
   Edit    Delete    11    sngim    71.138.81.14    2006-11-01 22:37:25
   Edit    Delete    17    aimhigher38    207.200.116.202    2006-11-01 22:35:22
   Edit    Delete    70    geeznutts    207.200.116.138    2006-11-01 22:35:35
   Edit    Delete    17    aimhigher38    207.200.116.133    2006-11-01 22:34:41
   Edit    Delete    17    aimhigher38    207.200.116.130    2006-11-01 22:34:50
   Edit    Delete    17    aimhigher38    207.200.116.197    2006-11-01 22:34:24
   Edit    Delete    0    Guest    71.135.185.95    2006-11-01 22:37:59
   Edit    Delete    17    aimhigher38    207.200.116.196    2006-11-01 22:35:51
   Edit    Delete    70    geeznutts    207.200.116.73    2006-11-01 22:35:46
   Edit    Delete    10    natrlhy    71.138.81.14    2006-11-01 22:37:26
   Edit    Delete    70    geeznutts    207.200.116.5    2006-11-01 22:35:40
   Edit    Delete    0    Guest    66.249.65.68    2006-11-01 22:37:15
   Edit    Delete    17    aimhigher38    207.200.116.139    2006-11-01 22:34:59
   Edit    Delete    17    aimhigher38    207.200.116.74    2006-11-01 22:35:31

AOL users always show up as way too many users.  How can I go about fixing this so that only 1 user shows up even when it appears to be coming from several IP's like proxy servers tend to?
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: "Who is online" plugin *experimental*
« Reply #119 on: November 02, 2006, 04:51:58 pm »

Hi Nibbler...
I uninstalled your plugin from the control panel, by clicking on the X of uninstall, I also choose to delete the table that was created originally.

Then I reinstalled it, but now I see everything double! I see a double who is online panel and a double gallery index!
Tried to uninstall the plugin again, and reinstall it but same issue happens!

What should I do to come back to normal ?

I had the same problem. Use Plugin Manager to set the Onlinestat plugin as the first one to be loaded into coppermine. That solved the problem on my CPG.

Cheers!
Hein
Logged
Pages: 1 2 3 4 5 [6] 7 8 9 10 ... 17   Go Up
 

Page created in 0.028 seconds with 21 queries.