Querys Navicat! <Drop rates> <Composing rates> AND MORE

06/17/2008 14:52 666^^devil^^666#1
Querys Navicat!

Go to Navicat Go to my click at New CLICK AT THE BIG ICON All Click at New Query paste the text and click at run


update FIleName(Likecq_drop_item_rule) set <Here The column name>=Here Numbers or letters;

Drop rates

update cq_dropitemrule set item0=ITEM ID HERE;
update cq_dropitemrule set item1=ITEM ID HERE;
update cq_dropitemrule set item2=ITEM ID HERE;
update cq_dropitemrule set item3=ITEM ID HERE;
update cq_dropitemrule set item4=ITEM ID HERE;
update cq_dropitemrule set item5=ITEM ID HERE;
update cq_dropitemrule set item6=ITEM ID HERE;
update cq_dropitemrule set item7=ITEM ID HERE;
update cq_dropitemrule set item8=ITEM ID HERE;
update cq_dropitemrule set item9=ITEM ID HERE;
update cq_dropitemrule set item10=ITEM ID HERE;
update cq_dropitemrule set item11=ITEM ID HERE;
update cq_dropitemrule set item12=ITEM ID HERE;
update cq_dropitemrule set item13=ITEM ID HERE;
update cq_dropitemrule set item14=ITEM ID HERE;

<THIS EXPLAINED Netlog_Stefan too>
[Only registered and activated users can see links. Click Here To Register...]

----

COMPOSING RATES

update cq_eudemon_rbn_rqr set min=MIN COMPOSING RATE..NUMBERS!;
AND
update cq_eudemon_rbn_rqr set max=MAX COMPOSING RATE..NUMBERS!;

DONT PUT IT ALL IN 1 TO 1 NEW QUERY
Example:
update cq_eudemon_rbn_rqr set min=1000;
This will update the column min to 1000

update cq_eudemon_rbn_rqr set max=2000;
This will update the column max to 2000
-----
Nobility rank

update cq_user set index82=NUMBERS;

This will update every Nobility rank donated money.
----

UPDATE every1s money and money at wh
update cq_user set money=numbers?;

wh:
update cq_user set money_saved=numbers?;

----
update every1s pk points

update cq_user set pk=numbers?;

----
update every1s level (not hp attk etc.)
update cq_user set level=numbers?;
----
More monsters active

update cq_generator set max_per_gen=NUMBERS;
------------
DONT FORGET TO *Thanks

*More coming soon
06/17/2008 23:10 Rawsteeey#2
i think...
someguys read this, got big help, and dont give a thanks -.-
06/18/2008 15:44 666^^devil^^666#3
Maybe they don't read it ;)