supergrame Posted December 11, 2008 Share Posted December 11, 2008 I cant get access to phpmyadmin and i have no idea why and i have no dea how to translate this into php please help me. here is the mysql database code: -- phpMyAdmin SQL Dump -- version 2.11.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 28, 2008 at 10:04 PM -- Server version: 5.0.51 -- PHP Version: 5.2.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `9by9` -- -- -------------------------------------------------------- -- -- Table structure for table `bannerrotator` -- CREATE TABLE IF NOT EXISTS `bannerrotator` ( `id` varchar(20) default NULL, `client` varchar(20) default NULL, `type` varchar(255) default NULL, `url` varchar(255) default NULL, `image` varchar(255) default NULL, `alt` varchar(255) default NULL, `iw` varchar(255) default NULL, `ih` varchar(255) default NULL, `html` text, `views` varchar(16) default NULL, `hits` varchar(16) default NULL, `expires` varchar(100) default NULL, `exptype` varchar(100) default NULL, `status` varchar(10) default NULL, `adgroup` varchar(16) default NULL, `created` varchar(10) default NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `bannerrotator` -- -- -------------------------------------------------------- -- -- Table structure for table `bannerrotators` -- CREATE TABLE IF NOT EXISTS `bannerrotators` ( `id` varchar(20) default NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `bannerrotators` -- INSERT INTO `bannerrotators` (`id`) VALUES ('Main'); -- -------------------------------------------------------- -- -- Table structure for table `brclients` -- CREATE TABLE IF NOT EXISTS `brclients` ( `id` varchar(20) default NULL, `pass` varchar(255) default NULL, `name` varchar(255) default NULL, `email` varchar(255) default NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `brclients` -- -- -------------------------------------------------------- -- -- Table structure for table `mailer` -- CREATE TABLE IF NOT EXISTS `mailer` ( `id` int(11) NOT NULL auto_increment, `subject` varchar(20) default NULL, `body` text, `first` int(11) default NULL, `last` int(11) default NULL, `rand` varchar(255) default NULL, `mask` varchar(255) default NULL, `html` varchar(255) default NULL, `high` varchar(10) default NULL, `progress` varchar(10) default NULL, `sent` varchar(20) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `mailer` -- -- -------------------------------------------------------- -- -- Table structure for table `qref` -- CREATE TABLE IF NOT EXISTS `qref` ( `id` int(11) NOT NULL auto_increment, `username` varchar(255) default NULL, `type` varchar(255) default NULL, `last` varchar(15) default NULL, `time` varchar(15) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `qref` -- -- -------------------------------------------------------- -- -- Table structure for table `redeem` -- CREATE TABLE IF NOT EXISTS `redeem` ( `id` int(11) NOT NULL auto_increment, `item` varchar(255) default NULL, `amount` varchar(255) default NULL, `autodebit` varchar(255) default NULL, `info` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `redeem` -- INSERT INTO `redeem` (`id`, `item`, `amount`, `autodebit`, `info`) VALUES (1, 'REDEEM YOUR EARNINGS', '10', '', '<input type=Text name="redeem[information]" value="Amount "><br><br>\r\nPLEASE TYPE IN THE AMOUNT YOU WOULD LIKE TO REDEEM IN THE BOX ABOVE<br><b>DELETE THE WORD AMMOUNT AND INSERT ONLY NUMBERS<br>IE: 10.00<br>NO DOLLARS SIGNS.<br>THEN HIT THE REQUEST BUTTON BELOW<br><br>\r\nPlease Note:</b><br><br></b>\r\nOnce we receive your request and verify it we will endevour to pay you out immediately.<br>Payouts take no longer than 8 hours maximum.<br><br>\r\n\r\nThank you Admin.<br><br>\r\n'); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE IF NOT EXISTS `sessions` ( `id` varchar(255) default NULL, `username` varchar(255) default NULL, `password` varchar(255) default NULL, `ip` varchar(255) default NULL, `time` varchar(255) default NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `username`, `password`, `ip`, `time`) VALUES ('970648bf486ca630916e8ca143597677', '1', '21232f297a57a5a743894a0e4a801fc3', '127.0.0.1', '1214654400'); -- -------------------------------------------------------- -- -- Table structure for table `system` -- CREATE TABLE IF NOT EXISTS `system` ( `id` varchar(20) default NULL, `mmheader` text, `mmfooter` text, `cron` varchar(255) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `system` -- INSERT INTO `system` (`id`, `mmheader`, `mmfooter`, `cron`) VALUES ('Admin', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `trans` -- CREATE TABLE IF NOT EXISTS `trans` ( `id` int(11) NOT NULL auto_increment, `username` varchar(20) default NULL, `type` varchar(255) default NULL, `amount` varchar(255) default NULL, `event` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `trans` -- INSERT INTO `trans` (`id`, `username`, `type`, `amount`, `event`) VALUES (1, '1', 'Credit', '100', ''); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` varchar(20) default NULL, `first` varchar(20) default NULL, `last` varchar(20) default NULL, `email` varchar(255) default NULL, `acc` varchar(255) default NULL, `pass` varchar(100) default NULL, `ref` varchar(20) default NULL, `refs` varchar(20) default NULL, `mpr` varchar(20) default NULL, `owedrefs` varchar(255) NOT NULL default '0', `refpos` varchar(255) NOT NULL default '0', `earnings` varchar(20) default NULL, `joindate` varchar(10) default NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `first`, `last`, `email`, `acc`, `pass`, `ref`, `refs`, `mpr`, `owedrefs`, `refpos`, `earnings`, `joindate`) VALUES ('1', 'Shannen', 'Saez', '[email protected]', '[email protected]', 'admin', 'admin', 'admin', NULL, '0', '0', '200', NULL); Link to comment https://forums.phpfreaks.com/topic/136453-can-some-one-please-convert-this-mysql-into-a-installphp/ Share on other sites More sharing options...
DarkWater Posted December 11, 2008 Share Posted December 11, 2008 No, we're not just here to do your work for you. Link to comment https://forums.phpfreaks.com/topic/136453-can-some-one-please-convert-this-mysql-into-a-installphp/#findComment-712186 Share on other sites More sharing options...
supergrame Posted December 11, 2008 Author Share Posted December 11, 2008 ok sorry i dident mean it like that.. can you show my an example of how to do one table. i dont mind doing the work i just dont no how to do it Link to comment https://forums.phpfreaks.com/topic/136453-can-some-one-please-convert-this-mysql-into-a-installphp/#findComment-712188 Share on other sites More sharing options...
phpSensei Posted December 11, 2008 Share Posted December 11, 2008 http://d15.biz/blog/2006/12/09/restore-mysql-dump-using-php/ Link to comment https://forums.phpfreaks.com/topic/136453-can-some-one-please-convert-this-mysql-into-a-installphp/#findComment-712189 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.