[HELP] drops , and other things

hi guyz i have some problems that i wish u guyz to help me with
1 - monsters only drop 2700 eo card and it gives 500k eps
i wanna know how to make it give less , and how to make drops high rates but only 270card.

2 - making all totems active for the leg same time by mysql or anything

3 - wanna know how to make business partner ready fast without wait 72 hours

4 - how to fast forward the eudemon purchaser it need 14 DAYS for god sake

5- edit lottery item

6 - how can i change the Unis XO star ? i wanna make the 19* like 39*

7 - at last i wanna know how exactly can i edit the newbie gift

i know its alo but u guyz can handle it
Regards

#1 check your cq_action table

#2 Not sure

#3 Not sure

#4 cq_action i believe

#5 cq_lottery

#6 Change the rarity of said eudemon

#7 Cq Action


(remember when you are a PM when you use an item such as the newbie gift it gives you an action ID. search the cq_action for it and just follow the path)

@2 Get a legion with all totems activated then goto the cq_syndicate table in there is a field called totem_pole (if i remember right) copy this number and make it your default value in the design view

@3 Most likely the cq_config but if you are doing it just for youself to test something you can just drop server forward it 3days and reboot it up. (I mean you computer date)

deadpool will u plz do a lil more explaining , cuz i dint understand a word

Quote:

Originally Posted by dani-filth0 hi guyz i have some problems that i wish u guyz to help me with 1 - monsters only drop 2700 eo card and it gives 500k eps i wanna know how to make it give less , and how to make drops high rates but only 270card. 2 - making all totems active for the leg same time by mysql or anything 3 - wanna know how to make business partner ready fast without wait 72 hours 4 - how to fast forward the eudemon purchaser it need 14 DAYS for god sake 5- edit lottery item 6 - how can i change the Unis XO star ? i wanna make the 19* like 39* 7 - at last i wanna know how exactly can i edit the newbie gift i know its alo but u guyz can handle it Regards

1= Update cq_dropitemrule set item0=729018 enter this in your navicat console
2=dk
3=dk
4=dk
5=cq_lottery
6=
update cq_grade set rarity= 1500 where id= 1071980;
update cq_grade set rarity= 1500 where id= 1071981;
update cq_grade set rarity= 1500 where id= 1071982; makes 19* 29* 12* 22*s enter this in your navicat console
7=serch the fourm for this one it is released somewere


hope i helped you dont forget the thanks button

thx guyz for the help , just step 3 left
and i have 1 more question , its the NPC 100 that sells special exp balls and universals , its not workin , how can i make it work and how to edit it prices

Quote:

Originally Posted by dani-filth0 hi guyz i have some problems that i wish u guyz to help me with 3 - wanna know how to make business partner ready fast without wait 72 hours

The only way I know of doing this is to go into cq_partner and change the date to 0 , then have the player relog. It should then activate their business partnership.

i've done that thx flamebaked
guyzi've tried to run a query for special expballs selling , and it was a mage pipy seling them but for 20k eps , i wanna change that , and there is an NPC called 100 i wanna remove it
and how can i make n NPC sells unis inbox ???

pumb , still need help with steps
2 , 4 , 7
can someone tell me where can i find legions at navicat ?
and i need help of editing boss drops

Quote:

Originally Posted by dani-filth0 pumb , still need help with steps 2 , 4 , 7 can someone tell me where can i find legions at navicat ? and i need help of editing boss drops

didnt bother reading my post?

Quote:

@2 Get a legion with all totems activated then goto the cq_syndicate table in there is a field called totem_pole (if i remember right) copy this number and make it your default value in the design view @3 Most likely the cq_config but if you are doing it just for youself to test something you can just drop server forward it 3days and reboot it up. (I mean you computer date)

i've read that , but i need something show the name of the legions in the game

Quote:

Originally Posted by dani-filth0 i've read that , but i need something show the name of the legions in the game

dude it says in my post that legions are in cq_syndicate

i rule usally of normal euds i find loads of gems and off bosses i find 5-10 red stone arent i good want to know my tips???????

how do i change the drop rates there all at 99 i want to change them all too like 35 or somthing lower if anyone has a sql or somthing or know of an easy way can u leave a message on here letting me know how thanks.

Who can help me change the price of special expball at shopping mall