# MySQL-Front Dump 2.1
#
# Host: localhost   Database: ihosttest
#--------------------------------------------------------
# Server version 4.0.17-max-debug


#
# Table structure for table 'account_types'
#

CREATE TABLE IF NOT EXISTS account_types (
  type_type varchar(10) NOT NULL DEFAULT '' ,
  type_name varchar(100) NOT NULL DEFAULT '' ,
  cost_1 decimal(10,2) NOT NULL DEFAULT '4.95' ,
  max_images int(11) NOT NULL DEFAULT '20' ,
  max_upload_size int(11) NOT NULL DEFAULT '100000' ,
  max_image_width int(11) NOT NULL DEFAULT '800' ,
  max_image_height int(11) NOT NULL DEFAULT '600' ,
  auto_jpeg tinyint(4) NOT NULL DEFAULT '0' ,
  jpeg_quality tinyint(4) NOT NULL DEFAULT '65' ,
  add_branding tinyint(4) NOT NULL DEFAULT '1' ,
  simultaneous_uploads tinyint(4) NOT NULL DEFAULT '1' ,
  auto_resize tinyint(4) NOT NULL DEFAULT '1' ,
  email_friends tinyint(4) NOT NULL DEFAULT '1' ,
  images_per_page int(10) unsigned NOT NULL DEFAULT '5' ,
  max_galleries int(11) NOT NULL DEFAULT '1' ,
  resize_images tinyint(4) NOT NULL DEFAULT '1' ,
  rename_images tinyint(4) NOT NULL DEFAULT '1' ,
  bandwidth int(11) NOT NULL DEFAULT '0' ,
  storage int(11) NOT NULL DEFAULT '0' ,
  cost_3 decimal(10,2) NOT NULL DEFAULT '14.95' ,
  cost_6 decimal(10,2) NOT NULL DEFAULT '24.95' ,
  cost_12 decimal(10,2) NOT NULL DEFAULT '44.00' ,
  PRIMARY KEY (type_type),
   KEY nameindex (type_name)
);



#
# Dumping data for table 'account_types'
#
INSERT INTO account_types VALUES("paid","Platinum","4.95","0","1024","1024","1024","0","85","0","5","1","5","20","10","1","1","1000","100","13.05","24.95","44.95");
INSERT INTO account_types VALUES("free","LitePlan","0.00","0","500","800","600","0","50","1","3","1","1","5","3","1","1","250","20","0.00","0.00","0.00");


#
# Table structure for table 'ads'
#

CREATE TABLE IF NOT EXISTS ads (
  ad_id int(11) NOT NULL auto_increment,
  name varchar(50) NOT NULL DEFAULT '' ,
  content text NOT NULL DEFAULT '' ,
  views int(11) NOT NULL DEFAULT '0' ,
  live tinyint(4) NOT NULL DEFAULT '0' ,
  groupname varchar(50) NOT NULL DEFAULT '' ,
  PRIMARY KEY (ad_id),
   KEY viewsindex (live,views),
   KEY nameindex (name)
);



#
# Dumping data for table 'ads'
#


#
# Table structure for table 'banned_ips'
#

CREATE TABLE IF NOT EXISTS banned_ips (
  ip varchar(20) NOT NULL DEFAULT '' ,
  added timestamp(14) ,
  PRIMARY KEY (ip)
);



#
# Dumping data for table 'banned_ips'
#


#
# Table structure for table 'galleries'
#

CREATE TABLE IF NOT EXISTS galleries (
  gallery_id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL DEFAULT '0' ,
  gallery_name varchar(50) NOT NULL DEFAULT '' ,
  gallery_intro text NOT NULL DEFAULT '' ,
  PRIMARY KEY (gallery_id),
   KEY userindex (user_id)
);



#
# Dumping data for table 'galleries'
#


#
# Table structure for table 'images'
#

CREATE TABLE IF NOT EXISTS images (
  image_id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL DEFAULT '0' ,
  name varchar(150) NOT NULL DEFAULT '' ,
  type varchar(5) NOT NULL DEFAULT '' ,
  width int(11) NOT NULL DEFAULT '0' ,
  height int(11) NOT NULL DEFAULT '0' ,
  uploaded datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  filesize int(10) unsigned NOT NULL DEFAULT '0' ,
  ip varchar(20) NOT NULL DEFAULT '' ,
  checked tinyint(4) NOT NULL DEFAULT '0' ,
  gallery_id int(11) NOT NULL DEFAULT '0' ,
  bandwidth int(11) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (image_id),
   KEY userindex (user_id,name),
   KEY useruploadedindex (user_id,uploaded),
   KEY uploadedindex (uploaded),
   KEY nameindex (name),
   KEY galindex (gallery_id)
);



#
# Dumping data for table 'images'
#


#
# Table structure for table 'page_content'
#

CREATE TABLE IF NOT EXISTS page_content (
  content_id int(11) NOT NULL auto_increment,
  name varchar(100) NOT NULL DEFAULT '' ,
  description varchar(255) NOT NULL DEFAULT '' ,
  content text NOT NULL DEFAULT '' ,
  PRIMARY KEY (content_id),
   KEY nameindex (name)
);



