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

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.


[Only registered and activated users can see links. Click Here To Register...]

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

Quote:

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

[Only registered and activated users can see links. Click Here To Register...]

Quote:

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 =\