[koaandl]

option 1 now works, just decided to, but option 2 now does nothing.... and i cant access the admin tool, how do i do that? if you mean the one via the website, my website is broken still, wont connect to the mysql server that the game server uses..

[eraserhead]

Edit yet again: I tried moving the sql database to the mysql at my webhost and voila the website works, but ironically, i put those details into the databases.cfg of sourcemod and the server cant connect.. ._.;;

So which database connection is the problem now?
Between the website and the database or between the gameserver and the database or both?

When looking at your webpage http://koaandl.byethost5.com/site/index.php
i still see this error: connection failed:Can't connect to MySQL server on '203.219.84.187' (4) ERROR CODE: 2003

I thought that was solved by moving the sql database to the same location as the website? Thats what i would have suggested to make things simpler anyway. In the config.inc.php it should say localhost now instead of the IP address you were pointing to.

The admin page should be something like this: http://koaandl.byethost5.com/site/admin/index.php

If i'm not mistaken the config.inc.php is still pointing to the external database host instead of localhost. This is what i see when i go to your admin page:
DEBUG: ACHV OPENEDconnection failed:Can't connect to MySQL server on '203.219.84.187' (4) ERROR CODE: 2003

And this is what i get if i ping your website host:
C:\Users\user>ping koaandl.byethost5.com

Pinging koaandl.byethost5.com [209.190.24.9] with 32 bytes of data

So these are different hosts! Maybe you should replace the default file for mysql.inc.php because i never had to edit that file to get things working.

[koaandl]

i changed the sql server so it was hosted on byethost (where the website was hosted) and it worked fine, i have momentairly switched the connection back to the home server (203.219.84.187) because i was testing something.

I have decided to take the easy route and host a web server on the computer that's running the game server..

Will update soon this post soon with results..

[eraserhead]

ok that would make things a lot simpler!

Pfsm999, a small update. I had to disable the plugin again because it still kept interfering with the ranking plugin. There were huge delays and at some point it catched up again but then it got even worse. People connecting to the server (including me) had rank 0, this was not acceptable so i unloaded the plugin.
Hope you will be able to fix this issue. The plugin itself seems to work fine apart from this.

[koaandl]

okay, it is all connected and working, but achieves wont count (eg there is a say a word one and that wont trigger, and a taunt kill 3 times with sandman and that doesnt count), it also says under players rank that nobody has started or completed any achievements

EDIT: I tried manually giving myself an achievement (with /admin_ach) and in the achievement's webpage (http//203.219.84.187:8080/index.php) it show's i have it it, as well as in player ranks, but ingame it still says i have 0 achievements and none have any status on them (all still 0) :<

This is the error log

L 03/17/2010 - 23:45:29: Info (map "ctf_2fort") (file "errors_20100317.log")
L 03/17/2010 - 23:45:29: [SM] Native "GetArrayCell" reported: Invalid index 0 (count: 0)
L 03/17/2010 - 23:45:29: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/17/2010 - 23:45:29: [SM]   [0]  Line 1102, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::ResetAllOneLife()
L 03/17/2010 - 23:45:29: [SM]   [1]  Line 269, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::OnMapStart()
L 03/17/2010 - 23:45:29: [SM] Native "CloseHandle" reported: Handle 1802116c is invalid (error 1)
L 03/17/2010 - 23:45:29: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/17/2010 - 23:45:29: [SM]   [0]  Line 447, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::MustCloseHandle()
L 03/17/2010 - 23:45:29: [SM]   [1]  Line 293, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::RequestRefresh()
L 03/17/2010 - 23:45:29: [SM] Native "GetArrayString" reported: Invalid index 0 (count: 0)
L 03/17/2010 - 23:45:29: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/17/2010 - 23:45:29: [SM]   [0]  Line 1189, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::ResetAllBlockStatus()
L 03/17/2010 - 23:45:29: [SM]   [1]  Line 1134, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::ResetFunction()
L 03/17/2010 - 23:45:29: [SM]   [2]  Line 1103, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::ResetAllOneLife()
L 03/17/2010 - 23:45:29: [SM]   [3]  Line 782, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::RC_Achievements_After_Query()
L 03/17/2010 - 23:45:29: [SM] Native "SQL_FetchInt" reported: Error fetching data from field 2
L 03/17/2010 - 23:45:29: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/17/2010 - 23:45:29: [SM]   [0]  Line 30, D:\srcds\orangebox\tf\addons\sourcemod\scripting\mwach/engineer.inc::RC_Blocks_Engi_Pda_Aft_Q()
L 03/17/2010 - 23:45:30: [SM] Native "GetArrayString" reported: Invalid index 0 (count: 0)
L 03/17/2010 - 23:45:30: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/17/2010 - 23:45:30: [SM]   [0]  Line 1189, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::ResetAllBlockStatus()
L 03/17/2010 - 23:45:30: [SM]   [1]  Line 1134, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::ResetFunction()
L 03/17/2010 - 23:45:30: [SM]   [2]  Line 1103, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::ResetAllOneLife()
L 03/17/2010 - 23:45:30: [SM]   [3]  Line 782, D:\srcds\orangebox\tf\addons\sourcemod\scripting\customs_achievements.sp::RC_Achievements_After_Query()
L 03/17/2010 - 23:45:30: [SM] Native "SQL_FetchInt" reported: Error fetching data from field 2
L 03/17/2010 - 23:45:30: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/17/2010 - 23:45:30: [SM]   [0]  Line 30, D:\srcds\orangebox\tf\addons\sourcemod\scripting\mwach/engineer.inc::RC_Blocks_Engi_Pda_Aft_Q()

