Jump to content

Looking for People Who know SQL Only


Recommended Posts

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 by Guest
Link to comment

-- 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(8) NOT NULL,

`dimension` int(8) NOT NULL,

`model` int(8) 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
-- 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 by Guest
Link to comment

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...