Agit points

[Mabuhay]

Can someone do this for me? Every time WoE Ends, the guild will receive the so called 'Agit Points'. It can be attained thru conquering castle. for example. Guild One has conquered the Swanhild Castle after the WoE ends, guild one receives 2 Agit points. Castles will have corresponding points.

Kriem = 3 Agit points

Swan = 2 Agit points

Other castles = 1 Agit points

And I was wondering if it can be stored as SQL so that it can be edited anytime.

The purpose of this script will help determine what guild really rules. and also to put up some thrills and motivation for players to play.

thanks

[Brian]

Here you go: http://rathena.kpaste.net/01a815b8cf?raw

• point values for each castle are set in the OnInit section
• when the script loads, it will attempt to add the `agit_points` column to the `guild` table. (If you see a MySQL error in the map-server, it means your MySQL user doesn't have the ALTER privilege. You will have to connect to your MySQL server as root and manually execute the ALTER TABLE query.)

[caspa]

Here you go: http://rathena.kpaste.net/01a815b8cf?raw

• point values for each castle are set in the OnInit section
• when the script loads, it will attempt to add the `agit_points` column to the `guild` table. (If you see a MySQL error in the map-server, it means your MySQL user doesn't have the ALTER privilege. You will have to connect to your MySQL server as root and manually execute the ALTER TABLE query.)

Sir bry..... can you put a reset ladder on this script...

also is this script attached on the guild itself? and not on the breaker?

like if "Player 1" joined the "Guild 1" and destroyed the Emperium....... so the "Guild 1" obtains 3 points..... now.... what if "Player 1" leaves the guild and joins "Guild 2"....... and breaks the emperium while he was in guild 2..... it would not start from 3 right? i mean the points "Player 1" accumulated while he was in "Guild 1" will not add on the points he will get on "Guild 2" ?.....................

Then is it possible to put a green color if the guild is still active and red if the guild is disbanded?

Edited February 16, 2013 by caspa

[Brian]

Brian, can you put a reset ladder on this script...

also is this script attached on the guild itself? and not on the breaker?

Then is it possible to put a green color if the guild is still active and red if the guild is disbanded?

1. to reset agit_points, run this SQL query (the server can be online or offline)

UPDATE `guild` SET `agit_points`=0;

2. `agit_points` is a new SQL column in the `guild` table.

Points are directly associated with the guild (emp break counts, and the character who breaks the emp is not recorded at all).

3. Since agit_points are part of the guild table, when a guild is deleted their agit_points are deleted too. Guilds that have been disbanded will not appear in the list.

[caspa]

okay thank you sir bry...........