#221
|
|||
|
You want even more overhead? How about a write to innoDB
Code:
database.LogPvPKill(zone->GetShortName(), pvp_points, killer->CharacterID(), killer->GetName(), guild_mgr.GetGuildName(killer->GuildID()), killer->GuildID(), killer->GetLevel(), killer->GetRace(), killer->GetClass(), long2ip(killer->GetIP()).c_str(), this->CharacterID(), this->GetName(), guild_mgr.GetGuildName(this->GuildID()), this->GuildID(), this->GetLevel(), this->GetRace(), this->GetClass(), long2ip(this->GetIP()).c_str() ); Code:
this->UpdatePVPStats(PVPEncounterDeath, pvp_points); // you lose! next we'll divide your points between the group. // we don't need to SendPVPStats() here, they'll get them when they zone to their bind Code:
if (killer->IsGrouped()) { Group *pvp_group = entity_list.GetGroupByClient(killer); if (pvp_group != NULL) { pvp_points = pvp_points / pvp_group->GroupCount(); // divide the points, TODO: fix it to not divide by people not in zone for (int i = 0; i < 6; i++) { if ( pvp_group->members[i] != NULL && // we're only awarding "assists" for groupies in the same zone pvp_group->members[i]->CastToClient()->CharacterID() != killer->CharacterID() && pvp_group->members[i]->CastToClient()->GetZoneID() == zone->GetZoneID() ) { pvp_group->members[i]->CastToClient()->UpdatePVPStats(PVPEncounterAssist, pvp_points); pvp_group->members[i]->CastToClient()->SendPVPStats(); } } } } killer->UpdatePVPStats(PVPEncounterKill, pvp_points); // do this here for code flow logic killer->SendPVPStats(); Somehow that read from a myISAM table ain't looking like that big a deal anymore? | ||
|
#222
|
|||
|
Rogean,
Is it possible you could dump the logs of the PvP kills to a different public area where somebody else (as I doubt you have the time) could create a web page that tracks kill:death ratio for some sort of Leaderboard. If the data is readily available somebody else could make like a Sullon Zek type page, though I'm not sure how successful it would be with the population being where it's at currently. Need these changes like yesterday!
__________________
| ||
|
#223
|
|||
|
Cropped to hide MQ.
__________________
Project 1999 (PvE):
Giegue Nessithurtsithurts, 60 Bard <Divinity> Starman Deluxe, 24 Enchanter Lardna Minch, 18 Warrior Project 1999 (PvP): [50 (sometimes 49) Bard] Wolfram Alpha (Half Elf) ZONE: oasis | ||
|
#224
|
||||
|
Quote:
Make an API for me Rogean.. I will make a pwn leaderboard site. | |||
|
#226
|
||||
|
Quote:
| |||
|
#227
|
||||
|
Quote:
Or have you? http://www.rogean.com/images/p99sysencsearch.png http://www.rogean.com/images/p99sysencdetails.png http://www.rogean.com/images/p99sysnpctrade.png Point of all this.. Those logging systems don't make a single database call from the zoneserver process. Database queries are 10 years ago. Get on my level.
__________________
| |||
|
#228
|
|||
|
God what i'd do to see whats inside "Hackers"
| ||
|
#229
|
||||
|
Quote:
__________________
| |||
|
#230
|
||||
|
I don't think anyone is claiming you haven't done a fantastic job.
We just wish you'd stop playing star wars and come back to it [You must be logged in to view images. Log in or Register.]
__________________
Raev | Loraen | Sakuragi <The A-Team> | Solo Artist Challenge | Farmer's Market
Quote:
| |||
|
|
|