Problem with the script

[wOni]

Hello i just need help for 

AnnieRuru script

 

 

 

 

alter table guild add column woe_points int(11) default 0 after emblem_data, add index (woe_points);

 

 

prontera,155,181,5 script Woe Points 100,{
.@nb = query_sql( "select name, woe_points from guild order by woe_points desc limit 3", .@guild_name$, .@points );
for ( .@i = 0; .@i < .@nb; .@i++ ) {
if ( !.@points[.@i] ) break;
mes ( .@i +1 )+". "+ .@guild_name$[.@i] +" -> "+ .@points[.@i];
}
close;     <========
OnClock1930:
OnClock2000:
OnClock2030:
OnClock2100:
for ( .@i = 0; .@i < 30; .@i++ ) {
.@castle_guild_id = getcastledata( getvariableofnpc( .Castles$[.@i], "WOE_CONTROL" ), 1 );
if ( getvariableofnpc( .Active[0], "WOE_CONTROL" ) & 1 << .@i && .@castle_guild_id )
query_sql "update guild set woe_points = woe_points +1 where guild_id = "+ .@castle_guild_id;
}
end;
OnBreakEmp: // put doevent under OnAgitBreak ...
query_sql "update guild set woe_points = woe_points +1 where guild_id = "+ getcharid(2);
end;
}

 

When i click the npc mapserver say

(incorrect use of close command)

 

 

thank your for the help!

[Elsa Mist]

Hello i just need help for 

AnnieRuru script

 

 

 

 

alter table guild add column woe_points int(11) default 0 after emblem_data, add index (woe_points);

 

 

prontera,155,181,5 script Woe Points 100,{

.@nb = query_sql( "select name, woe_points from guild order by woe_points desc limit 3", .@guild_name$, .@points );

for ( .@i = 0; .@i < .@nb; .@i++ ) {

if ( !.@points[.@i] ) break;

mes ( .@i +1 )+". "+ .@guild_name$[.@i] +" -> "+ .@points[.@i];

}

close;     <========

OnClock1930:

OnClock2000:

OnClock2030:

OnClock2100:

for ( .@i = 0; .@i < 30; .@i++ ) {

.@castle_guild_id = getcastledata( getvariableofnpc( .Castles$[.@i], "WOE_CONTROL" ), 1 );

if ( getvariableofnpc( .Active[0], "WOE_CONTROL" ) & 1 << .@i && .@castle_guild_id )

query_sql "update guild set woe_points = woe_points +1 where guild_id = "+ .@castle_guild_id;

}

end;

OnBreakEmp: // put doevent under OnAgitBreak ...

query_sql "update guild set woe_points = woe_points +1 where guild_id = "+ getcharid(2);

end;

}

 

When i click the npc mapserver say

(incorrect use of close command)

 

 

thank your for the help!

 

this lines

.@nb = query_sql( "select name, woe_points from guild order by woe_points desc limit 3", .@guild_name$, .@points );
for ( .@i = 0; .@i < .@nb; .@i++ ) {
if ( !.@points[.@i] ) break;
mes ( .@i +1 )+". "+ .@guild_name$[.@i] +" -> "+ .@points[.@i];
}
close;     <========

replace with

.@nb = query_sql( "select name, woe_points from guild order by woe_points desc limit 3", .@guild_name$, .@points );
for ( .@i = 0; .@i < .@nb; .@i++ ) {
if ( !.@points[.@i] ) break;
mes ( .@i +1 )+". "+ .@guild_name$[.@i] +" -> "+ .@points[.@i];
}
end;

[wOni]

change to that, but i dont know why it wont add +1 to woe points.

 

 

trigger:

npc/guild/agit_main.txt

 

OnAgitBreak:

doevent "Woe Points::OnBreakEmp"; <=====

set brokeemp,brokeemp+1;

set .@GID,getcharid(2);

i add this
doevent "Woe Points::OnBreakEmp";

but it wont add woe points

[Nova]

-

Edited July 2, 2015 by Nova

[wOni]

bump