[Pfsm999]

Hi everyone, i will done a correction very quickly !
I did not here to resolve and answer question because yesterday was my last day on my hollyday !

And now, i can continu to work on the plug !
@eraserhead, i will post you an update and if tonight we can test it together !
@SuperShadow, i will post your correction for style files !
@Other :

Thanks for all, and i will optimize the code ... again !

[SuperShadow]

Glad to have you back. Hope you enjoyed your holiday!

[Pfsm999]

A small update :
To correct problem with style css on website
To correct some issue on the plug.

See on the first post the new plug and web-interface

[eraserhead]

Should this also resolve the rank delays we have Pfsm999?

[Zuko]

L 03/21/2010 - 18:00:44: [SM] Native "GetClientAuthString" reported: Client index 1578 is invalid
L 03/21/2010 - 18:00:44: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:00:44: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:01:38: [SM] Native "GetClientAuthString" reported: Client index 1482 is invalid
L 03/21/2010 - 18:01:38: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:01:38: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:02:03: [SM] Native "GetClientAuthString" reported: Client index 1480 is invalid
L 03/21/2010 - 18:02:03: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:02:03: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:03:54: [SM] Native "GetClientAuthString" reported: Client index 79 is invalid
L 03/21/2010 - 18:03:54: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:03:54: [SM]   [0]  Line 59, mwach/sniper.inc::DelaySniperExpire()
L 03/21/2010 - 18:04:19: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/21/2010 - 18:04:19: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:04:19: [SM]   [0]  Line 59, mwach/sniper.inc::DelaySniperExpire()
L 03/21/2010 - 18:04:19: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/21/2010 - 18:04:19: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:04:19: [SM]   [0]  Line 59, mwach/sniper.inc::DelaySniperExpire()
L 03/21/2010 - 18:04:47: [SM] Native "GetClientAuthString" reported: Client index 1575 is invalid
L 03/21/2010 - 18:04:47: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:04:47: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:06:02: [SM] Native "GetClientAuthString" reported: Client index 1578 is invalid
L 03/21/2010 - 18:06:02: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:06:02: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:06:04: [SM] Native "GetClientAuthString" reported: Client index 1575 is invalid
L 03/21/2010 - 18:06:04: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:06:04: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:06:13: [SM] Native "GetClientAuthString" reported: Client index 110 is invalid
L 03/21/2010 - 18:06:13: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:06:13: [SM]   [0]  Line 59, mwach/sniper.inc::DelaySniperExpire()
L 03/21/2010 - 18:07:17: [SM] Native "GetClientAuthString" reported: Client index 0 is invalid
L 03/21/2010 - 18:07:17: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:07:17: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:07:48: [SM] Native "GetClientAuthString" reported: Client index 1578 is invalid
L 03/21/2010 - 18:07:48: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:07:48: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:08:01: [SM] Native "GetClientAuthString" reported: Client index 1482 is invalid
L 03/21/2010 - 18:08:01: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:08:01: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:09:00: [SM] Native "GetClientAuthString" reported: Client index 1578 is invalid
L 03/21/2010 - 18:09:00: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:09:00: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:10:09: [SM] Native "GetClientAuthString" reported: Client index 1561 is invalid
L 03/21/2010 - 18:10:09: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:10:09: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:10:27: [SM] Native "GetClientAuthString" reported: Client index 1591 is invalid
L 03/21/2010 - 18:10:27: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:10:27: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:10:39: [SM] Native "GetClientAuthString" reported: Client index 1578 is invalid
L 03/21/2010 - 18:10:39: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:10:39: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:12:09: [SM] Native "GetClientAuthString" reported: Client index 1578 is invalid
L 03/21/2010 - 18:12:09: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:12:09: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:12:18: [SM] Native "GetClientAuthString" reported: Client index 1566 is invalid
L 03/21/2010 - 18:12:18: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:12:18: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:13:30: [SM] Native "GetClientAuthString" reported: Client index 1600 is invalid
L 03/21/2010 - 18:13:30: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:13:30: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:13:58: [SM] Native "GetClientAuthString" reported: Client index 1593 is invalid
L 03/21/2010 - 18:13:58: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:13:58: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:14:40: [SM] Native "GetClientAuthString" reported: Client index 1578 is invalid
L 03/21/2010 - 18:14:40: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:14:40: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()
L 03/21/2010 - 18:15:10: [SM] Native "GetClientAuthString" reported: Client index 1578 is invalid
L 03/21/2010 - 18:15:10: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:15:10: [SM]   [0]  Line 92, mwach/medic.inc::blocks_medic_uber()

