UBB.Developers Forums UBB.threads 6 V6 Modifications Forum Design Integration IIP SideBarPal 1.1

Oh it works for me. It works fine on the left. It works fine on the right on every page but ONE. The main index which of course has Photopost. Now if I remove the ubbt_photopost.tmpl require from the ubbthreads.tmpl the sidebar comes up fine with no sql

Oh it works for me. It works fine on the left. It works fine on the right on every page but ONE. The main index which of course has Photopost. Now if I remove the ubbt_photopost.tmpl require from the ubbthreads.tmpl the sidebar comes up fine with no SQL errors on the main index. I did notice the code differences in the instructions but found where things needed to go. Interesting that this might be a MYSQL thing as maybe the mysql is not closing from Photopost who knows.

Omegatron... you might check if any of the variables in use by IIP Sidebarpal are also used by photopost. It might get monkeyed up if something you have is trying to use the same variable.

I see well Photopost program itself calls the Threads main.inc.php due to the heavy integration I have. I think I might just have to remove the code for users to change it from left to right until I can figure a workaround. But that is when you are running Photopost. So if I understand what your saying the problem has to located in reality to Michael's integration on the main forum. If I do remove that hack from the main forum we know the problem goes away. I do not understand why Michael's hack would interfere ,Since basically all that is happening is we are opening a MYSQL connection to the photopost database and pulling information. All tables are created within his hack. So it should not pull from the Photopost program itself where it might cause a problem because I make Photopost use Threads headers/footers and CSS. In that case I can understand the double global call issue.

Thanx for the tip.

I double checked that hack and there are NO GLOBAL CALLS.

Interesting.

it boggled my mind to no end too when I tried to combine them

which one was that one Allen.

the sidebar and photopost

or

photopost and threads.

Just an update to this hack.

Seems that it was not so much a global call issue as the inability to switch between MYSQL databases. I stating thinking why Michael did not have any problems and I did. From helping others I noticed that alot of people use ONE database when they have both Threads and Photopost. Well I always maintained separate databases. I decided to try different things so I put the Photopost tables into my Threads database. Well guess what that solved the issue. So it seems that one can only have one database as otherwise there is a problem switching back and forth between connections.

Except that I have two databases (well, three if you count the RP database which also is seperate).

Interesting then as combining the two databases solved my problems.

Maybe then it is a server related MYSQL issue.

Try this, in ubbt_photopost.tmpl change:

