Reply to thread

Message

<blockquote data-quote="DingoHotel" data-source="post: 256727" data-attributes="member: 41429">Hi,For the 'Dingo vdWeek' script, we have a SQL structure. Here is the Sql structure:-- ------------------------------&nbsp; Table structure for `users`-- ----------------------------DROP TABLE IF EXISTS `users`;CREATE TABLE `users` (&nbsp; `id` int(11) unsigned NOT NULL AUTO_INCREMENT,&nbsp; `username` varchar(50) NOT NULL,&nbsp; `real_name` varchar(100) NOT NULL DEFAULT '',&nbsp; `password` varchar(5000) NOT NULL,&nbsp; `mail` varchar(50) NOT NULL DEFAULT '<a href="mailto:defaultuser@meth0d.org">defaultuser@meth0d.org</a>',&nbsp; `auth_ticket` text,&nbsp; `rank` int(11) unsigned NOT NULL DEFAULT '1',&nbsp; `credits` int(11) NOT NULL DEFAULT '50000',&nbsp; `vip_points` int(11) NOT NULL DEFAULT '0',&nbsp; `activity_points` int(11) NOT NULL DEFAULT '0',&nbsp; `activity_points_lastupdate` double NOT NULL DEFAULT '0',&nbsp; `look` varchar(255) NOT NULL DEFAULT 'sh-290-77.ch-210-66.hd-180-1.lg-270-78.hr-100-31',&nbsp; `gender` enum('M','F') NOT NULL DEFAULT 'M',&nbsp; `motto` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,&nbsp; `account_created` varchar(50) NOT NULL,&nbsp; `last_online` varchar(50) NOT NULL,&nbsp; `online` enum('0','1') NOT NULL DEFAULT '0',&nbsp; `ip_last` varchar(120) NOT NULL,&nbsp; `ip_reg` varchar(120) NOT NULL,&nbsp; `home_room` int(10) unsigned NOT NULL DEFAULT '536',&nbsp; `respect` int(11) NOT NULL DEFAULT '0',&nbsp; `daily_respect_points` int(11) NOT NULL DEFAULT '3',&nbsp; `daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',&nbsp; `newbie_status` int(11) NOT NULL DEFAULT '0',&nbsp; `is_muted` enum('0','1') NOT NULL DEFAULT '0',&nbsp; `mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',&nbsp; `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',&nbsp; `block_newfriends` enum('0','1') NOT NULL DEFAULT '0',&nbsp; `hide_online` enum('0','1') DEFAULT '0',&nbsp; `hide_inroom` enum('0','1') NOT NULL DEFAULT '0',&nbsp; `mail_verified` varchar(devil) NOT NULL DEFAULT '0',&nbsp; `vip` enum('0','1') NOT NULL DEFAULT '0',&nbsp; `volume` int(3) NOT NULL DEFAULT '100',&nbsp; `account_twitter` varchar(225) DEFAULT NULL,&nbsp; `account_msn` varchar(225) DEFAULT NULL,&nbsp; `accept_trading` enum('0','1') NOT NULL DEFAULT '1',&nbsp; `geheim_pass` varchar(50) NOT NULL DEFAULT '',&nbsp; `home_bg` varchar(255) NOT NULL DEFAULT '<a href="http://dingohotel.be/cache/images/achtergrond.gif" target="_blank">http://dingohotel.be/cache/images/achtergrond.gif</a>',&nbsp; `home_text` varchar(999) NOT NULL,&nbsp; `dj` enum('0','1') NOT NULL DEFAULT '0',&nbsp; `dvdw` enum('0','1') NOT NULL DEFAULT '0',&nbsp; PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=229 DEFAULT CHARSET=latin1;With this SQL structure you can automatically fix that Script and the DeeJay Script!100% Credits to: dingohotel.beGreetz, DingoHotel</blockquote>

[QUOTE="DingoHotel, post: 256727, member: 41429"] Hi, For the 'Dingo vdWeek' script, we have a SQL structure. Here is the Sql structure: -- ---------------------------- -- Table structure for `users` -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `real_name` varchar(100) NOT NULL DEFAULT '', `password` varchar(5000) NOT NULL, `mail` varchar(50) NOT NULL DEFAULT '[email]defaultuser@meth0d.org[/email]', `auth_ticket` text, `rank` int(11) unsigned NOT NULL DEFAULT '1', `credits` int(11) NOT NULL DEFAULT '50000', `vip_points` int(11) NOT NULL DEFAULT '0', `activity_points` int(11) NOT NULL DEFAULT '0', `activity_points_lastupdate` double NOT NULL DEFAULT '0', `look` varchar(255) NOT NULL DEFAULT 'sh-290-77.ch-210-66.hd-180-1.lg-270-78.hr-100-31', `gender` enum('M','F') NOT NULL DEFAULT 'M', `motto` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `account_created` varchar(50) NOT NULL, `last_online` varchar(50) NOT NULL, `online` enum('0','1') NOT NULL DEFAULT '0', `ip_last` varchar(120) NOT NULL, `ip_reg` varchar(120) NOT NULL, `home_room` int(10) unsigned NOT NULL DEFAULT '536', `respect` int(11) NOT NULL DEFAULT '0', `daily_respect_points` int(11) NOT NULL DEFAULT '3', `daily_pet_respect_points` int(11) NOT NULL DEFAULT '3', `newbie_status` int(11) NOT NULL DEFAULT '0', `is_muted` enum('0','1') NOT NULL DEFAULT '0', `mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0', `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0', `block_newfriends` enum('0','1') NOT NULL DEFAULT '0', `hide_online` enum('0','1') DEFAULT '0', `hide_inroom` enum('0','1') NOT NULL DEFAULT '0', `mail_verified` varchar(devil) NOT NULL DEFAULT '0', `vip` enum('0','1') NOT NULL DEFAULT '0', `volume` int(3) NOT NULL DEFAULT '100', `account_twitter` varchar(225) DEFAULT NULL, `account_msn` varchar(225) DEFAULT NULL, `accept_trading` enum('0','1') NOT NULL DEFAULT '1', `geheim_pass` varchar(50) NOT NULL DEFAULT '', `home_bg` varchar(255) NOT NULL DEFAULT '[url]http://dingohotel.be/cache/images/achtergrond.gif[/url]', `home_text` varchar(999) NOT NULL, `dj` enum('0','1') NOT NULL DEFAULT '0', `dvdw` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=229 DEFAULT CHARSET=latin1; With this SQL structure you can automatically fix that Script and the DeeJay Script! 100% Credits to: dingohotel.be Greetz, DingoHotel [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members