SELECT THREAD.TID, THREAD.FID, THREAD.TITLE, THREAD.LENGTH, THREAD.POLL_FLAG, THREAD.STICKY, THREAD.VIEWCOUNT, USER_THREAD.LAST_READ, USER_THREAD.INTEREST, USER_FOLDER.INTEREST AS FOLDER_INTEREST, UNIX_TIMESTAMP(THREAD.MODIFIED) AS MODIFIED, USER.LOGON, USER.NICKNAME, USER_PEER.PEER_NICKNAME, USER_PEER.RELATIONSHIP FROM DEFAULT_THREAD THREAD LEFT JOIN DEFAULT_USER_THREAD USER_THREAD ON (USER_THREAD.TID = THREAD.TID AND USER_THREAD.UID = 21) LEFT JOIN DEFAULT_USER_FOLDER USER_FOLDER ON (USER_FOLDER.FID = THREAD.FID AND USER_FOLDER.UID = 21) LEFT JOIN USER USER ON (USER.UID = THREAD.BY_UID) LEFT JOIN DEFAULT_USER_PEER USER_PEER ON (USER_PEER.UID = 21 AND USER_PEER.PEER_UID = THREAD.BY_UID) WHERE THREAD.FID IN (1,2,3,4,5,6,7,8,9,11,12,13,14,16,20,22,23,24) AND ((USER_PEER.RELATIONSHIP & 8) = 0 OR USER_PEER.RELATIONSHIP IS NULL) AND ((USER_PEER.RELATIONSHIP & 2) = 0 OR USER_PEER.RELATIONSHIP IS NULL OR THREAD.LENGTH > 1) AND (USER_THREAD.INTEREST IS NULL OR USER_THREAD.INTEREST > -1) AND (USER_FOLDER.INTEREST IS NULL OR USER_FOLDER.INTEREST > -1) AND THREAD.LENGTH > 0 ORDER BY THREAD.STICKY DESC, THREAD.MODIFIED DESC LIMIT 0, 50;
In D:\web\project beehive\beehiveforum: "C:\Program Files\TortoiseCVS\cvs.exe" "-q" "checkout" "-P" "beehiveforum" CVSROOT=:ext:benlumley@beehiveforum.cvs.sourceforge.net:/cvsroot/beehiveforum cvs.exe [checkout aborted]: end of file from server (consult above messages if any) Error, CVS operation failed
aha.
that phrase about nails and heads would be appropriate.
had a feeling it'd be something obvious.
ta.
Is something weird happening with character encoding? I'm seeing the usual weird shit instead of accented characters and currency symbols and stuff, like when unicode's broken.
Is this something you're doing to try to get the RSS working? (giggle)
It's the other way around. Unicode has never worked that well with Beehive, but it now should. In theory. Maybe.
So old posts will have broken unicode characters but new ones won't.
£€àáâãäåèéêëòóĆć
And so forth.
i thought so ....
but i can't login, and i'm not listed on the beehive project either, was there with the list of devs before.
so ... errr.... unsure. finding out!