if (!$firstpass) {
if ($j != 0) { print "</table></tr></td></table><br />"; }

I think the problem is that the tables arent being closed out properly when you have more than one cat with no thumbs...?

well I solved it by moving them to all one database.

I think that the tables are fine as the hack itself validates with XHTML fine. If the tables were not closing correctly then the site would not validate. All my categories have thumbs also.

I really think it is some weird mysql server setting that maybe it is not switching from one connection to the other. I think the connection to the Photopost database was not closing and the sidebar was trying to pull info from the Photopost database instead of Threads. Thus the SQL errors. There could be some setting with mysql that we have different that allows it to work on your server and not on mine.

That's a good theory.

You could try adding this to the top of the sidebar

mysql_select_db(threadsDBname);

to see if that makes it switch back.

Well I already went through the trouble of combining the databases. Easier to backup that way anyway but I will try that out on my test site and see what happens.

I noticed the problem on one of my sites where there were more than one category within PhotoPost - if all the cats are in one grouping, then it should be okay. I have to check my hack docs.

Yes I see what your getting at. That would be another problem though I thought you solved that one before.

I am going to give this a shot on my test site and do what recreate the problem and then do what Josh said. I really really think the problem is what I stated. Unlike alot of other servers that configure MYSQL for you when you create a database I have full control and need to apply permissions et all when I create a database which leads me to beleive there is something different in the two mysql setups that prevent the switching back and forth.

I have it installed on my site:

http://drumlines.org/threads/ubbthreads.php?Cat=

But I seem to have some kind of table problem or something when I chose to display the sidebar on the right. The sidebar repeats itself at the bottom at 100%

Login: test
Pass: threadsdev

Ooops, my bad.

My only guess would be that somehow you are including the right sidebar close template twice. It would almost have to be to make it appear twice.

By the way Josh this solved the problem I stated

mysql_select_db(threadsDBname);

So somehow it didn't switch back on it's own.

Well... maybe this will help someone else.
Thanks for trying it.

No problem. Told ya I would test it.

You might want to change that to

mysql_select_db(threadsDBname) or die('Failed to select database threadsDBname');

cool, glad you found the solution

Dave always the wizard.

Can anyone tell me how I can place new menu items ? For example I would also like "forum index" to be in the menu.

Thanks!

pasqualist,

If you edit sidebarpal.php you will see the list in their of what to include. Just mark off in order 1,2,3,4,5,etc what order you would like things included on the sidebar.

No that's not what I mean. In the sidebarpal I only selected "$sidebar_include['menu'] = "1";". In this menu I would also like other items like "forum index" or "links". I think I should do something in "menupal.php", but it seems very complicated in PHP

Okay your question was a little vague and was in the sidebarpal thread.

Okay in menupal.php open it and do the following.

Above:

echo "$tableEnd</td></tr>$tbclose<br />";


Add:

echo "$rowStart<a href="$phpurl/$FrontPage.php?Cat=">Main Index</a>$rowEnd";
echo "$rowStart<a href="$phpurl/linksphp/links.php?op=Links">Links</a>$rowEnd";


That will put the Main Index and Links if you have TLD installed by Fishtails. You should be able to get the jist of how to add something there now.

I agree my posting wasn't very clear My english isn't that good

Thank you very much for the explanation! Works just like I wished. Only....

On the portal screen the link to the Main Index points to "http://www.mydomain.com/.php?Cat=". In the sidebar it works good. (http://www.mydomain.com/forum/ubbthreads.php?Cat=)

Okay just change it to this then forgot this has to be Threads PHPURL

echo "$rowStart<a href="{$config['phpurl']}/ubbthreads.php?Cat">Main Index</a>$rowEnd";

Well, looks like I'll want to take a closer look. Today we hit > 110 users on my boards and it crawled:

Generated in 19.429 seconds in which 19.209 seconds were spent on a total of 47 queries. Zlib compression enabled.

This number does not include the 36 queries for the PhotoPost hack. So, 83 queries per page!

I turned off the SideBar and was left with:

31 queries for UBBThreads
16 queries for the SideBar
36 queries for PhotoPost

I turned off sidebars, but left the PhotoPost in place and my times were reduced:

Generated in 2.328 seconds in which 2.157 seconds were spent on a total of 31 queries. Zlib compression enabled.

(adding in the 36 for PP, that makes 67 queries) - but still in 2.1 seconds.

Clearly the SideBars are adding in some significant time for processing that adversely effects the board when I get alot of users online.

Seems to be the same ole problems with IIP and alot of users on board generating the IIP page as well.

With 73 members online each test run within seconds of each other:

With Sidebar
- Generated in 6.315 seconds in which 6.051 seconds were spent on a total of 47 queries. Zlib compression enabled.
- Generated in 13.029 seconds in which 12.807 seconds were spent on a total of 47 queries. Zlib compression enabled.
- Generated in 12.414 seconds in which 12.289 seconds were spent on a total of 47 queries. Zlib compression enabled.

Without SideBar
- Generated in 5.024 seconds in which 4.92 seconds were spent on a total of 31 queries. Zlib compression enabled.
- Generated in 1.576 seconds in which 1.451 seconds were spent on a total of 31 queries. Zlib compression enabled.
- Generated in 1.762 seconds in which 1.601 seconds were spent on a total of 31 queries. Zlib compression enabled.

I ran each test alternating - on/off/on/off/on/off (imagine those users were a little confused).

I have my code in place to only UPDATE every 10 minutes; but either that isnt working or the remaining queries are still gobbling up alot of processing power.

Seems my code isn't caching properly some of the pages.... The Ca_TimeStamp is incrementing continually.

Generated in 41.25 seconds in which 40.716 seconds were spent on a total of 47 queries. Zlib compression enabled.

Okay, the problem is that $date gets overwritten by a bunch of the pals. I had to rename $date in sidebarpal.php to $iipdate so that my changes would work.

Now my times have decreased significantly as the reload isnt being done on every page load. However, there is still a large load when IIP is being used (almost twice the page generation time).

With 44 online users....

Threads/SideBar/PhotoPost
Generated in 3.235 seconds in which 3.049 seconds were spent on a total of 40 queries. Zlib compression enabled.

Threads/PhotoPost
Generated in 1.626 seconds in which 1.477 seconds were spent on a total of 31 queries. Zlib compression enabled.

Run within seconds of each other - there is still a load that doubles the time to generate the page by the SideBar/IIP code.

I am running with a couple IIPs:

Short Stats
Status Login
Whos Online
Top Posters
Hot Topic
ShoutBox
New User

In running through the list turning one off at a time, I didnt not much of a time difference EXCEPT for New User.

By turning off New User, my times dropped .6 seconds to a full 2 seconds over the averages with New User included.

Dont mind me - just talking through this as I go. But the "problem child" appears to be New User.

that's a lot... If we can't find a way to improve on it some more, we'll definitely need to put a warning in the initial post. It's doubling the time on ~30% more queries, even with your fixes.

Is this for the initial forum summary page? Or for the postlist pages too?

Well, for my setup I only put the sidebars on ubbthreads - I reversed the logic so as to only include it on pages I want it on. So my $iip_call is only set to 1 in ubbthreads to include it there. With sidebars, I turned off the Summary page and have everyone load ubbthreads.php.

All my other pages are nice and snappy; just the index page was giving me problems. With 110+ users online, I'm sure I lost alot when they didnt have their page load for 30+ seconds!

I think its safe to say on any page sidebar is loaded this will be an issue.

Hmmm.... we only get 28 queries on the main index here, and we're running full new post tracking.

I'm wondering if tehre's something with your IIP caching. I run it on measurection and have the photopost sidebar, plus a bunch of other things that use queries and the main index... and in the evenings, when there's usually about 50-70 people online, it seems to zip right along. I'm no longer running the shoutbox. But that was just because I wanted to use the space for some ads.