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:  10015
  • Reputation:   2361
  • Joined:  10/28/11
  • Last Seen:  

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. 

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:  

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

image.thumb.png.7f7cfd3ef6b5be42d64ee203b8bd73d5.png

and this is your SQL v1

image.thumb.png.d4a122c8fa2d41c591eb8c98dac218ee.png

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

image.thumb.png.41c21c64de296a586404576068e73590.png

and syntax are now different

image.thumb.png.59b306a41cc32348a2beb6f795966f21.png

 

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

image.thumb.png.34daa894d43e5c71495b4ea5722dab02.png

 

now i got tihs with the v1.4 master emistry
image.thumb.png.6edc757c8e6d2f23d2f70daa59c29c82.png

all the wayto here
image.thumb.png.ee7630c3ccdadec9024722b25c253cb0.png

and ends with this 1

image.thumb.png.4c7b700d649e50edfac423e9cf4fed1b.png

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

 

Link to comment
Share on other sites

  • 0

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

Another updated version to cover most of the renewal items.

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

q7SshO8.png

 

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

- added shadow gear category

- fix newer sql db structure, and script commands

Edited by Emistry
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:  

20 hours ago, Emistry said:

Another updated version to cover most of the renewal items.

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

q7SshO8.png

 

- 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

image.thumb.png.a7fe0bbce52f5717456360430286c54c.png

 

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

  • -1

  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/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.

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

  • -1

  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/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?

Edited by joelolopez
Link to comment
Share on other sites

  • -1

  • Group:  Members
  • Topic Count:  154
  • Topics Per Day:  0.03
  • Content Count:  493
  • Reputation:   46
  • Joined:  01/24/12
  • 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

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)

 

K9yLmXB.jpg

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

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