1

(2 replies, posted in PunBB 1.2 troubleshooting)

Any idea?

2

(2 replies, posted in PunBB 1.2 troubleshooting)

Hi All,

I want to know whether any tools can merge the followings CSS

DIV.blockpost DIV.box, DIV.postright, DIV.postfootright {BACKGROUND-COLOR: #f2f5f7}
DIV.blockpost DIV.box {BORDER-COLOR: #D5E5FE #D5E5FE #D5E5FE}

to

DIV.blockpost DIV.box {BACKGROUND-COLOR: #f2f5f7; BORDER-COLOR: #D5E5FE #D5E5FE #D5E5FE}
DIV.postright, DIV.postfootright {BACKGROUND-COLOR: #f2f5f7}

Therefore I can merge three CSS files into one for my forum.

Thanks in advance.

gchoyy

3

(9 replies, posted in PunBB 1.2 troubleshooting)

How about this?

SELECT t.id, t.poster, t.subject, t.num_replies, p.message, p.posted, t.posted, p.id
FROM pun_topics AS t
INNER JOIN pun_forums AS f ON f.id = t.forum_id
INNER JOIN pun_posts AS p ON p.topic_id = t.id
LEFT JOIN pun_forum_perms AS fp ON ( fp.forum_id = f.id
AND fp.group_id =3 )
WHERE (
fp.read_forum IS NULL
OR fp.read_forum =1
)
AND t.moved_to IS NULL
AND f.id
IN ( 1 )
AND t.posted = p.posted             <-----Changed
ORDER BY t.last_post DESC
LIMIT 15

4

(9 replies, posted in PunBB 1.2 troubleshooting)

Yes, I modify from extern.php.

BTW, do you think this is correct way to retrieve the first 15 topics with the message body (no replied post) for a forum:

SELECT t.id, t.poster, t.subject, t.num_replies, p.message, p.posted, p.id
FROM pun_topics AS t
INNER JOIN pun_forums AS f ON f.id = t.forum_id
INNER JOIN pun_posts AS p ON p.topic_id = t.id
LEFT JOIN pun_forum_perms AS fp ON ( fp.forum_id = f.id
AND fp.group_id =3 )
WHERE (
fp.read_forum IS NULL
OR fp.read_forum =1
)
AND t.moved_to IS NULL
AND f.id
IN ( 1 )
group by p.topic_id
ORDER BY t.last_post DESC
LIMIT 15

5

(9 replies, posted in PunBB 1.2 troubleshooting)

It works, but I want to show the first 15 topics with the message body (no replied post) for that forum.

Any ideals?

6

(9 replies, posted in PunBB 1.2 troubleshooting)

Hello,

I got the SQL error "#1064 - You have an error in your SQL syntax near 'SELECT id FROM pun_posts WHERE topic_id = 1) AND t.moved_to IS NULL AND f.id" for the following statement.

SELECT t.id, t.poster, t.subject, t.num_replies, p.message, p.posted, p.id
FROM pun_topics AS t
INNER JOIN pun_forums AS f ON f.id = t.forum_id
INNER JOIN pun_posts AS p ON p.topic_id = t.id
LEFT JOIN pun_forum_perms AS fp ON ( fp.forum_id = f.id
AND fp.group_id =3 )
WHERE (
fp.read_forum IS NULL
OR fp.read_forum =1
)
AND p.id
IN (
SELECT id
FROM pun_posts
WHERE topic_id =1
)
AND t.moved_to IS NULL
AND f.id
IN ( 1 )
ORDER BY t.last_post DESC
LIMIT 15

Any ideas? Please advice.

Regards,

gchoyy

Hi All,

I am trying to put the punbb 1.2.10 login screen (only the interface, not sharing the user db) in the the page of wordpress 1.5.2. So that I

    define('PUN_ROOT', './forum/');
    include './forum/include/common.php';

Actually, I follow these steps http://punbb.org/forums/viewtopic.php?id=8786 to integrate the login. If I create a new blank php file to contain the about codes, it run very well. But if I put the codes inside of the wp's theme, I got the following problem.

I traced that the function check_cookie & set_default_user cannot find the global $db, because I tried to add
   
    echo echo $db->prefix;

inside of these function but it did not echo anything.



Please advice.

Thanks

gchoyy