hostname=localhost
username=root
database=
password=

#include <a_samp>
#include <a_mysql>
#include <foreach>


/* RESOURCE DATA */
#include "module/language/english.pwn"
#include "module/define.pwn"
#include "module/resource.pwn"
#include "module/directive.pwn"
#include "module/sql.pwn"
#include "module/enum.pwn"


public OnGameModeInit(){
    #include "module/vehicles.pwn"
    dbcon();
    mode();
    server();
    thread();

    for(new vehicleid=1; vehicleid<=230; vehicleid++)vehicleSpawn(vehicleid);
    return 1;
}


public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]){

    if(!response){
        switch(dialogid){
            case DL_LOGIN, DL_REGIST:return Kick(playerid);
            case DL_MISSON_CLAN, DL_MISSON_SHOP, DL_MISSON_NOTICE, DL_MISSON_GAMBLE, DL_MYWEP, DL_MYCAR, DL_GARAGE :return 0;
            case DL_MISSON_DUEL :return DUEL_CORE[ON]=false;
            case DL_CLAN_INSERT, DL_CLAN_LIST, DL_CLAN_RANK, DL_CLAN_SETUP, DL_CLAN_LEAVE :return showMisson(playerid, 0);
            case DL_CLAN_INSERT_COLOR : return showDialog(playerid, DL_CLAN_INSERT);
            case DL_CLAN_INSERT_COLOR_RANDOM : return clanInsertColorRandom(playerid);
	    case DL_CLAN_INSERT_COLOR_CHOICE :return showDialog(playerid, DL_CLAN_INSERT_COLOR);
            case DL_CLAN_INSERT_SUCCESS : return showDialog(playerid, DL_CLAN_INSERT_COLOR);
            case DL_CLAN_SETUP_INVITE, DL_CLAN_SETUP_MEMBER, DL_CLAN_SETUP_SKIN: return showDialog(playerid, DL_CLAN_SETUP);
            case DL_CLAN_SETUP_MEMBER_SETUP : return showDialog(playerid, DL_CLAN_SETUP_MEMBER);
            case DL_CLAN_SETUP_MEMBER_SETUP_RANK, DL_CLAN_SETUP_MEMBER_SETUP_KICK : return showDialog(playerid, DL_CLAN_SETUP_MEMBER_SETUP);
            case DL_CLAN_SETUP_SKIN_SETUP, DL_CLAN_SETUP_SKIN_UPDATE : return showDialog(playerid, DL_CLAN_SETUP_SKIN);
            case DL_SHOP_WEAPON, DL_SHOP_SKIN, DL_SHOP_ACC, DL_SHOP_NAME : return showMisson(playerid, 1);
            case DL_SHOP_WEAPON_BUY : return showDialog(playerid, DL_SHOP_WEAPON);
            case DL_SHOP_SKIN_BUY : return showDialog(playerid, DL_SHOP_SKIN);
            case DL_SHOP_NAME_EDIT : return showDialog(playerid, DL_SHOP_NAME);
            case DL_MYWEP_SETUP : return showDialog(playerid, DL_MYWEP);
            case DL_MYWEP_SETUP_OPTION : return showDialog(playerid, DL_MYWEP_SETUP);
            case DL_MYWEP_SETUP_HOLD, DL_MYWEP_SETUP_PUT: return showDialog(playerid, DL_MYWEP_SETUP_OPTION);
            case DL_MYCAR_SETUP : return showDialog(playerid, DL_MYCAR);
            case DL_MYCAR_SETUP_SPAWN : return showDialog(playerid, DL_MYCAR_SETUP);
            case DL_GARAGE_REPAIR, DL_GARAGE_PAINT, DL_GARAGE_TURNING : return showDialog(playerid, DL_GARAGE);
            case DL_GAMBLE_CHOICE : return ShowPlayerDialog(playerid, DL_MISSON_GAMBLE, DIALOG_STYLE_INPUT,DIALOG_TITLE, MISSON_GAMBLE_TEXT, DIALOG_ENTER, DIALOG_CLOSE);
            case DL_GAMBLE_REGAMBLE, DL_GAMBLE_RESULT : return 0;
            case DL_DUEL_INFO: return 0;
            case DL_DUEL_TYPE:{
                if(INGAME[playerid][DUEL_JOIN])duelLeave(playerid);
                else showMisson(playerid, 3);
                return 1;
            }
            case DL_DUEL_MONEY : return showDialog(playerid, DL_DUEL_TYPE);
            case DL_DUEL_SUCCESS : return showDialog(playerid, DL_DUEL_MONEY);
        }
    }

    switch(dialogid){
        // CORE
        case DL_LOGIN  : checked(playerid, inputtext);
        case DL_REGIST : regist(playerid, inputtext);
        case DL_INFO   : info(playerid,listitem);
        case DL_MYWEP  : mywep(playerid,listitem);
        case DL_MYCAR  : mycar(playerid,listitem);
        case DL_GARAGE : garage(playerid,listitem);

        // MISSON
        case DL_MISSON_CLAN    : clan(playerid,listitem);
        case DL_MISSON_SHOP    : shop(playerid,listitem);
        case DL_MISSON_NOTICE  : notice(playerid,listitem);
        case DL_MISSON_DUEL    : duel(playerid,listitem);
        case DL_MISSON_GAMBLE  : gamble(playerid, inputtext);

        // CLAN
        case DL_CLAN_INSERT : clanInsert(playerid, inputtext);
        case DL_CLAN_LIST   : clanList(playerid);
        case DL_CLAN_RANK   : clanRank(playerid);
        case DL_CLAN_SETUP  : clanSetup(playerid, listitem);
        case DL_CLAN_LEAVE  : clanLeave(playerid);

        // CLAN INSERT
        case DL_CLAN_INSERT_COLOR        : clanInsertColor(playerid, listitem);
        case DL_CLAN_INSERT_COLOR_RANDOM : showDialog(playerid, DL_CLAN_INSERT_COLOR);
        case DL_CLAN_INSERT_COLOR_CHOICE : clanInsertColorChoice(playerid, inputtext);
        case DL_CLAN_INSERT_SUCCESS      : clanInsertSuccess(playerid);

        // CLAN SETUP
        case DL_CLAN_SETUP_INVITE : clanInvite(playerid, inputtext);
        case DL_CLAN_SETUP_MEMBER : clanMember(playerid, listitem);
        case DL_CLAN_SETUP_SKIN : clanSkin(playerid,listitem);

        // CLAN MEMBER SETUP
        case DL_CLAN_SETUP_MEMBER_SETUP      : clanMemberSetup(playerid,listitem);
        case DL_CLAN_SETUP_MEMBER_SETUP_RANK : clanMemberRank(playerid,listitem);
        case DL_CLAN_SETUP_MEMBER_SETUP_KICK : clanMemberKick(playerid);

        // CLAN SKIN
        case DL_CLAN_SETUP_SKIN_SETUP        : clanSkinSetup(playerid, inputtext);
        case DL_CLAN_SETUP_SKIN_UPDATE       : clanSkinUpdate(playerid);

        // SHOP
        case DL_SHOP_WEAPON : shopWeapon(playerid, listitem);
        case DL_SHOP_SKIN   : shopSkin(playerid, inputtext);
        case DL_SHOP_ACC    : shopAcc(playerid, listitem);
        case DL_SHOP_NAME   : shopName(playerid, inputtext);

        // SHOP WEAPON BUY
        case DL_SHOP_WEAPON_BUY : shopWeaponBuy(playerid);

        // SHOP SKIN BUY
        case DL_SHOP_SKIN_BUY : shopSkinBuy(playerid);

        // SHOP NAME EDIT
        case DL_SHOP_NAME_EDIT : shopNameEdit(playerid);

        // NOTICE
        case DL_NOTICE_SEASON : noticeSeason(playerid);

        // MYWEP SETUP
        case DL_MYWEP_SETUP        : setWep(playerid,listitem);
        case DL_MYWEP_SETUP_OPTION : setWepOption(playerid,listitem);
        case DL_MYWEP_SETUP_HOLD   : holdWep(playerid);
        case DL_MYWEP_SETUP_PUT    : putWep(playerid);

        // MYCAR SETUP
        case DL_MYCAR_SETUP        : setCar(playerid,listitem);
        case DL_MYCAR_SETUP_SPAWN  : spawnCar(playerid);

        // GARAGE
        case DL_GARAGE_REPAIR      : repairCar(playerid);
        case DL_GARAGE_PAINT       : paintCar(playerid, inputtext);
        case DL_GARAGE_TURNING     : turnCar(playerid);

        // DUEL
        case DL_DUEL_TYPE          : duelType(playerid, listitem);
        case DL_DUEL_MONEY         : duelMoney(playerid, inputtext);
        case DL_DUEL_SUCCESS       : duelSuccess(playerid);

        // GAMBLE
        case DL_GAMBLE_CHOICE      : gambleChoice(playerid, listitem);
        case DL_GAMBLE_REGAMBLE    : gambleRegamble(playerid);
        case DL_GAMBLE_RESULT      : gambleResult(playerid);

    }
    return 1;
}

