Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Battlefield 3 Stats Module

User Box

Anonymous

38.107.179.218

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ?This sh...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriousl...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Ct-green and ravennuke compatibility

Ct-green and ravennuke compatibility

9 Replies / 2189 Views


www.clanthemes.com Forum Index » Bugs/Issues	View previous topic :: View next topic

GyroTwister
Reputation: 478
Local time: 9:21 AM

Noob

0.00 posts per day
Medals: 0

Joined: Aug 30, 2007
Last Visit: 02 Jun 2009
Posts: 6
Points: 471

Ct-green and ravennuke compatibility Posted: Thu Mar 19, 2009 8:29 pm
Shop Purchases:Clan Themes Green PhpNuke Theme · Arnhem Multi Gaming Theme

Hello all,

In the past I've purchased the CT_Green theme. I haven't used it for some time but I the cycle of themes I want to use it once again.

However in the meantime I have installed RavenNuke 2.30.01 and it seems the theme is outdated to use with RavenNuke.

On the other hand ClanThemes says in the php-nuke theme section that these themes should be compatible with RavenNuke.

Any chance I could download an updated version of the theme??

With kind regards,

GyroTwister

LXS-Jones
Reputation: 35.4
Local time: 3:21 AM
Location: USA

Rocket Noob

0.02 posts per day
Medals: 0

Joined: Jun 13, 2008
Last Visit: 15 Nov 2011
Posts: 23
Points: 21143

Ct-green and ravennuke compatibility Posted: Thu Mar 19, 2009 8:33 pm
Shop Purchases:Anzio Multi Gaming Theme · Anzio vWar Addon Theme · Clan Roster 2.0 · Topsites Manager V1 PhpNuke Module · Call of Duty 5 Bulletproof Evo Theme · Medal of Honor Evo Theme · Bad Company 2 Vietnam Xtreme Theme

Hey Gyro..

If you are using RavenNuke 2.30.x you need to view this topic for all older php-nuke themes..

http://www.clanthemes.com/ftopict-4590-raven-v230-fix-for-missing-attachment-forums-files.html

GyroTwister
Reputation: 478
Local time: 9:21 AM

Noob

0.00 posts per day
Medals: 0

Joined: Aug 30, 2007
Last Visit: 02 Jun 2009
Posts: 6
Points: 471

Ct-green and ravennuke compatibility Posted: Thu Mar 19, 2009 8:42 pm
Shop Purchases:Clan Themes Green PhpNuke Theme · Arnhem Multi Gaming Theme

LXS-Jones,

I already had found this fixes and applied it. But there are other issues with CT_Green.

For example: CT_Green seems somehow to work with the sql_layer.php script. This is not RavenNuke compliant anymore. I know there are 2 lines in the mainfile.php to start up the sql_layer.php script again but has the CT_Green already been updated to address these kind of script issues??

On the other hand for some reason the CT_Green theme does not allow anyone to log in using Fx within IE everything works fine.

Any answers on these 2 questions??

With kind regards,

GyroTwister

floppy
Reputation: 2087.2
votes: 22
Local time: 3:21 AM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Re: Ct-green and ravennuke compatibility Posted: Thu Mar 19, 2009 11:23 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

What are the errors you receive? Did you turn on display_errors in config.php?

Phpnuke Downloads | VMaxxRx Male Enhancement

GyroTwister
Reputation: 478
Local time: 9:21 AM

Noob

0.00 posts per day
Medals: 0

Joined: Aug 30, 2007
Last Visit: 02 Jun 2009
Posts: 6
Points: 471

Ct-green and ravennuke compatibility Posted: Fri Mar 20, 2009 11:55 am
Shop Purchases:Clan Themes Green PhpNuke Theme · Arnhem Multi Gaming Theme

Ok to be as complete as possible:

In the mainfile from RavenNuke 2.30.01 you will find the following code:

Code:

/*
* The following two lines of code were moved and commented out in RN 2.30.00 to "test the waters" on
* finding out what old modules/blocks/hacks/etc. are still using this SQL layer that is so
* old it should be obsoleted. If you really need these back, uncomment them back. We will keep this
* code this way for one more major release as well as keep the includes/sql_layer.php script.
*/
//@require_once(INCLUDE_PATH.'includes/sql_layer.php');
//$dbi = sql_connect($dbhost, $dbuname, $dbpass, $dbname);

If these lines stay uncommented the following error occurs in theme.php from CT_Green:

Code:

Call to undefined function sql_query in theme.php line 104

The code in theme.php from line 104 is as follows:

Code:

// Determine how many READ Messages and how many UNREAD Messages
$result = sql_query( "select user_id from $prefix"._users." where username='$username'", $dbi );
list( $user_id ) = sql_fetch_row( $result, $dbi );
$result2 = sql_query( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='1' or privmsgs_type='5')", $dbi );
$MesUnread = sql_num_rows( $result2 );
$result3 = sql_query( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='0')", $dbi );
$MesRead = sql_num_rows( $result3 );

