[STOPPED][TF2] Custom Achievement Manager With MYSQL (V1.1) - Page 60

Pfsm999 · 03-22-2010 , 11:57 Re: [TF2] Custom Achievement Manager With MYSQL

Thanks Zuko !

Small fix update : v 1.03
See on the first post.

@eraserhead : normaly yes !

eraserhead · 03-22-2010 , 16:34 Re: [TF2] Custom Achievement Manager With MYSQL

pfsm999, i uploaded the 1.03 plugin today and we played on the server with 20 players. It seems you fixed the ranking and killstreak problems, they ran fine for hours, i will have to do some more testing to be sure though...

But just now the server crashed. I guess it must have been custom achievements causing it because the server never crashes. Here the error log:

Quote:

L 03/22/2010 - 14:00:19: SourceMod error session started
L 03/22/2010 - 14:00:19: Info (map "cp_orange_x3") (file "errors_20100322.log")
L 03/22/2010 - 14:00:19: [SM] Native "SQL_FetchInt" reported: Error fetching data from field 2
L 03/22/2010 - 14:00:19: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 14:00:19: [SM] [0] Line 30, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/engineer.inc::RC_Blocks_Engi_Pda_Aft_Q()
L 03/22/2010 - 14:00:21: [SM] Native "SQL_FetchInt" reported: Error fetching data from field 2
L 03/22/2010 - 14:00:21: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 14:00:21: [SM] [0] Line 30, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/engineer.inc::RC_Blocks_Engi_Pda_Aft_Q()
L 03/22/2010 - 14:45:43: [SM] Native "GetClientAuthString" reported: Client index 112 is invalid
L 03/22/2010 - 14:45:43: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 14:45:43: [SM] [0] Line 59, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/sniper.inc:

elaySniperExpire()
L 03/22/2010 - 14:46:29: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/22/2010 - 14:46:29: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 14:46:29: [SM] [0] Line 59, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/sniper.inc:

elaySniperExpire()
L 03/22/2010 - 14:53:09: [SM] Native "GetClientAuthString" reported: Client index 112 is invalid
L 03/22/2010 - 14:53:09: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 14:53:09: [SM] [0] Line 59, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/sniper.inc:

elaySniperExpire()
L 03/22/2010 - 15:17:07: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/22/2010 - 15:17:07: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 15:17:07: [SM] [0] Line 59, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/sniper.inc:

elaySniperExpire()
L 03/22/2010 - 15:40

5: [SM] Native "GetClientAuthString" reported: Client index 112 is invalid
L 03/22/2010 - 15:40

5: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 15:40

5: [SM] [0] Line 59, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/sniper.inc:

elaySniperExpire()
L 03/22/2010 - 15:42:44: [SM] Native "GetClientAuthString" reported: Client index 112 is invalid
L 03/22/2010 - 15:42:44: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 15:42:44: [SM] [0] Line 59, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/sniper.inc:

elaySniperExpire()
L 03/22/2010 - 15:43:40: [SM] Native "GetClientAuthString" reported: Client index 112 is invalid
L 03/22/2010 - 15:43:40: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 15:43:40: [SM] [0] Line 59, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/sniper.inc:

elaySniperExpire()

Zuko · 03-23-2010 , 06:43 Re: [TF2] Custom Achievement Manager With MYSQL

