[Acmcontester-developers] SF.net SVN: acmcontester:[447] ACMServer/trunk/web

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Revision: 447
          http://acmcontester.svn.sourceforge.net/acmcontester/?rev=447&view=rev
Author:   brus07
Date:     2008-12-12 10:11:40 +0000 (Fri, 12 Dec 2008)

Log Message:
-----------
New version of Web client.
Update table for work with parallel testing (on two TesterSystem).
Small change.

Modified Paths:
--------------
    ACMServer/trunk/web/action.php
    ACMServer/trunk/web/get.php
    ACMServer/trunk/web/insert.php
    ACMServer/trunk/web/submit.php
    ACMServer/trunk/web/table.php

Added Paths:
-----------
    ACMServer/trunk/web/get/
    ACMServer/trunk/web/get/connect.php
    ACMServer/trunk/web/get/diff.php
    ACMServer/trunk/web/get/get.php
    ACMServer/trunk/web/get/getfromold.php
    ACMServer/trunk/web/get/set.php
    ACMServer/trunk/web/get/table.php
    ACMServer/trunk/web/install.php
    ACMServer/trunk/web/start.sql

Removed Paths:
-------------
    ACMServer/trunk/web/update.php
    ACMServer/trunk/web/update3.0.0.1.sql
    ACMServer/trunk/web/update3.0.0.2.sql

Modified: ACMServer/trunk/web/action.php
===================================================================

--- ACMServer/trunk/web/action.php	2008-12-11 14:08:54 UTC (rev 446)
+++ ACMServer/trunk/web/action.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -4,6 +4,14 @@
 	
 	require_once("connect.php");
 	
