12.11.2016, 16:20
So basically, the .sql I imported to my Registeration systems mysql db was kinda empty, It had all the tables but no values in it. However, When a person registered, instead of showing 0 as his RegID, it shows the 10,000th account, from where I left off. Same is the case with houses. There is no house in the db, so a newly created house should have a ID of 0, however it shows 714 which was the last time.
Code
code
So, I'm literally out of ideas, on how can I freshly start from 0 ID for both houses and players.
Cheers,
After all my freind told me to do this in sql
sql of my server
Code
Код:
GetPlayerName(playerid, PlayerName, sizeof(PlayerName)); format(str, sizeof str, ""RED_E"[SG] {%06x}%s(%i) "GREEN_E"has registered, making the server have a total of "LB2_E"%s "GREEN_E"players registered.", pColor[playerid], PlayerName, playerid, ToCurrency(pRegID[playerid])); SendClientMessageToAll(COLOR_GREEN, str); RegisteredPlayers = pRegID[playerid];
Код:
ToCurrency(cCash) { new szStr[16]; format(szStr, sizeof(szStr), "%i", cCash); for(new iLen = strlen(szStr) - 3; iLen > 0; iLen -= 3) { strins(szStr, ",", iLen); } return szStr; }
Cheers,
After all my freind told me to do this in sql
Код:
// he said to do this but i cant do anyone can do for me he told me this Empty the table and execute this once: ALTER TABLE table_name AUTO_INCREMENT = 1
Код:
-- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.netnl66fd757da90b5...4.02585158-- Host: 127.0.0.1 -- Generation Time: Jun 10, 2016 at 12:11 PM -- Server version: 10.1.10-MariaDB -- PHP Version: 7.0.2 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 utf8mb4 */; -- -- Database: `xsfs_xsf` -- DELIMITER $$ -- -- Procedures -- CREATE DEFINER=`root`@`localhost` PROCEDURE `login` (IN `username` VARCHAR(24), IN `password` VARCHAR(42), IN `ip` VARCHAR(45), OUT `returncode` VARCHAR(24)) BEGIN DECLARE user_id INT; DECLARE user_exist TINYINT; DECLARE user_ban TINYINT; DECLARE login_attempts INT; DECLARE error_code INT; SET user_id = -1; SET error_code = 0; SELECT COUNT(*) INTO user_exist FROM players WHERE name = username; IF user_exist = 0 THEN SET error_code = 10; END IF; IF error_code = 0 THEN SELECT COUNT(*) INTO login_attempts FROM pcp_login_attempt WHERE (la_name = username OR la_ip = ip) AND la_error = 40 AND TIMESTAMPDIFF(MINUTE, la_time, NOW()) <= 10; IF login_attempts >= 3 THEN SET error_code = 20; END IF; END IF; IF error_code = 0 THEN SELECT COUNT(*) INTO user_ban FROM bans WHERE user_banned = username; IF user_ban <> 0 THEN SET error_code = 30; END IF; END IF; IF error_code = 0 THEN SELECT reg_id INTO user_id FROM players WHERE name = username AND pass = password; IF user_id = -1 THEN SET error_code = 40; END IF; END IF; INSERT INTO pcp_login_attempt (la_name, la_ip, la_error) VALUES (username, ip, error_code); SET returncode = CONCAT(error_code, '|' , user_id); END$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_user_data` (IN `user_id` INT) BEGIN SELECT P.reg_id AS id, P.name AS name, P.adminlevel AS admin, P.helper AS helper, P.premium AS premium, P.saveskin AS skin FROM players P WHERE reg_id = user_id LIMIT 1; END$$ DELIMITER ; -- -------------------------------------------------------- -- -- Table structure for table `achievements` -- CREATE TABLE `achievements` ( `ID` int(7) UNSIGNED NOT NULL, `reg_id` mediumint(7) UNSIGNED NOT NULL, `name` varchar(24) CHARACTER SET utf8 NOT NULL, `a1` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Grim Reaper', `a2` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Mass Killer', `a3` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'You''re Rich', `a4` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Official Stunter', `a5` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a6` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a7` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a8` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a9` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a10` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a11` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a12` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a13` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a14` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a15` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a16` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a17` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a18` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a19` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a20` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a21` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `a22` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Human Calculator', `a23` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Derby Pro', `a24` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Pro Cop', `a25` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Pro Theif', `a26` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Pickpocketer', `a27` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Ruthless', `a28` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'CookieJar Hunter' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Player Achivements'; -- -------------------------------------------------------- -- -- Table structure for table `activity` -- CREATE TABLE `activity` ( `reg_id` mediumint(7) UNSIGNED NOT NULL DEFAULT '0', `name` varchar(21) NOT NULL, `IP` varchar(16) NOT NULL, `jointime` int(11) UNSIGNED NOT NULL, `leavetime` int(11) UNSIGNED NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Activity Log'; -- -------------------------------------------------------- -- -- Table structure for table `adminlog` -- CREATE TABLE `adminlog` ( `command` varchar(14) NOT NULL, `admin` varchar(21) NOT NULL, `adminid` mediumint(7) UNSIGNED NOT NULL, `player` varchar(21) NOT NULL DEFAULT '*', `playerid` mediumint(7) NOT NULL DEFAULT '-1', `str` varchar(128) NOT NULL DEFAULT '*', `time` int(11) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `bans` -- CREATE TABLE `bans` ( `BanID` smallint(5) UNSIGNED NOT NULL COMMENT 'Ban ID', `user_banned` varchar(24) NOT NULL COMMENT 'Banned Player Name', `bIP` varchar(16) NOT NULL COMMENT 'Banned Player IP', `user_banner` varchar(24) NOT NULL DEFAULT '*' COMMENT 'Admin Name', `ban_reason` varchar(60) NOT NULL DEFAULT '*' COMMENT 'Ban Reason', `ban_timestamp` int(11) UNSIGNED NOT NULL COMMENT 'Ban Date', `ban_time` int(11) UNSIGNED NOT NULL COMMENT 'Ban Time (0 = Permenant)' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT; -- -------------------------------------------------------- -- -- Table structure for table `comments` -- CREATE TABLE `comments` ( `Name` text, `Comment` text, `Timestamp` text, `CKey` text ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE `groups` ( `gID` mediumint(6) NOT NULL, `gName` varchar(25) NOT NULL, `gTag` varchar(4) NOT NULL COMMENT 'Group Tag', `gFounder` varchar(24) NOT NULL COMMENT 'Group Founder', `gScore` int(8) NOT NULL DEFAULT '0', `gDate` int(11) NOT NULL DEFAULT '0', `gColor` int(11) NOT NULL DEFAULT '-1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `houses` -- CREATE TABLE `houses` ( `house_id` mediumint(4) NOT NULL, `hname` varchar(35) NOT NULL, `howner` varchar(21) NOT NULL, `hlocation` varchar(30) NOT NULL DEFAULT '*', `hpass` varchar(24) NOT NULL, `last_visited` int(11) UNSIGNED NOT NULL DEFAULT '0', `x` float NOT NULL DEFAULT '0', `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', `a` float NOT NULL DEFAULT '0', `cpx` float NOT NULL DEFAULT '0', `cpy` float NOT NULL DEFAULT '0', `cpz` float NOT NULL DEFAULT '0', `hvalue` int(12) UNSIGNED NOT NULL DEFAULT '500', `hforsale` int(12) UNSIGNED NOT NULL DEFAULT '0', `hstorage` int(12) UNSIGNED NOT NULL DEFAULT '0', `hint` tinyint(2) UNSIGNED NOT NULL DEFAULT '4', `hprivacy` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `interiors` -- CREATE TABLE `interiors` ( `int_name` varchar(30) NOT NULL, `intx` float NOT NULL DEFAULT '0', `inty` float NOT NULL DEFAULT '0', `intz` float NOT NULL DEFAULT '0', `inta` float NOT NULL DEFAULT '0', `cpx` float NOT NULL DEFAULT '0', `cpy` float NOT NULL DEFAULT '0', `cpz` float NOT NULL DEFAULT '0', `interior` tinyint(2) UNSIGNED NOT NULL DEFAULT '0', `value` int(12) UNSIGNED NOT NULL DEFAULT '500' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `kicks` -- CREATE TABLE `kicks` ( `player` varchar(21) NOT NULL, `player_ip` varchar(16) NOT NULL, `player_regid` mediumint(7) UNSIGNED NOT NULL, `admin` varchar(32) NOT NULL DEFAULT 'SYSTEM', `admin_regid` mediumint(7) UNSIGNED NOT NULL DEFAULT '0', `reason` varchar(128) NOT NULL, `time` int(11) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `labels` -- CREATE TABLE `labels` ( `id` int(11) NOT NULL, `owner` varchar(24) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `labelnum` int(1) NOT NULL DEFAULT '1', `text` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `posX` float NOT NULL, `posY` float NOT NULL, `posZ` float NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `monthlycomp` -- CREATE TABLE `monthlycomp` ( `test` int(11) NOT NULL, `reg_id` int(11) NOT NULL, `name` varchar(30) NOT NULL, `hours` int(11) NOT NULL, `minutes` int(11) NOT NULL, `seconds` int(11) NOT NULL, `kills` int(11) NOT NULL, `deaths` int(11) NOT NULL, `score` int(11) NOT NULL, `rtests` int(11) NOT NULL, `mb_found` int(11) NOT NULL, `cookiejars` int(11) NOT NULL, `events_won` int(11) NOT NULL, `duels_won` int(11) NOT NULL, `races_won` int(11) NOT NULL, `fallouts` int(11) NOT NULL, `derby_wins` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `namechanges` -- CREATE TABLE `namechanges` ( `num` smallint(5) UNSIGNED NOT NULL, `reg_id` int(7) UNSIGNED NOT NULL, `oldname` varchar(21) NOT NULL, `newname` varchar(21) NOT NULL, `time` int(11) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `parkourtimes` -- CREATE TABLE `parkourtimes` ( `parkourid` smallint(3) NOT NULL, `parkour` varchar(24) NOT NULL, `holder` varchar(24) NOT NULL DEFAULT 'NONE', `regid` smallint(5) NOT NULL DEFAULT '-1', `ms` mediumint(7) NOT NULL DEFAULT '0', `time` int(12) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `pcp_login_attempt` -- CREATE TABLE `pcp_login_attempt` ( `la_id` int(11) NOT NULL, `la_name` varchar(24) COLLATE utf8_unicode_ci NOT NULL, `la_ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL, `la_error` int(11) DEFAULT NULL, `la_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `pcp_news` -- CREATE TABLE `pcp_news` ( `nw_id` int(11) NOT NULL, `nw_title` varchar(24) NOT NULL, `nw_body` longtext, `nw_sticked` tinyint(1) NOT NULL DEFAULT '0', `nw_user` int(11) NOT NULL, `nw_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `pcp_page_perm` -- CREATE TABLE `pcp_page_perm` ( `pp_page` varchar(256) NOT NULL, `pp_perm` tinyint(1) NOT NULL DEFAULT '-1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `players` -- CREATE TABLE `players` ( `reg_id` int(7) UNSIGNED NOT NULL COMMENT 'Players Registration ID', `name` varchar(24) NOT NULL COMMENT 'Player''s Name', `IP` varchar(16) NOT NULL COMMENT 'Players IP', `pass` varchar(42) NOT NULL COMMENT 'Players Password', `email` varchar(40) NOT NULL DEFAULT '*' COMMENT 'Players Email', `adminlevel` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player''s Admin Level', `helper` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Server Helper.', `premium` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Premium Level', `gold_coins` mediumint(6) UNSIGNED NOT NULL COMMENT 'Gold Coins (Credits)', `hours` mediumint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Online Hours', `minutes` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Online Minutes', `seconds` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Online Seconds', `kills` int(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Kills', `deaths` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Deaths', `money` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Cash', `bmoney` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Bank Money', `score` mediumint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Score', `group_id` smallint(4) NOT NULL DEFAULT '-1' COMMENT 'Player''s Group', `group_rank` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Players Group Rank', `saveskin` smallint(4) UNSIGNED NOT NULL DEFAULT '999' COMMENT 'Player''s Saved Skin', `autoLogin` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Auto Login', `spawnplace` tinyint(3) NOT NULL DEFAULT '-1' COMMENT 'Player Spawn Area', `weapon_set` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Players Weapon Set', `seepms` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'View PMs (Admin Only)', `specoff` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Toggle Spectate', `hidden` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Hidden (Admin Only)', `autotune` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Vehicle AutoTune', `cookies` mediumint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Cookies', `events_won` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Events Won', `races_won` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Races Won', `parkours_won` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Parkours Won', `duels_won` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Duels Won', `fallouts` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Fallout Wins', `derby_wins` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Derby Wins', `MB_found` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Moneybags Found', `cookiejars` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Cookie Jars Found', `keyflip` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Speedbreak', `savedvehicle` mediumint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Saved Vehicle', `speedboost` float UNSIGNED NOT NULL DEFAULT '1.3' COMMENT 'Player Speedboost', `bounce` tinyint(1) UNSIGNED NOT NULL DEFAULT '1', `superman` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', `wheels` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Players default wheels', `reg_time` varchar(20) NOT NULL COMMENT 'Registration Date', `last_time` varchar(20) NOT NULL COMMENT 'Last Online Date', `color` int(11) NOT NULL DEFAULT '0' COMMENT 'Player Nick Color', `chat_color` int(11) NOT NULL DEFAULT '0' COMMENT 'Chat Color (VIP)', `id_color` int(11) NOT NULL DEFAULT '0' COMMENT 'Player ID Color', `goto` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Toggle Player Teleporting', `autofix` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Toggle Vehicle Repair', `god` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player God Mode', `rtests` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Reactions Won', `maths` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Math Questions Answered', `arrests` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player''s Arrests', `takedowns` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'CnR Takedowns', `robberies` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'CnR Robberies', `probberies` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'CnR Player Robberies', `times_arrested` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'CnR Times Arrested', `cop_kills` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Cops Killed in CnR.', `speedo` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Speedo Meter', `killstreak` smallint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Highest Killstreak', `active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Online', `hideMSGs` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Hide Server Messages', `duels_off` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Toggle Duel Invitations', `plate` varchar(15) NOT NULL DEFAULT '*' COMMENT 'Vehicle Plate', `time` tinyint(2) NOT NULL DEFAULT '-1' COMMENT 'Player Time', `weather` tinyint(2) NOT NULL DEFAULT '-1' COMMENT 'Player Weather', `description` varchar(40) NOT NULL DEFAULT 'None.' COMMENT 'Player Description', `country` varchar(30) NOT NULL DEFAULT '*' COMMENT 'Player Country', `namechange_date` int(12) NOT NULL DEFAULT '0' COMMENT 'Name Change Date', `v_expired` int(12) NOT NULL DEFAULT '0' COMMENT 'Premium Expiration Date', `Muted` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Mute Time', `Jailed` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Jail Time', `report_points` mediumint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Report Points', `house_id` smallint(4) NOT NULL DEFAULT '-1' COMMENT 'Player House ID', `gotpresent` int(12) NOT NULL DEFAULT '0' COMMENT 'Christmas Present', `togpms` tinyint(1) NOT NULL DEFAULT '0', `togevent` tinyint(1) NOT NULL DEFAULT '0', `hitsound` tinyint(1) NOT NULL DEFAULT '0', `cbugtime` int(11) NOT NULL DEFAULT '0', `togmsg` int(1) NOT NULL DEFAULT '1', `fstyle` int(2) NOT NULL DEFAULT '4' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Player Data Storage' ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `playerstest` -- CREATE TABLE `playerstest` ( `test` int(1) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `racetimes` -- CREATE TABLE `racetimes` ( `raceid` smallint(3) NOT NULL, `race` varchar(32) NOT NULL, `holder` varchar(24) NOT NULL DEFAULT 'NONE', `regid` smallint(5) NOT NULL DEFAULT '-1', `ms` mediumint(7) NOT NULL DEFAULT '0', `time` int(12) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `recover` -- CREATE TABLE `recover` ( `RecoverKey` varchar(255) DEFAULT NULL, `Username` varchar(255) DEFAULT NULL, `IP` varchar(255) DEFAULT NULL, `Date` varchar(255) DEFAULT NULL, `E-Mail` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `SessID` varchar(30) NOT NULL, `Username` text NOT NULL, `Password` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `soldhouses` -- CREATE TABLE `soldhouses` ( `name` varchar(24) NOT NULL, `hID` mediumint(4) UNSIGNED NOT NULL DEFAULT '0', `hbuyer` varchar(24) NOT NULL, `hprice` int(12) UNSIGNED NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `toys` -- CREATE TABLE `toys` ( `ID` mediumint(6) UNSIGNED NOT NULL, `Name` varchar(24) NOT NULL, `Slot0_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0', `Slot0_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0', `Slot0_XPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot0_YPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot0_ZPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot0_XRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot0_YRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot0_ZRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot0_XScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot0_YScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot0_ZScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot1_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0', `Slot1_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0', `Slot1_XPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot1_YPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot1_ZPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot1_XRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot1_YRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot1_ZRot` float(20,2) NOT NULL DEFAULT '0.00', `Slot1_XScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot1_YScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot1_ZScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot2_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0', `Slot2_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0', `Slot2_XPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot2_YPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot2_ZPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot2_XRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot2_YRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot2_ZRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot2_XScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot2_YScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot2_ZScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot3_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0', `Slot3_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0', `Slot3_XPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot3_YPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot3_ZPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot3_XRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot3_YRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot3_ZRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot3_XScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot3_YScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot3_ZScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot4_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0', `Slot4_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0', `Slot4_XPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot4_YPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot4_ZPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot4_XRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot4_YRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot4_ZRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot4_XScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot4_YScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot4_ZScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot5_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0', `Slot5_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0', `Slot5_XPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot5_YPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot5_ZPos` float(20,3) NOT NULL DEFAULT '0.000', `Slot5_XRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot5_YRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot5_ZRot` float(20,3) NOT NULL DEFAULT '0.000', `Slot5_XScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot5_YScale` float(20,3) NOT NULL DEFAULT '0.000', `Slot5_ZScale` float(20,3) NOT NULL DEFAULT '0.000' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `vehicles` -- CREATE TABLE `vehicles` ( `ID` mediumint(6) UNSIGNED NOT NULL, `Owner` varchar(24) NOT NULL, `Model` mediumint(6) NOT NULL, `Price` int(10) NOT NULL, `Locked` tinyint(1) NOT NULL DEFAULT '1', `PaintJob` smallint(3) NOT NULL DEFAULT '-1', `Color1` smallint(3) NOT NULL DEFAULT '0', `Color2` smallint(3) NOT NULL DEFAULT '0', `Plate` varchar(12) NOT NULL DEFAULT '*', `Mod1` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod2` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod3` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod4` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod5` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod6` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod7` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod8` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod9` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod10` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod11` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod12` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod13` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod14` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod15` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod16` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Mod17` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `Model_2` mediumint(6) NOT NULL DEFAULT '0', `Price_2` int(10) NOT NULL DEFAULT '0', `Paintjob_2` smallint(3) NOT NULL DEFAULT '-1', `Color1_2` smallint(3) NOT NULL DEFAULT '0', `Color2_2` smallint(3) NOT NULL DEFAULT '0', `Model_3` mediumint(5) NOT NULL DEFAULT '0', `Price_3` int(10) NOT NULL DEFAULT '0', `Paintjob_3` smallint(3) NOT NULL DEFAULT '-1', `Color1_3` smallint(3) NOT NULL DEFAULT '0', `Color2_3` smallint(3) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `web_adminactivity` -- CREATE TABLE `web_adminactivity` ( `reg_id` int(11) NOT NULL, `name` varchar(50) NOT NULL, `time` varchar(20) NOT NULL, `week` int(11) NOT NULL, `year` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_groups_images` -- CREATE TABLE `web_groups_images` ( `groupID` int(11) NOT NULL, `image_uri` varchar(150) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_news` -- CREATE TABLE `web_news` ( `id` int(11) NOT NULL, `posted_by` varchar(100) NOT NULL, `title` varchar(100) NOT NULL, `body` mediumtext NOT NULL, `date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `web_test` -- CREATE TABLE `web_test` ( `name` varchar(30) NOT NULL, `page` varchar(100) NOT NULL, `ip` varchar(20) NOT NULL, `timestamp` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_weeklyhours` -- CREATE TABLE `web_weeklyhours` ( `playerID` int(11) NOT NULL, `admin_name` varchar(40) NOT NULL, `admin_hours` varchar(40) NOT NULL, `year` int(11) NOT NULL, `week` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `achievements` -- ALTER TABLE `achievements` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `activity` -- ALTER TABLE `activity` ADD KEY `reg_id` (`reg_id`); -- -- Indexes for table `adminlog` -- ALTER TABLE `adminlog` ADD KEY `adminid` (`adminid`), ADD KEY `playerid` (`playerid`), ADD KEY `time` (`time`); -- -- Indexes for table `bans` -- ALTER TABLE `bans` ADD PRIMARY KEY (`BanID`); -- -- Indexes for table `groups` -- ALTER TABLE `groups` ADD PRIMARY KEY (`gID`); -- -- Indexes for table `houses` -- ALTER TABLE `houses` ADD PRIMARY KEY (`house_id`), ADD KEY `hname` (`hname`); -- -- Indexes for table `interiors` -- ALTER TABLE `interiors` ADD PRIMARY KEY (`int_name`), ADD KEY `int_name` (`int_name`); -- -- Indexes for table `labels` -- ALTER TABLE `labels` ADD PRIMARY KEY (`id`); -- -- Indexes for table `monthlycomp` -- ALTER TABLE `monthlycomp` ADD PRIMARY KEY (`test`); -- -- Indexes for table `namechanges` -- ALTER TABLE `namechanges` ADD PRIMARY KEY (`num`), ADD KEY `reg_id` (`reg_id`); -- -- Indexes for table `parkourtimes` -- ALTER TABLE `parkourtimes` ADD PRIMARY KEY (`parkourid`); -- -- Indexes for table `pcp_login_attempt` -- ALTER TABLE `pcp_login_attempt` ADD PRIMARY KEY (`la_id`); -- -- Indexes for table `pcp_news` -- ALTER TABLE `pcp_news` ADD PRIMARY KEY (`nw_id`); -- -- Indexes for table `pcp_page_perm` -- ALTER TABLE `pcp_page_perm` ADD PRIMARY KEY (`pp_page`); -- -- Indexes for table `players` -- ALTER TABLE `players` ADD PRIMARY KEY (`reg_id`), ADD KEY `name` (`name`); -- -- Indexes for table `playerstest` -- ALTER TABLE `playerstest` ADD PRIMARY KEY (`test`); -- -- Indexes for table `racetimes` -- ALTER TABLE `racetimes` ADD PRIMARY KEY (`raceid`), ADD KEY `race` (`race`); -- -- Indexes for table `soldhouses` -- ALTER TABLE `soldhouses` ADD PRIMARY KEY (`name`); -- -- Indexes for table `toys` -- ALTER TABLE `toys` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `vehicles` -- ALTER TABLE `vehicles` ADD PRIMARY KEY (`ID`); -- -- Indexes for table `web_news` -- ALTER TABLE `web_news` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `achievements` -- ALTER TABLE `achievements` MODIFY `ID` int(7) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=909183; -- -- AUTO_INCREMENT for table `bans` -- ALTER TABLE `bans` MODIFY `BanID` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Ban ID', AUTO_INCREMENT=16409; -- -- AUTO_INCREMENT for table `groups` -- ALTER TABLE `groups` MODIFY `gID` mediumint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1675; -- -- AUTO_INCREMENT for table `houses` -- ALTER TABLE `houses` MODIFY `house_id` mediumint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=714; -- -- AUTO_INCREMENT for table `labels` -- ALTER TABLE `labels` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `monthlycomp` -- ALTER TABLE `monthlycomp` MODIFY `test` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `namechanges` -- ALTER TABLE `namechanges` MODIFY `num` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20449; -- -- AUTO_INCREMENT for table `parkourtimes` -- ALTER TABLE `parkourtimes` MODIFY `parkourid` smallint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48; -- -- AUTO_INCREMENT for table `pcp_login_attempt` -- ALTER TABLE `pcp_login_attempt` MODIFY `la_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71; -- -- AUTO_INCREMENT for table `pcp_news` -- ALTER TABLE `pcp_news` MODIFY `nw_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `players` -- ALTER TABLE `players` MODIFY `reg_id` int(7) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Players Registration ID', AUTO_INCREMENT=909872; -- -- AUTO_INCREMENT for table `racetimes` -- ALTER TABLE `racetimes` MODIFY `raceid` smallint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253; -- -- AUTO_INCREMENT for table `toys` -- ALTER TABLE `toys` MODIFY `ID` mediumint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101523; -- -- AUTO_INCREMENT for table `vehicles` -- ALTER TABLE `vehicles` MODIFY `ID` mediumint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65603; -- -- AUTO_INCREMENT for table `web_news` -- ALTER TABLE `web_news` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; /*!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 */;