Print Page - Paste-1197093683:v:use

Title: Paste-1197093683:v:use_geshi-1:v:type-php
Post by: Shitiz Garg on Dec 08, 2007, 06:01 AM

SELECT
                     t.ID_TOPIC AS tID_TOPIC, t.ID_BOARD AS tID_BOARD, t.ID_FIRST_MSG, t.isSticky, t.numReplies, t.numViews,
                     m.posterTime, m.ID_TOPIC AS mID_TOPIC, m.ID_MSG, m.subject, m.body, m.ID_MEMBER,
                     b.name AS bname, b.memberGroups, b.ID_BOARD AS bID_BOARD, b.ID_CAT AS bCAT_ID,
                     c.ID_CAT as catID, c.name, mem.realName
                     \".(!$show_newIcon ? \'\' : \",IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) >= m.ID_MSG_MODIFIED AS isRead\" ).\"
               FROM
                   ({$db_prefix}topics AS t, {$db_prefix}categories AS c, {$db_prefix}boards AS b)
                     LEFT JOIN {$db_prefix}messages AS m ON (m.ID_TOPIC = t.ID_FIRST_MSG)
                     LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = m.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
                     LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = m.ID_BOARD AND lmr.ID_MEMBER=$ID_MEMBER)
                     LEFT JOIN {$db_prefix}members AS mem ON (m.ID_MEMBER = mem.ID_MEMBER)
                  WHERE
                     t.ID_BOARD = b.ID_BOARD
                     AND c.ID_CAT = b.ID_CAT
                     AND $user_info[query_see_board]
                     \".(empty($modSettings[\'recycle_enamle\'])?\'\':\"AND b.ID_BOARD != $modSettings[recycle_board]\").\"
\".(empty($boards_id)?\'\':\"AND t.ID_BOARD IN(\".implode(\',\',$boards_id).\") AND b.ID_BOARD IN(\".implode(\',\',$boards_id).\")\").\"
\".(empty($cats_id)?\'\':\"AND t.ID_BOARD IN(\".implode(\',\',$cats_id).\") AND b.ID_BOARD IN(\".implode(\',\',$cats_id).\")\").\"
                     \".(!$stickyOnly?\'\':\"AND t.isSticky = 1\").\"
                     \".($mode == 2 ? \"AND m.ID_TOPIC = t.ID_TOPIC\" : \"AND m.ID_MSG = t.ID_FIRST_MSG\").\"
                  ORDER BY m.\".($mode == 3 ? \"numViews\" : $mode==4 ? \"numReplies\" : \"posterTime\").\" DESC
                  LIMIT $limit\"

Title: Paste-1197093819:v:use_geshi-1:v:type-php
Post by: Guest on Dec 08, 2007, 06:03 AM

\"SELECT
   t.ID_TOPIC AS tID_TOPIC, t.ID_BOARD AS tID_BOARD, t.ID_FIRST_MSG, t.isSticky, t.numReplies, t.numViews,
   m.posterTime, m.ID_TOPIC AS mID_TOPIC, m.ID_MSG, m.subject, m.body, m.ID_MEMBER,
   b.name AS bname, b.memberGroups, b.ID_BOARD AS bID_BOARD, b.ID_CAT AS bCAT_ID,
   c.ID_CAT as catID, c.name, mem.realName
   \".(!$show_newIcon ? \'\' : \",IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) >= m.ID_MSG_MODIFIED AS isRead\" ).\"
FROM
({$db_prefix}topics AS t, {$db_prefix}categories AS c, {$db_prefix}boards AS b)
   LEFT JOIN {$db_prefix}messages AS m ON (m.ID_TOPIC = t.ID_FIRST_MSG)
   LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC = m.ID_TOPIC AND lt.ID_MEMBER = $ID_MEMBER)
LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD = m.ID_BOARD AND lmr.ID_MEMBER=$ID_MEMBER)
   LEFT JOIN {$db_prefix}members AS mem ON (m.ID_MEMBER = mem.ID_MEMBER)
      WHERE
   t.ID_BOARD = b.ID_BOARD
   AND c.ID_CAT = b.ID_CAT
   AND $user_info[query_see_board]
   \".(empty($modSettings[\'recycle_enamle\'])?\'\':\"AND b.ID_BOARD != $modSettings[recycle_board]\").\"
\".(empty($boards_id)?\'\':\"AND t.ID_BOARD IN(\".implode(\',\',$boards_id).\") AND b.ID_BOARD IN(\".implode(\',\',$boards_id).\")\").\"
\".(empty($cats_id)?\'\':\"AND t.ID_BOARD IN(\".implode(\',\',$cats_id).\") AND b.ID_BOARD IN(\".implode(\',\',$cats_id).\")\").\"
    \".(!$stickyOnly?\'\':\"AND t.isSticky = 1\").\"
   \".($mode == 2 ? \"AND m.ID_TOPIC = t.ID_TOPIC\" : \"AND m.ID_MSG = t.ID_FIRST_MSG\").\"
ORDER BY m.\".($mode == 3 ? \"numViews\" : $mode==4 ? \"numReplies\" : \"posterTime\").\" DESC
   LIMIT $limit\"

SleePyCode Forums

Special Site & Other Boards => PasteBin => Topic started by: Shitiz Garg on Dec 08, 2007, 06:01 AM