<?

include("includes/data_conn.php");


$q1 = "DROP TABLE IF EXISTS contact";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE contact (
  postid int(10) unsigned NOT NULL auto_increment,
  name varchar(50) NOT NULL default '0',
  date varchar(20) NOT NULL default '',
  demail varchar(65) NOT NULL default '',
  subject varchar(100) NOT NULL default '',
  post text NOT NULL,
  PRIMARY KEY  (postid))
  TYPE=MyISAM AUTO_INCREMENT=5 ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);



$q1 = "DROP TABLE IF EXISTS counter";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE counter (
  visits bigint(20) NOT NULL default '0')
  TYPE=MyISAM ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "DROP TABLE IF EXISTS faq";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE faq (
  faqid int(10) unsigned NOT NULL auto_increment,
  question text NOT NULL,
  answer text NOT NULL,
  category varchar(100) NOT NULL default '',
  PRIMARY KEY  (faqid))
  TYPE=MyISAM AUTO_INCREMENT=3 ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "INSERT INTO faq VALUES (3, 'Am I allowed to have more than one account?', 'We only allow one advertiser and one member account per person.  You may have more than one account per household, however using the same IP will cause problems with our anti-cheating system.', 'General FAQs')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO faq VALUES (4, 'Do you allow International users?', 'Yes, we accept users and advertisers whose countries who are qualified to use PayPal. ', 'General FAQs')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO faq VALUES (5, 'Can I cancel my account?', 'Yes, please send a request to support if you wish to cancel your account. You must include your PayPal email address so we can verify your identity. Funds over $25 will be deposited to your PayPal account. Funds under the payout rate of $25 are non payable.', 'General FAQs')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO faq VALUES (1, 'What is PaidTo Click?', 'PaidTo Click, is an exciting opportunity that brings advertisers and consumers together. Advertisers can bid on links and post banners for members to review. Members then receive a rate per click rate that is predetermined by the advertiser. After a member clicks on that link and views the site for the advertiser determined amount of time, the member is credited that click amount.', 'General FAQs')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO faq VALUES (7, 'What advertising programs do you offer?', 'We offer two types of advertising programs. Pay-Per-Click and Banner Impressions.', 'Advertisers')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO faq VALUES (8, 'How are you different from other Paid-To-Surf programs?', 'Other paid to search programs run on an automated system where members can sign up and begin surfing.  However these programs use timed systems that refresh new sites without any interaction from the surfer. Therefore users can let the surfing program run without even being seated at a computer! These program also usually just offer a traffic exchange. Where we excel in Paid-To-Click is by requiring members to manually click on a website link. The link then opens in a new window and credit is not given to the member until the pre-determined amount of time for the credit has passed. Plus our anti-cheat system only allows one credit visit to a site per member.', 'Advertisers')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO faq VALUES (9, 'Who determines the prices for my website links?', 'All advertisers determine the payout rate for members clicking on their links. The more an advertiser bids the more clicks that link will receive. Plus advertisers have the option of purchasing features to make their links more noticeable such as Bolding and Italics.', 'Advertisers')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO faq VALUES (10, 'Who determines the pre-determined amount of time that a member must visit a site to receive credit?', 'Advertisers determine the amount of time they require a member to surf their site to receive credit. The times range from 1 second to 30 seconds.', 'Advertisers')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "DROP TABLE IF EXISTS faq_sections";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE faq_sections (
  cat_id int(10) unsigned NOT NULL auto_increment,
  name varchar(100) NOT NULL default '',
  PRIMARY KEY  (cat_id))
  TYPE=MyISAM AUTO_INCREMENT=2 ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "INSERT INTO faq_sections VALUES (2, 'General FAQs')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO faq_sections VALUES (3, 'Advertisers')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "DROP TABLE IF EXISTS faqs";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE faqs (
  faqid int(10) unsigned NOT NULL auto_increment,
  category varchar(60) NOT NULL default '',
  question text,
  answer text,
  PRIMARY KEY  (faqid))
  TYPE=MyISAM AUTO_INCREMENT=1 ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "DROP TABLE IF EXISTS links";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE links (
  linkid int(10) unsigned NOT NULL auto_increment,
  addr varchar(255) NOT NULL default '',
  username varchar(20) NOT NULL default '',
  title varchar(50) NOT NULL default '',
  total varchar(10) NOT NULL default '',
  perclick varchar(10) NOT NULL default '',
  hits int(10) NOT NULL default '0',
  bold tinyint(2) NOT NULL default '0',
  italic tinyint(1) NOT NULL default '0',
  timer int(10) NOT NULL default '0',
  status varchar(50) NOT NULL default '',
  owe varchar(15) NOT NULL default '',
  PRIMARY KEY  (linkid))
  TYPE=MyISAM AUTO_INCREMENT=5 ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "INSERT INTO links VALUES (5, 'www.turnkeyzone.com/demos/font', 'crash', 'Free Fonts', '99.98', '0.02', 2, 0, 0, 5, 'active', '0')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO links VALUES (6, 'www.turnkeyzone.com/demos/templates', 'crash', 'Custom Templates', '99.98', '0.02', 1, 0, 0, 5, 'active', '0')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO links VALUES (7, 'www.datacryp.com', 'crash', 'Data Encryption', '99.98', '0.02', 1, 0, 0, 5, 'active', '0')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO links VALUES (8, 'www.traffic-jam.ca', 'crash', 'Web Design', '99.98', '0.02', 1, 0, 0, 5, 'active', '0')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO links VALUES (9, 'www.casheer.com', 'crash', 'Casheer Payment\'s', '99.98', '0.02', 1, 0, 0, 5, 'active', '0')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO links VALUES (10, 'www.vinyl-dog.ca', 'crash', 'Vinyl-Dog Cartoons', '99.98', '0.02', 1, 0, 0, 5, 'active', '0')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO links VALUES (11, 'www.virtualmarketingcenter.com', 'crash', 'Website Marketing', '99.98', '0.02', 1, 0, 0, 5, 'active', '0')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO links VALUES (12, 'www.hypershack.com', 'crash', 'Reseller Hosting', '99.98', '0.02', 1, 0, 0, 5, 'active', '0')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);
