-- MySQL dump 10.10 -- -- Host: mysql9.servage.net Database: crowsnest3 -- ------------------------------------------------------ -- Server version 4.0.26-standard /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `cpg148_albums` -- CREATE TABLE `cpg148_albums` ( `aid` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `description` text NOT NULL, `visibility` int(11) NOT NULL default '0', `uploads` enum('YES','NO') NOT NULL default 'NO', `comments` enum('YES','NO') NOT NULL default 'YES', `votes` enum('YES','NO') NOT NULL default 'YES', `pos` int(11) NOT NULL default '0', `category` int(11) NOT NULL default '0', `thumb` int(11) NOT NULL default '0', `keyword` varchar(50) default NULL, `alb_password` varchar(32) default NULL, `alb_password_hint` text, PRIMARY KEY (`aid`), KEY `alb_category` (`category`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_albums` -- INSERT INTO `cpg148_albums` VALUES (1,'New album','',0,'NO','YES','YES',100,10001,0,NULL,NULL,NULL); INSERT INTO `cpg148_albums` VALUES (2,'1812lsd','1812lsd's pic's',0,'NO','YES','YES',100,10002,8,'photos','',''); INSERT INTO `cpg148_albums` VALUES (4,'Koda's Pics','',0,'NO','YES','YES',1,10003,0,NULL,NULL,NULL); INSERT INTO `cpg148_albums` VALUES (5,'INF Pics','',0,'NO','YES','YES',1,2,0,NULL,NULL,NULL); INSERT INTO `cpg148_albums` VALUES (6,'Deerslayers','',0,'NO','YES','YES',1,10004,0,NULL,NULL,NULL); INSERT INTO `cpg148_albums` VALUES (7,'New album','',0,'NO','YES','YES',100,10005,0,NULL,NULL,NULL); INSERT INTO `cpg148_albums` VALUES (8,'New album','',0,'NO','YES','YES',101,10005,0,NULL,NULL,NULL); INSERT INTO `cpg148_albums` VALUES (9,'a1','',0,'NO','YES','YES',1,10006,0,NULL,NULL,NULL); INSERT INTO `cpg148_albums` VALUES (10,'New album','',0,'NO','YES','YES',1,10007,0,NULL,NULL,NULL); -- -- Table structure for table `cpg148_banned` -- CREATE TABLE `cpg148_banned` ( `ban_id` int(11) NOT NULL auto_increment, `user_id` int(11) default NULL, `ip_addr` tinytext, `expiry` datetime default NULL, `brute_force` tinyint(5) NOT NULL default '0', PRIMARY KEY (`ban_id`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_banned` -- -- -- Table structure for table `cpg148_bridge` -- CREATE TABLE `cpg148_bridge` ( `name` varchar(40) NOT NULL default '0', `value` varchar(255) NOT NULL default '', UNIQUE KEY `name` (`name`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_bridge` -- INSERT INTO `cpg148_bridge` VALUES ('short_name',''); INSERT INTO `cpg148_bridge` VALUES ('license_number',''); INSERT INTO `cpg148_bridge` VALUES ('db_database_name',''); INSERT INTO `cpg148_bridge` VALUES ('db_hostname',''); INSERT INTO `cpg148_bridge` VALUES ('db_username',''); INSERT INTO `cpg148_bridge` VALUES ('db_password',''); INSERT INTO `cpg148_bridge` VALUES ('full_forum_url',''); INSERT INTO `cpg148_bridge` VALUES ('relative_path_of_forum_from_webroot',''); INSERT INTO `cpg148_bridge` VALUES ('relative_path_to_config_file',''); INSERT INTO `cpg148_bridge` VALUES ('logout_flag',''); INSERT INTO `cpg148_bridge` VALUES ('use_post_based_groups',''); INSERT INTO `cpg148_bridge` VALUES ('cookie_prefix',''); INSERT INTO `cpg148_bridge` VALUES ('table_prefix',''); INSERT INTO `cpg148_bridge` VALUES ('user_table',''); INSERT INTO `cpg148_bridge` VALUES ('session_table',''); INSERT INTO `cpg148_bridge` VALUES ('group_table',''); INSERT INTO `cpg148_bridge` VALUES ('group_relation_table',''); INSERT INTO `cpg148_bridge` VALUES ('group_mapping_table',''); INSERT INTO `cpg148_bridge` VALUES ('use_standard_groups','1'); INSERT INTO `cpg148_bridge` VALUES ('validating_group',''); INSERT INTO `cpg148_bridge` VALUES ('guest_group',''); INSERT INTO `cpg148_bridge` VALUES ('member_group',''); INSERT INTO `cpg148_bridge` VALUES ('admin_group',''); INSERT INTO `cpg148_bridge` VALUES ('banned_group',''); INSERT INTO `cpg148_bridge` VALUES ('global_moderators_group',''); INSERT INTO `cpg148_bridge` VALUES ('recovery_logon_failures','0'); INSERT INTO `cpg148_bridge` VALUES ('recovery_logon_timestamp',''); -- -- Table structure for table `cpg148_categories` -- CREATE TABLE `cpg148_categories` ( `cid` int(11) NOT NULL auto_increment, `owner_id` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `pos` int(11) NOT NULL default '0', `parent` int(11) NOT NULL default '0', `thumb` int(11) NOT NULL default '0', PRIMARY KEY (`cid`), KEY `cat_parent` (`parent`), KEY `cat_pos` (`pos`), KEY `cat_owner_id` (`owner_id`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_categories` -- INSERT INTO `cpg148_categories` VALUES (1,0,'User galleries','This category contains albums that belong to Coppermine users.',0,0,0); INSERT INTO `cpg148_categories` VALUES (2,0,'INF Shared pics','hopefully we can share this folder',1,0,0); -- -- Table structure for table `cpg148_comments` -- CREATE TABLE `cpg148_comments` ( `pid` mediumint(10) NOT NULL default '0', `msg_id` mediumint(10) NOT NULL auto_increment, `msg_author` varchar(25) NOT NULL default '', `msg_body` text NOT NULL, `msg_date` datetime NOT NULL default '0000-00-00 00:00:00', `msg_raw_ip` tinytext, `msg_hdr_ip` tinytext, `author_md5_id` varchar(32) NOT NULL default '', `author_id` int(11) NOT NULL default '0', PRIMARY KEY (`msg_id`), KEY `com_pic_id` (`pid`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_comments` -- INSERT INTO `cpg148_comments` VALUES (16,1,'1812lsd','Flamin Great ;-)','2006-07-25 17:14:39','86.128.188.21','86.128.188.21','',2); -- -- Table structure for table `cpg148_config` -- CREATE TABLE `cpg148_config` ( `name` varchar(40) NOT NULL default '', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`name`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_config` -- INSERT INTO `cpg148_config` VALUES ('albums_per_page','12'); INSERT INTO `cpg148_config` VALUES ('album_list_cols','2'); INSERT INTO `cpg148_config` VALUES ('display_pic_info','0'); INSERT INTO `cpg148_config` VALUES ('alb_list_thumb_size','50'); INSERT INTO `cpg148_config` VALUES ('allowed_mov_types','ALL'); INSERT INTO `cpg148_config` VALUES ('allowed_doc_types','doc/txt/rtf/pdf/xls/pps/ppt/zip/gz/mdb'); INSERT INTO `cpg148_config` VALUES ('allowed_snd_types','mp3/midi/mid/wma/wav/ogg'); INSERT INTO `cpg148_config` VALUES ('allowed_img_types','ALL'); INSERT INTO `cpg148_config` VALUES ('allow_private_albums','1'); INSERT INTO `cpg148_config` VALUES ('allow_user_registration','1'); INSERT INTO `cpg148_config` VALUES ('allow_unlogged_access','1'); INSERT INTO `cpg148_config` VALUES ('allow_duplicate_emails_addr','0'); INSERT INTO `cpg148_config` VALUES ('caption_in_thumbview','1'); INSERT INTO `cpg148_config` VALUES ('views_in_thumbview','1'); INSERT INTO `cpg148_config` VALUES ('charset','utf-8'); INSERT INTO `cpg148_config` VALUES ('cookie_name','http://iron-fists.eu/cpg143'); INSERT INTO `cpg148_config` VALUES ('cookie_path','/'); INSERT INTO `cpg148_config` VALUES ('debug_mode','0'); INSERT INTO `cpg148_config` VALUES ('debug_notice','0'); INSERT INTO `cpg148_config` VALUES ('default_dir_mode','0777'); INSERT INTO `cpg148_config` VALUES ('default_file_mode','0666'); INSERT INTO `cpg148_config` VALUES ('default_sort_order','na'); INSERT INTO `cpg148_config` VALUES ('ecards_more_pic_target','http://iron-fists.eu/cpg148/'); INSERT INTO `cpg148_config` VALUES ('home_target','http://iron-fists.eu/index.php'); INSERT INTO `cpg148_config` VALUES ('custom_lnk_name','HOME'); INSERT INTO `cpg148_config` VALUES ('custom_lnk_url','http://iron-fists.eu/'); INSERT INTO `cpg148_config` VALUES ('enable_smilies','1'); INSERT INTO `cpg148_config` VALUES ('filter_bad_words','0'); INSERT INTO `cpg148_config` VALUES ('forbiden_fname_char','$/\\\\:*?"'<>|` &'); INSERT INTO `cpg148_config` VALUES ('fullpath','albums/'); INSERT INTO `cpg148_config` VALUES ('gallery_admin_email','michael.cox7@ntlworld.com'); INSERT INTO `cpg148_config` VALUES ('gallery_description','INF online photo album.'); INSERT INTO `cpg148_config` VALUES ('gallery_name','Iron-Fists Gallery.'); INSERT INTO `cpg148_config` VALUES ('im_options','-antialias'); INSERT INTO `cpg148_config` VALUES ('impath',''); INSERT INTO `cpg148_config` VALUES ('jpeg_qual','100'); INSERT INTO `cpg148_config` VALUES ('keep_votes_time','30'); INSERT INTO `cpg148_config` VALUES ('lang','english'); INSERT INTO `cpg148_config` VALUES ('main_page_layout','breadcrumb/catlist/alblist/random,2/lastup,2'); INSERT INTO `cpg148_config` VALUES ('main_table_width','100%'); INSERT INTO `cpg148_config` VALUES ('make_intermediate','1'); INSERT INTO `cpg148_config` VALUES ('max_com_lines','10'); INSERT INTO `cpg148_config` VALUES ('max_com_size','512'); INSERT INTO `cpg148_config` VALUES ('max_com_wlength','38'); INSERT INTO `cpg148_config` VALUES ('max_img_desc_length','512'); INSERT INTO `cpg148_config` VALUES ('max_tabs','12'); INSERT INTO `cpg148_config` VALUES ('max_upl_size','1024'); INSERT INTO `cpg148_config` VALUES ('max_upl_width_height','2048'); INSERT INTO `cpg148_config` VALUES ('auto_resize','0'); INSERT INTO `cpg148_config` VALUES ('min_votes_for_rating','1'); INSERT INTO `cpg148_config` VALUES ('normal_pfx','normal_'); INSERT INTO `cpg148_config` VALUES ('offline','0'); INSERT INTO `cpg148_config` VALUES ('picture_table_width','600'); INSERT INTO `cpg148_config` VALUES ('picture_width','400'); INSERT INTO `cpg148_config` VALUES ('read_exif_data','0'); INSERT INTO `cpg148_config` VALUES ('reg_requires_valid_email','1'); INSERT INTO `cpg148_config` VALUES ('subcat_level','2'); INSERT INTO `cpg148_config` VALUES ('theme','igames'); INSERT INTO `cpg148_config` VALUES ('thumbcols','4'); INSERT INTO `cpg148_config` VALUES ('thumbrows','3'); INSERT INTO `cpg148_config` VALUES ('thumb_method','gd2'); INSERT INTO `cpg148_config` VALUES ('thumb_pfx','thumb_'); INSERT INTO `cpg148_config` VALUES ('thumb_width','150'); INSERT INTO `cpg148_config` VALUES ('userpics','userpics/'); INSERT INTO `cpg148_config` VALUES ('vanity_block','1'); INSERT INTO `cpg148_config` VALUES ('user_profile1_name','Location'); INSERT INTO `cpg148_config` VALUES ('user_profile2_name','Interests'); INSERT INTO `cpg148_config` VALUES ('user_profile3_name','Website'); INSERT INTO `cpg148_config` VALUES ('user_profile4_name','Occupation'); INSERT INTO `cpg148_config` VALUES ('user_profile5_name',''); INSERT INTO `cpg148_config` VALUES ('user_profile6_name','Biography'); INSERT INTO `cpg148_config` VALUES ('user_field1_name',''); INSERT INTO `cpg148_config` VALUES ('user_field2_name',''); INSERT INTO `cpg148_config` VALUES ('user_field3_name',''); INSERT INTO `cpg148_config` VALUES ('user_field4_name',''); INSERT INTO `cpg148_config` VALUES ('display_comment_count','1'); INSERT INTO `cpg148_config` VALUES ('show_private','1'); INSERT INTO `cpg148_config` VALUES ('first_level','1'); INSERT INTO `cpg148_config` VALUES ('display_film_strip','1'); INSERT INTO `cpg148_config` VALUES ('display_film_strip_filename','0'); INSERT INTO `cpg148_config` VALUES ('max_film_strip_items','5'); INSERT INTO `cpg148_config` VALUES ('thumb_use','any'); INSERT INTO `cpg148_config` VALUES ('read_iptc_data','0'); INSERT INTO `cpg148_config` VALUES ('reg_notify_admin_email','1'); INSERT INTO `cpg148_config` VALUES ('disable_comment_flood_protect','0'); INSERT INTO `cpg148_config` VALUES ('upl_notify_admin_email','1'); INSERT INTO `cpg148_config` VALUES ('display_uploader','1'); INSERT INTO `cpg148_config` VALUES ('display_filename','0'); INSERT INTO `cpg148_config` VALUES ('language_list','0'); INSERT INTO `cpg148_config` VALUES ('language_flags','0'); INSERT INTO `cpg148_config` VALUES ('theme_list','0'); INSERT INTO `cpg148_config` VALUES ('language_reset','1'); INSERT INTO `cpg148_config` VALUES ('theme_reset','0'); INSERT INTO `cpg148_config` VALUES ('allow_memberlist','0'); INSERT INTO `cpg148_config` VALUES ('display_faq','0'); INSERT INTO `cpg148_config` VALUES ('show_bbcode_help','1'); INSERT INTO `cpg148_config` VALUES ('log_ecards','1'); INSERT INTO `cpg148_config` VALUES ('email_comment_notification','0'); INSERT INTO `cpg148_config` VALUES ('enable_zipdownload','1'); INSERT INTO `cpg148_config` VALUES ('slideshow_interval','5000'); INSERT INTO `cpg148_config` VALUES ('log_mode','2'); INSERT INTO `cpg148_config` VALUES ('media_autostart','1'); INSERT INTO `cpg148_config` VALUES ('enable_encrypted_passwords','1'); INSERT INTO `cpg148_config` VALUES ('time_offset',''); INSERT INTO `cpg148_config` VALUES ('ban_private_ip','0'); INSERT INTO `cpg148_config` VALUES ('smtp_host',''); INSERT INTO `cpg148_config` VALUES ('smtp_username',''); INSERT INTO `cpg148_config` VALUES ('smtp_password',''); INSERT INTO `cpg148_config` VALUES ('enable_plugins','1'); INSERT INTO `cpg148_config` VALUES ('enable_help','1'); INSERT INTO `cpg148_config` VALUES ('categories_alpha_sort','1'); INSERT INTO `cpg148_config` VALUES ('login_threshold','5'); INSERT INTO `cpg148_config` VALUES ('login_expiry','10'); INSERT INTO `cpg148_config` VALUES ('allow_email_change','0'); INSERT INTO `cpg148_config` VALUES ('clickable_keyword_search','1'); INSERT INTO `cpg148_config` VALUES ('users_can_edit_pics','1'); INSERT INTO `cpg148_config` VALUES ('show_which_exif','|0|0|0|0|0|0|0|0|1|0|1|1|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|1|0|0|0|1|1|0|0|0|0|1|0|0|0|1|0|0|1|1|0|0|0|0|0|1|0|1|1'); INSERT INTO `cpg148_config` VALUES ('alb_desc_thumb','1'); INSERT INTO `cpg148_config` VALUES ('link_pic_count','0'); INSERT INTO `cpg148_config` VALUES ('bridge_enable','0'); INSERT INTO `cpg148_config` VALUES ('language_fallback','1'); INSERT INTO `cpg148_config` VALUES ('vote_details','1'); INSERT INTO `cpg148_config` VALUES ('hit_details','1'); INSERT INTO `cpg148_config` VALUES ('browse_batch_add','1'); INSERT INTO `cpg148_config` VALUES ('custom_header_path','http://iron-fists.eu/test1/downloads/sigs/INF-Server-Banner.jpg'); INSERT INTO `cpg148_config` VALUES ('custom_footer_path',''); INSERT INTO `cpg148_config` VALUES ('comments_sort_descending','0'); INSERT INTO `cpg148_config` VALUES ('report_post','1'); INSERT INTO `cpg148_config` VALUES ('comments_anon_pfx','Guest_'); INSERT INTO `cpg148_config` VALUES ('admin_activation','0'); -- -- Table structure for table `cpg148_dict` -- CREATE TABLE `cpg148_dict` ( `keyId` bigint(20) NOT NULL auto_increment, `keyword` varchar(60) NOT NULL default '', PRIMARY KEY (`keyId`) ) TYPE=MyISAM COMMENT='Holds the keyword dictionary'; -- -- Dumping data for table `cpg148_dict` -- -- -- Table structure for table `cpg148_ecards` -- CREATE TABLE `cpg148_ecards` ( `eid` int(11) NOT NULL auto_increment, `sender_name` varchar(50) NOT NULL default '', `sender_email` text NOT NULL, `recipient_name` varchar(50) NOT NULL default '', `recipient_email` text NOT NULL, `link` text NOT NULL, `date` tinytext NOT NULL, `sender_ip` tinytext NOT NULL, PRIMARY KEY (`eid`) ) TYPE=MyISAM COMMENT='Used to log ecards'; -- -- Dumping data for table `cpg148_ecards` -- -- -- Table structure for table `cpg148_exif` -- CREATE TABLE `cpg148_exif` ( `filename` varchar(255) NOT NULL default '', `exifData` text NOT NULL, UNIQUE KEY `filename` (`filename`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_exif` -- -- -- Table structure for table `cpg148_favpics` -- CREATE TABLE `cpg148_favpics` ( `user_id` int(11) NOT NULL default '0', `user_favpics` text NOT NULL, PRIMARY KEY (`user_id`) ) TYPE=MyISAM COMMENT='Stores the server side favourites'; -- -- Dumping data for table `cpg148_favpics` -- -- -- Table structure for table `cpg148_filetypes` -- CREATE TABLE `cpg148_filetypes` ( `extension` varchar(7) NOT NULL default '', `mime` varchar(30) default NULL, `content` varchar(15) default NULL, `player` varchar(5) default NULL, PRIMARY KEY (`extension`) ) TYPE=MyISAM COMMENT='Used to store the file extensions'; -- -- Dumping data for table `cpg148_filetypes` -- INSERT INTO `cpg148_filetypes` VALUES ('jpg','image/jpg','image',''); INSERT INTO `cpg148_filetypes` VALUES ('jpeg','image/jpeg','image',''); INSERT INTO `cpg148_filetypes` VALUES ('jpe','image/jpe','image',''); INSERT INTO `cpg148_filetypes` VALUES ('gif','image/gif','image',''); INSERT INTO `cpg148_filetypes` VALUES ('png','image/png','image',''); INSERT INTO `cpg148_filetypes` VALUES ('bmp','image/bmp','image',''); INSERT INTO `cpg148_filetypes` VALUES ('jpc','image/jpc','image',''); INSERT INTO `cpg148_filetypes` VALUES ('jp2','image/jp2','image',''); INSERT INTO `cpg148_filetypes` VALUES ('jpx','image/jpx','image',''); INSERT INTO `cpg148_filetypes` VALUES ('jb2','image/jb2','image',''); INSERT INTO `cpg148_filetypes` VALUES ('swc','image/swc','image',''); INSERT INTO `cpg148_filetypes` VALUES ('iff','image/iff','image',''); INSERT INTO `cpg148_filetypes` VALUES ('asf','video/x-ms-asf','movie','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('asx','video/x-ms-asx','movie','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('mpg','video/mpeg','movie','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('mpeg','video/mpeg','movie','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('wmv','video/x-ms-wmv','movie','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('swf','application/x-shockwave-flash','movie','SWF'); INSERT INTO `cpg148_filetypes` VALUES ('avi','video/avi','movie','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('mov','video/quicktime','movie','QT'); INSERT INTO `cpg148_filetypes` VALUES ('mp3','audio/mpeg3','audio','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('midi','audio/midi','audio','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('mid','audio/midi','audio','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('wma','audio/x-ms-wma','audio','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('wav','audio/wav','audio','WMP'); INSERT INTO `cpg148_filetypes` VALUES ('ogg','audio/ogg','audio',''); INSERT INTO `cpg148_filetypes` VALUES ('psd','image/psd','image',''); INSERT INTO `cpg148_filetypes` VALUES ('ram','audio/x-pn-realaudio','document','RMP'); INSERT INTO `cpg148_filetypes` VALUES ('ra','audio/x-realaudio','document','RMP'); INSERT INTO `cpg148_filetypes` VALUES ('rm','audio/x-realmedia','document','RMP'); INSERT INTO `cpg148_filetypes` VALUES ('tiff','image/tiff','document',''); INSERT INTO `cpg148_filetypes` VALUES ('tif','image/tif','document',''); INSERT INTO `cpg148_filetypes` VALUES ('doc','application/msword','document',''); INSERT INTO `cpg148_filetypes` VALUES ('txt','text/plain','document',''); INSERT INTO `cpg148_filetypes` VALUES ('rtf','text/richtext','document',''); INSERT INTO `cpg148_filetypes` VALUES ('pdf','application/pdf','document',''); INSERT INTO `cpg148_filetypes` VALUES ('xls','application/excel','document',''); INSERT INTO `cpg148_filetypes` VALUES ('pps','application/powerpoint','document',''); INSERT INTO `cpg148_filetypes` VALUES ('ppt','application/powerpoint','document',''); INSERT INTO `cpg148_filetypes` VALUES ('zip','application/zip','document',''); INSERT INTO `cpg148_filetypes` VALUES ('rar','application/rar','document',''); INSERT INTO `cpg148_filetypes` VALUES ('gz','application/gz','document',''); INSERT INTO `cpg148_filetypes` VALUES ('mdb','application/msaccess','document',''); -- -- Table structure for table `cpg148_hit_stats` -- CREATE TABLE `cpg148_hit_stats` ( `sid` int(11) NOT NULL auto_increment, `pid` varchar(100) NOT NULL default '', `ip` varchar(20) NOT NULL default '', `search_phrase` varchar(255) NOT NULL default '', `sdate` bigint(20) NOT NULL default '0', `referer` text NOT NULL, `browser` varchar(255) NOT NULL default '', `os` varchar(50) NOT NULL default '', PRIMARY KEY (`sid`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_hit_stats` -- -- -- Table structure for table `cpg148_pictures` -- CREATE TABLE `cpg148_pictures` ( `pid` int(11) NOT NULL auto_increment, `aid` int(11) NOT NULL default '0', `filepath` varchar(255) NOT NULL default '', `filename` varchar(255) NOT NULL default '', `filesize` int(11) NOT NULL default '0', `total_filesize` int(11) NOT NULL default '0', `pwidth` smallint(6) NOT NULL default '0', `pheight` smallint(6) NOT NULL default '0', `hits` int(10) NOT NULL default '0', `mtime` datetime NOT NULL default '0000-00-00 00:00:00', `ctime` int(11) NOT NULL default '0', `owner_id` int(11) NOT NULL default '0', `owner_name` varchar(40) NOT NULL default '', `pic_rating` int(11) NOT NULL default '0', `votes` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `caption` text NOT NULL, `keywords` varchar(255) NOT NULL default '', `approved` enum('YES','NO') NOT NULL default 'NO', `galleryicon` int(11) NOT NULL default '0', `user1` varchar(255) NOT NULL default '', `user2` varchar(255) NOT NULL default '', `user3` varchar(255) NOT NULL default '', `user4` varchar(255) NOT NULL default '', `url_prefix` tinyint(4) NOT NULL default '0', `pic_raw_ip` tinytext, `pic_hdr_ip` tinytext, `lasthit_ip` tinytext, `position` int(11) NOT NULL default '0', PRIMARY KEY (`pid`), KEY `owner_id` (`owner_id`), KEY `pic_hits` (`hits`), KEY `pic_rate` (`pic_rating`), KEY `aid_approved` (`aid`,`approved`), KEY `pic_aid` (`aid`), FULLTEXT KEY `search` (`title`,`caption`,`keywords`,`filename`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_pictures` -- INSERT INTO `cpg148_pictures` VALUES (1,1,'Mikes/','Apache_Longbow.jpg',68867,95349,800,600,0,'0000-00-00 00:00:00',1153068893,1,'crowsnest',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg148_pictures` VALUES (2,1,'Mikes/','f_16_falcon_8.jpg',47477,65494,800,600,0,'0000-00-00 00:00:00',1153068893,1,'crowsnest',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg148_pictures` VALUES (3,1,'Mikes/','chopper_hovering_1024.jpg',89223,113803,1024,768,0,'0000-00-00 00:00:00',1153068892,1,'crowsnest',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg148_pictures` VALUES (4,1,'Mikes/','helicopter_2.jpg',258500,287666,1280,1024,0,'0000-00-00 00:00:00',1153068894,1,'crowsnest',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg148_pictures` VALUES (16,2,'userpics/10002/','Dragonshard.jpg',343859,381106,1600,1200,0,'0000-00-00 00:00:00',1153332126,2,'1812lsd',0,0,'Dragonshard','','','YES',0,'','','','',0,'86.128.188.21','86.128.188.21',NULL,0); INSERT INTO `cpg148_pictures` VALUES (17,2,'userpics/10002/','wallpaper_dead_rising_01_1600.jpg',250315,283142,1600,1200,0,'0000-00-00 00:00:00',1153332142,2,'1812lsd',0,0,'Dead Rising','','','YES',0,'','','','',0,'86.128.188.21','86.128.188.21',NULL,0); INSERT INTO `cpg148_pictures` VALUES (7,1,'Mikes/','helicopter_5.jpg',325951,349253,1600,1200,0,'0000-00-00 00:00:00',1153068895,1,'crowsnest',0,0,'','','','YES',0,'','','','',0,'','',NULL,0); INSERT INTO `cpg148_pictures` VALUES (9,2,'userpics/10002/','Medal_of_Honor_Pacific_Assault_1.jpg',163060,182855,1600,1200,0,'0000-00-00 00:00:00',1153092884,2,'1812lsd',0,0,'Medal of Honor Pacific Assault','','','YES',0,'','','','',0,'81.132.25.179','81.132.25.179',NULL,0); INSERT INTO `cpg148_pictures` VALUES (13,2,'userpics/10002/','57405FKMJ.jpg',249071,266934,1200,600,0,'0000-00-00 00:00:00',1153332025,2,'1812lsd',0,0,'World @ Night','','','YES',0,'','','','',0,'86.128.188.21','86.128.188.21',NULL,0); INSERT INTO `cpg148_pictures` VALUES (14,2,'userpics/10002/','pushell.jpg',972464,993842,1616,1412,0,'0000-00-00 00:00:00',1153332052,2,'1812lsd',0,0,'Pushell','','','YES',0,'','','','',0,'86.128.188.21','86.128.188.21',NULL,0); INSERT INTO `cpg148_pictures` VALUES (15,2,'userpics/10002/','bestgalactic_sombrero_02.jpg',186894,201110,1600,1200,0,'0000-00-00 00:00:00',1153332091,2,'1812lsd',0,0,'The Sombrero Galaxy','','','YES',0,'','','','',0,'86.128.188.21','86.128.188.21',NULL,0); INSERT INTO `cpg148_pictures` VALUES (18,5,'userpics/10003/','INF_Charlie_Fireteam.jpg',113885,218388,970,755,0,'0000-00-00 00:00:00',1154133397,3,'koda',0,0,'INF Join Operations Charlie Team','Remember the old day's','JO','YES',0,'','','','',0,'84.12.167.238','84.12.167.238',NULL,0); INSERT INTO `cpg148_pictures` VALUES (19,5,'userpics/10003/','INF_Bravo_Fireteam.jpg',112707,216098,970,755,0,'0000-00-00 00:00:00',1154133447,3,'koda',0,0,'INF Joint Operations Bravo Team','Remeber the old day's','JO','YES',0,'','','','',0,'84.12.167.238','84.12.167.238',NULL,0); INSERT INTO `cpg148_pictures` VALUES (20,4,'userpics/10003/','Gattling_Gun1.jpg',53364,147786,640,365,0,'0000-00-00 00:00:00',1154133739,3,'koda',0,0,'Yeah Baby!','Gimmie Gimmie Gimmie','Guns','YES',0,'','','','',0,'84.12.167.238','84.12.167.238',NULL,0); INSERT INTO `cpg148_pictures` VALUES (21,4,'userpics/10003/','oil%20fire.jpg',264445,367798,1356,876,0,'0000-00-00 00:00:00',1154133754,3,'koda',0,0,'Oil Fire','','','YES',0,'','','','',0,'84.12.167.238','84.12.167.238',NULL,0); INSERT INTO `cpg148_pictures` VALUES (22,4,'userpics/10003/','arsio09.jpg',6974,20772,320,240,0,'0000-00-00 00:00:00',1155152425,3,'koda',0,0,'Thundercats HO!','','','YES',0,'','','','',0,'81.6.224.102','81.6.224.102',NULL,0); INSERT INTO `cpg148_pictures` VALUES (23,4,'userpics/10003/','8yfx6tjuh2cakshh9f.jpg',86271,230594,492,614,0,'0000-00-00 00:00:00',1155152439,3,'koda',0,0,'Hail to the King !','','','YES',0,'','','','',0,'81.6.224.102','81.6.224.102',NULL,0); INSERT INTO `cpg148_pictures` VALUES (24,4,'userpics/10003/','johnpeelrip11.jpg',24966,48502,272,300,0,'0000-00-00 00:00:00',1155152449,3,'koda',0,0,'How about ?','','','YES',0,'','','','',0,'81.6.224.102','81.6.224.102',NULL,0); INSERT INTO `cpg148_pictures` VALUES (25,4,'userpics/10003/','furrberry.jpg',30052,143368,469,531,0,'0000-00-00 00:00:00',1155152461,3,'koda',0,0,'Furrberry','','','YES',0,'','','','',0,'81.6.224.102','81.6.224.102',NULL,0); INSERT INTO `cpg148_pictures` VALUES (26,4,'userpics/10003/','jason.jpg',322460,416799,1969,1421,0,'0000-00-00 00:00:00',1155152823,3,'koda',0,0,'Mean','','','YES',0,'','','','',0,'81.6.224.102','81.6.224.102',NULL,0); -- -- Table structure for table `cpg148_plugins` -- CREATE TABLE `cpg148_plugins` ( `plugin_id` int(10) unsigned NOT NULL auto_increment, `name` varchar(64) NOT NULL default '', `path` varchar(128) NOT NULL default '', `priority` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`plugin_id`), UNIQUE KEY `name` (`name`), UNIQUE KEY `path` (`path`) ) TYPE=MyISAM COMMENT='Stores the plugins'; -- -- Dumping data for table `cpg148_plugins` -- -- -- Table structure for table `cpg148_sessions` -- CREATE TABLE `cpg148_sessions` ( `session_id` varchar(40) NOT NULL default '', `user_id` int(11) default '0', `time` int(11) default NULL, `remember` int(1) default '0', PRIMARY KEY (`session_id`) ) TYPE=MyISAM COMMENT='Used to store sessions'; -- -- Dumping data for table `cpg148_sessions` -- INSERT INTO `cpg148_sessions` VALUES ('7a8e83e84c8f296175d9323852d3da37',1,1193864111,1); -- -- Table structure for table `cpg148_temp_data` -- CREATE TABLE `cpg148_temp_data` ( `unique_ID` varchar(8) NOT NULL default '', `encoded_string` blob NOT NULL, `timestamp` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`unique_ID`) ) TYPE=MyISAM COMMENT='Holds temporary file data for multiple file uploads'; -- -- Dumping data for table `cpg148_temp_data` -- -- -- Table structure for table `cpg148_usergroups` -- CREATE TABLE `cpg148_usergroups` ( `group_id` int(11) NOT NULL auto_increment, `group_name` varchar(255) NOT NULL default '', `group_quota` int(11) NOT NULL default '0', `has_admin_access` tinyint(4) NOT NULL default '0', `can_rate_pictures` tinyint(4) NOT NULL default '0', `can_send_ecards` tinyint(4) NOT NULL default '0', `can_post_comments` tinyint(4) NOT NULL default '0', `can_upload_pictures` tinyint(4) NOT NULL default '0', `can_create_albums` tinyint(4) NOT NULL default '0', `pub_upl_need_approval` tinyint(4) NOT NULL default '1', `priv_upl_need_approval` tinyint(4) NOT NULL default '1', `upload_form_config` tinyint(4) NOT NULL default '3', `custom_user_upload` tinyint(4) NOT NULL default '0', `num_file_upload` tinyint(4) NOT NULL default '5', `num_URI_upload` tinyint(4) NOT NULL default '3', PRIMARY KEY (`group_id`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_usergroups` -- INSERT INTO `cpg148_usergroups` VALUES (1,'Administrators',0,1,1,1,1,1,1,0,0,3,0,6,4); INSERT INTO `cpg148_usergroups` VALUES (2,'Registered',1024,0,1,1,1,1,1,1,0,3,0,6,4); INSERT INTO `cpg148_usergroups` VALUES (3,'Guests',0,0,1,0,0,0,0,1,1,3,0,6,4); INSERT INTO `cpg148_usergroups` VALUES (4,'Banned',0,0,0,0,0,0,0,0,0,0,0,0,0); -- -- Table structure for table `cpg148_users` -- CREATE TABLE `cpg148_users` ( `user_id` int(11) NOT NULL auto_increment, `user_group` int(11) NOT NULL default '2', `user_active` enum('YES','NO') NOT NULL default 'NO', `user_name` varchar(25) NOT NULL default '', `user_password` varchar(40) NOT NULL default '', `user_lastvisit` datetime NOT NULL default '0000-00-00 00:00:00', `user_regdate` datetime NOT NULL default '0000-00-00 00:00:00', `user_group_list` varchar(255) NOT NULL default '', `user_email` varchar(255) NOT NULL default '', `user_profile1` varchar(255) NOT NULL default '', `user_profile2` varchar(255) NOT NULL default '', `user_profile3` varchar(255) NOT NULL default '', `user_profile4` varchar(255) NOT NULL default '', `user_profile5` varchar(255) NOT NULL default '', `user_profile6` text NOT NULL, `user_actkey` varchar(32) NOT NULL default '', PRIMARY KEY (`user_id`), UNIQUE KEY `user_name` (`user_name`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_users` -- INSERT INTO `cpg148_users` VALUES (1,1,'YES','crowsnest','7c6bfd191d920c8bb13ccdc21596d9df','2007-10-31 20:54:24','2006-07-16 16:41:46','','michael.cox7@ntlworld.com','','','','','','',''); INSERT INTO `cpg148_users` VALUES (2,1,'YES','1812lsd','878bc621a34b3fb45654b3c8af73c7af','2006-12-04 13:11:46','2006-07-16 23:22:12','','1812lsd@gmail.com','Shrewsbury [UK]','Digital Art, Gaming, Driving Fast, PC's & Shit!','http://www.iron-fists.eu','Tarmac Terrorist','','','b3ec37c7c2db69bdfe625334f160bae8'); INSERT INTO `cpg148_users` VALUES (3,1,'YES','koda','ab82b7a711aa27abcb2b25f5e126e488','2007-01-17 23:49:14','2006-07-29 00:23:26','','kodaichiman@hotmail.com','','','','','','','ccc75c74490877876c64de5449131c2b'); INSERT INTO `cpg148_users` VALUES (4,2,'YES','Deerslayer','51c46caa0cb9ab9a734d57f9de90fb7f','2006-08-16 21:15:33','2006-08-16 21:14:25','','rusty02@optonline.net','','','','','','','e28c19440fb64e29355e5221e908e27d'); INSERT INTO `cpg148_users` VALUES (5,2,'YES','robert','aca92b016cce93cfac998bda842d0f5a','2007-01-27 13:06:37','2007-01-27 01:57:54','','danielle4friends@yahoo.com','','','','','','','c096d1aa6c83ac469dad362096cff62b'); INSERT INTO `cpg148_users` VALUES (6,2,'YES','speedy','3b2285b348e95774cb556cb36e583106','2007-02-20 15:36:53','2007-02-20 15:34:24','','erhanelectronics@gmail.com','','','','','','','bc00407b4ba74e77504019b1176d83db'); INSERT INTO `cpg148_users` VALUES (7,2,'YES','prodycool','7ded4d93eabe6286d2accf70caa23d53','2007-10-31 19:14:31','2007-10-31 19:14:07','','vandrushko@gmail.com','','','','','','','d568820064abb4276eb7198bab8215e3'); -- -- Table structure for table `cpg148_vote_stats` -- CREATE TABLE `cpg148_vote_stats` ( `sid` int(11) NOT NULL auto_increment, `pid` varchar(100) NOT NULL default '', `rating` smallint(6) NOT NULL default '0', `ip` varchar(20) NOT NULL default '', `sdate` bigint(20) NOT NULL default '0', `referer` text NOT NULL, `browser` varchar(255) NOT NULL default '', `os` varchar(50) NOT NULL default '', PRIMARY KEY (`sid`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_vote_stats` -- -- -- Table structure for table `cpg148_votes` -- CREATE TABLE `cpg148_votes` ( `pic_id` mediumint(9) NOT NULL default '0', `user_md5_id` varchar(32) NOT NULL default '', `vote_time` int(11) NOT NULL default '0', PRIMARY KEY (`pic_id`,`user_md5_id`) ) TYPE=MyISAM; -- -- Dumping data for table `cpg148_votes` -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2009-03-21 7:57:34