And indeed the sql_layer script is needed for this piece of code. This occurs in both IE and Fx.

If I set display_errors is "true" and test again with Fx no error whatsoever seems to occur. Allthough I am unable to log in. When I click on the input fields I am unable to type anything on the keyboard.

The website is http://www.dutchsnipers.com maybe this will help.

I changed the code for the private messages in theme.php to comments. Is that case all the other security which has been done by Raven is still in place.

floppy
Reputation: 2087.2
votes: 22
Local time: 3:21 AM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Re: Ct-green and ravennuke compatibility Posted: Fri Mar 20, 2009 12:02 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

Ok here are the changes for theme.php.

You need to make sure $db is in the globals

Example only

Code:

global $db, $prefix, $name;

Here is the code

Code:

$result = $db->sql_query( "select user_id from $prefix"._users." where username='$username'");
list( $user_id ) = sql_fetch_row( $result, $dbi );
$result2 = $db->sql_query( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='1' or privmsgs_type='5')");
$MesUnread = $db->sql_num_rows( $result2 );
$result3 = $db->sql_query( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='0')");
$MesRead = $db->sql_num_rows( $result3 );

DreAdeDcoRpSE
Reputation: 2221.6
votes: 28
Local time: 3:21 AM
Location: Back of your Mind

Forums Moderator

1.53 posts per day
Medals: 3 (View more...)

Site Admin

Joined: Sep 22, 2007
Last Visit: 10 Feb 2012
Posts: 2459
Points: 128885

Re: Ct-green and ravennuke compatibility Posted: Fri Mar 20, 2009 5:04 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 · · Modern Warfare 3 Xtreme Theme

Wouldn't you need to remove the object $dbi from the second line for your no longer calling on it.So it would be more like,

Code:

$result = $db->sql_query( "select user_id from $prefix"._users." where username='$username'");
list( $user_id ) = $db->sql_fetchrow( $result );
$result2 = $db->sql_query( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='1' or privmsgs_type='5')");
$MesUnread = $db->sql_num_rows( $result2 );
$result3 = $db->sql_query( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='0')");
$MesRead = $db->sql_num_rows( $result3 );

floppy
Reputation: 2087.2
votes: 22
Local time: 3:21 AM
Location: Jackson Mississippi

Site Admin

1.73 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 27 Jan 2012
Posts: 3313
Points: 132023

Re: Ct-green and ravennuke compatibility Posted: Fri Mar 20, 2009 5:10 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

Oopps! Yeah what dread posted.

DreAdeDcoRpSE
Reputation: 2221.6
votes: 28
Local time: 3:21 AM
Location: Back of your Mind

Forums Moderator

1.53 posts per day
Medals: 3 (View more...)

Site Admin

Joined: Sep 22, 2007
Last Visit: 10 Feb 2012
Posts: 2459
Points: 128885

Re: Ct-green and ravennuke compatibility Posted: Fri Mar 20, 2009 5:15 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 · · Modern Warfare 3 Xtreme Theme

I got ya back Sleepy

DreAdeDcoRpSE
Reputation: 2221.6
votes: 28
Local time: 3:21 AM
Location: Back of your Mind

Forums Moderator

1.53 posts per day
Medals: 3 (View more...)

Site Admin

Joined: Sep 22, 2007
Last Visit: 10 Feb 2012
Posts: 2459
Points: 128885

Re: Ct-green and ravennuke compatibility Posted: Fri Mar 20, 2009 5:34 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 · · Modern Warfare 3 Xtreme Theme

GyroTwister, Running RN 2.3.0 you may run into this problem with some themes or even modules/blocks, general the “old” inquiry results from the modules/blocks/themes for PHPNUke under 7.0.

Search in your module/block/theme for in the global variable declaration

Code:

$dbi

and change to:

Code:

$db

Then do a search for the inquiry and change to:

sql_query              <-----------to----------->             $db->sql_query
sql_fetch_row              <-----------to----------->              $db->sql_fetchrow
sql_num_rows              <-----------to----------->              $db->sql_numrows
sql_fetch_array              <-----------to----------->              $db->sql_fetchrow
sql_free_result              <-----------to----------->              $db->sql_freeresult

In this sql statement you find mostly for e.g.

Code:

$result, $dbi);

change to:

Code:

$result);

I hope this helps for any future issues that you might run into. This is something I been doing to blocks/modules so they will work on my Evo site which is now starting to affect RN with there latest release. Prior releases did not need these changes.

www.clanthemes.com Forum Index » Bugs/Issues

9 Replies / 2189 Views
Page 1 of 1
All times are GMT

Display posts from previous:

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work