Leaderboard

Autotrade Persistence & Live Vendor Data 27cbc7f brings two major vending features to rAthena. Live Vendor Data All vending data is now stored in SQL tables `vendings` and `vending_items`, making the data easily accessible to third party applications. This makes it possible to display and search through player shops on web pages or control panels without any server modifications. The vending data can also be accessed through scripts, which opens similar possibilities for players to search for shop items. [spoiler=Table Structures:] CREATE TABLE IF NOT EXISTS `vending_items` ( `vending_id` int(10) unsigned NOT NULL, `index` smallint(5) unsigned NOT NULL, `cartinventory_id` int(10) unsigned NOT NULL, `amount` smallint(5) unsigned NOT NULL, `price` int(10) unsigned NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS `vendings` ( `id` int(10) unsigned NOT NULL, `account_id` int(11) unsigned NOT NULL, `char_id` int(10) unsigned NOT NULL, `sex` enum('F','M') NOT NULL DEFAULT 'M', `map` varchar(20) NOT NULL, `x` smallint(5) unsigned NOT NULL, `y` smallint(5) unsigned NOT NULL, `title` varchar(80) NOT NULL, `autotrade` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Autotrade Persistence Vendors in auto-trade mode (@autotrade/@at) will now automatically be logged in after a server restart. In other words, it is no longer necessary for players to re-open their shops following each reboot or maintenance, made possible due to saving of vending data. This feature can be disabled in conf/battle/feature.conf. [spoiler=Options:] // Autotrade persistency (Note 1) // Should vendors that used @autotrade be restored after a restart? feature.autotrade: on // In which direction should respawned autotraders look? // Possible values are from 0-7 // Default: 4(South) feature.autotrade_direction: 4 // Do you want your autotraders to sit? (Note 1) feature.autotrade_sit: yes Credits Thanks to @Lemongrass for coding this update, and @Ind for the original idea. Don't forget to run sql-files/upgrades/upgrade_20140114.sql!

2013 Ragexe ( Thanks to Yommy for all the scripts and the great help Thanks to MStream for his help to the project and for adding patches Thanks to k3dt for unpacking/hosting all the exe and hosting the diff files ) Things you have to do to make it works Open your clientinfo.xml Search <servertype></servertype> Set it to primary Search <langtype></langtype> Set it to 0 Open your db/packet_db.txt in your rathena folder Search the version who match why your ragexe's date choice ex ://2013-05-22 Ragexepacket_ver: 36 So your version will be in clientinfo.xml :36 src/common/mmo.h Search #define PACKETVER YYYYMMDD And match it with the date version you choosed for your client ex : #define PACKETVER 20130522 Clean and re-build the solution of your emulator after it !!! Those patchs has been removed : Restore Login Window - Disable rag1&sak1 - Skip Service Select bug for a lot of people, please don't use it if it's not for testing purpose and use that software : Loki Launcher (It's a ro launcher : you have to use it to log in the game) http://hercules.ws/board/topic/1070-loki-launcher/ or R.O.L.e.X : http://hercules.ws/board/topic/930-rolex/ Ragexe (thx to k3dt) - The patchs support version of Ragexe >= 2013 03 20 http://k3dt.eu/Ragexe/unpacked/ Diff Patcher v2 http://www.mediafire.com/?fibc47gzvdshp8o Diff files http://k3dt.eu/Ragexe/unpacked/Diffs/ Data folder If you have some problem with your lua files, please delete your old data/luafiles514 folder And put those files in your ragnarok folder : https://subversion.assembla.com/svn/client-side-translation/ Finally, change all lua extension to lub extension, place this script in your data/luafiles514 folder Windows : http://www.mediafire.com/?jvtac0j8f6m604v Linux : http://www.mediafire.com/?r72dz8mpk83dvsr If you still have trouble with lub files, you can use my own luafiles514 folder (delete your own luafiles514 folder before !!!) http://www.mediafire.com/?uudw9u0siwnycwz Packets 2013-03-20 - Packets : Encryption keys 2013-05-15 - Packets : Encryption keys 2013-05-22 - Packets : Encryption keys 2013-05-29 - Packets : Encryption keys 2013-06-05 - Packets : Encryption keys 2013-06-12 - Packets : Encryption keys 2013-06-18 - Packets : Encryption keys 2013-06-26 - Packets : Encryption keys 2013-07-03 - Packets : Encryption keys 2013-07-10 - Packets : Encryption keys 2013-07-17 - Packets : Encryption keys 2013-07-24 - Packets : Encryption keys 2013-07-31 - Packets : Encryption keys 2013-08-07 - Packets : Encryption keys Any error ? Look this Support Topic first Working : @ Chat Fix Allow Chat Flood (X lines) Allow Space In Guild Name Arial on All Langtypes Change Gravity Error Handler Chat Color GM Chat Color Guild Chat Color Main Chat Color Party Other Chat Color Party You Chat Color Player Other Chat Color Player You Custom Window Title Disable 4 letter charname limit Disable 4 letter username limit Disable 4 letter password limit Disable Nagle Algorithm Disable Ragexe Filename Check Disable rag1&sak1 Disable Hallucination Wavy Screen Disable HShield Disable Packet Encryption Disable Quake Skill Effect Disable Swear Filter Enable Ascii Enable Custom 3D Bones Enable Multiple Grf Enable Official Custom Fonts Enable Title Bar Menu Enable 64k Hairstyle Enable DNS Support Enforce Official Login Background Extended Chat Box Extended Chat Room Box Extended Npc Box Extended PM Box Fix Camera Angles (Full, Less, Recommended) HKLM to HKCU Increase Headgear View ID to 5000 Increase Zoom Out (50% - 75% - Max) Increase Screenshot Quality Ignore Missing File Error Ignore Missing Palette Error Korea Service XML Fix Only First Login Background Only Second Login Background Packets Keys Change Read Data Folder First Read lua before lub (ItemInfo.lub) Read msgstringtable.txt Read questid2display.txt Remove GM Sprites Remove Gravity Adds Remove Gravity Logo Remove Hourly Annonce Remove Serial Display Shared Body Palettes Shared Head Palettes Skip Licence Screen Skip Ressurection Button Translate Client in English Use Custom Aura Sprites Use Normal Guild Brackets Use Plain Text Descriptions Use Ragnarok Icon Use SSO login packet for all Langtype

Doesn't the @whomap commands already do that? Anyways this will work like an @command warp to the map you'd like to know how many normal players are on and do @getusers... If you want to just input the map name that would probably require surfing your sqldb via script or something. - script user_count -1,{ OnUserGet: attachrid(.aid); addrid(1); if(getgmlevel()>20) end; set(.a,.a+1); end; OnEventDo: set(.aid, getcharid(3)); donpcevent "user_count::OnUserGet"; dispbottom(.a+" User(s) found on "+strcharinfo(3)+"."); set(.a,0); end; OnInit: bindatcmd "getusers","user_count::OnEventDo",99,99; } Remove ",99,99" if this command was intended for normal player use.

Please just read the error. "Duplicate unique name" means exactly what it sounds like. All NPCs are identified by a unique name, and the map-server will automatically rename any duplicates.

case 1: if (zeny > 19999) { zeny, zeny-20000; set blabla,1; close; }

A prize for donating to the "church" ? Under what conditions do you want the prize to be given ?. Here I rewrote the script so it easier to understand. // ================ rAthena Script ================================================== // ============== Information ======================================================= // = iRO Daily Quest : Church Donation // = Made by : // = Rikimaru //===== Current Version: =============================================== //= 1.3 //===== Compatible With: =============================================== //= any rAthena SVN //===== Description: =================================================== //= The iRO Daily Quest : Church Donation //= Usefull for having fun in a Server with a Mini Quest //= Has a counter of 24 Hours until the Players can do the Quest agian. //===== Additional Comments: =========================================== //= 1.1 Finished adding the stats food effects. [Rikimaru] //= 1.2 Fixed a few Bugs in the Script [Rikimaru] //= 1.3 Rewrote the script to make it easier to work with, //-SkittleNugget- //====================================================================== prontera,165,191,3 script [Quest] Church Worker 790,{ if(gettimetick(2) - donatedalready < (60 * 60 * 24)) { mes "^0000FF[ [Quest] Church Worker ]^000000"; mes "Sorry,but you have to wait 24 Hours,before you"; mes "can do the Quest again!"; close; } if (BaseLevel<60){ mes "^0000FF[ [Quest] Church Worker ]^000000"; mes "Hello,you can use my Service,"; mes "when you're at least Baselevel 60"; close; } else if (BaseLevel<80) {callsub Buff,40000,80000,50000,5; } else if (BaseLevel<96) {callsub Buff,80000,200000,60000,6; } else if (BaseLevel<99) {callsub Buff,200000,400000,100000,7; } Buff: //Buff, Zeny, BaseEXP, JobEXP, Food. mes "^0000FF[ [Quest] Church Worker ]^000000"; mes "Hello "+strcharinfo(0)+",do"; mes "you want to get special"; mes "Buffs for "+getarg(0)+" Zenny?"; next; switch(select("Yes,No")==2) { close; } mes "^0000FF[ [Quest] Church Worker ]^000000"; mes "Let me check everything."; next; if(Zeny < getarg(0)) { mes "^0000FF[ [Quest] Church Worker ]^000000"; mes "Sorry,but you need more Zeny!"; close; } set Zeny,Zeny - getarg(0); set BaseExp,getarg(1); set JobExp,getarg(2); sc_start SC_STRFood,180000,getarg(3); sc_start SC_AGIFood,180000,getarg(3); sc_start SC_VITFood,180000,getarg(3); sc_start SC_INTFood,180000,getarg(3); sc_start SC_DEXFood,180000,getarg(3); sc_start SC_LUKFood,180000,getarg(3); set donatedalready,gettimetick(2); mes "^0000FF[ [Quest] Church Worker ]^000000"; mes "Okay,thank you and have fun!"; close; } church_donation.txt

prontera,155,177,5 script Card Seller 100,{ mes "Welcome to card seller ... meh lazy to say"; next; .@s = select( .alphabet_menu$ ) -1; close2; callshop "card_mob#"+ .alphabet$[.@s], 1; end; OnInit: freeloop 1; .@total = query_sql("select distinct left( name_japanese, 1 ) as aaa from item_db right join mob_db on item_db.id = mob_db.dropcardid where ~mode & 32 and type = 6 group by name_japanese order by aaa", .alphabet$ ); for ( .@i = 0; .@i < .@total; .@i++ ) { .alphabet_menu$ = .alphabet_menu$ + .alphabet$[.@i] +" Cards:"; .@nb = query_sql( "select item_db.id from item_db right join mob_db on item_db.id = mob_db.dropcardid where ~mode & 32 and type = 6 and left( name_japanese, 1 ) = '"+ .alphabet$[.@i] +"' group by name_japanese order by name_japanese limit 128", .@id ); npcshopdelitem "card_mob#"+ .alphabet$[.@i], 501; for ( .@j = 0; .@j < .@nb; .@j++ ) npcshopadditem "card_mob#"+ .alphabet$[.@i], .@id[.@j], 1000000; } freeloop 0; end; } - shop card_mob#A -1,501:1000 - shop card_mob#B -1,501:1000 - shop card_mob#C -1,501:1000 - shop card_mob#D -1,501:1000 - shop card_mob#E -1,501:1000 - shop card_mob#F -1,501:1000 - shop card_mob#G -1,501:1000 - shop card_mob#H -1,501:1000 - shop card_mob#I -1,501:1000 - shop card_mob#J -1,501:1000 - shop card_mob#K -1,501:1000 - shop card_mob#L -1,501:1000 - shop card_mob#M -1,501:1000 - shop card_mob#N -1,501:1000 - shop card_mob#O -1,501:1000 - shop card_mob#P -1,501:1000 - shop card_mob#Q -1,501:1000 - shop card_mob#R -1,501:1000 - shop card_mob#S -1,501:1000 - shop card_mob#T -1,501:1000 - shop card_mob#U -1,501:1000 - shop card_mob#V -1,501:1000 - shop card_mob#W -1,501:1000 - shop card_mob#X -1,501:1000 - shop card_mob#Y -1,501:1000 - shop card_mob#Z -1,501:1000 tabs were broken. Don't forget to load item_db table in mysql