Jump to content

Question

Posted (edited)

hi i would like to request a mall script that sort out all types of equip for each npcs, and auto price each items

 

goal of this script:

             -all of the existing items in your item_db will be loaded to the npcs, you dont have to worry if there's something missing on your mall script, if there's an item update in item_db in your database, the script will automatically query select all the items depending on their item type (e.g weapon,cards,armors,ammo,usable,misc,etc) and put it on the diff npcs

 

            -auto pricing will be a great help so that you dont have to manually put and think of the price for each items, it also prevent npcs from selling items with 0 price or for free.

 

blacklist feature:

put item id here to exclude the item from the mall script

 

 

 

item price increased  depends on

-weight

-number of effects (if possible)

-attack

-number of slots

-weapon level

-defense

-required level

-applicable job

 

 

 

 

example of item pricing:

 

item name : Fire god knife [4]                    user formula settings (in pricing)

weight : 50                                                         for every 10 weight  =                   +  1,000 zenny              5,000z  

number of effects: enhant weapon to fire           no. of effects in script         1 *  1,000 zenny              1,000z

attack: 240                                                         for every 100 attack =                   +  5,000 zenny            10,000z

number of slots: 4                                              for every 1 slot =                           +  3,000 zenny            12,000z

weapon level:                                                  for every weapon level=              +  2,000 zenny              8,000z

defense: 10                                                       for every 10 defense  =                 +  1,000 zenny              1,000z 

required level: 160                                            for every 10 required level =        +10,000 zenny          160,000z

applicable jobs: thief,merchant,swordman class   for each job class=              +  5,000 zenny            15,000z

                                                                                                                                                           =============

                                                                                                                                       Total price         212,000z

(note:formula settings must be configurable)

Edited by joelolopez

Recommended Posts

  • 0
Posted

@joelolopez

Just add the remaining item type under the OnInit label.. and duplicate more of the shop npcs ....

 

 

Example 

https://pastebin.com/2MmTzS7X

 

Results :

