[Release] Season 4 Items and Vendor

[mcilduff]

Season 4 Items and a vendor!!

Hay guys i have a update for this and i will release it soon

DOWNLOAD NOW! (http://filebeam.com/d6e1e4e4f338545eefe8d0e634709399)


<bugs Fixed>

Changed the Entry ID's To a more Random number so you cant get the annoying Duplicate Entry Error

Fixed some displayIDs for palladin and Warlock.

Fixed the bug were the items dont get inserted into the vendor.

Changed The vendors DisplayID and faction so mobs don't attack him.

And added all the missing Items.


<What's New>


Vendor has the right price for the items.

All items are 100% blizzlike no Custom Stats

All DisplayID's Work.

Vendor's DisplayID changed to a better npc.

<How To execute The batch file>


First open your Database editor HeidiSQL/Navicat And connect to your server.

Click on Ascent and then click The "Import" Tab at the top of the page then click "Load SQL-File..."

Browse Your computer and find Mcilduff's Season 4 items + vendor.sql and click "Open"

Next click Execute what is a little arrow or press F+9 and wait for it to Execute.

Last Step restart your server and spawn the npc with .npc spawn 9999999 /ascent command.

:DHope this helps:D

Credits goes to <Mcilduff> for making this.

Golepa Delete that because that is NOT true hes just trying to snizzle my work and im not happy with that im not lieing so get rid of it or i will

please dont change that i have allready reported him so why dont you look that up im sorry if im being rude but this is my work]

[skate0721]

Cool Beans! I have been looking for season 4 vendors

[v1per]

Repost

[yuzoki]

http://www.ac-web.org/forum/releases/18285-release-season4-vendor.html
http://www.ac-web.org/forum/releases/18118-release-season-iv-4-guardian.html

Repost

Don't you remember how annoying my season 4 vendor was? like buy one item, then page again, buy, page etc, he fixed this, so no repost.

[mcilduff]

V1per you do know that agent11 release has bugs and some displayIDs are wrong and he didn't configure the SQL the right way making the items not insert into the vendor properly.

please don't post other Releases that are not my own.

Mcilduff.

[v1per]

Don't you remember how annoying my season 4 vendor was? like buy one item, then page again, buy, page etc, he fixed this, so no repost.

Yeah I remember. But this has been released before so this would be more like "[Release] Fixed S4 vendor" :P

V1per you do know that agent11 release has bugs and some displayIDs are wrong and he didn't configure the SQL the right way making the items not insert into the vendor properly.

please don't post other Releases that are not my own.

Mcilduff.


Fine I deleted the links

[mcilduff]

:)Thank You.:)


Mcilduff.

[bussemand2]

Dude why is it password protectet

[deece]

what is the password for this?

[cjamf]

password please

[rondy411]

whats the password

[mcilduff]

Sorry didn't Know that there was a password i will fix that asap.

Mcilduff.

OK I fixed the download problem now it has no password!.

Mcilduff.

[RiVOT]

no password was needed for me

proof: (and THANKS! this gear looks and is AWESOME!) :)
http://i294.photobucket.com/albums/mm101/flipcomz/PicVendorLoWPrivServerSellS4.jpg

[mcilduff]

Thank you RiVOT XD

Mcilduff.

[spearman360]

Nice I'll use this.

[mcilduff]

Thanks if you like please +rep XD

[Capone0824]

When i click execute its telling me.... 1060- duplicate entry '72000' for key 1??? what am i doing wrong?

[cjamf]

where is "load sql-file" after clicking import?

[moon123]

sweet i needed s4 i dont know how you guys do it love ya :) +rep

[mcilduff]

When i click execute its telling me.... 1060- duplicate entry '72000' for key 1??? what am i doing wrong?

umm you have a item/GO/NPC with the same enrty id as that, what you need to do is type 72000 into your database search bar and fine a entry with the same enrty ID as 72000 and change its Entry id to a differnt number like 81200 and click save there its all fixed all you need to do is execute the query agen and if it says.."1060- duplicate entry '72001'" then your in a big problem and i cant relly help you because you will need to change every entry id to a differnt number.

Mcilduff

where is "load sql-file" after clicking import?

Download HeidiSQL and use that Navicat is for people who know more with database editing..

Mcilduff.

[mughunter]

Can you please give me a list of the IDS?

[Hard_Core]

Don't you remember how annoying my season 4 vendor was? like buy one item, then page again, buy, page etc, he fixed this, so no repost.

for me it didnt fix that..

[Capone0824]

[QUOTE=mcilduff;183782]umm you have a item/GO/NPC with the same enrty id as that, what you need to do is type 72000 into your database search bar and fine a entry with the same enrty ID as 72000 and change its Entry id to a differnt number like 81200 and click save there its all fixed all you need to do is execute the query agen and if it says.."1060- duplicate entry '72001'" then your in a big problem and i cant relly help you because you will need to change every entry id to a differnt number.

Mcilduff


Is there a way to search the whole database at once? cause i only know how to do it from table to table.

I tried changeing the first couple id's to see if it would work, but it still gives me the error for whatever id i put...?

[uncleb4444]

works great thanks.


+rep

[mcilduff]

Is there a way to search the whole database at once? cause i only know how to do it from table to table.

I tried changeing the first couple id's to see if it would work, but it still gives me the error for whatever id i put...?

No you cant you haft to change all of the, or delete the other items with ids from 72000 to 72184 i think then try Executing the SQL agen and if you don't have success then i really can't help you.

:(Sorry Mcilduff.:(

[yesrightconnet]

excellent thread!!!

[Feelz]

excellent thread!!!

If you want to Spam at each post "Excellent Thread" Go into General and Spam into : Count To a Million ( No double post)

[FLFisherman]

Yay! Season 4! +rep

[phix]

nice +rep and could you add guardian? i cant find it in


NVM

[mcilduff]

Guardian is in it .. and thanks for the rep XD

[Horgande]

I gave you + rep :) Great work with this, thanks for it. :D

Also, I can get to import/execute the file, but still can't get the vendor to spawn.

[mcilduff]

I gave you + rep :) Great work with this, thanks for it. :D

Also, I can get to import/execute the file, but still can't get the vendor to spawn.

hmm... i dont know hy it dosnt spawn what do you use mangose antrix ascent? if its ascent type .npc spawn 999999 and i dont know what mangose is sorry if it still dosent work please remove it and execute it..

Mcilduff.

[luraguttn]

i am getting this error ...


SQL Error; Duplicate entry '72000' for key 1

and i haven`s added custom items yet..

[agent11]

Hey!

Thanks for ripping it from my fkin release!

You changed a few lines give me some damn credits!

[mcilduff]

Hey!

Thanks for ripping it from my fkin release!

You changed a few lines give me some damn credits!


:confused:LoL dude first i didnt do any of the above and second who the hell are you?:confused:this is my SQL From my Server that was alot of hard wrok and this is what i get in return? I made This so dont be Yapping up my tree u hear?:mad:.

And next time ask before you flame me for no reason u noob -Rep.:mad:

[agent11]

Yeah right m8, all of that damn SQL file in ur folder looks exactly like mine...

Its got my display id its got my entry id it looks exactly like my SQL script

You ripped it from mine give me some dam credit

That isnt yours

You no what? Shuv the fker up ur a$$ i dont giv a dam im not releasing no more

[babos15]

Damn nice!! my server will get more people now:D

[mcilduff]

Thanks XD

[ibotah]

w00t +rep:)

[mcilduff]

Np hope u like it XD