Author Topic: 4images comments to woltlab burning board  (Read 3262 times)

0 Members and 1 Guest are viewing this topic.

Offline qBass17

  • Addicted member
  • ******
  • Posts: 1.800
  • I ♥ 4I
    • View Profile
4images comments to woltlab burning board
« on: September 07, 2010, 07:55:37 PM »
Ich möchte das die Bilderkommentare auch direkt in die Datenbank von woltlab burning board geschrieben werden. Das hat auch schon funktioniert.
I would like the pictures and comments directly to the database by Burning Board. This has also already works.

              (image_id, user_id, user_name, comment_headline, comment_text, comment_ip, comment_date)
$id, ".$user_info['user_id'].", '$user_name', '$comment_headline', '$comment_text', '".$session_info['session_ip']."', ".time().")";
$commentid $site_db->get_insert_id();
// Forenpost erstellen
$sql "INSERT INTO wbb1_1_post
                 (threadID, enableHtml, username, subject, userID, message, time)
.$image_row['image_thread'].", '0', '$user_name', '$comment_headline',  ".$user_info['user_id'].", '$comment_text', ".time().")";
$commentid $site_db->get_insert_id();

Als nächstes möchte ich, dass die Kommentare auch wieder ausgegeben werden. Es sollen die in der 4images Datenbank eingetragenen Kommentare sowie die aus dem Forum angezeigt werden. Aber das funktioniert nicht richtig, hier der code

Next I would like the comments are also displayed again. It should in the 4images database registered comments, which are displayed from the forum. But that does not work properly, here is the code
  $sql "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date".get_user_table_field(", u.""user_level").get_user_table_field(", u.""user_name").get_user_table_field(", u.""user_email").get_user_table_field(", u.""user_showemail").get_user_table_field(", u.""user_invisible").get_user_table_field(", u.""user_joindate").get_user_table_field(", u.""user_lastaction").get_user_table_field(", u.""user_comments").get_user_table_field(", u.""user_homepage").get_user_table_field(", u.""user_icq").", p.threadID, p.username, p.subject, p.userID, p.message, p.time
          FROM "
          LEFT JOIN "
.USERS_TABLE." u ON (".get_user_table_field("u.""user_id")." = c.user_id)
  LEFT JOIN wbb1_1_post p ON (p.threadID = "
          WHERE c.image_id = 
          ORDER BY c.comment_date ASC"
$result $site_db->query($sql);


Post your comments here