$q1 = "INSERT INTO links VALUES (13, 'www.exitdevil.com', 'crash', 'Free Traffic', '99.98', '0.02', 1, 0, 0, 5, 'active', '0')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);




$q1 = "DROP TABLE IF EXISTS main";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE main (
  username varchar(50) NOT NULL default '',
  password varchar(50) NOT NULL default '',
  title varchar(75) NOT NULL default '',
  baseurl varchar(100) NOT NULL default '',
  rooturl varchar(100) NOT NULL default '',
  adminemail varchar(100) NOT NULL default '',
  newsemail varchar(100) NOT NULL default '',
  paypalemail varchar(100) NOT NULL default '',
  linkcharge varchar(50) NOT NULL default '',
  bannercharge varchar(50) NOT NULL default '',
  withdraw varchar(50) NOT NULL default '',
  bold varchar(50) NOT NULL default '',
  italic varchar(50) NOT NULL default '',
  referral varchar(50) NOT NULL default '',
  PRIMARY KEY  (username))
  TYPE=MyISAM";
 
 
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

//EDITED - KH 4/5/2007


$q1 = "DROP TABLE IF EXISTS n_ban";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE n_ban (
  banid int(10) NOT NULL auto_increment,
  username varchar(50) NOT NULL default '',
  title varchar(100) NOT NULL default '',
  banname varchar(100) NOT NULL default '',
  date varchar(50) NOT NULL default '',
  status varchar(25) NOT NULL default '',
  addr varchar(200) NOT NULL default '',
  views int(10) NOT NULL default '0',
  PRIMARY KEY  (banid))
  TYPE=MyISAM AUTO_INCREMENT=3 ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "DROP TABLE IF EXISTS newl";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE newl (
  linkid int(10) unsigned NOT NULL auto_increment,
  fname varchar(50) NOT NULL default '',
  lname varchar(50) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  username varchar(20) NOT NULL default '',
  password varchar(20) NOT NULL default '',
  PRIMARY KEY  (linkid))
  TYPE=MyISAM AUTO_INCREMENT=6 ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

//EDITED - KH 4/5/2007


$q1 = "DROP TABLE IF EXISTS pages";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE pages (
  page varchar(50) NOT NULL default '',
  p_content longtext NOT NULL,
  title varchar(100) NOT NULL default '')
  TYPE=MyISAM";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "DROP TABLE IF EXISTS payment";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE payment (
  payid int(10) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  amount varchar(10) NOT NULL default '',
  date varchar(15) NOT NULL default '',
  reason varchar(50) NOT NULL default '',
  PRIMARY KEY  (payid))
  TYPE=MyISAM AUTO_INCREMENT=3 ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "INSERT INTO payment VALUES (3, 'crash', '1000000000', '10/31/2003', 'Test Account for starter links')";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "DROP TABLE IF EXISTS users";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE users (
  userid int(10) unsigned NOT NULL auto_increment,
  fname varchar(50) NOT NULL default '',
  lname varchar(50) NOT NULL default '',
  name varchar(20) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  password varchar(20) NOT NULL default '',
  earned varchar(20) NOT NULL default '',
  visited longtext NOT NULL,
  refer varchar(100) NOT NULL default '',
  joined varchar(25) NOT NULL default '',
  PRIMARY KEY  (userid))
  TYPE=MyISAM AUTO_INCREMENT=7 ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


$q1 = "DROP TABLE IF EXISTS withdraw";
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);

$q1 = "CREATE TABLE withdraw (
  wid int(10) unsigned NOT NULL auto_increment,
  user varchar(25) NOT NULL default '',
  method varchar(25) NOT NULL default '',
  account varchar(100) NOT NULL default '',
  amount varchar(15) NOT NULL default '',
  date varchar(25) NOT NULL default '',
  status varchar(25) NOT NULL default '',
  PRIMARY KEY  (wid))
  TYPE=MyISAM AUTO_INCREMENT=2 ";
 
mysql_query($q1) or die(mysql_error()." at line ".__LINE__);


echo "<br><br><center><font face=verdana size=2 color=black><b>The site was installed successfully!<br><br>Delete this file from your server!</b><br><P>Visit your admin area to moderate your site:<BR><a href=\"control/\"> Site Admin</a><BR><P></font></center>";


?>