Little Problem

10/05/2008 20:57 Rawsteeey#1

Hey!

If I try to make a Query, to put Drop rate higher (on another way) i get an Error Message:

1064 - You have an error in your SQL syntax. Check the manual that correspnonds your MYSQL Server for the right syntax to use near '4294967295' at line 1.

My query is:
update cq_monstertype set drop_item_chance 4294967295;

whas wrong? I Hope I can get help^^

10/05/2008 21:20 FlameBaked#2

your missing and equal sign in the query.

It should be like this

Code:

update cq_monstertype set drop_item_chance=4294967295;

10/06/2008 06:34 funhacker#3

You aware that, that query will affect all fields?

10/06/2008 16:09 Rawsteeey#4

yes...

10/06/2008 16:59 funhacker#5

this also includes pets...

10/06/2008 17:40 Rawsteeey#6

yes i know lol