select user.user_id from user,session ,user_group
	where hash='' and
	    user.user_id=session.user_id and
	    user.user_id=user_group.user_id and
	    user_group.group_id in (3,2) and
	    end_time>1714934773

    select count(*) from user_group

    where user_id='' and group_id=3

select a.topic_id ,a.subject,a.icon,b.category_id from topics as a,topics_categories as b where a.topic_id=b.topic_id and a.featured_section_status=1 and b.category_id>0 group by a.topic_id

select a.topic_id ,a.subject,a.icon,b.category_id from topics as a,topics_categories as b where a.topic_id=b.topic_id and a.popular_section_status=1 and b.category_id>0 group by a.topic_id

    select subject from topics where topic_id=''

        select tz_offset/*,tz_tformat_sql,tz_tformat_php,tz_dformat_sql,
	    tz_dformat_php*/
	from config

	select page_id,navgroup from pages
	    where (mode='' or mode is null) and
	    substring_index(pages.name,'/',-1)='main.php'

    select title,header,footer,background,length(image1),
	length(image2),length(image3),length(image4),length(image5),
	font_color,font_size,support_department,
	table1_bgcolor,table2_bgcolor,table3_bgcolor,
	table1_color,table2_color,table3_color,
	table1_bordercolor,table2_bordercolor,table3_bordercolor,
	meta,glossary_color,length(online_img),length(offline_img),banner_text
    from pages_properties
    where pages_properties.page_id='' and object_id=''

    select /*length(header),*/header_align,length(footer),footer_align,
	header_html,footer_html,length(logo),toptable_color,bottomtable_color,
	textmain,textchat,length(mainimg),length(mainimg2),length(main_footer),
	main_footer_align
    from navlinks where navgroup='1'

    update pages set hits=hits+1,last_visit=now()
    where page_id=''

    select top_navigation,topnav_color,topnav_textcolor,/*length(left_img),*/
	links_color,powered,length(powered_img),navbutton_bg,powered_bg
    from config

    select secure_chat,redirect2support,
	    length(topright_online),length(topright_offline)
    from chat_config

select kbase_user from kb_config

select contact_phon,contact_email,header_color,top_navigation_text_color,footer_bar_color,footer_bar_text_color,links_color,table_bar_color,table_bar_text_color,right_heading_text_color,body_heading_text_color,body_text_color,top_links_color,top_navigation_color,top_navigation_background,body_border_top,body_background,top_navigation_area_show,facebook_link,twitter_link,rss_link,facebook_url,twitter_url,rss_url,search_image,search_hvr_image,facebook_image,twitter_image,rss_image,gray_area_phone,gray_area_email,gray_area_contactus
from navlinks where navgroup='1'

close window x

    update staff_status set online=0
    where updated + interval 5*5 second < now()

select count(*) from staff_status where online=1

select currently_offline from chat_config

	select access,subject,body,

	    date_format(modified + interval '' second,' '),

	    date_format(added + interval '' second,' ')

        from topics

	where topic_id=''

	select user.user_id from user,session ,user_group
	where hash='' and
	    user.user_id=session.user_id and
	    user.user_id=user_group.user_id and
	    user_group.group_id in (3,4) and
	    end_time>1714934774

    select rate_answers,allow_email_articles,allow_print_articles,

	allow_save_articles,show_faq,

	show_lastmodified,allow_comments,show_topic_id,show_relevance,

	show_recent,recent_number,allow_update_notify,bar_bg,categ_numrows,seo_links,show_latest

    from kb_config

select fulltext_search_kb from config

	select show_faq,table_bg,bar_bg,heading_fg,header_color,faq_by_rating,

	    kb_bg2

	from kb_config

	select category_id,name,description,icon,seo_url from help_categories

	where active in (1,2) and parent_id='0'

	order by sort asc

	select category_id,name,description,icon,seo_url from help_categories

	where active in (1,2) and parent_id='0'

	order by sort asc

	select topics.topic_id

	from topics ,help_categories,topics_categories

	where access=1 and intgroup_id in ('0',0)

	     and topics.topic_id=topics_categories.topic_id and

		topics_categories.category_id='0' and

		((topics_categories.category_id=help_categories.category_id and

		help_categories.active in (1,2)) or '0'=0)

	group by topics.topic_id

	select topics.topic_id,subject,left(body,255),short_content,body,

	    1 as score,

	    topics.icon,topics.seo_url,topics.sort_main,topics_categories.category_id

	from topics  ,help_categories,topics_categories

	where  access=1

	     and topics.topic_id=topics_categories.topic_id and

		topics_categories.category_id='0' and

		((topics_categories.category_id=help_categories.category_id and

		help_categories.active in (1,2)) or '0'=0)

	group by topics.topic_id

	order by score desc,topics_categories.sort

	limit 0,

	select user.user_id from user,session ,user_group
	where hash='' and
	    user.user_id=session.user_id and
	    user.user_id=user_group.user_id and
	    user_group.group_id in (3,2) and
	    end_time>1714934774

    select offline_logo,online_logo
    from chat_config

    select live_chat_heading,live_chat_description,contact_heading,contact_phon,contact_email,contact_hours,feedback_heading,feedback_description,top_question_heading,show_live_chat_section,show_Contact_us_section,show_give_feedback_section,show_top_question_section,searched_heading,searched_description,show_searched_section,search_image,search_hvr_image,suggest_your_image,suggest_your_hvr_image
    from navlinks where navgroup='1'