Jump to content

Battlelog Cache (1.0.1.0 - 14/1/13)


ImportBot

Recommended Posts

  • Replies 127
  • Created
  • Last Reply

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.
* Restored post. It could be that the author is no longer active.
Link to comment
  • 2 weeks later...

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

* Restored post. It could be that the author is no longer active.
Link to comment
  • 4 weeks later...

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 :P

* Restored post. It could be that the author is no longer active.
Link to comment

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.

* Restored post. It could be that the author is no longer active.
Link to comment

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 :smile:

 

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.

* Restored post. It could be that the author is no longer active.
Link to comment
  • 3 months later...

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.

* Restored post. It could be that the author is no longer active.
Link to comment
  • 3 weeks later...

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?

* Restored post. It could be that the author is no longer active.
Link to comment

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

* Restored post. It could be that the author is no longer active.
Link to comment

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.
* Restored post. It could be that the author is no longer active.
Link to comment

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.
* Restored post. It could be that the author is no longer active.
Link to comment
  • 3 months later...

Originally Posted by EBassie*:

 

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

 

thank you :mad:

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;
* Restored post. It could be that the author is no longer active.
Link to comment

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?
* Restored post. It could be that the author is no longer active.
Link to comment
  • 2 months later...

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 :biggrin:

* Restored post. It could be that the author is no longer active.
Link to comment

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 :biggrin:

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

* Restored post. It could be that the author is no longer active.
Link to comment

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
* Restored post. It could be that the author is no longer active.
Link to comment

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

* Restored post. It could be that the author is no longer active.
Link to comment

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
* Restored post. It could be that the author is no longer active.
Link to comment

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

* Restored post. It could be that the author is no longer active.
Link to comment

Archived

This topic is now archived and is closed to further replies.




×
×
  • Create New...

Important Information

Please review our Terms of Use and Privacy Policy. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.