// Developers notes /* # Coding guideline * Add +1 at the end of array declarations to visually account for null bit. * Always log first. * Always notify discord last. * Always wait for other queries to finish before initiating one: "sql_wait(sqlHandle); // Wait for other queries to finish" * Delete GVar strings as soon as possible, but at least before the player quits or the gamemode exits, as per: https://forum.sa-mp.com/showthread.php?t=151076 */ /* # Style guide * GLOBAL_CONSTANT * local_variable * someFunction * SomeClass */ /* # Adding a discord bot to your guild. https://discordapp.com/oauth2/authorize?client_id=%CLIENT_ID%&scope=bot&permissions=3072 Where %CLEINT_ID% is the client id. */ /* # To do: * Add geoiplib, to make connect messages fancier, and add a locate command. * Show underscores as spaces and convert spaces in changename input to undescores before regex chack. * Add table for bans and kicks. * Vip limit on characters. */ /// Global definitions // Colours /* #define COLOR_GREEN 0x33AA33AA #define COLOR_YELLOW 0xFFFF00AA #define COLOR_WHITE 0xFFFFFFAA #define COLOR_BLUE 0x0000BBAA #define COLOR_LIGHTBLUE 0x33CCFFAA #define COLOR_ORANGE 0xFF9900AA #define COLOR_RED 0xAA3333AA #define COLOR_LIME 0x10F441AA #define COLOR_NAVY 0x000080AA #define COLOR_AQUA 0xF0F8FFAA #define COLOR_CRIMSON 0xDC143CAA #define COLOR_BISQUE 0xFFE4C4AA #define COLOR_BLACK 0x000000AA #define COLOR_CHARTREUSE 0x7FFF00AA #define COLOR_BROWN 0XA52A2AAA #define COLOR_CORAL 0xFF7F50AA #define COLOR_GOLD 0xB8860BAA #define COLOR_GREENYELLOW 0xADFF2FAA #define COLOR_INDIGO 0x4B00B0AA #define COLOR_IVORY 0xFFFF82AA #define COLOR_LAWNGREEN 0x7CFC00AA #define COLOR_SEAGREEN 0x20B2AAAA #define COLOR_SEAGREEN 0x2E8B57AA #define COLOR_LIMEGREEN 0x32CD32AA //<--- Dark lime #define COLOR_MIDNIGHTBLUE 0X191970AA #define COLOR_MAROON 0x800000AA #define COLOR_OLIVE 0x808000AA #define COLOR_ORANGERED 0xFF4500AA #define COLOR_PINK 0xFFC0CBAA // - Light light pink #define COLOR_SPRINGGREEN 0x00FF7FAA #define COLOR_TOMATO 0xFF6347AA // - Tomato >:/ sounds wrong lol... well... :P #define COLOR_YELLOWGREEN 0x9ACD32AA //- like military green #define COLOR_MEDIUMAQUA 0x83BFBFAA #define COLOR_MEDIUMMAGENTA 0x8B008BAA // dark magenta ^^ */ #define COLOR_ACTIVEBORDER 0xB4B4B4FF #define COLOR_ACTIVECAPTION 0x99B4D1FF #define COLOR_ACTIVECAPTIONTEXT 0x000000FF #define COLOR_ALICEBLUE 0xF0F8FFFF #define COLOR_ANTIQUEWHITE 0xFAEBD7FF #define COLOR_APPWORKSPACE 0xABABABFF #define COLOR_AQUA 0x00FFFFFF #define COLOR_AQUAMARINE 0x7FFFD4FF #define COLOR_AZURE 0xF0FFFFFF #define COLOR_BEIGE 0xF5F5DCFF #define COLOR_BISQUE 0xFFE4C4FF #define COLOR_BLACK 0x000000FF #define COLOR_BLANCHEDALMOND 0xFFEBCDFF #define COLOR_BLUE 0x0000FFFF #define COLOR_BLUEVIOLET 0x8A2BE2FF #define COLOR_BROWN 0xA52A2AFF #define COLOR_BURLYWOOD 0xDEB887FF #define COLOR_BUTTONFACE 0xF0F0F0FF #define COLOR_BUTTONHIGHLIGHT 0xFFFFFFFF #define COLOR_BUTTONSHADOW 0xA0A0A0FF #define COLOR_CADETBLUE 0x5F9EA0FF #define COLOR_CHARTREUSE 0x7FFF00FF #define COLOR_CHOCOLATE 0xD2691EFF #define COLOR_CONTROL 0xF0F0F0FF #define COLOR_CONTROLDARK 0xA0A0A0FF #define COLOR_CONTROLDARKDARK 0x696969FF #define COLOR_CONTROLLIGHT 0xE3E3E3FF #define COLOR_CONTROLLIGHTLIGHT 0xFFFFFFFF #define COLOR_CONTROLTEXT 0x000000FF #define COLOR_CORAL 0xFF7F50FF #define COLOR_CORNFLOWERBLUE 0x6495EDFF #define COLOR_CORNSILK 0xFFF8DCFF #define COLOR_CRIMSON 0xDC143CFF #define COLOR_CYAN 0x00FFFFFF #define COLOR_DARKBLUE 0x00008BFF #define COLOR_DARKCYAN 0x008B8BFF #define COLOR_DARKGOLDENROD 0xB8860BFF #define COLOR_DARKGRAY 0xA9A9A9FF #define COLOR_DARKGREEN 0x006400FF #define COLOR_DARKKHAKI 0xBDB76BFF #define COLOR_DARKMAGENTA 0x8B008BFF #define COLOR_DARKOLIVEGREEN 0x556B2FFF #define COLOR_DARKORANGE 0xFF8C00FF #define COLOR_DARKORCHID 0x9932CCFF #define COLOR_DARKRED 0x8B0000FF #define COLOR_DARKSALMON 0xE9967AFF #define COLOR_DARKSEAGREEN 0x8FBC8BFF #define COLOR_DARKSLATEBLUE 0x483D8BFF #define COLOR_DARKSLATEGRAY 0x2F4F4FFF #define COLOR_DARKTURQUOISE 0x00CED1FF #define COLOR_DARKVIOLET 0x9400D3FF #define COLOR_DEEPPINK 0xFF1493FF #define COLOR_DEEPSKYBLUE 0x00BFFFFF #define COLOR_DEFAULT_CHAT 0xFFFFFFFF #define COLOR_DESKTOP 0x000000FF #define COLOR_DIMGRAY 0x696969FF #define COLOR_DODGERBLUE 0x1E90FFFF #define COLOR_FIREBRICK 0xB22222FF #define COLOR_FLBLUE 0x6495EDAA #define COLOR_FLORALWHITE 0xFFFAF0FF #define COLOR_FORESTGREEN 0x228B22FF #define COLOR_GAINSBORO 0xDCDCDCFF #define COLOR_GHOSTWHITE 0xF8F8FFFF #define COLOR_GOLD 0xFFD700FF #define COLOR_GOLDENROD 0xDAA520FF #define COLOR_GRADIENTACTIVECAPTION 0xB9D1EAFF #define COLOR_GRADIENTINACTIVECAPTION 0xD7E4F2FF #define COLOR_GRAY 0x808080FF #define COLOR_GRAYTEXT 0x808080FF #define COLOR_GREEN 0x008000FF #define COLOR_GREENYELLOW 0xADFF2FFF #define COLOR_GREY 0xAFAFAFAA #define COLOR_HIGHLIGHT 0x3399FFFF #define COLOR_HIGHLIGHTTEXT 0xFFFFFFFF #define COLOR_HONEYDEW 0xF0FFF0FF #define COLOR_HOTPINK 0xFF69B4FF #define COLOR_HOTTRACK 0x0066CCFF #define COLOR_INACTIVEBORDER 0xF4F7FCFF #define COLOR_INACTIVECAPTION 0xBFCDDBFF #define COLOR_INACTIVECAPTIONTEXT 0x434E54FF #define COLOR_INDIANRED 0xCD5C5CFF #define COLOR_INDIGO 0x4B0082FF #define COLOR_INFO 0xFFFFE1FF #define COLOR_INFOTEXT 0x000000FF #define COLOR_IVORY 0xFFFFF0FF #define COLOR_KHAKI 0xF0E68CFF #define COLOR_LAVENDER 0xE6E6FAFF #define COLOR_LAVENDERBLUSH 0xFFF0F5FF #define COLOR_LAWNGREEN 0x7CFC00FF #define COLOR_LEMONCHIFFON 0xFFFACDFF #define COLOR_LIGHTBLUE 0xADD8E6FF #define COLOR_LIGHTCORAL 0xF08080FF #define COLOR_LIGHTCYAN 0xE0FFFFFF #define COLOR_LIGHTGOLDENRODYELLOW 0xFAFAD2FF #define COLOR_LIGHTGRAY 0xD3D3D3FF #define COLOR_LIGHTGREEN 0x90EE90FF #define COLOR_LIGHTPINK 0xFFB6C1FF #define COLOR_LIGHTSALMON 0xFFA07AFF #define COLOR_LIGHTSEAGREEN 0x20B2AAFF #define COLOR_LIGHTSKYBLUE 0x87CEFAFF #define COLOR_LIGHTSLATEGRAY 0x778899FF #define COLOR_LIGHTSTEELBLUE 0xB0C4DEFF #define COLOR_LIGHTYELLOW 0xFFFFE0FF #define COLOR_LIME 0x00FF00FF #define COLOR_LIMEGREEN 0x32CD32FF #define COLOR_LINEN 0xFAF0E6FF #define COLOR_MAGENTA 0xFF00FFFF #define COLOR_MAROON 0x800000FF #define COLOR_MEDIUMAQUAMARINE 0x66CDAAFF #define COLOR_MEDIUMBLUE 0x0000CDFF #define COLOR_MEDIUMORCHID 0xBA55D3FF #define COLOR_MEDIUMPURPLE 0x9370DBFF #define COLOR_MEDIUMSEAGREEN 0x3CB371FF #define COLOR_MEDIUMSLATEBLUE 0x7B68EEFF #define COLOR_MEDIUMSPRINGGREEN 0x00FA9AFF #define COLOR_MEDIUMTURQUOISE 0x48D1CCFF #define COLOR_MEDIUMVIOLETRED 0xC71585FF #define COLOR_MENU 0xF0F0F0FF #define COLOR_MENUBAR 0xF0F0F0FF #define COLOR_MENUHIGHLIGHT 0x3399FFFF #define COLOR_MENUTEXT 0x000000FF #define COLOR_MIDNIGHTBLUE 0x191970FF #define COLOR_MINTCREAM 0xF5FFFAFF #define COLOR_MISTYROSE 0xFFE4E1FF #define COLOR_MOCCASIN 0xFFE4B5FF #define COLOR_NAVAJOWHITE 0xFFDEADFF #define COLOR_NAVY 0x000080FF #define COLOR_OLDLACE 0xFDF5E6FF #define COLOR_OLIVE 0x808000FF #define COLOR_OLIVEDRAB 0x6B8E23FF #define COLOR_ORANGE 0xFFA500FF #define COLOR_ORANGERED 0xFF4500FF #define COLOR_ORCHID 0xDA70D6FF #define COLOR_PALEGOLDENROD 0xEEE8AAFF #define COLOR_PALEGREEN 0x98FB98FF #define COLOR_PALETURQUOISE 0xAFEEEEFF #define COLOR_PALEVIOLETRED 0xDB7093FF #define COLOR_PAPAYAWHIP 0xFFEFD5FF #define COLOR_PEACHPUFF 0xFFDAB9FF #define COLOR_PERU 0xCD853FFF #define COLOR_PINK 0xFFC0CBFF #define COLOR_PLUM 0xDDA0DDFF #define COLOR_POWDERBLUE 0xB0E0E6FF #define COLOR_PURPLE 0x800080FF #define COLOR_RED 0xFF0000FF #define COLOR_ROSYBROWN 0xBC8F8FFF #define COLOR_ROYALBLUE 0x4169E1FF #define COLOR_SADDLEBROWN 0x8B4513FF #define COLOR_SALMON 0xFA8072FF #define COLOR_SANDYBROWN 0xF4A460FF #define COLOR_SCROLLBAR 0xC8C8C8FF #define COLOR_SEAGREEN 0x2E8B57FF #define COLOR_SEASHELL 0xFFF5EEFF #define COLOR_SIENNA 0xA0522DFF #define COLOR_SILVER 0xC0C0C0FF #define COLOR_SKYBLUE 0x87CEEBFF #define COLOR_SLATEBLUE 0x6A5ACDFF #define COLOR_SLATEGRAY 0x708090FF #define COLOR_SNOW 0xFFFAFAFF #define COLOR_SPRINGGREEN 0x00FF7FFF #define COLOR_STEELBLUE 0x4682B4FF #define COLOR_TAN 0xD2B48CFF #define COLOR_TEAL 0x008080FF #define COLOR_THISTLE 0xD8BFD8FF #define COLOR_TOMATO 0xFF6347FF #define COLOR_TRANSPARENT 0xFFFFFF00 #define COLOR_TURQUOISE 0x40E0D0FF #define COLOR_VIOLET 0xEE82EEFF #define COLOR_WHEAT 0xF5DEB3FF #define COLOR_WHITE 0xFFFFFFFF #define COLOR_WHITESMOKE 0xF5F5F5FF #define COLOR_WINDOW 0xFFFFFFFF #define COLOR_WINDOWFRAME 0x646464FF #define COLOR_WINDOWTEXT 0x000000FF #define COLOR_YELLOW 0xFFFF00FF #define COLOR_YELLOWGREEN 0x9ACD32FF #define STEALTH_ORANGE 0xFF880000 #define STEALTH_OLIVE 0x66660000 #define STEALTH_GREEN 0x33DD1100 #define STEALTH_PINK 0xFF22EE00 #define STEALTH_BLUE 0x0077BB00 // Color groups #define COLOR_DEFAULT_COMMAND_OUTPUT 0xFFFFFFFF // White #define COLOR_NOTICE 0xAFAFAFAA // Grey #define COLOR_WARNING_MESSAGE 0xFFA500FF // Orange? (Looks more yellow to me) // SQL datatypes #define SQL_INTERGER_LENGTH 10 // Log levels #define LOGLEVEL_CHAT -2 #define LOGLEVEL_COMMAND -1 #define LOGLEVEL_DEBUG 0 #define LOGLEVEL_INFO 1 #define LOGLEVEL_NOTICE 2 #define LOGLEVEL_WARNING 3 #define LOGLEVEL_ERROR 4 #define LOGLEVEL_CRITICAL 5 #define LOGLEVEL_PANIC 6 // Userlevels enum{ // Noted values as comments, for database reference. UNREGISTERED_PLAYER, // 0 REGISTERED_PLAYER, // 1 REGULAR_PLAYER, // 2 MODERATOR_CREW, // 3 ADMIN_CREW, // 4 MANAGEMENT_CREW, // 5 FOUNDER_PLAYER // 6 } // Discord channels enum{ ECHO_CHANNEL, MAIN_CHANNEL, ADMIN_ECHO_CHANNEL, ADMIN_CHANNEL, MANAGEMENT_CHANNEL } // Dialogs enum{ DIALOG_CHANGENAME, DIALOG_REGISTER, DIALOG_ACCOUNT_CREATED, DIALOG_LOGIN, DIALOG_CHANGE_USERNAME, DIALOG_CHARACTERS, DIALOG_LOGIN_FAILED } // Environment settings THESE SHOULD ALL BE READ FROM A CONFIG FILE! static bool:scriptDebug = true; // Debug setting #define MODE_NAME "0.0a Build 4" #define SERVER_NAME "Bone County RPG" #define PG_HOST "127.0.0.1" #define PG_ROLE "rpfw-dev" #define PG_PASS "1234" #define PG_DB "rpfw-dev" #define PG_PORT 5432 #define DISCORD_HOME_GUILD_ID "666077037470941184" // Emerald City Roleplay #define DISCORD_ECHO_CHANNEL_ID "667396220402270228" // #development //#define DISCORD_ECHO_CHANNEL_ID "666078187079598080" // #ecrp-echo #define DISCORD_MAIN_CHANNEL_ID "667396220402270228" // #development //#define DISCORD_MAIN_CHANNEL_ID "667396220402270228" // #development #define DISCORD_ADMIN_ECHO_CHANNEL_ID "672841892169383936" // #admin-echo #define DISCORD_ADMIN_CHANNEL_ID "672841892169383936" // #admins #define DISCORD_MANAGEMENT_CHANNEL_ID "666091376240361492" // #management // Game-mode limits #define MAX_CHARACTERS_PER_USER 20 // Maximum of MAX_CHARACTERS_PER_USER_DIGITS digits (Due to SQL query string length) #define MAX_CHARACTERS_PER_USER_DIGITS 3 // SQL plugin new SQL:sqlHandle; // discord-connector //static DCC_Guild:homeGuild; // Discord guild controlled by game community. static DCC_Channel:echoChannel; // Public echo channel. static DCC_Channel:mainChannel; // Channel for communirty notifications. static DCC_Channel:adminEchoChannel; // Admin echo channel. static DCC_Channel:adminChannel; // Channel for admin notifications. static DCC_Channel:managementChannel; // Channel for management notifications. DiscordEcho(const message[], messageLevel){ // Write to echo channels. switch(messageLevel) // Output facilities. { case ECHO_CHANNEL: {DiscordSendChannelMessage(echoChannel, message);} // Public echo message. case MAIN_CHANNEL: {DiscordSendChannelMessage(mainChannel, message);} // Public notification. case ADMIN_ECHO_CHANNEL: {DiscordSendChannelMessage(adminEchoChannel, message);} // Admin echo message. case ADMIN_CHANNEL: {DiscordSendChannelMessage(adminChannel, message);} // Admin notification. case MANAGEMENT_CHANNEL: {DiscordSendChannelMessage(managementChannel, message);} // Management notification. } return 0; } // Natives native WP_Hash(buffer[], len, const str[]); // https://forum.sa-mp.com/showthread.php?t=570945 //native Float:loadavg(); // https://forum.sa-mp.com/showthread.php?t=260206 LINUX ONLY // Includes #include // https://sa-mp.com #include // https://github.com/udan11/samp-plugin-sql (Fastest player in town and only one supporting postgreSQL) | Examples: https://pastebin.com/67y2nq2n https://github.com/udan11/samp-plugin-sql/issues/10 #include // Newest version: https://github.com/maddinat0r/sscanf/releases | Better readme: https://github.com/Y-Less/sscanf #include // https://github.com/oscar-broman/strlib #include // https://github.com/urShadow/Pawn.Regex #include // https://github.com/urShadow/Pawn.CMD (Fastest player in town) #include // https://github.com/samp-incognito/samp-gvar-plugin #include // https://github.com/maddinat0r/samp-discord-connector (Only player in town) //#include // https://github.com/samp-incognisto/samp-streamer-plugin NOT USED YET /// Middle-ware // Logging Logger(const log_level, const message[]){ // Write to logging facility // Do not log commands or debug when script debugging is turned off. if(scriptDebug == false){ // Debug is off if(log_level == LOGLEVEL_COMMAND || log_level == LOGLEVEL_DEBUG){ // Command or debug message return 0; // Stop and do not log } } // Messagelevel tag new human_readable_log_level[8 + 1]; switch(log_level){ // Assign log level. case LOGLEVEL_CHAT: human_readable_log_level = "chat"; case LOGLEVEL_COMMAND: human_readable_log_level = "command"; case LOGLEVEL_DEBUG: human_readable_log_level = "debug"; case LOGLEVEL_INFO: human_readable_log_level = "info"; case LOGLEVEL_NOTICE: human_readable_log_level = "notice"; case LOGLEVEL_WARNING: human_readable_log_level = "warning"; case LOGLEVEL_ERROR: human_readable_log_level = "error"; case LOGLEVEL_CRITICAL: human_readable_log_level = "critical"; case LOGLEVEL_PANIC: human_readable_log_level = "panic"; } printf("[%s] %s", human_readable_log_level, message); // Print to STDOUT. return 0; } /*// SQL plugin (BROKEN, look at it again after I have more then a week of experience) //forward sqlQuery(SQL:handle, query[]); //public sqlQuery(SQL:handle, query[]){ sqlQuery(SQL:handle, query[]){ //sql_wait(handle); // Wait for all queries to finish. new Result:result = sql_query(handle, query); if(sql_error(result)){printf("SQL error");} // Did not work during a test with a faulty statement. return result; }*/ // discord-connector DiscordSendChannelMessage(DCC_Channel:channel, const message[]){ if(scriptDebug){ // Log middle-ware event in debugging mode only new channel_name[100 + 1]; // Default value from tutorial DCC_GetChannelName(channel, channel_name); new logMessage[26 + 100 + 2000 + 1]; // Discord max message length = 2000 format(logMessage, sizeof(logMessage), "Send to discord channel %s: %s", channel_name, message); Logger(LOGLEVEL_DEBUG, logMessage); // Actually log the message } DCC_SendChannelMessage(channel, message); // Call discord-connector DISABLE THIS TO STOP ALL OUTGOING DISCORD MESSAGES } /// Game-mode // Functions forward changeName(playerid, const name[]); public changeName(playerid, const name[]){ // Check if name is valid and force change if needed. // Prevent regex error when comparing against null if(isempty(name)){ // No name entered ShowPlayerDialog(playerid, DIALOG_CHANGENAME, DIALOG_STYLE_INPUT, "Character name", "You must enter a name.\n\nExamples:\n Jo_Bo\n Dingle_P._J._Berry\n Jackson_DeForest_Kelley\n MaryJo_Ann_LaFluer", "Change", ""); // Force RP name. return 0; } // Check name new Regex:r = Regex_New("^[A-Z][a-z]{1,}([A-Z][a-z]{1,})?(_([A-Z][a-z]{1,}([A-Z][a-z]{1,})?|[A-Z]\\.(_[A-Z]\\.)?))?_[A-Z][a-z]{1,}([A-Z][a-z]{1,})?$"); // Regex name filter new isValidName = Regex_Check(name, r); // Validate name to filter Regex_Delete(r); if(!isValidName){ // Invalid role-play name ShowPlayerDialog(playerid, DIALOG_CHANGENAME, DIALOG_STYLE_INPUT, "Character name", "Please pick a realistic name, separate first and last name with an underscore.\n\nExamples:\n Jo_Bo\n Dingle_P._J._Berry\n Jackson_DeForest_Kelley\n MaryJo_Ann_LaFluer", "Change", ""); // Force RP name. print("past DIALOG_CHANGENAME"); } else { // Valid role-play name // Check for name in use /*new escaped_name[MAX_PLAYER_NAME + 1]; // TODO should be more, to account for escape characters. sql_escape_string(sqlHandle, name, escaped_name, sizeof(escaped_name)); // Escape player name BROKEN argument type mismatch on argument 2, but name is a sting...*/ new character_query[999 + MAX_PLAYER_NAME + 1]; format(character_query, sizeof(character_query), "SELECT id FROM character WHERE name = '%s'", name); new Result:character_result = sql_query(sqlHandle, character_query); if(sql_num_rows(character_result) > 0){ // Name taken ShowPlayerDialog(playerid, DIALOG_CHANGENAME, DIALOG_STYLE_INPUT, "Character name", "Name already taken. Please pick an original name.", "Change", ""); // Force RP name. } else{ // Name free // Rename or character creation if(GetPlayerState(playerid) == PLAYER_STATE_NONE){ // Not spawned: character creation // Do nothing let continue to spawn, after spawn character will be saved to database. } else{ // Spawned: renaming existing character } // Inform player & change name /*if(GetGVarInt("userlevel", playerid) > 1){ // Registered player. // Get username new username[MAX_PLAYER_NAME], message[75 + MAX_PLAYER_NAME + 1]; GetGVarString("username", username, sizeof(username), playerid); // Update or create character name in database new callback[1]; new Result:result; new query[51 + MAX_PLAYER_NAME + MAX_PLAYER_NAME + 1]; format(query, sizeof(query), "UPDATE \"user\"(name) VALUES('%s') WHERE username == '%s'", name, username); sql_wait(sqlHandle); // Wait for other queries to finish result = sql_query(sqlHandle, query, callback = "", "r"); if(sql_error(result)){ // Untested. printf("SQL error"); return 0; } // Inform user format(message, sizeof(message), "SERVER: Your username remains unchanged, next time connect as: %s", username); SendClientMessage(playerid, COLOR_WHITE, message); }*/ SetPlayerName(playerid, name); // Change name in-game } } return 0; } forward register(playerid); public register(playerid){ // Register player in database if(GetPlayerState(playerid) == PLAYER_STATE_NONE){ // Not spawned SendClientMessage(playerid, COLOR_DEFAULT_COMMAND_OUTPUT, "ERROR: You need to have spawned to register."); } else{ // Spawned player // Get username //new username[MAX_PLAYER_NAME + 1]; //GetGVarString("username", username, sizeof(username), playerid); if(GetGVarInt("userlevel", playerid) != UNREGISTERED_PLAYER){ // Registered player. printf("3"); new message[35 + MAX_PLAYER_NAME + 1]; format(message, sizeof(message), "ERROR: You are already registered"); //, %s.", SendClientMessage(playerid, COLOR_WHITE, message); } else{ // Unregistered player. ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Password", "Please pick a strong and safe password, that you are able to remember.", "Continue", "Cancel"); // Password prompt } } } forward getIPID(playerid); public getIPID(playerid){ new player_ip[45 + 1], query[37 + 45 + 1]; // Create varaibles GetPlayerIp(playerid, player_ip, sizeof(player_ip)); // Polulate player_ip variable format(query, sizeof(query), "SELECT id FROM ip WHERE address = '%s'", player_ip); // Format query string new Result:result = sql_query(sqlHandle, query); // Execute query return sql_get_field_assoc_int(result, "id"); // Get id from result } forward kickPlayer(playerid, kickerid, const reason[]); public kickPlayer(playerid, kickerid, const reason[]){ // Kick a player TODO table for all kicks new playername[MAX_PLAYER_NAME +1 ], kickername[MAX_PLAYER_NAME +1]; GetPlayerName(playerid, playername, sizeof(playername)); GetPlayerName(kickerid, kickername, sizeof(kickername)); // Notify all players new message[25 + 4 + MAX_PLAYER_NAME + 120 + 1]; // Max samp chat message length 128 - 8 for "/kick ? ". format(message, sizeof(message), "* [%i] %s kicked %s, reason: %s", kickerid, kickername, playername, reason); SendClientMessageToAll(COLOR_NOTICE, message); // Notify all players. // Inform player (Redundant, but some people are blind or stupid) new playerMessage[25 + 4 + MAX_PLAYER_NAME + 120 + 1]; // Max samp chat message length 128 - 8 for "/kick ? ". format(message, sizeof(message), "You have been kicked by %s, reason: %s", kickerName, reason); SendClientMessage(playerid, COLOR_RED, playerMessage); // Notify player SetTimerEx("Kick", 50, false, "i", playerid); // Give the message 50 milliseconds to reach the player before kicking. DiscordEcho(message, ECHO_CHANNEL); // Notify discord public echo } forward createCharacterRecord(playerid, id); public createCharacterRecord(playerid, id){ new playername[MAX_PLAYER_NAME + 1], character_query[94 + 10 + MAX_PLAYER_NAME + 3 + 1]; GetPlayerName(playerid, playername, sizeof(playername)); format(character_query, sizeof(character_query), "INSERT INTO character(character_id, name, skin_id) VALUES(%i, '%s', %i)", id, playername, GetPlayerSkin(playerid)); sql_query(sqlHandle, character_query); } forward getUserID(playerid); public getUserID(playerid){ // SQL escape username new client_connect_username[MAX_PLAYER_NAME + 1], escaped_username[MAX_PLAYER_NAME + 1]; // TODO escaped_username should be longer to account for escape characters (Also increate database column size!) GetGVarString("client_connect_username", client_connect_username, sizeof(client_connect_username), playerid); // Get client connect name sql_escape_string(sqlHandle, client_connect_username, escaped_username, sizeof(escaped_username)); // Escape player name // Get user ID new userid_query[47 + MAX_PLAYER_NAME + 1]; format(userid_query, sizeof(userid_query), "SELECT id FROM \"user\" WHERE name = '%s'", escaped_username); new Result:result = sql_query(sqlHandle, userid_query); return sql_get_field_assoc_int(result, "id"); } forward authenticate(playerid); public authenticate(playerid){ ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Sign in", "Enter your password to log on", "Log in", "Change name"); // Show password confirmation dialog } forward characterSelection(playerid); public characterSelection(playerid){ // If spawned, save current character if(GetPlayerState(playerid) != PLAYER_STATE_NONE){ savePlayerState(playerid); } new id = getUserID(playerid); new character_query[87 + SQL_INTERGER_LENGTH + MAX_CHARACTERS_PER_USER_DIGITS + 1]; format(character_query, sizeof(character_query), "SELECT id, name FROM character WHERE character_id = '%i' LIMIT %i", id, MAX_CHARACTERS_PER_USER); new Result:character_result = sql_query(sqlHandle, character_query); new character_string[1024 + 1], character_array[MAX_CHARACTERS_PER_USER]; for(new i = 0; i < sql_num_rows(character_result); i++){ new name[MAX_PLAYER_NAME + 1]; sql_get_field_assoc_ex(character_result, i, "name", name, sizeof(name)); format(character_string, sizeof(character_string), "%s%s\n", character_string, name); character_array[i] = sql_get_field_assoc_int_ex(character_result, i, "id"); } new character_array_string[MAX_CHARACTERS_PER_USER * SQL_INTERGER_LENGTH + 1]; strfrombin(character_array_string, character_array); // Convert array to string for use with GVar SetGVarString("character_array_string", character_array_string, playerid); ShowPlayerDialog(playerid, DIALOG_CHARACTERS, DIALOG_STYLE_LIST, "Characters", character_string, "Spawn", "New"); } forward savePlayerState(playerid); public savePlayerState(playerid){ new playername[MAX_PLAYER_NAME], escaped_playername[MAX_PLAYER_NAME + 1], character_query[187 + 10 + 3 + 3 + 1 + 16 + 16 + 16 + 16 + MAX_PLAYER_NAME + 1]; // Should be longer to allow for escaped characters GetPlayerName(playerid, playername, sizeof(playername)); sql_escape_string(sqlHandle, playername, escaped_playername, sizeof(escaped_playername)); // Escape player name new Float:health, Float:armour, Float:x, Float:y, Float:z, Float:Angle; // Unrealiable TODO change to gvars GetPlayerHealth(playerid, health); GetPlayerArmour(playerid, armour); GetPlayerPos(playerid, x, y, z); GetPlayerFacingAngle(playerid, Angle); format(character_query, sizeof(character_query), "UPDATE character SET (cash, health, armor, jailed, pos_x, pos_y, pos_z, rotation) = ('%i', '%f', '%f', '%i', '%f', '%f', '%f', '%f') WHERE name = '%s'", GetPlayerMoney(playerid), health, armour, 0, x, y, z, Angle, escaped_playername); sql_query(sqlHandle, character_query); } forward deleteAllGVars(playerid); public deleteAllGVars(playerid){ // Delete GVars as per https://forum.sa-mp.com/showthread.php?t=151076 //DeleteGVar("IPID", playerid); // From OnPlayerConnect DeleteGVar("client_connect_username", playerid); // From OnPlayerConnect DeleteGVar("userlevel", playerid); // From OnPlayerConnect DeleteGVar("hash", playerid); // From DIALOG_REGISTER DeleteGVar("character_array_string", playerid); // From OnDialogResponse DeleteGVar("authentication_count", playerid); // From DIALOG_LOGIN } // Commands public OnPlayerCommandPerformed(playerid, cmd[], params[], result, flags) { if(result == -1) { SendClientMessage(playerid, COLOR_DEFAULT_COMMAND_OUTPUT, "SERVER: Unknown command."); return 0; } return 1; } cmd:help(playerid, params[]){ SendClientMessage(playerid, COLOR_DEFAULT_COMMAND_OUTPUT, "SERVER: Ask questions in the chat, on Discord or the forum.\nTo list all commands: /cmds"); return 1; } alias:help("h"); cmd:cmds(playerid, params[]){ SendClientMessage(playerid, COLOR_DEFAULT_COMMAND_OUTPUT, "/cmds /my /v /p"); return 0; } alias:cmds("commands", "cmd"); cmd:register(playerid, params[]){ register(playerid); } cmd:my(playerid, params[]){ // No option specified if(strlen(params) < 1){ SendClientMessage(playerid, COLOR_DEFAULT_COMMAND_OUTPUT, "Usage: /my