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!

Taru spirit weapon/cape shop. Shop edit guide/SQL [ODIN]

Junior Spellweaver
Joined
May 26, 2008
Messages
195
Reaction score
0
I don't really know much >.<
just how to do a bunch of basic things, and i take so much from the community..
I mean least i can do is give something minor back >_<

Im pretty sure this guide is gonna be useless to anyone but beginers...
The pros i urge you just to look and take and change.
Beginers to shops and SQL i think you should read it all and look at how the shops are set out.
Its all very easy.

So yeah i coded this NPC (Corine in NLC *Perfect NPC*) for the second time.
She sells the Taru spirit cape, all lvl 10, all lvl 40 and all lvl 80 spirit weapons.

First off, go to your SQL browser and navigate to the odinms database then open up the shops database.
scroll down to the last entry and find the shop number, if the last shop is like...
EXAMPLE!
57?
Replace "SHOP ID!!!" with the next shop number *which would be 57+1 (so 58)

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(SHOP ID!!!, 9201094);

Now copy it into your mysql browser and execute.
*Depending on what your using it might be a box at the top or you may need to press a button that says SQL.*

Ok so Corine is now a shop, now you just need to set the item prices according to your servers economy.

Copy this into notepad
INSERT INTO `odinms`.`shopitems` (
`shopitemid` ,
`shopid` ,
`itemid` ,
`price` ,
`position`
)
VALUES (
NULL , 'SHOP ID !!!', '1102165', '500000', '0'
), (
NULL , 'SHOP ID !!!', '1452054', '150000', '1'
), (
NULL , 'SHOP ID !!!', '1462047', '150000', '2'
), (
NULL , 'SHOP ID !!!', '1332067', '150000', '3'
), (
NULL , 'SHOP ID !!!', '1472065', '150000', '4'
), (
NULL , 'SHOP ID !!!', '1382054', '150000', '5'
), (
NULL , 'SHOP ID !!!', '1332070', '150000', '6'
), (
NULL , 'SHOP ID !!!', '1452055', '250000', '7'
), (
NULL , 'SHOP ID !!!', '1462048', '250000', '8'
), (
NULL , 'SHOP ID !!!', '1332068', '250000', '9'
), (
NULL , 'SHOP ID !!!', '1472066', '250000', '10'
), (
NULL , 'SHOP ID !!!', '1382055', '250000', '11'
), (
NULL , 'SHOP ID !!!', '1332071', '250000', '12'
), (
NULL , 'SHOP ID !!!', '1452056', '500000', '13'
), (
NULL , 'SHOP ID !!!', '1462049', '500000', '14'
), (
NULL , 'SHOP ID !!!', '1332069', '500000', '15'
), (
NULL , 'SHOP ID !!!', '1472067', '500000', '16'
), (
NULL , 'SHOP ID !!!', '1382056', '500000', '17'
), (
NULL , 'SHOP ID !!!', '1332072', '500000', '18'
);

now press Ctr+H *Replace function <3*
Put in the top box
SHOP ID !!!
And in the bottom box put your shop number in my case its 58 so
Press replace all, right now good every item is now gonna be set to shop 58 *or whatever number shop you have*

Now we need to edit the prices, with the same notepad press Ctr+H again.
Set level 10 weapon price:
in the top box put
and in the bottom box put whatever price you think it should be for level 10 spirit weapons, so for example you want them 5000 each you would put
now replace all.

Set level 40 weapon price:
in the top box put
and in the bottom box put whatever price you think it should be for level 40 spirit weapons, so for example you want them 50000 each you would put
now replace all.

Set level 80 weapon + cape price:
in the top box put
and in the bottom box put whatever price you think it should be for level 80 spirit weapons & cape, so for example you want them 100000 each you would put
now replace all.

Now if you want the cape seperate from the lvl 80 weapon price * i think its a good level price tho since its the same lvl as the 80 weapons *
The first line
NULL , 'SHOP ID !!!', '1102165', '100000', '0'
Or whatever you have it to now is the cape.
the second last number *in my case 100000 is the cape price, change it manually to whatever you want.

Ok so.....Now youve succesfully edited the shop items prices for your server rates.

now alls thats left to do is copy your notepad and put it in your SQL browser and Execute.
Go to Corine in NLC and look at your new shop ^_^
If it doesnt show up do the !clearshops command.

If nothing else you have at least learn't a few things...
#1 how a shop is set up with SQL.
#2 the layout of items.
#3 that notepad has a replace function that can save ALOT!!! of time.

I do expect a few, rofl we need dis whys?
and stuff like that but hey... if it helps 1 person it was worth it >.<
 
Newbie Spellweaver
Joined
Jul 3, 2008
Messages
32
Reaction score
0
Re: [RELEASE] Taru spirit weapon/cape shop. SQL [ODIN]

this would be more like a guide, but nice. :]
 
Junior Spellweaver
Joined
May 26, 2008
Messages
195
Reaction score
0
Re: [RELEASE] Taru spirit weapon/cape shop. SQL [ODIN]

Well...it started plain... but i kinda went into alot of detail ._. ill rename the thread.
 
Newbie Spellweaver
Joined
Jun 29, 2008
Messages
5
Reaction score
0
Re: [RELEASE] Taru spirit weapon/cape shop. Shop edit guide/SQL [ODIN]

Any random id is fine as long as its totally random. such as 1536 or 8646. Saves alot of time.
 
Junior Spellweaver
Joined
May 26, 2008
Messages
195
Reaction score
0
Re: [RELEASE] Taru spirit weapon/cape shop. Shop edit guide/SQL [ODIN]

It's always a better idea to keep your shops in order ;o
0-56
MASSIVE GAP
1023-1024
Isnt gonna look very nice ;o
But hey.....
Still gonna work lol ;)

I do have one question tho, what is the maximum number for a shop id? 2,147,xxx,xxx?
 
Back
Top