flux pvp ladder

[dude123]

please can any one give me pvp ladder for lux cp there id already Death ranking why not kills and top pvp ranker raking please help if any one can give me

[Asura]

Hi Dude123,

I think you must set up a script on your server to count the deaths/kills per character; store it in a database or in a variable first. There is no simple script to just put in your FluxCP to make it work; you must integrate it within the game internally as well.

[dude123]

i have pvp ranking script in game but how do i integrate in flux cp for kills it have deaths ranking already

on searching i got this

http://sourceforge.net/apps/trac/raijero/changeset/470/fluxcp/

it have pvp ranking. but i think i neeed sql i dont know what sql table it need please help me in that case.

and also i wanna show the kill ranking in 127.0.0.1/fluxcp/?moduel=main that is main page so it will show 10 raking char]

please help

[Brian]

on searching i got this

http://sourceforge.n...set/470/fluxcp/

it have pvp ranking. but i think i neeed sql i dont know what sql table it need please help me in that case.

http://sourceforge.net/apps/trac/raijero/log/fluxcp/?verbose=on

Those modified FluxCP pages are designed to work with this NPC:

/raijero/trunk/npc/custom/pvp.txt

OnPCKillEvent:
query_sql "UPDATE `char` SET `kills` = `kills`+1 WHERE `char_id` = "+ getcharid(0);
if (attachrid(killedrid))
	query_sql "UPDATE `char` SET `deaths` = `deaths`+1 WHERE `char_id` = "+ getcharid(0);
end;

and these SQL modifications - /raijero/trunk/sql-files/main2.sql

-- Add columns to table `char`
ALTER TABLE `char`
ADD `kills` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
ADD `deaths` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
ADD `empbreak` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';