NeverSay

Looking for a scripter i can pay money please mssg me on skype the script i use are roleplay scripts i would like some debugging to be done an sme script so be add i can pay 75 Dollors an 65 Euros i think that how much lol But i would like for a speed mod where i can edit car speed an how fast they go i would like that to be save though the sql an alots more if the price is low i can pay more But there a huge list so please add me on skype or pm me here agame2821

Can someone help me set up a ucp for my server please i need help my skype name is Skype:agame2821 Please contact me asap

Hello everyone it NeverSay i need someone who can set up fourms like tonight i will pay good money like 20dollors if u can mssg me via Skype agame2821 Please hurry

If u can help me just send me a mssg on skype or on mta i need help with my UCP there a problem and i would like help with it please get back to me asap.

Hello im lookig for people who can do c++ an Php asap i will pay you 40dollors For doing the work thank you for helping me and i will be great full here my skype agame2821.

Please don't post here if you can't help this guy can't help me so that ok i still lookking for people there fo get at me i will pay u between 40-50 if u do the job right.

Still looking for people please talk to me he could not Finsh the job so please Add me on skype

Add me on Skype agame2821

Hello it me again im looking for people who know C++ And PHP i have something i would like to set up like a fourms and im looking for someone who can do so i do have domin so all i need is PHP Set up and that it thanks and get back to me ooo And i will pay u about 50 -40 Dollors Please Hurry

Hello everyone ATM Deadric Servers are Down sorry i did not post here before but should have asap they will be back up June 5 or Less then June 10 But most Likely June 5 Sorry please join server and we are happy to get any player we can We want your opintion so when server get up please tak a vote in game about something we are thinking about add to server and we want to know do people play even if ******** They have to apply but just vote ingame on June 7 and tell us what you think thanks and We Love everyone

Great Great Congrazt on vG Yea i truely don't give a fuck about what the fuck you think And just to let u know i had already fixed the problem like this topic is kind of done. Now im looking for people who know php and etc and i pay for that. Also i can run vG script you know why? Because i pay people to fix it for me i have a life and i can just pay alot of people the same way i payed my friend Orange to fix the Cylus script for me.

There you go when i put it in the database it says an Error please tell me if you neeed the error.

