[Question] Concerning Noobie Gift

03/11/2010 00:14 [GM]Death[PM]#1

So I have added the starter noobie gift and I'm not satisfied with it. I have searched and yet have found nothing on how to delete the noobie gift. Maybe I over looked it if there is a post on this topic already. If so, Send me the link. If you have any information regarding this it would be helpful. Thank you

Also I have looked for a way to edit the amount of eps you obtain by killing mobs (auto ep)
If I have over looked this I am sorry for this as well. I'm a pretty busy person so I sometimes over look things. =)

03/11/2010 00:24 alina1#2

Back up ur db before u do anything. I know it is a pain especially if u r trying different things.

Try running this query if u added the +255 gears.

delete from cq_action where id >= 6000524 and id <= 6000532;
delete from cq_action where id >= 6000539 and id <= 6000546;
delete from cq_action where id >= 6000547 and id <= 6000554;

I dont have the navicat open, but look at the query u ran. It adds the gift to the cq_action. See what action numbers it affects and delete them from ur cq_action -

Example - INSERT INTO `cq_action` VALUES ('6000524', '6000525', '6000539', '1001', '0', 'profession == 10'); Delete values 6000524, 6000525 and 6000539

I think that should do it, but dont keep me accountable heheheehe.

Remember make a back up before u make any changes.

03/11/2010 00:34 [GM]Death[PM]#3

It was the noobie gift. For example your a new character, You log on and you receive the +12 f-soul level 8 noobie gears. That's the one I'm trying to take out. =) But thank you, I sort of have an idea of what to do.

03/11/2010 01:14 ~WARNING~#4

try this(edit all of the red stuff according to your needs)

Code:

delete from cq_action where id >= 1000010 and id <= 1000026;

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, '[COLOR=Red]Welcome~to~**~EO~![/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000012, 1000013, 0000, 1080, 9000, 'new');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000013, 1000014, 0000, 0501, [COLOR=Red]111113[/COLOR], '[COLOR=Red]7000 7000 0 255 255 0 0 12 0 1024 0 0[/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000014, 1000015, 0000, 0501, [COLOR=Red]115113[/COLOR], '[COLOR=Red]7000 7000 0 255 255 0 0 12 0 1024 0 0[/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000015, 1000016, 0000, 0501, [COLOR=Red]121113[/COLOR], '[COLOR=Red]7000 7000 0 255 255 0 0 12 0 1024 0 0[/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000016, 1000017, 0000, 0501, [COLOR=Red]125113[/COLOR], '[COLOR=Red]7000 7000 0 255 255 0 0 12 0 1024 0 0[/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000017, 1000018, 0000, 0501, [COLOR=Red]131113[/COLOR], '[COLOR=Red]7000 7000 0 255 255 0 0 12 0 1024 0 0[/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000018, 1000019, 0000, 0501, [COLOR=Red]135113[/COLOR], '[COLOR=Red]7000 7000 0 255 255 0 0 12 0 1024 0 0[/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000019, 1000020, 0000, 0501, [COLOR=Red]141113[/COLOR], '[COLOR=Red]7000 7000 0 255 255 0 0 12 0 1024 0 0[/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000020, 1000021, 0000, 0501, [COLOR=Red]145113[/COLOR], '[COLOR=Red]7000 7000 0 255 255 0 0 12 0 1024 0 0[/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000021, 1000022, 0000, 1001, 0, '[COLOR=Red]money += 100000000[/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000022, 1000023, 0000, 1001, 0, '[COLOR=Red]emoney += 100000[/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000023, 1000024, 0000, 1081, 9000, 'phase = 1');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000024, 1000025, 0000, 0126, 0, '[COLOR=Red]Welcome~to~SERVERNAME~!~SOME~MESSAGE~YOU~WANT~TO~PUT![/COLOR]');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (1000025, 1000026, 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   (1000026, 0000, 0000, 0125, 2011, '[COLOR=Red]%user_name~Has~Recieved~His~Gift[/COLOR]');

03/11/2010 02:04 PraDevil[ELITE]#5

....*Bump* sorry

03/11/2010 02:09 mama12#6

ibeat u all and pradevil Did you guys read his Post????

QUOTE: "yet have found nothing on how to delete the noobie gift"

What you giving him is not what he asked 4! LOL. Just Spam away.

P.S. I agree with alina1. Look for Cq_action Id and Id next and Id fail - first 3 #s in query and remove them.

And ya back up ur stuff

03/11/2010 02:12 [GM]Death[PM]#7

Hmm I'm kind of sketchy on actually trying this. Don't want someones "idea" being a fail. I want to know its going to work. lol

03/11/2010 02:30 Knight^Hawk#8

delete the newbie gift from the itemtype ID: 729012 and delete it from the cq_action. ID RANGE: 6000524-6000554

autoep is in the cq_action ID RANGE: 1-like 70 or 100 not sure

always back up b4 you change anything

03/11/2010 03:18 [GM]Death[PM]#9

I have the auto ep fixed and as for the noobie gift. Rather than hurting my head trying to figure out how to delete them some have recommended I keep them in. Thank you all for the help. =)

03/11/2010 04:17 Knight^Hawk#10

all u really need to do is delete it from the cq action. filter id is between 6000524 6000554

NOTE: mine is 6000524-6000560 becuase i added pally weapons to it...

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

03/11/2010 06:00 mama12#11

Death Back up ur DB. Stop the MySql Admin. Then make a data rar. If the suggested actions dont work, u ll still have your old db saved in the rar.

IF When u trying to make a rar and it tells u that the program so and so is being used by another program - go to task manager -> Processes and stop mysqld-nt.exe

03/11/2010 12:55 .Ash#12

You said you wanted to change the EP that monster give when killed correct? well in Murtahs Auto EP System.. Change few things.. Ill show you how to do few of them.

Code:

INSERT INTO `cq_action` VALUES ('1', '2', '0000', '1001', '0', '[COLOR="Red"]e_money += 5[/COLOR]');
INSERT INTO `cq_action` VALUES ('2', '0', '0000', '1010', '2005', '[COLOR="Navy"]You found 5 EudemonPoints from a MadBull![/COLOR]');
INSERT INTO `cq_action` VALUES ('3', '4', '0000', '1001', '0', '[COLOR="Red"]e_money += 10[/COLOR]');
INSERT INTO `cq_action` VALUES ('4', '0', '0000', '1010', '2005', '[COLOR="Navy"]You found 10 EudemonPoints from a GreenGiant![/COLOR]');
INSERT INTO `cq_action` VALUES ('5', '6', '0000', '1001', '0', '[COLOR="Red"]e_money += 15[/COLOR]');
INSERT INTO `cq_action` VALUES ('6', '0', '0000', '1010', '2005', '[COLOR="Navy"]You found 15 EudemonPoints from a BullyWug![/COLOR]');
INSERT INTO `cq_action` VALUES ('7', '8', '0000', '1001', '0', '[COLOR="Red"]e_money += 20[/COLOR]');
INSERT INTO `cq_action` VALUES ('8', '0', '0000', '1010', '2005', '[COLOR="Navy"]You found 20 EudemonPoints from a Gnome![/COLOR]');
INSERT INTO `cq_action` VALUES ('9', '10', '0000', '1001', '0', '[COLOR="Red"]e_money += 30[/COLOR]');
INSERT INTO `cq_action` VALUES ('10', '0', '0000', '1010', '2005', '[COLOR="Navy"]You found 30 EudemonPoints from a Dragonkin![/COLOR]');

Legend:
Red= The EP That gives the player When monster is killed.
Blue= The message it shows the player when the monster is killed.