Status
Not open for further replies.

csaskt

Member
11
2011
0
0
hello i haven not access on my sql phpmyadmin how i can install wcddl table i mean how i can make install.php file and run in browser to install file on my sql i have sql server name username and password.But i have not cpanel to access the phpmyadmin.
 
Last edited:
7 comments
i have database but i cannot access it i have username password sql server too but i cannot access to import i want to install.php file like phpbb forum to create a table.
 
install.php file is not creating any database for you. it only populate the database with tables. you need to create a database first...
 
my dear brother i also want to create only tables i have database password ,username and sql server name.i just want to create a tables on it for WCDDL.
 
PHP:
<?php
include "funcs.php";

// Create table
$sql = mysql_query("
CREATE TABLE IF NOT EXISTS `wcddl_blacklist` (
  `url` varchar(255) NOT NULL,
  PRIMARY KEY  (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_config` (
  `config_name` varchar(200) NOT NULL,
  `config_val` text NOT NULL,
  `config_group` varchar(30) NOT NULL default 'misc',
  PRIMARY KEY  (`config_name`),
  KEY `config_group` (`config_group`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_downloads` (
  `id` int(11) NOT NULL auto_increment,
  `sid` int(5) NOT NULL,
  `title` varchar(200) NOT NULL,
  `type` varchar(20) NOT NULL,
  `url` text NOT NULL,
  `dat` varchar(15) NOT NULL,
  `views` int(5) NOT NULL,
  `rating` int(5) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `sid` (`sid`,`title`,`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_queue` (
  `id` int(11) NOT NULL auto_increment,
  `sid` int(5) NOT NULL,
  `title` varchar(200) NOT NULL,
  `type` varchar(20) NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_recents` (
  `query` varchar(200) NOT NULL,
  `searches` int(5) NOT NULL,
  PRIMARY KEY  (`query`),
  KEY `searches` (`searches`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_sites` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(200) NOT NULL,
  `url` text NOT NULL,
  `email` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `wcddl_whitelist` (
  `url` varchar(255) NOT NULL,
  PRIMARY KEY  (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
");
?>
NOT Tested
 
thanks for reply jomasaco its not work but my webmaster import database.sql file in my databse.Now i am facing the site path problem i dont know my site path name
 
Status
Not open for further replies.
Back
Top