Changeset 1089 for trunk/common
- Timestamp:
- 12/22/09 19:17:47 (2 years ago)
- Location:
- trunk/common
- Files:
-
- 2 edited
-
db/tags.php (modified) (2 diffs)
-
tags.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/common/db/tags.php
r1085 r1089 45 45 } 46 46 $query = sprintf( 47 "SELECT %s_id, tag_id ,48 tags.name AS tag_name, tags.type AS tag_type, tags.parent AS tag_parent47 "SELECT %s_id, tag_id AS id, 48 tags.name AS name, tags.type AS type, tags.parent AS parent 49 49 FROM ia_%s_tags AS obj_tags 50 50 LEFT JOIN ia_tags AS tags ON obj_tags.tag_id = tags.id 51 51 WHERE %s_id = %s%s%s 52 ORDER BY tag_name",52 ORDER BY name", 53 53 db_escape($obj), db_escape($obj), db_escape($obj), 54 54 db_quote($obj_id), $where_type, $where_parent … … 104 104 function tag_get_by_ids($tag_ids) { 105 105 $query = sprintf( 106 "SELECT `id` AS tag_id, `name` AS tag_name, 107 `parent` AS tag_parent, `type` AS tag_type 106 "SELECT `id`, `name`, `type`, `parent` 108 107 FROM ia_tags 109 108 WHERE `id` IN (%s)", implode(', ', array_map('db_quote', $tag_ids)) -
trunk/common/tags.php
r1083 r1089 47 47 $tag_names = array(); 48 48 foreach ($tag_list as $tag) { 49 $tag_names[] = $tag[' tag_name'];49 $tag_names[] = $tag['name']; 50 50 } 51 51 return implode(", ", $tag_names); … … 62 62 foreach ($parent_tags as $key => $tag) { 63 63 $parent_tags[$key]['sub_tags'] = Array(); 64 $parent_tags_key[$tag[' tag_id']] = $key;64 $parent_tags_key[$tag['id']] = $key; 65 65 } 66 66 67 67 foreach ($sub_tags as $tag) { 68 log_assert(isset($parent_tags_key[$tag[' tag_parent']]), "Child tag doesn't have a parent");69 $parent_tag_key = $parent_tags_key[$tag[' tag_parent']];68 log_assert(isset($parent_tags_key[$tag['parent']]), "Child tag doesn't have a parent"); 69 $parent_tag_key = $parent_tags_key[$tag['parent']]; 70 70 $parent_tags[$parent_tag_key]['sub_tags'][] = $tag; 71 71 }
Note: See TracChangeset
for help on using the changeset viewer.
![[infoarena] development](/chrome/site/logo.png)