quote:

---

Private Messages Mod (Default)

Creating table(s)...
CREATE TABLE FORUM_PM( M_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , M_SUBJECT nvarchar (100) NULL , M_FROM int NULL , M_TO int NULL , M_SENT nvarchar (50) NULL , M_MESSAGE ntext NULL , M_PMCOUNT nvarchar (50) NULL , M_READ int NULL DEFAULT 0, M_MAIL nvarchar (50) NULL , M_OUTBOX smallint NULL DEFAULT 1)
Table already exists
________________________________________

Adding Column M_PMEMAIL...
ALTER TABLE FORUM_MEMBERS ADD M_PMEMAIL int NULL DEFAULT 0
ALTER TABLE FORUM_MEMBERS ADD M_PMEMAIL int NULL DEFAULT 0
-2147217900 | Column names in each table must be unique. Column name 'M_PMEMAIL' in table 'FORUM_MEMBERS' is specified more than once.
________________________________________

Adding Column M_PMRECEIVE...
ALTER TABLE FORUM_MEMBERS ADD M_PMRECEIVE int NULL DEFAULT 1
ALTER TABLE FORUM_MEMBERS ADD M_PMRECEIVE int NULL DEFAULT 1
-2147217900 | Column names in each table must be unique. Column name 'M_PMRECEIVE' in table 'FORUM_MEMBERS' is specified more than once.
________________________________________

Adding Column M_PMBLOCKLIST...
ALTER TABLE FORUM_MEMBERS ADD M_PMBLOCKLIST ntext NULL
ALTER TABLE FORUM_MEMBERS ADD M_PMBLOCKLIST ntext NULL
-2147217900 | Column names in each table must be unique. Column name 'M_PMBLOCKLIST' in table 'FORUM_MEMBERS' is specified more than once.
________________________________________

Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strPMLimit','20')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strPMStatus','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strPMStatus','1')
-2147217873 | Cannot insert duplicate key row in object 'FORUM_CONFIG_NEW' with unique index 'C_VARIABLE'.

---

Private Messages (Reinstall)

[DROP]
PM
[END]

[CREATE]
PM
M_ID
M_SUBJECT#varchar (100)#NULL#
M_FROM#int#NULL#
M_TO#int#NULL#
M_SENT#varchar (50)#NULL#
M_MESSAGE#memo#NULL#
M_PMCOUNT#varchar (50)#NULL#
M_READ#int#NULL#0
M_MAIL#varchar (50)#NULL#
M_OUTBOX#smallint#NULL#1
[END]

[ALTER]
MEMBERS
DROP#M_PMEMAIL###
DROP#M_PMRECEIVE###
DROP#M_PMBLOCKLIST###
[END]

[ALTER]
MEMBERS
ADD#M_PMEMAIL#int#NULL#0
ADD#M_PMRECEIVE#int#NULL#1
ADD#M_PMBLOCKLIST#memo#NULL#
[END]

[DELETE]
CONFIG_NEW
(C_VARIABLE='STRPMLIMIT')
(C_VARIABLE='STRPMSTATUS')
[END]

[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('strPMLimit','20')
(C_VARIABLE,C_VALUE)#('strPMStatus','1')
[END]

quote:

---

Davio - If you are still up for a challenge, I could use your assistance. It seems the version of the Event Calender I have does not have recurring events. Since a lot of the theme of my forum is history, a lot recurs! Could you

---