mambax7 /
xoops-martin
| @@ 463-479 (lines=17) @@ | ||
| 460 | * @param $auction_id |
|
| 461 | * @return array|bool |
|
| 462 | */ |
|
| 463 | public function getRoomList($auction_id) |
|
| 464 | { |
|
| 465 | global $xoopsDB; |
|
| 466 | if (empty($auction_id)) { |
|
| 467 | return false; |
|
| 468 | } |
|
| 469 | $sql = "SELECT gr.room_id,gr.room_count,r.room_name FROM " . $xoopsDB->prefix("martin_auction_room") . " gr |
|
| 470 | left join " . $xoopsDB->prefix("martin_room") . " r ON r.room_id = gr.room_id |
|
| 471 | WHERE auction_id = " . $auction_id; |
|
| 472 | $result = $xoopsDB->query($sql); |
|
| 473 | $rows = array(); |
|
| 474 | while ($row = $xoopsDB->fetchArray($result)) { |
|
| 475 | $rows[] = $row; |
|
| 476 | } |
|
| 477 | ||
| 478 | return $rows; |
|
| 479 | } |
|
| 480 | ||
| 481 | /** |
|
| 482 | * @param $auction_id |
|
| @@ 441-457 (lines=17) @@ | ||
| 438 | * @param $group_id |
|
| 439 | * @return array|bool |
|
| 440 | */ |
|
| 441 | public function getRoomList($group_id) |
|
| 442 | { |
|
| 443 | global $xoopsDB; |
|
| 444 | if (empty($group_id)) { |
|
| 445 | return false; |
|
| 446 | } |
|
| 447 | $sql = "SELECT gr.room_id,gr.room_count,r.room_name FROM " . $xoopsDB->prefix("martin_group_room") . " gr |
|
| 448 | left join " . $xoopsDB->prefix("martin_room") . " r ON r.room_id = gr.room_id |
|
| 449 | WHERE group_id = " . $group_id; |
|
| 450 | $result = $xoopsDB->query($sql); |
|
| 451 | $rows = array(); |
|
| 452 | while ($row = $xoopsDB->fetchArray($result)) { |
|
| 453 | $rows[] = $row; |
|
| 454 | } |
|
| 455 | ||
| 456 | return $rows; |
|
| 457 | } |
|
| 458 | ||
| 459 | /** |
|
| 460 | * @param $group_id |
|
