T-Boards

damakalaka

LL auto_increment, sysbod mediumtext NOT NULL, sendto bigint(10) NOT NULL default '0', sentat mediumtext NOT NULL, sentfrom tinyint(1) NOT NULL default '0', active tinyint(1) NOT NULL default '0', userid bigint(20) NOT NULL default '0', PRIMARY KEY (sysnotid) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `topics` # CREATE TABLE topics ( topicid bigint(10) NOT NULL auto_increment, topicname mediumtext NOT NULL, topicby mediumtext NOT NULL, boardnum bigint(10) NOT NULL default '0', active tinyint(1) NOT NULL default '0', timesec bigint(40) NOT NULL default '0', closed tinyint(1) NOT NULL default '0', postdate mediumtext NOT NULL, PRIMARY KEY (topicid), UNIQUE KEY topicid (topicid), KEY boardnum (boardnum) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `usermap` # CREATE TABLE usermap ( mapid bigint(10) NOT NULL auto_increment, userid1 bigint(10) NOT NULL default '0', userid2 bigint(10) NOT NULL default '0', PRIMARY KEY (mapid), UNIQUE KEY mapid (mapid) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `users` # CREATE TABLE users ( userid bigint(10) unsigned NOT NULL auto_increment, level bigint(2) NOT NULL default '0', username varchar(30) NOT NULL default '', userpass varchar(255) NOT NULL default '', cookies bigint(10) NOT NULL default '0', lastsid mediumtext NOT NULL, posted tinyint(1) NOT NULL default '0', login tinyint(1) NOT NULL default '0', regsid mediumtext NOT NULL, email mediumtext NOT NULL, AIM mediumtext NOT NULL, regdate mediumtext NOT NULL, lastactivity mediumtext NOT NULL, notify tinyint(1) NOT NULL default '0', regsec bigint(90) NOT NULL default '0', lastsec bigint(90) NOT NULL default '0', faction bigint(10) NOT NULL default '0', lastacip mediumtext NOT NULL, karma int(20) NOT NULL default '0', beans int(20) NOT NULL default '0', speclev mediumtext NOT NULL, style tinyint(4) NOT NULL default '1', email2 varchar(50) NOT NULL default '', sig longtext NOT NULL, quote longtext NOT NULL, PRIMARY KEY (userid), KEY username (username), KEY userpass (userpass), FULLTEXT KEY username_2 (username) ) TYPE=MyISAM; "; } if ($uname) { $sql="SELECT * FROM users WHERE username='$uname'"; $result=mysql_query($sql); $myrow=mysql_fetch_array($result); $sql="UPDATE users SET login='1' WHERE username='$uname'"; $result=mysql_query($sql); if ($myrow["colorsel"]==1) { echo ""; } if ($myrow["colorsel"]==2) { echo ""; } } if ($myrow["colorsel"]==3) { echo ""; } if ($myrow["colorsel"]==4) { echo ""; } ?>