View Single Post
  #13  
Old 02-17-2009, 07:49 PM
Blue Icebox Blue Icebox is offline
Member
 
Join Date: Jan 2009
Posts: 45
Credits: 5,063
Blue Icebox
Default RE: A problem with the config.php!

Quote:
Originally Posted by BMR777
You need to use PHPMyAdmin in your host's control panel to insert the SQL queries inside of sql.txt onto your database. Open PHPMyAdmin from your host's control panel and click on your database on the list to the left. Then once the page loads click on the SQL icon at the top left in the row of icons and paste the contents of sql.txt into the window and submit it. :)
What is PHPMyAdmin? How do you get one?[hr]
do you mean the one that has:

Code:
CREATE TABLE article_content (page varchar(20), title varchar(75), date varchar(15), content varchar(15000));
INSERT INTO article_content (page, title, date, content) VALUES ('index', 'This is the index page', 'Jan-10-1999', 'This is a sample article.  All of this text you can change in the script admin control panel.');
INSERT INTO article_content (page, title, date, content) VALUES ('tos', 'This is the Terms of Service Page', 'Jan-10-1999', 'Put your Terms of Service and legal documents here.  All of this text you can change in the script admin control panel.');
INSERT INTO article_content (page, title, date, content) VALUES ('extra', 'This is the extra page.', 'Jan-10-1999', 'This is an extra page you can edit in your Admin CP.');

CREATE TABLE users (uid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, username varchar(20) UNIQUE, password varchar(100), email varchar(60), level varchar(60));

CREATE TABLE adoptables (uid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name varchar(30), imageurl varchar(300), memberlevel varchar(40), description varchar(300));

CREATE TABLE owned_adoptables (uid INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY, name varchar(30) , imageurl varchar(100), currentlevel int(10), totalclicks int(10), owner varchar(40), type varchar(30), code varchar(50));

CREATE TABLE adoptable_rankimages (name varchar(30) UNIQUE, l1i varchar(300), l2i varchar(300) , l3i varchar(300), l4i varchar(300), l5i varchar(300) , l6i varchar(300), l7i varchar(300), l8i varchar(300));

CREATE TABLE vote_voters (date varchar(30), username varchar(50), ip varchar(50), adoptableid int(10));
?
Reply With Quote