- [en]
- NO_ENOUGH_PLAYERS = !tNo Enough Players!y. !tRequired!y: !t%i!y.
- RUN_NOTICE = Ready for Run. Run After %i Second(s) !
- ZOMBIE_RELEASE = Zombie(s) Will Be Released After: %i Second(s) !
- READY_TO_RUN = !tAre you Ready to Run!y? !gGood Luck !y:)
- ESCAPE_SUCCESS = Escape Success!
- ESCAPE_FAIL = Escape Fail!
- START_GAME = Game Commencing!
- INFECTION_NOTICE = %s has infected %s !
- SCORE_MESSAGE = Zombies VS Humans^n %i --------- %i
- NO_WINNER = Escape Draw!
- RANK_INFO = [MASTER OF SURVIVAL]^n[1st] - %s^n[2nd] - %s^n[3rd] - %s
- RANK_INFO_LEADER = [Escape Leader]^n%s
- COINS_INFO = !tYour Current Escape Coins!y: !g%i
- ESCAPE_SUCCESS_COINS = !tEscape Success!y: !t+!g%i !tEscape Coins!y!
- HUMAN_INFECTED_COINS = !tInfected Human!y: !t+!g%i !tEscape Coins!y!
- ZOMBIE_SPEC = Spectating: %s^nHP: %i^nClass: Zombie^nEscape Coins: %i^nEscapes: %i
- ZOMBIE_SPEC_COMMAS = Spectating: %s^nHP: %s^nClass: Zombie^nEscape Coins: %i^nEscapes: %i
- HUMAN_SPEC = Spectating: %s^nHP: %i^nClass: Human^nEscape Coins: %i^nEscapes: %i
- HUMAN_SPEC_COMMAS = Spectating: %s^nHP: %s^nClass: Human^nEscape Coins: %i^nEscapes: %i
- HUMAN_SPEC_LEADER = Spectating: %s^nHP: %i^nClass: Escape Leader^nEscape Coins: %i^nEscapes: %i
- HUMAN_SPEC_COMMAS_LEADER = Spectating: %s^nHP: %s^nClass: Escape Leader^nEscape Coins: %i^nEscapes: %i
- ZOMBIE = HP: %i | Class: Zombie | Escape Coins: %i | Escapes: %i
- ZOMBIE_COMMAS = HP: %s | Class: Zombie | Escape Coins: %i | Escapes: %i
- HUMAN_LEADER = HP: %i | Class: Escape Leader | Escape Coins: %i | Escapes: %i
- HUMAN_LEADER_COMMAS = HP: %s | Class: Escape Leader | Escape Coins: %i | Escapes: %i
- HUMAN = HP: %i | Class: Human | Escape Coins: %i | Escapes: %i
- HUMAN_COMMAS = HP: %s | Class: Human | Escape Coins: %i | Escapes: %i
- BUY_ENABLED = !tYour menu has been re-enabled!y.
- RE_ENABLE_MENU = !tsay /enable or press M to enable your buy menu!y.
- ALREADY_BOUGHT = !tYou already bought Primary and Secondary Weapons!y!
- DEAD_CANT_BUY_WEAPON = !tYou can't buy when you're dead!y.
- NO_BUY_ZOMBIE = !tYou can't buy when you're Zombie!y.
- BUY_MENU_TIME_EXPIRED = !tBuy menu time has expired!y.
- MENU_PRIMARY_TITLE = Primary Weapons
- MENU_SECONDARY_TITLE = Secondary Weapons
- MENU_AUTOSELECT = Remember?
- SAVE_YES = Yes
- SAVE_NO = No
- NEXT = Next
- BACK = Back
- EXIT = Exit
- MAIN_MENU_TITLE = [ZE] Main Menu
- MENU_EXTRABUY = Buy Extra Items
- MENU_WEAPONBUY = Buy Weapons
- MENU_WEAPONBUY_RE_ENABLE = Re-enable Buy Weapons
- BUY_EXTRAITEM = Extra Items
- NO_EXTRA_ITEMS = !tNo extra items are currently available to you!y.
- ITEM_LIMIT = \w[\r%i\d|\r%i\w]
- ITEM_LEVEL = \w[\rLevel\d: \r%i\w]
- ITEM_VIP = \w(\rVIP\w)
- [bp]
- NO_ENOUGH_PLAYERS = !tFalta jogadores!y. !tNecessario!y: !t%i!y.
- RUN_NOTICE = Pronto pra Fugir?. Falta apenas %i segundos !
- ZOMBIE_RELEASE = Zumbis liberados em: %i Segundos !
- READY_TO_RUN = !tPronto para fugir!y? !gBoa Sorte !y:)
- ESCAPE_SUCCESS = Fugiram com sucesso!
- ESCAPE_FAIL = Falharam na fuga!
- START_GAME = Iniciando a Partida!
- INFECTION_NOTICE = %s foi infectado %s !
- SCORE_MESSAGE = Zombis VS Humanos^n %i --------- %i
- NO_WINNER = Voce perdeu!
- RANK_INFO = [MESTRE DE SOBREVIVENCIA]^n[1°] - %s^n[2°] - %s^n[3°] - %s
- RANK_INFO_LEADER = [Lider da Fuga]^n%s
- COINS_INFO = !tSeus Coins!y: !g%i
- ESCAPE_SUCCESS_COINS = !tConseguiram Fugir!y: !t+!g%i !tEscape Coins!y!
- HUMAN_INFECTED_COINS = !tInfectou Humano!y: !t+!g%i !tEscape Coins!y!
- ZOMBIE_SPEC = Assistindo: %s^nHP: %i^nClasse: Zombi^nEscape Coins: %i
- ZOMBIE_SPEC_COMMAS = Assistindo: %s^nHP: %s^nClasse: Zombi^nEscape Coins: %i
- HUMAN_SPEC = Assistindo: %s^nHP: %i^nClasse: Humano^nEscape Coins: %i
- HUMAN_SPEC_COMMAS = Assistindo: %s^nHP: %s^nClasse: Humano^nEscape Coins: %i
- HUMAN_SPEC_LEADER = Assistindo: %s^nHP: %i^nClasse: Lider da Fuga^nEscape Coins: %i
- HUMAN_SPEC_COMMAS_LEADER = Assistindo: %s^nHP: %s^nClasse: Lider da Fuga^nEscape Coins: %i
- ZOMBIE = HP: %i | Classe: Zombi | Escape Coins: %i
- ZOMBIE_COMMAS = HP: %s | Classe: Zombi | Escape Coins: %i
- HUMAN_LEADER = HP: %i | Classe: Lider da Fuga | Escape Coins: %i
- HUMAN_LEADER_COMMAS = HP: %s | Classe: Lider da Fuga | Escape Coins: %i
- HUMAN = HP: %i | Classe: Humano | Escape Coins: %i
- HUMAN_COMMAS = HP: %s | Classe: Humano | Escape Coins: %i
- BUY_ENABLED = !tSeu menu foi reativado!y.
- RE_ENABLE_MENU = !tdigite /enable ou aperte M para ativar seu menu de compras!y.
- ALREADY_BOUGHT = !tVocê já comprou Armas Primárias e Secundárias!y!
- DEAD_CANT_BUY_WEAPON = !tMorto não pode comprar Armas Primárias e Secundárias!y.
- NO_BUY_ZOMBIE = !tVocê não pode comprar pois é zumbi!y.
- BUY_MENU_TIME_EXPIRED = !tO tempo de compra expirou!y.
- MENU_PRIMARY_TITLE = Armas Primárias
- MENU_SECONDARY_TITLE = Armas Secundárias
- MENU_AUTOSELECT = Relembrar?
- SAVE_YES = Sim
- SAVE_NO = Nao
- NEXT = Proximo
- BACK = Volta
- EXIT = Sair
- MAIN_MENU_TITLE = [ZE] Menu Principal
- MENU_EXTRABUY = Comprar Itens Especiais
- MENU_WEAPONBUY = Comprar Armas
- MENU_WEAPONBUY_RE_ENABLE = Reabilite as armas compradas
- BUY_EXTRAITEM = Extra Itens
- NO_EXTRA_ITEMS = !tNão há itens extras disponíveis para você!y.
- ITEM_LIMIT = \w[\r%i\d|\r%i\w]
- ITEM_LEVEL = \w[\rLevel\d: \r%i\w]
- ITEM_VIP = \w(\rVIP\w)
- [pl]
- NO_ENOUGH_PLAYERS = !tBrak wystarczjacej liczby graczy!y. !tWymagana liczba!y: !t%i!y.
- RUN_NOTICE = Gotowy do ucieczki. Biegnij po %i sekundach !
- ZOMBIE_RELEASE = Zombie zostanie wypuszczone za: %i sekund !
- READY_TO_RUN = !tGotowy do ucieczki!y? !gPOWODZENIA !y:)
- ESCAPE_SUCCESS = Udana ucieczka!
- ESCAPE_FAIL = Nieudana ucieczka!
- START_GAME = Rozpoczecie gry!
- INFECTION_NOTICE = %s zarazil %s !
- SCORE_MESSAGE = Zombie VS Ludzie^n %i --------- %i
- NO_WINNER = Remis!
- RANK_INFO = [Mistrz przetrwania]^n[1st] - %s^n[2nd] - %s^n[3rd] - %s
- RANK_INFO_LEADER = [LIDER UCIECZKI]^n%s
- COINS_INFO = !tTwoja aktualna ilosc monet!y: !g%i
- ESCAPE_SUCCESS_COINS = !tUdana ucieczka!y: !t+!g%i !tmonet!y!
- HUMAN_INFECTED_COINS = !tZarazono czlowieka!y: !t+!g%i !tmonet!y!
- ZOMBIE_SPEC = Spectating: %s^nHP: %i^nKlasa: Zombie^nIlosc monet: %i
- ZOMBIE_SPEC_COMMAS = Spectating: %s^nHP: %s^nKlasa: Zombie^nIlosc monet: %i
- HUMAN_SPEC = Ogladanie: %s^nHP: %i^nKlasa: Czlowiek^nIlosc monet: %i
- HUMAN_SPEC_COMMAS = Ogladanie: %s^nHP: %s^nKlasa: Czlowiek^nIlosc monet: %i
- HUMAN_SPEC_LEADER = Ogladanie: %s^nHP: %i^nKlasa: Escape Lider^nIlosc monet: %i
- HUMAN_SPEC_COMMAS_LEADER = Ogladanie: %s^nHP: %s^nKlasa: Escape Lider^nIlosc monet: %i
- ZOMBIE = HP: %i | Klasa: Zombie | Ilosc monet: %i
- ZOMBIE_COMMAS = HP: %s | Klasa: Zombie | Ilosc monet: %i
- HUMAN_LEADER = HP: %i | Klasa: Escape Lider| Ilosc monet: %i
- HUMAN_LEADER_COMMAS = HP: %s | Klasa: Escape Lider | Ilosc monet: %i
- HUMAN = HP: %i | Klasa: Czlowiek | Ilosc monet: %i
- HUMAN_COMMAS = HP: %s | Class: Human | Escape Coins: %i
- BUY_ENABLED = !tYour menu has been re-enabled!y.
- RE_ENABLE_MENU = !tsay /enable or press M to enable your buy menu!y.
- ALREADY_BOUGHT = !tJuz kupiles bron!y!
- DEAD_CANT_BUY_WEAPON = !tNie mozesz kupic broni, kiedy jestes martwy!y.
- NO_BUY_ZOMBIE = !tNie mozesz kupic broni, kiedy jestes Zombie!y.
- BUY_MENU_TIME_EXPIRED = !tCzas kupowania broni sie skonczyl!y.
- MENU_PRIMARY_TITLE = Bron podstawowa
- MENU_SECONDARY_TITLE = Bron dodatkowa
- MENU_AUTOSELECT = Zapamietac?
- SAVE_YES = Tak
- SAVE_NO = Nie
- NEXT = Nastepny
- BACK = Powrot
- EXIT = Wyjscie
- MAIN_MENU_TITLE = [ZE] Glowne Menu
- MENU_EXTRABUY = Kup dodatkowe przedmioty
- MENU_WEAPONBUY = Kup bronie
- MENU_WEAPONBUY_RE_ENABLE = Wlacz ponowne kupowanie broni
- BUY_EXTRAITEM = Dodatkowe przedmioty
- NO_EXTRA_ITEMS = !tAktulanie dodatkowe przedmioty nie sa dostepne!y.
- ITEM_LIMIT = \w[\r%i\d|\r%i\w]
- ITEM_LEVEL = \w[\rPoziom\d: \r%i\w]
- ITEM_VIP = \w(\rVIP\w)
- [bs]
- NO_ENOUGH_PLAYERS = !tNema dovoljno igraca!y. !tPotrebno!y: !t%i!y.
- RUN_NOTICE = Spremite se za bijeg. Bjezite nakon %i sekundi !
- ZOMBIE_RELEASE = Zombiji ce biti pusteni nakon: %i sekundi !
- READY_TO_RUN = !tDa li ste spremni!y? !gSRETNO !y:)
- ESCAPE_SUCCESS = Uspjesan bijeg!
- ESCAPE_FAIL = Neuspjesan bijeg!
- START_GAME = Pokretanje igre!
- INFECTION_NOTICE = %s je zarazio %s !
- SCORE_MESSAGE = Zombiji VS Ljudi^n %i --------- %i
- NO_WINNER = Bez pobjednika!
- RANK_INFO = [MAJSTOR PREZIVLJAVANJA]^n[1st] - %s^n[2nd] - %s^n[3rd] - %s
- RANK_INFO_LEADER = [Lider bijega]^n%s
- COINS_INFO = !tVas trenutni broj kovanica!y: !g%i
- ESCAPE_SUCCESS_COINS = !tUspješan bijeg!y: !t+!g%i !tKovanica!y!
- HUMAN_INFECTED_COINS = !tZarazili ste covjeka!y: !t+!g%i !tKovanica!y!
- ZOMBIE_SPEC = Gledate: %s^nHP: %i^nVrsta: Zombi^nBroj kovanica: %i
- ZOMBIE_SPEC_COMMAS = Gledate: %s^nHP: %s^nKlasa: Zombi^nBroj kovanica: %i
- HUMAN_SPEC = Gledate: %s^nHP: %i^nVrsta: Covjek^nBroj kovanica: %i
- HUMAN_SPEC_COMMAS = Gledate: %s^nHP: %s^nVrsta: Covjek^nBroj kovanica: %i
- HUMAN_SPEC_LEADER = Gledate: %s^nHP: %i^nKlasa: Lider bijega^nBroj kovanica: %i
- HUMAN_SPEC_COMMAS_LEADER = Gledate: %s^nHP: %s^nKlasa: Lider bijega^nBroj kovanica: %i
- ZOMBIE = HP: %i | Vrsta: Zombi | Broj kovanica: %i
- ZOMBIE_COMMAS = HP: %s | Vrsta: Zombi | Broj kovanica: %i
- HUMAN_LEADER = HP: %i | Klasa: Lider bijega | Broj kovanica: %i
- HUMAN_LEADER_COMMAS = HP: %s | Klasa: Lider bijega | Broj kovanica: %i
- HUMAN = HP: %i | Vrsta: Covjek | Broj kovanica: %i
- HUMAN_COMMAS = HP: %s | Vrsta: Covjek | Broj kovanica: %i
- BUY_ENABLED = !tPonovo ste aktivirali meni za odabir oruzja!y.
- RE_ENABLE_MENU = !tnapisite /enable ili pritisnite slovo M da aktivirate meni za odabir oruzja!y.
- ALREADY_BOUGHT = !tVec ste odabrali svoje oruzje!y!
- DEAD_CANT_BUY_WEAPON = !tNe mozete odabrati oruzje kada ste mrtvi!y.
- NO_BUY_ZOMBIE = !tNe mozete odabrati oruzje kada ste zombi!y.
- BUY_MENU_TIME_EXPIRED = !tVrijeme za odabir oruzja je isteklo!y.
- MENU_PRIMARY_TITLE = Osnovno oruzje
- MENU_SECONDARY_TITLE = Dodatno oruzje
- MENU_AUTOSELECT = Zapamtiti?
- SAVE_YES = Da
- SAVE_NO = Ne
- NEXT = Sljedece
- BACK = Povratak
- EXIT = Izlaz
- MAIN_MENU_TITLE = [ZE] Glavni Meni
- MENU_EXTRABUY = Kupite dodatke
- MENU_WEAPONBUY = Odaberite oruzje
- MENU_WEAPONBUY_RE_ENABLE = Ponovo aktivirajte meni za odabir oruzja
- BUY_EXTRAITEM = Dodaci
- NO_EXTRA_ITEMS = !tDodaci trenutno nisu dostupni!y.
- ITEM_LIMIT = \w[\r%i\d|\r%i\w]
- ITEM_LEVEL = \w[\rLevel\d: \r%i\w]
- ITEM_VIP = \w(\rVIP\w)
- This plugin is going to be like escapes counter for humans only.
| Cvars:
Code: Select all
ze_escapes_host // Host to connect to ze_escapes_user // User to login with ze_escapes_pass // Password ze_escapes_dbname // Database
| Code:
- #include <zombie_escape>
- // Static (Change it if you need)
- new const g_szLogFile[] = "Human_Escapes.log" // MySQL Errors log file
- // MySQL Table
- new const g_szTable[] =
- "ALTER TABLE `zombie_escape` ADD IF NOT EXISTS `Escapes` INT(10) NOT NULL DEFAULT '0';"
- // Variables
- new g_iEscapes[33],
- Handle:g_hTuple
- // Cvars
- new g_pCvarDBInfo[4]
- // Database
- enum
- {
- Host = 0,
- User,
- Pass,
- DB
- }
- // Natives
- public plugin_natives()
- {
- register_native("ze_get_user_escapes", "native_ze_get_user_escapes", 1)
- register_native("ze_set_user_escapes", "native_ze_set_user_escapes", 1)
- }
- public plugin_init()
- {
- register_plugin("[ZE] Addons: Escapes (MySQL)", "1.1", "Jack GamePlay")
- // Cvars
- g_pCvarDBInfo[Host] = register_cvar("ze_escapes_host", "localhost")
- g_pCvarDBInfo[User] = register_cvar("ze_escapes_user", "user")
- g_pCvarDBInfo[Pass] = register_cvar("ze_escapes_pass", "pass")
- g_pCvarDBInfo[DB] = register_cvar("ze_escapes_dbname", "dbname")
- // Initialize MySQL - Delay 0.1 second required so we make sure that our zombie_escape.cfg already executed and cvars values loaded from it
- set_task(0.1, "Delay_MySQL_Init")
- }
- public Delay_MySQL_Init()
- {
- MySQL_Init()
- }
- public MySQL_Init()
- {
- new szHost[64], szUser[32], szPass[32], szDB[128]
- get_pcvar_string(g_pCvarDBInfo[Host], szHost, charsmax(szHost))
- get_pcvar_string(g_pCvarDBInfo[User], szUser, charsmax(szUser))
- get_pcvar_string(g_pCvarDBInfo[Pass], szPass, charsmax(szPass))
- get_pcvar_string(g_pCvarDBInfo[DB], szDB, charsmax(szDB))
- g_hTuple = SQL_MakeDbTuple(szHost, szUser, szPass, szDB)
- // Let's ensure that the g_hTuple will be valid, we will access the database to make sure
- new iErrorCode, szError[512], Handle:hSQLConnection
- hSQLConnection = SQL_Connect(g_hTuple, iErrorCode, szError, charsmax(szError))
- if(hSQLConnection != Empty_Handle)
- {
- log_amx("[MySQL][ESCAPES] Successfully connected to host: %s (ALL IS OK).", szHost)
- SQL_FreeHandle(hSQLConnection)
- }
- else
- {
- // Disable plugin, and display the error
- set_fail_state("[ESCAPES] Failed to connect to MySQL database: %s", szError)
- }
- // Create our table
- SQL_ThreadQuery(g_hTuple, "QueryCreateTable", g_szTable)
- }
- public QueryCreateTable(iFailState, Handle:hQuery, szError[], iError, szData[], iSize, Float:flQueueTime)
- {
- SQL_IsFail(iFailState, iError, szError, g_szLogFile)
- }
- public client_putinserver(id)
- {
- if (is_user_bot(id) || is_user_hltv(id))
- return
- // Just 1 second delay
- set_task(1.0, "DelayLoad", id)
- }
- public DelayLoad(id)
- {
- LoadEscapes(id)
- }
- public plugin_end()
- {
- if (g_hTuple != Empty_Handle)
- {
- SQL_FreeHandle(g_hTuple)
- }
- }
- public ze_roundend(WinTeam)
- {
- if (WinTeam == ZE_TEAM_HUMAN)
- {
- for (new id = 0; id <= get_member_game(m_nMaxPlayers); id++)
- {
- if (!is_user_alive(id) || ze_is_user_zombie(id))
- continue
- g_iEscapes[id] ++
- SaveEscapes(id)
- }
- }
- }
- LoadEscapes(id)
- {
- new szAuthID[35], szQuery[128], szData[5]
- get_user_authid(id, szAuthID, charsmax(szAuthID))
- formatex(szQuery, charsmax(szQuery), "SELECT `Escapes` FROM `zombie_escape` WHERE ( `SteamID` = '%s' );", szAuthID)
- num_to_str(id, szData, charsmax(szData))
- SQL_ThreadQuery(g_hTuple, "QuerySelectData", szQuery, szData, charsmax(szData))
- }
- public QuerySelectData(iFailState, Handle:hQuery, szError[], iError, szData[])
- {
- if (SQL_IsFail(iFailState, iError, szError, g_szLogFile))
- return
- new id = str_to_num(szData)
- // No results for this query means that player not saved before
- if (!SQL_NumResults(hQuery))
- {
- // This is new player
- g_iEscapes[id] = 0
- return
- }
- g_iEscapes[id] = SQL_ReadResult(hQuery, SQL_FieldNameToNum(hQuery, "Escapes"))
- }
- SaveEscapes(id)
- {
- new szAuthID[36], szQuery[128]
- get_user_authid(id, szAuthID, charsmax(szAuthID))
- formatex(szQuery, charsmax(szQuery), "UPDATE `zombie_escape` SET `Escapes` = '%d' WHERE `SteamID` = '%s';", g_iEscapes[id], szAuthID)
- SQL_ThreadQuery(g_hTuple, "QueryUpdateData", szQuery)
- }
- public QueryInsertData(iFailState, Handle:hQuery, szError[], iError, szData[], iSize, Float:flQueueTime)
- {
- SQL_IsFail(iFailState, iError, szError, g_szLogFile)
- }
- public QueryUpdateData(iFailState, Handle:hQuery, szError[], iError, szData[], iSize, Float:flQueueTime)
- {
- SQL_IsFail(iFailState, iError, szError, g_szLogFile)
- }
- // Natives
- public native_ze_get_user_escapes(id)
- {
- if (!is_user_connected(id))
- {
- log_error(AMX_ERR_NATIVE, "[ZE] Invalid Player id (%d)", id)
- return false
- }
- return g_iEscapes[id]
- }
- public native_ze_set_user_escapes(id, iAmount)
- {
- if (!is_user_connected(id))
- {
- log_error(AMX_ERR_NATIVE, "[ZE] Invalid Player id (%d)", id)
- return false
- }
- g_iEscapes[id] = iAmount
- SaveEscapes(id)
- return true
- }