Urban Dead Wiki Board
March 29, 2023, 03:36:08 am
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Looking to move this to a different server - without annoying ads.
 
  Home Help Search Links Staff List Calendar Login Register  

Database Error
Please try again. If you come back to this error screen, report the error to an administrator.


SELECT
c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.description,
b.numPosts, b.numTopics, b.ID_PARENT, IFNULL(m.posterTime, 0) AS posterTime,
IFNULL(mem.memberName, m.posterName) AS posterName, m.subject, m.ID_TOPIC,
IFNULL(mem.realName, m.posterName) AS realName,
1 AS isRead, 0 AS new_from,
IFNULL(mem.ID_MEMBER, 0) AS ID_MEMBER, m.ID_MSG,
IFNULL(mods_mem.ID_MEMBER, 0) AS ID_MODERATOR, mods_mem.realName AS modRealName
FROM urbandeadwiki_boards AS b
LEFT JOIN urbandeadwiki_categories AS c ON (c.ID_CAT = b.ID_CAT)
LEFT JOIN urbandeadwiki_messages AS m ON (m.ID_MSG = b.ID_LAST_MSG)
LEFT JOIN urbandeadwiki_members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)
LEFT JOIN urbandeadwiki_moderators AS mods ON (mods.ID_BOARD = b.ID_BOARD)
LEFT JOIN urbandeadwiki_members AS mods_mem ON (mods_mem.ID_MEMBER = mods.ID_MEMBER)
WHERE FIND_IN_SET(-1, b.memberGroups)
AND b.childLevel <= 1 ORDER BY b.boardOrder
Back
Bookmark this site! | Upgrade This Forum
SMF For Free - Create your own Forum


Powered by SMF | SMF © 2016, Simple Machines
Privacy Policy