R> Sql Mall

[joelolopez]

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: 4                                                  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 October 6, 2016 by joelolopez

[Emistry]

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.

[dannsatriow]

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.

Edited September 9, 2019 by dannsatriow

[jackel2013]

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

[Emistry]

9 hours ago, jackel2013 said:

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

it read your SQL database, not YAML, as long as you keep your SQL table data updated, then it should work fine. 

[jackel2013]

hello master emistry, seems theres some missing codes for the SQL V1.4 script. seems not working and where ion the script where you add the onLOAD on mention on previous replies?.  do you have a complete update? where onload is part of it. please ^^ not a coder much just a simple knowledge where i can understand a little on scirpt. also seems my syntax on the sql files is different on the syntax on script example 'atk' on the scpit but on sql is attack. so it wont read. thanks in advance

this is your sql v1.4

and this is your SQL v1

i think theres need more modif since on yml sq items are been separated files

and syntax are now different

 

i had followed the syntax error and might fixed but this is where i dont understand nowT_T

 

now i got tihs with the v1.4 master emistry

all the wayto here

and ends with this 1

i worked all night but nothing comes in my mind T_T

 

On 10/18/2022 at 12:30 AM, Emistry said:

it read your SQL database, not YAML, as long as you keep your SQL table data updated, then it should work fine. 

Master emistry? hope you can help me

 

[Emistry]

Another updated version to cover most of the renewal items.

https://pastebin.com/0FR1BaMT (v1.5)

 

- added more npc to cover all the new items released.

- added shadow gear category

- fix newer sql db structure, and script commands

Edited October 22, 2022 by Emistry

[jackel2013]

20 hours ago, Emistry said:

Another updated version to cover most of the renewal items.

https://pastebin.com/0FR1BaMT (v1.5)

 

- added more npc to cover all the new items released.

- added shadow gear category

- fix newer sql db structure, and script commands

TY master emistry ill study and try this one. and this are the results i have

 

So , 
*Only showing armos and shadows (shop5-9) is empty
*I dnt have NPC for the wepons
*No etc items
*NPC pet shops showing but empty

Thnks master emisty for the updates

 

Edited October 23, 2022 by jackel2013