+	
+	if (isset($delete) && $delete = 1)
+	{
+		$sql = "DELETE FROM `v3_submits` WHERE `id` = ".$id." LIMIT 1;";
+		$result = MySql_Query ($sql);
+		echo "Delete $id<br>";
+	}
+	
 	if (isset($empty) && $empty=1)
 	{
 		$sql = 'UPDATE `v3_submits` SET `result` = NULL WHERE `id` >= '.$from.' AND `id` <= '.$to;


Property changes on: ACMServer/trunk/web/get
___________________________________________________________________
Added: tsvn:logminsize
   + 5

Added: ACMServer/trunk/web/get/connect.php
===================================================================
--- ACMServer/trunk/web/get/connect.php	                        (rev 0)
+++ ACMServer/trunk/web/get/connect.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -0,0 +1,3 @@
+<?php
+	
+	require_once("../connect.php");
\ No newline at end of file

Added: ACMServer/trunk/web/get/diff.php
===================================================================
--- ACMServer/trunk/web/get/diff.php	                        (rev 0)
+++ ACMServer/trunk/web/get/diff.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -0,0 +1,126 @@
+<a href=submit.php>Submit</a><br>
+<a href=get.php>Get</a><br>
+<a href=table.php>Table</a><br>
+<?php
+	if (isset($full) != true || $full != 1)
+	{
+		echo "<a href=\"diff.php?full=1\">Full table</a><br>";
+	}
+	else
+	{
+		echo "<a href=\"diff.php?full=0\">Small table</a><br>";
+	}
+?>
+	
+<?php
+	require_once("connect.php");
+	
+	function getMax()
+	{
+		$sql = 'SELECT MAX(`id`) FROM `v3_submits`';
+		$result = MySql_Query ($sql);
+		while($arr = mysql_fetch_array($result)) {
+			return $arr[0];
+		}
+		return -1;
+	}
+?>
+	
+<FORM action = "../action.php?delete=1" method=post>
+	ID: <INPUT name=id value=-1>
+	<INPUT type=submit value="Delete">
+</FORM>
+
+<FORM action = "../action.php?empty=1" method=post>
+	Empty: <INPUT name=from value=<?php echo getMax();?> >-
+	<INPUT name=to value=<?php echo getMax();?> >
+	<INPUT type=submit value=run>
+</FROM>
+
+
+<?php
+	require_once("connect.php");
+	
+	$Query = "SELECT * FROM `v3_submits` ORDER BY `id` DESC";
+	if (isset($full) != true || $full != 1)
+	{
+		$Query .= " LIMIT 0 , 20;";
+	}
+	
+	$result = MySql_Query ($Query);
+	echo "<table border=1>\n";
+	echo "\t<tr>\n";
+		echo "\t\t<td>";
+			echo "<b>id</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>Problem</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>language</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>result</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>usedMemory</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>usedTime</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>RealStatus</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>RealTimeWorked</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>RealMemoryUsed</b>";
+		echo "</td>\n";
+	echo "\t</tr>\n";
+	while($arr = mysql_fetch_array($result)) {
+		echo "\t<tr>\n";
+		
+			echo "\t\t<td>";
+			$arr[0] = $bodytag = str_replace("\r\n", "<br>", $arr[0]);
+			echo $arr[0];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			$arr[5] = $bodytag = str_replace("\r\n", "<br>", $arr['problemID']);
+			echo $arr[5];
+			echo "</td>\n";
+
+			echo "\t\t<td>";
+			$arr[1] = $bodytag = str_replace("\r\n", "<br>", $arr['language']);
+			echo $arr[1];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			$arr[2] = $bodytag = str_replace("\r\n", "<br>", $arr[2]);
+			echo $arr[2];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr[4]/1000.0;
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr[3]/1000.0;
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr['Status'];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr['TimeWorked'];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr['MemoryUsed'];
+			echo "</td>\n";
+			
+		echo "\t</tr>\n";
+	}
+	echo "</table>\n";

Added: ACMServer/trunk/web/get/get.php
===================================================================
--- ACMServer/trunk/web/get/get.php	                        (rev 0)
+++ ACMServer/trunk/web/get/get.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -0,0 +1,27 @@
+<?php
+	
+	require_once("connect.php");
+	
+	require_once("getfromold.php");
+	
+	$Query = "SELECT `id`, `value`, `problemID`, `language` FROM `v3_submits` WHERE `result` IS NULL;";
+	
+	$result = MySql_Query ($Query);
+	
+	$arr = mysql_fetch_array($result);
+	if ($arr != false)
+	{
+		header('Content-type: text/xml');
+		echo "<?xml version=\"1.0\" encoding=\"utf-16\"?>";
+		echo "<?xml-stylesheet type=\"text/xsl\" href=\"../get.xsl\"?>";
+		echo "<submitList xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">";
+		do{
+			echo "<submit>";
+			echo "<id>".$arr['id']."</id>";
+			echo "<problem>".$arr['problemID']."</problem>";
+			echo "<sourceCode>".htmlspecialchars($arr['value'])."</sourceCode>";
+			echo "<language>".$arr['language']."</language>";
+			echo "</submit>";
+		}while($arr = mysql_fetch_array($result));
+		echo "</submitList>";
+	}
\ No newline at end of file

Added: ACMServer/trunk/web/get/getfromold.php
===================================================================
--- ACMServer/trunk/web/get/getfromold.php	                        (rev 0)
+++ ACMServer/trunk/web/get/getfromold.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -0,0 +1,42 @@
+<?php
+	$sql = 'SELECT SubmitID, submits.problemID, Source, submits.Language, submits.`Status`, submits.TestNumber, submits.TimeWorked, submits.MemoryUsed FROM submits LEFT JOIN v3_submits ON submits.SubmitID = v3_submits.id WHERE submits.`Status` > 0 AND submits.`Status` < 11 AND submits.FirstOnly=0 AND v3_submits.id IS NULL LIMIT 1 ';
+	$result = MySql_Query($sql);
+	if ($result != FALSE)
+	{
+		if ($result = mysql_fetch_array($result))
+		{
+			$id = $result['SubmitID'];
+			$source = $result['Source'];
+			
+			$status = $result['Status'];
+			if ($status == 1)
+				$status = "CompileErr";
+			if ($status == 2)
+				$status = "RealTimeLimit";
+			if ($status == 3)
+				$status = "WrongAnswer";
+			if ($status == 4)
+				$status = "TimeLimit";
+			if ($status == 5)
+				$status = "MemoryLimit";
+			if ($status == 6)
+				$status = "OutputLimit";
+			if ($status == 7)
+				$status = "InternalError";
+			if ($status == 9)
+				$status = "PresentationError";
+			if ($status == 10)
+				$status = "Accepted";
+			$problem = $result['problemID'];
+			$timeWorked = $result['TimeWorked'];
+			$memoryUsed = $result['MemoryUsed'];
+			$language = $result['Language'];
+			if ($language == 3)
+				$language = 1;
+
+			$Query = "INSERT INTO `v3_submits` (`id`, `value`, `result`, `problemID`, `language`, `Status`, `TimeWorked`, `MemoryUsed`)"
+				."VALUES ($id, '".mysql_real_escape_string($source)."', NULL, $problem, $language, '$status', $timeWorked, $memoryUsed);";
+
+			$result = MySql_Query($Query);
+		}
+	}
\ No newline at end of file

Added: ACMServer/trunk/web/get/set.php
===================================================================
--- ACMServer/trunk/web/get/set.php	                        (rev 0)
+++ ACMServer/trunk/web/get/set.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -0,0 +1,16 @@
+<?php
+	
+	require_once("connect.php");
+	
+	if (isset($res) && isset($id))
+	{
+		echo $res;
+		echo "<p>";
+		echo $id;
+		$res = mysql_real_escape_string($res);
+		$Query = "UPDATE `v3_submits` SET `result` = \"$res\", `usedMemory`=$usedMemory, `usedTime`=$usedTime WHERE `result` IS NULL AND `id` = $id LIMIT 1 ;";
+		
+		echo "<p>";
+		echo $Query;
+		$result = MySql_Query ($Query);
+	}
\ No newline at end of file

Added: ACMServer/trunk/web/get/table.php
===================================================================
--- ACMServer/trunk/web/get/table.php	                        (rev 0)
+++ ACMServer/trunk/web/get/table.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -0,0 +1,132 @@
+<a href=../submit.php>Submit</a><br>
+<a href=get.php>Get</a><br>
+<a href=diff.php>Different table</a><br>
+<?php
+	if (isset($full) != true || $full != 1)
+	{
+		echo "<a href=\"table.php?full=1\">Full table</a><br>";
+	}
+	else
+	{
+		echo "<a href=\"table.php?full=0\">Small table</a><br>";
+	}
+?>
+	
+<?php
+	require_once("connect.php");
+	
+	function getMax()
+	{
+		$sql = 'SELECT MAX(`id`) FROM `v3_submits`';
+		$result = MySql_Query ($sql);
+		while($arr = mysql_fetch_array($result)) {
+			return $arr[0];
+		}
+		return -1;
+	}
+?>
+	
+<FORM action = "../action.php?delete=1" method=post>
+	ID: <INPUT name=id value=-1>
+	<INPUT type=submit value="Delete">
+</FORM>
+
+<FORM action = "../action.php?empty=1" method=post>
+	Empty: <INPUT name=from value=<?php echo getMax();?> >-
+	<INPUT name=to value=<?php echo getMax();?> >
+	<INPUT type=submit value=run>
+</FROM>
+
+<?php
+	
+	$Query = "SELECT * FROM `v3_submits` ORDER BY `id` DESC";
+	if (isset($full) != true || $full != 1)
+	{
+		$Query .= " LIMIT 0 , 20;";
+	}
+	
+	$result = MySql_Query ($Query);
+	echo "<table border=1>\n";
+	echo "\t<tr>\n";
+		echo "\t\t<td>";
+			echo "<b>id</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>Problem</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>value</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>language</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>result</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>usedMemory</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>usedTime</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>RealStatus</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>RealTimeWorked</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
+			echo "<b>RealMemoryUsed</b>";
+		echo "</td>\n";
+	echo "\t</tr>\n";
+	while($arr = mysql_fetch_array($result)) {
+		echo "\t<tr>\n";
+		
+			echo "\t\t<td>";
+			$arr[0] = $bodytag = str_replace("\r\n", "<br>", $arr[0]);
+			echo $arr[0];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			$arr[5] = $bodytag = str_replace("\r\n", "<br>", $arr['problemID']);
+			echo $arr[5];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			$arr[1] = $bodytag = str_replace("\r\n", "<br>", htmlentities($arr[1]));
+			echo $arr[1];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			$arr[1] = $bodytag = str_replace("\r\n", "<br>", $arr['language']);
+			echo $arr[1];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			$arr[2] = $bodytag = str_replace("\r\n", "<br>", $arr[2]);
+			echo $arr[2];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr[4]/1000.0;
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr[3]/1000.0;
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr['Status'];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr['TimeWorked'];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr['MemoryUsed'];
+			echo "</td>\n";
+			
+		echo "\t</tr>\n";
+	}
+	echo "</table>\n";

Modified: ACMServer/trunk/web/get.php
===================================================================
--- ACMServer/trunk/web/get.php	2008-12-11 14:08:54 UTC (rev 446)
+++ ACMServer/trunk/web/get.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -2,7 +2,7 @@
 	
 	require_once("connect.php");
 	
-	$Query = "SELECT `id`, `value` FROM `v3_submits` WHERE `result` IS NULL;";
+	$Query = "SELECT `id`, `value`, `problemID`, `language` FROM `v3_submits` WHERE `result` IS NULL;";
 	
 	$result = MySql_Query ($Query);
 	
@@ -11,12 +11,14 @@
 	{
 		header('Content-type: text/xml');
 		echo "<?xml version=\"1.0\" encoding=\"utf-16\"?>";
+		echo "<?xml-stylesheet type=\"text/xsl\" href=\"get.xsl\"?>";
 		echo "<submitList xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">";
 		do{
 			echo "<submit>";
-			echo "<id>".$arr[0]."</id>";
-			echo "<sourceCode>".$arr[1]."</sourceCode>";
-			echo "<language>2</language>";
+			echo "<id>".$arr['id']."</id>";
+			echo "<problem>".$arr['problemID']."</problem>";
+			echo "<sourceCode>".htmlspecialchars($arr['value'])."</sourceCode>";
+			echo "<language>".$arr['language']."</language>";
 			echo "</submit>";
 		}while($arr = mysql_fetch_array($result));
 		echo "</submitList>";

Modified: ACMServer/trunk/web/insert.php
===================================================================
--- ACMServer/trunk/web/insert.php	2008-12-11 14:08:54 UTC (rev 446)
+++ ACMServer/trunk/web/insert.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -7,7 +7,6 @@
 		echo $text;
 		echo "<p>";
 		echo mysql_real_escape_string($text);
-		$Query = "INSERT INTO `v3_submits` ( `id` , `value` , `result` ) VALUES ('', '".mysql_real_escape_string($text)."', NULL);";
-		
+		$Query = "INSERT INTO `v3_submits` ( `id` , `value` , `result`, `problemID`, `language`) VALUES ('', '".mysql_real_escape_string($text)."', NULL, ".$problem.", ".$language.");";
 		$result = MySql_Query ($Query);
 	}

Added: ACMServer/trunk/web/install.php
===================================================================
--- ACMServer/trunk/web/install.php	                        (rev 0)
+++ ACMServer/trunk/web/install.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -0,0 +1,12 @@
+<?php
+	
+	require_once("connect.php");
+
+	$filename = "start.sql";
+	$handle = fopen($filename, "rb");
+	$contents = fread($handle, filesize($filename));
+	fclose($handle);
+	
+	$sql = $contents;
+	
+	$result = MySql_Query ($sql);

Added: ACMServer/trunk/web/start.sql
===================================================================
--- ACMServer/trunk/web/start.sql	                        (rev 0)
+++ ACMServer/trunk/web/start.sql	2008-12-12 10:11:40 UTC (rev 447)
@@ -0,0 +1,31 @@
+-- phpMyAdmin SQL Dump
+-- version 2.6.3-pl1
+-- http://www.phpmyadmin.net
+-- 
+-- \xD5\xEE\xF1\xF2: localhost
+-- \xD7\xE0\xF1 \xF1\xF2\xE2\xEE\xF0\xE5\xED\xED\xFF: \xC3\xF0\xF3 12 2008 \xF0., 11:11
+-- \xC2\xE5\xF0\xF1\xB3\xFF \xF1\xE5\xF0\xE2\xE5\xF0\xE0: 4.0.14
+-- \xC2\xE5\xF0\xF1\xB3\xFF PHP: 4.3.4
+-- 
+-- \xC1\xC4: `acm`
+-- 
+
+-- --------------------------------------------------------
+
+-- 
+-- \xD1\xF2\xF0\xF3\xEA\xF2\xF3\xF0\xE0 \xF2\xE0\xE1\xEB\xE8\xF6\xB3 `v3_submits_se`
+-- 
+
+CREATE TABLE `v3_submits` (
+  `id` int(11) NOT NULL auto_increment,
+  `value` blob NOT NULL,
+  `result` varchar(255) default NULL,
+  `usedMemory` varchar(20) NOT NULL default '',
+  `usedTime` varchar(20) NOT NULL default '',
+  `language` int(11) NOT NULL default '1',
+  `problemID` int(11) NOT NULL default '0',
+  `Status` varchar(255) NOT NULL default '',
+  `TimeWorked` varchar(20) NOT NULL default '',
+  `MemoryUsed` varchar(20) NOT NULL default '',
+  PRIMARY KEY  (`id`)
+) TYPE=MyISAM AUTO_INCREMENT=1 ;

Modified: ACMServer/trunk/web/submit.php
===================================================================
--- ACMServer/trunk/web/submit.php	2008-12-11 14:08:54 UTC (rev 446)
+++ ACMServer/trunk/web/submit.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -1,4 +1,10 @@
 <FORM action = "insert.php" method=post>
-	Text: <br><textarea name=text rows="20" wrap="VIRTUAL" cols="65"></textarea><br>
+	ProblemID: <INPUT name=problem type=edit value="1"><br>
+	LanguageID: 
+	<select  name=language size="1" name="lang" class="textbox">
+		<option value="1" selected="selected">Pascal</option>
+		<option value="2">C++</option>
+	</select><br>
+	SourceCode: <br><textarea name=text rows="20" wrap="VIRTUAL" cols="65"></textarea><br>
 	<INPUT type=submit value=\xC2i\xE4i\xF1\xEB\xE0\xF2\xE8>
 </FROM>
\ No newline at end of file

Modified: ACMServer/trunk/web/table.php
===================================================================
--- ACMServer/trunk/web/table.php	2008-12-11 14:08:54 UTC (rev 446)
+++ ACMServer/trunk/web/table.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -24,6 +24,11 @@
 		return -1;
 	}
 ?>
