brunoshp

i need buy item for pontos. ex: item 607 for 20 pontos item 678 for 15 pontos and other items

how i do player buy item in npc for ponts in Sql? table: ALTER TABLE `char` ADD `pontos` INT NOT NULL ; i make this but no ok! when player buy decrease -1 ponto in table this char. query_sql "UPDATE `char` SET `pontos` = `pontos` -1";

Not Ok .It did not work, he warned not to anyone how many players missing.

Hi, i need to make when player enter in chat , show for all server how many peoples to start. this script: - script custom_bg#control -1,{ OnInit: set .minplayer2start, 3; // minimum player to start setarray .rewarditem, 673, 5, // reward to the winning team 673, 3; // reward to the losing team set .startingscore, 99; // score at start set .eventlasting, 100; // event last 100 seconds end; OnStart: if ( getwaitingroomstate( 0, "red side" ) < .minplayer2start || getwaitingroomstate( 0, "blue side" ) < .minplayer2start ) end; set .red, waitingroom2bg( "guild_vs3", 13,50, strnpcinfo(0)+"::OnredQuit", strnpcinfo(0)+"::OnredDead", "red side" ); copyarray .team1aid[.@i], $@arenamembers[.@i], $@arenamembersnum; set .blue, waitingroom2bg( "guild_vs3", 86,50, strnpcinfo(0)+"::OnblueQuit", strnpcinfo(0)+"::OnblueDead", "blue side" ); copyarray .team2aid[.@i], $@arenamembers[.@i], $@arenamembersnum; delwaitingroom "red side"; delwaitingroom "blue side"; bg_warp .red, "guild_vs3", 13,50; bg_warp .blue, "guild_vs3", 86,50; set .score[1], .startingscore; set .score[2], .startingscore; bg_updatescore "guild_vs3", .score[1], .score[2]; sleep .eventlasting * 1000; if ( .score[1] == .score[2] ) mapannounce "guild_vs3", "Draw !", 0; else if ( .score[1] > .score[2] ) { mapannounce "guild_vs3", "red side wins !", 0; callsub L_reward, 1, 0; callsub L_reward, 2, 2; } else if ( .score[1] < .score[2] ) { mapannounce "guild_vs3", "blue side wins !", 0; callsub L_reward, 2, 0; callsub L_reward, 1, 2; } bg_warp .red, "prontera", 155,182; bg_warp .blue, "prontera", 158,182; bg_destroy .red; bg_destroy .blue; donpcevent "red side::OnInit"; donpcevent "blue side::OnInit"; end; L_reward: set .@size, getarraysize( getd(".team"+ getarg(0) +"aid") ); for ( set .@i, 0; .@i < .@size; set .@i, .@i +1 ) if ( isloggedin( getd(".team"+ getarg(0) +"aid["+ .@i +"]" ) ) ) getitem .rewarditem[ getarg(1) ], .rewarditem[ getarg(1) +1 ], getd(".team"+ getarg(0) +"aid["+ .@i +"]" ); return; OnredDead: callsub L_dead, 1; OnblueDead: callsub L_dead, 2; L_dead: set .score[ getarg(0) ], .score[ getarg(0) ] -1; bg_updatescore "guild_vs3", .score[1], .score[2]; if ( .score[ getarg(0) ] == 0 ) awake strnpcinfo(0); end; OnredQuit: callsub L_quit, 1, .red; OnblueQuit: callsub L_quit, 2, .blue; L_quit: if ( bg_get_data( getarg(1), 0) ) end; set .score[ getarg(0) ], 0; awake strnpcinfo(0); end; } bat_room,114,97,5 script red side 100,{ end; OnInit: waitingroom "Facção Vermelha", getvariableofnpc( .minplayer2start, "custom_bg#control" ) +1, "custom_bg#control::OnStart", getvariableofnpc( .minplayer2start, "custom_bg#control" ); end; } bat_room,169,227,5 script blue side 100,{ end; OnInit: waitingroom "Facção Azul", getvariableofnpc( .minplayer2start, "custom_bg#control" ) +1, "custom_bg#control::OnStart", getvariableofnpc( .minplayer2start, "custom_bg#control" ); end; } guild_vs3 mapflag pvp off guild_vs3 mapflag battleground 2 guild_vs3 mapflag nosave SavePoint guild_vs3 mapflag nowarp guild_vs3 mapflag nowarpto guild_vs3 mapflag noteleport guild_vs3 mapflag nomemo guild_vs3 mapflag nopenalty

Thx for all!

if i need to reset ranking, how i do?

