Re: art.gnome.org setup

[Thomas Wood <thos gnome org>]

Henrik Nilsen Omma wrote:
> Henrik Nilsen Omma wrote:
>
> > That would be great, thank you. I think I'm still missing some 
> > dependencies on my setup to get in running.
>
>
> To answer my own questions a bit: So it seems that I am missing the file 
> 'mysql.inc.php' which presumably connects with the MySQL database. It 
> makes sense that you would keep this out of the CVS since it presumably 
> contains the DB password. If anyone could send me a blanked out copy 
> that would be great though :)

mysql.inc.php contains the following:

<?php
 mysql_connect("localhost","user","password");
 mysql_select_db("artweb");
?>


You obviously need to make sure this is somewhere PHP can find it. You 
also need to add the /includes directory to you PHP path.


One other bit of trickery is getting apache set up correctly. You'll 
need to add this to your apache config:

<Directory /path/to/artweb>
        AllowOverride None
        order allow,deny
        allow from all

        php_value include_path 
.:/path/to/artweb/includes:/path/to/mysql:/usr/share/php
         DirectoryIndex index.html index.php
         <FilesMatch 
"(backgrounds|themes|gtk_engines|art-icons|download|users|contest)">
                ForceType application/x-httpd-php
        </FilesMatch>
</Directory>


Obviously replacing /path/to/artweb with the path to the artweb 
directory, and replace /path/to/mysql with the directory you have the 
mysql.inc.php file in.

I have attached the current structure of the artweb database. However, 
there are probably old and unused tables there as well, so it could do 
with some cleaning up.


-Thomas

-- MySQL dump 8.23
--
-- Host: button-back    Database: artweb
---------------------------------------------------------
-- Server version	4.1.11

--
-- Table structure for table `background`
--