+	
+<FORM action = "action.php?delete=1" method=post>
+	ID: <INPUT name=id value=-1>
+	<INPUT type=submit value="Delete">
+</FORM>
 
 <FORM action = "action.php?empty=1" method=post>
 	Empty: <INPUT name=from value=<?php echo getMax();?> >-
@@ -46,9 +51,15 @@
 			echo "<b>id</b>";
 		echo "</td>\n";
 		echo "\t\t<td>";
+			echo "<b>Problem</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
 			echo "<b>value</b>";
 		echo "</td>\n";
 		echo "\t\t<td>";
+			echo "<b>language</b>";
+		echo "</td>\n";
+		echo "\t\t<td>";
 			echo "<b>result</b>";
 		echo "</td>\n";
 		echo "\t\t<td>";
@@ -57,22 +68,44 @@
 		echo "\t\t<td>";
 			echo "<b>usedTime</b>";
 		echo "</td>\n";
+		
 	echo "\t</tr>\n";
 	while($arr = mysql_fetch_array($result)) {
 		echo "\t<tr>\n";
-		for ($i=0; $i<3; $i++)
-		{
+		
 			echo "\t\t<td>";
-			$arr[$i] = $bodytag = str_replace("\r\n", "<br>", $arr[$i]);
-			echo $arr[$i];
+			$arr[0] = $bodytag = str_replace("\r\n", "<br>", $arr[0]);
+			echo $arr[0];
 			echo "</td>\n";
-		}
-		for ($i=3; $i<5; $i++)
-		{
+			
 			echo "\t\t<td>";
-			echo $arr[$i]/1000.0;
+			$arr[5] = $bodytag = str_replace("\r\n", "<br>", $arr['problemID']);
+			echo $arr[5];
 			echo "</td>\n";
-		}
+			
+			echo "\t\t<td>";
+			$arr[1] = $bodytag = str_replace("\r\n", "<br>", htmlentities($arr[1]));
+			echo $arr[1];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			$arr[1] = $bodytag = str_replace("\r\n", "<br>", $arr['language']);
+			echo $arr[1];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			$arr[2] = $bodytag = str_replace("\r\n", "<br>", $arr[2]);
+			echo $arr[2];
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr[4]/1000.0;
+			echo "</td>\n";
+			
+			echo "\t\t<td>";
+			echo $arr[3]/1000.0;
+			echo "</td>\n";
+			
 		echo "\t</tr>\n";
 	}
 	echo "</table>\n";

