Chat, GUID, Stats and Mapstats Logger[1.1.0.1][BF3]

[ImportBot]

Originally Posted by kcuestag*:

 

Can't wait!

 

Let me know if you need a server to test on.

[ImportBot]

Originally Posted by HappyGotLucky*:

 

Same! If you could simplify the rank messages and make them work for say instead of yell that'd be fantastic. Unless Yell becomes available on BF4 soon.

[ImportBot]

Originally Posted by Strikes*:

 

Looks like it's working for all of our servers (BF4 - 10 of them). So much awesome data is from this; excellent man!

 

Now to go scour 187 pages on this thread to see if anyone's made something that outputs this information, from this DB, to the public on a website... if anyone already knows of something please let me know, lol.

[ImportBot]

Originally Posted by XpKiller*:

 

A new release is coming soon.

 

This new release has a slightly different db design and is going to support all games supported by procon.

 

I cannot guarantee yet that can can migrate all existent data to the new version

[ImportBot]

Originally Posted by kcuestag*:

 

This is awesome. Any chance of the update making it on time this weekend?

 

I don't mind about migration, I personally plan on starting from scratch, we already deleted our BF3 databases.

[ImportBot]

Originally Posted by TimSad*:

 

I do have 1 BF3 server left running this plugin. If the new database is more than just adding some tables and such here and there, hopefully writing an SQL to transfer the data won't be too hard. But then again, we won't be forced to use this one on our BF3 servers and thankfully each game has its own plugins directory.

[ImportBot]

Originally Posted by t0p8uzz*:

 

Running a 32 and two 64 man servers on I3D if you want any testers, let me know, we used it on BF3 servers a lot

[ImportBot]

Originally Posted by HappyGotLucky*:

 

Have 20 layers running the plugin. Looking forward to what you come up with. Stats loss due to DB changes doesn't matter much to me. As long as I can move basic player data over (EA/PB GUID/IP, soldier name and perhaps Chat) I'll be a happy camper.

[ImportBot]

Originally Posted by Frakkas*:

 

BTW, I did a quick workaround for the Yell/Say issue by simply replacing the //yell this! block of code at line 7426 with the //default say block of code in the else clause below it. This was for the "all" case in the switch statement. I also did this for the default case just a few lines below. And that was enough to get it working, but it had a bunch of [yell, 2] type fluff at the beginnings of the strings, so I deleted all that from the strings at the top of the file in addition to the cached stuff in the procon cfg file running on my layer server and it seems to be working fine.

 

You could probably use the Regex.Replace() code from the "yell" code block in the "say" code block and not have to bother with taking out the [yell, 2] from all the strings, but I'm going to actually play a bit tonight and leave it as is for now.

[ImportBot]

Originally Posted by XpKiller*:

 

@Frakkas

 

you don need to replace any code.

 

You read the plugin manual and replace the [yell] in the Statsmessages with [say] or [psay].

[ImportBot]

Originally Posted by Prophet731*:

 

@Xpkiller

 

Any chance you could PM me the new database schema? I just need to know what I need to write for my web admin (AdKats) for querying the database. I could also write a migrate script for the new/modified tables as I'm sure ill need to anyways.

[ImportBot]

Originally Posted by XpKiller*:

 

it is not final yet.

 

But there will be 2 new tables: one containing the weaponnames and one containing all weaponstats. All other tbl_wepons_* will not be used anymore. The table tbl_playerdata will get two new columns: Globalrank and game.

The table tbl_server will get a new column game as well.

 

So far only the weapon stats get lost without a migration script

[ImportBot]

Originally Posted by Narf!*:

 

I can haz beta?

[ImportBot]

Originally Posted by CptChaos*:

 

it is not final yet.

 

But there will be 2 new tables: one containing the weaponnames and one containing all weaponstats. All other tbl_wepons_* will not be used anymore. The table tbl_playerdata will get two new columns: Globalrank and game.

The table tbl_server will get a new column game as well.

 

So far only the weapon stats get lost without a migration script

I have to start blank. Also I don't see the point why someone would want to migrate the weapon stats as well. BF4 is a totally different game than BF3, so I would say that things like weapon stats aren't needed. Do you have some kind of test version available or an idea when the BF4 support is done?

 

Yes, I am anxious to start with the plugin, but take all the time you need!

[ImportBot]

Originally Posted by XpKiller*:

 

