ImportBot Posted December 30, 2010 Author Share Posted December 30, 2010 Originally Posted by XpKiller*: Yes you can delete the chatlog table but you cant delete entries from the other tables. When you do this you will have inconsistent Tables. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted December 31, 2010 Author Share Posted December 31, 2010 Originally Posted by XpKiller*: The next version of the plugin will provide support for BFBCS and will store them into a table called tbl_bfbcs If anyone wants to use Data from tables of the plugin and needs help pls contact me. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted December 31, 2010 Author Share Posted December 31, 2010 Originally Posted by Battlefield-gen-tr*: so where is the DATABASE script ? yeah there are update scripts but where is the original db script ? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 1, 2011 Author Share Posted January 1, 2011 Originally Posted by slekkas*: Hello and happy new year, After i applied one of the updates, i dont remember exactly witch one the ranking got messed up. For example i am first in our server, my game name is Killer Sotos, you can see it here: http://www.leagueofkarpathos.gr/server but when i log in to our server to play in the welcome message i get: Hello "Player" and welcome to our server. You are 23rd of 20000 players .... If i type @top10 it shows me 1st like it should be. Can you tell me how to fix this please? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 1, 2011 Author Share Posted January 1, 2011 Originally Posted by XpKiller*: i will take a look at this issue Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 1, 2011 Author Share Posted January 1, 2011 Originally Posted by Basert*: Hey, whats about my problem, do you have a solution? mfg Basert Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 1, 2011 Author Share Posted January 1, 2011 Originally Posted by Battlefield-gen-tr*: dude, I am seriously asking for some help. need The database script[/*:m:cak92pve] Readme.txt, which you talked about in the first post[/*:m:cak92pve] I couldnt find. Please help me. thanks Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 2, 2011 Author Share Posted January 2, 2011 Originally Posted by XpKiller*: Hey, whats about my problem, do you have a solution? mfg Basert Sry matedidnt found time to work a solution out yet Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 2, 2011 Author Share Posted January 2, 2011 Originally Posted by XpKiller*: dude, I am seriously asking for some help. need The database script[/*:m:35aerwih] Readme.txt, which you talked about in the first post[/*:m:35aerwih] I couldnt find. Please help me. thanks the readme is not in the download since the installation is described in the first post.There is also a Tuturial to setup the ODBC Driver in this forum. You dont need a database because the plugin creates the needed tables by itself. The only thing you must have or create a User and a database. A Mirgration Script is only needed if you want to upgrade 2.x to 3.x Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 2, 2011 Author Share Posted January 2, 2011 Originally Posted by Legate*: It's possible to show the weaponrank in yell like in "welcomeStats"? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 3, 2011 Author Share Posted January 3, 2011 Originally Posted by Sir_Duck*: some time I get this error.. Code: [22:00:00 74] Error in LogChat: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-log]MySQL server has gone away --- End of inner exception stack trace --- at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException) at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode) 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) [22:01:43 10] ExGeMan has a 5 kill streak going! [22:04:00 84] Error in LogChat: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-log]MySQL server has gone away --- End of inner exception stack trace --- at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException) at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode) 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 have 3 procon's accessing the same remote database, it it just timing out?Error MySQL server has gone away ? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 3, 2011 Author Share Posted January 3, 2011 Originally Posted by weaklinks*: some time I get this error.. Code: [22:00:00 74] Error in LogChat: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-log]MySQL server has gone away --- End of inner exception stack trace --- at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException) at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode) 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) [22:01:43 10] ExGeMan has a 5 kill streak going! [22:04:00 84] Error in LogChat: System.InvalidOperationException: The connection has been disabled. ---> System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-log]MySQL server has gone away --- End of inner exception stack trace --- at System.Data.Odbc.OdbcConnection.ConnectionIsAlive(Exception innerException) at System.Data.Odbc.OdbcConnection.HandleErrorNoThrow(OdbcHandle hrHandle, RetCode retcode) 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 have 3 procon's accessing the same remote database, it it just timing out?Error MySQL server has gone away ? MySQL server crashed / or restarted thus cannot reach it . contact ISP Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 8, 2011 Author Share Posted January 8, 2011 Originally Posted by XpKiller*: I will release my next Version of my Plugin in the next days. Change: The Plugin is able to pull Stats from BFBCS now. Some Code improvements and more If anyone wants to help me testing feel free to Contact me. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 8, 2011 Author Share Posted January 8, 2011 Originally Posted by BB-Insomnia*: *meld* kannst du vielleicht noch nen check einbauen ob die eaguid und guid in der playerdata stehen und evtl nachtragen? Gruß Inso Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 8, 2011 Author Share Posted January 8, 2011 Originally Posted by XpKiller*: Guid muss immer drine stehen weil sonst er kann insert macht Eaguid wird geupdatet wenn die Option on ist Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 8, 2011 Author Share Posted January 8, 2011 Originally Posted by BB-Insomnia*: Das mag sein, aaaaaber: Spieler die schon in der Datenbank waren bevor die GUID geloggt wurde, haben ein feines NULL Zellchen Ich hab in meiner DB Spieler ohne GUID, ich würde sie per Hand nachtragen, aber 2586 sind 6 zuviel Noch eine kleine Bitte: LastSeenOnServer wäre mit unixtimestamp schöner zu verarbeiten und auch in der Datenbank schöner zu sortieren. Denke da an eine Anzeige der Spieler der letzten X Tage auf dem Server EDITH: das gleiche bei den den Mapstats (TimeMapLoad,TimeRoundStarted,TimeRoundEnd) und wenn du schon drüber bist auch gleich noch logDate :-) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 8, 2011 Author Share Posted January 8, 2011 Originally Posted by XpKiller*: Datetime ist das Format von MYSQL / SQL kann man nicht ändern es gibt zwar einen Timestamp aber das war glaube ich nicht das gleiche. Die Eaguids werden normalerweise nachgetragen wenn der Spieler das nächste mal auf dem Server kommt. Man kann ja keine Daten eintragen die man nicht hat. BETA Version of 3.0.2.0 Pls give Feedback Changelog: Beta Release!!! Now able to pull Stats from BFBCS and able to warn/kick/ban Player with high kdr and high Score per Minute (Globalstats) The Stats of BFBCS will be stored in the DB to reduce stress ob BFBCS.(tbl_bfbcs) Some Improvements in Code Download Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 8, 2011 Author Share Posted January 8, 2011 Originally Posted by BB-Insomnia*: http://de.wikipedia.org/wiki/Unixzeit Somit würde aus dem im Moment gespeicherten "2011-01-08 20:13:22" ein einfaches "1294515022" mit dem man auch arbeiten könnte, wie zum Beispiel Spieler die in einen LastSeenOnServer vor mehr als 2 Wochen haben aus der Liste ausblenden, im Moment geht das nur seeeehr umständlich. Wegen der GUID: Die EAGUID wird ja nachgetragen wenn ein spieler joint, von dem sie noch nicht drin steht, die GUID hingegen nicht (die ist doch bekannt wenn ein spieler am Server ist). Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by XpKiller*: Der Unix timstamp ist aber umso schwerer zu lesen für Menschen. Die Guid werde ich nicht nachtragen lassen weil ich so in probleme mit unique Index kommen könnte. Deine Fehler stammen noch aus einer älteren Version welche dort einen Bug hat. Dieser Fehler schon seit langer Zeit behoben und tritt seit dem nicht mehr auf. Nobody wants to test :? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by HelloKitty*: I want and will! Just setting up a "test-procon". Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by EBassie*: I'll start to test tomorrow. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by BB-Insomnia*: Der Unix timstamp ist aber umso schwerer zu lesen für Menschen. Die Guid werde ich nicht nachtragen lassen weil ich so in probleme mit unique Index kommen könnte. Deine Fehler stammen noch aus einer älteren Version welche dort einen Bug hat. Dieser Fehler schon seit langer Zeit behoben und tritt seit dem nicht mehr auf. Unique id ist genauso unique wie die guid.aber wenn ich kann dich ja nicht zwingen http://bc2.blood-boys.de/info.php_Soldi ... B=Insomnia ... keine GUID (bin mir sicher das problem haben einige) Wozu muss die Zeitangabe in der Datenbank denn lesbar sein? Wer schaut sich denn solche Daten denn direkt in der Datenbank an? Dafür gibts ne Gui (wie zb meine Webstats). Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by XpKiller*: Der Datentyp DATETIME ist dem Datetime Datentyp von C# am ähnlichsten. Da ich diesen Datentyp zu Zeitberechnungen oder zum Bestimmenvon Updates benötigte werde ich hier nichts ändern. Und ich kenne sehr wohl Leute die direkt in die Datenbank gucken, da man sich mit geschickten Abfragen auffällige Spiel raussuchen kann. Klar kann ich eine Option machen das die guid nach getragen wird aber es kann aber genauso passieren das dann richtige Probleme auftretten können. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by BB-Insomnia*: Der Datentyp DATETIME ist dem Datetime Datentyp von C# am ähnlichsten. Da ich diesen Datentyp zu Zeitberechnungen oder zum Bestimmenvon Updates benötigte werde ich hier nichts ändern. Und ich kenne sehr wohl Leute die direkt in die Datenbank gucken, da man sich mit geschickten Abfragen auffällige Spiel raussuchen kann. Klar kann ich eine Option machen das die guid nach getragen wird aber es kann aber genauso passieren das dann richtige Probleme auftretten können. - check if GUID IS NOT = NULL => UPDATE GUID Kannste wenigstens die Timestamps in der playerdata nachtragen? Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by XpKiller*: Timestamp: http://php.net/manual/de/datetime.gettimestamp.php Ich werd das mit den guid update einbauen aber wird aus sein by default Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by BB-Insomnia*: hab schon ne Lösung gefunden, für die zeitangaben, glaub ich. Das mit den guids nachtragen, war grad dabei mir ein phpscript zu bauen, aber wenn du das einbaust ists auch gut. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by EoT-Honk*: http://de.wikipedia.org/wiki/Unixzeit Somit würde aus dem im Moment gespeicherten "2011-01-08 20:13:22" ein einfaches "1294515022" mit dem man auch arbeiten könnte, wie zum Beispiel Spieler die in einen LastSeenOnServer vor mehr als 2 Wochen haben aus der Liste ausblenden, im Moment geht das nur seeeehr umständlich. Wandle doch mit php um und arbeite damit, viel umständlicher is es dann ja auch nicht.4 zeilen Code oder so. Aber was anderes, hab die Beta mal eingefügt nur Tabelle wird keine erstellt. Okay, man muss das Plugin einmal deaktivieren und wieder aktivieren um die Tabelle zu erstellen. Nen neustart nach einfügen des Plugins hat irgendwie nicht gereicht. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by BB-Insomnia*: Honk] Wandle doch mit php um und arbeite damit, viel umständlicher is es dann ja auch nicht. 4 zeilen Code oder so. mir ging es nicht um die Ausgabe sondern um den Select aus der Datenbank, zb nur die spieler die am 1.1.2011 gespielt haben, aber ich habs schon hinbekommen. Noch einige kleine Anpassungen dann ist alles wunderbar :-) Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 9, 2011 Author Share Posted January 9, 2011 Originally Posted by XpKiller*: Honk] Aber was anderes, hab die Beta mal eingefügt nur Tabelle wird keine erstellt. Okay, man muss das Plugin einmal deaktivieren und wieder aktivieren um die Tabelle zu erstellen. Nen neustart nach einfügen des Plugins hat irgendwie nicht gereicht. The tables will be created when they are needed like on mapchange or a player requesting stats. Quote * Restored post. It could be that the author is no longer active. Link to comment
ImportBot Posted January 10, 2011 Author Share Posted January 10, 2011 Originally Posted by slekkas*: Hi, Yesterday i moved my procon to a different server and i did something stupid by mistake. For some time(2-3 hours) i had two instances of procon running with the plugin enabled on both. I think as a result it created duplicate entries during that time. You can see here for your self: http://www.leagueofkarpathos.gr/server . is there any way i can fix this? some kind of script that i could run in phpmyadmin that will remove the newest duplicates? To be honest with you I'm not quite sure what caused this. I'm just guessing. You guys have probably more experience on this so i guess you must have seen this before. Thanks in advance Quote * Restored post. It could be that the author is no longer active. Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.