#
# Dumping data for table 'page_content'
#
INSERT INTO page_content VALUES("1","Home Page","Content to display on the home page of the site.","<h3>Welcome to {sitename}!</h3>\r\n<p>\r\nWe offer both free and paid hosting for your images and photographs, whether for sharing with friends,\r\n adding to auction listings or other online use.\r\n</p>\r\n<p>\r\nYou can start uploading immediately after you <a href=\"join.php\">create your free account</a>,\r\n and only <a href=\"upgrade.php\">upgrade to our paid image hosting</a> service if you require the extra \r\nfeatures.\r\n</p>\r\n<p>\r\nWith either a free or paid account you can upload any of the three most popular web image formats\r\n (jpeg, png and gif). A brief summary of the features that our free and paid image hosting memberships \r\noffer is shown below.\r\n</p>\r\n<p>\r\nIf you have any further questions, please see our <a href=\"faq.php\">frequently asked questions</a>, \r\n<a href=\"terms.php\">terms &amp; conditions</a> and <a href=\"privacy-policy.php\">privacy policy</a> pages.\r\n If your query is not answered by these, please feel free to <a href=\"contact.php\">contact us directly</a>.\r\n</p>");
INSERT INTO page_content VALUES("2","Logged In","Displayed on the login, signup and confirm pages if the user is logged in.","<h3>Welcome back, {username}!</h3>\r\n<p>\r\nYou currently have {user_images} images uploaded to your {sitename} {user_type_name} account. \r\nYou can upload a maximum of {user_max_images} images to your {user_storage}mb of storage space.\r\nYou can view your images on <a href=\"images.php\">this page</a>, \r\nand upload more images <a href=\"upload.php\">here</a>.\r\n</p>\r\n\r\n<p>\r\nPlease ensure you are familiar with our <a href=\"terms.php\">Terms &amp; Conditions</a> and \r\n<a href=\"privacy-policy.php\">Privacy Policy</a>.\r\n</p>\r\n<p>\r\nIf you have any questions about your {sitename} account, please check our \r\n<a href=\"faq.php\">Frequently Asked Questions</a> page. \r\nIf you cannot find an answer to your question there, you can contact us via \r\n<a href=\"contact.php\">this form</a>.</p><p>Thank-you for hosting your images with {sitename}.\r\n</p>");
INSERT INTO page_content VALUES("3","Terms","The terms and conditions page for your site.","<h3>{sitename} Terms &amp; Conditions of Use</h3>\r\n<p>\r\n{sitename} provides a free and paid image and photo hosting service. \r\nUsers of this service may upload as many digital images as they wish (withing the limits of their accounts) \r\nand can then let others view the images by letting them know the url of the image.\r\n</p>\r\n<p>\r\nYou are authorized to sign up for and use 1 (one) free account only. \r\nAny members suspected of creating more than 1 (one) free account may have their accounts deleted and \r\nall images removed at any time.\r\n</p>\r\n<p>\r\nThis service is offered to those looking for personal image hosting. If any of your images uses excessive bandwidth we may delete the image from our servers with no prior notice and, at our discretion, suspend or terminate your account.\r\n</p>\r\n<p>\r\nAll images are the copyright of their respective owners. You may not use any of the images on this site for any purpose without the permission of the copyright holder.\r\n</p>\r\n<p>\r\nYou <strong>must</strong> own the copyright, or have permission from the copyright holder for any images\r\n you upload to this website.\r\n</p>\r\n<p>\r\nYou <strong>must not</strong> upload any images containing material that is of an adult nature, illegal, defamatory, promotes racism, hatred or discrimination.\r\n</p>\r\n<p>\r\nAny images found to break our terms and conditions will be removed with no warning. \r\nAnyone who uploads an image that violates our terms may be banned from using this site with no prior notice.\r\n</p>\r\n<p>\r\nIn the case of violation of our terms, we may share any and all information we hold on the user concerned with any interested 3rd parties.\r\n</p>\r\n<p>\r\nIf you believe one of our members has uploaded images to our site that break our terms and conditions please \r\n<a href=\"contact.php\">contact us</a> so we can take approriate action.\r\n</p>\r\n<p>\r\nPlease read our <a href=\"privacy-policy.php\">privacy policy</a> and <a href=\"faq.php\">frequently asked questions</a> for further information.\r\n</p>");
INSERT INTO page_content VALUES("4","Privacy Policy","The privacy policy for your site.","<h3>{sitename} Privacy Policy</h3>\r\n<p>\r\nThis is the web site of <b>{sitename}</b>.\r\n</p>\r\n<p>\r\nIf you want to contact us, please do so via the form on our <a href=\"contact.php\">contact page</a>.\r\n</p>\r\n<p>\r\nFor each visitor to our Web page, our Web server automatically recognizes your ip address.\r\n </p>\r\n<p>\r\nWe collect aggregate information on what pages consumers access or visit and any information\r\n you submit to us.\r\n</p>\r\n<p>\r\nThe information we collect is used to improve the content of our Web page, used to customize the content \r\nand/or layout of our page for each individual visitor, and is not shared with other organizations \r\nfor commercial or other purposes, \r\nwith the sole exception of cases where a user of our services breaks our terms &amp; conditions. \r\nUnder these circumstances, we may share your information with relevant law \r\nenforcement agencies and other relevant 3rd parties.\r\n</p>\r\n<p>\r\nWith respect to cookies: We use cookies to store visitors preferences,\r\n customize Web page content based on visitors\' browser type or other information that the \r\nvisitor sends and store your upload settings.\r\n</p>\r\n<p>\r\nWith respect to Ad Servers: To try and bring you offers that are of interest to you, we have relationships \r\nwith other companies that we allow to place ads on our Web pages. \r\nAs a result of your visit to our site, ad server companies may collect information such as your domain type,\r\n your IP address and clickstream information.\r\n For further information, consult the privacy policies of the companies advertising on our site. \r\n</p>\r\n<p>\r\nFrom time to time, we may use customer information for new, unanticipated uses not previously \r\ndisclosed in our privacy notice. If our information practices change at some time in the future we \r\nwill use for these new purposes only data collected from the time of the policy change forward .\r\n</p>\r\n<p>\r\nUpon request we provide site visitors with access to all information that we maintain about them, \r\nincluding contact information (e.g., name, address, phone number).\r\n</p>\r\n<p>\r\nConsumers can access this information by contacting us through our <a href=\"contact.php\">contact page</a>.\r\n </p>\r\n<p>\r\nIf you feel that this site is not following its stated information policy, or have any other questions\r\n regarding the operation of this site, please contact or us via the form on our\r\n <a href=\"contact.php\">contact page</a>.\r\n</p>");
INSERT INTO page_content VALUES("5","Remind","Content for the password reminder page.","<h3>Forgotten Your Password?</h3>\r\n<p>\r\nIf you have forgotten the login details for your {sitename} image hosting account, please enter either your \r\nusername <strong>or</strong> the email address you signed up with in the form below\r\n and we will send you a reminder.\r\n</p>\r\n<p>\r\nThe reminder will be sent to the email address you used when you opened your image hosting account.\r\n</p>");
INSERT INTO page_content VALUES("6","Reminder Sent","Displayed when the user submits the password reminder form.","<h3>Password Reminder Sent</h3>\r\n<p>\r\nAn email containing your {sitename} login details has been sent to your email address. \r\nYou should receive this email within the next 10 minutes.\r\n</p>\r\n<p>\r\nOnce you receive your username and password you can login <a href=\"login.php\">here</a>.\r\n</p>");
INSERT INTO page_content VALUES("7","Login","Displayed at the top of the login page.","<h3>Login</h3>\r\n<p>\r\nEnter your username and password and click the &quot;Login&quot; button to login to your account.\r\n</p>\r\n<p>\r\nIf you do not yet have a {sitename} account, you can <a href=\"join.php\">create one for free</a>.\r\n</p>\r\n<p>\r\nIf you have forgotten your login details we can <a href=\"remind.php\">email you a reminder</a>.\r\n</p>");
INSERT INTO page_content VALUES("8","Suspended Message","Message displayed if the user\'s account has been suspended.","<p><strong>Your Account Has Been Suspended</strong></p>\r\n<p>\r\nYour {sitename} image hosting account is currently suspended.\r\n</p>\r\n<p>\r\nPlease ensure you have read and agree to our <a href=\"terms.php\">terms &amp; conditions</a> and \r\nour <a href=\"privacy-policy.php\">privacy policy</a>.\r\n If you have any questions about your account that are not answered on our \r\n<a href=\"faq.php\">frequently asked questions page</a> then please <a href=\"contact.php\">contact us</a>.\r\n</p>");
INSERT INTO page_content VALUES("9","Unconfirmed Message","Displayed on login attempt if account not confirmed.","<p><strong>You Must Confirm Your Email Address</strong></p>\r\n<p>\r\nYou have not yet confirmed the email address you entered when you created your account. \r\nWe require this for security purposes. \r\nAn email was sent to your signup email address containing instructions on how to confirm it.\r\n</p>\r\n<p>\r\nIf you did not receive this email, or if you have deleted it, you can request a <a href=\"remind.php\">copy here</a>.</p>");
INSERT INTO page_content VALUES("10","Images","Displayed at the top of the member\'s images page.","<h3>My Images</h3>\r\n<p>\r\nAll the images you have uploaded to this site are listed below.\r\n To view an image, click on the thumbnail or the image name.\r\n</p>\r\n<p>\r\nIf you want to share an image with other people on the internet, copy the code from one of the three boxes \r\nnext to each image, depending on how you want to share the image:\r\n</p>\r\n<ul>\r\n<li><strong>URL</strong> - Copy the text in the url field if all you need is a url to give to people.</li>\r\n<li><strong>HTML</strong> - Copy the text in the html field if you want to link to the image from a page on another \r\nwebsite.</li>\r\n<li><strong>BB Code</strong> - Copy the text from the BB Code field if you want to include the image in a\r\n message on a website discussion forum that uses standard bulletin board codes \r\n(forums running phpbb, Invisionboard or VBulletin support this format of linking to images).</li>\r\n</ul>\r\n<p>You can also easily email links to your images to your friends by selecting the checkboxes next to each\r\n image you want to share submitting the email form at the bottom of this page.\r\n Just enter their email address and a short message and click the &quot;Send Email&quot; button.\r\n</p>\r\n<p>You can upload more images on the <a href=\"upload.php\">upload page</a>.</p>");
INSERT INTO page_content VALUES("11","Faq","Frequently asked questions page.","<h3>{sitename} Frequently Asked Questions</h3>\r\n<p>\r\nThis page lists common questions and answers about the {sitename} service. If your question is not answered here, please use our <a href=\"contact.php\">contact form</a> to get in touch.\r\n</p>\r\n<h3>Account Features</h3>\r\n<p><strong>What image formats are supported?</strong></p>\r\n<p>\r\n{sitename} supports images uploaded in jpeg, gif and png format.\r\n</p>\r\n<p><strong>What is the maximum allowed size for uploaded images?</strong></p>\r\n<p>The maximum filesize you can upload depends on whether you have a paid or free account, as does the\r\n maximum width and height allowed for uploaded images. Images with a larger filesize than the allowed maximum\r\n will be rejected. Images with larger widths and heights than your account allows may be automatically resized depending on your account.\r\n</p>\r\n<p>\r\nYou can view the maximum sizes allowed on our <a href=\"index.php\">home page</a>.\r\n</p>\r\n<p><strong>How many images can I upload?</strong></p>\r\n<p>\r\nThe number of images you can upload depends on the type of account you have. Please see our account \r\ncomparison table on the <a href=\"index.php\">{sitename} home page</a> for further details. \r\nNote that there is no limit on the number of uploads you can do, just on the number of images stored in your\r\n account at any one time. This limit may be set by the storage space we give you, or a set maximum number of images. You can delete images from your account at any time to make room for new \r\nones.\r\n</p>\r\n<p><strong>Where can I compare the features for free and paid accounts?</strong></p>\r\n<p>\r\nTo view and compare all the features of our free and paid accounts, please see the table on \r\nour <a href=\"index.php\">home page</a>.</p>\r\n<p><strong>Can I link to my images when I have uploaded them?</strong></p>\r\n<p>\r\nYes. We allow you to link directly to your images once they are uploaded. We provide you with url to each\r\n image, as well as html code to link to it, and bbcode compatible with the most commonly found forums.\r\n</p>\r\n<p><strong>Can I view / delete / access my images after they are uploaded?</strong></p>\r\n<p>\r\nYes. Once you login to your account you can browse a list of all your uploaded images together with \r\na thumbnail preview of each image. From here you can find the url to each image, delete images you no\r\n longer need, and email links to the images to your friends.\r\n</p>\r\n<p><strong>Are there any types of image that are not allowed on {sitename}?</strong></p>\r\n<p>\r\nYes. Any images that contravene our <a href=\"terms.php\">terms and conditions</a> may not be uploaded \r\nto your account. We reserve the right to delete without any notice any images which we believe violate \r\nour <a href=\"terms.php\">terms and conditions</a>, and to suspend or terminate the accounts of any \r\nmembers who upload images that violate our <a href=\"terms.php\">terms</a>.\r\n</p>\r\n<h3>Membership</h3>\r\n<p><strong>How do I sign up for an account?</strong></p>\r\n<p>\r\nYou can sign up for a free account on the <a href=\"join.php\">sign up</a> page. \r\nYou need to choose a username and password that you will use to upload images to your account.\r\n We also require you to enter a valid email address when you join. We send a confirmation email to this \r\naddress with instructions on how to activate your account. \r\n</p>\r\n<p><strong>Can I sign up for more than 1 account?</strong></p>\r\n<p>\r\nFree accounts are limited to 1 (one) per individual. If we catch anyone abusing this limit, we may delete all their \r\naccounts without any notice.\r\n</p>\r\n<p><strong>How do I access my account?</strong></p>\r\n<p>\r\nOnce you have signed up and confirmed your account, you can login to it on the \r\n<a href=\"login.php\">login</a> page. Whilst logged in to your account you can \r\n<a href=\"upload.php\">upload images</a>, <a href=\"images.php\">browse the images</a> you have already\r\n uploaded, get the urls required to view or link to the images, email links to the images to your friends, \r\nand delete any of your images.\r\n</p>\r\n<p><strong>Help! I\'ve forgotten my username or password.</strong></p>\r\n<p>\r\nIf you forget your login details for your {sitename} account we can send a reminder to the email address\r\n you registered with us when you created your account. Just follow the instructions on the\r\n <a href=\"remind.php\">password reminder</a> page.\r\n</p>\r\n<p><strong>How do I upgrade to a {paid_account_name} account?</strong></p>\r\n<p>\r\nIf you have outgrown the features provided by our {free_account_name} account, you can upgrade to a \r\npaid account on the <a href=\"upgrade.php\">upgrade</a> page.\r\n A {paid_account_name} costs ${paid_account_cost} per month (discounts may be available if you pay for several months at a time). Payments are accepted through\r\n <a href=\"https://www.paypal.com/\" target=\"_blank\">PayPal</a>, and in most cases your account \r\nwill be upgraded automatically after payment.\r\n</p>\r\n<h3>Unanswered Questions</h3>\r\n<p>\r\nIf you have any further questions not answered in this document, please \r\n<a href=\"contact.php\">contact us</a> directly.\r\n</p>");
INSERT INTO page_content VALUES("12","Sign Up","Message displayed at the top of the sign up page.","<h3>Open A Free Account</h3>\r\n<p>\r\nOur {sitename} {free_account_name} account is 100% free. Please fill in your details in the following form to\r\n create your image hosting account.\r\n</p>\r\n<p>\r\nAll fields are <strong>required</strong>.\r\n Please ensure the information you enter is accurate.\r\n</p>\r\n<p>\r\nPlease ensure you have read and agree to our <a href=\"terms.php\">terms &amp; conditions</a> \r\nand our <a href=\"privacy-policy.php\">privacy policy</a>. \r\nIf you have any questions about {sitename} that are not answered on our \r\n<a href=\"faq.php\">frequently asked questions page</a> then please <a href=\"contact.php\">contact us</a>.\r\n</p>");
INSERT INTO page_content VALUES("13","Signed Up - Complete","Displayed to new members when the sign up process is complete.","<h3>Your Account Is Now Active</h3>\r\n<p>\r\nThank you for joining {sitename}. Your {free_account_name} image hosting account has been created and is now active.\r\n You can login to your account <a href=\"login.php\">here</a>.\r\n</p>\r\n<p>\r\nPlease ensure you have read and agree to our <a href=\"terms.php\">terms &amp; conditions</a>\r\n and our <a href=\"privacy-policy.php\">privacy policy</a>. \r\nIf you have any questions about {sitename} that are not answered on our \r\n<a href=\"faq.php\">frequently asked questions page</a> then please <a href=\"contact.php\">contact us</a>.\r\n</p>");
INSERT INTO page_content VALUES("14","Signed Up - Unconfirmed","Displayed when a member signs up but needs to confirm their email address.","<h3>Please Confirm Your Account</h3>\r\n<p>\r\nThank you for signing up for our {free_account_name} image hosting account.\r\n Before you can login to your account you must confirm that the email address you entered when you signed \r\nup is valid.\r\n</p>\r\n<p>\r\nWe have sent an email to this address containing instructions on how to finish setting up your account.\r\n</p>");
INSERT INTO page_content VALUES("25","Image Limit Reached","Message displayed on the upload page when a member has reached their upload limit.","<p><strong>Maximum Upload Limit Reached</strong></p>\r\n<p>\r\nYou have reached your account image limit ({user_max_images} images, {user_storage}mb of storage). \r\nIf you want to upload any more images, you must:\r\n</p>\r\n<ul><li><strong>Either</strong> delete some of your <a href=\"images.php\">existing images</a> \r\n(select the checkboxes next to the images to delete and click the &quot;Delete Images&quot; button).</li>\r\n<li><strong>Or</strong> <a href=\"upgrade.php\">upgrade your account</a> for more storage space.\r\n If your account is already a {paid_type_name}, you may <a href=\"join.php?logout=1\">sign up for new one</a>\r\n for extra storage space.</li></ul>\r\n\r\n<p>If you have any questions about this limit or our policies in general, please <a href=\"contact.php\">contact us</a>.</p>");
INSERT INTO page_content VALUES("17","Confirm","Displayed at the top of the confirm email address page.","<h3>Confirm Your Email Address</h3>\r\n<p>\r\nBefore you can login to your {sitename} account, we require you to confirm that the email address you gave when you signed up is real.\r\n</p>\r\n<p>\r\nAn email has been sent to this address with instructions on how to confirm your account. If you have not received, or have deleted this email message you can <a href=\"/remind.php\">request a reminder</a>.\r\n</p>");
INSERT INTO page_content VALUES("18","Email Confirmed","Displayed when a member completes the email confirmation stage of signup.","<h3>Your Email Address Has Been Confirmed!</h3>\r\n<p>Thank you for confirming your email address. Your account is now <a href=\"/login.php\">ready to use</a>.</p>");
INSERT INTO page_content VALUES("19","Contact","Displayed at the top of the contact form page.","<h3>Contact Us</h3>\r\n<p>\r\nPlease use the form below if you have any comments, suggestions or other feedback regarding {sitename}.\r\n</p>\r\n<p>\r\nPlease also use this form to report any problems with your {sitename} account. You may also find our <a href=\"faq.php\">frequently asked questions</a> page provides an answer to your query.\r\n</p>\r\n<p><strong>Reporting Abuse</strong></p>\r\n<p>\r\nWe take all reports of abuse of our service seriously. If you have information that our service is being used to illegally host copyrighted, adult, or any other images that breach our <a href=\"terms.php\">terms &amp; conditions</a> please use this form to report them, including full details, <strong>especially the url of the offending image.</strong>\r\n</p>\r\n<p><strong>Please ensure that you enter your email address correctly.</strong></p>\r\n<p>\r\nOtherwise we will be unable to respond to your query. We will not share your email address with any other parties. You can view our <a href=\"privacy-policy.php\">Privacy Policy</a> for further information.\r\n</p>");
INSERT INTO page_content VALUES("20","Contact Submitted","Displayed when someone submits the contact form.","<h3>Your Message Has Been Sent</h3>\r\n<p>\r\nThank-you for contacting us at {sitename}. Your feedback is important to us.\r\n</p>\r\n<p>\r\nWe aim to respond to all queries within 48 hours.</p><p>Best Regards,\r\n</p>\r\n<p>The {sitename} Team. </p>");
INSERT INTO page_content VALUES("21","Upload","Displayed at the top of the upload images page.","<h3>Upload Your Images</h3>\r\n<p>\r\nUse the form below to upload your images to {sitename}. You may upload {user_simultaneous_uploads} images at a time using this form.\r\n</p>\r\n<p>\r\nWe accept images in jpeg, gif and png format. The maximum filesize we allow is {user_max_upload_size}k. Images larger than {user_max_image_width}x{user_max_image_height} pixels will be resized to fit to this size.\r\n</p>\r\n<p>\r\nYou currently have {user_images} out of a maximum of {user_max_images} images uploaded. You can manage these images <a href=\"images.php\">here</a>.\r\n</p>\r\n<p>You have currently used {user_bandwidth_used} mb out of your allowed {user_bandwidth}mb of bandwidth this month, and are currently using {user_storage_used}mb of your allowed {user_storage}mb  space.</p>\r\n<p>\r\nIf you have any questions about uploading your images and photographs, please read our\r\n <a href=\"faq.php\">frequently asked questions</a>, <a href=\"terms.php\">terms &amp; conditions</a> and <a href=\"privacy-policy.php\">privacy policy</a>. Alternatively, you can <a href=\"contact.php\">contact us directly</a>.\r\n</p>");
INSERT INTO page_content VALUES("22","Not Logged In","Displayed on pages requiring login if user is not logged in.","<p><strong>You Must Be Logged In To Access This Page</strong></p>\r\n<p>\r\nYou can login to your account by entering your username and password in the form below.\r\n</p>\r\n<p>\r\nIf you do not have an account with {sitename} you can <a href=\"join.php\">create one for free</a>. \r\nIf you have forgotten your username or password, we can <a href=\"remind.php\">email you a reminder</a>.\r\n</p>");
INSERT INTO page_content VALUES("23","No Images","Displayed on the images page when the user has not uploaded any images.","<p><strong>No images found matching your criteria.</strong></p>");
INSERT INTO page_content VALUES("24","No New Members","Displayed on the signup page if you uncheck the \"allow signups\" option on the settings page.","<h3>Sign-Up Disabled</h3>\r\n<p>{sitename} is not currently accepting any new members. Please try again at later date.</p>");
INSERT INTO page_content VALUES("26","Upgrade - Not Logged In","Displayed on the upgrade.php page when the user is not logged in.","<p><strong>Please Login or Create A Free Account</strong></p>\r\n<p>\r\nIn order to upgrade to a {paid_account_name} account, you must first have a free account.\r\n</p>\r\n<p>\r\nIf you have already created an account and confirmed your email address, please <a href=\"login.php\">log in to your account</a> and return to this page for upgrade instructions.\r\n</p>\r\n<p>\r\nIf you do not have an account with us, please <a href=\"join.php\">sign up for a free account</a>, follow the instructions to confirm your account and then return to this page if you need to upgrade it.\r\n</p>\r\n<p>\r\nFor further information about this site please see our <a href=\"faq.php\">frequently asked questions</a>, \r\n<a href=\"terms.php\">terms &amp; conditions</a>, \r\nand <a href=\"privacy-policy.php\">privacy policy</a> pages. You can contact us using the form <a href=\"contact.php\">on this page</a>.\r\n</p>");
INSERT INTO page_content VALUES("27","Upgrade","Intro text on the upgrade account page.","<h3>Upgrade Your Account</h3>\r\n<p>\r\nThe {sitename} {paid_account_name} account gives you access to extra image storage, larger file size limits and other extra features.\r\n</p>\r\n<p>\r\nA {paid_account_name} account costs ${paid_account_cost} per month. Payments are processed by <a target=\"_blank\" href=\"http://www.paypal.com/\">PayPal</a> and are recurring. Options for paying every 1, 3, 6 or 12 months are available below.\r\n</p>");
INSERT INTO page_content VALUES("28","Upgrade - Logged In","Message displayed on the upgrade page to members who are logged in and currently on the free plan.","<p><strong>Upgrade Now!</strong></p>\r\n<p>\r\nUpgrading your account is a simple process that usually takes just a few minutes.\r\n</p>\r\n<p>\r\nJust check that the information we have listed for your account below is correct, then click the subscribe button below that corresponds with the period of time you wish to upgrade for.\r\n</p>\r\n<p>\r\nPayments will recur whenever due. You can cancel your subscription payments at any time from within your <a href=\"http://www.paypal.com/\">PayPal</a> account.\r\n</p>");
INSERT INTO page_content VALUES("29","Upgrade - Already Upgraded","Message displayed on the upgrade account page if the member has already upgraded.","<p><strong>You Already Have A {paid_account_name} Account</strong></p>\r\n<p>\r\nYour account has already been upgraded.\r\n</p>");
INSERT INTO page_content VALUES("30","Images - Not Logged In","Content displayed on the images.php page if the user is not logged in.","<p><strong>My Images</strong></p>\r\n<p>\r\nAll the images you have uploaded to this site are listed below. \r\nTo view an image, click on the thumbnail or the image name.\r\n</p>\r\n<p>\r\nIf you want to share an image with other people on the internet, copy the code from one of the three\r\n boxes next to each image, depending on how you want to share the image:\r\n</p>\r\n<ul><li><strong>URL</strong> - Copy the text in the url field if all you need is a url to give to people. \r\n</li>\r\n<li><strong>HTML</strong> - Copy the text in the html field if you want to link to the image from a page on \r\nanother website. </li>\r\n<li><strong>BB Code</strong> - Copy the text from the BB Code field if you want to include the image in a \r\nmessage on a website discussion forum that uses standard bulletin board codes (forums running phpbb, \r\nInvisionboard or VBulletin support this format of linking to images).</li></ul>\r\n<p>\r\nYou can also easily email links to your images to your friends by selecting the checkboxes next to each image you \r\nwant to share submitting the email form at the bottom of this page. Just enter their email address and a short message and click the &quot;Send Email&quot; button.\r\n</p>");
INSERT INTO page_content VALUES("31","Upload - Not Logged In","Content displayed on the upload.php page if the user is not logged in.","<p><strong>Upload Your Images</strong></p>\r\n<p>\r\nUse the form below to upload your images to {sitename}. You may upload {user_simultaneous_uploads} images at a time using this form.\r\n</p>\r\n<p>\r\nWe accept images in jpeg, gif and png format. The maximum filesize we allow is {user_max_upload_size} bytes. Images larger than {user_max_image_width}x{user_max_image_height} pixels will be resized to fit to this size.\r\n</p>\r\n<p>\r\nIf you have any questions about uploading your images and photographs, please read our <a href=\"faq.php\">frequently asked questions</a>, <a href=\"terms.php\">terms &amp; conditions</a> and privacy policy. Alternatively, you can contact us directly.\r\n</p>");
INSERT INTO page_content VALUES("37","Uploads Suspended","Displayed on the upload.php page if admin disables uploads.","<h3>Image Uploads Temporarily Suspended</h3>\r\n<p>\r\nFor technical reasons {sitename} has temporarily suspended all image uploading.\r\n</p>\r\n<p>{sitename} apologises for any inconvenience this may cause.</p>");
INSERT INTO page_content VALUES("38","IP Banned","Displayed when someone accesses certain pages and their ip has been banned.","<h3>Access Denied</h3>\r\n<p>Access to the features offered on this page have been denied because your I.P. address has been involved in abuse of our services.\r\n</p>\r\n<p>\r\nIf you believe this is an error on our part, please <a href=\"contact.php\">contact us</a>.\r\n</p>");
INSERT INTO page_content VALUES("39","Resize Image","displayed at the top of the \"Resize Image\" page.","<h3>Resize Image</h3>\r\n<p>Use the form below to resize your image. The new image can be up to {user_max_image_width}x{user_max_image_height} pixels.</p>\r\n<p>You can ensure that the image is resized proportionally by only entering a value for <b>either</b> the width <b>or</b> the height.</p>\r\n<p>To save the resized image as a copy of the original instead of overwriting the original, check the box at the bottom of the form.</p>");
INSERT INTO page_content VALUES("40","Image Resized","Displayed when an image has been resized.","<h3>Image Resized</h3>\r\n<p>Your image has been resized. To view this image or to resize another image, <a href=\"images.php\">click here to return to your images page</a>.</p>");
INSERT INTO page_content VALUES("41","Cannot Resize","Displayed on the resize.php page if the user is not allowed to resize images.","<h3>Sorry, your account does not allow image resizing.</h3>\r\n<p>If you would like to be able to resize your images, please <a href=\"upgrade.php\">upgrade your account.</a></p>");
INSERT INTO page_content VALUES("42","Cannot Rename","Displayed on the rename.php page if the user is not allowed to rename images.","<h3>Sorry, your account does not allow you to rename image.</h3>\r\n<p>If you would like to be able to rename your images, please <a href=\"upgrade.php\">upgrade your account.</a></p>");
INSERT INTO page_content VALUES("43","Rename Image","displayed at the top of the rename.php page.","<h3>Rename Image</h3>\r\n<p>Enter a new name for this image. The name must be unique, and can contain any alphanumeric character, plus the characters \"-\" and \"_\". The name must begin and end with a number or letter.</p>\r\n<p>You do not need to include the file extension (eg., jpg, png, etc) in the new name. This will be added automatically.</p>");
INSERT INTO page_content VALUES("44","Image Renamed","Displayed when a user has renamed an image.","<h3>Image Renamed</h3>\r\n<p>Your image has been renamed. To rename another image, select the rename option on your <a href=\"images.php\">images</a> page.</p>");
INSERT INTO page_content VALUES("45","Galleries","Displayed at the top of the galleries.php page.","<h3>My Image Galleries</h3>\r\n<p>{sitename} allows you to organize their images into galleries, so if you have several related images to share with your friends or family, you can send them just the url of the gallery instead of a separate url to each image.</p>\r\n<p>{free_account_name} accounts can create up to {free_max_galleries} galleries and <a href=\"upgrade.php\">{paid_account_name}</a> accounts can have up to {paid_max_galleries} image galleries.</p>\r\n<p>There is no limit to the number of images you can display in each gallery, other than the maximum number allowed in your account.</p>\r\n<p>To add or remove images from your galleries, <a href=\"galleries.php?action=add\">create one or more galleries</a>, then browse to your <a href=\"images.php\">My Images</a> page, select the checkboxes next to the images you want to add to a gallery, and select the gallery from the list at the bottom of that page.</p>");
INSERT INTO page_content VALUES("46","Gallery Not Found","Displayed on the gallery.php page if no gallery specified.","<h3>Gallery Not Found!</h3>\r\n<p>Sorry, the image gallery you specified does not exist.</p>");
INSERT INTO page_content VALUES("47","No Image Selected","Displayed on the rename and resize page if no image selected.","<h3>No Image Selected!</h3>\r\n<p>Please return to the <a href=\"images.php\">My Images</a> page and select the image you want to perform this operation on.</p>");
INSERT INTO page_content VALUES("48","Galleries Not Allowed","Displayed on the galleries.php page if the user\'s account does not allow galleries.","<h3>Please upgrade your account</h3>\r\n<p>Your account does not allow you to create any image galleries. For the ability to create up to {paid_max_galleries} image galleries, please <a href=\"upgrade.php\">upgrade to a {paid_account_name} account</a>.</p>");
INSERT INTO page_content VALUES("49","Monthly Bandwidth Limit Reached","Displayed on the upload page when a member cannot upload images due to bandwidth","<h3>Monthly Bandwidth Limit Reached</h3>\r\n<p>Sorry, you cannot upload any more images at this time as you have reached your monthly bandwidth limit ({user_bandwidth}mb).</p>\r\n<p>If you currently have a {free_account_name} account you can increase your bandwidth allowance to {paid_bandwidth}mb per month by <a href=\"upgrade.php\">upgrading</a> to a {paid_account_name} account.</p>");


