JoWei

It's an issue with map cache, update it. What revision of rAthena you're using? Latest should have had the npc positions fixed.

Not sure what you want but if you want to delete table entirely then it should be DROP TABLE `pvpladder` or if you want to only empty the table then it should be TRUNCATE TABLE `pvpladder` That code you provide only delete an entry and is wrongly formatted as it suppose to have conditional entry after WHERE which should be for example DELETE FROM `pvpladder` WHERE `char_id` = 123456 which will delete all entries from `pvpladder` with `char_id` equal to 123456.

Seeing how the item script got uncommented, I'm guessing it should work. Not sure about the other items since I haven't quite looked into it.

Not quite sure you can duplicate a label but what you could do is set a variable which could be checked in OnBuyItem?

Basically, it's like you thought except for the Zeny part. It will log all items that are not: healing, etc, arrows and useable type but also not the zeny because it is logged from this part of the log conf: // Track Zeny Changes // Filter settings // 0 - don't log; 1 - log any zeny changes; 2.....1000000 - minimal absolut logging zeny value log_zeny: 0

Is /skillfail enabled?

Yes I have tried my query on my own RO DB but population is low which is why I used knife[3] since they are the most common among newly created characters. It returns the account ID if it finds the item specified. select `account_id`, `char_id` from `char` where `char_id` in ( select `char_id` from `inventory` where `nameid`=1201 union select `char_id` from `cart_inventory` where `nameid`=1201 union select `dest_id` from `mail` where `nameid`=1201 ) or `account_id` in ( select `account_id` from `storage` where `nameid`=1201 ) or `guild_id` in ( select `guild_id` from `guild_storage` where `nameid`=1201 ) Edit: Noticed I forgot the mail check and returns the char_id.

It should log only normal items and card. For Zeny there's this option: // Track Zeny Changes // Filter settings // 0 - don't log; 1 - log any zeny changes; 2.....1000000 - minimal absolut logging zeny value log_zeny: 0 Edit: Just re-read the 4080

This query should work fine for your case, just change 1201 for your item ID select `account_id` from `char` where `char_id` in ( select `char_id` from `inventory` where `nameid`=1201 union select `char_id` from `cart_inventory` where `nameid`=1201 ) or `account_id` in ( select `account_id` from `storage` where `nameid`=1201 ) or `guild_id` in ( select `guild_id` from `guild_storage` where `nameid`=1201 )

Yes I've got MSN I'll send you a PM.

Hm... can you tell me the steps your took to change the files? Because I could make the change on my side without issue. There's one last thing also I'd like to mention, there's 2 portal that lead between 01-02 that got removed in renewal meaning the place the portal should be isnt available to access by map unless you use older maps before the renewal update on map from KRO.

The file I posted earlier has to replace "hugel_fild.txt" because that's the older version of it where the ein_fild01-02 weren't disabled yet.

Oh, sorry my bad, I forgot to mention that the file containing those is "hugel_fild.txt".

