AES : Vault and /top15

[karimoo97]

Hello everyone I hope you are doing well !
Excuse me if this isn't the correct place to post this or if I'm not allowed to post without respecting the format

I really like the AES plugin and i would love to use it on my server but,

I don't have acces to SQL and I want to use a vault or something in my server but i didn't find the Database settings like the on posted in Aliedmodders, aes_db_type "1" (0-disable/1-file/2-SQL)

I would also like to save the XP by Nick,or maybe nick + ID if it's possible

+ CAN I rank players in /top15 based on their XP and not K/D-Skill or whatever is actually used in aes_statsx_cstrike


To summarize, I need to make AES save xp in a file by nick or (nick +id) and aes_statsx_cstrike to rank players by their xp in their XPeas

Please guide me and help me find the best version and the correct settings to do so


any help would be greatly appreciated

Greetings

 

[Gudaus]

Hello everyone I hope you are doing well !
Excuse me if this isn't the correct place to post this or if I'm not allowed to post without respecting the format

I really like the AES plugin and i would love to use it on my server but,

I don't have acces to SQL and I want to use a vault or something in my server but i didn't find the Database settings like the on posted in Aliedmodders, aes_db_type "1" (0-disable/1-file/2-SQL)

I would also like to save the XP by Nick,or maybe nick + ID if it's possible

aes_db_type "1" = nvault
aes_track_mode "0" = saving EXP by Nick

About what kind of AES you speaking? original 0.5 or this fork?

 

[karimoo97]

I tried both,
aes_db_type was removed from the cfg
aes_track_mode has a new value (-1) which is the only one working for me

+can I rank players in aes_statsx_cstrike based on their Xp? Or is there another plugin that does that ?

 

[serfreeman1337]

I don't have acces to SQL and I want to use a vault or something in my server

Use SQLite to save stats locally. (0.5 version)

• Uncomment sqlite in modules.ini
• Set aes_sql_driver to "sqlite"

CAN I rank players in /top15 based on their XP and not K/D-Skill or whatever is actually used in aes_statsx_cstrike

Easy to do that with csstatsx-sql.
Set them both to use same database:

aes_sql_driver "sqlite"
csstats_sql_type "sqlite"
aes_sql_name "amxx"
csstats_sql_db "amxx"

if you manage it to work
send me your data/sqlite3/amxx.sq3 file.
then i can edit csstatsx-sql to use xp for ranking.

csstatsx-sql in english

 

[karimoo97]

Hello serfreeman1337
First of all I want to thank you for making the best amxx experience system.

Now about the topic,this is what I did

I downloaded aes 0.5 And I saved locally with SQLite and everything worked,
Now th part I have a problem with, i want /rank and /top15 ranked by EXP :
I Installed csxmysql_amxx_statsx.zip with the same (sql_type and sql_db) as AES [NOTHING HAPPEND]
I Added csstatsx-sql.zip,I tried both statsx and statsx_n [NOTHING HAPPEND]

SO I installed AES : StatsX CStrike
SQL define : THE EXP didn't show at all
AES define : EXP worked fine in the /rank commend but it showed -- in the top15

This is so confusing to me as yo can tell by the way I explained,A mess

Thank for the support

 

[serfreeman1337]

i want /rank and /top15 ranked by EXP

send me your addons/amxmodx/data/sqlite3/amxx.sq3 file.
then i can edit csstatsx-sql to use xp for ranking.

EXP worked fine in the /rank commend but it showed -- in the top15

Check that csstats_rank and aes_track_mode cvars are set to same value.

Also you need uncomment both AES and SQL defines in statsx.

 

[karimoo97]

I Did,the only thing I hanged is defining both aes and sql and that allowed me to use /hot /rankstats ...... but the top15 is still broken


I attached the cvar sc but i couldn't attach the sql file so i uploaded this here : https://up2sha.re/file?f=j2STwNPp

 

[serfreeman1337]

Okay.

I don't have counter-strike right now and i need some help with debuging.
Use this version, open Top15 and post here contents of addons/amxmodx/logs/aes_statsx.log file .

 

[karimoo97]

I got this:

Спойлер

L 05/15/2018 - 02:26:50: Log file started (file "cstrike/addons/amxmodx/logs/aes_statsx.log") (game "cstrike") (amx "1.8.3-dev+5151")
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] sizeof=(30)
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] authid=(STEAM_0:1:286361)
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] authid=(STEAM_1:0:1374241181)
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] authid=(STEAM_0:0:172796617)
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] authid=(STEAM_1:0:1869996529)
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] authid=(STEAM_1:0:1065457878)
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] authid=(STEAM_1:0:1764840249)
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] authid=(STEAM_0:0:3819169)
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] authid=(STEAM_1:0:330039768)
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] authid=(STEAM_1:0:636450528)
L 05/15/2018 - 02:26:50: [SayTopHandler::iterator] authid=(STEAM_1:0:1932770362)
L 05/15/2018 - 02:26:50: [SayTopFormer] aes_stats_size=0
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] sizeof=(30)
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] authid=(STEAM_0:1:286361)
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] authid=(STEAM_1:0:1374241181)
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] authid=(STEAM_0:0:172796617)
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] authid=(STEAM_1:0:1869996529)
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] authid=(STEAM_1:0:1065457878)
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] authid=(STEAM_1:0:1764840249)
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] authid=(STEAM_0:0:3819169)
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] authid=(STEAM_1:0:330039768)
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] authid=(STEAM_1:0:636450528)
L 05/15/2018 - 02:29:00: [SayTopHandler::iterator] authid=(STEAM_1:0:1932770362)
L 05/15/2018 - 02:29:00: [SayTopFormer] aes_stats_size=0
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] sizeof=(30)
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] authid=(STEAM_0:1:286361)
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] authid=(STEAM_1:0:1374241181)
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] authid=(STEAM_0:0:172796617)
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] authid=(STEAM_1:0:1869996529)
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] authid=(STEAM_1:0:1065457878)
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] authid=(STEAM_1:0:1764840249)
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] authid=(STEAM_0:0:3819169)
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] authid=(STEAM_1:0:330039768)
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] authid=(STEAM_1:0:636450528)
L 05/15/2018 - 02:30:00: [SayTopHandler::iterator] authid=(STEAM_1:0:1932770362)
L 05/15/2018 - 02:30:00: [SayTopFormer] aes_stats_size=0

 

[serfreeman1337]

hm...
amx_cvar csstats_rank output is 0 ?

 

[karimoo97]

HAHAHA yeah I had the same reaction when I saw the log full of Steam IDs instead of nicks,I did check and it's set to 0, by nick
What can be the issue ?

 

[serfreeman1337]

try to debug csstatsx_sql or
replace authid with name on ~1502 line

#if defined AES
-    ArrayPushString(authids_array,authid)
+    ArrayPushString(authids_array,name)
#endif

 

[karimoo97]

Посмотреть вложение 9305Посмотреть вложение 9305Посмотреть вложение 9305Посмотреть вложение 9305Посмотреть вложение 9305
try to debug csstatsx_sql or
replace authid with name on ~1502 line

#if defined AES
-    ArrayPushString(authids_array,authid)
+    ArrayPushString(authids_array,name)
#endif

I will,I don't hav acces to the sv right now

i found this in the log : "aes_exp_cstrike.amxx" failed to load: Plugin uses an unknown function (name "get_user_stats2") - check your modules.ini.