mysql_admin_queries.php

来自「sabreipb 2.1.6 utf-8中文版本！」· PHP 代码 · 共 514 行 · 第 1/2 页

	
	function modlogs_view_two( $a )
	{
		return "SELECT mem.members_display_name, m.*, f.id as forum_id, f.name FROM ".SQL_PREFIX."moderator_logs m
				LEFT JOIN ".SQL_PREFIX."members mem ON(mem.id=m.member_id)
				LEFT JOIN ".SQL_PREFIX."forums f ON(f.id=m.forum_id)
				WHERE {$a['dbq']} ORDER BY m.ctime DESC LIMIT {$a['start']}, 20";
	}
	
	function modlogs_view_three( $a )
	{
		return "SELECT mem.members_display_name, m.*, f.id as forum_id, f.name FROM ".SQL_PREFIX."moderator_logs m
				  LEFT JOIN ".SQL_PREFIX."members mem ON(mem.id=m.member_id)
				  LEFT JOIN ".SQL_PREFIX."forums f ON(f.id=m.forum_id)
				ORDER BY m.ctime DESC LIMIT {$a['start']}, 20";
	}	
	
	function modlogs_list_current_last_five( $a )
	{
		return "SELECT mem.members_display_name, m.*, f.id as forum_id, f.name FROM ".SQL_PREFIX."moderator_logs m
					LEFT JOIN ".SQL_PREFIX."members mem ON(mem.id=m.member_id)
		            LEFT JOIN ".SQL_PREFIX."forums f ON (f.id=m.forum_id)
		            ORDER BY m.ctime DESC LIMIT 0, 5";
	}
	
	function modlogs_list_current_show_all( $a )
	{
		return "SELECT mem.members_display_name, m.*, count(m.id) as act_count
				FROM ".SQL_PREFIX."moderator_logs m
				LEFT JOIN ".SQL_PREFIX."members mem ON(mem.id=m.member_id)
				GROUP BY m.member_id
				ORDER BY act_count DESC";
	}
	
	function spiderlogs_list_current( $a )
	{
		return "SELECT count(*) as cnt, bot, max(entry_date) as entry_date, query_string FROM ".SQL_PREFIX."spider_logs GROUP BY bot ORDER BY entry_date DESC";
	}
	
	function statistics_show_views( $a )
	{
		return "SELECT SUM(t.views) as result_count, t.forum_id, f.name as result_name
				FROM ".SQL_PREFIX."topics t, ".SQL_PREFIX."forums f
				WHERE t.start_date > '{$a['from_time']}'
				AND t.start_date < '{$a['to_time']}'
				AND t.forum_id=f.id
				GROUP BY t.forum_id
				ORDER BY result_count {$a['sortby']}";
	}
	
	function statistics_result_screen( $a )
	{
		return "SELECT MAX({$a['sql_field']}) as result_maxdate,
				 COUNT(*) as result_count,
				 DATE_FORMAT(from_unixtime({$a['sql_field']}),'{$a['sql_date']}') AS result_time
				 FROM ".SQL_PREFIX."{$a['sql_table']}
				 WHERE {$a['sql_field']} > '{$a['from_time']}'
				 AND {$a['sql_field']} < '{$a['to_time']}'
				 GROUP BY result_time
				 ORDER BY {$a['sql_field']} {$a['sortby']}";
	}
	
	function stylesets_list_sets_templates( $a )
	{
		return "SELECT set_id FROM ".SQL_PREFIX."skin_templates GROUP BY set_id";
	}
	
	function stylesets_list_sets_macros( $a )
	{
		return "SELECT macro_set FROM ".SQL_PREFIX."skin_macro GROUP BY macro_set";
	}
	
	function stylesheets_do_form_concat( $a )
	{
		return "SELECT *, instr(',{$a['id']}{$a['parent']},1,', concat(',',set_skin_set_id,',') ) as theorder
				 FROM ".SQL_PREFIX."skin_sets
				 WHERE set_skin_set_id in ({$a['id']}{$a['parent']},1)
				 ORDER BY theorder";
	}
	
	function warnlogs_view_note( $a )
	{
		return "SELECT l.*, m.id as a_id, m.members_display_name as a_name, p.id as p_id, p.members_display_name as p_name
				FROM ".SQL_PREFIX."warn_logs l
				  LEFT JOIN ".SQL_PREFIX."members m ON (m.id=l.wlog_mid)
				  LEFT JOIN ".SQL_PREFIX."members p ON (p.id=l.wlog_addedby)
				WHERE l.wlog_id={$a['id']}";
	}
	
	function warnlogs_view( $a )
	{
		return "SELECT l.*, m.id as a_id, m.members_display_name as a_name, p.id as p_id, p.members_display_name as p_name
				FROM ".SQL_PREFIX."warn_logs l
				  LEFT JOIN ".SQL_PREFIX."members m ON (m.id=l.wlog_mid)
				  LEFT JOIN ".SQL_PREFIX."members p ON (p.id=l.wlog_addedby)
				WHERE l.wlog_mid={$a['mid']}
				ORDER BY l.wlog_date DESC LIMIT {$a['start']},30";
	}
	
	function warnlogs_view_two( $a )
	{
		return "SELECT l.*, m.id as a_id, m.members_display_name as a_name, p.id as p_id, p.members_display_name as p_name
				FROM ".SQL_PREFIX."warn_logs l
				  LEFT JOIN ".SQL_PREFIX."members m ON (m.id=l.wlog_mid)
				  LEFT JOIN ".SQL_PREFIX."members p ON (p.id=l.wlog_addedby)
				WHERE {$a['dbq']}
				ORDER BY l.wlog_date DESC LIMIT {$a['start']},30";
	}
	
	function warnlogs_list_current( $a )
	{
		return "SELECT l.*, m.id as a_id, m.members_display_name as a_name, p.id as p_id, p.members_display_name as p_name
				FROM ".SQL_PREFIX."warn_logs l
				LEFT JOIN ".SQL_PREFIX."members m ON (m.id=l.wlog_mid)
				LEFT JOIN ".SQL_PREFIX."members p ON (p.id=l.wlog_addedby)
			   ORDER BY l.wlog_date DESC LIMIT 0,10";
	}
	
	function warnlogs_list_current_two( $a )
	{
		return "SELECT l.*, m.name, m.members_display_name, count(l.wlog_mid) as act_count
				from ".SQL_PREFIX."warn_logs l, ".SQL_PREFIX."members m
				WHERE m.id=l.wlog_mid
				GROUP BY l.wlog_mid
				ORDER BY act_count DESC";
	}
	
	
	function cache_wrapper( $a )
	{
		return "SELECT *, instr(',{$a['id']}{$a['parent_in']},{$a['root']},', concat(',',set_skin_set_id,',') ) as theorder
				FROM ".SQL_PREFIX."skin_sets
				WHERE set_wrapper != '' AND set_skin_set_id in ({$a['id']}{$a['parent_in']},{$a['root']})
				ORDER BY theorder
				LIMIT 0,1";
	}
	
	function cache_templates_titles( $a )
	{
		return "SELECT group_name, set_id, suid, func_name, func_data,
				 INSTR(',{$a['id']}{$a['parent_in']},{$a['root']},' , CONCAT(',',set_id,',') ) as theorder
				FROM ".SQL_PREFIX."skin_templates WHERE set_id IN ({$a['id']}{$a['parent_in']},{$a['root']}) ORDER BY group_name, theorder DESC";
	}
	
	function cache_templates_bits( $a )
	{
		return "SELECT *,
				 INSTR(',{$a['id']}{$a['parent_in']},{$a['root']},' , CONCAT(',',set_id,',') ) as theorder
				FROM ".SQL_PREFIX."skin_templates WHERE set_id IN ({$a['id']}{$a['parent_in']},{$a['root']}) AND group_name='{$a['group']}' ORDER BY func_name,theorder DESC";
	}
	
	function cache_templates_all( $a )
	{
		return "SELECT *,
				 INSTR(',{$a['id']}{$a['parent_in']},{$a['root']},' , CONCAT(',',set_id,',') ) as theorder
				FROM ".SQL_PREFIX."skin_templates WHERE set_id IN ({$a['id']}{$a['parent_in']},{$a['root']}) ORDER BY group_name, func_name, theorder DESC";
	}
	
	function cache_templates_css( $a )
	{
		return "SELECT *, instr(',{$a['id']}{$a['parent_in']},{$a['root']},', concat(',',set_skin_set_id,',') ) as theorder
				FROM ".SQL_PREFIX."skin_sets
				WHERE set_css != '' AND set_skin_set_id in ({$a['id']}{$a['parent_in']},{$a['root']})
				ORDER BY theorder
				LIMIT 0,1";
	}
	
	function cache_templates_macros( $a )
	{
		return "SELECT *,
				 INSTR(',{$a['id']}{$a['parent_in']},{$a['root']},' , CONCAT(',',macro_set,',') ) as theorder
				FROM ".SQL_PREFIX."skin_macro
				WHERE macro_set IN ({$a['id']}{$a['parent_in']},{$a['root']})
				ORDER BY macro_value ASC,theorder DESC";
	}
	
	function cache_empty_css( $a )
	{
		return "SELECT * FROM ".SQL_PREFIX."skin_sets WHERE set_css like '' AND set_skin_set_parent={$a['parent_id']}";
	}
	
	function cache_empty_wrapper( $a )
	{
		return "SELECT * FROM ".SQL_PREFIX."skin_sets WHERE set_wrapper like '' AND set_skin_set_parent={$a['parent_id']}";
	}
	
	function mod_func_get_last_post( $a )
	{
		return "SELECT p.post_date, p.topic_id, p.author_id, p.author_name, p.pid, t.forum_id
				FROM ".SQL_PREFIX."posts p
				 LEFT JOIN ".SQL_PREFIX."topics t ON (p.topic_id=t.tid)
				WHERE topic_id={$a['tid']} and queued <> 1
				ORDER BY pid DESC LIMIT 0,1";
	}
	
	function mod_func_get_attach_count( $a )
	{
		return "SELECT COUNT(*) as count FROM ".SQL_PREFIX."attachments a
			     LEFT JOIN ".SQL_PREFIX."posts p on (a.attach_pid=p.pid)
			    WHERE p.topic_id={$a['tid']}";
	
	}
	
	function mod_func_get_topic_tracker( $a )
	{
		return "SELECT tr.*, m.id, m.mgroup, m.org_perm_id, t.tid, t.forum_id, g.g_id, g.g_perm_id
				 FROM ".SQL_PREFIX."tracker tr
				 LEFT JOIN ".SQL_PREFIX."topics t ON (tr.topic_id=t.tid)
				 LEFT JOIN ".SQL_PREFIX."members m on (m.id=tr.member_id)
				 LEFT JOIN ".SQL_PREFIX."groups g on (g.g_id=m.mgroup)
				WHERE tr.topic_id".$a['tid'];
	}
	
	function ucp_get_all_announcements( $a )
	{
		return "SELECT a.*, m.id, m.name, m.members_display_name
				 FROM ".SQL_PREFIX."announcements a
				  LEFT JOIN ".SQL_PREFIX."members m on (a.announce_member_id=m.id)
				 ORDER BY announce_end DESC";
	}
	
	function ucp_get_all_announcements_byid( $a )
	{
		return "SELECT a.*, m.*, me.*
				 FROM ".SQL_PREFIX."announcements a
				  LEFT JOIN ".SQL_PREFIX."members m on (a.announce_member_id=m.id)
				  LEFT JOIN ".SQL_PREFIX."member_extra me on (me.id=m.id)
				 WHERE a.announce_id={$a['id']}";
	}
	
	function ucp_tracker_prune( $a )
	{
		return "SELECT tr.trid FROM ".SQL_PREFIX."tracker tr, ".SQL_PREFIX."topics t WHERE t.tid=tr.topic_id AND t.last_post < {$a['time']}";
	}
	
	function login_getmember( $a )
	{
		return "SELECT m.*, g.*
				FROM ibf_members m, ibf_groups g
				WHERE LOWER(name)='{$a['username']}' and m.mgroup=g.g_id";
	}
	
	function settings_search( $a )
	{
		return "SELECT c.*, ct.conf_title_noshow
				FROM ".SQL_PREFIX."conf_settings c
				 LEFT JOIN ".SQL_PREFIX."conf_settings_titles ct ON ct.conf_title_id=c.conf_group
				WHERE LOWER(conf_title) LIKE '%{$a['keywords']}%' OR LOWER(conf_description) LIKE '%{$a['keywords']}%'
				ORDER BY conf_title
				LIMIT {$a['limit_a']}, {$a['limit_b']}";
	}
	
    
} // end class


?>