Full Radio Panel! Better The RadioPanels - Download Now

Bomb-Head · 19-04-2006, 10:54 PM

Does anybody know how to fix this?

~~Sygon.~~ · 19-04-2006, 10:57 PM

Answer my question ffs cream, paste tables herepls

Bomb-Head · 19-04-2006, 11:00 PM

The SQL file:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 19, 2006 at 05:23 PM
-- Server version: 4.1.18
-- PHP Version: 4.3.11
--
-- Database: ``
--

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

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

CREATE TABLE `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 `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=298 ;

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

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

CREATE TABLE `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 `application` (
`status` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `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 `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 `hellos`
--

CREATE TABLE `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=83 ;

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

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

CREATE TABLE `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 `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 `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 `news`
--

CREATE TABLE `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 `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 `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 `pm`
--

CREATE TABLE `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 `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 `promotion`
--

CREATE TABLE `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 `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 `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 `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=1041 ;

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

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

CREATE TABLE `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=121 ;

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

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

CREATE TABLE `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=6 ;

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

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

CREATE TABLE `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 `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=78 ;

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

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

CREATE TABLE `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 `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 `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=218 ;

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

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

CREATE TABLE `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=2 ;

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

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

CREATE TABLE `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 `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 `top`
--

CREATE TABLE `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 `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=3 ;

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

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

CREATE TABLE `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;

Do eack of them queries need to be run or does it do them its self?

~~Sygon.~~ · 19-04-2006, 11:10 PM

Whatsql error do you get when u enter it?

Bomb-Head · 19-04-2006, 11:18 PM

Its ok now lol it seems to be working for some reason :p But know when i go to the index page, as there was no set up i dont know what details to enter. theres no username in the drop down box. any suggestions ?

~~Dentafrice1~~ · 20-04-2006, 12:20 AM

Mines messed up now too!

Invent · 20-04-2006, 02:23 AM

;o I can help!

Ok if you get no users, open up PhpMyAdmin which you should have on your server. Find your database, open up the 'Staff' table and click SQL, and paste this code:

Code:

INSERT INTO `staff` VALUES ('1', 'admin', '4cb9c8a8048fd02294477fcb1a41191a', '[email protected]', '1', '0', '', '', '');

this creates the user 'admin' with the password 'changeme'. The user is an administrator aswell. ^_^ For people about to set the system up and are ready to paste the WHOLE SQL Export. Then use this instead, as it makes the user aswell

Code:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 19, 2006 at 05:23 PM
-- Server version: 4.1.18
-- PHP Version: 4.3.11
-- 
-- Database: ``
-- 

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

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

CREATE TABLE `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 `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=298 ;

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

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

CREATE TABLE `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 `application` (
  `status` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `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 `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 `hellos`
-- 

CREATE TABLE `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=83 ;

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

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

CREATE TABLE `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 `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 `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 `news`
-- 

CREATE TABLE `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 `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 `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 `pm`
-- 

CREATE TABLE `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 `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 `promotion`
-- 

CREATE TABLE `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 `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 `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 `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=1041 ;

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

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

CREATE TABLE `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=121 ;

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

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

CREATE TABLE `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=6 ;

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

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

CREATE TABLE `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 `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=78 ;

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

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

CREATE TABLE `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 `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 `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=218 ;

--
-- Mini-Mans help ^_^
--

INSERT INTO `staff` VALUES ('1', 'admin', '4cb9c8a8048fd02294477fcb1a41191a', '[email protected]', '1', '0', '', '', '');

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

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

CREATE TABLE `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=2 ;

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

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

CREATE TABLE `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 `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 `top`
-- 

CREATE TABLE `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 `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=3 ;

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

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

CREATE TABLE `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;

Im sure this will work, as it did for me

EDIT: I have installed the Panel on my website and well, I dont think you compiled it properly. I have alot of errors!

~~Dentafrice1~~ · 20-04-2006, 02:32 AM

yea

i tried

Invent · 20-04-2006, 02:33 AM

Did you make the DJ Panel. As it is the exact same as ClubHabbo's and on club habbo's it says credit to Nkay for it...

~~Dentafrice1~~ · 20-04-2006, 02:35 AM

it goes this way:

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

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

Thread Tools

Posting Permissions