[Release] Shop.dat to SQL for 5065/5095

[Alex06052]

Now idk if someone else has already released this but this should help it be easier for people that are thinking of making a completely new shop.dat and a database that can support it...

How to use it :

Step 1 - Run it
Step 2 - Put Shop.dat in same folder as the exe (i tested on 5065 and 5095 Shop.dats)
Step 3 - Click .dat -> sql
Step 4 - open navicat and run the sql (exe creates cq_goods.sql in current folder)
And there you go....

*note you should edit the table settings to Auto-Increment because '0' is used for ids so that they just automatically update.

[Angellinho]

That`s from a thread I made in 2010 on 4botters. I think is easier to explain how to make it.

Use this guide to can build your own shop
First
1: Your NPC :d :
REPLACE INTO `cq_npc` VALUES ('9999999', '0', '0', 'Spice', '0001', '8020', '-1', '1002', '0421', '0381', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', 'None', '0000', '00', '00', '0000', '01', null);
2: Add into cq_goods :
REPLACE INTO `cq_goods` VALUES ('888880', '9999999', '722022', '1');
REPLACE INTO `cq_goods` VALUES ('888881', '9999999', '722023', '1');
REPLACE INTO `cq_goods` VALUES ('888882', '9999999', '722024', '1');
REPLACE INTO `cq_goods` VALUES ('888883', '9999999', '722025', '1');
REPLACE INTO `cq_goods` VALUES ('888884', '9999999', '722026', '1');
REPLACE INTO `cq_goods` VALUES ('888885', '9999999', '722027', '1');
[The RED numbers is the ID for your Items] [The Orange is the ownerid(NPC ID)]
3: Go to your Game Client into ini folder and open "npc.ini" and there must to add something like that:
[NpcType500]
Name=Spice
SimpleObjID=0211
StandByMotion=999001100
BlazeMotion=999001190
RestMotion=999001101
Effect=relive
ASB=5
ADB=6
FixDir=0
4: Go into the same folder (ini) and open Shop.dat
Edit:
[Header]
Amount=36
Ex: Increase Amount with 1. (If your Amount is 36 put there 37)
After:
[Shop36]
ID=9999999
Name=Spice
Type=1
MoneyType=1 <---put 1 is the pay type for CPs...put 0 for Gold
ItemAmount=6 <---Amout Of Items from Your Own Shop!
Item0=722022
Item1=722023
Item2=722024
Item3=722025
Item4=722026
Item5=722027
Save it(Ctrl + S) And Close
Now your Shop is Created
If you wanna change the price of items...go to cq_itemtype..find the items and change price from "emoney_price" And after change the same from itemtype.dat from ini folder Using an Itemtype Decryptor
5: RESTART YOUR SERVER AND YOUR SHOP IS CREATED

[Alex06052]

Originally Posted by Angellinho

That`s from a thread I made in 2010 on 4botters. I think is easier to explain how to make it.

Yeah, I notice a lot of shop.dat guides but this is basically to make the process of creating the cq_goods.sql 100x easier since you can just dump it.

Instead of going through the gruesome work of doing it item by item..especially once you already edited shop.dat

*Also I released this because i was making a brand new shop.dat from nothing so that i didnt have old / duplicate items in the dat

Erm well embarrassing but there was a problem with the way i had the sql setup it was putting ITEMID where MONEYTPE should be in the sql....it now works properly =\