MapleStory/Gunz Hacks!
Would you like to react to this message? Create an account in a few clicks or log in to continue.
MapleStory/Gunz Hacks!

Hacks For MapleStory(GMS mapleStory or Private Server MapleStory)And Gunz! We Are Really Legit
 
HomeHome  PortalPortal  SearchSearch  Latest imagesLatest images  RegisterRegister  Log inLog in  

 

 [Guide]How To make a Shop Using SQL!

Go down 
AuthorMessage
Admin
Admin



Number of posts : 25
Registration date : 2008-07-08

[Guide]How To make a Shop Using SQL! Empty
PostSubject: [Guide]How To make a Shop Using SQL!   [Guide]How To make a Shop Using SQL! Icon_minitimeSun Aug 03, 2008 9:22 am

I DID NOT MAKE THIS! CREDITS TO FALZER FROM RAGEZONE FORUMS

This is a guide to make custom shop SQL. This guide may seem lame, but... It'll be good if people knew how to make their own Shop SQL. This should be basic knowledge, but some people might not know! Well, without further ado, I present you a guide to make a Shop SQL!

Description

A Shop SQL is a SQL file that will make a NPC sell stuff.

Update Log

This is pretty useless, but this is for people to see how much i update this.

1st Update - Made this Guide
2nd update - Did a Small Edit
3rd Update - Added Bonus Guide for Notepad ++
4th Update - Added New Information by wafles
5th Update - Added FAQ Section
6th Update - Added more Questions to FAQ Section

Requirements

- Notepad or Notepad++ (I would prefer Notepad for beginners)
- Brain (Duh!)
- Knowledge of Searching MapleTip

(Only use Notepad++ IF you understand how to make a Shop SQL fully! This is because you'll need to understand more to use Notepad++)

Also, it would be helpful if you read this guide to. http://forum.ragezone.com/showthread.php?t=442288

Format

This is the format of Shop SQLs.
Code:
INSERT INTO shopitems (shopid, itemid, price, VALUES (, , , ); INSERT INTO shopitems (shopid, itemid, price, position) VALUES (, , , ); INSERT INTO shopitems (shopid, itemid, price, position) VALUES (, , , ); INSERT INTO shops (`shopid`, `npcid`) VALUES (, );

You can alway add this,
Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (, , , );

if you want to add more items to the shop.

New Information!

This is a quote from wafles:
Quote:


Proper sql format actually suggests that you put ` on all non commands.

For example:

SELECT * FROM `databasetable` WHERE `field`='value';

This is correct format.

If you understand this, please tell me. Because I don't...

How to Set Up


Description

This is what a fully completed Shop SQL would look like.
Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122007, 10000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122001, 10000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122003, 10000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122004, 25000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122006, 25000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122002, 40000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122005, 40000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122000, 40000000, Cool;
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2041200, 50000000, 9);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1694, 9201085);

Now... An explanation. Look carefully at this one.
Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122007, 10000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122001, 10000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122003, 10000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122004, 25000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122006, 25000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122002, 40000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122005, 40000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122000, 40000000, Cool;
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2041200, 50000000, 9);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1694, 9201085);

Did you notice how all the 1694 are in this color? That is the Shop ID. Shop IDs are unique ID numbers that cannot be the same as any other shop IDs currently in the database.

Now, pay attention to this one!
Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122007, 10000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122001, 10000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122003, 10000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122004, 25000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122006, 25000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122002, 40000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122005, 40000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122000, 40000000, Cool;
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2041200, 50000000, 9);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1694, 9201085);

Notice the numbers in this color? That is the price of how much the item costs.

Now, this one next!
Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122007, 10000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122001, 10000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122003, 10000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122004, 25000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122006, 25000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122002, 40000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122005, 40000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122000, 40000000, Cool;
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2041200, 50000000, 9);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1694, 9201085);

Did you notice that some numbers were in this color? That is the item ID. The item ID is what the NPC will sell in their shop.

Just two more to look at!

1. This one now!
Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122007, 10000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122001, 10000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122003, 10000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122004, 25000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122006, 25000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122002, 40000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122005, 40000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122000, 40000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2041200, 50000000, 9);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1694, 9201085);

Notice how the numbers at the end are in this color? That is a bit difficult to explain. It shows how the item will appear first. If you already didn't know, the numbers from the top goes "1, 2, 3, 4, 5..."

2. This is the last one!
Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122007, 10000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122001, 10000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122003, 10000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122004, 25000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122006, 25000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122002, 40000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122005, 40000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122000, 40000000, Cool;
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2041200, 50000000, 9);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1694, 9201085);

Notice that? On the number that is this color, that is the NPC ID of what will sell the items. The IDs MUST be correct for the Shop SQL to work. To get some NPC IDs, all you need to do is click here. Then, you just search. Happy Searching~

Easier to Understand Description


This will be more understandable if you did not get what I said at the top.
Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (Shop ID, Item ID, Price, x);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (Shop ID, Item ID, Price, x);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (Shop ID, Item ID, Price, x);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(Shop ID, NPC ID);

Happy?

If you understand up to this point, good for you! XD

Time to Continue...

How to Make a Shop SQL (Finally! o.o)

If you don't know how to make one by this point, scroll up and start learning again. It should be VERY clear of how to make one IF you read and understand what was above.

So... If you still do not know how to make one by now, scroll up and start reading! If you understand everything, continue...

How to Make a SQL

[Notice] Only read this part if you do not know how to make a Notepad file a SQL.

This part is pretty easy. So... Follow these steps.
Code:
1. You must have finished your Shop SQL by now.
1.5. Once you are done, continue reading.
2. Click 'File', then 'Save As'.
3. Then, type in '_________.sql'
3.5. The _________ is where you type in the name for the SQL.
4. Click 'Save' and there you go! You have made a SQL!
Back to top Go down
https://cheaters.forumakers.com
 
[Guide]How To make a Shop Using SQL!
Back to top 
Page 1 of 1
 Similar topics
-
» Artie's guide on hacking MapleStory private servers

Permissions in this forum:You cannot reply to topics in this forum
MapleStory/Gunz Hacks! :: Maplestory PrivateServer Guides/releases-
Jump to: