hey i need a phew commands for Ether HeidiSQL Or navicat

[Bloodprince]

I made an SQL File with it mate.

[Elidan0]

but did you save all your queries or SQL's with your custom content? if so do the following to make a new working DB. keep in mind this will only replace your world DB, so keep all your other ones. and after you are dun just rerun your queries or make new ones if you just have the SQl files saved, but if you don't have either your queries or SQL files then i wouldn't suggest doing this because you will lose all your custom content

it's pretty simple.

1. download tortoisesvn
2. make a new folder anywhere
3. right click the folder and choose SVN checkout
4. where is says URL of repository put: lhdb - Revision 87: /
5. leave everything else the same and press ok
6. wait for it to do it's thing.
7. once it's done go into the folder and run tool and type in ur MySQL info

support Eatos and his DB here

[stoneharry]

Ermmm...

UPDATE `creature_proto`
^
were using the creature_proto table.

SET `minlevel` = '80'
^
Were changing the column called minlevel to 80. Make sure this is the correct column name, I didn't check.

AND `maxlevel` = '80'
^ See above

;
^ Allows us to execute more than one row basically.

If that is still giving you errors even though you changed the column name:

UPDATE `creature_names` SET `minlevel` = '80';
UPDATE `creature_proto` SET `maxlevel` = '80';

Also queries do not execute if they return an error, so when you executed this it should not have done anything.

[Elidan0]

Ermmm...

UPDATE `creature_proto`
^
were using the creature_proto table.

SET `minlevel` = '80'
^
Were changing the column called minlevel to 80. Make sure this is the correct column name, I didn't check.

AND `maxlevel` = '80'
^ See above

;
^ Allows us to execute more than one row basically.

If that is still giving you errors even though you changed the column name:

UPDATE `creature_names` SET `minlevel` = '80';
UPDATE `creature_proto` SET `maxlevel` = '80';

Also queries do not execute if they return an error, so when you executed this it should not have done anything.

it worked, he didn't get any errors, he just forgot to include UPDATE the first time, but apperently it set the levels of all his custom NPC's to 30-31, that has to be something wrong with the DB

[Bloodprince]

Right okay, but our DB is F**ked
and i dunno how to fix it agin :s

[Elidan0]

look a couple posts back, i told you how

[Bloodprince]

Ston do you got an MSN i can contact you on ?

---------- Post added at 02:53 PM ---------- Previous post was at 02:37 PM ----------

We changed the commands to
UPDATE `creature_proto` SET `minlevel` = '80';
UPDATE `creature_proto` SET `maxlevel` = '80';
and it worked (: ..

[stoneharry]

Probably because it should of been:

UPDATE `creature_proto` SET `minlevel` = '80' AND SET `creature_proto` = '80';

Or maybe the use of brackets was required, my SQL knowledge has never been that vast.

[Bloodprince]

hehehe meybe :P

[shadowknight513]

Right okay, but our DB is F**ked
and i dunno how to fix it agin :s

Told you. I still don't understand the point in having every creature 80, can you please explain it to me?

[stoneharry]

Honestly, leave him alone. It's up to him whether he wants to change it, hell he could make it so that all mobs were invincible, and it would still be none of your business.
Maybe he has it planned so that it's difficult to work out which mobs will give decent loot, or make it so that travelling around is not as easy as it once was. Whatever the reason, is it really your place to question his ideas?

The question has been answered, now drop it.

[Bloodprince]

hahaha thnx stone,
Stone do you got an msn i can contact you on if im looking for some commands or stuff like that etc ?

[Dynashock]

The SQL query provided by Stoneharry was not working because he included the AND statement in it, which only works in filtering situations. A comma instead would've done the trick. (Or of course splitting the query in two seperate queries.)

[Zaxer]

Bloodprince, I actually don't think you understand what happens when you change a mobs level, what you are looking for is to make all mobs lvl 80 and have about the same stats.
When a player level up the player gets new stats, but when a NPC level up nothing happens except the level changes.

[Bloodprince]

yea i know zax, but really what im looking for now, im underconstructing my own server atm , and im looking for haste/weapon speed cap in the core and i cant find it anywhere any ideas?.