| Author |
 Topic  |
|
willow
Starting Member
13 Posts |
 Posted - 17 November 2002 : 16:06:49
|
How can i delete all avatars or must i delete it one by one?
Please help me...
Greetings Willow |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 17 November 2002 : 19:11:50
|
| if you can get to the folder called avatars then simply delete all content... |
cHosting.nl |
 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 November 2002 : 19:18:24
|
That won't really remove the entries in the avatar folder folder ....
willow, if you're using Access you can delete all the records in the Avatar table. |
|
|
|
willow
Starting Member
13 Posts |
Posted - 18 November 2002 : 04:11:29
|
quote:
if you can get to the folder called avatars then simply delete all content...
Hay i did that all ready but just like laser was saying that won't really remove the entries in the avatar folder folder 
quote:
Willow, if you're using Access you can delete all the records in the Avatar table.
I have MS Access but what is an Avatar table? Sorry for my weak knowledge of asp.
Greetz willow |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 18 November 2002 : 04:47:09
|
hi~ willow,
why you'll need to do such a strange behavior ?? 
if you want to uninstall Avatar Mod, you can just undo/remove the code modified on topic.asp, pop_profile.asp, register.asp..... pages, then it will never show avatar again...
the database is ok, you can just ignore it, i think it wo'nt be anything influence to the forum function. if you really care about this, and want to delete the db table...
go to Admin Section/(Alternative MOD Setup)
then typing...
[DROP]
AVATAR
[END]
[ALERT]
MEMBERS
DROP#M_AVATAR_URL###
[END]
then press "submit", it'll be removed from db.... 
(make sure you really want to do this and be careful when doing this work..) |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 18 November 2002 : 06:21:46
|
willow, BE WARNED !!! ... I would NOT run this code !!!!
I just want to clarify, if you DO NOT want the avatar mod, so there is no avatar feature in your forum, go right ahead with DoraMoon's code.
But if you just want to get rid of the current icons that you have already, I think you need to use a different approach.
Also, I'm not 100% on the dbs format, but the way I read DoraMoon's code it delete remove the entire table, rather than just the contents
Edit ...
Further investigation shows : http://forum.snitz.com/forum/topic.asp?TOPIC_ID=36058&SearchTerms=dbs,format , but there's no documentation for DELETE which is what I think you need. |
Edited by - laser on 18 November 2002 06:38:21 |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 18 November 2002 : 07:55:18
|
well~~ laser is right,
sorry, i should remind you this first...
above my suggestion is totally remove the Avatar table..
DON'T DO THIS UNLESS YOU WANT TO TOTALLY REMOVE AVATAR MOD !
i'm still a little confuse what you really want to do ?? 
maybe you just want to reinstall all your avatar images....
if so... NEVER do what i said in previous post !!  |
|
|
|
willow
Starting Member
13 Posts |
Posted - 18 November 2002 : 08:30:37
|
I only want to delete the old avatars.And when that is happend i want to upload new ones. Excuse my bad english 
I have 600 unused avatars that must be deleted.
Can someone please explain in steps how to do this?
Thanks in advance
Willow |
Edited by - willow on 18 November 2002 08:32:08 |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 18 November 2002 : 08:46:23
|
hi~ willow,
sorry for my mistake.... thanks laser for saving your avatar mod.. 
i think if you can open your database with Access, just as laser mentioned, open your db with Access and click into FORUM_AVATAR table, then select the records you want to delete....
(after deleting, maybe you can also "compact/repair" this database, it can reset the A_ID autonumber...)
this one should be the easiest way to do this work, please try it first. if still any problem, then i think maybe we need to write a sql statement to do this job. (i'll try to make this later....) |
Edited by - DoraMoon on 18 November 2002 08:48:50 |
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 18 November 2002 : 10:36:57
|
ok~ here is a modified admin_delete_avatar.asp file ... admin_mass_delete_avatar.zip
just login as Admin then run it... it allow you delete a range of avatars at once.
but you need to know the A_ID value first, for example, you want to delete the avatars from A_ID=1 to A_ID=300, just input 1 and 300 then press Delete!
you can get the A_ID value in Review/Edit Avatar of Avatar Setup. (when mouse over the  or  , it will show A_ID in the link url at browser's status bar...)
i can't think about more easier way to do this.... the dbs [DELETE] seem also just can delete one by one, and if you also need to update the M_AVATAR_URL value, i think this could be the easiest way...
just try it if work for you.... |
|
|
|
willow
Starting Member
13 Posts |
Posted - 18 November 2002 : 11:40:18
|
Hey thanks for your fast reply and that you want to help me.
It means a lot to me.
I will try it and i will reply to you when it works ok?
Many thanks
Greetings Willow |
|
|
|
willow
Starting Member
13 Posts |
Posted - 18 November 2002 : 11:59:57
|
Hay,
When i tried to delete them it gives this error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'cLng'
/FORUM/admin_mass_delete_avatar.asp, line 64
Is there something wrong in line 64?
I hope i don't disturb you 
|
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 18 November 2002 : 13:37:41
|
hi~ willow,
there are two text input cell, make sure what you typing is "Number"!!
for example: you want to delete the avatar from A_ID = 12 to A_ID = 345
From A_ID = 12 To A_ID = 345
just input 12 and 345....
then all avatars in this range will be deleted.(if no this A_ID, it will skip and say Not Found..)....
coz it's a Admin page, so i did'nt check this number problem...
please try it again. |
|
|
|
willow
Starting Member
13 Posts |
Posted - 18 November 2002 : 18:45:15
|
Yeeessssssssss it worked.
Man you are good.
I take a bow for you.
Many many thanks oh great one.
Greetings willow |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 18 November 2002 : 19:15:40
|
| I'm glad that worked, I wasn't sure how to write the code myself for Snitz, but I had a feeling you wanted the mod, just not the current avatars |
|
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 19 November 2002 : 11:03:04
|
[ALERT]
MEMBERS
DROP#M_AVATAR_URL###
[END]
hey when u said this part in the dbs thing wot does this do??? i have never seen or heard of this function before.
can u plz explain wot it does??
thankx
MaD2ko0l |
© 1999-2010 MaD2ko0l |
|
|
|
Topic |
|
Topic Locked
