Limestone

Hi! i always got DB Error - Data truncated for column `balance` at row 1 i dont know what to do, here's my script mes "You have a total of "+#VOTEPOINTS+" Vote Points."; mes "Would you like to convert it to credits?"; mes "^ff0000Note:^000000 1 Vote Points = 1 Credits."; next; switch(select("Let me think first.:Yes, let's continue.")){ case 1: mes .npcName$; mes "Come back if you already want to talk to me."; close; case 2: if(#VOTEPOINTS < 1){ mes .npcName$; mes "You don't have enough Vote Points to convert."; close; } else { mes .npcName$; mes "Put your desired amount to be converted."; } input @vote,0,#VOTEPOINTS; if( @vote < #VOTEPOINTS ){ next; mes .npcName$; mes "Not enough Vote Points."; close; } else { next; mes .npcName$; mes "Thank you! and come again."; query_sql "UPDATE `cp_credits` SET `balance` = `balance` + @vote WHERE `account_id` = "+ getcharid(3) +" AND `balance` <> 0;"; set #VOTEPOINTS,#VOTEPOINTS-@vote; close; } }

in where? src folder? please elaborate. thanks! what i mean is the effect of the AC_DOUBLE, when in sniper and hunter job, the effect will be 3 hits instead of 2 hits, and the other jobs that has a AC_DOUBLE skill will remain the same effect. bump?

thank you euphy!

hi guys! how can i make selling items to npc will show how much zeny i gain? i want it to all npc, not only one. advance thank you for those who can help me.

how can i make triple strafe only works in hunter and sniper? in other jobs like, rogue, bard, dancer, and archer it will not work. thanks!

Hi! can i ask how to disabled skill delays in some skills like, HEAL, Potion pitcher and etc. i already edit my renewal.h to this http://pastebin.com/raw.php?i=TvYzGwps'>http://pastebin.com/raw.php?i=TvYzGwps i try to edit AL_HEAL in skill_cast_db.txt from: //-- AL_HEAL 28,0,1000,0,0,0,0 to: //-- AL_HEAL 28,0,0,0,0,0,0 But still i have fixed delay in heal.

emistry i try your script and convert to this, but it shows not exact amount of my #BANKNOTES "+@deposit+#BANKNOTES+" thanks, i already fixed my problem! Emistry i have 1 problem again, how can i set this script. if i put 100000z = 1 bank note case 2: mes "[ ^ffa500Bank Exchange^000000 ]"; mes "Very well, what type of exchange"; mes "would you like to do?"; next; switch(select("^ff0000Zeny^000000 -> ^fdd017Bank Note^000000:^fdd017Bank Note^000000 -> ^ff0000Zeny^000000:Nevermind.")){ case 1: mes "[ ^ffa500Bank Exchange^000000 ]"; mes "How much zeny do you want to"; mes "transfer into ^fdd017Bank Notes^000000?"; mes "Please note, that each ^fdd017Bank"; mes "Note^000000 is equivalent to ^ff0000100000^000000z."; next; input @zeny,0,Zeny; if(Zeny < 99999){ mes "[ ^ffa500Bank Exchange^000000 ]"; mes "I'm sorry, but you don't have"; mes "enought zeny for the transaction."; mes "Please input a valid amount."; close; } else if(@Zeny < 99999){ mes "[ ^ffa500Bank Exchange^000000 ]"; mes "Please input an amount greater"; mes "than 99,999."; close; } else { mes "[ ^ffa500Bank Exchange^000000 ]"; mes "Are you sure you want to"; mes "exchange ^ff0000"+@zeny+"^000000 z for ^ff0000"+@bank_note+"^000000 ^fdd017Bank Note^000000?"; } next; switch(select("Yep, go ahead.:No, I changed my mind.")){ case 1: mes "[ ^ffa500Bank Exchange^000000 ]"; mes "Okay then, would you like ^ff0000"+@zeny+"^000000 ^fdd017Bank Note^000000 "; mes "to be placed in your inventory or your account?"; next; switch(select("Inventory - ^ffa500"+countitem(8051)+"^000000 + ^ffa500"+@bank_note+"^000000 ^fdd017Bank Notes^000000:Account - ^ffa500"+(#BANKNOTES)+"^000000 + ^ffa500"+@bank_note+"^000000 ^fdd017Bank Notes^000000:Nevermind")){ case 1: mes "[ ^ffa500Bank Exchange^000000 ]"; mes "..."; next; set @exchange, @zeny / 100000; set Zeny,Zeny-(100000*@exchange); getitem 8051,@exchange; mes "[ ^ffa500Bank Exchange^000000 ]"; mes "Exchange Complete."; close; case 2: mes "[ ^ffa500Bank Exchange^000000 ]"; mes "..."; next; mes "[ ^ffa500Bank Exchange^000000 ]"; mes "Exchange Complete."; mes "Your total account balance is now ^ff0000"+#BANKNOTES+"^000000 ^fdd017Bank Notes^000000."; close; case 3: mes "[ ^ffa500Bank Exchange^000000 ]"; mes "Come back soon."; close; } case 2: mes "[ ^ffa500Bank Exchange^000000 ]"; mes "Come back soon."; close; }

mes "[ ^ffa500Bank Exchange^000000 ]"; mes "Very well, how much ^ffffBank Notes^000000"; mes "would you like to deposit?"; mes "Please note, that each ^fdd017Bank"; mes "Note^000000 is equivalent to ^ff0000100000^000000z."; next; input @deposit,0,countitem(8051); if(@deposit < 1) goto DepoB; mes "[ ^ffa500Bank Exchange^000000 ]"; mes "You currently have ^ff0000"+countitem(8051)+"^000000 ^fdd017Bank Note^000000"; mes "in your account."; mes "By finishing this transaction,"; mes "you will gain: mes "^ff0000"+@deposit+"^000000 ^fdd017Bank Note^000000"; mes "and have a total of:"; < ------ this part is what i'm missing -------- >

yes, it a variable. i tried already what you have written in your post, but it stills show how much bank notes before the transaction.

Hi! i'm making now a bank script but i dont know how to do this if i add a bank note in my account it shows a total of how many bank notes i have after the transaction for example i have 1 bank note already in my account if i add 1 bank note again it will show how many bank notes in my account after the transaction thanks!

i think its Training Edition, not Third Edition

how about the RE MATK? did you guys already started that? btw nice update!

How can i increase showevent scripts? because if i try 6-7 showevents, i see tons of dots in my minimap. but if i use 5 or lower. it working properly

Bump!

How did you solved it?

http://pastebin.com/tNdu6VgU how can i make this script like this. when i click the npc 1 then finish the quest, the showevent will automatically pop up in npc 2.

oh my i thought you have same problem with kim.

How to fix this sir Rage? Try this http://pastebin.com/hyh163jt

Thanks capuche, Woriking great!

my goodness. can someone help me!!!

the problem is in your msgstringtable.

can i request a custom mob drop via script that all of normal monsters (excepts Low level monster lvl 50 below) has a 2.5% chance of dropping a (red potion) and 5% chance on all mvp bosses and mini bosses. thanks!

did you try it in a clean rathena svn?

can i request to edit this src (from hercules) http://pastebin.com/qncjwLtY to make it compatible in rathena, i already applied it on my server ( no compile errors ) but when i try to click the npc, it always says This is a Item Shop. You need %s (%d) to Buy items. and then it does not open the shop but if i dont have the required item to buy from the shop, it opens the shop. thanks!

you must need to post in the harmony forums, to change their code to fit the latest rathena svn.