Leaderboard

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

I tested it using the CREATE TABLE and INSERT statements in your 1st post and I didn't get any warnings. Did you add a `die_point` column to your `char` table? If you're not using it, you should drop that column. Or you can fully qualify the table.column names like this: SELECT `char`.`name`, pvp_ranking.kill_point, pvp_ranking.die_point, pvp_ranking.kill_point-pvp_ranking.die_point FROM `pvp_ranking` LEFT JOIN `char` ON pvp_ranking.char_id=`char`.char_id WHERE pvp_ranking.kill_point>0 ORDER BY (pvp_ranking.kill_point - pvp_ranking.die_point) DESC LIMIT 10;

You probably uploaded the file with some tool that keeps the original file timestamp and your timezone is different than the server timezone, then the time is in the future. You can just ignore it or configure it to don't preserve timestamps.

Can't extract. I'm getting... Error 0x80004005: Unknown Method

just like other regular script commands.. if( issitting() ){ // the char is currently sitting }else{ // the char is not sitting }

use calculator on its programmer's view so that you can do arithmetic operations with hex,dec,bin and oct with ease..

Hmm.. I realize the benefit of a Diff file, it's very easy to apply the patch, but the major downside for me is, I don't know how to create a diff file and if I want to change the client then I have to wait for a next version diff to be released by Diff maker, such as ai4rei.. And some people may want to customize their language into their natives too Location: Press Esc --> Video Configuration Korean: ÀüÀå Hex: C0FCC0E5 (near 4E6F4374726C00006974656D00000000736B696C6C) Suggestion: More [4D6F7265] Location: Press Esc --> Sound Configuration Korean: ÆÄƼ¿ø ã±â ¾Ë¶÷ Hex: N/A (msgstringtable) Suggestion: Use 3D Effect (?) Inventory Window: Location: Press Alt+E Korean: Àåºñ Hex: N/A (msgstringtable) Suggestion: Equip Korean: °³ÀÎ Hex: N/A (msgstringtable) Suggestion: Fav Korean: ¾ÆÀÌÅÛ ¹ö¸®±â Àá±Ý Hex: N/A (msgstringtable) Suggestion: Item Lock Party Window: Location: Press Alt+Z Korean: ÆÄƼ°á¼º Hex: N/A (msgstringtable) Suggestion: Create Party Location: Press Alt+Z --> Create Party Korean: ÆÄƼ À̸§ µî·Ï Hex: N/A (msgstringtable) Suggestion: Party Name Location: Party Window Korean: ÆÄƼÃÊ´ë Hex: N/A (msgstringtable) Suggestion: Add to Party Location: Party Window Korean: ÆÄƼŻÅð Hex: N/A (msgstringtable) Suggestion: Leave Party Location: Party Window --> Add to Party Korean: ÃÊ´ëÇÒ Ä³¸¯ÅÍ À̸§ Hex: N/A (msgstringtable) Suggestion: Type character's name Location: Party Window --> Add to Party --> Press OK without typing anything Korean: ij¸¯Å͸íÀ» ÀÔ·ÂÇÏ¼Å¾ß ÇÕ´Ï´Ù. Hex: N/A (msgstringtable) Suggestion: Please type the character's name you want to invite to this party. Location: Press Alt+Z --> Create Party --> Press OK without typing anything Korean: ÆÄƼÀ̸§À» ÀÔ·ÂÇÏ¼Å¾ß ÇÕ´Ï´Ù. Hex: N/A (msgstringtable) Suggestion: Please insert the name of your party.

Ask your WebHost Provider this is excessive ram usage

Yes rAthena provide pre-re. You can disable RENEWAL here https://rathena.svn....onfig/renewal.h After that re-compile.

http://subversion.assembla.com/svn/ClientSide/

Those 0x numbers are hexadecimal (base 16, not base 10). 0x100 + 0x020 + 0x010 + 0x008 + 0x002 actually equals 0x13A, not 0x140. Actually, the config bits are like that 0x001 = 1 0x002 = 2 0x004 = 4 0x008 = 8 0x010 = 16 0x020 = 32 0x040 = 64 0x080 = 128

@Vitrue: Here are the changes -- case 5: set @s, select(implode(.Names$,":")); //... callshop "mission_shop"+@s,1; npcshopattach "mission_shop"+@s; end; OnBuyItem: for(set .@i,0; .@i<getarraysize(@bought_nameid); set .@i,.@i+1) for(set .@j,0; .@j<getarraysize(getd(".Shop"+@s)); set .@j,.@j+2) if (getd(".Shop"+@s+"["+.@j+"]") == @bought_nameid[.@i]) { set @cost, @cost+(getd(".Shop"+@s+"["+(.@j+1)+"]")*@bought_quantity[.@i]); break; } OnInit: // new shop arrays (be sure to rename the first one) setarray .Shop1[0],1202,5,1229,20; setarray .Shop2[0],5116,15; setarray .Names$[0],"Weapons","Headgears"; for(set .@i,1; .@i<=getarraysize(.@Names$); set .@i,.@i+1) { npcshopdelitem "mission_shop"+.@i,512; for(set .@j,0; .@j<getarraysize(getd(".Shop"+.@i)); set .@j,.@j+2) npcshopadditem "mission_shop"+.@i, getd(".Shop"+.@i+"["+.@j+"]"), getd(".Shop"+.@i+"["+(.@j+1)+"]"); } end; } // duplicate shops as necessary - shop mission_shop1 -1,512:-1 - shop mission_shop2 -1,512:-1

if (.off) end; // your script announce ...; // last line set .off,1; initnpctimer; waitingroom "[service unavailable]",0; end; OnTimer30000: stopnpctimer; set .off,0; delwaitingroom; end;

@bVersatile: Extract the rss2news folder to <fluxcp directory>/addons.

for me, BOTB (Best of the Best) Event or GVG (Guild vs Guild) is the best! Best Of The Best *insert job class here*!! especially when it is BOTB Soul Linker! seeing Soul Linker's in a pvp battle, lol using their own strategies to win

Das hier ist der Deutsche Bereich und hier wird Deutsch gesprochen! -> Alle nicht Deutschen Beiträge versteckt. ~ @Thema: 1. TXT wurde eingestellt, man muss jetzt SQL nutzen. (Die DBs (item/mob/etc.) können immer noch als TXT genutzt werden. Es wurde nur die Accountverwaltung ins SQL geschoben.) 2. Klar, einfach in der JobDB die entsprechenden Jobs auskommentieren. 3. Generell ist immer die aktuellste Version zu empfehlen, egal ob "old school", oder nicht.

I think you just have to find the right people. There are still some people out there who like running a server for free because they enjoy it!