- 0
Вопросы
Лучший ответ
#define mysql_host "" // Это IP нашего хостинга - если на локалке то пишем 127.0.0.1
#define mysql_db "" // Сюда в скобки пишем НАЗВАНИЕ нашей базы данных которую мы создали в Denwer
#define mysql_user "" // Логин базы данных - если на локалке то пишем root
#define mysql_pass "" // Пароль базы данных - если на локалке то оставляем пустым.
Компилируем и так же запускаем и проверяем, вуаяля вот вам ваш сервер с подключенной базой данных...
/*========================================================[MAIN CONFIG]=======================================================*/
#define SERVER_HOSTING false // hosting PC?
#define USE_ACTOR false // use actor?
/*===========================================================[DATA]===========================================================*/
#define PROJECT_NAME !"Server RolePlay"
#define PROJECT_URL_VK !"vk.com/odosenok"
#define PROJECT_URL_SITE !"yandex.ru"
#define SERVER_NAME_MODE "MRP 4.0.1"
#define SERVER_NAME_MAP "Criminal Russia"
#define SERVER_NAME_WEBURL PROJECT_URL_SITE
#define PROJECT_PASSWORD_RCON "1337"
#define PROJECT_PASSWORD 0
#define SERVER_NAME1 !"Название 1"
#define SERVER_NAME2 !"Название 2"
#define SERVER_NAME3 !"Название 3"
#define UPDATE_SERVER_NAME_TIME (4) // tick update server name
/*=======================================================[MySQL SETTINGS]=====================================================*/
#if SERVER_HOSTING == true
#define MYSQL_HOST !"host"
#define MYSQL_USER !"user"
#define MYSQL_PASSWORD !"pass"
#define MYSQL_DATABASE_MAIN !"main"
#define MYSQL_DATABASE_LOGS !"logs"
#else
#define MYSQL_HOST !"localhost"
#define MYSQL_USER !"root"
#define MYSQL_PASSWORD !""
#define MYSQL_DATABASE_MAIN !"main"
#define MYSQL_DATABASE_LOGS !"logs"
#endif
/* main */
#define MYSQL_CHARSET !"cp1251"
#define MYSQL_DABATASE_NAME_MAIN "MAIN" // don't pack!
#define MYSQL_DATABASE_NAME_LOGS "LOGS" // don't pack!
/* log */
#define TABLE_LOG_CONNECT "log_connect"
#define TABLE_LOG_COMMAND "log_command"
#define TABLE_LOG_CHAT "log_chat"
#define TABLE_LOG_ADMIN "log_admin"
/* vehicle */
#define TABLE_VEHICLES "vehicles"
#define TABLE_VEHICLES_PLAYERS "vehicles_players"
#define TABLE_VEHICLES_RENTS "vehicles_rents"
#define TABLE_VEHICLES_FRACS "vehicles_fracs"
#define TABLE_VEHICLES_DATA "vehicles_data"
#define TABLE_VEHICLES_TYPES "vehicle_types"
#define TABLE_VEHICLES_MEMBERS "vehicle_members"
/* player */
/*===================================================[ANTICHEAT & SECURITY]===================================================*/
#define ANTICHEAT_WEAPON true // anticheat of weapon
#define ANTICHEAT_AMMO true // anticheat of ammo
#define ANTICHEAT_MONEY true // anticheat of money
#define ANTICHEAT_HEALTH true // anticheat of health
#define ANTICHEAT_ARMOUR true // anticheat of armour
#define ANTICHEAT_TELEPORT false // anticheat of teleport
#define SECURITY_CENSOR true // activate security censor?
#define SECURITY_ADVERTISE true // activate security advertise (IP)?
#define TIME_ANTIFLOOD_CHAT (2)
#define TIME_ANTIFLOOD_COMMAND (3)
#define CALLBACK_WEAPON true
#define CALLBACK_AMMO true
#define CALLBACK_HEALTH true
#define CALLBACK_ARMOUR true
#define CALLBACK_MONEY false
/*===========================================================[LOGS]===========================================================*/
#define LOG_MYSQL_ERRORS true // log MySQL errors
#define LOG_ADMIN true // log admin actions?
#define LOG_CHAT true // log chat?
#define LOG_COMMAND true // log comamnds?
#define LOG_CONNECT true // log connects?
#define PRINT_ADMIN_ACTIONS false // вывод сообщений администратору о его же действиях
/*==========================================================[PLAYER]==========================================================*/
#if defined MAX_PLAYERS
#undef MAX_PLAYERS
#endif
#define MAX_PLAYERS (100) // max players
/*==========================================================[VEHICLE]=========================================================*/
#if defined MAX_VEHICLES
#undef MAX_VEHICLES
#endif
#define MAX_VEHICLES (200) // max vehicles
#define WRITE_VEHICLE_MANAGE false // write vehicle manage information?
#define VEHICLE_SPEED_UNIT_DEFAULT VEHICLE_SPEED_KMH // or VEHICLE_SPEED_UNIT_MPH
#define MAX_VEHICLES_ADMIN (100)
#define VEHHEALTH_TICK_RATE (300) // tickrate for check update vehicle health (для OnVehicleHealthChanged)
#define MAX_LENGTH_VEHICLE_NUMBER (8) // max length vehicle number plate
#define DEFAULT_VEHICLE_NUMBER "ТРАНЗИТ"
/*==========================================================[DESIGN]==========================================================*/
#if defined MAX_PICKUPS
#undef MAX_PICKUPS
#endif
#define MAX_PICKUPS (300) // max pickups
#define DEFAULT_WEATHER (2)
вот такой вариант рассмотри
Эта тема закрыта для публикации ответов.
-
Последние посетители 0 пользователей онлайн
Ни одного зарегистрированного пользователя не просматривает данную страницу
-
Похожий контент
-
От patrickk
Всем привет, решил написать dm сервер и довольно хорошим получился, даже на голову выше Goat dm. Оставил не решенную проблему тем что у меня есть 4 локации с rp run и cj run ну а как добавить cj бег на те локации не знаю и как эта система работает. Надеюсь мне помогут знающие люди
-
От Samolet
Здраствуйте, cоздаю копию Arizona на ОМП, опен мультиплеер, загрузил и подключил бд, но сервер не хочет вот лог :[2026-10-20T21:03:32+0300] [Info] Log file reloaded. Starting open.mp server (1.5.8.3079) from commit c6759bd8d265171ae3d86598895a23d5a8d92a3b Loading component $CAPI.so Successfully loaded component C-API (1.5.8.3079) with UID 10467dd8d4c56fc6 Loading component LegacyConfig.so Successfully loaded component LegacyConfig (1.5.8.3079) with UID 24ef6216838f9ffc Loading component NPCs.so Successfully loaded component NPCs (1.5.8.3079) with UID 3d0e59e87f4e90bc Loading component Recordings.so Successfully loaded component Recordings (1.5.8.3079) with UID 871144d399f5f613 Loading component Checkpoints.so Successfully loaded component Checkpoints (1.5.8.3079) with UID 44a937350d611dde Loading component TextDraws.so Successfully loaded component TextDraws (1.5.8.3079) with UID 9b5dc2b1d15c992a Loading component Pawn.so Successfully loaded component Pawn (1.5.8.3079) with UID 78906cd9f19c36a6 Loading component GangZones.so Successfully loaded component GangZones (1.5.8.3079) with UID b3351d11ee8d8056 Loading component Actors.so Successfully loaded component Actors (1.5.8.3079) with UID c81ca021eae2ad5c Loading component Pickups.so Successfully loaded component Pickups (1.5.8.3079) with UID cf304faa363dd971 Loading component Dialogs.so Successfully loaded component Dialogs (1.5.8.3079) with UID 44a111350d611dde Loading component Objects.so Successfully loaded component Objects (1.5.8.3079) with UID 59f8415f72da6160 Loading component Console.so Successfully loaded component Console (1.5.8.3079) with UID bfa24e49d0c95ee4 Loading component TextLabels.so Successfully loaded component TextLabels (1.5.8.3079) with UID a0c57ea80a009742 Loading component Variables.so Successfully loaded component Variables (1.5.8.3079) with UID 75e121848bc01fa2 Loading component Databases.so Successfully loaded component Databases (1.5.8.3079) with UID 80092e7eb5821a96 Loading component LegacyNetwork.so Successfully loaded component RakNetLegacyNetwork (1.5.8.3079) with UID ea9799fd79cf8442 Loading component CustomModels.so Successfully loaded component CustomModels (1.5.8.3079) with UID 15e3cb1e7c77ffff Loading component Menus.so Successfully loaded component Menus (1.5.8.3079) with UID 621e219eb97ee0b2 Loading component Vehicles.so Successfully loaded component Vehicles (1.5.8.3079) with UID 3f1f62ee9e22ab19 Loading component Classes.so Successfully loaded component Classes (1.5.8.3079) with UID 8cfb3183976da208 Loading component Timers.so Successfully loaded component Timers (1.5.8.3079) with UID 2ad8124c5ea257a3 Loaded 22 component(s) from /home/gs113492/components Executing Server Config... [2026-10-20T21:03:33+0300] [Info] Loading plugin: crashdetect.so [2026-10-20T21:03:33+0300] [Info] CrashDetect plugin 4.19 [2026-10-20T21:03:33+0300] [Info] Loading plugin: mapandreas.so [2026-10-20T21:03:33+0300] [Info] Loading plugin: streamer.so [2026-10-20T21:03:33+0300] [Info] *** Streamer Plugin v2.9.4 by Incognito loaded *** [2026-10-20T21:03:33+0300] [Info] Loading plugin: sscanf.so [2026-10-20T21:03:33+0300] [Info] [2026-10-20T21:03:33+0300] [Info] =============================== [2026-10-20T21:03:33+0300] [Info] sscanf plugin loaded. [2026-10-20T21:03:33+0300] [Info] Version: 2.8.3 [2026-10-20T21:03:33+0300] [Info] (c) 2018 Alex "Y_Less" Cole [2026-10-20T21:03:33+0300] [Info] =============================== [2026-10-20T21:03:33+0300] [Info] Loading plugin: TOTP.so [2026-10-20T21:03:33+0300] [Info] TOTP plugin v1.0.1 by Games loaded. [2026-10-20T21:03:33+0300] [Info] Loading plugin: mysql_static.so [2026-10-20T21:03:33+0300] [Info] >> plugin.mysql: R39-6 successfully loaded. [2026-10-20T21:03:33+0300] [Info] Loading plugin: libpawn_json.so [2026-10-20T21:03:34+0300] [Error] Function not registered: YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_RegAlias [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_Reset [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_RegHandler [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_Delete [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_New [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_IgnoreBits [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_Init [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_SendRPC [2026-10-20T21:03:34+0300] [Error] Function not registered: PR_SendPacket [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_WriteValue [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Error] Function not registered: BS_ReadValue [2026-10-20T21:03:34+0300] [Error] Function not registered: PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_ReadValue [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Info] [debug] BS_WriteValue [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendPacket [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendRPC [2026-10-20T21:03:34+0300] [Info] [debug] PR_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_IgnoreBits [2026-10-20T21:03:34+0300] [Info] [debug] BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Info] [debug] BS_New [2026-10-20T21:03:34+0300] [Info] [debug] BS_Delete [2026-10-20T21:03:34+0300] [Info] [debug] PR_RegHandler [2026-10-20T21:03:34+0300] [Info] [debug] BS_Reset [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] PC_RegAlias [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] YSF_SetTickRate [2026-10-20T21:03:34+0300] [Error] File or function is not found [2026-10-20T21:03:34+0300] [Info] [debug] Run time error 19: "File or function is not found" [2026-10-20T21:03:34+0300] [Info] [debug] PC_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_ReadValue [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetNumberOfBytesUsed [2026-10-20T21:03:34+0300] [Info] [debug] BS_WriteValue [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendPacket [2026-10-20T21:03:34+0300] [Info] [debug] PR_SendRPC [2026-10-20T21:03:34+0300] [Info] [debug] PR_Init [2026-10-20T21:03:34+0300] [Info] [debug] BS_IgnoreBits [2026-10-20T21:03:34+0300] [Info] [debug] BS_SetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] BS_ResetReadPointer [2026-10-20T21:03:34+0300] [Info] [debug] BS_New [2026-10-20T21:03:34+0300] [Info] [debug] BS_Delete [2026-10-20T21:03:34+0300] [Info] [debug] PR_RegHandler [2026-10-20T21:03:34+0300] [Info] [debug] BS_Reset [2026-10-20T21:03:34+0300] [Info] [debug] BS_GetWriteOffset [2026-10-20T21:03:34+0300] [Info] [debug] PC_RegAlias [2026-10-20T21:03:34+0300] [Info] Legacy Network started on ***.**.**.***:2717. Помогите пожалуйста
-
VadimS Новичок 1
При компиляции выходят 4 предупреждения:
C:\Users\Роман\Desktop\Crmp- сервер\gamemodes\SosnovkaRRP.pwn(37) : warning 213: tag mismatch
C:\Users\Роман\Desktop\Crmp- сервер\gamemodes\SosnovkaRRP.pwn(43) : warning 213: tag mismatch
C:\Users\Роман\Desktop\Crmp- сервер\gamemodes\SosnovkaRRP.pwn(57) : warning 213: tag mismatch
C:\Users\Роман\Desktop\Crmp- сервер\gamemodes\SosnovkaRRP.pwn(58) : warning 213: tag mismatch
На эти строки:
connect = mysql_connect("127.0.0.1", "root", "", "SosnovkaRRP");
mysql_close(connect);
mysql_format(connect, string, sizeof string, "SELECT 1 FROM `users` WHERE `name`='%s'", Player[playerid][P_NAME]);
mysql_tquery(connect, string, "IsPlayerReg", "d", playerid);
Что делать ?
Поделиться сообщением
Ссылка на сообщение