| Revision | bb91a7477f9cf87eab2a9c90286d9583981acc77 (tree) |
|---|---|
| Time | 2006-11-06 22:13:08 |
| Author | shizuki <shizuki@1ca2...> |
| Commiter | shizuki |
サブカテゴリの並び順に対応(ordid で並べ替え)
git-svn-id: https://svn.sourceforge.jp/svnroot/nucleus-jp/plugin@482 1ca29b6e-896d-4ea0-84a5-967f57386b96
trunk/NP_Dtree/dtree/dtreedata.php (diff)| @@ -91,14 +91,16 @@ global $CONF, $manager; | ||
| 91 | 91 | $catFilter = '=' . $catFilter; |
| 92 | 92 | } |
| 93 | 93 | |
| 94 | - $query = 'SELECT * FROM %s WHERE catid %s ORDER BY scatid'; | |
| 94 | + $query = 'SELECT * FROM %s WHERE catid %s ORDER BY ordid ASC'; | |
| 95 | +// $query = 'SELECT * FROM %s WHERE catid %s ORDER BY scatid'; | |
| 95 | 96 | $res = sql_query(sprintf($query, sql_table('plug_multiple_categories_sub'), $catFilter)); |
| 96 | 97 | while ($o = mysql_fetch_object($res)) { |
| 97 | 98 | $scatid = intval($o->scatid); |
| 98 | 99 | $nodeArray['subcat'][$scatid] = $n; |
| 99 | 100 | $n++; |
| 100 | 101 | } |
| 101 | - $query = 'SELECT * FROM %s WHERE catid %s ORDER BY scatid'; | |
| 102 | + $query = 'SELECT * FROM %s WHERE catid %s ORDER BY ordid ASC'; | |
| 103 | +// $query = 'SELECT * FROM %s WHERE catid %s ORDER BY scatid'; | |
| 102 | 104 | $res = sql_query(sprintf($query, sql_table('plug_multiple_categories_sub'), $catFilter)); |
| 103 | 105 | $mcategories =& $manager->getPlugin('NP_MultipleCategories'); |
| 104 | 106 | if (method_exists($mcategories, "getRequestName")) { |
Fork