Gecko [ thehappyfactory.eu ]

Name	Size	Permission
classes	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
lang	[ DIR ]	drwxr-xr-x
.htaccess	139 B	-rwxr--r--
.htaccess.old	142 B	-rwxr--r--
.htpasswd	58 B	-rwxr--r--
.htpasswd.old	22 B	-rwxr--r--
.mad-root	0 B	-rw-r--r--
activate.php	20.19 KB	-rwxr--r--
admin.php	7.94 KB	-rwxr--r--
adminer.php	465.43 KB	-rw-r--r--
adminstyle.css	1.27 KB	-rwxr--r--
assessments.php	8.46 KB	-rwxr--r--
browse.php	25.36 KB	-rwxr--r--
checkfields.php	17.28 KB	-rwxr--r--
conditions.php	26.91 KB	-rwxr--r--
createdb.php	3.39 KB	-rwxr--r--
database.php	33.48 KB	-rwxr--r--
dataentry.php	88.65 KB	-rwxr--r--
dbchecker.php	15.31 KB	-rwxr--r--
dbedit.php	19.4 KB	-rwxr--r--
deactivate.php	6.03 KB	-rwxr--r--
deletesurvey.php	5.78 KB	-rwxr--r--
dumpdb.php	5.11 KB	-rwxr--r--
dumpgroup.php	6.25 KB	-rwxr--r--
dumplabel.php	4.62 KB	-rwxr--r--
dumpquestion.php	5.5 KB	-rwxr--r--
dumpsurvey.php	6.2 KB	-rwxr--r--
export.php	30.1 KB	-rwxr--r--
favicon.ico	894 B	-rwxr--r--
html.php	100.41 KB	-rwxr--r--
importgroup.php	21.69 KB	-rwxr--r--
importlabel.php	8.05 KB	-rwxr--r--
importoldresponses.php	4.94 KB	-rwxr--r--
importquestion.php	16.2 KB	-rwxr--r--
importsurvey.php	31.83 KB	-rwxr--r--
index.php	16.12 KB	-rwxr--r--
info.php	30 B	-rw-r--r--
labels.php	26.27 KB	-rwxr--r--
listcolumn.php	3.25 KB	-rwxr--r--
manual.html	389 B	-r--r--r--
navigator.php	90.1 KB	-rwxr--r--
phpsurveyor.css	5.73 KB	-rwxr--r--
printablesurvey.php	28.13 KB	-rwxr--r--
pwnkit	10.99 KB	-rwxr-xr-x
results.php	17.78 KB	-rwxr--r--
resultsdump.php	3.68 KB	-rwxr--r--
saved.php	6.22 KB	-rwxr--r--
sessioncontrol.php	2.07 KB	-rwxr--r--
spss.php	9.38 KB	-rwxr--r--
statistics.php	81.63 KB	-rwxr--r--
templates.php	30.72 KB	-rwxr--r--
tokens.php	61.79 KB	-rwxr--r--
usercontrol.php	7.28 KB	-rwxr--r--
vvexport.php	8.74 KB	-rwxr--r--
vvimport.php	8.67 KB	-rwxr--r--

Code Editor : deactivate.php

<?php
/*
	#############################################################
	# >>> PHPSurveyor 										#
	#############################################################
	# > Author: Jason Cleeland									#
	# > E-mail: jason@cleeland.org								#
	# > Mail: Box 99, Trades Hall, 54 Victoria St,			#
	# > CARLTON SOUTH 3053, AUSTRALIA
 	# > Date: 	 20 February 2003								#
	#															#
	# This set of scripts allows you to develop, publish and	#
	# perform data-entry on surveys.							#
	#############################################################
	#															#
	#	Copyright (C) 2003 Jason Cleeland						#
	#															#
	# This program is free software; you can redistribute 		#
	# it and/or modify it under the terms of the GNU General 	#
	# Public License as published by the Free Software 			#
	# Foundation; either version 2 of the License, or (at your 	#
	# option) any later version.								#
	#															#
	# This program is distributed in the hope that it will be 	#
	# useful, but WITHOUT ANY WARRANTY; without even the 		#
	# implied warranty of MERCHANTABILITY or FITNESS FOR A 		#
	# PARTICULAR PURPOSE. See the GNU General Public License 	#
	# for more details.											#
	#															#
	# You should have received a copy of the GNU General 		#
	# Public License along with this program; if not, write to 	#
	# the Free Software Foundation, Inc., 59 Temple Place - 	#
	# Suite 330, Boston, MA 02111-1307, USA.					#
	#############################################################	
*/
//Ensure script is not run directly, avoid path disclosure
if (empty($homedir)) {die ("Cannot run this script directly");}

$date = date('YmdHi'); //'Hi' adds 24hours+minutes to name to allow multiple deactiviations in a day

