quote:

---

Originally posted by Chuck McB

ok, will get my IP-less tester to ...erm...test it...

---

quote:

---

Originally posted by Chuck McB

quote:

---

Originally posted by Chuck McB

ok, will get my IP-less tester to ...erm...test it...

---

Tested (finally) and working fine. Nice one :)

---

quote:

---

Dropping Table..
DROP TABLE FORUM_IPLIST
-2147467259 | [TCX][MyODBC]Unknown table 'FORUM_IPLIST'

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_IPLIST ( IPLIST_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLIST_MEMBERID varchar(32) NULL DEFAULT 0, IPLIST_STARTIP varchar(32) NULL , IPLIST_STARTDATE varchar(32) NULL , IPLIST_ENDDATE varchar(32) NULL , IPLIST_COMMENT varchar(255) NULL , IPLIST_STATUS varchar(8) NULL , IPLIST_DBPAGEKEY varchar(32) NULL ,KEY FORUM_IPLIST _IPLIST_ID(IPLIST_ID))
CREATE TABLE FORUM_IPLIST ( IPLIST_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLIST_MEMBERID varchar(32) NULL DEFAULT 0, IPLIST_STARTIP varchar(32) NULL , IPLIST_STARTDATE varchar(32) NULL , IPLIST_ENDDATE varchar(32) NULL , IPLIST_COMMENT varchar(255) NULL , IPLIST_STATUS varchar(8) NULL , IPLIST_DBPAGEKEY varchar(32) NULL ,KEY FORUM_IPLIST _IPLIST_ID(IPLIST_ID))
-2147217911 | [TCX][MyODBC]You have an error in your SQL syntax near '_IPLIST_ID(IPLIST_ID))' at line 1

--------------------------------------------------------------------------------

Dropping Table..
DROP TABLE FORUM_PAGEKEYS
-2147467259 | [TCX][MyODBC]Unknown table 'FORUM_PAGEKEYS'

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_PAGEKEYS ( PAGEKEYS_ID INT (11) DEFAULT '' NOT NULL auto_increment , PAGEKEYS_PAGEKEY varchar(32) NULL ,KEY FORUM_PAGEKEYS _PAGEKEYS_ID(PAGEKEYS_ID))
CREATE TABLE FORUM_PAGEKEYS ( PAGEKEYS_ID INT (11) DEFAULT '' NOT NULL auto_increment , PAGEKEYS_PAGEKEY varchar(32) NULL ,KEY FORUM_PAGEKEYS _PAGEKEYS_ID(PAGEKEYS_ID))
-2147217911 | [TCX][MyODBC]You have an error in your SQL syntax near '_PAGEKEYS_ID(PAGEKEYS_ID))' at line 1
--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_PAGEKEYS (PAGEKEYS_PAGEKEY) VALUES ('post.asp')
INSERT INTO FORUM_PAGEKEYS (PAGEKEYS_PAGEKEY) VALUES ('post.asp')
-2147467259 | [TCX][MyODBC]Table 'venues_info.FORUM_PAGEKEYS' doesn't exist

--------------------------------------------------------------------------------

Dropping Table..
DROP TABLE FORUM_IPLOG
-2147467259 | [TCX][MyODBC]Unknown table 'FORUM_IPLOG'

--------------------------------------------------------------------------------

Creating table(s)...
CREATE TABLE FORUM_IPLOG( IPLOG_ID INT (11) DEFAULT '' NOT NULL auto_increment , IPLOG_MEMBERID varchar(32) NULL DEFAULT 0, IPLOG_IP varchar(32) NULL , IPLOG_PATHINFO varchar(255) NULL , IPLOG_DATE varchar(32) NULL ,KEY FORUM_IPLOG_IPLOG_ID(IPLOG_ID))
Table created succesfully

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEBAN','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELCK','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATECOK','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEMET','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEMSG','You are banned from these forums')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELKMSG','Forums are currently locked')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATENOACMSG','You do not have access to the requested page')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEWARNMSG','Your or another persons activity is being logged')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEVER','Ver 2.2.7')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATELOG','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATETYP','0')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATEEXP','15')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRIPGATECSS','0')

Value(s) updated succesfully

---

quote:

---

#
# Table structure for table 'FORUM_IPLIST'
#

DROP TABLE IF EXISTS `FORUM_IPLIST`;
CREATE TABLE `FORUM_IPLIST` (
`IPLIST_ID` INT NOT NULL AUTO_INCREMENT,
`IPLIST_MEMBERID` VARCHAR(32),
`IPLIST_STARTIP` VARCHAR(32),
`IPLIST_STARTDATE` VARCHAR(32),
`IPLIST_ENDDATE` VARCHAR(32),
`IPLIST_COMMENT` VARCHAR(255),
`IPLIST_STATUS` VARCHAR(8),
`IPLIST_DBPAGEKEY` VARCHAR(32),
PRIMARY KEY `PrimaryKey` (`IPLIST_ID`)
);

#
# Dumping data for table 'FORUM_IPLIST'
#

LOCK TABLES `FORUM_IPLIST` WRITE;
UNLOCK TABLES;

#
# Table structure for table 'FORUM_IPLOG'
#

DROP TABLE IF EXISTS `FORUM_IPLOG`;
CREATE TABLE `FORUM_IPLOG` (
`IPLOG_ID` INT NOT NULL AUTO_INCREMENT,
`IPLOG_MEMBERID` VARCHAR(32),
`IPLOG_IP` VARCHAR(32),
`IPLOG_PATHINFO` VARCHAR(255),
`IPLOG_DATE` VARCHAR(32),
PRIMARY KEY `PrimaryKey` (`IPLOG_ID`)
);

#
# Dumping data for table 'FORUM_IPLOG'
#

LOCK TABLES `FORUM_IPLOG` WRITE;
UNLOCK TABLES;

#
# Table structure for table 'FORUM_PAGEKEYS'
#

DROP TABLE IF EXISTS `FORUM_PAGEKEYS`;
CREATE TABLE `FORUM_PAGEKEYS` (
`PAGEKEYS_ID` INT NOT NULL AUTO_INCREMENT,
`PAGEKEYS_PAGEKEY` VARCHAR(32),
PRIMARY KEY `PrimaryKey` (`PAGEKEYS_ID`)
);

#
# Dumping data for table 'FORUM_PAGEKEYS'
#

LOCK TABLES `FORUM_PAGEKEYS` WRITE;
UNLOCK TABLES;

---