[Add-on] All In One Shop

[Diffusion]

Re: [Release] All In One Shop

i need help too . same result as Jimmyxx.

Remove this from the SQL

/* Deletes shops in that range */
DELETE FROM `shops` WHERE `shopid` >= 5000 AND `shopid` <= 5081;

/* Deletes shop items in those shops */
DELETE FROM `shopitems` WHERE `shopid` >= 5000 AND `shopid` <= 5081;

And Re-Execute the sql...

 

[Jimmyxx]

Re: [Release] All In One Shop

Remove this from the SQL

/* Deletes shops in that range */
DELETE FROM `shops` WHERE `shopid` >= 5000 AND `shopid` <= 5081;

/* Deletes shop items in those shops */
DELETE FROM `shopitems` WHERE `shopid` >= 5000 AND `shopid` <= 5081;

And Re-Execute the sql...

I deleted the lines now i get duplicate error in 5000 what i should do

 

[Shawn]

Re: [Release] All In One Shop

I deleted the lines now i get duplicate error in 5000 what i should do

*sigh*

did you look at the lines you deleted? did you look at the thread at all? like... everyones' posts? here, i'll edit the top post yet again.

 

[haha401]

Re: [Release] All In One Shop

Great ++

But when i open the Npc it work, but when i should buy something from the different classes, it ends up with nothing.
The Npc, who should sell the Equips don't have equips,its all empty. :/

I have exuded the Sql, from your File-front "all in One".

 

[gtxx911]

Re: [Release] All In One Shop

Error: unkown cloumn '1' in 'field list'

 

[ZeroSix]

Re: [Release] All In One Shop

Thanks a lot man ive been looking for one that actually works! =]

 

[gundum584]

Re: [Release] All In One Shop

nvm ))(

 

[bobbub]

Re: [Release] All In One Shop

hey ionfused here can u explain it a lil better


thanks

 

[Bartvo]

Re: [Release] All In One Shop

Thanks, it really worked.

Although the ReadMe wasn't right.

Here's the ReadMe:

Instructions for Beginners

1.) Open All In One.js.
[COLOR="Red"]2.) Press Ctrl+H.
3.) Replace NPCID with whatever NPC you want to use.
4.) Replace PRICE with whatever you want to sell everything for.[/COLOR]
5.) Save.
6.) Open MySQL.
7.) Go to File > Open Script.
8.) Find the All In One.sql.
9.) Execute the All In One.sql.
10.) Go to your repack.
11.) Go to Scripts > NPC.
12.) Open whatever NPC you want to use.
13.) Open All In One.js.
14.) Copy the script into whatever NPC you are using.
15.) Save.
16.) Start server.
17.) I'm getting carried away huh?
18.) Log in.
19.) Go to your NPC, or spawn it with a command.
20.) Enjoy

The red part isn't right. It says that you have to search for "NPCID" in All In One.js, but there isn't anything like "NPCID", neither is there the word "PRICE".

You don't have to change anything in All In One.js exept the text that your NPC will say (That's like: Welcome to ...MS / ...Story).

So there is no reason why step 2 would be there.

About step 3: That has to be done in All In One.sql. Make sure that you search CaSe-sEnSiTiVE. Else it won't get the right PRICE and then your Sql will be f*cked up (then you still have the rar or just redownload ).

The rest of the ReadMe was good.

 

[zamiel9]

Re: [Release] All In One Shop

Hmmmm...Good job!!!


Now I have this shop working...tt1:

OffTopic:WTH?How to we login now?No login conlum or watever:grr:

 

[Shawn]

Re: [Release] All In One Shop

Thanks, it really worked.

Although the ReadMe wasn't right.

Here's the ReadMe:

Instructions for Beginners

1.) Open All In One.js.
[COLOR="Red"]2.) Press Ctrl+H.
3.) Replace NPCID with whatever NPC you want to use.
4.) Replace PRICE with whatever you want to sell everything for.[/COLOR]
5.) Save.
6.) Open MySQL.
7.) Go to File > Open Script.
8.) Find the All In One.sql.
9.) Execute the All In One.sql.
10.) Go to your repack.
11.) Go to Scripts > NPC.
12.) Open whatever NPC you want to use.
13.) Open All In One.js.
14.) Copy the script into whatever NPC you are using.
15.) Save.
16.) Start server.
17.) I'm getting carried away huh?
18.) Log in.
19.) Go to your NPC, or spawn it with a command.
20.) Enjoy

The red part isn't right. It says that you have to search for "NPCID" in All In One.js, but there isn't anything like "NPCID", neither is there the word "PRICE".

You don't have to change anything in All In One.js exept the text that your NPC will say (That's like: Welcome to ...MS / ...Story).

So there is no reason why step 2 would be there.

About step 3: That has to be done in All In One.sql. Make sure that you search CaSe-sEnSiTiVE. Else it won't get the right PRICE and then your Sql will be f*cked up (then you still have the rar or just redownload ).

The rest of the ReadMe was good.

Yea, I made the ReadMe before I saved the file, and never changed it after I decided people would probably just screw it up lol.

Hmmmm...Good job!!!


Now I have this shop working...tt1:

OffTopic:WTH?How to we login now?No login conlum or watever:grr:

login? uhmm.... if you have problems logging in, that is with your server, not with this. o.0

 

[dragonbIood]

Re: [Release] All In One Shop

Good job, although I got mine to work on my first try >_>

 

[Shawn]

Re: [Release] All In One Shop

updated again because someone had a problem with the script. if you can't get the one to work in the download, use the one posted.

 

[iTouchy]

Re: [Release] All In One Shop

Thank you for the release and the mini tutorial on how to make it work I just started and I still don't fully understand how everything works

 

[Prismtx]

Re: [Release] All In One Shop

I did everything according to the revised read me and Im getting

"Script line: 10 Unknown column '9010002' in 'field list'

I am useing Mia's NPC ID. I also dont see a text box at the top of the MySQL Query Browser window with the All In One Script loaded where it shows a box at the top of the screen near the buttons in your picture where you say to take out and re insert those lines in the script file.

 

[Shawn]

Re: [Release] All In One Shop

I did everything according to the revised read me and Im getting

"Script line: 10 Unknown column '9010002' in 'field list'

I am useing Mia's NPC ID. I also dont see a text box at the top of the MySQL Query Browser window with the All In One Script loaded where it shows a box at the top of the screen near the buttons in your picture where you say to take out and re insert those lines in the script file.

that is because you are in the sql tab. there should be an open tab, before the sql tab, after opening the script. click on it and wala, theres the box to type in. if there isn't, open a new tab in it and again... wala, theres the box. now.. as for the error... could you take a screen shot of that? i don't see how that error could have come to be, since "field list" is the columns in the character table, and nothing about the sql nor NPC touch the character table.

 

[Prismtx]

Re: [Release] All In One Shop

Spoiler

I saw the blank tab to the left, I dont see a space between my buttons with a text box like the one in your pic, just the one in the main text area when I open up the resultset1 tab.

Also I dont really understand how to access the tables and all that like you have in your pics either.

Im pretty much new at working with the MySQL Query Browser so I really appreciate any help yall can give me.

 

[iJFAC]

Re: [Release] All In One Shop

Hope it works for Xiuz , downloading. Thanks bboy <3..

 

[omegaheros]

Re: [Release] All In One Shop

lol whats so hard about adding an all in one shop i did it when i didnt even know how to code a poop.

 

[iternalflame]

Re: [Release] All In One Shop

i get bat errors when i press into a shop any help im using luckystroy?