Battlelog Cache (1.0.1.0 - 14/1/13)

[ImportBot]

Originally Posted by aduh*:

 

You can truncate the cache table, yes.

like that ?

http://i.imgur.com/yC8vrNi.jpg

Empty from dropdown menu ?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

like that ?

http://i.imgur.com/yC8vrNi.jpg

Empty from dropdown menu ?

Yep, that will work.

 

Running "TRUNCATE BattlelogCache;" will also work.

[ImportBot]

Originally Posted by aduh*:

 

Is it possible to empty only old entries of users not visits server from long time?

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Is it possible to empty only old entries of users not visits server from long time?

The plugin will rebuild its cache for users regularly in your server, it won't take long either.

[ImportBot]

Originally Posted by aduh*:

 

Ok thx

[ImportBot]

Originally Posted by durangod*:

 

Hi,

 

i set up the db on my host server and the only way i could create the playerlist table is to have atleast one field, so i gave it an AI (auto increment) field called pid. And thats all. is that ok? thanks

 

 

or maybe i should not make it an AI field, as you prob have your own that it self creates... please advise

[ImportBot]

Originally Posted by MadSochi*:

 

Where can i get the FULL .sql script for creation battlelogcache's table ?

 

https://morpheusx.at/procon/battlelo...ble_create.sql

 

This link is empty.

[ImportBot]

Originally Posted by gh0oSst*:

 

Where can i get the FULL .sql script for creation battlelogcache's table ?

 

https://morpheusx.at/procon/battlelo...ble_create.sql

 

This link is empty.

here..

 

Attached Files:

• battlelogcache_table_create.zip

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

here..

Thanks. I've re-uploaded the file to my new server as well, so the URL linked above should work again!

[ImportBot]

Originally Posted by MadSochi*:

 

