Sergey |
|
---|---|
По крайней мере мне не понятна и выборка у esclkm? Вот моя выборка с правами в листе
$guest_read = (isset($cfg['plugin']['userseditpage']['auth_user']))?$cfg['plugin']['userseditpage']['auth_user']:RIGHTS_EMPTY; //переходный переиод
$guest_read = (($guest_read & $rights_r) ==$rights_r);
sed_die(empty($sed_cat[$c]['maker']) and !$usr['isadmin']);
$id_el=$pag['page_id'];
$link_code=$struc_link['structure_id'].':'.$pag['page_id'];
$link_code_ex='-'.$struc_link['structure_id'].':'.$pag['page_id'];
$link_code_want='+'.$struc_link['structure_id'].':'.$pag['page_id'];
//echo $link_code."=link_code <br/>";
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_pages
WHERE (FIND_IN_SET('$c',page_cat)
OR FIND_IN_SET('$c',page_cat_extending))
AND (page_state=0 OR page_state=2)
AND (page_id != $id_el)
AND (NOT FIND_IN_SET('$link_code',page_cat_extending))
AND (NOT FIND_IN_SET('$link_code_ex',page_cat_extending))
AND (NOT FIND_IN_SET('$link_code_want',page_cat_extending))
AND (page_ownerid = {$usr['id']}
OR ((page_rights & $rights_r)=$rights_r)
OR IFNULL(NOT page_rights,('$guest_read')))");
$totallines = sed_sql_result($sql, 0, 0); //echo "totallines=".$totallines."<br/>";
$sql = sed_sql_query("SELECT p.*, u.user_name ".$join_ratings_columns."
FROM $db_pages as p ".$join_ratings_condition."
LEFT JOIN $db_users AS u ON u.user_id=p.page_ownerid
WHERE (FIND_IN_SET('$c',page_cat)
OR FIND_IN_SET('$c',page_cat_extending))
AND (page_state=0 OR page_state=2)
AND (page_id != $id_el)
AND (NOT FIND_IN_SET('$link_code',page_cat_extending))
AND (NOT FIND_IN_SET('$link_code_ex',page_cat_extending))
AND (NOT FIND_IN_SET('$link_code_want',page_cat_extending))
AND (page_ownerid = {$usr['id']}
OR ((page_rights & $rights_r)=$rights_r)
OR IFNULL(NOT page_rights,('$guest_read')))
ORDER BY page_$s $w LIMIT $d,".$cfg['maxrowsperpage']); www.cotonti.mobi
|