Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

[ImportBot]

Originally Posted by Flyswamper*:

 

Each customer has their own database. If that customer has more than one server, all of their servers go into one database. It sounds like you think that every customer's server is in one database, which isn't how it works (in case that's what you were thinking).

Yeah...despite my poor choice of wording in the above posts...I had no idea whether or not each customers table resides in a separate database or not. With passwords/accounts and such...I can see why you have setup each customer with a database. All I knew (from what you previously told me) was that customers had their own unique *SINGLE* table.

 

At any rate.... my goal here is to make life easier for everybody...... and I've now become convinced that changing the database structure would probably create you guys a lot more headaches than it would help.

 

I do think an additional field in the table *probably* would have been a better design choice...but it looks like one of those design choices that needs to be made early in the process....not now, after so many are up and running with populated data and php scripts that all integrate into the original design.

 

And then again....I probably don't know what the heck I'm talking about.... and just like to speculate on this kinda stuff.

[ImportBot]

Originally Posted by XpKiller*:

 

Just adding a new field will not work only think about what would happen if the player plays on both servers.

Right you will get redundant rows or mixed ranking.

[ImportBot]

Originally Posted by Flyswamper*:

 

Just adding a new field will not work only think about what would happen if the player plays on both servers.

Right you will get redundant rows or mixed ranking.

This is almost surely a case of me not understanding (not taking the time to understand) what the records in the database (even now) really look like but.....

 

I guess I was imagining that with a server-id field, that if you want to retrieve stats for players/ranks on a particular server you would just need to make sure your SQL coding retrieved only records generated from the desired server. Maybe it is more complicated than that, but that is what I was imagining...

[ImportBot]

Originally Posted by XpKiller*:

 

Just adding a new field will not work only think about what would happen if the player plays on both servers.

Right you will get redundant rows or mixed ranking.

This is almost surely a case of me not understanding (not taking the time to understand) what the records in the database (even now) really look like but.....

 

I guess I was imagining that with a server-id field, that if you want to retrieve stats for players/ranks on a particular server you would just need to make sure your SQL coding retrieved only records generated from the desired server. Maybe it is more complicated than that, but that is what I was imagining...

That is not possible, that has nothing to do with coding skills it wont work that way or the database get f***ing slow.

Each Server gets his own table no problem will work without any problems.

[ImportBot]

Originally Posted by FoxTech*:

 

I created a new database and changed the database name field in the plugin. I recieved an error when I did this. So I udpated the plugin to the lastest 2.03 version, with no success. I get error after error, no matter what I do I get errors.

 

dCode:

Error: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.47-community]Field 'AEK971_kills' doesn't have a default value
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.StartStreaming()
[19:53:59 44] Error in SQLQuery: System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.1.47-community]Table 'bc2pleasework.tbl_playerstats' doesn't exist
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Odbc.OdbcCommand.ExecuteReader()
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)
[19:54:38 13] Error in LogChat: System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.1.47-community]Table 'bc2pleasework.tbl_chatlog' doesn't exist
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.LogChat(String strSpeaker, String strMessage, String strType)
[19:54:59 19] Error in SQLQuery: System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.1.47-community]Table 'bc2pleasework.tbl_playerstats' doesn't exist
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Odbc.OdbcCommand.ExecuteReader()
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(String str_selectSQL, Int32 sort)
[19:54:59 98] Error in LogChat: System.Data.Odbc.OdbcException: ERROR [42S02] [MySQL][ODBC 5.1 Driver][mysqld-5.1.47-community]Table 'bc2pleasework.tbl_chatlog' doesn't exist
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
   at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.LogChat(String strSpeaker, String strMessage, String strType)

I even tried using my old database and I downgraded the plugin. I was able to get the plugin to work the @top10, but it doesn't record any further stats nor does the @stats or welcome message work.

 

That above error is after I upgraded again and created yet another blank database. It creates the tables in the database with nothing but null fields. I have no idea what is going on.

[ImportBot]

Originally Posted by FoxTech*:

 

anyone have any idea what is wrong, I'm wrecking my brain over this.

[ImportBot]

Originally Posted by XpKiller*:

 

Hi

I aware of this problem and probably have a fix for that.

I try to release this fix today.

[ImportBot]

Originally Posted by FoxTech*:

 

the plugin has additionally started to crash my procon server. As long as I don't enable it. Procon is stable... just thought I'd throw that out there.

[ImportBot]

Originally Posted by XpKiller*:

 

I don't have any crashs of procon related to this plugin

[ImportBot]

Originally Posted by FoxTech*:

 

I don't know, if I leave it running long enough and let it produce those errors, it eventually crashes my procon server. Disabling the plugin leaves my procon server stable.

[ImportBot]

Originally Posted by XpKiller*:

 

*BUMP*

 

New Version 2.04 8-)

 

Changlog:

 

2.03 --> 2.04

MapStats Feature

Fixed broken Welcomestats

improved some SQL Querys for better Performance

added tableprefix feature(use this if you only got one database but more Server)

possible fix for the have no default value error some people got

 

 