plugin still does not work (properly) on my server, achievements are not counting or counting wrong ;-(

+

Code:

L 03/23/2010 - 10:51:55: Info (map "pl_goldrush") (file "errors_20100323.log")
L 03/23/2010 - 10:51:55: [SM] Native "GetArrayCell" reported: Invalid index 0 (count: 0)
L 03/23/2010 - 10:51:55: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/23/2010 - 10:51:55: [SM]   [0]  Line 251, mwach/kill.inc::blocks_kill()
L 03/23/2010 - 10:51:55: [SM]   [1]  Line 137, mwach/kill.inc::blocks_kill_pre()
L 03/23/2010 - 11:12:36: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/23/2010 - 11:12:36: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/23/2010 - 11:12:36: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/23/2010 - 11:13:07: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/23/2010 - 11:13:07: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/23/2010 - 11:13:07: [SM]   [0]  Line 59, mwach/sniper.inc::DelaySniperExpire()
L 03/23/2010 - 11:13:07: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/23/2010 - 11:13:07: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/23/2010 - 11:13:07: [SM]   [0]  Line 59, mwach/sniper.inc::DelaySniperExpire()
L 03/23/2010 - 11:15:34: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/23/2010 - 11:15:34: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/23/2010 - 11:15:34: [SM]   [0]  Line 59, mwach/sniper.inc::DelaySniperExpire()

eraserhead · 03-23-2010 , 07:37 Re: [TF2] Custom Achievement Manager With MYSQL

Yes i had the same problem. I noticed when i enabled achievements progression (for instance an achieve where i had to build 100 dispensers) it was stuck at 23 no matter what i tried. So for some reason some achievements stopped working after the last update.

NovaDenizen · 03-24-2010 , 02:45 Re: [TF2] Custom Achievement Manager With MYSQL

For this error:

Code:

L 03/22/2010 - 15:43:40: [SM] Native "GetClientAuthString" reported: Client index 112 is invalid
L 03/22/2010 - 15:43:40: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 15:43:40: [SM] [0] Line 59, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/sniper.inc::DelaySniperExpire()

I think the problem is here:

Code:

public Action:blocks_sniper_jarate(UserMsg:msg_id, Handle:bf, const players[], playersNum, bool:reliable, bool:init)
{
        CreateTimer(0.1, DelaySniperExpire, bf);
        return Plugin_Continue;
}

I can't find a reference for this, but I believe that the bitbuffer object that bf refers to is only guaranteed to be valid for the lifetime of the blocks_sniper_jarate call. In other words, CloseHandle(bf) is called as soon as blocks_sniper_jarate returns, so when DelaySniperExpire is called, bf points at an invalid handle.

I don't understand why the timer is used here anyway. I don't see any advantage to it. You could Just put the code from DelaySniperExpire into this method.

NovaDenizen · 03-24-2010 , 03:03 Re: [TF2] Custom Achievement Manager With MYSQL

This error:

Code:

L 03/22/2010 - 14:00:19: [SM] Native "SQL_FetchInt" reported: Error fetching data from field 2
L 03/22/2010 - 14:00:19: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/22/2010 - 14:00:19: [SM] [0] Line 30, C:\Documents and Settings\Administrateur\Bureau\Nouveau dossier\tf2-customachievement\script\mwach/engineer.inc::RC_Blocks_Engi_Pda_Aft_Q()

The problem is in engineer.inc

Code:

     29                 SetArrayCell(g_LIST_BLOCKS_ENGI_PDA_ID, i, SQL_FetchInt(strHQuery, 0));
     30                 SetArrayCell(g_LIST_BLOCKS_ENGI_PDA_OBJECT, i, SQL_FetchInt(strHQuery, 2));

The query is basically "select * from blocks_engineer_pda". blocks_engineer_pda only has 2 fields, so the SQL_FetchInt should be called with 0 and 1, not 0 and 2.

NovaDenizen · 03-24-2010 , 03:17 Re: [TF2] Custom Achievement Manager With MYSQL

Code:


L 03/23/2010 - 11:12:36: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/23/2010 - 11:12:36: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/23/2010 - 11:12:36: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()

When a medic pops uber by himself, with no target, the targetid will be 0, and this GetClientAuthString call will fail.

Pfsm999 · 03-26-2010 , 04:53 Re: [TF2] Custom Achievement Manager With MYSQL

@NovaDenizen : Thanks again !

But i can put all my code in the first function because, i must close quickly this function because when you open a hook of a UserMessage you can't open a new UserMessage ! And this is very important ! You can't Write on chat while this function steal open !

I corrected bug for :

Engineer,
Medic,
Sniper,
Spy Files

And i return a Normal SQL priority of SQL insert and Update on the code.
See on the first post the new plug !

eraserhead · 03-26-2010 , 08:36 Re: [TF2] Custom Achievement Manager With MYSQL

Pfsm999, how do we know if your update is regarding the plugin, webinterface or both? Because on the first page it says website v1.rar.

Pfsm999 · 03-26-2010 , 08:51 Re: [TF2] Custom Achievement Manager With MYSQL

Just the plug ^^