/* OnDialogResponse stock
   @ info()                          : Help topic                [/ help command related]
   @ clan(playerid,listitem)         : Korean War Association [clan pickup related]
   @ shop(playerid,listitem)         : Cappuccino shop [shop pickup related]
   @ notice(playerid,listitem)       : Meeting place [notice board pickup related]
   @ duel(playerid,listitem)         : Dual [dual-chapter sign-up related]
   @ gamble(playerid,inputtext[])    : Slot Machine [Related to slot machine pickup]
   @ mywep(playerid,listitem)        : My weapon settings        [/wep command related]
   @ mycar(playerid,listitem)        : My car settings           [/car command related]
   @ garage(playerid,listitem)       : Garage related            [Caps Look within the workshop]
*/

/* CLAN
   @ clanInsert(playerid, inputtext) : Clan Creation         [clanInsert - clanInsertColor - clanInsertColorRandom - clanInsertSuccess]
   @ clanList(playerid);             : Clan List
   @ clanRank(playerid);             : Clan Ranking
   @ clanSetup(playerid, listitem);  : Clan Management
   @ clanLeave(playerid);            : Clan Leave

   @ clanJoin(playerid, clanid)      : Clan joining
*/

/* CLAN INSERT
   @ clanInsertColor(playerid, listitem)         : How to assign unique color to a clan [random, direct]
   @ clanInsertColorRandom(playerid)             : Clan unique color random
   @ clanInsertColorChoice(playerid, inputtext)  : Clan Unique Color Direct
   @ clanInsertSuccess(playerid)                 : Check for Clan Generation Complete input
*/

/* CLAN SETUP
   @ clanInvite(playerid, inputtext)  : Invite a clan
   @ clanMember(playerid, listitem)   : View clan members              [clanMember - clanMemberSetup - clanMemberRank - clanMemberKick]
   @ clanSkin(playerid,listitem)      : Clan Skin Management            [clanSkin - clanSkinSetup - clanSkinUpdate]
*/

/* CLAN MEMBER SETUP
   @ clanMemberSetup(playerid, listitem);  : Clan member management type [change position, deportation]
   @ clanMemberRank(playerid, listitem);   : Change clan position
   @ clanMemberKick(playerid);             : Clan Exile
*/

/* SHOP
    @ shopWeapon(playerid, listitem)   :  Buy Weapon     [shopWeapon - shopWeaponBuy]
    @ shopSkin(playerid, inputtext)    :  Buy Skins      [shopSkin   - shopSkinBuy  ]
    @ shopAcc(playerid, listitem)      :  Buy Acc
    @ shopName(playerid, inputtext)    :  Rename         [shopName   - shopNameEdit ]
*/

/* SHOP WEAPON BUY
   @ shopWeaponBuy(playerid)   : Weapon Buy confirmation message
*/

/* SHOP SKIN BUY
   @ shopSkinBuy(playerid)   : Skin Buy confirmation message
*/

/* SHOP NAME EDIT
   @ shopNameEdit(playerid)  : Rename confirmation message
*/

/* MYWEP SETUP
   @ setWep(playerid, listitem)          : See my weapons  [setWep - setWepOption]
   @ setWepOption(playerid, listitem)    : Setting up the main weapon
   @ holdWep(playerid)                   : Equipped with main weapon
   @ putWep(playerid)                    : Removing the main weapon
*/

/* DUEL
    @ duelType(playerid, listitem)        : Dual weapon type designation
    @ duelMoney(playerid, inputtext[])    : Specify Dual Betting Amount
    @ duelSuccess(playerid)               : Dual entry
    @ duelSpawn(playerid, order)          : Dual chapter spawning  @order : 0 plaer spaw A / 1 player spawn B
    @ duelTimer(p1, p2)                   : Dual start timer       [ tick timer 1500, four binding]
    @ duelResult(playerid)                : Dual Results
    @ duelMatchID(playerid)               : Get a matched relative ID return
    @ duelLeave(playerid)                 : Dual exiting
*/

/* GAMBLE
   @ gambleChoice(playerid, listitem)            : Specify slot machine bet amount
   @ gambling(playerid, dice, listitem, result)  : Slot machine game progress
   @ gambleRegamble(playerid)                    : Go back to the slot machine [5-value rule re-rolls]
   @ gambleResult(playerid)                      : Output slot machine result
*/


/* stock
   @ zoneInit()                          : Initialize all (init)
   @ zoneSave(id, owner_clan)            : Save up to date
   @ vehicleInit()                       : Vehicle initialization (init)
   @ vehicleSave(vehicleid)              : Vehicle storage
   @ vehicleSpawn(vehicleid)             : Vehicle responder
   @ zoneSetup()                         : Setting up the remainder (create modeling min xy, max xy)
   @ showZone(playerid)                  : Show up
   @ vehicleBuy(playerid, carid)         : Buying a vehicle
   @ showEnvi(playerid)                  : FPS, PING, Packet Loss Print     [ ServerThread - event (tick switch 5, 10 ,15) ]
   @ showRank(playerid)                  : User tier (rank) overhead output [ ServerThread - event (tick switch 20) ]
   @ showTextDraw(playerid)              : Text draw output
   @ fixPos(playerid)                    : Random spawn position random assignment
   @ event(playerid)                     : Thread handler                   [ ServerTherad - event - showEnvi - showRank ]
   @ checkWarp(playerid)                 : Vehicle warp detection check     [ ServerThread - checkWarp ]
   @ inCar(playerid, vehicleid)          : Specifying the vehicle's normal boarding certification
   @ warp(playerid)                      : Vehicle warp detection
   @ warpInit(playerid)                  : Toggle vehicle off (init )
   @ giveMoney(playerid,money)           : Money cycle
   @ death(playerid, killerid, reason)   : death
   @ killCombo(playerid)                 : Specify a kill combo
   @ deathPickup(killerid, playerid, Float:pickup_x, Float:pickup_y, Float:pickup_z)      : Death Pickup Generation [Armor, Heart value greater than 0]
   @ loadMisson()                        : Loading Mission Data [Clan, Store, Ranking, Dual, Slot Machine]
   @ missonInit(name[24],Float:pos_x,Float:pos_y,Float:pos_z)                             : Mission model initialization (init)
   @ object_init()                       : Object initialization (init)
   @ textLabel_init()                    : 3D Label Reset   (init)
   @ textDraw_init();                    : 2D texture initialization (init)
   @ searchMissonRange(playerid)         : Surrounding radius Mission event check
   @ searchGarageRange(playerid)         : Check the existence of the surrounding radius gas station event
   @ showMisson(playerid, type)          : Open Mission Event
   @ showGarage(playerid)                : Open the gas station event
   @ showDialog(playerid, type)          : Dialog Handler
   @ isPlayerZone(playerid, zoneid)      : Check whether there is a certain existence
   @ checkZone(playerid)                 : A rehearsal event              [ ServerThread - checkZone ]
   @ holdZone(playerid)                  : Acquisition of survival
   @ isHaveWeapon(playerid , weaponid)   : Check whether a specific weapon is purchased
   @ isEmptyWep(playerid, listitem)      : Check whether or not to buy a store weapon       [ shopWeapon (Dialog) ]
   @ isBuyWepMoney(weponid, money)       : Check specific weapons purchase conditions       [ shopWeapon ( money ) ]
   @ isHoldWep(playerid, model)          : Check with worn suit
   @ isClan(playerid, type)              : Check user clan related status        @ type : IS_CLEN_HAVE, IS_CLEN_NOT, IS_CLEN_LEADER, IS_CLEN_INSERT_MONEY
   @ isHangul(playerid, str[])           : Input Hangul check
   @ isMaxHaveCar(playerid)              : Limited number of cars checked
   @ randomColor()                       : Random hex value return
   @ packet(playerid)                    : User packet loss update
   @ fps(playerid)                       : User FPS update
   @ setAlpha(color, a)                  : Damage text draw alpha value specified      [TakeDamage Callback - damage - setalpha]
   @ damage(playerid)                    : Shooting hitting information
   @ getPlayerId(name[]                  : Return ID by user name
   @ wepID(model)                        : Returns an array of weapons as a weapon model name
   @ wepName(model)                      : Return weapon name to weapon model name (Korean for)
   @ wepNameTD(model)                    : Return weapon name to weapon model name (English for Text Draw)
   @ sync(playerid)                      : Disink
   @ kdRatio(kill, death)                : Returns the user fee rate
   @ kdTier(level, kill, death)          : Return user tier name
*/

