-
ok guys those of you with mysql 4.0.xx.xx or below please use this querie
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 02, 2006 at 11:04 PM
-- Server version: 4.1.19
-- PHP Version: 4.3.11
-- --------------------------------------------------------
--
-- Table structure for table `adminmsg`
--
CREATE TABLE `adminmsg` (
`id` int(11) NOT NULL,
`username` varchar(225) NOT NULL default '',
`comment` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
--
-- Dumping data for table `adminmsg`
--
-- --------------------------------------------------------
--
-- Table structure for table `alert`
--
CREATE TABLE `alert` (
`ID` int(11) NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=298 ;
--
-- Dumping data for table `alert`
--
-- --------------------------------------------------------
--
-- Table structure for table `alerts`
--
CREATE TABLE `alerts` (
`id` int(225) NOT NULL,
`sender` varchar(225) NOT NULL default '',
`sip` varchar(225) NOT NULL default '',
`msg` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `alerts`
--
-- --------------------------------------------------------
--
-- Table structure for table `application`
--
CREATE TABLE `application` (
`status` text NOT NULL
) TYPE=MyISAM;
--
-- Dumping data for table `application`
--
-- --------------------------------------------------------
--
-- Table structure for table `banned_songs`
--
CREATE TABLE `banned_songs` (
`id` int(11) NOT NULL,
`Song` text NOT NULL,
`From` text NOT NULL,
`Long` text NOT NULL,
`Reason` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `banned_songs`
--
-- --------------------------------------------------------
--
-- 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 ''
) TYPE=MyISAM;
--
-- Dumping data for table `config`
--
-- --------------------------------------------------------
--
-- Table structure for table `friday`
--
CREATE TABLE `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`)
) TYPE=MyISAM;
--
-- Dumping data for table `friday`
--
INSERT INTO `friday` VALUES ('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `hellos`
--
CREATE TABLE `hellos` (
`id` int(11) NOT NULL,
`message` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=84 ;
--
-- Dumping data for table `hellos`
--
INSERT INTO `hellos` VALUES (83, ',m;;lm''lm;nnnnnnnnnnnnnn', '88.104.18.123');
-- --------------------------------------------------------
--
-- 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`)
) TYPE=MyISAM;
--
-- Dumping data for table `ipban`
--
-- --------------------------------------------------------
--
-- Table structure for table `maintanance`
--
CREATE TABLE `maintanance` (
`status` varchar(200) binary NOT NULL default '',
`reason` text NOT NULL,
`title` text NOT NULL,
`image` text NOT NULL
) TYPE=MyISAM;
--
-- Dumping data for table `maintanance`
--
-- --------------------------------------------------------
--
-- Table structure for table `missslot`
--
CREATE TABLE `missslot` (
`id` int(11) NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;
--
-- Dumping data for table `missslot`
--
-- --------------------------------------------------------
--
-- Table structure for table `monday`
--
CREATE TABLE `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`)
) TYPE=MyISAM;
--
-- Dumping data for table `monday`
--
INSERT INTO `monday` VALUES ('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `news`
--
CREATE TABLE `news` (
`ID` int(11) NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=16 ;
--
-- Dumping data for table `news`
--
-- --------------------------------------------------------
--
-- Table structure for table `notices`
--
CREATE TABLE `notices` (
`ID` int(11) NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;
--
-- Dumping data for table `notices`
--
-- --------------------------------------------------------
--
-- Table structure for table `officialdjs`
--
CREATE TABLE `officialdjs` (
`ID` int(11) NOT NULL,
`NoticeMessage` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `officialdjs`
--
-- --------------------------------------------------------
--
-- 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 ''
) TYPE=MyISAM;
--
-- Dumping data for table `pm`
--
-- --------------------------------------------------------
--
-- Table structure for table `privmsgs`
--
CREATE TABLE `privmsgs` (
`msg_id` int(10) NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `privmsgs`
--
-- --------------------------------------------------------
--
-- Table structure for table `promotion`
--
CREATE TABLE `promotion` (
`id` int(11) NOT NULL,
`yourname` text NOT NULL,
`djname` text NOT NULL,
`djreason` text NOT NULL,
`IP` int(11) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `promotion`
--
-- --------------------------------------------------------
--
-- Table structure for table `radioinfo`
--
CREATE TABLE `radioinfo` (
`id` int(11) NOT NULL,
`Radio_IP` text NOT NULL,
`Radio_Port` text NOT NULL,
`Radio_Password` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;
--
-- Dumping data for table `radioinfo`
--
-- --------------------------------------------------------
--
-- Table structure for table `requests`
--
CREATE TABLE `requests` (
`id` int(11) NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=855 ;
--
-- Dumping data for table `requests`
--
INSERT INTO `requests` VALUES (853, 'dude', 'DJ Request', 'admin', 'test', '2006-06-02 13:59:07', '62.254.0.16', 0);
INSERT INTO `requests` VALUES (854, 'test', 'DJ Request', 'test', 'test', '2006-06-02 14:00:15', '62.254.0.16', 0);
-- --------------------------------------------------------
--
-- Table structure for table `requests2`
--
CREATE TABLE `requests2` (
`id` int(11) NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=1041 ;
--
-- Dumping data for table `requests2`
--
-- --------------------------------------------------------
--
-- Table structure for table `rooms`
--
CREATE TABLE `rooms` (
`id` int(11) NOT NULL,
`name` varchar(100) NOT NULL default '',
`message` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=121 ;
--
-- Dumping data for table `rooms`
--
-- --------------------------------------------------------
--
-- Table structure for table `saturday`
--
CREATE TABLE `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`)
) TYPE=MyISAM;
--
-- Dumping data for table `saturday`
--
INSERT INTO `saturday` VALUES ('1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `shoutout`
--
CREATE TABLE `shoutout` (
`id` int(11) NOT NULL,
`username` varchar(225) NOT NULL default '',
`comment` text NOT NULL,
`IP` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Dumping data for table `shoutout`
--
INSERT INTO `shoutout` VALUES (1, 'Offline!', 'DJ Says Is Not In Use By The Current DJ', '192.168.1.1');
-- --------------------------------------------------------
--
-- Table structure for table `shows`
--
CREATE TABLE `shows` (
`name` text NOT NULL,
`dj` text NOT NULL,
`day` text NOT NULL,
`time` text NOT NULL
) TYPE=MyISAM;
--
-- Dumping data for table `shows`
--
-- --------------------------------------------------------
--
-- Table structure for table `sitenews`
--
CREATE TABLE `sitenews` (
`ID` int(11) NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=78 ;
--
-- Dumping data for table `sitenews`
--
-- --------------------------------------------------------
--
-- Table structure for table `slotrequest`
--
CREATE TABLE `slotrequest` (
`id` int(11) NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `slotrequest`
--
-- --------------------------------------------------------
--
-- 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`)
) TYPE=MyISAM;
--
-- Dumping data for table `special`
--
-- --------------------------------------------------------
--
-- Table structure for table `staff`
--
CREATE TABLE `staff` (
`id` int(11) NOT NULL,
`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`),
KEY `username` (`username`),
FULLTEXT KEY `password` (`password`)
) TYPE=MyISAM AUTO_INCREMENT=221 ;
--
-- Dumping data for table `staff`
--
INSERT INTO `staff` VALUES (1, 'admin', '0ee6cdfe1571e223c62af7134150108c', '[email protected]', 1, 0, '', '', '');
INSERT INTO `staff` VALUES (218, 'Admin', '0ee6cdfe1571e223c62af7134150108c', '', 1, 0, 'never', '', '');
INSERT INTO `staff` VALUES (219, 'test', 'f046918c9a07ca552308cdf5b2b3e1e1', '', 2, 0, 'never', '', '');
INSERT INTO `staff` VALUES (220, 'test1', 'runescape', '', 1, 0, 'never', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `staff_chat`
--
CREATE TABLE `staff_chat` (
`id` int(11) NOT NULL,
`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`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
--
-- Dumping data for table `staff_chat`
--
INSERT INTO `staff_chat` VALUES (2, 'test', 'Hey', '13:30:30', '84.9.113.23');
INSERT INTO `staff_chat` VALUES (3, 'test', 'allo', '13:53:18', '88.104.18.123');
INSERT INTO `staff_chat` VALUES (4, 'test', 'allo', '13:53:18', '88.104.18.123');
-- --------------------------------------------------------
--
-- Table structure for table `staffchat`
--
CREATE TABLE `staffchat` (
`id` tinyint(10) NOT NULL,
`name` varchar(255) NOT NULL default '',
`body` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `staffchat`
--
-- --------------------------------------------------------
--
-- 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`)
) TYPE=MyISAM;
--
-- Dumping data for table `status`
--
-- --------------------------------------------------------
--
-- 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`)
) TYPE=MyISAM;
--
-- Dumping data for table `top`
--
-- --------------------------------------------------------
--
-- Table structure for table `topnotices`
--
CREATE TABLE `topnotices` (
`ID` int(11) NOT NULL,
`NoticeMessage` text NOT NULL,
`IP` int(11) NOT NULL default '0',
UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
--
-- Dumping data for table `topnotices`
--
-- --------------------------------------------------------
--
-- 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'
) TYPE=MyISAM;
--
-- Dumping data for table `users_online`
--
INSERT INTO `users_online` VALUES (0, 'test', '1149282403', '/staff/home.php', 0);
iNicks [Forum Moderator] - Please do not double post, simply edit your last post.
-
where do we get tis mysql database from
-
its on cpanel you have to make a new one
-
oh yeh cpanel 10 ok and ftp is that on the cpanel
-
Also +rep
iNicks [Forum Moderator] - Please dont double post, simply edit your last post.
-
um can you post some screenshots please? =]
-
nice fix apart from i got it working from the start without editing any of the code lol
-
Bad gateway for me, nice share though.
-
i didnt edit any code lol i just edited a couple more files that needed sql connections adding
as well as dbconfig and dbconfig1 need details index.php also needs them
-
Hey
Its a very good panel. I will try it out later :)
