Upcoming changes

[GODPARTICLE]

You want even more overhead? How about a write to innoDB

	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()
						
	);

Or an update

	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

Or an update for the entire group?

	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?

[Rogean]

Originally Posted by GODPARTICLE [You must be logged in to view images. Log in or Register.]

You want even more overhead? How about a write to innoDB

Or an update

Or an update for the entire group?


Somehow that read from a myISAM table ain't looking like that big a deal anymore?

And yet we have far more sophisticated tracking on numerous systems such as that in the game, as I'm sure you've seen.

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.

[GODPARTICLE]

Originally Posted by Rogean [You must be logged in to view images. Log in or Register.]

And yet we have far more sophisticated tracking on numerous systems such as that in the game, as I'm sure you've seen.

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.

So you store them locally in memory for awhile and take a big dump then, you don't avoid the database

[Rogean]

Originally Posted by GODPARTICLE [You must be logged in to view images. Log in or Register.]

So you store them locally in memory for awhile and take a big dump then, you don't avoid the database

Bzzzzt

[hijinks]

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!

[Vile]

Originally Posted by hijinks [You must be logged in to view images. Log in or Register.]

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!

Make an API for me Rogean.. I will make a pwn leaderboard site.

[Vile]

Originally Posted by Vile [You must be logged in to view images. Log in or Register.]

Make an API for me Rogean.. I will make a pwn leaderboard site.

I'll even code the API and send to you for approval (you can input DB info etc..). I just need to see the table structure where you logging the PvP kill info...

[GODPARTICLE]

server needs leaderboards

[You must be logged in to view images. Log in or Register.]

[magician]

God what i'd do to see whats inside "Hackers"

[Rogean]

Originally Posted by magician [You must be logged in to view images. Log in or Register.]

God what i'd do to see whats inside "Hackers"

Nothing, actually. It's a dead link. Page I never made. All the information is in the database, but there's no front end page for it. (Account table holds the flag, separate tables hold violation instances with information regarding type and details).