#
# Table structure for table 'paypalpayments'
#

CREATE TABLE IF NOT EXISTS paypalpayments (
  payment_id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL DEFAULT '0' ,
  txn_id varchar(20) NOT NULL DEFAULT '' ,
  dated datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  amount decimal(10,2) NOT NULL DEFAULT '0.00' ,
  paypal_email varchar(100) NOT NULL DEFAULT '' ,
  paypal_data text NOT NULL DEFAULT '' ,
  sub_id varchar(32) NOT NULL DEFAULT '' ,
  PRIMARY KEY (payment_id),
  UNIQUE KEY txnindex (txn_id),
   KEY userindex (user_id),
   KEY emailindex (paypal_email),
   KEY datedindex (dated)
);



#
# Dumping data for table 'paypalpayments'
#


#
# Table structure for table 'settings'
#

CREATE TABLE IF NOT EXISTS settings (
  admin_username varchar(50) NOT NULL DEFAULT 'admin' ,
  admin_password varchar(50) NOT NULL DEFAULT 'password' ,
  admin_email varchar(150) NOT NULL DEFAULT '' ,
  sitename varchar(100) NOT NULL DEFAULT '' ,
  siteurl varchar(150) NOT NULL DEFAULT '' ,
  email_confirmation tinyint(3) unsigned NOT NULL DEFAULT '0' ,
  signup_email_from varchar(100) NOT NULL DEFAULT '' ,
  signup_email_subject varchar(100) NOT NULL DEFAULT '' ,
  signup_email_template text NOT NULL DEFAULT '' ,
  email_confirmation_key varchar(50) NOT NULL DEFAULT 'enter something random here' ,
  allow_signups tinyint(3) unsigned NOT NULL DEFAULT '0' ,
  thumbnail_width int(10) unsigned NOT NULL DEFAULT '120' ,
  thumbnail_height int(10) unsigned NOT NULL DEFAULT '120' ,
  image_folder varchar(255) NOT NULL DEFAULT './images' ,
  thumb_folder varchar(255) NOT NULL DEFAULT './thumbs' ,
  image_url varchar(255) NOT NULL DEFAULT '/images/' ,
  thumb_url varchar(255) NOT NULL DEFAULT '/thumbs/' ,
  allow_uploads tinyint(3) unsigned NOT NULL DEFAULT '1' ,
  branding_text varchar(100) NOT NULL DEFAULT 'hosted by www.mysite.com' ,
  branding_color varchar(10) NOT NULL DEFAULT '#ffffff' ,
  branding_bgcolor varchar(10) NOT NULL DEFAULT '#000000' ,
  branding_transparency tinyint(3) unsigned NOT NULL DEFAULT '50' ,
  branding_size tinyint(3) unsigned NOT NULL DEFAULT '8' ,
  min_branding_width int(10) unsigned NOT NULL DEFAULT '200' ,
  min_branding_height int(10) unsigned NOT NULL DEFAULT '150' ,
  email_images_subject varchar(100) NOT NULL DEFAULT 'Have a look at my pictures' ,
  email_images_template text NOT NULL DEFAULT '' ,
  reminder_email_from varchar(50) NOT NULL DEFAULT '' ,
  reminder_email_subject varchar(100) NOT NULL DEFAULT 'your password reminder' ,
  reminder_email_template text NOT NULL DEFAULT '' ,
  paypal_email varchar(100) NOT NULL DEFAULT '' ,
  payment_email_subject varchar(100) NOT NULL DEFAULT 'Your account has been upgraded!' ,
  payment_email_message text NOT NULL DEFAULT '' ,
  installed tinyint(3) unsigned NOT NULL DEFAULT '0' ,
  ban_ips tinyint(4) NOT NULL DEFAULT '1' ,
  gallery_max_image_width int(11) NOT NULL DEFAULT '500' ,
  gallery_max_image_height int(11) NOT NULL DEFAULT '500' ,
  gallery_url_mode varchar(20) NOT NULL DEFAULT 'querystring' ,
  bandwidth_checked date NOT NULL DEFAULT '0000-00-00' ,
  bandwidth_reset_checked date NOT NULL DEFAULT '0000-00-00' ,
  notify_bandwidth_exceeded tinyint(4) NOT NULL DEFAULT '0' ,
  bandwidth_exceeded_from varchar(100) NOT NULL DEFAULT 'admin@example.com' ,
  bandwidth_exceeded_subject varchar(100) NOT NULL DEFAULT 'monthly bandwidth exceeded' ,
  bandwidth_exceeded_message text NOT NULL DEFAULT '' ,
  payment_notifications tinyint(4) NOT NULL DEFAULT '1', 
	paypal_account_email varchar(150) NOT NULL
);



