Originally posted by The Kins

---

WHY HAVE NONE OF YOU FUCKERS POSTED ABOUT THIS YET?????

---

 $set[userpic]="<img width=60 src=\"$post[picture]\">";

Originally posted by HyperHacker

---

---

- Guests should have post layouts enabled, not disabled

---

Eh, it's kinda better disabled. Googlebots don't waste everyone's bandwidth downloading their layouts, for one. Sometimes I'd browse at school and always was glad guests had layouts off, because I didn't have to log in and change my settings to turn them off. Those computers were much too slow and some layouts back then were much too NSFW for them to be turned on. I'm sure other people are still in the same position.

---

static inline uint64_t rbeu64(char *p)

{

    return (    (((uint64_t)(((unsigned char *)p)[0]))<<56)

              | (((uint64_t)(((unsigned char *)p)[1]))<<48)

              | (((uint64_t)(((unsigned char *)p)[2]))<<40)

              | (((uint64_t)(((unsigned char *)p)[3]))<<32)

              | (((uint64_t)(((unsigned char *)p)[4]))<<24)

              | (((uint64_t)(((unsigned char *)p)[5]))<<16)

              | (((uint64_t)(((unsigned char *)p)[6]))<<8)

              |  ((uint64_t)(((unsigned char *)p)[7]))         );

}

Originally posted by ||bass in IRC

---

Nov 26 23:33:56 ||bass the following query is wrong:
Nov 26 23:33:58 ||bass SELECT p.*,text,headtext,signtext,edited,options,tagval,u.id uid,name,posts,sex,powerlevel,picture,title,useranks,location,lastposttime,lastactivity,imood,skype,regdate FROM posts p,posts_text LEFT JOIN users uON p.user=u.id WHERE thread=9277 AND p.id=pid ORDER BY p.id LIMIT 0,100
Nov 26 23:34:13 ||bass SELECT p.*,text,headtext,signtext,edited,options,tagval,u.id uid,name,posts,sex,powerlevel,picture,title,useranks,location,lastposttime,lastactivity,imood,skype,regdate FROM posts_text, posts p LEFT JOIN users uON p.user=u.id WHERE thread=9277 AND p.id=pid ORDER BY p.id LIMIT 0,100
Nov 26 23:34:28 ||bass notice the very subtle difference
Nov 26 23:34:33 ||bass because
Nov 26 23:34:48 ||bass since you are using p in the ON clause
Nov 26 23:34:58 ||bass posts p has to be an immediate operand of the join
Nov 26 23:35:47 ||bass that is actual standardized sql syntax
Nov 26 23:36:03 ||bass i know mysql4 let you use any table from anywhere in the query in the join
Nov 26 23:36:12 ||bass for the on clause
Nov 26 23:36:21 ||bass but, at least if you read the standard
Nov 26 23:36:28 ||bass it's explicitly supposed to fail
Nov 26 23:36:31 ||bass which it does in php5
Nov 26 23:37:02 ||bass because the name resolution for an ON clause is only supposed to look as far as the immediate operands of the join keywords
Nov 26 23:37:40 ||bass i actually read the section of the standard in question last night when this came up and xkeeper asked me what was going on
Nov 26 23:38:40 ||bass the mysql 5 documentation cites it

---