Smilies css sprite

[fxdigi-cash]

Originally Posted by Zachery

You'd be surpised how many people want to do something, but don't have it setup.

Just update the urls for the smilies.

Hi Zachery, sorry to reply late, I got busy...

Thanks for the solution, but I've never thought I have to change the url for each smilie. what if I have 200 smilies on my board!! do I have to change the url to each one??

isn't there a better way to do that specifying a url to all smilies at once??

I'm just curious if there is a solution for any vb that has a lot of smilies!!

Thanks again

[Zachery]

You could do a query to replace them in the database, but that is not my forte.

[tpearl5]

Originally Posted by Zachery

You could do a query to replace them in the database, but that is not my forte.

You wouldn't be able to do it with a query alone since you can't do a find/replace via regex in MySQL. It would be easy if the file name were in a different field, but unfortunately you would need a script to loop through and make the URL changes to retain the file name.

You could use this to get a specific URL:

SELECT * FROM `smilie` WHERE `smiliepath` LIKE '%domain.com%'