The link for the correct revision was the one I posted earlier. It keeps all version of the files so all you need to do it just checkout another version that you'd use to find the files through the logs. Here's the file I found for warps ein_fild01-02 that came from revision 15059 right before the changes in 15060 for renewal warp ajustments //===== eAthena Script ======================================= //= Hugel Field Warp Script //===== By: ================================================== //= Sara-chan (1.0) //===== Current Version: ===================================== //= 1.2 //===== Compatible With: ===================================== //= Any Athena Version; RO Episode 10+ //===== Description: ========================================= //= Warp Points for Hugel Field //===== Additional Comments: ================================= //= Initial Release //= 1.1 Official warps [Playtester] //= 1.2 Corrected NPC names to fall within proper restrictions. [L0ne_W0lf] //============================================================ //= Hugel Field ============================================== ein_fild04,343,293,0 warp hugel001 1,1,ein_fild05,80,294 ein_fild05,76,294,0 warp hugel001a 1,1,ein_fild04,336,292 ein_fild05,376,183,0 warp hugel002 1,1,ein_fild06,47,166 ein_fild06,42,171,0 warp hugel002a 1,1,ein_fild05,371,183 ein_fild02,357,251,0 warp hugel003-1 1,1,yuno_fild04,38,280 yuno_fild04,33,279,0 warp hugel003a-1 1,1,ein_fild02,350,250 ein_fild01,349,369,0 warp hugel003 1,1,yuno_fild05,43,346 yuno_fild05,41,350,0 warp hugel003a 1,1,ein_fild01,345,367 ein_fild01,106,34,0 warp hugel004 1,1,ein_fild02,109,358 ein_fild02,108,364,0 warp hugel004a 1,1,ein_fild01,106,40 ein_fild01,234,34,0 warp hugel005 1,1,ein_fild02,258,343 ein_fild02,257,350,0 warp hugel005a 1,1,ein_fild01,231,40 ein_fild02,170,29,0 warp hugel006 1,1,ein_fild05,172,366 ein_fild05,172,371,0 warp hugel006a 1,1,ein_fild02,170,37 hu_fild01,366,185,0 warp hugel007 1,1,hu_fild02,22,168 hu_fild02,17,168,0 warp hugel007a 1,1,hu_fild01,361,189 hu_fild04,47,372,0 warp hugel008 1,1,hu_fild02,40,27 hu_fild02,40,22,0 warp hugel008a 1,1,hu_fild04,48,368 hu_fild04,294,379,0 warp hugel009 1,1,hu_fild02,280,31 hu_fild02,283,28,0 warp hugel009a 1,1,hu_fild04,289,376 hu_fild05,284,356,0 warp hugel010 1,1,hu_fild03,288,26 hu_fild03,288,19,0 warp hugel010a 1,1,hu_fild05,276,346 hu_fild05,353,126,0 warp hugel011 1,1,hu_fild06,34,119 hu_fild06,28,119,0 warp hugel011a 1,1,hu_fild05,347,130 hu_fild02,374,339,0 warp hugel012 1,1,hu_fild03,24,337 hu_fild03,20,338,0 warp hugel012a 1,1,hu_fild02,370,339 hu_fild02,378,162,0 warp hugel013 1,1,hu_fild03,30,163 hu_fild03,25,163,0 warp hugel013a 1,1,hu_fild02,373,160 yuno_fild09,377,184,0 warp hugel014 1,1,yuno_fild10,44,183 yuno_fild10,39,183,0 warp hugel014a 1,1,yuno_fild09,371,184

Uh, when you checkout the trunk of rAthena for example > https://rathena.svn..../rathena/trunk/ On Windows with Tortoise SVN, just right click on the folder then select "SVN Show log" then in the log search bar, enter the file name of the spawns/warps you want. I'm uncertain for other OS as I'm using Windows as my server host.

You can checkout another copy of rAthena or eAthena SVN and update revision backward to get the files wanted to the date, I'm not sure to which revision you will have to update but you can try to find the exact file which contains the spawns and portals in the log search. It should bring up all the revision in which the files has changed and just locate the one you want to use.

For the mapcache just go in rAthena SVN trunk root and you should have it there when you compile the server. It's named mapcache.exe. I'd recommand backing up your "trunk/db/map_cache.dat" before running it. Just run that and you should see a command prompt adding the maps in mapcache.dat. As for portals, you will have to copy from older revision from before they were removed in the SVN.

I'm guessing you didn't update your mapcache which defines walkable cell and such server side. Just run the mapcache and it should work fine afterward. As for pre-renewal maps npc positions and mobs spawns, I just copy over old scripts from eA or older rA revisions.

They are nice maps indeed and would be proven useful later on for events, theme dungeon or story of some sort. So thanks Ridley for sharing them and Denny for letting Ridley share them as a pack. Wow they got downloaded fast.( At 141 downloads right now. ) O_o And I wonder if they had wanted to try maps before saying a word. Anyhow I'll be trying them out when I get home from work~

Hey Sharpienero, nice tutorials but on part 3, I can confirm that all the commands still works even if they are duplicated in 2 different groups since I got normal players and super players with nearly all the same commands.

Happy birthday to you JMan!

KRO official is base 150/50 for third while it's 99/70 for trans, I'll have to recheck Edit: Yeah, it's 99/50 for second jobs, 99/70 for transcended jobs and 150/50 for third jobs

My guess is that the VPS provider added up all the CPU power together making the number a bit more appealing, for 21ghz case it would be 6 core with 3.5ghz speed each.

If you're using a router, be sure to route your connections to your computer's internal IP because if you use the IP to connect it will connect through your router first. Without having the information about which computer to the network to connect to at what port, it won't be able to connect as it wouldnt be able to tell it had to connect to your computer. So, make sure you set your computer as a server on your router. For example: DLink has a feature to set up Virtual Server which can allow connection directly to your computer if you set "any" port as public toward your computer. Edit: Replied too late

There's also client side change you need to do which should be in "data/lua files/skillinfoz/skillinfolist.lua(lub)".