enum DUEL_MODEL{
        ID,
        WIN_ID,
        WIN_NAME[24],
        LOSS_ID,
        LOSS_NAME[24],
        TYPE,
        MONEY,
        Float:WIN_HP,
        Float:WIN_AM
    }
    new DUEL[USED_DUEL_LIST][DUEL_MODEL];
 
    enum DUEL_CORE_MODEL{
        INDEX,
        bool:ON,
        PID1,
        PID2,
        TYPE,
        MONEY,
        LENGTH,
        TICK
    }
    new DUEL_CORE[DUEL_CORE_MODEL];
 
    enum DAMAGE_MODEL{
        Float:TAKE,
        Float:GIVE
    }
    new DAMAGE[USED_PLAYER][USED_PLAYER][DAMAGE_MODEL];
 
    enum WARP_MODEL{
       bool:CHECK,
       bool:INCAR,
       CARID
    }
    new WARP[USED_PLAYER][WARP_MODEL];
 
    enum CLAN_CP_MODEL{
       CP,
       INDEX
    }
    new CLAN_CP[USED_ZONE][USED_CLAN][CLAN_CP_MODEL];
 
    enum NODMZONE_MODEL{
        ID,
        Float:MIN_X,
        Float:MIN_Y,
        Float:MAX_X,
        Float:MAX_Y
    }
    new NODMZONE[NODMZONE_MODEL];
 
    enum ZONE_MODEL{
        ID,
        OWNER_CLAN,
        STAY_HUMAN,
        STAY_CLAN,
        Float:MIN_X,
        Float:MIN_Y,
        Float:MAX_X,
        Float:MAX_Y
    }
    new ZONE[USED_ZONE][ZONE_MODEL];
 
    enum USER_MODEL{
        ID,
        NAME[MAX_PLAYER_NAME],
        PASS[24],
        USERIP[16],
        CLANID,
        ADMIN,
        MONEY,
        LEVEL,
        EXP,
        KILLS,
        DEATHS,
        SKIN,
        WEP1,
        WEP2,
        WEP3,
        INTERIOR,
        WORLD,
        DUEL_WIN,
        DUEL_LOSS,
        Float:POS_X,
        Float:POS_Y,
        Float:POS_Z,
        Float:ANGLE,
        Float:HP,
        Float:AM
    }
    new USER[USED_PLAYER][USER_MODEL];
 
    enum WEPBAG_MODEL{
        MODEL
    }
    new WEPBAG[USED_PLAYER][USED_WEAPON][WEPBAG_MODEL];
 
    enum CARBAG_MODEL{
        ID
    }
    new CARBAG[USED_PLAYER][USED_WEAPON][CARBAG_MODEL];
 
    enum VEHICLE_MODEL{
        ID,
        OWNER_ID[MAX_PLAYER_NAME],
        OWNER_NAME[MAX_PLAYER_NAME],
        COLOR1,
        COLOR2,
        Float:POS_X,
        Float:POS_Y,
        Float:POS_Z,
        Float:ANGLE
    }
    new VEHICLE[USED_VEHICLE][VEHICLE_MODEL];
 
    enum HOUSE_MODEL{
        ID,
        OWNER_ID,
        OPEN,
        INTERIOR,
        WORLD,
        Float:ENTER_POS_X,
        Float:ENTER_POS_Y,
        Float:ENTER_POS_Z,
        Float:LEAVE_POS_X,
        Float:LEAVE_POS_Y,
        Float:LEAVE_POS_Z
    }
    new HOUSE[USED_HOUSE][HOUSE_MODEL];
 
    enum CLAN_MODEL{
        ID,
        NAME[50],
        LEADER_ID,
        LEADER_NAME[MAX_PLAYER_NAME],
        KILLS,
        DEATHS,
        COLOR,
        ZONE_LENGTH,
        SKIN
    }
    new CLAN[USED_CLAN][CLAN_MODEL];
 
    enum INGAME_MODEL{
        bool:LOGIN,
        Float:SPAWN_POS_X,
        Float:SPAWN_POS_Y,
        Float:SPAWN_POS_Z,
        Float:SPAWN_ANGLE,
        ENTER_ZONE,
        ZONE_TICK,
        INVITE_CLANID,
        INVITE_CLAN_REQUEST_MEMBERID,
        BUY_SKINID,
        BUY_WEAPONID,
        HOLD_WEPID,
        HOLD_WEPLIST,
        WEPBAG_INDEX,
        HOLD_CARID,
        EDIT_NAME[24],
        COMBO,
        AMMO,
        bool:SYNC,
        bool:SPAWN,
        bool:RESTART,
        bool:NODM,
        bool:DUEL_JOIN,
        EVENT_TICK,
        SEASON,
        PAINT_TYPE,
        CAR_PAINT1,
        CAR_PAINT2,
        DRUNK_LEVEL_LAST,
        FPS,
        Float:PACKET,
        TAKE_DAMAGE_ALPHA,
        GIVE_DAMAGE_ALPHA,
        DEATH_PICKUP_HP,
        DEATH_PICKUP_AM,
        GAMBLE
    }
    new INGAME[USED_PLAYER][INGAME_MODEL];
 
    enum MISSON_MODEL{
        NAME[24],
        Float:POS_Y,
        Float:POS_X,
        Float:POS_Z
    }
    new MISSON[USED_MISSON][MISSON_MODEL];
 
    enum GARAGE_MODEL{
        NAME[50],
        Float:POS_Y,
        Float:POS_X,
        Float:POS_Z
    }
    new GARAGE[USED_GARAGE][GARAGE_MODEL];
 
    enum CLAN_SETUP_MODEL{
        NAME[50],
        MEMBER,
        COLOR
    }
    new CLAN_SETUP[USED_PLAYER][CLAN_SETUP_MODEL];
 
    enum TDrawG_MODEL{
        Text:ID,
        Text:COMBO
    }
    new TDrawG[USED_TEXTDRAW][TDrawG_MODEL];
 
    enum TDraw_MODEL{
        Text:ZONETEXT,
        Text:CP,
        Text:FPS,
        Text:PING,
        Text:PACKET,
        Text:TAKE_DAMAGE,
        Text:GIVE_DAMAGE
    }
    new TDraw[USED_PLAYER][TDraw_MODEL];

/* DB INIT CREATE */
#define SQL_USER_TABLE_1 "\
CREATE TABLE \
    user_info( \
        ID INT PRIMARY KEY AUTO_INCREMENT \
        ,NAME VARCHAR(24) NOT NULL \
        ,PASS VARCHAR(24) NOT NULL \
        ,USERIP VARCHAR(16) NOT NULL \
        ,ADMIN INT(1) NOT NULL \
        ,CLANID INT(2) NOT NULL \
        ,MONEY INT(10) NOT NULL \
        ,LEVEL INT(3) NOT NULL \
        ,EXP INT(3) NOT NULL) \
    ENGINE=INNODB"
 
