Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 10:31 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `photopost_settings` PROCEDURE ANALYSE();
Rows: 7
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.photopost_settings.id | 1 | 220 | 1 | 3 | 0 | 0 | 122.0286 | 62.2846 | TINYINT(3) UNSIGNED NOT NULL |
| puroparty.photopost_settings.title | Acceptable image file types? | Your Website URL (include http://) | 6 | 87 | 0 | 0 | 35.3714 | NULL | ENUM('Acceptable image file types?','Acceptable multimedia file types?','Administrator Email Address','Allow downloads from URLs?','Allow members to rate photos?','Allow multimedia uploads?','Allow new user registrations?','Allow users to be notified of new posts via email?','Allow users to choose additional categories during upload?','Allow users to create Personal Albums?','Allow users to delete their own images?','Allow users to move their own images?','Allow users to post comments?','Allow users to send e-Cards?','Allow users to upload photos?','BotBuster Integration','Color for image borders','Comments increment user post count?','Contents of the Announcement box?','cright','Date format','Debug Setting','Default location of the photo previews?','Default number of comments per page','Default number of thumbnail rows?','Default theme setting (UBBThreads users only)','Degrees to rotate landscape thumbnails? (set to 0 for no rotation)','Degrees to rotate portrait thumbnails? (set to 0 for no rotation)','Depth (number of levels) of categories to display.','Directory for backups?','Display # of comments indicator under thumbnails?','Display and extract EXIF information from images?','Display Custom PAL #1','Display Custom PAL #2','Display Custom PAL #3','Display date?','Display description?','Display dimensions?','Display Featured Photos on this page?','Display filesize?','Display headers during SlideShows?','Display keywords?','Display Members Gallery on the main index page?','Display Moderators as part of the category description?','Display new comments/photos indicator on index?','Display number of viewers on categories?','Display quickratings under photos?','Display ratings that have no comments attached?','Display title under photo?','Display unapproved comments?','Display views?','Do you want Members Gallery to show all of a users photos?','Do you want moderators to have global rights?','Do you want to allow people to download their favorites?','Do you want to allow ZIP uploads?','Do you want to be notified of all new comments?','Do you want to enable the Announcement box?','Do you want to prompt for optional info during registration?','Do you want to show the Members Gallery in List format?','Do you want to use the forum-style layout?','Enable IP Cache Timeout','Enable next and previous photo previews?','Enable on-the-fly image protection','Enable slideshows?','Enable watermarking of photos with overlay image?','Enable ZLIB page compression','Expire eCards after how many days (even if not read)?','Forum Cookie Prefix','Forum database table prefix','Full path to COPPA rules file, or leave blank for default?','Full path to Header Include file','Full path to HTML file containing head tags','Full Path to Registration Rules, or leave blank for default','Full path to the Footer include file','Full SERVER PATH to PhotoPost data directory','Full server path to watermark overlay image.','Gallery Open?','GMT Offset','Highest Ratings PAL','How many days after an eCard has been read do you want to keep it?','How many file upload prompts do you want?','If enabled, position of overlay watermark on images.','If photo upload width or height exceeds maximums, resize upload down to max dimensions?','If rotating, long side for mini thumbnail?','If rotating, short side for mini thumbnail?','Imaging Integration (IM or GD)','Load limit for server?','Max allowable image height in pixels','Max allowable image width in pixels','Maximum multimedia upload size in Kb','Message displayed when closed','Min allowable image height in pixels','Min allowable image width in pixels','Minutes to cache index page data for featured photos, statistics and PALs?','Mobile Phone Integration: EMail address for images','Notify Admin of New Uploads?','Number of columns for most recent additions section?','Number of columns for thumbnail pages','Number of Highest Rated Photos to display','Number of Last Comments to display','Number of minutes a user is allowed to edit a comment?','Number of photos to display in the most recent additions section?','Number of top level categories to show on index page?','Number of Top Posters to display','Original Image storage directory URL','Orignial Image storage directory server path','Path to jhead (if used)','Path to jpegtran (if used)','Path to mysqldump','PATH to UPLOADS directory?','Photo uploads increment user post count?','PhotoPost Cookie Domain','PhotoPost Cookie Path','PhotoPost main table width, percent or pixels.','PhotoPost Version','Pixel size of borders for images/thumbnails','Quality setting for resizing/thumbnails?','Random Image PAL','Require unique email addresses for user registration?','Require users to be registered to send an e-Card?','Require users to be registered to view images?','Require verification of email address upon registration?','Save and display medium and large images?','Select a border for your thumbnails','Select a theme for your website','Show Avatars','Show Calendar PAL?','Show Category Avatars?','Show direct links to photos?','Show html code to display photos?','Show Last Comments column on Index?','Show Last Photo column on Index','Show last photo thumbnail in member galleries listing?','Show Most Popular images on Index page?','Show Most Recent Additions on Index page?','Show Personal Albums Index link under Members Gallery?','Show post count and photo details for cats without thumbs?','Show Random images on Index page?','Show recent photos in default location (bottom)? (if no, will display at top)','Show Sidebar Globally?','Show Sidebar on Index Page?','Show signatures?','Show UBBCode on Photo page?','Sidebar Placement.?','Sidebar Width','Statistics PAL','Thumbnail image max width and height in pixels','Title for the Announcement box?','Title for your PhotoPost Application','Top Posters PAL','Trigger medium graphic height and width','UnderCategory PAL','URL to PhotoPost data directory','URL to PhotoPost images directory','URL to PhotoPost PHP directory','URL to UPLOADS directory?','URL to your forums main directory','Use 24 hour time format?','Use Anti-leeching code?','Use category cache?','Use COPPA for registration?','Use email to notify users?','Use embedded multimedia?','Use Integrated forum stylesheets?','Use photo view caching to reduce view update queries on high load sites?','Use popup window for BIG images?','Use Spider-friendly URLs?','Use Whos Online PAL?','User Registration System','Web site name','When using on-the-fly image generation, do you want to overlay the watermark image?','Your Commission Junction click-through URL','Your mailing address to receive COPPA permission forms?','Your SMF Cookie Name','Your Website URL (include http://)') NOT NULL |
| puroparty.photopost_settings.varname | acceptimg | zipuploadurl | 4 | 14 | 0 | 0 | 8.8457 | NULL | ENUM('acceptimg','acceptmm','address','adminemail','allowfavzip','allowmedia','allowpa','allowpost','allowrate','allowregs','allowup','allowzip','annotate','backupdir','biggraphic','bigpopup','bigsave','botbuster','cachetimeout','calpal','cardage','cardexpire','cardreg','catcache','catdepth','catdetails','cellpadding','cjurl','closedmsg','compression','comtimeout','cookieprefix','cookie_path','coppa','copparules','cpostcount','cright','custom1pal','custom2pal','custom3pal','datadir','datafull','debug','defaultposts','dispcoms','dispdate','dispdesc','dispdims','dispempty','dispfs','dispkeys','displaynew','displayonline','dispmods','dispopular','dispquick','disptitle','dispviews','disrandom','domain','domain_path','downurl','dprefix','emailunique','emailverify','embededmm','enablecard','features','filmstrip','footer','forumstyle','framecolor','galleryname','getoptional','gmtoffset','gravity','header','headtags','idir','imgquality','indexavatars','indexcats','ipcache','jhead_command','jpegtran','loadlimit','maindir','maxfiles','maxheight','maxwidth','memblist','membthumb','memformat','minheight','minil','minis','minwidth','mmuploadsize','mobemail','moderatecoms','modprivs','mostpoppal','mostrecent','mysqldumppath','news','newscopy','newstitle','nextbox','notifyadmin','numcompal','numtoppal','onlinepal','onthefly','optcats','origdir','origfull','overwater','ppboards','ppdateformat','pplayout','ppostcount','previewwidth','pversion','randompal','ratingspal','recentcols','recentdefault','recentnum','reqregister','resizeorig','right-click','rotatel','rotatep','rules','showalbum','showavatar','showcoms','showdirect','showexif','showhtml','showlast','showmem','showsigs','showubb','sidebar','sidebar_global','sidebar_index','sidebar_width','slidehead','slideshow','smfcookie','spider','statspal','tablewidth','theme','threads','thumbborder','thumbcols','thumbrows','timeformat','topposterspal','undercat','uploadnotify','useemail','usegd','usenotify','userdel','usermove','vbulletin','vbversion','viewcache','watermark','webname','zipuploaddir','zipuploadurl') NOT NULL |
| puroparty.photopost_settings.description | You can use this feature for on-the-fly watermarks in combination with the on-the-fly image generation. | 0 | 165 | 101 | 0 | 27.4629 | NULL | ENUM('',' Choose the width for your sidebar',' Display Highest Ratings?',' Display Random Image?',' Display Recent Comments and Who\'s Online Pals',' Display Statistics Pal?',' Display Top Posters Pal?',' If you modified the custom1pal.tmpl and want to include it set to yes',' If you modified the custom2pal.tmpl and want to include it set to yes',' If you modified the custom3pal.tmpl and want to include it set to yes','.yourdomain.com; sets the cookie to be usable across the domain','0 to disable. 86400 is one day.','Adds a query to main index, but shows numbers of viewers per category','Adds a text link to the Albums index into the Members Gallery description','An uploaded larger than this will create a medium image of this size.','Choose from the available borders for your thumbnails','Choose from the available themes for your site layout','Color of the frame around images/thumbs','Determines the location of the film-strip previews on the showphoto page.','Do you want to display the calendar pal, yes or no.','Do you want to display the Index Avatars?','Do you want to display the page link to a photo?','Do you want to show the img src html tag for a photo?','EMail address users should send their images to','For users of ImageMagick only','Full path to the image files directory.','How do you want PhotoPost to handle errors?','How many rows of thumbnails do you want to display by default on this page?','If rotating your thumbnails, we need to create a mini thumbnail','If running *nix and you want to disable your forums when load goes over a certain limit; place the high limit here.','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.','If you use a forum like vB3 or Threads and want to use the intergated stylesheet option, choose Yes','If you want BIG photos to appear using a popup window, set to yes','If you would like to clean any JPG image uploaded before being processed; enter the path to your jpegtran executable.','Keywords: dow, month, mm, dd, yyyy','Number of minutes to cache information. Default is 10 minutes, 0 means no caching.','On larger sites this option can slow down the showgallery page. Turn off to speed up this page.','On some larger sites, using the category cache can actually reduce performance.','Only needed for users of SMF forums','Select ImageMagick or GD1/GD2 for image processing','Seperate file types by a comma and include the . (example: .jpg,.gif,.png)','Seperate file types by a comma and include the . (example: .mpg,.wma,.asf,.mp3)','Set this to NO if you want to assign moderators to specific categories','Set this to off for no sidebar or left or right depending on your tastes.','Set this to YES if you want the moderators listed on the index page under a category','Set this to YES if you want to enable the view caching code which caches photo view updates','Set to 0 to show all top level categories on one page','Set to on if you want to enable Zlib page compression (and it is supported)','Set to yes if you have BotBuster on your system (this includes the necessary tag)','Showsidebar on showphoto,showmembers and showgallery pages?','Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_','The full path to the directory to store backups','The full path to your mysqldump executable','Thickness - set to 0 for no border','This block can contain HTML code (200 character limit)','This is the URL path to your forum installation.','This is the web / virtual path to the data directory.','This only needs to be set if you are extracting EXIF information from images. Full server path.','This option uses the watermark.php script to serve images','This should be set to match the path/domain for your cookies. Setting to / enables entire site.','This variable is used to track IP addresses and userids for voting and viewing purposes. This is set in HOURS. 0 disables this setting','Threads Users: We need to know what the site default theme setting is.','To include an HTML file as the footer, enter the full path.','To include an HTML file as the header, enter the full path.','Typically this path matches your DATA directory server path, unless you want to store your original images seperatly from your thumbnails/medium images.','Typically this path matches your DATA directory URL, unless you want to store your original images seperatly from your thumbnails/medium images.','Use Right-Click Disable JavaScript to try and prevent right-clicking images','Users can be notified of photo approvals and deletions.','When available, display signatures?','When available, show avatars?','Yes is the default setting, No uses the thumbnail gallery layout','You can elect to have time displayed as HH:MMam or using the 24 hour clock','You can use this feature for on-the-fly watermarks in combination with the on-the-fly image generation.') NOT NULL | |
| puroparty.photopost_settings.setting | #000000 | yes | 1 | 52 | 13 | 0 | 5.5829 | NULL | ENUM('','#000000','.jpg,.jpeg,.png','.mpeg,.mpg,.avi,.asf,.wmv,.mov','/','/home/www/puroparty/photos/data/','/home/www/puroparty/photos/uploads','/path/to/php/footer.htm','/path/to/php/header.htm','/path/to/php/headtags.htm','/usr/bin/jhead','/usr/bin/jpegtran','/usr/bin/mysqldump','0','1','10','100','100%','12','15','16000','2','20%','2500','27','3','4','5','5.6','50','600','7','70','90','default','dow month dd, yyyy','http://www.domain.com/forum','http://www.puroparty.com','http://www.puroparty.com/photos','http://www.puroparty.com/photosdata','http://www.puroparty.com/photosimages','http://www.puroparty.com/photosuploads','infopop','left','My Photo Gallery','News','no','open','photopost','PuroParty.com','robert1999@gmail.com','SouthEast','The galleries are temporarily down for maintainence.','thumbnail','top','yes') NOT NULL |
| puroparty.photopost_settings.optionorder | 1 | 300 | 1 | 3 | 0 | 0 | 13.6286 | 23.7485 | ENUM('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','53','300') NOT NULL |
| puroparty.photopost_settings.section | 1 | 13 | 1 | 2 | 2 | 0 | 5.2400 | 3.5936 | ENUM('0','1','2','3','4','5','6','7','8','9','10','11','12','13') NOT NULL |