-
Posts
51 -
Joined
-
Last visited
Community Answers
-
Mahiro's post in Need help on this Announcement Box script. was marked as the answer
there are four variables that have not been set
-
Mahiro's post in Auto Reward 3x Guilds was marked as the answer
Well I tried like that but it failed.
I've been giving a search to try via SQL and it worked out fine:
query_sql "SELECT `guild_id` FROM `rwoe` ORDER BY `kd` DESC LIMIT 3",[email protected]_id; for([email protected]=0; [email protected]<getarraysize([email protected]_id); [email protected]++){ query_sql "UPDATE rwoe SET ord = "+([email protected]+1)+" WHERE guild_id="[email protected]_id[[email protected]]+""; } query_sql "SELECT `guild_id`,`ord` FROM `rwoe` WHERE `ord`=1",[email protected]_id1,[email protected]; // G1 query_sql "SELECT `guild_id`,`ord` FROM `rwoe` WHERE `ord`=2",[email protected]_id2,[email protected]; // G2 query_sql "SELECT `guild_id`,`ord` FROM `rwoe` WHERE `ord`=3",[email protected]_id3,[email protected]; // G3 soon after I joined with an If:
if([email protected] == 1){ // TOP 1 query_sql "SELECT `char_id` FROM `char` WHERE `guild_id`="[email protected]_id1+"",[email protected]; for([email protected]=0; [email protected]<getarraysize([email protected]); [email protected]++) { [email protected]$ = "1"; [email protected]$ = "1"; [email protected]$ = "1"; [email protected] = 0; setarray [email protected][0], 607, 608, 609, 613; setarray [email protected][0], 10, 5, 1, 1; setarray [email protected][0], 0, 0, 0, 0; setarray [email protected][0], 0, 0, 0, 0; setarray [email protected][0], 0, 0, 0, 0; mail [email protected][[email protected]], [email protected]$, [email protected]$, [email protected]$, [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]; } One for each TOP.
-
Mahiro's post in Adding Achievement was marked as the answer
- ID: 240500 Group: "AG_GET_ITEM" Name: "Jogador BETA" Condition: " ARG0 >= 3000000 " Reward: TitleID: 1035 Score: 30 [240500] = { UI_Type = 0, group = "GET_ITEM", major = 1, minor = 2, title = "Jogador BETA", content = { summary = "Seja BETA", details = "Teste o servidor em sua segunda fase.", }, resource = { [1] = { text = "Dado aos Jogadores que ajudaram o servidor em sua fase BETA. Obrigado!" } }, reward = { title = 1035 }, score = 30, } [1035] = "BETA"
friend,
I have no idea what version of rAthena you are using, or what date you are using, but I just got the same lines as the one you sent in the above Quote and works perfectly as you can see.
Edit: In your 'achievement_db' file, the 'Reward:' and 'TitleID: ID'