Zikula Community

(mysql): select postnuke_module_vars.pn_name, postnuke_module_vars.pn_value from postnuke_module_vars where postnuke_module_vars.pn_modname = '/PNConfig'  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_session_info.pn_vars from postnuke_session_info where postnuke_session_info.pn_sessid = '2638f7e8489d79b92ea60ccd0268c63e'  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_session_info.pn_ipaddr from postnuke_session_info where postnuke_session_info.pn_sessid = '2638f7e8489d79b92ea60ccd0268c63e'  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_user_property.pn_prop_label as label, postnuke_user_data.pn_uda_value as value from postnuke_user_data, postnuke_user_property where postnuke_user_data.pn_uda_uid = '2' and postnuke_user_data.pn_uda_propid = postnuke_user_property.pn_prop_id  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select * from postnuke_users where postnuke_users.pn_uid = 2  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_modules.pn_name, postnuke_modules.pn_displayname, postnuke_modules.pn_id from postnuke_modules  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_modules.pn_id, postnuke_modules.pn_name, postnuke_modules.pn_type, postnuke_modules.pn_directory, postnuke_modules.pn_regid, postnuke_modules.pn_displayname, postnuke_modules.pn_description, postnuke_modules.pn_state, postnuke_modules.pn_version from postnuke_modules  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_user_perms.pn_realm, postnuke_user_perms.pn_component, postnuke_user_perms.pn_instance, postnuke_user_perms.pn_level from postnuke_user_perms where postnuke_user_perms.pn_uid in (-1,2) order by postnuke_user_perms.pn_sequence  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_group_membership.pn_gid from postnuke_group_membership where postnuke_group_membership.pn_uid in (-1,2)  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_group_perms.pn_realm, postnuke_group_perms.pn_component, postnuke_group_perms.pn_instance, postnuke_group_perms.pn_level from postnuke_group_perms where postnuke_group_perms.pn_gid in (-1,0,2) order by postnuke_group_perms.pn_sequence  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_module_vars.pn_name, postnuke_module_vars.pn_value from postnuke_module_vars where postnuke_module_vars.pn_modname = 'pnrender'  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_module_vars.pn_name, postnuke_module_vars.pn_value from postnuke_module_vars where postnuke_module_vars.pn_modname = 'Modules'  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_modules.pn_id, postnuke_modules.pn_name, postnuke_modules.pn_type, postnuke_modules.pn_displayname, postnuke_modules.pn_description, postnuke_modules.pn_directory, postnuke_modules.pn_state, postnuke_modules.pn_version, postnuke_modules.pn_admin_capable from postnuke_modules order by postnuke_modules.pn_name limit 50,25  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select COUNT(1) from postnuke_modules  
--------------------------------------------------------------------------------


--------------------------------------------------------------------------------
(mysql): select count(*) AS count from postnuke_banner where postnuke_banner.pn_type = '0'  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): select postnuke_banner.pn_bid, postnuke_banner.pn_imageurl, postnuke_banner.pn_clickurl from postnuke_banner where postnuke_banner.pn_type = '0' limit 0,1  
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(mysql): update postnuke_banner set postnuke_banner.pn_impmade=postnuke_banner.pn_impmade+1 where postnuke_banner.pn_bid=0