Haikenz

Utility: Cash Shop Manager

Recommended Posts

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.

2qduatc.png

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
  • Submitted
    03/22/2018
  • Category
  • Video
    https://www.youtube.com/watch?v=ocigrUMImZg
  • Content Author
    Haikenz

 

  • Upvote 1

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
Posted (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 by Visual

Share this post


Link to post
Share on other sites

character who adds things does not see them

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...