Forum stylesheets

[kisii]

I have SMF and PP integrated, after 5,21 upgrade i noticed that It only respects Use Integrated forum stylesheets feature only whenone is logged in, othersise when there is a guest it floods the index page with the header background color, I have checked usergroup permissions but no avail, any idea?

[Chuck S]

Link to your install as it should load the default stylesheet?

if ( $authuser == "" ) {

$query = "SELECT value FROM $ctable
WHERE variable ='theme_default'";
$stylec = ppmysql_query($query,$db_link);
list( $defaultstyle ) = mysql_fetch_row($stylec);
ppmysql_free_result( $stylec );
}

// If they don't have a stylesheet pref we use the default
if ( $numstyle == "" || $numstyle == 0 ) {
$numstyle = $defaultstyle;
}


$query = "SELECT value FROM $extable
WHERE variable ='theme_url' AND ID_THEME = '$numstyle'";
$styled = ppmysql_query($query,$db_link);
list( $finalstyle ) = mysql_fetch_row($styled);
ppmysql_free_result( $styled );

// If they don't have a stylesheet pref we use the default
if ( $User['userid'] == 0 ) {
$User['stylesheet'] = $finalstyle;
}

[kisii]

Thanks chuck. On what file should that script go on?

[Chuck S]

I was simply showing that it loads the default stylesheet automatically by showing the actual code

I asked for your url to post posted here so I can see your install.

[kisii]

Hey Chuck,

I did not ignore your request, my new host had disabled my account for high CPU usage, them canadinas tell me that running 4 php scripts is violatong the terms of the subs agreement...anyhow im back and on a different server.

I still have the same issue, im sure this started occcuring after I upgraded to 5.21 . I have PMed you with an admin acount and password.
Thanks.

[Chuck S]

Your using SMF RC 1.1 which we do not support at this time.

However from what I see there are no changes to the stylsheet stuff.

Go to mysql phpmyadmin etc and go through the process run those queries.

You should have a theme url for the default theme in your database and it looks like you dont so look at that last query especially.

[kisii]

Hi Chuck,

Im not very proficient with databases - pretty bad at it and Im not sure what I will be doing in phpadmin but if you give me specific instructions I can fix it.
Every time that SMF comes out with a build, something breaks on PP......uhhuuugh!

Thanks

[Chuck S]

Well I dont know what your issue is.

It does not appear to be anything with PHOTOPOST

If I register a new user in SMF photopost recognizes them fine. That would point to an issue with these few users you meantion maybe something went wrong with there import.

Have them try and reset there password

[kisii]

correct but it only recognizes the correct theme or stylesheet after a user has logged in which it shouldnt anyway. If I have Photopost pull the SMF theme that I have for all guests and users from SMF, then it should right? The current problem would only make sense of I had set in SMf that guests should be reset or defaulted to a specific theme.

[Chuck S]

You need to run the query I noted cause it should return a value like so

http://www.kenyans.org/discussions/Themes/kenyan

I think your styleid is 5 but dont know

SELECT value FROM smf_themes
WHERE variable ='theme_url' AND ID_THEME = '5'

or maybe this if it is not a number

SELECT value FROM smf_themes
WHERE variable ='theme_url' AND ID_THEME = 'kenyan'


Remember we do not support SMF 1.1RC2 so not too much more I can say here. Once SMF releases a stable version we will work out supporting it and dropping support for 1.0-1.05

[kisii]

Greatly appreciated , I will try it and let you know.

[kisii]

Chuck , I have tried that and its a value number , I change dit back and forth but I do not see any difference on the themes. I have posted on SMF ( about the same issue but I have not got any response). I know one of their major overhaul was the default theme, nothing in detail that I am aware of that coudl have created this problem.
I woudl really really appreciate if if you woudl for the last time take a peek at my database settings. Let me knwo I will email the logins.
Thanks

[Chuck S]

Jimmy

Forum stylesheets

As noted when you run the query

SELECT value FROM smf_themes
WHERE variable ='theme_url' AND ID_THEME = '5'

The variable called theme_url should have a url value like so

http://www.kenyans.org/discussions/Themes/kenyan

I can take a peek but need the phpmyadmin login to run the query

[kisii]

check your mailbox...thanks!

[Chuck S]

Your theme default was set to 0

I changed it to 5 and your good

[kisii]

you are the greatest - Thanks a Bunch.

[kisii]

chuck just for my future records what table among the four
ID_MEMBER

ID_THEME

value

variable

and from what drop down menu did you change the number.

[Chuck S]

No in your overall settings your theme was set to 0

I set the default theme to 5 in the settings table of smf

[kisii]

Hey Chuck,

Bothering you for the last time. I thought the prob wqs fixed sO i created a new theme with the new tabbed menus that RC2 has and when I tried to select it it went back to the same thing that we had before. I did not mean to bug you again but I have tried for about 2 hours to get that setting to change in the database but I cant seem to find it. Cn you please help once again or just just me step by step what to do? - maybe someone will need the steps here later as well.
Thanks.

[Chuck S]

Jimmy you must do as posted above. View your SMF settings table. There is an variable in there called theme_default this must be set to the default theme id. Last time it was set to 0 and I set it to 5

SELECT value FROM smf_settings WHERE variable ='theme_default'

thats the query we use. you should be able to find the variable and change the value to what you want.