Full Radio Panel! Better The RadioPanels - Download Now

[[$]]

I can set them up i just dont know why some of the links dont work

Then tell us.. you just said that constantly.

[-::Mr.Dave::-]

that still give the error
#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 7

anyway for the code for admin account just check page 3 of this thread also what mysql version are you guys running im using 4.0.25

[Bomb-Head]

Then tell us.. you just said that constantly.

It would help if i was actually talking to YOU.

[Liam.]

Links etc will be easy, if I had mine set up I could help but the sql don't work

You know the whole code did you run that as one query or seperate ones?

And if the links dont work then edit index or nav or something and correct them

[Bomb-Head]

Links etc will be easy, if I had mine set up I could help but the sql don't work

You know the whole code did you run that as one query or seperate ones?

And if the links dont work then edit index or nav or something and correct them

For the main SQL i ran them as seperate queries, and for the timetable SQL i ran it all as one

[-::Mr.Dave::-]

bomb can yu post the sql you used and also what version your sql is. to find version its on cpanel homepage

[N1nty]

[$] did u say u installed urs?

[Bomb-Head]

I dont use cpanel i use plesk so i cant find out what version it is lol.

[Bomb-Head]

The sql i used: (REMEMBER: RUN THEM AS SEPERATE QUERIES)



-- 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: `panel`-- -- ---------------------------------------------------------- -- 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;

EDIT: SORRY BUT FOR SOME REASON THAT LOOKS COMPLETLEY MUCKED UP :s I TRUED WRAPING THE CODE TAGES ROUND IT BUT IT MADE IT WORSE

[-::Mr.Dave::-]

bomb i sent you a message with the phpmyadmin access stuff