Weet niet of het het goeie forum is, maar is er toevallig nog iemand die de SQL van EliteAvengers source heeft? Die zou ik graag willen hebben.
EliteAvengers SQL
-
Guest, wil je besparen op je domeinnamen? (ad)
-
Heb je geluk dat ik al jaren bezig ben en heel veel zaken staan heb :p
PHP
Toon Meer-- phpMyAdmin SQL Dump -- version 2.6.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generatie Tijd: 23 Jul 2005 om 18:04 -- Server versie: 4.0.17 -- PHP Versie: 4.3.10 -- -- Database: `elitea_elite` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[buildings]` -- CREATE TABLE `[buildings]` ( `type` varchar(225) NOT NULL default '', `city` varchar(225) NOT NULL default '', `owner` varchar(225) NOT NULL default 'unowned', `start` datetime NOT NULL default '0000-00-00 00:00:00', `price` int(11) NOT NULL default '0', `production` datetime NOT NULL default '0000-00-00 00:00:00', `profit` int(50) NOT NULL default '0', `active` int(11) NOT NULL default '0', `amount` int(50) NOT NULL default '0' ) TYPE=MyISAM; -- -- Gegevens worden uitgevoerd voor tabel `[buildings]` -- INSERT INTO `[buildings]` VALUES ('bulletfactory', 'California', 'ZeRoDeaD', '2005-07-17 10:48:28', 210, '0000-00-00 00:00:00', -577507898, 250, 250); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Ohio', 'ant9002', '2005-07-17 00:44:03', 1000, '0000-00-00 00:00:00', -349850, 0, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'New York', 'marnix', '2005-07-16 21:50:46', 2500, '0000-00-00 00:00:00', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Texas', 'Henderson', '2005-07-16 21:57:45', 500, '0000-00-00 00:00:00', 4134500, 250, 2500); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Nevada', 'Dionisus', '2005-07-18 12:21:21', 2500, '0000-00-00 00:00:00', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'New Jersey', '5litre', '2005-07-17 01:07:39', 99999, '0000-00-00 00:00:00', -2692500, 250, 1750); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Illinois', 'bennythec0p', '2005-07-22 15:17:25', 2500, '0000-00-00 00:00:00', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Colorado', 'Sh1t', '2005-07-17 00:08:45', 200, '0000-00-00 00:00:00', -1194984, 50, 4250); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Michigan', 'LegendKillah', '2005-06-10 16:10:13', 250, '2005-04-25 19:56:09', 251750, 250, 4250); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Louisiana', 'Polsie', '2005-07-22 13:06:33', 99999, '0000-00-00 00:00:00', -1450000, 250, 250); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Pennsylvania', 'charlesworth', '2005-07-23 04:00:36', 220, '0000-00-00 00:00:00', -150000, 250, 750); INSERT INTO `[buildings]` VALUES ('bulletfactory', 'Admin Palace', 'unowned', '2005-04-23 20:29:16', 2500, '0000-00-00 00:00:00', 0, 0, 2142383647); INSERT INTO `[buildings]` VALUES ('roulette', 'New York', 'ant9002', '2005-07-16 23:44:05', 100, '2005-04-27 06:26:47', -100, 0, 0); INSERT INTO `[buildings]` VALUES ('roulette', 'California', 'ZeRoDeaD', '2005-07-21 23:49:22', 100, '2005-04-27 06:20:38', -6744402, 0, 0); INSERT INTO `[buildings]` VALUES ('roulette', 'Colorado', 'Polsie', '2005-07-17 11:13:52', 100, '2005-04-27 06:21:26', 1280, 0, 0); INSERT INTO `[buildings]` VALUES ('roulette', 'Michigan', 'HeLLHouND', '2005-07-18 19:02:18', 100, '2005-04-27 06:21:42', -7900, 0, 0); INSERT INTO `[buildings]` VALUES ('roulette', 'Nevada', 'tidemanns', '2005-07-17 06:33:06', 100, '2005-04-27 06:22:01', 2100, 0, 0); INSERT INTO `[buildings]` VALUES ('roulette', 'New Jersey', 'canian', '2005-07-23 17:05:06', 2500, '2005-04-27 06:22:31', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('roulette', 'Ohio', 'ant9002', '2005-07-17 07:51:08', 100, '2005-04-27 06:22:53', 80610, 0, 0); INSERT INTO `[buildings]` VALUES ('roulette', 'Texas', 'Henderson', '2005-07-17 09:36:04', 2000, '2005-04-27 06:23:17', 3550, 0, 0); INSERT INTO `[buildings]` VALUES ('roulette', 'Illinois', 'Equilibrium', '2005-07-17 09:22:52', 100, '2005-04-27 06:23:45', -2900, 0, 0); INSERT INTO `[buildings]` VALUES ('roulette', 'Pennsylvania', 'ant9002', '2005-07-17 00:50:49', 100, '2005-04-27 06:24:04', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('roulette', 'Louisiana', 'dave', '2005-07-22 13:10:22', 100, '2005-04-27 06:24:29', -1900, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'New York', 'marnix', '2005-07-16 21:11:22', 2500, '0000-00-00 00:00:00', -135830, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'California', 'ZeRoDeaD', '2005-04-11 13:59:51', 0, '0000-00-00 00:00:00', -577537138, 1, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'Illinois', 'bennythec0p', '2005-07-22 15:18:19', 2500, '0000-00-00 00:00:00', 630, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'Colorado', 'Sh1t', '2005-07-16 23:13:58', 2500, '0000-00-00 00:00:00', 3220, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'Michigan', 'HeLLHouND', '2005-07-22 21:06:15', 2500, '0000-00-00 00:00:00', 420, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'Pennsylvania', 'charlesworth', '2005-07-18 12:22:44', 2500, '0000-00-00 00:00:00', 2310, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'Louisiana', 'NoMeRcY', '2005-07-22 13:06:42', 2500, '0000-00-00 00:00:00', 560, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'Nevada', 'Sh1t', '2005-07-16 22:27:17', 2500, '0000-00-00 00:00:00', 14570, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'New Jersey', 'ZeRoDeaD', '2005-07-23 14:38:00', 2500, '0000-00-00 00:00:00', 70, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'Ohio', 'ant9002', '2005-07-22 21:03:38', 2500, '0000-00-00 00:00:00', 590, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'Texas', 'Henderson', '2005-07-16 21:02:06', 2500, '0000-00-00 00:00:00', 1730, 0, 0); INSERT INTO `[buildings]` VALUES ('trainstation', 'Admin Palace', 'unowned', '2005-04-11 13:59:51', 2500, '0000-00-00 00:00:00', 0, 1, 0); INSERT INTO `[buildings]` VALUES ('slot', 'California', 'ZeRoDeaD', '2005-06-20 11:10:44', 2147483647, '0000-00-00 00:00:00', -554984018, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'Ohio', 'ant9002', '2005-07-17 01:41:50', 500, '0000-00-00 00:00:00', 3070, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'New York', 'marnix', '2005-07-16 23:57:00', 1, '0000-00-00 00:00:00', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'Texas', 'Henderson', '2005-07-17 09:05:32', 2000, '0000-00-00 00:00:00', 38300, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'Nevada', 'charlesworth', '2005-07-17 06:33:00', 100, '0000-00-00 00:00:00', 48, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'New Jersey', 'Equilibrium', '2005-07-17 08:37:50', 25000, '0000-00-00 00:00:00', 11103, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'Illinois', 'Equilibrium', '2005-07-17 09:39:47', 100, '0000-00-00 00:00:00', 198100, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'Colorado', 'Gangsterkil', '2005-07-19 21:09:33', 100, '0000-00-00 00:00:00', 2953, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'Michigan', 'towelie', '2005-07-16 23:19:07', 100, '2005-04-25 19:56:09', 25581, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'Louisiana', 'NoMeRcY', '2005-07-22 13:11:51', 20000000, '0000-00-00 00:00:00', 7100, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'Pennsylvania', 'Polsie', '2005-07-20 15:25:14', 11, '0000-00-00 00:00:00', -5989, 0, 0); INSERT INTO `[buildings]` VALUES ('slot', 'Admin Palace', 'unowned', '2005-04-23 20:29:16', 2500, '0000-00-00 00:00:00', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'New York', 'marnix', '2005-07-16 21:20:10', 1, '2005-04-27 06:26:47', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'California', 'ZeRoDeaD', '2005-04-27 06:20:38', 2147483647, '2005-04-27 06:20:38', 17888796, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'Colorado', 'Sh1t', '2005-07-16 23:06:07', 2, '2005-04-27 06:21:26', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'Michigan', 'Polsie', '2005-07-16 21:28:20', 11, '2005-04-27 06:21:42', -36000, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'Nevada', 'Equilibrium', '2005-07-16 22:15:08', 100, '2005-04-27 06:22:01', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'New Jersey', 'Gangsterkil', '2005-07-16 22:13:00', 100, '2005-04-27 06:22:31', 900, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'Ohio', 'ant9002', '2005-07-16 21:59:09', 500, '2005-04-27 06:22:53', 3400, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'Texas', 'Henderson', '2005-07-16 21:20:48', 100, '2005-04-27 06:23:17', 1100, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'Illinois', 'ZeRoDeaD', '2005-07-16 21:40:37', 25000, '2005-04-27 06:23:45', 0, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'Pennsylvania', 'Gangsterkil', '2005-07-16 21:21:23', 11, '2005-04-27 06:24:04', 35611, 0, 0); INSERT INTO `[buildings]` VALUES ('racetrack', 'Louisiana', 'charlesworth', '2005-07-22 13:13:09', 11, '2005-04-27 06:24:29', -10000, 0, 0); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[clans]` -- CREATE TABLE `[clans]` ( `id` int(15) NOT NULL auto_increment, `name` varchar(30) NOT NULL default 'Noname', `owner` varchar(16) NOT NULL default '', `started` datetime NOT NULL default '0000-00-00 00:00:00', `type` int(1) NOT NULL default '0', `info` text NOT NULL, `clicks` int(5) NOT NULL default '0', `clickstoday` int(3) NOT NULL default '0', `cash` int(9) NOT NULL default '0', `bank` int(9) NOT NULL default '10000', `bankleft` int(2) NOT NULL default '10', `bankmax` int(5) NOT NULL default '10000', `attwins` int(6) NOT NULL default '0', `attlosses` int(6) NOT NULL default '0', `defwins` int(6) NOT NULL default '0', `deflosses` int(6) NOT NULL default '0', `land` int(6) NOT NULL default '300', `homes` int(3) NOT NULL default '2', `money_lvl1` int(3) NOT NULL default '0', `money_lvl2` int(3) NOT NULL default '0', `money_lvl3` int(3) NOT NULL default '0', `def_lvl1` int(3) NOT NULL default '0', `def_lvl2` int(3) NOT NULL default '0', `def_lvl3` int(3) NOT NULL default '0', `IPs` text NOT NULL, `level` int(3) NOT NULL default '1', `recruiting` int(3) NOT NULL default '1', `open` int(50) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=94 ; -- -- Gegevens worden uitgevoerd voor tabel `[clans]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[cron]` -- CREATE TABLE `[cron]` ( `time` datetime default NULL, `name` varchar(16) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -- Gegevens worden uitgevoerd voor tabel `[cron]` -- INSERT INTO `[cron]` VALUES ('2005-07-23 18:00:06', 'hour'); INSERT INTO `[cron]` VALUES ('2005-07-23 02:00:14', 'day'); INSERT INTO `[cron]` VALUES ('2005-07-21 02:00:12', 'week'); INSERT INTO `[cron]` VALUES ('2005-07-01 07:27:36', 'month'); INSERT INTO `[cron]` VALUES ('2005-07-23 16:00:01', 'horserace'); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[detective]` -- CREATE TABLE `[detective]` ( `id` int(200) NOT NULL auto_increment, `naam` varchar(200) default NULL, `zoeker` varchar(200) default NULL, `uren` int(200) NOT NULL default '0', `tijd` datetime NOT NULL default '0000-00-00 00:00:00', `vind` int(200) NOT NULL default '0', `status` int(200) NOT NULL default '0', `land` varchar(225) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=207 ; -- -- Gegevens worden uitgevoerd voor tabel `[detective]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[garage]` -- CREATE TABLE `[garage]` ( `id` int(11) NOT NULL auto_increment, `car` varchar(255) NOT NULL default '', `damage` int(2) NOT NULL default '0', `original` varchar(255) NOT NULL default '', `city` varchar(225) NOT NULL default '', `date` datetime NOT NULL default '0000-00-00 00:00:00', `login` varchar(225) NOT NULL default '', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=6016 ; -- -- Gegevens worden uitgevoerd voor tabel `[garage]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[getuige]` -- CREATE TABLE `[getuige]` ( `id` int(255) NOT NULL auto_increment, `naam` varchar(255) NOT NULL default '', `vermoord` varchar(255) NOT NULL default '', `moorder` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=141 ; -- -- Gegevens worden uitgevoerd voor tabel `[getuige]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[handdruk]` -- CREATE TABLE `[handdruk]` ( `id` int(255) NOT NULL auto_increment, `naam` varchar(255) NOT NULL default '', `inzet` int(255) NOT NULL default '0', `wanneer` datetime NOT NULL default '0000-00-00 00:00:00', `land` varchar(225) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Gegevens worden uitgevoerd voor tabel `[handdruk]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[landen]` -- CREATE TABLE `[landen]` ( `id` int(6) NOT NULL auto_increment, `area` int(3) NOT NULL default '0', `land` varchar(128) NOT NULL default '', `aantal` int(3) NOT NULL default '0', `prijs` int(128) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=71 ; -- -- Gegevens worden uitgevoerd voor tabel `[landen]` -- INSERT INTO `[landen]` VALUES (8, 4, 'California', 185, 360); INSERT INTO `[landen]` VALUES (7, 3, 'California', 340, 466); INSERT INTO `[landen]` VALUES (6, 2, 'California', 265, 321); INSERT INTO `[landen]` VALUES (5, 1, 'California', -2982, 190); INSERT INTO `[landen]` VALUES (9, 5, 'California', 152, 331); INSERT INTO `[landen]` VALUES (10, 6, 'California', 2487, 483); INSERT INTO `[landen]` VALUES (11, 1, 'New York', 455, 242); INSERT INTO `[landen]` VALUES (12, 2, 'New York', 175, 470); INSERT INTO `[landen]` VALUES (13, 3, 'New York', 158, 215); INSERT INTO `[landen]` VALUES (14, 4, 'New York', 235, 452); INSERT INTO `[landen]` VALUES (15, 5, 'New York', 225, 495); INSERT INTO `[landen]` VALUES (16, 6, 'New York', -769, 181); INSERT INTO `[landen]` VALUES (17, 1, 'Illinois', 2000000353, 430); INSERT INTO `[landen]` VALUES (18, 2, 'Illinois', -600, 292); INSERT INTO `[landen]` VALUES (19, 3, 'Illinois', 165, 320); INSERT INTO `[landen]` VALUES (20, 4, 'Illinois', 610, 434); INSERT INTO `[landen]` VALUES (21, 5, 'Illinois', 155, 385); INSERT INTO `[landen]` VALUES (22, 6, 'Illinois', 185, 467); INSERT INTO `[landen]` VALUES (23, 1, 'Michigan', 235, 382); INSERT INTO `[landen]` VALUES (24, 2, 'Michigan', 155, 270); INSERT INTO `[landen]` VALUES (25, 3, 'Michigan', -470, 193); INSERT INTO `[landen]` VALUES (26, 4, 'Michigan', 100, 421); INSERT INTO `[landen]` VALUES (27, 5, 'Michigan', 165, 497); INSERT INTO `[landen]` VALUES (28, 6, 'Michigan', 405, 384); INSERT INTO `[landen]` VALUES (29, 1, 'Colorado', 2116, 403); INSERT INTO `[landen]` VALUES (30, 2, 'Colorado', 100, 140); INSERT INTO `[landen]` VALUES (31, 3, 'Colorado', 100, 356); INSERT INTO `[landen]` VALUES (32, 4, 'Colorado', 100, 156); INSERT INTO `[landen]` VALUES (33, 5, 'Colorado', 75, 157); INSERT INTO `[landen]` VALUES (34, 6, 'Colorado', -2005, 113); INSERT INTO `[landen]` VALUES (35, 1, 'Nevada', 255, 377); INSERT INTO `[landen]` VALUES (36, 2, 'Nevada', 108, 373); INSERT INTO `[landen]` VALUES (37, 3, 'Nevada', 100, 394); INSERT INTO `[landen]` VALUES (38, 4, 'Nevada', 120, 265); INSERT INTO `[landen]` VALUES (39, 5, 'Nevada', -317, 101); INSERT INTO `[landen]` VALUES (40, 6, 'Nevada', 250, 243); INSERT INTO `[landen]` VALUES (41, 1, 'Louisiana', 155, 289); INSERT INTO `[landen]` VALUES (42, 2, 'Louisiana', 100, 492); INSERT INTO `[landen]` VALUES (43, 3, 'Louisiana', 100, 327); INSERT INTO `[landen]` VALUES (44, 4, 'Louisiana', 100, 489); INSERT INTO `[landen]` VALUES (45, 5, 'Louisiana', 155, 326); INSERT INTO `[landen]` VALUES (46, 6, 'Louisiana', 0, 176); INSERT INTO `[landen]` VALUES (47, 1, 'Pennsylvania', 155, 377); INSERT INTO `[landen]` VALUES (48, 2, 'Pennsylvania', 155, 335); INSERT INTO `[landen]` VALUES (49, 3, 'Pennsylvania', 100, 216); INSERT INTO `[landen]` VALUES (50, 4, 'Pennsylvania', 110, 486); INSERT INTO `[landen]` VALUES (51, 5, 'Pennsylvania', 140, 307); INSERT INTO `[landen]` VALUES (52, 6, 'Pennsylvania', -350, 180); INSERT INTO `[landen]` VALUES (53, 1, 'New Jersey', 115, 242); INSERT INTO `[landen]` VALUES (54, 2, 'New Jersey', 610, 476); INSERT INTO `[landen]` VALUES (55, 3, 'New Jersey', 140, 247); INSERT INTO `[landen]` VALUES (56, 4, 'New Jersey', -660, 158); INSERT INTO `[landen]` VALUES (57, 5, 'New Jersey', 128, 251); INSERT INTO `[landen]` VALUES (58, 6, 'New Jersey', 280, 355); INSERT INTO `[landen]` VALUES (66, 2, 'Texas', -100, 135); INSERT INTO `[landen]` VALUES (62, 2, 'Ohio', 130, 300); INSERT INTO `[landen]` VALUES (63, 3, 'Ohio', 180, 352); INSERT INTO `[landen]` VALUES (65, 1, 'Texas', 99, 391); INSERT INTO `[landen]` VALUES (59, 1, 'Ohio', 1000000083, 360); INSERT INTO `[landen]` VALUES (60, 4, 'Ohio', 100, 498); INSERT INTO `[landen]` VALUES (61, 5, 'Ohio', 120, 326); INSERT INTO `[landen]` VALUES (64, 6, 'Ohio', 350, 425); INSERT INTO `[landen]` VALUES (67, 3, 'Texas', 145, 277); INSERT INTO `[landen]` VALUES (68, 4, 'Texas', 100, 257); INSERT INTO `[landen]` VALUES (69, 5, 'Texas', 100, 242); INSERT INTO `[landen]` VALUES (70, 6, 'Texas', 205, 356); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[logs]` -- CREATE TABLE `[logs]` ( `time` datetime default NULL, `IP` varchar(32) default NULL, `forwardedFor` varchar(32) default NULL, `login` varchar(225) default NULL, `person` varchar(225) default NULL, `code` int(10) default NULL, `area` varchar(32) default NULL ) TYPE=MyISAM; -- -- Gegevens worden uitgevoerd voor tabel `[logs]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[messages]` -- CREATE TABLE `[messages]` ( `id` int(9) NOT NULL auto_increment, `IP` varchar(32) NOT NULL default '', `forwardedFor` varchar(32) default NULL, `time` datetime default NULL, `from` varchar(45) default NULL, `to` varchar(16) default NULL, `subject` varchar(50) NOT NULL default '', `message` text NOT NULL, `read` int(1) NOT NULL default '0', `inbox` int(1) default '1', `outbox` int(1) default '1', `saved` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=6236 ; -- -- Gegevens worden uitgevoerd voor tabel `[messages]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[omnilog]` -- CREATE TABLE `[omnilog]` ( `time` datetime default NULL, `login` varchar(16) default NULL, `IP` varchar(32) default NULL, `forwardedFor` varchar(32) default NULL, `file` varchar(64) default NULL, `$_POST` text, `$_GET` text ) TYPE=MyISAM; -- -- Gegevens worden uitgevoerd voor tabel `[omnilog]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[online]` -- CREATE TABLE `[online]` ( `time` datetime default NULL, `IP` varchar(32) default NULL, `login` varchar(16) NOT NULL default '', `validate` varchar(32) default NULL, PRIMARY KEY (`login`), KEY `IP` (`IP`) ) TYPE=MyISAM; -- -- Gegevens worden uitgevoerd voor tabel `[online]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[orgcrime]` -- CREATE TABLE `[orgcrime]` ( `id` int(100) NOT NULL auto_increment, `leader` varchar(100) default NULL, `we` varchar(100) default NULL, `pilot` varchar(100) default NULL, `ee` varchar(100) default NULL, `hacker` varchar(100) default NULL, `lo` varchar(100) default NULL, `weapon` int(1) NOT NULL default '0', `weapons` int(1) NOT NULL default '0', `chopper` int(1) NOT NULL default '0', `explosive` int(1) NOT NULL default '0', `explosives` int(1) NOT NULL default '0', `pcs` int(1) NOT NULL default '0', `los` int(1) NOT NULL default '0', `ready` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Gegevens worden uitgevoerd voor tabel `[orgcrime]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[temp]` -- CREATE TABLE `[temp]` ( `id` int(16) NOT NULL auto_increment, `time` datetime default NULL, `login` varchar(16) default NULL, `IP` varchar(32) default NULL, `forwardedFor` varchar(32) default NULL, `code` int(10) unsigned NOT NULL default '0', `area` varchar(32) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2543 ; -- -- Gegevens worden uitgevoerd voor tabel `[temp]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[users]` -- CREATE TABLE `[users]` ( `id` int(4) NOT NULL auto_increment, `signup` datetime default NULL, `login` varchar(50) default NULL, `pass` varchar(32) default NULL, `level` int(3) NOT NULL default '1', `IP` varchar(32) default NULL, `email` varchar(64) default NULL, `type` int(1) default NULL, `url` varchar(128) NOT NULL default '', `info` text NOT NULL, `music` varchar(225) NOT NULL default '', `cash` int(9) NOT NULL default '10000', `bank` int(9) NOT NULL default '2500', `bankleft` int(1) NOT NULL default '5', `bankmax` int(4) NOT NULL default '2500000', `clicks` int(4) NOT NULL default '0', `clickstoday` int(3) NOT NULL default '0', `lotto` int(1) NOT NULL default '1', `attack` int(6) NOT NULL default '0', `defence` int(6) NOT NULL default '0', `attwins` int(6) NOT NULL default '0', `attlosses` int(6) NOT NULL default '0', `defwins` int(6) NOT NULL default '0', `deflosses` int(6) NOT NULL default '0', `clan` varchar(36) NOT NULL default '', `clanlevel` int(3) NOT NULL default '0', `bonus` text NOT NULL, `missie` int(5) NOT NULL default '1', `bullets` int(11) NOT NULL default '100', `smstegoed` int(5) NOT NULL default '30', `City` varchar(128) NOT NULL default 'California', `Citynumb` int(1) NOT NULL default '1', `showonline` int(1) NOT NULL default '1', `online` datetime NOT NULL default '0000-00-00 00:00:00', `activated` int(1) NOT NULL default '0', `Knife` int(5) NOT NULL default '0', `Walter P99` int(5) NOT NULL default '0', `Uzi` int(5) NOT NULL default '0', `MP5k` int(5) NOT NULL default '0', `Flashbang` int(5) NOT NULL default '0', `Granaat` int(5) NOT NULL default '0', `Shotgun` int(5) NOT NULL default '0', `G36C` int(5) NOT NULL default '0', `SIG 552` int(5) NOT NULL default '0', `Ak47` int(5) NOT NULL default '0', `Ak Beta` int(5) NOT NULL default '0', `Scherpschut geweer` int(5) NOT NULL default '0', `Granaat Lanceerder` int(5) NOT NULL default '0', `Bazooka` int(5) NOT NULL default '0', `Kogelvrij vest` int(5) NOT NULL default '0', `Bulldog` int(5) NOT NULL default '0', `Camera` int(5) NOT NULL default '0', `Hek` int(5) NOT NULL default '0', `Muur` int(5) NOT NULL default '0', `Bunker` int(5) NOT NULL default '0', `Mobieltje` int(1) NOT NULL default '0', `FN P90` int(5) NOT NULL default '0', `Chip` int(5) NOT NULL default '0', `Helm` int(5) NOT NULL default '0', `Politie wagen` int(5) NOT NULL default '0', `IPs` text NOT NULL, `blocklist` text NOT NULL, `recruiters` int(26) NOT NULL default '0', `Scorpion` int(5) NOT NULL default '0', `Tigher` int(5) NOT NULL default '0', `Hellbender` int(5) NOT NULL default '0', `Bankpas` int(5) NOT NULL default '0', `PIN` int(4) NOT NULL default '1234', `avatar` varchar(225) NOT NULL default 'images/nopic.gif', `change` int(2) NOT NULL default '2', `health` int(5) NOT NULL default '100', `GoliathTank` int(5) NOT NULL default '0', `Shield` int(5) NOT NULL default '0', `drug1` int(11) NOT NULL default '0', `drug2` int(11) NOT NULL default '0', `drug3` int(11) NOT NULL default '0', `drug4` int(11) NOT NULL default '0', `drug5` int(11) NOT NULL default '0', `drug6` int(11) NOT NULL default '0', `strength` int(11) NOT NULL default '0', `won` int(11) NOT NULL default '0', `lost` int(11) NOT NULL default '0', `gstart` int(1) NOT NULL default '0', `orgtime` datetime NOT NULL default '0000-00-00 00:00:00', `land` varchar(225) NOT NULL default 'Unknown', `woonplaats` varchar(225) NOT NULL default 'Unknown', `realname` varchar(225) NOT NULL default 'Unknown', `age` int(11) NOT NULL default '0', `opdruktijd` datetime NOT NULL default '0000-00-00 00:00:00', `opdruktijd1` int(200) NOT NULL default '0', `m1` int(50) NOT NULL default '0', `misdaad` datetime NOT NULL default '0000-00-00 00:00:00', `m2` int(10) NOT NULL default '0', `m3` int(10) NOT NULL default '0', `m4` int(10) NOT NULL default '0', `m5` int(10) NOT NULL default '0', `m6` int(10) NOT NULL default '0', `codechecker` int(50) NOT NULL default '0', `Apache` int(5) NOT NULL default '0', `posts` int(50) NOT NULL default '0', `postdate` datetime NOT NULL default '0000-00-00 00:00:00', `auto` datetime NOT NULL default '0000-00-00 00:00:00', `a1` int(10) NOT NULL default '0', `a2` int(10) NOT NULL default '0', `a3` int(10) NOT NULL default '0', `a4` int(10) NOT NULL default '0', `a5` int(10) NOT NULL default '0', `a6` int(10) NOT NULL default '0', `weapon` int(2) NOT NULL default '0', `protection` int(2) NOT NULL default '0', `messages` int(225) NOT NULL default '0', `recruiter` varchar(225) NOT NULL default '', `octime` datetime NOT NULL default '0000-00-00 00:00:00', `OCstatus` int(1) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `login` (`login`) ) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1047 ; -- -- Gegevens worden uitgevoerd voor tabel `[users]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `[weapons]` -- CREATE TABLE `[weapons]` ( `id` int(4) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `area` int(2) default NULL, `costs` int(7) default NULL, `url` varchar(40) default NULL, `attack` int(5) default NULL, `defence` int(5) default NULL, `max` text, `eval` text, `error` text, `extra` text, PRIMARY KEY (`id`), KEY `name` (`name`), KEY `area` (`area`) ) TYPE=MyISAM AUTO_INCREMENT=58 ; -- -- Gegevens worden uitgevoerd voor tabel `[weapons]` -- INSERT INTO `[weapons]` VALUES (1, 'Knife', 1, 2000, 'item-Knife', 20, 20, '1 per $type_s (You have $num $type_p who haven''t got a Knife)', '$num = $data->clicks-$data->{''Knife''}; return $num;', 'All your $type_s already have a Knife.', NULL); INSERT INTO `[weapons]` VALUES (35, 'Scorpion', 12, 60000, 'item-Scorpion', 1300, 730, '1 per $type_s (You have $num $type_p who havent got this weapon)', '$num = $data->clicks-$data->Scorpion; return $num;', 'All your $type_p have a Scorpion', ''); INSERT INTO `[weapons]` VALUES (2, 'Walter P99', 1, 5000, 'item-Walter_P99', 50, 50, '1 per $type_s (You have $num $type_p who haven''t got a Walter P99)', '$num = $data->clicks-$data->{''Walter P99''}; return $num;', 'All your $type_p already have a Walter P99', NULL); INSERT INTO `[weapons]` VALUES (3, 'Uzi', 1, 6000, 'item-Uzi', 65, 65, '1 per $type_s (You have $num $type_p who haven''t got a Uzi)', '$num = $data->clicks-$data->Uzi; return $num;', 'All of your $type_p already have an Uzi.', NULL); INSERT INTO `[weapons]` VALUES (4, 'Flashbang', 1, 10000, 'item-Flashbang', 110, 110, '1 per $type_s (Je hebt $num $type_p die deze granaat nog niet hebben)', '$num = $data->clicks-$data->Flashbang; return $num;', 'Al je $type_p hebben al een flashbang', NULL); INSERT INTO `[weapons]` VALUES (5, 'Granaat', 1, 15000, 'item-Grenade', 170, 170, '1 per $type_s (Je hebt $num $type_p die deze granaat nog niet hebben)', '$num = $data->clicks-$data->Granaat; return $num;', 'Al je $type_p hebben al een granaat', NULL); INSERT INTO `[weapons]` VALUES (6, 'MP5k', 1, 7500, 'item-MP5k', 80, 80, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL); INSERT INTO `[weapons]` VALUES (7, 'Shotgun', 1, 17500, 'item-Shotgun', 200, 200, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL); INSERT INTO `[weapons]` VALUES (8, 'G36C', 1, 22500, 'item-G36C', 270, 270, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL); INSERT INTO `[weapons]` VALUES (9, 'SIG 552', 1, 25000, 'item-SIG_552', 310, 310, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL); INSERT INTO `[weapons]` VALUES (10, 'Ak47', 1, 30000, 'item-Ak47', 390, 390, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL); INSERT INTO `[weapons]` VALUES (11, 'Ak Beta', 1, 40000, 'item-Ak_Beta', 570, 570, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL); INSERT INTO `[weapons]` VALUES (12, 'Scherpschut geweer', 1, 45000, 'item-Sniper_rifle', 670, 670, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL); INSERT INTO `[weapons]` VALUES (13, 'M4', 1, 50000, 'item-M4', 780, 780, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL); INSERT INTO `[weapons]` VALUES (14, 'Granaat Lanceerder', 1, 60000, 'item-Grenade_Launcher', 1030, 1030, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL); INSERT INTO `[weapons]` VALUES (15, 'Bazooka', 1, 75000, 'item-Bazooka', 1490, 1490, 'Je hebt $num $type_p die dit wapen kunnen dragen', '$num = $data->clicks-$data->MP5k-$data->Shotgun-$data->G36C-$data->{''SIG 552''}-$data->Ak47-$data->{''Ak Beta''}-$data->{''Scherpschut geweer''}-$data->M4-$data->{''Granaat Lanceerder''}-$data->Bazooka; return $num;', 'Je hebt geen $type_s die dit wapen kan dragen', NULL); INSERT INTO `[weapons]` VALUES (16, 'Kogelvrij vest', 2, 12500, 'item-Bulletproof_vest', 140, 140, '1 per $type_s (Je hebt $num $type_p die dit vest nog niet hebben)', '$num = $data->clicks-$data->{''Kogelvrij vest''}; return $num;', 'Je hebt geen $type_s die dit vest kan dragen', NULL); INSERT INTO `[weapons]` VALUES (17, 'Bulldog', 3, 2500, 'item-Bulldog', 0, 30, '5 (Je kan nog $num honden meer hebben)', '$num = 5-$data->Bulldog; return $num;', 'Je hebt al 5 honden', NULL); INSERT INTO `[weapons]` VALUES (18, 'Camera', 3, 8000, 'item-Cam', 0, 90, '7 (Je kan nog $num cameras plaatsen)', '$num = 7-$data->Camera; return $num;', 'Je hebt al 7 cameras', NULL); INSERT INTO `[weapons]` VALUES (19, 'Hek', 3, 15000, 'item-Barbed_wire', 0, 170, '3 (Je kan nog $num hekken neerzetten)', '$num = 3-$data->Hek; return $num;', 'Je hebt al 3 hekken', NULL); INSERT INTO `[weapons]` VALUES (20, 'Muur', 3, 20000, 'item-Stone_wall', 0, 240, '3 (Je kan nog $num muren bouwen)', '$num = 3-$data->Muur; return $num;', 'Je hebt al 3 muren', NULL); INSERT INTO `[weapons]` VALUES (21, 'Bunker', 3, 35000, 'item-Bunker', 0, 470, '5 (Je kan nog $num bunkers bouwen)', '$num = 5-$data->Bunker; return $num;', 'Je hebt al 5 bunkers', NULL); INSERT INTO `[weapons]` VALUES (22, 'Mobieltje', 4, 1000, 'item-Cellphone', NULL, NULL, '1 (Je kan nog $num mobieltjes kopen)', '$num = 1-$data->Mobieltje; return $num;', 'Je hebt al een mobieltje', 'Als je een mobiel hebt kun je berichten versturen en ontvangen'); INSERT INTO `[weapons]` VALUES (23, 'FN P90', 5, 50000, 'item-FN_P90', 900, 900, '1 per junkie (Je hebt nog $num junkies die dit wapen kunnen dragen)', '$num = $data->clicks-$data->{''FN P90''}; return $num;', 'Al je junkies hebben dit wapen al', NULL); INSERT INTO `[weapons]` VALUES (24, 'Chip', 6, 25000, 'item-Chip', 400, 400, '1 per kloon (Je hebt $num klonen die nog geen chip hebben)', '$num = $data->clicks-$data->Chip; return $num;', 'Al je klonen hebben al een chip in hun hoofd', NULL); INSERT INTO `[weapons]` VALUES (25, 'Helm', 7, 20000, 'item-Helmet', 240, 240, '1 per agent (Je hebt nog $num agenten zonder helm)', '$num = $data->clicks-$data->Helm; return $num;', 'Elke agent heeft al een helm', NULL); INSERT INTO `[weapons]` VALUES (26, 'Politie wagen', 7, 35000, 'item-Police_car', 470, 470, '1 per agent (Je kan nog $num wagens kopen)', '$num = $data->clicks-$data->{''Politie wagen''}; return $num;', 'Elke agent heeft al een wagen', NULL); INSERT INTO `[weapons]` VALUES (27, 'Home', 8, 25000, 'item-Home', NULL, NULL, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl2*500+$clan->money_lvl3*200+$clan->def_lvl1*100+$clan->def_lvl2*25+$clan->def_lvl3*150); $num -= ($clan->type == 3) ? 0 : $clan->money_lvl1*100; return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een huis te bouwen', 'In ieder huis kunnen 5 clan-members'); INSERT INTO `[weapons]` VALUES (28, 'Wall', 8, 50000, 'item-Stone_wall', NULL, 3000, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl2*500+$clan->money_lvl3*200+$clan->def_lvl1*100+$clan->def_lvl2*25+$clan->def_lvl3*150); $num -= ($clan->type == 3) ? 0 : $clan->money_lvl1*100; return ($num >= 100) ? 1 : 0;', 'Je hebt niet genoeg land om een muur te bouwen', NULL); INSERT INTO `[weapons]` VALUES (29, 'Sattelite', 9, 90000, 'item-Sattelite', NULL, NULL, '100m<sup>2</sup> (Je hebt nog ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl1*100+$clan->money_lvl2*500+$clan->money_lvl3*200+$clan->def_lvl1*100+$clan->def_lvl2*25+$clan->def_lvl3*150); return ($num >= 100) ? 1 : 0;', 'You haven''t got enough land to buy a sattelite.', 'Every members will get for every hour: Bank: $150,contant: $50'); INSERT INTO `[weapons]` VALUES (30, 'Casino', 10, 90000, 'item-Alchemy', NULL, NULL, '100m<sup>2</sup> (You still have ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl1*100+$clan->money_lvl2*500+$clan->money_lvl3*200+$clan->def_lvl1*100+$clan->def_lvl2*25+$clan->def_lvl3*150); return ($num >= 100) ? 1 : 0;', 'You haven''t got enough money to buy a Casino', 'Every crew-members get every hour:<br>Bank: $100,contant: $100'); INSERT INTO `[weapons]` VALUES (31, 'Stock', 11, 90000, 'item-Business', NULL, NULL, '1 Manager (You still have $num managers)', '$dbresX = mysql_query("SELECT `id` FROM `[users]` WHERE `clan`=''{$clan->name}'' AND `clanlevel`=''6''"); $num = (mysql_num_rows($dbresX)+1)-$clan->money_lvl1; return $num;', 'You need a manager to look at the stocks', 'Per manager verdient iedereen in het corps:<br>Bank: $200 tot $400 per uur'); INSERT INTO `[weapons]` VALUES (34, 'Hellbender', 12, 100000, 'item-Hellbender', 2000, 1800, '1 (You can buy $num Hellbenders)', '$num = 1-$data->Hellbender; return $num;', 'You already have a Hellbender!', NULL); INSERT INTO `[weapons]` VALUES (33, 'GoliathTank', 12, 495000, 'item-GoliathTank', 10000, 10000, '1 per $type_s (Je hebt $num $type_p die dit wapen nog niet hebben)', '$num = $data->clicks-$data->{''GoliathTank''}; return $num;', 'Al je $type_p hebben al een GoliathTank', ''); INSERT INTO `[weapons]` VALUES (56, 'Bullet Factory', 8, 750000, 'item-Bullet_Factory', NULL, NULL, '500m<sup>2</sup> (You have ${num}m<sup>2</sup>)', '$num = $clan->land-($clan->homes*100+$clan->money_lvl1*100+$clan->money_lvl2*500+$clan->money_lvl3*200+$clan->def_lvl1*100+$clan->def_lvl2*25+$clan->def_lvl3*150); return ($num >= 500) ? 1 : 0;', 'You haven''t got enough land to buy a Bullet Factory.', 'With a Bullet Factory every members will recieve every hour 10 Bullet. You''ll need atleast 1 sattelite to control them!'); INSERT INTO `[weapons]` VALUES (36, 'Tigher', 12, 649000, 'item-tank', 12000, 15000, '10 (You can buy $num Tighers)', '$num = 10-$data->Tigher; return $num;', 'You already have 10 Tighers!', NULL); INSERT INTO `[weapons]` VALUES (52, 'Shield', 2, 49500, 'item-Shield', 200, 1000, '1 per $type_s (You have $num $type_p who haven''t got this weapon)', '$num = $data->clicks-$data->{''Shield''}; return $num;', 'All your $type_p have a Shield', ''); INSERT INTO `[weapons]` VALUES (57, 'Apache', 1, 250000, 'item-apache', 4500, 4500, '1 per $type_s (You have $num $type_p who haven\\''t got this weapon)', '$num = $data->clicks-$data->{''Apache''}; return $num;', 'All your $type_p already have a Apache.', ''); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `attempts` -- CREATE TABLE `attempts` ( `id` int(225) NOT NULL auto_increment, `date` datetime NOT NULL default '0000-00-00 00:00:00', `login` varchar(225) NOT NULL default '', `defender` varchar(225) NOT NULL default '', `bullets` int(50) NOT NULL default '0', `result` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='?Copyright 2005/2006 Elite Avengers' AUTO_INCREMENT=98 ; -- -- Gegevens worden uitgevoerd voor tabel `attempts` -- INSERT INTO `attempts` VALUES (1, '2005-07-20 00:01:45', 'Henderson', 'StonedBoss', 3000, 0); INSERT INTO `attempts` VALUES (2, '2005-07-20 00:02:08', 'Henderson', 'StonedBoss', 700, 0); INSERT INTO `attempts` VALUES (3, '2005-07-20 00:02:17', 'Henderson', 'StonedBoss', 3000, 0); INSERT INTO `attempts` VALUES (4, '2005-07-20 00:02:27', 'Henderson', 'StonedBoss', 3000, 0); INSERT INTO `attempts` VALUES (5, '2005-07-20 00:02:35', 'Henderson', 'StonedBoss', 3000, 1); INSERT INTO `attempts` VALUES (66, '2005-07-22 15:14:30', 'Polsie', 'Snake', 14, 0); INSERT INTO `attempts` VALUES (65, '2005-07-22 15:14:28', 'Polsie', 'Snake', 14000, 0); INSERT INTO `attempts` VALUES (64, '2005-07-22 15:14:21', 'Polsie', 'Snake', 14, 0); INSERT INTO `attempts` VALUES (63, '2005-07-22 15:14:10', 'Polsie', 'Snake', 14821, 0); INSERT INTO `attempts` VALUES (62, '2005-07-22 14:51:19', 'ZeRoDeaD - MODKILL', 'Kemmie', 1, 1); INSERT INTO `attempts` VALUES (61, '2005-07-22 14:51:19', 'ZeRoDeaD', 'Kemmie - MODKILL', 1, 1); INSERT INTO `attempts` VALUES (60, '2005-07-22 14:49:09', 'ZeRoDeaD', 'Valefor', 5000, 1); INSERT INTO `attempts` VALUES (59, '2005-07-22 13:03:50', 'Snake', 'Theko', 50000, 1); INSERT INTO `attempts` VALUES (58, '2005-07-22 13:03:44', 'Snake', 'Theko', 50000, 0); INSERT INTO `attempts` VALUES (57, '2005-07-22 13:03:36', 'Snake', 'Theko', 56000, 0); INSERT INTO `attempts` VALUES (56, '2005-07-21 17:37:53', 'Theko', 'T-Rob', 4000, 1); INSERT INTO `attempts` VALUES (55, '2005-07-21 17:37:12', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (54, '2005-07-21 17:36:20', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (53, '2005-07-21 17:35:40', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (52, '2005-07-21 17:34:47', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (51, '2005-07-21 17:34:22', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (50, '2005-07-21 17:33:12', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (49, '2005-07-21 17:32:19', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (48, '2005-07-21 17:31:40', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (47, '2005-07-21 17:31:09', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (46, '2005-07-21 17:30:18', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (45, '2005-07-21 17:29:44', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (44, '2005-07-21 17:29:15', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (43, '2005-07-21 17:28:31', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (42, '2005-07-21 17:28:01', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (41, '2005-07-21 17:27:38', 'Theko', 'T-Rob', 4000, 0); INSERT INTO `attempts` VALUES (40, '2005-07-21 17:26:40', 'Theko', 'T-Rob', 2000, 0); INSERT INTO `attempts` VALUES (39, '2005-07-21 17:26:06', 'Theko', 'T-Rob', 2000, 0); INSERT INTO `attempts` VALUES (38, '2005-07-21 17:25:34', 'Theko', 'T-Rob', 1000, 0); INSERT INTO `attempts` VALUES (67, '2005-07-22 15:14:40', 'Polsie', 'Snake', 14821, 0); INSERT INTO `attempts` VALUES (68, '2005-07-22 15:14:50', 'Polsie', 'Snake', 14821, 0); INSERT INTO `attempts` VALUES (69, '2005-07-22 15:15:02', 'Polsie', 'Snake', 14821, 0); INSERT INTO `attempts` VALUES (70, '2005-07-22 15:15:10', 'Polsie', 'Snake', 14821, 0); INSERT INTO `attempts` VALUES (71, '2005-07-22 15:15:17', 'Polsie', 'Snake', 14821, 0); INSERT INTO `attempts` VALUES (72, '2005-07-22 15:15:20', 'Polsie', 'Snake', 14000, 0); INSERT INTO `attempts` VALUES (73, '2005-07-22 15:15:25', 'Polsie', 'Snake', 14821, 0); INSERT INTO `attempts` VALUES (74, '2005-07-22 15:15:28', 'Polsie', 'Snake', 14000, 0); INSERT INTO `attempts` VALUES (75, '2005-07-22 15:15:30', 'Polsie', 'Snake', 14821, 1); INSERT INTO `attempts` VALUES (76, '2005-07-22 17:10:57', 'ZeRoDeaD', 'Prince - MODKILL', 1, 1); INSERT INTO `attempts` VALUES (77, '2005-07-22 17:17:22', '5litre', 'TestAccount - MODKILL', 1, 1); INSERT INTO `attempts` VALUES (78, '2005-07-22 19:13:44', 'ant9002', 'joshboy29', 10000, 0); INSERT INTO `attempts` VALUES (79, '2005-07-22 19:13:52', 'ant9002', 'joshboy29', 9000, 0); INSERT INTO `attempts` VALUES (80, '2005-07-22 19:14:32', 'ant9002', 'joshboy29', 123, 0); INSERT INTO `attempts` VALUES (81, '2005-07-22 19:15:51', 'ZeRoDeaD', 'Staffcantkillmem - MODKILL', 1, 1); INSERT INTO `attempts` VALUES (82, '2005-07-22 19:38:21', 'Polsie', 'poosniffer', 940, 0); INSERT INTO `attempts` VALUES (83, '2005-07-22 20:00:46', 'ant9002', 'joshboy29', 3000, 0); INSERT INTO `attempts` VALUES (84, '2005-07-22 20:01:03', 'ant9002', 'joshboy29', 30, 0); INSERT INTO `attempts` VALUES (85, '2005-07-22 21:02:34', 'ant9002', 'joshboy29', 4000, 1); INSERT INTO `attempts` VALUES (86, '2005-07-23 04:00:03', 'recon', 'EverWorld', 25000, 0); INSERT INTO `attempts` VALUES (87, '2005-07-23 04:00:15', 'recon', 'EverWorld', 25000, 0); INSERT INTO `attempts` VALUES (88, '2005-07-23 04:00:31', 'recon', 'EverWorld', 50000, 1); INSERT INTO `attempts` VALUES (94, '2005-07-23 13:28:56', '5litre', 'TestAccount - MODKILL', 1, 1); INSERT INTO `attempts` VALUES (95, '2005-07-23 14:31:37', 'Henderson', 'Dirk', 15000, 1); INSERT INTO `attempts` VALUES (93, '2005-07-23 10:00:44', 'ZeRoDeaD', 'Test - MODKILL', 1, 1); INSERT INTO `attempts` VALUES (96, '2005-07-23 14:33:17', 'Polsie', 'recon - MODKILL', 1, 1); INSERT INTO `attempts` VALUES (97, '2005-07-23 17:49:10', 'ant9002', 'MiniPlato', 2000, 1); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `berichtenbalk` -- CREATE TABLE `berichtenbalk` ( `id` int(11) NOT NULL auto_increment, `naam` varchar(50) NOT NULL default '', `bericht` varchar(225) NOT NULL default '', `ip` text NOT NULL, `time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=19 ; -- -- Gegevens worden uitgevoerd voor tabel `berichtenbalk` -- INSERT INTO `berichtenbalk` VALUES (16, '5litre', 'The game got resetted because of a database error', '81.59.98.21', '2005-07-16 22:16:35'); INSERT INTO `berichtenbalk` VALUES (17, 'Dionisus', 'Tonight I''m going away for 2 weeks, on vacation. In that time a friend will watch my account', '24.132.91.150', '2005-07-18 22:22:13'); INSERT INTO `berichtenbalk` VALUES (18, '5litre', 'We have a new host :) Enjoy', '81.59.105.177', '2005-07-19 13:15:21'); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `crewreplys` -- CREATE TABLE `crewreplys` ( `datum` datetime NOT NULL default '0000-00-00 00:00:00', `titel` varchar(255) NOT NULL default '', `text` text NOT NULL, `schrijver` varchar(255) NOT NULL default '', `forum` int(255) NOT NULL default '1', `id` int(255) NOT NULL auto_increment, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=407 ; -- -- Gegevens worden uitgevoerd voor tabel `crewreplys` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `crewtopics` -- CREATE TABLE `crewtopics` ( `titel` varchar(255) NOT NULL default '', `datum` datetime NOT NULL default '0000-00-00 00:00:00', `forum` int(255) NOT NULL default '1', `text` text NOT NULL, `poster` varchar(255) NOT NULL default '', `id` int(255) NOT NULL auto_increment, `last` datetime NOT NULL default '0000-00-00 00:00:00', `type` int(1) NOT NULL default '0', `locked` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=188 ; -- -- Gegevens worden uitgevoerd voor tabel `crewtopics` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `extra-[omnilog]` -- CREATE TABLE `extra-[omnilog]` ( `time` datetime default NULL, `login` varchar(16) default NULL, `IP` varchar(32) default NULL, `forwardedFor` varchar(32) default NULL, `file` varchar(64) default NULL, `$_POST` text, `$_GET` text ) TYPE=MyISAM; -- -- Gegevens worden uitgevoerd voor tabel `extra-[omnilog]` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `forummess` -- CREATE TABLE `forummess` ( `datum` datetime NOT NULL default '0000-00-00 00:00:00', `titel` varchar(255) NOT NULL default '', `text` text NOT NULL, `schrijver` varchar(255) NOT NULL default '', `forum` int(255) NOT NULL default '1', `id` int(255) NOT NULL auto_increment, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2293 ; -- -- Gegevens worden uitgevoerd voor tabel `forummess` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `hitlist` -- CREATE TABLE `hitlist` ( `id` int(255) NOT NULL auto_increment, `naam` varchar(255) NOT NULL default '', `Reason` text NOT NULL, `prijs` int(50) NOT NULL default '0', `plaatser` varchar(255) NOT NULL default 'Anonymus', `date` datetime NOT NULL default '0000-00-00 00:00:00', `echt` varchar(225) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; -- -- Gegevens worden uitgevoerd voor tabel `hitlist` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `nieuws1` -- CREATE TABLE `nieuws1` ( `id` int(9) NOT NULL auto_increment, `naam` varchar(32) NOT NULL default '', `datum` datetime default '0000-00-00 00:00:00', `IP` varchar(32) NOT NULL default '', `subject` varchar(50) NOT NULL default '', `bericht` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=13 ; -- -- Gegevens worden uitgevoerd voor tabel `nieuws1` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `playermess` -- CREATE TABLE `playermess` ( `titel` varchar(255) NOT NULL default '', `datum` datetime NOT NULL default '0000-00-00 00:00:00', `forum` int(255) NOT NULL default '1', `text` text NOT NULL, `poster` varchar(255) NOT NULL default '', `id` int(255) NOT NULL auto_increment, `last` datetime NOT NULL default '0000-00-00 00:00:00', `type` int(1) NOT NULL default '0', `locked` int(1) NOT NULL default '0', `protected` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=504 ; -- -- Gegevens worden uitgevoerd voor tabel `playermess` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `poll` -- CREATE TABLE `poll` ( `id` int(11) NOT NULL auto_increment, `vraag` varchar(200) NOT NULL default '', `actief` int(1) NOT NULL default '0', `datum` int(20) NOT NULL default '0', `keuze1` varchar(50) NOT NULL default '', `keuze2` varchar(50) NOT NULL default '', `keuze3` varchar(50) NOT NULL default '', `keuze4` varchar(50) NOT NULL default '', `keuze5` varchar(50) NOT NULL default '', `keuze6` varchar(50) NOT NULL default '', `keuze7` varchar(50) NOT NULL default '', `keuze8` varchar(50) NOT NULL default '', `keuze9` varchar(50) NOT NULL default '', `keuze10` varchar(50) NOT NULL default '', `antwoord1` int(11) NOT NULL default '0', `antwoord2` int(11) NOT NULL default '0', `antwoord3` int(11) NOT NULL default '0', `antwoord4` int(11) NOT NULL default '0', `antwoord5` int(11) NOT NULL default '0', `antwoord6` int(11) NOT NULL default '0', `antwoord7` int(11) NOT NULL default '0', `antwoord8` int(11) NOT NULL default '0', `antwoord9` int(11) NOT NULL default '0', `antwoord10` int(11) NOT NULL default '0', `gestemd` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; -- -- Gegevens worden uitgevoerd voor tabel `poll` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `rechtbankusers` -- CREATE TABLE `rechtbankusers` ( `id` int(4) NOT NULL auto_increment, `login` varchar(16) default NULL, `straf` varchar(255) NOT NULL default '', `reden` text NOT NULL, `ip` varchar(32) default NULL, `time` datetime NOT NULL default '0000-00-00 00:00:00', `admin` varchar(225) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `login` (`login`) ) TYPE=MyISAM AUTO_INCREMENT=8 ; -- -- Gegevens worden uitgevoerd voor tabel `rechtbankusers` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `scripts` -- CREATE TABLE `scripts` ( `id` int(50) NOT NULL auto_increment, `title` varchar(225) NOT NULL default '', `bcode` text, `hcode` text, `cat` varchar(225) NOT NULL default '', `show` int(225) NOT NULL default '0', `bodytag` varchar(150) NOT NULL default '<body>', `wholescript` int(1) NOT NULL default '0', `hexample` text NOT NULL, `bexample` text NOT NULL, `discription` text NOT NULL, UNIQUE KEY `id` (`id`,`title`) ) TYPE=MyISAM COMMENT='?Elite Avengers' AUTO_INCREMENT=2 ; -- -- Gegevens worden uitgevoerd voor tabel `scripts` -- INSERT INTO `scripts` VALUES (1, 'Test', '<?php \r\n\r\nob_start(); \r\nsession_start(); \r\n\r\n@mysql_connect("localhost", "username", "password"); \r\n@mysql_select_db("database"); \r\n\r\n echo "<link rel=''stylesheet'' type=''text/css'' href=''style.css''>"; \r\n\r\n// Stats ////////////////////// \r\n$datum = mktime(0,0,0,date("n"),date("j"),date("Y")); \r\n$maand = date("n"); \r\n$jaar = date("Y"); \r\n$ip = $_SERVER[''REMOTE_ADDR'']; \r\n\r\n// Nieuw dag = nieuw unieke hits \r\n@mysql_query("DELETE FROM stats WHERE type=''3'' AND datum !=''".$datum."''"); \r\n\r\n// Totalen, totaal: uniek en hits \r\n$een = mysql_num_rows(mysql_query("SELECT * FROM stats WHERE type=''1''")); \r\nif($een == 0){ @mysql_query("INSERT INTO stats (type,uniek,hits,datum) VALUES (''1'',''0'',''0'',''".$datum."'')"); } \r\n$sql = @mysql_query("SELECT * FROM stats WHERE type=''3'' AND ip=''".$ip."''"); \r\n$bezoek = mysql_num_rows($sql); \r\nif($bezoek == 0){ \r\n @mysql_query("UPDATE stats SET uniek=uniek+1, hits=hits+1 WHERE type=''1''"); \r\n @mysql_query("INSERT INTO stats (type,datum,ip) VALUES (''3'',''".$datum."'',''".$ip."'')"); \r\n} else { \r\n @mysql_query("UPDATE stats SET hits=hits+1 WHERE type=''1''"); \r\n} \r\n\r\n// Dagen \r\n$sql = @mysql_query("SELECT * FROM stats WHERE type=''2'' AND datum=''".$datum."''"); \r\n$num = mysql_num_rows($sql); \r\nif(@$num == 0){ \r\n @mysql_query("INSERT INTO stats (type,hits,uniek,datum,maand,jaar) VALUES (''2'',''1'',''1'',''".$datum."'',''".$maand."'',''".$jaar."'')"); \r\n} else { \r\n if($bezoek == 0) { \r\n @mysql_query("UPDATE stats SET hits=hits+1, uniek=uniek+1 WHERE type=''2'' AND datum=''".$datum."''"); \r\n } else { \r\n @mysql_query("UPDATE stats SET hits=hits+1 WHERE type=''2'' AND datum=''".$datum."''"); \r\n } \r\n} \r\n\r\n// verbannen script \r\n\r\n$query = mysql_query("SELECT * FROM leden WHERE ip=''".$_SERVER[''REMOTE_ADDR'']."'' AND status=''0''"); \r\n$aantalb = mysql_num_rows($query); \r\n\r\nif($aantalb == TRUE){ \r\n\r\n echo "<br><br><br><center><table width=''75%'' cellpadding=''10'' bgcolor=''#F8F8F8'' border=''0'' style=''border: 1px solid #CCCCCC;''> \r\n <tr> \r\n <td align=''center''><font size=''6'' color=''#FF0000''><b>Verbannen</b></font><br><br> \r\n Door onbekende redenen bent u verbannen van PCexperience!<br> \r\n Voor info kunt u mailen naar [email protected]</td> \r\n </tr> \r\n </table></center>"; \r\n\r\n exit(); \r\n\r\n} \r\n\r\nif(isset($_COOKIE[''id''])){ \r\n\r\n$query = mysql_query("SELECT * FROM leden WHERE id=''".$_COOKIE[''id'']."'' AND status=''0''"); \r\n$aantal = mysql_num_rows($query); \r\n\r\nif($aantal == TRUE){ \r\n\r\n echo "<br><br><br><center><table width=''75%'' cellpadding=''10'' bgcolor=''#F8F8F8'' border=''0'' style=''border: 1px solid #CCCCCC;''> \r\n <tr> \r\n <td align=''center''><font size=''6'' color=''#FF0000''><b>Verbannen</b></font><br><br> \r\n Door onbekende redenen bent u verbannen van PCexperience!<br> \r\n Voor info kunt u mailen naar [email protected]</td> \r\n </tr> \r\n </table></center>"; \r\n\r\n exit(); \r\n\r\n} \r\n\r\n} \r\n\r\n// online script \r\n\r\n$time = time()-180; \r\n$oquery = mysql_query("SELECT * FROM online WHERE tijdstempel < $time"); \r\nwhile($orow = mysql_fetch_assoc($oquery)){ \r\n\r\n mysql_query("DELETE FROM online WHERE id=''".$orow[''id'']."''"); \r\n\r\n} \r\n\r\nif(isset($_COOKIE[''id'']) AND !empty($_COOKIE[''id''])){ \r\n\r\n $oquery = mysql_query("SELECT * FROM online WHERE wie=''".$_COOKIE[''id'']."''"); \r\n $oaantal = mysql_num_rows($oquery); \r\n\r\n if($oaantal == TRUE){ \r\n\r\n mysql_query("UPDATE online SET waar=''".$_SERVER["HTTP_X_REWRITE_URL"]."'', tijdstempel=''".time()."'' WHERE wie=''".$_COOKIE[''id'']."''"); \r\n\r\n } else { \r\n\r\n mysql_query("INSERT INTO online (wie, waar, tijd, tijdstempel) VALUES (''".$_COOKIE[''id'']."'', ''".$_SERVER["HTTP_X_REWRITE_URL"]."'', ''".date("H:i:s")."'', ''".time()."'')"); \r\n\r\n } \r\n\r\n} else { \r\n\r\n $oquery = mysql_query("SELECT * FROM online WHERE ip=''".$_SERVER[''REMOTE_ADDR'']."''"); \r\n $oaantal = mysql_num_rows($oquery); \r\n\r\n if($oaantal == TRUE){ \r\n\r\n mysql_query("UPDATE online SET waar=''".$_SERVER["HTTP_X_REWRITE_URL"]."'', tijdstempel=''".time()."'' WHERE ip=''".$_SERVER[''REMOTE_ADDR'']."''"); \r\n\r\n } else { \r\n\r\n mysql_query("INSERT INTO online (wie, waar, tijd, tijdstempel, ip) VALUES (''Gast'', ''".$_SERVER["HTTP_X_REWRITE_URL"]."'', ''".date("H:i:s")."'', ''".time()."'', ''".$_SERVER[''REMOTE_ADDR'']."'')"); \r\n\r\n } \r\n\r\n} \r\n\r\n// \r\n\r\nfunction begintabel($titel){ \r\n\r\n global $root; \r\n \r\n echo "<table width=''100%'' cellpadding=''5'' cellspacing=''0'' border=''0'' style=''border: 1px solid #729820;''> \r\n <tr> \r\n <td width=''100%'' background=''images/index_table_bg_picture.jpg'' style=''border-bottom: 1px solid #729820;''><b>".$titel."</b></td> \r\n </tr> \r\n <tr> \r\n <td width=''100%''>"; \r\n \r\n} \r\n\r\nfunction eindetabel(){ \r\n \r\n echo "</td> \r\n </tr> \r\n </table>"; \r\n\r\n} \r\n\r\nfunction ingelogd(){ \r\n\r\n if(!empty($_COOKIE[''id'']) AND !empty($_COOKIE[''wachtwoord'']) AND !empty($_COOKIE[''hash''])){ \r\n\r\n $query = @mysql_query("SELECT * FROM leden WHERE id=''".$_COOKIE[''id'']."'' AND wachtwoord=''".$_COOKIE[''wachtwoord'']."'' AND hash=''".$_COOKIE[''hash'']."''"); \r\n\r\n $aantal = mysql_num_rows($query); \r\n\r\n } else { \r\n\r\n $aantal = 0; \r\n\r\n } \r\n\r\n return $aantal; \r\n\r\n} \r\n\r\nfunction getgebruikersnaam($userid){ \r\n\r\n $query = @mysql_query("SELECT * FROM leden WHERE id=''".$userid."''"); \r\n $row = @mysql_fetch_assoc($query); \r\n\r\n return $row[''gebruikersnaam'']; \r\n\r\n} \r\n\r\nfunction functie(){ \r\n\r\n $functie = 0; \r\n\r\n if(isset($_COOKIE[''id''])){ \r\n\r\n $query = @mysql_query("SELECT * FROM leden WHERE id=''".$_COOKIE[''id'']."''"); \r\n $row = @mysql_fetch_assoc($query); \r\n\r\n $functie = $row[''status'']; \r\n\r\n } \r\n\r\nreturn $functie; \r\n\r\n} \r\n\r\nfunction remote_file_exists($url){ \r\n\r\n $head = ""; \r\n $url_p = parse_url ($url); \r\n \r\n if (isset ($url_p["host"])) \r\n { $host = $url_p["host"]; } \r\n else \r\n { return 1; } \r\n \r\n if (isset ($url_p["path"])) \r\n { $path = $url_p["path"]; } \r\n else \r\n { $path = ""; } \r\n \r\n $fp = fsockopen ($host, 80, $errno, $errstr, 20); \r\n if (!$fp) \r\n { return 2; } \r\n else \r\n { \r\n $parse = parse_url($url); \r\n $host = $parse[''host'']; \r\n \r\n fputs($fp, "HEAD ".$url." HTTP/1.1rn"); \r\n fputs($fp, "HOST: ".$host."rn"); \r\n fputs($fp, "Connection: closernrn"); \r\n $headers = ""; \r\n while (!feof ($fp)) \r\n { $headers .= fgets ($fp, 128); } \r\n } \r\n fclose ($fp); \r\n $arr_headers = explode("n", $headers); \r\n $return = false; \r\n if (isset ($arr_headers[0])) \r\n { $return = strpos ($arr_headers[0], "404") === false; } \r\n return $return; \r\n} \r\n\r\n//////////// \r\n\r\nfunction phphighlite($code) { \r\n \r\n $code = str_replace("[**code]", "[phptag]", $code); \r\n $code = str_replace("[/*****code]", "[/phptag]", $code); \r\n\r\n if (floor(phpversion())<4) { \r\n $return = $code; \r\n } else { \r\n\r\n $code = str_replace("<br>", "", $code); \r\n $code = str_replace("<br />", "", $code); \r\n $code = str_replace(">", ">", $code); \r\n $code = str_replace("<", "<", $code); \r\n $code = str_replace("&", "&", $code); \r\n $code = str_replace(''$'', ''$'', $code); \r\n $code = str_replace(''n'', ''\\\\n'', $code); \r\n $code = str_replace(''r'', ''\\\\r'', $code); \r\n $code = str_replace(''t'', ''\\\\t'', $code); \r\n $code = str_replace(''"'', ''"'', $code); \r\n\r\n $code = stripslashes($code); \r\n $code = trim($code); \r\n $code = str_replace("", "", $code); \r\n $regels = explode("n", $code); \r\n $aantal = count($regels) + 1; \r\n\r\n ob_start(); \r\n $oldlevel=error_reporting(0); \r\n highlight_string($code); \r\n error_reporting($oldlevel); \r\n $code = ob_get_contents(); \r\n ob_end_clean(); \r\n\r\n $return = ""; \r\n $return .= "<table cellspacing="0" cellpadding="3" border="0" width="100%" bgcolor="#D6D6D6">n"; \r\n $return .= "<tr>n"; \r\n $return .= "<td valign="middle"><b>Code</b></td>n"; \r\n $return .= "</tr>n"; \r\n $return .= "</table>n"; \r\n\r\n $return .= "<!-- code table -->n"; \r\n $return .= "<table cellspacing="0" cellpadding="0" border="0" width="100%">n"; \r\n $return .= "<tr>n"; \r\n $return .= "<td>n"; \r\n $return .= "<table cellspacing="0" cellpadding="3" border="0" width="100%" bgcolor="#D6D6D6" style="border-left: 1px solid #D6D6D6; border-right: 1px solid #D6D6D6; border-bottom: 1px solid #D6D6D6;">n"; \r\n $return .= "<tr>n"; \r\n $return .= "<td width="1" valign="top" align="left">n"; \r\n for($i = "1"; $i < $aantal; $i++) \r\n { \r\n $return .= $i."<br />"; \r\n } \r\n $return .= "</td>n"; \r\n $return .= "<td valign="top" bgcolor="#FFFFFF">n"; \r\n $return .= "<table cellspacing="0" cellpadding="0" border="0" width="100%" style="table-layout: fixed;">n"; \r\n $return .= "<tr>n"; \r\n $return .= "<td nowrap valign=''top''>n"; \r\n $return .= "n"; \r\n $return .= "".$code."n"; \r\n $return .= "n"; \r\n $return .= "</td>n"; \r\n $return .= "</tr>n"; \r\n $return .= "</table>n"; \r\n $return .= "</td></tr></table>n"; \r\n $return .= "</td></tr></table><br />n"; \r\n\r\n $return = str_replace(""", """, $return); \r\n } \r\n\r\n return $return; \r\n} \r\n\r\nfunction italic($code) { \r\n$code = "<i>".$code."</i>"; \r\n$code = trim($code); \r\nreturn $code; \r\n} \r\nfunction bold($code) { \r\n$code = "<b>".$code."</b>"; \r\n$code = trim($code); \r\nreturn $code; \r\n} \r\nfunction underlined($code) { \r\n$code = "<u>".$code."</u>"; \r\n$code = trim($code); \r\nreturn $code; \r\n} \r\nfunction s($code) { \r\n$code = "<s>".$code."</s>"; \r\n$code = trim($code); \r\nreturn $code; \r\n} \r\nfunction google($input){ \r\n$input = trim($input); \r\n$output = "| <a href=''http://www.google.nl/search?hl=nl&q=".$input."&lr='' target=''_blank''><b><font color=''#0066FF''>G</font><font color=''#FF0000''>o</font><font color=''#FFCC00''>o</font><font color=''#0066FF''>g</font><font color=''#339900''>l</font><font color=''#FF0000''>e</font> zoeken</b>: ".$input."</a> |"; \r\nreturn $output; \r\n} \r\n\r\nfunction ubb($bericht) { \r\n$kleur1 = "#EAF0FA"; \r\n$kleur2 = "#F7F7F7"; \r\n$borderkleur = "#D3D3D3"; \r\n $bericht = htmlspecialchars($bericht); \r\n $bericht = stripslashes($bericht); \r\n $bericht = nl2br($bericht); \r\n $bericht = preg_replace(''_[***c****ode](.*?)[*****/c****ode]_ise'', "phphighlite('' \\1 '')", $bericht); \r\n $bericht = str_replace("[center]", "<center>", $bericht); \r\n $bericht = str_replace("[/center]", "</center>", $bericht); \r\n $bericht = str_replace("[small]", "<small>", $bericht); \r\n $bericht = str_replace("[/small]", "</small>", $bericht); \r\n $bericht = str_replace("[quote]", "<small>Quote:</small><br><hr><i>", $bericht); \r\n $bericht = str_replace("[/quote]", "</i><hr>", $bericht); \r\n $bericht = str_replace("[phptable]", "<table width="100%" bgcolor="$kleur2" style="BORDER-RIGHT: $borderkleur 2px solid; BORDER-TOP: $borderkleur 1px solid; BORDER-BOTTOM: $borderkleur 2px solid; BORDER-LEFT: $borderkleur 1px solid" cellspacing="0" cellpadding="1"><tr><td>", $bericht); \r\n $bericht = str_replace("[/phptable]", "</td></tr></table>", $bericht); \r\n $bericht = str_replace("[table]", "<table>", $bericht); \r\n $bericht = str_replace("[/table]", "</table>", $bericht); \r\n $bericht = str_replace("[tr]", "<tr>", $bericht); \r\n $bericht = str_replace("[/tr]", "</tr>", $bericht); \r\n $bericht = str_replace("[td]", "<td>", $bericht); \r\n $bericht = str_replace("[/td]", "</td>", $bericht); \r\n $bericht = str_replace("[ul]", "<ul>", $bericht); \r\n $bericht = str_replace("[/ul]", "</ul>", $bericht); \r\n $bericht = str_replace("[li]", "<li>", $bericht); \r\n $bericht = str_replace("[/li]", "</li>", $bericht); \r\n //$bericht = eregi_replace("http://[^[:space:]]+","<a href="\\0" target="_blank">\\0</a>",$bericht); \r\n $bericht = eregi_replace("([a-zA-Z0-9_-]+)@([a-zA-Z0-9._-]+)(.[a-zA-Z]+)", "<a href="mailto:1@23">\\1@\\2\\3</a>", $bericht); \r\n $bericht = preg_replace(''_[s](.*?)[/s]_ise'', "s('' \\1 '')", $bericht); \r\n $bericht = preg_replace(''_[i](.*?)[/i]_ise'', "italic('' \\1 '')", $bericht); \r\n $bericht = preg_replace(''_[b](.*?)[/b]_ise'', "bold('' \\1 '')", $bericht); \r\n $bericht = preg_replace(''_[u](.*?)[/u]_ise'', "underlined('' \\1 '')", $bericht); \r\n $bericht = str_replace("[img]","<img src="http://",$bericht); \r\n $bericht = str_replace("[/img]","" border=''0''>",$bericht); \r\n $bericht = eregi_replace("[url]www.([^[]*)","<a href="http://www.\\1" target=_blank>1", $bericht); \r\n $bericht = eregi_replace("[url]([^[]*)","<a href="\\1" target=_blank>1", $bericht); \r\n $bericht = eregi_replace("([url=)([A-Za-z0-9_~&=;?:%@#./-]+[A-Za-z0-9/])(])", "<a href="http://\\2" target=_blank>", $bericht); \r\n $bericht = eregi_replace("[url](http://(.*))", "<a href="1" target="_blank">\\1", $bericht); \r\n $bericht = eregi_replace("([/url])", "</a>", $bericht); \r\n $bericht = str_replace("http://http://", "http://", $bericht); \r\n\r\n $bericht = preg_replace(''_[google](.*?)[/google]_ise'', "google('' \\1 '')", $bericht); \r\n\r\n $bericht = str_replace(":angry:","<img src=''smileys/angry.gif''>", $bericht); \r\n $bericht = str_replace(":biggrin:","<img src=''smileys/biggrin.gif''>", $bericht); \r\n $bericht = str_replace(":blink:","<img src=''smileys/blink.gif''>", $bericht); \r\n $bericht = str_replace(":cool:","<img src=''smileys/cool.gif''>", $bericht); \r\n $bericht = str_replace(":dry:","<img src=''smileys/dry.gif''>", $bericht); \r\n $bericht = str_replace(":happy:","<img src=''smileys/happy.gif''>", $bericht); \r\n $bericht = str_replace(":huh:","<img src=''smileys/huh.gif''>", $bericht); \r\n $bericht = str_replace(":laugh:","<img src=''smileys/laugh.gif''>", $bericht); \r\n $bericht = str_replace(":mellow:","<img src=''smileys/mellow.gif''>", $bericht); \r\n $bericht = str_replace(":ninja:","<img src=''smileys/ninja.gif''>", $bericht); \r\n $bericht = str_replace(":ohmy:","<img src=''smileys/ohmy.gif''>", $bericht); \r\n $bericht = str_replace(":rolleyes:","<img src=''smileys/rolleyes.gif''>", $bericht); \r\n $bericht = str_replace(":sad:","<img src=''smileys/sad.gif''>", $bericht); \r\n $bericht = str_replace(":sleep:","<img src=''smileys/sleep.gif''>", $bericht); \r\n $bericht = str_replace(":smile:","<img src=''smileys/smile.gif''>", $bericht); \r\n $bericht = str_replace(":tongue:","<img src=''smileys/tongue.gif''>", $bericht); \r\n $bericht = str_replace(":unsure:","<img src=''smileys/unsure.gif''>", $bericht); \r\n $bericht = str_replace(":wacko:","<img src=''smileys/wacko.gif''>", $bericht); \r\n $bericht = str_replace(":wink:","<img src=''smileys/wink.gif''>", $bericht); \r\n\r\nreturn $bericht; \r\n} \r\n\r\nfunction userinfo($userid){ \r\n\r\n $query = mysql_query("SELECT * FROM leden WHERE id=''".$userid."''"); \r\n $row = mysql_fetch_assoc($query); \r\n\r\n $query = mysql_query("SELECT * FROM online WHERE wie=''".$userid."''"); \r\n $aantal = mysql_num_rows($query); \r\n\r\n if(ingelogd() == TRUE){ \r\n\r\n $query = mysql_query("SELECT * FROM leden WHERE id=''".$_COOKIE[''id'']."''"); \r\n $my = mysql_fetch_assoc($query); \r\n\r\n } else { \r\n\r\n $my[''showava''] = 0; \r\n\r\n } \r\n\r\n if($aantal == TRUE){ \r\n\r\n $online = "<font color=''#009900''>Online</font>"; \r\n\r\n } else { \r\n\r\n $online = "<font color=''#FF0000''>Offline</font>"; \r\n\r\n } \r\n\r\n $status = $row[''status'']; \r\n $status = str_replace("0", "<font color=''red''>Verbannen</font>", $status); \r\n $status = str_replace("1", "<font color=''green''>Lid</font>", $status); \r\n $status = str_replace("2", "<font color=''blue''>Moderator</font>", $status); \r\n $status = str_replace("3", "<font color=''blue''>Super Moderator</font>", $status); \r\n $status = str_replace("4", "<font color=''red''>Administrator</font>", $status); \r\n\r\n if($row[''posts''] == 1){ \r\n\r\n $posts = "1 post"; \r\n\r\n } else { \r\n\r\n $posts = $row[''posts'']." posts"; \r\n\r\n } \r\n\r\n if(!empty($row[''avatar''])){ \r\n\r\n $info = "<b><a href=''ledenlijst.php?actie=profiel&id=".$userid."''>".$row[''gebruikersnaam'']."</a></b><br>".$status."<br>"; \r\n\r\n if($my[''showava''] == TRUE){ \r\n\r\n $info.="<img src=''".$row[''avatar'']."''><br><br>".$online."<br>".$posts; \r\n\r\n } else { \r\n\r\n $info.="<br>".$online."<br>".$posts; \r\n\r\n } \r\n\r\n } else { \r\n\r\n $info = "<b><a href=''ledenlijst.php?actie=profiel&id=".$userid."''>".$row[''gebruikersnaam'']."</a></b><br>".$status."<br><hr>".$online."<br>".$posts; \r\n\r\n } \r\n\r\n return $info; \r\n\r\n} \r\n\r\nfunction gebruikersnaam($userid){ \r\n\r\n $query = mysql_query("SELECT * FROM leden WHERE id=''".$userid."''"); \r\n $aantal = mysql_num_rows($query); \r\n $row = mysql_fetch_assoc($query); \r\n\r\n if($aantal == FALSE){ \r\n\r\n $un = "Onbekend"; \r\n\r\n } else { \r\n\r\n $un = $row[''gebruikersnaam'']; \r\n\r\n } \r\n\r\nreturn $un; \r\n\r\n} \r\n\r\nfunction icon($form, $veld){ \r\n\r\n echo "<SCRIPT language=JavaScript> \r\n function icon(theicon) { \r\n document.".$form.".".$veld.".value += ""+theicon; \r\n document.".$form.".".$veld.".focus(); \r\n } \r\n </script>"; \r\n\r\n echo "<table bgcolor=''#F8F8F8'' width=''100%'' cellpadding=''4'' cellspacing=''0'' border=''0'' style=''border: 1px solid #CCCCCC;''> \r\n <tr> \r\n <td width=''100%''> \r\n \r\n <a href="javascript:icon('':angry:'')"><img src="smileys/angry.gif" border="0"></a> \r\n <a href="javascript:icon('':biggrin:'')"><img src="smileys/biggrin.gif" border="0"></a> \r\n <a href="javascript:icon('':blink:'')"><img src="smileys/blink.gif" border="0"></a> \r\n <a href="javascript:icon('':cool:'')"><img src="smileys/cool.gif" border="0"></a> \r\n <a href="javascript:icon('':dry:'')"><img src="smileys/dry.gif" border="0"></a> \r\n <a href="javascript:icon('':happy:'')"><img src="smileys/happy.gif" border="0"></a> \r\n <a href="javascript:icon('':huh:'')"><img src="smileys/huh.gif" border="0"></a> \r\n <a href="javascript:icon('':laugh:'')"><img src="smileys/laugh.gif" border="0"></a> \r\n <a href="javascript:icon('':mellow:'')"><img src="smileys/mellow.gif" border="0"></a> \r\n <a href="javascript:icon('':ninja:'')"><img src="smileys/ninja.gif" border="0"></a> \r\n <a href="javascript:icon('':ohmy:'')"><img src="smileys/ohmy.gif" border="0"></a> \r\n <a href="javascript:icon('':rolleyes:'')"><img src="smileys/rolleyes.gif" border="0"></a> \r\n <a href="javascript:icon('':sad:'')"><img src="smileys/sad.gif" border="0"></a> \r\n <a href="javascript:icon('':sleep:'')"><img src="smileys/sleep.gif" border="0"></a> \r\n <a href="javascript:icon('':smile:'')"><img src="smileys/smile.gif" border="0"></a> \r\n <a href="javascript:icon('':tongue:'')"><img src="smileys/tongue.gif" border="0"></a> \r\n <a href="javascript:icon('':unsure:'')"><img src="smileys/unsure.gif" border="0"></a> \r\n <a href="javascript:icon('':wacko:'')"><img src="smileys/wacko.gif" border="0"></a> \r\n <a href="javascript:icon('':wink:'')"><img src="smileys/wink.gif" border="0"></a> \r\n \r\n </td> \r\n </tr> \r\n <tr> \r\n <td width=''100%''> \r\n \r\n <input type="button" value="B" style="font-weight:bold; width: 30px" onClick="javascript:icon(''[b]hier je tekst[/b]'')"> \r\n <input type="button" value="i" style="font-style:italic; width: 30px" onClick="javascript:icon(''[i]hier je tekst[/i]'')"> \r\n <input type="button" value="u" style="text-decoration: underline; width: 30px" onClick="javascript:icon(''[u]hier je tekst[/u]'')"> \r\n <input type="button" value="ss" style="text-decoration: line-through; width: 30px" onClick="javascript:icon(''[s]hier je tekst[/s]'')"> \r\n <input type="button" value="Figuur" style="font-style:italic;" onClick="javascript:icon(''[img]hier de url[/img]'')"> \r\n <input type="button" value="Link" style="font-style:italic;" onClick="javascript:icon(''[url=hier de url]hier de linknaam[/url]'')"> \r\n <input type="button" value="Quote" onClick="javascript:icon(''[quote]hier je tekst[/quote]'')"> \r\n <input type="button" value="Code" onClick="javascript:icon(''[****code]hier je code[/***c****ode]'')"> \r\n <input type="button" value="Google" onClick="javascript:icon(''[google]hier je zoekterm[/google]'')"> \r\n \r\n </td> \r\n </tr> \r\n </table>"; \r\n\r\n \r\n\r\n} \r\n\r\nfunction choppen($input, $limiet){ \r\n\r\n$tekens = strlen($input); \r\n\r\nif($tekens > $limiet){ \r\n\r\n$input = substr($input, 0, $limiet); \r\n$input = $input."..."; \r\n\r\n} \r\n\r\n$output = $input; \r\n\r\nreturn $output; \r\n\r\n} \r\n\r\nfunction postsplus($user){ \r\n\r\n mysql_query("UPDATE leden SET posts=posts+1 WHERE id=''".$user."''"); \r\n\r\n} \r\n\r\nfunction postsminus($user){ \r\n\r\n mysql_query("UPDATE leden SET posts=posts-1 WHERE id=''".$user."''"); \r\n\r\n} \r\n\r\nfunction signature($userid){ \r\n\r\n if(ingelogd() == TRUE){ \r\n\r\n $query = mysql_query("SELECT * FROM leden WHERE id=''".$_COOKIE[''id'']."''"); \r\n $my = mysql_fetch_assoc($query); \r\n\r\n } else { \r\n\r\n $my[''showsig''] = 0; \r\n $my[''showava''] = 0; \r\n\r\n } \r\n\r\n $query = mysql_query("SELECT * FROM leden WHERE id=''".$userid."''"); \r\n $row = mysql_fetch_assoc($query); \r\n\r\n $sig = ""; \r\n\r\n if($my[''showsig''] == TRUE){ \r\n\r\n if(!empty($row[''signature''])){ \r\n\r\n $sig.="<hr>"; \r\n $sig.=ubb($row[''signature'']); \r\n\r\n } else { \r\n\r\n $sig = ""; \r\n\r\n } \r\n\r\n } \r\n\r\nreturn $sig; \r\n\r\n} \r\n\r\nfunction lekubb($bericht){ \r\n\r\n $bericht = htmlspecialchars($bericht); \r\n $bericht = stripslashes($bericht); \r\n $bericht = nl2br($bericht); \r\n\r\nreturn $bericht; \r\n\r\n} \r\n\r\n?> ', '', 'Test', 241, '<body>', 1, '', 'Help!', 'First!:P');Is een leuke source, was mijn hele eerste, maar is wel bagger beveiligd standaard
-
Je moet hem even goed tussen de tags zetten.
-
Angepast in de sql staat ook [ / c o d e ]
Heb er **** bijgeplaatst
Participate now!
Heb je nog geen account? Registreer je nu en word deel van onze community!