Discover Habbo's history
Treat yourself with a Secret Santa gift.... of a random Wiki page for you to start exploring Habbo's history!
Happy holidays!
Celebrate with us at Habbox on the hotel, on our Forum and right here!
Join Habbox!
One of us! One of us! Click here to see the roles you could take as part of the Habbox community!


Page 4 of 23 FirstFirst 1234567814 ... LastLast
Results 31 to 40 of 225
  1. #31
    Join Date
    Dec 2005
    Posts
    2,992
    Tokens
    1,531

    Latest Awards:

    Default

    Quote 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.
    That went fast.

  2. #32
    Join Date
    Mar 2005
    Location
    Kidlington, Oxford.
    Posts
    7,274
    Tokens
    0

    Latest Awards:

    Default

    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....

  3. #33
    Join Date
    Feb 2006
    Location
    Inside your PC
    Posts
    1,626
    Tokens
    0

    Latest Awards:

    Default

    anyone got a fixed version of this panel

  4. #34
    Join Date
    Dec 2005
    Posts
    1,733
    Tokens
    201
    Habbo
    Bomb-Head

    Latest Awards:

    Default

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

  5. #35
    Join Date
    Feb 2006
    Location
    Newcastle
    Posts
    397
    Tokens
    0

    Default

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

  6. #36
    Join Date
    Feb 2006
    Location
    Inside your PC
    Posts
    1,626
    Tokens
    0

    Latest Awards:

    Default

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

  7. #37
    Join Date
    Feb 2006
    Location
    Inside your PC
    Posts
    1,626
    Tokens
    0

    Latest Awards:

    Default

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

  8. #38
    Join Date
    Apr 2005
    Location
    North Carolina, USA
    Posts
    4,535
    Tokens
    0

    Latest Awards:

    Default

    -- 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;
    Last edited by Dentafrice1; 20-04-2006 at 01:52 PM.

  9. #39
    Join Date
    Feb 2006
    Location
    Newcastle
    Posts
    397
    Tokens
    0

    Default

    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

  10. #40
    Join Date
    Nov 2005
    Posts
    807
    Tokens
    1,335

    Latest Awards:

    Default

    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'];
    Last edited by Splinter; 20-04-2006 at 02:07 PM.

Page 4 of 23 FirstFirst 1234567814 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •