在更新MySQL表的触发器之后,我有以下内容:
CREATE
DEFINER = 'root'@'localhost'
TRIGGER phpbb_rathermenacing.phpbb_bbdkp_memberlist_AUPD
AFTER UPDATE
ON phpbb_rathermenacing.phpbb_bbdkp_memberlist
FOR EACH ROW
BEGIN
IF NEW.member_confirmed = 1 AND
NEW.member_rank_id <>
我试着这样做:
$sql = "SELECT phpbb_users.user_id, phpbb_users.username, phpbb_users.user_colour, topic_poster, phpbb_topics.forum_id, phpbb_forums.forum_price
FROM phpbb_topics LEFT JOIN phpbb_forums ON phpbb_topics.forum_id = phpbb_forums.forum_id
LEFT JOIN phpbb_users ON phpbb_topics.topic_post
我需要从Drupal + phpBB获取最多评论+帖子的用户列表。
我正在使用mySQL。
Drupal数据库的结构: dr_comments(cid,uid) dr_users(uid,名称)
phpBB: phpbb_posts(post_id,poster_id) phpbb_users(user_id,用户名)
我为大多数评论来自Drupal和phpBB而不是一起的用户提供了SQL代码。
Drupal:
SELECT
U.name,
COUNT(C.cid) AS CommentCount
FROM
dr_users AS U
INNER JOIN dr_comments AS
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1024: Cannot modify header information - headers already sent by (output started at /application/libraries/phpbb_library.php:1)
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1024: Cannot modify header information - hea