[Blade Kiro]

Originally Posted by Blade Kiro For some reason the plugin is welcoming people to the server and it is saying that ranking is enabled, but when I type rank nothing happens.

Any idea why this is happening? Any cvar that would not let you type rank?

[DarthNinja]

Originally Posted by Blade Kiro Any idea why this is happening? Any cvar that would not let you type rank?

what is your rank_chattag set to?

[Blade Kiro]

rank_chattag "NS2"

[DarthNinja]

Originally Posted by Blade Kiro rank_chattag "NS2"

Type "NS2" in chat

[MjrNuT]

Originally Posted by dwatring Getting the database to work. And how to host files on my website to make it work. 1. Go to the administration page of your webserver (a common interface is Cpanel) 2. Go to MySQL databases and create a new database called tf2stats. You will see that the databasename is prepended with your account name (presuming you are using a hosting provider and not your own server). For instance the database will have a name like abcd12_tf2stats. 3. Now make a user that can acces the database. It will be prepended with your account name again so it will be something like abcd12_user and you also have to choose a password, you will need this in step 5. That is what you said, but I don't have an admin page. And I certainly don't have a MySQL database. I don't have a hosting provider either.

A dedicated server by your meaning then is that you have full management of a machine, not a virtual instance.

By what I've read from you, you have a barebones either windows or linux. So, you need to find out how to install the applications needed to run this web interface.

[Lob (UK]

Hi mate,

The plugin is running great and all the new weapons are being picked up so Thanks again for that.

There is a new error being written to the sourcemod Logs though which has only started since installing the updated plugin.

It is not effecting the performance of the Server or Plugin but its something that does need resolving when you get a chance.

Could it be something to do with the 9 extra weapons when writing to the database (90 columns for player but only 81 values!)

Here is some of the Sourcemod Log.

 
L 12/23/2009 - 23:16:02: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:16:31: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:16:53: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:23:54: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:23:58: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:25:56: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:33:52: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:34:35: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:34:44: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:36:07: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:37:32: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:38:30: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:39:01: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:40:16: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:43:33: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:45:11: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:48:42: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:50:21: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied
L 12/23/2009 - 23:55:40: [n1g-tf2-stats.smx] SQL Error: table Player has 90 columns but 81 values were supplied

There is also the unrecognised ball event in the N1G_WEAPONERRORS.log which is a very rare event anyway like has been said previously.

 
L 12/24/2009 - 09:31:12: [n1g-tf2-stats.smx] Weapon: ball

Cheers

- Lob (UK)

[DarthNinja]

I saw that in testing, I think its a database error, I thought I fixed it though...
You *could* try and export all the data, then drop all the tables and let the plugin recreate them (then import the data) and see if that fixes it.

I'm not sure what the cause is...

And the ball weapon I'll add once theres another reason to update the plugin...

[eraserhead]

Originally Posted by dwatring Getting the database to work. And how to host files on my website to make it work. That is what you said, but I don't have an admin page. And I certainly don't have a MySQL database. I don't have a hosting provider either.

I am assuming here that your knowlegde/experience level does not extend to making a webserver of your own and setting up MySQL etc. So my advice is that if you really want the web rankings just hire some webspace with a provider otherwise it will be mission impossible for you. You could just simply start with using the plugin locally on you TF2 server without the web ranking of course. Did you get that to work?

[Lob (UK]

Originally Posted by DarthNinja I saw that in testing, I think its a database error, I thought I fixed it though... You *could* try and export all the data, then drop all the tables and let the plugin recreate them (then import the data) and see if that fixes it. I'm not sure what the cause is... And the ball weapon I'll add once theres another reason to update the plugin...

Hi again.

I have opened the current tf2stats.sq3 to have a look at it and the new tables are all there and have been created the same as they would be with a new database. There are 90 as there should now be. I opened a saved one from before the update and there were only 81 so the new tables have definately been created ok by the new plugin and you can see the new weapon columns that have been added.

However,

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.

If the plugin has already converted the existing table to add the new columns of weapons, then i doubt exporting a database with no data in the new colums would actually make any difference if you know what i mean.

Cheers

- Lob (UK)

[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.