OXPUS.de

Code: Alles auswählen

<?
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);
define('DOWNLOADS_TABLE', $table_prefix.'downloads');
define('DL_CAT_TABLE', $table_prefix.'downloads_cat');

$sql=array(
'CREATE TABLE '.DOWNLOADS_TABLE.' (
                        id int(11) auto_increment,
                        description varchar(255),
                        file_name varchar(255),
                        klicks int(11) default \'0\',
                        free tinyint(1) default \'0\',
                        extern tinyint(1) default \'0\',
                        long_desc text,
                        sort int(11) default \'0\',
                        cat int(11) default \'0\',
                        PRIMARY KEY  (id)) ',

'CREATE TABLE '.DL_CAT_TABLE.' (
                        id int(11) auto_increment,
                        path varchar(255),
                        cat_name varchar(255),
                        sort int(11) default \'0\',
                        description text,
                        PRIMARY KEY  (id)) ',

'ALTER TABLE '.USERS_TABLE.' ADD user_traffic INT(255) DEFAULT 0 '
);

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);

if ( $userdata['user_level'] != ADMIN )
      message_die(GENERAL_ERROR, "You are not Authorised to do this"); 
$n=0;
while($sql[$n])
{
	if(!$result = $db->sql_query($sql[$n])) 
	$message.="<font color=red>Failed to update: ".($n+1)." , ".$sql[$n]."</font><br />";
	else $message.="<font color=green>Success: ".($n+1)." , ".$sql[$n]."</font><br />";
	$n++;
}
 message_die(GENERAL_MESSAGE, $message); 
?>