I have been steadly altering XOOPS from (
http://www.xoops.org) to use
ADOdb 5.11 for the 2.x series of XOOPS. This is for extra database functions.
I am
not using the
ADODb Sessions however for some reason the
session_id() when the
standard XOOPS Session is set with handler and so on is causing for some reason the
cookies to be not sent with
standard ADODB not with the ADODB Session Management.
It is like the headers are being sent for some reason I have been circumventing it with
ob_start() and
ob_end_clean(); when the file is loaded but I am not sure where in the file it is outputing a character for the headers to be sent.
Could anyone offer any advice!!
If you are looking for the resource for the code i am working on it is here ::
xoops2.5_adodb_pdo_0.22.zip (1.3Mb)
Just replace the database directory with XOOPS 2.4 or XOOPS 2.5
When I go to log in the following SQL happens:
0.001070 - SET NAMES 'utf8'
0.000583 - SET SQL_BIG_SELECTS = 1
0.003259 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0.001664 - SELECT * FROM modules WHERE dirname = 'webcams'
0.001295 - SELECT sess_data, sess_ip FROM session WHERE sess_id = ''
0.001755 - SELECT * FROM modules WHERE dirname = 'protector'
0.001889 - SELECT COUNT(*) FROM banner
0.002101 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0.002315 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3)
0.017161 - 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,-1) AND b.bid IN (1,2,3,4,5,6,7,8,9,10,11,12,13) ORDER BY b.weight, m.block_id
0.002350 - SELECT * FROM modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
0.001799 - SELECT * FROM group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND gperm_groupid = '3')
You can see with this line
SELECT sess_data, sess_ip FROM session WHERE sess_id = '' the
session id is
missing, i am not sure why this is..
Could anyone help please?
