Leaderboard

All headgear official bRO, cRO, euRO, fRO, idRO, iRO, jRO mysgRO, twRO, tRO Update November 2022 Headgear November 2022.7z Iclude list and miss headgear

E - Script Collection Last Update : September 10, 2013 Refine Function SQL Mission Board Monster Marching Vendor Control Advanced Stylist Coin Exchanger Doppelganger Race Of The Day Limited Items Multi Currency Shop Random News GM Online List Link Broken E-Inquiry DotA Runes Flower Counting Game Class Restriction Chain Quest Build Manager Misc Scripts : Freebies Script Card Trader Gold Room [ Pick Gold ] Gold Room [ Guild Tax ] Map Restriction [ GM Based ] Daily Reward Monthly Reward Monster Spawner Monster Summoner with Last Summoned Display Players Stats & Equipments 3rd Job Item Giver Exchanger [ Cashpoint to Coins ] Exchanger [ Poring Coin - Zeny ] Exchanger [ Points to Tickets ] Exchanger [ Item to Item ] Exchanger [ Item to Item ] Exchanger [ Multi Item to 1 Item ] Party Match Auto Ban Over Stats Users Soul Link Buff Kill Players gain Cash Points Party Members All Get Items [ Snippet ] Message Board Stalker Class Skill Reproduce NPC Multiple Selection Quest [ Template ] In-Game Item Rewarder In-Game Points Rewarder Invasion Event Custom Item Rate Status Point Seller [ Snippet ] Anti Bot Security Script Anti Bot Script [ Code / Question ] Item Combo Restriction [ LHZ Card ] Drop Item Upon Death PVP Switcher + Announcer [ Guild Master ] Rotating Waitingroom Messages +10 Refiner [ Specific Items ] Random Rate Item Exchanger MVP Invasion Premium Users [ Boost Rates ] Display Cutin Image upon Login Custom Randomed Box Items Kick GM during WOE Custom Crafting NPC Restrict Same IP [ Certain Map ] Coloured Items Exchanger Guild Master Changer Party Team PK Match Gambling Game IRC Channel Crafting NPC Guild Storage Restriction Stage Game [ Version 4 ] Monster Wiki Event [ Version 3 ] Special Thank you for my Tutor : Notes : I am a bit lazy to write all those Script Descriptions, i do believe that all of you able to get how this script works. Anyway, i will still doing my best to write the Updated Changelog or informations about the script as detail as possible. All the Scripts above are uploaded to Pastebin . Abide the Following Rule : Scripts Error / Not Working , you have to Explain it in Details. ( Add in Images / Modified Scripts ) Do not SPAM / BUMP in my Topic. Do not ask for Support stuffs for other Scripts in this Topic. Link Down , then drop [ @Emistry ] a message. I Reserved the Right for NOT Answering your Posts if you did not abide my Topic's Rules. Keep This In Your Mind : All the Scripts i distribute here are NOT FOR COMMERCIAL USES . DO NOT remove my Credits if you are using part of the scripts to modify your own. DO NOT re-release the scripts in any form / way. If you ♥ these Scripts , Click on to Vote this Topic up. Or you may also click on at above the Topic

File Name: Account Bound Items File Submitter: Xantara File Submitted: 16 Sep 2012 File Category: Source Modifications Content Author: Xantara, Zephyrus, RO Information This system would allow (non-stackable, non-pet-egg) items to be bounded onto a player's account. This means that the bounded items cannot be traded, dropped, auctioned, nor mailed. But, they can be storaged so that it can be shared among the characters of that account. Features: - Item coloration to distinguish bounded items and non-bounded ones (see screenshot) - Script commands (getitembound, getitembound2, equipisbounded) to create and check for bounded items - At commands (@itembound, @itembound2) to create bounded items - New group permission (can_trade_bounded) to allow the group to distribute these bounded items if enabled (mostly just for High GMs / Admins) - Changes to the SQL files to track bounded items. This would effect cart, inventory, and storage databases. Tested on rAthena revision 17294 (using v1.5.1). Script Command Documentations At Commands Documentations Known Issues - When moving a bounded item to storage, item colouration is gone. However, re-opening the storage or re-logging will fix this issue.1 - When moving a bounded item to the cart inventory, item colouration is gone. However, re-logging will fix this issue.1 1 If you are able to find these packets (ie. PACKET_ZC_ADD_ITEM_TO_STORE3 and/or PACKET_ZC_ADD_ITEM_TO_CART3), please let me know! Credits Created by @Xantara Popularized by Zephyrus Idea by Ragnarok Online License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License. Like my work? Rate/vote this download Rep up my support topic post Do not mirror without my consent. Click here to download this file

