Full Radio Panel! Better The RadioPanels - Download Now

Nick. · 20-04-2006, 07:55 AM

Originally Posted by Creamcheese06

it goes this way:

Louis Collins made it for Nkay
Nkay gave it out
I bought it from Louis
I modded all of it

Riiiiiiiiiiiiight. I'm not gonna believe that for the reason that I heard ThinkHabbo stole it from HabboFM. I HEARD this.

But meh, I haven't tried to install it as my DJ Panel is intergrated to my site. So when they login to the User System DJ's get extra options etc.

~~the wombats~~ · 20-04-2006, 07:59 AM

I remember Bobboid having that, well one from your site. The shift key got abused on that also. But I can remember it working perfect then....

-::Mr.Dave::- · 20-04-2006, 09:03 AM

anyone got a fixed version of this panel

Bomb-Head · 20-04-2006, 10:47 AM

Yay, mines working now. Thanx for the help mini-man. And well done creameh, it rocks

~~Liam.~~ · 20-04-2006, 11:21 AM

Mine don't lol, can't create the tables, errors.

-::Mr.Dave::- · 20-04-2006, 11:25 AM

yeh theres to many errors none of it works just post the original made by louis collins

-::Mr.Dave::- · 20-04-2006, 12:49 PM

the sql is the main problem. just use the code from louises original

~~Dentafrice1~~ · 20-04-2006, 01:51 PM

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 20, 2006 at 09:56 AM
-- Server version: 4.1.18
-- PHP Version: 4.3.11
--

--

-- --------------------------------------------------------

--
-- Table structure for table `adminmsg`
--

CREATE TABLE IF NOT EXISTS `adminmsg` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) NOT NULL default '',
`comment` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

--
-- Table structure for table `alert`
--

