mambax7 /
xoops-martin
| @@ 617-629 (lines=13) @@ | ||
| 614 | * @param $auction_id |
|
| 615 | * @return array|bool |
|
| 616 | */ |
|
| 617 | public function getAuctionBidList($auction_id) |
|
| 618 | { |
|
| 619 | if (!$auction_id) { |
|
| 620 | return false; |
|
| 621 | } |
|
| 622 | global $xoopsDB; |
|
| 623 | $sql = 'SELECT b.*,u.uname FROM ' . $xoopsDB->prefix('martin_auction_bid') . ' b '; |
|
| 624 | $sql .= 'INNER JOIN ' . $xoopsDB->prefix('users') . ' u ON (u.uid = b.uid) '; |
|
| 625 | $sql .= 'WHERE b.auction_id = ' . $auction_id . ' '; |
|
| 626 | $sql .= 'ORDER BY b.bid_price DESC , b.bid_id DESC '; |
|
| 627 | ||
| 628 | return $this->GetRows($sql); |
|
| 629 | } |
|
| 630 | } |
|
| 631 | ||
| @@ 596-608 (lines=13) @@ | ||
| 593 | * @param $group_id |
|
| 594 | * @return array|bool |
|
| 595 | */ |
|
| 596 | public function getGroupJoinList($group_id) |
|
| 597 | { |
|
| 598 | if (!$group_id) { |
|
| 599 | return false; |
|
| 600 | } |
|
| 601 | global $xoopsDB; |
|
| 602 | $sql = 'SELECT j.*,u.uname FROM ' . $xoopsDB->prefix('martin_group_join') . ' j '; |
|
| 603 | $sql .= 'INNER JOIN ' . $xoopsDB->prefix('users') . ' u ON (u.uid = j.uid) '; |
|
| 604 | $sql .= 'WHERE j.group_id = ' . $group_id . ' '; |
|
| 605 | $sql .= 'ORDER BY j.join_id DESC '; |
|
| 606 | ||
| 607 | return $this->GetRows($sql); |
|
| 608 | } |
|
| 609 | ||
| 610 | /** |
|
| 611 | * @check group join exist |
|