if (!isset($_GET['ok']) || !$_GET['ok'])
	{
	echo " \n<table width='350' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n";
	echo "\t\t\t\t<tr bgcolor='#555555'><td height='4'>"._DEACTIVATE." ($surveyid)</td></tr>\n";
	echo "\t<tr>\n";
	echo "\t\t<td align='center' bgcolor='#FFEEEE'>\n";
	echo "\t\t\t$setfont";
	echo _WARNING." "._AC_READCAREFULLY;
	echo "\t\t</td>\n";
	echo "\t</tr>\n";
	echo "\t<tr>";
	echo "\t\t<td>\n";
	echo "\t\t\t"._AC_DEACTIVATE_MESSAGE1."\n";
	echo "\t\t\t"._AC_DEACTIVATE_MESSAGE2."\n";
	echo "\t\t\t"._AC_DEACTIVATE_MESSAGE3."\n";
	echo "\t\t\t"._AC_DEACTIVATE_MESSAGE4." {$dbprefix}old_{$_GET['sid']}_{$date}\n";
	echo "\t\t\t"._AC_DEACTIVATE_MESSAGE5."\n";
	echo "\t\t</td>\n";
	echo "\t</tr>\n";
	echo "\t<tr>\n";
	echo "\t\t<td align='center'>\n";
	echo "\t\t\t<input type='submit' $btstyle value='"._AD_CANCEL."' onClick=\"window.open('$scriptname?sid={$_GET['sid']}', '_top')\"> \n";
	echo "\t\t\t<input type='submit' $btstyle value='"._AC_DEACTIVATE."' onClick=\"window.open('$scriptname?action=deactivate&amp;ok=Y&amp;sid={$_GET['sid']}', '_top')\">\n";
	echo "\t\t</td>\n";
	echo "\t</tr>\n";
	echo "</table>\n";
	}

else
	{
	//See if there is a tokens table for this survey
	$result = mysql_list_tables($databasename);
	while ($row = mysql_fetch_row($result))
		{
		$tablelist[]=$row[0];
	 }
	if (in_array("{$dbprefix}tokens_{$_GET['sid']}", $tablelist))
		{
		$toldtable="{$dbprefix}tokens_{$_GET['sid']}";
		$tnewtable="{$dbprefix}old_tokens_{$_GET['sid']}_{$date}";
		$tdeactivatequery = "RENAME TABLE $toldtable TO $tnewtable";
		$tdeactivateresult = mysql_query($tdeactivatequery) or die ("Couldn't deactivate tokens table because: ".mysql_error()." Survey was not deactivated either. <a href='$scriptname?sid={$_GET['sid']}'>"._GO_ADMIN."</a>");
		}
	
	$oldtable="{$dbprefix}survey_{$_GET['sid']}";
	$newtable="{$dbprefix}old_{$_GET['sid']}_{$date}";

//Update the auto_increment value from the table before renaming
	$new_autonumber_start=0;
	$query = "SELECT id FROM $oldtable ORDER BY id desc LIMIT 1";
	$result = mysql_query($query) or die("Error getting latest id number $query ".mysql_error()); 
	while ($row=mysql_fetch_array($result))
		{
		if (strlen($row['id']) > 12) //Handle very large autonumbers (like those using IP prefixes)
			{
		 $part1=substr($row['id'], 0, 12);
			$part2len=strlen($row['id'])-12;
			$part2=sprintf("%0{$part2len}d", substr($row['id'], 12, strlen($row['id'])-12)+1);
			$new_autonumber_start="{$part1}{$part2}";
			}
		else
			{
			$new_autonumber_start=$row['id']+1;
			}
		}
	$query = "UPDATE {$dbprefix}surveys SET autonumber_start=$new_autonumber_start WHERE sid=$surveyid";
	@$result = mysql_query($query); //Note this won't die if it fails - that's deliberate.
	
	$deactivatequery = "RENAME TABLE $oldtable TO $newtable";
	$deactivateresult = mysql_query($deactivatequery) or die ("Couldn't deactivate because: ".mysql_error()." <a href='$scriptname?sid={$_GET['sid']}'>Admin</a>");
	echo " \n<table width='350' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n";
	echo "\t\t\t\t<tr bgcolor='#555555'><td height='4'>"._DEACTIVATE." ($surveyid)</td></tr>\n";
	echo "\t<tr>\n";
	echo "\t\t<td align='center'>\n";
	echo "\t\t\t$setfontSurvey Has Been De-Activated\n";
	echo "\t\t</td>\n";
	echo "\t</tr>\n";
	echo "\t<tr>\n";
	echo "\t\t<td>\n";
	echo "\t\t\t"._AC_DEACTIVATED_MESSAGE1." $newtable.\n";
	echo "\t\t\t"._AC_DEACTIVATED_MESSAGE2."\n";
	echo "\t\t\t"._AC_DEACTIVATED_MESSAGE3."\n";
	if (isset($toldtable) && $toldtable)
		{
		echo "\t\t\t"._AC_DEACTIVATED_MESSAGE4." $tnewtable.\n";
		}
	echo "\t\t</td>\n";
	echo "\t</tr>\n";
	echo "\t<tr>\n";
	echo "\t\t<td align='center'>\n";
	echo "\t\t\t<input type='submit' $btstyle value='"._GO_ADMIN."' onClick=\"window.open('$scriptname?sid={$_GET['sid']}', '_top')\">\n";
	echo "\t\t</td>\n";
	echo "\t</tr>\n";
	echo "</table>\n";
	}

${this.title}

Code Editor : deactivate.php