Module communication

[Dragonfire]

Atm the clanapp is standalone ...
I can implement a email notification if you agree,
but it would be cool to have more connections ...

1. webserver <-> notification system:

• livestreams, e.g. your ones
• events
• clan invitation
• new map
• ...

For live events, we send it direct over json to the faf.lobby ...

For persistent events, like clan invites, new maps, ...
I have another solution:

We have a event table:

Code: Select all

CREATE TABLE `event` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `data` VARCHAR(256) NOT NULL,
  `time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`));


(data is a json decoded dict)
Each startup the client ask for all events since the last logout time and show it, maybe persistent ...

2. name changes:
For performance reason we copy the player_name from the login table to a clan app table ...
Only if a player login again we check the original name and update it, if changed ...
Can I add a hook to the change_name.php script, that automatically updates the name?

[Ze_PilOt]

1. I have to think about it.

2. Why aren't using using the login table directly?

[Dragonfire]

2. Why aren't using using the login table directly?

As I wrote I consider about it ...
My excuse: thebeej did it xD

But if the amount of users increase it is a nice performance increase ... because we query the tabe A LOT.
(some kind of materialized view...)

[Aulex]

[VoR]Aulex:
ya i saw it
[VoR]Aulex:
thanks
[VoR]Aulex:
i think that would be a great idea
[VoR]Aulex:
would allow information to be transferred a lot better
[VoR]Aulex:
and would probably ease a lot of zep's frustration
DEV_Dragonfire:
write that !
17:44
DEV_Dragonfire:
psot it ..
17:45
[VoR]Aulex:
fiiiine
DEV_Dragonfire:
btw. what of zep's furstation?
[VoR]Aulex:
he gets pissed when no one reads announcments
[VoR]Aulex:
that popup could say like "new post in What's New section"

[Ze_PilOt]

2. Why aren't using using the login table directly?

As I wrote I consider about it ...
My excuse: thebeej did it xD

But if the amount of users increase it is a nice performance increase ... because we query the tabe A LOT.
(some kind of materialized view...)

I don't think it's necessary at all.

[Dragonfire]

I don't think it's necessary at all.

Then I change the implementation, maybe thebeej can say something about his decision (wait 2 weeks), but more important is question 1.

[Ze_PilOt]

I think he did it that way because he had no access to the FAF database to begin with.

Also, it forces me to do a join in the request to get the right clan tag at user login (as your table use different UIDs), and that's probably triggered more often than the page display

[Dragonfire]

I think he did it that way because he had no access to the FAF database to begin with.

Also, it forces me to do a join in the request to get the right clan tag at user login (as your table use different UIDs), and that's probably triggered more often than the page display

Yeah, we can optimize it later xd
If I have time I redesign it
Hope the game_stats materialized colum increases the performance.

1. what are your cons again the server<-> notification thing?

3. server <-> friendlist:
Should I store, friendgroup and some properties locally or on server?

[burnstreet]

3. server <-> friendlist:
Should I store, friendgroup and some properties locally or on server?

On the server please, better for people who use multiple computers.

[Ze_PilOt]

I think he did it that way because he had no access to the FAF database to begin with.

Also, it forces me to do a join in the request to get the right clan tag at user login (as your table use different UIDs), and that's probably triggered more often than the page display

Yeah, we can optimize it later xd
If I have time I redesign it
Hope the game_stats materialized colum increases the performance.

1. what are your cons again the server<-> notification thing?

3. server <-> friendlist:
Should I store, friendgroup and some properties locally or on server?

No. Please don't store anything locally. It's really not needed and will lead to more problems than it solve.

For notifications, it's probably easier and more effective to program a bot able to do it in the chat.