[Question] Concerning Noobie Gift

[[GM]Death[PM]]

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. =)

[alina1]

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.

[[GM]Death[PM]]

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.

[~WARNING~]

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

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]');

[PraDevil[ELITE]]

....*Bump* sorry

[mama12]

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

[[GM]Death[PM]]

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

[Knight^Hawk]

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

[[GM]Death[PM]]

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. =)

[Knight^Hawk]

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...

[mama12]

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

[.Ash]

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.

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.