1 rizwank 1.1 <?php
 2             //get set
 3             include('./config.php');
 4             
 5             // get authorised
 6             include('./validate.php');
 7             
 8             // get connected
 9             include('./database.php');
10             
11             ?>
12             <?php
13             
14             // so i guess first that we need to check that a category with this name doesn't already exist.
15             
16             $results = mysql_list_tables($mysqdb['name']) or die("Invalid request: " . mysql_error());
17             
18             while ($row = mysql_fetch_row($results)) {
19              $cats[] = $row[0]; 	
20             }
21             		
22 rizwank 1.1 mysql_free_result($results);
23             
24             if(in_array($HTTP_POST_VARS['new_category_name'],$cats)) {
25             		$go = "Location: " . $mysqvars[url] . "/admin.php?func=1&msg=98"; 
26             		header($go);
27             } else {
28             		$query = "CREATE TABLE `$HTTP_POST_VARS[new_category_name]` (`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,`url` TEXT NOT NULL ,`title` TEXT NOT NULL ,`extras` TEXT NOT NULL , `status` ENUM( '0', '1' ) DEFAULT '1' NOT NULL) COMMENT = '$HTTP_POST_VARS[new_category_desc]'";
29             		 $results = mysql_query($query) or die("Invalid request: " . mysql_error());
30             		 $go = "Location: " . $mysqvars[url] . "/admin.php?msg=99"; 
31             		header($go);
32             }			 
33             
34             ?>