Jump to content

Utility: Cash Shop Manager


Haikenz

Recommended Posts


  • Group:  Members
  • Topic Count:  84
  • Topics Per Day:  0.02
  • Content Count:  309
  • Reputation:   82
  • Joined:  11/15/11
  • Last Seen:  

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

  • 9 months later...

  • Group:  Members
  • Topic Count:  27
  • Topics Per Day:  0.01
  • Content Count:  107
  • Reputation:   5
  • Joined:  07/01/14
  • Last Seen:  

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.

Link to comment
Share on other sites

  • 2 months later...

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  45
  • Reputation:   1
  • Joined:  10/09/18
  • Last Seen:  

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

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  84
  • Topics Per Day:  0.02
  • Content Count:  309
  • Reputation:   82
  • Joined:  11/15/11
  • Last Seen:  

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

Link to comment
Share on other sites

  • 3 months later...

  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.00
  • Content Count:  144
  • Reputation:   19
  • Joined:  06/28/12
  • Last Seen:  

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


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.00
  • Content Count:  144
  • Reputation:   19
  • Joined:  06/28/12
  • Last Seen:  

character who adds things does not see them

Link to comment
Share on other sites

  • 1 year later...

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  12/04/17
  • Last Seen:  

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

Link to comment
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.

×
×
  • Create New...