Help cq_action

06/04/2012 12:44 seraf2#1
iv been trying to do some editing in a database, iv managed to understand nearly all of it except the cq_action, for some reason i cannot find anything i want in there
if im not wrong things like quest rewards, eps drops all go into there right? but when i enter ids i find nothing. so i was wondering if anyone could explain how i can changed eps drops manualy without a script since this mighthelp me understand the cq_action better or change the event rewards manually

so if anyone can help me id be greatfull
06/04/2012 15:18 pretzel666#2
Just Type in what it gives , So say when you kill a monster it says "You Recieved 5 Eps From A Madbull" You would search "You Recieved 5 Eps From A Madbull" in cq_action ? Understand or do you need more details?
06/04/2012 20:27 karnyge#3
If you are a [PM] -
Watch the numbers in the bottom left corner of the screen. These are actions, most of the time. Use them to search for the ids.

Changing the autoeps -
Open Navicat, click on cq_action.
Click on the id column anywhere and select sort ascending.
The first lines are usually the autoeps, but check the last column, (parameters) for the eps/monster name.
06/05/2012 01:08 seraf2#4
thanks for your answers but i still cannot find them :( im sure im doing somthing wrong i just dont know what :(
when i kill a monsters i get a message saying 1000 emoney has been added but i cannot find in my cq action
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
06/05/2012 02:48 karnyge#5
Every database i have ever accessed has the autoep system set in the same place. You must not be following instructions or the entire autoep system is not where it is supposed to be.

Open the cq_action table.
Click on the column called ID.
Select sort ascending.

Now you should see the autoeps system as the first lines in the table.

If the above is failing to deliver the required information, and it should not fail, use the search engine of navicat.
Search for += or =+ in the param coloumn. These two symbols are always part of the autoeps system. The full param should look like this, as an example - emoney=+10.
Sometimes it may have emoney2 or a different number to add, but =+ or += will always be part of it.

Now, there will be numerous entries that are not all part of the autoep system. Easy way to work out which is which, is to look at the ID numbers. All autoeps will be consecutive odd or even numbers, EG 1, 3, 5 etc or 2, 4, 6 etc. The numbers in between are the award message.
So as an example.
id number 1 awards 10 eps, id number 2 is the message telling you this.
id number 3 awards 15 eps, id number 4 is the message telling you this.

Get the picture now?
06/05/2012 15:33 seraf2#6
yeah iv found that thanks i can now change eps :D thanks so much
btw i still cant seem to find other ids though like events :( but ill keep trying thanks karnyge

iv just found out why i cant find the ids for some reason all my cq_action ids dont show for example action id 1 only shows when i press assending on ids and 99999only shows when i press decending so the ones in the middle dont show, anyone know how i can view the whole cq_action