[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 0 - 433 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 2 - 1071 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 3 - 1970 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 4 - 1123 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 5 - 3456 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 6 - 1107 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 7 - 162 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 8 - 139 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 10 - 208 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 11 - 276 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 18 - 1156 Item(s)

adjust the NPC coordinate yourself.

  • 0
Posted

I agree with anacondaqq lol this isn't something someone will do for free.

nobody will make such big amount of work for free.

And as i see, you provide not enough information (technical details and nuances) related to your system.

ur wrong dude, not all people here in rathena is like what u think... like my master capuche he can make this script no problem lol. im so sorry if u didnt meet any kind people here in rathena like sir capuche..

dude im requesting this script so that all of rathena members (including you) will benefit to my idea and who ever will implement this script

  • 0
Posted

then lets trash this script request section, lets put this request to the paid services section instead, happy? why should i request for a script that so easy to do? so in that case why should i request if i can do it all by myself?

 

No need to act-out so strongly we're open to all kinds of requests, and your request is actually quite thorough. I'm not trying to take sides here but the task at hand isn't completely convoluted. I've done similar scripts in the past with monster hunting systems which used a formula based on your level and grabbed monsters directly from the SQL database while ignoring some of the event ones.

 

 

nobody will make such big amount of work for free.

And as i see, you provide not enough information (technical details and nuances) related to your system.

 

Again no need to criticize his request. I didn't see it before he edited the post but even if it didn't have enough information, contrary to what's there now, it surely would've gone unanswered which is enough in my opinion.

  • 0
Posted

hi i would like to request a mall script that sort out all types of equip for each npcs, and auto price each items

 

Sorry for double post... You might want to consider modifying some of your prices. xD

 

1c3b61a605f2c114f0143d556ab68bb4.gif

  • Upvote 1
  • 0
Posted

Looking interesting :D why all the pots are same prices?

 

They aren't it's just that most consumables are usable by every job so... ~24 * 5k per pot xD.

 

 

they started it @skorm, skorm can i have some a copy of your script?

 

I would but it's actually a mess right now... A functional mess. The way I wanted to do it was to create one npc/shop and duplicate them multiple times for each item type in the database, but for some reason duplicating npcs that access the sql database is causing a memory leak and crashing my mapserver ( The duplicated npc works perfectly ), the system is just unstable. I'm going to have to download a newer version of rAthena and see if this is something that was fixed.

  • 0
Posted

@joelolopez

Just add the remaining item type under the OnInit label.. and duplicate more of the shop npcs ....

 

 

Example 

https://pastebin.com/2MmTzS7X

 

Results :

[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 0 - 433 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 2 - 1071 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 3 - 1970 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 4 - 1123 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 5 - 3456 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 6 - 1107 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 7 - 162 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 8 - 139 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 10 - 208 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 11 - 276 Item(s)
[Debug]: script debug : 0 110023607 : Loaded NPC Shop for Item Type 18 - 1156 Item(s)

adjust the NPC coordinate yourself.

im going to try this after work, thnx @Emistry for the efforts , i really appreciate it a lot

  • 0
Posted
12 hours ago, jackel2013 said:

Can you help me?same here also viewing only jellopy. T_T

 

what do you mean change occurance?i also dont get it?!!!

plz open new post with all the info of your problem to get help faster

  • 0
Posted

here is a slightly updated version...

https://pastebin.com/gwaeHFd4

[Debug]: script debug : 0 110017945 : SQL Mall - HEALING - Loaded 189 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - USABLE - Loaded 594 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - ETC - Loaded 1,533 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - WEAPON - Loaded 605 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - NPC not found - Shop#t_4_12
[Debug]: script debug : 0 110017945 : SQL Mall - ARMOR - Loaded 1,100 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - CARD - Loaded 439 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - PETEGG - Loaded 1 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - PETARMOR - Loaded 1 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - AMMO - Loaded 1 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - DELAYCONSUME - Loaded 1 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - CASH - Loaded 733 Item(s)

 

czcK8of.png

  • remove item with 0 cost
  • auto hide any extra npc (naming dependent)
  • fix some item cost

 

  • 0
Posted
On 9/30/2018 at 4:10 PM, Emistry said:

here is a slightly updated version...

https://pastebin.com/gwaeHFd4


[Debug]: script debug : 0 110017945 : SQL Mall - HEALING - Loaded 189 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - USABLE - Loaded 594 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - ETC - Loaded 1,533 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - WEAPON - Loaded 605 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - NPC not found - Shop#t_4_12
[Debug]: script debug : 0 110017945 : SQL Mall - ARMOR - Loaded 1,100 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - CARD - Loaded 439 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - PETEGG - Loaded 1 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - PETARMOR - Loaded 1 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - AMMO - Loaded 1 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - DELAYCONSUME - Loaded 1 Item(s)
[Debug]: script debug : 0 110017945 : SQL Mall - CASH - Loaded 733 Item(s)

 

czcK8of.png

  • remove item with 0 cost
  • auto hide any extra npc (naming dependent)
  • fix some item cost

 

I think it's even better if a special room is made for the whole NPC, with entrance and exit  ( if possible )

  • 0
Posted
On 3/14/2019 at 11:37 AM, djdsw said:

Can someone help me? even use slightly updated version from this script, I got only jellopy.

you probably didnt import the item_db sql into your database.

  • Love 1
  • 0
Posted (edited)
On 3/28/2019 at 4:39 PM, Emistry said:

you probably didnt import the item_db sql into your database.

Thankyou Emistry for your reply, sorry for my very late. I already import my item_db_re.sql because Im playing renewal. here my sample. Am I doing wrong?

would you please to teach me how to correct import item_db_re sql into my database.. thankyou very much.

Capture.PNG

Edited by dannsatriow

Join the conversation

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

Guest
Answer this question...

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

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...