1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59
60. 60
61. 61
62. 62
63. 63
64. 64
65. 65
66. 66
67. 67
68. 68
69. 69
70. 70
71. 71
72. 72
73. 73
74. 74
75. 75
76. 76
77. 77
78. 78
79. 79
80. 80
81. 81
82. 82
83. 83
84. 84
85. 85
86. 86
87. 87
88. 88
89. 89
90. 90

<?php
/*---------------------------------------------------------------------------
*       @Module Name: Clans
* @Description: ClanWars for LiveStreet
* @Version: 1.0
* @Author: trim06
* @LiveStreet Version: 0.3.1
* @File Name: Clans.mapper.class.php
* @License: GNU GPL v2, http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
*----------------------------------------------------------------------------
*/
 
class Mapper_Clans extends Mapper {
        public function AddClan($ownerId, $clanName, $nameUrl, $clanPeople, $clanDesc, $urlHomePage, $pathAvatar)
  {
                $sql = 'INSERT INTO '.DB_TABLE_CLANS.'
                        (owner_id,
                        name,
                        name_url,
      people,
      people_count,
      description,
      reg_date,
      avator,
      url_home_page
                        )
                        VALUES(?d, ?, ?, ?, ?d, ?, NOW(), ?, ?)
                ';
    $clanPeopleCount = count(explode(',', $clanPeople));
                if($this->oDb->query($sql, $ownerId, $clanName, $nameUrl, $clanPeople, $clanPeopleCount, $clanDesc, $pathAvatar, $urlHomePage))
    {
                    $this->DropInviteClanCreate($ownerId);
                        return true;
                }               
                return false;
        }
  
        public function UpdateClan($clanId, $ownerId, $clanPeople, $clanName, $nameUrl, $clanDesc, $urlHomePage, $pathAvatar)
  {
                $sql = 'UPDATE '.DB_TABLE_CLANS.' 
                        SET 
        name = ?,
        name_url = ?,
        people = ?,
        description = ?,'.
        (($pathAvatar) ? "avator = '".$pathAvatar."'," : '').
        'url_home_page = ?,
        people_count = ?d
                        WHERE
                                owner_id = ?d AND id = ?d
                ';
    $clanPeopleCount = count(explode(',', $clanPeople));
                if ($this->oDb->query($sql, $clanName, $nameUrl, $clanPeople, $clanDesc, $urlHomePage, $clanPeopleCount, $ownerId, $clanId))
    {
                        return true;
                }               
                return false;
        }
  public function GetClans($status,&$iCount,$iCurrPage,$iPerPage)
  {
    $sql = 'SELECT * FROM '.DB_TABLE_CLANS.' WHERE status=?d 
AND id NOT IN (SELECT clan_id
                FROM '.DB_TABLE_CLANS_BANS.'
                WHERE ban_active=1
                GROUP BY clan_id)
ORDER BY rating DESC LIMIT ?d, ?d';
    $status = ($status=='good') ? 0 : 1;
    if($aRows=$this->oDb->selectPage($iCount, $sql, $status, ($iCurrPage-1)*$iPerPage, $iPerPage))
    {
      return $aRows;
    }
    return null;
  }
public function GetBannedClans(&$iCount,$iCurrPage,$iPerPage)
  {
    $sql = 'SELECT c.* 
        FROM  
        (SELECT clan_id
                FROM '.DB_TABLE_CLANS_BANS.'
                WHERE ban_active=1
                GROUP BY clan_id) as cb
        JOIN '.DB_TABLE_CLANS.' as c ON c.id=cb.clan_id
        ORDER BY rating 
        DESC LIMIT ?d, ?d';
    if($aRows=$this->oDb->selectPage($iCount, $sql, ($iCurrPage-1)*$iPerPage, $iPerPage))
    {
      return $aRows;
    }
    return null;
  }