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

Du kannst auch etwas für andere Benutzer hier tun zB kannst du selbst Faq Einträge verfassen.
 

Forum Index
  
     PD-Downloads
   Version 1.2 Permissions Problems



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


See User information
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


Re: Version 1.2 Permissions Problems
#2
Webmaster (O.M.A.)
Webmaster (O.M.A.)


See User information
hello

thank you for you feedback.

and yes you are right with some points - first of all, gonzo and i did this module so you are on the right and best place for feedback about pd-downloads.

you are absolutly right that $groups is an array, but we cant simply write "b.gperm_groupid = $groups", because it will end with that "b.gperm_groupid = Array".

because we need to extract the array and make a right sql query out of it.

the possible solution for that would be: get the size of the array, then we could make a string in a loop - so we could add every bit of the array to a string.

so the result could be like this "b.gperm_groupid = 0 and b.gperm_groupid = 1" (and so on), but we have to test it if it works like i think.

by the side, you are right about the problem - this is not new at all - the simplest and fastest solution is to put every user in only one group, its not a nice fix but it works

i have to say that i dont have much free time at the moment to do developing on our modules and when i have free time i often have to do other thinks (that the true and the real life )

but i try to give me best to support every request, often i cant give a fix for problems because of my work but i always try to answer request and support them as good as possible.

Posted on: 2007/1/31 22:54
The Solution Provider
_________________________________
Resized Image
_________________________________
------ krobi@power-dreams.com
Report Top


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


See User information
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



  New Topic


You can view topic.
You can start a new topic.
You cannot reply to posts.
You cannot edit your posts.
You cannot delete your posts.
You cannot add new polls.
You cannot vote in polls.
You cannot attach files to posts.
You cannot post without approval.
You cannot use topic type.
You cannot use HTML syntax.
You cannot use signature.
You cannot create PDF files.
You cannot get print page.

[Advanced Search]


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

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

Latest: LELO_05

Werbung

Partner


