fiction
New member
Hello,
Who can help me with an npc that restrict all the mvp cards in a certain map.
I have an idea with the sql, but i don't know how to do it more perfectly.
This is that i'm looking for:
If a player enter in the map that is restricted a message will appear informing that the mvp cards isn't allowed.
.mvpcards = query_sql("select item_db.id from item_db right join mob_db on item_db.id = mob_db.dropcardid where mexp > 0 and type = 6 group by name_japanese;", .idmvpcard);
Greetings.- !
Who can help me with an npc that restrict all the mvp cards in a certain map.
I have an idea with the sql, but i don't know how to do it more perfectly.
This is that i'm looking for:
If a player enter in the map that is restricted a message will appear informing that the mvp cards isn't allowed.
.mvpcards = query_sql("select item_db.id from item_db right join mob_db on item_db.id = mob_db.dropcardid where mexp > 0 and type = 6 group by name_japanese;", .idmvpcard);
Greetings.- !