CREATE TABLE IF NOT EXISTS `alert` (
`ID` int(11) NOT NULL auto_increment,
`message` text NOT NULL,
`name` varchar(100) NOT NULL default '',
`active` varchar(200) NOT NULL default '',
`direct` varchar(100) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=302 ;

-- --------------------------------------------------------

--
-- Table structure for table `alerts`
--

CREATE TABLE IF NOT EXISTS `alerts` (
`id` int(225) NOT NULL auto_increment,
`sender` varchar(225) NOT NULL default '',
`sip` varchar(225) NOT NULL default '',
`msg` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `application`
--

CREATE TABLE IF NOT EXISTS `application` (
`status` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `banned_songs`
--

CREATE TABLE IF NOT EXISTS `banned_songs` (
`id` int(11) NOT NULL auto_increment,
`Song` text NOT NULL,
`From` text NOT NULL,
`Long` text NOT NULL,
`Reason` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `config`
--

CREATE TABLE IF NOT EXISTS `config` (
`config_name` varchar(20) NOT NULL default '',
`config_value` varchar(20) NOT NULL default '',
`config_type_1` varchar(20) NOT NULL default '',
`config_value_2` varchar(50) NOT NULL default '',
`config_type_2` varchar(20) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `friday`
--

CREATE TABLE IF NOT EXISTS `friday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `hellos`
--

CREATE TABLE IF NOT EXISTS `hellos` (
`id` int(11) NOT NULL auto_increment,
`message` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=86 ;

-- --------------------------------------------------------

--
-- Table structure for table `ipban`
--

CREATE TABLE IF NOT EXISTS `ipban` (
`ID` int(11) NOT NULL default '0',
`IP` varchar(15) NOT NULL default '',
`Username` text NOT NULL,
`Reason` text NOT NULL,
`Banned` text NOT NULL,
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `maintanance`
--

CREATE TABLE IF NOT EXISTS `maintanance` (
`status` varchar(200) character set armscii8 collate armscii8_bin NOT NULL default '',
`reason` text NOT NULL,
`title` text NOT NULL,
`image` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `missslot`
--

CREATE TABLE IF NOT EXISTS `missslot` (
`id` int(11) NOT NULL auto_increment,
`Username` varchar(225) NOT NULL default '',
`Time` text NOT NULL,
`Day` text NOT NULL,
`Reason` text NOT NULL,
`Cover` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `monday`
--

CREATE TABLE IF NOT EXISTS `monday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
`ID` int(11) NOT NULL auto_increment,
`NoticeTitle` text NOT NULL,
`NoticeMessage` text NOT NULL,
`NoticeDAT` text NOT NULL,
`IP` int(11) NOT NULL default '0',
`NoticeUsername` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

-- --------------------------------------------------------

--
-- Table structure for table `notices`
--

CREATE TABLE IF NOT EXISTS `notices` (
`ID` int(11) NOT NULL auto_increment,
`NoticeTitle` text NOT NULL,
`NoticeMessage` text NOT NULL,
`NoticeDAT` text NOT NULL,
`IP` int(11) NOT NULL default '0',
`NoticeUsername` text NOT NULL,
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `officialdjs`
--

CREATE TABLE IF NOT EXISTS `officialdjs` (
`ID` int(11) NOT NULL auto_increment,
`NoticeMessage` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `permfriday`
--

CREATE TABLE IF NOT EXISTS `permfriday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `permmonday`
--

CREATE TABLE IF NOT EXISTS `permmonday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `permsaturday`
--

CREATE TABLE IF NOT EXISTS `permsaturday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `permsunday`
--

CREATE TABLE IF NOT EXISTS `permsunday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `permthursday`
--

CREATE TABLE IF NOT EXISTS `permthursday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `permtuesday`
--

CREATE TABLE IF NOT EXISTS `permtuesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `permwednesday`
--

CREATE TABLE IF NOT EXISTS `permwednesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `pm`
--

CREATE TABLE IF NOT EXISTS `pm` (
`id` varchar(50) NOT NULL default '',
`ip` varchar(50) NOT NULL default '',
`send_to` varchar(50) NOT NULL default '',
`send_from` varchar(50) NOT NULL default '',
`message` text NOT NULL,
`date` varchar(50) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `privmsgs`
--

CREATE TABLE IF NOT EXISTS `privmsgs` (
`msg_id` int(10) NOT NULL auto_increment,
`msg_title` varchar(100) NOT NULL default '',
`msg_txt` text NOT NULL,
`msg_read` int(1) NOT NULL default '0',
`msg_date` varchar(12) NOT NULL default '0000-00-00',
`msg_time` varchar(100) NOT NULL default '',
`msg_ip` varchar(20) NOT NULL default '',
`msg_to` varchar(50) NOT NULL default '',
`msg_from` varchar(50) NOT NULL default '',
PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `profile`
--

CREATE TABLE IF NOT EXISTS `profile` (
`hname` varchar(25) NOT NULL default '',
`music` varchar(100) NOT NULL default '',
`music2` varchar(100) NOT NULL default '',
`favoritefood` varchar(100) NOT NULL default '',
`hotel` varchar(100) NOT NULL default '',
`staff` varchar(100) NOT NULL default '',
`groom` varchar(100) NOT NULL default '',
`proom` varchar(100) NOT NULL default '',
`friends` varchar(200) NOT NULL default '',
`age` varchar(100) NOT NULL default '',
`song` varchar(200) NOT NULL default '',
`aboutme` text NOT NULL,
`favoritecolor` varchar(100) NOT NULL default '',
`favoriteday` varchar(100) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`address` text NOT NULL,
`rank` varchar(100) NOT NULL default '',
`avatar` varchar(100) NOT NULL default '',
`status` varchar(50) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `promotion`
--

CREATE TABLE IF NOT EXISTS `promotion` (
`id` int(11) NOT NULL auto_increment,
`yourname` text NOT NULL,
`djname` text NOT NULL,
`djreason` text NOT NULL,
`IP` int(11) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `radioinfo`
--

CREATE TABLE IF NOT EXISTS `radioinfo` (
`id` int(11) NOT NULL auto_increment,
`Radio_IP` text NOT NULL,
`Radio_Port` text NOT NULL,
`Radio_Password` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

-- --------------------------------------------------------

--
-- Table structure for table `requests`
--

CREATE TABLE IF NOT EXISTS `requests` (
`id` int(11) NOT NULL auto_increment,
`habboname` varchar(225) NOT NULL default '',
`type` varchar(225) NOT NULL default '',
`dj_name` varchar(225) NOT NULL default '',
`message` text NOT NULL,
`date` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
`report` tinyint(1) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=853 ;

-- --------------------------------------------------------

--
-- Table structure for table `requests2`
--

CREATE TABLE IF NOT EXISTS `requests2` (
`id` int(11) NOT NULL auto_increment,
`habboname` varchar(225) NOT NULL default '',
`type` varchar(225) NOT NULL default '',
`dj_name` varchar(225) NOT NULL default '',
`message` text NOT NULL,
`date` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
`report` tinyint(1) NOT NULL default '0',
`email` text NOT NULL,
`example` text NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1043 ;

-- --------------------------------------------------------

--
-- Table structure for table `rooms`
--

CREATE TABLE IF NOT EXISTS `rooms` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`message` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=124 ;

-- --------------------------------------------------------

--
-- Table structure for table `saturday`
--

CREATE TABLE IF NOT EXISTS `saturday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `shoutout`
--

CREATE TABLE IF NOT EXISTS `shoutout` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) NOT NULL default '',
`comment` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Table structure for table `shows`
--

CREATE TABLE IF NOT EXISTS `shows` (
`name` text NOT NULL,
`dj` text NOT NULL,
`day` text NOT NULL,
`time` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `sitenews`
--

CREATE TABLE IF NOT EXISTS `sitenews` (
`ID` int(11) NOT NULL auto_increment,
`NoticeTitle` text NOT NULL,
`NoticeMessage` text NOT NULL,
`NoticeDAT` text NOT NULL,
`NoticeTIM` text NOT NULL,
`IP` int(11) NOT NULL default '0',
`NoticeUsername` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=79 ;

-- --------------------------------------------------------

--
-- Table structure for table `slotrequest`
--

CREATE TABLE IF NOT EXISTS `slotrequest` (
`id` int(11) NOT NULL auto_increment,
`Username` varchar(225) NOT NULL default '',
`Day` text NOT NULL,
`Time` text NOT NULL,
`ShowName` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `special`
--

CREATE TABLE IF NOT EXISTS `special` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `staff`
--

CREATE TABLE IF NOT EXISTS `staff` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) NOT NULL default '',
`password` text NOT NULL,
`email` text NOT NULL,
`level` int(1) NOT NULL default '0',
`ban` int(1) NOT NULL default '0',
`lastlogin` varchar(225) NOT NULL default 'never',
`ip` varchar(15) NOT NULL default '',
`avatar` text NOT NULL,
UNIQUE KEY `id` (`id`),
FULLTEXT KEY `password` (`password`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=220 ;

-- --------------------------------------------------------

--
-- Table structure for table `staff_chat`
--

CREATE TABLE IF NOT EXISTS `staff_chat` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(225) NOT NULL default '',
`message` text NOT NULL,
`time` time NOT NULL default '00:00:00',
`ip` varchar(15) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `staffchat`
--

CREATE TABLE IF NOT EXISTS `staffchat` (
`id` tinyint(10) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`body` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `status`
--

CREATE TABLE IF NOT EXISTS `status` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `sunday`
--

CREATE TABLE IF NOT EXISTS `sunday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `thursday`
--

CREATE TABLE IF NOT EXISTS `thursday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `top`
--

CREATE TABLE IF NOT EXISTS `top` (
`id` int(10) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`artist` varchar(255) NOT NULL default '',
`album` varchar(255) NOT NULL default '',
`votes` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `topnotices`
--

CREATE TABLE IF NOT EXISTS `topnotices` (
`ID` int(11) NOT NULL auto_increment,
`NoticeMessage` text NOT NULL,
`IP` int(11) NOT NULL default '0',
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Table structure for table `tuesday`
--

CREATE TABLE IF NOT EXISTS `tuesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `users_online`
--

CREATE TABLE IF NOT EXISTS `users_online` (
`id` int(11) NOT NULL default '0',
`username` varchar(225) NOT NULL default '',
`time` text NOT NULL,
`url` text NOT NULL,
`kick` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `wednesday`
--

CREATE TABLE IF NOT EXISTS `wednesday` (
`id` varchar(225) NOT NULL default '',
`a` varchar(225) NOT NULL default '',
`b` varchar(225) NOT NULL default '',
`c` varchar(225) NOT NULL default '',
`d` varchar(225) NOT NULL default '',
`e` varchar(225) NOT NULL default '',
`f` varchar(225) NOT NULL default '',
`x` varchar(225) NOT NULL default '',
`g` varchar(225) NOT NULL default '',
`h` varchar(225) NOT NULL default '',
`i` varchar(225) NOT NULL default '',
`j` varchar(225) NOT NULL default '',
`k` varchar(225) NOT NULL default '',
`l` varchar(225) NOT NULL default '',
`m` varchar(225) NOT NULL default '',
`n` varchar(225) NOT NULL default '',
`o` varchar(225) NOT NULL default '',
`p` varchar(225) NOT NULL default '',
`q` varchar(225) NOT NULL default '',
`r` varchar(225) NOT NULL default '',
`s` varchar(225) NOT NULL default '',
`t` varchar(225) NOT NULL default '',
`u` varchar(225) NOT NULL default '',
`v` varchar(225) NOT NULL default '',
`w` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

~~Liam.~~ · 20-04-2006, 01:59 PM

Still dont work for me

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=8' at line 26

Splinter · 20-04-2006, 02:05 PM

the SQL manager is just asking to be owned in my opinion because you just need to use a delete query and its all over.. saying that I also see no protection for SQL injection so not very secure..

Also you have used $PHP_SELF for form submission which wont work on most server since its now $_SERVER['PHP_SELF'];

Thread: Full Radio Panel! Better The RadioPanels - Download Now

Thread Tools

Posting Permissions