Taking System out

02/05/2011 22:56 stedabest321#1
Ok, In my server, Untoldlegends. When people use the 999 Flowers it comes up saying ... E.g

Code:
Teddy Sent Kisses 999Roses to Show his love for her
In the System chat, This gets realy annoying when a player buys 50 Flowers or somthing and Uses them all as you can imagin your trying to talk to a friend
and its going

Code:
Teddy Sent Kisses 999Roses to Show his love for her
Teddy Sent Kisses 999Roses to Show his love for her
Teddy Sent Kisses 999Roses to Show his love for her
Teddy Sent Kisses 999Roses to Show his love for her
Teddy Sent Kisses 999Roses to Show his love for her
Teddy Sent Kisses 999Roses to Show his love for her
Teddy Sent Kisses 999Roses to Show his love for her
Lmao it would be nice if some one can help with this because i had so many Complaints about this, and it would be alot better to just Take them fully out
"the System Info"

Thanks in advance to any one going to help me out there tyvm :)

fgcxbfv

ggfd

Can any one help with this sorry for the double post no one replyed to it can any one help ??
02/07/2011 12:56 PraDevil[ELITE]#2
i dont kow why dont u search it on your db or msg(i not remember well since i quit eo)
Code:
999Roses
02/07/2011 13:15 AziQ#3
yes .did u try to search in cq_action .?
02/07/2011 16:56 40z10Q#4
Exactly .if any sentences pops out at [GM] message some of them can be edit from cq_action and some of them can be edited at msg server .so if those sentences pops out at the chat side so i think u can edit em at cq_action .
02/07/2011 19:01 stedabest321#5
I tryed all off it I was wondering if it was Msg Server but the Rates on that are guna be high to find it ;(
02/07/2011 22:58 [GM]RageIsName[PM]#6
hmnn?? try searching in the cq_action if not then....your doomed
02/08/2011 04:05 stedabest321#7
-.- did u read the above ?
Quote:
Exactly .if any sentences pops out at [GM] message some of them can be edit from cq_action and some of them can be edited at msg server .so if those sentences pops out at the chat side so i think u can edit em at cq_action .
Quote:
I tryed all off it I was wondering if it was Msg Server but the Rates on that are guna be high to find it ;(
Maybe read that
02/08/2011 13:27 40z10Q#8
Quote:
Originally Posted by [GM]RageIsName[PM] View Post
hmnn?? try searching in the cq_action if not then....your doomed
dont talk like u know everything .i think u are the most user that post HELP thread .so watch your mouth .
02/08/2011 16:49 PraDevil[ELITE]#9
Quote:
Originally Posted by 40z10Q View Post
dont talk like u know everything .i think u are the most user that post HELP thread .so watch your mouth .
and dont post if u didnt have anything usefull to tell..enough with your first help and i think he can solve it by using his brain..sorry DP and KA for some &^#!( here..lets stay on topic guys
02/09/2011 01:42 stedabest321#10
Quote:
Originally Posted by PraDevil[ELITE] View Post
and dont post if u didnt have anything usefull to tell..enough with your first help and i think he can solve it by using his brain..sorry DP and KA for some &^#!( here..lets stay on topic guys
hmmm. i checked the cq_action i just cant find anything else :'( im guna look now but if u know tell me please thx
02/09/2011 04:44 PraDevil[ELITE]#11
find the roses id(cq_itemtype) look at id_action that will be your cq_action id..take action id and search on cq_action..you will find it

edit:

after checking on my old query..i also has change some of this kind of GM message..here is it :)
Code:
update cq_action set param='%user_name has sent 999 WhiteRose to #79%target_name#79 for their Love forever..' where id=9107127;
update cq_action set param='%user_name has sent 99 WhiteRose to #79%target_name#79 for their Love forever..' where id=9107117;
update cq_action set param='%user_name has sent 999 RedRose to #78%target_name#78 for their Love forever..' where id=9107087;
update cq_action set param='%user_name has sent 99 RedRose to #78%target_name#78 for their Love forever..' where id=9107077;
02/09/2011 11:38 stedabest321#12
I dont mean the GM BoradCast i mean the System in the Chat where people spamm that wih flowers
02/09/2011 13:57 PraDevil[ELITE]#13
i dont really understand what you mean..can you put pic for it?
02/09/2011 14:13 stedabest321#14
[Only registered and activated users can see links. Click Here To Register...]


There, where it says like Sent 999 roses to **************************
Etc, that part
02/09/2011 15:40 King_Arthur#15
Do you get any results if you run this query?
Code:
SELECT * FROM cq_action WHERE param LIKE '%to~show~his~love%' AND `data` = 2011;