Search options (Page 39 of 77)

And the id does match: navblogs? If so, there's no reason why it shouldn't be working. Make sure the containing div id and <a tag id match and that should work.

A slight alteration may need making to the navlink inclusion in the functions file, just to generate the id. I'll have a peek later.

Edit: Come to think of it, why don't you just add an id to each <a tag in the extra links input box?

That error may not mean it's an invalid search term. I seem to think, (from the error messages I've seen occur on Punres), that the error message function has a somewhat modified output from default. It appears to be the old obscurity method.

You don't need to touch functions.php at all. Forget the functions file. CSS, yes, functions, no. Again, look in your page source. The id is already there. For example, with the blogs which you mentioned:

<div id="punblogs" class="pun">

So that they only change colour whilst you are on the respective page for that navbar link you mean? If so, look through the CSS code for that tabs mod. That does the same thing, just in a different fashion.

In proper context of the English language, however, & is also a word unto itself, and the hyphen is a word join/combine, rather than a separator. I don't know regarding other languages, but the hyphen is perfectly legitimate occuring somewhere within a word, and some words are actually incorrect without it's use.

Code and language are two separate things.

The author of the thread just edits the topic title when they have found the solution.

That's definitely the truth about it not being simple.

So the straight strip replace is definitely not upto the job then. What feasible way is there of matching and extracting inside the query function the parts that need to go into the dblink function? Is it a case of going for full blown preg_replace/preg_match type regexes?

Thanks for all the advice, btw.

Matt

My minds obviously in thick mode again. The bit which I'm just totally not grasping is this:

dblink('dbname=userdb', 'SELECT * FROM ".$this->prefix."users')

With the SELECT statement being hardcoded in, how would it know what to do when a DELETE or such was part of the query, rather than SELECT?

How would things be done for the likes of delete/insert/update? Just been thinking about that. (Dangerous thing for me, I know). But, the statement/action part couldn't be wildcarded or similar as such, could it?

Would it be simpler to just run a second instance of the dblayer, (adjusted accordingly), in parallel with the existing one specifically for the user/group/online tables, rather than trying to work this dblink into the existing dblayer class?

$sql = str_replace($this->prefix."users", "dblink('dbname=userdb', '".$this->prefix."users')", $sql);

That would be roughly the alternative to the MySQL method above?

However, by the looks of that first dblink doc, the select statement for that table also needs to be within that dblink function, along the lines of:

$sql = str_replace($this->prefix."users", "dblink('dbname=userdb', 'select [userdb required columns here] from ".$this->prefix."users')", $sql);

Unless I've misinterpreted that dblink documentation, that wouldn't be feasible using that str_replace method above, would it? Or, have I completely misinterpreted that documentation, as is my usual forte?

Thanks again,

Matt

Would that need to be done throughout the code itself, or should using that within the dblayer query function work?

i.e:

        function query($sql, $unbuffered = false)
        {
                $sql = str_replace($this->prefix.'users', 'userdb.'.$this->prefix.'users', $sql);
                $sql = str_replace($this->prefix.'groups', 'userdb.'.$this->prefix.'groups', $sql);
                $sql = str_replace($this->prefix.'online', 'userdb.'.$this->prefix.'online', $sql);

I've just tried that method within the query function, and it error logs as:

STATEMENT:  SELECT u.*, g.*, o.logged FROM userdb.users AS u INNER JOIN userdb.groups AS g ON u.group_id=g.g_id LEFT JOIN userdb.online AS o ON o.ident='[I.P address]' WHERE u.id=1
ERROR:  3F000: schema "userdb" does not exist
LOCATION:  LookupExplicitNamespace, namespace.c:1289
STATEMENT:  SELECT user_id FROM userdb.online WHERE idle=0
WARNING:  25P01: there is no transaction in progress
LOCATION:  EndTransactionBlock, xact.c:2931

Apologies if I'm missing the point again.

Thanks again,

Matt