EARTHWALKER

What errors through SQLyog/navicat are you getting? This info will help us to pinpoint where you are going wrong.

The more info you can provide, the smoother and quicker your journey will be; like what DB you use and where did you get it, what SD2 and where did you get mangos e.t.c

Works fine on my end.

But, I must stress that you have fell into the trap that hundreds before have done.

You've posted for help, without giving any information about the core or db you use.

If you are getting no errors applying the sql's, then yes, all is well.

Also, that is a YES, to using the mangos sql updates. They add a bit of both to coincide with any changes to the core.

I'm the forums' official 1970's pornstar lookalike. It's all in the privet hedge moustache

Je suis le sosie officiel d'étoile de porno de 1970 des forums. C'est tout dans la moustache de haie de troène. That's about as good as I can translate.

The OP wanted to APPLY a patch, not MAKE one.

Perhaps my grammar is just too perfect

Right-click the folder where the patch is and choose Git bash. Then type this:-

patch -p1 < nameofthepatch.patch

No idea what the above poster is talking about...lol

I'm sure many have been there before. I know I have

I implemented your code Grz3s and still had some error's, so I added them and now all have gone. Thanks.

Here's your code updated:

UPDATE creature SET MovementType=2, spawndist =0 WHERE guid IN (326,1012,3557,3574,3595,3596,4360,4361,4364,4377,4378,4522,5459,31772,37642,37647,37669,37671,37676,37677,37682,37691,37692,37693,37694,37695,37696,37697,37698,37699,37700,38347,39540,46818,51475,52070,52074,57656,58702,77361,77730,79750,84633,84716,85044,86177,86278,95560,115275,115276,127781,133611,135170,135210,135227,135228,135241,135253,135263,135265,135306,135338,135364,135445,135453,135473,135517,135530,135712,135729,135775,135805,202957,202956,202955,202954,202591,202588,202958,202959,202960,202961,202962,202963,202964,202965,202966,202967,202968,202969,202970,202971,202972,202973,202974,203112,203359,203846,203848,203927);

OOh, there's a couple of names I've not heard for a long time. Antrix too if I remember correctly. The pain of remember is starting to melt my brain. I best stop

Only one that worked flawlessly that I can rember is hakashi's restarter, I still have it somewhere in amongst all this dust

I use this little script that works 100%

// Set quest to auto-complete: Replace **** with Quest ID

UPDATE `quest_template` SET `Method`='0' WHERE (`entry`='*****')

I use this link on thottbot to get my quest id's - http://thottbot.com/?f=q

I haven't found one that doesn't work yet and I've done about 30 so far.

Oh I see. Now it makes sense. Only myself and some family members play on my local server, so no need for me, but I can see the logistical need for this.

Or does he mean Peter Pan's home, never neverland?

Perhaps someone can explain what this fake player business is all about?

First off m8, having a public mangos server is against the law and NOT EVER to be discussed in this forum as it breaks all ToS's

If you want to discuss such things you will need to discuss it privately with someone else.

Sorry, but that is the way it is.

mangoszero? Not sure what that is dude. Try and explain a little more please.

André? Same name as me

2010-09-05 17:02:07 ERROR: [A] You have: --> `10257_01_mangos_command.sql`

So from your mangos/sql/updates folder, you will need to add all the files, from:- 10263_01_mangos_pool_creature.sql and onwards until you reach 10430_01_mangos_spell_chain.sql

Yes it is confusing and long winded at first, but once you do that, I suggest you update at least once a week.

I do it once a week and it only takes about 30 minutes to re-grab, compile, compile sd2, then do the few updates.

Anyone else ?

I cant host it myself .. I only have 10mb upload speed and that is to low ... and there are no provider here to offer me more speed ...

Wow! 10 mb upload speed? Where in the world are you? You have slightly more than 10x my upload speed which is 768kb upload and I have no problem running a server for 50 or so people.

I know it is not a priority for you cyber, but can someone confirm if the buyer is working on his/her branch? the players on my server are complaining about it ain't working.

Yes his buyer is working fine.

I have found that ALL greens, blues, purples, etc are bought and a few greys here and there.

Make sure you have these settings:-

AuctionHouseBot.Seller.Enabled = 1

AuctionHouseBot.Buyer.Enabled = 1

Also try to do this:-

AuctionHouseBot.BuyPrice.Seller = 3

AuctionHouseBot.BuyPrice.Buyer = 6

I have my buyprice set to 3 as my gold drop is x3, so to even it out.

buyprice is 6 which you may or may not know, means the buyer will buy at 6x the standard vendor price.

Do my settings and try and sell a green item sword or piece of armour for 6 times the vendor price and see what happens.

I'm thinking they may be trying to sell it for too high a price.

"[Revision: * * 0482 *]"

huh?

Exactly herrtigger. Makes you wonder sometimes what planet these people are from.

Mods, May as well close this one as the OP obviously doesn't want to help as he can't be bothered to provide any info and my new E.S.P chip has blown a fuse

Hmmm, very strange mate. Yours worked fine last time I used it. Any idea what happened?

Well, any help you need regarding mangos can be said in this forum. That way you are probably going to get more help than just me.

After all. That is what the forum is for.

All it says to me is your version of windows and what cpu.

If you can't provide us with the simple info we ask for, then......nevermind.

Onwards to the next thread.

I think your marbles are gone.

I grabbed the latest rev of mangos, (10426) about 7 hours ago. Used cybers repo to make a patch. Patched, compiled, grabbed sd2, (1815), re-compiled, set up configs, set up the db to reflect min 25000/max 30000 in all three houses and bingo, everything works fine.

just not this latest update (rev 10385).

My min items is set to 25000 and max to 30000 and all is fine.

I have a patch for that rev is you need it.