CREATE TABLE IF NOT EXISTS `BattlelogCache` (

`personaId` varchar(50) COLLATE utf8_bin NOT NULL,

 

VARCHAR ? Not Integer? Not autoincrement?

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

CREATE TABLE IF NOT EXISTS `BattlelogCache` (

`personaId` varchar(50) COLLATE utf8_bin NOT NULL,

 

VARCHAR ? Not Integer? Not autoincrement?

Indeed.

The PersonaID is the one fetched from Battlelog, which is unique per player and automatically "generated" by querying the player's stats from the EA servers.

No idea why I didn't add a "normal" integer/autoincrement index, but it probably seemed enough back then

[ImportBot]

Originally Posted by durangod*:

 

i am alittle confused here now and i hope its just because some of what is posted is for bf3 and some for bf4. If you look at the reply on this thread i think its 156 myrcon.net/...battlelog-cache#entry32123

 

you will see that i had to create some kind of field in the table. That procplay db is never populated but i guess its not suppose to be. So is this BattlelogCache something new aside from the procplay db. Does this go inside the bfadmlog table, just not sure what do do with this sql that is being shared if i am running bf3 only.

[ImportBot]

Originally Posted by MorpheusX(AUT)*:

 

i am alittle confused here now and i hope its just because some of what is posted is for bf3 and some for bf4. If you look at the reply on this thread i think its 156 myrcon.net/...battlelog-cache#entry32123

 

you will see that i had to create some kind of field in the table. That procplay db is never populated but i guess its not suppose to be. So is this BattlelogCache something new aside from the procplay db. Does this go inside the bfadmlog table, just not sure what do do with this sql that is being shared if i am running bf3 only.

Creating a table without an autoincrement key should work fine, I just tried it again with my local and remote (MySQL) databases. I don't know which system you're hosting your database on, but it appears to be a problem on the hosting side.

Added another "id" field with int/autocreate should be fine, however I'm not a 100% sure atm. You could at least give it a try though

 

I honestly don't know what "procplay" and "bfadmlog" tables you're talking about: BattlelogCache (which only works for BF3 btw) is completely independent from any other plugins and/or Procon systems. It will just require one table (created via the SQL found here: https://morpheusx.at/procon/battlelo...ble_create.sql) in a database, nothing else.

[ImportBot]

Originally Posted by spatieman*:

 

(bumping)

just made the database, entered the tablestuff, and worked.

thnxs morpheusX.

now its waiting time for other smart guys (uh, and womans) to make a plugin that can periodic flush some tagged stat info in the server.

[ImportBot]

Originally Posted by davidgong*:

 

I can not find The CREATE-script for the table in the plugin's zip-File and download's link is not available.

[ImportBot]

Originally Posted by Mamba334*:

 

Is there a battleolog cache for BF4? Insane Limits tells me it needs to have that installed in order to work, but its not supported for bf4?

[ImportBot]

Originally Posted by LumPenPacK*:

 

Is there a battleolog cache for BF4? Insane Limits tells me it needs to have that installed in order to work, but its not supported for bf4?

No, Battlelog Cache doesn't support BF4 but IL should basically also works without it. Just make sure "slow data fetch" is enabled.

 

Sent from mobile device

[ImportBot]

Originally Posted by Mamba334*:

 

No, Battlelog Cache doesn't support BF4 but IL should basically also works without it. Just make sure "slow data fetch" is enabled.

 

Sent from mobile device

I did that bro, but it says "You need Battlelog Cache for this to be enabled" when you check the box to run it.

[ImportBot]

Originally Posted by EBassie*:

 

I did that bro, but it says "You need Battlelog Cache for this to be enabled" when you check the box to run it.

It's just a warning. You can use Battlelog fetching. You don't NEED Battlelog Cache.

[ImportBot]

Originally Posted by Mamba334*:

 

It's just a warning. You can use Battlelog fetching. You don't NEED Battlelog Cache.

Ok, so where is the option to limit jets?

[ImportBot]

Originally Posted by ChaTon*:

 

MorpheusX can you reupload the file for creating the sql table ?

 

thank you

[ImportBot]

Originally Posted by EBassie*:

 

MorpheusX can you reupload the file for creating the sql table ?

 

thank you

Use this:

 

Code:

CREATE TABLE IF NOT EXISTS `BattlelogCache` (
  `personaId` varchar(50) COLLATE utf8_bin NOT NULL,
  `playerName` varchar(32) COLLATE utf8_bin NOT NULL,
  `clanTag` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `overviewStats` longtext COLLATE utf8_bin,
  `weaponStats` longtext COLLATE utf8_bin,
  `vehicleStats` longtext COLLATE utf8_bin,
  `generalStatus` text COLLATE utf8_bin,
  `overviewStatsError` text COLLATE utf8_bin,
  `weaponStatsError` text COLLATE utf8_bin,
  `vehicleStatsError` text COLLATE utf8_bin,
  `timestampOverview` timestamp NULL DEFAULT NULL,
  `timestampWeapon` timestamp NULL DEFAULT NULL,
  `timestampVehicle` timestamp NULL DEFAULT NULL,
  `timestampClanTag` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`personaId`),
  UNIQUE KEY `playerName` (`playerName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

[ImportBot]

Originally Posted by ColColonCleaner*:

 

Use this:

 

Code:

CREATE TABLE IF NOT EXISTS `BattlelogCache` (
  `personaId` varchar(50) COLLATE utf8_bin NOT NULL,
  `playerName` varchar(32) COLLATE utf8_bin NOT NULL,
  `clanTag` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `overviewStats` longtext COLLATE utf8_bin,
  `weaponStats` longtext COLLATE utf8_bin,
  `vehicleStats` longtext COLLATE utf8_bin,
  `generalStatus` text COLLATE utf8_bin,
  `overviewStatsError` text COLLATE utf8_bin,
  `weaponStatsError` text COLLATE utf8_bin,
  `vehicleStatsError` text COLLATE utf8_bin,
  `timestampOverview` timestamp NULL DEFAULT NULL,
  `timestampWeapon` timestamp NULL DEFAULT NULL,
  `timestampVehicle` timestamp NULL DEFAULT NULL,
  `timestampClanTag` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`personaId`),
  UNIQUE KEY `playerName` (`playerName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Perhaps edit that into the OP?

[ImportBot]

Originally Posted by ChaTon*:

 

Thank you ebassie

[ImportBot]

Originally Posted by Hodor*:

 

So much time has passed, and so far for the BF4 can not do that. I looked up, there's not much to do, but I don't know how to change the code so that no error occurred.

 

lazy people here

[ImportBot]

Originally Posted by EBassie*:

 

So much time has passed, and so far for the BF4 can not do that. I looked up, there's not much to do, but I don't know how to change the code so that no error occurred.

 

lazy people here

This plugin won't get updated for BF4 by the original author.

 

I don't believe it's needed either.

 

No need to be cynical about it.

 

Sent from my Galaxy S6 Edge using Tapatalk

[ImportBot]

Originally Posted by Hodor*:

 

This plugin won't get updated for BF4 by the original author.

 

I don't believe it's needed either.

 

No need to be cynical about it.

 

Sent from my Galaxy S6 Edge using Tapatalk

Its needed for Multibalancer, because without battlelog - stupid and slow balancer. Truebalancer can check Battlelog BF4, but not friendly with /move /fmove AdKats. That's why I do not use TrueBAlancer

[ImportBot]

Originally Posted by EBassie*:

 

Its needed for Multibalancer, because without battlelog - stupid and slow balancer. Truebalancer can check Battlelog BF4, but not friendly with /move /fmove AdKats. That's why I do not use TrueBAlancer

It's not NEEDED for multibalancer to work with BF4.

 

Multibalancer CAN use it for BF3, but it's NOT NEEDED either.

 

Sent from my Galaxy S6 Edge using Tapatalk

[ImportBot]

Originally Posted by Hodor*:

 

It's not NEEDED for multibalancer to work with BF4.

 

Multibalancer CAN use it for BF3, but it's NOT NEEDED either.

 

Sent from my Galaxy S6 Edge using Tapatalk

Oh really? I want to balance from Battlelog statistic, because it will be faster than waiting until the player plays a half round and after balancer will move him for balance

[ImportBot]

Originally Posted by EBassie*:

 

Oh really? I want to balance from Battlelog statistic, because it will be faster than waiting until the player plays a half round and after balancer will move him for balance

Well it works for me, so why wouldn't it work for you?

 

Multibalancer does check if you have this plugin installed and enabled. But if it's not present it will fetch the stats directly from battlelog....

 

 

 

 

Sent from my Galaxy S6 Edge using Tapatalk