i need to add Ranking wot in this raking pvp. mes "Ok, this is Ranking WoT[TOP 10]"; next; query_sql "SELECT name, wotrank FROM char ORDER BY char DESC LIMIT 10",@name$,@charwot; dispbottom "Ranking WOT [TOP 10]"; dispbottom " "; dispbottom "Player < x > Position"; dispbottom " "; for(set @i,0;@i<=9;set @i,@i+1) { dispbottom "["+(@i+1)+"] < x > "+@name$[@i]+" < x > "+@charwot[@i]+""; } close; my table in database : ALTER TABLE `char` ADD `wotrank` INT NOT NULL ; this not ok, help me to fix!! pls!

up

Yeah ! id account have item 31098 or other item id! Up?

I need one npc with this? he Check how acount have item 969 and list for my what account have this items!

Is good , but only for $$?

@security should also contain 1.Block invites from a guild. 2.Block /guild command. 3.Block delete character** Advantage: 1. Even if your account is hacked , no one can transfers your equips by any means. **I don't know if we can delete a character without a Gamemaster.[ if we can then @security should contain Block delete character too]** 2. This way we can give our id to a friend without the fear of losing our equips , i.e unless we are already in a guild. Great for giving our id for level services. @security blocks trade and also disables a person to change password unless he knows the security number. This way one also cannot sell items to NPCs. Now the only way a person can lose his/her equips is by gstorage. So the above suggestion.

up

i use this , hot i make to block trade? with this script? http://pastebin.com/eYsnN9qv

but leader use rally and player not talk to npc?

i use this AnnieRuru script's :http://www.eathena.ws/board/index.php?showtopic=271291&st=0&p=1491475entry1491475 The reward will be given to all guild members only members particped Event AnnieRuru can help?

up

Pin code have bug. i log in first and put pin code 1111, if i log out and log in have to put pin code = 1111 but i put and no enter, show msg failed to login. Help me

have a bugs. 1 - > dont play other round after 1º rond. 2 -> if end round an you with flag have error .

Buump i need to but where?

make others players enter room after battle . for enter in evente you have party. afeter round off no call other for room.

