Patskie

By default, EDP doesn't affect soul destroyer | soul breaker. If you want then you have to edit your source On your src/map/battle.c. Find : case ASC_BREAKER: skillratio += 100*skill_lv-100; Then add a check if a character uses EDP : if(sc && sc->data[SC_EDP]) skillratio *= 2; Will add 100% damage on soul breaker when he or she uses EDP. Didn't test though

If you want SQL version then try the post above, if you want it via script then something like this : Hp = Hp + 500; // Add 500 hit points on current amount of hit points.MaxHp = MaxHP + 500; // Add 500 hit points on maximum available amount of hit points. Hp - Current amount of hit points.MaxHP - Maximum amount of hit points.

Mithril Coin Trader prontera,150,150,0 script Sample 100,{ mes .NPC$; mes "Hello " +strcharinfo(0)+ " what can i do for you?"; next; if (select("Trade my " +getitemname(.coin)+ " to zeny:Nothing" ) - 1) close; if (!countitem(.coin)) close; mes .NPC$; mes "How many " +getitemname(.coin)+ " would you like to exchange?"; next; input @amount; if (@amount == 0 || countitem(.coin) < @amount) { mes .NPC$; mes "Invalid amount"; close; } mes .NPC$; mes "So you want to exchange " +@amount+ " " +getitemname(.coin)+ "?"; next; if (select("Yes:No") - 1) close; mes .NPC$; mes "Here you go!"; delitem .coin, @amount; Zeny = Zeny + ( .rate * @amount ); close; OnInit: .NPC$ = strnpcinfo(1); .coin = 674; // 674 = Mithril Coin .rate = 5000; // 1 (.coin) = 5000 zeny end;}

Thanks guys!

http://pastebin.com/raw.php?i=sav691vy try

Add this code : mes "Your password is " +#finalpassword$;

Depende sa gusto mo. Skill formula mga ganon

It's orayt.

Exactly! Some scripts might have been limited to 128 because of array limit. But with these suggestion it will read all the data until the very end

Being on others point of view .next() command is more readable than a for loop statement. I know there is an existing script for dealing over all the data which is for loop. But there is a saying that the more simpler and easier the code is, the better, as long as they provide the accurate result. Another thing i want to consider in this suggestion, Can anyone (developer) here create a script command wherein it will get the item script of an item and put it in npc script? This suggestion is like this post on rAthena. Well correct me if this command is already existing. Thanks

But for a newbie scripter. It will be more easy to learn and remember this suggestion. But like you've said. Either will do a loop

Hello i just want to request if this is possible. Why not implement a script command wherein it will get all results from a query_sql command. For example if a script do a query_command like the following : query_sql "SELECT `name` FROM `char` WHERE `online` = '1'", .@name$; From the query given above i must implement a for loop statement to go over with all the data. for( set .@a,0; .@a < getarraysize(.@name$); set .@a,.@a + 1) mes "- " +.@name$[.@a]; My suggestions is this : 1. Implement a script command like ResultSet in java or DataReader on C#? so if this will happen. It would look like these when i use the query given above : ( i would give ResultSet as an example ) ResultSet rs = query.getResultSet(); //Get the result from the query_sql commandwhile (rs.next()) { set .@names$ = rs.getString("name"); mes "Online Users : " +.@names$;} } Or it may be : ResultSet rs = query_sql("SELECT `name` FROM `char` WHERE `online` = '1'") // Direct Querywhile (rs.next()) { set .@names$ = rs.getString("name"); mes "Online Users : " +.@names$;} } While the statement has next line get those and when they are in the name column then print them. Well for me it will be quite easy to make scripts Anyway this is just a suggestion.

Great work!

/me joins the trend, in c.int main(int argc, char **argv) { const char* peepz[17] = { "Jezu","dastgirpojee","JayPee","nanakiwurtz","hemagx","malufett","pr3p","nndsl","Zopokx","Vali","Virtue","M45T3R","Michieru","Judas","Beret","Yommy","Jman" }; int i; for(i = 0; i < 17; i++) { if( i != 16 ) printf("%s & ",peepz[i]); else printf("%s , ",peepz[i]); } printf("I'm Ind"); return 0;} /me does java version public class Hello{ public static void main(String[] args){ int i; String[] names = {"Jezu","dastgirpojee","JayPee","nanakiwurtz","hemagx","malufett","pr3p","nndsl","Zopokx","Vali","Virtue","M45T3R","Michieru","Judas","Beret","Yommy","Jman","Ind"}; System.out.print("Hi"); for(i = 0; i < names.length; i++){ System.out.print(" "+names[i]); if(i != (names.length-1)) System.out.print(" &"); if(i == (names.length-1)) System.out.print(".n"); } System.out.print("I'm Streusel."); }} C# version : static void Main(string[] args) { string[] names = {"Yommy","Beret", "Judas", "hemagx", "Michieru", "M45T3R", "Virtue", "Vali", "Zopokx", "nndsl", "pr3p", "malufett", "hemagx", "nanakiwurtz", "JayPee", "dastgirpojee", "Jezu", "Jman", "Ind", "Nameless2you", "Squishyyy", "kyeme", "Frost", "MStream", "latheesan", "clydelion"}; string name = "Patskie"; for (int i = 0; i < names.Length; i++) { Console.WriteLine("Hello {0}, i am {1}", names[i], name); } Console.ReadLine(); }

No need for more colors as long as the color blending of the background as well as the fonts is good. Great work!

Like this suggestion also

Like this http://pastebin.com/ms27PgNN ? Patch this first OnPCStatCalcEvent.patch I never tried to modify my stat attributes perhaps this is my best shot. Anyone who has better script is appreciated.

199+9 You mean your npc will add stats on the 9?

It's nice if you would provide your OWN guide, probably this thread won't UPDATE anymore. I will

Any update on this? Hercules emulator are already in public and one thing, i suggest you make a guide regarding the MySQL Workbench framework not this one. Because it is more updated compare to those sql tools and for me it is more convenient and easy.

Just naruto :|

Description : A simple castle drop exchanger npc to provide trading system from one castle drop to another. This is useful esp. for those server wherein some castle drops are not that useful or are not used for some quest like break the seal and so on. Suggestions and bug reports are appreciated. Credits also to Annieruru. How to use : Must have items specified on the script to exchange also on the items specified on the script. setarray .itemid, 7074, 7075, 7076, 7077, 7088, 7089, 7090; Configuration : NPC Name (Default: NPC Name) : set $npc$,"^FF0000" +strnpcinfo(1)+ "^000000"; Zeny to use the service : .req_zeny = 10000; Items needed to be traded and items to be traded : setarray .itemid, 7074, 7075, 7076, 7077, 7088, 7089, 7090; Changelog : cdexchanger.txt

Thanks!

This script enhances player capabilities by depositing, withdrawing and inquiring their balance anytime, anywhere! How to use : Just use @atm in-game. How to install : • Import the bank.sql on your database REMOVED ON VERSION 2.0 • Go to conf/script.conf • Find input_max_value: 10000000 and change it to 2147483647 • Go to src/common/mmo.h • Find #define MAX_ZENY 1000000000 and change it to 2000000000 • Recompile your server and re-start it • Put atm.txt on your npc folder • Reload the script by using @reloadscript or @loadscript and enjoy! Script features : • Register your account on the bank REMOVED ON VERSION 2.0 • Automatically register your account to the bank system ADDED ON VERSION 2.0 • Interest triggers every 00:00 each day ADDED ON VERSION 2.0 THANKS TO ANGELMELODY FOR THE SUGGESTION! • Limited times of reminder on your account number during login ADDED ON VERSION 2.0 • The bank can hold up to 9,223,372,036,854,775,807 zeny from it's original 2,147,483,647 zeny ADDED ON VERSION 2.0 • Deposit zeny to the bank • Withdraw zeny from the bank • Inquire your account balance Script restriction : • You should put your account number first before doing transactions. By default your account number is your account id ADDED ON VERSION 2.0 • Restrict 0 zeny deposit and withdraw • Restrict depositing amount which is larger than the current holding zeny • Restrict the user to withdraw amount which is larger than the balance of the account • Restrict the user to withdraw which will probably result of holding 2,000,000,000 zeny or more Changelog : atm.txt http://pastebin.com/raw.php?i=2YW0wPPp

Simple and useful SQL based script intended to boost players capabilities to manage their own account in-game. Feel free to use and do not remove credits. Report bug and glitches immediately if any occur. Suggestions and criticism are welcome since it is part of learning. How to use : Just use @account in-game. Script Features : • My Account = Information of the current invoking account. • Change Mail = Change the e-mail of the current invoking account. • Change Gender = Change the gender of the current invoking account. By default you can use this once a day. To configure : set #timer,gettimetick(2) + 86400; // 86400 seconds = 1 day • Users Online = Show the list of user's online with their corresponding job.• Set Password = Set a password for the current account to enhance security. Once set, it will be asked every time you do logging in. • Delete Password = Delete the password for the current account. • View Character = View all characters in an account • Reset Position = Reset the position of the character in an account. • Reset Style = Reset the current style to default style of the character. • Reset Equipment = Reset the equipment of the character in an account. Changelog : 1.0 - Initial Release accountsystem.txt