#define SQL_USER_TABLE_2 "\
ALTER TABLE user_info \
    ADD( \
        KILLS INT(5) NOT NULL \
        ,DEATHS INT(5) NOT NULL \
        ,SKIN INT(5) NOT NULL \
        ,WEP1 INT(2) NOT NULL \
        ,WEP2 INT(2) NOT NULL \
        ,WEP3 INT(2) NOT NULL \
        ,INTERIOR INT(2) NOT NULL \
        ,WORLD INT(1) NOT NULL)"
 
#define SQL_USER_TABLE_3 "\
ALTER TABLE user_info \
    ADD(\
        POS_X DECIMAL (10,5) NOT NULL \
        ,POS_Y DECIMAL (10,5) NOT NULL \
        ,POS_Z DECIMAL (10,5) NOT NULL \
        ,ANGLE DECIMAL (10,5) NOT NULL \
        ,HP DECIMAL (3,0) NOT NULL \
        ,AM DECIMAL (3,0) NOT NULL)"
 
#define SQL_CLAN_TABLE "\
CREATE TABLE \
    clan_info( \
        ID INT PRIMARY KEY AUTO_INCREMENT \
        ,NAME VARCHAR(20) NOT NULL \
        ,LEADER_ID INT NOT NULL \
        ,KILLS INT(5) NOT NULL \
        ,DEATHS INT(5) NOT NULL \
        ,COLOR INT(10) NOT NULL \
        ,ZONE_LENGTH INT(3) NOT NULL \
        ,SKIN INT(3) NOT NULL \
    ) ENGINE=INNODB"
 
#define SQL_ZONE_TABLE "\
CREATE TABLE \
    zone_info( \
        ID INT PRIMARY KEY AUTO_INCREMENT \
        ,OWNER_CLAN INT(3) NOT NULL \
    ) ENGINE=INNODB"
 
#define SQL_VEHICLE_TABLE "\
CREATE TABLE \
    vehicle_info( \
        ID INT PRIMARY KEY AUTO_INCREMENT \
        ,OWNER_ID INT NOT NULL \
        ,POS_X DECIMAL (10,5) NOT NULL \
        ,POS_Y DECIMAL (10,5) NOT NULL \
        ,POS_Z DECIMAL (10,5) NOT NULL \
        ,ANGLE DECIMAL (10,5) NOT NULL \
        ,COLOR1 INT(3) NOT NULL \
        ,COLOR2 INT(3) NOT NULL \
    ) ENGINE=INNODB;"
 
#define SQL_HOUSE_TABLE "\
CREATE TABLE \
    house_info( \
        ID INT PRIMARY KEY AUTO_INCREMENT \
        ,OWNER_ID INT NOT NULL \
        ,OPEN INT(1) NOT NULL \
        ,ENTER_POS_X DECIMAL (10,5) NOT NULL \
        ,ENTER_POS_Y DECIMAL (10,5) NOT NULL \
        ,ENTER_POS_Z DECIMAL (10,5) NOT NULL \
        ,LEAVE_POS_X DECIMAL (10,5) NOT NULL \
        ,LEAVE_POS_Y DECIMAL (10,5) NOT NULL \
        ,LEAVE_POS_Z DECIMAL (10,5) NOT NULL \
    ) ENGINE=INNODB"
 
#define SQL_WEAPON_TABLE "\
CREATE TABLE \
    weapon_info( \
        ID INT PRIMARY KEY AUTO_INCREMENT \
        ,USER_ID INT NOT NULL \
        ,MODEL INT(4) NOT NULL \
    ) ENGINE=INNODB"
 
#define SQL_DUEL_TABLE "\
CREATE TABLE \
    duel_info( \
        ID INT PRIMARY KEY AUTO_INCREMENT, \
        WIN_ID INT, \
        LOSS_ID INT, \
        TYPE INT(1), \
        MONEY INT, \
        WIN_HP DECIMAL (3,0) NOT NULL, \
        WIN_AM DECIMAL (3,0) NOT NULL \
    ) ENGINE=INNODB"
 
/* DB DATA LOAD SELECT */
#define SQL_DATA_LOAD_USER "\
SELECT \
    ID \
FROM user_info \
LIMIT 1"
 
#define SQL_DATA_LOAD_HOUSE "\
SELECT \
    * \
FROM house_info"
 
#define SQL_DATA_LOAD_VEHICLE "\
SELECT \
    vehicle.ID\
    ,vehicle.OWNER_ID \
    ,(SELECT \
        NAME \
    FROM user_info \
    WHERE ID = vehicle.OWNER_ID) \
    AS OWNER_NAME \
    ,vehicle.POS_X \
    ,vehicle.POS_Y \
    ,vehicle.POS_Z \
    ,vehicle.ANGLE \
    ,vehicle.COLOR1 \
    ,vehicle.COLOR2 \
FROM vehicle_info \
AS vehicle"
 
#define SQL_DATA_LOAD_CALN "\
SELECT \
    clan.ID \
    ,clan.NAME \
    ,clan.LEADER_ID \
    ,user.NAME AS LEADER_NAME \
    ,clan.KILLS \
    ,clan.DEATHS \
    ,clan.COLOR \
    ,clan.ZONE_LENGTH \
FROM clan_info \
AS clan \
INNER JOIN \
user_info \
AS user \
ON clan.LEADER_ID = user.ID"
 
#define SQL_DATA_LOAD_ZONE "\
SELECT * \
FROM zone_info"
 
#define SQL_DATA_LOAD_WEAPON "\
SELECT ID \
FROM weapon_info \
LIMIT 1"
 
#define SQL_DATA_LOAD_DUEL "\
SELECT ID \
FROM duel_info"
 
/* USER LOG */
#define SQL_USER_WEAPON_JOIN "\
SELECT weapon.MODEL \
FROM user_info AS user \
INNER JOIN weapon_info \
AS weapon \
ON user.ID = weapon.USER_ID \
WHERE user.ID = %d"
 
#define SQL_USER_PASS_CHECK "\
SELECT ID, PASS \
FROM user_info \
WHERE NAME = '%s' \
LIMIT 1"
 
#define SQL_USER_INSERT "\
INSERT INTO user_info( \
    NAME \
    ,PASS \
    ,USERIP \
    ,ADMIN \
    ,CLANID \
    ,MONEY \
    ,LEVEL \
    ,EXP \
    ,KILLS \
    ,DEATHS \
    ,SKIN \
    ,WEP1 \
    ,WEP2 \
    ,WEP3 \
    ,INTERIOR \
    ,WORLD \
    ,POS_X \
    ,POS_Y \
    ,POS_Z \
    ,ANGLE \
    ,HP \
    ,AM) \
VALUES ('%s','%s','%s',%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%f,%f,%f,%f,%f,%f)"
 
#define SQL_USER_SELECT "\
SELECT \
    USERIP \
    ,ADMIN \
    ,CLANID \
    ,MONEY \
    ,LEVEL \
    ,EXP \
    ,KILLS \
    ,DEATHS \
    ,SKIN \
    ,WEP1 \
    ,WEP2 \
    ,WEP3 \
    ,INTERIOR \
    ,WORLD \
    ,(SELECT \
        COUNT(TYPE) \
    FROM duel_info \
    WHERE WIN_ID = %d) \
    AS DUEL_WIN \
    ,(SELECT \
        COUNT(TYPE) \
    FROM duel_info \
    WHERE LOSS_ID = %d) \
    AS DUEL_LOSS \
    ,POS_X \
    ,POS_Y \
    ,POS_Z \
    ,ANGLE \
    ,HP \
    ,AM \
FROM user_info \
WHERE ID = %d \
LIMIT 1"
 
/* USER LEVEL RANK LIST */
#define SQL_USER_LEVEL_RANK "\
SELECT \
    ID \
    ,NAME \
    ,LEVEL \
    ,KILLS \
    ,DEATHS \
FROM user_info \
ORDER BY LEVEL \
DESC LIMIT 10"
 
/* USER KILL RANK LIST */
#define SQL_USER_KILL_RANK "\
SELECT \
    ID \
    ,NAME \
    ,LEVEL \
    ,KILLS \
    ,DEATHS \
FROM user_info \
ORDER BY KILLS \
DESC LIMIT 10"
 
/* CALN INSERT */
#define SQL_CLAN_NAME_CHECK "\
SELECT \
    NAME \
