jTynne

Make sure you've: 1. Updated the map_index file in the db folder. 2. Added the .gat data to the mapcache.dat file in the db folder. 3. Updated the maps_athena.conf file in the conf folder. 4. Restart the server. This should work if you follow the steps correctly.

from iRO's message board.

CREATE TABLE IF NOT EXISTS `cp_ticket` ( `ticket_id` int(11) NOT NULL AUTO_INCREMENT, `ticket_number` int(11) NOT NULL, `group` tinyint(4) NOT NULL DEFAULT '1', `account_id` int(11) NOT NULL, `subject` varchar(100) NOT NULL, `category` varchar(100) NOT NULL, `body` text NOT NULL, `date_filed` datetime NOT NULL, `poster` varchar(100) NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'open', `ip` varchar(50) NOT NULL, PRIMARY KEY (`ticket_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=804 ; -- There ya go!

Comment out the maps you want people to be able to warp to in https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/conf/mapflag/nowarpto.txt

I already have a ticket system implemented on my server, and am trying to figure out if this is simply a modification of the one released by someone else (SketchyPhoenix I think? I don't remember who wrote it though, since a client of mine gave it to me for free a few years ago @_@ and/or if it's backwards compatible with my existing ticket system. It seems to function similarly, but yours has a few more features. Am discussing this with my staff at this time, but would love to know the answers to my questions so I know whether or not to make the purchase Thanks!

What client date/version? What langtype are you using? Try langtype 0 and 1 to see if that'll help. I recently had a similar issue. =X

RO Sprite Studio (ROSS) - Palette Creation Tool View File RO Sprite Studio (ROSS) - Palette Creation Tool Version 1.3.0.0 I'm not certain who made this tool, however, this was given to me a few years ago by a colleague of mine at ElysiumRO. I've used it ever since to create palettes for the RO game client; specifically, for my servers. The interface is easy to use, and it is by far the fastest, easiest way to make RO palettes. Please note, however, that you MUST have a pretty good understanding of how palettes work in RO in order to use this, as you will need to save the palettes to the appropriate folders, with the appropriate names (which CAN be generated in the program itself). This package does NOT include the RO class sprites, or my master palette file that I created for use with the program. It does however contain ROSS and all required files to run. jTynne Submitter jTynne Submitted 12/07/2011 Category Spriting & Paletting Tools Content Author jtynne  

File Name: jTynne Monster Sprite Recolor Collection (100 Sprites) File Submitter: jTynne File Submitted: 07 Dec 2011 File Category: Mobs Title: jTynne Monster Sprite Recolor Collection (100 Sprites) Author: jTynne - [email protected] Background History: I created the recolors for the sprites contained within this package over the years, spanning many of my servers (dating as far back as 2008). Many of the monster sprites contained in this collection are to be used for specific regions I've created, or for events. Additional Notes: The sprites are FREE to download and use for your server, however, I will note that a small donation towards my cause would be greatly appreciated if you do make use of these on your server. I will make certain to note on my website that your server has made a donation as thanks for the files. Donations can be made via Paypal to : [email protected] Sprite Contents: Adamantium Golem Adamantoise Algea Anu Mummy Anunaki Anu Warrior Arcanis Atum Bali Forest Warg Bird of Paradise Bloody Hand (Crimson Wave) Blossom Blue Lif Bradium Calliope Cave Monster Coal Contagious Crabon Dark Knight Delph Diatres Draconis Dragonfly Dusk Eden Mineral Cluster 1/2/3 Eden Mantis (Bana Mantis) Eden Sentinel Eden Wasp Elunium Elunium Golem Fahl Fenrir Fiend Fire Warg Gil Harsiesis Hazardous Healer Hellhound High Orc Lord Horus Hrobi Ice Boitata Implosion Insomniac Jungle Boy Khonsu Kimre Lady Hel Lavender Lepera Lespera Lorelei Lycan Maat Mandrake Marine Grenade Mazze Mercune Merman Guard Mertseger Monitor Lizard Mono Mossy Golem Mud Runner Neo Drake (Oil Spill Drake) Neptunian Ocho Oridecon Oridecon Golem Paros Mummy Paros Shaman Pegasus Perasus Rock Golem Rukk Salem Santa Drops Santa Marin Santa Poporing Seaphr Sheller Siren Spearfish Spectre Sprite Sproutling Toxifrog Unicorn Venus Blowfish Violif Werewolf Wood Warg Yutei Zombie Dragon Click here to download this file

File Name: Christmas Arena (1 Map) File Submitter: jTynne File Submitted: 07 Dec 2011 File Category: Maps & Textures Christmas Arena by jTynne This is a map that was unfinished and given to an old client "as-is", who was not charged for it since the old version had the black cell error that many maps have when made via Browedit. It would make for a very charming Lutie PVP Arena, or a great Christmas event map. The map is FREE to download and use for your server, however, I will note that a small donation towards my cause would be greatly appreciated if you do make use of it on your server. I will make certain to note on my website that your server has made a donation as thanks for the map file. Donations can be made via Paypal to : [email protected] Version: 1.0 Author: jTynne @ http://www.justintynne.com Click here to download this file

Euphy's is the closest to this that I can think of. Mine doesn't have a card remover, rental, or platinum skills.

Apply the needed SQL updates: ALTER TABLE `inventory` ADD COLUMN `favorite` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `expire_time`; ALTER TABLE `cart_inventory` ADD COLUMN `favorite` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `expire_time`; ALTER TABLE `storage` ADD COLUMN `favorite` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `expire_time`; Kind of surprised they haven't been added into the SVN yet..

OH! Thank you! That was leftover from another test of mine. Got it! Testing.. Xantara-- it works! PM me your Paypal e-mail address so that I may submit payment.

Thanks, now testing. Will let you know the results ASAP

I don't usually publicly ask for assistance, but I figure that such a script could inspire others with their own creations if I did ask for support on this publicly. In this script, I want players to earn temporary "value" points that get stored in an SQL table (or a global array) along with their character ID. In this particular example, a GM must enable the sorting mechanism, but in the final iteration it will be automatically called upon by an external script via "donpcevent "Ides Sort::OnSort";" which will then run an SQL query that orders the players with the highest "value" in descending order and warps the results into two places in a 1 2 1 2 1 2 1 2 fashion. This is to essentially provide as much balance as possible for a PVP-based event. The problem I face presently is that the script is not teleporting players past a certain point, and at times does not even make it past the "for" loop to reach the truncate queries and erasing the array and temporary global variables. The console shows no errors, and even when the script runs, no errors display. What I'm requesting is the script's sorting feature at the very least, to be optimized and changed to allow it to work. If players are offline when it activates, it simply skips over them and continues sorting the remaining players. If anyone can assist with this, I'd be most grateful as this has been trying my nerves for the greater portion of the past 48 hours. ides01,100,144,0 script Ides Sort -1,5,5,{ if(getgroupid() >= 95) { mes "Continue Sort?"; next; menu "Yes",-; close2; donpcevent "Ides Sort::OnSort"; end; } if(idessorted < 1) { warp "ides01", set idessorted,1; set .@char_id,getcharid(0); // Value 1-10 for Base Level if(BaseLevel < 70) { set .@value,.@values+1;} if(BaseLevel >= 70 && BaseLevel < 80) { set .@value,.@values+2;} if(BaseLevel >= 80 && BaseLevel < 90) { set .@value,.@values+3;} if(BaseLevel >= 90 && BaseLevel < 100) { set .@value,.@values+4;} if(BaseLevel >= 100 && BaseLevel < 110) { set .@value,.@values+5;} if(BaseLevel >= 110 && BaseLevel < 120) { set .@value,.@values+6;} if(BaseLevel >= 120 && BaseLevel < 130) { set .@value,.@values+7;} if(BaseLevel >= 130 && BaseLevel < 140) { set .@value,.@values+8;} if(BaseLevel >= 140 && BaseLevel < 150) { set .@value,.@values+9;} if(BaseLevel == 150) { set .@value,.@values+10;} set .@value,.@value+BaseLevel; // Class Points Based On if(Class >= 0 && Class <= 25 || Class >= 4046 && Class <= 4049) { set .@value,.@value+0;} // First Jobs & Extended Jobs if(Class >= 4001 && Class <= 4022) { set .@value,.@value+10;} // Trans Classes if(Class >= 4023 && Class <= 4045) { set .@value,.@value+0;} // Baby First/Second Jobs if(Class >= 4054 && Class <= 4087) { set .@value,.@value+25;} // 3rd Jobs if(Class >= 4096 && Class <= 4112) { set .@value,.@value+15;} // Baby 3rd Jobs if(Class >= 4211) { set .@value,.@value+15;} // Kagerou/Oboro Place Holder // Role Specific Values query_sql("INSERT INTO `rune_rankings`.`ides_sorting` values ('"+.@char_id+"', '"+.@value+"')"); } mes "Success"; close; end; OnSort: set $@nb1, query_sql("SELECT char_id,value FROM `rune_rankings`.`ides_sorting` ORDER BY value DESC", $@char_id[1], $@value[1]); set $@nb2,query_sql("SELECT COUNT(*) AS size FROM rune_rankings.ides_sorting", $@size); for( set .@i, 0; .@i <= $@size; set .@i, .@i +1 ) { if($ideswitch == 0) { set $ideswitch,1; warpchar "ides01",50,146,$@char_id[.@i]; goto L_skip; } set $ideswitch,0; warpchar "ides01",154,146,$@char_id[.@i]; L_skip: } //mapannounce "ides01","[ides] Teams have been sorted!",0; query_sql("TRUNCATE `rune_rankings`.`ides_sorting`"); deletearray $@char_id[0],$@size; set $@nb2,0; set $@size,0; end; } 3:20pm EST: Since I've not received any assistance on this yet, $10.00 USD via Paypal to whoever can get it working properly.

This would be a fabulous custom addition to rAthena. So much additional functionality and possibilities.. Five stars from me! Great work!

Do you operate a server that runs on rAthena? Are you someone who codes fixes/updates for a server that runs rAthena? If you answered yes to either of the above, then I have one more question for you: Do you share your fixes/findings/content with the rest of the community? If no, consider this a "Call To Action" for server administrators and content developers. I recently made my server public, and despite the excellent work the developers here do on a daily basis, there are still a lot of things that have to be updated/fixed, revised, and optimized. While the emulator IS essentially production ready, I've found myself having to go through and edit quite a few things, code official things that no one's been able to get to yet, and figure things out regarding why quests or certain scripts are missing or simply not working (or are missing functionality/support for the new classes). While I completely understand that not EVERYONE mooches off of the emulation project, I urge those of you who run a server and who are capable of writing fixes of your own, to please post your fixes/findings in the Bug Tracker if you do not already do so. There's plenty of things to update and finish in the item database, documentation files to be updated/modified, among other things. I'm not a developer here, and honestly, I'm not a professional script writer, however, I'm doing what I can to ensure the rest of the community can benefit even if only by a slight margin by sharing my content updates, and I urge others to do the same. The less that the developers here have to tend to on their own, the faster we'll start seeing things we've been waiting on, like completion of Oboro/Kagerou, script fixes, updated database inserts, and more. /hops off soap box

I just came all over the desk. Best script ever.

EssenceRO Tira -> Paradox924X Complications? Players have been leaving ever since. =/ I used to play on Essence in my spare time, but left when all of my friends I'd made left due to issues they had with the new administration. It's unfortunate, too, because the core of the server was one of my favorites in my years playing.

Simple script I wrote, if someone wants to optimize it, feel free. If there's errors, please feel free to point them out so that they can be fixed. Wrote this since the Arch Bishop job change script is terribly broken and don't have time to tend to it completely myself at this time. prt_in,42,114,5 script 3rd Job Items 91,{ set .@n$,"[3rd Job Items]"; if(thirdjobitem > 0) {mes .@n$,"You have already received your award. I can no longer provide assistance to you."; close; end;} mes .@n$,"Once you have changed to a Third Job, I will award you with the headgear and Green Apple Ring you would obtain through the official quests."; next; L_rune: if(Class == Job_Rune_Knight || Class == Job_Baby_Rune || Class == Job_Rune_Knight_T || Class == Job_Rune_Knight2 || Class == Job_Rune_Knight_T2 || Class == Job_Baby_Rune2) { set .@item,5746; goto L_process; } L_warlock: if(Class == Job_Warlock || Class == Job_Baby_Warlock || Class == Job_Warlock_T) { set .@item,5753; goto L_process; } L_ranger: if(Class == Job_Ranger || Class == Job_Baby_Ranger || Class == Job_Ranger_T || Class == Job_Baby_Ranger2 || Class == Job_Ranger_T2 || Class == Job_Ranger2) { set .@item,5748; goto L_process; } L_arch: if(Class == Job_Arch_Bishop || Class == Job_Baby_Bishop || Class == Job_Arch_Bishop_T) { set .@item,5747; goto L_process; } L_mech: if(Class == Job_Mechanic || Class == Job_Baby_Mechanic || Class == Job_Mechanic_T || Class == Job_Mechanic_T2 || Class == Job_Baby_Mechanic2 || Class == Job_Mechanic2) { set .@item,5749; goto L_process; } L_cross: if(Class == Job_Guillotine_Cross || Class == Job_Baby_Cross || Class == Job_Guillotine_Cross_T) { set .@item,5755; goto L_process; } L_guard: if(Class == Job_Royal_Guard || Class == Job_Baby_Guard || Class == Job_Royal_Guard_T || Class == Job_Royal_Guard_T2 || Class == Job_Royal_Guard2 || Class == Job_Baby_Guard2) { set .@item,5757; goto L_process; } L_sorcerer: if(Class == Job_Sorcerer || Class == Job_Baby_Sorcerer || Class == Job_Sorcerer_T) { set .@item,5756; goto L_process; } L_minstrel: if(Class == Job_Minstrel || Class == Job_Baby_Minstrel || Class == Job_Minstrel_T) { set .@item,5751; goto L_process; } L_wanderer: if(Class == Job_Wanderer || Class == Job_Baby_Wanderer || Class == Job_Wanderer_T) { set .@item,5758; goto L_process; } L_sura: if(Class == Job_Sura || Class == Job_Baby_Sura || Class == Job_Sura_T) { set .@item,5754; goto L_process; } L_genetic: if(Class == Job_Genetic || Class == Job_Baby_Genetic || Class == Job_Genetic_T) { set .@item,5752; goto L_process; } L_shadow: if(Class == Job_Shadow_Chaser || Class == Job_Baby_Chaser || Class == Job_Shadow_Chaser_T) { set .@item,5750; goto L_process; } mes .@n$,"It does not appear as though you're a third job. Sorry, but I have nothing for you."; close; end; L_process: set thirdjobitem,1; getitem .@item,1; getitem 2795,1; mes .@n$,"There you are! Enjoy and congratulations on reaching your respective 3rd Job Class."; close; end; }

Yay! Thank you SBlack! (God you two are confusing as hell.) <3

Absolutely wonderful! Just took a gander at it in Browedit.. 10/10 from me!

Download Miruku and patch. Port Malaya comes by default in rAthena.. Miruku Site: http://miruku.rathena.org

query_sql script command is how I've done it in the past. Write an SQL statement that will update the user's group_id column in the char table.

Girl, best back up off my man! *flips razor blade* I'm ALL THE PROTECTION MY BABY NEEDS! *and what*?!?! <3 I like that the account management system is being suggested lots. Hooh lawd. (DeePee: When you guys did it in the pserver community after iRO did it, I knew it was time to beg someone to write it for the rest of us haha)

Shop Search - If you can get rA to store the data differently rather than how it's currently handled, I think this would be great for -all- servers to have, rather than a select handful. Integrated Chat - I can't say too much, but Ind's IRC thing + web side ability to chat with those in-game would be awesome (and configuration to be able to lock people out until they get approval from an admin to chat). Automated Donation Handling - Similar to Flux. Vote For Points - Right out the box, the same handling as the V4P in Flux would be adequate. Easier CMS - The currently handling in Flux is annoying to say the least. Account Clusters - One main login to manage multiple in-game accounts similar to iRO's system. As I think of others, I'll post them here.