-- MySQL dump 8.22 -- -- Host: localhost Database: centurywebdesign_com --------------------------------------------------------- -- Server version 3.23.54 -- -- Table structure for table 'altuseremail' -- CREATE TABLE altuseremail ( id int(11) NOT NULL auto_increment, userid int(11) NOT NULL default '0', email varchar(50) NOT NULL default '', sendnotifications tinyint(4) NOT NULL default '0', sendinvoice tinyint(4) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'altuseremail' -- -- -- Table structure for table 'billingtype' -- CREATE TABLE billingtype ( id int(11) NOT NULL auto_increment, name varchar(25) NOT NULL default '', description text NOT NULL, detail text NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'billingtype' -- INSERT INTO billingtype VALUES (1,'Hosting','New Domain Hosting','domain.com (/month) x = $'); INSERT INTO billingtype VALUES (2,'Maintenance','Maintenance','Default maintenance detail'); INSERT INTO billingtype VALUES (3,'Development','Development','Default development detail'); INSERT INTO billingtype VALUES (4,'Installation','Installation','Default installation detail'); INSERT INTO billingtype VALUES (5,'Misc.','Misc.','Default Misc. description'); INSERT INTO billingtype VALUES (6,'Overusage','Overusage','Default overusage detail'); -- -- Table structure for table 'cache' -- CREATE TABLE cache ( cachekey varchar(50) NOT NULL default '', lastupdated datetime NOT NULL default '0000-00-00 00:00:00', content text NOT NULL, PRIMARY KEY (cachekey) ) TYPE=MyISAM; -- -- Dumping data for table 'cache' -- INSERT INTO cache VALUES ('ADMINSUMMARY','2003-02-23 11:44:04','\r\n \r\n \r\n \r\n
\r\n \r\n\r\n Client Stats
\r\n\r\n Total: 1
\r\n\r\n Active: 1
\r\n\r\n Pending: 0
\r\n\r\n
\r\n\r\n Domain Stats
\r\n\r\n Total: 3
\r\n\r\n Active: 3
\r\n\r\n Pending: 0
\r\n\r\n \r\n
'); -- -- Table structure for table 'country' -- CREATE TABLE country ( id int(11) NOT NULL auto_increment, name varchar(80) NOT NULL default '', iso char(2) NOT NULL default '', PRIMARY KEY (id), KEY by_name (name,iso), KEY by_iso (iso,name) ) TYPE=MyISAM; -- -- Dumping data for table 'country' -- INSERT INTO country VALUES (1,'Afghanistan','AF'); INSERT INTO country VALUES (2,'Albania','AL'); INSERT INTO country VALUES (3,'Algeria','DZ'); INSERT INTO country VALUES (4,'American Samoa','AS'); INSERT INTO country VALUES (5,'Andorra','AD'); INSERT INTO country VALUES (6,'Angola','AO'); INSERT INTO country VALUES (7,'Anguilla','AI'); INSERT INTO country VALUES (8,'Antarctica','AQ'); INSERT INTO country VALUES (9,'Antigua and Barbuda','AG'); INSERT INTO country VALUES (10,'Argentina','AR'); INSERT INTO country VALUES (11,'Armenia','AM'); INSERT INTO country VALUES (12,'Aruba','AW'); INSERT INTO country VALUES (13,'Australia','AU'); INSERT INTO country VALUES (14,'Austria','AT'); INSERT INTO country VALUES (15,'Azerbaijan','AZ'); INSERT INTO country VALUES (16,'Bahamas','BS'); INSERT INTO country VALUES (17,'Bahrain','BH'); INSERT INTO country VALUES (18,'Bangladesh','BD'); INSERT INTO country VALUES (19,'Barbados','BB'); INSERT INTO country VALUES (20,'Belarus','BY'); INSERT INTO country VALUES (21,'Belgium','BE'); INSERT INTO country VALUES (22,'Belize','BZ'); INSERT INTO country VALUES (23,'Benin','BJ'); INSERT INTO country VALUES (24,'Bermuda','BM'); INSERT INTO country VALUES (25,'Bhutan','BT'); INSERT INTO country VALUES (26,'Bolivia','BO'); INSERT INTO country VALUES (27,'Bosnia and Herzegovina','BA'); INSERT INTO country VALUES (28,'Botswana','BW'); INSERT INTO country VALUES (29,'Bouvet Island','BV'); INSERT INTO country VALUES (30,'Brazil','BR'); INSERT INTO country VALUES (31,'Brunei Darussalam','BN'); INSERT INTO country VALUES (32,'Bulgaria','BG'); INSERT INTO country VALUES (33,'Burkina Faso','BF'); INSERT INTO country VALUES (34,'Burundi','BI'); INSERT INTO country VALUES (35,'Cambodia','KH'); INSERT INTO country VALUES (36,'Cameroon','CM'); INSERT INTO country VALUES (37,'Canada','CA'); INSERT INTO country VALUES (38,'Cape Verde','CV'); INSERT INTO country VALUES (39,'Cayman Islands','KY'); INSERT INTO country VALUES (40,'Central African Republic','CF'); INSERT INTO country VALUES (41,'Chad','TD'); INSERT INTO country VALUES (42,'Chile',' C'); INSERT INTO country VALUES (43,'China','CN'); INSERT INTO country VALUES (44,'Christmas Island','CX'); INSERT INTO country VALUES (45,'Cocos (Keeling) Islands','CC'); INSERT INTO country VALUES (46,'Colombia','CO'); INSERT INTO country VALUES (47,'Comoros','KM'); INSERT INTO country VALUES (48,'Congo','CG'); INSERT INTO country VALUES (49,'Cook Islands','CK'); INSERT INTO country VALUES (50,'Costa Rica','CR'); INSERT INTO country VALUES (51,'Cote D\'ivoire','CI'); INSERT INTO country VALUES (52,'Croatia','HR'); INSERT INTO country VALUES (53,'Cuba','CU'); INSERT INTO country VALUES (54,'Cyprus','CY'); INSERT INTO country VALUES (55,'Czech Republic','CZ'); INSERT INTO country VALUES (56,'Denmark','DK'); INSERT INTO country VALUES (57,'Djibouti','DJ'); INSERT INTO country VALUES (58,'Dominica','DM'); INSERT INTO country VALUES (59,'Dominican Republic','DO'); INSERT INTO country VALUES (60,'East Timor','TP'); INSERT INTO country VALUES (61,'Ecuador','EC'); INSERT INTO country VALUES (62,'Egypt','EG'); INSERT INTO country VALUES (63,'El Salvador','SV'); INSERT INTO country VALUES (64,'Equatorial Guinea','GQ'); INSERT INTO country VALUES (65,'Eritrea','ER'); INSERT INTO country VALUES (66,'Estonia','EE'); INSERT INTO country VALUES (67,'Ethiopia','ET'); INSERT INTO country VALUES (68,'Faroe Islands','FO'); INSERT INTO country VALUES (69,'Fiji','FJ'); INSERT INTO country VALUES (70,'Finland','FI'); INSERT INTO country VALUES (71,'France','FR'); INSERT INTO country VALUES (72,'France, Metropolitan','FX'); INSERT INTO country VALUES (73,'French Guiana','GF'); INSERT INTO country VALUES (74,'French Polynesia','PF'); INSERT INTO country VALUES (75,'Gabon','GA'); INSERT INTO country VALUES (76,'Gambia','GM'); INSERT INTO country VALUES (77,'Georgia','GE'); INSERT INTO country VALUES (78,'Germany','DE'); INSERT INTO country VALUES (79,'Ghana','GH'); INSERT INTO country VALUES (80,'Gibraltar','GI'); INSERT INTO country VALUES (81,'Greece','GR'); INSERT INTO country VALUES (82,'Greenland','GL'); INSERT INTO country VALUES (83,'Grenada','GD'); INSERT INTO country VALUES (84,'Guadeloupe','GP'); INSERT INTO country VALUES (85,'Guam','GU'); INSERT INTO country VALUES (86,'Guatemala','GT'); INSERT INTO country VALUES (87,'Guinea','GN'); INSERT INTO country VALUES (88,'Guinea-bissau','GW'); INSERT INTO country VALUES (89,'Guyana','GY'); INSERT INTO country VALUES (90,'Haiti','HT'); INSERT INTO country VALUES (91,'Honduras','HN'); INSERT INTO country VALUES (92,'Hong Kong','HK'); INSERT INTO country VALUES (93,'Hungary','HU'); INSERT INTO country VALUES (94,'Iceland','IS'); INSERT INTO country VALUES (95,'India','IN'); INSERT INTO country VALUES (96,'Indonesia','ID'); INSERT INTO country VALUES (97,'Iran (Islamic Republic of)','IR'); INSERT INTO country VALUES (98,'Iraq','IQ'); INSERT INTO country VALUES (99,'Ireland','IE'); INSERT INTO country VALUES (100,'Israel','IL'); INSERT INTO country VALUES (101,'Italy','IT'); INSERT INTO country VALUES (102,'Jamaica','JM'); INSERT INTO country VALUES (103,'Japan','JP'); INSERT INTO country VALUES (104,'Jordan','JO'); INSERT INTO country VALUES (105,'Kazakhstan','KZ'); INSERT INTO country VALUES (106,'Kenya','KE'); INSERT INTO country VALUES (107,'Kiribati','KI'); INSERT INTO country VALUES (108,'Korea','KR'); INSERT INTO country VALUES (109,'Kuwait','KW'); INSERT INTO country VALUES (110,'Kyrgyzstan','KG'); INSERT INTO country VALUES (111,'Latvia','LV'); INSERT INTO country VALUES (112,'Lebanon','LB'); INSERT INTO country VALUES (113,'Lesotho','LS'); INSERT INTO country VALUES (114,'Liberia','LR'); INSERT INTO country VALUES (115,'Libya','LY'); INSERT INTO country VALUES (116,'Liechtenstein','LI'); INSERT INTO country VALUES (117,'Lithuania','LT'); INSERT INTO country VALUES (118,'Luxembourg','LU'); INSERT INTO country VALUES (119,'Macau','MO'); INSERT INTO country VALUES (120,'Madagascar','MG'); INSERT INTO country VALUES (121,'Malawi','MW'); INSERT INTO country VALUES (122,'Malaysia','MY'); INSERT INTO country VALUES (123,'Maldives','MV'); INSERT INTO country VALUES (124,'Mali','ML'); INSERT INTO country VALUES (125,'Malta','MT'); INSERT INTO country VALUES (126,'Martinique','MQ'); INSERT INTO country VALUES (127,'Mauritania','MR'); INSERT INTO country VALUES (128,'Mauritius','MU'); INSERT INTO country VALUES (129,'Mayotte','YT'); INSERT INTO country VALUES (130,'Mexico','MX'); INSERT INTO country VALUES (131,'Monaco','MC'); INSERT INTO country VALUES (132,'Mongolia','MN'); INSERT INTO country VALUES (133,'Montserrat','MS'); INSERT INTO country VALUES (134,'Morocco','MA'); INSERT INTO country VALUES (135,'Mozambique','MZ'); INSERT INTO country VALUES (136,'Myanmar','MM'); INSERT INTO country VALUES (137,'Namibia','NA'); INSERT INTO country VALUES (138,'Nauru','NR'); INSERT INTO country VALUES (139,'Nepal','NP'); INSERT INTO country VALUES (140,'Netherlands','NL'); INSERT INTO country VALUES (141,'New Caledonia','NC'); INSERT INTO country VALUES (142,'New Zealand','NZ'); INSERT INTO country VALUES (143,'Nicaragua','NI'); INSERT INTO country VALUES (144,'Niger','NE'); INSERT INTO country VALUES (145,'Nigeria','NG'); INSERT INTO country VALUES (146,'Niue','NU'); INSERT INTO country VALUES (147,'Norfolk Island','NF'); INSERT INTO country VALUES (148,'Norway','NO'); INSERT INTO country VALUES (149,'Oman','OM'); INSERT INTO country VALUES (150,'Pakistan','PK'); INSERT INTO country VALUES (151,'Palau','PW'); INSERT INTO country VALUES (152,'Panama','PA'); INSERT INTO country VALUES (153,'Papua New Guinea','PG'); INSERT INTO country VALUES (154,'Paraguay','PY'); INSERT INTO country VALUES (155,'Peru','PE'); INSERT INTO country VALUES (156,'Philippines','PH'); INSERT INTO country VALUES (157,'Pitcairn','PN'); INSERT INTO country VALUES (158,'Poland','PL'); INSERT INTO country VALUES (159,'Portugal','PT'); INSERT INTO country VALUES (160,'Puerto Rico','PR'); INSERT INTO country VALUES (161,'Qatar','QA'); INSERT INTO country VALUES (162,'Reunion','RE'); INSERT INTO country VALUES (163,'Romania','RO'); INSERT INTO country VALUES (164,'Russian Federation','RU'); INSERT INTO country VALUES (165,'Rwanda','RW'); INSERT INTO country VALUES (166,'Saint Kitts and Nevis','KN'); INSERT INTO country VALUES (167,'Saint Lucia','LC'); INSERT INTO country VALUES (168,'Samoa','WS'); INSERT INTO country VALUES (169,'San Marino','SM'); INSERT INTO country VALUES (170,'Sao Tome and Principe','ST'); INSERT INTO country VALUES (171,'Saudi Arabia','SA'); INSERT INTO country VALUES (172,'Senegal','SN'); INSERT INTO country VALUES (173,'Seychelles','SC'); INSERT INTO country VALUES (174,'Sierra Leone','SL'); INSERT INTO country VALUES (175,'Singapore','SG'); INSERT INTO country VALUES (176,'Slovakia (Slovak Republic)','SK'); INSERT INTO country VALUES (177,'Slovenia','SI'); INSERT INTO country VALUES (178,'Solomon Islands','SB'); INSERT INTO country VALUES (179,'Somalia','SO'); INSERT INTO country VALUES (180,'South Africa','ZA'); INSERT INTO country VALUES (181,'Spain','ES'); INSERT INTO country VALUES (182,'Sri Lanka','LK'); INSERT INTO country VALUES (183,'St. Helena','SH'); INSERT INTO country VALUES (184,'Sudan','SD'); INSERT INTO country VALUES (185,'Suriname','SR'); INSERT INTO country VALUES (186,'Swaziland','SZ'); INSERT INTO country VALUES (187,'Sweden','SE'); INSERT INTO country VALUES (188,'Switzerland','CH'); INSERT INTO country VALUES (189,'Syrian Arab Republic','SY'); INSERT INTO country VALUES (190,'Taiwan','TW'); INSERT INTO country VALUES (191,'Tajikistan','TJ'); INSERT INTO country VALUES (192,'Thailand','TH'); INSERT INTO country VALUES (193,'Togo','TG'); INSERT INTO country VALUES (194,'Tokelau','TK'); INSERT INTO country VALUES (195,'Tonga','TO'); INSERT INTO country VALUES (196,'Trinidad and Tobago','TT'); INSERT INTO country VALUES (197,'Tunisia','TN'); INSERT INTO country VALUES (198,'Turkey','TR'); INSERT INTO country VALUES (199,'Turkmenistan','TM'); INSERT INTO country VALUES (200,'Tuvalu','TV'); INSERT INTO country VALUES (201,'Uganda','UG'); INSERT INTO country VALUES (202,'Ukraine','UA'); INSERT INTO country VALUES (203,'United Arab Emirates','AE'); INSERT INTO country VALUES (204,'United Kingdom','GB'); INSERT INTO country VALUES (205,'United States','US'); INSERT INTO country VALUES (206,'Uruguay','UY'); INSERT INTO country VALUES (207,'Uzbekistan','UZ'); INSERT INTO country VALUES (208,'Vanuatu','VU'); INSERT INTO country VALUES (209,'Venezuela','VE'); INSERT INTO country VALUES (210,'Viet Nam','VN'); INSERT INTO country VALUES (211,'Virgin Islands (British)','VG'); INSERT INTO country VALUES (212,'Virgin Islands (U.S.)','VI'); INSERT INTO country VALUES (213,'Wallis and Futuna Islands','WF'); INSERT INTO country VALUES (214,'Western Sahara','EH'); INSERT INTO country VALUES (215,'Yemen','YE'); INSERT INTO country VALUES (216,'Yugoslavia','YU'); INSERT INTO country VALUES (217,'Zambia','ZM'); INSERT INTO country VALUES (218,'Zimbabwe','ZW'); -- -- Table structure for table 'customdomainfields' -- CREATE TABLE customdomainfields ( id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL default '', type tinyint(4) NOT NULL default '0', isrequired tinyint(4) NOT NULL default '0', isChangable tinyint(4) NOT NULL default '1', isAdminOnly tinyint(4) NOT NULL default '0', width tinyint(4) NOT NULL default '20', myOrder int(11) NOT NULL default '0', showcustomer tinyint(4) NOT NULL default '0', showadmin tinyint(4) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'customdomainfields' -- INSERT INTO customdomainfields VALUES (1,'IP Address',0,1,0,0,30,0,0,0); -- -- Table structure for table 'customuserfields' -- CREATE TABLE customuserfields ( id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL default '', type tinyint(4) NOT NULL default '0', isrequired tinyint(4) NOT NULL default '0', isChangable tinyint(4) NOT NULL default '1', isAdminOnly tinyint(4) NOT NULL default '0', width tinyint(4) NOT NULL default '20', myOrder int(11) NOT NULL default '0', showcustomer tinyint(4) NOT NULL default '1', showadmin tinyint(4) NOT NULL default '1', InSignup tinyint(1) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'customuserfields' -- INSERT INTO customuserfields VALUES (1,'First Name',0,1,0,0,20,2,1,1,1); INSERT INTO customuserfields VALUES (2,'Last Name',0,1,0,0,20,3,1,1,1); INSERT INTO customuserfields VALUES (3,'Address',2,1,1,0,45,7,1,0,1); INSERT INTO customuserfields VALUES (4,'Email',0,1,0,0,35,4,1,1,1); INSERT INTO customuserfields VALUES (5,'City',3,1,1,0,20,8,1,0,1); INSERT INTO customuserfields VALUES (6,'State',4,0,1,0,3,9,1,0,1); INSERT INTO customuserfields VALUES (7,'Postcode / Zipcode',5,1,1,0,10,10,1,0,1); INSERT INTO customuserfields VALUES (8,'Phone',7,1,1,0,20,6,1,1,1); INSERT INTO customuserfields VALUES (10,'Organization',0,0,0,0,30,1,1,0,1); INSERT INTO customuserfields VALUES (11,'ICQ Number',0,0,0,0,20,5,1,1,0); INSERT INTO customuserfields VALUES (12,'IM on Payment',1,0,0,0,20,12,0,1,0); INSERT INTO customuserfields VALUES (13,'IM on Login',1,0,0,0,20,13,0,1,0); INSERT INTO customuserfields VALUES (14,'IM on New Ticket',1,0,0,0,20,14,0,1,0); INSERT INTO customuserfields VALUES (15,'Country',6,1,1,0,20,11,1,0,1); INSERT INTO customuserfields VALUES (16,'IM on New Signup',1,0,0,0,20,16,0,1,0); INSERT INTO customuserfields VALUES (17,'HTML Email Format',1,1,0,0,20,18,1,1,0); -- -- Table structure for table 'domain_customdomainfields' -- CREATE TABLE domain_customdomainfields ( userid int(11) NOT NULL default '0', customid int(11) NOT NULL default '0', value text, PRIMARY KEY (userid,customid), KEY userid (userid), KEY customid (customid) ) TYPE=MyISAM; -- -- Dumping data for table 'domain_customdomainfields' -- INSERT INTO domain_customdomainfields VALUES (1,1,'216.127.66.50'); INSERT INTO domain_customdomainfields VALUES (2,1,'216.127.66.50'); INSERT INTO domain_customdomainfields VALUES (3,1,'216.127.66.50'); -- -- Table structure for table 'domains' -- CREATE TABLE domains ( id int(11) NOT NULL auto_increment, DomainName text, CustomerID int(11) default NULL, UserName text, password varchar(25) NOT NULL default '', recurring tinyint(1) default NULL, Comments mediumtext, current tinyint(4) NOT NULL default '1', billsent tinyint(1) NOT NULL default '0', Plan int(11) NOT NULL default '0', dateActivated date default NULL, controlpanel int(11) NOT NULL default '0', serverid int(11) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'domains' -- INSERT INTO domains VALUES (1,'centurywebdesign.com',101,'centurywebdesign','danger',1,NULL,1,0,1,'2003-02-22',0,1); INSERT INTO domains VALUES (2,'centurywebdesign.tv',101,'centurywebdesign.tv','qwerty',1,'',1,0,1,'2003-02-23',2,1); INSERT INTO domains VALUES (3,'plasticpipework.com',101,'plasticpipework','plasticpipework',0,'',1,0,1,'2003-02-23',0,1); -- -- Table structure for table 'groups' -- CREATE TABLE groups ( id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL default '', deletable tinyint(4) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id), KEY id_2 (id) ) TYPE=MyISAM; -- -- Dumping data for table 'groups' -- INSERT INTO groups VALUES (1,'User',0); INSERT INTO groups VALUES (2,'Site Admin',0); INSERT INTO groups VALUES (3,'Tech Support',0); -- -- Table structure for table 'gwlforumsauth_access' -- CREATE TABLE gwlforumsauth_access ( group_id mediumint(8) NOT NULL default '0', forum_id smallint(5) unsigned NOT NULL default '0', auth_view tinyint(1) NOT NULL default '0', auth_read tinyint(1) NOT NULL default '0', auth_post tinyint(1) NOT NULL default '0', auth_reply tinyint(1) NOT NULL default '0', auth_edit tinyint(1) NOT NULL default '0', auth_delete tinyint(1) NOT NULL default '0', auth_sticky tinyint(1) NOT NULL default '0', auth_announce tinyint(1) NOT NULL default '0', auth_vote tinyint(1) NOT NULL default '0', auth_pollcreate tinyint(1) NOT NULL default '0', auth_attachments tinyint(1) NOT NULL default '0', auth_mod tinyint(1) NOT NULL default '0', KEY group_id (group_id), KEY forum_id (forum_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsauth_access' -- INSERT INTO gwlforumsauth_access VALUES (4,3,1,1,1,1,1,1,1,0,1,1,0,0); INSERT INTO gwlforumsauth_access VALUES (3,2,1,1,1,1,1,1,1,0,1,1,0,0); INSERT INTO gwlforumsauth_access VALUES (3,3,1,1,1,1,1,1,1,0,1,1,0,0); INSERT INTO gwlforumsauth_access VALUES (8,2,1,1,1,1,1,1,1,0,1,1,0,0); INSERT INTO gwlforumsauth_access VALUES (8,3,1,1,1,1,1,1,1,0,1,1,0,0); INSERT INTO gwlforumsauth_access VALUES (8,4,1,1,1,1,1,1,1,0,1,1,0,0); INSERT INTO gwlforumsauth_access VALUES (3,8,1,1,1,1,1,1,1,0,1,1,0,0); INSERT INTO gwlforumsauth_access VALUES (10,3,1,1,1,1,1,1,1,0,1,1,0,0); INSERT INTO gwlforumsauth_access VALUES (8,8,1,1,1,1,1,1,1,0,1,1,0,0); -- -- Table structure for table 'gwlforumsbanlist' -- CREATE TABLE gwlforumsbanlist ( ban_id mediumint(8) unsigned NOT NULL auto_increment, ban_userid mediumint(8) NOT NULL default '0', ban_ip varchar(8) NOT NULL default '', ban_email varchar(255) default NULL, PRIMARY KEY (ban_id), KEY ban_ip_user_id (ban_ip,ban_userid) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsbanlist' -- -- -- Table structure for table 'gwlforumscategories' -- CREATE TABLE gwlforumscategories ( cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100) default NULL, cat_order mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (cat_id), KEY cat_order (cat_order) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumscategories' -- INSERT INTO gwlforumscategories VALUES (4,'[GwL] Private',40); INSERT INTO gwlforumscategories VALUES (3,'Public',10); INSERT INTO gwlforumscategories VALUES (5,'[GwL] Council',50); INSERT INTO gwlforumscategories VALUES (6,'Server',20); INSERT INTO gwlforumscategories VALUES (7,'[GwL] Cup',30); -- -- Table structure for table 'gwlforumsconfig' -- CREATE TABLE gwlforumsconfig ( config_name varchar(255) NOT NULL default '', config_value varchar(255) NOT NULL default '', PRIMARY KEY (config_name) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsconfig' -- INSERT INTO gwlforumsconfig VALUES ('config_id','1'); INSERT INTO gwlforumsconfig VALUES ('board_disable','0'); INSERT INTO gwlforumsconfig VALUES ('sitename','ClanGwL Forum'); INSERT INTO gwlforumsconfig VALUES ('site_desc','Forum for TO clan GwL'); INSERT INTO gwlforumsconfig VALUES ('cookie_name','phpbb2mysql'); INSERT INTO gwlforumsconfig VALUES ('cookie_path','/'); INSERT INTO gwlforumsconfig VALUES ('cookie_domain',''); INSERT INTO gwlforumsconfig VALUES ('cookie_secure','0'); INSERT INTO gwlforumsconfig VALUES ('session_length','3600'); INSERT INTO gwlforumsconfig VALUES ('allow_html','0'); INSERT INTO gwlforumsconfig VALUES ('allow_html_tags','b,i,u,pre'); INSERT INTO gwlforumsconfig VALUES ('allow_bbcode','1'); INSERT INTO gwlforumsconfig VALUES ('allow_smilies','1'); INSERT INTO gwlforumsconfig VALUES ('allow_sig','1'); INSERT INTO gwlforumsconfig VALUES ('allow_namechange','0'); INSERT INTO gwlforumsconfig VALUES ('allow_theme_create','0'); INSERT INTO gwlforumsconfig VALUES ('allow_avatar_local','0'); INSERT INTO gwlforumsconfig VALUES ('allow_avatar_remote','0'); INSERT INTO gwlforumsconfig VALUES ('allow_avatar_upload','0'); INSERT INTO gwlforumsconfig VALUES ('override_user_style','1'); INSERT INTO gwlforumsconfig VALUES ('posts_per_page','15'); INSERT INTO gwlforumsconfig VALUES ('topics_per_page','50'); INSERT INTO gwlforumsconfig VALUES ('hot_threshold','25'); INSERT INTO gwlforumsconfig VALUES ('max_poll_options','10'); INSERT INTO gwlforumsconfig VALUES ('max_sig_chars','255'); INSERT INTO gwlforumsconfig VALUES ('max_inbox_privmsgs','50'); INSERT INTO gwlforumsconfig VALUES ('max_sentbox_privmsgs','25'); INSERT INTO gwlforumsconfig VALUES ('max_savebox_privmsgs','50'); INSERT INTO gwlforumsconfig VALUES ('board_email_sig','Thanks, The Management'); INSERT INTO gwlforumsconfig VALUES ('board_email','n.crossley@virgin.net'); INSERT INTO gwlforumsconfig VALUES ('smtp_delivery','0'); INSERT INTO gwlforumsconfig VALUES ('smtp_host',''); INSERT INTO gwlforumsconfig VALUES ('smtp_username',''); INSERT INTO gwlforumsconfig VALUES ('smtp_password',''); INSERT INTO gwlforumsconfig VALUES ('require_activation','0'); INSERT INTO gwlforumsconfig VALUES ('flood_interval','15'); INSERT INTO gwlforumsconfig VALUES ('board_email_form','0'); INSERT INTO gwlforumsconfig VALUES ('avatar_filesize','6144'); INSERT INTO gwlforumsconfig VALUES ('avatar_max_width','80'); INSERT INTO gwlforumsconfig VALUES ('avatar_max_height','80'); INSERT INTO gwlforumsconfig VALUES ('avatar_path','images/avatars'); INSERT INTO gwlforumsconfig VALUES ('avatar_gallery_path','images/avatars/gallery'); INSERT INTO gwlforumsconfig VALUES ('smilies_path','images/smiles'); INSERT INTO gwlforumsconfig VALUES ('default_style','2'); INSERT INTO gwlforumsconfig VALUES ('default_dateformat','D M d, Y g:i a'); INSERT INTO gwlforumsconfig VALUES ('board_timezone','0'); INSERT INTO gwlforumsconfig VALUES ('prune_enable','1'); INSERT INTO gwlforumsconfig VALUES ('privmsg_disable','0'); INSERT INTO gwlforumsconfig VALUES ('gzip_compress','0'); INSERT INTO gwlforumsconfig VALUES ('coppa_fax',''); INSERT INTO gwlforumsconfig VALUES ('coppa_mail',''); INSERT INTO gwlforumsconfig VALUES ('record_online_users','6'); INSERT INTO gwlforumsconfig VALUES ('record_online_date','1045490004'); INSERT INTO gwlforumsconfig VALUES ('server_name','www.centurywebdesign.com'); INSERT INTO gwlforumsconfig VALUES ('server_port','80'); INSERT INTO gwlforumsconfig VALUES ('script_path','/gwlforums/'); INSERT INTO gwlforumsconfig VALUES ('version','.0.4'); INSERT INTO gwlforumsconfig VALUES ('board_startdate','1045480399'); INSERT INTO gwlforumsconfig VALUES ('default_lang','english'); -- -- Table structure for table 'gwlforumsdisallow' -- CREATE TABLE gwlforumsdisallow ( disallow_id mediumint(8) unsigned NOT NULL auto_increment, disallow_username varchar(25) NOT NULL default '', PRIMARY KEY (disallow_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsdisallow' -- -- -- Table structure for table 'gwlforumsforum_prune' -- CREATE TABLE gwlforumsforum_prune ( prune_id mediumint(8) unsigned NOT NULL auto_increment, forum_id smallint(5) unsigned NOT NULL default '0', prune_days smallint(5) unsigned NOT NULL default '0', prune_freq smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (prune_id), KEY forum_id (forum_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsforum_prune' -- -- -- Table structure for table 'gwlforumsforums' -- CREATE TABLE gwlforumsforums ( forum_id smallint(5) unsigned NOT NULL default '0', cat_id mediumint(8) unsigned NOT NULL default '0', forum_name varchar(150) default NULL, forum_desc text, forum_status tinyint(4) NOT NULL default '0', forum_order mediumint(8) unsigned NOT NULL default '1', forum_posts mediumint(8) unsigned NOT NULL default '0', forum_topics mediumint(8) unsigned NOT NULL default '0', forum_last_post_id mediumint(8) unsigned NOT NULL default '0', prune_next int(11) default NULL, prune_enable tinyint(1) NOT NULL default '0', auth_view tinyint(2) NOT NULL default '0', auth_read tinyint(2) NOT NULL default '0', auth_post tinyint(2) NOT NULL default '0', auth_reply tinyint(2) NOT NULL default '0', auth_edit tinyint(2) NOT NULL default '0', auth_delete tinyint(2) NOT NULL default '0', auth_sticky tinyint(2) NOT NULL default '0', auth_announce tinyint(2) NOT NULL default '0', auth_vote tinyint(2) NOT NULL default '0', auth_pollcreate tinyint(2) NOT NULL default '0', auth_attachments tinyint(2) NOT NULL default '0', PRIMARY KEY (forum_id), KEY forums_order (forum_order), KEY cat_id (cat_id), KEY forum_last_post_id (forum_last_post_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsforums' -- INSERT INTO gwlforumsforums VALUES (1,3,'General Chat','General [GwL] chat - public forum so we can take the piss :D',0,10,16,5,22,NULL,0,0,0,0,0,1,1,3,3,1,1,0); INSERT INTO gwlforumsforums VALUES (2,4,'General Chat','Stuff that needs to be said - say it here ',0,10,2,1,15,NULL,0,2,2,2,2,2,2,2,3,2,2,0); INSERT INTO gwlforumsforums VALUES (3,6,'Server Discussions','',0,10,0,0,0,NULL,0,2,2,2,2,2,2,2,3,2,2,0); INSERT INTO gwlforumsforums VALUES (4,5,'Council General','Council news needs posting here',0,10,0,0,0,NULL,0,2,2,2,2,2,2,2,3,2,2,0); INSERT INTO gwlforumsforums VALUES (5,3,'Recruitment','If your interested in Joining [GwL] you need to post here',0,20,0,0,0,NULL,0,0,0,0,0,1,1,3,3,1,1,0); INSERT INTO gwlforumsforums VALUES (6,3,'Match Reports','Match Reports from matches [GwL] have played',0,30,0,0,0,NULL,0,0,0,0,0,1,1,3,3,1,1,0); INSERT INTO gwlforumsforums VALUES (7,3,'Other Games','Any news on other games that we play',0,40,0,0,0,NULL,0,0,0,0,0,1,1,3,3,1,1,0); INSERT INTO gwlforumsforums VALUES (8,4,'Council Chambers','If you have a problem or Idea that you need the council to sort out - post it here',0,20,0,0,0,NULL,0,2,2,2,2,2,2,2,3,2,2,0); INSERT INTO gwlforumsforums VALUES (9,7,'Cup Results / Reports','Post your results, Reports and screenies here',0,10,0,0,0,NULL,0,0,0,0,0,1,1,3,3,1,1,0); INSERT INTO gwlforumsforums VALUES (10,7,'Cup Fixtures','Post here to sort out the match dates / reschedules etc',0,20,0,0,0,NULL,0,0,0,0,0,1,1,3,3,1,1,0); INSERT INTO gwlforumsforums VALUES (11,7,'Cup Discussion','Discussion about the cup',0,30,0,0,0,NULL,0,0,0,0,0,1,1,3,3,1,1,0); -- -- Table structure for table 'gwlforumsgroups' -- CREATE TABLE gwlforumsgroups ( group_id mediumint(8) NOT NULL auto_increment, group_type tinyint(4) NOT NULL default '1', group_name varchar(40) NOT NULL default '', group_description varchar(255) NOT NULL default '', group_moderator mediumint(8) NOT NULL default '0', group_single_user tinyint(1) NOT NULL default '1', PRIMARY KEY (group_id), KEY group_single_user (group_single_user) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsgroups' -- INSERT INTO gwlforumsgroups VALUES (1,1,'Anonymous','Personal User',0,1); INSERT INTO gwlforumsgroups VALUES (2,1,'Insomnia','Personal User',0,1); INSERT INTO gwlforumsgroups VALUES (3,0,'GwL Members','',2,0); INSERT INTO gwlforumsgroups VALUES (4,1,'','Personal User',0,1); INSERT INTO gwlforumsgroups VALUES (5,1,'','Personal User',0,1); INSERT INTO gwlforumsgroups VALUES (6,1,'','Personal User',0,1); INSERT INTO gwlforumsgroups VALUES (7,1,'','Personal User',0,1); INSERT INTO gwlforumsgroups VALUES (8,2,'Council','',6,0); INSERT INTO gwlforumsgroups VALUES (9,1,'','Personal User',0,1); INSERT INTO gwlforumsgroups VALUES (10,1,'Tu\' Members','',6,0); INSERT INTO gwlforumsgroups VALUES (11,1,'','Personal User',0,1); INSERT INTO gwlforumsgroups VALUES (12,1,'','Personal User',0,1); INSERT INTO gwlforumsgroups VALUES (13,1,'','Personal User',0,1); -- -- Table structure for table 'gwlforumsposts' -- CREATE TABLE gwlforumsposts ( post_id mediumint(8) unsigned NOT NULL auto_increment, topic_id mediumint(8) unsigned NOT NULL default '0', forum_id smallint(5) unsigned NOT NULL default '0', poster_id mediumint(8) NOT NULL default '0', post_time int(11) NOT NULL default '0', poster_ip varchar(8) NOT NULL default '', post_username varchar(25) default NULL, enable_bbcode tinyint(1) NOT NULL default '1', enable_html tinyint(1) NOT NULL default '0', enable_smilies tinyint(1) NOT NULL default '1', enable_sig tinyint(1) NOT NULL default '1', post_edit_time int(11) default NULL, post_edit_count smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (post_id), KEY forum_id (forum_id), KEY topic_id (topic_id), KEY poster_id (poster_id), KEY post_time (post_time) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsposts' -- INSERT INTO gwlforumsposts VALUES (2,2,1,-1,1045482171,'d4bcbde4','Mon',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (4,4,1,2,1045484944,'516722ad','',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (5,4,1,3,1045485558,'82d1f8aa','',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (6,5,1,4,1045486391,'50c0f417','',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (7,4,1,2,1045486543,'516722ad','',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (8,4,1,5,1045486978,'3efce004','',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (9,5,1,6,1045487192,'3efce004','',1,0,1,1,NULL,0); INSERT INTO gwlforumsposts VALUES (10,5,1,5,1045488037,'3efce004','',1,0,1,1,NULL,0); INSERT INTO gwlforumsposts VALUES (11,2,1,2,1045488041,'516722ad','',1,0,1,1,NULL,0); INSERT INTO gwlforumsposts VALUES (13,6,2,6,1045488612,'3efce004','',1,0,1,1,NULL,0); INSERT INTO gwlforumsposts VALUES (14,2,1,6,1045488934,'3efce004','',1,0,1,1,NULL,0); INSERT INTO gwlforumsposts VALUES (15,6,2,4,1045489059,'50c0f417','',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (16,7,1,4,1045489991,'50c0f417','',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (17,2,1,8,1045490163,'d4bcbee3','',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (18,7,1,8,1045490288,'d4bcbee3','',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (19,4,1,8,1045490557,'d4bcbee3','',1,0,1,0,NULL,0); INSERT INTO gwlforumsposts VALUES (21,4,1,9,1045491189,'50c28b36','',1,0,1,1,NULL,0); INSERT INTO gwlforumsposts VALUES (22,8,1,10,1045496115,'d577c368','',1,0,1,0,NULL,0); -- -- Table structure for table 'gwlforumsposts_text' -- CREATE TABLE gwlforumsposts_text ( post_id mediumint(8) unsigned NOT NULL default '0', bbcode_uid varchar(10) NOT NULL default '', post_subject varchar(60) default NULL, post_text text, PRIMARY KEY (post_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsposts_text' -- INSERT INTO gwlforumsposts_text VALUES (2,'7c514f6f39','user accounts','Are we migrating the old user accounts to here...or do we need to re-register??\r\n\r\nMon'); INSERT INTO gwlforumsposts_text VALUES (4,'73b9cfb7e0','New Forum','It seems that our old forums have been deleted. Ee-ore may have a backup of the database but he isn\'t in a hurry to give it to me. \r\n\r\nFor them moment everyone will need to re-register.'); INSERT INTO gwlforumsposts_text VALUES (5,'79f8e1cb78','','nice forums legin !\r\n\r\nreally am impressed... nice, clean, fast, and good smileys...\r\n\r\nvery nice :) :shock: :oops: :P :twisted: :arrow: :wink:'); INSERT INTO gwlforumsposts_text VALUES (6,'b43920fa45','Nice','Nice Insomnia better than a kick in the testies :wink:'); INSERT INTO gwlforumsposts_text VALUES (7,'9be411d8e7','','Thanks.... Just somthing I knocked up'); INSERT INTO gwlforumsposts_text VALUES (8,'d1ae12f313','','Actually, this does look better than old ones. A bit more lively.'); INSERT INTO gwlforumsposts_text VALUES (9,'51133d374a','','depends if a kick in the testies would give you a forum board... :shock:'); INSERT INTO gwlforumsposts_text VALUES (10,'21f277f7dc','','maybe a lump in the throat.'); INSERT INTO gwlforumsposts_text VALUES (11,'9e41a2d6f7','','For the moment you will need to re-register.'); INSERT INTO gwlforumsposts_text VALUES (13,'f2c67749cd','You all know the score','Reaper will be leaving to join another clan.\r\n\r\nEe-Ore has left.\r\n\r\nMost of the others I have spoken to are staying and are going to help re-build. Reaper and EO will be missed and thier loss in skills will be felt - but those skills can be replaced if we all take the time to do our bit.\r\n\r\nI\'m not going to beat about the bush - Reaper was a big asset in the tacs department BUT he was also 75% of the problems I had to deal with and he knows that (I told him enough times) - so could we build on what we have and get back up to our previous standard?\r\n\r\nhell yes.'); INSERT INTO gwlforumsposts_text VALUES (14,'7e2b51161d','','Sorry Mon we havent got any of the old details from the other forum - its a scratch job Im afraid :( \r\n\r\nBut Insoms done a good job (as I helped him with the tricky bits lol) 8)'); INSERT INTO gwlforumsposts_text VALUES (15,'b5f03c1ab7','','Misty as you know and a lot the guys here do to this clan can still be good and we can have some fun as well being a force to be reckoned with.\r\nReaper is good at tacs and not a bad player too I should know he has taken my head off a few times :lol: \r\n\r\nI hope we don\'t lose the guys we call friends through this and they stay loyal to GwL if anyone needs a chat just drop me a line if any doubts anyway i got lots of work to be getting on with but i will be looking at the forums now and again to get updates to this.\r\n\r\n\r\nI look forward to people responding cheers Hercster out\r\n :wink:'); INSERT INTO gwlforumsposts_text VALUES (16,'081e00f4bc','PC TWEAKS -add to your favourites','[url]http://www.tweaktown.com/document.php?dType=guide[/url]'); INSERT INTO gwlforumsposts_text VALUES (17,'67f5bacc07','','cheers m8....can someone shove my account on the members list now...or do u know something I dont :lol:'); INSERT INTO gwlforumsposts_text VALUES (18,'75fcaa4487','','herc + tweeks guides = mon not on ts for the next couple of weeks :lol:'); INSERT INTO gwlforumsposts_text VALUES (19,'b5f74831b8','','this does look nice...but how did the old database get deleted??'); INSERT INTO gwlforumsposts_text VALUES (21,'a945ae9d36','','shite'); INSERT INTO gwlforumsposts_text VALUES (22,'711e386ca4','sigs','any1 kno the url to me sig?'); -- -- Table structure for table 'gwlforumsprivmsgs' -- CREATE TABLE gwlforumsprivmsgs ( privmsgs_id mediumint(8) unsigned NOT NULL auto_increment, privmsgs_type tinyint(4) NOT NULL default '0', privmsgs_subject varchar(255) NOT NULL default '0', privmsgs_from_userid mediumint(8) NOT NULL default '0', privmsgs_to_userid mediumint(8) NOT NULL default '0', privmsgs_date int(11) NOT NULL default '0', privmsgs_ip varchar(8) NOT NULL default '', privmsgs_enable_bbcode tinyint(1) NOT NULL default '1', privmsgs_enable_html tinyint(1) NOT NULL default '0', privmsgs_enable_smilies tinyint(1) NOT NULL default '1', privmsgs_attach_sig tinyint(1) NOT NULL default '1', PRIMARY KEY (privmsgs_id), KEY privmsgs_from_userid (privmsgs_from_userid), KEY privmsgs_to_userid (privmsgs_to_userid) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsprivmsgs' -- -- -- Table structure for table 'gwlforumsprivmsgs_text' -- CREATE TABLE gwlforumsprivmsgs_text ( privmsgs_text_id mediumint(8) unsigned NOT NULL default '0', privmsgs_bbcode_uid varchar(10) NOT NULL default '0', privmsgs_text text, PRIMARY KEY (privmsgs_text_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsprivmsgs_text' -- -- -- Table structure for table 'gwlforumsranks' -- CREATE TABLE gwlforumsranks ( rank_id smallint(5) unsigned NOT NULL auto_increment, rank_title varchar(50) NOT NULL default '', rank_min mediumint(8) NOT NULL default '0', rank_special tinyint(1) default '0', rank_image varchar(255) default NULL, PRIMARY KEY (rank_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsranks' -- INSERT INTO gwlforumsranks VALUES (1,'Site Admin',-1,1,NULL); -- -- Table structure for table 'gwlforumssearch_results' -- CREATE TABLE gwlforumssearch_results ( search_id int(11) unsigned NOT NULL default '0', session_id varchar(32) NOT NULL default '', search_array text NOT NULL, PRIMARY KEY (search_id), KEY session_id (session_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumssearch_results' -- -- -- Table structure for table 'gwlforumssearch_wordlist' -- CREATE TABLE gwlforumssearch_wordlist ( word_text varchar(50) binary NOT NULL default '', word_id mediumint(8) unsigned NOT NULL auto_increment, word_common tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (word_text), KEY word_id (word_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumssearch_wordlist' -- INSERT INTO gwlforumssearch_wordlist VALUES ('example',1,0); INSERT INTO gwlforumssearch_wordlist VALUES ('post',2,0); INSERT INTO gwlforumssearch_wordlist VALUES ('phpbb',3,0); INSERT INTO gwlforumssearch_wordlist VALUES ('installation',4,0); INSERT INTO gwlforumssearch_wordlist VALUES ('delete',5,0); INSERT INTO gwlforumssearch_wordlist VALUES ('topic',6,0); INSERT INTO gwlforumssearch_wordlist VALUES ('forum',7,0); INSERT INTO gwlforumssearch_wordlist VALUES ('since',8,0); INSERT INTO gwlforumssearch_wordlist VALUES ('everything',9,0); INSERT INTO gwlforumssearch_wordlist VALUES ('seems',35,0); INSERT INTO gwlforumssearch_wordlist VALUES ('working',11,0); INSERT INTO gwlforumssearch_wordlist VALUES ('welcome',12,0); INSERT INTO gwlforumssearch_wordlist VALUES ('accounts',13,0); INSERT INTO gwlforumssearch_wordlist VALUES ('migrating',14,0); INSERT INTO gwlforumssearch_wordlist VALUES ('mon',15,0); INSERT INTO gwlforumssearch_wordlist VALUES ('reregister',16,0); INSERT INTO gwlforumssearch_wordlist VALUES ('user',17,0); INSERT INTO gwlforumssearch_wordlist VALUES ('moment',34,0); INSERT INTO gwlforumssearch_wordlist VALUES ('may',33,0); INSERT INTO gwlforumssearch_wordlist VALUES ('hurry',32,0); INSERT INTO gwlforumssearch_wordlist VALUES ('give',31,0); INSERT INTO gwlforumssearch_wordlist VALUES ('forums',22,0); INSERT INTO gwlforumssearch_wordlist VALUES ('eeore',30,0); INSERT INTO gwlforumssearch_wordlist VALUES ('deleted',29,0); INSERT INTO gwlforumssearch_wordlist VALUES ('database',28,0); INSERT INTO gwlforumssearch_wordlist VALUES ('backup',27,0); INSERT INTO gwlforumssearch_wordlist VALUES ('wink',55,0); INSERT INTO gwlforumssearch_wordlist VALUES ('twisted',54,0); INSERT INTO gwlforumssearch_wordlist VALUES ('smileys',53,0); INSERT INTO gwlforumssearch_wordlist VALUES ('shock',52,0); INSERT INTO gwlforumssearch_wordlist VALUES ('nice',51,0); INSERT INTO gwlforumssearch_wordlist VALUES ('legin',50,0); INSERT INTO gwlforumssearch_wordlist VALUES ('impressed',49,0); INSERT INTO gwlforumssearch_wordlist VALUES ('fast',48,0); INSERT INTO gwlforumssearch_wordlist VALUES ('clean',47,0); INSERT INTO gwlforumssearch_wordlist VALUES ('arrow',46,0); INSERT INTO gwlforumssearch_wordlist VALUES ('insomnia',56,0); INSERT INTO gwlforumssearch_wordlist VALUES ('kick',57,0); INSERT INTO gwlforumssearch_wordlist VALUES ('testies',58,0); INSERT INTO gwlforumssearch_wordlist VALUES ('knocked',59,0); INSERT INTO gwlforumssearch_wordlist VALUES ('somthing',60,0); INSERT INTO gwlforumssearch_wordlist VALUES ('thanks',61,0); INSERT INTO gwlforumssearch_wordlist VALUES ('actually',62,0); INSERT INTO gwlforumssearch_wordlist VALUES ('bit',63,0); INSERT INTO gwlforumssearch_wordlist VALUES ('lively',64,0); INSERT INTO gwlforumssearch_wordlist VALUES ('ones',65,0); INSERT INTO gwlforumssearch_wordlist VALUES ('board',66,0); INSERT INTO gwlforumssearch_wordlist VALUES ('depends',67,0); INSERT INTO gwlforumssearch_wordlist VALUES ('throat',71,0); INSERT INTO gwlforumssearch_wordlist VALUES ('lump',70,0); INSERT INTO gwlforumssearch_wordlist VALUES ('back',77,0); INSERT INTO gwlforumssearch_wordlist VALUES ('asset',76,0); INSERT INTO gwlforumssearch_wordlist VALUES ('another',75,0); INSERT INTO gwlforumssearch_wordlist VALUES ('beat',78,0); INSERT INTO gwlforumssearch_wordlist VALUES ('build',79,0); INSERT INTO gwlforumssearch_wordlist VALUES ('bush',80,0); INSERT INTO gwlforumssearch_wordlist VALUES ('clan',81,0); INSERT INTO gwlforumssearch_wordlist VALUES ('deal',82,0); INSERT INTO gwlforumssearch_wordlist VALUES ('department',83,0); INSERT INTO gwlforumssearch_wordlist VALUES ('enough',84,0); INSERT INTO gwlforumssearch_wordlist VALUES ('felt',85,0); INSERT INTO gwlforumssearch_wordlist VALUES ('hell',86,0); INSERT INTO gwlforumssearch_wordlist VALUES ('help',87,0); INSERT INTO gwlforumssearch_wordlist VALUES ('join',88,0); INSERT INTO gwlforumssearch_wordlist VALUES ('knows',89,0); INSERT INTO gwlforumssearch_wordlist VALUES ('leaving',90,0); INSERT INTO gwlforumssearch_wordlist VALUES ('left',91,0); INSERT INTO gwlforumssearch_wordlist VALUES ('loss',92,0); INSERT INTO gwlforumssearch_wordlist VALUES ('missed',93,0); INSERT INTO gwlforumssearch_wordlist VALUES ('others',94,0); INSERT INTO gwlforumssearch_wordlist VALUES ('previous',95,0); INSERT INTO gwlforumssearch_wordlist VALUES ('problems',96,0); INSERT INTO gwlforumssearch_wordlist VALUES ('reaper',97,0); INSERT INTO gwlforumssearch_wordlist VALUES ('rebuild',98,0); INSERT INTO gwlforumssearch_wordlist VALUES ('replaced',99,0); INSERT INTO gwlforumssearch_wordlist VALUES ('score',100,0); INSERT INTO gwlforumssearch_wordlist VALUES ('skills',101,0); INSERT INTO gwlforumssearch_wordlist VALUES ('spoken',102,0); INSERT INTO gwlforumssearch_wordlist VALUES ('standard',103,0); INSERT INTO gwlforumssearch_wordlist VALUES ('staying',104,0); INSERT INTO gwlforumssearch_wordlist VALUES ('tacs',105,0); INSERT INTO gwlforumssearch_wordlist VALUES ('thier',106,0); INSERT INTO gwlforumssearch_wordlist VALUES ('told',107,0); INSERT INTO gwlforumssearch_wordlist VALUES ('afraid',108,0); INSERT INTO gwlforumssearch_wordlist VALUES ('bits',109,0); INSERT INTO gwlforumssearch_wordlist VALUES ('details',110,0); INSERT INTO gwlforumssearch_wordlist VALUES ('done',111,0); INSERT INTO gwlforumssearch_wordlist VALUES ('helped',112,0); INSERT INTO gwlforumssearch_wordlist VALUES ('insoms',113,0); INSERT INTO gwlforumssearch_wordlist VALUES ('job',114,0); INSERT INTO gwlforumssearch_wordlist VALUES ('lol',115,0); INSERT INTO gwlforumssearch_wordlist VALUES ('scratch',116,0); INSERT INTO gwlforumssearch_wordlist VALUES ('sorry',117,0); INSERT INTO gwlforumssearch_wordlist VALUES ('tricky',118,0); INSERT INTO gwlforumssearch_wordlist VALUES ('again',119,0); INSERT INTO gwlforumssearch_wordlist VALUES ('anyone',120,0); INSERT INTO gwlforumssearch_wordlist VALUES ('anyway',121,0); INSERT INTO gwlforumssearch_wordlist VALUES ('call',122,0); INSERT INTO gwlforumssearch_wordlist VALUES ('chat',123,0); INSERT INTO gwlforumssearch_wordlist VALUES ('cheers',124,0); INSERT INTO gwlforumssearch_wordlist VALUES ('doubts',125,0); INSERT INTO gwlforumssearch_wordlist VALUES ('drop',126,0); INSERT INTO gwlforumssearch_wordlist VALUES ('few',127,0); INSERT INTO gwlforumssearch_wordlist VALUES ('force',128,0); INSERT INTO gwlforumssearch_wordlist VALUES ('forward',129,0); INSERT INTO gwlforumssearch_wordlist VALUES ('friends',130,0); INSERT INTO gwlforumssearch_wordlist VALUES ('fun',131,0); INSERT INTO gwlforumssearch_wordlist VALUES ('getting',132,0); INSERT INTO gwlforumssearch_wordlist VALUES ('guys',133,0); INSERT INTO gwlforumssearch_wordlist VALUES ('gwl',134,0); INSERT INTO gwlforumssearch_wordlist VALUES ('head',135,0); INSERT INTO gwlforumssearch_wordlist VALUES ('hercster',136,0); INSERT INTO gwlforumssearch_wordlist VALUES ('hope',137,0); INSERT INTO gwlforumssearch_wordlist VALUES ('line',138,0); INSERT INTO gwlforumssearch_wordlist VALUES ('lose',139,0); INSERT INTO gwlforumssearch_wordlist VALUES ('lots',140,0); INSERT INTO gwlforumssearch_wordlist VALUES ('loyal',141,0); INSERT INTO gwlforumssearch_wordlist VALUES ('misty',142,0); INSERT INTO gwlforumssearch_wordlist VALUES ('needs',143,0); INSERT INTO gwlforumssearch_wordlist VALUES ('people',144,0); INSERT INTO gwlforumssearch_wordlist VALUES ('player',145,0); INSERT INTO gwlforumssearch_wordlist VALUES ('reckoned',146,0); INSERT INTO gwlforumssearch_wordlist VALUES ('responding',147,0); INSERT INTO gwlforumssearch_wordlist VALUES ('stay',148,0); INSERT INTO gwlforumssearch_wordlist VALUES ('still',149,0); INSERT INTO gwlforumssearch_wordlist VALUES ('taken',150,0); INSERT INTO gwlforumssearch_wordlist VALUES ('updates',151,0); INSERT INTO gwlforumssearch_wordlist VALUES ('work',152,0); INSERT INTO gwlforumssearch_wordlist VALUES ('add',153,0); INSERT INTO gwlforumssearch_wordlist VALUES ('favourites',154,0); INSERT INTO gwlforumssearch_wordlist VALUES ('tweaks',155,0); INSERT INTO gwlforumssearch_wordlist VALUES ('account',156,0); INSERT INTO gwlforumssearch_wordlist VALUES ('list',157,0); INSERT INTO gwlforumssearch_wordlist VALUES ('members',158,0); INSERT INTO gwlforumssearch_wordlist VALUES ('shove',159,0); INSERT INTO gwlforumssearch_wordlist VALUES ('someone',160,0); INSERT INTO gwlforumssearch_wordlist VALUES ('couple',161,0); INSERT INTO gwlforumssearch_wordlist VALUES ('guides',162,0); INSERT INTO gwlforumssearch_wordlist VALUES ('herc',163,0); INSERT INTO gwlforumssearch_wordlist VALUES ('next',164,0); INSERT INTO gwlforumssearch_wordlist VALUES ('tweeks',165,0); INSERT INTO gwlforumssearch_wordlist VALUES ('weeks',166,0); INSERT INTO gwlforumssearch_wordlist VALUES ('shite',167,0); INSERT INTO gwlforumssearch_wordlist VALUES ('any1',168,0); INSERT INTO gwlforumssearch_wordlist VALUES ('kno',169,0); INSERT INTO gwlforumssearch_wordlist VALUES ('sig',170,0); INSERT INTO gwlforumssearch_wordlist VALUES ('sigs',171,0); INSERT INTO gwlforumssearch_wordlist VALUES ('url',172,0); -- -- Table structure for table 'gwlforumssearch_wordmatch' -- CREATE TABLE gwlforumssearch_wordmatch ( post_id mediumint(8) unsigned NOT NULL default '0', word_id mediumint(8) unsigned NOT NULL default '0', title_match tinyint(1) NOT NULL default '0', KEY post_id (post_id), KEY word_id (word_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumssearch_wordmatch' -- INSERT INTO gwlforumssearch_wordmatch VALUES (4,7,1); INSERT INTO gwlforumssearch_wordmatch VALUES (4,27,0); INSERT INTO gwlforumssearch_wordmatch VALUES (4,28,0); INSERT INTO gwlforumssearch_wordmatch VALUES (4,29,0); INSERT INTO gwlforumssearch_wordmatch VALUES (4,30,0); INSERT INTO gwlforumssearch_wordmatch VALUES (4,22,0); INSERT INTO gwlforumssearch_wordmatch VALUES (2,17,1); INSERT INTO gwlforumssearch_wordmatch VALUES (2,13,1); INSERT INTO gwlforumssearch_wordmatch VALUES (2,17,0); INSERT INTO gwlforumssearch_wordmatch VALUES (2,16,0); INSERT INTO gwlforumssearch_wordmatch VALUES (2,15,0); INSERT INTO gwlforumssearch_wordmatch VALUES (2,14,0); INSERT INTO gwlforumssearch_wordmatch VALUES (2,13,0); INSERT INTO gwlforumssearch_wordmatch VALUES (4,31,0); INSERT INTO gwlforumssearch_wordmatch VALUES (4,32,0); INSERT INTO gwlforumssearch_wordmatch VALUES (4,33,0); INSERT INTO gwlforumssearch_wordmatch VALUES (4,34,0); INSERT INTO gwlforumssearch_wordmatch VALUES (4,16,0); INSERT INTO gwlforumssearch_wordmatch VALUES (4,35,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,46,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,47,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,48,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,49,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,50,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,51,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,52,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,53,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,54,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,55,0); INSERT INTO gwlforumssearch_wordmatch VALUES (5,22,0); INSERT INTO gwlforumssearch_wordmatch VALUES (6,56,0); INSERT INTO gwlforumssearch_wordmatch VALUES (6,57,0); INSERT INTO gwlforumssearch_wordmatch VALUES (6,51,0); INSERT INTO gwlforumssearch_wordmatch VALUES (6,58,0); INSERT INTO gwlforumssearch_wordmatch VALUES (6,55,0); INSERT INTO gwlforumssearch_wordmatch VALUES (6,51,1); INSERT INTO gwlforumssearch_wordmatch VALUES (7,59,0); INSERT INTO gwlforumssearch_wordmatch VALUES (7,60,0); INSERT INTO gwlforumssearch_wordmatch VALUES (7,61,0); INSERT INTO gwlforumssearch_wordmatch VALUES (8,62,0); INSERT INTO gwlforumssearch_wordmatch VALUES (8,63,0); INSERT INTO gwlforumssearch_wordmatch VALUES (8,64,0); INSERT INTO gwlforumssearch_wordmatch VALUES (8,65,0); INSERT INTO gwlforumssearch_wordmatch VALUES (9,66,0); INSERT INTO gwlforumssearch_wordmatch VALUES (9,67,0); INSERT INTO gwlforumssearch_wordmatch VALUES (9,7,0); INSERT INTO gwlforumssearch_wordmatch VALUES (9,31,0); INSERT INTO gwlforumssearch_wordmatch VALUES (9,57,0); INSERT INTO gwlforumssearch_wordmatch VALUES (9,52,0); INSERT INTO gwlforumssearch_wordmatch VALUES (9,58,0); INSERT INTO gwlforumssearch_wordmatch VALUES (10,71,0); INSERT INTO gwlforumssearch_wordmatch VALUES (10,70,0); INSERT INTO gwlforumssearch_wordmatch VALUES (11,16,0); INSERT INTO gwlforumssearch_wordmatch VALUES (11,34,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,77,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,63,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,30,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,76,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,75,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,78,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,79,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,80,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,81,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,82,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,83,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,84,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,85,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,86,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,87,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,88,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,89,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,90,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,91,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,92,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,93,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,94,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,95,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,96,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,97,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,98,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,99,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,101,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,102,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,103,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,104,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,105,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,106,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,107,0); INSERT INTO gwlforumssearch_wordmatch VALUES (13,100,1); INSERT INTO gwlforumssearch_wordmatch VALUES (14,108,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,109,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,110,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,111,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,7,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,112,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,113,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,114,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,115,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,15,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,116,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,117,0); INSERT INTO gwlforumssearch_wordmatch VALUES (14,118,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,22,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,55,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,81,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,97,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,105,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,115,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,119,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,120,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,121,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,122,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,123,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,124,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,125,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,126,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,127,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,128,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,129,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,130,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,131,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,132,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,133,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,134,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,135,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,136,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,137,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,138,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,139,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,140,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,141,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,142,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,143,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,144,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,145,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,146,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,147,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,148,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,149,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,150,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,151,0); INSERT INTO gwlforumssearch_wordmatch VALUES (15,152,0); INSERT INTO gwlforumssearch_wordmatch VALUES (16,153,1); INSERT INTO gwlforumssearch_wordmatch VALUES (16,154,1); INSERT INTO gwlforumssearch_wordmatch VALUES (16,155,1); INSERT INTO gwlforumssearch_wordmatch VALUES (17,156,0); INSERT INTO gwlforumssearch_wordmatch VALUES (17,124,0); INSERT INTO gwlforumssearch_wordmatch VALUES (17,157,0); INSERT INTO gwlforumssearch_wordmatch VALUES (17,115,0); INSERT INTO gwlforumssearch_wordmatch VALUES (17,158,0); INSERT INTO gwlforumssearch_wordmatch VALUES (17,159,0); INSERT INTO gwlforumssearch_wordmatch VALUES (17,160,0); INSERT INTO gwlforumssearch_wordmatch VALUES (18,161,0); INSERT INTO gwlforumssearch_wordmatch VALUES (18,162,0); INSERT INTO gwlforumssearch_wordmatch VALUES (18,163,0); INSERT INTO gwlforumssearch_wordmatch VALUES (18,115,0); INSERT INTO gwlforumssearch_wordmatch VALUES (18,15,0); INSERT INTO gwlforumssearch_wordmatch VALUES (18,164,0); INSERT INTO gwlforumssearch_wordmatch VALUES (18,165,0); INSERT INTO gwlforumssearch_wordmatch VALUES (18,166,0); INSERT INTO gwlforumssearch_wordmatch VALUES (19,28,0); INSERT INTO gwlforumssearch_wordmatch VALUES (19,29,0); INSERT INTO gwlforumssearch_wordmatch VALUES (19,51,0); INSERT INTO gwlforumssearch_wordmatch VALUES (22,169,0); INSERT INTO gwlforumssearch_wordmatch VALUES (22,168,0); INSERT INTO gwlforumssearch_wordmatch VALUES (21,167,0); INSERT INTO gwlforumssearch_wordmatch VALUES (22,170,0); INSERT INTO gwlforumssearch_wordmatch VALUES (22,172,0); INSERT INTO gwlforumssearch_wordmatch VALUES (22,171,1); -- -- Table structure for table 'gwlforumssessions' -- CREATE TABLE gwlforumssessions ( session_id char(32) NOT NULL default '', session_user_id mediumint(8) NOT NULL default '0', session_start int(11) NOT NULL default '0', session_time int(11) NOT NULL default '0', session_ip char(8) NOT NULL default '0', session_page int(11) NOT NULL default '0', session_logged_in tinyint(1) NOT NULL default '0', PRIMARY KEY (session_id), KEY session_user_id (session_user_id), KEY session_id_ip_user_id (session_id,session_ip,session_user_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumssessions' -- INSERT INTO gwlforumssessions VALUES ('e64691451c9af952e3442d528be30dd3',7,1045773048,1045773048,'50010e91',0,1); -- -- Table structure for table 'gwlforumssmilies' -- CREATE TABLE gwlforumssmilies ( smilies_id smallint(5) unsigned NOT NULL auto_increment, code varchar(50) default NULL, smile_url varchar(100) default NULL, emoticon varchar(75) default NULL, PRIMARY KEY (smilies_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumssmilies' -- INSERT INTO gwlforumssmilies VALUES (1,':D','icon_biggrin.gif','Very Happy'); INSERT INTO gwlforumssmilies VALUES (2,':-D','icon_biggrin.gif','Very Happy'); INSERT INTO gwlforumssmilies VALUES (3,':grin:','icon_biggrin.gif','Very Happy'); INSERT INTO gwlforumssmilies VALUES (4,':)','icon_smile.gif','Smile'); INSERT INTO gwlforumssmilies VALUES (5,':-)','icon_smile.gif','Smile'); INSERT INTO gwlforumssmilies VALUES (6,':smile:','icon_smile.gif','Smile'); INSERT INTO gwlforumssmilies VALUES (7,':(','icon_sad.gif','Sad'); INSERT INTO gwlforumssmilies VALUES (8,':-(','icon_sad.gif','Sad'); INSERT INTO gwlforumssmilies VALUES (9,':sad:','icon_sad.gif','Sad'); INSERT INTO gwlforumssmilies VALUES (10,':o','icon_surprised.gif','Surprised'); INSERT INTO gwlforumssmilies VALUES (11,':-o','icon_surprised.gif','Surprised'); INSERT INTO gwlforumssmilies VALUES (12,':eek:','icon_surprised.gif','Surprised'); INSERT INTO gwlforumssmilies VALUES (13,':shock:','icon_eek.gif','Shocked'); INSERT INTO gwlforumssmilies VALUES (14,':?','icon_confused.gif','Confused'); INSERT INTO gwlforumssmilies VALUES (15,':-?','icon_confused.gif','Confused'); INSERT INTO gwlforumssmilies VALUES (16,':???:','icon_confused.gif','Confused'); INSERT INTO gwlforumssmilies VALUES (17,'8)','icon_cool.gif','Cool'); INSERT INTO gwlforumssmilies VALUES (18,'8-)','icon_cool.gif','Cool'); INSERT INTO gwlforumssmilies VALUES (19,':cool:','icon_cool.gif','Cool'); INSERT INTO gwlforumssmilies VALUES (20,':lol:','icon_lol.gif','Laughing'); INSERT INTO gwlforumssmilies VALUES (21,':x','icon_mad.gif','Mad'); INSERT INTO gwlforumssmilies VALUES (22,':-x','icon_mad.gif','Mad'); INSERT INTO gwlforumssmilies VALUES (23,':mad:','icon_mad.gif','Mad'); INSERT INTO gwlforumssmilies VALUES (24,':P','icon_razz.gif','Razz'); INSERT INTO gwlforumssmilies VALUES (25,':-P','icon_razz.gif','Razz'); INSERT INTO gwlforumssmilies VALUES (26,':razz:','icon_razz.gif','Razz'); INSERT INTO gwlforumssmilies VALUES (27,':oops:','icon_redface.gif','Embarassed'); INSERT INTO gwlforumssmilies VALUES (28,':cry:','icon_cry.gif','Crying or Very sad'); INSERT INTO gwlforumssmilies VALUES (29,':evil:','icon_evil.gif','Evil or Very Mad'); INSERT INTO gwlforumssmilies VALUES (30,':twisted:','icon_twisted.gif','Twisted Evil'); INSERT INTO gwlforumssmilies VALUES (31,':roll:','icon_rolleyes.gif','Rolling Eyes'); INSERT INTO gwlforumssmilies VALUES (32,':wink:','icon_wink.gif','Wink'); INSERT INTO gwlforumssmilies VALUES (33,';)','icon_wink.gif','Wink'); INSERT INTO gwlforumssmilies VALUES (34,';-)','icon_wink.gif','Wink'); INSERT INTO gwlforumssmilies VALUES (35,':!:','icon_exclaim.gif','Exclamation'); INSERT INTO gwlforumssmilies VALUES (36,':?:','icon_question.gif','Question'); INSERT INTO gwlforumssmilies VALUES (37,':idea:','icon_idea.gif','Idea'); INSERT INTO gwlforumssmilies VALUES (38,':arrow:','icon_arrow.gif','Arrow'); INSERT INTO gwlforumssmilies VALUES (39,':|','icon_neutral.gif','Neutral'); INSERT INTO gwlforumssmilies VALUES (40,':-|','icon_neutral.gif','Neutral'); INSERT INTO gwlforumssmilies VALUES (41,':neutral:','icon_neutral.gif','Neutral'); INSERT INTO gwlforumssmilies VALUES (42,':mrgreen:','icon_mrgreen.gif','Mr. Green'); INSERT INTO gwlforumssmilies VALUES (43,':fadein:','new_spiral.gif','#Fade in'); INSERT INTO gwlforumssmilies VALUES (44,':fist:','new_321.gif','#Fist'); INSERT INTO gwlforumssmilies VALUES (45,'0X','new_alien.gif','#alien'); INSERT INTO gwlforumssmilies VALUES (46,':drinking:','new_all_coholic.gif','#Beer'); INSERT INTO gwlforumssmilies VALUES (47,':angel:','new_angel.gif','#angel'); INSERT INTO gwlforumssmilies VALUES (48,':agrue:','new_argue.gif','#Bad Talk'); INSERT INTO gwlforumssmilies VALUES (49,':evilbat:','new_asthanos.gif','#Evil Bat'); INSERT INTO gwlforumssmilies VALUES (50,':bday:','new_bdaysmile.gif','#Bday'); INSERT INTO gwlforumssmilies VALUES (51,':new-alien:','new_beammeup.gif','#Beammeup-alien'); INSERT INTO gwlforumssmilies VALUES (52,':BIG:','new_bigcrowd.gif','#Big smile'); INSERT INTO gwlforumssmilies VALUES (53,':grab:','new_bluegrab.gif','#Bluegrab'); INSERT INTO gwlforumssmilies VALUES (54,':robot:','new_borgsmile.gif','#Robot'); INSERT INTO gwlforumssmilies VALUES (55,':new-bday:','new_birthday.gif','#Birthday'); INSERT INTO gwlforumssmilies VALUES (56,':black:','new_blackey.gif','#Black smile'); INSERT INTO gwlforumssmilies VALUES (57,':B-fly:','new_butterfly.gif','#butterfly'); INSERT INTO gwlforumssmilies VALUES (58,':Fade-color','new_color_.gif','#Fadeing color'); INSERT INTO gwlforumssmilies VALUES (59,':bad-words:','new_cussing.gif','#Cussing out'); INSERT INTO gwlforumssmilies VALUES (60,':eggface:','new_eggface.gif','#Egg'); INSERT INTO gwlforumssmilies VALUES (61,':crazyeyes:','new_Eyecrazy.gif','#Crazy'); INSERT INTO gwlforumssmilies VALUES (62,':morning:','new_gmorning.gif','#morning'); INSERT INTO gwlforumssmilies VALUES (63,':icecream:','new_icecream.gif','#Icecream'); INSERT INTO gwlforumssmilies VALUES (64,':infinity:','new_infinity.gif','#infinity'); INSERT INTO gwlforumssmilies VALUES (65,':eating:','new_kodomagnam.gif','#Eating smiley'); INSERT INTO gwlforumssmilies VALUES (66,':lilangel:','new_littleangel.gif','#Lil angel'); INSERT INTO gwlforumssmilies VALUES (67,':lol!:','new_Llol.gif','#LOL'); INSERT INTO gwlforumssmilies VALUES (68,':lying:','new_llying.gif','#llying'); INSERT INTO gwlforumssmilies VALUES (69,':microwave:','new_microwave.gif','#Microwave'); INSERT INTO gwlforumssmilies VALUES (70,':painting:','new_monalisa.gif','#monalisa'); INSERT INTO gwlforumssmilies VALUES (71,':multi:','new_multi.gif','#Milti'); INSERT INTO gwlforumssmilies VALUES (72,':n00b:','new_newbie.gif','#Newbie'); INSERT INTO gwlforumssmilies VALUES (73,':olympic:','new_olympic1.gif','#Olympic'); INSERT INTO gwlforumssmilies VALUES (74,':popcorn:','new_popcornsmiley.gif','#Popcornsmile'); INSERT INTO gwlforumssmilies VALUES (75,':puppydogeyes:','new_puppy_dog_eyes.gif','#Puppy dog'); INSERT INTO gwlforumssmilies VALUES (76,':rainbow1:','new_rainbow.gif','#Rainbow1'); INSERT INTO gwlforumssmilies VALUES (77,':rainbowafro:','new_rainfro.gif','#Afro'); INSERT INTO gwlforumssmilies VALUES (78,':rofl:','new_rofl.gif','#Rofl'); INSERT INTO gwlforumssmilies VALUES (79,':rocol:','new_rotcol.gif','#Rotcol'); INSERT INTO gwlforumssmilies VALUES (80,':scatter:','new_scatter.gif','#Scatter'); INSERT INTO gwlforumssmilies VALUES (81,':shocked!:','new_shocked.gif','#Shocked'); INSERT INTO gwlforumssmilies VALUES (82,':scrambleup:','new_scrambles.gif','#Scramble'); INSERT INTO gwlforumssmilies VALUES (83,':silly:','new_silly.gif','#Silly'); INSERT INTO gwlforumssmilies VALUES (84,':sleeping:','new_sleeping.gif','#Sleep'); INSERT INTO gwlforumssmilies VALUES (85,':turn-l:','new_smile-l.gif','#Turn-l'); INSERT INTO gwlforumssmilies VALUES (86,':flasingsmile:','new_smileyb.gif','#Flash'); INSERT INTO gwlforumssmilies VALUES (87,':smilecolros:','new_smilie_colors1.gif','#Smile_colors'); INSERT INTO gwlforumssmilies VALUES (88,':snipersmile:','new_snipersmilie.gif','#Sniper'); INSERT INTO gwlforumssmilies VALUES (89,':2gunfire:','new_2gunsfiring_v1.gif','#2gunfire'); INSERT INTO gwlforumssmilies VALUES (90,':changes:','new_squarecycle.gif','#CHanges'); INSERT INTO gwlforumssmilies VALUES (91,':squarewink:','new_squarewink.gif','#Wink2'); INSERT INTO gwlforumssmilies VALUES (92,':halfrobot:','new_terminator.gif','#Halfrobot'); INSERT INTO gwlforumssmilies VALUES (93,':splat:','new_tomato.gif','#Splat'); INSERT INTO gwlforumssmilies VALUES (94,':onfire:','new_ukliam2.gif','#Onfire'); INSERT INTO gwlforumssmilies VALUES (95,':usa','new_usa.gif','#Usa'); INSERT INTO gwlforumssmilies VALUES (96,':vamp:','new_vampv.gif','#Vamp'); INSERT INTO gwlforumssmilies VALUES (97,':x-mas:','new_xmas.gif','#X-mas'); -- -- Table structure for table 'gwlforumsthemes' -- CREATE TABLE gwlforumsthemes ( themes_id mediumint(8) unsigned NOT NULL auto_increment, template_name varchar(30) NOT NULL default '', style_name varchar(30) NOT NULL default '', head_stylesheet varchar(100) default NULL, body_background varchar(100) default NULL, body_bgcolor varchar(6) default NULL, body_text varchar(6) default NULL, body_link varchar(6) default NULL, body_vlink varchar(6) default NULL, body_alink varchar(6) default NULL, body_hlink varchar(6) default NULL, tr_color1 varchar(6) default NULL, tr_color2 varchar(6) default NULL, tr_color3 varchar(6) default NULL, tr_class1 varchar(25) default NULL, tr_class2 varchar(25) default NULL, tr_class3 varchar(25) default NULL, th_color1 varchar(6) default NULL, th_color2 varchar(6) default NULL, th_color3 varchar(6) default NULL, th_class1 varchar(25) default NULL, th_class2 varchar(25) default NULL, th_class3 varchar(25) default NULL, td_color1 varchar(6) default NULL, td_color2 varchar(6) default NULL, td_color3 varchar(6) default NULL, td_class1 varchar(25) default NULL, td_class2 varchar(25) default NULL, td_class3 varchar(25) default NULL, fontface1 varchar(50) default NULL, fontface2 varchar(50) default NULL, fontface3 varchar(50) default NULL, fontsize1 tinyint(4) default NULL, fontsize2 tinyint(4) default NULL, fontsize3 tinyint(4) default NULL, fontcolor1 varchar(6) default NULL, fontcolor2 varchar(6) default NULL, fontcolor3 varchar(6) default NULL, span_class1 varchar(25) default NULL, span_class2 varchar(25) default NULL, span_class3 varchar(25) default NULL, img_size_poll smallint(5) unsigned default NULL, img_size_privmsg smallint(5) unsigned default NULL, PRIMARY KEY (themes_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsthemes' -- INSERT INTO gwlforumsthemes VALUES (1,'subSilver','subSilver','subSilver.css','','E5E5E5','000000','006699','5493B4','','DD6900','EFEFEF','DEE3E7','D1D7DC','','','','98AAB1','006699','FFFFFF','cellpic1.gif','cellpic3.gif','cellpic2.jpg','FAFAFA','FFFFFF','','row1','row2','','Verdana, Arial, Helvetica, sans-serif','Trebuchet MS','Courier, \'Courier New\', sans-serif',10,11,12,'444444','006600','FFA34F','','','',NULL,NULL); INSERT INTO gwlforumsthemes VALUES (2,'SpacePilot3K','SpacePilot3K','SpacePilot3K.css','','000000','DDDDDD','8BC7FF','5493B4','','DD6900','','','','','','','98AAB1','FFFFFF','FFFFFF','cellpic1.gif','cellpic3.gif','cellpic2.jpg','FFFFFF','FFFFFF','FFFFFF','row1','row2','row3','Verdana, Arial, Helvetica, sans-serif','Trebuchet MS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); -- -- Table structure for table 'gwlforumsthemes_name' -- CREATE TABLE gwlforumsthemes_name ( themes_id smallint(5) unsigned NOT NULL default '0', tr_color1_name char(50) default NULL, tr_color2_name char(50) default NULL, tr_color3_name char(50) default NULL, tr_class1_name char(50) default NULL, tr_class2_name char(50) default NULL, tr_class3_name char(50) default NULL, th_color1_name char(50) default NULL, th_color2_name char(50) default NULL, th_color3_name char(50) default NULL, th_class1_name char(50) default NULL, th_class2_name char(50) default NULL, th_class3_name char(50) default NULL, td_color1_name char(50) default NULL, td_color2_name char(50) default NULL, td_color3_name char(50) default NULL, td_class1_name char(50) default NULL, td_class2_name char(50) default NULL, td_class3_name char(50) default NULL, fontface1_name char(50) default NULL, fontface2_name char(50) default NULL, fontface3_name char(50) default NULL, fontsize1_name char(50) default NULL, fontsize2_name char(50) default NULL, fontsize3_name char(50) default NULL, fontcolor1_name char(50) default NULL, fontcolor2_name char(50) default NULL, fontcolor3_name char(50) default NULL, span_class1_name char(50) default NULL, span_class2_name char(50) default NULL, span_class3_name char(50) default NULL, PRIMARY KEY (themes_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsthemes_name' -- INSERT INTO gwlforumsthemes_name VALUES (1,'The lightest row colour','The medium row color','The darkest row colour','','','','Border round the whole page','Outer table border','Inner table border','Silver gradient picture','Blue gradient picture','Fade-out gradient on index','Background for quote boxes','All white areas','','Background for topic posts','2nd background for topic posts','','Main fonts','Additional topic title font','Form fonts','Smallest font size','Medium font size','Normal font size (post body etc)','Quote & copyright text','Code text colour','Main table header text colour','','',''); -- -- Table structure for table 'gwlforumstopics' -- CREATE TABLE gwlforumstopics ( topic_id mediumint(8) unsigned NOT NULL auto_increment, forum_id smallint(8) unsigned NOT NULL default '0', topic_title char(60) NOT NULL default '', topic_poster mediumint(8) NOT NULL default '0', topic_time int(11) NOT NULL default '0', topic_views mediumint(8) unsigned NOT NULL default '0', topic_replies mediumint(8) unsigned NOT NULL default '0', topic_status tinyint(3) NOT NULL default '0', topic_vote tinyint(1) NOT NULL default '0', topic_type tinyint(3) NOT NULL default '0', topic_first_post_id mediumint(8) unsigned NOT NULL default '0', topic_last_post_id mediumint(8) unsigned NOT NULL default '0', topic_moved_id mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (topic_id), KEY forum_id (forum_id), KEY topic_moved_id (topic_moved_id), KEY topic_status (topic_status), KEY topic_type (topic_type) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumstopics' -- INSERT INTO gwlforumstopics VALUES (2,1,'user accounts',-1,1045482171,35,3,0,0,0,2,17,0); INSERT INTO gwlforumstopics VALUES (4,1,'New Forum',2,1045484944,41,5,0,0,0,4,21,0); INSERT INTO gwlforumstopics VALUES (5,1,'Nice',4,1045486391,28,2,0,0,0,6,10,0); INSERT INTO gwlforumstopics VALUES (6,2,'You all know the score',6,1045488612,10,1,0,0,0,13,15,0); INSERT INTO gwlforumstopics VALUES (7,1,'PC TWEAKS -add to your favourites',4,1045489991,11,1,0,0,0,16,18,0); INSERT INTO gwlforumstopics VALUES (8,1,'sigs',10,1045496115,3,0,0,0,0,22,22,0); -- -- Table structure for table 'gwlforumstopics_watch' -- CREATE TABLE gwlforumstopics_watch ( topic_id mediumint(8) unsigned NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', notify_status tinyint(1) NOT NULL default '0', KEY topic_id (topic_id), KEY user_id (user_id), KEY notify_status (notify_status) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumstopics_watch' -- INSERT INTO gwlforumstopics_watch VALUES (6,4,0); -- -- Table structure for table 'gwlforumsuser_group' -- CREATE TABLE gwlforumsuser_group ( group_id mediumint(8) NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', user_pending tinyint(1) default NULL, KEY group_id (group_id), KEY user_id (user_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsuser_group' -- INSERT INTO gwlforumsuser_group VALUES (1,-1,0); INSERT INTO gwlforumsuser_group VALUES (2,2,0); INSERT INTO gwlforumsuser_group VALUES (3,2,0); INSERT INTO gwlforumsuser_group VALUES (4,3,0); INSERT INTO gwlforumsuser_group VALUES (5,4,0); INSERT INTO gwlforumsuser_group VALUES (6,5,0); INSERT INTO gwlforumsuser_group VALUES (7,6,0); INSERT INTO gwlforumsuser_group VALUES (3,6,0); INSERT INTO gwlforumsuser_group VALUES (3,4,0); INSERT INTO gwlforumsuser_group VALUES (3,5,0); INSERT INTO gwlforumsuser_group VALUES (8,6,0); INSERT INTO gwlforumsuser_group VALUES (8,4,0); INSERT INTO gwlforumsuser_group VALUES (9,7,0); INSERT INTO gwlforumsuser_group VALUES (10,6,0); INSERT INTO gwlforumsuser_group VALUES (11,8,0); INSERT INTO gwlforumsuser_group VALUES (3,8,0); INSERT INTO gwlforumsuser_group VALUES (3,7,0); INSERT INTO gwlforumsuser_group VALUES (12,9,0); INSERT INTO gwlforumsuser_group VALUES (13,10,0); -- -- Table structure for table 'gwlforumsusers' -- CREATE TABLE gwlforumsusers ( user_id mediumint(8) NOT NULL default '0', user_active tinyint(1) default '1', username varchar(25) NOT NULL default '', user_password varchar(32) NOT NULL default '', user_session_time int(11) NOT NULL default '0', user_session_page smallint(5) NOT NULL default '0', user_lastvisit int(11) NOT NULL default '0', user_regdate int(11) NOT NULL default '0', user_level tinyint(4) default '0', user_posts mediumint(8) unsigned NOT NULL default '0', user_timezone decimal(5,2) NOT NULL default '0.00', user_style tinyint(4) default NULL, user_lang varchar(255) default NULL, user_dateformat varchar(14) NOT NULL default 'd M Y H:i', user_new_privmsg smallint(5) unsigned NOT NULL default '0', user_unread_privmsg smallint(5) unsigned NOT NULL default '0', user_last_privmsg int(11) NOT NULL default '0', user_emailtime int(11) default NULL, user_viewemail tinyint(1) default NULL, user_attachsig tinyint(1) default NULL, user_allowhtml tinyint(1) default '1', user_allowbbcode tinyint(1) default '1', user_allowsmile tinyint(1) default '1', user_allowavatar tinyint(1) NOT NULL default '1', user_allow_pm tinyint(1) NOT NULL default '1', user_allow_viewonline tinyint(1) NOT NULL default '1', user_notify tinyint(1) NOT NULL default '1', user_notify_pm tinyint(1) NOT NULL default '0', user_popup_pm tinyint(1) NOT NULL default '0', user_rank int(11) default '0', user_avatar varchar(100) default NULL, user_avatar_type tinyint(4) NOT NULL default '0', user_email varchar(255) default NULL, user_icq varchar(15) default NULL, user_website varchar(100) default NULL, user_from varchar(100) default NULL, user_sig text, user_sig_bbcode_uid varchar(10) default NULL, user_aim varchar(255) default NULL, user_yim varchar(255) default NULL, user_msnm varchar(255) default NULL, user_occ varchar(100) default NULL, user_interests varchar(255) default NULL, user_actkey varchar(32) default NULL, user_newpasswd varchar(32) default NULL, PRIMARY KEY (user_id), KEY user_session_time (user_session_time) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsusers' -- INSERT INTO gwlforumsusers VALUES (-1,0,'Anonymous','',0,0,0,1045480399,0,1,0.00,NULL,'','',0,0,0,NULL,0,0,0,1,1,1,0,1,0,1,0,NULL,'',0,'','','','','',NULL,'','','','','','',''); INSERT INTO gwlforumsusers VALUES (2,1,'Insomnia','474a7751a342c80a15fcef6016238868',1045497166,0,1045489389,1045480399,1,4,0.00,2,'english','d M Y h:i a',0,0,0,NULL,0,0,0,1,1,1,1,1,0,1,1,1,'',0,'n.crossley@virgin.net','','','','[img:d666ad63b5]http://www.clangwl.co.uk/sigs/gwlinsomnia.jpg[/img:d666ad63b5]','d666ad63b5','','','','','','',''); INSERT INTO gwlforumsusers VALUES (5,1,'Althan','24412aa365632abdcbf6a6b047647146',1045488287,-4,1045486931,1045486913,0,2,0.00,2,'english','D M d, Y g:i a',0,0,0,NULL,0,1,0,1,1,1,1,1,0,1,1,0,'',0,'jonathaniwilliams@hotmail.com','','','','[img:1e1a2be5db]http://www.clangwl.co.uk/sigs/gwlalthan.jpg[/img:1e1a2be5db]','1e1a2be5db','','','','','','',NULL); INSERT INTO gwlforumsusers VALUES (3,1,'[GwL]Reaper','3f76818f507fe7eb6422bd0703c64c88',1045485585,-9,1045485518,1045485492,0,1,0.00,2,'english','D M d, Y g:i a',0,0,0,NULL,0,1,0,1,1,1,1,1,0,1,1,0,'',0,'reaper@clangwl.co.uk','','http://www.clangwl.co.uk','','','','','','','','','',NULL); INSERT INTO gwlforumsusers VALUES (4,1,'[GwL]Herc','586d51f16086429a691920ce95a53620',1045493716,1,1045492304,1045486229,1,3,0.00,2,'english','D M d, Y g:i a',0,0,0,NULL,0,1,0,1,1,1,1,1,0,1,1,0,'',0,'martinpriory67@blueyonder.co.uk','','','','','','','','','','','',NULL); INSERT INTO gwlforumsusers VALUES (6,1,'[GwL]Red_Mist','6945994adb8ecdf7721d0d2d8a028878',1045491375,0,1045487046,1045487036,1,3,0.00,2,'english','D M d, Y g:i a',0,0,0,NULL,0,1,0,1,1,1,1,1,0,1,1,0,'',0,'Misty@clangwl.co.uk','46429126','http://www.clangwl.co.uk','Cleethorpes','[img:45749c0de4]http://www.clangwl.co.uk/sigs/gwlmisty.jpg[/img:45749c0de4][size=10:45749c0de4][list:45749c0de4][*:45749c0de4][GwL] Leader\r\n[*:45749c0de4][GwL] Council Member\r\n[*:45749c0de4][GwL] Server\'s Webadmin\r\n[*:45749c0de4][GwL] Webmaster\r\n[*:45749c0de4][GwL] Fattest bastard (officially)\r\n[/list:u:45749c0de4][/size:45749c0de4]','45749c0de4','','','Si_Phix@hotmail.com','Ambulance Driver','','',NULL); INSERT INTO gwlforumsusers VALUES (7,1,'Gilb`','03e418afd6dddb76c99d5019da8899d8',1045773048,0,1045773048,1045488548,0,0,0.00,2,'english','D M d, Y g:i a',0,0,0,NULL,0,1,0,1,1,1,1,1,0,1,1,0,'',0,'hates_apples@hotmail.com','','','','','','','','','','','',NULL); INSERT INTO gwlforumsusers VALUES (8,1,'MonTheFish','6a96cfcd0d4f264fddc0185a4e031820',1045492417,0,1045490557,1045490089,0,3,0.00,2,'english','D M d, Y g:i a',0,0,0,NULL,0,1,0,1,1,1,1,1,0,1,1,0,'',0,'monthefish@clangwl.co.uk','','','','','','','','','','','',NULL); INSERT INTO gwlforumsusers VALUES (10,1,'[GwL]Fluffy_Bunny','92c142219d4b5cba95eee2e53ace3c89',1045496092,0,1045496030,1045496014,0,1,1.00,2,'english','D M d, Y g:i a',0,0,0,NULL,0,1,0,1,1,1,1,1,0,1,1,0,'',0,'kheiremans@yahoo.com','','http://users.pandora.be/pB-GwL','belgium','','','','','kheiremans@yahoo.com','student','','',NULL); INSERT INTO gwlforumsusers VALUES (9,1,'NeCRoS','fea0f1f6fede90bd0a925b4194deac11',1045491173,0,1045491173,1045491158,0,1,0.00,2,'english','D M d, Y g:i a',0,0,0,NULL,1,1,0,1,1,1,1,1,0,1,1,0,'',0,'go0d_riddance@hotmail.com','','http://www.feelthedamage.co.uk','Scotland, UK','[img:08c846be25]http://www.feelthedamage.co.uk/images/nec_15.jpg[/img:08c846be25]','08c846be25','bazdudex','lord_necros_x','go0d_riddance@hotmail.com','Student','None whatsoever','',NULL); -- -- Table structure for table 'gwlforumsvote_desc' -- CREATE TABLE gwlforumsvote_desc ( vote_id mediumint(8) unsigned NOT NULL auto_increment, topic_id mediumint(8) unsigned NOT NULL default '0', vote_text text NOT NULL, vote_start int(11) NOT NULL default '0', vote_length int(11) NOT NULL default '0', PRIMARY KEY (vote_id), KEY topic_id (topic_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsvote_desc' -- -- -- Table structure for table 'gwlforumsvote_results' -- CREATE TABLE gwlforumsvote_results ( vote_id mediumint(8) unsigned NOT NULL default '0', vote_option_id tinyint(4) unsigned NOT NULL default '0', vote_option_text varchar(255) NOT NULL default '', vote_result int(11) NOT NULL default '0', KEY vote_option_id (vote_option_id), KEY vote_id (vote_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsvote_results' -- -- -- Table structure for table 'gwlforumsvote_voters' -- CREATE TABLE gwlforumsvote_voters ( vote_id mediumint(8) unsigned NOT NULL default '0', vote_user_id mediumint(8) NOT NULL default '0', vote_user_ip char(8) NOT NULL default '', KEY vote_id (vote_id), KEY vote_user_id (vote_user_id), KEY vote_user_ip (vote_user_ip) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumsvote_voters' -- -- -- Table structure for table 'gwlforumswords' -- CREATE TABLE gwlforumswords ( word_id mediumint(8) unsigned NOT NULL auto_increment, word char(100) NOT NULL default '', replacement char(100) NOT NULL default '', PRIMARY KEY (word_id) ) TYPE=MyISAM; -- -- Dumping data for table 'gwlforumswords' -- INSERT INTO gwlforumswords VALUES (1,'Fuck','F**k'); -- -- Table structure for table 'help' -- CREATE TABLE help ( id int(11) NOT NULL auto_increment, title varchar(40) NOT NULL default '', detail text NOT NULL, linkwords varchar(40) NOT NULL default 'Click to view available tags', width int(3) NOT NULL default '240', height int(3) NOT NULL default '320', PRIMARY KEY (id), UNIQUE KEY id (id), KEY id_2 (id) ) TYPE=MyISAM; -- -- Dumping data for table 'help' -- INSERT INTO help VALUES (1,'Welcome Email Tags','[COMPANYNAME]
Company name[ACCOUNTINFORMATION]
Includes Domain Name, Username, Password, IP
[DOMAINNAME]
domain name without http://www.
[DOMAINUSERNAME]
Domain User Name
[DOMAINPASSWORD]
Domain Password
[DOMAINIP]
IP Address to Domain
[COMPANYURL]
URL to your website
[SUPPORTEMAIL]
Email to support staff
[CLIENTAPPLICATIONURL]
URL to Client Exec.
[CLIENTNAME]
Both first and last name
[NAMESERVERS]
lists only hostnames
[NAMESERVERSANDIPS]
lists both IPs and hostnames
[SERVERHOSTNAME]
example server1.yourdomain.com
[SERVERSHAREDIP]
shared IP for server','Click to view available tags',240,320); INSERT INTO help VALUES (2,'Invoice Template Tags','[DATE] Date payment is due.
[SENTDATE] Date invoice was originally sent.
[CLIENTNAME]
[INVOICENUMBER]
[INVOICEDESCRIPTION]
[AMOUNT] The total price due.
[CLIENTAPPLICATIONURL] URL to Client Exec.
[COMPANYNAME]
[BILLINGEMAIL] Email address for billing inquires
','Click to view available tags',240,320); INSERT INTO help VALUES (3,'Recommend Us Tags','[CLIENTNAME]
\r\n[COMPANYNAME]
\r\n[COMPANYURL] URL to your companies website, not ClientExec\'s
\r\n','Click to view available tags',240,320); INSERT INTO help VALUES (4,'Reset Password Tags','[CLIENTNAME]
\r\n[COMPANYNAME]
\r\n[REQUESTIP] IP of the machine which requested the password changed.
\r\n[CONFIRMATION URL] URL that user must press to confirm the password change
','Click to view available tags',240,320); INSERT INTO help VALUES (5,'Recurring Invoice Setting',' Generate Uninvoiced Work:
Creates an uninvoiced work entry for your customer. You will need to create an invoice, or merge it INTO an invoice and send.

 Generate Invoice:
Creates an invoice with one entry for the hosting work. Invoice will still need to be sent.

 Generate Invoice & Send:
Creates the invoice and sends.','Click for more detailed info',240,320); INSERT INTO help VALUES (6,'Ticket Template Tags','[CLIENTNAME]
[TICKETNUMBER]
[DESCRIPTION]
[CLIENTAPPLICATIONURL] URL to Client Exec.
[COMPANYNAME]
','Click to view available tags',240,320); INSERT INTO help VALUES (7,'Signup Completion Tags','[COMPANYNAME]
[COMPANYURL]
URL to your website
[SUPPORTEMAIL]
Email to support staff
[CLIENTAPPLICATIONURL]
URL to Client Exec.','Click to view available tags',240,320); -- -- Table structure for table 'invoice' -- CREATE TABLE invoice ( id int(11) NOT NULL auto_increment, customerid int(11) NOT NULL default '0', billdate date NOT NULL default '0000-00-00', description varchar(50) NOT NULL default '', amount float NOT NULL default '0', sent tinyint(4) NOT NULL default '0', paid tinyint(1) NOT NULL default '0', archive tinyint(4) NOT NULL default '0', sentdate date default NULL, datepaid date default NULL, PRIMARY KEY (id), UNIQUE KEY id (id) ) TYPE=MyISAM; -- -- Dumping data for table 'invoice' -- INSERT INTO invoice VALUES (1000,101,'2003-02-22','Invoice #1000',85,1,0,0,'2003-02-23',NULL); -- -- Table structure for table 'invoiceentry' -- CREATE TABLE invoiceentry ( id int(11) NOT NULL auto_increment, customerid int(11) NOT NULL default '0', description varchar(95) NOT NULL default '', detail text NOT NULL, invoiceid int(11) NOT NULL default '0', date date NOT NULL default '0000-00-00', billingtypeid int(11) NOT NULL default '0', price float NOT NULL default '0', recurring int(11) NOT NULL default '0', appliestoid int(11) NOT NULL default '0', includenextpayment tinyint(4) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM COMMENT='Maintain information of work completed for customer'; -- -- Dumping data for table 'invoiceentry' -- INSERT INTO invoiceentry VALUES (1,101,'Hosting for centurywebdesign.com, 22/02/2003 thru 22/02/2004','centurywebdesign.com (£ 85.00) =£ 85.00\n',1000,'2003-02-22',0,85,0,1,0); -- -- Table structure for table 'module' -- CREATE TABLE module ( id int(11) NOT NULL auto_increment, name varchar(25) NOT NULL default '', description text, moduleorder int(11) NOT NULL default '0', deletable tinyint(4) NOT NULL default '1', PRIMARY KEY (id), UNIQUE KEY id (id), KEY id_2 (id) ) TYPE=MyISAM; -- -- Dumping data for table 'module' -- INSERT INTO module VALUES (2,'HOME','This is an example Home Text string! You can change this in Admin-settings',1,0); INSERT INTO module VALUES (3,'CLIENTS','This is an example Client Text string! You can change this in Admin-settings',2,0); INSERT INTO module VALUES (4,'BILLING','This is an example Support Text string! You can change this in Admin-settings',3,1); INSERT INTO module VALUES (5,'SUPPORT','This is an example Support Text string! You can change this in Admin-settings',4,1); INSERT INTO module VALUES (6,'ADMIN','This is an example Admin Text string! You can change this in Admin-settings',5,0); -- -- Table structure for table 'module_group' -- CREATE TABLE module_group ( moduleid int(11) NOT NULL default '0', groupid int(11) NOT NULL default '0', viewable tinyint(4) NOT NULL default '1', viewall tinyint(4) NOT NULL default '1', PRIMARY KEY (moduleid,groupid) ) TYPE=MyISAM; -- -- Dumping data for table 'module_group' -- INSERT INTO module_group VALUES (2,2,1,1); INSERT INTO module_group VALUES (3,2,1,1); INSERT INTO module_group VALUES (4,2,1,1); INSERT INTO module_group VALUES (5,2,1,1); INSERT INTO module_group VALUES (6,2,1,1); INSERT INTO module_group VALUES (2,3,1,0); INSERT INTO module_group VALUES (3,3,1,1); INSERT INTO module_group VALUES (4,3,1,1); INSERT INTO module_group VALUES (5,3,1,1); INSERT INTO module_group VALUES (6,3,1,0); INSERT INTO module_group VALUES (2,1,1,0); INSERT INTO module_group VALUES (3,1,1,0); INSERT INTO module_group VALUES (4,1,1,0); INSERT INTO module_group VALUES (5,1,1,0); INSERT INTO module_group VALUES (6,1,0,0); -- -- Table structure for table 'nameserver' -- CREATE TABLE nameserver ( id int(11) NOT NULL auto_increment, serverid int(11) NOT NULL default '0', ip varchar(50) NOT NULL default '', hostname varchar(50) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'nameserver' -- -- -- Table structure for table 'package' -- CREATE TABLE package ( id int(11) NOT NULL auto_increment, planname varchar(25) NOT NULL default '', description text NOT NULL, planid int(11) NOT NULL default '0', price float NOT NULL default '0', showpackage tinyint(1) NOT NULL default '1', price3 float NOT NULL default '0', price6 float NOT NULL default '0', price12 float NOT NULL default '0', price1included tinyint(4) NOT NULL default '1', price3included tinyint(4) NOT NULL default '1', price6included tinyint(4) NOT NULL default '1', price12included tinyint(4) NOT NULL default '1', setup float NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id), KEY id_2 (id) ) TYPE=MyISAM; -- -- Dumping data for table 'package' -- INSERT INTO package VALUES (1,'Basic','Plan Features:
\r\n2Gig Bandwidth
\r\n40MB Diskspace
\r\n...',5,0,1,0,45,85,0,0,1,1,0); INSERT INTO package VALUES (2,'Premium','Plan Features:
\r\n4Gig Bandwidth
\r\n100MB Diskspace
\r\n...',5,0,1,0,85,150,0,0,1,1,0); -- -- Table structure for table 'promotion' -- CREATE TABLE promotion ( id int(11) NOT NULL auto_increment, code varchar(20) NOT NULL default '', description text NOT NULL, active tinyint(4) NOT NULL default '1', showuser tinyint(4) NOT NULL default '0', welcomeemail text NOT NULL, isdefault smallint(1) NOT NULL default '0', name varchar(50) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'promotion' -- INSERT INTO promotion VALUES (5,'NORMAL','This client type is used for everyone signing up for our services through our advertised rates on our website, normal clients. (non promotions)',1,1,'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the " mainwebsite_html " directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL] for fastest response.\r\n\r\nThanks for choosing our company.',1,'Shared Web Hosting'); -- -- Table structure for table 'recurringfee' -- CREATE TABLE recurringfee ( id int(11) NOT NULL auto_increment, customerid int(11) NOT NULL default '0', billingtypeid int(11) NOT NULL default '0', description text NOT NULL, detail text NOT NULL, amount float NOT NULL default '0', appliestoid int(11) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id), KEY id_2 (id) ) TYPE=MyISAM; -- -- Dumping data for table 'recurringfee' -- -- -- Table structure for table 'server' -- CREATE TABLE server ( id int(11) NOT NULL auto_increment, name varchar(25) NOT NULL default '', hostname varchar(50) NOT NULL default '', sharedip varchar(50) NOT NULL default '', isdefault tinyint(1) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'server' -- INSERT INTO server VALUES (1,'Srv01','srv01.centurywebdesign.com','216.127.66.50',1); -- -- Table structure for table 'serverip' -- CREATE TABLE serverip ( serverid int(11) NOT NULL default '0', ip varchar(50) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table 'serverip' -- INSERT INTO serverip VALUES (1,'216.127.66.52'); INSERT INTO serverip VALUES (1,'216.127.66.162'); INSERT INTO serverip VALUES (1,'216.127.66.163'); INSERT INTO serverip VALUES (1,'216.127.66.164'); INSERT INTO serverip VALUES (1,'216.127.66.165'); INSERT INTO serverip VALUES (1,'216.127.66.166'); INSERT INTO serverip VALUES (1,'216.127.66.167'); -- -- Table structure for table 'setting' -- CREATE TABLE setting ( id int(11) NOT NULL auto_increment, name varchar(100) default NULL, value text NOT NULL, description text NOT NULL, type tinyint(4) NOT NULL default '0', isrequired tinyint(4) NOT NULL default '1', istruefalse tinyint(4) NOT NULL default '0', istextarea tinyint(4) NOT NULL default '0', isfromoptions tinyint(4) NOT NULL default '0', myorder int(11) NOT NULL default '0', helpid int(3) default '0', plugin tinyint(4) NOT NULL default '0', ispassword tinyint(4) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id), KEY id_2 (id), KEY plugin (plugin) ) TYPE=MyISAM; -- -- Dumping data for table 'setting' -- INSERT INTO setting VALUES (1,'Title','Member Center :','String that is visable in the browser title. This string with the slogan variable make up the title for all pages.',1,0,0,0,0,0,0,0,0); INSERT INTO setting VALUES (3,'Company URL','http://www.centurywebdesign.co.uk','Your company\'s domain name with http:// preceding the domain name
(example: http://www.clientexec.com)',1,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (4,'Company Name','Century Web Design Ltd','Your company name',1,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (69,'ClientExec Version','1.0 RC 1','Version of ClientExec',0,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (6,'Template','Raleigh','Select the template you wish your users to see. For new templates to be visable you must place the new style in the templates folder, which is off of the ClientExec root directory.',2,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (7,'PopUpBackColor','#FFFFCC','Background color used for popups throughout the site.
A sample TABLE has been colored in with the color you have selected.',2,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (8,'PopUpTextColor','#000000','Text color used for popups throughout the site.
A sample TABLE has been colored in with the color you have selected.',2,1,0,0,0,3,0,0,0); INSERT INTO setting VALUES (13,'SMTP Host','mail.centurywebdesign.com','This is the SMTP host information to relay your email through.',3,0,0,0,0,1,0,0,0); INSERT INTO setting VALUES (14,'SMTP Username','cwd-general@centurywebdesign.com','Username required for relaying email through your SMTP Host.
Note: Only fill this in if your server requires server authentication. Filling this setting in will set SMTP authentication on.',3,0,0,0,0,2,0,0,0); INSERT INTO setting VALUES (15,'SMTP Password','nOOdle','Password required for relaying email through your SMTP Host.
Note: Only fill this in if your server requires server authentication.',3,0,0,0,0,3,0,0,0); INSERT INTO setting VALUES (20,'Billing Email','payments@centurywebdesign.co.uk','This is the email address that is visible to users after receiving an invoice payment request by email.',4,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (21,'Invoice Subject','Paymants Department','Subject to be displayed to clients when they receive an invoice payment request by email.',4,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (22,'Billing Name','Accounts','Real Name to be used for Invoice Payment Requests.',4,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (100,'Allow Bank Transfer Payments','0','Select yes if you want to give your new customers the option of paying by bank transfers',4,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (101,'Send Invoice Offset','15','Select the number of days prior to your invoice\'s due date to send your customer their invoice',4,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (18,'Popup Confirmations','1','Setting this option to YES will provide you with a popup alert after completing most actions with the application.',1,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (24,'ClientExec URL','http://www.centurywebdesign.com/account','The URL to this application. This value is used in many places where client is sent a link or where any 3rd party billing might return to give control back to this site.
Note: Make sure you include http:// in front of the domain name
(example: http://www.clientexec.com)',1,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (72,'Allow Check and MoneyOrder Payments','1','Select Yes if you want to give your new customers the option of paying by check or money order',4,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (23,'Invoice BCC','1','Select YES if you want the application to send a BCC, Blind Carbon Copy, to your BILLING email each time an invoice is sent.',4,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (40,'Advertising or Banner','','This section can be used to display any extra information you want to share with your clients.
Note: The setting \'Show Information Window\' must be set to use for this to be seen by your customers.',1,0,0,1,0,0,0,0,0); INSERT INTO setting VALUES (61,'Archive Invoices After Payment','0','Automatically archive invoices for customer after payment is made.',4,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (62,'Trouble Ticket Start Number','1000','Determine the number you wish to start numbering your trouble tickets',8,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (63,'Trouble Ticket Template','ATTN: [CLIENTNAME],\n\nTrouble Ticket #[TICKETNUMBER] has been updated\n\nDescription:\n[DESCRIPTION]\n\nIf you want to view the entire log of this ticket log onto our client management site at [CLIENTAPPLICATIONURL] with your username and password.\n\nIf you have any questions regarding this response or any other support questions please feel free to contact us.\n\nThank you,\n[COMPANYNAME]','Template for emails that get sent our to clients after their tickets have been commented on or closed.',7,1,0,1,0,0,6,0,0); INSERT INTO setting VALUES (98,'PopUpBorderColor','#FFCC00','Border color used for popups throughout the site.
A sample TABLE has been colored in with the color you have selected.',2,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (99,'Default Country Name','48fcd6956b782234a762a3af339caa72','',-1,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (58,'Access Via Domain Username','1','Allow user to access ClientExec with any one of their domain\'s username and password.',1,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (75,'Offer Domain Services','1','Select Yes if you want ClientExec to offer the ability to transfer or register a domain for a customer during signup.',10,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (45,'Show Client UserID','0','Allow your clients to view their userid when browsing their profile.',1,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (35,'Payment Receipt Template','Dear [CLIENTNAME],\r\n\r\nPayment receipt for Invoice #[INVOICENUMBER], sent on [DATE].\r\n\r\nCompany: [COMPANYNAME]. \r\nTotal Charge: [AMOUNT] \r\n\r\nYou may review your invoice history at any time by logging in at: [CLIENTAPPLICATIONURL]\r\n\r\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].\r\n\r\nNote: This email will serve as an official receipt for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]','Template for the email sent to clients after invoice is paid.',7,1,0,1,0,0,2,0,0); INSERT INTO setting VALUES (70,'Default Gateway','paypal','',0,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (71,'Default Currency','GBP','Select the default currency you would like ClientExec to use for your customers. This will also be the currency used during customer signup',4,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (34,'Invoice Template','Due Date: [DATE]\r\nInvoice #[INVOICENUMBER]\r\n\r\nATTN: [CLIENTNAME],\r\n\r\nYou currently have a balance of [AMOUNT] due on your account with [COMPANYNAME]. \r\n\r\nInvoice Description:\r\n[INVOICEDESCRIPTION]\r\n\r\nTotal Due: [AMOUNT]\r\n\r\nPayment Instructions:\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\r\n2) Click on the \"Billing\" tab\r\n3) Select the invoice you want to pay\r\n4) Click on pay invoice\r\n\r\nWe greatly appreciate your efforts to ensure that payment\r\nis received in a timely matter.\r\n\r\nIf you have any questions regarding your account or if \r\nyou wish to pay by check, please feel free to contact us.\r\n\r\nNote: This email will serve as an official invoice for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]','Template for invoices sent through email.',7,1,0,1,0,0,2,0,0); INSERT INTO setting VALUES (36,'Support Email','support@centurywebdesign.co.uk','Email address you want all support questions sent to. This email address is used as an entry to some template based emails, such as the welcome email template.',8,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (73,'Include Saved Percentage','1','Select Yes if you want to show percentage saved in signup script when a customer selects a longer billing cycle.',10,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (38,'Integrate Control Panel','1','Select YES if you want to integrate with a specific hosting control panel. Note: You must provide the required information for the control panel you select.',9,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (57,'Access Via Alt Emails','1','Allow user to access ClientExec with any one of their Alternate Emails in their profile.',1,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (39,'Cpanel Port','2082','List the port number used in your installation of the Cpanel Control Panel. Note: This is usually set to 2082 as the default setting',9,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (74,'Check Domain Availability','1','Select Yes if you want ClientExec to check on customer\'s domain availability during signup.',10,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (42,'Welcome System Message','Welcome to our Member Center!','Include the initial System Message all new users will see upon visiting the Home Page',1,0,0,1,0,0,0,0,0); INSERT INTO setting VALUES (43,'Recommend Us Template','Hi,\r\n\r\nYour Friend, [CLIENTNAME], considered our hosting services at [COMPANYNAME] interesting and wanted to send you our link. Please feel free to contact us with any questions you might have about what we can do for you.\r\n\r\n[COMPANYNAME]\r\n[COMPANYURL] ','Allow your clients to recommend your services to both their associates and friends.',7,0,0,1,0,0,3,0,0); INSERT INTO setting VALUES (65,'Additional Notes For Invoices','','Additonal information to provide for those clients that make payments via checks. This text will be provided as well in the PDF invoices if the field is not left blank.',4,0,0,1,0,0,0,0,0); INSERT INTO setting VALUES (46,'Forgot Password Template','[CLIENTNAME],\r\n\r\nA web user from [REQUESTIP] has just requested to change the password on this account.\r\n\r\nBy clicking on the confimation link below you will be sent a new password and are recommended to change it after logging in.\r\n\r\nConfirmation URL: [CONFIRMATION URL]\r\n\r\nThank you,\r\n[COMPANYNAME]','Allow your clients to recommend your services to both their associates and friends.',7,0,0,1,0,0,4,0,0); INSERT INTO setting VALUES (47,'Mail Type','1','Select the method you want ClientExec to send mail.
Note: If you have selected SMTP you will need to complete the SMTP settings as well.',3,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (49,'Invoice Start Number','1000','Determine the number you wish to start numbering your invoices',4,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (51,'Enable Pay Invoice','1','Determine if you want your clients to view the pay invoice button',4,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (52,'Language','English','Determine the default language for your site',1,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (53,'IM Online Status','1','Show when users are logged into their IM Client.
Note: User must have a valid IM client ID identified in their profile',1,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (54,'Recurring Invoice Setting','1','The following setting will allow you to determine how to handle recurring invoices from within the application.',4,1,0,0,0,0,5,0,0); INSERT INTO setting VALUES (55,'Show Change Domain Password','0','This setting determines if you want to allow customers to change their domain password.',1,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (64,'Display Tickets Ascending','1','Select YES if you want to display trouble tickets in the order they were entered. NO will display the tickets in Descending order, the latest one on top.',8,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (56,'Show All Settings','1','This setting allows you to view all settings for a given type at once.',0,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (67,'Email For New Trouble Tickets','support@centurywebdesign.co.uk','Email addresses ClientExec will send email notification on all new trouble tickets. You can seperate emails by a comma
Example: support1@domain.com, support2@domain.com',8,0,0,0,0,0,0,0,0); INSERT INTO setting VALUES (68,'Date Format','d/m/Y','Select the date format you want site wide.',1,0,0,0,0,0,0,0,0); INSERT INTO setting VALUES (76,'Forward To Gateway','0','Select Yes if you want ClientExec to forward all new customers to the gateway selected for payment. CHECK and Money ORDER selections will just create the pending account and notify admin.',10,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (77,'Domain Registration Extra','','Include text you want displayed when prompting new user on action to take place with either new domain or a transfer.',10,0,0,1,0,0,0,0,0); INSERT INTO setting VALUES (78,'Signup Completion Template','
Thank you for your order

You should receive your invoice information shortly, followed by your account information. If you do not receive your account information within 24 hours, please contact our sales team at [SUPPORTEMAIL]

Thank you for choosing [COMPANYNAME]!
','Text shown upon signup completion for new customers that are not forwarded to a payment gateway.
Note: HTML accepted
',10,0,0,1,0,0,7,0,0); INSERT INTO setting VALUES (79,'Show Terms and Conditions','0','Select Yes if you want ClientExec to show the terms and conditions and enforce approval before completing the signup process',10,1,1,0,0,0,0,0,0); INSERT INTO setting VALUES (80,'Terms and Conditions','Your terms and conditions go here ...','Terms and Conditions that new customers need to agree to before receiving your services. The setting, Show Term and Conditions, will need to be set to Yes before this content is displayed in the signup process.
Note: Content will be displayed inside a textarea',10,0,0,1,0,0,0,0,0); INSERT INTO setting VALUES (81,'plugin_2checkout_Seller ID','','ID used to identify you to 2checkout.com.
Note: This ID is required if you have selected 2checkout as a payment gateway for any of your clients.',6,0,0,0,0,0,0,1,0); INSERT INTO setting VALUES (82,'plugin_2checkout_In Signup','0','Select YES if you want to include this payment processor in the signup script.',6,0,1,0,0,0,0,1,0); INSERT INTO setting VALUES (83,'plugin_2checkout_Signup Name','credit card','Select the name to display in the signup process for this payment type. Example: eCheck or Credit Card.',6,0,0,0,0,0,0,1,0); INSERT INTO setting VALUES (84,'plugin_paypal_User ID','','ID used to identify you to PayPal.
Note: This ID is required if you have selected PayPal as a payment gateway for any of your clients.',6,0,0,0,0,0,0,1,0); INSERT INTO setting VALUES (85,'plugin_paypal_In Signup','0','Select YES if you want to include this payment processor in the signup script.',6,0,1,0,0,0,0,1,0); INSERT INTO setting VALUES (86,'plugin_paypal_Signup Name','paypal','Select the name to display in the signup process for this payment type. Example: eCheck or Credit Card.',6,0,0,0,0,0,0,1,0); INSERT INTO setting VALUES (87,'plugin_paysystems_Company ID','','ID used to identify you to PaySystems.
Note: This ID is required if you have selected PaySystems as a payment gateway for any of your clients.',6,0,0,0,0,0,0,1,0); INSERT INTO setting VALUES (88,'plugin_paysystems_In Signup','0','Select YES if you want to include this payment processor in the signup script.',6,0,1,0,0,0,0,1,0); INSERT INTO setting VALUES (89,'plugin_paysystems_Signup Name','credit card','Select the name to display in the signup process for this payment type. Example: eCheck or Credit Card.',6,0,0,0,0,0,0,1,0); INSERT INTO setting VALUES (90,'plugin_worldpay_Installation ID','','ID used to identify you to WorldPay.
Note: This ID is required if you have selected WorldPay as a payment gateway for any of your clients.',6,0,0,0,0,0,0,1,0); INSERT INTO setting VALUES (91,'plugin_worldpay_Callback Password','','Password used to verify valid transactions FROM WorldPay Callbacks.
Note: This password has to match the value set in the WorldPay Customer Managment System.',6,0,0,0,0,0,0,1,1); INSERT INTO setting VALUES (92,'plugin_worldpay_MD5 Secret','','MD5 Secret used to verify valid transactions FROM WorldPay.
Note: This secret has to match the value set in the WorldPay Customer Managment System.',6,0,0,0,0,0,0,1,1); INSERT INTO setting VALUES (93,'plugin_worldpay_In Signup','0','Select YES if you want to include this payment processor in the signup script.',6,0,1,0,0,0,0,1,0); INSERT INTO setting VALUES (94,'plugin_worldpay_Signup Name','credit card','Select the name to display in the signup process for this payment type. Example: eCheck or Credit Card.',6,0,0,0,0,0,0,1,0); INSERT INTO setting VALUES (95,'Document Root','/home/virtual/site1/fst/var/www/html/account','',0,1,0,0,0,0,0,0,0); INSERT INTO setting VALUES (96,'Email For New Signups','','Email addresses ClientExec will send email notifications to after all new signups. You can seperate emails by a comma
Example: support1@domain.com, support2@domain.com',10,0,0,0,0,0,0,0,0); INSERT INTO setting VALUES (97,'Default Country','GB','Default Country for your ClientExec installation',1,0,0,0,0,0,0,0,0); -- -- Table structure for table 'setting_options' -- CREATE TABLE setting_options ( id int(11) NOT NULL auto_increment, settingid int(11) NOT NULL default '0', name varchar(50) NOT NULL default '', value text, PRIMARY KEY (id), UNIQUE KEY id (id), KEY id_2 (id) ) TYPE=MyISAM COMMENT='Contains all the available options for a giving setting'; -- -- Dumping data for table 'setting_options' -- -- -- Table structure for table 'troubleticket' -- CREATE TABLE troubleticket ( id int(11) NOT NULL auto_increment, userid int(11) NOT NULL default '0', subject text NOT NULL, priority int(2) NOT NULL default '3', datesubmitted datetime NOT NULL default '0000-00-00 00:00:00', status int(2) NOT NULL default '0', messagetype varchar(40) NOT NULL default 'Other', assignedtoid int(11) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'troubleticket' -- -- -- Table structure for table 'troubleticket_log' -- CREATE TABLE troubleticket_log ( id int(11) NOT NULL auto_increment, troubleticketid int(11) NOT NULL default '0', message text NOT NULL, userid int(11) NOT NULL default '0', mydatetime datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'troubleticket_log' -- -- -- Table structure for table 'troubleticket_type' -- CREATE TABLE troubleticket_type ( name varchar(40) NOT NULL default '', myorder int(2) NOT NULL default '0', PRIMARY KEY (name) ) TYPE=MyISAM; -- -- Dumping data for table 'troubleticket_type' -- INSERT INTO troubleticket_type VALUES ('Software',0); INSERT INTO troubleticket_type VALUES ('Billing Issues',1); INSERT INTO troubleticket_type VALUES ('Control Panel',2); INSERT INTO troubleticket_type VALUES ('Email Problems',3); INSERT INTO troubleticket_type VALUES ('Upgrades',4); INSERT INTO troubleticket_type VALUES ('Other',5); -- -- Table structure for table 'user_customuserfields' -- CREATE TABLE user_customuserfields ( userid int(11) NOT NULL default '0', customid int(11) NOT NULL default '0', value text, PRIMARY KEY (userid,customid), KEY userid (userid), KEY customid (customid) ) TYPE=MyISAM; -- -- Dumping data for table 'user_customuserfields' -- INSERT INTO user_customuserfields VALUES (100,1,'Admin'); INSERT INTO user_customuserfields VALUES (100,2,'User'); INSERT INTO user_customuserfields VALUES (100,4,'nigel.crossley@centurywebdesign.co.uk'); INSERT INTO user_customuserfields VALUES (101,1,'Nigel'); INSERT INTO user_customuserfields VALUES (101,2,'Crossley'); INSERT INTO user_customuserfields VALUES (101,4,'n.crossley@virgin.net'); INSERT INTO user_customuserfields VALUES (101,8,'02920638120'); INSERT INTO user_customuserfields VALUES (101,3,'44 Edington Ave, Heath'); INSERT INTO user_customuserfields VALUES (101,5,'Cardiff'); INSERT INTO user_customuserfields VALUES (101,7,'CF14 3QG'); INSERT INTO user_customuserfields VALUES (101,15,'GB'); -- -- Table structure for table 'users' -- CREATE TABLE users ( id int(11) NOT NULL auto_increment, current tinyint(1) default '0', nextbilldate date default NULL, comments mediumtext, paymenttype varchar(30) NOT NULL default '0', paymentterm tinyint(4) NOT NULL default '0', clienttype tinyint(4) NOT NULL default '0', groupid int(10) unsigned default '1', password varchar(45) default NULL, dateActivated date default NULL, signature text, systemmsg text, lastseen datetime default NULL, isOrganization tinyint(4) default '0', active smallint(6) NOT NULL default '1', recurring tinyint(4) default '1', currency varchar(5) default '0', pending tinyint(1) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table 'users' -- INSERT INTO users VALUES (100,0,'0000-00-00','Admin user','2checkout',0,0,2,'2cbf3b7657a6fa64','0000-00-00','admin@domain.com\r\nReinventing Support!','Welcome to our Member Center!','2003-03-06 22:27:05',0,1,1,'USD',0); INSERT INTO users VALUES (101,0,'2004-02-22','IP: 81.103.34.173\nHOSTNAME: pc4-whit1-4-cust173.cdif.cable.ntl.com\nUSER AGENT: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705)','check',12,5,1,'47db33034f5b95d6','2003-02-22',NULL,'Welcome to our Member Center!','2003-02-22 18:47:22',0,1,1,'GBP',0);