Before anyone says anything, yes i looked in the stickied threads, and yes i used search facility.
My problem is simple- REVOLUTION DB, it doesnt have a newbie gift to start with. So i need help in making it from scratch.
I want it to have gears, eps and pps.
We can do it thru msn if you want, details on my profile page. Or just put a new guide up on epvp for us idiots who know nothing lol.
THX
Running this query,
delete from cq_action where id >= 1000010 and id <= 1000038;
update cq_action set id_next = 1000010 where id = 1000006;
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(1000010, 1000011, 1000012, 1080, 9000, 'isexit');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(1000011, 0000, 0000, 0126, 0, 'Welcome~to~ServerName~Enjoy~And~Invite~Ur~Frriend s!');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(1000012, 1000033, 0000, 1080, 9000, 'new');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(1000033, 1000034, 0000, 0501, 729020, '0 0 0 0 0 0 0 0 0 0 0 0');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(1000034, 1000035, 0000, 1081, 9000, 'phase = 1');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(1000035, 1000036, 0000, 0126, 0, 'Welcome~to~ServerName!~There~are~a~Begginer~gift~ for~you~good~luck~to~you!!');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(1000036, 1000037, 0000, 1085, 0, 'gmlog/gift_log user name:%user_name user id:[%user_id] get time:');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(1000037, 0000, 0000, 0125, 2011, 'Congratulate~To~%user_name~Has~Join
BUT GETTING THIS ERROR
[Err] 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''Congratulate~To~%user_name~Has~Join' at line 4
Could use a little help
OK SORTED IT OUT request closure please mods.






