NeverSay Posted May 16, 2012 Share Posted May 16, 2012 (edited) 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 Edited May 18, 2012 by Guest Link to comment
mjr Posted May 16, 2012 Share Posted May 16, 2012 I can pay good money DO NOT write you e-mail address in public places Link to comment
Stanley Sathler Posted May 16, 2012 Share Posted May 16, 2012 Why you don't post your code/problem here? If you do it, we will help you more easily. Link to comment
NeverSay Posted May 16, 2012 Author Share Posted May 16, 2012 -- 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 */; Link to comment
NeverSay Posted May 16, 2012 Author Share Posted May 16, 2012 There you go when i put it in the database it says an Error please tell me if you neeed the error. Link to comment
Jaysds1 Posted May 16, 2012 Share Posted May 16, 2012 (edited) -- phpMyAdmin SQL Dump -- version 3.4.5 -- [url=http://www.phpmyadmin.net]http://www.phpmyadmin.net[/url] -- -- 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, Edited May 16, 2012 by Guest Link to comment
myonlake Posted May 16, 2012 Share Posted May 16, 2012 Seriously, never try to run Valhalla Gamemode if you don't know anything. This is a simple issue, which is something to do with your SQL file type. Change the type and it works. I am still and always saying: no matter how beautiful the script is, no one cares because you're lame. There are no other successful vG servers than the original one. Oh my god -.- Link to comment
NeverSay Posted May 18, 2012 Author Share Posted May 18, 2012 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. Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now