@CptChaos

 

the coming version is going to support all frostbite type engine games (BFBC2, MOH, MOHW,BF3,BF4).

 

I'm aiming to release the beta this evening.

[ImportBot]

Originally Posted by p19blo*:

 

@CptChaos

 

the coming version is going to support all frostbite type engine games (BFBC2, MOH, MOHW,BF3,BF4).

 

I'm aiming to release the beta this evening.

yay

[ImportBot]

Originally Posted by qraze*:

 

That sounds great

[ImportBot]

Originally Posted by Jaffaman*:

 

Sounds great we use to run this on our old BF3 server looking forward to getting it set up on BF4

[ImportBot]

Originally Posted by tonnic*:

 

Nice!

[ImportBot]

Originally Posted by Ruger*:

 

That's great!!

 

 

Sent from my iPhone using Tapatalk 2

[ImportBot]

Originally Posted by jking54*:

 

Great news Xp, so better to just start anew, new database?

[ImportBot]

Originally Posted by XpKiller*:

 

and here we go:

 

myrcon.net/.../stats-webpage-for-xpkillers-stats-logger-plugin

 

@jking54

There are some changes. I recommend to start a new db. maybe i provide a upgrade script later.

[ImportBot]

Originally Posted by Causality85*:

 

Is it compatible with the former version, or will the former tables be overwritten? I wrote SQL-Tasks (Abfragen), that I'd like to use in the future (it took the last 3 days to write some nice tasks to improve and enhance the use of your great Statslogger) (i will make a thread for that tasks in the "PlugIn Enhancement"-Section... maybe it's of intrest for you)

And to be honest, I don't want to edit them once more... i was a totally SQL noob a week ago... and now i am a magician with the "Where xy IN" clause (to give you a hint "entry in backup-banlist= erasing stats of banned players to keep the score/kill rankings clean of banned players... maybe also a good hint for plug-in improvement )

 

Back to main topic: Compatible? Old Tables' death?

[ImportBot]

Originally Posted by XpKiller*:

 

to keep it short:

 

the majority were unchanged or slightly altered

 

new tables:

tbl_games --> contains Game infos

tbl_weapons --> contains weaponlist for each game.

tbl_weapons _stats --> contains all weaponstats now. (Replacement for tbl_weapon_* tables)

 

altered tables:

tbl_playerdata --> added column GameID and GlobalRank

tbl_playerdata --> Unique incex now contains GameID and EA_GUID

tbl_server --> added column GameID

tbl_currentplayers --> added column GlobalRank

 

So it not compatibly without a migration script

 

If needed i can provide a script to update the old schema. I would need some time to write it.

 

You could sent me pm with your script so i could look at your script and tell you if it still will work.

[ImportBot]

Originally Posted by Frakkas*:

 

@Frakkas

 

you don need to replace any code.

 

You read the plugin manual and replace the [yell] in the Statsmessages with [say] or [psay].

Seems like those settings were getting stomped by what was in the config file every time I rebooted the layer server.

[ImportBot]

Originally Posted by Athlon*:

 

Seems like those settings were getting stomped by what was in the config file every time I rebooted the layer server.

Sounds like you were editing the text directly. Use the little ... way to the right of String[]Array (text box should open) if you want your text to stick.

[ImportBot]

Originally Posted by jking54*:

 

edited...

[ImportBot]

Originally Posted by XpKiller*:

 

let me check that later.

 

Also please post those questions in the thread of the new plugin.

[ImportBot]

Originally Posted by jking54*:

 

let me check that later.

 

Also please post those questions in the thread of the new plugin.

whups sorry (had many myrcon windows open ), will do

[ImportBot]

Originally Posted by ZeroKooL*:

 

Try to change your password. Otherwise you need to contact the server owner. To disable old_password auth.

The 6.6 .net connector had drop the support for it because it was deprecated.

I tried changing my password and it did not help, spent 2hrs talking to my host (hostgator) and they refused to To disable old_password auth, is there anything else i can do?

 

In the past when connecting to my DB's i have used

 

public DatabaseAccess()

{

connectionString = "Server=XXX.XXX.XXX.XXX;Port=XXXX;Database=XXXXXX; Uid=XXXXXXXX;password=XXXXXX;";

}

and it works fine.

 

But i can not workout how to implement this into the plugin.

 

Regards

Zero