FROM clan_info \
WHERE NAME = '%s' \
LIMIT 1"
 
#define SQL_CLAN_COLOR_CHECK "\
SELECT \
    NAME,COLOR \
FROM clan_info \
WHERE COLOR = %d \
LIMIT 1"
 
#define SQL_CLAN_INSERT_SUCCESS "\
INSERT INTO \
    clan_info( \
        NAME \
        ,LEADER_ID \
        ,KILLS \
        ,DEATHS \
        ,COLOR \
        ,ZONE_LENGTH \
        ,SKIN) \
    VALUES('%s',%d,0,0,%d,0,0)"
 
/* CLAN SKIN UPDATE */
#define SQL_CLAN_SKIN_UPDATE "\
UPDATE \
clan_info \
SET \
    SKIN = %d \
WHERE CLANID = %d"
 
/* CLAN ZONE LENTH UPDATE */
#define SQL_CLAN_ZONE_LENGTH "\
UPDATE \
clan_info \
SET \
    ZONE_LENGTH = %d \
WHERE ID = %d"
 
/* CLAN LIST SELECT */
#define SQL_CLAN_LIST "\
SELECT \
    NAME \
FROM clan_info \
LIMIT 10"
 
/* CLAN RANK SELECT */
#define SQL_CLAN_RANK "\
SELECT \
    NAME \
    ,ZONE_LENGTH \
FROM clan_info \
ORDER BY ZONE_LENGTH \
DESC LIMIT 10"
 
/* CLAN MEMBER LIST SELECT */
#define SQL_CLAN_MEMBER_LIST "\
SELECT \
    ID \
    ,NAME \
    ,LEVEL \
    ,KILLS \
    ,DEATHS \
FROM user_info \
WHERE CLANID = %d"
 
/* WEAPON BUY */
#define SQL_WEAPON_BUY_CHECK "\
SELECT \
    USER_ID \
FROM weapon_info \
WHERE USER_ID = %d \
AND MODEL = %d \
LIMIT 1"
 
#define SQL_WEAPON_BUY_SUCCESS "\
INSERT INTO \
    weapon_info( \
        USER_ID \
        ,MODEL) \
    VALUES(%d,%d)"
 
/* NAME EDIT */
#define SQL_NAME_EDIT_CHECK "\
SELECT \
    NAME \
FROM user_info \
WHERE NAME = '%s' \
LIMIT 1"
 
#define SQL_NAME_CLAN_EDIT "\
UPDATE \
user_info \
SET \
    NAME = '%s' \
WHERE ID = %d"
 
/* VEHICLE DATA */
#define SQL_VEHICLE_INIT_INSERT "\
INSERT INTO \
vehicle_info( \
    OWNER_ID \
    ,POS_X \
    ,POS_Y \
    ,POS_Z \
    ,ANGLE \
    ,COLOR1 \
    ,COLOR2) \
VALUES (0, %f, %f, %f, %f, 0, 0)"
 
#define SQL_VEHICLE_DATA_UPDATE "\
UPDATE \
vehicle_info \
    SET POS_X = %f \
    ,POS_Y = %f \
    ,POS_Z = %f \
    ,ANGLE = %f \
WHERE ID = %d"
 
#define SQL_VEHICLE_COLOR_UPDATE "\
UPDATE \
vehicle_info \
    SET \
        COLOR1 = %d \
        ,COLOR2 = %d \
    WHERE ID = %d"
 
#define SQL_VEHICLE_BUY_UPDATE "\
UPDATE \
vehicle_info \
    SET \
        OWNER_ID = %d \
    WHERE ID = %d"
 
/* MY VEHICLE LOG */
#define SQL_MYCAR_SELECT "\
SELECT \
    ID \
    FROM vehicle_info \
WHERE OWNER_ID=%d"
 
/* MY VEHICLE LENGTH CAR */
#define SQL_MYCAR_LENGTH "\
SELECT OWNER_ID \
FROM vehicle_info \
WHERE OWNER_ID=%d"
 
/* ZONE DATA */
#define SQL_ZONE_INIT_INSERT "\
INSERT INTO \
    zone_info( \
    OWNER_CLAN) \
VALUES (%d)"
 
#define SQL_ZONE_DATA_UPDATE "\
UPDATE \
    zone_info \
    SET \
OWNER_CLAN = %d \
WHERE ID = %d"
 
#define SQL_ZONE_DATA_SELECT "\
SELECT \
    OWNER_CLAN \
FROM zone_info"
 
/* DUEL INSERT */
 
#define SQL_DUEL_INSERT "\
INSERT INTO \
duel_info( \
    WIN_ID \
    ,LOSS_ID \
    ,TYPE \
    ,MONEY \
    ,WIN_HP \
    ,WIN_AM) \
VALUES(%d,%d,%d,%d,%f,%f)"
 
#define SQL_DUEL_SELECT "\
SELECT \
    ID \
    ,WIN_ID \
    ,(SELECT \
        NAME \
    FROM user_info \
    WHERE ID = duel.WIN_ID) \
    AS WIN_NAME \
    ,LOSS_ID \
    ,(SELECT \
        NAME \
    FROM user_info \
    WHERE ID = duel.LOSS_ID) \
    AS LOSS_NAME \
    ,TYPE \
    ,MONEY \
    ,WIN_HP \
    ,WIN_AM \
FROM duel_info \
AS duel \
ORDER BY ID \
DESC LIMIT 20"

