lvl_systema - в чат пишет s1 - s2

Bars

Пользователь
Регистрация
10 Июн 2017
Сообщения
76
Симпатии
4
Пол
Мужской
Код:
#include <amxmodx>
#include <hamsandwich>
#include <cstrike>
#include <sqlx>

new iOneStepKills =    10
new iUserKillsStep = 15

new iUserLevel[33], iUserKills[33], iLevelNext[33]
new iMaxPlayers, gMsgSayText

new Host[]     = "80.77.174.154"
new User[]    = "u117967amfn"
new Pass[]     = "nPAUC3oDklEwvdm6bgJE"
new Db[]     = "db117967"

new Handle:g_SqlTuple
new g_Error[512]

public plugin_init()
{
    register_plugin("LVL System [MySQL]", "1.0", "MaJIou' / Remake by Pain")
    
    register_message(get_user_msgid("SayText"),"Tekst") // Отлавливаем событие написания игроком сообщения
    
    RegisterHam(Ham_Killed, "player", "fw_Killed", 1)
    
    iMaxPlayers = get_maxplayers()
    gMsgSayText = get_user_msgid("SayText")
    set_task(1.0, "MySql_Init")
}

public plugin_precache() precache_sound("MG_SOUND/levelup.wav" )

public plugin_natives()
{
    register_native("get_level", "native_get_level", 1)
    register_native("set_level", "native_set_level", 1)
}

public native_get_level(id)
{
    return iUserLevel[id]
}

public native_set_level(id, level)
{
    iUserLevel[id] = level
    Save_MySql(id)
}
    
public client_putinserver(id)
{
    iUserLevel[id] = 0
    iUserKills[id] = 0
    iLevelNext[id] = 0
    
    Load_MySql(id)
    set_task(2.0, "CheckLevel", id)
}

public client_disconnect(id)
{
    Save_MySql(id)
    remove_task(id + 123321)
}


public MySql_Init()
{
    // we tell the API that this is the information we want to connect to,
    // just not yet. basically it's like storing it in global variables
    g_SqlTuple = SQL_MakeDbTuple(Host, User, Pass, Db)
  
    // ok, we're ready to connect
    new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple, ErrorCode, g_Error, charsmax(g_Error))
    if(SqlConnection == Empty_Handle)
        // stop the plugin with an error message
        set_fail_state(g_Error)
      
    new Handle:Queries
    // we must now prepare some random queries
    Queries = SQL_PrepareQuery(SqlConnection, "CREATE TABLE IF NOT EXISTS tutorial (name varchar(32),next INT(11),kills INT(11),level INT(11))")

    if(!SQL_Execute(Queries))
    {
        // if there were any problems
        SQL_QueryError(Queries, g_Error, charsmax(g_Error))
        set_fail_state(g_Error)
      
    }
    
    // close the handle
    SQL_FreeHandle(Queries)
  
    // you free everything with SQL_FreeHandle
    SQL_FreeHandle(SqlConnection)
}

public Load_MySql(id)
{
    new szName[32], szTemp[512]
    get_user_name(id, szName, charsmax(szName))
    
    new Data[1]
    Data[0] = id
    
    //we will now select from the table `tutorial` where the steamid match
    format(szTemp, charsmax(szTemp), "SELECT * FROM `tutorial` WHERE (`tutorial`.`name` = '%s')", szName)
    SQL_ThreadQuery(g_SqlTuple, "register_client", szTemp, Data, 1)
}

public register_client(FailState, Handle:Query, Error[], Errcode, Data[], DataSize)
{
    if(FailState == TQUERY_CONNECT_FAILED)
    {
        log_amx("Load - Could not connect to SQL database.  [%d] %s", Errcode, Error)
    }
    else if(FailState == TQUERY_QUERY_FAILED)
    {
        log_amx("Load Query failed. [%d] %s", Errcode, Error)
    }

    new id
    id = Data[0]
    
    if(SQL_NumResults(Query) < 1)
    {
        //.if there are no results found
        
        new szName[32]
        get_user_name(id, szName, charsmax(szName)) // get user's name
        
        //  if its still pending we can't do anything with it
        if (equal(szName,"ID_PENDING"))
            return PLUGIN_HANDLED
            
        new szTemp[512]
        
        // now we will insturt the values into our table.
        format(szTemp, charsmax(szTemp), "INSERT INTO `tutorial` ( `name` , `level`, `kills`, `next`) VALUES ('%s',%i,%i,%i);", szName, iUserLevel[id], iUserKills[id], iLevelNext[id])
        
        //DEBUG
        server_print("%s", szTemp)
        
        SQL_ThreadQuery(g_SqlTuple, "IgnoreHandle", szTemp)
    }
    else
    {
        new iNext, sNext[11],
        iLevel, sLevel[11],
        iKills, sKills[11]
        
        iNext = SQL_FieldNameToNum(Query, "next")
        iLevel = SQL_FieldNameToNum(Query, "level")
        iKills = SQL_FieldNameToNum(Query, "kills")
        
        SQL_ReadResult(Query, iNext, sNext, charsmax(sNext))
        SQL_ReadResult(Query, iLevel, sLevel, charsmax(sLevel))
        SQL_ReadResult(Query, iKills, sKills, charsmax(sKills))
        
        iLevelNext[id]        = str_to_num(sNext)
        iUserLevel[id]        = str_to_num(sLevel)
        iUserKills[id]        = str_to_num(sKills)
    }
    
    return PLUGIN_HANDLED
}

