Create Your Own ItemMall Shop Tutorial

yokohiro

Legendary Battlemage
500 Posts 10 Happy Years
Joined
Jan 24, 2007
Messages
652
Reaction score
324
Small tutorial on how to create your itemmal shop.
enjoy!


item id = id of item

item group = category
2 = costumes
3 = Eidolon
4 = Traveler Items
5 = Gear Improvement
6 = Cosumables
7 = House
8 = Fortune Packs
47 = Daily Limit
49 = Limited Itens

item index = position of item in category
1
2
3

Item num = number of itens purchase

money unit = coin
1 = AP
2 = Bonus Point
3 = Loyalt Point

Point = price of item

Special price = discount of item

Num Limit = number of item purchase (limited item)

Level limit = limit min of level for use item.

Gender = Gender kkkkk
-1 all gender
0 - F
1 - M

Not sell date = proibited sell of a period

sell date = permited of sell
0 = all date


reload_itemmall_db
for reload itemmall


Vídeo demonstration:
You must be registered to see links
 
F

fido67

Banned
Banned
Joined
Sep 4, 2014
Messages
77
Reaction score
2
Hello , I 've follow your video guide but I have a problem : The item doesent appear in my itemmall

You must be registered to see links
Here a screen of the itemmall in game.

You must be registered to see links
Here part 1 of my db tuple

You must be registered to see links
Here part 2 of my db tuple

So why thoses item doesent appear ? I already refresh the db and reboot the server.
 
Y

ybyok123

Initiate Mage
Joined
Jun 8, 2022
Messages
1
Reaction score
0
Can anybody share the newest itemmall.sql please?
 
N

name21

Initiate Mage
Joined
Apr 9, 2023
Messages
4
Reaction score
0
Can anybody share the newest itemmall.sql please?
 

dev91

Newbie Spellweaver
Joined
Sep 5, 2023
Messages
26
Reaction score
11
in database AP = tb_user>pvalues, how bout LP??
 

Quintazon

Newbie Spellweaver
10 Happy Years
Joined
Sep 5, 2013
Messages
26
Reaction score
3
Hi I have been playing around with an itemmall I have been working on to merge some I old ones, adding in missing fields for the old ones. Just curious I did
Code: 
select distinct a.item_group
from itemmall a
and got all of the ones listed here, plus these:
1, 48, 50, 51, 52, 62 and 99

it seems
1=hot items

anyone know what the others are, before i go digging around?

Edit2: I did notice that one of them must be the hot items that have there own list because those are gone since I removed them.

and here's something I just did to get rid of lucky packs but you can probably use it for whatever,

Code: 
delete
from itemmall main
where main.item_id in
(
    select filt.item_id
    from
        (
            select distinct a.item_id, b.itemname
            from itemmall a
            join
            (
                select sub.item_id,sub.itemname
                from powerupitem sub
            ) b
            on
            a.item_id = b.item_id
        ) filt
    where
    filt.itemname like '%Lucky Pack'
)

edit1: also does anyone know what are detail_type and flags are?

edit3: Oooo never mind this scheme is very different.
 
Last edited:
You must log in or register to reply here.