I turned on mySQL debug and checked for errors, I didn't find any I think (this is all very new to me
)
just to make sure, here's what the debug came up with:
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = 'e2b04307affcd172a20fca4fa040b55c'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'xfguestbook'
SELECT * FROM xoops_config WHERE (conf_modid = 85) ORDER BY conf_order ASC
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 3) ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 0, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 1
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,85) AND b.bid IN (204,161,24,170,165,155,90,163,171,160,157,141,9,10,18,82,14,119,117,144,17,191,150,16,159,15,13,194,185,158,23,180,12,7,121,6,2,1,151,4,154,152,203,92,198,196,195,193,192,190,189,182,181,153,146,145,138,137,116,115,114,93,113,112,111,26,25,21,20,19,11,8,91,5,3,136,51,202) ORDER BY b.weight,b.bid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'PL v6.0' AND tpl_file = 'system_dummy.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = 0 AND to_userid = 1)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'PL v6.0' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_xfguestbook_msg WHERE moderate = 0
SELECT COUNT(*) FROM xoops_xfguestbook_msg WHERE moderate = 1
SELECT * FROM xoops_xfguestbook_msg WHERE moderate = 0 ORDER BY msg_id DESC LIMIT 0, 10
SELECT * FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT * FROM xoops_smiles
SELECT * FROM xoops_users WHERE uid=4
SELECT rank_title AS title, rank_image AS image FROM xoops_ranks WHERE rank_id = 6
SELECT * FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT * FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT * FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT * FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT * FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT * FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT * FROM xoops_users WHERE uid=1
SELECT rank_title AS title, rank_image AS image FROM xoops_ranks WHERE rank_id = 7
SELECT * FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT * FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT * FROM xoops_users WHERE uid=1
SELECT rank_title AS title, rank_image AS image FROM xoops_ranks WHERE rank_id = 7
SELECT * FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'PL v6.0' AND tpl_file = 'xfguestbook_index.html') ORDER BY tpl_refid
SELECT theme, title, subtitle, metakey, metadesc FROM xoops_ctem_link WHERE mid='85'
SELECT theme, title, subtitle, metakey, metadesc FROM xoops_ctem_pagelink WHERE pid=''
Total: 37 queries
Thx for the help so far Mith!!
