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]

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

[joelolopez]

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

Edited October 7, 2016 by joelolopez

[joelolopez]

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?

Edited October 8, 2016 by joelolopez

[joelolopez]

you can try something like this .

https://pastebin.com/2MmTzS7X

 

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

 

Emistry i m going to try this..

you can try something like this .

https://pastebin.com/2MmTzS7X

 

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

 

i ddnt see any card shop generated from these npcs.. i got jellopy most of these npcs