#
# Dumping data for table 'settings'
#
INSERT INTO settings VALUES("admin","password","","My Image Host","","1","","New account created!","Welcome to {sitename}\r\n\r\nYour username is: {username}\r\nYour password is: {password}\r\n\r\n<confirm>\r\nPlease confirm your email address by visiting the url below:\r\n\r\n{siteurl}confirm.php?confirm=1&username={username}&cid={confirmid}\r\n</confirm>\r\n\r\nThank you for joining {sitename}!","89fd0sjkdfslakjlfsdkla","1","120","120","","","","","1","free image hosting by www.myimagehost.com","#ffffff","#000000","70","8","200","100","Have a look at my pictures.","{message}\r\n\r\nClick the links below to view the images in your web browser. If clicking the links does not work, copy them and paste them into your browser\'s address bar.\r\n\r\n{imagelinks}\r\n\r\nThis message was sent to you from {sitename} ({siteurl}) on behalf of the sender.\r\nIf you believe you have received this message in error please accept our apologies.\r\nIf you wish to complain about the sender of this message, please contact us at:\r\n{siteurl}contact.php\r\n\r\nThanks.","reminder@example.com","your password reminder","Hi there,\r\n\r\nThis is a password reminder:\r\n\r\nYour username: {username}\r\nYour password: {password}\r\n\r\n<confirm>\r\nPlease confirm your email address by visiting the url below:\r\n\r\n{siteurl}confirm.php?confirm=1&username={username}&cid={confirmid}\r\n</confirm>\r\n\r\nYou can login at {siteurl}login.php\r\n\r\nThanks, the {sitename} team.","paypal@example.com","Your account has been upgraded!","Hi {username},\r\n\r\nThis is a confirmation email that your {sitename} account has been upgraded until {expirydate}.\r\n\r\nThank-you for using our service!","0","1","500","500","querystring",now(),now(),"1","admin@example.com","monthly bandwidth exceeded","You have exceeded your monthly bandwidth limit on {sitename}.\r\n\r\nYour images cannot be viewed until your bandwidth usage is reset at the beginning of the next month of your membership.","1", "");


