Guild PK Points

[Aya]

Is it possible to make a script (like a ranker NPC or something) that tally the total accumulated PK points of a certain Guild during WoE? For example, Guild 1: Total PK points = 1000; Guild 2: Total PK points = 2000 something like that.

[Capuche]

Is it possible to make a script (like a ranker NPC or something) that tally the total accumulated PK points of a certain Guild during WoE? For example, Guild 1: Total PK points = 1000; Guild 2: Total PK points = 2000 something like that.

// alter table guild add column pk_woe_points int(11) default 0 after emblem_data, add index (pk_woe_points);
prontera,155,181,5	script	PK Woe Points	100,{
	.@nb = query_sql( "SELECT name, pk_woe_points from guild order by pk_woe_points desc limit 3", .@guild_name$, .@points ); // top 3
	for ( .@i = 0; .@i < .@nb; .@i++ ) {
		if ( !.@points[.@i] ) break;
		mes ( .@i +1 )+". "+ .@guild_name$[.@i] +" -> "+ .@points[.@i];
	}
	close;

OnPCKillEvent:
	if( agitcheck() && getcharid(2) && compare( .castle$, strcharinfo(3) ) )
		query_sql "update guild set pk_woe_points = pk_woe_points +1 where guild_id = "+ getcharid(2);
	end;
OnInit:
	setarray .@castle_name$, "prtg_cas01", "prtg_cas02"; // etc.. add yours castles
	.castle$ = implode( .@castle_name$, "|" );
	end;
}

One kill in prtg_cas01 = +1 point to the guild killer

[Aya]

Okay, now testing it. Thanks btw.

Uhh I think your script gives a certain guild a Points. Hmm what I want is that, it's like a pvp ladder but instead of recording a player's Kills, I want it to be the guild's kills. )

[GM Takumirai]

i see like a pvp ladder with reset function

Edited March 6, 2013 by GM Takumirai

[Capuche]

Okay, now testing it. Thanks btw.

Uhh I think your script gives a certain guild a Points. Hmm what I want is that, it's like a pvp ladder but instead of recording a player's Kills, I want it to be the guild's kills. )

It records guild's kills

Each time a player of a guild kill a player on a map in woe

setarray .@castle_name$, "prtg_cas01", "prtg_cas02"; // etc.. add yours castles

the guild gains 1 point

i see like a pvp ladder with reset function

There isn't reset function for this script

But you can reset with sql

Edited March 6, 2013 by Capuche