Haikenz Posted March 26, 2018 Posted March 26, 2018 View File Cash Shop Manager NPC that allows you to manage your store Cash shop can Add, Edit and Remove items. Languages: English (US), Português (BR) Warning: To use the NPC it is recommended that you use the "item_cash_db.sql" in your folder "sql-files". DROP TABLE IF EXISTS `item_cash_db`; CREATE TABLE `item_cash_db` ( `tab` smallint(6) NOT NULL, `item_id` smallint(5) unsigned NOT NULL, `price` mediumint(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`tab`,`item_id`) ) ENGINE=MyISAM; Preview: Q: I added an item and it didn't show up in the store. Quote It is necessary that you click on the Relog menu of the NPC, and then go out and enter the game. Q: I'm trying to add an item and it's giving error. Quote This occurs when you are adding an item ID that already exists in the store or is an invalid ID. Because the NPC has a lock restriction to not send repeated item in the store. Q: I added the item in the "Sale" and still did not appear. Quote 1-Type /limitedsale and hit enter in the chat window in the client. 2-Enter the item name into the Item DB Name field in the sale window.3-Fill in the data you want for the item: Number of Sale: Amount of this item that is sold to players. Sale Start Time: This is the Month / Day and then Hour : Minute of the start of the sale Time to sell: How many hours the sale will last. 24h is max tested so far.4-Click Add Limited Item and wait for the start time that was entered to pass. By buying this script, you agree to these terms: You are not allowed to redistribute this script in any way, shape, or form. Chargeback scams are not tolerated and will get you punished on rAthena. I still retain all rights to this script. Terms above may be changed or adjusted without prior notification. Copyright © - Haikenz 2011-2018 - All Rights Reserved Submitter Haikenz Submitted 03/22/2018 Category Utilities Video https://www.youtube.com/watch?v=ocigrUMImZg Content Author Haikenz 2 Quote
Cid Kagenou Posted January 3, 2019 Posted January 3, 2019 did all the steps , yet nothing has been added to the cash shop , i can see the items in the db , but nothing appears in the cash shop. Quote
TrustGTX Posted March 17, 2019 Posted March 17, 2019 On 1/3/2019 at 10:48 AM, Fahhad said: did all the steps , yet nothing has been added to the cash shop , i can see the items in the db , but nothing appears in the cash shop. same @Haikenz Quote
Haikenz Posted March 22, 2019 Author Posted March 22, 2019 @Fahhad @TrustGTX Hi, sorry for the delay, so you need to use SQL mode instead of TXT inter_athena.conf // Use SQL item_db, mob_db and mob_skill_db for the map server? (yes / no) use_sql_db: yes import sql-files/item_cash_db.sql You can now use npc!When you start adding items to the store it does not appear immediately, you have to relogue the character to appear. Quote
Visual Posted June 25, 2019 Posted June 25, 2019 (edited) On 3/22/2019 at 2:34 PM, Haikenz said: @Fahhad @TrustGTX Hi, sorry for the delay, so you need to use SQL mode instead of TXT inter_athena.conf // Use SQL item_db, mob_db and mob_skill_db for the map server? (yes / no) use_sql_db: yes import sql-files/item_cash_db.sql You can now use npc!When you start adding items to the store it does not appear immediately, you have to relogue the character to appear. Is it possible to do something so that not the entire server is translated into sql? Edited June 25, 2019 by Visual Quote
Jimkojima Posted October 5, 2020 Posted October 5, 2020 Works great, worth the value and safe up tons of time manage the item cash shop triple thumbs up Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.