<?php include ("_mysql.php"); mysql_connect($host, $user, $pwd) or die (`ERROR: keine verbindung zu mysql`); mysql_select_db($db) or die (`ERROR: konnte nicht zu datenbank "`.$db.`" verbinden`); mysql_query("DROP TABLE IF EXISTS ".PREFIX."tut"); mysql_query("CREATE TABLE ".PREFIX."tut ( tutorialsID int(11) NOT NULL auto_increment PRIMARY KEY, date int(14) NOT NULL default `0`, title varchar(255) NOT NULL, tpic varchar(255) NOT NULL, schwier varchar(255) NOT NULL, vorwort text NOT NULL, content text NOT NULL, screens text NOT NULL, poster int(11) NOT NULL, votes int(11) NOT NULL, points int(11) NOT NULL, rating int(11) NOT NULL, saved int(1) NOT NULL, viewed int(11) NOT NULL, comments int(1) NOT NULL ) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=2 "); mysql_query("ALTER TABLE ".PREFIX."user ADD tut TEXT NOT NULL"); safe_query("CREATE TABLE `".PREFIX."tutorials_rubrics` ( `rubricID` int(11) NOT NULL AUTO_INCREMENT, `rubric` varchar(255) NOT NULL DEFAULT ``, `pic` varchar(255) NOT NULL DEFAULT ``, PRIMARY KEY (`rubricID`)) ENGINE=MyISAM;"); safe_query("ALTER TABLE `".PREFIX."tut` ADD `rubric` INT( 11 ) NOT NULL "); chmod("images/articles-rubrics/",0777); echo`<center><h2>TUTORIALS</h2><br><h2><br><br><h2>Installation complete</h2><br><br>Delete install-tutorials.php</center>`; ?> |