[How2] Create a Market [EASY]

Nove240 · 08/06/2019, 00:17

Nulled.

Dark Blaze · 08/06/2019, 11:07

lol

Nove240 · 08/06/2019, 17:43

Quote:

Originally Posted by Dark Blaze

lol

I know there is a soft but , this soft don't work in my computer so ^^

InkDevil · 08/06/2019, 18:29

Quote:

Originally Posted by Nove240

I know there is a soft but , this soft don't work in my computer so ^^

It contains everything you need, yes.
(Sort_id is btw the sequence of displayed items in market ingame, lowest number of market-name comes first, highest last slot)
But it would be a bit more useful if you could make ... well, for example an insert-query with explanation.

Your thread miss' where the basic prices come from.
(price, huntaholic_point, arena_point in ItemResource)
The fitting ratio in MarketResource is a multiplier.

I don't want to talk bad about your thread, it's nice when someone explains such things for people who don't know these things yet.

Just wanted to make some additions/suggestions

Nove240 · 08/07/2019, 00:45

Quote:

Originally Posted by InkDevil

It contains everything you need, yes.
(Sort_id is btw the sequence of displayed items in market ingame, lowest number of market-name comes first, highest last slot)
But it would be a bit more useful if you could make ... well, for example an insert-query with explanation.

Your thread miss' where the basic prices come from.
(price, huntaholic_point, arena_point in ItemResource)
The fitting ratio in MarketResource is a multiplier.

I don't want to talk bad about your thread, it's nice when someone explains such things for people who don't know these things yet.
Just wanted to make some additions/suggestions

I will add some thing

I have add some thing

SilentWisdom · 08/09/2019, 04:50

Code:

select i.[id], s.[value] as name, i.[price], i.[huntaholic_point], i.[arena_point] from dbo.ItemResource i
left join dbo.StringResource s on s.code = i.id
where s.[value] = '' /* (Complete match) */ or s.[value] LIKE '%%' /* (Partial match)*/ or  i.[id] = 1234567

This might help you all find your item prices a bit easier.

rebelknight · 04/03/2020, 01:22

um im lost here were do I find all this? in Telecaster? if not then what file ?

is it were I have my lua files? if so I don't see it there

Dark Blaze · 04/03/2020, 04:15

Quote:

Originally Posted by rebelknight

um im lost here were do I find all this? in Telecaster? if not then what file ?

is it were I have my lua files? if so I don't see it there

dbo.MarketResource table is in Arcadia database.

rebelknight · 04/03/2020, 05:23

Quote:

Originally Posted by Dark Blaze

dbo.MarketResource table is in Arcadia database.

ty for letting me know I looked into it but the stamina saver is not there
here is what it shows me