CREATE TABLE background (
  backgroundID int(6) NOT NULL auto_increment,
  userID int(6) NOT NULL default '0',
  `status` varchar(15) NOT NULL default '',
  background_name varchar(200) NOT NULL default '',
  version int(8) NOT NULL default '0',
  license varchar(30) NOT NULL default '',
  parent int(6) NOT NULL default '0',
  category varchar(20) NOT NULL default '',
  add_timestamp int(20) NOT NULL default '0',
  release_date date NOT NULL default '0000-00-00',
  background_description text NOT NULL,
  thumbnail_filename varchar(100) NOT NULL default '',
  download_start_timestamp int(20) NOT NULL default '0',
  download_count int(8) NOT NULL default '0',
  rating float default NULL,
  PRIMARY KEY  (backgroundID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `background_archive`
--

CREATE TABLE background_archive (
  backgroundID int(6) NOT NULL auto_increment,
  `status` varchar(15) NOT NULL default '',
  background_name varchar(200) NOT NULL default '',
  parent int(6) NOT NULL default '0',
  category varchar(20) NOT NULL default '',
  author varchar(50) NOT NULL default '',
  author_email varchar(100) NOT NULL default '',
  add_timestamp int(20) NOT NULL default '0',
  release_date date NOT NULL default '0000-00-00',
  background_description text NOT NULL,
  thumbnail_filename varchar(50) NOT NULL default '',
  screenshot_filename varchar(50) NOT NULL default '',
  screenshot_description text NOT NULL,
  download_start_timestamp int(20) NOT NULL default '0',
  download_count int(8) NOT NULL default '0',
  PRIMARY KEY  (backgroundID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `background_resolution`
--

CREATE TABLE background_resolution (
  background_resolutionID int(6) NOT NULL auto_increment,
  backgroundID int(6) NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  resolution varchar(50) NOT NULL default '',
  filename varchar(100) NOT NULL default '',
  PRIMARY KEY  (background_resolutionID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `background_resolution_archive`
--

CREATE TABLE background_resolution_archive (
  background_resolutionID int(6) NOT NULL auto_increment,
  backgroundID int(6) NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  resolution varchar(50) NOT NULL default '',
  filename varchar(100) NOT NULL default '',
  PRIMARY KEY  (background_resolutionID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `comment`
--

CREATE TABLE `comment` (
  commentID int(6) NOT NULL auto_increment,
  artID int(6) NOT NULL default '0',
  userID int(6) NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  `timestamp` int(10) default NULL,
  `comment` text NOT NULL,
  `status` varchar(10) NOT NULL default 'new',
  PRIMARY KEY  (commentID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `contest`
--

CREATE TABLE contest (
  contestID int(6) NOT NULL auto_increment,
  userID int(8) NOT NULL default '0',
  `status` varchar(15) NOT NULL default '',
  contest varchar(30) NOT NULL default '',
  name varchar(50) NOT NULL default '',
  version varchar(8) NOT NULL default '',
  license varchar(30) NOT NULL default '',
  parent int(6) NOT NULL default '0',
  add_timestamp int(20) NOT NULL default '0',
  release_date date NOT NULL default '0000-00-00',
  description text NOT NULL,
  thumbnail_filename varchar(50) NOT NULL default '',
  small_thumbnail_filename varchar(50) NOT NULL default '',
  download_start_timestamp int(20) NOT NULL default '0',
  download_count int(8) NOT NULL default '0',
  download_filename varchar(50) NOT NULL default '',
  depends varchar(20) NOT NULL default '',
  rating float default NULL,
  PRIMARY KEY  (contestID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `faq`
--

CREATE TABLE faq (
  faqID int(6) NOT NULL auto_increment,
  question tinytext NOT NULL,
  answer text NOT NULL,
  `status` varchar(7) NOT NULL default '',
  userID int(6) NOT NULL default '0',
  PRIMARY KEY  (faqID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `featured`
--

CREATE TABLE featured (
  id int(6) NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  blurb text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `icon`
--

CREATE TABLE icon (
  name varchar(50) NOT NULL default '',
  realname varchar(50) NOT NULL default '',
  tarball_name varchar(50) NOT NULL default '',
  tarball_filename varchar(50) NOT NULL default '',
  image varchar(50) NOT NULL default '',
  num_columns int(6) NOT NULL default '0',
  PRIMARY KEY  (name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='icon sections';

--
-- Table structure for table `incoming_background`
--

CREATE TABLE incoming_background (
  backgroundID int(6) NOT NULL auto_increment,
  userID int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `status` varchar(15) NOT NULL default '',
  background_name varchar(200) NOT NULL default '',
  version varchar(10) NOT NULL default '',
  license varchar(30) NOT NULL default '',
  parentID int(8) NOT NULL default '0',
  category varchar(20) NOT NULL default '',
  background_description text NOT NULL,
  updateID int(6) NOT NULL default '0',
  `comment` text,
  PRIMARY KEY  (backgroundID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `incoming_background_resolution`
--

CREATE TABLE incoming_background_resolution (
  background_resolutionID int(6) NOT NULL auto_increment,
  backgroundID int(6) NOT NULL default '0',
  `type` varchar(10) NOT NULL default '',
  resolution varchar(50) NOT NULL default '',
  filename varchar(100) NOT NULL default '',
  PRIMARY KEY  (background_resolutionID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `incoming_theme`
--

CREATE TABLE incoming_theme (
  themeID int(6) NOT NULL auto_increment,
  userID int(8) NOT NULL default '0',
  `status` varchar(15) NOT NULL default '',
  version varchar(10) NOT NULL default '',
  license varchar(30) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  theme_name varchar(200) NOT NULL default '',
  parentID int(8) NOT NULL default '0',
  category varchar(20) NOT NULL default '',
  theme_url varchar(100) NOT NULL default '',
  theme_description text NOT NULL,
  depends varchar(20) NOT NULL default '',
  updateID int(6) NOT NULL default '0',
  `comment` text,
  PRIMARY KEY  (themeID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `mirror`
--

CREATE TABLE mirror (
  mirrorID int(4) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  location varchar(20) NOT NULL default '',
  url varchar(50) NOT NULL default '',
  PRIMARY KEY  (mirrorID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `news`
--

CREATE TABLE news (
  newsID int(6) NOT NULL auto_increment,
  userID int(8) NOT NULL default '0',
  `status` varchar(20) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  author varchar(25) NOT NULL default '',
  author_email varchar(50) NOT NULL default '',
  title varchar(50) NOT NULL default '',
  body text NOT NULL,
  foobar varchar(20) NOT NULL default '',
  PRIMARY KEY  (newsID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='art.gnome.org newsfeed';

--
-- Table structure for table `poll`
--

CREATE TABLE poll (
  pollID int(6) NOT NULL auto_increment,
  poll_name varchar(100) NOT NULL default '',
  PRIMARY KEY  (pollID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='art.gnome.org polls';

--
-- Table structure for table `screenshot`
--

CREATE TABLE screenshot (
  screenshotID int(6) NOT NULL auto_increment,
  thumbnail_filename varchar(50) NOT NULL default '',
  add_timestamp int(20) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  image_filename varchar(50) NOT NULL default '',
  description text NOT NULL,
  PRIMARY KEY  (screenshotID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Screenshots';

--
-- Table structure for table `theme`
--

CREATE TABLE theme (
  themeID int(6) NOT NULL auto_increment,
  userID int(8) NOT NULL default '0',
  `status` varchar(15) NOT NULL default '',
  category varchar(30) NOT NULL default '',
  theme_name varchar(50) NOT NULL default '',
  version varchar(8) NOT NULL default '',
  license varchar(30) NOT NULL default '',
  parent int(6) NOT NULL default '0',
  add_timestamp int(20) NOT NULL default '0',
  release_date date NOT NULL default '0000-00-00',
  description text NOT NULL,
  thumbnail_filename varchar(50) NOT NULL default '',
  small_thumbnail_filename varchar(50) NOT NULL default '',
  download_start_timestamp int(20) NOT NULL default '0',
  download_count int(8) NOT NULL default '0',
  download_filename varchar(50) NOT NULL default '',
  depends varchar(20) NOT NULL default '',
  rating float default NULL,
  PRIMARY KEY  (themeID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='theme table';

--
-- Table structure for table `theme_archive`
--

CREATE TABLE theme_archive (
  themeID int(6) NOT NULL auto_increment,
  `status` varchar(15) NOT NULL default '',
  category varchar(30) NOT NULL default '',
  theme_name varchar(50) NOT NULL default '',
  author varchar(100) NOT NULL default '',
  author_email varchar(100) NOT NULL default '',
  add_timestamp int(20) NOT NULL default '0',
  release_date date NOT NULL default '0000-00-00',
  description text NOT NULL,
  thumbnail_filename varchar(50) NOT NULL default '',
  small_thumbnail_filename varchar(50) NOT NULL default '',
  download_start_timestamp int(20) NOT NULL default '0',
  download_count int(8) NOT NULL default '0',
  download_filename varchar(50) NOT NULL default '',
  PRIMARY KEY  (themeID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='theme table';

--
-- Table structure for table `tip`
--

CREATE TABLE tip (
  tipID int(6) NOT NULL auto_increment,
  `type` varchar(25) NOT NULL default '',
  title varchar(100) NOT NULL default '',
  body text NOT NULL,
  tip_url varchar(100) NOT NULL default '',
  PRIMARY KEY  (tipID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  userID int(6) NOT NULL auto_increment,
  username varchar(12) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  realname varchar(50) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  homepage varchar(100) NOT NULL default '',
  info text NOT NULL,
  active int(11) NOT NULL default '1',
  `level` tinyint(4) NOT NULL default '0',
  lastlog date NOT NULL default '0000-00-00',
  timezone decimal(3,1) default NULL,
  location varchar(50) default NULL,
  PRIMARY KEY  (userID),
  UNIQUE KEY username (username)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `vote`
--

CREATE TABLE vote (
  voteID int(6) NOT NULL auto_increment,
  userID int(6) NOT NULL default '0',
  artID int(6) NOT NULL default '0',
  rating int(1) NOT NULL default '0',
  `type` varchar(10) default NULL,
  PRIMARY KEY  (voteID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;