| Revision | 77bcbe8c3ac803a1b388e25d12d813aec3ec895b (tree) |
|---|---|
| Time | 2006-10-19 17:21:10 |
| Author | satona <satona@1ca2...> |
| Commiter | satona |
PHP5対応、doAction対策、
＆Script Insertion対策途中
git-svn-id: https://svn.sourceforge.jp/svnroot/nucleus-jp/plugin@459 1ca29b6e-896d-4ea0-84a5-967f57386b96
| @@ -311,7 +311,15 @@ function orderKey(key, sequence) { | ||
| 311 | 311 | $res = sql_query($query); |
| 312 | 312 | $i = 0; |
| 313 | 313 | while($row = mysql_fetch_array($res)) { |
| 314 | - echo 'scatDat['.($i++).'] = new setScatDat('.$row['scatid'].' , "'.$row['sname'].'", "'.$row['sdesc'].'");'."\n"; | |
| 314 | + //<sato(na)0.5j> | |
| 315 | + echo 'scatDat['.($i++).'] = new setScatDat('. | |
| 316 | + $row['scatid']. | |
| 317 | + ' , "'. | |
| 318 | + addslashes($row['sname']). | |
| 319 | + '", "'. | |
| 320 | + addslashes($row['sdesc']). | |
| 321 | + '");'."\n"; | |
| 322 | + //</sato(na)0.5j> | |
| 315 | 323 | } |
| 316 | 324 | echo ' |
| 317 | 325 | scatDat.sort(eval("sort" + key + sequence)); |
| @@ -657,7 +665,10 @@ function orderKey(key, sequence) { | ||
| 657 | 665 | if (!$mycatid && $mysubcatid) $mysubcatid = 0; |
| 658 | 666 | |
| 659 | 667 | $query = 'SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, UNIX_TIMESTAMP(i.itime) as timestamp, i.itime, i.imore as more, m.mnumber as authorid, c.cname as category, i.icat as catid, i.iclosed as closed' ; |
| 660 | - $query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c'; | |
| 668 | + //<sato(na)0.5j> | |
| 669 | + //$query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c'; | |
| 670 | + $query .= ' FROM '.sql_table('category').' as c, '.sql_table('member').' as m, '.sql_table('item').' as i'; | |
| 671 | + //</sato(na)0.5j> | |
| 661 | 672 | |
| 662 | 673 | if ($mycatid) { |
| 663 | 674 | $query .= ' LEFT JOIN '.sql_table('plug_multiple_categories').' as p ON i.inumber=p.item_id'; |
| @@ -835,7 +846,10 @@ function orderKey(key, sequence) { | ||
| 835 | 846 | |
| 836 | 847 | $query = 'SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, i.itime, i.imore as more, m.mnumber as authorid, m.memail as authormail, m.murl as authorurl, c.cname as category, i.icat as catid, i.iclosed as closed'; |
| 837 | 848 | |
| 838 | - $query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c' | |
| 849 | + //<sato(na)0.5j> | |
| 850 | + //$query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c' | |
| 851 | + $query .= ' FROM '.sql_table('category').' as c, '.sql_table('member').' as m, '.sql_table('item').' as i' | |
| 852 | + //</sato(na)0.5j> | |
| 839 | 853 | . ' WHERE i.iblog='.$b->getID() |
| 840 | 854 | . ' and i.iauthor=m.mnumber' |
| 841 | 855 | . ' and i.icat=c.catid' |
Fork
trunk/NP_MultipleCategories/NP_MultipleCategories.php