1 rental_shop_weapon_rank7 700000789 0.000 0.000 0.000
2 rental_shop_weapon_rank7 700000790 0.000 0.000 0.000
3 rental_shop_weapon_rank7 700000791 0.000 0.000 0.000
4 rental_shop_weapon_rank7 700000792 0.000 0.000 0.000
5 rental_shop_weapon_rank7 700000793 0.000 0.000 0.000
6 rental_shop_weapon_rank7 700000794 0.000 0.000 0.000
7 rental_shop_weapon_rank7 700000795 0.000 0.000 0.000
8 rental_shop_weapon_rank7 700000796 0.000 0.000 0.000
9 rental_shop_weapon_rank7 700000797 0.000 0.000 0.000
10 rental_shop_weapon_rank7 700000798 0.000 0.000 0.000
11 rental_shop_weapon_rank7 700000799 0.000 0.000 0.000
12 rental_shop_weapon_rank7 700000800 0.000 0.000 0.000
13 rental_shop_weapon_rank7 700000801 0.000 0.000 0.000
14 rental_shop_weapon_rank7 700000802 0.000 0.000 0.000
15 rental_shop_weapon_rank7 700000750 0.000 0.000 0.000
16 rental_shop_weapon_rank7 700000754 0.000 0.000 0.000
17 rental_shop_weapon_rank7 700000749 0.000 0.000 0.000
18 rental_shop_weapon_rank7 700000748 0.000 0.000 0.000
19 rental_shop_weapon_rank7 700000756 0.000 0.000 0.000
20 rental_shop_weapon_rank7 700000747 0.000 0.000 0.000
21 rental_shop_weapon_rank7 700000757 0.000 0.000 0.000
22 rental_shop_weapon_rank7 700000758 0.000 0.000 0.000
23 rental_shop_weapon_rank7 700000755 0.000 0.000 0.000
24 rental_shop_weapon_rank7 700000752 0.000 0.000 0.000
25 rental_shop_weapon_rank7 700000751 0.000 0.000 0.000
26 rental_shop_weapon_rank7 700000753 0.000 0.000 0.000
27 rental_shop_weapon_rank7 700000759 0.000 0.000 0.000
28 rental_shop_weapon_rank7 700000760 0.000 0.000 0.000
29 rental_shop_weapon_rank6 700000721 0.000 0.000 0.000
30 rental_shop_weapon_rank6 700000722 0.000 0.000 0.000
31 rental_shop_weapon_rank6 700000723 0.000 0.000 0.000
32 rental_shop_weapon_rank6 700000724 0.000 0.000 0.000
33 rental_shop_weapon_rank6 700000725 0.000 0.000 0.000
34 rental_shop_weapon_rank6 700000726 0.000 0.000 0.000
35 rental_shop_weapon_rank6 700000727 0.000 0.000 0.000
36 rental_shop_weapon_rank6 700000728 0.000 0.000 0.000
37 rental_shop_weapon_rank6 700000729 0.000 0.000 0.000
38 rental_shop_weapon_rank6 700000730 0.000 0.000 0.000
39 rental_shop_weapon_rank6 700000731 0.000 0.000 0.000
40 rental_shop_weapon_rank6 700000732 0.000 0.000 0.000
41 rental_shop_weapon_rank6 700000745 0.000 0.000 0.000
42 rental_shop_weapon_rank6 700000746 0.000 0.000 0.000
43 rental_shop_weapon_rank5 700000695 0.000 0.000 0.000
44 rental_shop_weapon_rank5 700000707 0.000 0.000 0.000
45 rental_shop_weapon_rank5 700000696 0.000 0.000 0.000
46 rental_shop_weapon_rank5 700000708 0.000 0.000 0.000
47 rental_shop_weapon_rank5 700000697 0.000 0.000 0.000
48 rental_shop_weapon_rank5 700000709 0.000 0.000 0.000
49 rental_shop_weapon_rank5 700000698 0.000 0.000 0.000
50 rental_shop_weapon_rank5 700000710 0.000 0.000 0.000
51 rental_shop_weapon_rank5 700000699 0.000 0.000 0.000
52 rental_shop_weapon_rank5 700000711 0.000 0.000 0.000
53 rental_shop_weapon_rank5 700000700 0.000 0.000 0.000
54 rental_shop_weapon_rank5 700000712 0.000 0.000 0.000
55 rental_shop_weapon_rank5 700000701 0.000 0.000 0.000
56 rental_shop_weapon_rank5 700000713 0.000 0.000 0.000
57 rental_shop_weapon_rank5 700000702 0.000 0.000 0.000
58 rental_shop_weapon_rank5 700000714 0.000 0.000 0.000
59 rental_shop_weapon_rank5 700000703 0.000 0.000 0.000
60 rental_shop_weapon_rank5 700000715 0.000 0.000 0.000
61 rental_shop_weapon_rank5 700000704 0.000 0.000 0.000
62 rental_shop_weapon_rank5 700000716 0.000 0.000 0.000
63 rental_shop_weapon_rank5 700000705 0.000 0.000 0.000
64 rental_shop_weapon_rank5 700000717 0.000 0.000 0.000
65 rental_shop_weapon_rank5 700000706 0.000 0.000 0.000
66 rental_shop_weapon_rank5 700000718 0.000 0.000 0.000
67 rental_shop_weapon_rank5 700000719 0.000 0.000 0.000
68 rental_shop_weapon_rank5 700000720 0.000 0.000 0.000
69 rental_shop_weapon_rank4 700000681 0.000 0.000 0.000
70 rental_shop_weapon_rank4 700000682 0.000 0.000 0.000
71 rental_shop_weapon_rank4 700000683 0.000 0.000 0.000
72 rental_shop_weapon_rank4 700000684 0.000 0.000 0.000
73 rental_shop_weapon_rank4 700000685 0.000 0.000 0.000
74 rental_shop_weapon_rank4 700000686 0.000 0.000 0.000
75 rental_shop_weapon_rank4 700000687 0.000 0.000 0.000
76 rental_shop_weapon_rank4 700000688 0.000 0.000 0.000
77 rental_shop_weapon_rank4 700000689 0.000 0.000 0.000
78 rental_shop_weapon_rank4 700000690 0.000 0.000 0.000
79 rental_shop_weapon_rank4 700000691 0.000 0.000 0.000
80 rental_shop_weapon_rank4 700000692 0.000 0.000 0.000
81 rental_shop_weapon_rank4 700000693 0.000 0.000 0.000
82 rental_shop_weapon_rank4 700000694 0.000 0.000 0.000
83 rental_shop_weapon_rank3 700000667 0.000 0.000 0.000
84 rental_shop_weapon_rank3 700000668 0.000 0.000 0.000
85 rental_shop_weapon_rank3 700000669 0.000 0.000 0.000
86 rental_shop_weapon_rank3 700000670 0.000 0.000 0.000
87 rental_shop_weapon_rank3 700000671 0.000 0.000 0.000
88 rental_shop_weapon_rank3 700000672 0.000 0.000 0.000
89 rental_shop_weapon_rank3 700000673 0.000 0.000 0.000
90 rental_shop_weapon_rank3 700000674 0.000 0.000 0.000
91 rental_shop_weapon_rank3 700000675 0.000 0.000 0.000
92 rental_shop_weapon_rank3 700000676 0.000 0.000 0.000
93 rental_shop_weapon_rank3 700000677 0.000 0.000 0.000
94 rental_shop_weapon_rank3 700000678 0.000 0.000 0.000
95 rental_shop_weapon_rank3 700000679 0.000 0.000 0.000
96 rental_shop_weapon_rank3 700000680 0.000 0.000 0.000
97 rental_shop_weapon_rank2 700000653 0.000 0.000 0.000
98 rental_shop_weapon_rank2 700000654 0.000 0.000 0.000
99 rental_shop_weapon_rank2 700000655 0.000 0.000 0.000
100 rental_shop_weapon_rank2 700000656 0.000 0.000 0.000
101 rental_shop_weapon_rank2 700000657 0.000 0.000 0.000
102 rental_shop_weapon_rank2 700000658 0.000 0.000 0.000
103 rental_shop_weapon_rank2 700000659 0.000 0.000 0.000
104 rental_shop_weapon_rank2 700000660 0.000 0.000 0.000
105 rental_shop_weapon_rank2 700000661 0.000 0.000 0.000
106 rental_shop_weapon_rank2 700000662 0.000 0.000 0.000
107 rental_shop_weapon_rank2 700000663 0.000 0.000 0.000
108 rental_shop_weapon_rank2 700000664 0.000 0.000 0.000
109 rental_shop_weapon_rank2 700000665 0.000 0.000 0.000
110 rental_shop_weapon_rank2 700000666 0.000 0.000 0.000
111 rental_shop_armor_rank7 700000803 0.000 0.000 0.000
112 rental_shop_armor_rank7 700000804 0.000 0.000 0.000
113 rental_shop_armor_rank7 700000805 0.000 0.000 0.000
114 rental_shop_armor_rank7 700000806 0.000 0.000 0.000
115 rental_shop_armor_rank7 700000811 0.000 0.000 0.000
116 rental_shop_armor_rank7 700000812 0.000 0.000 0.000
117 rental_shop_armor_rank7 700000813 0.000 0.000 0.000
118 rental_shop_armor_rank7 700000814 0.000 0.000 0.000
119 rental_shop_armor_rank7 700000807 0.000 0.000 0.000
120 rental_shop_armor_rank7 700000808 0.000 0.000 0.000
121 rental_shop_armor_rank7 700000809 0.000 0.000 0.000
122 rental_shop_armor_rank7 700000810 0.000 0.000 0.000
123 rental_shop_armor_rank7 700000641 0.000 0.000 0.000
124 rental_shop_armor_rank7 700000642 0.000 0.000 0.000
125 rental_shop_armor_rank7 700000643 0.000 0.000 0.000
126 rental_shop_armor_rank7 700000644 0.000 0.000 0.000
127 rental_shop_armor_rank7 700000649 0.000 0.000 0.000
128 rental_shop_armor_rank7 700000650 0.000 0.000 0.000
129 rental_shop_armor_rank7 700000651 0.000 0.000 0.000
130 rental_shop_armor_rank7 700000652 0.000 0.000 0.000
131 rental_shop_armor_rank7 700000645 0.000 0.000 0.000
132 rental_shop_armor_rank7 700000646 0.000 0.000 0.000
133 rental_shop_armor_rank7 700000647 0.000 0.000 0.000
134 rental_shop_armor_rank7 700000648 0.000 0.000 0.000
135 rental_shop_armor_rank6 700000635 0.000 0.000 0.000
136 rental_shop_armor_rank6 700000636 0.000 0.000 0.000
137 rental_shop_armor_rank6 700000637 0.000 0.000 0.000
138 rental_shop_armor_rank6 700000638 0.000 0.000 0.000
139 rental_shop_armor_rank6 700000640 0.000 0.000 0.000
140 rental_shop_armor_rank6 700000639 0.000 0.000 0.000
141 rental_shop_armor_rank5 700000629 0.000 0.000 0.000
142 rental_shop_armor_rank5 700000630 0.000 0.000 0.000
143 rental_shop_armor_rank5 700000631 0.000 0.000 0.000
144 rental_shop_armor_rank5 700000632 0.000 0.000 0.000
145 rental_shop_armor_rank5 700000634 0.000 0.000 0.000
146 rental_shop_armor_rank5 700000633 0.000 0.000 0.000
147 rental_shop_armor_rank4 700000615 0.000 0.000 0.000
148 rental_shop_armor_rank4 700000619 0.000 0.000 0.000
149 rental_shop_armor_rank4 700000623 0.000 0.000 0.000
150 rental_shop_armor_rank4 700000616 0.000 0.000 0.000
151 rental_shop_armor_rank4 700000620 0.000 0.000 0.000
152 rental_shop_armor_rank4 700000624 0.000 0.000 0.000
153 rental_shop_armor_rank4 700000617 0.000 0.000 0.000
154 rental_shop_armor_rank4 700000621 0.000 0.000 0.000
155 rental_shop_armor_rank4 700000625 0.000 0.000 0.000
156 rental_shop_armor_rank4 700000618 0.000 0.000 0.000
157 rental_shop_armor_rank4 700000622 0.000 0.000 0.000
158 rental_shop_armor_rank4 700000626 0.000 0.000 0.000
159 rental_shop_armor_rank4 700000628 0.000 0.000 0.000
160 rental_shop_armor_rank4 700000627 0.000 0.000 0.000
161 rental_shop_armor_rank3 700000601 0.000 0.000 0.000
162 rental_shop_armor_rank3 700000605 0.000 0.000 0.000
163 rental_shop_armor_rank3 700000609 0.000 0.000 0.000
164 rental_shop_armor_rank3 700000602 0.000 0.000 0.000
165 rental_shop_armor_rank3 700000606 0.000 0.000 0.000
166 rental_shop_armor_rank3 700000610 0.000 0.000 0.000
167 rental_shop_armor_rank3 700000603 0.000 0.000 0.000
168 rental_shop_armor_rank3 700000607 0.000 0.000 0.000
169 rental_shop_armor_rank3 700000611 0.000 0.000 0.000
170 rental_shop_armor_rank3 700000604 0.000 0.000 0.000
171 rental_shop_armor_rank3 700000608 0.000 0.000 0.000
172 rental_shop_armor_rank3 700000612 0.000 0.000 0.000
173 rental_shop_armor_rank3 700000614 0.000 0.000 0.000
174 rental_shop_armor_rank3 700000613 0.000 0.000 0.000
175 rental_shop_armor_rank2 700000587 0.000 0.000 0.000
176 rental_shop_armor_rank2 700000591 0.000 0.000 0.000
177 rental_shop_armor_rank2 700000595 0.000 0.000 0.000
178 rental_shop_armor_rank2 700000588 0.000 0.000 0.000
179 rental_shop_armor_rank2 700000592 0.000 0.000 0.000
180 rental_shop_armor_rank2 700000596 0.000 0.000 0.000
181 rental_shop_armor_rank2 700000589 0.000 0.000 0.000
182 rental_shop_armor_rank2 700000593 0.000 0.000 0.000
183 rental_shop_armor_rank2 700000597 0.000 0.000 0.000
184 rental_shop_armor_rank2 700000590 0.000 0.000 0.000
185 rental_shop_armor_rank2 700000594 0.000 0.000 0.000
186 rental_shop_armor_rank2 700000598 0.000 0.000 0.000
187 rental_shop_armor_rank2 700000600 0.000 0.000 0.000
188 rental_shop_armor_rank2 700000599 0.000 0.000 0.000
189 crushop_Newequip_helm_7rank 221710801 0.750 0.000 0.000
190 crushop_Newequip_helm_7rank 221710802 0.750 0.000 0.000
191 crushop_Newequip_helm_7rank 221710803 0.750 0.000 0.000
192 crushop_Newequip_helm_7rank 221710804 0.750 0.000 0.000
193 crushop_Newequip_helm_7rank 221710805 0.750 0.000 0.000
194 crushop_Newequip_helm_7rank 221710806 0.750 0.000 0.000
195 crushop_Newequip_helm_7rank 221710807 0.750 0.000 0.000
196 crushop_Newequip_helm_7rank 221710808 0.750 0.000 0.000
197 crushop_Newequip_helm_7rank 221720801 0.750 0.000 0.000
198 crushop_Newequip_helm_7rank 221720802 0.750 0.000 0.000
199 crushop_Newequip_helm_7rank 221720803 0.750 0.000 0.000
200 crushop_Newequip_helm_7rank 221720804 0.750 0.000 0.000

