heartfilia

I am using eathena and seems like there's no longer support for it. If anyone here who is willing to script a WOE prize giver that has no bugs please message me. My server has two woe schedule per day and i want the winner to receive the prize after woe (All members who are online) I am currently using toasty's woe controller.

Link is dead?

Tried updating my flux guild ranking.. And i got this error.. Help pls. Fatal error: Call to a member function toArray() on a non-object in /home/modules/ranking/guild.php on line 6 ranking/guild.php <?php if (!defined('FLUX_ROOT')) exit; $title = 'Guild Ranking'; $castleNames = Flux::config('CastleNames')->toArray(); $ids = implode(',', array_fill(0, count($castleNames), '?')); $col = "g.guild_id, g.name, g.guild_lv, g.average_lv, g.emblem_len, "; $col .= "GREATEST(g.exp, (SELECT SUM(exp) FROM {$server->charMapDatabase}.guild_member WHERE guild_member.guild_id = g.guild_id)) AS exp, "; $col .= "(SELECT COUNT(char_id) FROM {$server->charMapDatabase}.`char` WHERE `char`.guild_id = g.guild_id) AS members, "; $col .= "(SELECT COUNT(castle_id) FROM {$server->charMapDatabase}.guild_castle WHERE guild_castle.guild_id = g.guild_id AND castle_id IN ($ids)) AS castles"; $sql = "SELECT $col FROM {$server->charMapDatabase}.guild AS g "; $sql .= "LEFT JOIN {$server->charMapDatabase}.`char` AS ch ON ch.char_id = g.char_id "; $sql .= "LEFT JOIN {$server->loginDatabase}.login ON login.account_id = ch.account_id "; $sql .= "WHERE login.level < ? "; $sql .= "ORDER BY g.guild_lv DESC, castles DESC, exp DESC, (g.average_lv + members) DESC, "; $sql .= "g.average_lv DESC, members DESC, g.max_member DESC, g.next_exp ASC "; $sql .= "LIMIT ".(int)Flux::config('GuildRankingLimit'); $sth = $server->connection->getStatement($sql); $sth->execute(array_merge(array_keys($castleNames), array((int)Flux::config('RankingHideLevel')))); $guilds = $sth->fetchAll(); ?>

prontera,155,177,5 script Card Seller 100,{ mes "Welcome to card seller ... meh lazy to say"; next; .@s = select( .alphabet_menu$ ) -1; close2; callshop "card_mob#"+ .alphabet$[.@s], 1; end; OnInit: freeloop 1; .@total = query_sql("select distinct left( name_japanese, 1 ) as aaa from item_db right join mob_db on item_db.id = mob_db.dropcardid where ~mode & 32 and type = 6 group by name_japanese order by aaa", .alphabet$ ); for ( .@i = 0; .@i < .@total; .@i++ ) { .alphabet_menu$ = .alphabet_menu$ + .alphabet$[.@i] +" Cards:"; .@nb = query_sql( "select item_db.id from item_db right join mob_db on item_db.id = mob_db.dropcardid where ~mode & 32 and type = 6 and left( name_japanese, 1 ) = '"+ .alphabet$[.@i] +"' group by name_japanese order by name_japanese limit 128", .@id ); npcshopdelitem "card_mob#"+ .alphabet$[.@i], 501; for ( .@j = 0; .@j < .@nb; .@j++ ) npcshopadditem "card_mob#"+ .alphabet$[.@i], .@id[.@j], 1000000; } freeloop 0; end; } - shop card_mob#A -1,501:1000 - shop card_mob#B -1,501:1000 - shop card_mob#C -1,501:1000 - shop card_mob#D -1,501:1000 - shop card_mob#E -1,501:1000 - shop card_mob#F -1,501:1000 - shop card_mob#G -1,501:1000 - shop card_mob#H -1,501:1000 - shop card_mob#I -1,501:1000 - shop card_mob#J -1,501:1000 - shop card_mob#K -1,501:1000 - shop card_mob#L -1,501:1000 - shop card_mob#M -1,501:1000 - shop card_mob#N -1,501:1000 - shop card_mob#O -1,501:1000 - shop card_mob#P -1,501:1000 - shop card_mob#Q -1,501:1000 - shop card_mob#R -1,501:1000 - shop card_mob#S -1,501:1000 - shop card_mob#T -1,501:1000 - shop card_mob#U -1,501:1000 - shop card_mob#V -1,501:1000 - shop card_mob#W -1,501:1000 - shop card_mob#X -1,501:1000 - shop card_mob#Y -1,501:1000 - shop card_mob#Z -1,501:1000 Not working on 3ceam?

The file's name is agit_template on eathena. Under OnAgitBreak: add if ( strcharinfo(3) == "Your Castle Map Name" ) query_sql "update guild set woe_points = woe_points +1 where guild_id = "+ getcharid(2); and replace "Your Castle Map Name" by the map name of the castle Thanks for that. BTW I tried this on eathena But there is an error in Line 8. Not working in eathena/3CeAM?

@Capuche - I want to use the script in a certain map only. How? And there is no agit_main.txt in npc/guild/ Thanks!