Nukemods Forum - View Single Post

IACOJ · #8 (**permalink**) 01-31-2003, 04:09 PM

I have part of the sql for you. Please note I am not sure about how to add the first two things, but I believe they need to be there so you don't use the same table for your reviews.

In the table structure for nuke_authors you need to insert this (I think) I'm not sure if the insert command will work there or not)

Code:

radminreviews1 tinyint(2) NOT NULL default '0',

In nuke_modules you need to add the following (I think)

Code:

INSERT INTO nuke_modules VALUES (26,'Reviews1','',0,0,1);

Check the numerical value, if you haven't added anything else that table it should be right, but check anyway.

You should be able to save the rest of this as an sql to create the tables.

Code:

#
# Table structure for table 'nuke_reviews1'
#

CREATE TABLE nuke_reviews1 (
  id int(10) NOT NULL auto_increment,
  date date NOT NULL default '0000-00-00',
  title varchar(150) NOT NULL default '',
  text text NOT NULL,
  reviewer varchar(20) default NULL,
  email varchar(60) default NULL,
  score int(10) NOT NULL default '0',
  cover varchar(100) NOT NULL default '',
  url varchar(100) NOT NULL default '',
  url_title varchar(50) NOT NULL default '',
  hits int(10) NOT NULL default '0',
  rlanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;

#
# Dumping data for table 'nuke_reviews1'
#

#
# Table structure for table 'nuke_reviews1_add'
#

CREATE TABLE nuke_reviews1_add (
  id int(10) NOT NULL auto_increment,
  date date default NULL,
  title varchar(150) NOT NULL default '',
  text text NOT NULL,
  reviewer varchar(20) NOT NULL default '',
  email varchar(60) default NULL,
  score int(10) NOT NULL default '0',
  url varchar(100) NOT NULL default '',
  url_title varchar(50) NOT NULL default '',
  rlanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;

#
# Dumping data for table 'nuke_reviews1_add'
#


#
# Table structure for table 'nuke_reviews1_comments'
#

CREATE TABLE nuke_reviews1_comments (
  cid int(10) NOT NULL auto_increment,
  rid int(10) NOT NULL default '0',
  userid varchar(25) NOT NULL default '',
  date datetime default NULL,
  comments text,
  score int(10) NOT NULL default '0',
  PRIMARY KEY  (cid),
  KEY cid (cid),
  KEY rid (rid),
  KEY userid (userid)
) TYPE=MyISAM;

#
# Dumping data for table 'nuke_reviews1_comments'
#


#
# Table structure for table 'nuke_reviews1_main'
#

CREATE TABLE nuke_reviews1_main (
  title varchar(100) default NULL,
  description text
) TYPE=MyISAM;

#
# Dumping data for table 'nuke_reviews1_main'
#

INSERT INTO nuke_reviews1_main VALUES ('reviews1 Section Title','reviews1 Section Long Description');

As I said before I THINK this is right, that doesn't mean it is. If anyone notices an error please correct it.

EDIT: This sql is based on the assumption that nuke is the prefix for your nuke db and that review1 is the name for your second review table. If those are not the values you are using you need to change them to reflect you table values. Hope that makes sense.