[Sobuno]

Originally Posted by Lob (UK All the columns of all the new weapons in the table are empty of scores though which is related to the new errors reported. The new weapons are adding the points onto the total scores perfectly fine and all the previous weapon columns are all fine too but for some reason the new weapons are not adding any points/numbers on to the new tables that it has itself created as in the new weapon tables.

I think they are not being tracked because the plugin updates the fields by doing field = field+1. If the field is empty, I am not sure the sqlite database knows how to handle it.

To fix it, I just shut down my server and ran an update command that set all the new weapons to 0 (Update Player set KW_rocketlauncher_directhit = 0, KW_telefrag = 0, etc.)

[Lob (UK]

Originally Posted by Sobuno I think they are not being tracked because the plugin updates the fields by doing field = field+1. If the field is empty, I am not sure the sqlite database knows how to handle it. To fix it, I just shut down my server and ran an update command that set all the new weapons to 0 (Update Player set KW_rocketlauncher_directhit = 0, KW_telefrag = 0, etc.)

I shall give that a try.

Thanks very much for the info

- Lob (UK)

[cybersquare420]

they are not being recorded on my mysql db either... all tables are there, and are populated with zero for a value, so the math should be working right... i dont have unlocks yet, so i am unsure if event is being scored by plugin and just not getting recorded, or if it just isnt recognizing the event...

p.s. not to be a pest, but it also seems to still be keeping a score for the bots.... could you have it so players get points for killing bots, but bots dont get points at all? thanx for all your efforts before and coming!!

[Lob (UK]

I have run the update command and set the new weapons all to 0 as suggested.

Tested a few new weapon kills and looked at the database again and the points are now being counted and added to the columns.

The same error message is still being written to the sourcemod Logs though which is odd.

These are the errors from the test and these coincide with the new weapon kills we did and like i say, they do now get counted in the table but the error still written.

 
L 12/24/2009 - 14:46:11: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:48:31: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:49:34: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:49:59: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:50:22: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:50:35: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:51:28: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:51:31: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:52:05: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:52:10: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:53:07: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:53:27: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:53:31: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/24/2009 - 14:53:35: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied

- Lob (UK)

[dwatring]

Originally Posted by rig0r Question: does your plugin ignore bots (the bots Valve added a couple of days ago) ? It seems they are included in the ranking, but if I go to the webrank webby I cannot find any bot playernames.

It screws with the rank system because they constantly change IP's. So do NOT do this if you are thinking of. just a heads up if you dont want ur rankings screwed

[rig0r]

Originally Posted by dwatring It screws with the rank system because they constantly change IP's. So do NOT do this if you are thinking of. just a heads up if you dont want ur rankings screwed

Yeah, that's why I want the plugin to ignore them.

[dwatring]

Originally Posted by rig0r Yeah, that's why I want the plugin to ignore them.

Yeah, same here.

[Blade Kiro]

Still having the same problem. Changed the chattag back to RANK. Typed rank in, nothing. Typed top10, nothing. Yet in all the chat logs is keeps saying Welcome X and Ranking is now enabled, etc. I really dont know whats wrong.

[Lob (UK]

Hi DarthNinja,

I have had to remove the updated plugin version 6.0 from my Server and revert back to the previous version 5.0

The Updated Plugin is not working correctly unfortunately.

No New Players have been getting written to the database whether it is an existing database or a new one generated by the plugin itself. I have tested both.

New Players cannot use the Rank chat command as it does not work because they do not exist in the database.

Top works but if you do players and then select a new player, then nothing happens because he is not recorded in the database.

The error messages that i have reported previously still occur even if you let the plugin create a new database.

Even when putting the previous version back on, the newer databases would not work correctly when new players joined.

Luckily, i saved a back up of the database before i updated the plugin although a lot of people have lost 5 days playing ranks due to me having revert back to the previous version and backed up database.

Hope the problems can be resolved soon

- Lob (UK)

[eraserhead]

Damn, this isnt good news... I updated the plugin but dit NOT make a backup of my database...