| 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 |
|
|
|
Topic Locked
.