i need t omake other players registred can into in event! i use AnnieRuru System. prontera,156,185,5 script Party vs Party 100,{ if (getpartymembercount(getcharid(1)) != 1 && getpartycount(getcharid(1)) != 1){ mes " You need have 3 players un party!"; close;} if (getpartyleader(getcharid(1),2) != getcharid(0)) {mes "Only Leader Party can Registre!"; close;} mes "You Wanna Sign Up"; if ( select( "yes", "no" ) == 2 ) close; else if ( .signup_count == 128 ) { mes "Sorry the whole queue is full"; close; } while ( .signup_aid[.@i] != getcharid(3) && .@i < .signup_count ) set .@i, .@i +1; if ( .@i < .signup_count ) { mes "you have already sign up in this event"; mes "You have ^FF0000"+(.signup_count-1)+"^000000 Peoples in your front."; close; } set .signup_aid[ .signup_count ], getcharid(3); set .signup_count, .signup_count +1; mes "You are now signed to the BG event"; dispbottom "You have "+(.signup_count-1)+" Peoples in your front !"; close2; L_start: if ( .signup_count < .min2start ) end; for ( set .@i, 0; .@i < .signup_count; set .@i, .@i +1 ) { if ( attachrid( .signup_aid[.@i] ) ) { if ( getmapflag( strcharinfo(3), mf_nowarp ) ) { // player has went into another event deletearray .signup_aid[.@i], 1; set .signup_count, .signup_count -1; set .@i, .@i -1; } } else { deletearray .signup_aid[.@i], 1; set .signup_count, .signup_count -1; set .@i, .@i -1; } } if ( .start || .signup_count < .min2start ) end; announce "event started", 0; set .start, 1; for ( set .@i, 0; .@i < .signup_count; set .@i, .@i +1 ) setbgid ( .@i %2 )? .red : .blue, .signup_aid[.@i]; deletearray .signup_aid, .min2start; set .signup_count, .signup_count - .min2start; bg_warp .red, "guild_vs3", 13,50; bg_warp .blue, "guild_vs3", 86,50; cleararray .score[1], .startingscore, 2; bg_updatescore "guild_vs3", .score[1], .score[2]; sleep .eventlasting * 1000; if ( .start == 1 ) { if ( .score[1] == .score[2] ) mapannounce "guild_vs3", "Draw !", 0; else if ( .score[1] > .score[2] ) { mapannounce "guild_vs3", " Red side wins !", 0; callsub L_reward, .red; } else if ( .score[1] < .score[2] ) { mapannounce "guild_vs3", " Blue side wins !", 0; callsub L_reward, .blue; } } bg_warp .red, "prontera", 155,182; bg_warp .blue, "prontera", 158,182; bg_kickall .red; bg_kickall .blue; set .start, 0; deletearray .score; enablenpc "Partytwo"; enablenpc "Partyone"; goto L_start; L_reward: getbgusers getarg(0); for ( set .@i, 0; .@i < $@arenamembersnum; set .@i, .@i +1 ) // getitem 501, 1, $@arenamembers[.@i]; // item reward return; OnredDead: callsub L_dead, 1; OnblueDead: callsub L_dead, 2; L_dead: //warp "guild_vs3", 13,50; set .score[ getarg(0) ], .score[ getarg(0) ] -1; bg_updatescore "guild_vs3", .score[1], .score[2]; if ( !.score[ getarg(0) ] ) awake strnpcinfo(0); sleep2 1250; percentheal 100,100; end; OnredQuit: callsub L_quit, 1, .red; OnblueQuit: callsub L_quit, 2, .blue; L_quit: if ( bg_get_data( getarg(1), 0 ) ) end; set .score[ getarg(0) ], 0; awake strnpcinfo(0); end; OnInit: set .eventlasting, 30 * 60; // how long would the event last or it auto-reset. 30 *60 = 30 mins set .min2start, 2; // minimum player to start set .startingscore, 4; // score at start set .red, createbgid( "guild_vs3", 13,50, strnpcinfo(0)+"::OnredQuit", strnpcinfo(0)+"::OnredDead" ); set .blue, createbgid( "guild_vs3", 86,50, strnpcinfo(0)+"::OnblueQuit", strnpcinfo(0)+"::OnblueDead" ); set $psvp_map$,"guild_vs3"; set $pvsp_grupo1,0; set $pvsp_grupo2,0; set $pvsp_kill1,0; set $pvsp_kill2,0; enablenpc "Partytwo"; enablenpc "Partyone"; end; OnPCKillEvent: if(strcharinfo(3) == $psvp_map$) { if(getcharid(1) == $pvsp_grupo1) { set $pvsp_kill1,$pvsp_kill1+1; mapannounce $psvp_map$,"O grupo ["+getpartyname($pvsp_grupo1)+"] matou "+$pvsp_kill1+"/3 players do grupo ["+getpartyname($pvsp_grupo2)+"]!",bc_all; } if(getcharid(1) == $pvsp_grupo2) { set $pvsp_kill2,$pvsp_kill2+1; mapannounce $psvp_map$,"O grupo ["+getpartyname($pvsp_grupo2)+"] matou "+$pvsp_kill2+"/3 players do grupo ["+getpartyname($pvsp_grupo1)+"]!",bc_all; } if($pvsp_kill1 == 1) { announce "[Party vs Party] O grupo vencendor foi o ["+getpartyname($pvsp_grupo1)+"] !",bc_all; sleep2 2000; mapwarp $psvp_map$,"lhz_cube.gat",66,192; } if($pvsp_kill2 == 1) { announce "[Party vs Party] O grupo vencendor foi o ["+getpartyname($pvsp_grupo2)+"] !",bc_all; sleep2 2000; mapwarp $psvp_map$,"lhz_cube.gat",66,192; } set $pvsp_grupo1,0; set $pvsp_grupo2,0; set $pvsp_kill1,0; set $pvsp_kill2,0; end; } } guild_vs3,13,50,0 script Partyone 139,5,5,{ warpparty "guild_vs3",13,50,getcharid(1); if($pvsp_grupo1 == 0) set $pvsp_grupo1,getcharid(1); disablenpc "Partyone"; end; } guild_vs3,86,50,0 script Partytwo 139,5,5,{ warpparty "guild_vs3",86,50,getcharid(1); if($pvsp_grupo2 == 0) set $pvsp_grupo2,getcharid(1); disablenpc "Partytwo"; end; } //guild_vs3 mapflag battleground 2 guild_vs3 mapflag nosave SavePoint guild_vs3 mapflag nowarp guild_vs3 mapflag nowarpto guild_vs3 mapflag noteleport guild_vs3 mapflag nomemo guild_vs3 mapflag nopenalty guild_vs3 mapflag nobranch guild_vs3 mapflag noicewall

I can use this Queue for party vs party?

Good! very Good !

For clone pet you need add cod in src!