#
# Table structure for table 'users'
#

CREATE TABLE IF NOT EXISTS users (
  user_id int(11) NOT NULL auto_increment,
  status tinyint(4) NOT NULL DEFAULT '0' ,
  name varchar(50) NOT NULL DEFAULT '' ,
  username varchar(20) NOT NULL DEFAULT '' ,
  pass varchar(20) NOT NULL DEFAULT '' ,
  email varchar(150) NOT NULL DEFAULT '' ,
  joined datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  updated datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  lastlogin datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  ip varchar(20) NOT NULL DEFAULT '' ,
  account_type varchar(10) NOT NULL DEFAULT 'free' ,
  paid_until date NOT NULL DEFAULT '0000-00-00' ,
  loginip varchar(20) NOT NULL DEFAULT '' ,
  bandwidth_exceeded tinyint(4) NOT NULL DEFAULT '0' ,
  bandwidth_reset date NOT NULL DEFAULT '0000-00-00' ,
  deleted_images_bandwidth int(11) NOT NULL DEFAULT '0' ,
  sub_id varchar(100) NOT NULL DEFAULT '' ,
  sub_months tinyint(4) NOT NULL DEFAULT '0' ,
  sub_amount decimal(10,2) NOT NULL DEFAULT '0.00' ,
  PRIMARY KEY (user_id),
   KEY loginindex (username,pass),
   KEY joinedindex (joined,status),
   KEY emailindex (email,username),
   KEY statusindex (status)
);



#
# Dumping data for table 'users'
#
