mysql_admin_queries.php

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

<?php

/*
+--------------------------------------------------------------------------
|   Invision Power Board v2.1.5
|   =============================================
|   by Matthew Mecham
|   (c) 2001 - 2005 Invision Power Services, Inc.
|   
|   =============================================
|   Web: 
|   Time: Wed, 01 Mar 2006 19:11:29 GMT
|   Release: 
|   Licence Info: 
+---------------------------------------------------------------------------
|   > $Date: 2006-02-01 18:16:26 +0000 (Wed, 01 Feb 2006) $
|   > $Revision: 132 $
|   > $Author: bfarber $
+---------------------------------------------------------------------------
|
|   > MySQL ADMIN DB Queries abstraction module
|   > Module written by Matt Mecham
|   > Date started: 24th May 2004
|
|	> Module Version Number: 1.0.0
+--------------------------------------------------------------------------
*/



class sql_queries extends db_driver
{

     var $db  = "";
     var $tbl = "";
     
    /*========================================================================*/
    // Set up...             
    /*========================================================================*/  
                   
    function sql_queries( &$obj )
    {
    	$this->db = &$obj;
    	
    	if ( ! $this->db->obj['sql_tbl_prefix'] )
    	{
    		$this->db->obj['sql_tbl_prefix'] = '".SQL_PREFIX."';
    	}
    	
    	$this->tbl = $this->db->obj['sql_tbl_prefix'];
    }
    
    /*========================================================================*/
    
    # IPB 2.1 BETA 2: NEW NEW NEW!
	function acpperms_get_main_groups( $a )
	{
		return "SELECT perm_key, perm_main, perm_child FROM ".SQL_PREFIX."admin_permission_keys WHERE perm_main='{$a['perm_main']}' GROUP BY perm_child";
	}
    
    # IPB 2.1 BETA 2: NEW NEW NEW!
	function login_getmember_by_dname( $a )
	{
		return "SELECT m.*, g.*
				FROM ibf_members m, ibf_groups g
				WHERE LOWER(members_display_name)='{$a['username']}' and m.mgroup=g.g_id";
	}
	
    function admin_emo_count( $a )
    {
    	return "SELECT id, count(id) as count, emo_set FROM ".SQL_PREFIX."emoticons GROUP BY emo_set ORDER BY emo_set";
    }
    
    function adminlogs_view_one( $a )
    {
    	return "SELECT m.*, mem.id, mem.name, mem.members_display_name FROM ".SQL_PREFIX."admin_logs m, ".SQL_PREFIX."members mem
				WHERE m.member_id={$a['mid']} AND m.member_id=mem.id ORDER BY m.ctime DESC LIMIT {$a['limit_a']}, 20";
    }
    
    function adminlogs_view_two( $a )
    {
    	return "SELECT m.*, mem.id, mem.name, mem.members_display_name FROM ".SQL_PREFIX."admin_logs m, ".SQL_PREFIX."members mem
				 WHERE m.member_id=mem.id AND {$a['dbq']} ORDER BY m.ctime DESC LIMIT {$a['limit_a']}, 20";
    }
    
    function adminlogs_view_list_current( $a )
    {
    	return "SELECT m.*, mem.id, mem.members_display_name as name FROM ".SQL_PREFIX."admin_logs m, ".SQL_PREFIX."members mem
				 WHERE m.member_id=mem.id ORDER BY m.ctime DESC LIMIT 0, 5";
    }
    
    function adminlogs_view_list_current_two( $a )
    {
    	return "SELECT m.*, mem.members_display_name as name, count(m.id) as act_count
				FROM ".SQL_PREFIX."admin_logs m, ".SQL_PREFIX."members mem
				WHERE m.member_id=mem.id
				GROUP BY m.member_id ORDER BY act_count DESC";
    }
	
	
	