#define GARAGE1_TEXT            "Southern Gas Station"
#define GARAGE2_TEXT            "Southern Gas Station 2F"
#define GARAGE3_TEXT            "Car Washer Workshop"
#define GARAGE4_TEXT            "Northern Gas Station"
#define GARAGE5_TEXT            "Flint County gas station"
#define MISSON1_TEXT            "Korean War Association"
#define MISSON2_TEXT            "Cappuccino Store"
#define MISSON3_TEXT            "Meeting Square"
#define MISSON4_TEXT            "Top Gun Dual Chapters"
#define MISSON5_TEXT            "Sweet Machine"
#define CLAN_CHAT               "(Clan Channel) %s(%d) : %s"
#define ADMIN_CHAT              "(Admin channel) Lv.%d %s(%d) : %s"
#define ALREADY_LOGIN           "    You are already logged in."
#define ONLY_LOGIN_CMD          "    Available after login."
#define TYPE_NOT_PASSWORD       "    Please enter a password."
#define YOU_NOT_PASSWORD        "    The password is incorrect."
#define JOIN_LOGIN              "    You are logged in."
#define JOIN_REGIST             "    I am a member."
#define LOG_SAVE                "    Saved."
#define LEVEL_TEN_BY_DEAGLE     "    Desert Eagle is available up to level 10."
#define IN_CAR_NOT_OWNER        "    It is a vehicle without an owner."
#define IN_CAR_WHO_OWNER        "    This vehicle is owned by [%s]"
#define CLAN_INVITE_YES         "    You became a member of [{%06x}%s{AFAFAF}] A Clan."
#define CLAN_INVITE_YES_CALL    "    %s has accepted your invitation to join the clan."
#define CLAN_INVITE_NOT         "    You have refused to invite [%s] the clan."
#define CLAN_INVITE_NOT_CALL    "    You have refused to invite [%s] the clan."
#define CLAN_HAVE_TEXT          "    You belong to the clan already."
#define CLAN_NOT_TEXT           "    You are not in the clan."
#define CLAN_NOT_LEADER_TEXT    "    It is not a clan leader."
#define CLAN_INSERT_NOT_MONEY   "    There is not enough money to create a clan. (8000�޷�)"
#define LOBBY_TEL_NOT_MONEY     "    Lobby also lacks funds to move. (2000�޷�)"
#define LOBBY_GO_TEXT           "    Moved to non-combat zone."
#define INPUT_TEXT_HANGUL       "    Hangul should not be included."
#define YOU_NOT_MYCAR           "    The vehicle you boarded is not your property."
#define CLAN_NAME_MIN_LENTH     "    Please enter at least 3 characters for the clan name."
#define CLAN_NAME_MAX_LENTH     "    Clan names can be up to 20 characters long."
#define YOU_NAME_MIN_LENTH      "    Please enter at least 3 characters for your nickname."
#define YOU_NAME_MAX_LENTH      "    Nickname must be at most 24 characters."
#define UNCLAN                  "No affiliation"
#define DIALOG_TITLE            "{8D8DFF}Samp War Korea"
#define DIALOG_ENTER            "Confirm"
#define DIALOG_PREV             "backwards"
#define DIALOG_CLOSE            "Close"
#define DIALOG_EXIT             "Leave"
#define DIALOG_STRAT            "Game progress"
#define YOU_NOT_ADMIN           "    Please acquire administrator privilege and use it."
#define YOU_CAR_NOT_HAVE        "    You do not have a car. Bidding on the roadside through [/carbuy]."
#define YOU_WEAPON_NOT_HAVE     "    We do not have weapons. Buy weapons at the cappuccino store in Alhambra [/lobby]."
#define CAR_NOT_IN              "    Please enter the command after boarding the vehicle."
#define CAR_HAVE_MAX_LENTH      "    You have exceeded the maximum number of vehicles."
#define SERVER_RESTART_TEXT     "    The server restarts. Please wait."
#define HELP_MONEY_TEXT         "    /money [id] [money]"
#define GIVE_NOT_MONEY_LENGTH   "    It is more than the amount of money you have."
#define GIVE_MONEY_GET          "    %d(%d) has been given %d dollars."
#define GIVE_MONEY_SEND         "    Pay %d dollars to %s(%d)."
#define HELP_PM_TEXT            "    /pm [id] [word]"
#define HELP_GIVEMONEY_TEXT     "    /servermoney [id] [money]"
#define HELP_TIME_TEXT          "    /time [time]"
#define HELP_KICK_TEXT          "    /kick [id]"
#define HELP_BOMB_TEXT          "    /bomb [id]"
#define HELP_IP_TEXT            "    /ip [id]"
#define HELP_CALL_TEXT          "    /call [id]"
#define HELP_ADMIN_TEXT         "    /admin [id] [level]"
#define HELP_GO_TEXT            "    /go [id]"
#define HELP_BAN_TEXT           "    /kick [id]"
#define HELP_PM_NOT_SELF        "    I can not send a whisper to myself."
#define ADMIN_GIVEMONEY_GET     "    I have received %d dollars from you."
#define ADMIN_GIVEMONEY_SEND    "    (Administrator function) %s will be paid to %d."
#define ADMIN_KICK_GET          "    The administrator will ban you."
#define ADMIN_KICK_SEND         "    (Administrator function) Expires %s."
#define ADMIN_BAN_GET           "    Your manager will expel you permanently."
#define ADMIN_BAN_SEND          "    (Administrator function) Permanently expires %s."
#define ADMIN_BOMB_GET          "    Your manager will blow you."
#define ADMIN_BOMB_SEND         "    (Administrator function) Explodes %s."
#define ADMIN_IP_SEND           "    (Administrator function) %s's ip is [%s]."
#define ADMIN_CALL_GET          "    Administrator will summon you."
#define ADMIN_CALL_SEND         "    (Administrator function) Summons %s."
#define ADMIN_GO_GET            "    Your manager will appear to you."
#define ADMIN_GO_SEND           "    (Administrator function) Appears to %s."
#define ADMIN_ADMIN_GET         "    Administrator gives you admin (%d rating) permissions."
#define ADMIN_ADMIN_SEND        "    (Administrator function) Admin (%d rating) management rights are given to%s."
#define ADMIN_NOT_MAX_LENGTH    "    You can not pay more than 4 levels of management."
#define ADMIN_SETTIME_NOTICE    "    Your administrator has adjusted your server environment to %d."
#define PM_SEND_TEXT            "(( PM sent to %s (%d) : %s ))"
#define PM_GET_TEXT             "(( PM %s(%d) : %s ))"
#define NO_DM_ZONE_TEXT         "    The other party is in the DM prohibited area."
#define NO_DM_ZONE_TEXT2        "    You can not fire a firearm out of the DM prohibited area."
#define NOT_DM_NO_WEAPON        "    You can not take out the firearm in the DM prohibited area."
#define ALREADY_CLAN_NAME       "    [%s] clan is an already existing clan."
#define ALREADY_CLAN_COLOR      "    {%06x}%06x{FFFFFF}The color is specified as the unique color of the [%s] clan."
#define YOU_CLAN_LEAVE          "    You have left the [%s] clan where you belonged."
#define YOU_CLAN_INSERT_SUCCESS "    You have created [{%06x}%s {AFAFAF}] clan."
#define CLAN_INVITE_USER_NAME   "    Please enter the nickname of the user you are inviting."
#define NOT_JOIN_USER           "    The user number that is not currently connected to the server."
#define CLAN_INVITE_REQ         "    %s tells you [{%06x}%s{AFAFAF}] You have been invited to join the clan."
#define CLAN_INVITE_RES         "    If you agree {8D8DFF}Y key{AFAFAF} Please press {FF0000} N key {AFAFAF} to decline."
#define YOU_NOT_CLAN_CHAT       "    It does not belong to the clan."
#define ALREADY_HAVE_WEAPON     "    You already have [%s]."
#define ALREADY_HOLD_WEAPON     "    This weapon is already set as the main weapon."
#define SKIN_MAX_299            "    Skins from 1 to 299 are present."
#define SKIN_NOT_CJ             "    CJ skins can not be selected by regulation."
#define SKIN_BUY_NOT_MONEY      "    There is not enough money to buy the skins. ($ 3,000)"
#define NAME_EDIT_NOT_MONEY     "    I do not have enough funds to change my nickname. ($ 20,000)"
#define ALREADY_NAME            "    This nickname already exists."
#define WEAPON_BUY_NOT_MONEY    "    There is not enough money to buy weapons."
#define WEAPON_BUY_SUCCESS      "    You purchased [%s] weapons."
#define WEAPON_BUY_HELP_TEXT    "    [/wep] Please use the command."
#define SKIN_BUY_SUCCESS        "    You have purchased %d skins."
#define NAME_EDIT_SUCCESS       "    You have changed your nickname to %s."
#define WEAPON_HOLD_SUCCESS     "    Attaches slot %d. to weapon [%s]"
#define WEAPON_PUT_SUCCESS      "    Removes slot %d weapon from [%s]"
#define IN_CAR_NOT_CAR_SPAWN    "    You can not be summoned when you are in a vehicle."
#define CAR_SPAWN_NOT_MONEY     "    There is not enough money to summon the vehicle."
#define CAR_SPAWN_SUCCESS       "    [%s] Summons the vehicle in front of you."
#define CAR_REPAIR_NOT_MONEY    "    There is not enough money to repair the car. ($100)"
#define CAR_REPAIR_SUCCESS      "    [%s] Repair the vehicle."
#define CAR_PAINT_NOT_MONEY     "    There is not enough money to paint the car. ($500)"
#define CAR_PAINT1_TEXT         "    Sets the type 1 color of the car."
#define CAR_PAINT2_TEXT         "    Sets the type 2 color of the car."
#define CAR_BUY_NOT_MONEY       "    There is not enough money to buy a car. (Bid: $ 30,000)"
#define CAR_ALREADY_SELL        "    It is already a vehicle with the owner."
#define CAR_BUY_SUCCESS         "    You have purchased [%s] vehicles."
#define GIVE_CASH               "$ %d"
#define GIVE_EXP                "%d EXP"
#define GARAGE_TEXT_LABEL       "%s (Horn(Caps Lock))"
#define MISSON_TEXT_LABEL       "%s (F Key)"
#define MISSON_CLAN_TEXT        "{FFFFFF}Clan Generation ($8000)\nClan List\nClan Ranking\nClan Information\nClan withdrawal"
#define MISSON_SHOP_TEXT        "{FFFFFF}Weapon\nSkin ($2000)\nAccessories\nChange nickname ($20,000)"
#define MISSON_NOTICE_TEXT      "{FFFFFF}Season Ranking"
#define MISSON_DUEL_TEXT        "{FFFFFF}Entrance\nRecently viewed dual games\n"
#define DUEL_LIST_DL_TITLE      "{8D8DFF}\t\tRecently viewed dual games{FFFFFF}\n\n"
#define DUEL_LIST_DL_CONTENT    "[The %dth Top Gun]\t\tWeapon: %s\tBetting dollar: $%d\t\tHP/AM: %.0f%/%.0f%\t\tWin: %s Loss: %s\n\n"
#define DUEL_DL_TYPE_TEXT       "{FFFFFF}Fist\nDesert Eagle\nDesert Eagle & Shotgun\nSniper Rifle & Shotgun\nSPAS & Country Rifle\nM4 & Shotgun"
#define DUEL_DL_MONEY_TEXT      "{FFFFFF}Please enter the betting amount of your living room with your opponent in the Dual I field."
#define DUEL_DL_SUCCESS_TEXT    "{FFFFFF}Do you want to proceed with dual warping under the following conditions?\n\nWeapon settings : %s\nBetting dollars : $ %d\n\n"
#define DUEL_OPEN1_TEXT         "[The %dth Top Gun] %s has held a dual war (Betting dollars : $%d) (weapon name : %s)"
#define DUEL_OPEN2_TEXT         "    You can board in a non-combat zone."
#define DUEL_OPEN3_TEXT         "    To exit, type the command [/re]."
#define DUEL_START_TEXT         "[The %dth Top Gun] %s and %s are playing. (Betting dollars : $%d) (weapon name : %s)"
#define DUEL_RESULT_TEXT        "[The %dth Top Gun] %s has won %s. (Betting dollars : $%d) (weapon name : %s) (HP/AM: %.0f%/%.0f%)"
#define DUEL_NOT_MONEY          "    You do not have enough funds for the current bet amount."
#define DUEL_KILL_NOT_CMD       "    Please use the [/re] command to replace dual standby."
#define DUEL_ALREADY_SETUP      "    Currently someone is in the Dual I setup."
#define DUEL_ALREADY_PROGRESS   "    Dual is currently in progress."
#define DUEL_NOT_CMD            "    You can not use this command while in dual mode."
#define MISSON_GAMBLE_TEXT      "{8D8DFF}Odd even number machine{FFFFFF}\n\nIf you make odd and even numbers, you get double the money.\n\n{8D8DFF}Game rules{FFFFFF}\neven(2,4) odd number(1,3) again(5) Boom(6)\n\n{AFAFAF}No maximum bet amount limit!{FFFFFF}\t\t{FFFF00}Double the prize!{FFFFFF}\n\nPlease bet.\n{AFAFAF}Tip: Do not enter $ 500{FFFFFF}\n\n"
#define GAMBLE_MIN_MONEY        "    You can bet at least $500."
#define GAMBLE_NOT_MONEY        "    I do not have enough money to do it. (At least $500)"
#define GAMBLE_RESULT_TEXT      "{8D8DFF} How many dice did you throw?{FFFFFF}\t\t{AFAFAF}Betting dollars : $%d{FFFFFF}\n\n Dice thrown by a dealer : {8D8DFF}%d{FFFFFF}\n Your choice : {8D8DFF}%s{FFFFFF}\n\n"
#define GAMBLE_DL_LOSE          "%s \t\t{CC0033}You are defeated! next time!{FFFFFF}\n\n"
#define GAMBLE_DL_WIN           "%s \t\t{FFFF00}Victory! Congratulations!{FFFFFF}\n\n"
#define GAMBLE_DL_REGAMBLE      "%s \t\t{FF9933}again! Careful choice!{FFFFFF}\n\n"
#define GAMBLE_DL_FAIL          "%s \t\t{660000}Boom! That's too bad!{FFFFFF}\n\n"
#define LOGIN_DL_TEXT           "{FFFFFF}Please log in"
#define REGIST_DL_TEXT          "{FFFFFF}Please register."
#define INFO_DL_TEXT            "Server Specification\nMy profile\nCommand Help\nSeason Rank Help\nAdmin Help"
#define MYCAR_DL_TEXT           "License plate : %d\t\tmodel name : %s\n\n"
#define GARAGE_DL_TEXT          "{FFFFFF}repair ($100)\nPaint ($500)\ntuning"
#define CLAN_LIST_DL_TITLE      "{8D8DFF}\t\tClan List{FFFFFF}\n\n"
#define CLAN_LIST_DL_CONTENT    "Clan name \t\t {%06x}%s{FFFFFF}\n\n"
#define CLAN_RANK_DL_TITLE      "{8D8DFF}\t\tClan Ranking{FFFFFF}\n\n"
#define CLAN_RANK_DL_CONTENT    "Top %d \t Total occupied area : %d\t\t{%06x}%s{FFFFFF}\n\n"
#define CLAN_SETUP_DL_TEXT      "{FFFFFF}Invite clan members\nList Clan Dollars\nClan Representative Skin"
#define CLAN_LEAVE_DL_TEXT      "{FFFFFF}Do you really want to leave the clan?"
#define CLAN_INSERT_DL_NAME     "{FFFFFF}Please enter your name."
#define CLAN_INSERT_DL_COLOR    "{FFFFFF}Random color view"
#define CLAN_RANDOM_COLOR_TEXT  "{%06x}color :\t\t%s\n\n{FFFFFF}Random colors are drawn."
#define CLAN_CHOICE_COLOR_TEXT  "{FFFFFF}Please specify the color of the clan."
#define CLAN_INSERT_DL_SUCCESS  "{FFFFFF}Clan name :\t\t%s\n\nClan color : \t\t{%06x}%06x{FFFFFF}\n\nWould you like to create a clan with the above conditions?\n\n(Deduction : $ 20000)"
#define CLAN_INVITE_TEXT        "{FFFFFF}Please enter the nickname of the person you wish to invite."
#define CLAN_MEMBER_CONTENT     "name : %s\t\tlevel %d\tKill - %d Death - %d K/D - %.01f% Rank - %s\n{FFFFFF}"
#define CLAN_MEMBER_SETUP       "{FFFFFF}Change position\nForced deportation"
#define CLAN_MEMBER_SETUP_RANK  "{FFFFFF}Rating 1\nRating 2\nRating 3"
#define CLAN_MEMBER_SETUP_KICK  "{FFFFFF}Are you really banned?"
#define CLAN_MEMBER_DL_SKIN     "{FFFFFF}Register representative skins\nGet a representative skin\n"
#define CLAN_MEMBER_SKIN_SETUP  "{FFFFFF} Please enter the number of the skin to register as the clan representative's skin."
#define CLAN_MEMBER_SKIN_UPDATE "{FFFFFF} Do you really want to change to a clan skin?"
#define CLAN_SKIN_EDIT_SUCCESS  "The clan representative skin has been renamed to [%d]."
#define YOU_CLAN_NOT_SKIN       "    There is currently no set clan representative skin."
#define CLAN_SKIN_GET_SUCCESS   "    Changed to clan representative skin. (Skin %d)"
#define CLAN_ONLY_LEADER        "    You are not a clan leader."
#define SHOP_DL_SKIN_TEXT       "{FFFFFF} Please enter the number of the skin you want to change."
#define SHOP_DL_ACC_TEXT        "{FFFFFF}hat\nMask"
#define SHOP_DL_NAME_TEXT       "{FFFFFF} Please enter your nickname to change."
#define SHOP_DL_WEAPON_BUY_TEXT "{FFFFFF}weapon name :\t\t%s\n\nDo you really want to buy that weapon?\n\n(Deduction : $%d)"
#define SHOP_DL_SKIN_BUY_TEXT   "{FFFFFF}skin number :\t\t%d\n\nDo you really want to buy that skin?\n\n(Deduction : $2000)"
#define SHOP_DL_NAME_EDIT_TEXT  "{FFFFFF}Nickname to change :\t\t%s\n\nAre you sure you want to change to this nickname?\n\n(Deduction : $20000)"
#define SEASON_DL_LEVEL_TITLE   "{8D8DFF}\t\tSamp War Level Ranking - Total 10{FFFFFF}\n\n"
#define SEASON_DL_KILL_TITLE    "{8D8DFF}\t\tSamp War most Kills Ranking - Total 10{FFFFFF}\n\n"
#define SEASON_DL_CONTENT_TEXT  "Level : %d\tKill : %d Deaths : %d K/D %.01f% Rank %s{FFFFFF}\t|{8D8DFF}Top %d{FFFFFF}\tName : %s\n\n"
#define MYWEP_SETUP_SLOT_TITLE  "Mainspring slot"
#define MYWEP_SETUP_SLOT_NONE   "Empty"
#define MYWEP_DL_OPTION_TEXT    "{FFFFFF}Mounting\nDesorption\n"
#define MYWEP_DL_HOLD_TEXT      "{FFFFFF}slot %d :\t\t%s\n\nDo you really want to install the selected weapon?\n"
#define MYWEP_DL_PUT_TEXT       "{FFFFFF}slot %d :\t\t%s\n\nDo you really want to remove the selected weapon?\n"
#define MYCAR_SETUP_TEXT        "{FFFFFF}Summons($500)"
#define MYCAR_DL_SPAWN_TEXT     "{FFFFFF}Vehicle model name :\t\t%s\n\nDo you really want to summon that vehicle?\n\n(Deduction : $500)"
#define GARAGE_DL_REPAIR_TEXT   "{FFFFFF}Do you really want to repair the vehicle you boarded?\n\n(Deduction : $100)"
#define GARAGE_DL_PAINT_SETUP   "{FFFFFF}Please enter the paint number you want to paint."
#define GARAGE_DL_TURNING_TEXT  "{FFFFFF}Wheel\nBonnet\nbumper"
#define GAMBLE_DL_CHOICE_TEXT   "{FFFFFF}odd number\neven"
#define ZONE_CLAN_HOLD_TEXT     "    The section %d is occupying that {%06x}[%s] {AFAFAF} clan "
#define ZONE_CLAN_HAVED_TEXT    "    {%06x}[%s] {AFAFAF} Clan occupied area %d. (Lead occupant: %s)"

    #define DL_LOGIN                          100
    #define DL_REGIST                         101
    #define DL_INFO                           102
    #define DL_MENU                           103
    #define DL_MISSON_CLAN                    104
    #define DL_MISSON_SHOP                    105
    #define DL_MISSON_NOTICE                  106
    #define DL_MYWEP                          107
    #define DL_MYCAR                          108
    #define DL_GARAGE                         109
    #define DL_MISSON_DUEL                    110
    #define DL_MISSON_GAMBLE                  111

    #define DL_CLAN_INSERT                    1040
    #define DL_CLAN_INSERT_COLOR              10400
    #define DL_CLAN_INSERT_COLOR_RANDOM       10401
    //#define DL_CLAN_INSERT_COLOR_CHOICE       10402
    #define DL_CLAN_INSERT_SUCCESS            10403

    #define DL_CLAN_LIST                      1041
    #define DL_CLAN_RANK                      1042
    #define DL_CLAN_SETUP                     1043
    #define DL_CLAN_LEAVE                     1044

    #define DL_CLAN_SETUP_INVITE              10430
    #define DL_CLAN_SETUP_MEMBER              10431
    #define DL_CLAN_SETUP_MEMBER_SETUP        10433
    #define DL_CLAN_SETUP_MEMBER_SETUP_RANK   10434
    #define DL_CLAN_SETUP_MEMBER_SETUP_KICK   10435

    #define DL_CLAN_SETUP_SKIN                10436
    #define DL_CLAN_SETUP_SKIN_SETUP          10437
    #define DL_CLAN_SETUP_SKIN_UPDATE         10438

    #define DL_SHOP_WEAPON                    1050
    #define DL_SHOP_SKIN                      1051
    #define DL_SHOP_ACC                       1052
    #define DL_SHOP_NAME                      1053

    #define DL_SHOP_WEAPON_BUY                10500
    #define DL_SHOP_SKIN_BUY                  10510
    #define DL_SHOP_NAME_EDIT                 10540

    #define DL_NOTICE_SEASON                  1060

    #define DL_MYWEP_SETUP                    1070
    #define DL_MYWEP_SETUP_OPTION             1071
    #define DL_MYWEP_SETUP_HOLD               1072
    #define DL_MYWEP_SETUP_PUT                1073

    #define DL_MYCAR_SETUP                    1080
    #define DL_MYCAR_SETUP_SPAWN              1081

    #define DL_GARAGE_REPAIR                  1090
    #define DL_GARAGE_PAINT                   1091
    #define DL_GARAGE_TURNING                 1092

    #define DL_DUEL_TYPE                      1100
    #define DL_DUEL_MONEY                     1101
    #define DL_DUEL_SUCCESS                   1102
    #define DL_DUEL_INFO                      1103

    #define DL_GAMBLE_CHOICE                  1110
    #define DL_GAMBLE_REGAMBLE                1111
    #define DL_GAMBLE_RESULT                  1112

    #define COL_SYS  0xAFAFAF99

    /* IS CHECK */
    #define IS_CLEN_HAVE          500
    #define IS_CLEN_NOT           501
    #define IS_CLEN_LEADER        502
    #define IS_CLEN_INSERT_MONEY  503

    /*ZONE BASE */
    #define USED_PLAYER    51
    #define USED_ZONE      932
    #define USED_TEXTDRAW  200
    #define USED_WEAPON    11
    #define USED_VEHICLE   230
    #define USED_HOUSE     500
    #define USED_CLAN      100
    #define USED_MISSON    5
    #define USED_GARAGE    5
    #define USED_DUEL      2
    #define USED_DUEL_LIST 20

    #define PRESSED(%0) \
        (((newkeys & (%0)) == (%0)) && ((oldkeys & (%0)) != (%0)))
    #define RELEASED(%0) \
        (((newkeys & (%0)) != (%0)) && ((oldkeys & (%0)) == (%0)))

    new FALSE = false;
    #define formatMsg(%0,%1,%2)\
        do{\
            new _str[256];\
            format(_str,256,%2);\
            SendClientMessage(%0,%1,_str);\
        }\
        while(FALSE)

    #define formatMsgAll(%0,%1,%2)\
        do{\
            new _str[256];\
            format(_str,256,%1,%2);\
            SendClientMessageToAll(%0,_str);\
        }\
        while(FALSE)

    #define rgbToHex(%0,%1,%2,%3) %0 << 24 | %1 << 16 | %2 << 8 | %3

    tierInfo(){
        new str[1024];
        strcat( str, "\t\t\t\t\t{8D8DFF}Season Rank Help{FFFFFF}\n\n");
        strcat( str, "{804040}◎Bronze {FFFFFF}K/D Ratio 50% {7FFF00}↑\n\n");
        strcat( str, "{C0C0C0}▼Sliver {FFFFFF}K/D Ratio 50% {7FFF00}↑\n\n");
        strcat( str, "{FFFF00}▣Gold {FFFFFF}K/D Ratio 55% {7FFF00}↑\n\n");
        strcat( str, "{00FFFF}⊙Platinum {FFFFFF}K/D Ratio 60% {7FFF00}↑\n\n");
        strcat( str, "{1229FA}◈Diamond {FFFFFF}K/D Ratio 70% {7FFF00}↑\n\n");
        strcat( str, "{FF0000}▩Challenger {FFFFFF}K/D Ratio 80%  {7FFF00}↑{FFFFFF} 3rd place in K / D server ranking {7FFF00}↑\n\n");
        strcat( str, "\n");
        strcat( str, "{8D8DFF}From level 3{FFFFFF} A tier appears at the top of the head.");
        return str;
    }

    adminInfo(){
        new str[1024];
        strcat( str, "\t\t\t\t\t{8D8DFF}Admin Help{FFFFFF}\n\n");
        strcat( str, "{8D8DFF}1 rating{FFFFFF}\n");
        strcat( str, "/kick\n");
        strcat( str, "/time\n");
        strcat( str, "{8D8DFF}2 rating{FFFFFF}\n");
        strcat( str, "/bomb\n");
        strcat( str, "/ip\n");
        strcat( str, "{8D8DFF}3 rating{FFFFFF}\n");
        strcat( str, "/ban\n");
        strcat( str, "/call\n");
        strcat( str, "/go\n");
        strcat( str, "{8D8DFF}4 rating{FFFFFF}\n");
        strcat( str, "/admin\n");
        strcat( str, "/restart\n");
        strcat( str, "\n");
        strcat( str, "{8D8DFF}Admin channel{FFFFFF}: @Say\n");
        return str;
    }