adm_vote.php

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

<?php
/*
	adm_vote.php

	Version  : 1.0.0
	Author   : Tracemouse ([e-mail])
	Copyright: http://www.vitci.com
	Writed   : 2003/09/10
	Modified : 2003/12/10
*/

require "./common.php";
$file_name='./adm_vote.php';

if((!$delsubmit)&&(!$addsubmit)&&(!$addvotesubmit)&&(!$editsubmit))
{
 	if($action=='optionlist')
 	{
 		$query = $db->query("SELECT COUNT(*) FROM $table_votekeys WHERE vid=$vid");
 		$recnum = $db->result($query, 0);
 		$maxsid=$recnum+1;
 		$reclist = array();
 		$query = $db->query("SELECT * FROM $table_votekeys WHERE vid=$vid order by sid");
 		while($dbq_result = $db->fetch_array($query))
        	{
    		$reclist[] = $dbq_result;
 		}
 		$display = 'option';
 	}
    	elseif($action=='delvote')
    	{
        	$query = $db->query("SELECT COUNT(*) FROM $table_votekeys WHERE vid=$vid");
    		$recnum=$db->result($query,0);
        	if($recnum > 0)
        		gotourl($language['alt_vote_notnull']);
        	else
        	{
        		$sqlstr="DELETE FROM $table_votes WHERE vid=$vid";
            		if($query=$db->query($sqlstr))
    				gotourl($language['delsuccess'],$file_name);
    			else
    				gotourl($language['db_err'].":<br>".$sqlstr);
        	}
    	}
    	else
 	{
 		$query = $db->query("SELECT COUNT(*) FROM $table_votes");
 		$recnum = $db->result($query, 0);
 		$reclist = array();
 		$query = $db->query("SELECT * FROM $table_votes");
 		while($dbq_result = $db->fetch_array($query))
        	{
    			//$dbq_result['multi']=($dbq_result==0)?$language['no']:$language['yes'];
    			$dbq_result['yes_check']=($dbq_result['multi']==0)?"":"checked";
    			$dbq_result['no_check']=($dbq_result['multi']==0)?"checked":"";
    			$reclist[] = $dbq_result;
 		}
 		$display = 'list';
 	}
}
elseif($addvotesubmit)
{
 	$sqlstr="INSERT INTO $table_votes(question,multi,dateline,poster) VALUES('$question',$multi,$timestamp,'$_login_user')";
    	if($query=$db->query($sqlstr))
    		gotourl($language['editsuccess'],$file_name);
    	else
    		gotourl($language['db_err'].":<br>".$sqlstr);
}
elseif($addsubmit)
{
	$sqlstr="INSERT INTO $table_votekeys(vid,sid,options) VALUES($vid,$sid,'$option')";
  	if($query=$db->query($sqlstr))
  		gotourl($language['editsuccess'],$file_name.'?action=optionlist&vid='.$vid.'&question='.$question);
  	else
  		gotourl($language['db_err'].":<br>".$sqlstr);
}
elseif($delsubmit)
{
 	if(is_array($delete)) 
 	{
  		$ids = $comma = "";
  		foreach($delete as $id) 
  		{
    			$ids .= "$comma'$id'";
			$comma = ", ";
   		}
   		$db->query("DELETE FROM $table_votekeys WHERE vid=$vid AND sid IN ($ids)");
  	}
  	gotourl($language['delsuccess'],$file_name.'?action=optionlist&vid='.$vid.'&question='.$question);
}
elseif($editsubmit)
{
	if(is_array($question))
	{
		foreach($question as $key => $value) 
		{
			$sqlstr="update $table_votes set question='$value' where vid = $key";
			if (!($query=$db->query($sqlstr)))	gotourl($language['db_err'].":<br>".$sqlstr);
		}	
	}
	if(is_array($multi))
	{
		foreach($multi as $key => $value) 
		{
			$sqlstr="update $table_votes set multi='$value' where vid = $key";
			if (!($query=$db->query($sqlstr)))	gotourl($language['db_err'].":<br>".$sqlstr);
		}	
	}
	gotourl($language['editsuccess'],$file_name);
	
}

include template('vote');
?>