	function attachments_bulk_remove( $a )
	{
		return "SELECT a.*, p.pid, p.topic_id
				FROM ".SQL_PREFIX."attachments a
				 LEFT JOIN ".SQL_PREFIX."posts p ON (p.pid=a.attach_pid)
				WHERE a.attach_pid > 0 AND a.attach_id IN(".implode(",",$a['ids']).")";
	}
	
	
	function emaillogs_view_email( $a )
	{	
		return "SELECT email.*, m.id, m.members_display_name as name, mem.id as to_id, mem.members_display_name as to_name FROM ".SQL_PREFIX."email_logs email
				 LEFT JOIN ".SQL_PREFIX."members m ON (m.id=email.from_member_id)
				 LEFT JOIN ".SQL_PREFIX."members mem ON (mem.id=email.to_member_id)
				WHERE email.email_id={$a['id']}";
	}
	
	function emaillogs_list_current( $a )
	{	
		return "SELECT email.*, m.id, m.members_display_name as name, mem.id as to_id, mem.members_display_name as to_name FROM ".SQL_PREFIX."email_logs email
				 LEFT JOIN ".SQL_PREFIX."members m ON (m.id=email.from_member_id)
				 LEFT JOIN ".SQL_PREFIX."members mem ON (mem.id=email.to_member_id) {$a['dbe']}
				ORDER BY email_date DESC LIMIT {$a['limit_a']},25";
	}
	
	function groups_permsplash( $a )
	{
		return "SELECT COUNT(id) as count, org_perm_id FROM ".SQL_PREFIX."members WHERE (org_perm_id IS NOT NULL AND org_perm_id != '') GROUP by org_perm_id";
	}
	
	# Changed [ 2.1 ] Added OR m.mgroup_others LIKE CONCAT('%,',g.g_id,',%')
	function groups_main_screen( $a )
	{
		return "SELECT g.g_id, g.g_access_cp, g.g_is_supmod, g.g_title,g.prefix, g.suffix,
				  COUNT(m.id) as count
				 FROM ".SQL_PREFIX."groups as g
		         LEFT JOIN ".SQL_PREFIX."members m ON (m.mgroup = g.g_id OR m.mgroup_others LIKE CONCAT('%,',g.g_id,',%'))
		         GROUP BY g.g_id ORDER BY g.g_title";
	}
	
	function index_admin_logs( $a )
	{
		return "SELECT m.*, mem.id, mem.name, mem.members_display_name FROM ".SQL_PREFIX."admin_logs m, ".SQL_PREFIX."members mem
					WHERE  m.member_id=mem.id ORDER BY m.ctime DESC LIMIT 0, 5";
	}
	
	function languages_list_current( $a )
	{
		return "select ".SQL_PREFIX."languages.*, count(".SQL_PREFIX."members.id) as mcount from ".SQL_PREFIX."languages
				left join ".SQL_PREFIX."members on(".SQL_PREFIX."members.language=".SQL_PREFIX."languages.ldir)
				where (".SQL_PREFIX."members.language is not null or ".SQL_PREFIX."members.language = 'en')
				group by ".SQL_PREFIX."languages.ldir
				order by ".SQL_PREFIX."languages.lname";
	}
	
	function member_tools_learn_ip_one( $a )
	{
		return "SELECT m.id, m.members_display_name as name, m.email, m.posts, m.joined, p.pid, p.author_id, p.post_date, p.ip_address, p.topic_id
				FROM ".SQL_PREFIX."posts p
				 LEFT JOIN ".SQL_PREFIX."members m ON ( p.author_id=m.id)
				WHERE p.ip_address{$a['query']} GROUP BY p.author_id ORDER BY p.post_date DESC LIMIT 250";
	}
	
	function member_tools_learn_ip_two( $a )
	{
		return "SELECT m.id, m.members_display_name as name, m.email, m.posts, m.joined, p.vote_date, p.ip_address, p.tid
				FROM ".SQL_PREFIX."voters p
				 LEFT JOIN ".SQL_PREFIX."members m ON ( p.member_id=m.id)
				WHERE p.ip_address{$a['query']} GROUP BY p.member_id ORDER BY p.vote_date DESC LIMIT 250";
	}
	
