Half-Life Alyx RP (URF) 2022-02-08

да и к тому же я этот файлик уже потерял его где то

 

а дай сам код таблицы на sql и пофикшеный hlalyx urf

CREATE TABLE `custom_physguns` (
`SteamID` bigint(20) NOT NULL,
`Active` int(1) NOT NULL,
`Class` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ну на код одной таблицы как ты и просил)

 

а сборку сам фиксанешь

 

а можиш дать весь код для ирф для бд и фикс

 

а можиш дать весь код для ирф для бд и фикс

Купи у кого-то и не парься

 

держите полный бд

Спойлер

-- phpMyAdmin SQL Dump
-- version 5.2.1deb3
-- phpMyAdmin
--
-- Хост: localhost:3306
-- Время создания: Янв 20 2026 г., 18:57
-- Версия сервера: 8.0.44-0ubuntu0.24.04.2
-- Версия PHP: 8.3.6
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 */;
--
-- База данных: `s37343_magic`
--
CREATE DATABASE IF NOT EXISTS `s37343_magic` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
USE `s37343_magic`;
-- --------------------------------------------------------
--
-- Структура таблицы `autodonate_logs`
--
CREATE TABLE `autodonate_logs` (
`id` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`amount` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`account` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`comment` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`data` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `ba_adminonline`
--
CREATE TABLE `ba_adminonline` (
`Name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`SteamID` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`IPAddress` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`Amount` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `ba_badplayer`
--
CREATE TABLE `ba_badplayer` (
`Name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`SteamID` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`IP` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`Reson` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `ba_bans`
--
CREATE TABLE `ba_bans` (
`steamid` bigint NOT NULL,
`ip` varchar(39) NOT NULL,
`name` varchar(255) NOT NULL,
`reason` varchar(255) NOT NULL,
`a_steamid` bigint NOT NULL,
`a_name` varchar(255) NOT NULL,
`ban_time` int NOT NULL,
`ban_len` int NOT NULL,
`unban_time` int NOT NULL,
`unban_reason` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
--
-- Дамп данных таблицы `ba_bans`
--
INSERT INTO `ba_bans` (`steamid`, `ip`, `name`, `reason`, `a_steamid`, `a_name`, `ban_time`, `ban_len`, `unban_time`, `unban_reason`) VALUES
(90071996842377216, 'Error!', 'Bot01', '1.1', 76561199187770996, 'Hon Peatross', 1675017692, 600, 1675018292, NULL),
(76561199230652199, '178.37.140.178:27005', 'Tabith Hochhauser', 'Ð§Ñ Ð¿Ñ€Ð¾ÐµÐºÑ‚Ð°', 76561199143888294, 'Ucan', 1675679843, 0, 0, NULL);
-- --------------------------------------------------------
--
-- Структура таблицы `ba_cheaters`
--
CREATE TABLE `ba_cheaters` (
`steamid` bigint NOT NULL,
`date` int NOT NULL,
`infractions` text NOT NULL,
`screengrab` longblob NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `ba_hashlog`
--
CREATE TABLE `ba_hashlog` (
`steamid` bigint NOT NULL,
`lastseen` int NOT NULL,
`hashid` char(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Дамп данных таблицы `ba_hashlog`
--
INSERT INTO `ba_hashlog` (`steamid`, `lastseen`, `hashid`) VALUES
(76561199187770996, 1675684832, 'd7b4c968ac40c63d55095d178d2f2be8504a40a17d4831f4a9a04b9f0b8e9d9a'),
(76561199230652199, 1675679186, '2f853286b5dbc730fa38cc8d99be2c2572e6e73f54bdd9ed76afa0424b5a236a');
-- --------------------------------------------------------
--
-- Структура таблицы `ba_iplog`
--
CREATE TABLE `ba_iplog` (
`steamid` bigint NOT NULL,
`lastseen` int NOT NULL,
`ip` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Дамп данных таблицы `ba_iplog`
--
INSERT INTO `ba_iplog` (`steamid`, `lastseen`, `ip`) VALUES
(76561199187770996, 1675093333, '85.115.248.171'),
(76561199187770996, 1675684805, '85.115.248.111');
-- --------------------------------------------------------
--
-- Структура таблицы `ba_keys`
--
CREATE TABLE `ba_keys` (
`Date` int NOT NULL,
`Key` varchar(64) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Структура таблицы `ba_ranks`
--
CREATE TABLE `ba_ranks` (
`steamid` bigint NOT NULL,
`sv_id` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1',
`rank` tinyint NOT NULL,
`expire_rank` tinyint NOT NULL,
`expire_time` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Структура таблицы `ba_rating`
--
CREATE TABLE `ba_rating` (
`steamid` bigint NOT NULL,
`nameid` text NOT NULL,
`rate` bigint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Дамп данных таблицы `ba_rating`
--
INSERT INTO `ba_rating` (`steamid`, `nameid`, `rate`) VALUES
(76561198118891587, 'Sakiso Baki', 5),
(76561199187770996, 'ИнфернуÑ', 11);
-- --------------------------------------------------------
--
-- Структура таблицы `ba_ratinglogs`
--
CREATE TABLE `ba_ratinglogs` (
`a_steamid` bigint NOT NULL,
`rate` tinyint(1) NOT NULL,
`data` bigint NOT NULL,
`p_steamid` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Дамп данных таблицы `ba_ratinglogs`
--
INSERT INTO `ba_ratinglogs` (`a_steamid`, `rate`, `data`, `p_steamid`) VALUES
(76561199187770996, 1, 1675085647, 76561198163566508),
(76561199143888294, 5, 1675676502, 76561198930700327);
-- --------------------------------------------------------
--
-- Структура таблицы `ba_server_vars`
--
CREATE TABLE `ba_server_vars` (
`sv_uid` bigint NOT NULL,
`var` varchar(50) NOT NULL,
`data` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Дамп данных таблицы `ba_server_vars`
--
INSERT INTO `ba_server_vars` (`sv_uid`, `var`, `data`) VALUES
(1741413904, 'adminroom', '{v-1514.9920654297,1950.4935302734,64.03125;~}'),
(3656605284, 'adminroom', '{v-1524.9011230469,1955.0354003906,64.03125;~}');
-- --------------------------------------------------------
--
-- Структура таблицы `ba_users`
--
CREATE TABLE `ba_users` (
`steamid` bigint NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`firstjoined` int DEFAULT NULL,
`lastseen` int NOT NULL,
`playtime` int DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
--
-- Дамп данных таблицы `ba_users`
--
INSERT INTO `ba_users` (`steamid`, `name`, `firstjoined`, `lastseen`, `playtime`) VALUES
(76561199187770996, 'ИнфернуÑ', 1675001821, 1675685910, 7245330),
(76561198188947733, 'Леон Бручо', 1675677239, 1675677871, 631);
-- --------------------------------------------------------
--
-- Структура таблицы `ba_warn`
--
CREATE TABLE `ba_warn` (
`Name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`SteamID` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`IPAddress` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`Amount` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `ba_warns`
--
CREATE TABLE `ba_warns` (
`steamid` bigint NOT NULL,
`warns` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `custom_physguns`
--
CREATE TABLE `custom_physguns` (
`SteamID` bigint NOT NULL,
`Active` int NOT NULL,
`Class` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `custom_playtime`
--
CREATE TABLE `custom_playtime` (
`id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
`steamid` bigint NOT NULL,
`time` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
--
-- Дамп данных таблицы `custom_playtime`
--
INSERT INTO `custom_playtime` (`id`, `steamid`, `time`) VALUES
('j:king_els', 76561199234066580, 3),
('j:sword_guard', 76561199234066580, 3),
('QEntities', 76561199234066580, 3);
-- --------------------------------------------------------
--
-- Структура таблицы `custom_toolguns`
--
CREATE TABLE `custom_toolguns` (
`SteamID` bigint NOT NULL,
`Active` int NOT NULL,
`Class` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `dupes`
--
CREATE TABLE `dupes` (
`steamid` varchar(64) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`dupe` text,
`original_pos` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `fps_log`
--
CREATE TABLE `fps_log` (
`time` int NOT NULL,
`steamid` bigint NOT NULL,
`fps` int NOT NULL,
`fps_config` int NOT NULL,
`players` int NOT NULL,
`playtime` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Дамп данных таблицы `fps_log`
--
INSERT INTO `fps_log` (`time`, `steamid`, `fps`, `fps_config`, `players`, `playtime`) VALUES
(1768934845, 76561199234066580, 133, 0, 1, 15),
(1768935144, 76561199234066580, 136, 0, 1, 15);
-- --------------------------------------------------------
--
-- Структура таблицы `global_chat`
--
CREATE TABLE `global_chat` (
`Server` varchar(50) NOT NULL,
`Color` int NOT NULL,
`Name` varchar(50) NOT NULL,
`Message` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `global_ranks_given`
--
CREATE TABLE `global_ranks_given` (
`steamid` bigint NOT NULL,
`rank` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`active_until` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `halloween_temp_presents`
--
CREATE TABLE `halloween_temp_presents` (
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`steamid` bigint NOT NULL,
`present_type` int NOT NULL,
`present_id` varchar(32) NOT NULL,
`expire_time` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `inventories`
--
CREATE TABLE `inventories` (
`_invID` int UNSIGNED NOT NULL,
`_charID` bigint UNSIGNED NOT NULL,
`_invType` varchar(24) DEFAULT NULL,
`_width` int DEFAULT NULL,
`_height` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Дамп данных таблицы `inventories`
--
INSERT INTO `inventories` (`_invID`, `_charID`, `_invType`, `_width`, `_height`) VALUES
(5, 76561199234066580, 'player', 5, 5);
-- --------------------------------------------------------
--
-- Структура таблицы `items`
--
CREATE TABLE `items` (
`_itemID` int UNSIGNED NOT NULL,
`_invID` int UNSIGNED NOT NULL,
`_uniqueID` varchar(60) NOT NULL,
`_data` varchar(500) DEFAULT NULL,
`_x` smallint NOT NULL,
`_y` smallint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `job_recovery`
--
CREATE TABLE `job_recovery` (
`steamid` bigint NOT NULL,
`job` varchar(255) DEFAULT NULL,
`ip` varchar(255) DEFAULT NULL,
`mdldata` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `job_whitelist`
--
CREATE TABLE `job_whitelist` (
`steamid` bigint NOT NULL,
`job_id` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `kload_sessions`
--
CREATE TABLE `kload_sessions` (
`steamid` bigint NOT NULL COMMENT 'steamid, e.g. 76561198218213083',
`token` varchar(64) NOT NULL COMMENT 'csrf token',
`expires` timestamp NULL DEFAULT NULL COMMENT 'date at which token is invalid'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `kload_settings`
--
CREATE TABLE `kload_settings` (
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `kload_users`
--
CREATE TABLE `kload_users` (
`id` int UNSIGNED NOT NULL,
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'steam name',
`steamid` bigint NOT NULL COMMENT 'steamid, e.g. 76561198218213083',
`steamid2` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'steam2 id, e.g. STEAM_...',
`steamid3` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'steam3 id, e.g. [U:1:...',
`admin` tinyint(1) DEFAULT '0' COMMENT 'is the user an admin?',
`perms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'list of perms, inactive when admin = 0',
`settings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'user settings in JSON',
`custom_css` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'user css for styling',
`banned` tinyint(1) DEFAULT '0' COMMENT 'is the user banned?',
`registered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'date when joined'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `kshop_credits_transactions`
--
CREATE TABLE `kshop_credits_transactions` (
`Time` bigint DEFAULT NULL,
`SteamID` varchar(40) DEFAULT NULL,
`Change` int DEFAULT NULL,
`Note` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Структура таблицы `kshop_currency_conversions`
--
CREATE TABLE `kshop_currency_conversions` (
`currency` char(3) NOT NULL DEFAULT '',
`rate` float NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `kshop_ipn_transactions`
--
CREATE TABLE `kshop_ipn_transactions` (
`pay_status` varchar(32) NOT NULL,
`payer_email` varchar(128) NOT NULL,
`custom` varchar(20) NOT NULL,
`amount` float NOT NULL,
`currency` varchar(8) NOT NULL,
`txn_id` varchar(64) NOT NULL,
`txn_type` varchar(32) NOT NULL,
`first_name` varchar(64) DEFAULT NULL,
`last_name` varchar(64) DEFAULT NULL,
`parent_txn_id` varchar(64) DEFAULT NULL,
`timestamp` double DEFAULT '0',
`net` float DEFAULT '0',
`receiver_email` varchar(128) DEFAULT 'superiorgmodservers@gmail.com'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Структура таблицы `kshop_purchases`
--
CREATE TABLE `kshop_purchases` (
`Time` bigint DEFAULT NULL,
`SteamID` varchar(40) DEFAULT NULL,
`Upgrade` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Структура таблицы `kshop_servers`
--
CREATE TABLE `kshop_servers` (
`HostID` bigint UNSIGNED NOT NULL DEFAULT '0',
`Address` varchar(30) DEFAULT NULL,
`HostName` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Структура таблицы `like_reascts`
--
CREATE TABLE `like_reascts` (
`ReactorID` bigint NOT NULL,
`TargetID` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `lootables`
--
CREATE TABLE `lootables` (
`Model` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`Vector` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`Angle` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`Count` int NOT NULL,
`Type` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`HideWhenEmpty` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `ny_gift_cooldowns`
--
CREATE TABLE `ny_gift_cooldowns` (
`steamid` bigint NOT NULL,
`cooldown` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `orgs`
--
CREATE TABLE `orgs` (
`Owner` bigint NOT NULL,
`Name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`Color` char(9) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`MoTD` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`Flag` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Дамп данных таблицы `orgs`
--
INSERT INTO `orgs` (`Owner`, `Name`, `Color`, `MoTD`, `Flag`) VALUES
(76561199187770996, 'DEVELOPERS', '#000000', 'Клан разработчиков.', 'xywaoGw'),
(76561199143888294, 'Пидоры', '#FFFFFF', 'Welcome to Пидоры!', '<blockquote class=\"imgur-embed-pub\" lang=\"en\" data-id=\"a/iMRGQDs\" ><a href=\"//imgur.com/a/iMRGQDs\">Simplified Welsh Flag</a></blockquote><script async src=\"//s.imgur.com/min/embed.js\" charset=\"utf-8\"></script>'),
(76561199234066580, '123123', '#7C78EC', 'Welcome to 123123!', ''),
(76561199234066580, '123123123', '#89CBEB', 'Welcome to 123123123!', ''),
(76561199234066580, '123', '#FFC4E4', 'Welcome to 123!', ''),
(76561199234066580, 'weqweqwe', '#85D5AA', 'Welcome to weqweqwe!', '');
-- --------------------------------------------------------
--
-- Структура таблицы `orgs_log`
--
CREATE TABLE `orgs_log` (
`ActID` int NOT NULL,
`Org` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`Actor` bigint NOT NULL,
`Data` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `org_banner`
--
CREATE TABLE `org_banner` (
`Org` varchar(80) NOT NULL,
`Time` bigint DEFAULT NULL,
`Data` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Структура таблицы `org_player`
--
CREATE TABLE `org_player` (
`SteamID` bigint NOT NULL,
`Org` text NOT NULL,
`Rank` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
--
-- Дамп данных таблицы `org_player`
--
INSERT INTO `org_player` (`SteamID`, `Org`, `Rank`) VALUES
(76561199187770996, 'DEVELOPERS', 'Создатель Ñервера'),
(76561198843110963, 'DEVELOPERS', 'Младший разработчик');
-- --------------------------------------------------------
--
-- Структура таблицы `org_rank`
--
CREATE TABLE `org_rank` (
`Org` text NOT NULL,
`RankName` text NOT NULL,
`Weight` int NOT NULL,
`Invite` tinyint(1) NOT NULL,
`Kick` tinyint(1) NOT NULL,
`Rank` tinyint(1) NOT NULL,
`MoTD` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
--
-- Дамп данных таблицы `org_rank`
--
INSERT INTO `org_rank` (`Org`, `RankName`, `Weight`, `Invite`, `Kick`, `Rank`, `MoTD`) VALUES
('DEVELOPERS', 'Создатель Ñервера', 100, 1, 1, 1, 1),
('Пидоры', 'Member', 1, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Структура таблицы `permaprops`
--
CREATE TABLE `permaprops` (
`id` int NOT NULL,
`map` text NOT NULL,
`content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `perma_customjobs`
--
CREATE TABLE `perma_customjobs` (
`SteamID` bigint NOT NULL,
`key` text COLLATE utf8mb3_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `players_online`
--
CREATE TABLE `players_online` (
`steamid` bigint NOT NULL,
`server_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
-- --------------------------------------------------------
--
-- Структура таблицы `player_data`
--
CREATE TABLE `player_data` (
`SteamID` bigint NOT NULL,
`Name` varchar(50) NOT NULL,
`Money` int NOT NULL,
`Achs` text NOT NULL,
`Pocket` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
--
-- Дамп данных таблицы `player_data`
--
INSERT INTO `player_data` (`SteamID`, `Name`, `Money`, `Achs`, `Pocket`) VALUES
(76561199187770996, 'Infernus', 12860374, '{\"100768792\":6.0,\"415845005\":13.0}', '{}'),
(76561199230652199, 'Tabith Hochhauser', 25000, '[]', '{}');
-- --------------------------------------------------------
--
-- Структура таблицы `player_emoji`
--
CREATE TABLE `player_emoji` (
`steamid` bigint NOT NULL,
`emoji_id` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `player_hats`
--
CREATE TABLE `player_hats` (
`SteamID` bigint NOT NULL,
`Model` varchar(255) NOT NULL,
`Active` tinyint NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `pp_blockedtools`
--
CREATE TABLE `pp_blockedtools` (
`Tool` varchar(50) NOT NULL,
`Rank` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `pp_whitelist`
--
CREATE TABLE `pp_whitelist` (
`Model` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `rp_doordata`
--
CREATE TABLE `rp_doordata` (
`Index` int NOT NULL,
`Map` varchar(50) NOT NULL,
`Title` varchar(50) DEFAULT NULL,
`Team` varchar(50) DEFAULT NULL,
`Group` varchar(50) DEFAULT NULL,
`Ownable` int DEFAULT NULL,
`Locked` int DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `rp_jobspawn`
--
CREATE TABLE `rp_jobspawn` (
`id` int NOT NULL,
`job` char(30) NOT NULL,
`map` varchar(45) NOT NULL,
`x` int NOT NULL,
`y` int NOT NULL,
`z` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `saved_timemultipliers`
--
CREATE TABLE `saved_timemultipliers` (
`steamid` bigint NOT NULL,
`id` varchar(20) NOT NULL,
`value` int NOT NULL,
`until` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `social_discord_current`
--
CREATE TABLE `social_discord_current` (
`discord_id` varchar(32) NOT NULL,
`steamid` bigint NOT NULL,
`mode` int NOT NULL,
`value` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `social_info`
--
CREATE TABLE `social_info` (
`social_id` varchar(32) NOT NULL,
`value` varchar(64) NOT NULL,
`steamid` bigint DEFAULT NULL,
`promo` varchar(16) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `steamgroupawards`
--
CREATE TABLE `steamgroupawards` (
`Name` text NOT NULL,
`SteamID64` bigint DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Структура таблицы `warn_system`
--
CREATE TABLE `warn_system` (
`SteamID` bigint NOT NULL,
`Count` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
--
-- Индексы сохранённых таблиц
--
--
-- Индексы таблицы `ba_hashlog`
--
ALTER TABLE `ba_hashlog`
ADD PRIMARY KEY (`steamid`,`hashid`);
--
-- Индексы таблицы `ba_iplog`
--
ALTER TABLE `ba_iplog`
ADD PRIMARY KEY (`steamid`,`ip`);
--
-- Индексы таблицы `ba_keys`
--
ALTER TABLE `ba_keys`
ADD PRIMARY KEY (`Date`,`Key`);
--
-- Индексы таблицы `ba_ranks`
--
ALTER TABLE `ba_ranks`
ADD PRIMARY KEY (`steamid`,`sv_id`);
--
-- Индексы таблицы `ba_rating`
--
ALTER TABLE `ba_rating`
ADD PRIMARY KEY (`steamid`);
--
-- Индексы таблицы `ba_server_vars`
--
ALTER TABLE `ba_server_vars`
ADD PRIMARY KEY (`sv_uid`,`var`);
--
-- Индексы таблицы `ba_users`
--
ALTER TABLE `ba_users`
ADD PRIMARY KEY (`steamid`),
ADD KEY `steamid` (`steamid`);
--
-- Индексы таблицы `ba_warns`
--
ALTER TABLE `ba_warns`
ADD PRIMARY KEY (`steamid`);
--
-- Индексы таблицы `custom_physguns`
--
ALTER TABLE `custom_physguns`
ADD PRIMARY KEY (`SteamID`);
--
-- Индексы таблицы `custom_playtime`
--
ALTER TABLE `custom_playtime`
ADD PRIMARY KEY (`id`,`steamid`);
--
-- Индексы таблицы `custom_toolguns`
--
ALTER TABLE `custom_toolguns`
ADD PRIMARY KEY (`SteamID`);
--
-- Индексы таблицы `global_ranks_given`
--
ALTER TABLE `global_ranks_given`
ADD PRIMARY KEY (`steamid`);
--
-- Индексы таблицы `inventories`
--
ALTER TABLE `inventories`
ADD PRIMARY KEY (`_invID`);
--
-- Индексы таблицы `items`
--
ALTER TABLE `items`
ADD PRIMARY KEY (`_itemID`);
--
-- Индексы таблицы `job_recovery`
--
ALTER TABLE `job_recovery`
ADD PRIMARY KEY (`steamid`);
--
-- Индексы таблицы `job_whitelist`
--
ALTER TABLE `job_whitelist`
ADD PRIMARY KEY (`steamid`,`job_id`);
--
-- Индексы таблицы `kload_sessions`
--
ALTER TABLE `kload_sessions`
ADD UNIQUE KEY `steamid` (`steamid`),
ADD UNIQUE KEY `token` (`token`);
--
-- Индексы таблицы `kload_settings`
--
ALTER TABLE `kload_settings`
ADD UNIQUE KEY `name` (`name`);
--
-- Индексы таблицы `kload_users`
--
ALTER TABLE `kload_users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `kload_users_index` (`steamid`,`steamid2`,`steamid3`);
--
-- Индексы таблицы `kshop_currency_conversions`
--
ALTER TABLE `kshop_currency_conversions`
ADD PRIMARY KEY (`currency`);
--
-- Индексы таблицы `kshop_servers`
--
ALTER TABLE `kshop_servers`
ADD PRIMARY KEY (`HostID`);
--
-- Индексы таблицы `ny_gift_cooldowns`
--
ALTER TABLE `ny_gift_cooldowns`
ADD PRIMARY KEY (`steamid`);
--
-- Индексы таблицы `org_banner`
--
ALTER TABLE `org_banner`
ADD PRIMARY KEY (`Org`);
--
-- Индексы таблицы `permaprops`
--
ALTER TABLE `permaprops`
ADD PRIMARY KEY (`id`);
--
-- Индексы таблицы `players_online`
--
ALTER TABLE `players_online`
ADD PRIMARY KEY (`steamid`);
--
-- Индексы таблицы `player_emoji`
--
ALTER TABLE `player_emoji`
ADD PRIMARY KEY (`steamid`);
--
-- Индексы таблицы `player_hats`
--
ALTER TABLE `player_hats`
ADD PRIMARY KEY (`SteamID`,`Model`);
--
-- Индексы таблицы `pp_blockedtools`
--
ALTER TABLE `pp_blockedtools`
ADD PRIMARY KEY (`Tool`);
--
-- Индексы таблицы `pp_whitelist`
--
ALTER TABLE `pp_whitelist`
ADD PRIMARY KEY (`Model`);
--
-- Индексы таблицы `rp_doordata`
--
ALTER TABLE `rp_doordata`
ADD PRIMARY KEY (`Index`,`Map`);
--
-- Индексы таблицы `rp_jobspawn`
--
ALTER TABLE `rp_jobspawn`
ADD PRIMARY KEY (`id`);
--
-- Индексы таблицы `saved_timemultipliers`
--
ALTER TABLE `saved_timemultipliers`
ADD PRIMARY KEY (`steamid`,`id`);
--
-- Индексы таблицы `social_discord_current`
--
ALTER TABLE `social_discord_current`
ADD PRIMARY KEY (`discord_id`,`mode`);
--
-- Индексы таблицы `social_info`
--
ALTER TABLE `social_info`
ADD PRIMARY KEY (`social_id`,`value`);
--
-- Индексы таблицы `warn_system`
--
ALTER TABLE `warn_system`
ADD PRIMARY KEY (`SteamID`);
--
-- AUTO_INCREMENT для сохранённых таблиц
--
--
-- AUTO_INCREMENT для таблицы `inventories`
--
ALTER TABLE `inventories`
MODIFY `_invID` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT для таблицы `items`
--
ALTER TABLE `items`
MODIFY `_itemID` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=190;
--
-- AUTO_INCREMENT для таблицы `kload_users`
--
ALTER TABLE `kload_users`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;
/*!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 */;