- 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)
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
now press Ctr+H *Replace function <3*
Put in the top box
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
Set level 40 weapon price:
in the top box put
Set level 80 weapon + cape price:
in the top box put
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
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 >.<
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)
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
now press Ctr+H *Replace function <3*
Put in the top box
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
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 >.<