public Save_MySql(id)
{
    new szName[32], szTemp[512]
    get_user_name(id, szName, charsmax(szName))
    
    // Here we will update the user hes information in the database where the steamid matches.
    format(szTemp, charsmax(szTemp), "UPDATE `tutorial` SET `Level` = '%i' ,  `kills` = '%i',  `next` = '%i'  WHERE `tutorial`.`name` = '%s';", iUserLevel[id], iUserKills[id], iLevelNext[id], szName)
    SQL_ThreadQuery(g_SqlTuple, "IgnoreHandle", szTemp)
}

public IgnoreHandle(FailState, Handle:Query, Error[], Errcode, Data[], DataSize)
{
    SQL_FreeHandle(Query)
    
    return PLUGIN_HANDLED
}

public plugin_end() SQL_FreeHandle(g_SqlTuple)

public CheckLevel(id)
{

    if(iUserLevel[id] < 1)
    {
        iUserLevel[id] = 1
        iLevelNext[id] = iOneStepKills
    }

    Task_Player(id, 1.0)
}

public fw_Killed(victim, attacker, corpse)
{
    new gName[32]
    get_user_name(attacker, gName, charsmax( gName ))
    
    if(!is_user_connected(victim) || !is_user_connected(attacker) || victim == attacker)
        return

    iUserKills[attacker]++

    if(iUserKills[attacker] >= iLevelNext[attacker])
    {
        iLevelNext[attacker] += iUserKillsStep
        iUserLevel[attacker]++
        
        if(iUserLevel[attacker] == (2 | 3 | 4 | 5 | 8 | 10 | 15 | 20))
            colored_print(attacker, "^x03[LEVEL] Достижение^x04 %d ^x03уровня. Вам стали доступны новые товары в магазине!", iUserLevel[attacker], iLevelNext[attacker])
        else
            colored_print(attacker, "^x03[LEVEL] Вы достигли^x04 %d ^x03уровня. Следующий через^x04 %d ^x03убийств", iUserLevel[attacker], iLevelNext[attacker])
        
        colored_print(0, "^x03[LEVEL] ^x01Игрок^x04 %s ^x03достиг уровня^x04 %i", gName, iUserLevel[attacker])
    
        iUserKills[attacker] = 0
        client_cmd(attacker, "spk MG_SOUND/levelup.wav")
    }
    
}

public Tekst(msgId,msgDest,msgEnt)
{
    new id = get_msg_arg_int(1) // сокращаем ид игрока который пишет сообщения
    
    if(!is_user_connected(id)) return PLUGIN_CONTINUE;
    
    new szTmp[256],szTmp2[256], szPrefix[64];
    get_msg_arg_string(2,szTmp, charsmax( szTmp ) ) // поулчаем написаное сообщение
 
    if(get_user_flags(id) & ADMIN_CHAT)
    {
        formatex(szPrefix, charsmax( szPrefix ), "^x03[^x04ADMIN^x03]^x03[^x04%i LVL^x03]^x04", iUserLevel[id])
    }
    else
    {
        formatex(szPrefix, charsmax( szPrefix ), "^x04[%i LVL]", iUserLevel[id])
    } 
    if(!equal(szTmp,"#Cstrike_Chat_All")) // Если чат между коммандой
    {
        add(szTmp2,charsmax(szTmp2),szPrefix); // Ставим наш префикс
        add(szTmp2,charsmax(szTmp2)," ");
        add(szTmp2,charsmax(szTmp2),szTmp); // Сообщение
    }
    else
    { // Если чат общий
        add(szTmp2,charsmax(szTmp2),szPrefix); //наш префикс
        add(szTmp2,charsmax(szTmp2)," ^x03%s1^x01: ^x01%s2") // Имя игрока и сообщение
    }
    set_msg_arg_string(2,szTmp2); //Устанавливаем вид который мы сделали выше
    return PLUGIN_CONTINUE // Продолжаем работу плагина
}

public PlayerInfo(id)
{
    id -= 123321
    
    set_hudmessage(0, 255, 255, -1.0, 0.10, 0, 6.0, 1.1);
    show_hudmessage(id, "Уровень: %d^nУбийств: %i | До сл. уровня: %i ^nНаша Группа: vk.com/csscreative", iUserLevel[id], iUserKills[id], iLevelNext[id] - iUserKills[id])
}

stock colored_print( target, const message[],  any:... )
{
    static buffer[ 512 ]

    if( !target )
    {
        static player
        for( player = 1; player <= iMaxPlayers; player++ )
        {
            if ( !is_user_connected( player ) )
            continue;

            vformat( buffer, charsmax( buffer ), message, 3 )

            message_begin( MSG_ONE_UNRELIABLE, gMsgSayText, _, player )
            write_byte( player )
            write_string( buffer )
            message_end()
        }
    }

    else
    {
        vformat( buffer, charsmax( buffer ), message, 3 )

        message_begin( MSG_ONE, gMsgSayText, _, target )
        write_byte( target )
        write_string( buffer )
        message_end()
    }
}

stock Task_Player(const id, Float:TIME)
{
    if(task_exists(id + 123321))
        remove_task(id + 123321)
            
    set_task(TIME, "PlayerInfo", id + 123321, _, _, "b")
}
[DOUBLEPOST=1563407106][/DOUBLEPOST]Не могу понять почему в чат выдает s1 - s2, знатоки выручите как подправить эту проблему?
 

Вложения

Molodoi

Команда форума
Модератор
Регистрация
14 Июн 2017
Сообщения
608
Симпатии
126
Bars, посмотрите правку в коде в первом посту написано что исправлен баг [2.8] Lite Translit
 

Bars

Пользователь
Регистрация
10 Июн 2017
Сообщения
76
Симпатии
4
Пол
Мужской
Сверху Снизу