| | 247 | ### Function: BBpress Latest Discussions Sidebar Widget |
|---|
| | 248 | function bbld_widget($args) { |
|---|
| | 249 | global $table_prefix,$wpdb; |
|---|
| | 250 | $forum_slimit = get_option('wpbb_limit'); |
|---|
| | 251 | if (get_option('wpbb_exdb')) { |
|---|
| | 252 | $exbbdb = new wpdb(get_option('wpbb_dbuser'), get_option('wpbb_dbpass'), get_option('wpbb_dbname'), get_option('wpbb_dbhost')); |
|---|
| | 253 | $bbtopic = $exbbdb->get_results("SELECT * FROM ".get_option('wpbb_bbprefix')."topics WHERE topic_status = 0 ORDER BY topic_time DESC LIMIT $forum_slimit"); |
|---|
| | 254 | } |
|---|
| | 255 | else { |
|---|
| | 256 | $bbtopic = $wpdb->get_results("SELECT * FROM ".get_option('wpbb_bbprefix')."topics WHERE topic_status = 0 ORDER BY topic_time DESC LIMIT $forum_slimit"); |
|---|
| | 257 | } |
|---|
| | 258 | if ($bbtopic) { |
|---|
| | 259 | extract($args); |
|---|
| | 260 | echo $before_widget; |
|---|
| | 261 | echo $before_title . __("Forum Last $forum_slimit Discussions") . $after_title; |
|---|
| | 262 | echo '<ul>'; |
|---|
| | 263 | foreach ( $bbtopic as $bbtopic ) { |
|---|
| | 264 | if (get_option('wpbb_exdb')) { |
|---|
| | 265 | $bbforum = $exbbdb->get_row("SELECT * FROM ".get_option('wpbb_bbprefix')."forums WHERE forum_id = '$bbtopic->forum_id'"); |
|---|
| | 266 | } |
|---|
| | 267 | else { |
|---|
| | 268 | $bbforum = $wpdb->get_row("SELECT * FROM ".get_option('wpbb_bbprefix')."forums WHERE forum_id = '$bbtopic->forum_id'"); |
|---|
| | 269 | } |
|---|
| | 270 | if (get_option('wpbb_permalink')) { |
|---|
| | 271 | echo '<li><a href="' . get_option('wpbb_path') . '/topic/' . $bbtopic->topic_id . '">' . __("$bbtopic->topic_title") . '</a><br />'; |
|---|
| | 272 | $forum_url = get_option('wpbb_path') . '/forum/' . $bbtopic->forum_id; |
|---|
| | 273 | } |
|---|
| | 274 | else { |
|---|
| | 275 | echo '<li><a href="' . get_option('wpbb_path') . '/topic.php?id=' . $bbtopic->topic_id . '">' . __("$bbtopic->topic_title") . '</a><br />'; |
|---|
| | 276 | $forum_url = get_option('wpbb_path') . '/forum.php?id=/' . $bbtopic->forum_id; |
|---|
| | 277 | } |
|---|
| | 278 | if (get_option('wpbb_intergrated')) { |
|---|
| | 279 | $wpuid = $wpdb->get_row("SELECT * FROM ".$table_prefix."users WHERE user_login = '$bbtopic->topic_last_poster_name'"); |
|---|
| | 280 | if ($wpuid) { |
|---|
| | 281 | $user_forum_data = "$bbtopic->topic_last_poster_name"; |
|---|
| | 282 | $user_forum_data = get_userdata($wpuid->ID); |
|---|
| | 283 | echo '<small>' . __('Last Post By: ') . $user_forum_data->display_name . '<br />' . __('Inside: ') . '<a href="'.$forum_url.'">' . __("$bbforum->forum_name") . '</a></small></li>'; |
|---|
| | 284 | } |
|---|
| | 285 | else { |
|---|
| | 286 | echo '<small>' . __('Last Post By: ') . $bbtopic->topic_last_poster_name . '<br />' . __('Inside: ') . '<a href="'.$forum_url.'">' . __("$bbforum->forum_name") . '</a></small></li>'; |
|---|
| | 287 | } |
|---|
| | 288 | } |
|---|
| | 289 | else { |
|---|
| | 290 | echo '<small>' . __('Last Post By: ') . $bbtopic->topic_last_poster_name . '<br />' . __('Inside: ') . '<a href="'.$forum_url.'">' . __("$bbforum->forum_name") . '</a></small></li>'; |
|---|
| | 291 | } |
|---|
| | 292 | } |
|---|
| | 293 | echo "</ul>"; |
|---|
| | 294 | echo $after_widget; |
|---|
| | 295 | } |
|---|
| | 296 | } |
|---|
| | 297 | |
|---|
| | 298 | ### Function: Register BbLD Widget |
|---|
| | 299 | function bbld_add_widget() { |
|---|
| | 300 | if (function_exists('register_sidebar_widget')) { |
|---|
| | 301 | register_sidebar_widget('BbLD Widget','bbld_widget'); |
|---|
| | 302 | } |
|---|
| | 303 | } |
|---|
| | 304 | |
|---|
| | 305 | ### Function: Add BbLD Widget |
|---|
| | 306 | add_action('init', 'bbld_add_widget'); |
|---|
| | 307 | |
|---|
