Leaderboard

1.

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!

www.forum.cronus-emulator.com