adm_updatesql.php

这个版本只是修正了一些BUG

<?php
/***********************************************
	adm_updatesql.php

	Version  : 1.2
	Author   : Tracemouse ([e-mail])
	Copyright: www.vitci.com
	Writed   : 2004/12/31
	Modified : 2004/04/19
************************************************/
require "./common.php";
$file_name='./adm_updatesql.php';

if($submit)
{
	$sqltext=stripslashes($sqltext);
	if($query=$db->query($sqltext,1))
    	{
        	if($issaved=='on')
        	{
        		$sqltext=daddslashes($sqltext);
        		$sqlstr="insert into $table_updatesql(sqltext,username,exectime)
            	     			values('$sqltext','$admin_user',$timestamp)";
        		if($query=$db->query($sqlstr,1))
    				gotourl($language['updatesuccess'],$file_name);
        		else
        			gotourl($language['db_err'].":<br>".$sqlstr);
    	}
        else
        	gotourl($language['updatesuccess'],$file_name);
    	}
    	else
    		gotourl($language['db_err'].":<br>".$sqltext);
}
else
{
    	if($action == 'exec')
    	{
        	if($query=$db->query($sqltext,1))
        	{
        		$sqlstr="insert into $table_updatesql(sqltext,username,exectime)
            	     			values('$sqltext','$admin_user',$timestamp)";
        		if($query=$db->query($sqlstr))
    				gotourl($language['updatesuccess'],$file_name);
        		else
        			gotourl($language['db_err'].":<br>".$sqlstr);
        	}
        	else
    			gotourl($language['db_err'].":<br>".$sqltext);
    	}
    	elseif($action == 'del')
    	{
 		$sqlstr="DELETE FROM $table_updatesql WHERE id = $id";
        	if($query=$db->query($sqlstr))
    			gotourl($language['delsuccess'],$file_name);
        	else
        		gotourl($language['db_err'].":<br>".$sqlstr);
    	}
    	else
    	{
    		$query=$db->query("select * from $table_updatesql");
    		$reclist=array();
    		while($dbq_rec=$db->fetch_array($query))
    		{
        		$dbq_rec['exectime']=gmdate($dateformat." ".$timeformat,$dbq_rec['exectime']);
        		$reclist[]=$dbq_rec;
    		}
    		unset($dbq_rec);unset($query);
    	}
}

include template('updatesql');

?>