| @@ 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 | } |
|