[Release!]Orcrist's 1 Meso MAPLE SHOP!

Newbie Spellweaver
Joined
Sep 8, 2008
Messages
32
Reaction score
0
Hey! This is my 1st EVAR shop! And if some one could test this on a server for me that'd be awsome... O yeah you might need to make it in a MYSQLS 1st... Also, if it doesn't work please tell me what I did wrong... This is my 1st evar shop! Thanks any BAI Please tell me if anything is wrong!

I guess i did somthing wrong. Now how would i fix this?

Code:
 INSERT INTO shops ( shopid, npcid ) VALUES ( 9201003, 9201003 ); --Mom and Dad (Amoria: Meet the Parents) (Made by Orcrist)
cm.sendYesNo("Hey! You! Yeah you... Do you wanna vist the BEST EVAR 1 Meso Maple shop? Then CLICK YES! What are you waiting for DO IT. This Shop was made by Orcrist of Ragezone and CEF =) Oh yeah mister Admin person... you can take that out..");
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1032040, 1, 1);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1032041, 1, 2);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1032042, 1, 3);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002508, 1, 4);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002509, 1, 5);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002510, 1, 6);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002511, 1, 7);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002513, 1, 8);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002515, 1, 9);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002516, 1, 10);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002517, 1, 11);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002518, 1, 12);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002600, 1, 13);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002601, 1, 14);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002602, 1, 15);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002603, 1, 16);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002717, 1, 17);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092030, 1, 18);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092045, 1, 19);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092046, 1, 20);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092047, 1, 21);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302020, 1, 22);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302030, 1, 23);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302033, 1, 24);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302064, 1, 25);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302080, 1, 26);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1332025, 1, 27);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1332055, 1, 28);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1332056, 1, 29);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1372034, 1, 30);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1382009, 1, 31);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1382012, 1, 32);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1382039, 1, 33);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1402039, 1, 34);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1312032, 1, 35);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1412011, 1, 36);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1412027, 1, 37);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1422014, 1, 38);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1422029, 1, 39);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1432012, 1, 40);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1432040, 1, 41);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1442024, 1, 42);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1442030, 1, 43);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1442051, 1, 44);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1452016, 1, 45);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1452022, 1, 46);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1452045, 1, 47);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1462014, 1, 48);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1462019, 1, 49);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1462040, 1, 50);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1472030, 1, 51);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1472032, 1, 52);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1472055, 1, 53);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1702132, 1, 54);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1702140, 1, 55);
cm.dispose(Thank You for visting Orcrist's 1 Mesos Maple shop! With 55 items :D Hope to see you soon in one of my other shops!);
 

Attachments

:D It took me like 15 mins to make... But its my 1st one and it has 55 items of just maple items! Can some one test it out for me? And post a sceenie if it works cuz i can't test it... I dunu how to make a server...
 
Yeah.. I would post sceenies but i havn't got a server to test it on =( And i know there were alot out but i just wanted to start with somthing simple XD
 
1 mesos shops are very easy to make. Just find a EVERYTHING SQL script and then run one MySQL script and bam you got yourself a 1 mesos shop.
Rules are that you have to test things before posting
 
lol not to bash or anything but how is it you can make a NPC but not a server?

I know realy? I mean... I always get lost..... Even with repakcs... and noob-freindly guides... I get lost with like copy and pasting the java files.... Becuase i guess i don;t have some? or somthing....
 
cm.gainItem(id, amount)
isnt a mysql command..
u suppose to put it in a npcid.js...

edit: u messed up mysql and java....
 
This is how you do it.
Code:
 INSERT INTO shops ( shopid, npcid ) VALUES ( 9201003, 9201003 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1032040, 1, 1);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1032041, 1, 2);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1032042, 1, 3);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002508, 1, 4);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002509, 1, 5);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002510, 1, 6);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002511, 1, 7);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002513, 1, 8);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002515, 1, 9);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002516, 1, 10);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002517, 1, 11);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002518, 1, 12);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002600, 1, 13);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002601, 1, 14);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002602, 1, 15);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002603, 1, 16);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002717, 1, 17);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092030, 1, 18);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092045, 1, 19);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092046, 1, 20);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092047, 1, 21);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302020, 1, 22);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302030, 1, 23);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302033, 1, 24);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302064, 1, 25);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302080, 1, 26);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1332025, 1, 27);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1332055, 1, 28);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1332056, 1, 29);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1372034, 1, 30);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1382009, 1, 31);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1382012, 1, 32);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1382039, 1, 33);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1402039, 1, 34);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1312032, 1, 35);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1412011, 1, 36);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1412027, 1, 37);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1422014, 1, 38);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1422029, 1, 39);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1432012, 1, 40);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1432040, 1, 41);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1442024, 1, 42);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1442030, 1, 43);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1442051, 1, 44);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1452016, 1, 45);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1452022, 1, 46);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1452045, 1, 47);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1462014, 1, 48);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1462019, 1, 49);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1462040, 1, 50);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1472030, 1, 51);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1472032, 1, 52);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1472055, 1, 53);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1702132, 1, 54);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1702140, 1, 55);

