Участник
Пользователь
- Сообщения
- 103
- Реакции
- 9
- Ошибка
-
Перезапись данных в столбцах таблицы mysql сервера (сброс уровня игроков, привязанного по SteamID).
- ОС
- Linux
- Amx Mod X
-
AMX Mod X 1.9.0.5241 (http://www.amxmodx.org) Authors: David "BAILOPAN" Anderson, Pavol "PM OnoTo" Marko Felix "SniperBeamer" Geyer, Jonny "Got His Gun" Bergstrom Lukasz "SidLuke" Wlasinski, Christian "Basic-Master" Hammacher Borja "faluco" Ferrer, Scott "DS" Ehlert Compiled: Jan 30 2019 07:09:07 Built from: https://github.com/alliedmodders/amxmodx/commit/2110037 Build ID: 5241:2110037 Core mode: JIT+ASM32C++
- Билд
-
Protocol version 48 Exe version 1.1.2.7/Stdio (cstrike) ReHLDS version: 3.7.0.692-dev Build date: 18:58:01 Sep 21 2019 (1988) Build from: https://github.com/dreamstalker/rehlds/commit/e7232beC++
- ReGamedll
-
ReGameDLL version: 5.13.0.434-dev Build date: 09:36:38 Dec 26 2019 Build from: https://github.com/s1lentq/ReGameDLL_CS/commit/7983a9dC++
- Версия Metamod
-
Metamod-r v1.3.0.128, API (5:13) Metamod-r build: 17:47:54 Aug 24 2018 Metamod-r from: https://github.com/theAsmodai/metamod-r/commit/0cf2f70C++
- Список метамодулей
-
Currently loaded plugins: description stat pend file vers src load unload [ 1] SafeNameAndChat RUN - SafeNameAndChat.so v1.1 ini ANY ANY [ 2] Reunion RUN - reunion_mm_i386.so v0.1.0.92 ini Start Never [ 3] ReAuthCheck RUN - reauthcheck_mm_i386.so v0.1.6 ini Start Never [ 4] VoiceTranscoder RUN - VoiceTranscoder.so v2017RC3 ini ANY ANY [ 5] AMX Mod X RUN - amxmodx_mm_i386.so v1.9.0.5241 ini Start ANY [ 6] Rechecker RUN - rechecker_mm_i386.so v2.5 ini Chlvl ANY [ 7] ReSemiclip RUN - resemiclip_mm_i386.so v2.3.9 ini Chlvl ANY [ 8] MySQL RUN - mysql_amxx_i386.so v1.9.0.5241 pl5 ANY ANY [ 9] ReAPI RUN - reapi_amxx_i386.so v5.12.0.192-dev pl5 ANY Never [10] Ham Sandwich RUN - hamsandwich_amxx_i386.so v1.9.0.5241 pl5 ANY ANY [11] CStrike RUN - cstrike_amxx_i386.so v1.9.0.5241 pl5 ANY ANY [12] FakeMeta RUN - fakemeta_amxx_i386.so v1.9.0.5241 pl5 ANY ANY [13] Fun RUN - fun_amxx_i386.so v1.9.0.5241 pl5 ANY ANY [14] Engine RUN - engine_amxx_i386.so v1.9.0.5241 pl5 ANY ANY [15] GeoIP RUN - geoip_amxx_i386.so v1.9.0.5241 pl5 ANY ANY 15 plugins, 15 runningC++
- Список плагинов
-
Currently loaded plugins: name version author file status [ 1] [AMXX] DeathRun Stats 1.0 Komap AMXX_DeathRunSt debug [ 2] GameCMS_API 5.2.9 zhorzh78 gamecms_api.amx running [ 3] GameCMS_GagManager 2.2.2 zhorzh78 gamecms_gagmana running [ 4] Lite Bans 2.2 neygomon lite_bans_off.a running [ 5] GameCMS Time Awards 1.4 API_5 zhorzh78 gamecms_time_aw running [ 6] Maps Menu 1.9.0.5234 AMXX Dev Team mapsmenu.amxx running [ 7] Admin Votes 1.8.3-dev+ AMXX Dev Team adminvote.amxx running [ 8] Lite MapChooser 2.6 neygomon mapchooser.amxx running [ 9] [AMXX] NewYear v2 2.1.1 Komap AMXX_Xmas.amxx debug [ 10] [AMXX] Fireworks 1.1.3 Komap AMXX_XmasFireWo debug [ 11] Reklama 30.11.2018 mx?! reklama.amxx running [ 12] Demo Recorder 2.4.0 F@nt0M demo_recorder.a running [ 13] Players Menu 1.7 neugomon players_menu.am running [ 14] Ping Control 1.31 neygomon ping_control.am running [ 15] [AMXX] CKPUH_III_OT Komap 1.0 info.amxx running [ 16] Frost Trap 1.11 R3X DeathRun_FrostT running [ 17] Deathrun Manager 3.0.3 modi xPaw / smowin / DeathRun_MainMo debug [ 18] Level [MySQL] + speed 1.0 Kulogram/Evolut DeathRun_LevelS running [ 19] DeathRun Duels 3.2 Sho0ter & CaNiBa DeathRun_Duels. running [ 20] DeathRun Games 1.0 [Forze]*Misterio DeathRun_Games. running [ 21] DeathRun Shop 1.0 [Forze]*Misterio DeathRun_Shop.a running [ 22] DeathRun Seller 1.0 [Forze]*Misterio DeathRun_Seller debug [ 23] Чеки 0.7 BlackSmoke DeathRun_CheckP running [ 24] DeathRun Knife Mod 1.0 [Forze]*Misterio DeathRun_KnifeS running [ 25] plugin_trail 1.3.2 Bahrmanou,Nickro DeathRun_TrailS running [ 26] [DR]AutoBhop 1.0 DeathRun_Bhop.a running [ 27] DeathRun menu 1.0 [Forze]*Misterio DeathRun_Menu.a debug [ 28] Auto Join on Connect 0.1 VEN DeathRun_AutoJo running [ 29] AdminMenu 1.0 bublik DeathRun_VipMen running [ 30] AdminMenu 1.0 bublik DeathRun_AdminM running [ 31] AdminMenu 1.0 bublik DeathRun_BossMe running [ 32] AdminMenu 1.0 bublik DeathRun_SuperM running [ 33] AdminMenu 4.1 SkocH & Schibeki DeathRun_SuperG running [ 34] DeathRun Hook 1.0 [Forze]*Misterio DeathRun_Hook.a running [ 35] SpecList 1.2a SasaiLalka DeathRun_SpecLi running [ 36] [DR] HidePlayers 1.0 Komap AMXX_DR_HidePla running [ 37] VIP Tag 0.1 c-s.net.ua VipTab.amxx running [ 38] [reAPI] Flash Control 1.1 neugomon flash_control.a running [ 39] Paint Marker 1.1 w0w paint_marker.am debug [ 40] Walls Creator 1.1 d3m37r4 walls_creator.a debug [ 41] CMS_SkinManager 1.2 zhorhz78 CMS_SkinManager running [ 42] AFK Kicker by Leo_[BH] 2.0 Leo_[BH] / Chees afkkicker.amxx running [ 43] unknown unknown unknown transfer.amxx running [ 44] [ReAPI] Block 'Fire in 0.0.1 sergrib block_fith.amxx running [ 45] resetscore(ReAPI) 1.0 Phantom re_rs.amxx running [ 46] knopki 1.0 StudenT knopki.amxx running [ 47] Invisible Spectator 1.0 ReHLDS Team re_invis_spec.a running [ 48] [183] Analizator 19.10.08 SKAJIbnEJIb analizator.amxx running [ 49] Lite Translit 2.8 neygomon lite_translit.a running 49 plugins, 49 runningC++
- Автор плагина
- Kulogram/Evolution
- Версия плагина
- 1.0
- Исходный код
-
#include < amxmodx > #include < cstrike > #include < sqlx > #include < hamsandwich > #include < fakemeta > #include < amxmisc > #define PLUGIN " Level [MySQL] + speedometr " #define VERSION " 1.0 " #define AUTHOR " Kulogram/Evolution " new OneKill = 15 // Сколько нужно убить что бы получить 2 уровень new TwoKill = 30 // + 10 убийств к следующему уровню ( На 2 уровне, нужно будет убить 50 игроков.) new Level[ 33 ] , UserKills[ 33 ] , LevelNext[ 33 ], g_Money[ 33 ] new MaxPlayers, TaskEnt, ShowSpeed new bool:plrSpeed[33] new const KEYSMENU = MENU_KEY_1|MENU_KEY_2|MENU_KEY_3|MENU_KEY_4|MENU_KEY_5|MENU_KEY_6|MENU_KEY_7|MENU_KEY_8|MENU_KEY_9|MENU_KEY_0 new const g_szSoundLevel[][] = { "Event_Levels/Level_Up.wav" } // [ Start: MYSQL ] new g_szQuery[ 2048 ] , szAuthID[ 33 ][ 32 ] ; new Handle: g_hDBTuple , Handle: g_hConnect ; new const szHost[ ] = "31.31.198.41" , szUser[ ] = "" , szPassword[ ] = "" , szDataBase[ ] = "" , szTableName[ ] = "Forze_Level_System" // [ End: MYSQL ] public plugin_init() { register_plugin( PLUGIN , VERSION , AUTHOR ) register_forward(FM_Think, "Think") TaskEnt = engfunc(EngFunc_CreateNamedEntity, engfunc(EngFunc_AllocString, "info_target")) set_pev(TaskEnt, pev_classname, "speedometer_think") set_pev(TaskEnt, pev_nextthink, get_gametime() + 1.01) RegisterHam( Ham_Killed , "player" , "Player_Killing" , 1 ); RegisterHam( Ham_Spawn , "player" , "Player_Spawn" , 1 ); register_menu( "Menu_1" , KEYSMENU , "ClCmd_Moneymenu" ); register_clcmd( "MoneyMenu" , "ClCmd_Moneymenunew" ); MaxPlayers = get_maxplayers(); ShowSpeed = register_cvar("showspeed", "1") } public plugin_natives() { register_native( "SetUserLevel" , "NativeSetUserLevel" , 1 ) register_native( "GetUserLevel" , "NativeGetUserLevel" , 1 ) register_native( "SetUserNext" , "NativeSetUserNext" , 1 ) register_native( "GetUserNext" , "NativeGetUserNext" , 1 ) register_native( "GetUserGold" , "native_get_money" , 1 ) register_native( "SetUserGold" , "native_set_money" , 1 ) } public plugin_precache() precache_sound( "Event_Levels/Level_Up.wav" ) public Think(ent) { if(ent == TaskEnt) { Info() set_pev(ent, pev_nextthink, get_gametime() + 0.1) } } public Player_Killing( victim , attacker ) { if( !is_user_connected( attacker ) || Level[attacker] >= 100 ) return HAM_IGNORED UserKills[attacker] += 1 g_Money[ attacker ] += random_num( 1 , 10 ) if(UserKills[attacker] >= LevelNext[attacker]) { LevelNext[attacker] += TwoKill Level[attacker] += 1 client_print( attacker , print_center , "Вы достигли %d уровня. Следующий через %d убийств" , Level[ attacker ] , LevelNext[ attacker ] ) UserKills[ attacker ] = 0 client_cmd( attacker , "spk %s" , g_szSoundLevel ) } return PLUGIN_HANDLED; } public Player_Spawn( pPlayer ) { if( !is_user_connected( pPlayer ) ) return; set_task( 2.0 , "Check_Level" , pPlayer ) } public Info() { static target static Float:velocity[3] static Float:speedh for(new pPlayer = 0; pPlayer <= MaxPlayers; pPlayer++) { if(!is_user_bot(pPlayer) && is_user_connected(pPlayer) || (!plrSpeed[pPlayer])) { target = pev(pPlayer, pev_iuser1) == 4 ? pev(pPlayer, pev_iuser2) : pPlayer pev(target, pev_velocity, velocity) speedh = floatsqroot(floatpower(velocity[0], 2.0) + floatpower(velocity[1], 2.0)) set_hudmessage(0, 255, 0, -1.0, 0.89, 0, 0.0, 0.1, 0.01, 0.0) if(Level [ pPlayer ] <= 99) { show_hudmessage( pPlayer , "Скорость: %3.2f^nЗолото: %d | Уровень: %d | Опыт: %i / %i" , speedh , g_Money[ pPlayer ], Level[ pPlayer ] , UserKills[ pPlayer ] , LevelNext[ pPlayer ] , UserKills[ pPlayer ] ) } else { show_hudmessage( pPlayer , "Скорость: %3.2f^nЗолото: %d | Уровень: 100 | Максимум" , speedh, g_Money[ pPlayer ] ) } } } return PLUGIN_CONTINUE } public Check_Level( pPlayer ) { if( Level[ pPlayer ] < 1 ) { Level[ pPlayer ] = 1 LevelNext[ pPlayer ] = OneKill } } public ClCmd_Moneymenunew( pPlayer ) { static menu[ 1048 ], len len = 0 len += formatex( menu[ len ] , charsmax( menu ) - len , "\wВыдача золота^n^n" ) if( get_user_flags( pPlayer ) & ADMIN_CVAR ) len += formatex( menu[ len ] , charsmax( menu ) - len , "\y1. \wВыдать: \d[1000 золота]^n" ) else len += formatex( menu[ len ] , charsmax( menu ) - len , "\y1. \dВыдать: \r[1000 золота]^n" ) len += formatex( menu[ len ] , charsmax( menu ) - len , "^n^n\y0. \wВыход" , pPlayer ) show_menu( pPlayer , KEYSMENU , menu , -1 , "Menu_1" ); } public ClCmd_Moneymenu( pPlayer , key ) { switch ( key ) { case 0: { MenuPlayer( pPlayer ) } } return PLUGIN_HANDLED } public MenuPlayer( pPlayer ) { if( get_user_flags( pPlayer ) & ADMIN_CVAR ) { new i_Menu = menu_create( "\wВыбери игрока", "menu_handle" ) new s_Players[ 32 ], i_Num, i_Player new s_Name[ 32 ], s_Player[ 10 ], text[ 128 ] get_players( s_Players , i_Num ) for ( new i; i < i_Num; i++ ) { i_Player = s_Players[ i ] get_user_name( i_Player , s_Name , charsmax( s_Name ) ) num_to_str( i_Player , s_Player , charsmax( s_Player ) ) formatex( text , charsmax( text ) , "\w%s \y[\d%d\y]" , s_Name , g_Money[ i_Player ] ) menu_additem( i_Menu , text , s_Player , 0 ) } menu_setprop( i_Menu, MPROP_EXITNAME , "Выход" ) menu_setprop( i_Menu, MPROP_NEXTNAME , "Далее" ) menu_setprop( i_Menu, MPROP_BACKNAME , "Назад" ) menu_display( pPlayer , i_Menu , 0 ) } else client_print( pPlayer , print_center , "НЕТ ДОСТУПА." ) } public menu_handle( pPlayer , menu , item ) { if ( item == MENU_EXIT ) { menu_destroy( menu ) return PLUGIN_HANDLED } new s_Data[ 6 ] , s_Name[ 64 ] , i_Access , i_Callback menu_item_getinfo( menu , item , i_Access , s_Data , charsmax( s_Data ) , s_Name , charsmax( s_Name ) , i_Callback ) new i_Player = str_to_num( s_Data ) g_Money[ i_Player ] += 1000 client_print( i_Player , print_center , "Вы получили 1000 золота." ) menu_destroy( menu ) return PLUGIN_HANDLED } // [ Start: MYSQL ] public plugin_cfg( ) { new szError[ 512 ] , iErrorCode; g_hDBTuple = SQL_MakeDbTuple ( szHost , szUser , szPassword , szDataBase ); g_hConnect = SQL_Connect( g_hDBTuple , iErrorCode , szError , charsmax( szError ) ); if ( g_hConnect == Empty_Handle ) set_fail_state( szError ); if ( !SQL_TableExists( g_hConnect , szTableName ) ) { new Handle: Queries; new Query [ 1024 ]; format( Query , 1023 , "CREATE TABLE `%s` (AuthID VARCHAR(40) CHARACTER SET cp1250 COLLATE cp1250_general_ci NOT NULL, Money INT NOT NULL, Level INT NOT NULL, Kills INT NOT NULL, NextKills INT NOT NULL, PRIMARY KEY (AuthID))" , szTableName ); Queries = SQL_PrepareQuery( g_hConnect, Query ); if ( !SQL_Execute( Queries ) ) { SQL_QueryError( Queries , szError ,charsmax( szError ) ); set_fail_state( szError ); } SQL_FreeHandle ( Queries ); } SQL_QueryAndIgnore( g_hConnect , "SET NAMES utf8" ); } public plugin_end ( ) { if( g_hDBTuple ) SQL_FreeHandle( g_hDBTuple ); if( g_hConnect ) SQL_FreeHandle( g_hConnect ); return; } public client_putinserver( pPlayer ) { new iParams [ 1 ]; iParams [ 0 ] = pPlayer; get_user_authid( pPlayer, szAuthID [ pPlayer ] , charsmax( szAuthID[ ] ) ); plrSpeed[pPlayer] = ShowSpeed > 0 ? true : false format( g_szQuery , charsmax( g_szQuery ) , "SELECT * FROM `%s` WHERE ( `%s`.`AuthID` = '%s' )", szTableName , szTableName , szAuthID [ pPlayer ] ); SQL_ThreadQuery( g_hDBTuple, "SQL_QueryConnection", g_szQuery, iParams, sizeof iParams ); } public client_disconnect( pPlayer ) { format( g_szQuery , charsmax( g_szQuery ), "UPDATE `%s` SET `Money` = '%d' , `Level` = '%i' , `Kills` = '%i' , `NextKills` = '%i' WHERE `%s`.`AuthID` = '%s';", szTableName , g_Money[ pPlayer ] , Level[ pPlayer ] , UserKills[ pPlayer ] , LevelNext[ pPlayer ] , szTableName , szAuthID [ pPlayer ] ); SQL_ThreadQuery( g_hDBTuple, "ThreadQueryHandler", g_szQuery ); } public SQL_QueryConnection ( iState , Handle: hQuery , szError [ ] , iErrcode , iParams [ ] , iParamsSize ) { switch ( iState ) { case TQUERY_CONNECT_FAILED: log_amx ( "Load - Could not connect to SQL database. [%d] %s" , iErrcode , szError ); case TQUERY_QUERY_FAILED: log_amx ( "Load Query failed. [%d] %s" , iErrcode , szError ); } new pPlayer = iParams[ 0 ]; if ( SQL_NumResults( hQuery ) < 1 ) { if ( equal( szAuthID [ pPlayer ] , "ID_PENDING" ) ) return PLUGIN_HANDLED; Level [ pPlayer ] = 0; g_Money [ pPlayer ] = 0; format( g_szQuery , charsmax( g_szQuery ), "INSERT INTO `%s` ( `AuthID` , `Money` , `Level` , `Kills` , `NextKills` ) VALUES ( '%s' , '%d' , '%i' , '%i' , '%i' );", szTableName , szAuthID [ pPlayer ] , g_Money[ pPlayer ] , Level [ pPlayer ] , UserKills [ pPlayer ] , LevelNext [ pPlayer ] ); SQL_ThreadQuery( g_hDBTuple , "ThreadQueryHandler" , g_szQuery ); return PLUGIN_HANDLED; } else { g_Money [ pPlayer ] = SQL_ReadResult ( hQuery , 1 ); Level [ pPlayer ] = SQL_ReadResult ( hQuery , 2 ); UserKills [ pPlayer ] = SQL_ReadResult ( hQuery , 3 ); LevelNext [ pPlayer ] = SQL_ReadResult ( hQuery , 4 ); } return PLUGIN_HANDLED; } public ThreadQueryHandler( iState , Handle: hQuery , szError [ ], iError , iParams [ ] , iParamsSize ) { if ( iState == 0 ) return; log_amx( "SQL Error: %d (%s)" , iError , szError ); } stock bool: SQL_TableExists ( Handle: db , const szTable [ ] ) { new Handle: query = SQL_PrepareQuery ( db , "SELECT * FROM information_schema.tables WHERE table_name = '%s' LIMIT 1;" , szTable ); new g_Error [ 512 ]; if ( !SQL_Execute ( query ) ) { SQL_QueryError ( query , g_Error , charsmax ( g_Error ) ); set_fail_state ( g_Error ); } else if ( !SQL_NumResults ( query ) ){ SQL_FreeHandle ( query ); return false; } SQL_FreeHandle ( query ); return true; } public NativeSetUserLevel( pPlayer , iValue ) { Level [ pPlayer ] = iValue; format( g_szQuery , charsmax( g_szQuery ) , "UPDATE `%s` SET `Level` = '%i' WHERE `%s`.`AuthID` = '%s';", szTableName, Level [ pPlayer ] , szTableName , szAuthID [ pPlayer ] ); SQL_ThreadQuery( g_hDBTuple , "ThreadQueryHandler" , g_szQuery ); } public NativeSetUserNext( pPlayer , iValue ) { LevelNext [ pPlayer ] = iValue; format( g_szQuery , charsmax( g_szQuery ) , "UPDATE `%s` SET `LevelNext` = '%i' WHERE `%s`.`AuthID` = '%s';", szTableName, LevelNext [ pPlayer ] , szTableName , szAuthID [ pPlayer ] ); SQL_ThreadQuery( g_hDBTuple , "ThreadQueryHandler" , g_szQuery ); } public native_set_money( pPlayer , num ) { g_Money[ pPlayer ] = num } public NativeGetUserNext( pPlayer ) { return LevelNext[ pPlayer ]; } public NativeGetUserLevel( pPlayer ) { return Level[ pPlayer ]; } public native_get_money( pPlayer ) { return g_Money[ pPlayer ] } // [ End: MYSQL ]C++
Проблема заключается в том, что у некоторых игроков сбрасывается опыт и другие данные занесенные в базу mysql. Сначала думал, что столбцы дублируются с новыми данными уже, но нет, при поиске нашел только один столбец с тем SteamID игрока, у которого был сброс, точно уверяю, что у игрока SteamID (STEAM_0:0:14614951) не менялся, у него куплена привилегия на данный айди, а также это стим версия кс. И могу уверять, что уровень у игрока был максимальный, а сейчас стал 4, он его за это время апнул.
Прикладываю исходник плагина уровневой системы, таблицу в которой была перезапись данных в столбцах.
Прикладываю исходник плагина уровневой системы, таблицу в которой была перезапись данных в столбцах.
В этой теме было размещено решение! Перейти к решению.
Вложения
-
694.6 KB Просмотры: 337
