Changed smilies, can old 'Text to Replace' still showing/redirect to new smilies?

[basketmen]

i want to change some smilies 'Text to Replace'

for example

old 'Text to Replace' is :lol:

new 'Text to Replace' is :-)

can :lol: still be showing/redirect to new 'Text to Replace' :-) smilies some way?

too bad if old posts that still using 'Text to Replace' :lol: the smilies are not showing again

[Digital Jedi]

If you change the replacement text of a Smiley in the Smileys Manager, the old text will not work anymore, and all that will show in old posts is the text. If you don't want that, you can just upload the Smiley under a different file name, and use different text for it. However, the old Smiley will still show in the Smileys List whenever it's opened. You can push it down to the bottom or to another category, if you like.

You could also try using something like Word Replacement to always change the old :lol: to the new text.

[BirdOPrey5]

Change your smiley settings then...

Just run an MySQL query on your post table...

update `PREFIX_post` set pagetext = replace (pagetext, ':lol:' , ':-)')

Obviously make sure you have a backup before you attempt manual changes on the database but it should be no problem.

Replace "PREFIX_" with whatever prefix you set in your config.php file, if any.

[basketmen]

Originally Posted by BirdOPrey5

Change your smiley settings then...

Just run an MySQL query on your post table...

update `PREFIX_post` set pagetext = replace (pagetext, ':lol:' , ':-)')

Obviously make sure you have a backup before you attempt manual changes on the database but it should be no problem.

Replace "PREFIX_" with whatever prefix you set in your config.php file, if any.

thank you for answering guys,


i already checked config.php, which one prefix that you mean actually

here is the config.php content

$config['Database']['tableprefix'] = '';


$config['Misc']['cookieprefix'] = 'bb';

[BirdOPrey5]

table prefix, yours in blank so the query would be:

update `post` set pagetext = replace (pagetext, ':lol:' , ':-)')

How big is your posts table (how many posts do you have)? If it's a lot I would suggest turning off the forum just as an extra precaution before running the query.

[basketmen]

Originally Posted by BirdOPrey5

table prefix, yours in blank so the query would be:

update `post` set pagetext = replace (pagetext, ':lol:' , ':-)')

How big is your posts table (how many posts do you have)? If it's a lot I would suggest turning off the forum just as an extra precaution before running the query.

thank you very much, this is works before for replacing old smilies to new smilies





i have similar problem now


my forum url is changed, from with www ( http://www.domain.com ), to without www ( http://domain.com )




i had try this

update `post` set pagetext = replace (pagetext, 'www.domain.com', 'domain.com')

or
update `post` set pagetext = replace (pagetext, 'http://www.domain.com', 'http://domain.com')




but its not works, its just says Affected Rows: 0 (3.0977s)


please help, how to change it in post table, there are a lot of them in post table

[BirdOPrey5]

I responded to your vb.com thread.

[v123shine]

open vbulletin option >> site name / url / contact details >> remove www from your 'forum url' and 'homepage url'.

i had try this

update `post` set pagetext = replace (pagetext, 'www.domain.com', 'domain.com')

or
update `post` set pagetext = replace (pagetext, 'http://www.domain.com', 'http://domain.com')




but its not works, its just says Affected Rows: 0 (3.0977s)