NM Themes with banner next to logo

mikem · **NM Themes with banner next to logo -** 04-17-2003, 11:33 AM

We are currently in the process of making all Nuke6.5 themes with the banners next to the logo.
We have found an easy way to do this thanks to a great tip posted over at phpnuke.org by Mtechnik

Currently most theme packs for Nuke6.5 are version 1.0
You can check your version in your theme.php file in the top comments.
We will make an announcement again when all the theme packs are done for Nuke6.5 whcih should be later today. They will be version 2.0.
The only files you would need to replace would be the theme.php and header.html
If you have already made changes to these files, then you would need to run diffs. between your modified files and the ones in the new packs and apply the changes yourself.

EDIT:
ALL Nuke6.5 theme packs have now been updated.

thanks, NMStaff

ads · 04-17-2003, 12:31 PM

A little while ago I posted a question here asking where the banners display on your themes so im very happy to hear this. You guys do an excellent work. Thanks.

ads · 04-17-2003, 03:07 PM

Im getting this error after replacing ....

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/local/public_html/includes/sql_layer.php on line 286

changed back to the old theme.php and it went away.

mikem · 04-17-2003, 03:13 PM

Quote:

Originally Posted by ads

Im getting this error after replacing ....

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/local/public_html/includes/sql_layer.php on line 286

changed back to the old theme.php and it went away.

which theme pack?

mikem

ads · 04-17-2003, 03:14 PM

Helius

mikem · 04-17-2003, 03:22 PM

Ya got me..I tested all these changes on my testsite which is runnin a Fresh Nuke6.5 install.
I get no errors. Is it on every page?
Is there anyway you can upload the changed files again, and then turn on Nukedebugging and post back what the debug message says?
If you don't know how to turn on debugging,

sql_layer.php Debug

Open sql_layer.php go to line 300 and change:

Code:

case "MySQL": 
$row = mysql_fetch_row($res); 
return $row; 
break;;

To the following:

Code:

case "MySQL": 
if ($row = mysql_fetch_row($res)) { 
return $row; 
} else { 
print (mysql_error()); 
} 
break;;

mikem

ads · 04-17-2003, 03:33 PM

Yup its on every page , I have re-uploaded the files theme.php and header.html a couple of times, still the same.

I did what you said to sql_layer.php , gave me the same error at top of the page ...

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/local/public_html/includes/sql_layer.php on line 286

mikem · 04-17-2003, 03:37 PM

crud.
I can't remeber the other SQl debug way that is more descriptive. chatserv posted it in here somehwere... :?

OK..I need to know if anyone else that uses banners hass tried the new theme packs yet with the banners moved.
All the theme packs have been updated, so if this is a problem with EVERYONE, then we need to get it resolved, which shouldn't be too difficult.

If it is just a problem with your site, then it may be mroe difficult to find the solution, but not all is lost :-)
Is everything else on all your pages ok..is the message just at the top? Does the banner appear?

mikem

ads · 04-17-2003, 03:46 PM

ok , debug is turned on in line 181 of sql_layer.php , just change $sql_debug = 0; to $sql_debug = 1; .... here is what I got ...

SQL query: select radminsuper from nuke_authors where aid='ads'
SQL query: select topicid, topictext from nuke_topics order by topictext

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/local/public_html/includes/sql_layer.php on line 286

I dont think it helps much though.

mikem · 04-17-2003, 03:46 PM

Ok let's try this debug
change lines 252-255 in sql_layer.php from:

Code:

    case "MySQL": 
        $rows=mysql_num_rows($res); 
        return $rows; 
    break;;

to:

Code:

    case "MySQL": 
        if ($rows=mysql_num_rows($res)) { 
        return $rows; 
        } else { 
        print (mysql_error()); 
        } 
        break;;

see what that shows for that error...

mikem