About this Page
This is a discussion on Multiple Review Modules? within the Purged Topics forums, part of the NM Staff category; Hi! Ok.. I'm really new at all this. So bear with me. ops: I know very little about PhP ...

cold · #1 (**permalink**) 01-31-2003, 09:33 AM

Hi!

Ok.. I'm really new at all this. So bear with me.

ops: I know very little about PhP and even less about MySQL... 8O Please be gentle. :wink:

I was wondering if there was anyway to have MULTIPLE Review Modules? Like to have one review module for, let's say, cars, and have another review module under it for boats? Is there any way to do this? :?: I would like more then one review section on my main menu. (Not for boats and cars though.. lol.. just an example.. )

But, how would I go about duplicating more then one of these modules? I would like all the features of the main reviews module, but I want a few of them, where people can post comments for each review section... Help me..

Also, is there any way to acivate comments for the "SECTIONS" module? Or, am I asking for too much now.. 8O

Thanx Guys!

IACOJ · #2 (**permalink**) 01-31-2003, 01:17 PM

In the review module you can review different things, and others can comment on the review.

If you still want to have an additional reviews section the easiest way would be to copy the entire review folder, name it review2 or whatever you want. Then ftp it to your sites modules section. Go into admin/modules you will see reviews and reviews2, click edit, give it a custom name, save it and that name will show up in your modules section. Do the same thing for the other one.

cold · #3 (**permalink**) 01-31-2003, 01:52 PM

Hi IACOJ,

I did what you told me, but it doesn't seem to be working right. The new Module shows in the admin control panel, and I see it in the side menu, but it seems to be referencing the same part of the MySQL Database. I added one review to REVIEWS 1, and the review also showed up in REVIEW 2... :roll: And when I deleted the review from REVIEW 2, I also deleted it in REVIEW 1... :roll: Still not working right, but it's closer then I got on my own.. 8O

I actually want like a seperate database entry for the other review section, so reviews on SOCKS don't mix with reviews on SHOES...

..... 8O

In case you guys want to know, I'm messing with PHP-NUKE 6.

IACOJ · #4 (**permalink**) 01-31-2003, 02:20 PM

hmmm... ok, I see what you are getting at. I'll have to look at the files associated with it, to see where things have to be changed. It'll take a while.

You might want to do a search or ask over at anorscorner to see if anyone has made something similar.

mikem · #5 (**permalink**) 01-31-2003, 02:29 PM

Well, you could rename the original reviews module to reviews1 and keep the original one too. You also would need to go through all the files in the reviews1 module and change any references from reviews to reviews1

Then you also need another reviews table in your database.
example
nuke_reviews
nuke_reviews1
You should be able to copy the info for the reviews table and rename it as reviews1 then upload it to your database.
ALSO..lol You would need to change the SQL queries in the reviews1 module to point to the review1 table instead of the original reviews table

confused yet?

I am
mikem

cold · #6 (**permalink**) 01-31-2003, 02:45 PM

8O

O-K................................................. ..........................................

Let me get this strait.....

-Download the REVIEWS folder
-Rename this folder REVIEWS2
-Open the index.php file and rename every reference to "reviews" to "reviews2"
-Upload this folder back to modules.
-Open myPhPAdmin
-Open my Nuke Database
-Duplicate the NUKE_REVIEWS sections to new database entries called "nuke_reviews2"
-Import the new tables and optimize the database.
-Go to NUKE Admin panel/modules

-Rename REVIEWS2 to "Whatever Reviews"

Then, this should work right.... Right? :?: Yes? No?

8O 8O 8O 8O 8O 8O

Why do I do things like this to myself. I shoulda opened that Geocities account..

mikem · #7 (**permalink**) 01-31-2003, 02:58 PM

Yes that is the idea..Now Granted. I am just speaking hypothetically. But if you understood half of what I said in my previous post..you're sharper than you think.

Make SURE you backup your database before you touch it!!!

disclaimer: WE or anyone associated with nukemods cannot be held responsible for any mis-fortune, nervous breakdown, anxiety or Site crash that may arise with your Website, database or your neighboor's Dog for that matter. Follow our instructions at your own risk :-)

IACOJ · #8 (**permalink**) 01-31-2003, 03: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.

cold · #9 (**permalink**) 02-02-2003, 12:17 AM

WOW! You guys are great! IT WORKED!!!!

It took some doing, but I got it down! I made 3!!!!

The only thing... in the admin panel, you can only edit the REVIEWS PAGE TITLE and the REVIEWS DISCRIPTION for the first review section. I can't add to the other ones.. but.. Maybe if I can mess with the admin.php, I might be able to make another button to point to the other reviews sections...? Ya think? :?:

IACOJ · #10 (**permalink**) 02-02-2003, 01:11 AM

To add the other ones you have to upload them to the modules folder. Then go into your admin cp/modules and you should be able to edit the names of the others as well.

About this PageThis is a discussion on Multiple Review Modules? within the Purged Topics forums, part of the NM Staff category; Hi! Ok.. I'm really new at all this. So bear with me. ops: I know very little about PhP ...

Multiple Review Modules?

About this Page
This is a discussion on Multiple Review Modules? within the Purged Topics forums, part of the NM Staff category; Hi! Ok.. I'm really new at all this. So bear with me. ops: I know very little about PhP ...