| @@ 332-343 (lines=12) @@ | ||
| 329 | } |
|
| 330 | ||
| 331 | // Ensure that the table has a 'value' column |
|
| 332 | if ((boolean)Symphony::Database()->fetchVar('Field', 0, sprintf( |
|
| 333 | "SHOW COLUMNS FROM `tbl_entries_data_%d` LIKE '%s'", |
|
| 334 | $this->get('dynamic_options'), |
|
| 335 | 'value' |
|
| 336 | )) |
|
| 337 | ) { |
|
| 338 | $results = Symphony::Database()->fetchCol('value', sprintf( |
|
| 339 | "SELECT DISTINCT `value` |
|
| 340 | FROM `tbl_entries_data_%d` |
|
| 341 | ORDER BY `value` ASC", |
|
| 342 | $this->get('dynamic_options') |
|
| 343 | )); |
|
| 344 | } |
|
| 345 | ||
| 346 | // In the case of a Upload field, use 'file' instead of 'value' |
|
| @@ 347-358 (lines=12) @@ | ||
| 344 | } |
|
| 345 | ||
| 346 | // In the case of a Upload field, use 'file' instead of 'value' |
|
| 347 | if (($results === false) && (boolean)Symphony::Database()->fetchVar('Field', 0, sprintf( |
|
| 348 | "SHOW COLUMNS FROM `tbl_entries_data_%d` LIKE '%s'", |
|
| 349 | $this->get('dynamic_options'), |
|
| 350 | 'file' |
|
| 351 | )) |
|
| 352 | ) { |
|
| 353 | $results = Symphony::Database()->fetchCol('file', sprintf( |
|
| 354 | "SELECT DISTINCT `file` |
|
| 355 | FROM `tbl_entries_data_%d` |
|
| 356 | ORDER BY `file` ASC", |
|
| 357 | $this->get('dynamic_options') |
|
| 358 | )); |
|
| 359 | } |
|
| 360 | ||
| 361 | if ($results) { |
|