block control block control
We Do It 4 Our Dreams
Login
Username:

Password:

Remember me



Lost Password?

Register now!

Hauptmenü
Bereiche
Home
PD News
PC News
BeOS News
Berichte
Community
Case Gallery
Power Pics
Forum
Downloads
Links
Informationen
Seitenübersicht
Hilfe / FAQ
Partnerseiten
Sponsoren
Kontakt

Websiteinfo's
Webmaster (O.M.A.)
Krobi
Krobi
Gonzo
Gonzo
V(i)P's
MASTER-STYX
MASTER-STYX
Mario
Mario


Herzlich Willkommen

_MB_INCBLOCKS_WELCOME

Als registrierter User steht dir das gesamte Forum mit all seinen extra Funktionen natürlich auch vollkommen kostenlos zur Verfügung.
 

Forum Index
  
      All Posts (rlankford)



Re: Version 1.2 Permissions Problems
#1
Power-Dreams Anfänger
Power-Dreams Anfänger


Thank you for the response. Is your recommendation, then, that I should downgrade back to version 1 again? The permissions in that version seemed to work correctly. I only upgraded to see what new features might be present. It does look as so some problems were addressed!

Sorry to hear that the developers are too busy to continue development. Is there another downloads module that everyone has moved on to at this point that I should look at instead?

Posted on: 2007/2/1 20:13
Report Top
Version 1.2 Permissions Problems
#2
Power-Dreams Anfänger
Power-Dreams Anfänger


I've recently upgraded from version 1 to version 1.2. I have a section of files that I restrict to a particular Xoops group of users (let's call it 'specialGroup'). This functionality no longer works with this module. I believe the problem to be new and it isn't a matter of syntax. Rather, it seems to be a logical problem with out the code is set up.

Please look at the following code in singlefile.php:

$result $xoopsDB->query("SELECT a.*, b.* FROM " $xoopsDB->prefix("PDdownloads{$mydirnumber}_downloads") . " a, ".$xoopsDB->prefix('group_permission')." b WHERE (a.lid = $lid AND b.gperm_itemid = $lid) AND a.offline = 0 AND (a.published > 0 AND a.published <= $time_cur) AND (a.expired = 0 OR a.expired > $time_cur) AND b.gperm_modid = $module_id AND b.gperm_name = "PDDownFilePerm{$mydirnumber}" AND b.gperm_groupid = $groups[0]");


The last constraint on the query makes mention of $groups[0]. $groups is an array that simply contains a list of all the groups that the currently logged on user is a part of. The query is now hard-coded to only search on the first group that the user is a part of. This doesn't work! All users are a part of 'registered users' in Xoops. This group is always higher in the array than the 'specialGroup' group. Because of this, it's impossible or anyone to see my download record because singlefile.php doesn't recognize as anyone from 'registered users' as having access to the document!

You can fix this particular page easily enough by removing the last constraint from the query shown above. This, however, doesn't fix the code in viewcat.php. The same problems apply, but they manifest themselves differently since the code there is much more complex.

I can't be the first person to have run across this! It there a fix available (or being worked on) for this problem in how permissions are checked? I haven't spent much time on this myself yet, but it looks to me as if the programmers of this module have neglected to fully appreciate the task of checking permissions for each of these records.

Please don't consider this post a flame. I very much appreciate this module and look forward to any responses. Thanks in advance for any help as it's much appreciated.

Note: I'll be cross posting this over on the Xoops.org forum too.

Posted on: 2007/1/31 20:16
Report Top

TopTop


PD-Members
User online: 1
Guests: 1
Members: 0

more...
Members: 423
Today: 0
Yesterday: 0

Latest: LELO_05

Werbung

Partner