L 03/21/2010 - 18:24:21: SourceMod error session started
L 03/21/2010 - 18:24:21: Info (map "cp_dustbowl") (file "errors_20100321.log")
L 03/21/2010 - 18:24:21: [SM] Native "GetArrayCell" reported: Invalid index -1 (count: 3)
L 03/21/2010 - 18:24:21: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:24:21: [SM]   [0]  Line 1464, customs_achievements.sp::AddToAchievement()
L 03/21/2010 - 18:24:21: [SM]   [1]  Line 1323, customs_achievements.sp::AchievementCheckCompletion()
L 03/21/2010 - 18:24:21: [SM]   [2]  Line 1013, customs_achievements.sp::UpdateBlockStatus()
L 03/21/2010 - 18:24:21: [SM]   [3]  Line 325, mwach/kill.inc::blocks_kill()
L 03/21/2010 - 18:24:21: [SM]   [4]  Line 137, mwach/kill.inc::blocks_kill_pre()
L 03/21/2010 - 18:24:22: [SM] Native "GetArrayString" reported: Invalid index 3 (count: 3)
L 03/21/2010 - 18:24:22: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:24:22: [SM]   [0]  Line 1264, customs_achievements.sp::ResetBlockStatus()
L 03/21/2010 - 18:24:22: [SM]   [1]  Line 1129, customs_achievements.sp::ResetFunction()
L 03/21/2010 - 18:24:22: [SM]   [2]  Line 1116, customs_achievements.sp::ResetAllOneLifeForOneClient()
L 03/21/2010 - 18:24:22: [SM]   [3]  Line 333, mwach/kill.inc::blocks_ResetOnDeath()
L 03/21/2010 - 18:24:30: [SM] Native "GetArrayString" reported: Invalid index 6 (count: 6)
L 03/21/2010 - 18:24:30: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:24:30: [SM]   [0]  Line 1264, customs_achievements.sp::ResetBlockStatus()
L 03/21/2010 - 18:24:30: [SM]   [1]  Line 1176, customs_achievements.sp::ResetJustBlockFunction()
L 03/21/2010 - 18:24:30: [SM]   [2]  Line 1438, customs_achievements.sp::AddToAchievement()
L 03/21/2010 - 18:24:30: [SM]   [3]  Line 1323, customs_achievements.sp::AchievementCheckCompletion()
L 03/21/2010 - 18:24:30: [SM]   [4]  Line 1013, customs_achievements.sp::UpdateBlockStatus()
L 03/21/2010 - 18:24:30: [SM]   [5]  Line 325, mwach/kill.inc::blocks_kill()
L 03/21/2010 - 18:24:30: [SM]   [6]  Line 137, mwach/kill.inc::blocks_kill_pre()
L 03/21/2010 - 18:24:31: [SM] Native "GetArrayString" reported: Invalid index 9 (count: 9)
L 03/21/2010 - 18:24:31: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:24:31: [SM]   [0]  Line 1264, customs_achievements.sp::ResetBlockStatus()
L 03/21/2010 - 18:24:31: [SM]   [1]  Line 1176, customs_achievements.sp::ResetJustBlockFunction()
L 03/21/2010 - 18:24:31: [SM]   [2]  Line 1438, customs_achievements.sp::AddToAchievement()
L 03/21/2010 - 18:24:31: [SM]   [3]  Line 1323, customs_achievements.sp::AchievementCheckCompletion()
L 03/21/2010 - 18:24:31: [SM]   [4]  Line 1013, customs_achievements.sp::UpdateBlockStatus()
L 03/21/2010 - 18:24:31: [SM]   [5]  Line 325, mwach/kill.inc::blocks_kill()
L 03/21/2010 - 18:24:31: [SM]   [6]  Line 137, mwach/kill.inc::blocks_kill_pre()
L 03/21/2010 - 18:24:32: [SM] Native "GetArrayString" reported: Invalid index 9 (count: 9)
L 03/21/2010 - 18:24:32: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:24:32: [SM]   [0]  Line 1264, customs_achievements.sp::ResetBlockStatus()
L 03/21/2010 - 18:24:32: [SM]   [1]  Line 1176, customs_achievements.sp::ResetJustBlockFunction()
L 03/21/2010 - 18:24:32: [SM]   [2]  Line 1438, customs_achievements.sp::AddToAchievement()
L 03/21/2010 - 18:24:32: [SM]   [3]  Line 1323, customs_achievements.sp::AchievementCheckCompletion()
L 03/21/2010 - 18:24:32: [SM]   [4]  Line 1013, customs_achievements.sp::UpdateBlockStatus()
L 03/21/2010 - 18:24:32: [SM]   [5]  Line 325, mwach/kill.inc::blocks_kill()
L 03/21/2010 - 18:24:32: [SM]   [6]  Line 137, mwach/kill.inc::blocks_kill_pre()
L 03/21/2010 - 18:24:35: [SM] Native "GetArrayString" reported: Invalid index 9 (count: 9)
L 03/21/2010 - 18:24:35: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:24:35: [SM]   [0]  Line 1264, customs_achievements.sp::ResetBlockStatus()
L 03/21/2010 - 18:24:35: [SM]   [1]  Line 1176, customs_achievements.sp::ResetJustBlockFunction()
L 03/21/2010 - 18:24:35: [SM]   [2]  Line 1438, customs_achievements.sp::AddToAchievement()
L 03/21/2010 - 18:24:35: [SM]   [3]  Line 1323, customs_achievements.sp::AchievementCheckCompletion()
L 03/21/2010 - 18:24:35: [SM]   [4]  Line 1013, customs_achievements.sp::UpdateBlockStatus()
L 03/21/2010 - 18:24:35: [SM]   [5]  Line 325, mwach/kill.inc::blocks_kill()
L 03/21/2010 - 18:24:35: [SM]   [6]  Line 137, mwach/kill.inc::blocks_kill_pre()
L 03/21/2010 - 18:24:38: [SM] Native "GetArrayString" reported: Invalid index 12 (count: 12)
L 03/21/2010 - 18:24:38: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:24:38: [SM]   [0]  Line 1264, customs_achievements.sp::ResetBlockStatus()
L 03/21/2010 - 18:24:38: [SM]   [1]  Line 1176, customs_achievements.sp::ResetJustBlockFunction()
L 03/21/2010 - 18:24:38: [SM]   [2]  Line 1438, customs_achievements.sp::AddToAchievement()
L 03/21/2010 - 18:24:38: [SM]   [3]  Line 1323, customs_achievements.sp::AchievementCheckCompletion()
L 03/21/2010 - 18:24:38: [SM]   [4]  Line 1013, customs_achievements.sp::UpdateBlockStatus()
L 03/21/2010 - 18:24:38: [SM]   [5]  Line 325, mwach/kill.inc::blocks_kill()
L 03/21/2010 - 18:24:38: [SM]   [6]  Line 137, mwach/kill.inc::blocks_kill_pre()
L 03/21/2010 - 18:24:40: [SM] Native "GetArrayString" reported: Invalid index 12 (count: 12)
L 03/21/2010 - 18:24:40: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:24:40: [SM]   [0]  Line 1264, customs_achievements.sp::ResetBlockStatus()
L 03/21/2010 - 18:24:40: [SM]   [1]  Line 1129, customs_achievements.sp::ResetFunction()
L 03/21/2010 - 18:24:40: [SM]   [2]  Line 1116, customs_achievements.sp::ResetAllOneLifeForOneClient()
L 03/21/2010 - 18:24:40: [SM]   [3]  Line 333, mwach/kill.inc::blocks_ResetOnDeath()
L 03/21/2010 - 18:24:48: [SM] Native "GetArrayString" reported: Invalid index 15 (count: 15)
L 03/21/2010 - 18:24:48: [SM] Displaying call stack trace for plugin "customs_achievements.smx":
L 03/21/2010 - 18:24:48: [SM]   [0]  Line 1264, customs_achievements.sp::ResetBlockStatus()
L 03/21/2010 - 18:24:48: [SM]   [1]  Line 1176, customs_achievements.sp::ResetJustBlockFunction()
L 03/21/2010 - 18:24:48: [SM]   [2]  Line 1438, customs_achievements.sp::AddToAchievement()
L 03/21/2010 - 18:24:48: [SM]   [3]  Line 1323, customs_achievements.sp::AchievementCheckCompletion()
L 03/21/2010 - 18:24:48: [SM]   [4]  Line 1013, customs_achievements.sp::UpdateBlockStatus()

http://g2.isports.pl/~zuko/errors_20100321.log