- Joined
- Sep 6, 2007
- Messages
- 10
- Reaction score
- 0
Each new version of L2J, or when we want to change the style or the prices of all items of a server L2j the admins have to rebuild their shops.
It is a list quite large, and substantial work redo all shops.
I would like someone with that provision and understand about SQL programming or make a query or a code that makes these shops an easy way.
A good system, it would be more or less like this:
mysql querys to make:
G = Grade [no grade][d grade][c grade][b grade][a grade][s grade][s80 grade]
T = Tpe [weapon][armor][jewel]
P = Multipliquer Price of buy (comparate with shell price) [VALUE]
B = Buylist [number]
O = Order [decreasing][growing]
X = Power or Magic Atk or Def [patk][matk][pdef][mdef]
G Grade T Shop with valor of buy P biggest of the shell price in a B buylist in order by O of X
Exemples:
PS: x = buylist number
No Grade weapons Shop with valor of buy 2x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
D Grade weapons Shop with valor of buy 4x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
C Grade weapons Shop with valor of buy 6x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
B Grade weapons Shop with valor of buy 12x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
A Grade weapons Shop with valor of buy 24x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
S Grade weapons Shop with valor of buy 48x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
S80 Grade weapons Shop with valor of buy 96x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
No Grade armor Shop with valor of buy 2x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
D Grade armor Shop with valor of buy 4x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
C Grade armor Shop with valor of buy 6x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
B Grade armor Shop with valor of buy 12x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
A Grade armor Shop with valor of buy 24x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
S Grade armor Shop with valor of buy 48x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
S80 Grade armor Shop with valor of buy 96x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
No Grade jewel Shop with valor of buy 2x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
D Grade jewel Shop with valor of buy 4x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
C Grade jewel Shop with valor of buy 6x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
B Grade jewel Shop with valor of buy 12x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
A Grade jewel Shop with valor of buy 24x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
S Grade jewel Shop with valor of buy 48x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
S80 Grade jewel Shop with valor of buy 96x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
This would be very useful for all admins and developers around the world, we would be very grateful, especially me. THANK YOU VERY!
ps: sorry for my bad english
It is a list quite large, and substantial work redo all shops.
I would like someone with that provision and understand about SQL programming or make a query or a code that makes these shops an easy way.
A good system, it would be more or less like this:
mysql querys to make:
G = Grade [no grade][d grade][c grade][b grade][a grade][s grade][s80 grade]
T = Tpe [weapon][armor][jewel]
P = Multipliquer Price of buy (comparate with shell price) [VALUE]
B = Buylist [number]
O = Order [decreasing][growing]
X = Power or Magic Atk or Def [patk][matk][pdef][mdef]
G Grade T Shop with valor of buy P biggest of the shell price in a B buylist in order by O of X
Exemples:
PS: x = buylist number
No Grade weapons Shop with valor of buy 2x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
D Grade weapons Shop with valor of buy 4x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
C Grade weapons Shop with valor of buy 6x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
B Grade weapons Shop with valor of buy 12x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
A Grade weapons Shop with valor of buy 24x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
S Grade weapons Shop with valor of buy 48x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
S80 Grade weapons Shop with valor of buy 96x biggest of the shell price in a "X" buylist in order by biggest p.atk or m.atk.
No Grade armor Shop with valor of buy 2x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
D Grade armor Shop with valor of buy 4x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
C Grade armor Shop with valor of buy 6x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
B Grade armor Shop with valor of buy 12x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
A Grade armor Shop with valor of buy 24x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
S Grade armor Shop with valor of buy 48x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
S80 Grade armor Shop with valor of buy 96x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
No Grade jewel Shop with valor of buy 2x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
D Grade jewel Shop with valor of buy 4x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
C Grade jewel Shop with valor of buy 6x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
B Grade jewel Shop with valor of buy 12x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
A Grade jewel Shop with valor of buy 24x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
S Grade jewel Shop with valor of buy 48x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
S80 Grade jewel Shop with valor of buy 96x biggest of the shell price in a "X" buylist in order by biggest p.def or m.def
This would be very useful for all admins and developers around the world, we would be very grateful, especially me. THANK YOU VERY!
ps: sorry for my bad english
