Search options (Page 1 of 5)

I get the error when I try to include extern.php

I include the PHP stuff first:

// Include PunBB stuff
    define('PUN_ROOT', 'messageboard/');
    require PUN_ROOT.'include/common.php';
    define('PUN_TURN_OFF_MAINT', 1);
    define('PUN_QUIET_VISIT', 1);

Then include my scripts, which use $db2. Then I include extern.php

Essentially I think that the current database is being switched to my db (as defined by $db2), so when the punbb (extern) code tries to run, it's simply pointing at the wrong database. In other words, punbb relies on the author not switching php/mysql to another database, whether explicitly or implicitly.

I can't believe I'm the only person to come across this. Surely other people are integrating punbb into their pages along with their own scripts?

Any ideas? (Thanks for your help so far)

Alan

$db2 = new DBLayer($dbx_host, $dbx_username, $dbx_password, $dbx_name, $dbx_prefix, $px_connect);

I then call it with:

                    $result = $db2->query($strsql) or error('Unable to fetch topic list', __FILE__, __LINE__, $db2->error());

                    // If there are records returned
                    if ($db2->num_rows($result))
                        {
                            while ($row = $db2->fetch_assoc($result))
                            {
                            }
                        }

Which all works fine. The problem comes when the page then calls extern.php which gives:

PunBB reported: Unable to fetch group info

Database reported: Table 'anotherdb.punbb_groups' doesn't exist (Errno: 1146)

Am I going to have to modify the mysql code in punbb so that the database is switched before every query?
Seems like an inelegant solution but if someone could help me with that I'd appreciate it.

Alan

Thanks.

How do I that?
(sorry I'm going to be a n00b for the 1st ten years!)

Thanks, I thought I'd seen it somewhere.
I did mean a mod to record it somewhere.
The danger of course is that a recording mod puts even more strain on the server!

--Alan

Is there a simple way of outputting time it takes a server to render a punbb page?
It might be a useful mod to make (I might have a go).

The number of concurrent users, number of searches, page views etc. will all contribute, but in my experience (I do IT capacity for a living) it's very hard to model that without resorting to a complex simulation for each setup and usage profile which will be different for every site.

As your server/setup reaches capacity, the average page render time will increase, and that's what you want to keep down to a level acceptable to users. Ideally you'll also not want to stretch your setup to the point where you couldn't carry out admin functions like backups etc.

--Alan

*don't flame me*

Are sub-forums going to be part of 1.3 as standard?
(pretty important to my site!)

--Alan

Use a URL include?

Yeah I used to but I found that I was getting performance issues and my host suggested hard-coding the parameters in. As I understand it, using URL includes puts a lot more load on the server.

Now that I know what to comment out it's not so bad. It does seem to be a flaw with extern.php that you can only use it once in a page because of the repeated calls to parse/dblayer etc. Is there a way of detecting whether a function has already be defined and thus not call for those includes again?

Maybe a small global array in which you store details of which functions have already been defined?

--Alan