Jump to content
  • 1

R> Sql Mall


joelolopez

Question


  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/12
  • Last Seen:  

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

Recommended Posts

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  42
  • Topics Per Day:  0.01
  • Content Count:  1096
  • Reputation:   344
  • Joined:  02/26/12
  • Last Seen:  

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.

Link to comment
Share on other sites

  • 0

  • Group:  Developer
  • Topic Count:  48
  • Topics Per Day:  0.01
  • Content Count:  1443
  • Reputation:   337
  • Joined:  10/17/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  33
  • Topics Per Day:  0.01
  • Content Count:  1268
  • Reputation:   381
  • Joined:  02/03/12
  • Last Seen:  

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.

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  33
  • Topics Per Day:  0.01
  • Content Count:  1268
  • Reputation:   381
  • Joined:  02/03/12
  • Last Seen:  

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

  • 0

  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  383
  • Reputation:   121
  • Joined:  03/31/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/12
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  33
  • Topics Per Day:  0.01
  • Content Count:  1268
  • Reputation:   381
  • Joined:  02/03/12
  • Last Seen:  

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.

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

you can try something like this .

https://pastebin.com/2MmTzS7X

 

* make sure you have all the correspond data for each item_db ( SQL Tables)

 

K9yLmXB.jpg

  • Upvote 2
Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  33
  • Topics Per Day:  0.01
  • Content Count:  1268
  • Reputation:   381
  • Joined:  02/03/12
  • Last Seen:  

you can try something like this .

https://pastebin.com/2MmTzS7X

 

Quite elegant. +1

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/12
  • Last Seen:  

@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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/12
  • Last Seen:  

@Emistry thank you for making this script +1

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/12
  • Last Seen:  

@Emistry , im having trouble renameing these npcs how can i make each npcs name uniques to each other? when i rename it all items inside the npc are gone

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

Shop#type_

change all occurrance to whatever you want.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/12
  • Last Seen:  

Shop#type_

change all occurrance to whatever you want.

 

i dont get it, can u atleast give an example 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  38
  • Reputation:   0
  • Joined:  11/18/12
  • Last Seen:  

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

 

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

Edited by jackel2013
Link to comment
Share on other sites

  • 0

  • Group:  Content Moderator
  • Topic Count:  55
  • Topics Per Day:  0.02
  • Content Count:  1676
  • Reputation:   702
  • Joined:  12/21/14
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  38
  • Reputation:   0
  • Joined:  11/18/12
  • Last Seen:  

I just use the script from the owner. I didnt change anything and when i loaded it only jelopies aee seen each npcs

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  23
  • Topics Per Day:  0.01
  • Content Count:  116
  • Reputation:   18
  • Joined:  09/08/17
  • Last Seen:  

If anyone has made a more stable version, would gladly pay for this one actually.

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

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

 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  14
  • Reputation:   0
  • Joined:  01/12/17
  • Last Seen:  

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 )

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  1
  • Reputation:   0
  • Joined:  03/05/19
  • Last Seen:  

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

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10013
  • Reputation:   2345
  • Joined:  10/28/11
  • Last Seen:  

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

  • 0

  • Group:  Members
  • Topic Count:  2
  • Topics Per Day:  0.00
  • Content Count:  13
  • Reputation:   0
  • Joined:  08/01/18
  • Last Seen:  

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

  • 0

  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  38
  • Reputation:   0
  • Joined:  11/18/12
  • Last Seen:  

Hi is there any updated version that work on 2022 emulators work for yaml project?

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

×
×
  • Create New...