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>1714086858

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

	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 (2) and
	    end_time>1714086858

select search_image,search_hvr_image,continue_image,continue_hvr_image,rate_image,rate_hvr_image
from navlinks where navgroup='1'

select name from contact_fields where name like '%email%' or name like '%e-mail%'

    select offline_text from chat_config

    select choose_password,noreply,allow_contacts2_users,fulltext_search_kb
    from config

	select page_id,navgroup from pages
	    where (mode='' or mode is null) and
	    substring_index(pages.name,'/',-1)='tickets.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 tickets.user_id from tickets,responses
	where tickets.ticket_id=responses.ticket_id and
	    responses.response_id=''

	    update responses set rated='',
		rate_comments=''
	    where response_id=''