[GUIDE]Remove VIP login effect/message

02/14/2010 22:02 ~WARNING~#1

Very simple to remove these.

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

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

Step 1. Go in to navicat, Cq_action
Step 2. View > sort > decending
step 3. search for the following action ID: 27779127
Step 4. Also find the following ID: 27779100
Step 5. change the type values to "0" for the rows between 27779127 and 27779100
Step 6. enjoy a effect/message free login

02/14/2010 22:27 zspider#2

and if i wanaa add them (effect-message) how to do that???

02/14/2010 22:34 ~WARNING~#3

edit the params of ID 27779117 - 27779110

for example, the params of all 7 of those, are in this form:
241 0 86400 0

where 241 0 86400 0 is the KIND of effect.

EDIT: remember if your not removing, do not remove the type values.

02/14/2010 22:58 zspider#4

Quote:

Originally Posted by ibeatuall

edit the params of ID 27779117 - 27779110

for example, the params of all 7 of those, are in this form:
241 0 86400 0

where 241 0 86400 0 is the KIND of effect.

EDIT: remember if your not removing, do not remove the type values.

i searched for this ids 27779117 - 27779110 in cq_action but i didn't find it

02/14/2010 23:14 ~WARNING~#5

remove limiting for pages.

02/15/2010 03:24 chathouse#6

Code:

27779100	27779110	27779101	5001	0	== 4
27779101	27779111	27779102	5001	0	== 5
27779102	27779112	27779103	5001	0	== 6
27779103	27779113	27779104	5001	0	== 7
27779104	27779114	27779105	5001	0	== 8
27779105	27779115	27779106	5001	0	== 9
27779106	27779116	27779107	5001	0	== 10
27779107	27779117	0	5001	0	== 11
27779110	27779110	0	4001	0	241 0 86400 0
27779111	27779121	0	4001	0	242 0 86400 0
27779112	27779122	0	4001	0	243 0 86400 0
27779113	27779123	0	4001	0	244 0 86400 0
27779114	27779124	0	4001	0	245 0 86400 0
27779115	27779125	0	4001	0	246 0 86400 0
27779116	27779126	0	4001	0	247 0 86400 0
27779117	27779127	0	4001	0	156 0 86400 0
27779120	0	0	125	2011	Lvl~4~VIP~member~%user_name~has~just~logged~in.
27779121	0	0	125	2011	Lvl~5~VIP~member~%user_name~has~just~logged~in.
27779122	0	0	125	2011	Lvl~6~VIP~member~%user_name~has~just~logged~in.
27779123	0	0	125	2011	Lvl~7~VIP~member~%user_name~has~just~logged~in.
27779124	0	0	125	2011	Lvl~8~VIP~member~%user_name~has~just~logged~in.
27779125	0	0	125	2011	Lvl~9~VIP~member~%user_name~has~just~logged~in.
27779126	0	0	125	2011	Lvl~10~VIP~member~%user_name~has~just~logged~in.
27779127	0	0	125	2011	Lvl~11~VIP~member~%user_name~has~just~logged~in.

that's all for vip level. in cq_action and has nothing to do with the effect of if you are vip

02/15/2010 03:28 ~WARNING~#7

actually it does, because now that i've removed those new players no longer have the glow, to remove the old glow you have to remove the magic effect

02/15/2010 03:36 chathouse#8

and what I would need to edit to remove the overall effect on the character?

02/15/2010 03:49 ~WARNING~#9

im still searching for the table they are in, as far as i know they are perm.

02/15/2010 09:16 zspider#10

so if i wanaa add it will be like that or i must add cq_task or what??

Code:

