hey i need a phew commands for Ether HeidiSQL Or navicat

[stoneharry]

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

[Bloodprince]

Thnx harry,
That query command is for navicat right or both? =D

[Elidan0]

it's not a Navicat command, i guess you can call it an SQL command, meaning you put it in an SQL file and run it as a query, and yeah, it will work on Navicat or anything you use.

[Bloodprince]

So how do i make an SQL file ? =p
without using Wow-v.

[Elidan0]

simply open up a notepad file, paste the code in there, and save as XXX.sql (the XXX is a filler)

[Bloodprince]

Hm okay thnx ill try that ^^ i will let ya know if it works (:

---------- Post added at 02:00 PM ---------- Previous post was at 01:56 PM ----------

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`creature_proto` SET `minlevel` = '80' AND `maxlevel` = '80'' at line 1
[Err] `creature_proto` SET `minlevel` = '80' AND `maxlevel` = '80';
[Msg] Finished - Unsuccessfully
--------------------------------------------------
This is what i get :S i can SS it too

---------- Post added at 02:02 PM ---------- Previous post was at 02:00 PM ----------

Got it now D:

[Elidan0]

then either it's the wrong command (which i doubt, since it was given to you by Stoneharry) or there's something wrong with your DB.

oh wait, are you sure you used the whole code? it looks like you missed the UPDATE

[Bloodprince]

yeah i did xD , i added UPDATE and it worked, but im checking every mobs now to see if it REALLY worked :P

[Elidan0]

k, but keep in mind, this is not really a solution, you still have level 80 creatures with lvl 1 stats

[Bloodprince]

Well it didtint change the creatures level's :S ive added with navicat AND heidiSQL

[Elidan0]

try restarting MySQL

[Bloodprince]

it changed their levels to bloody 31 - 32 instead o.O

[Elidan0]

every single NPC? then that's a problem with your DB, not with the command/code.

[Bloodprince]

Aight will try that =p hope it bloody works or else i got a fcking loads of typing to do it the DB -.-

---------- Post added at 02:16 PM ---------- Previous post was at 02:14 PM ----------

Not every single it only did with our custom mobs o.O
yup there's something wrong with our DB <.< Omfg

[Elidan0]

did you save all your queries?