"; $output .= "

Step 3: Setting up the PhotoPost database "; // Connecting, selecting database $link = mysql_connect("$host", "$mysql_user", "$mysql_password") or die('I cannot connect to the PhotoPost MySQL server. [host:$host][mysql_user:$mysql_user][mysql_password:$mysql_password]. Check your config-inc.php for the correct settings and rerun.'); //1090904400 mysql_select_db ("$database", $link); if ( mysql_errno() > 0 ) { $query = "CREATE DATABASE $database"; $dbsetup = mysql_query($query,$link); if ( !$dbsetup ) { instdie( "Could not connect to or create the PhotoPost database. Be sure your user has permissions to CREATE or create a blank table before hitting REFRESH or go back to Step 1 to check your database settings." ); exit; } mysql_select_db("$database", $link); } $query = array(); $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}admlog (id int(10) NOT NULL auto_increment, adminuser varchar(50) NOT NULL default '', description varchar(255) NOT NULL default '', datestamp int(20) NOT NULL default '0', ip varchar(35) NOT NULL default '', PRIMARY KEY (id)) TYPE=MyISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}favorites (id int(12) NOT NULL auto_increment, userid int(8) NOT NULL default '0', photo int(11) NOT NULL default '0', PRIMARY KEY (id), KEY parent (photo), KEY userid (userid)) TYPE=MyISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}laston (cat smallint(4) NOT NULL default '0', userid mediumint(9) NOT NULL default '0', laston int(11) unsigned default NULL, PRIMARY KEY (cat,userid)) TYPE=MyISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}exif (photoid INT(11) DEFAULT '0' NOT NULL, exifinfo TEXT)"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}categories (id int(12) NOT NULL auto_increment, catname varchar(255) NOT NULL default '', description varchar(255) default NULL, catorder mediumint(4) NOT NULL default '9999', thumbs varchar(4) NOT NULL default 'yes', parent int(5) NOT NULL default '0', header varchar(200) default NULL, footer varchar(200) default NULL, headtags varchar(200) default NULL, private varchar(5) NOT NULL default 'no', ugnoview VARCHAR(255) NULL, ugnoupload VARCHAR(255) NULL, ugnopost VARCHAR(255) NULL, ugnovote VARCHAR(255) NULL, ugnoanno VARCHAR(255) NULL, children TEXT default NULL, albums TEXT default NULL, subalbum INT(12) DEFAULT '0' NOT NULL, lastpost INT(11) UNSIGNED, lastphoto INT(11) UNSIGNED, photos INT(11) UNSIGNED default '0', posts INT(11) UNSIGNED default '0', password VARCHAR(24), cattype ENUM('c','a') NOT NULL DEFAULT 'c', theme VARCHAR(32) DEFAULT NULL, thumbtype INT(2) UNSIGNED DEFAULT '0', catdepth varchar(6) DEFAULT NULL, watermark varchar(250) NOT NULL default '', sortorder INT(2) DEFAULT '1' NOT NULL, extra1 VARCHAR(250), extra2 VARCHAR(250), extra3 VARCHAR(250), extra4 VARCHAR(250), extra5 VARCHAR(250), extra6 VARCHAR(250), thumbnail INT(15) DEFAULT '0' NOT NULL, maximages INT(12) default '0' NOT NULL, canzip varchar(3) DEFAULT 'no' NOT NULL, frames VARCHAR(32) default '0' NOT NULL, intro VARCHAR(3) default 'no' NOT NULL, introtitle VARCHAR(128) DEFAULT NULL, introcopy TEXT DEFAULT NULL, moderators TEXT DEFAULT NULL, numextra INT(3) default '0' NOT NULL, ratingtype INT(1) DEFAULT '0' NOT NULL, takevotes INT(1) DEFAULT '0' NOT NULL, votes tinyint(1) DEFAULT '0' NOT NULL, ismember SMALLINT(1) default '0' NOT NULL, PRIMARY KEY (id),KEY parent(parent)) TYPE=MyISAM"; $query[] = "INSERT INTO {$pp_db_prefix}categories (id,catname,description,catorder,thumbs,parent,children) VALUES (1,'Main','',2,'no',0,'2')"; $query[] = "INSERT INTO {$pp_db_prefix}categories (id,catname,description,catorder,thumbs,parent,children) VALUES (2,'A Category','Photos of a particular subject',1,'yes',1,'')"; $query[] = "INSERT INTO {$pp_db_prefix}categories (id,catname,description,catorder,thumbs,parent,children) VALUES (500,'Member Galleries','Individual user galleries - any photo category',1,'yes',0,'')"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}comments (id int(11) NOT NULL auto_increment, username VARCHAR(32) NOT NULL, userid int(11) NOT NULL default '0', date int(15) NOT NULL default '0', rating float(12,2) default NULL, comment text NOT NULL, photo int(11) NOT NULL default '0', cat int(11) NOT NULL default '0', approved INT(2) DEFAULT '0' NOT NULL, votes tinyint(1) NOT NULL default '0', ipaddress VARCHAR(32) DEFAULT '0', PRIMARY KEY (id),KEY photo(photo),KEY cat(cat)) TYPE=MyISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}photos (id int(10) NOT NULL auto_increment, user varchar(50) NOT NULL default '', userid int(8) NOT NULL default '0', cat int(11) NOT NULL default '0', storeid int(12) NOT NULL default '0', storecat int(12) NOT NULL default '0', date int(15) NOT NULL default '0', title varchar(75) NULL default '', description text NULL, keywords varchar(150) default NULL, bigimage varchar(100) NOT NULL default '', width smallint(6) default NULL, height smallint(4) default NULL, filesize int(10) default '0', views int(10) NOT NULL default '0', medwidth int(12) default '0', medheight smallint(6) default '0', medsize mediumint(9) default '0', approved tinyint(2) NOT NULL default '0', lastpost int(15) NOT NULL default '0', rating float(12,2) NOT NULL default '0', watermarked varchar(5) NOT NULL default 'no', allowprint varchar(5) NOT NULL default 'yes', extra1 VARCHAR(255), extra2 VARCHAR(255), extra3 VARCHAR(255), extra4 VARCHAR(255), extra5 VARCHAR(255), extra6 VARCHAR(255), disporder INT(5) DEFAULT '99999' NOT NULL, ipaddress VARCHAR(32) DEFAULT '0', numcom INT(8) DEFAULT '0' NOT NULL, lastposter VARCHAR(255), lastpid INT(8) DEFAULT '0' NOT NULL, allowrate INT(1) DEFAULT '1' NOT NULL, allowcoms INT(1) DEFAULT '1' NOT NULL, exifinfo BINARY(1) NOT NULL DEFAULT '0', tags INT(15) NOT NULL default '0', votes tinyint(1) NOT NULL default '0', ismature smallint(1) NOT NULL default '0', PRIMARY KEY (id),KEY userid(userid),KEY cat(cat),KEY bigimage(bigimage,cat)) TYPE=MyISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}settings (id int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', varname varchar(25) NOT NULL default '', description varchar(250) NOT NULL default '', setting varchar(250) NOT NULL default '', optionorder int(3) NOT NULL default '0', section int(3) NOT NULL default '0', PRIMARY KEY (id)) TYPE=MyISAM"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (1,'Title for your PhotoPost Application','galleryname','','My Photo Gallery',1,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (2,'Web site name','webname','','My Website',2,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (3,'Your Website URL (include http://)','domain','','http://www.domain.com',3,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (4,'Administrator Email Address','adminemail','','admin@domain.com',4,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (5,'URL to PhotoPost data directory','datadir','This is the web / virtual path to the data directory.','http://www.domain.com/photopost/data',5,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (6,'Full SERVER PATH to PhotoPost data directory','datafull','Full path to the image files directory.','/path/to/your/photopost/data',6,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (7,'URL to your forums main directory','vbulletin','This is the URL path to your forum installation.','http://www.domain.com/forum',1,13)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (8,'Full path to Header Include file','header','To include an HTML file as the header, enter the full path.','/path/to/php/header.htm',8,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (9,'Full path to the Footer include file','footer','To include an HTML file as the footer, enter the full path.','/path/to/php/footer.htm',9,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (10,'Full path to HTML file containing head tags','headtags','','/path/to/php/headtags.htm',10,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (11,'URL to PhotoPost PHP directory','maindir','','http://www.domain.com/photopost',11,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (13,'Default number of comments per page','defaultposts','','15',1,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (14,'Show Most Recent Additions on Index page?','mostrecent','','yes',4,9)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (15,'Number of columns for thumbnail pages','thumbcols','','4',1,4)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (18,'Thumbnail image max width and height in pixels','previewwidth','','100',1,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (19,'Max allowable image width in pixels','maxwidth','','2500',2,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (20,'Max allowable image height in pixels','maxheight','','2500',3,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (21,'Trigger medium graphic height and width','biggraphic','An uploaded larger than this will create a medium image of this size.','600',4,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (37,'cright','cright','','Photo Sharing Gallery by PhotoPost Copyright © 2009 All Enthusiast, Inc.',300,'0')"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (38,'Use email to notify users?','useemail','Users can be notified of photo approvals and deletions.','yes',1,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (41,'User Registration System','vbversion','','vb3',2,13)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (42,'Comments increment user post count?','cpostcount','','yes',1,7)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (43,'Photo uploads increment user post count?','ppostcount','','yes',5,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (44,'Save and display medium and large images?','bigsave','','yes',6,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (45,'Number of columns for most recent additions section?','recentcols','','4',1,9)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (46,'Number of photos to display in the most recent additions section?','recentnum','','12',2,9)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (47,'Allow users to send e-Cards?','enablecard','','no',2,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (48,'Require users to be registered to send an e-Card?','cardreg','','yes',3,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (49,'URL to PhotoPost images directory','idir','','http://www.domain.com/images',13,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (50,'Depth (number of levels) of categories to display.','catdepth','','1',2,3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (51,'Allow users to be notified of new posts via email?','usenotify','','yes',2,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (58,'Show post count and photo details for cats without thumbs?','catdetails','','no',3,3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (61,'Use COPPA for registration?','coppa','','yes',3,8)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (62,'Full Path to Registration Rules, or leave blank for default','rules','','',4,8)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (63,'Require verification of email address upon registration?','emailverify','','yes',5,8)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (64,'Your mailing address to receive COPPA permission forms?','address','','',6,8)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (65,'Full path to COPPA rules file, or leave blank for default?','copparules','','',7,8)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (66,'Allow new user registrations?','allowregs','','yes',8,8)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (67,'Allow users to upload photos?','allowup','','yes',3,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (68,'Allow users to post comments?','allowpost','','yes',4,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (69,'Show recent photos in default location (bottom)? (if no, will display at top)','recentdefault','','yes',3,9)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (70,'Your Commission Junction click-through URL','cjurl','','',6,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (71,'Notify Admin of New Uploads?','uploadnotify','','yes',10,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (72,'Show last photo thumbnail in member galleries listing?','membthumb','','yes',4,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (75,'PhotoPost main table width, percent or pixels.','tablewidth','','100%',5,9)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (76,'Require unique email addresses for user registration?','emailunique','','no',1,8)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (78,'Show Random images on Index page?','disrandom','','no',4,3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (79,'Show Most Popular images on Index page?','dispopular','','no',5,3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (80,'Do you want to allow ZIP uploads?','allowzip','','no',5,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (81,'PATH to UPLOADS directory?','zipuploaddir','','/path/to/uploads',16,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (82,'URL to UPLOADS directory?','zipuploadurl','','http://www.yoursite.com/uploads',17,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (83,'Forum database table prefix','dprefix','','',3,13)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (84,'PhotoPost Version','pversion','','6.22',53,0)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (86,'Enable watermarking of photos with overlay image?','annotate','','no',1,10)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (87,'If enabled, position of overlay watermark on images.','gravity','','SouthEast',2,10)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (88,'Quality setting for resizing/thumbnails?','imgquality','','70',7,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (89,'If photo upload width or height exceeds maximums, resize upload down to max dimensions?','resizeorig','','yes',8,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (90,'Full server path to watermark overlay image.','watermark','','',3,10)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (91,'Allow users to delete their own images?','userdel','','no',17,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (92,'Display Members Gallery on the main index page?','showmem','','yes',6,3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (93,'Require users to be registered to view images?','reqregister','','no',9,8)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (94,'Do you want Members Gallery to show all of a users photos?','memformat','','yes',4,4)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (95,'Display headers during SlideShows?','slidehead','','yes',24,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (97,'Maximum multimedia upload size in Kb','mmuploadsize','','16000',10,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (98,'Allow users to create Personal Albums?','allowpa','','yes',7,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (99,'Allow multimedia uploads?','allowmedia','','no',8,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (100,'Allow members to rate photos?','allowrate','','yes',20,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (101,'Display new comments/photos indicator on index?','displaynew','','no',7,3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (102,'Display and extract EXIF information from images?','showexif','','no',9,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (103,'Do you want to show the Members Gallery in List format?','memblist','','no',3,4)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (104,'Do you want to prompt for optional info during registration?','getoptional','','yes',2,8)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (105,'Do you want to be notified of all new comments?','notifyadmin','','no',9,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (114,'Display filesize?','dispfs','','yes',11,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (115,'Display views?','dispviews','','yes',12,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (116,'Display date?','dispdate','','yes',13,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (117,'Display dimensions?','dispdims','','yes',14,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (118,'Display keywords?','dispkeys','','yes',15,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (119,'Display description?','dispdesc','','yes',16,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (120,'Display ratings that have no comments attached?','dispempty','','yes',17,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (121,'Display title under photo?','disptitle','','yes',18,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (122,'Display quickratings under photos?','dispquick','','yes',19,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (123,'Do you want to allow people to download their favorites?','allowfavzip','','yes',11,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (124,'Display # of comments indicator under thumbnails?','dispcoms','','yes',2,4)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (125,'Display unapproved comments?','moderatecoms','','yes',21,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (126,'How many file upload prompts do you want?','maxfiles','','1',13,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (128,'Pixel size of borders for images/thumbnails','cellpadding','Thickness - set to 0 for no border','1',8,9)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (129,'Color for image borders','framecolor','Color of the frame around images/thumbs','#000000',7,9)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (130,'Select a theme for your website','theme','Choose from the available themes for your site layout','default',6,9)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (131,'Show UBBCode on Photo page?','showubb','','no',25,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (133,'Use Spider-friendly URLs?','spider','','no',15,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (134,'Use Anti-leeching code?', 'right-click', 'Use Right-Click Disable JavaScript to try and prevent right-clicking images', 'no', 23, 5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (135,'Display number of viewers on categories?', 'displayonline', 'Adds a query to main index, but shows numbers of viewers per category', 'yes', 8, 3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (136,'Allow users to choose additional categories during upload?', 'optcats', '', 'no', 14, 6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (137,'Enable slideshows?', 'slideshow', '', 'yes', 22, 5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (138,'Enable next and previous photo previews?', 'nextbox', '', 'yes', 26, 5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (139,'How many days after an eCard has been read do you want to keep it?', 'cardage', '', '7', 14, 2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (140,'Expire eCards after how many days (even if not read)?', 'cardexpire', '', '90', 13, 2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (141,'Acceptable multimedia file types?', 'acceptmm', 'Seperate file types by a comma and include the . (example: .mpg,.wma,.asf,.mp3)', '.mpeg,.mpg,.avi,.asf,.wmv,.mov', 11, 6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (142,'Acceptable image file types?', 'acceptimg', 'Seperate file types by a comma and include the . (example: .jpg,.gif,.png)', '.jpg,.jpeg,.png', 12, 6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (143,'Select a border for your thumbnails','thumbborder','Choose from the available borders for your thumbnails','thumbnail',9,9)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (144,'Sidebar Placement.?', 'sidebar', 'Set this to off for no sidebar or left or right depending on your tastes.', 'left', 1, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (145,'Sidebar Width', 'sidebar_width', ' Choose the width for your sidebar', '20%', 4, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (146,'UnderCategory PAL', 'undercat', ' Display Recent Comments and Who\'s Online Pals', 'no', 5, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (147,'Statistics PAL', 'statspal', ' Display Statistics Pal?', 'yes', 6, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (148,'Top Posters PAL', 'topposterspal', ' Display Top Posters Pal?', 'no', 7, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (149,'Random Image PAL', 'randompal', ' Display Random Image?', 'yes', 8, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (150,'Highest Ratings PAL', 'ratingspal', ' Display Highest Ratings?', 'no', 9, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (151,'Show Sidebar on Index Page?', 'sidebar_index', '', 'yes', 2, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (152,'Show Sidebar Globally?', 'sidebar_global', 'Showsidebar on showphoto,showmembers and showgallery pages?', 'yes', 3, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (153,'Default theme setting (UBBThreads users only)', 'threads', 'Threads Users: We need to know what the site default theme setting is.', 'infopop', 5, 13)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (154,'Show signatures?', 'showsigs', 'When available, display signatures?', 'yes', 27, 5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (155,'Show Avatars', 'showavatar', 'When available, show avatars?', 'yes', 28, 5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (156,'Show Category Avatars?', 'indexavatars', 'Do you want to display the Index Avatars?', 'yes', 9, 3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (157,'Display Custom PAL #1', 'custom1pal', ' If you modified the custom1pal.tmpl and want to include it set to yes', 'no', 10, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (158,'Display Custom PAL #2', 'custom2pal', ' If you modified the custom2pal.tmpl and want to include it set to yes', 'no', 11, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (159,'Display Custom PAL #3', 'custom3pal', ' If you modified the custom3pal.tmpl and want to include it set to yes', 'no', 12, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (160,'Number of Top Posters to display', 'numtoppal', '', '5', 13, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (161,'Number of Last Comments to display', 'numcompal', '', '5', 14, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (162,'Number of Highest Rated Photos to display', 'mostpoppal', '', '5', 15, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (163,'Use Integrated forum stylesheets?', 'forumstyle', 'If you use a forum like vB3 or Threads and want to use the intergated stylesheet option, choose Yes', 'no', 4, 13)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (164,'Use Whos Online PAL?', 'onlinepal', '', 'yes', 10, 11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 12)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (167,'Enable ZLIB page compression', 'compression', 'Set to on if you want to enable Zlib page compression (and it is supported)', '0', 23, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (168,'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', 'dow month dd, yyyy', 24, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (169,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '0', 25, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (170,'Enable IP Cache Timeout', 'ipcache', 'This variable is used to track IP addresses and userids for voting and viewing purposes. This is set in HOURS. 0 disables this setting', '0', 26, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (171,'PhotoPost Cookie Path', 'cookie_path', 'This should be set to match the path/domain for your cookies. Setting to / enables entire site.', '/', 1, 12)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (172,'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', '', 2, 12)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (173,'PhotoPost Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', '', 3, 12)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (174,'Debug Setting', 'debug', 'How do you want PhotoPost to handle errors?', '0', 27, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (175,'Enable on-the-fly image protection', 'onthefly', 'This option uses the watermark.php script to serve images', 'no', 29, 5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (176,'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '0', 28, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (177,'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '', 29, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (178,'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '/usr/bin/mysqldump', 30, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (179,'Path to jpegtran (if used)', 'jpegtran', 'If you would like to clean any JPG image uploaded before being processed; enter the path to your jpegtran executable.', '/usr/bin/jpegtran', 18, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (180,'Path to jhead (if used)', 'jhead_command', 'This only needs to be set if you are extracting EXIF information from images. Full server path.', '/usr/bin/jhead', 19, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (181,'Gallery Open?', 'ppboards', '', 'open', 20, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (182,'Message displayed when closed', 'closedmsg', '', 'The galleries are temporarily down for maintainence.', 21, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (183,'Show Personal Albums Index link under Members Gallery?', 'showalbum', 'Adds a text link to the Albums index into the Members Gallery description', 'yes', 10, 3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (184,'Allow users to move their own images?','usermove','','no',16,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (185,'Use embedded multimedia?','embededmm', '', 'yes', 5, 5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (186,'Degrees to rotate portrait thumbnails? (set to 0 for no rotation)','rotatep', 'For users of ImageMagick only', '0', 15, 6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (187,'Degrees to rotate landscape thumbnails? (set to 0 for no rotation)','rotatel', 'For users of ImageMagick only', '0', 16, 6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (188,'If rotating, long side for mini thumbnail?','minil', 'If rotating your thumbnails, we need to create a mini thumbnail', '50', 17, 6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (189,'If rotating, short side for mini thumbnail?','minis', 'If rotating your thumbnails, we need to create a mini thumbnail', '27', 18, 6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (190,'Allow downloads from URLs?','downurl', '', 'yes', 19, 6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (192,'Number of top level categories to show on index page?','indexcats', 'Set to 0 to show all top level categories on one page', '0', 11, 3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (193,'Use popup window for BIG images?','bigpopup', 'If you want BIG photos to appear using a popup window, set to yes', 'no', 31, 5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (194,'Do you want to use the forum-style layout?','pplayout', 'Yes is the default setting, No uses the thumbnail gallery layout', 'yes', 18, 3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (195,'Do you want to enable the Announcement box?','news', '', 'no', 12, 3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (196,'Title for the Announcement box?','newstitle', '', 'News', 13, 3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (197,'Contents of the Announcement box?','newscopy', 'This block can contain HTML code (200 character limit)', '', 14, 3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (198,'Use 24 hour time format?','timeformat', 'You can elect to have time displayed as HH:MMam or using the 24 hour clock', 'no', 32, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (199,'Do you want moderators to have global rights?','modprivs', 'Set this to NO if you want to assign moderators to specific categories', 'yes', 18, 2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (200,'Display Moderators as part of the category description?','dispmods', 'Set this to YES if you want the moderators listed on the index page under a category', 'no', 15, 3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (201,'Use photo view caching to reduce view update queries on high load sites?','viewcache', 'Set this to YES if you want to enable the view caching code which caches photo view updates', 'no', 33, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (202,'Min allowable image width in pixels','minwidth','','0',21,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (203,'Min allowable image height in pixels','minheight','','0',22,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (204,'Mobile Phone Integration: EMail address for images','mobemail','EMail address users should send their images to','',23,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (205,'Show Last Comments column on Index?','showcoms','','yes',16,3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (206,'Show Last Photo column on Index','showlast','','yes',17,3)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (207,'Original Image storage directory URL','origdir','Typically this path matches your DATA directory URL, unless you want to store your original images seperatly from your thumbnails/medium images.','http://www.domain.com/photopost/data',34,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (208,'Orignial Image storage directory server path','origfull','Typically this path matches your DATA directory server path, unless you want to store your original images seperatly from your thumbnails/medium images.','/path/to/your/photopost/data',35,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (209,'When using on-the-fly image generation, do you want to overlay the watermark image?','overwater','You can use this feature for on-the-fly watermarks in combination with the on-the-fly image generation.','no',30,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (210,'Default location of the photo previews?','filmstrip','Determines the location of the film-strip previews on the showphoto page.','top',26,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (211,'Minutes to cache index page data for featured photos, statistics and PALs?','cachetimeout','Number of minutes to cache information. Default is 10 minutes, 0 means no caching.','10',36,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (212,'Show Calendar PAL?','calpal','Do you want to display the calendar pal, yes or no.','yes',16,11)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (213,'Show html code to display photos?','showhtml','Do you want to show the img src html tag for a photo?','no',6,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (214,'Show direct links to photos?','showdirect','Do you want to display the page link to a photo?','no',7,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (215,'Load limit for server?','loadlimit','If running *nix and you want to disable your forums when load goes over a certain limit; place the high limit here.','0',35,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (216,'Default number of thumbnail rows?','thumbrows','How many rows of thumbnails do you want to display by default on this page?','3',6,4)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (217,'Use category cache?','catcache','On some larger sites, using the category cache can actually reduce performance.','yes',36,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (218,'Display Featured Photos on this page?','features','On larger sites this option can slow down the showgallery page. Turn off to speed up this page.','yes',8,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (220,'Number of seconds a user is allowed to edit a comment?','comtimeout','0 to disable. 86400 is one day.','0',2,7)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (221,'Require users to be registered to use search?','searchreg','','no',1,14)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (222,'Maximium number of search results to return?','searchmax','On larger sites, the less the better.','500',2,14)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (223,'Number of seconds between searches?','searchto','The number of seconds a user must wait between searches.','30',3,14)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (224,'Number of days to hold search results?','searchhold','','7',5,14)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (225,'Display who is viewing a category?','catonline','This option adds a query to the Show Gallery page.','yes',5,4)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (226,'Use lightbox integration?','lightbox','','no',32,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (227,'Width to trigger lightbox integration (if enabled)?','lbwidth','','900',33,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (228,'Height to trigger lightbox integration (if enabled)?','lbheight','','600',34,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (229,'Use mature content filter?','mature','Prevents photos marked from mature being shown without user electing to view them.','no',18,2)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (230,'Use uniform thumbnail feature?','uniform','','no',26,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (231,'Uniform thumbnail height?','uniheight','Can only be used when using IM for imaging.','78',27,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (232,'Uniform thumbnail width','uniwidth','Can only be used when using IM for imaging.','120',28,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (233,'Use Messaging System for PhotoPost alerts/notices?','usemsg','','yes',38,1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (234,'Use CAPTCHA images when verifying unregistered users?','usecaptcha','Requires GD2 support!','no',4,8)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (235,'Enable PhotoPost Message Board?','usebb','Used only for internal PhotoPost systems.','no',5,13)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (236,'Enable Email a Friend feature?','findfriend','','yes',7,4)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (237,'Enable Auto Rotate if EXIF info is available?','autorotate','','yes',23,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (238,'Use images for user menu options on showphoto?','imgmenu','','yes',35,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (239,'Enable zoom javascript?','zoom','Enable the TJP zoom javascript feature on showphoto?','no',36,5)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (240,'Enable Flash uploader?','flashupload','Selects flash uploader if user is registered and flash is installed. As a 3rd party plug-in, this option is not supported by PhotoPost support.','no',29,6)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (241, 'Which Payment Processor do you want to use?', 'processor', 'currently paypal and authorize.net are supported', 'paypal', 3, 15)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (242, 'Authorize.Net Login ID', 'authorizeid', 'Your Login ID for Authorize.Net.', '', 4, 15)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (243, 'Authorize.Net Transaction Key', 'authorizekey', 'The transaction key as specified within the Security section of the Authorize.Net merchant account system.', '', 5, 15)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (244, 'MoneyBookers Email', 'mbemail', 'Please enter your MoneyBookers email, all references to the subscription service will use this email.', '', 6, 15)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (245, 'Moneybookers Secret Word', 'mbsecret', 'Secret Word in lowercase as typed into your Moneybookers Profile.', '', 7, 15)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (246, 'WorldPay Installation ID', 'wp_instid', 'The Install ID that is generated by the WorldPay CMS for the subscription callback. You must set your callback url to point to your payment.php script', '', 8, 15)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (247, 'WorldPay Callback Password', 'wp_password', 'The password entered during the creation of the subscription callback within the WorldPay CMS.', '', 9, 15)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (248, 'Default Currency', 'currency', '', 'USD', 19, 1)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (249,'Your PayPal email address for your account?', 'paypalemail', 'Required to receive payments!', '', 12, 15)"; $query[] = "INSERT INTO {$pp_db_prefix}settings VALUES (250,'PayPal currency code?', 'paypalcur', 'USD for US Dollar', 'USD', 13, 15)"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}sort (sortid int(15) NOT NULL auto_increment, name varchar(35) NOT NULL default '', code varchar(75) NOT NULL default '', PRIMARY KEY (sortid)) TYPE=MyISAM"; $query[] = "INSERT INTO {$pp_db_prefix}sort VALUES (2,'Latest','ORDER BY disporder,date DESC')"; $query[] = "INSERT INTO {$pp_db_prefix}sort VALUES (3,'Most Views','ORDER BY disporder,views DESC')"; $query[] = "INSERT INTO {$pp_db_prefix}sort VALUES (1,'Most Active','ORDER BY disporder,lastpost DESC')"; $query[] = "INSERT INTO {$pp_db_prefix}sort VALUES (4,'Most Popular','ORDER BY disporder,rating DESC, views DESC')"; $query[] = "INSERT INTO {$pp_db_prefix}sort VALUES (6,'Random', 'ORDER BY disporder,RAND()')"; $query[] = "INSERT INTO {$pp_db_prefix}sort VALUES (5,'Least Popular', 'ORDER BY disporder,rating,views')"; $query[] = "INSERT INTO {$pp_db_prefix}sort VALUES (7,'Image Name', 'ORDER BY disporder,bigimage')"; $query[] = "INSERT INTO {$pp_db_prefix}sort VALUES (8,'Title', 'ORDER BY disporder,title')"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}admingroups (id int(3) NOT NULL auto_increment, name varchar(35) NOT NULL default '', PRIMARY KEY (id)) TYPE=MyISAM"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (1,'Global Options')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (2,'Admin Options')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (3,'Index Options')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (4,'Show Gallery Options')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (5,'Show Photo Options')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (6,'Upload Photo Options')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (7,'Comments Options')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (8,'Registration Options')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (9,'Layout Options')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (10,'Watermark Options')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (11,'Sidebar Settings')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (12,'Cookie Settings')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (13,'Forum Settings')"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (14,'Search Options');"; $query[] = "INSERT INTO {$pp_db_prefix}admingroups VALUES (15,'Payment Options');"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}sortmemb (sortid int(15) NOT NULL auto_increment, name varchar(35) NOT NULL default '', code varchar(75) NOT NULL default '', PRIMARY KEY (sortid)) TYPE=MyISAM"; $query[] = "INSERT INTO {$pp_db_prefix}sortmemb VALUES (2,'Date (newest first)','ORDER BY maxdate DESC')"; $query[] = "INSERT INTO {$pp_db_prefix}sortmemb VALUES (3,'Views (high to low)','ORDER BY tviews DESC')"; $query[] = "INSERT INTO {$pp_db_prefix}sortmemb VALUES (1,'Most Active','ORDER BY maxlast DESC')"; $query[] = "INSERT INTO {$pp_db_prefix}sortmemb VALUES (4,'Alphabetical Order','ORDER BY user ASC')"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}ecards (id int(25) NOT NULL auto_increment, fromname varchar(100) NOT NULL default '', toname varchar(100) NOT NULL default '', subject varchar(150) NOT NULL default '', message text NOT NULL, photoid int(25) NOT NULL default '0', date int(25) NOT NULL default '0', backcolor VARCHAR(12) DEFAULT '#696969' NOT NULL, bordcolor VARCHAR(12) DEFAULT '#000000' NOT NULL, fontcolor VARCHAR(12) DEFAULT '#FFFFFF' NOT NULL, pickfont VARCHAR(32) DEFAULT 'arial' NOT NULL, layout VARCHAR(24) DEFAULT 'tobottom' NOT NULL, returnr INT(15) DEFAULT '0' NOT NULL, readdate INT(15) DEFAULT '0' NOT NULL, PRIMARY KEY (id)) TYPE=MyISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}notify (id int(15) NOT NULL auto_increment, userid int(25) NOT NULL default '0', photo int(25) NOT NULL default '0', type INT(2) DEFAULT '0' NOT NULL, PRIMARY KEY (id),KEY photo(photo)) TYPE=MyISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}users (userid int(25) NOT NULL auto_increment, usergroupid int(5) NOT NULL default '0', username varchar(30) NOT NULL default '', realname varchar(80) default NULL, password varchar(50) NOT NULL default '', email varchar(75) NOT NULL default '', homepage varchar(100) default NULL, icq varchar(50) default NULL, aim varchar(30) default NULL, yahoo varchar(30) default NULL, joindate int(25) NOT NULL default '0', posts int(20) NOT NULL default '0', birthday date NOT NULL default '0000-00-00', ipaddress varchar(18) default NULL, location varchar(100) default NULL, interests MEDIUMTEXT NULL DEFAULT NULL, occupation varchar(250) default NULL, bio MEDIUMTEXT NULL DEFAULT NULL, site VARCHAR(30) default NULL, offset SMALLINT(2) DEFAULT '0' NOT NULL, lastphoto INT( 12 ) NOT NULL DEFAULT '0', lastdate INT( 15 ) NOT NULL DEFAULT '0', views int(10) NOT NULL default '0', cellphone VARCHAR(255) DEFAULT NULL, title varchar(30) default NULL, signature varchar(250) default NULL, avatar varchar(120) default NULL, mature tinyint(1) NOT NULL default '1', invites int(6) NOT NULL default '0', accepts int(6) NOT NULL default '0', laston int(15) NOT NULL default '0', paypal VARCHAR(75) NOT NULL DEFAULT '', PRIMARY KEY (userid)) TYPE=MyISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}ipcache (id int(10) NOT NULL auto_increment, userid INT(25) NOT NULL, ipaddr VARCHAR(75) NOT NULL, date INT(11) UNSIGNED, type VARCHAR(4) NOT NULL, photo INT(10) NOT NULL, PRIMARY KEY (id)) TYPE=MyISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}iponline (userid VARCHAR(128) NOT NULL default '', ipaddr VARCHAR(75) NOT NULL default '', date INT(11) UNSIGNED, what VARCHAR(64) NOT NULL default '', item VARCHAR(16) NOT NULL default '', uid INT(12) NOT NULL default '0', referer VARCHAR(255) default NULL, agent VARCHAR(100) default NULL, PRIMARY KEY (ipaddr)) TYPE=MyISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}photoviews (photoid mediumint(9) NOT NULL default '0') TYPE=HEAP"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}extrafields (id INT(12) NOT NULL AUTO_INCREMENT, cat INT(12), fieldname VARCHAR(255), fieldtype VARCHAR(2), fieldoptions TEXT, PRIMARY KEY (id) )"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}photoextras (id INT(12) NOT NULL AUTO_INCREMENT, photo INT(12), extraid INT(12), selection TEXT, PRIMARY KEY (id) )"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}cache (id tinyint(1) NOT NULL default '1', timestamp int(15) NOT NULL default '0', statscache mediumtext, recentcache mediumtext, popularcache mediumtext, randomcache mediumtext, calcache mediumtext, catcache mediumtext, catprops mediumtext, PRIMARY KEY (id), KEY id (id)) TYPE=MyISAM"; $query[] = "INSERT INTO {$pp_db_prefix}cache VALUES (1,0,null,null,null,null,null,null,null)"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}searchids ( searchid INT( 12 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , userid INT( 12 ) NOT NULL DEFAULT '0', searchtype VARCHAR( 1 ) NULL , searchterms VARCHAR( 250 ) NULL , searchdate VARCHAR( 5 ) NULL , cats MEDIUMTEXT NULL , name VARCHAR( 64 ) NULL , preview SMALLINT( 1 ) NOT NULL DEFAULT '1', idlist MEDIUMTEXT NULL , numresults INT( 5 ) NOT NULL DEFAULT '0', ipaddress VARCHAR( 15 ) NULL , searchtime FLOAT( 6, 6 ) NOT NULL DEFAULT '0', date INT( 15 ) NOT NULL DEFAULT '0' )"; $query[] = "CREATE TABLE {$pp_db_prefix}messages ( msgid int( 12 ) NOT NULL AUTO_INCREMENT , userid int( 12 ) NOT NULL default '0', fromuserid INT( 12 ) DEFAULT '0' NOT NULL, datestamp int( 15 ) NOT NULL default '0', message mediumtext, status smallint( 1 ) NOT NULL default '0', type enum( 'c', 'f', 'i', 'm', 'r' ) default NULL , photo int( 12 ) NOT NULL default '0', PRIMARY KEY ( msgid ) ) TYPE=MYISAM"; $query[] = "CREATE TABLE {$pp_db_prefix}captcha ( id int( 12 ) NOT NULL auto_increment , code varchar( 12 ) default NULL , PRIMARY KEY ( id ) ) TYPE=MyISAM"; $query[] = "CREATE TABLE {$pp_db_prefix}buddies ( id int( 12 ) NOT NULL auto_increment , userid int( 12 ) NOT NULL default '0', buddy int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , KEY userid ( userid ) ) TYPE=MyISAM"; $query[] = "CREATE TABLE {$pp_db_prefix}board ( msgid int(12) NOT NULL auto_increment, replyto int(12) NOT NULL default '0', userid int(12) NOT NULL default '0', category int(4) NOT NULL default '0', date int(15) NOT NULL default '0', subject varchar(250) default NULL, message mediumtext, replies int(6) NOT NULL default '0', views int(7) NOT NULL default '0', lastmsg int(12) NOT NULL default '0', lastdate int(15) NOT NULL default '0', lastuser int(12) NOT NULL default '0', lastusername varchar(32) default NULL, ipaddr varchar(15) default NULL, updated int(16) NOT NULL default '0', updateuser int(12) NOT NULL default '0', PRIMARY KEY (msgid), KEY date (date) ) TYPE=MyISAM"; $query[] = "CREATE TABLE {$pp_db_prefix}invites ( id int( 12 ) NOT NULL AUTO_INCREMENT , code varchar( 32 ) default NULL , email varchar( 32 ) default NULL , name varchar( 64 ) default NULL , message mediumtext, datestamp int( 16 ) NOT NULL default '0', referer int( 10 ) NOT NULL default '0', status smallint( 1 ) NOT NULL default '0', uid int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , UNIQUE KEY code ( code ) ) TYPE=MYISAM"; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}subscriptions (id int(10) NOT NULL auto_increment, name VARCHAR(75) NOT NULL default '', description TEXT NULL DEFAULT NULL, gid INT(4) NOT NULL default '0', duration VARCHAR(75) NOT NULL default '', days INT(4) NOT NULL default '0', price float(12,2) NOT NULL default '0.00', isactive varchar(3) NOT NULL default 'yes', PRIMARY KEY (id)) TYPE=MyISAM "; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}paid_subscriptions (id int(10) NOT NULL auto_increment, userid VARCHAR(75) NOT NULL default '', start VARCHAR(250) NOT NULL default '', end VARCHAR(75) NOT NULL default '', days INT(4) NOT NULL default '0', subid INT(5) NOT NULL default '0', gid INT(4) NOT NULL default '0', oldid INT(4) NOT NULL default '0', PRIMARY KEY (id)) TYPE=MyISAM "; $query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}currency (id int(12) NOT NULL auto_increment, name VARCHAR( 25 ) NOT NULL , code VARCHAR( 5 ) NOT NULL , symbol VARCHAR(25) NOT NULL default '', type INT(3) NOT NULL default '0', PRIMARY KEY (id)) TYPE=MyISAM "; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (1,'US Dollars','USD','$', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (2,'Britain Pounds','GBP','£', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (3,'Canadian Dollars','CAD','$', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (4,'Australian Dollars','AUD','$', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (5,'Brazil, Reais','BRL','R$', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (7,'Costa Rica, Colón','CRC','₡', '2')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (8,'Denmark Kroner','DKK','kr', '2')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (9,'Euro','EUR','€', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (10,'Lira','ITL','₤', '1')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (11,'Franc','FRF','₣', '1')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (12,'Korea (South), Won','KRW','￦', '3')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (13,'Japan, Yen','JPY','¥', '3')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (14,'South Africa, Rand','ZAR','R', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (15,'Indian, Rupees','INR','₨', '2')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (16,'Thailand, Baht','THB','฿', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (17,'Laos, Kips','LAK','₭', '3')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (18,'China, Yuan','CNY','元', '3')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (19,'Hong Kong, Dollars','HKD','HK$', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (20,'Iran Rials','IRR','﷼', '2')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (21,'Israel, New Shekels','ILS','₪', '2')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (22,'Mongolia, Tugriks','MNT','₮', '2')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (23,'Netherlands Antilles, Guilders/Florins','ANG','ƒ', '2')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (24,'Nigeria, Nairas','NGN','₦', '2')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (25,'Russia, Rubles','RUB','руб', '2')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (26,'Taiwan, New Dollars','TWD','NT$', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (27,'Vietnam, Dong','VND','₫', '2')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (28,'Pesos','COP','₱', '0')"; $query[] = "INSERT INTO {$pp_db_prefix}currency VALUES (29,'Signapore Dollars','SGD','SGD$', '0')"; $query[] = "CREATE TABLE {$pp_db_prefix}payments (id int(12) NOT NULL auto_increment, amount float(12,2) NOT NULL default '0', pmt_key VARCHAR(32) NOT NULL default '', user_id INT(5) NOT NULL default '0', sub_id INT(5) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM "; print $output; $errorrep = 0; for ( $x=0; $x < count($query); $x++) { $iquery = $query[$x]; $setup = mysql_query($iquery, $link); if ( !$setup ) { print "Step 3: MySQL error reported: [$iquery] Result: " . mysql_error() . " Database: $database "; $errorrep = 1; } } $output = " Database setup completed, but you aren't finished quite yet. "; if ( $errorrep == 1 ) { $output .= " There were errors during the installation of the database. Review your errors before continuing as the errors may prevent PhotoPost from functioning properly. "; } $output .= "The final installation step will help you begin configuring PhotoPost for your server. Now you must choose whether you intend to use PhotoPost's Internal registration system, or a third party's, to register yourself and your users to grant access to upload photos and post comments, If you do not own a third party forum program listed below, or you do not wish PhotoPost to work with those applications, then choose: PhotoPost Internal User Registration If you want PhotoPost to use vBulletin, UBBThreads, DCForum, InvisionBoard, IkonBoard or phpbb2/Nuke/PostNuke existing user database and registration system, choose: External User Registration (vBulletin, UBBT6, DCForums, IB, Ikon, SMF, phpBB2 or Nuke)

"; print $output; exit; } function ci_verify($dataToSend) { $port=80; $host="www.photopost.com"; $path="/confirm.pl"; if(!($fp = @fsockopen($host, $port))) return "Error: Error opening network socket.\n"; socket_set_blocking($fp, TRUE); fwrite($fp, "POST $path HTTP/1.0\r\n"); fwrite($fp, "Host: $host\r\n"); fwrite($fp, "Content-type: application/x-www-form-urlencoded\r\n"); fwrite($fp, "Content-length: " . strlen($dataToSend) . "\r\n\r\n"); fwrite($fp, $dataToSend); for($result = ""; !feof($fp); $result .= fread($fp, 1000000)); fclose($fp); return $result; } if ($step == "3") { $passonly = 0; if ( !isset($regtype) ) { $link = mysql_connect("$host", "$mysql_user", "$mysql_password") or die('I cannot connect to the PhotoPost MySQL server. [host:$host][mysql_user:$mysql_user][mysql_password:$mysql_password]. Check your config-inc.php for the correct settings and rerun.'); //1090904400 mysql_select_db ("$database", $link); $query = "SELECT setting FROM {$pp_db_prefix}settings WHERE id='41'"; $resulta = mysql_query($query, $link)or die( "Error with PhotoPost database: [$link]: $query
Error: " . mysql_error() ); list( $isetting ) = mysql_fetch_row($resulta); @mysql_free_result( $resulta ); if ( $isetting != "photopost" ) { instdie( "You can only change the Administrator password for Internal registration systems." ); exit; } $query = "SELECT setting FROM {$pp_db_prefix}settings WHERE id='6'"; $resulta = mysql_query($query, $link)or die( "Error with PhotoPost database: [$link]: $query
Error: " . mysql_error() ); list( $id6 ) = mysql_fetch_row($resulta); @mysql_free_result( $resulta ); $regtype="internal"; $passonly = 1; } $output = "