[Help] Voting Reward

Page 2 of 2 1 2
10/14/2011 05:50 Marcus*#16
thought that would have been the issue just wasnt sure thanks for fixing it
10/14/2011 13:33 WolvesMaster#17
really thx Eurion
and thx to Marcus too ;)

btw if i want to make it a prize drop in the Inventory ?
10/16/2011 11:42 idlemonkey#18
you should name it Marcus instead of SantaClaus
10/18/2011 19:26 -+Sezzy+-#19
I would make a via php querry b/c (dident look at code carefully) if they click the button or npc link, it pops up and browser and immid rewards the EP. Make it so it verifies the vote using PHP
11/26/2011 03:08 karnyge#20
Quote:
Originally Posted by Eurion View Post
Just so no one else runs into this problem, you can't process actions after a action type of 2011. So here's the fix for it.

Code:
DELETE FROM `cq_action` WHERE id >= 5846200 AND id <= 5846205;

INSERT INTO `cq_action` VALUES 
('5846200', '5846201', '0', '101', '0', 'Hi~there.~You~can~vote~for~us~every~12~hours~'),
('5846201', '5846202', '0', '102', '0', 'Vote! 5846203'),
('5846202', '4000026', '0', '102', '0', 'Naw~thanks 0'),
('5846203', '5846204', '0', '1041', '0', '[Your Vote Site]'),
('5846204', '5846205', '0', '1001', '0', 'e_money += 50000'),
('5846205', '0', '0', '125', '2011', 'Congratulations! %user_name has voted for [YOUR SERVER NAME]');
Credits still goes to Marcus* I just fixed the issue.

I cant find the NPC by name in the cq_npc, but i can find the things it says in the cq_action.
So.......
....how do i remove the Vote NPC with or without using a query?
11/26/2011 07:22 WolvesMaster#21
i got 2 ways to remove it

1- look for this in cq_npc 5846200 <== it's the task0 for the NPC
OR 2- stand next to your voting NPC in the game then look at it's coordinate then search for it in maybe your last page in cq_npc and you will find it


Regards
Page 2 of 2 1 2