|
@@ 3129-3133 (lines=5) @@
|
| 3126 |
|
WHERE field_id = $field_id AND tag LIKE '$tag%' ORDER BY tag LIMIT $limit"; |
| 3127 |
|
$result = Database::query($sql); |
| 3128 |
|
$return = array(); |
| 3129 |
|
if (Database::num_rows($result) > 0) { |
| 3130 |
|
while ($row = Database::fetch_array($result, 'ASSOC')) { |
| 3131 |
|
$return[] = array('caption' => $row['tag'], 'value' => $row['tag']); |
| 3132 |
|
} |
| 3133 |
|
} |
| 3134 |
|
if ($return_format == 'json') { |
| 3135 |
|
$return = json_encode($return); |
| 3136 |
|
} |
|
@@ 3193-3197 (lines=5) @@
|
| 3190 |
|
ORDER BY tag"; |
| 3191 |
|
$result = Database::query($sql); |
| 3192 |
|
$return = array(); |
| 3193 |
|
if (Database::num_rows($result) > 0) { |
| 3194 |
|
while ($row = Database::fetch_array($result, 'ASSOC')) { |
| 3195 |
|
$return[$row['id']] = array('tag' => $row['tag'], 'count' => $row['count']); |
| 3196 |
|
} |
| 3197 |
|
} |
| 3198 |
|
|
| 3199 |
|
return $return; |
| 3200 |
|
} |
|
@@ 3226-3230 (lines=5) @@
|
| 3223 |
|
|
| 3224 |
|
$result = Database::query($sql); |
| 3225 |
|
$return = array(); |
| 3226 |
|
if (Database::num_rows($result) > 0) { |
| 3227 |
|
while ($row = Database::fetch_array($result, 'ASSOC')) { |
| 3228 |
|
$return[$row['id']] = array('tag' => $row['tag'], 'count' => $row['count']); |
| 3229 |
|
} |
| 3230 |
|
} |
| 3231 |
|
$user_tags = $return; |
| 3232 |
|
$tag_tmp = array(); |
| 3233 |
|
foreach ($user_tags as $tag) { |