0.087 seconds - 62 queries
None All Errors (73) Deprecated (0) Queries (62) Blocks (9) Extra (2) Timers(7)
Errors
Warning: mysqli::__construct(): Persistent connections are disabled. Downgrading to normal in file /class/database/mysqldatabase.php line 64
Notice: Constant _MD_MESSAGEC already defined in file /modules/newbb/language/english/main.php line 254
Warning: preg_match(): Unknown modifier '/' in file /home/www/old.pd/pd_lib/modules/protector/class/protector.php line 1194
Unknown: Function get_magic_quotes_gpc() is deprecated in file /class/libraries/vendor/xoops/xmf/src/Request.php line 119
Warning: Use of undefined constant _MI_POLLS_NAME - assumed '_MI_POLLS_NAME' (this will throw an Error in a future version of PHP) in file /modules/xoopspoll/xoops_version.php line 28
Warning: Use of undefined constant _MI_POLLS_DESC - assumed '_MI_POLLS_DESC' (this will throw an Error in a future version of PHP) in file /modules/xoopspoll/xoops_version.php line 30
Warning: Use of undefined constant _MI_POLLS_BNAME1 - assumed '_MI_POLLS_BNAME1' (this will throw an Error in a future version of PHP) in file /modules/xoopspoll/xoops_version.php line 72
Warning: Use of undefined constant _MI_PARTNERS_NAME - assumed '_MI_PARTNERS_NAME' (this will throw an Error in a future version of PHP) in file /modules/xoopspartners/xoops_version.php line 31
Warning: Use of undefined constant _MI_PARTNERS_DESC - assumed '_MI_PARTNERS_DESC' (this will throw an Error in a future version of PHP) in file /modules/xoopspartners/xoops_version.php line 34
Warning: Use of undefined constant _MI_PARTNERS_NAME - assumed '_MI_PARTNERS_NAME' (this will throw an Error in a future version of PHP) in file /modules/xoopspartners/xoops_version.php line 54
Warning: Use of undefined constant _MI_PARTNERS_DESC - assumed '_MI_PARTNERS_DESC' (this will throw an Error in a future version of PHP) in file /modules/xoopspartners/xoops_version.php line 55
Warning: Use of undefined constant _MI2_sponsors_NAME - assumed '_MI2_sponsors_NAME' (this will throw an Error in a future version of PHP) in file /modules/sponsors/xoops_version.php line 31
Warning: Use of undefined constant _MI2_sponsors_DESC - assumed '_MI2_sponsors_DESC' (this will throw an Error in a future version of PHP) in file /modules/sponsors/xoops_version.php line 34
Warning: Use of undefined constant _MI_CONTACT_NAME - assumed '_MI_CONTACT_NAME' (this will throw an Error in a future version of PHP) in file /modules/contact/xoops_version.php line 28
Warning: Use of undefined constant _MI_CONTACT_DESC - assumed '_MI_CONTACT_DESC' (this will throw an Error in a future version of PHP) in file /modules/contact/xoops_version.php line 30
Warning: Use of undefined constant _ALBM_MYALBUM_NAME - assumed '_ALBM_MYALBUM_NAME' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 34
Warning: Use of undefined constant _ALBM_BNAME_RANDOM - assumed '_ALBM_BNAME_RANDOM' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 63
Warning: Use of undefined constant _ALBM_BNAME_RECENT - assumed '_ALBM_BNAME_RECENT' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 72
Warning: Use of undefined constant _ALBM_BNAME_HITS - assumed '_ALBM_BNAME_HITS' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 81
Warning: Use of undefined constant _ALBM_BNAME_RECENT_P - assumed '_ALBM_BNAME_RECENT_P' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 90
Warning: Use of undefined constant _ALBM_BNAME_HITS_P - assumed '_ALBM_BNAME_HITS_P' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 99
Warning: Use of undefined constant _ALBM_TEXT_SMNAME1 - assumed '_ALBM_TEXT_SMNAME1' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 114
Warning: Use of undefined constant _ALBM_TEXT_SMNAME2 - assumed '_ALBM_TEXT_SMNAME2' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 122
Warning: Use of undefined constant _ALBM_TEXT_SMNAME3 - assumed '_ALBM_TEXT_SMNAME3' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 125
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NOTIFY - assumed '_MI_MYALBUM_GLOBAL_NOTIFY' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 452
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NOTIFYDSC - assumed '_MI_MYALBUM_GLOBAL_NOTIFYDSC' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 453
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NOTIFY - assumed '_MI_MYALBUM_CATEGORY_NOTIFY' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 456
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NOTIFYDSC - assumed '_MI_MYALBUM_CATEGORY_NOTIFYDSC' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 457
Warning: Use of undefined constant _MI_MYALBUM_PHOTO_NOTIFY - assumed '_MI_MYALBUM_PHOTO_NOTIFY' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 463
Warning: Use of undefined constant _MI_MYALBUM_PHOTO_NOTIFYDSC - assumed '_MI_MYALBUM_PHOTO_NOTIFYDSC' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 464
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFY - assumed '_MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFY' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 471
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYCAP - assumed '_MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYCAP' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 472
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYDSC - assumed '_MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYDSC' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 473
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYSBJ - assumed '_MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYSBJ' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 475
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFY - assumed '_MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFY' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 479
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYCAP - assumed '_MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYCAP' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 480
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYDSC - assumed '_MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYDSC' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 481
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYSBJ - assumed '_MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYSBJ' (this will throw an Error in a future version of PHP) in file /modules/myalbum/xoops_version.php line 483
Warning: Use of undefined constant _ALBM_MYALBUM_NAME - assumed '_ALBM_MYALBUM_NAME' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 34
Warning: Use of undefined constant _ALBM_BNAME_RANDOM - assumed '_ALBM_BNAME_RANDOM' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 63
Warning: Use of undefined constant _ALBM_BNAME_RECENT - assumed '_ALBM_BNAME_RECENT' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 72
Warning: Use of undefined constant _ALBM_BNAME_HITS - assumed '_ALBM_BNAME_HITS' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 81
Warning: Use of undefined constant _ALBM_BNAME_RECENT_P - assumed '_ALBM_BNAME_RECENT_P' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 90
Warning: Use of undefined constant _ALBM_BNAME_HITS_P - assumed '_ALBM_BNAME_HITS_P' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 99
Warning: Use of undefined constant _ALBM_TEXT_SMNAME1 - assumed '_ALBM_TEXT_SMNAME1' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 114
Warning: Use of undefined constant _ALBM_TEXT_SMNAME2 - assumed '_ALBM_TEXT_SMNAME2' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 122
Warning: Use of undefined constant _ALBM_TEXT_SMNAME3 - assumed '_ALBM_TEXT_SMNAME3' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 125
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NOTIFY - assumed '_MI_MYALBUM_GLOBAL_NOTIFY' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 452
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NOTIFYDSC - assumed '_MI_MYALBUM_GLOBAL_NOTIFYDSC' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 453
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NOTIFY - assumed '_MI_MYALBUM_CATEGORY_NOTIFY' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 456
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NOTIFYDSC - assumed '_MI_MYALBUM_CATEGORY_NOTIFYDSC' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 457
Warning: Use of undefined constant _MI_MYALBUM_PHOTO_NOTIFY - assumed '_MI_MYALBUM_PHOTO_NOTIFY' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 463
Warning: Use of undefined constant _MI_MYALBUM_PHOTO_NOTIFYDSC - assumed '_MI_MYALBUM_PHOTO_NOTIFYDSC' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 464
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFY - assumed '_MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFY' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 471
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYCAP - assumed '_MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYCAP' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 472
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYDSC - assumed '_MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYDSC' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 473
Warning: Use of undefined constant _MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYSBJ - assumed '_MI_MYALBUM_GLOBAL_NEWPHOTO_NOTIFYSBJ' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 475
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFY - assumed '_MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFY' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 479
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYCAP - assumed '_MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYCAP' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 480
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYDSC - assumed '_MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYDSC' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 481
Warning: Use of undefined constant _MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYSBJ - assumed '_MI_MYALBUM_CATEGORY_NEWPHOTO_NOTIFYSBJ' (this will throw an Error in a future version of PHP) in file /modules/myalbum1/xoops_version.php line 483
Warning: Use of undefined constant _MI_TUTORIALS_NAME - assumed '_MI_TUTORIALS_NAME' (this will throw an Error in a future version of PHP) in file /modules/tutorials/xoops_version.php line 2
Warning: Use of undefined constant _MI_TUTORIALS_DESC - assumed '_MI_TUTORIALS_DESC' (this will throw an Error in a future version of PHP) in file /modules/tutorials/xoops_version.php line 4
Warning: Use of undefined constant _MI_TUTORIALS_SMNAME1 - assumed '_MI_TUTORIALS_SMNAME1' (this will throw an Error in a future version of PHP) in file /modules/tutorials/xoops_version.php line 54
Unknown: define(): Declaration of case-insensitive constants is deprecated in file /modules/newbb/language/english/modinfo.php line 121
Unknown: define(): Declaration of case-insensitive constants is deprecated in file /modules/newbb/language/english/modinfo.php line 221
Warning: Use of undefined constant _MB_INCBLOCKS_WELCOME - assumed '_MB_INCBLOCKS_WELCOME' (this will throw an Error in a future version of PHP) in file /modules/incblocks/blocks/menuwelcome.php line 15
Notice: Trying to access array offset on value of type null in file /modules/PDMembers/blocks/PDMembers_block.php line 32
Notice: Undefined index: user_regdate in file /modules/PDMembers/blocks/PDMembers_block.php line 94
Warning: count(): Parameter must be an array or an object that implements Countable in file /modules/PDMembers/blocks/PDMembers_block.php line 94
Warning: Database updates are not allowed during processing of a GET request in file /class/database/mysqldatabase.php line 519
Warning: include_once(/modules/xoopspoll/language/english/main.php): failed to open stream: No such file or directory in file /modules/xoopspoll/blocks/xoopspoll.php line 33
Warning: include_once(): Failed opening '/modules/xoopspoll/language/english/main.php' for inclusion (include_path='.:/usr/share/php') in file /modules/xoopspoll/blocks/xoopspoll.php line 33
Deprecated
Queries
0.000096 - SET SQL_BIG_SELECTS = 1
0.001295 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC
0.000370 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '671e84fa4bb3a64c20aa4751b041a58d'
0.000357 - SELECT * FROM modules WHERE dirname = 'newbb'
0.001185 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '44')
0.001665 - SELECT * FROM config WHERE (`conf_modid` = '44') ORDER BY conf_order ASC
0.000457 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
0.000336 - SELECT COUNT(*) FROM protector_access WHERE ip='18.116.85.72' AND request_uri='/modules/newbb/viewpost.php?uid=448'
0.000269 - SELECT COUNT(*) FROM protector_access WHERE ip='18.116.85.72'
0.000327 - INSERT INTO protector_access SET ip='18.116.85.72', request_uri='/modules/newbb/viewpost.php?uid=448', expire=UNIX_TIMESTAMP()+'10'
0.000520 - SELECT * FROM modules WHERE dirname = 'xoopspoll'
0.004410 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_view')
0.001278 - SELECT * FROM `bb_forums` WHERE (`forum_id` IN (70, 16, 15, 78, 17, 77, 13, 12, 11, 67, 66, 65, 10, 23, 22, 68, 6, 5, 64, 8, 7, 63, 35, 19, 18, 69, 4, 38, 24, 76, 74, 73, 62, 41, 30, 40, 29, 28, 27, 32, 31, 72, 71)) ORDER BY forum_order ASC
0.001292 - SELECT COUNT(*) FROM `bb_posts` WHERE (`forum_id` IN (40,4,77,17,18,69,22,24,27,31,70,62,63,64,65,66,67,68,71,72,73,74,76,78,19,23,28,7,15,32,35,41,5,16,29,30,38,8,6,10,11,12,13) AND `uid` = '448' AND `approved` = '1')
0.001380 - SELECT p.*, t.* FROM bb_posts AS p LEFT JOIN bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (40,4,77,17,18,69,22,24,27,31,70,62,63,64,65,66,67,68,71,72,73,74,76,78,19,23,28,7,15,32,35,41,5,16,29,30,38,8,6,10,11,12,13) AND p.uid = '448' AND p.approved = '1') ORDER BY p.post_id DESC LIMIT 0, 10
0.000434 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC
0.000489 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC
0.005278 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3)
0.001233 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,44) AND b.bid IN (9,82,6,1,12,11,10,8,7,5,4,86,3,219,2,44,175,177,178,45,80,79,78,85,84,83,81,97,98,92,93,90,91,64,65,66,67,169,170,168,136,143,151,180,181,182,183,227,179,210,204,205,206,207,208,209,197,198,199,200,201,202,203,196,190,191,192,193,194,195,211,176,223,226,230,231,232,233) ORDER BY b.weight, m.block_id
0.000517 - SELECT * FROM modules WHERE (`hasmain` = '1' AND `isactive` = '1' AND `weight` > '0') ORDER BY weight ASC, mid ASC
0.002032 - SELECT * FROM group_permission WHERE (`gperm_name` = 'module_read' AND `gperm_modid` = '1' AND `gperm_groupid` = '3')
0.001003 - SELECT gperm_itemid FROM group_permission LEFT JOIN modules m ON gperm_modid=m.mid WHERE m.dirname='myalbum' AND gperm_name='myalbum_global' AND (gperm_groupid=3)
0.000823 - SELECT gperm_itemid FROM group_permission LEFT JOIN modules m ON gperm_modid=m.mid WHERE m.dirname='myalbum1' AND gperm_name='myalbum_global' AND (gperm_groupid=3)
0.000303 - SELECT * FROM modules WHERE dirname = 'PDdownloads'
0.000272 - SELECT * FROM modules WHERE dirname = 'PDlinks'
0.000544 - SELECT count(*) FROM modules WHERE dirname = 'pcnews' AND isactive=1
0.000300 - SELECT * FROM modules WHERE dirname = 'pcnews'
0.000968 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '46' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pcnews_submit')
0.000322 - SELECT count(*) FROM modules WHERE dirname = 'pdnews' AND isactive=1
0.000269 - SELECT * FROM modules WHERE dirname = 'pdnews'
0.000797 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '47' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pdnews_submit')
0.000315 - SELECT count(*) FROM modules WHERE dirname = 'beosnews' AND isactive=1
0.000265 - SELECT * FROM modules WHERE dirname = 'beosnews'
0.000822 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '48' AND (`gperm_groupid` = '3') AND `gperm_name` = 'beosnews_submit')
0.000299 - SELECT count(*) FROM modules WHERE dirname = 'PDMembers' AND isactive=1
0.001190 - SELECT text, submitter FROM incblock_welcometext ORDER BY RAND() LIMIT 0,1
0.000276 - SELECT * FROM smiles
0.000328 - DELETE FROM online WHERE online_updated < 1714280697
0.000285 - SELECT COUNT(*) FROM online WHERE online_uid=0 AND online_ip=''
0.000357 - UPDATE online SET online_updated = 1714280997, online_module = 44 WHERE online_uid = 0 AND online_ip=''
0.000186 - SELECT online_uid, online_uname FROM online
0.000812 - SELECT uid, uname, user_regdate FROM users WHERE user_regdate >= 1714168800 and level > 0
0.000254 - SELECT uid, uname from users where level > 0 order by uid DESC limit 1
0.000428 - SELECT COUNT(*) FROM users WHERE level > 0
0.000122 - SELECT COUNT(*) FROM session
0.000667 - SELECT u.uid, u.uname, u.email, u.user_viewemail, u.user_avatar, g.name AS groupname FROM groups_users_link l LEFT JOIN users u ON l.uid=u.uid LEFT JOIN groups g ON l.groupid=g.groupid WHERE g.group_type='Admin' ORDER BY l.groupid, u.uid
0.000364 - SELECT * FROM xoopspoll_desc WHERE display=1 ORDER BY weight ASC, end_time DESC
0.000277 - SELECT id FROM partners Where status = 1 ORDER BY hits DESC
0.000201 - SELECT id, url, image, title FROM partners WHERE id=9
0.000175 - SELECT id, url, image, title FROM partners WHERE id=3
0.000164 - SELECT id, url, image, title FROM partners WHERE id=5
0.000161 - SELECT id, url, image, title FROM partners WHERE id=6
0.000160 - SELECT id, url, image, title FROM partners WHERE id=4
0.000283 - SELECT * FROM `users` WHERE `uid` IN (448)
0.000305 - SELECT rank_title AS title, rank_image AS image FROM ranks WHERE rank_min <= 2 AND rank_max >= 2 AND rank_special = 0
0.000247 - SELECT groupid FROM groups_users_link WHERE uid=448
0.000188 - SELECT * FROM groups WHERE groupid=2
0.000191 - SELECT user_digests, uid FROM bb_user_stats WHERE uid IN( 448)
0.000261 - SELECT forum_id, COUNT(*) AS count FROM bb_moderates WHERE (uid=0 OR ip IN('18','18.116','18.116.85','18.116.85.72')) AND (mod_end > 1714280997) GROUP BY forum_id
0.001281 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'category_access')
0.000531 - SELECT `cat_id`, `cat_order`, `cat_title` FROM `bb_categories` WHERE `cat_id` IN (8, 9, 5, 4, 10, 17, 2) ORDER BY cat_order ASC
0.000345 - SELECT * FROM users WHERE uid = '448'
Total: 62
Blocks
Login: Not cached
Main Menu: Not cached
Herzlich Willkommen: Not cached
Usermenü: Not cached
PD-Members: Not cached
Site Info: Not cached
Umfragenblock: Not cached
Google Adsense (klein): Not cached
Partner: Not cached
Total: 9
Extra
Included files: 236 files
Memory usage: 1832232 bytes
Timers
XOOPS took 0.087 seconds to load.
XOOPS Boot took 0.011 seconds to load.
Module init took 0.023 seconds to load.
newBB_Header took 0.004 seconds to load.
XOOPS output init took 0.038 seconds to load.
Module display took 0.013 seconds to load.
Page rendering took 0.002 seconds to load.