コード例 #1
0
ファイル: tree.library.php プロジェクト: KasaiDot/Dashboard2
 function prepareForInsert($parent, $language)
 {
     if ($parent > 0) {
         $res = sql::query("\n\t\t\t\tSELECT \n\t\t\t\t\t`right` \n\t\t\t\tFROM \n\t\t\t\t\t" . _TABLE_PREFIX_ . "contents \n\t\t\t\tWHERE \n\t\t\t\t\t`ID` = " . $parent . "\n\t\t\t");
         $ref = sql::fetch_array($res, MYSQL_ASSOC);
         $left = intval($ref['right']);
         treeStorage::_createSpace($language, $left, 2);
     } else {
         $res = sql::query("\n\t\t\t\tSELECT \n\t\t\t\t\tMAX(`right`) AS max \n\t\t\t\tFROM \n\t\t\t\t\t" . _TABLE_PREFIX_ . "contents \n\t\t\t\tWHERE \n\t\t\t\t\t`language` = '" . $language . "'\n\t\t\t");
         $ref = sql::fetch_array($res, MYSQL_ASSOC);
         $left = intval($ref['max']) + 1;
     }
     $right = $left + 1;
     return array($left, $right);
 }