INSERT INTO `cq_action` VALUES ('27779100', '27779110', '27779101', '5001', '0', '== 4');
INSERT INTO `cq_action` VALUES ('27779101', '27779111', '27779102', '5001', '0', '== 5');
INSERT INTO `cq_action` VALUES ('27779102', '27779112', '27779103', '5001', '0', '== 6');
INSERT INTO `cq_action` VALUES ('27779103', '27779113', '27779104', '5001', '0', '== 7');
INSERT INTO `cq_action` VALUES ('27779104', '27779114', '27779105', '5001', '0', '== 8');
INSERT INTO `cq_action` VALUES ('27779105', '27779115', '27779106', '5001', '0', '== 9');
INSERT INTO `cq_action` VALUES ('27779106', '27779116', '27779107', '5001', '0', '== 10');
INSERT INTO `cq_action` VALUES ('27779107', '27779117', '0', '5001', '0', '== 11');
INSERT INTO `cq_action` VALUES ('27779110', '27779110', '0', '4001', '0', '241 0 86400 0');
INSERT INTO `cq_action` VALUES ('27779111', '27779121', '0', '4001', '0', '242 0 86400 0');
INSERT INTO `cq_action` VALUES ('27779112', '27779122', '0', '4001', '0', '243 0 86400 0');
INSERT INTO `cq_action` VALUES ('27779113', '27779123', '0', '4001', '0', '244 0 86400 0');
INSERT INTO `cq_action` VALUES ('27779114', '27779124', '0', '4001', '0', '245 0 86400 0');
INSERT INTO `cq_action` VALUES ('27779115', '27779125', '0', '4001', '0', '246 0 86400 0');
INSERT INTO `cq_action` VALUES ('27779116', '27779126', '0', '4001', '0', '247 0 86400 0');
INSERT INTO `cq_action` VALUES ('27779117', '27779127', '0', '4001', '0', '156 0 86400 0');
INSERT INTO `cq_action` VALUES ('27779120', '0', '0', '2011', '0', 'Lvl~4~VIP~member~%user_name~has~just~logged~in.');
INSERT INTO `cq_action` VALUES ('27779121', '0', '0', '2011', '0', 'Lvl~5~VIP~member~%user_name~has~just~logged~in.');
INSERT INTO `cq_action` VALUES ('27779122', '0', '0', '2011', '0', 'Lvl~6~VIP~member~%user_name~has~just~logged~in.');
INSERT INTO `cq_action` VALUES ('27779123', '0', '0', '2011', '0', 'Lvl~7~VIP~member~%user_name~has~just~logged~in.');
INSERT INTO `cq_action` VALUES ('27779124', '0', '0', '2011', '0', 'Lvl~8~VIP~member~%user_name~has~just~logged~in.');
INSERT INTO `cq_action` VALUES ('27779125', '0', '0', '2011', '0', 'Lvl~9~VIP~member~%user_name~has~just~logged~in.');
INSERT INTO `cq_action` VALUES ('27779126', '0', '0', '2011', '0', 'Lvl~10~VIP~member~%user_name~has~just~logged~in.');
INSERT INTO `cq_action` VALUES ('27779127', '0', '0', '2011', '0', 'Lvl~11~VIP~member~%user_name~has~just~logged~in.');

02/15/2010 21:38 chathouse#11

I do not now know exactly .. If messages are also available with the respective ID can you delete via cq_task.

I have not yet looked so well .. therefore stored in my pile ne amount of text files .. so I can remove many database entries. And thus save space.

Only if you jump in removing cq_action do these messages in the broadcast or not more than GM message a which is logged with a VIP level.

02/16/2010 04:11 zspider#12

Quote:

Originally Posted by chathouse

I do not now know exactly .. If messages are also available with the respective ID can you delete via cq_task.

I have not yet looked so well .. therefore stored in my pile ne amount of text files .. so I can remove many database entries. And thus save space.

Only if you jump in removing cq_action do these messages in the broadcast or not more than GM message a which is logged with a VIP level.

so if i wanaa add this things how to do that???

02/16/2010 04:16 ~WARNING~#13

you have to make it load the action ID's when a player logs in

02/16/2010 14:52 chathouse#14

Quote:

Originally Posted by zspider

so if i wanaa add this things how to do that???

with no manual, I really meant to remove the ... is in the candy version that already exists.

If you want to have, .. You need to insert the codes only if the IDs are not used. Otherwise you'll just have to complete the IDS change.

Regarding the cq_task so no i have testing 3 different ID and none of them are here, .. I think the more the cq_task is needed only for NPCs, or where an action takes place .. So by clicking the mouse.

If you want to stop the build you need only bring in de cq_action, .. expand and stop if you want to have it displayed at various VIPs from lvl 1 - lvl 8 or more....