I have the AVATAR mod installed on my Snitz forums. A long time ago I manually entered the full URL for the avatar images on a domain I hosted. I have since closed that domain, but in order to make short work of my AVATAR mod installation on other forums I host, I copied the AVATAR table from the original database to the other databases.
So now what I need to do is simply remove the full path of the avatars and set it localized to the forum/avatar/ folder.
Is this something I could do rather easily with the SQL Enterprise Manager, or would I need to write out some ASP to truncate the string and rewrite it to the database? Any support is appreciated.
If it was me, I'd probably pull the table into an asp page recordset, and then loop through the recordset editing the url column for each record (actually, I'd probably do this in VB but heck, this is an asp forum :)
Topic Locked
Posted - 10 June 2003 : 01:18:16