Hi All, I know some of you knows me. I am jingcleovil from somewhere else. I just develop the flux CMS originally. and some other flux addons. Anyways, I have develop a cool and social network based Ragnarok Control that has the following features. 1. Has facebook like wall. 2. AJAX based page browsing (like github). 2. Search Item 3. Manage Account. 4. Delete Character. 5. Ladder Based 6. Ticket Support 7. Notifications if someone send you message. and will add more feature.... ITS NOT DONE YET. I am still developing for a couple of weeks. Here is the demo page. http://www.ragnagears.com/ username: demo password: demo

As in one of the latest revisions a TXT file for the level penalties was added and this is basically a renewal functionality as also mentioned inside this file, I would suggest to move it into /db/re/. I know that this feature could also be a benefit for non renewal servers, but the internal organization should be clearly structured. Thanks for your attention.

Unless you post the voting system, no.

it is fine in how the categorization works right, even if they remake it, you will still need to click the category to find paid or free

@ winz actually it's 2 IPs simultaneously changing. i don't know if that's sarcastic or not. but when i actually refresh my no-ip DUC program. it always changes the IP address. making the server can't reach off the pacing of the ip. by the way, i surf the net about the pros and cons of IP addresses. it seems that dynamic addresses aren't capable of hosting a server efficiently. il better get static IP address from my provider (BayanTel), it has an additional PHP250.00/month though. for @pandaplaygames' information

You mean people can't see it? If you said people are LAZY to find it, which is like saying people won't even click Free/Paid eventho there is 2 Category. (Same thing, needs 2 click to categorized)

150,150,1 script ABC 53,{ input .ABC$; dispbottom "Activated."; donpcevent "DEF::OnEnable"; end; } 152,152,1 script DEF 53;{ getvariableofnpc(.ABC$,"ABC"); mes .ABC$; mes "From ABC."; close; OnEnable: hideoffnpc; end; OnInit: hideonnpc; end; } Something like this?

IPD default have the fliter function.

wtf ... goddameit can sometimes think outside the box when solving a problem .... thx for the idea here is the tested sql script update `char`, ( select char_id, sum(lv) as xyz from skill group by char_id ) as abc set skill_point = skill_point + xyz where `char`.char_id = abc.char_id; delete from skill; run this when server is off EDIT: wait, this is for all characters ... wait I think of some way for gunslinger only update `char`, ( select char_id, sum(lv) as xyz from skill group by char_id ) as abc set skill_point = skill_point + xyz where `char`.char_id = abc.char_id and class >= 4054 and base_level >= 150 and job_level >= 50; delete from skill; like this EDIT2 ... erm ... I think the class is abit ... off wait I recheck the job ID yeah Emistry is wrong, goddameit correct update `char`, ( select char_id, sum(lv) as xyz from skill group by char_id ) as abc set skill_point = skill_point + xyz where `char`.char_id = abc.char_id and ( class = 4211 or class = 4212 or ( class >= 4054 and class <= 4079 ) ) and base_level >= 150 and job_level >= 50; delete from skill; like this I think this is final LMAO ... delete from skill will wipe the database ... >.< wait .... urgh ... I really post too fast ... update `char`, ( select char_id, sum(lv) as xyz from skill group by char_id ) as abc set skill_point = skill_point + xyz where `char`.char_id = abc.char_id and ( class = 4211 or class = 4212 or ( class >= 4054 and class <= 4079 ) ) and base_level >= 150 and job_level >= 50; delete from skill where skill.char_id in ( select char_id from `char` where ( class = 4211 or class = 4212 or ( class >= 4054 and class <= 4079 ) ) and base_level >= 150 and job_level >= 50 ); bleh .... finally ... I hope no more of such things <.< final EDIT: this method is not correct either - like marriage skill shouldn't be edit and if a user riding, should unmount them ... etc

