My First Shop

[AFatPerson]

I worked very hard trying to understand the shop id and I finally got it.

Please dont flame its MY FIRST SHOP/CREATION

Spindle Sells few items Elixirs demon elixirs EOF's and Cracks. Please take a look

 INSERT INTO shops
(`npcid`)
VALUES
(9201082);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 4001017, 2000000000, 1);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 4031179, 1000000000, 2);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 2022179, 1000000, 3);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 2020025, 500000, 4);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 2022118, 5000000, 5);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 2022108, 5000000, 6);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 5220000, 1000000, 7);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 2022282, 10000000, 8);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 2022176, 100000, 9);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 5180000, 50000000, 10);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(9595006, 5050000, 50000000, 11);

 

[Roamer]

Re: [Release] My First Shop

Screen shots pls

 

[Falzer]

Re: [Release] My First Shop

Explanation? Has been tested? Etc.?

 

[MortalMS]

Re: [Release] My First Shop

Tested. Great job on it.

 

[SaintsIan]

Re: [Release] My First Shop

hey hey not bad for your first release, i support the development of knownledge =] congratulations looks nice but i would prefer to use an all in one shop npc. good work on it though =] *pats your back* at least your not spoonfed

 

[Falzer]

Re: [Release] My First Shop

Lulz... I wonder if he ever read my guide on how to make a Shop SQL? o.o

 

[AFatPerson]

Re: [Release] My First Shop

Lulz... I wonder if he ever read my guide on how to make a Shop SQL? o.o

hey hey not bad for your first release, i support the development of knownledge =] congratulations looks nice but i would prefer to use an all in one shop npc. good work on it though =] *pats your back* at least your not spoonfed

THanks and yes i did read it. I was confused for a bit i was told many different things. SaintsIan I appreciate you supporting me. I will try to make better shops and such for the fun of it. My spare time i will make shops for fun and such like one npc sells everything if youd like. I will just keep trying my best i forgot to SS so let me do that right now

 

[Falzer]

Re: [Release] My First Shop

Umm... Why Spindle though? Just want to ask that.

 

[Sengi]

Re: [Release] My First Shop

Good job but btw it dont take alot u just put codes that's all O.O it's so simple tho

 

[SaintsIan]

Re: [Release] My First Shop

Good job but btw it dont take alot u just put codes that's all O.O it's so simple tho

LMAO! comment on the topic, dont go off saying you can do it and all, because personally i can do it as well, he released it being his first so have some dignity =].

 

[Onesky]

Re: [Release] My First Shop

Good job but btw it dont take alot u just put codes that's all O.O it's so simple tho

Eh w/e
its his first release anyways..

 

[iRandom]

Re: [Release] My First Shop

great now my spindle does't ha to sell crap that's uselsess

 

[firepower12]

Re: [Release] My First Shop

HOW DO I MAKE THIS TO WORK? pLEASE SOM31 H3L!P?!

 

[AFatPerson]

Re: [Release] My First Shop

great now my spindle does't ha to sell crap that's uselsess

Its nice to know that i helped people o-o Feels good Lol xD

 

[AFatPerson]

Re: [Release] My First Shop

HOW DO I MAKE THIS TO WORK? pLEASE SOM31 H3L!P?!

Sorry double post >_> But you save it on a notepad name it Spindle.sql then excute it in your MySQL and go in game talk to Spindle

 

[Falzer]

Re: [Release] My First Shop

HOW DO I MAKE THIS TO WORK? pLEASE SOM31 H3L!P?!

Execute via MySQL? o.o

 

[jasonhwang]

Re: [Release] My First Shop

LOL he was joking.

 

[llammaboi]

Re: [Release] My First Shop

HOW DO I MAKE THIS TO WORK? pLEASE SOM31 H3L!P?!

HAHAHAHAHAHAHAHAHAHAHHAHAHAHAHAHAHAH SO FUNNY!. No. Just. No. You're not funny. At All.

Its good to see someone actually trying to make things. Good Job. Next, you can code Ring Effects.

 

[jasonhwang]

Re: [Release] My First Shop

HAHAHAHAHAHAHAHAHAHAHHAHAHAHAHAHAHAH SO FUNNY!. No. Just. No. You're not funny. At All.

Its good to see someone actually trying to make things. Good Job. Next, you can code Ring Effects.

One weird fella . Good job on your first release. You should make something else instead of shops though

 

[AFatPerson]

Re: [Release] My First Shop

One weird fella . Good job on your first release. You should make something else instead of shops though

sure can u give some ideas?