Nero

Example I want to get item to one npc and it will require 1 hr again to get or talk to him. (Timer will count even you log out) Thanks!!

Hello how can i properly remove a costume equipment via sql? example i want to properly remove the costume archangel wing ( 20500) Ive used : DELETE FROM `inventory ` WHERE nameid='20500' AND equip='8192; But when i login i can see that the archangel wing(20500) is gone in the equip but the sprite view is still there. Is there anyway to remove also the sprite view upon deleting the item in sql? or is there any scripts that can be done via onlogin to automatically check and remove the player's costume garment sprite view before entering the game? Thanks in advance!

Example: during woe. I would like to record all the break announcement that can be seen on an npc. Npc will show: [NPCname] Kriemhild castle has been conquered by playername1 of the guildname1. close;

I have this problem in players name not showing on item Situation: (MAP: ALBERTA) if Player 1 use @produce bow and Vend it, Play 2 will only see nameless bow If player 2 bought the bow and warp to other place (EXAMPLE : PRONTERA) he will now see the name of the bow.

up please help Nid help everyone

Im having error in this one [Error]: script error in file 'npc/rage/koe.txt' line 158 column 39 parse_callfunc: expected ')' to close argument list 155: if ( isloggedin( $@guildmemberaid[.@i],$@guildmembercid[.@i] ) ) { 156: if ( $@guildmemberaid[.@i] == .@master_id ) { 157: while ( .@x < .@item_master_size ) { * 158: if(!checkvending(strcharinfo(0,$@guildmembercid[.@i]))) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^ 159: getitem .@item_master[.@x],.@item_master[.@x+1],$@guildmemberaid[.@i]; 160: .@x += 2; 161: } if(!checkvending(strcharinfo(0,$@guildmembercid

- script guild_vs1s2 -1,{ OnAgitEnd: callsub( L_reward,0, "guild_vs1" ); end; OnAgitEnd2: callsub( L_reward,1, "guild_vs1" ); end; L_reward: .@type = getarg( 0,0 ); .@map$ = getarg( 1,"" ); if ( .@type == 0) { // woe fe setarray .@item_master, 30206,2; setarray .@item_member, 30206,1; } else { // woe se setarray .@item_master, 30206,2; setarray .@item_member, 30206,1; } .@item_master_size = getarraysize( .@item_master ) - 1; .@item_member_size = getarraysize( .@item_member ) - 1; if ( .@map$ != "" ) { .@gid = getcastledata( .@map$,1 ); if ( .@gid > 0 ) { getguildmember .@gid,1; getguildmember .@gid,2; .@master_id = getcharid( 3, getguildmaster( .@gid ) ); while ( .@i < $@guildmembercount ) { .@x = 0; if ( isloggedin( $@guildmemberaid[.@i],$@guildmembercid[.@i] ) ) { if ( $@guildmemberaid[.@i] == .@master_id ) { while ( .@x < .@item_master_size ) { getitem .@item_master[.@x],.@item_master[.@x+1],$@guildmemberaid[.@i]; .@x += 2; } } else { while ( .@x < .@item_member_size ) { if ( CheckVending() ){ end; } getitem .@item_member[.@x],.@item_member[.@x+1],$@guildmemberaid[.@i]; .@x += 2; } } } .@i++; } } } return; } Still not getting anything.

Hmm i got some problem. No error on script but members doesnt receive the reward. even if the player is not in vend/autotrade

Wow thanks!!! Fast answer!

How can i restrict them from getting reward in this script: - script guild_vs1s2 -1,{ OnAgitEnd: callsub( L_reward,0, "guild_vs1" ); end; OnAgitEnd2: callsub( L_reward,1, "guild_vs1" ); end; L_reward: .@type = getarg( 0,0 ); .@map$ = getarg( 1,"" ); if ( .@type == 0) { // woe fe setarray .@item_master, 30206,2; setarray .@item_member, 30206,1; } else { // woe se setarray .@item_master, 30206,2; setarray .@item_member, 30206,1; } .@item_master_size = getarraysize( .@item_master ) - 1; .@item_member_size = getarraysize( .@item_member ) - 1; if ( .@map$ != "" ) { .@gid = getcastledata( .@map$,1 ); if ( .@gid > 0 ) { getguildmember .@gid,1; getguildmember .@gid,2; .@master_id = getcharid( 3, getguildmaster( .@gid ) ); while ( .@i < $@guildmembercount ) { .@x = 0; if ( isloggedin( $@guildmemberaid[.@i],$@guildmembercid[.@i] ) ) { if ( $@guildmemberaid[.@i] == .@master_id ) { while ( .@x < .@item_master_size ) { getitem .@item_master[.@x],.@item_master[.@x+1],$@guildmemberaid[.@i]; .@x += 2; } } else { while ( .@x < .@item_member_size ) { getitem .@item_member[.@x],.@item_member[.@x+1],$@guildmemberaid[.@i]; .@x += 2; } } } .@i++; } } } return; } Where to put this one if( ( checkvending() == 2 && !.autotrade ) ?

Thanks for your answer. But i really need to know what is the problem. Yes upgrading or changing the client itself will probably fix the problem thats why I stated all the possible error i found.

any support for this one?

Hello I dont know if you are aware of this problem. Situation: Rudra bow = no arrow animation. Class num = 77 upon checking only on weapontable.lub class num 73 to 76 will show the arrow animation from any bow sprites. so reverting WEAPONTYPE_Hunter_Bow = 76, WEAPONTYPE_Bow_Of_Rudra = 77, [Weapon_IDs.WEAPONTYPE_Hunter_Bow] = "_1718", changed to 1720 [Weapon_IDs.WEAPONTYPE_Bow_Of_Rudra] = "_1720", then using class num 76 to rudra bow- Will now show the arrow animation/attack therefore sprite of rudra bow is not the reason. probably client is only accepting bow animation between WEAPONTYPE_CrossBow = 73, WEAPONTYPE_Arbalest = 74, WEAPONTYPE_Kakkung = 75, WEAPONTYPE_Hunter_Bow = 76, any one here can tell me how may i fix the problem? Thank you in advance.

Thanks to all of you! Thumbs up!!

Hello everyone i would like to request this one. If map is in pvp = every warp there will be a self announce info. Example at pay_fild08 is in pvp on. if you teleport on that area, you will see a broadcast to self with the "The map is currently in PVP mode so be ready!"; Thank you everyone and Godbless!