archive-info.com » INFO » A » AVIATIA.INFO

Total: 1

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".

  • ON p post id f forum last post id LEFT JOIN USERS TABLE u ON u user id p poster id ORDER BY f cat id f forum order break if result db sql query sql message die GENERAL ERROR Could not query forums information LINE FILE sql forum data array while row db sql fetchrow result forum data row db sql freeresult result if total forums count forum data message die GENERAL MESSAGE lang No forums Obtain a list of topic ids which contain posts made since user last visited if userdata session logged in sql SELECT t forum id t topic id p post time FROM TOPICS TABLE t POSTS TABLE p WHERE p post id t topic last post id AND p post time userdata user lastvisit AND t topic moved id 0 if result db sql query sql message die GENERAL ERROR Could not query new topic information LINE FILE sql new topic data array while topic data db sql fetchrow result new topic data topic data forum id topic data topic id topic data post time db sql freeresult result Obtain list of moderators of each forum First users then groups broken into two queries sql SELECT aa forum id u user id u username FROM AUTH ACCESS TABLE aa USER GROUP TABLE ug GROUPS TABLE g USERS TABLE u WHERE aa auth mod TRUE AND g group single user 1 AND ug group id aa group id AND g group id aa group id AND u user id ug user id GROUP BY u user id u username aa forum id ORDER BY aa forum id u user id if result db sql query sql message die GENERAL ERROR Could not query forum moderator information LINE FILE sql forum moderators array while row db sql fetchrow result forum moderators row forum id row username db sql freeresult result sql SELECT aa forum id g group id g group name FROM AUTH ACCESS TABLE aa USER GROUP TABLE ug GROUPS TABLE g WHERE aa auth mod TRUE AND g group single user 0 AND g group type sql query sql message die GENERAL ERROR Could not query forum moderator information LINE FILE sql while row db sql fetchrow result forum moderators row forum id row group name db sql freeresult result Find which forums are visible for this user is auth ary array is auth ary auth AUTH VIEW AUTH LIST ALL userdata forum data Start output of page define SHOW ONLINE true page title lang Index include phpbb root path includes page header phpEx template set filenames array body index body tpl template assign vars array TOTAL POSTS sprintf l total post s total posts TOTAL USERS sprintf l total user s total users NEWEST USER sprintf lang Newest user newest user FORUM IMG images forum FORUM NEW IMG images forum new FORUM LOCKED IMG images forum locked L FORUM lang Forum L TOPICS lang Topics L REPLIES lang Replies L VIEWS lang Views

    Original URL path: http://forum.aviatia.info/ (2016-04-29)
    Open archived version from archive