Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[v75+][Mini Mini Release] Full Timeless Shop

Status
Not open for further replies.
Newbie Spellweaver
Joined
Dec 21, 2008
Messages
42
Reaction score
11
This is only a really small release which would only take someone like 10 mins to do. Ive put the names of the items next to the query, this will only be helpfull to the servers with full timeless.

The npcid used is : 2082002 (Harry)

PHP:
INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1032031, 10000000, 0);  -- Timeless Earings --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1122012, 10000000, 1);  -- Timeless Pendant --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1002776, 10000000, 2);  -- Timeless Fennel --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1002777, 10000000, 3);  -- Timeless Coral --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1002778, 10000000, 4);  -- Timeless Rapido --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1002779, 10000000, 5);  -- Timeless Chive --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1002780, 10000000, 6);  -- Timeless Conrad Henkel --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1102172, 10000000, 7);  -- Timeless Moonlight --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1082234, 10000000, 8);  -- Timeless Bergamot --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1082235, 10000000, 9);  -- Timeless Hermosa --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1082236, 10000000, 10);  -- Timeless Presto --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1082237, 10000000, 11);  -- Timeless Lubav --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1082238, 10000000, 12);  -- Timeless Charlston --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1052155, 10000000, 13);  -- Timeless Taragon --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1052156, 10000000, 14);  -- Timeless Myst Blue --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1052157, 10000000, 15);  -- Timeless Everynew

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1052158, 10000000, 16);  -- Timeless Prinsid --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1052159, 10000000, 17);  -- Timeless Burgunt --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1092057, 10000000, 18);  -- Timeless Prelude

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1092058, 10000000, 19);  -- Timeless Kite Shield --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1092059, 10000000, 20);  -- Timeless List

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1072355, 10000000, 21);  -- Timeless Grabbe --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1072356, 10000000, 22);  -- Timeless Cabatina --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1072357, 10000000, 23);  -- Timeless Rontano --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1072358, 10000000, 24);  -- Timeless Moonsteed --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1072359, 10000000, 25);  -- Timeless Paraon --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1302081, 10000000, 26);  -- Timeless Executioners --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1312037, 10000000, 27);  -- Timeless Bardiche --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1322060, 10000000, 28);  -- Timeless Alargando --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1402046, 10000000, 29);  -- Timeless Nibbleheim --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1412033, 10000000, 30);  -- Timeless Tabarzin --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1422037, 10000000, 31);  -- Timeless Bellocce

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1442063, 10000000, 32);  -- Timeless Diesra --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1482023, 10000000, 33);  -- Timeless Equinox --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1332073, 10000000, 34);  -- Timeless Pescas --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1332074, 10000000, 35);  -- Timeless Killic --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1372044, 10000000, 36);  -- Timeless Enreal Tear --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1382057, 10000000, 37);  -- Timeless Aeas Hand --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1432047, 10000000, 38);  -- Timeless Alchupiz --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1452057, 10000000, 39);  -- Timeless Engaw --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1462050, 10000000, 40);  -- Timeless Black Beauty --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1472068, 10000000, 41);  -- Timeless Lampion --

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1492023, 10000000, 42);  -- Timeless Blindness --

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(10086, 2082002);
 
Last edited:
Newbie Spellweaver
Joined
Jul 17, 2008
Messages
51
Reaction score
4
Re: [Mini Mini Release] Full Timeless Shop

This is great for beginner they can gather up the sqls and learn to edit them!
 
Skilled Illusionist
Loyal Member
Joined
Dec 18, 2009
Messages
300
Reaction score
32
Re: [Mini Mini Release] Full Timeless Shop

Nice =D Gotta test it out =D but isnt Money too cheap for High rate? Cant I make it like Exchange Maple Golden Bags for Timeless
 
Smoke & Fly
Loyal Member
Joined
Apr 21, 2008
Messages
1,190
Reaction score
76
Re: [Mini Mini Release] Full Timeless Shop

Nice =D Gotta test it out =D but isnt Money too cheap for High rate? Cant I make it like Exchange Maple Golden Bags for Timeless
Yes, but not in the common maplestory shop window.
 
Newbie Spellweaver
Joined
Sep 30, 2008
Messages
14
Reaction score
0
Re: [Mini Mini Release] Full Timeless Shop

umh sorry to be a noob or smthing, but how do u use this?
 
Smoke & Fly
Loyal Member
Joined
Apr 21, 2008
Messages
1,190
Reaction score
76
Re: [Mini Mini Release] Full Timeless Shop

umh sorry to be a noob or smthing, but how do u use this?
Execute the query in your MySQL, then restart the server and look for this npc 2082002.
 
Newbie Spellweaver
Joined
Dec 21, 2008
Messages
42
Reaction score
11
Re: [Mini Mini Release] Full Timeless Shop

Please make sure that your server supports full timeless.

And you dont have to restart the server if you did the npc code right.
 
Last edited:
Newbie Spellweaver
Joined
Dec 15, 2009
Messages
9
Reaction score
0
Re: [Mini Mini Release] Full Timeless Shop

How do I make the players pay using tetris?
 
Newbie Spellweaver
Joined
Dec 10, 2009
Messages
17
Reaction score
2
Re: [Mini Mini Release] Full Timeless Shop

