| Author |
 Topic  |
|
|
Radianation
Junior Member
USA
186 Posts |
 Posted - 10 June 2003 : 01:18:16
|
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. |
Edited by - ruirib on 11 June 2003 07:37:35 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 10 June 2003 : 02:04:53
|
| 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 :) |
======
Doug G
======
Computer history and help at www.dougscode.com |
 |
|
|
Radianation
Junior Member
USA
186 Posts |
Posted - 10 June 2003 : 12:08:29
|
| ok, I'll give that a shot. Thanks! |
|
|
|
Radianation
Junior Member
USA
186 Posts |
Posted - 10 June 2003 : 16:33:27
|
| Actually, was there a script already designed for importing avatars? |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 11 June 2003 : 08:52:00
|
| The avatar mod I adapted has a import feature. |
|
|
| |
Topic |
|
Topic Locked
