Created
April 26, 2013 23:32
-
-
Save Mrbytes/5471127 to your computer and use it in GitHub Desktop.
internationalization of language on install & new table structure
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| From dc7363d00d08ad69baa31c1d9d2f1505b67f2b63 Mon Sep 17 00:00:00 2001 | |
| From: mrbytes <eguervos@msn.com> | |
| Date: Sat, 27 Apr 2013 01:22:30 +0200 | |
| Subject: [PATCH] internationalization of language on install | |
| --- | |
| install/extra/basicdata.sql | 876 +++++++++++++++++++ | |
| install/extra/script_text_locales.sql | 717 ++++++++++++++++ | |
| install/extra/structure.sql | 1496 +++++++++++++++++++++++++++++++++ | |
| install/functions/database.php | 141 +++- | |
| install/functions/permissioncheck.php | 6 +- | |
| install/functions/writeconfig.php | 94 +-- | |
| install/index.php | 46 +- | |
| 7 files changed, 3304 insertions(+), 72 deletions(-) | |
| create mode 100644 install/extra/basicdata.sql | |
| create mode 100644 install/extra/script_text_locales.sql | |
| create mode 100644 install/extra/structure.sql | |
| diff --git a/install/extra/basicdata.sql b/install/extra/basicdata.sql | |
| new file mode 100644 | |
| index 0000000..80f24f5 | |
| --- /dev/null | |
| +++ b/install/extra/basicdata.sql | |
| @@ -0,0 +1,876 @@ | |
| +## Basic Data | |
| +## Database version: U-232 V3 | |
| +## ************************** | |
| + | |
| +SET NAMES utf8; | |
| + | |
| +## Data for the table `ach_bonus` | |
| + | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('1','Subtract 10GB From Your Download.','1','10737418240'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('2','Subtract 1GB From Your Download.','1','1073741824'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('3','Subtract 3GB From Your Download.','1','3221225472'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('4','Subtract 5GB From Your Download.','1','5368709120'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('5','Subtract 100MB From Your Download.','1','107374182'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('6','Subtract 300MB From Your Download.','1','322122547'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('7','Subtract 500MB From Your Download.','1','536870910'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('8','Subtract 1MB From Your Download.','1','1073741'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('9','Add 1GB to your Upload.','2','1073741824'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('10','Add 10GB to your Upload.','2','10737418240'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('11','Add 3GB to your Upload.','2','3221225472'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('12','Add 5GB to your Upload.','2','5368709120'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('13','Add 100MB to your Upload.','2','107374182'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('14','Add 300MB to your Upload.','2','322122547'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('15','Add 500MB to your Upload.','2','536870910'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('16','Add 1MB to your Upload.','2','1073741'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('17','Add 1 Invite.','3','1'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('18','Add 2 Invites.','3','2'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('19','Add 100 Bonus Points to your Total.','4','100'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('20','Add 200 Bonus Points to your Total.','4','200'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('21','Add 500 Bonus Points to your Total.','4','500'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('22','Add 750 Bonus Points to your Total.','4','750'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('23','Add 1000 Bonus Points to your Total.','4','1000'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('24','Add 50 Bonus Points to your Total.','4','50'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('25','Add 25 Bonus Points to your Total.','4','25'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('26','Add 75 Bonus Points to your Total.','4','75'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('27','Add 10 Bonus Points to your Total.','4','10'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('28','Nothing','5','0'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('29','Nothing','5','0'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('30','Nothing','5','0'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('31','Nothing','5','0'); | |
| +insert into `ach_bonus` (`bonus_id`, `bonus_desc`, `bonus_type`, `bonus_do`) values('32','Nothing','5','0'); | |
| + | |
| +## Data for the table `achievementist` | |
| + | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('1','First Birthday','Been a member for at least 1 year.','birthday1.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('2','Second Birthday','Been a member for a period of at least 2 years.','birthday2.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('6','Fourth Birthday','Been a member for a period of at least 4 years.','birthday4.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('5','Third Birthday','Been a member for a period of at least 3 years.','birthday3.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('7','Fifth Birthday','Been a member for a period of at least 5 years.','birthday5.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('8','Uploader LVL1','Uploaded at least 1 torrent to the site.','ul1.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('9','Uploader LVL2','Uploaded at least 50 torrents to the site.','ul2.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('10','Uploader LVL3','Uploaded at least 100 torrents to the site.','ul3.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('11','Uploader LVL4','Uploaded at least 200 torrents to the site.','ul4.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('12','Uploader LVL5','Uploaded at least 300 torrents to the site.','ul5.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('13','Uploader LVL6','Uploaded at least 500 torrents to the site.','ul6.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('14','Uploader LVL7','Uploaded at least 800 torrents to the site.','ul7.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('15','Uploader LVL8','Uploaded at least 1000 torrents to the site.','ul8.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('16','Uploader LVL9','Uploaded at least 1500 torrents to the site.','ul9.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('17','Uploader LVL10','Uploaded at least 2000 torrents to the site.','ul10.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('18','Inviter LVL1','Invited at least 1 new user to the site.','invite1.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('19','Inviter LVL2','Invited at least 2 new users to the site.','invite2.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('20','Inviter LVL3','Invited at least 3 new users to the site.','invite3.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('21','Inviter LVL4','Invited at least 5 new users to the site.','invite4.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('22','Inviter LVL5','Invited at least 10 new users to the site.','invite5.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('23','Forum Poster LVL1','Made at least 1 post in the forums.','fpost1.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('24','Forum Poster LVL2','Made at least 25 posts in the forums.','fpost2.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('25','Forum Poster LVL3','Made at least 50 posts in the forums.','fpost3.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('26','Forum Poster LVL4','Made at least 100 posts in the forums.','fpost4.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('27','Forum Poster LVL5','Made at least 250 posts in the forums.','fpost5.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('28','Avatar Setter','User has successfully set an avatar on profile settings.','piratesheep.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('29','Old Virginia','At the age of 25 still remains a virgin. (Custom Achievement.)','virgin.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('30','Forum Poster LVL6','Made at least 500 posts in the forums.','fpost6.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('31','Stick Em Up LVL1','Uploading at least 1 sticky torrent to the site.','sticky1.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('32','Stick Em Up LVL2','Uploading at least 5 sticky torrents to the site.','sticky2.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('33','Stick Em Up LVL3','Uploading at least 10 sticky torrents.','sticky3.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('34','Stick EM Up LVL4','Uploading at least 25 sticky torrents.','sticky4.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('35','Stick EM Up LVL5','Uploading at least 50 sticky torrents.','sticky5.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('36','Gag Da B1tch','Getting gagged like he\'s Adams Man!','gagged.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('37','Signature Setter','User has successfully set a signature on profile settings.','signature.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('38','Corruption Counts','Transferred at least 1 byte of corrupt data incoming.','corrupt.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('40','7 Day Seeder','Seeded a snatched torrent for a total of at least 7 days.','7dayseed.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('41','14 Day Seeder','Seeded a snatched torrent for a total of at least 14 days.','14dayseed.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('42','21 Day Seeder','Seeded a snatched torrent for a total of at least 21 days.','21dayseed.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('43','28 Day Seeder','Seeded a snatched torrent for a total of at least 28 days.','28dayseed.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('44','45 Day Seeder','Seeded a snatched torrent for a total of at least 45 days.','45dayseed.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('45','60 Day Seeder','Seeded a snatched torrent for a total of at least 60 days.','60dayseed.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('46','90 Day Seeder','Seeded a snatched torrent for a total of at least 90 days.','90dayseed.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('47','120 Day Seeder','Seeded a snatched torrent for a total of at least 120 days.','120dayseed.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('48','200 Day Seeder','Seeded a snatched torrent for a total of at least 200 days.','200dayseed.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('49','1 Year Seeder','Seeded a snatched torrent for a total of at least 1 Year.','365dayseed.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('50','Sheep Fondler','User has been caught touching the sheep at least 1 time.','sheepfondler.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('51','Forum Topic Starter LVL1','Started at least 1 topic in the forums.','ftopic1.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('52','Forum Topic Starter LVL2','Started at least 10 topics in the forums.','ftopic2.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('53','Forum Topic Starter LVL3','Started at least 25 topics in the forums.','ftopic3.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('55','Forum Topic Starter LVL4','Started at least 50 topics in the forums.','ftopic4.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('58','Bonus Banker LVL1','Earned at least 1 bonus point.','bonus1.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('57','Forum Topic Starter LVL5','Started at least 75 topics in the forums.','ftopic5.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('61','Bonus Banker LVL3','Earned at least 500 bonus points.','bonus3.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('60','Bonus Banker LVL2','Earned at least 100 bonus points.','bonus2.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('66','Bonus Banker LVL6','Earned at least 5000 bonus points.','bonus6.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('63','Bonus Banker LVL4','Earned at least 1000 bonus points.','bonus4.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('65','Bonus Banker LVL5','Earned at least 2000 bonus points.','bonus5.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('71','Bonus Banker LVL9','Earned at least 70000 bonus points.','bonus10.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('68','Bonus Banker LVL7','Earned at least 10000 bonus points.','bonus7.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('70','Bonus Banker LVL8','Earned at least 30000 bonus points.','bonus9.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('72','Bonus Banker LVL10','Earned at least 100000 bonus points.','bonus8.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('73','Bonus Banker LVL11','Earned at least 1000000 bonus points.','bonus11.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('74','Christmas Achievement','User has found the Christmas Achievement in the advent calendar page.','christmas.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('75','Advent Playa','Played the Advent Calendar all 25 days straight.','xmasdays.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('76','Request Filler LVL1','Filled at least 1 request from the request page.','reqfiller1.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('77','Request Filler LVL2','Filled at least 5 requests from the request page.','reqfiller2.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('78','Request Filler LVL3','Filled at least 10 requests from the request page.','reqfiller3.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('79','Request Filler LVL4','Filled at least 25 requests from the request page.','reqfiller4.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('80','Request Filler LVL5','Filled at least 50 requests from the request page.','reqfiller5.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('81','Adam Punker','Officially Punked Adam in the proper forum thread.','adampnkr.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('82','Shout Spammer LVL1','Made at least 10 posts to the shoutbox today.','spam1.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('83','Shout Spammer LVL2','Made at least 25 posts to the shoutbox today.','spam2.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('84','Shout Spammer LVL3','Made at least 50 posts to the shoutbox today.','spam3.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('85','Shout Spammer LVL4','Made at least 75 posts to the shoutbox today.','spam4.png'); | |
| +insert into `achievementist` (`id`, `achievname`, `notes`, `clienticon`) values('86','Shout Spammer LVL5','Made at least 100 posts to the shoutbox today.','spam5.png'); | |
| + | |
| +## Data for the table `achievements` | |
| + | |
| +## Data for the table `announcement_main` | |
| + | |
| +## Data for the table `announcement_process` | |
| + | |
| +## Data for the table `attachments` | |
| + | |
| +## Data for the table `avps` | |
| + | |
| +insert into `avps` (`arg`, `value_s`, `value_i`, `value_u`) values('loadlimit','0','0','0'); | |
| +insert into `avps` (`arg`, `value_s`, `value_i`, `value_u`) values('inactivemail','0','0','0'); | |
| +insert into `avps` (`arg`, `value_s`, `value_i`, `value_u`) values('sitepot','0','0','0'); | |
| +insert into `avps` (`arg`, `value_s`, `value_i`, `value_u`) values('last24','0','0','0'); | |
| + | |
| +## Data for the table `bannedemails` | |
| + | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('1','1282299331','1','Fake provider','*@emailias.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('2','1282299331','1','Fake provider','*@e4ward.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('3','1282299331','1','Fake provider','*@dumpmail.de'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('4','1282299331','1','Fake provider','*@dontreg.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('5','1282299331','1','Fake provider','*@disposeamail.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('6','1282299331','1','Fake provider','*@antispam24.de'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('7','1282299331','1','Fake provider','*@trash-mail.de'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('8','1282299331','1','Fake provider','*@spambog.de'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('9','1282299331','1','Fake provider','*@spambog.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('10','1282299331','1','Fake provider','*@discardmail.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('11','1282299331','1','Fake provider','*@discardmail.de'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('12','1282299331','1','Fake provider','*@mailinator.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('13','1282299331','1','Fake provider','*@wuzup.net'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('14','1282299331','1','Fake provider','*@junkmail.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('15','1282299331','1','Fake provider','*@clarkgriswald.net'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('16','1282299331','1','Fake provider','*@2prong.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('17','1282299331','1','Fake provider','*@jrwilcox.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('18','1282299331','1','Fake provider','*@10minutemail.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('19','1282299331','1','Fake provider','*@pookmail.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('20','1282299331','1','Fake provider','*@golfilla.info'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('21','1282299331','1','Fake provider','*@afrobacon.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('22','1282299331','1','Fake provider','*@senseless-entertainment.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('23','1282299331','1','Fake provider','*@put2.net'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('24','1282299331','1','Fake provider','*@temporaryinbox.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('25','1282299331','1','Fake provider','*@slaskpost.se'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('26','1282299331','1','Fake provider','*@haltospam.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('27','1282299331','1','Fake provider','*@h8s.org'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('28','1282299331','1','Fake provider','*@ipoo.org'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('29','1282299331','1','Fake provider','*@oopi.org'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('30','1282299331','1','Fake provider','*@poofy.org'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('31','1282299331','1','Fake provider','*@jetable.org'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('32','1282299331','1','Fake provider','*@kasmail.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('33','1282299331','1','Fake provider','*@mail-filter.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('34','1282299331','1','Fake provider','*@maileater.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('35','1282299331','1','Fake provider','*@mailexpire.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('36','1282299331','1','Fake provider','*@mailnull.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('37','1282299331','1','Fake provider','*@mailshell.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('38','1282299331','1','Fake provider','*@mymailoasis.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('39','1282299331','1','Fake provider','*@mytrashmail.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('40','1282299331','1','Fake provider','*@mytrashmail.net'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('41','1282299331','1','Fake provider','*@shortmail.net'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('42','1282299331','1','Fake provider','*@sneakemail.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('43','1282299331','1','Fake provider','*@sofort-mail.de'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('44','1282299331','1','Fake provider','*@spamcon.org'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('45','1282299331','1','Fake provider','*@spamday.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('46','1282299331','1','fake provider','*@spamex.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('47','1282299307','1','fake provider','*@spamgourmet.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('48','1282299289','1','fake provider','*@spamhole.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('49','1282299331','1','Fake provider','*@spammotel.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('50','1282299331','1','Fake provider','*@tempemail.net'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('51','1282299331','1','Fake provider','*@tempinbox.com'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('52','1282299331','1','Fake provider','*@throwaway.de'); | |
| +insert into `bannedemails` (`id`, `added`, `addedby`, `comment`, `email`) values('53','1282299331','1','Fake provider','*@woodyland.org'); | |
| + | |
| +## Data for the table `bans` | |
| + | |
| +## Data for the table `blackjack` | |
| + | |
| +## Data for the table `blocks` | |
| + | |
| +## Data for the table `bonus` | |
| + | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('1','1.0GB Uploaded','275.0','With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.','traffic','1073741824','1.0','yes','275.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('2','2.5GB Uploaded','350.0','With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.','traffic','2684354560','1.0','yes','350.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('3','5GB Uploaded','550.0','With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.','traffic','5368709120','1.0','yes','550.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('4','3 Invites','650.0','With enough bonus points acquired, you are able to exchange them for a few invites. The points are then removed from your Bonus Bank and the invitations are added to your invites amount.','invite','3','1.0','yes','650.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('5','Custom Title!','50.0','For only 50.0 Karma Bonus Points you can buy yourself a custom title. the only restrictions are no foul or offensive language or userclass can be entered. The points are then removed from your Bonus Bank and your special title is changed to the title of your choice','title','1','1.0','yes','50.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('6','VIP Status','5000.0','With enough bonus points acquired, you can buy yourself VIP status for one month. The points are then removed from your Bonus Bank and your status is changed.','class','1','1.0','yes','5000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('7','Give A Karma Gift','100.0','Well perhaps you dont need the upload credit, but you know somebody that could use the Karma boost! You are now able to give your Karma credits as a gift! The points are then removed from your Bonus Bank and added to the account of a user of your choice!\r\n\r\nAnd they recieve a PM with all the info as well as who it came from...','gift_1','1073741824','1.0','yes','100.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('8','Custom Smilies','300.0','With enough bonus points acquired, you can buy yourself a set of custom smilies for one month! The points are then removed from your Bonus Bank and with a click of a link, your new smilies are available whenever you post or comment!','smile','1','1.0','yes','300.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('9','Remove Warning','1000.0','With enough bonus points acquired... So you have been naughty... tsk tsk :P Yep now for the Low Low price of only 1000 points you can have that warning taken away lol.!','warning','1','1.0','yes','1000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('10','Ratio Fix','500.0','With enough bonus points acquired, you can bring the ratio of one torrent to a 1 to 1 ratio! The points are then removed from your Bonus Bank and your status is changed.','ratio','1','1.0','yes','500.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('11','FreeLeech','30000.0','The Ultimate exchange if you have over 30000 Points - Make the tracker freeleech for everyone for 3 days: Upload will count but no download.\r\nIf you dont have enough points you can donate certain amount of your points until it accumulates. Everybodys karma counts!','freeleech','1','0.0','yes','1.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('12','Doubleupload','30000.0','The ultimate exchange if you have over 30000 points - Make the tracker double upload for everyone for 3 days: Upload will count double.\r\nIf you dont have enough points you can donate certain amount of your points until it accumulates. Everybodys karma counts!','doubleup','1','110.0','yes','1.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('13','Halfdownload','30000.0','The ultimate exchange if you have over 30000 points - Make the tracker Half Download for everyone for 3 days: Download will count only half.\r\nIf you dont have enough points you can donate certain amount of your points until it accumulates. Everybodys karma counts!','halfdown','1','0.0','yes','1.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('14','1.0GB Download Removal','150.0','With enough bonus points acquired, you are able to exchange them for a Download Credit Removal. The points are then removed from your Bonus Bank and the download credit is removed from your total downloaded amount.','traffic2','1073741824','1.0','yes','150.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('15','2.5GB Download Removal','300.0','With enough bonus points acquired, you are able to exchange them for a Download Credit Removal. The points are then removed from your Bonus Bank and the download credit is removed from your total downloaded amount.','traffic2','2684354560','1.0','yes','300.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('16','5GB Download Removal','500.0','With enough bonus points acquired, you are able to exchange them for a Download Credit Removal. The points are then removed from your Bonus Bank and the download credit is removed from your total downloaded amount.','traffic2','5368709120','1.0','yes','500.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('17','Anonymous Profile','750.0','With enough bonus points acquired, you are able to exchange them for Anonymous profile for 14 days. The points are then removed from your Bonus Bank and the Anonymous switch will show on your profile.','anonymous','1','1.0','yes','750.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('18','Freeleech for 1 Year','80000.0','With enough bonus points acquired, you are able to exchange them for Freelech for one year for yourself. The points are then removed from your Bonus Bank and the freeleech will be enabled on your account.','freeyear','1','1.0','yes','80000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('19','3 Freeleech Slots','1000.0','With enough bonus points acquired, you are able to exchange them for some Freeleech Slots. The points are then removed from your Bonus Bank and the slots are added to your free slots amount.','freeslots','3','0.0','yes','1000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('20','200 Bonus Points - Invite trade-in','1.0','If you have 1 invite and dont use them click the button to trade them in for 200 Bonus Points.','itrade','200','0.0','yes','0.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('21','Freeslots - Invite trade-in','1.0','If you have 1 invite and dont use them click the button to trade them in for 2 Free Slots.','itrade2','2','0.0','yes','0.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('22','Pirate Rank for 2 weeks','50000.0','With enough bonus points acquired, you are able to exchange them for Pirates status and Freeleech for 2 weeks. The points are then removed from your Bonus Bank and the Pirate icon will be displayed throughout, freeleech will then be enabled on your account.','pirate','1','1.0','yes','50000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('23','King Rank for 1 month','70000.0','With enough bonus points acquired, you are able to exchange them for Kings status and Freeleech for 1 month. The points are then removed from your Bonus Bank and the King icon will be displayed throughout, freeleech will then be enabled on your account.','king','1','1.0','yes','70000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('24','10GB Uploaded','1000.0','With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.','traffic','10737418240','0.0','yes','1000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('25','25GB Uploaded','2000.0','With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.','traffic','26843545600','0.0','yes','2000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('26','50GB Uploaded','4000.0','With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.','traffic','53687091200','0.0','yes','4000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('27','100GB Uploaded','8000.0','With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.','traffic','107374182400','0.0','yes','8000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('28','520GB Uploaded','40000.0','With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.','traffic','558345748480','0.0','yes','40000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('29','1TB Uploaded','80000.0','With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.','traffic','1099511627776','0.0','yes','80000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('30','Parked Profile','75000.0','With enough bonus points acquired, you are able to unlock the parked option within your profile which will ensure your account will be safe. The points are then removed from your Bonus Bank and the parked switch will show on your profile.','parked','1','1.0','yes','75000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('31','Pirates bounty','50000.0','With enough bonus points acquired, you are able to exchange them for Pirates bounty which will select random users and deduct random amount of reputation points from them. The points are removed from your Bonus Bank and the reputation points will be deducted from the selected users then credited to you.','bounty','1','1.0','yes','50000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('32','100 Reputation points','40000.0','With enough bonus points acquired, you are able to exchange them for some reputation points. The points are then removed from your Bonus Bank and the rep is added to your total reputation amount.','reputation','100','0.0','yes','40000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('33','Userblocks','50000.0','With enough bonus points acquired and a minimum of 50 reputation points, you are able to exchange them for userblocks access. The points are then removed from your Bonus Bank and the user blocks configuration link will appear on your menu.','userblocks','0','0.0','yes','50000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('34','Bump a Torrent!','5000.0','With enough bonus points acquired, you can Bump a torrent back to page 1 of the torrents page, bringing it back to life! \r\nThe torrent will then appear on page 1 again! The points are then removed from your Bonus Bank and the torrent is Bumped!\r\n** note there is an option to either view Bumped torrents or not.','bump','1','0.0','yes','5000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('35','Immunity','150000.0','With enough bonus points acquired, you are able to exchange them for immunity for one year. The points are then removed from your Bonus Bank and the immunity switch is enabled on your account.','immunity','1','0.0','yes','150000.0'); | |
| +insert into `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`, `pointspool`, `enabled`, `minpoints`) values('36','User Unlocks','500.0','With enough bonus points acquired and a minimum of 50 reputation points, you are able to exchange them for bonus locked moods. The points are then removed from your Bonus Bank and the user unlocks configuration link will appear on your menu.','userunlock','1','0.0','yes','500.0'); | |
| + | |
| +## Data for the table `bonuslog` | |
| + | |
| +## Data for the table `bookmarks` | |
| + | |
| +## Data for the table `bugs` | |
| + | |
| +## Data for the table `cards` | |
| + | |
| +insert into `cards` (`id`, `points`, `pic`) values('1','2','2p.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('2','3','3p.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('3','4','4p.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('4','5','5p.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('5','6','6p.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('6','7','7p.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('7','8','8p.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('8','9','9p.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('9','10','10p.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('10','10','vp.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('11','10','dp.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('12','10','kp.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('13','1','tp.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('14','2','2b.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('15','3','3b.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('16','4','4b.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('17','5','5b.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('18','6','6b.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('19','7','7b.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('20','8','8b.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('21','9','9b.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('22','10','10b.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('23','10','vb.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('24','10','db.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('25','10','kb.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('26','1','tb.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('27','2','2k.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('28','3','3k.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('29','4','4k.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('30','5','5k.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('31','6','6k.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('32','7','7k.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('33','8','8k.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('34','9','9k.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('35','10','10k.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('36','10','vk.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('37','10','dk.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('38','10','kk.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('39','1','tk.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('40','2','2c.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('41','3','3c.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('42','4','4c.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('43','5','5c.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('44','6','6c.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('45','7','7c.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('46','8','8c.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('47','9','9c.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('48','10','10c.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('49','10','vc.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('50','10','dc.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('51','10','kc.bmp'); | |
| +insert into `cards` (`id`, `points`, `pic`) values('52','1','tc.bmp'); | |
| + | |
| +## Data for the table `casino` | |
| + | |
| +## Data for the table `casino_bets` | |
| + | |
| +## Data for the table `categories` | |
| + | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('2','Games','cat_games.png','No Description','-1','1'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('3','Movies','cat_dvd.png','No Description','-1','2'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('4','Music','cat_music.png','No Description','-1','4'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('5','Episodes','cat_tveps.png','No Description','3','2'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('6','XXX','cat_xxx.png','No Description','3','2'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('7','Games/PSP','cat_psp.png','No Description','2','1'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('8','Games/PS2','cat_ps2.png','No Description','2','1'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('9','Anime','cat_anime.png','No Description','3','2'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('10','Movies/XviD','cat_xvid.png','No Description','3','2'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('11','Movies/HDTV','cat_hdtv.png','No Description','3','2'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('12','Games/PC Rips','cat_pcrips.png','No Description','2','1'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('13','Apps','cat_misc.png','No Description','-1','3'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('1','Apps','cat_appz.png','No Description','13','3'); | |
| +insert into `categories` (`id`, `name`, `image`, `cat_desc`, `parent_id`, `tabletype`) values('14','Music','cat_music.png','No Description','4','4'); | |
| + | |
| +## Data for the table `cheaters` | |
| + | |
| +## Data for the table `cleanup` | |
| + | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('1','Lottery Autoclean','lotteryclean.php','1322336888','259200','d6704d582b136ea1ed13635bb9059f57','1','Lottery Autoclean - Lottery clean up here every 3 days','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('2','Optimze Db Auto','optimizedb.php','1322356284','172800','d6704d582b136ea1ed13635bb9059f57','1','Auto Optimize - Runs every 2 days','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('3','Auto Backup Db','backupdb.php','1322227809','86400','d6704d582b136ea1ed13635bb9059f57','1','Auto Backup - Runs every 1 day','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('4','Irc bonus','irc_update.php','1322224621','1800','c06a074cd6403bcc1f292ce864c3cdd5','1','Irc idle bonus update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('5','Statistics','sitestats_update.php','1322224030','3600','2a2afb82d82cc4ddcb6ff1753a40dfe9','1','SIte statistics update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('6','Karma Bonus','karma_update.php','1322224833','1800','d0df8a38cfba26ece2c285189a656ad0','0','Seedbonus award update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('7','Forums','forum_update.php','1322223364','900','c9c58a0d43b02cd5358115673bc04c9e','0','Forum online and count update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('8','Torrents','torrents_update.php','1322223716','900','81875d0e7b63771ae2a59f2a48755da4','1','Torrents update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('9','Normalize','torrents_normalize.php','1322223925','900','1274dd2d9ffd203e6d489db25d0f28fe','1','File, comment, torrent update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('10','Ips','ip_update.php','1322230920','86400','0b4f34774259b5069d220c485aa10eba','1','Ip clean','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('11','Signups','expired_signup_update.php','1322225774','259200','bdde41096f769d1a01251813cc2c1353','1','Expired signups update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('12','Peers','peer_update.php','1322223724','900','72181fc6214ddc556d71066df031d424','1','Peers update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('13','Visible','visible_update.php','1322223676','900','77c523eab12be5d0342e4606188cd2ca','0','Torrents visible update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('14','Announcements','announcement_update.php','1322235510','86400','b73c139b4defbc031e201b91fef29a4c','1','Old announcement updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('15','Readposts','readpost_update.php','1322237616','86400','3e0c8bc6b6e6cc61fdfe8b26f8268b77','1','Old Readposts updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('16','Happyhour','happyhour_update.php','1316047921','43200','a7c422bc9f17b3fba5dab2d0129acd32','1','HappyHour Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('17','Customsmilies','customsmilie_update.php','1322237624','86400','9e8a41be2b0a56d83e0d0c0b00639f66','1','Custom Smilie Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('18','Karma Vips','karmavip_update.php','1322241313','86400','c444f13b95998c98a851714673ff6b84','1','Karma VIp Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('19','Anonymous Profile','anonymous_update.php','1322248387','86400','25146aec76a7b163ac6955685ff667d9','1','Anonymous Profile Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('20','Delete Torrents','delete_torrents_update.php','1322249440','86400','52f8e3c9fd438d4a86062f88f1146098','1','Delete Old Torrents Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('21','Funds','funds_update.php','1322249596','86400','5f50f43a9e640cd6203e1964c17361ba','1','Funds And Donation Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('22','Leechwarns','leechwarn_update.php','1322250519','86400','0303a05302fadf30fc18f987d2a5b285','1','Leechwarnings Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('23','Auto Invite','autoinvite_update.php','1322253658','86400','48839ced75a612d41d9278718075dbb2','1','Auto Invite Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('24','Hit And Run','hitrun_update.php','1322225873','3600','3ab445bbff84f87e8dc5a16489d7ca31','1','Hit And Run Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('25','Freeslots Update','freeslot_update.php','1322242742','86400','63db6b0519eccbfe0b06d87b8f0bcaad','1','Freeslots Stuffs Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('26','Backup Clean','backup_update.php','1322256765','86400','2c0d1a9ffa04937255344b97e2c9706f','1','Backups Clean Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('27','Inactive Clean','inactive_update.php','1322222619','86400','a401de097e031315b751b992ee40d733','1','Inactive Users Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('28','Shout Clean','shout_update.php','1322359522','172800','13515c22103b5b916c3d86023220cd61','1','Shoutbox Clean Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('29','Power User Clean','pu_update.php','1322276169','86400','4751425b1c765360a5f8bab14c6b9a47','1','Power User Clean Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('30','Power User Demote Clean','pu_demote_update.php','1322258944','86400','e9249b5f653f03ed425d68947155056b','1','Power User Demote Clean Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('31','Bugs Clean','bugs_update.php','1322423964','1209600','1e9734cdf50408a7739b7b03272aeab3','1','Bugs Update Clean','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('32','Sitepot Clean','sitepot_update.php','1322302367','86400','29dae941216f1bdb81f69dce807b3501','1','Sitepot Update Clean','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('33','Userhits Clean','userhits_update.php','1322306426','86400','d0cec8e7adb50290db6cf911a5c74339','1','Userhits Clean Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('34','Process Kill','processkill_update.php','1322222860','86400','b7c0f14c9482a14e9f5cb0d467dfd7c6','1','Mysql Process KIll Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('35','Cleanup Log','cleanlog_update.php','1322224214','86400','7dc0b72fc8c12b264fad1613fbea2489','1','Cleanup Log Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('36','Pirate Cleanup','pirate_update.php','1322243128','86400','e5f20d43425832e9397841be6bc92be2','1','Pirate Stuffs Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('37','King Cleanup','king_update.php','1322245383','86400','12b5c6c9f9919ca09816225c29fddaeb','1','King Stuffs Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('38','Free User Cleanup','freeuser_update.php','1322224046','3900','37f9de0443159bf284a1c7a703e96cf9','1','Free User Stuffs Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('39','Download Possible Cleanup','downloadpos_update.php','1322246051','86400','e20bcc6d07c6ec493e106adb8d2a8227','1','Download Possible Stuffs Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('40','Upload Possible Cleanup','uploadpos_update.php','1322246739','86400','fd1110b750af878faccaf672fe53876d','1','Upload Possible Stuffs Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('41','Free Torrents Cleanup','freetorrents_update.php','1322223274','3600','20390090ac784fee830d19bd708cfcad','1','Free Torrents Stuffs Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('42','Chatpost Cleanup','chatpost_update.php','1322246743','86400','bab6f1de36dc97dff02745051e076a39','1','Chatpost Stuffs Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('43','Immunity Cleanup','immunity_update.php','1322248056','86400','11bf6f41c659b9f49f6ccdfa616e9f82','1','Immunity Stuffs Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('44','Warned Cleanup','warned_update.php','1322248383','86400','6e558b89ac60454eaa3a45243347c977','1','Warned Stuffs Update','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('45','Games Update','gameaccess_update.php','1322306043','86400','33704fd97f8840ff08ef4e6ff236b3e4','1','Games Stuffs Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('46','Pm Update','sendpmpos_update.php','1322306068','86400','32784b9c2891f022a91d5007f068f7d9','1','Pm Stuffs Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('47','Avatar Update','avatarpos_update.php','1322306522','86400','f257794129ee772f5cfe00b33b363100','1','Avatar Stuffs Updates','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('48','Birthday Pms','birthday_update.php','1336226521','86400','1fd167bf236ea5e74e835224d1cc36e9','1','Pm all members with birthdays.','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('49','Movie of the week','mow_update.php','1336316808','604800','716274782f2f7229d960a6661fb06b60','1','Updates movie of the week','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('50','Silver torrents','silvertorrents_update.php','1336179577','3600','3e1aab005271870d69934ebe37e28819','1','Clean expired silver','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('51','Failed Logins','failedlogin_update.php','1340568661','86400','c90f0f030d7914db6ae1263de1730541','1','Delete expired failed logins','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('52','Christmas Gift Rest','gift_update.php','1372122786','31556926','4bdd6190a0ba3420d21b50b79945c06b','1','Reset all users yearly xmas gift','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('53','Achievements Update','achievement_avatar_update.php','1343436987','86400','0c5889bab74e7ff8f920ec524423f627','1','Updates user avatar achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('54','Achievements Update','achievement_bday_update.php','1343487059','86400','2b95ff34a27d540f61ceca3ee1424216','1','Updates user birthday achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('55','Achievements Update','achievement_corrupt_update.php','1343436995','86400','afefaecc0e31e412c28dbab154e43f9d','1','Updates user corrupt achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('56','Achievements Update','achievement_fpost_update.php','1343437005','86400','f466ff2246e7e84bc60210aa947185da','1','Updates user forum post achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('57','Achievements Update','achievement_ftopics_update.php','1343437011','86400','825f6cac5fa992f505ceea3992db5483','1','Updates user forum topic achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('58','Achievements Update','achievement_invite_update.php','1343437021','86400','02e56c3aeba0b1e3e4bcca11699f23eb','1','Updates user invite achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('59','Achievements Update','achievement_karma_update.php','1343437028','86400','3827839629ade62f03a9fccbacb8402a','1','Updates user Karma achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('60','Achievements Update','achievement_request_update.php','1343437069','86400','48ec70ecc00c88b37977e2743d294888','1','Updates user request achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('61','Achievements Update','achievement_seedtime_update.php','1343437078','86400','158fb134b7a1487bdda67d42544693fc','1','Updates user seedtime achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('62','Achievements Update','achievement_sheep_update.php','1343437099','86400','97c3919a5947e00952bf82d1dc6f5c58','1','Updates user sheep achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('63','Achievements Update','achievement_shouts_update.php','1343437084','86400','b07151b274bb6d568ab1bc3b3364cb6c','1','Updates user shout achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('64','Achievements Update','achievement_sig_update.php','1343437104','86400','82c3ff41b8e45a96bcd1582345d6dca9','1','Updates user signature achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('65','Achievements Update','achievement_sreset_update.php','1343437109','86400','b51582111414701c0bd512fd2b4f0507','1','Updates user achievements - Reset shouts','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('66','Achievements Update','achievement_sticky_update.php','1343437115','86400','00aaf60d3806924a42e95e64ee00c5fb','1','Updates user sticky torrents achievements','1'); | |
| +insert into `cleanup` (`clean_id`, `clean_title`, `clean_file`, `clean_time`, `clean_increment`, `clean_cron_key`, `clean_log`, `clean_desc`, `clean_on`) values('67','Achievements Update','achievement_up_update.php','1343437120','86400','b0feb2e2c22dbf9f1575c798a5d1560d','1','Updates user uploader achievements','1'); | |
| + | |
| +## Data for the table `cleanup_log` | |
| + | |
| +## Data for the table `coins` | |
| + | |
| +## Data for the table `comments` | |
| + | |
| +## Data for the table `countries` | |
| + | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('1','Sweden','sweden.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('2','United States of America','usa.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('3','Russia','russia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('4','Finland','finland.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('5','Canada','canada.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('6','France','france.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('7','Germany','germany.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('8','China','china.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('9','Italy','italy.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('10','Denmark','denmark.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('11','Norway','norway.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('12','United Kingdom','uk.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('13','Ireland','ireland.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('14','Poland','poland.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('15','Netherlands','netherlands.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('16','Belgium','belgium.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('17','Japan','japan.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('18','Brazil','brazil.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('19','Argentina','argentina.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('20','Australia','australia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('21','New Zealand','newzealand.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('22','Spain','spain.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('23','Portugal','portugal.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('24','Mexico','mexico.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('25','Singapore','singapore.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('67','India','india.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('62','Albania','albania.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('26','South Africa','southafrica.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('27','South Korea','southkorea.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('28','Jamaica','jamaica.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('29','Luxembourg','luxembourg.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('30','Hong Kong','hongkong.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('31','Belize','belize.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('32','Algeria','algeria.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('33','Angola','angola.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('34','Austria','austria.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('35','Yugoslavia','yugoslavia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('36','Western Samoa','westernsamoa.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('37','Malaysia','malaysia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('38','Dominican Republic','dominicanrep.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('39','Greece','greece.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('40','Guatemala','guatemala.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('41','Israel','israel.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('42','Pakistan','pakistan.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('43','Czech Republic','czechrep.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('44','Serbia','serbia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('45','Seychelles','seychelles.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('46','Taiwan','taiwan.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('47','Puerto Rico','puertorico.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('48','Chile','chile.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('49','Cuba','cuba.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('50','Congo','congo.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('51','Afghanistan','afghanistan.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('52','Turkey','turkey.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('53','Uzbekistan','uzbekistan.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('54','Switzerland','switzerland.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('55','Kiribati','kiribati.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('56','Philippines','philippines.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('57','Burkina Faso','burkinafaso.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('58','Nigeria','nigeria.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('59','Iceland','iceland.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('60','Nauru','nauru.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('61','Slovenia','slovenia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('63','Turkmenistan','turkmenistan.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('64','Bosnia Herzegovina','bosniaherzegovina.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('65','Andorra','andorra.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('66','Lithuania','lithuania.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('68','Netherlands Antilles','nethantilles.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('69','Ukraine','ukraine.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('70','Venezuela','venezuela.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('71','Hungary','hungary.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('72','Romania','romania.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('73','Vanuatu','vanuatu.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('74','Vietnam','vietnam.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('75','Trinidad & Tobago','trinidadandtobago.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('76','Honduras','honduras.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('77','Kyrgyzstan','kyrgyzstan.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('78','Ecuador','ecuador.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('79','Bahamas','bahamas.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('80','Peru','peru.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('81','Cambodia','cambodia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('82','Barbados','barbados.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('83','Bangladesh','bangladesh.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('84','Laos','laos.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('85','Uruguay','uruguay.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('86','Antigua Barbuda','antiguabarbuda.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('87','Paraguay','paraguay.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('89','Thailand','thailand.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('88','Union of Soviet Socialist Republics','ussr.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('90','Senegal','senegal.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('91','Togo','togo.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('92','North Korea','northkorea.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('93','Croatia','croatia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('94','Estonia','estonia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('95','Colombia','colombia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('96','Lebanon','lebanon.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('97','Latvia','latvia.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('98','Costa Rica','costarica.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('99','Egypt','egypt.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('100','Bulgaria','bulgaria.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('101','Scotland','scotland.gif'); | |
| +insert into `countries` (`id`, `name`, `flagpic`) values('102','United Arab Emirates','uae.gif'); | |
| + | |
| +## Data for the table `dbbackup` | |
| + | |
| +## Data for the table `events` | |
| + | |
| +insert into `events` (`id`, `userid`, `startTime`, `endTime`, `overlayText`, `displayDates`, `freeleechEnabled`, `duploadEnabled`, `hdownEnabled`) values('1','1','1354629410','1354888610','FreeLeech [ON]','1','0','0','0'); | |
| + | |
| +## Data for the table `failedlogins` | |
| + | |
| +## Data for the table `files` | |
| + | |
| +## Data for the table `forum_config` | |
| + | |
| +insert into `forum_config` (`id`, `delete_for_real`, `min_delete_view_class`, `readpost_expiry`, `min_upload_class`, `accepted_file_extension`, `accepted_file_types`, `max_file_size`, `upload_folder`) values('13','1','4','7','6','a:3:{i:0;s:3:\"zip\";i:1;s:3:\"rar\";i:2;s:0:\"\";}','a:3:{i:0;s:15:\"application/zip\";i:1;s:15:\"application/rar\";i:2;s:0:\"\";}','2097152','C:/webdev/htdocs/uploads/'); | |
| + | |
| +## Data for the table `forum_poll` | |
| + | |
| +## Data for the table `forum_poll_votes` | |
| + | |
| +## Data for the table `forums` | |
| + | |
| +## Data for the table `freeleech` | |
| + | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('1','Contribute 1 to Site Countdown Pot','1','Donate 1 coin and 1 minute will be removed from the Countdown.','contribute','60'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('2','Contribute 5 to Site Countdown Pot','5','Donate 5 coins and 5 minutes will be removed from the Countdown.','contribute','300'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('3','Contribute 10 to Site Countdown Pot','10','Donate 10 coins and 10 minutes will be removed from the Countdown.','contribute','600'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('4','Contribute 25 to Site Countdown Pot','25','Donate 25 coins and 25 minutes will be removed from the Countdown.','contribute','1500'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('5','Contribute 50 to Site Countdown Pot','50','Donate 50 coins and 50 minutes will be removed from the Countdown.','contribute','3000'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('6','Contribute 100 to Site Countdown Pot','100','Donate 100 coins and 1 hour and 40 minutes will be removed from the Countdown.','contribute','6000'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('7','Contribute 500 to Site Countdown Pot','500','Donate 500 coins and 8 hours and 20 minutes will be removed from the Countdown.','contribute','30000'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('8','Contribute 1000 to Site Countdown Pot','1000','Donate 1000 coins and 16 hours and 40 minutes will be removed from the Countdown.','contribute','60000'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('9','Contribute to Site Countdown Pot','0','Enter a custom amount to donate. ','contribut3','0'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('10','Freeleech','0','Freeleech Sunday is enabled','countdown','1318201200'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('11','Sitewide Freeleech','0','set by','manual','0'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('12','Sitewide Doubleseed','0','set by ','manual','0'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('13','Sitewide Freeleech and Doubleseed','0','set by','manual','0'); | |
| +insert into `freeleech` (`id`, `name`, `var`, `description`, `type`, `amount`) values('15','Crazy Hour','1320940444','Freeleech and Double Upload credit for 24 Hours','crazyhour','0'); | |
| + | |
| +## Data for the table `freeslots` | |
| + | |
| +## Data for the table `friends` | |
| + | |
| +## Data for the table `funds` | |
| + | |
| +## Data for the table `happyhour` | |
| + | |
| +## Data for the table `happylog` | |
| + | |
| +## Data for the table `infolog` | |
| + | |
| +## Data for the table `invite_codes` | |
| + | |
| +## Data for the table `ips` | |
| + | |
| +## Data for the table `lottery_config` | |
| + | |
| +insert into `lottery_config` (`name`, `value`) values('ticket_amount','10000'); | |
| +insert into `lottery_config` (`name`, `value`) values('ticket_amount_type','seedbonus'); | |
| +insert into `lottery_config` (`name`, `value`) values('user_tickets','50'); | |
| +insert into `lottery_config` (`name`, `value`) values('class_allowed','0|1|2|3|4|5|6'); | |
| +insert into `lottery_config` (`name`, `value`) values('total_winners','5'); | |
| +insert into `lottery_config` (`name`, `value`) values('prize_fund','10000000'); | |
| +insert into `lottery_config` (`name`, `value`) values('start_date','1303558113'); | |
| +insert into `lottery_config` (`name`, `value`) values('end_date','1303642713'); | |
| +insert into `lottery_config` (`name`, `value`) values('use_prize_fund','1'); | |
| +insert into `lottery_config` (`name`, `value`) values('enable','0'); | |
| +insert into `lottery_config` (`name`, `value`) values('lottery_winners',''); | |
| +insert into `lottery_config` (`name`, `value`) values('lottery_winners_amount','2000000'); | |
| +insert into `lottery_config` (`name`, `value`) values('lottery_winners_time','1303817233'); | |
| + | |
| +## Data for the table `messages` | |
| + | |
| +## Data for the table `moods` | |
| + | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('1','is a slurpee ninja','ninja.gif','1'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('2','is headbanging','punk.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('3','is grooving to the music','music.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('4','is farting','fart3.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('5','is hard at work','elektrik.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('6','is feeling artistic','graffiti.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('7','is feeling Good!','good.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('8','is having a cig','cigar.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('9','is eating cookies','cookies.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('10','is telling a story','talk2.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('11','is pissed drunk','drinks.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('12','Is old','oldman.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('13','is in bed','sleeping.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('14','is kenny','kenny.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('15','is feeling lucky','clover.gif','1'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('16','is feeling super','super.gif','1'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('17','is bouncing','trampoline.gif','1'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('18','is drinking cola','pepsi.gif','1'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('19','is hitting the bong','bong.gif','1'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('20','is spidey','spidey.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('21','is taz!','taz.gif','1'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('22','is wanted','wanted.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('23','is a wizard','wizard.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('24','is a pissed off','soapbox1.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('25','is da bomb','bomb.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('26','hitting the bhong','bhong.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('27','is smiling','smile2.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('28','is cheerful','clapper1.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('29','is crazy','crazy.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('30','Is banned','banned.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('31','is teasing','blum.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('32','is headbanging','mini4.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('33','is wacko','wacko.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('34','woof woof!','pish.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('35','is crabby','evilmad.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('36','is dead','wink_skull.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('37','is bored','tumbleweed.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('38','is in shock','sheesh.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('39','is feeling weird','weirdo.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('40','is stoned','smokin.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('41','is feeling smart','smart.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('42','is feeling sly','sly.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('43','is feeling like shit','shit.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('44','is feeling like a pimp','pimp.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('45','is feeling old','oldtimer.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('46','is a ninja','ninja.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('47','is into the music','music.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('48','is feeling like a king','king.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('49','is feeling lazy','smoke2.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('50','is feeling like kissing','kissing2.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('52','is laughing out loud','laugh.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('53','is feeling innocent','innocent.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('54','is feeling like a winner','hooray.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('55','is having fun','fun.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('56','has gone fishing','fishing.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('57','is drunk','drunk.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('58','is feeling crazy','crazy.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('59','is dancing','mml.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('60','is feeling like crying','cry.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('61','needs coffee','cuppa.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('62','is feeling bossy','cigar.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('63','is feeling like an angel','angeldevil.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('64','is feeling like an angel','angel.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('65','is drinking','beer.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('66','is drinking with friends','beer2.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('67','is feeling bananas','bananadance.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('68','is feeling awesome','w00t.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('69','is feeling like a tease','tease.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('70','is feeling happy','smile1.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('71','yarrr matey','pirate2.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('72','is feeling yucky','yucky.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('73','devil','devil.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('74','is feeling devilish','devil.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('75','is feeling like ranting','rant.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('76','is a pirate','pirate.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('77','in love','love.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('78','is feeling silly','clown.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('79','is feeling sad','wavecry.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('80','in wub','wub.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('81','is feeling angry','angry.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('82','is feeling tired','yawn.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('83','is feeling good','grin.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('84','is feeling bad','wall.gif','0'); | |
| +insert into `moods` (`id`, `name`, `image`, `bonus`) values('85','is feeling neutral','noexpression.gif','0'); | |
| + | |
| +## Data for the table `news` | |
| + | |
| +## Data for the table `notconnectablepmlog` | |
| + | |
| +## Data for the table `now_viewing` | |
| + | |
| +## Data for the table `offer_votes` | |
| + | |
| +## Data for the table `offers` | |
| + | |
| +## Data for the table `over_forums` | |
| + | |
| +## Data for the table `paypal_config` | |
| + | |
| +insert into `paypal_config` (`name`, `value`) values('email','Bigjoos1@hotmail.co.uk'); | |
| +insert into `paypal_config` (`name`, `value`) values('gb','3'); | |
| +insert into `paypal_config` (`name`, `value`) values('weeks','4'); | |
| +insert into `paypal_config` (`name`, `value`) values('invites','1'); | |
| +insert into `paypal_config` (`name`, `value`) values('enable','1'); | |
| + | |
| +## Data for the table `peers` | |
| + | |
| +## Data for the table `pmboxes` | |
| + | |
| +## Data for the table `poll_voters` | |
| + | |
| +## Data for the table `polls` | |
| + | |
| +## Data for the table `posts` | |
| + | |
| +## Data for the table `promo` | |
| + | |
| +## Data for the table `rating` | |
| + | |
| +## Data for the table `read_posts` | |
| + | |
| +## Data for the table `relations` | |
| + | |
| +## Data for the table `reports` | |
| + | |
| +## Data for the table `reputation` | |
| + | |
| +## Data for the table `reputationlevel` | |
| + | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('1','-999999','is infamous around these parts'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('2','-50','can only hope to improve'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('3','-10','has a little shameless behaviour in the past'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('4','0','is an unknown quantity at this point'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('5','15','is on a distinguished road'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('6','50','will become famous soon enough'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('7','150','has a spectacular aura about'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('8','250','is a jewel in the rough'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('9','350','is just really nice'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('10','450','is a glorious beacon of light'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('11','550','is a name known to all'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('12','650','is a splendid one to behold'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('13','1000','has much to be proud of'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('14','1500','has a brilliant future'); | |
| +insert into `reputationlevel` (`reputationlevelid`, `minimumreputation`, `level`) values('15','2000','has a reputation beyond repute'); | |
| + | |
| +## Data for the table `request_votes` | |
| + | |
| +## Data for the table `requests` | |
| + | |
| +## Data for the table `searchcloud` | |
| + | |
| +insert into `searchcloud` (`id`, `searchedfor`, `howmuch`, `ip`) values('1','Testing','1',''); | |
| + | |
| +## Data for the table `shit_list` | |
| + | |
| +## Data for the table `shoutbox` | |
| + | |
| +## Data for the table `site_config` | |
| + | |
| +insert into `site_config` (`name`, `value`) values('site_online','1'); | |
| +insert into `site_config` (`name`, `value`) values('autoshout_on','1'); | |
| +insert into `site_config` (`name`, `value`) values('seedbonus_on','1'); | |
| +insert into `site_config` (`name`, `value`) values('openreg','true'); | |
| +insert into `site_config` (`name`, `value`) values('forums_online','1'); | |
| +insert into `site_config` (`name`, `value`) values('maxusers','10000'); | |
| +insert into `site_config` (`name`, `value`) values('invites','5000'); | |
| +insert into `site_config` (`name`, `value`) values('openreg_invites','true'); | |
| +insert into `site_config` (`name`, `value`) values('failedlogins','5'); | |
| +insert into `site_config` (`name`, `value`) values('ratio_free','true'); | |
| +insert into `site_config` (`name`, `value`) values('captcha_on','true'); | |
| +insert into `site_config` (`name`, `value`) values('dupeip_check_on','true'); | |
| +insert into `site_config` (`name`, `value`) values('totalneeded','50'); | |
| + | |
| +## Data for the table `sitelog` | |
| + | |
| +## Data for the table `snatched` | |
| + | |
| +## Data for the table `staffmessages` | |
| + | |
| +## Data for the table `staffpanel` | |
| + | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('1','Flood Control','staffpanel.php?tool=floodlimit','Manage flood limits','5','1','1277910147'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('2','Coders Log','staffpanel.php?tool=editlog','Coders site file edit log','6','1','1277909868'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('3','Bonus Manager','staffpanel.php?tool=bonusmanage','Site karma bonus manager','5','1','1277910813'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('4','Non Connectables','staffpanel.php?tool=findnotconnectable','Find - Pm non-connectable users','4','1','1277911274'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('5','Edit Events','staffpanel.php?tool=events','Edit - Add Freeleech/doubleseed/halfdownload events','6','1','1277911847'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('6','Site Log','staffpanel.php?tool=log','View site log','4','1','1277912694'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('7','Poll Manager','staffpanel.php?tool=polls_manager','Add - Edit site polls','4','1','1277912814'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('8','Ban Ips','staffpanel.php?tool=bans','Cached ip ban manager','4','1','1277912935'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('9','Add user','staffpanel.php?tool=adduser','Add new users from site','5','1','1277912999'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('10','Extra Stats','staffpanel.php?tool=stats_extra','View graphs of site stats','5','1','1277913051'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('11','Templates','staffpanel.php?tool=themes','Site template manager','6','1','1277913213'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('12','Tracker Stats','staffpanel.php?tool=stats','View uploader and category activity','4','1','1277913435'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('13','Shoutbox History','staffpanel.php?tool=shistory','View shout history','4','1','1277913521'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('14','Backup Db','staffpanel.php?tool=backup','Mysql Database Back Up','6','1','1277913720'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('15','Usersearch','staffpanel.php?tool=usersearch','Mass pm and Mass announcement system','5','1','1277913916'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('16','Mysql Stats','staffpanel.php?tool=mysql_stats','Mysql server stats','6','1','1277914654'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('17','Failed Logins','staffpanel.php?tool=failedlogins','Clear Failed Logins','4','1','1277914881'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('18','Inactive Users','staffpanel.php?tool=inactive','Manage inactive users','4','1','1277915991'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('19','Reset Passwords','staffpanel.php?tool=reset','Reset lost passwords','4','1','1277916104'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('20','Forum Manager','staffpanel.php?tool=forum_manage','Forum admin and management','5','1','1277916172'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('21','Overforum Manager','staffpanel.php?tool=over_forums','Over Forum admin and management','5','1','1277916240'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('22','Edit Categories','staffpanel.php?tool=categories','Manage site categories','6','1','1277916351'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('23','Reputation Admin','staffpanel.php?tool=reputation_ad','Reputation system admin','6','1','1277916398'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('24','Reputation Settings','staffpanel.php?tool=reputation_settings','Manage reputation settings','6','1','1277916443'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('25','News Admin','staffpanel.php?tool=news&mode=news','Add - Edit site news','4','1','1277916501'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('26','Freeleech Manage','staffpanel.php?tool=freeleech','Manage site wide freeleech','5','1','1277916603'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('27','Freeleech Users','staffpanel.php?tool=freeusers','View freeleech users','5','1','1277916636'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('28','Site Donations','staffpanel.php?tool=donations','View all/current site donations','6','1','1277916690'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('29','View Reports','staffpanel.php?tool=reports','Respond to site reports','4','1','1278323407'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('30','Delete','staffpanel.php?tool=delacct','Delete user accounts','4','1','1278456787'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('31','Username change','staffpanel.php?tool=namechanger','Change usernames here.','6','1','1278886954'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('32','Blacklist','staffpanel.php?tool=nameblacklist','Control username blacklist.','4','1','1279054005'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('33','System Overview','staffpanel.php?tool=system_view','Monitor load averages and view phpinfo','6','1','1277910147'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('34','Snatched Overview','staffpanel.php?tool=snatched_torrents','View all snatched torrents','4','1','1277910147'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('35','Pm Overview','staffpanel.php?tool=pmview','Pm overview - For monitoring only !!!','6','1','1277910147'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('36','Data Reset','staffpanel.php?tool=datareset','Reset download stats for nuked torrents','5','1','1277910147'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('37','Dupe Ip Check','staffpanel.php?tool=ipcheck','Check duplicate ips','4','1','1277910147'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('38','Lottery','lottery.php','Configure lottery','4','1','1282824272'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('39','Group Pm','staffpanel.php?tool=grouppm','Send grouped pms','4','1','1282838663'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('40','Client Ids','staffpanel.php?tool=allagents','View all client id','6','1','1283592994'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('41','Forum Config','staffpanel.php?tool=forum_config','Configure forums','5','1','1284303053'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('42','Sysop log','staffpanel.php?tool=sysoplog','View staff actions','6','1','1284686084'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('43','Server Load','staffpanel.php?tool=load','View current server load','6','1','1284900585'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('44','Promotions','promo.php','Add new signup promotions','4','1','1286231384'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('45','Account Manage','staffpanel.php?tool=acpmanage','Account manager - Conifrm pending users','4','1','1289950651'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('46','Block Manager','staffpanel.php?tool=block.settings','Manage Global site block settings','6','1','1292185077'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('47','Advanced Mega Search','staffpanel.php?tool=mega_search','Search by ip, invite code, username','6','1','1292333576'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('48','Warnings','staffpanel.php?tool=warn&mode=warn','Warning Management','4','1','1294788655'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('49','Leech Warnings','staffpanel.php?tool=leechwarn','Leech Warning Management','4','1','1294794876'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('50','Hnr Warnings','staffpanel.php?tool=hnrwarn','Hit And Run Warning Management','4','1','1294794904'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('51','Site Peers','staffpanel.php?tool=view_peers','Site Peers Overview','4','1','1296099600'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('52','Top Uploaders','staffpanel.php?tool=uploader_info','View site top uploaders','4','1','1297907345'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('53','Paypal Settings','staffpanel.php?tool=paypal_settings','Adjust global paypal settings here','6','1','1304288197'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('54','Staff Config','staffpanel.php?tool=staff_config','Update allowed staff arrays here','6','1','1304342083'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('55','Site Settings','staffpanel.php?tool=site_settings','Adjust site settings here','6','1','1304422497'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('56','Paypal Confirm','staffpanel.php?tool=paypal_manual_confirm','Manually confirm donations here','6','1','1304869394'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('57','APC Manage','staffpanel.php?tool=apc','View APC manager','6','1','1305728681'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('58','Memcache Manage','staffpanel.php?tool=memcache','View memcache manager','6','1','1305728711'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('59','Edit Moods','staffpanel.php?tool=edit_moods','Edit site usermoods here','4','1','1308914441'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('60','Search Cloud Manage','staffpanel.php?tool=cloudview','Manage searchcloud entries','5','1','1311359588'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('61','Mass Bonus Manager','staffpanel.php?tool=mass_bonus_for_members','MassUpload, MassSeedbonus, MassFreeslot, MassInvite','5','1','1311882635'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('62','Hit And Runs','staffpanel.php?tool=hit_and_run','View All Hit And Runs','5','1','1312682819'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('63','View Possible Cheats','staffpanel.php?tool=cheaters','View All Cheat Information','5','1','1312682871'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('64','Cleanup Manager','staffpanel.php?tool=cleanup_manager','Clean up interval manager','6','1','1315001255'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('65','Uploader Applications','staffpanel.php?tool=uploadapps&action=app','Manage Uploader Applications','4','1','1325807155'); | |
| +insert into `staffpanel` (`id`, `page_name`, `file_name`, `description`, `av_class`, `added_by`, `added`) values('66','Staff Shout History','staffpanel.php?tool=staff_shistory','View staff shoutbox history','4','1','1328723553'); | |
| + | |
| +## Data for the table `stats` | |
| + | |
| +insert into `stats` (`id`, `regusers`, `unconusers`, `torrents`, `seeders`, `leechers`, `torrentstoday`, `donors`, `unconnectables`, `forumtopics`, `forumposts`, `numactive`, `torrentsmonth`, `gender_na`, `gender_male`, `gender_female`, `powerusers`, `disabled`, `uploaders`, `moderators`, `administrators`, `sysops`) values('1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1'); | |
| + | |
| +## Data for the table `stylesheets` | |
| + | |
| +insert into `stylesheets` (`id`, `uri`, `name`) values('1','1.css','Default V3 Skin'); | |
| + | |
| +## Data for the table `subscriptions` | |
| + | |
| +## Data for the table `subtitles` | |
| + | |
| +## Data for the table `thanks` | |
| + | |
| +## Data for the table `thankyou` | |
| + | |
| +## Data for the table `thumbsup` | |
| + | |
| +## Data for the table `tickets` | |
| + | |
| +## Data for the table `topics` | |
| + | |
| +## Data for the table `torrents` | |
| + | |
| +## Data for the table `uploadapp` | |
| + | |
| +## Data for the table `user_blocks` | |
| + | |
| +## Data for the table `user_config` | |
| + | |
| +insert into `user_config` (`name`, `value`) values('UC_USER','0'); | |
| +insert into `user_config` (`name`, `value`) values('UC_POWER_USER','1'); | |
| +insert into `user_config` (`name`, `value`) values('UC_VIP','2'); | |
| +insert into `user_config` (`name`, `value`) values('UC_UPLOADER','3'); | |
| +insert into `user_config` (`name`, `value`) values('UC_MODERATOR','4'); | |
| +insert into `user_config` (`name`, `value`) values('UC_ADMINISTRATOR','5'); | |
| +insert into `user_config` (`name`, `value`) values('UC_SYSOP','6'); | |
| +insert into `user_config` (`name`, `value`) values('UC_MIN','0'); | |
| +insert into `user_config` (`name`, `value`) values('UC_MAX','6'); | |
| +insert into `user_config` (`name`, `value`) values('UC_STAFF','4'); | |
| + | |
| +## Data for the table `usercomments` | |
| + | |
| +## Data for the table `userhits` | |
| + | |
| +## Data for the table `users` | |
| + | |
| +## Data for the table `usersachiev` | |
| + | |
| +## Data for the table `ustatus` | |
| + | |
| +## Data for the table `wiki` | |
| + | |
| +insert into `wiki` (`id`, `name`, `body`, `userid`, `time`, `lastedit`, `lastedituser`) values('1','index','[align=center][size=6]Welcome to the [b]Wiki[/b][/size][/align]','0','1228076412','1281610709','1'); | |
| diff --git a/install/extra/script_text_locales.sql b/install/extra/script_text_locales.sql | |
| new file mode 100644 | |
| index 0000000..088dd56 | |
| --- /dev/null | |
| +++ b/install/extra/script_text_locales.sql | |
| @@ -0,0 +1,717 @@ | |
| +## Table structure | |
| + | |
| +CREATE TABLE script_texts ( | |
| +id INTEGER PRIMARY KEY, | |
| +deftext TEXT, | |
| +locale TEXT | |
| +); | |
| + | |
| +## Text data default | |
| + | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('This was already installed, huh ? how this happened',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Unknown action',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Submit data',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('All done',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Installation complete',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Directory check',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('It looks like you need to chmod some directories!',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('all directories marked in red should be chmoded 0777',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Reload',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Next step',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Host',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Usually this will be localhost unless your on a cluster server.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Username',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Your mysql username.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Password',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Your mysql password.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Database',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Your mysql database name.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Table prefix',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Prefix that you''ll give to tables [default ''U232v3'']',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Announce Url',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Your announce url.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('HTTPS Announce Url',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Your HTTPS announce url.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Site Email',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Your site email address.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Site Name',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Your site name.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Prefix',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Path',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Only required for sub-domain installs.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Cookie Domain',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Your domain name - note exclude http and www.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Domain',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Your site domain name - note exclude http or www.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Your domain name - note include http and www.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Write config',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Config file was saved',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Config file could not be saved',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Config file was already written',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Announce file was saved',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('announce file could not be saved',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Announce file was already written',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Go back',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Connection to database no issues reported, data may be imported.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Import database',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('The connection to the database reported the next issue: ',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('There was an error while importing the structure: ',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('check for error.',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('The structure of database was imported successful',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('There was an error while importing the basicdata: ',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Basicdata of database was imported successful',:lang); | |
| +INSERT INTO script_texts (deftext,locale) VALUES ('Finish',:lang); | |
| +## and so.... | |
| + | |
| +## Only will update 'locale' field with the correspond of your language, | |
| +## so will occupy just the memory needed. | |
| +## To update your language, just replaced NULL by your 'translated phrase'. | |
| + | |
| +## Acronym's meaning | |
| +## 'deftext'=> 'English' - en | |
| +## 'locale' => 'German' - de | |
| +## 'locale' => 'French' - fr | |
| +## 'locale' => 'Italian' - it | |
| +## 'locale' => 'Chinese' - zh | |
| +## 'locale' => 'Portuguese' - pt | |
| +## 'locale' => 'Spanish' - es | |
| +## 'locale' => 'Korean' - ko | |
| +## 'locale' => 'Russian' - ru | |
| + | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Esto ya estaba instalado, ¿cómo puede ser eso, eh?' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='This was already installed, huh ? how this happened'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Acción desconocida' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Unknown action'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Enviar datos' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Submit data'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Todo hecho' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='All done'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Instalación completa' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Installation complete'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Verificacón de Directorios' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Directory check'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN '¡Parece que algunos directorios necesitan chmod!' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='It looks like you need to chmod some directories!'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'todos los directorios marcados en rojo deben tener un chmod 0777' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='all directories marked in red should be chmoded 0777'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Refrescar' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Reload'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Siguiente paso' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Next step'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN NULL | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Host'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Normalmente debe ser localhost a menos que servidor esté en un clúster.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Usually this will be localhost unless your on a cluster server.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Nombre de usuario' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Username'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Nombre de usuario en Mysql' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Your mysql username.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Contraseña' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Password'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Tu contraseña en Mysql' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Your mysql password.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Base de datos' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Database'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Nombre de la Base de datos' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Your mysql database name.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Prefijo de tablas' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Table prefix'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Prefijo que tendrán las tablas [predeterminado ''U232v3'']' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Prefix that you''ll give to tables [default ''U232v3'']'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Url de Announce' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Announce Url'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'La Url del Announce.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Your announce url.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Url HTTPS del Announce' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='HTTPS Announce Url'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'La Url como HTTPS del Announce.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Your HTTPS announce url.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Email del Site' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Site Email'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Dirección e-mail del Site.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Your site email address.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Nombre del Site' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Site Name'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'El nombre del Site.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Your site name.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Prefijo' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Prefix'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Sólo se necesita en instalaciones para sub-dominios.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Only required for sub-domain installs.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Ruta' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Path'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Dominio de la Cookie' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Cookie Domain'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'El nombre de tu dominio - Nota excluir http y www.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Your domain name - note exclude http and www.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Doninio' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Domain'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Su nombre de dominio del Site - Nota excluir http y www.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Your site domain name - note exclude http or www.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'El nombre de tu dominio - Nota incluir http y www.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Your domain name - note include http and www.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Escribir config' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Write config'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'El archivo config se ha guardado' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Config file was saved'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'El archivo config no se pudo guardar' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Config file could not be saved'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'El archivo config estaba ya escrito' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Config file was already written'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'El archivo announce se ha guardado' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Announce file was saved'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'El archivo announce no se pudo guardar' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='announce file could not be saved'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'El archivo announce estaba ya escrito' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Announce file was already written'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Volver' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Go back'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'La conexión a la base de datos no reportó problemas, los datos pueden ser importados.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Connection to database no issues reported, data may be imported.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Importar base de datos' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Import database'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'La conexión a la base de datos reportó el problema siguiente: ' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='The connection to the database reported the next issue: '; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Se ha producido un error al importar la estructura: ' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='There was an error while importing the structure: '; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'comprueba el error.' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='check for error.'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'La estructura de base de datos se ha importado con éxito' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='The structure of database was imported successful'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Se ha producido un error al importar el Datos: ' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='There was an error while importing the basicdata: '; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Datos de la base de datos importados correctamente' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Basicdata of database was imported successful'; | |
| +UPDATE script_texts SET locale = CASE | |
| +WHEN locale = 'de' THEN NULL | |
| +WHEN locale = 'fr' THEN NULL | |
| +WHEN locale = 'it' THEN NULL | |
| +WHEN locale = 'zh' THEN NULL | |
| +WHEN locale = 'pt' THEN NULL | |
| +WHEN locale = 'es' THEN 'Finalizar' | |
| +WHEN locale = 'ko' THEN NULL | |
| +WHEN locale = 'ru' THEN NULL | |
| +ELSE locale | |
| +END | |
| +WHERE deftext='Finish'; | |
| +## and so.... | |
| diff --git a/install/extra/structure.sql b/install/extra/structure.sql | |
| new file mode 100644 | |
| index 0000000..f69179c | |
| --- /dev/null | |
| +++ b/install/extra/structure.sql | |
| @@ -0,0 +1,1496 @@ | |
| +## Structure | |
| +## Database version: U-232 V3 | |
| +## ************************** | |
| + | |
| +SET NAMES utf8; | |
| +SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; | |
| +SET time_zone = "+00:00"; | |
| + | |
| +## Table structure for table `ach_bonus` | |
| + | |
| +CREATE TABLE `ach_bonus` ( | |
| + `bonus_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, | |
| + `bonus_desc` text NOT NULL, | |
| + `bonus_type` tinyint(4) NOT NULL DEFAULT '0', | |
| + `bonus_do` text NOT NULL, | |
| + PRIMARY KEY (`bonus_id`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `achievementist` | |
| + | |
| +CREATE TABLE `achievementist` ( | |
| + `id` int(5) NOT NULL AUTO_INCREMENT, | |
| + `achievname` varchar(40) DEFAULT NULL, | |
| + `notes` varchar(250) DEFAULT NULL, | |
| + `clienticon` varchar(255) DEFAULT NULL, | |
| + UNIQUE KEY `id` (`id`), | |
| + KEY `hostname` (`achievname`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=87 DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `achievements` | |
| + | |
| +CREATE TABLE `achievements` ( | |
| + `id` int(5) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(5) NOT NULL DEFAULT '0', | |
| + `achievement` varchar(255) DEFAULT NULL, | |
| + `date` int(11) NOT NULL DEFAULT '0', | |
| + `icon` varchar(50) DEFAULT NULL, | |
| + `description` varchar(255) DEFAULT NULL, | |
| + `achievementid` int(5) NOT NULL DEFAULT '0', | |
| + UNIQUE KEY `id` (`id`), | |
| + KEY `userid` (`userid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `announcement_main` | |
| + | |
| +CREATE TABLE `announcement_main` ( | |
| + `main_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `owner_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `created` int(11) NOT NULL DEFAULT '0', | |
| + `expires` int(11) NOT NULL DEFAULT '0', | |
| + `sql_query` text NOT NULL, | |
| + `subject` text NOT NULL, | |
| + `body` text NOT NULL, | |
| + PRIMARY KEY (`main_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `announcement_process` | |
| + | |
| +CREATE TABLE `announcement_process` ( | |
| + `process_id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `main_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `status` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`process_id`), | |
| + KEY `user_id` (`user_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `attachments` | |
| + | |
| +CREATE TABLE `attachments` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `post_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `file_name` varchar(255) NOT NULL DEFAULT '', | |
| + `file` varchar(255) NOT NULL DEFAULT '', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + `extension` enum('zip','rar') NOT NULL DEFAULT 'zip', | |
| + `size` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `times_downloaded` int(10) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `post_id` (`post_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `avps` | |
| + | |
| +CREATE TABLE `avps` ( | |
| + `arg` varchar(20) NOT NULL, | |
| + `value_s` text NOT NULL, | |
| + `value_i` int(11) NOT NULL DEFAULT '0', | |
| + `value_u` int(10) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`arg`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `bannedemails` | |
| + | |
| +CREATE TABLE `bannedemails` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `added` int(11) NOT NULL, | |
| + `addedby` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `email` (`email`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `bans` | |
| + | |
| +CREATE TABLE `bans` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `added` int(11) NOT NULL, | |
| + `addedby` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + `first` int(11) DEFAULT NULL, | |
| + `last` int(11) DEFAULT NULL, | |
| + PRIMARY KEY (`id`), | |
| + KEY `first_last` (`first`,`last`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `blackjack` | |
| + | |
| +CREATE TABLE `blackjack` ( | |
| + `userid` int(11) NOT NULL DEFAULT '0', | |
| + `points` int(11) NOT NULL DEFAULT '0', | |
| + `status` enum('playing','waiting') COLLATE utf8_bin NOT NULL DEFAULT 'playing', | |
| + `cards` text COLLATE utf8_bin NOT NULL, | |
| + `date` int(11) DEFAULT '0', | |
| + `gameover` enum('yes','no') COLLATE utf8_bin NOT NULL DEFAULT 'no', | |
| + PRIMARY KEY (`userid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; | |
| + | |
| +## Table structure for table `blocks` | |
| + | |
| +CREATE TABLE `blocks` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `blockid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `userfriend` (`userid`,`blockid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `bonus` | |
| + | |
| +CREATE TABLE `bonus` ( | |
| + `id` int(5) NOT NULL AUTO_INCREMENT, | |
| + `bonusname` varchar(50) NOT NULL DEFAULT '', | |
| + `points` decimal(10,1) NOT NULL DEFAULT '0.0', | |
| + `description` text NOT NULL, | |
| + `art` varchar(10) NOT NULL DEFAULT 'traffic', | |
| + `menge` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `pointspool` decimal(10,1) NOT NULL DEFAULT '1.0', | |
| + `enabled` enum('yes','no') NOT NULL DEFAULT 'yes' COMMENT 'This will determined a switch if the bonus is enabled or not! enabled by default', | |
| + `minpoints` decimal(10,1) NOT NULL, | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `bonuslog` | |
| + | |
| +CREATE TABLE `bonuslog` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `donation` decimal(10,1) NOT NULL, | |
| + `type` varchar(44) COLLATE utf8_unicode_ci NOT NULL, | |
| + `added_at` int(11) NOT NULL, | |
| + KEY `id` (`id`), | |
| + KEY `added_at` (`added_at`), | |
| + FULLTEXT KEY `type` (`type`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='log of contributors towards freeleech etc...'; | |
| + | |
| +## Table structure for table `bookmarks` | |
| + | |
| +CREATE TABLE `bookmarks` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `torrentid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `private` enum('yes','no') CHARACTER SET utf8 NOT NULL DEFAULT 'yes', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `bugs` | |
| + | |
| +CREATE TABLE `bugs` ( | |
| + `id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `sender` int(10) NOT NULL DEFAULT '0', | |
| + `added` int(12) NOT NULL DEFAULT '0', | |
| + `priority` enum('low','high','veryhigh') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'low', | |
| + `problem` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| + `status` enum('fixed','ignored','na') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'na', | |
| + `staff` int(10) NOT NULL DEFAULT '0', | |
| + `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `cards` | |
| + | |
| +CREATE TABLE `cards` ( | |
| + `id` int(11) NOT NULL AUTO_INCREMENT, | |
| + `points` int(11) NOT NULL DEFAULT '0', | |
| + `pic` text COLLATE utf8_bin NOT NULL, | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; | |
| + | |
| +## Table structure for table `casino` | |
| + | |
| +CREATE TABLE `casino` ( | |
| + `userid` int(10) NOT NULL DEFAULT '0', | |
| + `win` bigint(20) NOT NULL DEFAULT '0', | |
| + `lost` bigint(20) NOT NULL DEFAULT '0', | |
| + `trys` int(11) NOT NULL DEFAULT '0', | |
| + `date` int(11) NOT NULL DEFAULT '0', | |
| + `enableplay` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `deposit` bigint(20) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`userid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `casino_bets` | |
| + | |
| +CREATE TABLE `casino_bets` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) NOT NULL DEFAULT '0', | |
| + `proposed` varchar(40) COLLATE utf8_unicode_ci NOT NULL, | |
| + `challenged` varchar(40) COLLATE utf8_unicode_ci NOT NULL, | |
| + `amount` bigint(20) NOT NULL DEFAULT '0', | |
| + `time` int(11) NOT NULL DEFAULT '0', | |
| + `winner` varchar(25) COLLATE utf8_unicode_ci NOT NULL, | |
| + PRIMARY KEY (`id`), | |
| + KEY `userid` (`userid`,`proposed`,`challenged`,`amount`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `categories` | |
| + | |
| +CREATE TABLE `categories` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL, | |
| + `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + `cat_desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No Description', | |
| + `parent_id` mediumint(5) NOT NULL DEFAULT '-1', | |
| + `tabletype` tinyint(2) unsigned NOT NULL DEFAULT '1', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `cheaters` | |
| + | |
| +CREATE TABLE `cheaters` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `added` int(11) NOT NULL, | |
| + `userid` int(10) NOT NULL DEFAULT '0', | |
| + `torrentid` int(10) NOT NULL DEFAULT '0', | |
| + `client` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `rate` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `beforeup` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `upthis` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `timediff` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `userip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `cleanup` | |
| + | |
| +CREATE TABLE `cleanup` ( | |
| + `clean_id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `clean_title` char(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `clean_file` char(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `clean_time` int(11) NOT NULL DEFAULT '0', | |
| + `clean_increment` int(11) NOT NULL DEFAULT '0', | |
| + `clean_cron_key` char(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `clean_log` tinyint(1) NOT NULL DEFAULT '0', | |
| + `clean_desc` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `clean_on` tinyint(1) NOT NULL DEFAULT '1', | |
| + PRIMARY KEY (`clean_id`), | |
| + KEY `clean_time` (`clean_time`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `cleanup_log` | |
| + | |
| +CREATE TABLE `cleanup_log` ( | |
| + `clog_id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `clog_event` char(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `clog_time` int(11) NOT NULL DEFAULT '0', | |
| + `clog_ip` char(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', | |
| + `clog_desc` text COLLATE utf8_unicode_ci NOT NULL, | |
| + PRIMARY KEY (`clog_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `coins` | |
| + | |
| +CREATE TABLE `coins` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `torrentid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `points` int(10) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `torrentid` (`torrentid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `comments` | |
| + | |
| +CREATE TABLE `comments` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `user` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `torrent` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL, | |
| + `text` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `ori_text` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `editedby` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `editedat` int(11) NOT NULL, | |
| + `anonymous` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `request` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `offer` int(10) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `user` (`user`), | |
| + KEY `torrent` (`torrent`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `countries` | |
| + | |
| +CREATE TABLE `countries` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + `flagpic` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `dbbackup` | |
| + | |
| +CREATE TABLE `dbbackup` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `name` varchar(50) NOT NULL, | |
| + `added` int(10) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `events` | |
| + | |
| +CREATE TABLE `events` ( | |
| + `id` int(11) NOT NULL AUTO_INCREMENT, | |
| + `userid` int(11) NOT NULL, | |
| + `startTime` int(11) NOT NULL, | |
| + `endTime` int(11) NOT NULL, | |
| + `overlayText` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `displayDates` tinyint(1) NOT NULL, | |
| + `freeleechEnabled` tinyint(1) NOT NULL, | |
| + `duploadEnabled` tinyint(1) NOT NULL, | |
| + `hdownEnabled` tinyint(1) NOT NULL, | |
| + PRIMARY KEY (`id`), | |
| + KEY `startTime` (`startTime`,`endTime`), | |
| + FULLTEXT KEY `overlayText` (`overlayText`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `failedlogins` | |
| + | |
| +CREATE TABLE `failedlogins` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `added` int(11) NOT NULL, | |
| + `banned` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `attempts` int(10) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `files` | |
| + | |
| +CREATE TABLE `files` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `torrent` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + `size` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `torrent` (`torrent`), | |
| + FULLTEXT KEY `filename` (`filename`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `forum_config` | |
| + | |
| +CREATE TABLE `forum_config` ( | |
| + `id` smallint(1) NOT NULL DEFAULT '1', | |
| + `delete_for_real` smallint(6) NOT NULL DEFAULT '0', | |
| + `min_delete_view_class` smallint(2) unsigned NOT NULL DEFAULT '7', | |
| + `readpost_expiry` smallint(3) NOT NULL DEFAULT '14', | |
| + `min_upload_class` smallint(2) unsigned NOT NULL DEFAULT '2', | |
| + `accepted_file_extension` varchar(80) NOT NULL, | |
| + `accepted_file_types` varchar(280) NOT NULL, | |
| + `max_file_size` int(10) unsigned NOT NULL DEFAULT '2097152', | |
| + `upload_folder` varchar(80) NOT NULL DEFAULT 'uploads/', | |
| + PRIMARY KEY (`readpost_expiry`), | |
| + KEY `delete_for_real` (`delete_for_real`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `forum_poll` | |
| + | |
| +CREATE TABLE `forum_poll` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `question` varchar(280) NOT NULL, | |
| + `poll_answers` text, | |
| + `number_of_options` smallint(2) unsigned NOT NULL DEFAULT '0', | |
| + `poll_starts` int(11) NOT NULL DEFAULT '0', | |
| + `poll_ends` int(11) NOT NULL DEFAULT '0', | |
| + `change_vote` enum('yes','no') NOT NULL DEFAULT 'no', | |
| + `multi_options` smallint(2) unsigned NOT NULL DEFAULT '1', | |
| + `poll_closed` enum('yes','no') DEFAULT 'no', | |
| + PRIMARY KEY (`id`), | |
| + KEY `user_id` (`user_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `forum_poll_votes` | |
| + | |
| +CREATE TABLE `forum_poll_votes` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `poll_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `option` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + `ip` varchar(15) NOT NULL DEFAULT '', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `poll_id` (`poll_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `forums` | |
| + | |
| +CREATE TABLE `forums` ( | |
| + `sort` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `name` varchar(60) NOT NULL DEFAULT '', | |
| + `description` varchar(200) DEFAULT NULL, | |
| + `min_class_read` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + `min_class_write` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + `post_count` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `topic_count` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `min_class_create` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + `parent_forum` tinyint(4) NOT NULL DEFAULT '0', | |
| + `forum_id` tinyint(4) DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `freeleech` | |
| + | |
| +CREATE TABLE `freeleech` ( | |
| + `id` int(5) NOT NULL AUTO_INCREMENT, | |
| + `name` varchar(50) NOT NULL DEFAULT '', | |
| + `var` int(10) NOT NULL DEFAULT '0', | |
| + `description` text NOT NULL, | |
| + `type` varchar(10) NOT NULL DEFAULT 'contribute', | |
| + `amount` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `type` (`type`) | |
| +) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `freeslots` | |
| + | |
| +CREATE TABLE `freeslots` ( | |
| + `torrentid` int(10) unsigned NOT NULL, | |
| + `userid` int(10) unsigned NOT NULL, | |
| + `doubleup` enum('yes','no') NOT NULL DEFAULT 'no', | |
| + `free` enum('yes','no') NOT NULL DEFAULT 'no', | |
| + `addedup` int(11) NOT NULL DEFAULT '0', | |
| + `addedfree` int(11) NOT NULL DEFAULT '0', | |
| + KEY `userid` (`userid`) | |
| +) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `friends` | |
| + | |
| +CREATE TABLE `friends` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `friendid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `confirmed` enum('yes','no') COLLATE utf8_bin NOT NULL DEFAULT 'no', | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `userfriend` (`userid`,`friendid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; | |
| + | |
| +## Table structure for table `funds` | |
| + | |
| +CREATE TABLE `funds` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `cash` decimal(8,2) NOT NULL DEFAULT '0.00', | |
| + `user` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL, | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `happyhour` | |
| + | |
| +CREATE TABLE `happyhour` ( | |
| + `id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) NOT NULL DEFAULT '0', | |
| + `torrentid` int(10) NOT NULL DEFAULT '0', | |
| + `multiplier` float NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `userid` (`userid`,`torrentid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `happylog` | |
| + | |
| +CREATE TABLE `happylog` ( | |
| + `id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) NOT NULL DEFAULT '0', | |
| + `torrentid` int(10) NOT NULL DEFAULT '0', | |
| + `multi` float NOT NULL DEFAULT '0', | |
| + `date` int(10) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `userid` (`userid`,`torrentid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `infolog` | |
| + | |
| +CREATE TABLE `infolog` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `added` int(11) DEFAULT '0', | |
| + `txt` text CHARACTER SET utf8, | |
| + PRIMARY KEY (`id`), | |
| + KEY `added` (`added`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `invite_codes` | |
| + | |
| +CREATE TABLE `invite_codes` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `sender` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `receiver` varchar(32) NOT NULL DEFAULT '0', | |
| + `code` varchar(32) NOT NULL DEFAULT '', | |
| + `invite_added` int(10) NOT NULL, | |
| + `status` enum('Pending','Confirmed') NOT NULL DEFAULT 'Pending', | |
| + PRIMARY KEY (`id`), | |
| + KEY `sender` (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `ips` | |
| + | |
| +CREATE TABLE `ips` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `ip` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + `userid` int(10) DEFAULT NULL, | |
| + `type` enum('login','announce','browse') NOT NULL, | |
| + `seedbox` tinyint(1) NOT NULL DEFAULT '0', | |
| + `lastbrowse` int(11) NOT NULL DEFAULT '0', | |
| + `lastlogin` int(11) NOT NULL DEFAULT '0', | |
| + `lastannounce` int(11) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `userid` (`userid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `lottery_config` | |
| + | |
| +CREATE TABLE `lottery_config` ( | |
| + `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', | |
| + `value` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', | |
| + UNIQUE KEY `name` (`name`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `messages` | |
| + | |
| +CREATE TABLE `messages` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `sender` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `receiver` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL, | |
| + `subject` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No Subject', | |
| + `msg` text COLLATE utf8_unicode_ci, | |
| + `unread` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `poster` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `location` smallint(6) NOT NULL DEFAULT '1', | |
| + `saved` enum('no','yes') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `urgent` enum('no','yes') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `draft` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + PRIMARY KEY (`id`), | |
| + KEY `receiver` (`receiver`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `moods` | |
| + | |
| +CREATE TABLE `moods` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `name` varchar(40) NOT NULL DEFAULT '', | |
| + `image` varchar(40) NOT NULL DEFAULT '', | |
| + `bonus` int(3) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=86 DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `news` | |
| + | |
| +CREATE TABLE `news` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(11) NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + `body` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| + `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| + `sticky` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'no', | |
| + PRIMARY KEY (`id`), | |
| + | |
| + KEY `added` (`added`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `notconnectablepmlog` | |
| + | |
| +CREATE TABLE `notconnectablepmlog` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `user` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `date` int(11) DEFAULT NULL, | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `now_viewing` | |
| + | |
| +CREATE TABLE `now_viewing` ( | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `forum_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `topic_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`user_id`), | |
| + KEY `forum_id` (`forum_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `offer_votes` | |
| + | |
| +CREATE TABLE `offer_votes` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `offer_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `vote` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + PRIMARY KEY (`id`), | |
| + KEY `user_offer` (`offer_id`,`user_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `offers` | |
| + | |
| +CREATE TABLE `offers` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `offer_name` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + `image` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + `description` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `category` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + `offered_by_user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `filled_torrent_id` int(10) NOT NULL DEFAULT '0', | |
| + `vote_yes_count` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `vote_no_count` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `comments` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `link` varchar(240) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + `status` enum('approved','pending','denied') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending', | |
| + PRIMARY KEY (`id`), | |
| + KEY `id_added` (`id`,`added`), | |
| + KEY `offered_by_name` (`offer_name`,`offered_by_user_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `over_forums` | |
| + | |
| +CREATE TABLE `over_forums` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `name` varchar(60) NOT NULL DEFAULT '', | |
| + `description` varchar(200) DEFAULT NULL, | |
| + `min_class_view` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + `sort` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `paypal_config` | |
| + | |
| +CREATE TABLE `paypal_config` ( | |
| + `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', | |
| + `value` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', | |
| + UNIQUE KEY `name` (`name`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `peers` | |
| + | |
| +CREATE TABLE `peers` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `torrent` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `passkey` varchar(32) COLLATE utf8_unicode_ci NOT NULL, | |
| + `peer_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL, | |
| + `compact` varchar(6) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| + `ip` varchar(64) COLLATE utf8_unicode_ci NOT NULL, | |
| + `port` smallint(5) unsigned NOT NULL DEFAULT '0', | |
| + `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `to_go` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `seeder` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `started` int(11) NOT NULL, | |
| + `last_action` int(11) NOT NULL, | |
| + `prev_action` int(11) NOT NULL, | |
| + `connectable` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `userid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `agent` varchar(60) COLLATE utf8_unicode_ci NOT NULL, | |
| + `finishedat` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `downloadoffset` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `uploadoffset` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `corrupt` int(10) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`), | |
| + KEY `torrent` (`torrent`), | |
| + KEY `torrent_seeder` (`torrent`,`seeder`), | |
| + KEY `last_action` (`last_action`), | |
| + KEY `connectable` (`connectable`), | |
| + KEY `userid` (`userid`), | |
| + KEY `passkey` (`passkey`), | |
| + KEY `torrent_connect` (`torrent`,`connectable`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `pmboxes` | |
| + | |
| +CREATE TABLE `pmboxes` ( | |
| + `id` int(11) NOT NULL AUTO_INCREMENT, | |
| + `userid` int(11) NOT NULL, | |
| + `boxnumber` tinyint(4) NOT NULL DEFAULT '2', | |
| + `name` varchar(15) COLLATE utf8_unicode_ci NOT NULL, | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `poll_voters` | |
| + | |
| +CREATE TABLE `poll_voters` ( | |
| + `vid` int(10) NOT NULL AUTO_INCREMENT, | |
| + `ip_address` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `vote_date` int(10) NOT NULL DEFAULT '0', | |
| + `poll_id` int(10) NOT NULL DEFAULT '0', | |
| + `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + PRIMARY KEY (`vid`), | |
| + KEY `poll_id` (`poll_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `polls` | |
| + | |
| +CREATE TABLE `polls` ( | |
| + `pid` mediumint(8) NOT NULL AUTO_INCREMENT, | |
| + `start_date` int(10) DEFAULT NULL, | |
| + `choices` mediumtext, | |
| + `starter_id` mediumint(8) NOT NULL DEFAULT '0', | |
| + `starter_name` varchar(30) NOT NULL DEFAULT '', | |
| + `votes` smallint(5) NOT NULL DEFAULT '0', | |
| + `poll_question` varchar(255) DEFAULT NULL, | |
| + PRIMARY KEY (`pid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `posts` | |
| + | |
| +CREATE TABLE `posts` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `topic_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + `body` text, | |
| + `edited_by` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `edit_date` int(11) NOT NULL DEFAULT '0', | |
| + `icon` varchar(80) DEFAULT '', | |
| + `post_title` varchar(120) DEFAULT NULL, | |
| + `bbcode` enum('yes','no') NOT NULL DEFAULT 'yes', | |
| + `post_history` text NOT NULL, | |
| + `edit_reason` varchar(60) DEFAULT NULL, | |
| + `ip` varchar(15) NOT NULL DEFAULT '', | |
| + `status` enum('deleted','recycled','postlocked','ok') NOT NULL DEFAULT 'ok', | |
| + `staff_lock` tinyint(1) unsigned NOT NULL DEFAULT '0', | |
| + `anonymous` enum('yes','no') NOT NULL DEFAULT 'no', | |
| + PRIMARY KEY (`id`), | |
| + KEY `topicid` (`topic_id`), | |
| + KEY `userid` (`user_id`), | |
| + FULLTEXT KEY `body` (`post_title`,`body`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `promo` | |
| + | |
| +CREATE TABLE `promo` ( | |
| + `id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `name` varchar(120) CHARACTER SET utf8 NOT NULL, | |
| + `added` int(10) NOT NULL DEFAULT '0', | |
| + `days_valid` int(2) NOT NULL DEFAULT '0', | |
| + `accounts_made` int(3) NOT NULL DEFAULT '0', | |
| + `max_users` int(3) NOT NULL DEFAULT '0', | |
| + `link` varchar(32) CHARACTER SET utf8 NOT NULL, | |
| + `creator` int(10) NOT NULL DEFAULT '0', | |
| + `users` text CHARACTER SET utf8 NOT NULL, | |
| + `bonus_upload` bigint(10) NOT NULL DEFAULT '0', | |
| + `bonus_invites` int(2) NOT NULL DEFAULT '0', | |
| + `bonus_karma` int(3) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `rating` | |
| + | |
| +CREATE TABLE `rating` ( | |
| + `id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `topic` int(10) NOT NULL DEFAULT '0', | |
| + `torrent` int(10) NOT NULL DEFAULT '0', | |
| + `rating` int(1) NOT NULL DEFAULT '0', | |
| + `user` int(10) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `read_posts` | |
| + | |
| +CREATE TABLE `read_posts` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `topic_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `last_post_read` int(10) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `topic_id` (`topic_id`), | |
| + KEY `user_id` (`user_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `relations` | |
| + | |
| +CREATE TABLE `relations` ( | |
| + `id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `user` int(10) NOT NULL DEFAULT '0', | |
| + `relation_with` int(10) NOT NULL DEFAULT '0', | |
| + `relation` enum('friends','blocked','neutral') NOT NULL DEFAULT 'neutral', | |
| + PRIMARY KEY (`id`), | |
| + KEY `relation` (`user`,`relation_with`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `reports` | |
| + | |
| +CREATE TABLE `reports` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `reported_by` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `reporting_what` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `reporting_type` enum('User','Comment','Request_Comment','Offer_Comment','Request','Offer','Torrent','Hit_And_Run','Post') CHARACTER SET utf8 NOT NULL DEFAULT 'Torrent', | |
| + `reason` text CHARACTER SET utf8 NOT NULL, | |
| + `who_delt_with_it` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `delt_with` tinyint(1) NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + `how_delt_with` text CHARACTER SET utf8 NOT NULL, | |
| + `2nd_value` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `when_delt_with` int(11) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `delt_with` (`delt_with`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `reputation` | |
| + | |
| +CREATE TABLE `reputation` ( | |
| + `reputationid` int(11) unsigned NOT NULL AUTO_INCREMENT, | |
| + `reputation` int(10) NOT NULL DEFAULT '0', | |
| + `whoadded` int(10) NOT NULL DEFAULT '0', | |
| + `reason` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + `dateadd` int(10) NOT NULL DEFAULT '0', | |
| + `locale` enum('posts','comments','torrents','users') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'posts', | |
| + `postid` int(10) NOT NULL DEFAULT '0', | |
| + `userid` mediumint(8) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`reputationid`), | |
| + KEY `userid` (`userid`), | |
| + KEY `whoadded` (`whoadded`), | |
| + KEY `multi` (`postid`,`userid`), | |
| + KEY `dateadd` (`dateadd`), | |
| + KEY `locale` (`locale`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `reputationlevel` | |
| + | |
| +CREATE TABLE `reputationlevel` ( | |
| + `reputationlevelid` int(11) unsigned NOT NULL AUTO_INCREMENT, | |
| + `minimumreputation` int(10) NOT NULL DEFAULT '0', | |
| + `level` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + PRIMARY KEY (`reputationlevelid`), | |
| + KEY `reputationlevel` (`minimumreputation`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `request_votes` | |
| + | |
| +CREATE TABLE `request_votes` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `request_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `vote` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + PRIMARY KEY (`id`), | |
| + KEY `user_request` (`request_id`,`user_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `requests` | |
| + | |
| +CREATE TABLE `requests` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `request_name` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + `image` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + `description` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `category` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + `requested_by_user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `filled_by_user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `filled_torrent_id` int(10) NOT NULL DEFAULT '0', | |
| + `vote_yes_count` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `vote_no_count` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `comments` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `link` varchar(240) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + PRIMARY KEY (`id`), | |
| + KEY `id_added` (`id`,`added`), | |
| + KEY `requested_by_name` (`request_name`,`requested_by_user_id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `searchcloud` | |
| + | |
| +CREATE TABLE `searchcloud` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `searchedfor` varchar(50) COLLATE utf8_unicode_ci NOT NULL, | |
| + `howmuch` int(10) NOT NULL, | |
| + `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL, | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `searchedfor` (`searchedfor`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `shit_list` | |
| + | |
| +CREATE TABLE `shit_list` ( | |
| + `userid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `suspect` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `shittyness` int(2) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + `text` text COLLATE utf8_unicode_ci, | |
| + KEY `userid` (`userid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `shoutbox` | |
| + | |
| +CREATE TABLE `shoutbox` ( | |
| + `id` bigint(40) NOT NULL AUTO_INCREMENT, | |
| + `userid` bigint(6) NOT NULL DEFAULT '0', | |
| + `to_user` int(10) NOT NULL DEFAULT '0', | |
| + `username` varchar(25) NOT NULL DEFAULT '', | |
| + `date` int(11) NOT NULL DEFAULT '0', | |
| + `text` text NOT NULL, | |
| + `text_parsed` text NOT NULL, | |
| + `staff_shout` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + PRIMARY KEY (`id`), | |
| + KEY `for` (`to_user`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `site_config` | |
| + | |
| +CREATE TABLE `site_config` ( | |
| + `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', | |
| + `value` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', | |
| + UNIQUE KEY `name` (`name`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `sitelog` | |
| + | |
| +CREATE TABLE `sitelog` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `added` int(11) NOT NULL, | |
| + `txt` text COLLATE utf8_unicode_ci, | |
| + PRIMARY KEY (`id`), | |
| + KEY `added` (`added`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `snatched` | |
| + | |
| +CREATE TABLE `snatched` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `torrentid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `port` smallint(5) unsigned NOT NULL DEFAULT '0', | |
| + `connectable` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `agent` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `peer_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `upspeed` bigint(20) NOT NULL DEFAULT '0', | |
| + `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `downspeed` bigint(20) NOT NULL DEFAULT '0', | |
| + `to_go` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `seeder` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `seedtime` int(11) unsigned NOT NULL DEFAULT '0', | |
| + `leechtime` int(11) unsigned NOT NULL DEFAULT '0', | |
| + `start_date` int(11) NOT NULL, | |
| + `last_action` int(11) NOT NULL, | |
| + `complete_date` int(11) NOT NULL, | |
| + `timesann` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `hit_and_run` int(11) NOT NULL, | |
| + `mark_of_cain` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `finished` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + PRIMARY KEY (`id`), | |
| + KEY `tr_usr` (`torrentid`,`userid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `staffmessages` | |
| + | |
| +CREATE TABLE `staffmessages` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `sender` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) DEFAULT '0', | |
| + `msg` text COLLATE utf8_unicode_ci, | |
| + `subject` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `answeredby` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `answered` int(1) NOT NULL DEFAULT '0', | |
| + `answer` text COLLATE utf8_unicode_ci, | |
| + PRIMARY KEY (`id`), | |
| + KEY `answeredby` (`answeredby`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `staffpanel` | |
| + | |
| +CREATE TABLE `staffpanel` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `page_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL, | |
| + `file_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL, | |
| + `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `av_class` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + `added_by` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(10) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `file_name` (`file_name`), | |
| + KEY `av_class` (`av_class`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `stats` | |
| + | |
| +CREATE TABLE `stats` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `regusers` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `unconusers` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `torrents` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `seeders` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `leechers` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `torrentstoday` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `donors` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `unconnectables` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `forumtopics` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `forumposts` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `numactive` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `torrentsmonth` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `gender_na` int(10) unsigned NOT NULL DEFAULT '1', | |
| + `gender_male` int(10) unsigned NOT NULL DEFAULT '1', | |
| + `gender_female` int(10) unsigned NOT NULL DEFAULT '1', | |
| + `powerusers` int(10) unsigned NOT NULL DEFAULT '1', | |
| + `disabled` int(10) unsigned NOT NULL DEFAULT '1', | |
| + `uploaders` int(10) unsigned NOT NULL DEFAULT '1', | |
| + `moderators` int(10) unsigned NOT NULL DEFAULT '1', | |
| + `administrators` int(10) unsigned NOT NULL DEFAULT '1', | |
| + `sysops` int(10) unsigned NOT NULL DEFAULT '1', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `stylesheets` | |
| + | |
| +CREATE TABLE `stylesheets` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `uri` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `subscriptions` | |
| + | |
| +CREATE TABLE `subscriptions` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `topic_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `subtitles` | |
| + | |
| +CREATE TABLE `subtitles` ( | |
| + `id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL, | |
| + `filename` varchar(36) COLLATE utf8_unicode_ci NOT NULL, | |
| + `imdb` varchar(50) COLLATE utf8_unicode_ci NOT NULL, | |
| + `lang` varchar(3) COLLATE utf8_unicode_ci NOT NULL, | |
| + `comment` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `fps` varchar(6) COLLATE utf8_unicode_ci NOT NULL, | |
| + `poster` varchar(120) COLLATE utf8_unicode_ci NOT NULL, | |
| + `cds` int(3) NOT NULL DEFAULT '0', | |
| + `hits` int(10) NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + `owner` int(10) NOT NULL DEFAULT '0', | |
| + KEY `id` (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `thanks` | |
| + | |
| +CREATE TABLE `thanks` ( | |
| + `id` int(11) NOT NULL AUTO_INCREMENT, | |
| + `torrentid` int(11) NOT NULL DEFAULT '0', | |
| + `userid` int(11) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `thankyou` | |
| + | |
| +CREATE TABLE `thankyou` ( | |
| + `tid` bigint(10) NOT NULL AUTO_INCREMENT, | |
| + `uid` bigint(10) NOT NULL DEFAULT '0', | |
| + `torid` bigint(10) NOT NULL DEFAULT '0', | |
| + `thank_date` int(10) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`tid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `thumbsup` | |
| + | |
| +CREATE TABLE `thumbsup` ( | |
| + `id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `type` enum('torrents','posts') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'torrents', | |
| + `torrentid` int(10) NOT NULL DEFAULT '0', | |
| + `userid` int(11) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `tickets` | |
| + | |
| +CREATE TABLE `tickets` ( | |
| + `id` int(4) NOT NULL AUTO_INCREMENT, | |
| + `user` int(11) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `user` (`user`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `topics` | |
| + | |
| +CREATE TABLE `topics` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `user_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `topic_name` varchar(120) DEFAULT NULL, | |
| + `locked` enum('yes','no') NOT NULL DEFAULT 'no', | |
| + `forum_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `last_post` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `sticky` enum('yes','no') NOT NULL DEFAULT 'no', | |
| + `views` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `poll_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `num_ratings` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `rating_sum` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `topic_desc` varchar(120) NOT NULL DEFAULT '', | |
| + `post_count` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `first_post` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `status` enum('deleted','recycled','ok') NOT NULL DEFAULT 'ok', | |
| + `main_forum_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `anonymous` enum('yes','no') NOT NULL DEFAULT 'no', | |
| + PRIMARY KEY (`id`), | |
| + KEY `userid` (`user_id`), | |
| + KEY `subject` (`topic_name`), | |
| + KEY `lastpost` (`last_post`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8; | |
| + | |
| +## Table structure for table `torrents` | |
| + | |
| +CREATE TABLE `torrents` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `info_hash` varchar(40) COLLATE utf8_unicode_ci NOT NULL, | |
| + `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + `save_as` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + `search_text` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `descr` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `ori_descr` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `category` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `size` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL, | |
| + `type` enum('single','multi') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'single', | |
| + `numfiles` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `comments` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `views` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `hits` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `times_completed` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `leechers` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `seeders` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `last_action` int(11) NOT NULL, | |
| + `visible` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `banned` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `owner` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `num_ratings` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `rating_sum` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `nfo` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `client_created_by` char(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unknown', | |
| + `free` int(11) unsigned NOT NULL DEFAULT '0', | |
| + `sticky` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `anonymous` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `url` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| + `checked_by` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `points` int(10) NOT NULL DEFAULT '0', | |
| + `allow_comments` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `poster` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'pic/noposter.png', | |
| + `nuked` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `nukereason` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `last_reseed` int(11) NOT NULL DEFAULT '0', | |
| + `release_group` enum('scene','p2p','none') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none', | |
| + `subs` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `vip` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', | |
| + `newgenre` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `pretime` int(11) NOT NULL DEFAULT '0', | |
| + `bump` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `request` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `offer` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `username` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `thanks` int(10) NOT NULL DEFAULT '0', | |
| + `description` varchar(120) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `youtube` varchar(42) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `tags` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `silver` int(11) unsigned NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `info_hash` (`info_hash`), | |
| + KEY `owner` (`owner`), | |
| + KEY `visible` (`visible`), | |
| + KEY `category_visible` (`category`,`visible`), | |
| + FULLTEXT KEY `ft_search` (`search_text`), | |
| + FULLTEXT KEY `newgenre` (`newgenre`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `uploadapp` | |
| + | |
| +CREATE TABLE `uploadapp` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) NOT NULL DEFAULT '0', | |
| + `applied` int(11) NOT NULL DEFAULT '0', | |
| + `speed` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `offer` longtext COLLATE utf8_unicode_ci NOT NULL, | |
| + `reason` longtext COLLATE utf8_unicode_ci NOT NULL, | |
| + `sites` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `sitenames` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `scene` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `creating` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `seeding` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `connectable` enum('yes','no','pending') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending', | |
| + `status` enum('accepted','rejected','pending') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending', | |
| + `moderator` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `comment` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `users` (`userid`), | |
| + KEY `status` (`status`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `user_blocks` | |
| + | |
| +CREATE TABLE `user_blocks` ( | |
| + `userid` int(10) unsigned NOT NULL, | |
| + `index_page` int(10) unsigned NOT NULL DEFAULT '585727', | |
| + `global_stdhead` int(10) unsigned NOT NULL DEFAULT '511', | |
| + `userdetails_page` bigint(20) unsigned NOT NULL DEFAULT '268439084', | |
| + UNIQUE KEY `userid` (`userid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `user_config` | |
| + | |
| +CREATE TABLE `user_config` ( | |
| + `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', | |
| + `value` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', | |
| + UNIQUE KEY `name` (`name`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `usercomments` | |
| + | |
| +CREATE TABLE `usercomments` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `user` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `userid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + `text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| + `ori_text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| + `editedby` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `editedat` int(11) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `user` (`user`), | |
| + KEY `userid` (`userid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `userhits` | |
| + | |
| +CREATE TABLE `userhits` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `hitid` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `number` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `added` int(11) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + KEY `userid` (`userid`), | |
| + KEY `added` (`added`), | |
| + KEY `hitid` (`hitid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `users` | |
| + | |
| +CREATE TABLE `users` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `username` varchar(40) COLLATE utf8_unicode_ci NOT NULL, | |
| + `passhash` varchar(32) COLLATE utf8_unicode_ci NOT NULL, | |
| + `secret` varchar(20) COLLATE utf8_unicode_ci NOT NULL, | |
| + `passkey` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `email` varchar(80) COLLATE utf8_unicode_ci NOT NULL, | |
| + `status` enum('pending','confirmed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending', | |
| + `added` int(11) NOT NULL, | |
| + `last_login` int(11) NOT NULL, | |
| + `last_access` int(11) NOT NULL, | |
| + `curr_ann_last_check` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `curr_ann_id` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `editsecret` varchar(32) COLLATE utf8_unicode_ci NOT NULL, | |
| + `privacy` enum('strong','normal','low') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'normal', | |
| + `stylesheet` int(10) DEFAULT '1', | |
| + `info` text COLLATE utf8_unicode_ci, | |
| + `acceptpms` enum('yes','friends','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL, | |
| + `class` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + `override_class` tinyint(3) unsigned NOT NULL DEFAULT '255', | |
| + `language` tinyint(3) unsigned NOT NULL DEFAULT '1', | |
| + `avatar` varchar(100) COLLATE utf8_unicode_ci NOT NULL, | |
| + `av_w` smallint(3) unsigned NOT NULL DEFAULT '0', | |
| + `av_h` smallint(3) unsigned NOT NULL DEFAULT '0', | |
| + `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `title` varchar(30) COLLATE utf8_unicode_ci NOT NULL, | |
| + `country` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `notifs` varchar(300) COLLATE utf8_unicode_ci NOT NULL, | |
| + `modcomment` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `enabled` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `donor` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `warned` int(11) NOT NULL DEFAULT '0', | |
| + `torrentsperpage` int(3) unsigned NOT NULL DEFAULT '0', | |
| + `topicsperpage` int(3) unsigned NOT NULL DEFAULT '0', | |
| + `postsperpage` int(3) unsigned NOT NULL DEFAULT '0', | |
| + `deletepms` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `savepms` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `reputation` int(10) NOT NULL DEFAULT '10', | |
| + `time_offset` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', | |
| + `dst_in_use` tinyint(1) NOT NULL DEFAULT '0', | |
| + `auto_correct_dst` tinyint(1) NOT NULL DEFAULT '1', | |
| + `show_shout` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'yes', | |
| + `shoutboxbg` enum('1','2','3') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '1', | |
| + `chatpost` int(11) NOT NULL DEFAULT '1', | |
| + `smile_until` int(10) NOT NULL DEFAULT '0', | |
| + `seedbonus` decimal(10,1) NOT NULL DEFAULT '200.0', | |
| + `bonuscomment` text COLLATE utf8_unicode_ci, | |
| + `vip_added` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `vip_until` int(10) NOT NULL DEFAULT '0', | |
| + `freeslots` int(11) unsigned NOT NULL DEFAULT '5', | |
| + `free_switch` int(11) unsigned NOT NULL DEFAULT '0', | |
| + `invites` int(10) unsigned NOT NULL DEFAULT '1', | |
| + `invitedby` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `invite_rights` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `anonymous` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `uploadpos` int(11) NOT NULL DEFAULT '1', | |
| + `forumpost` int(11) NOT NULL DEFAULT '1', | |
| + `downloadpos` int(11) NOT NULL DEFAULT '1', | |
| + `immunity` int(11) NOT NULL DEFAULT '0', | |
| + `leechwarn` int(11) NOT NULL DEFAULT '0', | |
| + `disable_reason` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| + `clear_new_tag_manually` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `last_browse` int(11) NOT NULL DEFAULT '0', | |
| + `sig_w` smallint(3) unsigned NOT NULL DEFAULT '0', | |
| + `sig_h` smallint(3) unsigned NOT NULL DEFAULT '0', | |
| + `signatures` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `signature` varchar(225) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `forum_access` int(11) NOT NULL DEFAULT '0', | |
| + `highspeed` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `hnrwarn` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `hit_and_run_total` int(9) DEFAULT '0', | |
| + `donoruntil` int(11) unsigned NOT NULL DEFAULT '0', | |
| + `donated` int(3) NOT NULL DEFAULT '0', | |
| + `total_donated` decimal(8,2) NOT NULL DEFAULT '0.00', | |
| + `vipclass_before` int(10) NOT NULL DEFAULT '0', | |
| + `parked` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `passhint` int(10) unsigned NOT NULL, | |
| + `hintanswer` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `avatarpos` int(11) NOT NULL DEFAULT '1', | |
| + `support` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `supportfor` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `support_lang` varchar(320) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en', | |
| + `sendpmpos` int(11) NOT NULL DEFAULT '1', | |
| + `invitedate` int(11) NOT NULL DEFAULT '0', | |
| + `invitees` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', | |
| + `invite_on` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'yes', | |
| + `subscription_pm` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'no', | |
| + `gender` enum('Male','Female','NA') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NA', | |
| + `anonymous_until` int(10) NOT NULL DEFAULT '0', | |
| + `viewscloud` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'yes', | |
| + `tenpercent` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `avatars` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `offavatar` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `pirate` int(11) unsigned NOT NULL DEFAULT '0', | |
| + `king` int(11) unsigned NOT NULL DEFAULT '0', | |
| + `hidecur` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `ssluse` int(1) NOT NULL DEFAULT '1', | |
| + `signature_post` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `forum_post` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `avatar_rights` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `offensive_avatar` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `view_offensive_avatar` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes', | |
| + `paranoia` tinyint(3) unsigned NOT NULL DEFAULT '0', | |
| + `google_talk` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + `msn` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `aim` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `yahoo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `website` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `icq` varchar(255) COLLATE utf8_unicode_ci NOT NULL, | |
| + `show_email` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `parked_until` int(10) NOT NULL DEFAULT '0', | |
| + `gotgift` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `hash1` varchar(96) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `suspended` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `bjwins` int(10) NOT NULL DEFAULT '0', | |
| + `bjlosses` int(10) NOT NULL DEFAULT '0', | |
| + `warn_reason` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, | |
| + `onirc` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `irctotal` bigint(20) unsigned NOT NULL DEFAULT '0', | |
| + `birthday` date DEFAULT '0000-00-00', | |
| + `got_blocks` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `last_access_numb` bigint(30) NOT NULL DEFAULT '0', | |
| + `onlinetime` bigint(30) NOT NULL DEFAULT '0', | |
| + `pm_on_delete` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'no', | |
| + `commentpm` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'no', | |
| + `split` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `browser` text COLLATE utf8_unicode_ci, | |
| + `hits` int(10) NOT NULL DEFAULT '0', | |
| + `comments` int(10) unsigned NOT NULL DEFAULT '0', | |
| + `categorie_icon` int(10) DEFAULT '1', | |
| + `perms` int(11) NOT NULL DEFAULT '0', | |
| + `mood` int(10) NOT NULL DEFAULT '1', | |
| + `got_moods` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `pms_per_page` tinyint(3) unsigned DEFAULT '20', | |
| + `show_pm_avatar` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `watched_user` int(11) NOT NULL DEFAULT '0', | |
| + `watched_user_reason` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `staff_notes` text COLLATE utf8_unicode_ci NOT NULL, | |
| + `game_access` int(11) NOT NULL DEFAULT '1', | |
| + `show_staffshout` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'yes', | |
| + `browse_icons` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no', | |
| + `numuploads` int(10) NOT NULL DEFAULT '0', | |
| + `corrupt` int(10) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `username` (`username`), | |
| + KEY `ip` (`ip`), | |
| + KEY `uploaded` (`uploaded`), | |
| + KEY `downloaded` (`downloaded`), | |
| + KEY `country` (`country`), | |
| + KEY `last_access` (`last_access`), | |
| + KEY `enabled` (`enabled`), | |
| + KEY `warned` (`warned`), | |
| + KEY `pkey` (`passkey`), | |
| + KEY `free_switch` (`free_switch`), | |
| + KEY `iphistory` (`ip`,`id`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `usersachiev` | |
| + | |
| +CREATE TABLE `usersachiev` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `totalshoutlvl` tinyint(2) NOT NULL DEFAULT '0', | |
| + `username` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', | |
| + `snatchmaster` tinyint(1) NOT NULL DEFAULT '0', | |
| + `invited` int(3) NOT NULL DEFAULT '0', | |
| + `bday` tinyint(1) NOT NULL DEFAULT '0', | |
| + `ul` tinyint(1) NOT NULL DEFAULT '0', | |
| + `inviterach` tinyint(1) NOT NULL DEFAULT '0', | |
| + `forumposts` int(10) NOT NULL DEFAULT '0', | |
| + `postachiev` tinyint(2) NOT NULL DEFAULT '0', | |
| + `avatarset` tinyint(1) NOT NULL DEFAULT '0', | |
| + `avatarach` tinyint(1) NOT NULL DEFAULT '0', | |
| + `stickyup` int(5) NOT NULL DEFAULT '0', | |
| + `stickyachiev` tinyint(1) NOT NULL DEFAULT '0', | |
| + `sigset` tinyint(1) NOT NULL DEFAULT '0', | |
| + `sigach` tinyint(1) NOT NULL DEFAULT '0', | |
| + `corrupt` tinyint(1) NOT NULL DEFAULT '0', | |
| + `dayseed` tinyint(3) NOT NULL DEFAULT '0', | |
| + `sheepyset` tinyint(1) NOT NULL DEFAULT '0', | |
| + `sheepyach` tinyint(1) NOT NULL DEFAULT '0', | |
| + `spentpoints` int(3) NOT NULL DEFAULT '0', | |
| + `achpoints` int(3) NOT NULL DEFAULT '1', | |
| + `forumtopics` int(10) NOT NULL DEFAULT '0', | |
| + `topicachiev` tinyint(2) NOT NULL DEFAULT '0', | |
| + `bonus` tinyint(2) NOT NULL DEFAULT '0', | |
| + `bonusspent` decimal(10,2) NOT NULL DEFAULT '0.00', | |
| + `christmas` tinyint(1) NOT NULL DEFAULT '0', | |
| + `xmasdays` int(2) NOT NULL DEFAULT '0', | |
| + `reqfilled` int(5) NOT NULL DEFAULT '0', | |
| + `reqlvl` tinyint(2) NOT NULL DEFAULT '0', | |
| + `dailyshouts` int(5) NOT NULL DEFAULT '0', | |
| + `dailyshoutlvl` tinyint(2) NOT NULL DEFAULT '0', | |
| + `weeklyshouts` int(5) NOT NULL DEFAULT '0', | |
| + `weeklyshoutlvl` tinyint(2) NOT NULL DEFAULT '0', | |
| + `monthlyshouts` int(5) NOT NULL DEFAULT '0', | |
| + `monthlyshoutlvl` tinyint(2) NOT NULL DEFAULT '0', | |
| + `totalshouts` int(10) NOT NULL DEFAULT '0', | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `username` (`username`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `ustatus` | |
| + | |
| +CREATE TABLE `ustatus` ( | |
| + `id` int(10) NOT NULL AUTO_INCREMENT, | |
| + `userid` int(10) NOT NULL DEFAULT '0', | |
| + `last_status` varchar(140) COLLATE utf8_unicode_ci NOT NULL, | |
| + `last_update` int(11) NOT NULL DEFAULT '0', | |
| + `archive` text COLLATE utf8_unicode_ci NOT NULL, | |
| + PRIMARY KEY (`id`), | |
| + UNIQUE KEY `userid` (`userid`) | |
| +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| + | |
| +## Table structure for table `wiki` | |
| + | |
| +CREATE TABLE `wiki` ( | |
| + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, | |
| + `name` varchar(100) CHARACTER SET utf8 NOT NULL, | |
| + `body` longtext CHARACTER SET utf8, | |
| + `userid` int(10) unsigned DEFAULT '0', | |
| + `time` int(11) NOT NULL, | |
| + `lastedit` int(10) unsigned DEFAULT NULL, | |
| + `lastedituser` int(10) unsigned DEFAULT NULL, | |
| + PRIMARY KEY (`id`) | |
| +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| diff --git a/install/functions/database.php b/install/functions/database.php | |
| index 187a5a8..0b57e7a 100644 | |
| --- a/install/functions/database.php | |
| +++ b/install/functions/database.php | |
| @@ -1,33 +1,138 @@ | |
| <?php | |
| + | |
| +function take_out_remarks($sql) | |
| +{ | |
| + $lines = explode("\n", $sql); | |
| + $sql = ""; | |
| + $linecount = count($lines); | |
| + $catch = ""; | |
| + for ($i = 0; $i < $linecount; $i++) | |
| + { | |
| + if (($i != ($linecount - 1)) || (strlen($lines[$i]) > 0)) | |
| + { | |
| + if ((!empty($lines[$i])) && (trim($lines[$i][0] != "#"))) | |
| + { | |
| + $catch .= $lines[$i] . "\n"; | |
| + } else { | |
| + $catch .= "\n"; | |
| + } | |
| + $lines[$i] = ""; | |
| + } | |
| + } | |
| + return $catch; | |
| +} | |
| + | |
| +//== Ported from phpbb, all acknowledgments. | |
| +function split_sql_file($sql, $delimiter) | |
| +{ | |
| + $tokens = explode($delimiter, $sql); | |
| + $sql = ""; | |
| + $output = array(); | |
| + $matches = array(); | |
| + $token_count = count($tokens); | |
| + for ($i = 0; $i < $token_count; $i++) | |
| + { | |
| + if (($i != ($token_count - 1)) || (strlen($tokens[$i] > 0))) | |
| + { | |
| + $total_quotes = preg_match_all("/'/", $tokens[$i], $matches); | |
| + $escaped_quotes = preg_match_all("/(?<!\\\\)(\\\\\\\\)*\\\\'/", $tokens[$i], $matches); | |
| + $unescaped_quotes = $total_quotes - $escaped_quotes; | |
| + if (($unescaped_quotes % 2) == 0) | |
| + { | |
| + $output[] = $tokens[$i]; | |
| + $tokens[$i] = ""; | |
| + } else { | |
| + $temp = $tokens[$i] . $delimiter; | |
| + $tokens[$i] = ""; | |
| + $complete_stmt = false; | |
| + for ($j = $i + 1; (!$complete_stmt && ($j < $token_count)); $j++) | |
| + { | |
| + $total_quotes = preg_match_all("/'/", $tokens[$j], $matches); | |
| + $escaped_quotes = preg_match_all("/(?<!\\\\)(\\\\\\\\)*\\\\'/", $tokens[$j], $matches); | |
| + $unescaped_quotes = $total_quotes - $escaped_quotes; | |
| + if (($unescaped_quotes % 2) == 1) | |
| + { | |
| + $output[] = $temp . $tokens[$j]; | |
| + $tokens[$j] = ""; | |
| + $temp = ""; | |
| + $complete_stmt = true; | |
| + $i = $j; | |
| + } else { | |
| + $temp .= $tokens[$j] . $delimiter; | |
| + $tokens[$j] = ""; | |
| + } | |
| + } | |
| + } | |
| + } | |
| + } | |
| + return $output; | |
| +} | |
| + | |
| function db_test() | |
| { | |
| global $root, $INSTALLER09; | |
| - $out = '<fieldset><legend>Database</legend>'; | |
| + $out = '<fieldset><legend>'.____('Database').'</legend>'; | |
| require_once ($root.'include/config.php'); | |
| - if (@mysql_connect($INSTALLER09['mysql_host'], $INSTALLER09['mysql_user'], $INSTALLER09['mysql_pass'], $INSTALLER09['mysql_db'])) { | |
| - $out.= '<div class="readable">Connection to database was made</div>'; | |
| - if (mysql_select_db($INSTALLER09['mysql_db'])) { | |
| - $out.= '<div class="readable">Data base exists, data can be imported</div>'; | |
| - $out.= '<form action="index.php" method="post"><div class="info" style="text-align:center;"><input type="hidden" name="do" value="db_insert" /><input type="submit" value="Import database" /></div></form>'; | |
| - } else $out.= '<div class="notreadable">There was an error while selecting the database<br/>'.mysql_error().'</div><div class="info" style="text-align:center"><input type="button" value="Reload" onclick="window.location.reload()"/></div>'; | |
| - } else $out.= '<div class="notreadable">There was an error while connection to the database<br/>'.mysql_error().'</div><div class="info" style="text-align:center"><input type="button" value="Reload" onclick="window.location.reload()"/></div>'; | |
| - $out.= '</fieldset>'; | |
| - print ($out); | |
| + if (@mysqli_connect($INSTALLER09['mysql_host'], $INSTALLER09['mysql_user'], $INSTALLER09['mysql_pass'], $INSTALLER09['mysql_db'])) | |
| + { | |
| + $out.= '<div class="readable">'.____('Connection to database no issues reported, data may be imported.').'</div>'; | |
| + $out.= '<form action="index.php" method="post"><div class="info" style="text-align:center;"><input type="hidden" name="do" value="db_insert" /><input type="submit" value='.____('Import database').' /></div></form>'; | |
| + } else $out.= '<div class="notreadable">'.____('The connection to the database reported the next issue: ').'</br>'.mysqli_connect_error().'</div><div class="info" style="text-align:center"><input type="button" value='.____('Reload').' onclick="window.location.reload()"/></div>'; | |
| + $out.= '</fieldset>'; | |
| + print ($out); | |
| } | |
| -//== Win - remember to set your path up correctly in the query- atm its set for appserv c:\AppServ\MySQL\bin\mysql | |
| + | |
| function db_insert() | |
| { | |
| global $root, $INSTALLER09; | |
| - $out = '<fieldset><legend>Database</legend>'; | |
| + $table_structure = 'extra/structure.sql'; | |
| + $table_basicdata = 'extra/basicdata.sql'; | |
| require_once ($root.'include/config.php'); | |
| - $q = sprintf('/usr/bin/mysql -h %s -u %s -p%s %s < %sinstall/extra/install.sql', $INSTALLER09['mysql_host'], $INSTALLER09['mysql_user'], $INSTALLER09['mysql_pass'], $INSTALLER09['mysql_db'], $root); //== Linux | |
| - //$q = sprintf('c:\AppServ\MySQL\bin\mysql -h %s -u %s -p%s %s < %sinstall/extra/install.sql',$INSTALLER09['mysql_host'],$INSTALLER09['mysql_user'],$INSTALLER09['mysql_pass'],$INSTALLER09['mysql_db'],$root); //== Win - remember to set your path up correctly - atm its set for appserv | |
| - exec($q, $o); | |
| - if (!count($o)) { | |
| - $out.= '<div class="readable">Database was imported</div><div class="info" style="text-align:center"><input type="button" value="Finish" onclick="window.location.href=\'?step=3\'"/></div>'; | |
| + $mysqli = new mysqli($INSTALLER09['mysql_host'], $INSTALLER09['mysql_user'], $INSTALLER09['mysql_pass'], $INSTALLER09['mysql_db']); | |
| + $endqueries = ';'; | |
| + $endqueries_basicdata = ';'; | |
| + $out = '<fieldset><legend>'.____('Database').'</legend>'; | |
| + $sql_query = @fread(@fopen($table_structure, 'r'), @filesize($table_structure)); | |
| + $sql_query = take_out_remarks($sql_query); | |
| + $sql_query = split_sql_file($sql_query, $endqueries); | |
| + for ($i = 0; $i < count($sql_query); $i++) | |
| + { | |
| + $stmt_query = $mysqli->stmt_init(); | |
| + $stmt_query->prepare($sql_query[$i]); | |
| + $stmt_query->execute(); | |
| + if (($stmt_query->errno) != 0) | |
| + { | |
| + $out.= '<div class="notreadable">'.____('There was an error while importing the structure: ').'<br/>'.$stmt_query->errno.''.____(' check for error.').'</div><div class="info" style="text-align:center"><input type="button" value='.____('Reload').' onclick="window.location.reload()"/></div>'; | |
| + $out.= '</fieldset>'; | |
| + print ($out); | |
| + $mysqli->close(); | |
| + die(); | |
| + } | |
| + } | |
| + $out.= '<div class="readable">'.____('The structure of database was imported successful').'</div>'; | |
| + unset($sql_query); | |
| + $sql_query = @fread(@fopen($table_basicdata, 'r'), @filesize($table_basicdata)); | |
| + $sql_query = take_out_remarks($sql_query); | |
| + $sql_query = split_sql_file($sql_query, $endqueries_basicdata); | |
| + for ($i = 0; $i < count($sql_query); $i++) | |
| + { | |
| + $stmt_query = $mysqli->stmt_init(); | |
| + $stmt_query->prepare($sql_query[$i]); | |
| + $stmt_query->execute(); | |
| + if (($stmt_query->errno) != 0) | |
| + { | |
| + $out.= '<div class="notreadable">'.____('There was an error while importing the basicdata: ').'<br/>'.$stmt_query->errno.''.____(' check for error.').'</div><div class="info" style="text-align:center"><input type="button" value='.____('Reload').' onclick="window.location.reload()"/></div>'; | |
| + $out.= '</fieldset>'; | |
| + print ($out); | |
| + $mysqli->close(); | |
| + die(); | |
| + } | |
| + } | |
| + $out.= '<div class="readable">'.____('Basicdata of database was imported successful').'</div><div class="info" style="text-align:center"><input type="button" value='.____('Finish').' onclick="window.location.href=\'?step=3\'"/></div>'; | |
| file_put_contents('step2.lock', 1); | |
| - } else $out.= '<div class="notreadable">There was an error while importing the database<br/>'.$o.'</div>'; | |
| $out.= '</fieldset>'; | |
| print ($out); | |
| + $mysqli->close(); | |
| } | |
| + | |
| ?> | |
| diff --git a/install/functions/permissioncheck.php b/install/functions/permissioncheck.php | |
| index 8f0589f..f073e49 100644 | |
| --- a/install/functions/permissioncheck.php | |
| +++ b/install/functions/permissioncheck.php | |
| @@ -29,15 +29,15 @@ function permissioncheck() | |
| ); | |
| checkdir($dirs); | |
| $continue = true; | |
| - $out = '<fieldset><legend>Directory check</legend>'; | |
| + $out = '<fieldset><legend>'.____('Directory check').'</legend>'; | |
| foreach ($dirs as $dir => $state) { | |
| if (!$state) $continue = false; | |
| $out.= '<div class="'.($state ? 'readable' : 'notreadable').'">'.$dir.'</div>'; | |
| } | |
| - if (!$continue) $out.= '<div class="info" style="text-align:center">It looks like you need to chmod some directories!<br/>all directories marked in red should be chmoded 0777<br/><input type="button" value="Reload" onclick="window.location.reload()"/></div>'; | |
| + if (!$continue) $out.= '<div class="info" style="text-align:center">'.____('It looks like you need to chmod some directories!').'<br/>'.____('all directories marked in red should be chmoded 0777').'<br/><input type="button" value='.____('Reload').' onclick="window.location.reload()"/></div>'; | |
| $out.= '</fieldset>'; | |
| if ($continue) { | |
| - $out.= '<fieldset><div style="text-align:center"><input type="button" onclick="window.location.href=\'index.php?step=1\'" value="Next step" /></div></fieldset>'; | |
| + $out.= '<fieldset><div style="text-align:center"><input type="button" onclick="window.location.href=\'index.php?step=1\'" value='.____('Next step').' /></div></fieldset>'; | |
| file_put_contents('step0.lock', '1'); | |
| } | |
| return $out; | |
| diff --git a/install/functions/writeconfig.php b/install/functions/writeconfig.php | |
| index 98bc605..1d7b82f 100644 | |
| --- a/install/functions/writeconfig.php | |
| +++ b/install/functions/writeconfig.php | |
| @@ -1,97 +1,97 @@ | |
| <?php | |
| //==09 Installer by putyn | |
| $foo = array( | |
| - 'Database' => array( | |
| + ____('Database') => array( | |
| array( | |
| - 'text' => 'Host', | |
| + 'text' => ____('Host'), | |
| 'input' => 'config[mysql_host]', | |
| - 'info' => 'Usually this will be localhost unless your on a cluster server.' | |
| + 'info' => ____('Usually this will be localhost unless your on a cluster server.') | |
| ) , | |
| array( | |
| - 'text' => 'Username', | |
| + 'text' => ____('Username'), | |
| 'input' => 'config[mysql_user]', | |
| - 'info' => 'Your mysql username.' | |
| + 'info' => ____('Your mysql username.') | |
| ) , | |
| array( | |
| - 'text' => 'Password', | |
| + 'text' => ____('Password'), | |
| 'input' => 'config[mysql_pass]', | |
| - 'info' => 'Your mysql password.' | |
| + 'info' => ____('Your mysql password.') | |
| ) , | |
| array( | |
| - 'text' => 'Database', | |
| + 'text' => ____('Database'), | |
| 'input' => 'config[mysql_db]', | |
| - 'info' => 'Your mysql database name.' | |
| + 'info' => ____('Your mysql database name.') | |
| ) , | |
| ) , | |
| - 'Tracker' => array( | |
| + ____('Tracker') => array( | |
| array( | |
| - 'text' => 'Announce Url', | |
| + 'text' => ____('Announce Url'), | |
| 'input' => 'config[announce_urls]', | |
| - 'info' => 'Your announce url.' | |
| + 'info' => ____('Your announce url.') | |
| ) , | |
| array( | |
| - 'text' => 'HTTPS Announce Url', | |
| + 'text' => ____('HTTPS Announce Url'), | |
| 'input' => 'config[announce_https]', | |
| - 'info' => 'Your HTTPS announce url.' | |
| + 'info' => ____('Your HTTPS announce url.') | |
| ) , | |
| array( | |
| - 'text' => 'Site Email', | |
| + 'text' => ____('Site Email'), | |
| 'input' => 'config[site_email]', | |
| - 'info' => 'Your site email address.' | |
| + 'info' => ____('Your site email address.') | |
| ) , | |
| array( | |
| - 'text' => 'Site Name', | |
| + 'text' => ____('Site Name'), | |
| 'input' => 'config[site_name]', | |
| - 'info' => 'Your site name.' | |
| + 'info' => ____('Your site name.') | |
| ) , | |
| ) , | |
| - 'Cookies' => array( | |
| + ____('Cookies') => array( | |
| array( | |
| - 'text' => 'Prefix', | |
| + 'text' => ____('Prefix'), | |
| 'input' => 'config[cookie_prefix]', | |
| - 'info' => 'Only required for sub-domain installs.' | |
| + 'info' => ____('Only required for sub-domain installs.') | |
| ) , | |
| array( | |
| - 'text' => 'Path', | |
| + 'text' => ____('Path'), | |
| 'input' => 'config[cookie_path]', | |
| - 'info' => 'Only required for sub-domain installs.' | |
| + 'info' => ____('Only required for sub-domain installs.') | |
| ) , | |
| array( | |
| - 'text' => 'Cookie Domain', | |
| + 'text' => ____('Cookie Domain'), | |
| 'input' => 'config[cookie_domain]', | |
| - 'info' => 'Your domain name - note exclude http and www.' | |
| + 'info' => ____('Your domain name - note exclude http and www.') | |
| ) , | |
| array( | |
| - 'text' => 'Domain', | |
| + 'text' => ____('Domain'), | |
| 'input' => 'config[domain]', | |
| - 'info' => 'Your site domain name - note exclude http or www.' | |
| + 'info' => ____('Your site domain name - note exclude http or www.') | |
| ) , | |
| ) , | |
| - 'Announce' => array( | |
| + ____('Announce') => array( | |
| array( | |
| - 'text' => 'Host', | |
| + 'text' => ____('Host'), | |
| 'input' => 'announce[mysql_host]', | |
| - 'info' => 'Usually this will be localhost unless your on a cluster server.' | |
| + 'info' => ____('Usually this will be localhost unless your on a cluster server.') | |
| ) , | |
| array( | |
| - 'text' => 'Username', | |
| + 'text' => ____('Username'), | |
| 'input' => 'announce[mysql_user]', | |
| - 'info' => 'Your mysql username.' | |
| + 'info' => ____('Your mysql username.') | |
| ) , | |
| array( | |
| - 'text' => 'Password', | |
| + 'text' => ____('Password'), | |
| 'input' => 'announce[mysql_pass]', | |
| - 'info' => 'Your mysql password.' | |
| + 'info' => ____('Your mysql password.') | |
| ) , | |
| array( | |
| - 'text' => 'Database', | |
| + 'text' => ____('Database'), | |
| 'input' => 'announce[mysql_db]', | |
| - 'info' => 'Your mysql database name.' | |
| + 'info' => ____('Your mysql database name.') | |
| ) , | |
| array( | |
| - 'text' => 'Domain', | |
| + 'text' => ____('Domain'), | |
| 'input' => 'announce[baseurl]', | |
| - 'info' => 'Your domain name - note include http and www.' | |
| + 'info' => ____('Your domain name - note include http and www.') | |
| ) , | |
| ) , | |
| ); | |
| @@ -118,37 +118,37 @@ function saveconfig() | |
| { | |
| global $root; | |
| $continue = true; | |
| - $out = "<fieldset><legend>Write config</legend>"; | |
| + $out = '<fieldset><legend>'.____('Write config').'</legend>'; | |
| if (!file_exists('config.lock')) { | |
| $config = file_get_contents('extra/config.sample.php'); | |
| $keys = array_map('foo', array_keys($_POST['config'])); | |
| $values = array_values($_POST['config']); | |
| $config = preg_replace($keys, $values, $config); | |
| if (file_put_contents($root.'include/config.php', $config)) { | |
| - $out.= '<div class="readable">Config file was saved</div>'; | |
| + $out.= '<div class="readable">'.____('Config file was saved').'</div>'; | |
| file_put_contents('config.lock', 1); | |
| } else { | |
| - $out.= '<div class="notreadable">Config file could not be saved</div>'; | |
| + $out.= '<div class="notreadable">'.____('Config file could not be saved').'</div>'; | |
| $continue = false; | |
| } | |
| - } else $out.= '<div class="readable">Config file was already written</div>'; | |
| + } else $out.= '<div class="readable">'.____('Config file was already written').'</div>'; | |
| if (!file_exists('announce.lock')) { | |
| $announce = file_get_contents('extra/ann_config.sample.php'); | |
| $keys = array_map('foo', array_keys($_POST['announce'])); | |
| $values = array_values($_POST['announce']); | |
| $announce = preg_replace($keys, $values, $announce); | |
| if (file_put_contents($root.'include/ann_config.php', $announce)) { | |
| - $out.= '<div class="readable">Announce file was saved</div>'; | |
| + $out.= '<div class="readable">'.____('Announce file was saved').'</div>'; | |
| file_put_contents('announce.lock', 1); | |
| } else { | |
| - $out.= '<div class="notreadable">announce file could not be saved</div>'; | |
| + $out.= '<div class="notreadable">'.____('announce file could not be saved').'</div>'; | |
| $continue = false; | |
| } | |
| - } else $out.= '<div class="readable">Announce file was already written</div>'; | |
| + } else $out.= '<div class="readable">'.____('Announce file was already written').'</div>'; | |
| if ($continue) { | |
| - $out.= '<div style="text-align:center" class="info"><input type="button" value="Next step" onclick="window.location.href=\'index.php?step=2\'"/></div>'; | |
| + $out.= '<div style="text-align:center" class="info"><input type="button" value='.____('Next step').' onclick="window.location.href=\'index.php?step=2\'"/></div>'; | |
| file_put_contents('step1.lock', 1); | |
| - } else $out.= '<div style="text-align:center" class="info"><input type="button" value="Go back" onclick="window.go(-1)"/></div>'; | |
| + } else $out.= '<div style="text-align:center" class="info"><input type="button" value='.____('Go back').' onclick="window.go(-1)"/></div>'; | |
| $out.= '</fieldset>'; | |
| print ($out); | |
| } | |
| diff --git a/install/index.php b/install/index.php | |
| index 22a308e..944f430 100644 | |
| --- a/install/index.php | |
| +++ b/install/index.php | |
| @@ -1,8 +1,46 @@ | |
| <?php | |
| +class TempDB extends SQLite3 | |
| +{ | |
| + function __construct() | |
| + { | |
| + $this->open(":memory:"); | |
| + } | |
| +} | |
| + | |
| +function ____($words) | |
| +{ | |
| + global $db; | |
| + $stmt = $db->prepare('SELECT locale FROM script_texts WHERE deftext = :words'); | |
| + $stmt->bindValue(':words', $words); | |
| + $res = $stmt->execute(); | |
| + $res = $res->fetchArray(SQLITE3_ASSOC); | |
| + $locale = $res['locale']; | |
| + if (!isset($locale)) return $words; | |
| + return $locale; | |
| +} | |
| +require_once ('functions/database.php'); | |
| +$table_locales = 'extra/script_text_locales.sql'; | |
| +$sql_query = @fread(@fopen($table_locales, 'r'), @filesize($table_locales)); | |
| +$sql_query = take_out_remarks($sql_query); | |
| +$sql_query = split_sql_file($sql_query,';'); | |
| +$db = new TempDB(); | |
| +if (!$db) die ("Could not create in-memory database."); | |
| +$lang = substr($_SERVER["HTTP_ACCEPT_LANGUAGE"],0,2); | |
| +for ($i = 0; $i < count($sql_query); $i++) | |
| +{ | |
| + $stmt = $db->prepare($sql_query[$i]); | |
| + if (($db->lastErrorCode()) != 0) | |
| + { | |
| + die("There was an error while importing locales text: " . $db->lastErrorMsg() ); | |
| + $bd->close(); | |
| + } | |
| + $stmt->bindValue(':lang', $lang); | |
| + $stmt->execute(); | |
| +} | |
| $step = isset($_GET['step']) ? (int)$_GET['step'] : 0; | |
| $root = $_SERVER['DOCUMENT_ROOT']; | |
| if ($root[strlen($root) - 1] != DIRECTORY_SEPARATOR) $root = $root.DIRECTORY_SEPARATOR; | |
| -if (file_exists($root.'include/install.lock')) die('This was already installed, huh ? how this happened'); | |
| +if (file_exists($root.'include/install.lock')) die(____('This was already installed, huh ? how this happened')); | |
| function checkpreviousstep() | |
| { | |
| $step = isset($_GET['step']) ? (int)$_GET['step'] - 1 : 0; | |
| @@ -39,7 +77,7 @@ if ($_SERVER['REQUEST_METHOD'] == 'POST') { | |
| break; | |
| default: | |
| - print ('<fieldset><div class="notreadable">Unknown action</div></fieldset>'); | |
| + print ('<fieldset><div class="notreadable">'.____('Unknown action').'</div></fieldset>'); | |
| } | |
| } else { | |
| switch ($step) { | |
| @@ -53,7 +91,7 @@ if ($_SERVER['REQUEST_METHOD'] == 'POST') { | |
| require_once ('functions/writeconfig.php'); | |
| $out = '<form action="index.php" method="post">'; | |
| foreach ($foo as $fo => $fooo) $out.= createblock($fo, $fooo); | |
| - $out.= '<fieldset><div style="text-align:center"><input type="submit" value="Submit data" /><input type="hidden" value="write" name="do" /></div></fieldset></form>'; | |
| + $out.= '<fieldset><div style="text-align:center"><input type="submit" value='.____('Submit data').' /><input type="hidden" value="write" name="do" /></div></fieldset></form>'; | |
| print ($out); | |
| break; | |
| @@ -64,7 +102,7 @@ if ($_SERVER['REQUEST_METHOD'] == 'POST') { | |
| break; | |
| case 3: | |
| - $out = '<fieldset><legend>All done</legend><div class="info">Installation complete</div></fieldset>'; | |
| + $out = '<fieldset><legend>'.____('All done').'</legend><div class="info">'.____('Installation complete').'</div></fieldset>'; | |
| print ($out); | |
| break; | |
| } | |
| -- | |
| 1.7.11.msysgit.1 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment