Page 2 of 2
Posted: Wed Dec 21, 2005 6:44 am
by glossy
seremtan wrote:what's needed right now is an admin to confirm this extravagant claim
Code: Select all
SELECT p1.`privmsgs_subject` , u1.`username` , u2.`username` , p2.`privmsgs_text`
FROM rawbert_privmsgs p1, rawbert_privmsgs_text p2, rawbert_users u1, rawbert_users u2
WHERE (
(
p1.`privmsgs_from_userid` =138
AND p1.`privmsgs_to_userid` =30
)
OR (
p1.`privmsgs_from_userid` =30
AND p1.`privmsgs_to_userid` =138
)
)
AND p2.`privmsgs_text_id` = p1.`privmsgs_id`
AND u1.`user_id` = p1.`privmsgs_from_userid`
AND u2.`user_id` = p1.`privmsgs_to_userid`
ORDER BY p1.`privmsgs_date` ASC
Posted: Wed Dec 21, 2005 7:04 pm
by seremtan
what does that mean? i don't speak nerd
Posted: Wed Dec 21, 2005 11:19 pm
by jester!
It is an sql statement returning all pms from one user to another from rawbert tables which are then ordered by date...
Posted: Thu Dec 22, 2005 12:00 am
by GONNAFISTYA
jester! wrote:It is an sql statement returning all pms from one user to another from rawbert tables which are then ordered by date...
Have you always been this fucking gay?
Posted: Thu Dec 22, 2005 2:46 am
by ek
so where the fuck is poohard with them demos
Posted: Thu Dec 22, 2005 2:47 am
by ek
GONNAFISTYA wrote:jester! wrote:It is an sql statement returning all pms from one user to another from rawbert tables which are then ordered by date...
Have you always been this fucking gay?
only for chubby's.
Posted: Thu Dec 22, 2005 4:16 am
by seremtan
ek wrote:so where the fuck is poohard with them demos
don't hold your breath
on second thoughts, do hold your breath. for about 10 years
Posted: Thu Dec 22, 2005 4:24 am
by ek
who knows, we might get lucky and he will bless us with this high rated quake game he has been dribbling about for the past 42k posts
Posted: Fri Dec 23, 2005 6:26 am
by prince1000
duhard is /speconly
Posted: Fri Dec 23, 2005 11:32 am
by ek
heh wow. he is hiding longer then usual, not a single post in 3 days!
Posted: Fri Dec 23, 2005 2:06 pm
by Ezekiel
shaft wrote:lol, dont bother. Poohard wont show.
His loss - not going to hang around for ever. Looks like he'll have to crush me after Christmas now. 
Posted: Sun Dec 25, 2005 5:46 am
by Duhard
okay okay okay...you guys are so mean to me...hmmm
Look, you morons have to understand that I don't have the demos of me crushing that noob anymore..I need some free space for all the demos of ego crushing I dish out every week so, I just get rid of those demos of me crushing noobs, got it?
HOWEVER, I have some screenies to prove it morons..
Posted: Sun Dec 25, 2005 5:47 am
by Duhard
...and that was a cK guy..ouch...
Posted: Sun Dec 25, 2005 8:05 am
by Duhard
Ezekiel wrote:shaft wrote:lol, dont bother. Poohard wont show.
His loss - not going to hang around for ever. Looks like he'll have to crush me after Christmas now.
Christmas, Easter, Valentine's Day...it really doesn't matter moronoid...bottom line, you're gonna get the beating of your life kiddo..