30.11.2016, 16:10
Quote:
|
Originally Posted by Speedpro
 Pass the complete code
Code:
/* __________________________________________________ | | | Base SQLite Script | | ------------------ | | Created by: Norrin | | http://creativecommons.org/licenses/by-nc-nd/4.0 | |__________________________________________________| */ //------------------------------------------------------------------------------ // INCLUDES //------------------------------------------------------------------------------ #include <a_samp> #include <sscanf2> #include <streamer> #include <zcmd> //------------------------------------------------------------------------------ // SERVER CONFIGURATION //------------------------------------------------------------------------------ #define SERVER_NAME "Roleplay Script" #define SERVER_RCON "goodroleplayserver" #define SERVER_PASSWORD "0" #define SERVER_VERSION "v0.1" #define SERVER_MAP "Los Santos" #define SERVER_WEBSITE "N/A" #define SERVER_TEAMSPEAK "N/A" //------------------------------------------------------------------------------ // DEFINITIONS //------------------------------------------------------------------------------ #define COLOR_WHITE 0xFFFFFFAA #define COLOR_BLACK 0x000000FF #define COLOR_GREY 0xB4B5B7FF #define COLOR_YELLOW 0xFFFF00AA #define COLOR_RED 0xAA3333AA #define COLOR_ORANGE 0xF69521AA #define COLOR_GREEN 0x33AA33AA #define COLOR_PURPLE 0xC2A2DAAA #define COLOR_CYAN 0x00FFFFFF #define COLOR_GOLD 0xFFD700FF #define COLOR_LIME 0x00FF00FF #define COLOR_TEAL 0x008080AA #define COLOR_HOTPINK 0xFF69B4FF #define COLOR_LAVENDER 0xE6E6FAFF #define COLOR_LIGHTRED 0xFF6347AA #define COLOR_CYANBLUE 0x01FCFFC8 #define COLOR_LIGHTBLUE 0x33CCFFAA #define COLOR_NEWBIE 0xBED9EFFF #define COLOR_FADE1 0xE6E6E6E6 #define COLOR_FADE2 0xC8C8C8C8 #define COLOR_FADE3 0xAAAAAAAA #define COLOR_FADE4 0x8C8C8C8C #define COLOR_FADE5 0x6E6E6E6E #define DIALOG_REGISTER (1) #define DIALOG_LOGIN (2) #define DIALOG_BANINFO (3) #define DIALOG_AGE (4) #define DIALOG_GENDER (5) #define DIALOG_SKIN (6) #define MAX_DOORS (100) //------------------------------------------------------------------------------ // MACROS //------------------------------------------------------------------------------ #define IsPlayerLogged(%0) GetPVarInt(%0, "gLogged") #define IsPlayerTabbed(%0) gettime() > (PlayerInfo[%0][pLastUpdate] + 2) //------------------------------------------------------------------------------ // NATIVES //------------------------------------------------------------------------------ native WP_Hash(buffer[], len, const str[]); //------------------------------------------------------------------------------ // VARIABLES //------------------------------------------------------------------------------ new DB:Database; new WorldTime[3]; new Text:StopAnim; new Text:BoxNotice; new Text:LoadingNotice; enum pInfo { pID, pUsername[MAX_PLAYER_NAME], pAge, pGender, pRegistered, pMember, pRank, pLeader, pIP[16], pBanned, pBanReason[64], pBanExpiry, pJailTime, pJailReason[64], pNMute, pRMute, pAdmin, pTester, pSecondaryTask, pMoney, Float:pPositionX, Float:pPositionY, Float:pPositionZ, Float:pFacingAngle, pInterior, pVirtualWorld, pSkin, Float:pHealth, Float:pArmour, pReport[128], pLastUpdate, PlayerAnimLibsPreloaded, gPlayerUsingLoopingAnim, CurrentDialog } new PlayerInfo[MAX_PLAYERS][pInfo]; enum dInfo { Float:dExteriorX, Float:dExteriorY, Float:dExteriorZ, Float:dExteriorAngle, dExteriorInt, dExteriorVir, Float:dInteriorX, Float:dInteriorY, Float:dInteriorZ, Float:dInteriorAngle, dInteriorInt, dInteriorVir, dName[64], dPickup, Text3D:dDynamicText } new DoorInfo[MAX_DOORS][dInfo]; //------------------------------------------------------------------------------ // FORWARDS //------------------------------------------------------------------------------ // NIL //------------------------------------------------------------------------------ // FUNCTIONS //------------------------------------------------------------------------------ main() { SendRconCommand("hostname "SERVER_NAME); SendRconCommand("rcon_password "SERVER_RCON); SendRconCommand("gamemodetext "SERVER_VERSION); SendRconCommand("mapname "SERVER_MAP); SendRconCommand("weburl "SERVER_WEBSITE); SendRconCommand("password "SERVER_PASSWORD); printf(""SERVER_NAME" ("SERVER_VERSION"), has been loaded successfully."); } //------------------------------------------------------------------------------ // CALLBACKS //------------------------------------------------------------------------------ public OnGameModeInit() { //AntiDeAMX(); No existing stock Database = db_open("database.db"); new string[1024]; strcat(string, "CREATE TABLE IF NOT EXISTS Accounts("); strcat(string, "UserID INTEGER PRIMARY KEY AUTOINCREMENT,"); strcat(string, "Username VARCHAR(24) COLLATE NOCASE,"); strcat(string, "Password VARCHAR(128),"); strcat(string, "IP VARCHAR(16),"); strcat(string, "Age INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Gender INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Registered INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Member INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Rank INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Leader INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Banned INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "BanReason VARCHAR(64),"); strcat(string, "BanExpiry INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "JailTime INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "JailReason VARCHAR(64),"); strcat(string, "NMute INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "RMute INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "AdminLevel INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "TesterLevel INTEGER DEFUALT 0 NOT NULL,"); strcat(string, "SecondaryTask INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Money INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "PositionX FLOAT DEFAULT 0.0,"); strcat(string, "PositionY FLOAT DEFAULT 0.0,"); strcat(string, "PositionZ FLOAT DEFAULT 0.0,"); strcat(string, "FacingAngle FLOAT DEFAULT 0.0,"); strcat(string, "Interior INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "VirtualWorld INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Health FLOAT DEFAULT 0.0,"); strcat(string, "Armour FLOAT DEFAULT 0.0,"); strcat(string, "Skin INTEGER DEFAULT 0 NOT NULL)"); db_query(Database, string); format(string, sizeof(string), ""); strcat(string, "CREATE TABLE IF NOT EXISTS Doors("); strcat(string, "TITLE VARCHAR(24),"); strcat(string, "EXTERIOR_POSX FLOAT DEFAULT 0.0,"); strcat(string, "EXTERIOR_POSY FLOAT DEFAULT 0.0,"); strcat(string, "EXTERIOR_POSZ FLOAT DEFAULT 0.0,"); strcat(string, "EXTERIOR_INT INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "EXTERIOR_VW INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "EXTERIOR_ANGLE FLOAT DEFAULT 0.0,"); strcat(string, "INTERIOR_POSX FLOAT DEFAULT 0.0,"); strcat(string, "INTERIOR_POSY FLOAT DEFAULT 0.0,"); strcat(string, "INTERIOR_POSZ FLOAT DEFAULT 0.0,"); strcat(string, "INTERIOR_INT INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "INTERIOR_VW INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "INTERIOR_ANGLE FLOAT DEFAULT 0.0)"); db_query(Database, string); format(string, sizeof(string), ""); strcat(string, "CREATE TABLE IF NOT EXISTS Groups("); strcat(string, "Name VARCHAR(24),"); strcat(string, "Type INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Rank0 INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Rank1 INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Rank2 INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Rank3 INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Rank4 INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Rank5 INTEGER DEFAULT 0 NOT NULL,"); strcat(string, "Rank6 INTEGER DEFAULT 0 NOT NULL)"); db_query(Database, string); EnableStuntBonusForAll(0); SetNameTagDrawDistance(15.0); ShowPlayerMarkers(0); DisableInteriorEnterExits(); //LoadTextdraws(); No existing stock gettime(WorldTime[0], WorldTime[1], WorldTime[2]); SetWorldTime(WorldTime[0]); return 1; } |