1.994 seconds - 86 queries
None All Errors (77) Deprecated (0) Queries (86) Blocks (9) Extra (2) Timers(8)
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
Unknown: Function get_magic_quotes_gpc() is deprecated in file /class/libraries/vendor/xoops/xmf/src/Request.php line 119
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
Notice: Undefined index: in file /modules/newbb/class/forum.php line 1038
Warning: count(): Parameter must be an array or an object that implements Countable in file /home/www/old.pd/pd_data/caches/smarty_compile/68760a1d-newbb-powerdreams1-default^%%5A^5AE^5AECABCD%%db%3Anewbb_viewtopic.tpl.php line 76
Deprecated
Queries
0.000092 - SET SQL_BIG_SELECTS = 1
0.001271 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC
0.000255 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'bc13577616da446c8dc1f1d4d10592e8'
0.000316 - SELECT * FROM modules WHERE dirname = 'newbb'
0.001105 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '44')
0.001653 - SELECT * FROM config WHERE (`conf_modid` = '44') ORDER BY conf_order ASC
0.000210 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
0.000323 - SELECT COUNT(*) FROM protector_access WHERE ip='54.163.62.42' AND request_uri='/modules/newbb/viewtopic.php?topic_id=685'
0.000281 - SELECT COUNT(*) FROM protector_access WHERE ip='54.163.62.42'
0.885335 - INSERT INTO protector_access SET ip='54.163.62.42', request_uri='/modules/newbb/viewtopic.php?topic_id=685', expire=UNIX_TIMESTAMP()+'10'
0.000582 - SELECT * FROM modules WHERE dirname = 'xoopspoll'
0.000424 - SELECT * FROM bb_topics WHERE topic_id = '685'
0.000326 - SELECT * FROM bb_forums WHERE forum_id = '73'
0.001611 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'category_access')
0.003923 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_access')
0.005390 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_view')
0.000563 - SELECT COUNT(*) FROM `bb_posts` WHERE (`topic_id` = '685' AND `approved` = '1')
0.000582 - SELECT p.*, t.* FROM bb_posts p, bb_posts_text t WHERE p.topic_id=685 AND p.post_id = t.post_id AND p.approved = 1 ORDER BY p.post_id DESC LIMIT 0, 10
0.000304 - UPDATE bb_topics SET topic_views = LAST_INSERT_ID(topic_views + 1) WHERE topic_id =685
0.000381 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC
0.000373 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC
0.003150 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3)
0.000548 - 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.000267 - SELECT * FROM modules WHERE (`hasmain` = '1' AND `isactive` = '1' AND `weight` > '0') ORDER BY weight ASC, mid ASC
0.000955 - SELECT * FROM group_permission WHERE (`gperm_name` = 'module_read' AND `gperm_modid` = '1' AND `gperm_groupid` = '3')
0.000420 - 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.000359 - 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.000197 - SELECT * FROM modules WHERE dirname = 'PDdownloads'
0.000298 - SELECT * FROM modules WHERE dirname = 'PDlinks'
0.000289 - SELECT count(*) FROM modules WHERE dirname = 'pcnews' AND isactive=1
0.000213 - SELECT * FROM modules WHERE dirname = 'pcnews'
0.000684 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '46' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pcnews_submit')
0.000171 - SELECT count(*) FROM modules WHERE dirname = 'pdnews' AND isactive=1
0.000139 - SELECT * FROM modules WHERE dirname = 'pdnews'
0.000336 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '47' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pdnews_submit')
0.000153 - SELECT count(*) FROM modules WHERE dirname = 'beosnews' AND isactive=1
0.000131 - SELECT * FROM modules WHERE dirname = 'beosnews'
0.000344 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '48' AND (`gperm_groupid` = '3') AND `gperm_name` = 'beosnews_submit')
0.000151 - SELECT count(*) FROM modules WHERE dirname = 'PDMembers' AND isactive=1
0.000551 - SELECT text, submitter FROM incblock_welcometext ORDER BY RAND() LIMIT 0,1
0.000157 - SELECT * FROM smiles
0.000156 - SELECT COUNT(*) FROM online WHERE online_uid=0 AND online_ip=''
0.000162 - UPDATE online SET online_updated = 1711618520, online_module = 44 WHERE online_uid = 0 AND online_ip=''
0.000129 - SELECT online_uid, online_uname FROM online
0.000362 - SELECT uid, uname, user_regdate FROM users WHERE user_regdate >= 1711494000 and level > 0
0.000135 - SELECT uid, uname from users where level > 0 order by uid DESC limit 1
0.000191 - SELECT COUNT(*) FROM users WHERE level > 0
0.000072 - SELECT COUNT(*) FROM session
0.000338 - 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.000200 - SELECT * FROM xoopspoll_desc WHERE display=1 ORDER BY weight ASC, end_time DESC
0.000155 - SELECT id FROM partners Where status = 1 ORDER BY hits DESC
0.000108 - SELECT id, url, image, title FROM partners WHERE id=9
0.000114 - SELECT id, url, image, title FROM partners WHERE id=3
0.000087 - SELECT id, url, image, title FROM partners WHERE id=5
0.000085 - SELECT id, url, image, title FROM partners WHERE id=6
0.000110 - SELECT id, url, image, title FROM partners WHERE id=4
0.000090 - SELECT `forum_id`, `forum_name` FROM `bb_forums` WHERE `forum_id` IN ()
Error number: 1064
Error message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
0.000134 - SELECT cat_title, cat_id FROM bb_categories WHERE cat_id = '17'
0.001804 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_post')
0.003756 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_reply')
0.000780 - SELECT * FROM `users` WHERE `uid` IN (448,1)
0.000417 - SELECT rank_title AS title, rank_image AS image FROM ranks WHERE rank_id = 9
0.000283 - SELECT groupid FROM groups_users_link WHERE uid=1
0.000208 - SELECT * FROM groups WHERE groupid=1
0.000372 - SELECT rank_title AS title, rank_image AS image FROM ranks WHERE rank_min <= 2 AND rank_max >= 2 AND rank_special = 0
0.000227 - SELECT groupid FROM groups_users_link WHERE uid=448
0.000191 - SELECT * FROM groups WHERE groupid=2
0.000263 - SELECT user_digests, uid FROM bb_user_stats WHERE uid IN( 1, 448)
0.002909 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_edit')
0.002376 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_delete')
0.003822 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_reply')
0.000635 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_print')
0.002650 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_edit')
0.001125 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_delete')
0.003646 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_reply')
0.000568 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_print')
0.002887 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_edit')
0.002205 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_delete')
0.003904 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_reply')
0.000806 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_print')
0.000427 - SELECT forum_id, COUNT(*) AS count FROM bb_moderates WHERE (uid=0 OR ip IN('54','54.163','54.163.62','54.163.62.42')) AND (mod_end > 1711618521) GROUP BY forum_id
0.004947 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_groupid` IN (3) AND `gperm_itemid` = '73' AND `gperm_name` IN ('forum_access', 'forum_view', 'forum_post', 'forum_reply', 'forum_edit', 'forum_delete', 'forum_addpoll', 'forum_vote', 'forum_attach', 'forum_noapprove', 'forum_type', 'forum_html', 'forum_signature', 'forum_pdf', 'forum_print'))
0.002350 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_addpoll')
0.001232 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'category_access')
0.000498 - 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.003704 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_reply')
Total: 86
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: 241 files
Memory usage: 1936416 bytes
Timers
XOOPS took 1.994 seconds to load.
XOOPS Boot took 0.011 seconds to load.
Module init took 1.286 seconds to load.
newBB_Header took 0.004 seconds to load.
newBB_viewtopic took 1.092 seconds to load.
XOOPS output init took 0.028 seconds to load.
Module display took 0.666 seconds to load.
Page rendering took 0.003 seconds to load.