관리-도구

편집 파일: smtp_control.php

<?php
class Smtpcontrol
{
	var $mysqli;   
	var $dbpref;  
	function __construct($arr)
	{
		$this->mysqli=$arr['mysqli'];
		$this->dbpref=$arr['dbpref'];
	}
	function getSMTP($id,$all=0)
	{
		//get list
		$mysqli=$this->mysqli;
		$pref=$this->dbpref;
		$table=$pref."quick_smtp_setting";
		$id=$mysqli->real_escape_string($id);
		
		if($all==1)
		{
			$qry=$mysqli->query("select * from `".$table."` order by id desc");
			if($qry->num_rows>0)
			{
				return $qry;
			}
			else
			{
				return 0;
			}
		}
		else
		{
			$qry=$mysqli->query("select * from `".$table."` where `id`=".$id."");
			if($qry->num_rows>0)
			{
				return $qry->fetch_object(); 
			}
			else
			{
				return 0;
			}
		}
	}
	function pluginGetSMTPs($data)
	{
	   $mysqli=$this->mysqli;
	   $dbpref=$this->dbpref;
	   $table=$dbpref.'quick_smtp_setting';
	   $arr=array();
	   $qry=$mysqli->query("select * from `".$table."`".$data);
	   while($r=$qry->fetch_assoc())
	   {
		 $r['user_name']=$r['username'];
		 unset($r['username']);
		 $r['host_name']=$r['hostname'];
		 unset($r['hostname']);
		 $r['from_name']=$r['fromname'];
		 unset($r['fromname']);
		 $r['from_email']=$r['fromemail'];
		 unset($r['fromemail']);
		 $r['reply_name']=$r['replyname'];
		 unset($r['replyname']);
		 $r['reply_email']=$r['replyemail'];
		 unset($r['replyemail']);
		 array_push($arr,$r);
	   }
	   return $arr;
	}
}