Author |
Topic |
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 05 October 2003 : 02:52:32
|
Hi,
I would like to remove the Avatar Mod from my forum.
Reversing the the files changing is no problem, but how do I reverse/delete the database changings?
This is the dbs file for the Avata Mod I hade implemented before and need to delete: ----------- Avatar Mod for 3.4 [CREATE] AVATAR A_ID A_URL#varchar (255)#NULL# A_NAME#varchar (50)#NULL# A_MEMBER_ID#int#NULL#0 [END] [ALTER] MEMBERS ADD#M_AVATAR_URL#varchar (255)#NULL# [END] [ALTER] MEMBERS_PENDING ADD#M_AVATAR_URL#varchar (255)#NULL# [END] [INSERT] CONFIG_NEW (C_VARIABLE,C_VALUE)#('intShowAvatar','1') (C_VARIABLE,C_VALUE)#('strAvatarFolder','avatars/') (C_VARIABLE,C_VALUE)#('intAvatarWidth','64') (C_VARIABLE,C_VALUE)#('intAvatarHeight','64') (C_VARIABLE,C_VALUE)#('intAvatarBorder','1') [END]
----------------- My guess is that this might be correct? ----------------- Avatar Mod for 3.4 [DELETE] AVATAR A_ID A_URL#varchar (255)#NULL# A_NAME#varchar (50)#NULL# A_MEMBER_ID#int#NULL#0 [END] [ALTER] MEMBERS DEL#M_AVATAR_URL#varchar (255)#NULL# [END] [ALTER] MEMBERS_PENDING DEL#M_AVATAR_URL#varchar (255)#NULL# [END] [DELETE] CONFIG_NEW (C_VARIABLE,C_VALUE)#('intShowAvatar','1') (C_VARIABLE,C_VALUE)#('strAvatarFolder','avatars/') (C_VARIABLE,C_VALUE)#('intAvatarWidth','64') (C_VARIABLE,C_VALUE)#('intAvatarHeight','64') (C_VARIABLE,C_VALUE)#('intAvatarBorder','1') [END] ------------
Is this correct?
Cheers / Tomas
|
!-Keep distance in traffic-! www.whiplashinfo.se |
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 05 October 2003 : 08:13:33
|
No, that isn't right, even though it is a logical assumption. To drop a table, the code is:
[DROP] AVATAR [END]
To drop a field in a table, the code is:
[ALTER] MEMBERS DROP#M_AVATAR_URL### [END]
There is a full description on how to create a dbs-file in this topic, so that you can check it out yourself. |
Jan =========== FR Portal Forums | Active Users 4.0.20 Mod |
|
|
EvilRick
Starting Member
37 Posts |
Posted - 12 October 2003 : 18:32:07
|
[ALTER]
CONFIG_NEW
DROP#(C_VARIABLE,C_VALUE)#('strCMSLeftNavWidth','150')
DROP#(C_VARIABLE,C_VALUE)#('strCMSLeftNavDisplay','5')
DROP#(C_VARIABLE,C_VALUE)#('strCMSLeftNavItems','1')
DROP#(C_VARIABLE,C_VALUE)#('strCMSRightNavWidth','150')
DROP#(C_VARIABLE,C_VALUE)#('strCMSRightNavDisplay','5')
DROP#(C_VARIABLE,C_VALUE)#('strCMSRightNavItems','1')
DROP#(C_VARIABLE,C_VALUE)#('strCMSEnableSearch','1')
DROP#(C_VARIABLE,C_VALUE)#('strCMSDefaultCID','0')
DROP#(C_VARIABLE,C_VALUE)#('strCMSPageTitle','Portal')
DROP#(C_VARIABLE,C_VALUE)#('strCMSTitleDisplay','1')
[END]
I'm trying to remove these values from the CONFIG_NEW table, but it's not working. What do I have to change, and where to get rid of those string values?
TIA |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 12 October 2003 : 19:09:15
|
Im not sure if it is possible to remove specific records with a dbs-file, only columns. I think you need to use sql-queries to accomplish that. |
Jan =========== FR Portal Forums | Active Users 4.0.20 Mod |
|
|
EvilRick
Starting Member
37 Posts |
Posted - 12 October 2003 : 19:40:48
|
I will give that a try then.
Thanks! |
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
Topic |
|
|
|