[HELP]writing a query

01/09/2011 18:41 karnyge#1

would someone be so kind as to give me the basics of writing a query please. I need to know how to remove items from dropitemrule, and then add new items to the same thing.

thanks in advance

01/09/2011 21:25 PraDevil[ELITE]#2

why karnyge? i didnt see like b4 i know u @@
anyways if u mean cq_dropitemrule and would like to reset what to drop so this is it.

Code:

UPDATE cq_dropitemrule SET item0=[B]ID[/B], item1=[B]ID[/B], item3=[B]ID[/B], item4=[B]ID[/B], item5=[B]ID[/B], item6=[B]ID[/B], item7=[B]ID[/B], item8=[B]ID[/B], item9=[B]ID[/B], item10=[B]ID[/B], item11=[B]ID[/B], item12=[B]ID[/B], item12=[B]ID[/B], item13=[B]ID[/B], item14=[B]ID[/B] where group_id=[B]MONSTER ID[/B];