-- phpMyAdmin SQL Dump -- version 3.4.5 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Apr 29, 2012 at 04:04 AM -- Server version: 5.5.16 -- PHP Version: 5.3.8 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `rpserver` -- -- -------------------------------------------------------- -- -- Table structure for table `accounts` -- CREATE TABLE IF NOT EXISTS `accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` text, `password` text, `registerdate` datetime DEFAULT NULL, `lastlogin` datetime DEFAULT NULL, `ip` text, `admin` tinyint(3) unsigned DEFAULT '0', `hiddenadmin` tinyint(3) unsigned DEFAULT '0', `adminduty` tinyint(3) unsigned DEFAULT '0', `adminjail` tinyint(3) unsigned DEFAULT '0', `adminjail_time` int(11) DEFAULT NULL, `adminjail_by` text, `adminjail_reason` text, `banned` tinyint(3) unsigned DEFAULT '0', `banned_by` text, `banned_reason` text, `muted` tinyint(3) unsigned DEFAULT '0', `globalooc` tinyint(3) unsigned DEFAULT '1', `country` text, `friendsmessage` text, `adminjail_permanent` tinyint(3) unsigned DEFAULT '0', `adminreports` int(11) DEFAULT '0', `warns` tinyint(3) unsigned DEFAULT '0', `chatbubbles` tinyint(3) unsigned NOT NULL DEFAULT '1', `adminnote` text, `appstate` tinyint(1) DEFAULT '0', `appdatetime` datetime DEFAULT NULL, `appreason` longtext, `email` text, `help` int(1) NOT NULL DEFAULT '1', `adblocked` int(1) NOT NULL DEFAULT '0', `newsblocked` int(1) NOT NULL DEFAULT '0', `mtaserial` text, `d_addiction` text, `loginhash` varchar(64) DEFAULT NULL, `credits` int(11) NOT NULL DEFAULT '0', `transfers` int(11) DEFAULT '0', `monitored` varchar(255) NOT NULL DEFAULT 'New Player', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ; -- -- Dumping data for table `accounts` -- INSERT INTO `accounts` (`id`, `username`, `password`, `registerdate`, `lastlogin`, `ip`, `admin`, `hiddenadmin`, `adminduty`, `adminjail`, `adminjail_time`, `adminjail_by`, `adminjail_reason`, `banned`, `banned_by`, `banned_reason`, `muted`, `globalooc`, `country`, `friendsmessage`, `adminjail_permanent`, `adminreports`, `warns`, `chatbubbles`, `adminnote`, `appstate`, `appdatetime`, `appreason`, `email`, `help`, `adblocked`, `newsblocked`, `mtaserial`, `d_addiction`, `loginhash`, `credits`, `transfers`, `monitored`) VALUES (1, 'OverDrive', '1EE92F90C952D3D685D70427B135C32F', NULL, NULL, '192.168.1.2', 6, 0, 0, 0, NULL, NULL, NULL, 0, NULL, NULL, 0, 1, NULL, 'Sample Message', 0, 0, 0, 1, NULL, 3, NULL, NULL, NULL, 1, 0, 0, '37B935477D87EFDED627D4F489497644', NULL, 'Dy6klMCr9kVoFRW8tzI3TziqL1vjEoo2OL63u4DrIXoWbRJAGvT08f6i67iKQuA9', 0, 0, 'New Player'); -- -------------------------------------------------------- -- -- Table structure for table `adminhistory` -- CREATE TABLE IF NOT EXISTS `adminhistory` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user` int(10) unsigned NOT NULL, `user_char` text NOT NULL, `admin` int(10) unsigned NOT NULL, `admin_char` text NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `action` tinyint(3) unsigned NOT NULL, `duration` int(10) unsigned NOT NULL, `reason` text NOT NULL, `hiddenadmin` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `apb` -- CREATE TABLE IF NOT EXISTS `apb` ( `id` int(11) NOT NULL AUTO_INCREMENT, `description` text NOT NULL, `doneby` int(11) NOT NULL, `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `applications` -- CREATE TABLE IF NOT EXISTS `applications` ( `id` int(11) NOT NULL AUTO_INCREMENT, `accountID` int(11) NOT NULL, `dateposted` datetime NOT NULL, `content` text NOT NULL, `datereviewed` datetime DEFAULT NULL, `adminID` int(11) DEFAULT NULL, `adminNote` text, `adminAction` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `atms` -- CREATE TABLE IF NOT EXISTS `atms` ( `id` int(11) NOT NULL AUTO_INCREMENT, `x` decimal(10,6) DEFAULT '0.000000', `y` decimal(10,6) DEFAULT '0.000000', `z` decimal(10,6) DEFAULT '0.000000', `rotation` decimal(10,6) DEFAULT '0.000000', `dimension` int(5) DEFAULT '0', `interior` int(5) DEFAULT '0', `deposit` tinyint(3) unsigned DEFAULT '0', `limit` int(10) unsigned DEFAULT '5000', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ; -- -- Dumping data for table `atms` -- INSERT INTO `atms` (`id`, `x`, `y`, `z`, `rotation`, `dimension`, `interior`, `deposit`, `limit`) VALUES (1, 589.611328, -1253.958984, 17.800000, 21.000000, 0, 0, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `characters` -- CREATE TABLE IF NOT EXISTS `characters` ( `id` int(11) NOT NULL AUTO_INCREMENT, `charactername` text, `account` int(11) DEFAULT '0', `x` float DEFAULT '0', `y` float DEFAULT '0', `z` float DEFAULT '0', `rotation` float DEFAULT '0', `interior_id` int(5) DEFAULT '0', `dimension_id` int(5) DEFAULT '0', `health` float DEFAULT '100', `armor` float DEFAULT '0', `skin` int(3) DEFAULT '264', `money` bigint(20) DEFAULT '250', `gender` int(1) DEFAULT '0', `cuffed` int(11) DEFAULT '0', `duty` int(3) DEFAULT '0', `cellnumber` int(30) DEFAULT '0', `fightstyle` int(2) DEFAULT '4', `pdjail` int(1) DEFAULT '0', `pdjail_time` int(11) DEFAULT '0', `job` int(3) DEFAULT '0', `cked` int(1) DEFAULT '0', `lastarea` text, `age` int(3) DEFAULT '18', `faction_id` int(11) DEFAULT '-1', `faction_rank` int(2) DEFAULT '1', `faction_perks` text, `transport` int(1) DEFAULT '0', `skincolor` int(1) DEFAULT '0', `weight` int(3) DEFAULT '180', `height` int(3) DEFAULT '180', `description` text, `deaths` int(11) DEFAULT '0', `faction_leader` int(1) DEFAULT '0', `fingerprint` text, `casualskin` int(3) DEFAULT '0', `bankmoney` bigint(20) DEFAULT '500', `car_license` int(1) DEFAULT '0', `gun_license` int(1) DEFAULT '0', `tag` int(3) DEFAULT '1', `hoursplayed` int(11) DEFAULT '0', `pdjail_station` int(1) DEFAULT '0', `timeinserver` int(2) DEFAULT '0', `restrainedobj` int(11) DEFAULT '0', `restrainedby` int(11) DEFAULT '0', `dutyskin` int(3) DEFAULT '-1', `fish` int(10) unsigned NOT NULL DEFAULT '0', `truckingruns` int(10) unsigned NOT NULL DEFAULT '0', `truckingwage` int(10) unsigned NOT NULL DEFAULT '0', `phoneoff` tinyint(4) NOT NULL DEFAULT '0', `blindfold` tinyint(4) NOT NULL DEFAULT '0', `lang1` tinyint(2) DEFAULT '1', `lang1skill` tinyint(3) DEFAULT '100', `lang2` tinyint(2) DEFAULT '0', `lang2skill` tinyint(3) DEFAULT '0', `lang3` tinyint(2) DEFAULT '0', `lang3skill` tinyint(3) DEFAULT '0', `currlang` tinyint(1) DEFAULT '1', `lastlogin` datetime DEFAULT NULL, `creationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `election_candidate` tinyint(3) unsigned NOT NULL DEFAULT '0', `election_canvote` tinyint(3) unsigned NOT NULL DEFAULT '0', `election_votedfor` int(10) unsigned NOT NULL DEFAULT '0', `jobcontract` tinyint(3) unsigned NOT NULL DEFAULT '0', `marriedto` int(10) unsigned NOT NULL DEFAULT '0', `photos` int(10) unsigned NOT NULL DEFAULT '0', `maxvehicles` int(4) unsigned NOT NULL DEFAULT '5', `ck_info` text, `alcohollevel` float NOT NULL, `active` tinyint(1) NOT NULL DEFAULT '1', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ; -- -- Dumping data for table `characters` -- INSERT INTO `characters` (`id`, `charactername`, `account`, `x`, `y`, `z`, `rotation`, `interior_id`, `dimension_id`, `health`, `armor`, `skin`, `money`, `gender`, `cuffed`, `duty`, `cellnumber`, `fightstyle`, `pdjail`, `pdjail_time`, `job`, `cked`, `lastarea`, `age`, `faction_id`, `faction_rank`, `faction_perks`, `transport`, `skincolor`, `weight`, `height`, `description`, `deaths`, `faction_leader`, `fingerprint`, `casualskin`, `bankmoney`, `car_license`, `gun_license`, `tag`, `hoursplayed`, `pdjail_station`, `timeinserver`, `restrainedobj`, `restrainedby`, `dutyskin`, `fish`, `truckingruns`, `truckingwage`, `phoneoff`, `blindfold`, `lang1`, `lang1skill`, `lang2`, `lang2skill`, `lang3`, `lang3skill`, `currlang`, `lastlogin`, `creationdate`, `election_candidate`, `election_canvote`, `election_votedfor`, `jobcontract`, `marriedto`, `photos`, `maxvehicles`, `ck_info`, `alcohollevel`, `active`) VALUES (1, 'Rachel_Dawson', 1, 1342.99, -1697.49, 31.844, 337.211, 0, 0, 68.2353, 0, 93, 998925648, 1, 0, 0, 15001, 4, 0, 0, 0, 0, 'Commerce', 23, 125, 20, '[ [ 9, 15 ] ]', 0, 1, 63, 157, '__________________________________________________________________________\\n', 0, 1, 'F1E199764935A15FC9C9CB594FF7601E', 93, 0, 1, 0, 1, 2, 0, 61, 0, 0, -1, 0, 0, 0, 0, 0, 1, 100, 0, 0, 0, 0, 1, '2012-04-29 00:49:05', '2012-04-28 20:28:31', 0, 0, 0, 0, 0, 0, 5, NULL, 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `computers` -- CREATE TABLE IF NOT EXISTS `computers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `posX` float(10,5) NOT NULL, `posY` float(10,5) NOT NULL, `posZ` float(10,5) NOT NULL, `rotX` float(10,5) NOT NULL, `rotY` float(10,5) NOT NULL, `rotZ` float(10,5) NOT NULL, `interior` int( NOT NULL, `dimension` int( NOT NULL, `model` int( NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `dancers` -- CREATE TABLE IF NOT EXISTS `dancers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `x` float NOT NULL, `y` float NOT NULL, `z` float NOT NULL, `rotation` float NOT NULL, `skin` smallint(5) unsigned NOT NULL, `type` tinyint(3) unsigned NOT NULL, `interior` int(10) unsigned NOT NULL, `dimension` int(10) unsigned NOT NULL, `offset` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `donators` -- CREATE TABLE IF NOT EXISTS `donators` ( `id` int(11) NOT NULL AUTO_INCREMENT, `accountID` int(11) NOT NULL, `charID` int(11) NOT NULL DEFAULT '-1', `perkID` int(4) NOT NULL, `perkValue` varchar(10) NOT NULL DEFAULT '1', `expirationDate` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `don_transactions` -- CREATE TABLE IF NOT EXISTS `don_transactions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `transaction_id` varchar(64) NOT NULL, `donator_email` varchar(255) NOT NULL, `amount` double NOT NULL, `original_request` text, `dt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, `handled` smallint(1) DEFAULT '0', `username` varchar(50) NOT NULL, `realamount` double NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `don_transaction_failed` -- CREATE TABLE IF NOT EXISTS `don_transaction_failed` ( `id` int(11) NOT NULL AUTO_INCREMENT, `output` text NOT NULL, `ip` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `elevators` -- CREATE TABLE IF NOT EXISTS `elevators` ( `id` int(11) NOT NULL AUTO_INCREMENT, `x` decimal(10,6) DEFAULT '0.000000', `y` decimal(10,6) DEFAULT '0.000000', `z` decimal(10,6) DEFAULT '0.000000', `tpx` decimal(10,6) DEFAULT '0.000000', `tpy` decimal(10,6) DEFAULT '0.000000', `tpz` decimal(10,6) DEFAULT '0.000000', `dimensionwithin` int(5) DEFAULT '0', `interiorwithin` int(5) DEFAULT '0', `dimension` int(5) DEFAULT '0', `interior` int(5) DEFAULT '0', `car` tinyint(3) unsigned DEFAULT '0', `disabled` tinyint(3) unsigned DEFAULT '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `emailaccounts` -- CREATE TABLE IF NOT EXISTS `emailaccounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` text, `password` text, `creator` int(11) DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `emails` -- CREATE TABLE IF NOT EXISTS `emails` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` datetime NOT NULL, `sender` text, `receiver` text, `subject` text, `message` text, `inbox` int(1) NOT NULL DEFAULT '0', `outbox` int(1) NOT NULL DEFAULT '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `factions` -- CREATE TABLE IF NOT EXISTS `factions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text, `bankbalance` bigint(20) DEFAULT NULL, `type` int(11) DEFAULT NULL, `rank_1` text, `rank_2` text, `rank_3` text, `rank_4` text, `rank_5` text, `rank_6` text, `rank_7` text, `rank_8` text, `rank_9` text, `rank_10` text, `rank_11` text, `rank_12` text, `rank_13` text, `rank_14` text, `rank_15` text, `rank_16` text, `rank_17` text, `rank_18` text, `rank_19` text, `rank_20` text, `wage_1` int(11) DEFAULT '100', `wage_2` int(11) DEFAULT '100', `wage_3` int(11) DEFAULT '100', `wage_4` int(11) DEFAULT '100', `wage_5` int(11) DEFAULT '100', `wage_6` int(11) DEFAULT '100', `wage_7` int(11) DEFAULT '100', `wage_8` int(11) DEFAULT '100', `wage_9` int(11) DEFAULT '100', `wage_10` int(11) DEFAULT '100', `wage_11` int(11) DEFAULT '100', `wage_12` int(11) DEFAULT '100', `wage_13` int(11) DEFAULT '100', `wage_14` int(11) DEFAULT '100', `wage_15` int(11) DEFAULT '100', `wage_16` int(11) DEFAULT '100', `wage_17` int(11) DEFAULT '100', `wage_18` int(11) DEFAULT '100', `wage_19` int(11) DEFAULT '100', `wage_20` int(11) DEFAULT '100', `motd` text, `note` text, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=126 ; -- -- Dumping data for table `factions` -- INSERT INTO `factions` (`id`, `name`, `bankbalance`, `type`, `rank_1`, `rank_2`, `rank_3`, `rank_4`, `rank_5`, `rank_6`, `rank_7`, `rank_8`, `rank_9`, `rank_10`, `rank_11`, `rank_12`, `rank_13`, `rank_14`, `rank_15`, `rank_16`, `rank_17`, `rank_18`, `rank_19`, `rank_20`, `wage_1`, `wage_2`, `wage_3`, `wage_4`, `wage_5`, `wage_6`, `wage_7`, `wage_8`, `wage_9`, `wage_10`, `wage_11`, `wage_12`, `wage_13`, `wage_14`, `wage_15`, `wage_16`, `wage_17`, `wage_18`, `wage_19`, `wage_20`, `motd`, `note`) VALUES (1, 'Los Santos Police Department', 0, 2, 'Suspended / On Leave', 'Student', 'Cadet', 'PO I', 'PO II', 'PO III', 'Detective I', 'Detective II', 'Detective III', 'Detective Seargeant', 'Seargeant I', 'Seargeant II', 'Lieutenant', 'Captain', 'Commander', 'Deputy Chief of Police', 'Assistant Chief of Police', 'Chief of Police', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''), (2, 'Los Santos Medical Services', 0, 4, 'Dynamic Rank #1', 'Dynamic Rank #2', 'Dynamic Rank #3', 'Dynamic Rank #4', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''), (3, 'Government of Los Santos', 509, 3, 'Dynamic Rank #1', 'Dynamic Rank #2', 'Dynamic Rank #3', 'Dynamic Rank #4', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''), (4, 'Los Santos Fire Department', 0, 4, 'Dynamic Rank #1', 'Dynamic Rank #2', 'Dynamic Rank #3', 'Dynamic Rank #4', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''), (20, 'San Andreas Network', 0, 6, 'Dynamic Rank #1', 'Dynamic Rank #2', 'Dynamic Rank #3', 'Dynamic Rank #4', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''), (30, 'Hex Tow ''n Go', 0, 5, 'Dynamic Rank #1', 'Dynamic Rank #2', 'Dynamic Rank #3', 'Dynamic Rank #4', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''), (125, 'Uni-Tel', 0, 5, 'Suspended', 'On Leave', 'Trainee Warehouse Worker', 'Trainee Salesman', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'CEO', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', 'nub\n'); -- -------------------------------------------------------- -- -- Table structure for table `forgotdetails` -- CREATE TABLE IF NOT EXISTS `forgotdetails` ( `uniquekey` text, `account` int(11) DEFAULT '0', `keytimestamp` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `friends` -- CREATE TABLE IF NOT EXISTS `friends` ( `id` int(10) unsigned NOT NULL, `friend` int(10) unsigned NOT NULL, PRIMARY KEY (`id`,`friend`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `fuelpeds` -- CREATE TABLE IF NOT EXISTS `fuelpeds` ( `id` int(11) NOT NULL AUTO_INCREMENT, `posX` float NOT NULL, `posY` float NOT NULL, `posZ` float NOT NULL, `rotZ` float NOT NULL, `skin` int(3) NOT NULL, `priceratio` int(3) NOT NULL, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `fuelpeds` -- INSERT INTO `fuelpeds` (`id`, `posX`, `posY`, `posZ`, `rotZ`, `skin`, `priceratio`, `name`) VALUES (1, 1941.5, -1769.29, 13.6406, 91.5477, 50, 5, 'Chad_Ballocks'), (2, 1941.5, -1776.36, 13.6406, 92.8222, 50, 5, 'Robert_Edeworth'); -- -------------------------------------------------------- -- -- Table structure for table `fuelstations` -- CREATE TABLE IF NOT EXISTS `fuelstations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `x` decimal(10,6) DEFAULT '0.000000', `y` decimal(10,6) DEFAULT '0.000000', `z` decimal(10,6) DEFAULT '0.000000', `interior` int(5) DEFAULT '0', `dimension` int(5) DEFAULT '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `gates` -- CREATE TABLE IF NOT EXISTS `gates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `objectID` int(11) NOT NULL, `startX` float NOT NULL, `startY` float NOT NULL, `startZ` float NOT NULL, `startRX` float NOT NULL, `startRY` float NOT NULL, `startRZ` float NOT NULL, `endX` float NOT NULL, `endY` float NOT NULL, `endZ` float NOT NULL, `endRX` float NOT NULL, `endRY` float NOT NULL, `endRZ` float NOT NULL, `gateType` tinyint(3) unsigned NOT NULL, `autocloseTime` int(4) NOT NULL, `movementTime` int(4) NOT NULL, `objectDimension` int(11) NOT NULL, `objectInterior` int(11) NOT NULL, `gateSecurityParameters` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `interiors` -- CREATE TABLE IF NOT EXISTS `interiors` ( `id` int(11) NOT NULL AUTO_INCREMENT, `x` float DEFAULT '0', `y` float DEFAULT '0', `z` float DEFAULT '0', `type` int(1) DEFAULT '0', `owner` int(11) DEFAULT '-1', `locked` int(1) DEFAULT '0', `cost` int(11) DEFAULT '0', `name` text, `interior` int(5) DEFAULT '0', `interiorx` float DEFAULT '0', `interiory` float DEFAULT '0', `interiorz` float DEFAULT '0', `dimensionwithin` int(5) DEFAULT '0', `interiorwithin` int(5) DEFAULT '0', `angle` float DEFAULT '0', `angleexit` float DEFAULT '0', `max_items` int(5) DEFAULT '0', `rentable` int(1) DEFAULT '0', `rent` int(11) DEFAULT '0', `money` int(11) DEFAULT '0', `items` text, `items_values` text, `tennant` int(11) DEFAULT '-1', `supplies` int(11) DEFAULT '100', `safepositionX` float DEFAULT NULL, `safepositionY` float DEFAULT NULL, `safepositionZ` float DEFAULT NULL, `safepositionRZ` float DEFAULT NULL, `fee` int(10) unsigned DEFAULT '0', `disabled` tinyint(3) unsigned DEFAULT '0', `lastused` datetime DEFAULT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=9 ; -- -- Dumping data for table `interiors` -- INSERT INTO `interiors` (`id`, `x`, `y`, `z`, `type`, `owner`, `locked`, `cost`, `name`, `interior`, `interiorx`, `interiory`, `interiorz`, `dimensionwithin`, `interiorwithin`, `angle`, `angleexit`, `max_items`, `rentable`, `rent`, `money`, `items`, `items_values`, `tennant`, `supplies`, `safepositionX`, `safepositionY`, `safepositionZ`, `safepositionRZ`, `fee`, `disabled`, `lastused`) VALUES (1, 1555.07, -1675.63, 16.1953, 2, 0, 0, 0, 'Los Santos Police Department', 10, 246.37, 107.51, 1003.21, 0, 0, 0, 271.073, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, '2012-04-29 00:00:00'), (2, 1481.02, -1771.63, 18.7958, 2, 0, 0, 0, 'City Hall', 3, 390.44, 173.91, 1008.38, 0, 0, 90, 271.073, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, '2012-04-28 21:39:05'), (3, 2037.57, -1404.76, 17.2511, 2, 0, 0, 0, 'Los Santos Emergency Medical Services', 3, 390.44, 173.91, 1008.38, 0, 0, 90, 273.556, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, NULL), (4, 1712.27, -1129.74, 24.0859, 2, 0, 0, 0, 'Fire Department | Station 60', 3, 390.44, 173.91, 1008.38, 0, 0, 90, 0.326843, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, NULL), (5, 1487.73, -1010.26, 26.8438, 1, -1, 1, 0, 'San Andreas Network', 3, 390.44, 173.91, 1008.38, 0, 0, 90, 0.639954, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, NULL), (6, 1494.04, -2386.69, 13.5469, 1, -1, 1, 0, 'Los Santos International Airport', 3, 390.44, 173.91, 1008.38, 0, 0, 178.907, 181.434, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, NULL), (7, 1111.5, -1795.56, 16.5938, 2, 0, 0, 0, 'Department of motor vehicles', 5, 226.56, 1114.19, 1080.99, 0, 0, 270, 270.787, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, '2012-04-28 21:51:46'), (8, 914.195, -1004.17, 37.9887, 1, 1, 0, 0, 'Uni-Tel', 32, 2079.89, 477.98, 41.85, 0, 0, 0, 177.1, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, '2012-04-28 21:52:44'); -- -------------------------------------------------------- -- -- Table structure for table `items` -- CREATE TABLE IF NOT EXISTS `items` ( `index` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` tinyint(3) unsigned NOT NULL, `owner` int(10) unsigned NOT NULL, `itemID` int(10) NOT NULL, `itemValue` text NOT NULL, PRIMARY KEY (`index`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=14 ; -- -- Dumping data for table `items` -- INSERT INTO `items` (`index`, `type`, `owner`, `itemID`, `itemValue`) VALUES (1, 1, 1, 16, '93'), (2, 1, 1, 17, '1'), (3, 1, 1, 18, '1'), (4, 1, 1, 3, '1'), (5, 1, 1, 5, '8'), (6, 1, 1, 3, '2'), (8, 1, 1, 77, '1'), (9, 1, 1, 115, '4:1:Knife'), (10, 1, 1, 71, '125'), (11, 1, 1, 3, '3'), (12, 1, 1, 3, '4'), (13, 1, 1, 119, '#01 - CEO - R.Dawson'); -- -------------------------------------------------------- -- -- Table structure for table `logtable` -- CREATE TABLE IF NOT EXISTS `logtable` ( `time` datetime NOT NULL, `action` int(2) NOT NULL, `source` varchar(12) NOT NULL, `affected` text NOT NULL, `content` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `lottery` -- CREATE TABLE IF NOT EXISTS `lottery` ( `characterid` int(255) NOT NULL, `ticketnumber` int(3) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `mdcusers` -- CREATE TABLE IF NOT EXISTS `mdcusers` ( `user_name` varchar(20) NOT NULL, `password` varchar(20) NOT NULL DEFAULT '123', `high_command` int(1) DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `objects` -- CREATE TABLE IF NOT EXISTS `objects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `model` int(6) NOT NULL DEFAULT '0', `posX` float(12,7) NOT NULL DEFAULT '0.0000000', `posY` float(12,7) NOT NULL DEFAULT '0.0000000', `posZ` float(12,7) NOT NULL DEFAULT '0.0000000', `rotX` float(12,7) NOT NULL DEFAULT '0.0000000', `rotY` float(12,7) NOT NULL DEFAULT '0.0000000', `rotZ` float(12,7) NOT NULL DEFAULT '0.0000000', `interior` int(5) NOT NULL, `dimension` int(5) NOT NULL, `comment` varchar(50) DEFAULT NULL, `solid` int(1) NOT NULL DEFAULT '1', `doublesided` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `paynspray` -- CREATE TABLE IF NOT EXISTS `paynspray` ( `id` int(11) NOT NULL AUTO_INCREMENT, `x` decimal(10,6) DEFAULT '0.000000', `y` decimal(10,6) DEFAULT '0.000000', `z` decimal(10,6) DEFAULT '0.000000', `dimension` int(5) DEFAULT '0', `interior` int(5) DEFAULT '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=9 ; -- -- Dumping data for table `paynspray` -- INSERT INTO `paynspray` (`id`, `x`, `y`, `z`, `dimension`, `interior`) VALUES (1, 487.242188, -1741.555664, 10.832272, 0, 0), (2, 1024.963867, -1023.606445, 31.805906, 0, 0), (3, 2063.466797, -1830.992188, 13.251081, 0, 0), (4, 1545.098633, -1663.876953, 5.890625, 0, 0), (5, 720.349609, -456.050781, 16.335938, 0, 0), (6, 2811.736328, -2153.569336, 1583.233887, 839, 2), (7, 1911.286133, -1776.229492, 12.952327, 0, 0), (8, 1517.291992, -1672.346680, 29.099415, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `phone_contacts` -- CREATE TABLE IF NOT EXISTS `phone_contacts` ( `phone` int(11) NOT NULL, `entryName` varchar(30) NOT NULL, `entryNumber` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `phone_settings` -- CREATE TABLE IF NOT EXISTS `phone_settings` ( `phonenumber` int(1) NOT NULL, `turnedon` smallint(1) unsigned NOT NULL DEFAULT '1', `secretnumber` smallint(1) unsigned NOT NULL DEFAULT '0', `ringtone` smallint(1) NOT NULL DEFAULT '1', `phonebook` varchar(40) DEFAULT NULL, `boughtby` int(11) NOT NULL DEFAULT '-1', PRIMARY KEY (`phonenumber`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `phone_settings` -- INSERT INTO `phone_settings` (`phonenumber`, `turnedon`, `secretnumber`, `ringtone`, `phonebook`, `boughtby`) VALUES (298, 1, 0, 1, NULL, -1); -- -------------------------------------------------------- -- -- Table structure for table `publicphones` -- CREATE TABLE IF NOT EXISTS `publicphones` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `x` float NOT NULL, `y` float NOT NULL, `z` float NOT NULL, `dimension` int(10) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE IF NOT EXISTS `settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text, `value` text, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=9 ; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `name`, `value`) VALUES (1, 'motd', 'Carmods are back || Hit F2 if you need the assistance of an admin.'), (2, 'amotd', 'Found any bugs? Report them to Jector(Rachel Dawson) or Amir Stewart'), (3, 'globalsupplies', '7920'), (4, 'lotteryjackpot', '72060'), (5, 'welfare', '200'), (6, 'tax', '10'), (7, 'incometax', '10'), (8, 'garagestates', '[ { "1": true, "2": true, "3": false, "4": true, "5": true, "6": true, "7": true, "8": true, "9": true, "10": true, "11": true, "12": true, "13": false, "14": false, "15": true, "16": true, "17": true, "18": true, "19": true, "20": true, "21": true, "22": true, "23": true, "24": true, "25": true, "26": true, "27": true, "28": true, "29": true, "30": true, "31": true, "32": true, "33": true, "34": true, "35": true, "36": true, "37": true, "38": true, "39": true, "40": true, "41": true, "42": true, "43": true, "44": true, "45": true, "46": true, "47": true, "48": true, "49": true, "0": true } ]'); -- -------------------------------------------------------- -- -- Table structure for table `shops` -- CREATE TABLE IF NOT EXISTS `shops` ( `id` int(11) NOT NULL AUTO_INCREMENT, `x` float DEFAULT '0', `y` float DEFAULT '0', `z` float DEFAULT '0', `dimension` int(5) DEFAULT '0', `interior` int(5) DEFAULT '0', `shoptype` tinyint(4) DEFAULT '0', `rotation` float NOT NULL DEFAULT '0', `skin` int(11) DEFAULT '-1', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `speedcams` -- CREATE TABLE IF NOT EXISTS `speedcams` ( `id` int(11) NOT NULL AUTO_INCREMENT, `x` float(11,7) NOT NULL DEFAULT '0.0000000', `y` float(11,7) NOT NULL DEFAULT '0.0000000', `z` float(11,7) NOT NULL DEFAULT '0.0000000', `interior` int(3) NOT NULL DEFAULT '0' COMMENT 'Stores the location of the pernament speedcams', `dimension` int(5) NOT NULL DEFAULT '0', `maxspeed` int(4) NOT NULL DEFAULT '120', `radius` int(4) NOT NULL DEFAULT '2', `enabled` smallint(1) DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `speedcams` -- INSERT INTO `speedcams` (`id`, `x`, `y`, `z`, `interior`, `dimension`, `maxspeed`, `radius`, `enabled`) VALUES (2, 1349.7988281, -1399.8105469, 13.3075285, 0, 0, 95, 24, 1), (3, 1592.7099609, -1732.2382812, 13.3828125, 0, 0, 65, 16, 1); -- -------------------------------------------------------- -- -- Table structure for table `speedingviolations` -- CREATE TABLE IF NOT EXISTS `speedingviolations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `carID` int(11) NOT NULL, `time` datetime NOT NULL, `speed` int(5) NOT NULL, `area` varchar(50) NOT NULL, `personVisible` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `suspectcrime` -- CREATE TABLE IF NOT EXISTS `suspectcrime` ( `id` int(11) NOT NULL AUTO_INCREMENT, `suspect_name` text, `time` text, `date` text, `officers` text, `ticket` int(11) DEFAULT NULL, `arrest` int(11) DEFAULT NULL, `fine` int(11) DEFAULT NULL, `ticket_price` text, `arrest_price` text, `fine_price` text, `illegal_items` text, `details` text, `done_by` text, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `suspectdetails` -- CREATE TABLE IF NOT EXISTS `suspectdetails` ( `suspect_name` text, `birth` text, `gender` text, `ethnicy` text, `cell` int(5) DEFAULT '0', `occupation` text, `address` text, `other` text, `is_wanted` int(1) DEFAULT '0', `wanted_reason` text, `wanted_punishment` text, `wanted_by` text, `photo` text, `done_by` text ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tags` -- CREATE TABLE IF NOT EXISTS `tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, `x` decimal(10,6) DEFAULT NULL, `y` decimal(10,6) DEFAULT NULL, `z` decimal(10,6) DEFAULT NULL, `interior` int(5) DEFAULT NULL, `dimension` int(5) DEFAULT NULL, `rx` decimal(10,6) DEFAULT NULL, `ry` decimal(10,6) DEFAULT NULL, `rz` decimal(10,6) DEFAULT NULL, `modelid` int(5) DEFAULT NULL, `creationdate` datetime DEFAULT NULL, `creator` int(11) NOT NULL DEFAULT '-1', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tc_comments` -- CREATE TABLE IF NOT EXISTS `tc_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `poster` int(11) NOT NULL, `ip` varchar(50) NOT NULL, `message` text NOT NULL, `posted` int(25) NOT NULL, `type` int(1) NOT NULL, `ticket` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tc_tickets` -- CREATE TABLE IF NOT EXISTS `tc_tickets` ( `id` int(11) NOT NULL AUTO_INCREMENT, `creator` int(11) NOT NULL, `posted` int(25) NOT NULL, `subject` varchar(100) NOT NULL, `message` text NOT NULL, `status` int(1) NOT NULL, `lastpost` int(25) NOT NULL, `assigned` int(11) NOT NULL, `IP` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `tempinteriors` -- CREATE TABLE IF NOT EXISTS `tempinteriors` ( `id` int(11) NOT NULL, `posX` float NOT NULL, `posY` float DEFAULT NULL, `posZ` float DEFAULT NULL, `interior` int(5) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tempobjects` -- CREATE TABLE IF NOT EXISTS `tempobjects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `model` int(6) NOT NULL DEFAULT '0', `posX` float(12,7) NOT NULL DEFAULT '0.0000000', `posY` float(12,7) NOT NULL DEFAULT '0.0000000', `posZ` float(12,7) NOT NULL DEFAULT '0.0000000', `rotX` float(12,7) NOT NULL DEFAULT '0.0000000', `rotY` float(12,7) NOT NULL DEFAULT '0.0000000', `rotZ` float(12,7) NOT NULL DEFAULT '0.0000000', `interior` int(5) NOT NULL, `dimension` int(5) NOT NULL, `comment` varchar(50) DEFAULT NULL, `solid` int(1) NOT NULL DEFAULT '1', `doublesided` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `vehicles` -- CREATE TABLE IF NOT EXISTS `vehicles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `model` int(3) DEFAULT '0', `x` decimal(10,6) DEFAULT '0.000000', `y` decimal(10,6) DEFAULT '0.000000', `z` decimal(10,6) DEFAULT '0.000000', `rotx` decimal(10,6) DEFAULT '0.000000', `roty` decimal(10,6) DEFAULT '0.000000', `rotz` decimal(10,6) DEFAULT '0.000000', `currx` decimal(10,6) DEFAULT '0.000000', `curry` decimal(10,6) DEFAULT '0.000000', `currz` decimal(10,6) DEFAULT '0.000000', `currrx` decimal(10,6) DEFAULT '0.000000', `currry` decimal(10,6) DEFAULT '0.000000', `currrz` decimal(10,6) DEFAULT '0.000000', `fuel` int(3) DEFAULT '100', `engine` int(1) DEFAULT '0', `locked` int(1) DEFAULT '0', `lights` int(1) DEFAULT '0', `sirens` int(1) DEFAULT '0', `paintjob` int(11) DEFAULT '0', `hp` float DEFAULT '1000', `color1` varchar(50) DEFAULT '0', `color2` varchar(50) DEFAULT '0', `color3` varchar(50) DEFAULT '0', `color4` varchar(50) DEFAULT '0', `plate` text, `faction` int(11) DEFAULT '-1', `owner` int(11) DEFAULT '-1', `job` int(11) DEFAULT '-1', `tintedwindows` int(1) DEFAULT '0', `dimension` int(5) DEFAULT '0', `interior` int(5) DEFAULT '0', `currdimension` int(5) DEFAULT '0', `currinterior` int(5) DEFAULT '0', `enginebroke` int(1) DEFAULT '0', `items` text, `itemvalues` text, `Impounded` int(3) DEFAULT '0', `handbrake` int(1) DEFAULT '0', `safepositionX` float DEFAULT NULL, `safepositionY` float DEFAULT NULL, `safepositionZ` float DEFAULT NULL, `safepositionRZ` float DEFAULT NULL, `upgrades` varchar(150) DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', `wheelStates` varchar(30) DEFAULT '[ [ 0, 0, 0, 0 ] ]', `panelStates` varchar(40) DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', `doorStates` varchar(30) DEFAULT '[ [ 0, 0, 0, 0, 0, 0 ] ]', `odometer` int(15) DEFAULT '0', `headlights` varchar(30) DEFAULT '[ [ 255, 255, 255 ] ]', `variant1` tinyint(3) unsigned NOT NULL DEFAULT '255', `variant2` tinyint(3) unsigned NOT NULL DEFAULT '255', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=5 ; -- -- Dumping data for table `vehicles` -- INSERT INTO `vehicles` (`id`, `model`, `x`, `y`, `z`, `rotx`, `roty`, `rotz`, `currx`, `curry`, `currz`, `currrx`, `currry`, `currrz`, `fuel`, `engine`, `locked`, `lights`, `sirens`, `paintjob`, `hp`, `color1`, `color2`, `color3`, `color4`, `plate`, `faction`, `owner`, `job`, `tintedwindows`, `dimension`, `interior`, `currdimension`, `currinterior`, `enginebroke`, `items`, `itemvalues`, `Impounded`, `handbrake`, `safepositionX`, `safepositionY`, `safepositionZ`, `safepositionRZ`, `upgrades`, `wheelStates`, `panelStates`, `doorStates`, `odometer`, `headlights`, `variant1`, `variant2`) VALUES (1, 409, 541.406250, -1291.089844, 17.080635, 0.000000, 0.000000, 29.998169, 1100.066406, -1802.304688, 13.989842, 13.222046, 2.960815, 260.035400, 99, 1, 0, 1, 0, 0, 912.82, '[ [ 1, 1, 0 ] ]', '[ [ 0 ] ]', '[ [ ] ]', '[ [ ] ]', 'KX2 5692', -1, 1, -1, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0 ] ]', '[ [ 0, 2, 0, 0, 0, 2, 0 ] ]', '[ [ 2, 0, 0, 0, 0, 0 ] ]', 1072, '[ [ 255, 255, 255 ] ]', 255, 255), (2, 560, 2136.503906, -1145.796875, 24.661764, 0.000000, 0.000000, 337.999878, 1966.869141, -1780.372070, -105.339905, 13.666992, 32.568970, 102.260742, 92, 1, 0, 1, 0, 0, 966.056, '[ [ 17, 1, 17 ] ]', '[ [ 1 ] ]', '[ [ ] ]', '[ [ ] ]', 'IT5 9322', -1, 1, -1, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 1 ] ]', '[ [ 0, 2, 0, 0, 0, 0 ] ]', 1819, '[ [ 255, 255, 255 ] ]', 255, 255), (3, 480, 541.405273, -1291.088867, 17.022371, 359.774780, 0.000000, 29.998169, 541.405273, -1291.088867, 17.022371, 0.000000, 0.000000, 29.998169, 100, 0, 1, 0, 0, 0, 1000, '[ [ 73, 45, 73 ] ]', '[ [ 45 ] ]', '[ [ ] ]', '[ [ ] ]', 'RD2 2212', -1, 1, -1, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0 ] ]', 0, '[ [ 255, 255, 255 ] ]', 255, 255), (4, 480, 547.405273, -1291.088867, 17.028622, 359.774780, 0.000000, 29.998169, 1943.609375, -1770.748047, 13.238859, 2.460938, 4.279175, 56.200562, 94, 1, 0, 1, 0, 0, 421.49, '[ [ 6, 6, 6 ] ]', '[ [ 6 ] ]', '[ [ ] ]', '[ [ ] ]', 'IN9 6294', -1, 1, -1, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0 ] ]', '[ [ 1, 0, 0, 0, 2, 2, 1 ] ]', '[ [ 2, 2, 2, 2, 0, 0 ] ]', 2169, '[ [ 255, 255, 255 ] ]', 255, 255); -- -------------------------------------------------------- -- -- Table structure for table `wiretransfers` -- CREATE TABLE IF NOT EXISTS `wiretransfers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `from` int(11) NOT NULL, `to` int(11) NOT NULL, `amount` int(11) NOT NULL, `reason` text NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `type` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `wiretransfers` -- INSERT INTO `wiretransfers` (`id`, `from`, `to`, `amount`, `reason`, `time`, `type`) VALUES (1, -57, 1, 2, 'BANKINTEREST', '2012-04-28 23:00:22', 6), (2, 1, -3, 502, 'VEHICLETAX', '2012-04-28 23:00:22', 6), (3, 1, -3, 0, 'VEHICLETAX', '2012-04-29 00:00:22', 6); -- -------------------------------------------------------- -- -- Table structure for table `worlditems` -- CREATE TABLE IF NOT EXISTS `worlditems` ( `id` int(11) NOT NULL AUTO_INCREMENT, `itemid` int(11) DEFAULT '0', `itemvalue` text, `x` float DEFAULT '0', `y` float DEFAULT '0', `z` float DEFAULT '0', `dimension` int(5) DEFAULT '0', `interior` int(5) DEFAULT '0', `creationdate` datetime DEFAULT NULL, `rz` float DEFAULT '0', `creator` int(10) unsigned DEFAULT '0', `protected` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Hello i need help with my sql database it does not work on my dedi and im going to need some help on it please if someone can help. I can pay good money contact info: Please someone contact me i will pay anyone. Who know SQL DataBase. Skype:agame2821

Hello Everyone looking to help Deadric Map i need Mappers You will be apart of the server and admin. Here is Contract Info: Skype:agame2821 email:[email protected] deadricgaming.net