Any idea?
2 2006-02-14 16:35
Topic: Merge CSS Files (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 2005-11-19 01:54
Re: SQL - Select (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 2005-11-18 07:59
Re: SQL - Select (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 2005-11-18 07:38
Re: SQL - Select (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 2005-11-18 06:14
Topic: SQL - Select (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
7 2005-11-12 03:33
Topic: Integrate with WP (0 replies, posted in PunBB 1.2 modifications, plugins and integrations)
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