Yep.. I can edit the names ok. But, for the reviews administration.. I can only edit the first one. (REVIEWS PAGE TITLE and REVIEWS PAGE DISCRIPTION) I can't change these for the new ones :cry: ... I was wondering if there was anything I had to change in the admin.php or something. :?:

__________________
Clarissa Winters

You will have to do the same basic procedure for admin. For admin/modules, admin links/, admin/case.

Code:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /public_html/nuke/html/includes/sql_layer.php on line 301 Access Denied

:cry: :cry: :cry: :cry: :cry:

I added links.reviews2.php, reviews2.php, and case.reviews2.php... I see a new button, but I get that error. I did change the references in each file from _review to _review2... :cry:

__________________
Clarissa Winters

The sql file will have to be updated to reflect for the admin part. Im sorry I didn't think it through before I posted. Now if IACOJ will please do his sql magic to it, to include this you'll be in business.

Find the tables in mysql for reviews, copy it, edit it to point to the new modules (one for each module) and save them back in the database. I don't know enough DB stuff to do it though.

Cold

Can you tell me please the names of the review folders that you have loaded to your server, so I can make the correct sql. for you?

Did you add these

Code:

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

Code:

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

to the last sql?

EDIT:

Try this for radminreview BACK UP your db first

Code:

ALTER TABLE nuke_authors ADD radminreviews1 tinyint(2) NOT NULL default '0',

Assuming again that you have folder named reviews1

Ok... I added the following folders...

• Reviews
  Reviews2
  Reviews3
  Reviews4
  Reviews5
  Reviews6
  Reviews7
  Reviews8
  Reviews9

8O ...... ok.. so I want to do allot of reviews.. Actually, I'm helping some friends create a gaming web site. So, they want allot of sections for different reviews for different games. It's gonna be free, so I'm donating my stupidity... 8O

Originally Posted by IACOJ, you

Did you add these Code: radminreviews1 tinyint(2) NOT NULL default '0', Code: INSERT INTO nuke_modules VALUES (26,'Reviews1','',0,0,1); to the last sql?

Where was I supposed to add these entries? :roll:

Originally Posted by Then you

Cold

Clarissa is fine. :wink:

__________________
Clarissa Winters

Clarissa,

You aren't stupid, you're learning I hadn't even heard of php until about 4 or 5 months ago.

Those two commands should have been run with the first sql, but I wasn't exactly sure how to insert them.

301 errors basically mean that something wasn't installed properly.

Did you alter the sql I gave you before, or run it as is? Did you back up before you ran it?

ok.. these...

Code:

radminreviews1 tinyint(2) NOT NULL default '0', INSERT INTO nuke_modules VALUES (26,'Reviews1','',0,0,1);

Gave me an SQL error when I tried to add them. Unless I did something wrong... Which is very likely... :roll: ... SQL to me is like a diaphram to a guy...

Ok.. here is what I did do...

• 1 Downloaded the Reviews Folder
  2 Renamed it to Reviews2
  3 Opened the index.php and replaced all the _reviews with _reviews2
  4 Exported the parts of mySQL referencing the Revies Section...
  -nuke_reviews
  -nuke_reviews_add
  -nuke_reviews_comments
  -nuke_reviews_main
  5 I opened the exported SQL in notepad and changed the keys from reviews to reviews2
  6 Added the parts back in as nuke_reviews2, etc.
  7 made a directory for the images for Reviews2

Then, did it all over again for Reviews3. 8O

And I did backup the entire database before I messed with it.

Don't get me wrong, The seperate review sections work fine indipendantly. I think I'm just knit-picking.... :roll: Hey.. It's my right as a descendant of Eve... LOL!

__________________
Clarissa Winters

Is you db prefix nuke? Or something else?

I'll post an sql that you can run dirctly, just copy it into a txt file, go into phpmyadmin, click sql you'll see a box there that says browse. Click that find the txt file, and then click go. It should run.

You have two options here as I see it. You can load your backup first, and I'll give you a complete sql to make all the tables and alter the others as needed. Or I can give you one that doesn't contain any reference to reviews2 and reviews3. With the exception of trying to insert those two commands that gave you an error.

Either way I need you to go into your db and check the first numerical value in nuke_modules for reviews, reviews2 and reviews3. It will probably be something 24 26 27 respectively.

Can you let me know which way you want to go. I'll post the sql here

Quote:

Is you db prefix nuke? Or something else?

Yep.. I stick to defaults to avoid trouble... :roll:

Quote:

I'll post an sql that you can run dirctly, just copy it into a txt file, go into phpmyadmin, click sql you'll see a box there that says browse. Click that find the txt file, and then click go. It should run.

Way cool!

Quote:

You have two options here as I see it. You can load your backup first, and I'll give you a complete sql to make all the tables and alter the others as needed. Or I can give you one that doesn't contain any reference to reviews2 and reviews3. With the exception of trying to insert those two commands that gave you an error.

Eh.. Ok.. I have made a few changes, but mostly to the theme.php for looks. I haven't really messed much with the DB. Only to add the 4 sections for each review module. So, Actually, I entered 32 New Keys, but they are all duplicates of the first original 4 Reviews .SQL. (If that makes sense...)

Quote:

Either way I need you to go into your db and check the first numerical value in nuke_modules for reviews, reviews2 and reviews3. It will probably be something 24 26 27 respectively.

I can do that...

Quote:

Can you let me know which way you want to go. I'll post the sql here

If I understood you, would either post the entire database here, or post the parts I need for the admin.php to work. Right? Please bear with me. I'm not as good with this stuff as you guys might be... I would just need the parts to get the admin.php to display the icons for the other review sections. They could all be named reviews, that doesn't matter. I can figure that out....

But, if it's something that you're going to go nuts with IACOJ, don't go through that much trouble for it. Like I said, what you had originally posted for me worked, and I have several sections now thanks too you :wink: !

But as far as this...

Quote:

check the first numerical value in nuke_modules for reviews, reviews2 and reviews3. It will probably be something 24 26 27 respectively.

I'm having trouble seeing what you mean. I'm so new to mySQL that it's not funny... I'm getting there, but still a little slow..

__________________
Clarissa Winters