@@ 77-85 (lines=9) @@ | ||
74 | } elseif ($action == 'static') { |
|
75 | if (is_array($identifier)) { |
|
76 | $banner = $identifier; |
|
77 | } else { |
|
78 | $Qbanner = $OSCOM_Db->prepare('select banners_id, banners_title, banners_image, banners_html_text from :table_banners where banners_id = :banners_id and status = 1'); |
|
79 | $Qbanner->bindInt(':banners_id', $identifier); |
|
80 | $Qbanner->execute(); |
|
81 | ||
82 | if ($Qbanner->fetch() !== false) { |
|
83 | $banner = $Qbanner->toArray(); |
|
84 | } |
|
85 | } |
|
86 | } |
|
87 | ||
88 | $output = ''; |
@@ 135-141 (lines=7) @@ | ||
132 | $Qcountries->execute(); |
|
133 | ||
134 | $countries_array = $Qcountries->toArray(); |
|
135 | } else { |
|
136 | $Qcountries = $OSCOM_Db->prepare('select countries_name from :table_countries where countries_id = :countries_id'); |
|
137 | $Qcountries->bindInt(':countries_id', $countries_id); |
|
138 | $Qcountries->execute(); |
|
139 | ||
140 | $countries_array = $Qcountries->toArray(); |
|
141 | } |
|
142 | } else { |
|
143 | $countries_array = $OSCOM_Db->query('select countries_id, countries_name from :table_countries order by countries_name')->fetchAll(); |
|
144 | } |