	function member_tools_learn_ip_three( $a )
	{
		return "SELECT m.id, m.members_display_name as name, m.email, m.posts, m.joined, p.email_date, p.from_ip_address
				FROM ".SQL_PREFIX."email_logs p
				 LEFT JOIN ".SQL_PREFIX."members m ON ( p.from_member_id=m.id)
				WHERE p.from_ip_address{$a['query']} GROUP BY p.from_member_id ORDER BY p.email_date DESC LIMIT 250";
	}
	
	function member_tools_learn_ip_four( $a )
	{
		return "SELECT m.id, m.members_display_name as name, m.email, m.posts, m.joined, p.entry_date, p.ip_address
				FROM ".SQL_PREFIX."validating p
				 LEFT JOIN ".SQL_PREFIX."members m ON ( p.member_id=m.id)
				WHERE p.ip_address{$a['query']} GROUP BY p.member_id ORDER BY p.entry_date DESC LIMIT 250";
	}
	
	function member_tools_show_ips( $a )
	{
		return "SELECT count(ip_address) as ip, ip_address, pid, topic_id, post_date
				FROM ".SQL_PREFIX."posts
				WHERE author_id={$a['mid']}
				GROUP BY ip_address
				ORDER BY ip DESC LIMIT {$a['st']}, {$a['end']}";
	}
	
	function member_domod( $a )
	{
		return "SELECT m.id, m.name, m.email, m.mgroup, v.* FROM ".SQL_PREFIX."validating v
				 LEFT JOIN ".SQL_PREFIX."members m ON (v.member_id=m.id)
				WHERE m.id IN(".implode( ",",$a['ids'] ).")";
	}
	
	# Updated 2.1 (member_view_mod) [ Added: extra query bit AND m.members_display_name AND m.ip_address]
	function member_view_mod( $a )
	{
		return "SELECT m.name, m.members_display_name, m.ip_address, m.id, m.email, m.posts, m.joined, v.*
				  FROM ".SQL_PREFIX."validating v
				LEFT JOIN ".SQL_PREFIX."members m ON (v.member_id=m.id)
				WHERE v.lost_pass=0 {$a['extra']}
				ORDER BY {$a['col']} {$a['ord']} LIMIT {$a['st']},75";
	}
	
	function member_search_form_one( $a )
	{
		return "SELECT m.*, me.*, m.id as memid
				FROM ".SQL_PREFIX."members m
				 LEFT JOIN ".SQL_PREFIX."member_extra me ON (me.id=m.id)
				 LEFT JOIN ".SQL_PREFIX."pfields_content p ON (p.member_id=m.id)
				{$a['rq']} ORDER BY m.members_display_name LIMIT {$a['st']},25";
	}
	
	function member_search_form_two( $a )
	{
		return "SELECT m.*, me.*, m.id as memid
				FROM ".SQL_PREFIX."members m
				 LEFT JOIN ".SQL_PREFIX."member_extra me ON (me.id=m.id)
				 LEFT JOIN ".SQL_PREFIX."pfields_content p ON (p.member_id=m.id)
				{$a['rq']}";
	}
	
	function member_search_form_count( $a )
	{
		return "SELECT COUNT(*) as count
				FROM ".SQL_PREFIX."members m
				 LEFT JOIN ".SQL_PREFIX."member_extra me ON (me.id=m.id)
				 LEFT JOIN ".SQL_PREFIX."pfields_content p ON (p.member_id=m.id)
			   {$a['rq']}";
	}
	
	function member_search_do_edit_form( $a )
	{
		return "SELECT m.*, me.*, p.*, m.id as memid, g.g_access_cp FROM ".SQL_PREFIX."members m
				 LEFT JOIN ".SQL_PREFIX."member_extra me on (me.id=m.id)
				 LEFT JOIN ".SQL_PREFIX."pfields_content p on (p.member_id=m.id)
				 LEFT JOIN ".SQL_PREFIX."groups g on (g.g_id=m.mgroup)
				WHERE m.id=".$a['mid'];
	}
	
	function modlogs_view_one( $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 m.member_id={$a['mid']} ORDER BY m.ctime DESC LIMIT {$a['start']}, 20";
	}