Give Feedback

 

webscript for the Mapstats feaure will follow

[ImportBot]

Originally Posted by Panther*:

 

good job with the new version.

 

but i still can't get the welcome message for new players to work. no message at all apears.

message for players who rejoin the server get the normal welcome message.

 

regards

Panda

[ImportBot]

Originally Posted by XpKiller*:

 

I uploaded the wrong build...

 

BTW has anyone wishes for the next releases?

[ImportBot]

Originally Posted by Panther*:

 

just an idea, nothing big, because your script includes allready everything.

 

sometimes it appears, that ppl under the top100 start cheating and then i alway delete them from the stats.

for this i have to go in the mysql database.

It would be great if we would have an ingame comand to delete a player.

like:

@deletestats "Player"

Are you sure?

@yes

[ImportBot]

Originally Posted by Brazin*:

 

Whenever I request the top10, it seems to publish everybody as "1." now.

 

[ImportBot]

Originally Posted by XpKiller*:

 

Whenever I request the top10, it seems to publish everybody as "1." now.

 

The ranking is correct I did a typing mistake I wrote rank =+1 instead of rank += 1

I will upload a fixed version this evening.

 

About this deleting player thing I will take look if this I really useful.

Because to get the autocompleter working you need a list of nicknames ( in my case I got 30000 unique playernames)

I don't delete them I just reset them get there guid and ban them.

[ImportBot]

Originally Posted by Panther*:

 

oh ok i got it.

 

i thought you coud use a sql command to delete the whole database entry of this user.

 

i search in phpmyadmin for the player and then click on remove this entry to remove the player completely out of the database.

 

but as i said, it is something realy not at all important. was just thinking the other day about it =).

[ImportBot]

Originally Posted by XpKiller*:

 

*BUMP*

 

New Version 2.05 8-)

 

Date: 02.09.2010

 

Changlog:

 

2.04 --> 2.05

 

Some codeparts improved and reworked to provide better fault tolerance.

some bugfixes

[ImportBot]

Originally Posted by Panther*:

 

grats!

are you going to implemen the report-function you have been talking about to report a cheater to the admins?

 

PS: Welcome messages are working for newcommers : Thanks :roll:

[ImportBot]

Originally Posted by XpKiller*:

 

yep will do

 

and i should release betas

[ImportBot]

Originally Posted by EBassie*:

 

I found a bug:

 

sometimes the 'LastSeenOnServer' field gets updated with this strange timestamp: 0001-01-01 00:00:00

[ImportBot]

Originally Posted by XpKiller*:

 

I found a bug:

 

sometimes the 'LastSeenOnServer' field gets updated with this strange timestamp: 0001-01-01 00:00:00

Hi

Thank for your report I will investigate this issue.

I also found a bug too, the average Playercount is wrong in the table tbl _mapstats

[ImportBot]

Originally Posted by OzumSage*:

 

we have upgraded from version 1.52 to this version. all went well with the tables and stats seem to be working, but now when certain people join the server (ie. me) it says the ingame message is longer than 100 characters. this only happens to a few people and the people it happens to only get the welcome back message. i have tried to change the length in your code to >150 but message about the max length goes away, but no stats show. i only have 8 characters in my ingame name but would like to know how to get the stats to show for these players.

 

where does the strmessage get it's info? what ingame message is too long so that i can shorten it. with version 1.52 we did not get this message and all player stats showed correctly.

 

help would be appreciated.

 

great plugin, btw.

[ImportBot]

Originally Posted by XpKiller*:

 

i sent you a pm.

[ImportBot]

Originally Posted by XpKiller*:

 

I'm planning to change the database design again for the future Version 3 of my Plugin because i found some bottlenecks in my design. Also i can buildin new feature like GUID Tracking.

 

From these changes mainly users with multiply Gameservers or Layerhoster would benefit.

The datebase will store less redundant data and would be fast too.

 

if there is interest or need for this changes pls let me know and also let me know if you dont want such changes!!

[ImportBot]

Originally Posted by EBassie*:

 

If we are able to keep the current data, I would not mind changing.

[ImportBot]

Originally Posted by XpKiller*:

 

Thats for sure you will keep your data

[ImportBot]

Originally Posted by SinBad-OTF*:

 

I have taken Draco's 'Simple View' php files and modified them slightly. Primarily wanted to see the chat log and filter out all the server posts, just to see user chat. Secondly, wanted to provide some user data that admins might need. Now I have a question.... The GUID that is recorded is the PB Guid and when I ban a player using the PB Guid, it never shows up in the banlist in Procon, only bans by name and EA Guid show up. Am I missing something somewhere? How can I see users that have been banned using the PBGuid? Also, I heard that the EA Guid changes when the users' IP changes. True or False?

 

//SinBad

[ImportBot]

Originally Posted by EBassie*:

 

I Thought the EA Guid is a 'hash' of the game-key.

[ImportBot]

Originally Posted by XpKiller*:

 

Right the pb guid is a hash of the cd key

 

The issue that the player not show of is because procon only calls the bans from server which reason starts with BC2!