<?php
include "maincore.php";
include "subheader.php";
opentable("SQL query");
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."forum_nmember");
$result = dbquery("CREATE TABLE ".$db_prefix."forum_nmember (
forum_lev_id smallint(5) unsigned NOT NULL auto_increment,
forum_mpost smallint(5) unsigned NOT NULL default '0',
forum_mlevel varchar(32) NOT NULL default '',
forum_level char(1) NOT NULL default '',
PRIMARY KEY (forum_lev_id)
) TYPE=MyISAM AUTO_INCREMENT=7");
if (!$result) {echo mysql_error()." = 1<br>";}
$result2 = dbquery("INSERT INTO ".$db_prefix."forum_nmember VALUES ('1', '10', 'Newbie', '1')");
if (!$result2) {echo mysql_error()." = 2<br>";}
$result3 = dbquery("INSERT INTO ".$db_prefix."forum_nmember VALUES (2, 25, 'Member', '2')");
if (!$result3) {echo mysql_error()." = 3<br>";}
$result4 = dbquery("INSERT INTO ".$db_prefix."forum_nmember VALUES (3, 100, 'Advenced member', '3')");
if (!$result4) {echo mysql_error()." = 4<br>";}
$result5 = dbquery("INSERT INTO ".$db_prefix."forum_nmember VALUES (4, 150, 'Gold member', '4')");
if (!$result5) {echo mysql_error()." = 5<br>";}
$result6 = dbquery("INSERT INTO ".$db_prefix."forum_nmember VALUES (6, 200, 'Silver member', '5')");
if (!$result6) {echo mysql_error()." = 6<br>";}
$result7_1 = dbquery("ALTER TABLE ".$db_prefix."users DROP user_mlevel");
if (!$result7_1) {echo mysql_error()." = 7_1<br>";}
$result7 = dbquery("ALTER TABLE ".$db_prefix."users ADD user_mlevel VARCHAR( 32 ) NOT NULL AFTER user_level");
if (!$result7) {echo mysql_error()." = 7<br>";}
if (!$result && !$result2 && !$result3 && !$result4 && !$result5 && !$result6 && !$result7_1 && !$result7){
echo "<center><font color='red'>Error in query, look number.</font></center>";
} else {
echo "<center><font color='green'>Create, insert, alter = OK!</font></center>";
}
closetable();
include "footer.php";
?>
