Guild Ranking SQL guide

[chromus28]

guys can any one give me an guide or step by step on how to install the guild ranking by lllchrislll ??

 

http://llchrisll-scripts.googlecode.com/svn/trunk/released/sql-based/gld_ranker.txt <<<<<here is it

[Lil Troll]

Insert this to Sql Query.
 

DROP TABLE IF EXISTS `guild_rank_mem`;
CREATE TABLE `guild_rank_mem` (
  `char_id` int(10) unsigned NOT NULL,
  `guild_id` smallint(5) unsigned NOT NULL,
  `rank` smallint(5) unsigned DEFAULT '0',
  `woe` smallint(5) unsigned DEFAULT '0',
  `donate` int(11) unsigned DEFAULT '0',
  `donate_am` int(11) unsigned DEFAULT '0',
  `holiday` smallint(5) unsigned DEFAULT '0',
  PRIMARY KEY (`char_id`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `guild_rank_guild`;
CREATE TABLE  `guild_rank_guild` (
  `guild_id` smallint(5) unsigned NOT NULL,
  `type` smallint(5) unsigned DEFAULT '1',
  `rank` smallint(5) unsigned DEFAULT '0',
  `woe` smallint(5) unsigned DEFAULT '0',
  `donate` int(11) unsigned DEFAULT '0',
  `donate_min` int(11) unsigned DEFAULT '0',
  `donate_max` int(11) unsigned DEFAULT '0',
  PRIMARY KEY (`guild_id`)
) ENGINE=MyISAM;

Then place the NPC wherever you wanted.