yeah me and goddameit has alot experienced in writing instanced scripts I thought as long as the instance 1st 2 characters is <a number> and '@' this symbol, then it will work however, 1@tnm1 ~ 1@tnm3 is official KRO maps ? or is that just some of your custom map ? this is official rathena endless tower script used for( set .@i, 1; .@i <= 6; set .@i, .@i + 1 ) { if( instance_attachmap(.@i + "@tower", .@instance) == "" ) { mes "^0000ff"+.@md_name$+" ^000000- Reservation Failed!"; instance_destroy(.@instance); close; } since your map name changes on your last character, just do it like this for( set .@i, 1; .@i <= 3; set .@i, .@i + 1 ) { if( instance_attachmap( "1@tnm"+ .@i, .@instance) == "" ) { mes "^0000ff"+.@md_name$+" ^000000- Reservation Failed!"; instance_destroy(.@instance); close; }

now change @tnm1....remember that when create instance create a temporary maps... 001@blabla 002@blabla... now need create 001@tnm1 001@tnm2 001@tnm3 (same instance) (change @tnmx) if your map name is '@tnm1' then it can't it must be '(1~9)+@tnm1'. if is 1@tnm1, 1@tnm2, 1@tnm3 (same instance). means variable is 'm+(1~???)' then it can't it must be <instance id>+map name so which is you want?

announce "Sorry, only 1 character per IP is allowed on this map.", bc_blue|bc_self; sleep 1000; warp "SavePoint",0,0; [Error]: script_rid2sd: fatal error ! player not attached! lol... xD damn ... bumping old topics ! so cheating >.<

Here is a longer explanation of the original post: create a SourceForge account https://sourceforge....er/registration create a new project: https://sourceforge.net/p/add_project * make sure you check the SVN tool, to enable SVN install TortoiseSVN on your computer http://tortoisesvn.net/downloads.html checkout a working copy of the SVN of your new project. The SVN url will be something like: https://svn.code.sf.net/p/PROJECTNAME/code/ * make sure your URL has https so you have read+write access In your new working copy, create folders for your patcher stuff. For example: / /patcher/ /patcher/data/ SVN Commit your changes. Now you should be able to browse your SVN and see the folders you just created http://svn.code.sf.net/p/PROJECTNAME/code/patcher/ Configure your patcher (see Category:Patchers) Your "patcher website" URL is the SVN url: http://svn.code.sf.net/p/PROJECTNAME/code/patcher/ * http for anonymous read-only access Here's an example of some of the Thor_Patcher urls you would configure: RootURL='http://svn.code.sf.net/p/PROJECTNAME/code/patcher/' file_url=http://svn.code.sf.net/p/PROJECTNAME/code/patcher/data/ Now in your working copy, add the patcher website files. Thor patcher for example, would have: /patcher/main.ini /patcher/plist.txt /patcher/data/this_is_a_patch.thor set appropriate SVN Properties for each file type "patchlist" and other text files should have svn:eol-style=native "patch files" (ex: .grf .gpf, .rar .thor) and any other binary files should have svn:mime-type=application/octet-stream "html files" - should have svn:mime-type=text/html (if you forget this property, the html file will display as plain-text. example) images - should have their corresponding image type (for example .png should have svn:mime-type=image/png) [*]SVN Commit [*]Each time you have a new patch, add the patch to your working copy, then SVN Commit the changes.

@Rafael omg ! yeah you are right, using select inside select will return result faster only if the search key is not indexed xD if a search inside the where clause is indexed, run time is the same thx for reminding me though I still prefer to use this method since I don't need to check the field is indexed or not here it is prontera,157,178,5 script Sample 757,{ if ( getgmlevel() < 80 ) end; mes "Input Player Name"; if ( input( .@input$, 4, 23 ) ) { mes "invalid name length"; close; } if ( set( .@nb, query_sql( "select name, online from `char` where account_id = ( select account_id from `char` where name = '"+ escape_sql(.@input$) +"' ) order by char_num", .@name$, .@online ) ) ) for ( set .@i, 0; .@i < .@nb; set .@i, .@i +1 ) mes " > "+ .@name$[.@i] +" "+( ( .@online[.@i] )? "^00FF00[Online]" : "^FF0000[Offline]" )+"^000000"; else mes "No character found"; close; } also ... everyone eathena\rathena script engine sux big time the labels and variable names are NOT case sensitive in rathena script engine, unlike visual basic or C++ prontera,157,178,5 script Sample 757,{ set .@test_var, 123456; npctalk .@TEST_vAr +""; end; onnpckIlLeVenT: dispbottom "You just killed a mob ID "+ kIlLeDrid; end; } all above example works

that fix me! part, we can abuse SQL to calculate numbers above 2^31 select 123456789012345678901 > 123456789012345678900; return 1 also, consider the fact a negative sign is also count as 1 string 2147xxxxxx is 10 strings -2147xxxxxx is 11 strings EDIT: seems you already know this because you used >11 EDIT2: select 123456789012345678901 > 2147000000 OR 123456789012345678901 < -2147000000; select 123 > 2147000000 OR 123 < -2147000000;

Yeah, what I linked you to is the old alberta and izlude. Please run your mapcache and grf with the izlude map (.gat for mapcache and all 3 for your grf).

Clarification: Are you looking for Old Izlude as in the Map? If so: Old Izlude is in our forums. Check the downloads section. As for old Yuno? There was really an Old Yuno? o_O. Seesh.. I guess I'm not that old then D: Or: are you looking for Old NPC locations for the Old Izlude? If so, that'd be in pre-renewal section and not renewal.

.@nb == query_sql() //dual '=' needed for comparisons Annie are not comparing the value.... but assigning the value returned by the query_sql to the variable... input( .@input$, 4, 23 ) //The variable used in the sql command has no capital letter. capital or non-capital letter in variable work the same...

Card Trader released!

Latest Stable Client Latest Stable LUB Latest Stable Data Files/GRF Clean RO Folder PM Judas if you have any useful content to add, suggestions, or information to make this setup process much easier! Thanks!