Create Your Own ItemMall Shop Tutorial

[yokohiro]

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:

To view the content, you need to sign in or register

 

[yokohiro]

any have ID's for all category? send me please.

ty.

 

[fido67]

Hello , I 've follow your video guide but I have a problem : The item doesent appear in my itemmall

To view the content, you need to sign in or register

Here a screen of the itemmall in game.

To view the content, you need to sign in or register

Here part 1 of my db tuple

To view the content, you need to sign in or register

Here part 2 of my db tuple

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

 

[joemamafat]

did u fix this problem?

 

[itachi77]

did u fix this problem?

You are using money type 3 ("Loyalty id coin 3") so it gonna show in Loyalty shop.

 

[ybyok123]

Can anybody share the newest itemmall.sql please?

 

[name21]

Can anybody share the newest itemmall.sql please?

 

[Quintazon]

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

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,

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.