How do I make the players pay using tetris?

By editing it to the id of the tetris and get the players to use @buytetris or something like that the id is 4030002

---------- Post added at 01:37 PM ---------- Previous post was at 01:32 PM ----------
I got a error when trying to execute it

Script line: 216 Duplicate entry '10086' for key 1

Could Someone help me

BTW IM very new at all of this could some1 give me a video or a TV tut
 
Last edited:
Newbie Spellweaver
Joined
Jul 10, 2008
Messages
14
Reaction score
2
Re: [Mini Mini Release] Full Timeless Shop

---------- Post added at 01:37 PM ---------- Previous post was at 01:32 PM ----------
I got a error when trying to execute it

Script line: 216 Duplicate entry '10086' for key 1

Could Someone help me

BTW IM very new at all of this could some1 give me a video or a TV tut

I'm assuming this is a shop ID, it means you already have a shop using this ID, and you need to change the SQL or your database.

If you want to TV or need help on something, my msn is Iacoopa@hotmail.com
 
Last edited:
Custom Title Activated
Loyal Member
Joined
Nov 27, 2009
Messages
1,905
Reaction score
948
Re: [Mini Mini Release] Full Timeless Shop

Good job, I needed this, and here it was!
 
Newbie Spellweaver
Joined
Oct 22, 2010
Messages
42
Reaction score
6
Re: [Mini Mini Release] Full Timeless Shop

Can i edit this and excute it?
 
Everything is possible~
Loyal Member
Joined
Jan 9, 2008
Messages
818
Reaction score
847
This is a lot faster:

Code:
INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(10086, 1032031, 10000000, 0),  -- Timeless Earings --
(10086, 1122012, 10000000, 1),  -- Timeless Pendant --
(10086, 1002776, 10000000, 2),  -- Timeless Fennel --
(10086, 1002777, 10000000, 3),  -- Timeless Coral --
(10086, 1002778, 10000000, 4),  -- Timeless Rapido --
(10086, 1002779, 10000000, 5),  -- Timeless Chive --
(10086, 1002780, 10000000, 6),  -- Timeless Conrad Henkel --
(10086, 1102172, 10000000, 7),  -- Timeless Moonlight --
(10086, 1082234, 10000000, 8),  -- Timeless Bergamot --
(10086, 1082235, 10000000, 9),  -- Timeless Hermosa --
(10086, 1082236, 10000000, 10),  -- Timeless Presto --
(10086, 1082237, 10000000, 11),  -- Timeless Lubav --
(10086, 1082238, 10000000, 12),  -- Timeless Charlston --
(10086, 1052155, 10000000, 13),  -- Timeless Taragon --
(10086, 1052156, 10000000, 14),  -- Timeless Myst Blue --
(10086, 1052157, 10000000, 15),  -- Timeless Everynew --
(10086, 1052158, 10000000, 16),  -- Timeless Prinsid --
(10086, 1052159, 10000000, 17),  -- Timeless Burgunt --
(10086, 1092057, 10000000, 18),  -- Timeless Prelude --
(10086, 1092058, 10000000, 19),  -- Timeless Kite Shield --
(10086, 1092059, 10000000, 20),  -- Timeless List --
(10086, 1072355, 10000000, 21),  -- Timeless Grabbe --
(10086, 1072356, 10000000, 22),  -- Timeless Cabatina --
(10086, 1072357, 10000000, 23),  -- Timeless Rontano --
(10086, 1072358, 10000000, 24),  -- Timeless Moonsteed --
(10086, 1072359, 10000000, 25),  -- Timeless Paraon --
(10086, 1302081, 10000000, 26),  -- Timeless Executioners --
(10086, 1312037, 10000000, 27),  -- Timeless Bardiche --
(10086, 1322060, 10000000, 28),  -- Timeless Alargando --
(10086, 1402046, 10000000, 29),  -- Timeless Nibbleheim --
(10086, 1412033, 10000000, 30),  -- Timeless Tabarzin --
(10086, 1422037, 10000000, 31),  -- Timeless Bellocce --
(10086, 1442063, 10000000, 32),  -- Timeless Diesra --
(10086, 1482023, 10000000, 33),  -- Timeless Equinox --
(10086, 1332073, 10000000, 34),  -- Timeless Pescas --
(10086, 1332074, 10000000, 35),  -- Timeless Killic --
(10086, 1372044, 10000000, 36),  -- Timeless Enreal Tear --
(10086, 1382057, 10000000, 37),  -- Timeless Aeas Hand --
(10086, 1432047, 10000000, 38),  -- Timeless Alchupiz --
(10086, 1452057, 10000000, 39),  -- Timeless Engaw --
(10086, 1462050, 10000000, 40),  -- Timeless Black Beauty --
(10086, 1472068, 10000000, 41),  -- Timeless Lampion --
(10086, 1492023, 10000000, 42);  -- Timeless Blindness --

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(10086, 2082002);
 
Junior Spellweaver
Joined
Oct 12, 2010
Messages
152
Reaction score
39
Wow, Nice one
I will added on my KinoStory
Thank alot :]
 
Status
Not open for further replies.
Back
Top