sorry for long post but im still very new to all this

the id I get from gm tool is 90000000 as stamina saver

I personally don't know what all this means

ThunderNikk · 04/03/2020, 13:38

Your row selection or edit commands are limited in your SQL server.

If you open that up you will see more items...

It can also be easier to enter an SQL query to narrow things down a little bit...

Select new query from the menu bar at the top of server management studio and paste the following into the window. Then hit execute query. (I Hope it is right for the column name I am not in front of my database stuff right now)

Code:

Select * From arcadia.dbo.itemresource where icon_file_name like '%crushop%'

This will return most of the cash shop items from your item resource so you can look at and verify IDs

And Stamina Saver most certainly already is in your market resource somewhere under the crushop stuff because it is available for the test servers, but a standard server will not have NPCs available that are opening those markets.

rebelknight · 04/03/2020, 17:24

I found the id for stamina saver but how do I change it ?
sort_id name code price_ratio huntaholic_ratio arena_ratio
1 market_consumable_alu 900000 75.000 0.000 0.000

it wont let me change it for some reason and im not sure what price ratio has to do with amount of rupee

I did select 1000 rows and found it there

ThunderNikk · 04/03/2020, 17:42

You wont be able to edit in a select statement.

You will have to run an update statement to update a row in SQL

Like

Update dbo.marketresource set price_ratio = 25.000 where code = 900000

Depending on what you actually want to update.

Ink explains where price comes from in Item Resource above...

Basically the ratio in market resource is a percentage ratio of price in item resource.

rebelknight · 04/03/2020, 19:40

im just gonna leave it the way it is I don't know how to do any of this : (

i don't wanna mess it up or anything

can someone help me using teamview I will watch how its done like to 3 times Im sure ill get it

or guide me using discord video call

any 1 able to please help me using team viewer it would be easier couse if I have any qustions I can just ask while its being done and guide me with it plz any one?

or use discord video call

MrXY89 · 04/04/2020, 21:36

If you want to use Management Studio to modify the MarketResource table eg GUI interface. There is a way.

Don't run this unless your aware of what it is doing!

In short it will create a new table called "MarketResourceDB" with a ID column as a primary key. The sql code will copy all the data from "MarketResource" to "MarketResourceDB". It will then drop your "MarketResource" table and create a view so rappelz can still read the data.

Now Studio Management or any web interface will be able to make modifications to rows based on a ID column and not a specific item id.

Epic 7.2 ->

Epic 9.5.2 - Should work with below epics ->

Nove240 · 04/14/2020, 00:23

hm