Utility: Cash Shop Manager

[Haikenz]

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

 

[Cid Kagenou]

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.

[TrustGTX]

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

[Haikenz]

@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.

[Visual]

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

[Visual]

character who adds things does not see them

[Jimkojima]

Works great, worth the value and safe up tons of time manage the item cash shop triple thumbs up