Elijah23

Hello everyone.. So i've used a script for guild points.. function script GuildRanker { query_sql("select name from `guild` where guild_id = '"+.@gid+"'", .@gname$); query_sql "CREATE TABLE IF NOT EXISTS `woe_extension`(`guild_id` int(11) unsigned NOT NULL,`guild_points` smallint(6) unsigned NOT NULL default '0')"; set .@TempGuild_id, .@gid; query_sql("SELECT guild_points FROM woe_extension WHERE guild_id="+.@TempGuild_id, .@TempGuild_Points); if ( .@TempGuild_id != 0 && .@TempGuild_Points == 0 ) {// guild not listed yet set .@TempGuild_Points, .@TempGuild_Points + 1; query_sql "INSERT INTO woe_extension (guild_id, guild_points) VALUES ("+.@TempGuild_id+","+.@TempGuild_Points+")"; announce "Guild ["+.@gname$+"] has just added One [1] WoE Points by conquering a Castle and with a running Guild Conqueror Points of "+.@TempGuild_Points+" !",bc_all; } if ( .@TempGuild_id != 0 && .@TempGuild_Points >= 1 ) { // guild is listed set .@TempGuild_Points, .@TempGuild_Points + 1; query_sql("UPDATE woe_extension SET guild_points="+.@TempGuild_Points+" WHERE guild_id="+.@TempGuild_id); announce "Guild ["+.@gname$+"] has just added another One [1] WoE Points by conquering a Castle and with a running Guild Conqueror Points of "+.@TempGuild_Points+" !",bc_all; } return; It's working and giving the points and it's recorded on the sql.. I want to integrate this point in the guild ranking feature of flux or maybe another ranking feature but i'm finding it hard to do so cause i can't understand the code such as: $col = "g.guild_id, g.name, g.guild_lv, g.exp, g.average_lv, g.emblem_len,"; $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) 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 "; I tried to make a code but it's not working.. Thanks in advance..

Hi! Here's a script from Goddameit which i have edited... //Author : Goddameit //Version : 2011/12/16 - 01:04 function script AllGuildMemberEvent { if(!set(.@gid,getcastledata(getarg(0),1))) return; query_sql("select account_id, char_id from `guild_member` where guild_id = '"+.@gid+"'", .@gmaid, .@gmcid); for(set .@i,0;.@i { if(isloggedin(.@gmaid[.@i])) getitem 12628,1,.@gmaid[.@i]; } } - script AGME -1,{ OnAGME: setarray .@maps$[0],"aldeg_cas01","aldeg_cas02","aldeg_cas03","aldeg_cas04","aldeg_cas05"; setarray .@maps$[5],"gefg_cas01","gefg_cas02","gefg_cas03","gefg_cas04","gefg_cas05"; setarray .@maps$[10],"payg_cas01","payg_cas02","payg_cas03","payg_cas04","payg_cas05"; setarray .@maps$[15],"prtg_cas01","prtg_cas02","prtg_cas03","prtg_cas04","prtg_cas05"; for( set .@i,0; .@i <= 19; set .@i, .@i+1) { callfunc "AllGuildMemberEvent",.@maps$[.@i],0, "System","WoE Victory Reward","Congratulations! Your guild succeeded in occupying "+ getcastlename(.@maps$[.@i]) +". This is your rewards.", 501,1,1,0, "[You got a mail!! Please relogin to reupdate your mail list.]"; } end; } For the cashpoints, just make an item that gives a cash point and add it's getitem command.. EDIT: I forgot to tell you to add onAgitEnd of your woe script.. Hope it helps..

Thanks for the answer, i'm gonna try this.. Edit: Thank you very much.. It's working now..

Hello po, gumagamit ako ng Renewal client, 05-17b-2011 ang prob po, hindi nag sasave yung sa friend setup na Open 1:1 Chat not between Friends Open 1:1 Chat between Friends Alarm when you receive a 1 on 1 Chat So dinidisable ko po yung unang dalawa, yung open 1:1 Chat, kaso pag cnlose na po yung client, pag open ko po ulit, nka enable nanaman. May nabasa ako dati na regarding daw sa diff na extended PM box, so i tried to diff another 05-17b-2011 na naka enable at yung isa hindi nka enable, pero same result lang po. Maraming Salamat po sa makakatulong sa akin..

Sir, how can i show the server status on all pages?.. I managed to put it on top and place it in header.php but only shows in server status page... Thanks..

Ok, so i tried different clients ranging from 5-11 to 6-28 clients.. And i found out that its only the "GREEN DRAGON" mount which is giving me the error.. So I think it's sprite or act error.. I checked rdata.grf and it has the sprite and act for the green dragon, So I really don't have any idea why it's causing such error... Advance thanks to someone who can help.. God bless you guys..

Hi guys.. I'm using the said client above.. all is well but I'm having trouble when using skills of a Rune Knight on a Dragon Mount... When i cast Rune Knight's skills like dragon breath, concentration and enchant blade, it gives me a gravity error... But using my admin account which doesn't show a dragon mount, i don't have gravity errors... I really don't know what's causing the error... I'm using the data folder from Judas... 07-16-2011 Btw, i'm using 3ceam 650.. There are no errors in the mapserver, char server and login server... Thanks for those who will reply..