Jump to content

[SOLVED] install not working?

adamlacombe

By adamlacombe
in PHP Coding Help

 Share

Recommended Posts

adamlacombe Member

adamlacombe

Posted
Posted

I have an install file but the form won't show.

I remove everything but the form and it shows.

This is what I have:

<?php
if($_POST['submit']){

mysql_connect("LOCALHOST", "USER", "PASS") or die(mysql_error());
mysql_select_db("DB") or die(mysql_error());

$sitename = $_POST['sitename'];
$url = $_POST['url'];
$theme = $_POST['theme'];
$id = $_POST['id'];
$status = $_POST['status'];



mysql_query("CREATE TABLE IF NOT EXISTS `comments` (
  `com_id` int(11) NOT NULL auto_increment,
  `page_id` int(11) NOT NULL default '0',
  `com_name` varchar(50) NOT NULL default '',
  `com_comment` text NOT NULL,
  `com_cat` varchar(10) NOT NULL default '',
  `com_date` int(11) NOT NULL default '0',
  `ip` varchar(255) NOT NULL,
  PRIMARY KEY  (`com_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3302;");


mysql_query("CREATE TABLE IF NOT EXISTS `favorites` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `pageid` bigint(11) NOT NULL,
  `pagecat` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31;");

mysql_query("CREATE TABLE IF NOT EXISTS `feedback` (
  `fb_id` int(11) NOT NULL auto_increment,
  `fb_email` varchar(50) NOT NULL default '',
  `fb_message` text NOT NULL,
  `fb_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fb_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10;");

mysql_query("CREATE TABLE IF NOT EXISTS `game` (
  `game_id` int(11) NOT NULL auto_increment,
  `game_name` varchar(150) NOT NULL default '',
  `game_link` varchar(888) NOT NULL,
  `game_thumb` varchar(255) NOT NULL,
  `game_des` text NOT NULL,
  `game_cat` varchar(100) NOT NULL default '',
  `game_type` varchar(255) NOT NULL,
  `game_views` int(11) NOT NULL default '0',
  PRIMARY KEY  (`game_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=583;");


mysql_query("INSERT INTO `game` (`game_id`, `game_name`, `game_link`, `game_thumb`, `game_des`, `game_cat`, `game_type`, `game_views`) VALUES
(1, 'Drag Racer V3', 'http://toxicflash.com/swf/f-619.swf', 'http://arcadecredits.com/thumbs/1.gif', '', 'racing', 'e', 27),
(2, 'Stunt Pilot', 'stuntpilot.swf', 'stuntpilotmedicon.jpg', 'Be the best Stunt Pilot and complete all the courses without crashing!', 'action', 'h', 10),
(3, 'Doomland 2154', 'doomland_con.swf', 'Doomland 2154.jpg', 'Shoot em up time crisis style in this amazing 3d shooter, Doomland 2154.', 'shooter', 'h', 3),
(4, 'Big Truck Adventures 2', 'bigtruckadventures2-swf.swf', 'Big Truck Adventures 2.jpg', '', 'racing', 'h', 48),
(5, 'Happy Tree Friends: Flippy Attack', 'Flippy Attack.swf', 'Flippy Attack.png', 'The objective of this game is simple. Stay alive as long as possible. Using characters from Happy Tree Friends.', 'Action', 'h', 14),
(6, 'Hamster Ball', 'hamsterball.swf', 'Hamster Ball.jpg', 'The objective of the game is to move the hamsterball to the orange flag and stop there as quickly as possible. Make sure you avoid the spikes and pitfalls so the poor hamster dosent die. Make sure you collect the stars on the way! Enjoy!', 'Adventure', 'h', 2);");


mysql_query("CREATE TABLE IF NOT EXISTS `game_cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10;");

mysql_query("INSERT INTO `game_cat` (`cat_id`, `cat_name`) VALUES
(1, 'Action'),
(2, 'Adventure'),
(3, 'Racing'),
(4, 'Shooter');");


mysql_query("CREATE TABLE IF NOT EXISTS `joke` (
  `joke_id` int(11) NOT NULL auto_increment,
  `joke_name` varchar(150) NOT NULL default '',
  `joke_joke` text NOT NULL,
  `joke_cat` varchar(50) NOT NULL default '',
  `joke_by` varchar(255) NOT NULL,
  `joke_view` int(11) NOT NULL default '0',
  `joke_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`joke_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=176;");



mysql_query("INSERT INTO `joke` (`joke_id`, `joke_name`, `joke_joke`, `joke_cat`, `joke_by`) VALUES
(1, 'GM vs. Microsoft', 'At a recent computer expo (COMDEX), Bill Gates reportedly compared the computer industry with the auto industry and stated: "If GM had kept up with technology like the computer industry has, we would all be driving twenty-five dollar cars that got 1000 miles to the gallon." In response to Bill''s comments, General Motors issued a press release stating (by Mr Welch himself): If GM had developed technology like Microsoft, we would all be driving cars with the following characteristics:\r<br />1. For no reason whatsoever your car would crash twice a day.\r<br />2. Every time they repainted the lines on the road you would have to buy a new car.\r<br />3. Occasionally your car would die on the freeway for no reason, and you would just accept this, restart and drive on.\r<br />4. Occasionally, executing a maneuver such as a left turn, would cause your car to shut down and refuse to restart, in which case you would have to reinstall the engine.\r<br />5. Only one person at a time could use the car, unless you bought "Car95" or "CarNT." But then you would have to buy more seats.\r<br />6. Macintosh would make a car that was powered by the sun, reliable, five times as fast, and twice as easy to drive, but would only run on five per cent of the roads.\r<br />7. The oil, water temperature and alternator warning lights would be replaced by a single "general car default" warning light.\r<br />8. New seats would force everyone to have the same size butt.\r<br />9. The airbag system would say "Are you sure?" before going off.\r<br />10. Occasionally for no reason whatsoever, your car would lock you out and refuse to let you in until you simultaneously lifted the door handle, turned the key, and grab hold of the radio antenna.\r<br />11. GM would require all car buyers to also purchase a deluxe set of Rand McNally road maps (now a GM subsidiary), even though they neither need them nor want them. Attempting to delete this option would immediately cause the car''s performance to diminish by 50% or more. Moreover, GM would become a target for investigation by the Justice Department.\r<br />12. Every time GM introduced a new model car buyers would have to learn how to drive all over again because none of the controls would operate in the same manner as the old car.\r<br />13. You''d press the "start" button to shut off the engine. ', 'Computer Jokes', 'Admin'),
(2, 'Whos in the Trees?', 'A brunette, a redhead and a blonde were in the wilderness chased by police and their dogs. They got tired running so they each climbed a tree.\r\n<br />The police dogs came and started barking on a tree with the brunette on it. The brunette cried "COOO COOO" The police said it''s just a pigeon up there. The dogs then barked on a tree with the redhead on it. The redhead cried "HOOO HOOO" The police said it''s just an owl up there. The dogs then came to the tree with the blonde on it. The blond cried "MOOO MOOO".', 'Blonde Jokes', 'Admin');");

mysql_query("CREATE TABLE IF NOT EXISTS `joke_cat` (
  `jokecat_id` int(11) NOT NULL auto_increment,
  `jokecat_cat` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`jokecat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19;");



mysql_query("INSERT INTO `joke_cat` (`jokecat_id`, `jokecat_cat`) VALUES
(1, 'Adult Jokes'),
(2, 'Animal Jokes'),
(3, 'Bar Jokes'),
(4, 'Blonde Jokes'),
(5, 'Computer Jokes'),
(6, 'Dirty Jokes'),
(8, 'Funny Quotes'),
(9, 'Knock Knock Jokes'),
(10, 'Lawyer Jokes'),
(11, 'Medical Jokes'),
(12, 'Misc Jokes'),
(13, 'Redneck Jokes'),
(14, 'Relationship Jokes'),
(15, 'Religious Jokes'),
(16, 'Yo Mama Jokes');");


mysql_query("CREATE TABLE IF NOT EXISTS `pm` (
  `id` bigint(20) NOT NULL auto_increment,
  `from` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `parentid` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8;");

mysql_query("CREATE TABLE IF NOT EXISTS `settings` (
  `id` varchar(2) NOT NULL,
  `sitename` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `topads` text NOT NULL,
  `bottomads` text NOT NULL,
  `theme` varchar(255) NOT NULL,
  `rpp` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;");


		mysql_query("INSERT INTO settings SET 
					url='$url',
					id='1',
					status='online',
					theme='$theme',
					sitename='$sitename'") or die(mysql_error());



mysql_query("CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(10) NOT NULL default '2',
  `status` varchar(255) NOT NULL,
  `gameplays` int(11) NOT NULL default '0',
  `first` varchar(32) NOT NULL,
  `last` varchar(32) NOT NULL,
  `username` varchar(32) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `avatar` varchar(255) NOT NULL default 'default.gif',
  `location` varchar(255) NOT NULL,
  `myspace` varchar(255) NOT NULL,
  `aim` varchar(255) NOT NULL,
  `yim` varchar(255) NOT NULL,
  `about` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6;");



mysql_query("INSERT INTO `users` (`id`, `type`, `status`, `gameplays`, `first`, `last`, `username`, `password`, `email`, `avatar`, `location`, `myspace`, `aim`, `yim`, `about`) VALUES

(1, '1', 'offline', 0, 'billy', 'bob', 'admin', '21232f297a57a5a743894a0e4a801fc3', '', 'default.gif', '', '', '', '', 'I am the admin!....');");




mysql_query("CREATE TABLE IF NOT EXISTS `video_cat` (
  `vid_id` int(11) NOT NULL auto_increment,
  `vid_cat` varchar(250) NOT NULL default '',
  `vid_count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vid_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8;");


mysql_query("INSERT INTO `video_cat` (`vid_id`, `vid_cat`) VALUES
(1, 'autos'),
(2, 'comedy'),
(3, 'sports'),
(4, 'music'),
(5, 'education'),
(6, 'news');");


mysql_query("CREATE TABLE IF NOT EXISTS `video` (
  `video_id` int(11) NOT NULL auto_increment,
  `video_name` varchar(250) NOT NULL default '',
  `video_link` varchar(250) NOT NULL default '',
  `video_des` text NOT NULL,
  `video_cat` varchar(50) NOT NULL default '',
  `video_views` int(11) NOT NULL default '0',
  `video_by` varchar(255) NOT NULL,
  PRIMARY KEY  (`video_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56;");



mysql_query("INSERT INTO `video` (`video_id`, `video_name`, `video_link`, `video_des`, `video_cat`, `video_views`, `video_by`) VALUES
(1, 'Numa Numa', '60og9gwKh1o', '', 'Comedy', 248, ''),
(2, 'Shrek Karaoke', 'gknjvqdB_1M', '', 'Music', 82, ''),
(3, 'Eminem - Beautiful', 'pCzRei9-42s', '', 'music', 26, 'admin'),
(4, 'Call of Duty: Modern Warfare 2 Trailer', 'P7vyLDEwF5I', '', 'news', 15, 'admin'),
(5, 'Michael Jackson - Billie Jean', 'CaAD7EizAfw', '', 'music', 16, 'admin'),
(6, 'Michael Jackson - Beat It', 'jyCiNAgfcUs', '', 'music', 11, 'admin'),
(7, 'sponge bob - pump it', 'fYIeLApUUlI', 'music video for sponge bob pump it by black eyed peas', 'music', 2, 'Admin'),
(8, 'Spongebob We Will Rock You', 'OkrMnu9k4-A', 'Spongebob and his friends singin'' We Will Rock You, from Queen', 'music', 8, 'Admin'),
(9, 'Michael Jackson - They Dont Really Care About Us', 'ZPFFDSChedY', 'The last song he preformed before his death.', '', 30, 'Admin');



mysql_query("CREATE TABLE IF NOT EXISTS `vote` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `pageid` int(11) default NULL,
  `pagecat` varchar(255) NOT NULL,
  `rating` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16;");



	echo '<div class="done">Updated.</div><br />
	Please delete the install.php file. <br /><br />Username: __ Password: __<br />
	These are to login to the admin panel (default admin account). CHANGE THEM ASAP!!! ';
	exit;

}else{


echo "<form action='install.php' method='POST'>

		<div class='header'>Settings</div>
Site Name:<br />	
<input type='text' name='sitename' size='40'><br />

Domain:	
<input type='text' name='url' size='40' value='http://'><br />

Theme:
<input type='text' name='theme' size='40' value='default' readonly><br />

<input type='submit' name='submit' value='Install Media Script!'>
</form>";
}
?>

 

When I go to the page there's no errors, no form, no nothing.

 

Any ideas?

 

Thanks In advanced!

Link to comment
Share on other sites
adamlacombe Member

adamlacombe

Posted
  • Author
Posted

Maybe I should have this topic moved to mysql help?

 

I got the form to show but i get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

 

and the file now looks like this:

<?php
include ('includes/db.php');

if(isset($_POST['submit'])){

   $sitename = $_POST['sitename'];
   $url = $_POST['url'];
   $theme = $_POST['theme'];
   


mysql_query("CREATE TABLE IF NOT EXISTS `comments` (
  `com_id` int(11) NOT NULL auto_increment,
  `page_id` int(11) NOT NULL default '0',
  `com_name` varchar(50) NOT NULL default '',
  `com_comment` text NOT NULL,
  `com_cat` varchar(10) NOT NULL default '',
  `com_date` int(11) NOT NULL default '0',
  `ip` varchar(255) NOT NULL,
  PRIMARY KEY  (`com_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3302 ;");


mysql_query("CREATE TABLE IF NOT EXISTS `favorites` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `pageid` bigint(11) NOT NULL,
  `pagecat` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;");

mysql_query("CREATE TABLE IF NOT EXISTS `feedback` (
  `fb_id` int(11) NOT NULL auto_increment,
  `fb_email` varchar(50) NOT NULL default '',
  `fb_message` text NOT NULL,
  `fb_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fb_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;");

mysql_query("CREATE TABLE IF NOT EXISTS `game` (
  `game_id` int(11) NOT NULL auto_increment,
  `game_name` varchar(150) NOT NULL default '',
  `game_link` varchar(888) NOT NULL,
  `game_thumb` varchar(255) NOT NULL,
  `game_des` text NOT NULL,
  `game_cat` varchar(100) NOT NULL default '',
  `game_type` varchar(255) NOT NULL,
  `game_views` int(11) NOT NULL default '0',
  PRIMARY KEY  (`game_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=583 ;");


mysql_query("INSERT INTO `game` (`game_id`, `game_name`, `game_link`, `game_thumb`, `game_des`, `game_cat`, `game_type`, `game_views`) VALUES
(1, 'Drag Racer V3', 'http://toxicflash.com/swf/f-619.swf', 'http://arcadecredits.com/thumbs/1.gif', '', 'racing', 'e', 27),
(2, 'Stunt Pilot', 'stuntpilot.swf', 'stuntpilotmedicon.jpg', 'Be the best Stunt Pilot and complete all the courses without crashing!', 'action', 'h', 10),
(3, 'Doomland 2154', 'doomland_con.swf', 'Doomland 2154.jpg', 'Shoot em up time crisis style in this amazing 3d shooter, Doomland 2154.', 'shooter', 'h', 3),
(4, 'Big Truck Adventures 2', 'bigtruckadventures2-swf.swf', 'Big Truck Adventures 2.jpg', '', 'racing', 'h', 48),
(5, 'Happy Tree Friends: Flippy Attack', 'Flippy Attack.swf', 'Flippy Attack.png', 'The objective of this game is simple. Stay alive as long as possible. Using characters from Happy Tree Friends.', 'Action', 'h', 14),
(6, 'Hamster Ball', 'hamsterball.swf', 'Hamster Ball.jpg', 'The objective of the game is to move the hamsterball to the orange flag and stop there as quickly as possible. Make sure you avoid the spikes and pitfalls so the poor hamster dosent die. Make sure you collect the stars on the way! Enjoy!', 'Adventure', 'h', '2'");



mysql_query("CREATE TABLE IF NOT EXISTS `game_cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;");


mysql_query("INSERT INTO `game_cat` (`cat_id`, `cat_name`) VALUES
(1, 'Action'),
(2, 'Adventure'),
(3, 'Racing'),
(4, 'Shooter'");




mysql_query("CREATE TABLE IF NOT EXISTS `joke` (
  `joke_id` int(11) NOT NULL auto_increment,
  `joke_name` varchar(150) NOT NULL default '',
  `joke_joke` text NOT NULL,
  `joke_cat` varchar(50) NOT NULL default '',
  `joke_by` varchar(255) NOT NULL,
  `joke_view` int(11) NOT NULL default '0',
  `joke_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`joke_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=176 ;");


mysql_query("CREATE TABLE IF NOT EXISTS `joke_cat` (
  `jokecat_id` int(11) NOT NULL auto_increment,
  `jokecat_cat` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`jokecat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;");

mysql_query("INSERT INTO `joke_cat` (`jokecat_id`, `jokecat_cat`) VALUES
(1, 'Adult Jokes'),
(2, 'Animal Jokes'),
(3, 'Bar Jokes'),
(4, 'Blonde Jokes'),
(5, 'Computer Jokes'),
(6, 'Dirty Jokes'),
(8, 'Funny Quotes'),
(9, 'Knock Knock Jokes'),
(10, 'Lawyer Jokes'),
(11, 'Medical Jokes'),
(12, 'Misc Jokes'),
(13, 'Redneck Jokes'),
(14, 'Relationship Jokes'),
(15, 'Religious Jokes'),
(16, 'Yo Mama Jokes'");


mysql_query("CREATE TABLE IF NOT EXISTS `pm` (
  `id` bigint(20) NOT NULL auto_increment,
  `from` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `parentid` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;");

mysql_query("CREATE TABLE IF NOT EXISTS `settings` (
  `id` varchar(2) NOT NULL,
  `sitename` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `topads` text NOT NULL,
  `bottomads` text NOT NULL,
  `theme` varchar(255) NOT NULL,
  `rpp` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;");


       mysql_query("INSERT INTO settings SET 
                url='$url',
                id='1',
                status='online',
                theme='$theme',
                sitename='$sitename'") or die(mysql_error());



mysql_query("CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(10) NOT NULL default '2',
  `status` varchar(255) NOT NULL,
  `gameplays` int(11) NOT NULL default '0',
  `first` varchar(32) NOT NULL,
  `last` varchar(32) NOT NULL,
  `username` varchar(32) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `avatar` varchar(255) NOT NULL default 'default.gif',
  `location` varchar(255) NOT NULL,
  `myspace` varchar(255) NOT NULL,
  `aim` varchar(255) NOT NULL,
  `yim` varchar(255) NOT NULL,
  `about` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;");

mysql_query("INSERT INTO `users` (`id`, `type`, `status`, `gameplays`, `first`, `last`, `username`, `password`, `avatar`, `about`) VALUES

(1, '1', 'offline', 0, 'billy', 'bob', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'default.gif', 'I am the admin!....'") or die(mysql_error());



mysql_query("CREATE TABLE IF NOT EXISTS `video_cat` (
  `vid_id` int(11) NOT NULL auto_increment,
  `vid_cat` varchar(250) NOT NULL default '',
  `vid_count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vid_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;");

mysql_query("INSERT INTO `video_cat` (`vid_id`, `vid_cat`) VALUES
(1, 'autos'),
(2, 'comedy'),
(3, 'sports'),
(4, 'music'),
(5, 'education'),
(6, 'news'");



mysql_query("CREATE TABLE IF NOT EXISTS `video` (
  `video_id` int(11) NOT NULL auto_increment,
  `video_name` varchar(250) NOT NULL default '',
  `video_link` varchar(250) NOT NULL default '',
  `video_des` text NOT NULL,
  `video_cat` varchar(50) NOT NULL default '',
  `video_views` int(11) NOT NULL default '0',
  `video_by` varchar(255) NOT NULL,
  PRIMARY KEY  (`video_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;");


mysql_query("INSERT INTO `video` (`video_id`, `video_name`, `video_link`, `video_des`, `video_cat`, `video_views`, `video_by`) VALUES
(1, 'Numa Numa', '60og9gwKh1o', '', 'Comedy', 248, ''),
(2, 'Shrek Karaoke', 'gknjvqdB_1M', '', 'Music', 82, ''),
(3, 'Eminem - Beautiful', 'pCzRei9-42s', '', 'music', 26, 'admin'),
(4, 'Call of Duty: Modern Warfare 2 Trailer', 'P7vyLDEwF5I', '', 'news', 15, 'admin'),
(5, 'Michael Jackson - Billie Jean', 'CaAD7EizAfw', '', 'music', 16, 'admin'),
(6, 'Michael Jackson - Beat It', 'jyCiNAgfcUs', '', 'music', 11, 'admin'),
(7, 'sponge bob - pump it', 'fYIeLApUUlI', 'music video for sponge bob pump it by black eyed peas', 'music', 2, 'Admin'),
(8, 'Spongebob We Will Rock You', 'OkrMnu9k4-A', 'Spongebob and his friends singin We Will Rock You, from Queen', 'music', 8, 'Admin'),
(9, 'Michael Jackson - They Dont Really Care About Us', 'ZPFFDSChedY', 'The last song he preformed before his death.', '', 30, 'Admin'");




mysql_query("CREATE TABLE IF NOT EXISTS `vote` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `pageid` int(11) default NULL,
  `pagecat` varchar(255) NOT NULL,
  `rating` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;");



      echo '<div class="done">Updated.</div><br />
      Please delete the install.php file. <br /><br />Username: __ Password: __<br />
      These are to login to the admin panel (default admin account). CHANGE THEM ASAP!!! ';
      exit;
   
}


echo "<form action='install.php' method='POST'>

         <div class='header'>Settings</div>
   Site Name:<br />   
   <input type='text' name='sitename' size='40'><br />

   Domain:   
   <input type='text' name='url' size='40' value='http://'><br />
         
   Theme:
   <input type='text' name='theme' size='40' value='default' readonly><br />

   <input type='submit' name='submit' value='Install Media Script!'>
   </form>";
?>

Link to comment
Share on other sites
Stuie_b Newbie

Stuie_b

Posted
Posted

Your insert queries are incomplete! You dont seem to end any of your insert queries...

 

<?php
include ('includes/db.php');

if(isset($_POST['submit'])){

   $sitename = $_POST['sitename'];
   $url = $_POST['url'];
   $theme = $_POST['theme'];
   


mysql_query("CREATE TABLE IF NOT EXISTS `comments` (
  `com_id` int(11) NOT NULL auto_increment,
  `page_id` int(11) NOT NULL default '0',
  `com_name` varchar(50) NOT NULL default '',
  `com_comment` text NOT NULL,
  `com_cat` varchar(10) NOT NULL default '',
  `com_date` int(11) NOT NULL default '0',
  `ip` varchar(255) NOT NULL,
  PRIMARY KEY  (`com_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3302 ;");


mysql_query("CREATE TABLE IF NOT EXISTS `favorites` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `pageid` bigint(11) NOT NULL,
  `pagecat` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;");

mysql_query("CREATE TABLE IF NOT EXISTS `feedback` (
  `fb_id` int(11) NOT NULL auto_increment,
  `fb_email` varchar(50) NOT NULL default '',
  `fb_message` text NOT NULL,
  `fb_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fb_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;");

mysql_query("CREATE TABLE IF NOT EXISTS `game` (
  `game_id` int(11) NOT NULL auto_increment,
  `game_name` varchar(150) NOT NULL default '',
  `game_link` varchar(888) NOT NULL,
  `game_thumb` varchar(255) NOT NULL,
  `game_des` text NOT NULL,
  `game_cat` varchar(100) NOT NULL default '',
  `game_type` varchar(255) NOT NULL,
  `game_views` int(11) NOT NULL default '0',
  PRIMARY KEY  (`game_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=583 ;");


//Game query missing ); at end of query
mysql_query("INSERT INTO `game` (`game_id`, `game_name`, `game_link`, `game_thumb`, `game_des`, `game_cat`, `game_type`, `game_views`) VALUES
(1, 'Drag Racer V3', 'http://toxicflash.com/swf/f-619.swf', 'http://arcadecredits.com/thumbs/1.gif', '', 'racing', 'e', 27),
(2, 'Stunt Pilot', 'stuntpilot.swf', 'stuntpilotmedicon.jpg', 'Be the best Stunt Pilot and complete all the courses without crashing!', 'action', 'h', 10),
(3, 'Doomland 2154', 'doomland_con.swf', 'Doomland 2154.jpg', 'Shoot em up time crisis style in this amazing 3d shooter, Doomland 2154.', 'shooter', 'h', 3),
(4, 'Big Truck Adventures 2', 'bigtruckadventures2-swf.swf', 'Big Truck Adventures 2.jpg', '', 'racing', 'h', 48),
(5, 'Happy Tree Friends: Flippy Attack', 'Flippy Attack.swf', 'Flippy Attack.png', 'The objective of this game is simple. Stay alive as long as possible. Using characters from Happy Tree Friends.', 'Action', 'h', 14),
(6, 'Hamster Ball', 'hamsterball.swf', 'Hamster Ball.jpg', 'The objective of the game is to move the hamsterball to the orange flag and stop there as quickly as possible. Make sure you avoid the spikes and pitfalls so the poor hamster dosent die. Make sure you collect the stars on the way! Enjoy!', 'Adventure', 'h', '2');");



mysql_query("CREATE TABLE IF NOT EXISTS `game_cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;");

//Game_cat query missing ); at end of query
mysql_query("INSERT INTO `game_cat` (`cat_id`, `cat_name`) VALUES
(1, 'Action'),
(2, 'Adventure'),
(3, 'Racing'),
(4, 'Shooter');");




mysql_query("CREATE TABLE IF NOT EXISTS `joke` (
  `joke_id` int(11) NOT NULL auto_increment,
  `joke_name` varchar(150) NOT NULL default '',
  `joke_joke` text NOT NULL,
  `joke_cat` varchar(50) NOT NULL default '',
  `joke_by` varchar(255) NOT NULL,
  `joke_view` int(11) NOT NULL default '0',
  `joke_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`joke_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=176 ;");


mysql_query("CREATE TABLE IF NOT EXISTS `joke_cat` (
  `jokecat_id` int(11) NOT NULL auto_increment,
  `jokecat_cat` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`jokecat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;");

//joke_cat query missing ); at end of query
mysql_query("INSERT INTO `joke_cat` (`jokecat_id`, `jokecat_cat`) VALUES
(1, 'Adult Jokes'),
(2, 'Animal Jokes'),
(3, 'Bar Jokes'),
(4, 'Blonde Jokes'),
(5, 'Computer Jokes'),
(6, 'Dirty Jokes'),
(8, 'Funny Quotes'),
(9, 'Knock Knock Jokes'),
(10, 'Lawyer Jokes'),
(11, 'Medical Jokes'),
(12, 'Misc Jokes'),
(13, 'Redneck Jokes'),
(14, 'Relationship Jokes'),
(15, 'Religious Jokes'),
(16, 'Yo Mama Jokes');");


mysql_query("CREATE TABLE IF NOT EXISTS `pm` (
  `id` bigint(20) NOT NULL auto_increment,
  `from` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `parentid` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;");

mysql_query("CREATE TABLE IF NOT EXISTS `settings` (
  `id` varchar(2) NOT NULL,
  `sitename` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `topads` text NOT NULL,
  `bottomads` text NOT NULL,
  `theme` varchar(255) NOT NULL,
  `rpp` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;");

//settings query missing ); at end of query
       mysql_query("INSERT INTO settings SET 
                url='$url',
                id='1',
                status='online',
                theme='$theme',
                sitename='$sitename');") or die(mysql_error());



mysql_query("CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(10) NOT NULL default '2',
  `status` varchar(255) NOT NULL,
  `gameplays` int(11) NOT NULL default '0',
  `first` varchar(32) NOT NULL,
  `last` varchar(32) NOT NULL,
  `username` varchar(32) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `avatar` varchar(255) NOT NULL default 'default.gif',
  `location` varchar(255) NOT NULL,
  `myspace` varchar(255) NOT NULL,
  `aim` varchar(255) NOT NULL,
  `yim` varchar(255) NOT NULL,
  `about` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;");

//users query missing ); at end of query
mysql_query("INSERT INTO `users` (`id`, `type`, `status`, `gameplays`, `first`, `last`, `username`, `password`, `avatar`, `about`) VALUES

(1, '1', 'offline', 0, 'billy', 'bob', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'default.gif', 'I am the admin!....');") or die(mysql_error());



mysql_query("CREATE TABLE IF NOT EXISTS `video_cat` (
  `vid_id` int(11) NOT NULL auto_increment,
  `vid_cat` varchar(250) NOT NULL default '',
  `vid_count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vid_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;");

//video_cat query missing ); at end of query
mysql_query("INSERT INTO `video_cat` (`vid_id`, `vid_cat`) VALUES
(1, 'autos'),
(2, 'comedy'),
(3, 'sports'),
(4, 'music'),
(5, 'education'),
(6, 'news');");



mysql_query("CREATE TABLE IF NOT EXISTS `video` (
  `video_id` int(11) NOT NULL auto_increment,
  `video_name` varchar(250) NOT NULL default '',
  `video_link` varchar(250) NOT NULL default '',
  `video_des` text NOT NULL,
  `video_cat` varchar(50) NOT NULL default '',
  `video_views` int(11) NOT NULL default '0',
  `video_by` varchar(255) NOT NULL,
  PRIMARY KEY  (`video_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;");

//video query missing ); at end of query
mysql_query("INSERT INTO `video` (`video_id`, `video_name`, `video_link`, `video_des`, `video_cat`, `video_views`, `video_by`) VALUES
(1, 'Numa Numa', '60og9gwKh1o', '', 'Comedy', 248, ''),
(2, 'Shrek Karaoke', 'gknjvqdB_1M', '', 'Music', 82, ''),
(3, 'Eminem - Beautiful', 'pCzRei9-42s', '', 'music', 26, 'admin'),
(4, 'Call of Duty: Modern Warfare 2 Trailer', 'P7vyLDEwF5I', '', 'news', 15, 'admin'),
(5, 'Michael Jackson - Billie Jean', 'CaAD7EizAfw', '', 'music', 16, 'admin'),
(6, 'Michael Jackson - Beat It', 'jyCiNAgfcUs', '', 'music', 11, 'admin'),
(7, 'sponge bob - pump it', 'fYIeLApUUlI', 'music video for sponge bob pump it by black eyed peas', 'music', 2, 'Admin'),
(8, 'Spongebob We Will Rock You', 'OkrMnu9k4-A', 'Spongebob and his friends singin We Will Rock You, from Queen', 'music', 8, 'Admin'),
(9, 'Michael Jackson - They Dont Really Care About Us', 'ZPFFDSChedY', 'The last song he preformed before his death.', '', 30, 'Admin');");




mysql_query("CREATE TABLE IF NOT EXISTS `vote` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `pageid` int(11) default NULL,
  `pagecat` varchar(255) NOT NULL,
  `rating` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;");



      echo '<div class="done">Updated.</div><br />
      Please delete the install.php file. <br /><br />Username: __ Password: __<br />
      These are to login to the admin panel (default admin account). CHANGE THEM ASAP!!! ';
      exit;
   
}


echo "<form action='install.php' method='POST'>

         <div class='header'>Settings</div>
   Site Name:<br />   
   <input type='text' name='sitename' size='40'><br />

   Domain:   
   <input type='text' name='url' size='40' value='http://'><br />
         
   Theme:
   <input type='text' name='theme' size='40' value='default' readonly><br />

   <input type='submit' name='submit' value='Install Media Script!'>
   </form>";
?>

 

i've made the changes and placed a comment at the incorrect queries,

 

Stuie

Link to comment
Share on other sites
manny Newbie

manny

Posted
Posted

Try this code...

<?php
include ('includes/db.php');

if(isset($_POST['submit'])){

   $sitename = $_POST['sitename'];
   $url = $_POST['url'];
   $theme = $_POST['theme'];
   


mysql_query("CREATE TABLE IF NOT EXISTS `comments` (
  `com_id` int(11) NOT NULL auto_increment,
  `page_id` int(11) NOT NULL default '0',
  `com_name` varchar(50) NOT NULL default '',
  `com_comment` text NOT NULL,
  `com_cat` varchar(10) NOT NULL default '',
  `com_date` int(11) NOT NULL default '0',
  `ip` varchar(255) NOT NULL,
  PRIMARY KEY  (`com_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3302 ;");


mysql_query("CREATE TABLE IF NOT EXISTS `favorites` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `pageid` bigint(11) NOT NULL,
  `pagecat` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;");

mysql_query("CREATE TABLE IF NOT EXISTS `feedback` (
  `fb_id` int(11) NOT NULL auto_increment,
  `fb_email` varchar(50) NOT NULL default '',
  `fb_message` text NOT NULL,
  `fb_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fb_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;");

mysql_query("CREATE TABLE IF NOT EXISTS `game` (
  `game_id` int(11) NOT NULL auto_increment,
  `game_name` varchar(150) NOT NULL default '',
  `game_link` varchar(888) NOT NULL,
  `game_thumb` varchar(255) NOT NULL,
  `game_des` text NOT NULL,
  `game_cat` varchar(100) NOT NULL default '',
  `game_type` varchar(255) NOT NULL,
  `game_views` int(11) NOT NULL default '0',
  PRIMARY KEY  (`game_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=583 ;");


//Game query missing ); at end of query
mysql_query("INSERT INTO `game` (`game_id`, `game_name`, `game_link`, `game_thumb`, `game_des`, `game_cat`, `game_type`, `game_views`) VALUES
(1, 'Drag Racer V3', 'http://toxicflash.com/swf/f-619.swf', 'http://arcadecredits.com/thumbs/1.gif', '', 'racing', 'e', 27),
(2, 'Stunt Pilot', 'stuntpilot.swf', 'stuntpilotmedicon.jpg', 'Be the best Stunt Pilot and complete all the courses without crashing!', 'action', 'h', 10),
(3, 'Doomland 2154', 'doomland_con.swf', 'Doomland 2154.jpg', 'Shoot em up time crisis style in this amazing 3d shooter, Doomland 2154.', 'shooter', 'h', 3),
(4, 'Big Truck Adventures 2', 'bigtruckadventures2-swf.swf', 'Big Truck Adventures 2.jpg', '', 'racing', 'h', 48),
(5, 'Happy Tree Friends: Flippy Attack', 'Flippy Attack.swf', 'Flippy Attack.png', 'The objective of this game is simple. Stay alive as long as possible. Using characters from Happy Tree Friends.', 'Action', 'h', 14),
(6, 'Hamster Ball', 'hamsterball.swf', 'Hamster Ball.jpg', 'The objective of the game is to move the hamsterball to the orange flag and stop there as quickly as possible. Make sure you avoid the spikes and pitfalls so the poor hamster dosent die. Make sure you collect the stars on the way! Enjoy!', 'Adventure', 'h', '2');");



mysql_query("CREATE TABLE IF NOT EXISTS `game_cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;");

//Game_cat query missing ); at end of query
mysql_query("INSERT INTO `game_cat` (`cat_id`, `cat_name`) VALUES
(1, 'Action'),
(2, 'Adventure'),
(3, 'Racing'),
(4, 'Shooter');");




mysql_query("CREATE TABLE IF NOT EXISTS `joke` (
  `joke_id` int(11) NOT NULL auto_increment,
  `joke_name` varchar(150) NOT NULL default '',
  `joke_joke` text NOT NULL,
  `joke_cat` varchar(50) NOT NULL default '',
  `joke_by` varchar(255) NOT NULL,
  `joke_view` int(11) NOT NULL default '0',
  `joke_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`joke_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=176 ;");


mysql_query("CREATE TABLE IF NOT EXISTS `joke_cat` (
  `jokecat_id` int(11) NOT NULL auto_increment,
  `jokecat_cat` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`jokecat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;");

//joke_cat query missing ); at end of query
mysql_query("INSERT INTO `joke_cat` (`jokecat_id`, `jokecat_cat`) VALUES
(1, 'Adult Jokes'),
(2, 'Animal Jokes'),
(3, 'Bar Jokes'),
(4, 'Blonde Jokes'),
(5, 'Computer Jokes'),
(6, 'Dirty Jokes'),
(8, 'Funny Quotes'),
(9, 'Knock Knock Jokes'),
(10, 'Lawyer Jokes'),
(11, 'Medical Jokes'),
(12, 'Misc Jokes'),
(13, 'Redneck Jokes'),
(14, 'Relationship Jokes'),
(15, 'Religious Jokes'),
(16, 'Yo Mama Jokes');");


mysql_query("CREATE TABLE IF NOT EXISTS `pm` (
  `id` bigint(20) NOT NULL auto_increment,
  `from` varchar(255) NOT NULL,
  `to` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `parentid` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;");

mysql_query("CREATE TABLE IF NOT EXISTS `settings` (
  `id` varchar(2) NOT NULL,
  `sitename` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `topads` text NOT NULL,
  `bottomads` text NOT NULL,
  `theme` varchar(255) NOT NULL,
  `rpp` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;");

//settings query missing ); at end of query
       mysql_query("INSERT INTO settings SET 
                `url`='".$url."',
                `id`='1',
                `status`='online',
                `theme`='$theme',
                `sitename`='".$sitename."');") or die(mysql_error());



mysql_query("CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(10) NOT NULL default '2',
  `status` varchar(255) NOT NULL,
  `gameplays` int(11) NOT NULL default '0',
  `first` varchar(32) NOT NULL,
  `last` varchar(32) NOT NULL,
  `username` varchar(32) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `avatar` varchar(255) NOT NULL default 'default.gif',
  `location` varchar(255) NOT NULL,
  `myspace` varchar(255) NOT NULL,
  `aim` varchar(255) NOT NULL,
  `yim` varchar(255) NOT NULL,
  `about` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;");

//users query missing ); at end of query
mysql_query("INSERT INTO `users` (`id`, `type`, `status`, `gameplays`, `first`, `last`, `username`, `password`, `avatar`, `about`) VALUES

(1, '1', 'offline', 0, 'billy', 'bob', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'default.gif', 'I am the admin!....');") or die(mysql_error());



mysql_query("CREATE TABLE IF NOT EXISTS `video_cat` (
  `vid_id` int(11) NOT NULL auto_increment,
  `vid_cat` varchar(250) NOT NULL default '',
  `vid_count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vid_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;");

//video_cat query missing ); at end of query
mysql_query("INSERT INTO `video_cat` (`vid_id`, `vid_cat`) VALUES
(1, 'autos'),
(2, 'comedy'),
(3, 'sports'),
(4, 'music'),
(5, 'education'),
(6, 'news');");



mysql_query("CREATE TABLE IF NOT EXISTS `video` (
  `video_id` int(11) NOT NULL auto_increment,
  `video_name` varchar(250) NOT NULL default '',
  `video_link` varchar(250) NOT NULL default '',
  `video_des` text NOT NULL,
  `video_cat` varchar(50) NOT NULL default '',
  `video_views` int(11) NOT NULL default '0',
  `video_by` varchar(255) NOT NULL,
  PRIMARY KEY  (`video_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;");

//video query missing ); at end of query
mysql_query("INSERT INTO `video` (`video_id`, `video_name`, `video_link`, `video_des`, `video_cat`, `video_views`, `video_by`) VALUES
(1, 'Numa Numa', '60og9gwKh1o', '', 'Comedy', 248, ''),
(2, 'Shrek Karaoke', 'gknjvqdB_1M', '', 'Music', 82, ''),
(3, 'Eminem - Beautiful', 'pCzRei9-42s', '', 'music', 26, 'admin'),
(4, 'Call of Duty: Modern Warfare 2 Trailer', 'P7vyLDEwF5I', '', 'news', 15, 'admin'),
(5, 'Michael Jackson - Billie Jean', 'CaAD7EizAfw', '', 'music', 16, 'admin'),
(6, 'Michael Jackson - Beat It', 'jyCiNAgfcUs', '', 'music', 11, 'admin'),
(7, 'sponge bob - pump it', 'fYIeLApUUlI', 'music video for sponge bob pump it by black eyed peas', 'music', 2, 'Admin'),
(8, 'Spongebob We Will Rock You', 'OkrMnu9k4-A', 'Spongebob and his friends singin We Will Rock You, from Queen', 'music', 8, 'Admin'),
(9, 'Michael Jackson - They Dont Really Care About Us', 'ZPFFDSChedY', 'The last song he preformed before his death.', '', 30, 'Admin');");




mysql_query("CREATE TABLE IF NOT EXISTS `vote` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `pageid` int(11) default NULL,
  `pagecat` varchar(255) NOT NULL,
  `rating` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;");



      echo '<div class="done">Updated.</div><br />
      Please delete the install.php file. <br /><br />Username: __ Password: __<br />
      These are to login to the admin panel (default admin account). CHANGE THEM ASAP!!! ';
      exit;
   
}


echo "<form action='install.php' method='POST'>

         <div class='header'>Settings</div>
   Site Name:<br />   
   <input type='text' name='sitename' size='40'><br />

   Domain:   
   <input type='text' name='url' size='40' value='http://'><br />
         
   Theme:
   <input type='text' name='theme' size='40' value='default' readonly><br />

   <input type='submit' name='submit' value='Install Media Script!'>
   </form>";
?>

 

If this didn't help, do me a favor and give me the url for the pahe you are trying to install

 

Let me know if you made it

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.