And then make the NPC for it. No cm.thingy in sql
 
ooo i see what your doing.

thats not a NPC thats MySQL commands. like the INSERT, thats for inserting into shops your items and stuff. thats why its messing up.

the cm.sendYesNo and cm.dispose are the NPC commands. 2 different things.

EDIT:
this is the MySQL stuff...
Code:
INSERT INTO shops ( shopid, npcid ) VALUES ( 9201003, 9201003 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1032040, 1, 1);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1032041, 1, 2);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1032042, 1, 3);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002508, 1, 4);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002509, 1, 5);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002510, 1, 6);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002511, 1, 7);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002513, 1, 8);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002515, 1, 9);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002516, 1, 10);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002517, 1, 11);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002518, 1, 12);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002600, 1, 13);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002601, 1, 14);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002602, 1, 15);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002603, 1, 16);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1002717, 1, 17);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092030, 1, 18);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092045, 1, 19);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092046, 1, 20);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1092047, 1, 21);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302020, 1, 22);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302030, 1, 23);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302033, 1, 24);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302064, 1, 25);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1302080, 1, 26);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1332025, 1, 27);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1332055, 1, 28);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1332056, 1, 29);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1372034, 1, 30);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1382009, 1, 31);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1382012, 1, 32);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1382039, 1, 33);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1402039, 1, 34);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1312032, 1, 35);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1412011, 1, 36);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1412027, 1, 37);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1422014, 1, 38);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1422029, 1, 39);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1432012, 1, 40);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1432040, 1, 41);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1442024, 1, 42);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1442030, 1, 43);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1442051, 1, 44);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1452016, 1, 45);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1452022, 1, 46);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1452045, 1, 47);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1462014, 1, 48);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1462019, 1, 49);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1462040, 1, 50);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1472030, 1, 51);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1472032, 1, 52);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1472055, 1, 53);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1702132, 1, 54);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 9201003, 1702140, 1, 55);

and this is the NPC stuff
Code:
cm.sendYesNo("Hey! You! Yeah you... Do you wanna vist the BEST EVAR 1 Meso Maple shop? Then CLICK YES! What are you waiting for DO IT. This Shop was made by Orcrist of Ragezone and CEF =) Oh yeah mister Admin person... you can take that out..");
 
OHHHH.... So i just like put together 2 differnt things in the same thing? sooo... i have the shop for it but now how do i make the NPC for it? Or am I not getting it?

EDUT: Sooo... How do i know put the npc into the shop? or is that already done by exicuding both the npc script snd the shop script?
 
obviously, if u don't get how to do this, you shouldnt be releasing it. YOU DONT NEED A NPC ALWAYS.if u put a shop for that NPC, that npc will automatically open it
 
obviously, if u don't get how to do this, you shouldnt be releasing it. YOU DONT NEED A NPC ALWAYS.if u put a shop for that NPC, that npc will automatically open it



Ohhh... okay thanks.... I'm getting it now... and sorry for my noobsness in new XD every one gotta start some where
 
Back