Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Eudemons Online > EO PServer Hosting
You last visited: Today at 19:14

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[HELP]Making from scratch a newbie gift

Discussion on [HELP]Making from scratch a newbie gift within the EO PServer Hosting forum part of the Eudemons Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Aug 2008
Posts: 502
Received Thanks: 145
[HELP]Making from scratch a newbie gift

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.
karnyge is offline  
Old 08/11/2010, 19:44   #2
 
Manly393's Avatar
 
elite*gold: 0
Join Date: Apr 2008
Posts: 180
Received Thanks: 47
lol np
Manly393 is offline  
Thanks
1 User
Old 08/11/2010, 20:53   #3

 
magewarior2's Avatar
 
elite*gold: 20
Join Date: Mar 2008
Posts: 1,550
Received Thanks: 820
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(1000037, 0000, 0000, 0125, 2011, 'Congratulate~To~%user_name~Has~Join`)
magewarior2 is offline  
Old 08/11/2010, 21:28   #4
 
Manly393's Avatar
 
elite*gold: 0
Join Date: Apr 2008
Posts: 180
Received Thanks: 47
haha i had it there he didn't copy it all
Manly393 is offline  
Reply


Similar Threads Similar Threads
[Guide]Spawn Newbie Gift on newcomer inventory(replace method)!
08/24/2013 - EO PServer Guides & Releases - 11 Replies
Hello again, i want to show you how to add the newbie gift to the inventory of a new user without adding any npc or add the item to any shop. Ok let's start. When u login for the first time you will see in your inventory two not needed items: Shelley's Letter Queen`sLetter Those two items are totally useless so we are gonna to replace them with the newbie gift. Newbie Gift item id is 729012
[Help]Newbie Gift
06/29/2010 - EO PServer Hosting - 2 Replies
Iam asking about if i can add an starting Newbie Gift about lvl 1-20 super stuff without + i already have an +50 Newbie Gift High lvl iteams but i need to change them to lowest lvl with no + ! here is the +50 for the Newbie ! INSERT INTO `cq_action` VALUES ('70000524', '70000525', '70000539', '1001', '0', 'profession == 10'); INSERT INTO `cq_action` VALUES ('70000525', '70000526', '0000', '0502', '1021083', ''); INSERT INTO `cq_action` VALUES ('70000526', '70000527', '0000', '0501',...
[HELP]Newbie Gift
05/02/2010 - EO PServer Hosting - 2 Replies
the Newbie Gift is gived for the new player when they get in the game as lvl 1 can i change it to lvl 125 as when the player reached lvl 125 he must take this gift any idea's about that ?
Gving new members newbie gift automatically
08/11/2009 - EO PServer Hosting - 9 Replies
ok so i followed this guide to make the newbie items http://www.elitepvpers.com/forum/eo-pserver-hostin g/157851-make-newbiegift-give-255-a.html obviously ive edited it to what ever plus i wanted and no fsoul, but what i need to know is how to make it so when new members join they automatically recieve this. At the moment i have to manually award this item to them. when i searched the forums i only found that link above which only explains how to edit the items inside. if u can help...
Making a bot from scratch.
08/08/2009 - GW Bots - 3 Replies
Ok, so I want to make a bot, never done this sort of thing before, I know very little about AutoIt... And I also don't know German, so don't go pointing me to any of the various german guides. Are there any English guides already written for this? If so, can someone provide a link(s) please? It wouldn't just be helping me, I mean, there's so many other people on this forum that could use it. Thanks in advance :)



All times are GMT +1. The time now is 19:15.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.