Deleted: ACMServer/trunk/web/update.php
===================================================================
--- ACMServer/trunk/web/update.php	2008-12-11 14:08:54 UTC (rev 446)
+++ ACMServer/trunk/web/update.php	2008-12-12 10:11:40 UTC (rev 447)
@@ -1,7 +0,0 @@
-<?php
-	
-	require_once("connect.php");
-	 
-	$sql = 'ALTER TABLE `v3_submits` CHANGE `value` `value` BLOB NOT NULL';
-	
-	$result = MySql_Query ($sql);
\ No newline at end of file

Deleted: ACMServer/trunk/web/update3.0.0.1.sql
===================================================================
--- ACMServer/trunk/web/update3.0.0.1.sql	2008-12-11 14:08:54 UTC (rev 446)
+++ ACMServer/trunk/web/update3.0.0.1.sql	2008-12-12 10:11:40 UTC (rev 447)
@@ -1,5 +0,0 @@
---
--- Insert new column to table
---
-ALTER TABLE `v3_submits` ADD `usedMemory` VARCHAR( 20 ) NOT NULL ,
-ADD `usedTime` VARCHAR( 20 ) NOT NULL ;
\ No newline at end of file

Deleted: ACMServer/trunk/web/update3.0.0.2.sql
===================================================================
--- ACMServer/trunk/web/update3.0.0.2.sql	2008-12-11 14:08:54 UTC (rev 446)
+++ ACMServer/trunk/web/update3.0.0.2.sql	2008-12-12 10:11:40 UTC (rev 447)
@@ -1,5 +0,0 @@
---
--- Change type and length of field 'value'
---
-
-ALTER TABLE `v3_submits` CHANGE `value` `value` BLOB NOT NULL
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


