Nouveaux membres

Messages / Messages texte

test

matt il y a 8 mois via web | 0 réponse(s) / Répondre |

test

matt il y a 8 mois via web | 0 réponse(s) / Répondre |

ta gueule !

matt il y a 8 mois via web | 0 réponse(s) / Répondre |

jhegzgdj egzhjdg ehjzdg jezgdhjg jzehgd jezgdjhegzhjdg ed g ejz de z dzged gzej dgjez dhz dezjhegzgdj egzhjdg ehjzdg jezgdhjg jzehgd jezgdjhegzhjdg ed [...]

matt il y a 8 mois via web | 0 réponse(s) / Répondre |

zekjdh zehjkdezdezdjkezzhd

matt il y a 8 mois via web | 0 réponse(s) / Répondre |

heckz hfkzej zf kzcjfhzkefhk zjefhc kz fchkzhfck zLegi, Patres colendissimi, in Arabum monumentis, interrogatum Abdalam 1 Sarracenum, quid in hac quas [...]

matt il y a 8 mois via web | 0 réponse(s) / Répondre |

nouveautÃ©

mariano il y a 8 mois via web | 0 réponse(s) / Répondre |

zxhjs ajzhgs jxag sjgaxhjzsxa

gege_hotmail il y a 9 mois via web | 0 réponse(s) / Répondre |

echkjzhfcezfk ch kjzefck ezcfzf

gege_hotmail il y a 9 mois via web | 0 réponse(s) / Répondre |

hjgjg hjg jhgj g

gege_hotmail il y a 9 mois via web | 0 réponse(s) / Répondre |

premier message

gege_hotmail il y a 9 mois via web | 0 réponse(s) / Répondre |

repetit test ! :p

matt il y a 9 mois via web | 0 réponse(s) / Répondre |

petit test de message ! :-)

matt il y a 9 mois via web | 0 réponse(s) / Répondre |

© Allty 2008

Execution time: -1219976769.3664 | Queries cached : 1 | Queries without cache : 6 | Show / HideSELECT 	SQL_CALC_FOUND_ROWS 
						m.id `id`,
						GROUP_CONCAT(r.`rcpt_username`) `to`,
						m.msg_sent_time `date`,
						m.message,
						m.from_username `sender`,
						m.appid `app`,
						m.msg_replying_to `replying_to`,
						m.users_group `users_group`,
						m.`replies`,
						u.sex `sender_sex`,
						CASE 	WHEN m.msg_type & b'1' THEN 'text'
					 	WHEN m.msg_type & b'100' THEN 'file'
						WHEN m.msg_type & b'10' THEN 'link'
						WHEN m.msg_type & b'1000' THEN 'event'
						WHEN m.msg_type & b'10000' THEN 'video'
						END `content_type`,
IF(m.msg_type & b'10000000', 'public', 'private') `visibility` 
				FROM
					msg `m`
				LEFT JOIN msg_recipients `r` ON(m.id=r.msg_id)
				LEFT JOIN users `u` ON (m.from_username = u.username)
				WHERE 1=1 AND m.msg_type & b'10000000' 

				GROUP BY m.id
				ORDER BY m.id DESC LIMIT 0,30
SELECT FOUND_ROWS() as total, '8d92df9afa1d5d393ce9b20dbb35731a' as md5checkSELECT 	SQL_CALC_FOUND_ROWS 
						m.id `id`,
						GROUP_CONCAT(r.`rcpt_username`) `to`,
						m.msg_sent_time `date`,
						m.message,
						m.from_username `sender`,
						m.appid `app`,
						m.msg_replying_to `replying_to`,
						m.users_group `users_group`,
						m.`replies`,
						u.sex `sender_sex`,
						CASE 	WHEN m.msg_type & b'1' THEN 'text'
					 	WHEN m.msg_type & b'100' THEN 'file'
						WHEN m.msg_type & b'10' THEN 'link'
						WHEN m.msg_type & b'1000' THEN 'event'
						WHEN m.msg_type & b'10000' THEN 'video'
						END `content_type`,
IF(m.msg_type & b'10000000', 'public', 'private') `visibility` 
				FROM
					msg `m`
				LEFT JOIN msg_recipients `r` ON(m.id=r.msg_id)
				LEFT JOIN users `u` ON (m.from_username = u.username)
				WHERE 1=1 AND m.msg_type & b'10000000' 

				GROUP BY m.id
				ORDER BY m.id DESC LIMIT 0,30
SELECT FOUND_ROWS() as total, '8d92df9afa1d5d393ce9b20dbb35731a' as md5check
SELECT GROUP_CONCAT(username) as last_members FROM users WHERE picture=1 ORDER BY date_sub DESC LIMIT 15SELECT 	SQL_CALC_FOUND_ROWS 
						m.id `id`,
						GROUP_CONCAT(r.`rcpt_username`) `to`,
						m.msg_sent_time `date`,
						m.message,
						m.from_username `sender`,
						m.appid `app`,
						m.msg_replying_to `replying_to`,
						m.users_group `users_group`,
						m.`replies`,
						u.sex `sender_sex`,
						CASE 	WHEN m.msg_type & b'1' THEN 'text'
					 	WHEN m.msg_type & b'100' THEN 'file'
						WHEN m.msg_type & b'10' THEN 'link'
						WHEN m.msg_type & b'1000' THEN 'event'
						WHEN m.msg_type & b'10000' THEN 'video'
						END `content_type`,
IF(m.msg_type & b'10000000', 'public', 'private') `visibility` 
				FROM
					msg `m`
				LEFT JOIN msg_recipients `r` ON(m.id=r.msg_id)
				LEFT JOIN users `u` ON (m.from_username = u.username)
				WHERE 1=1 AND m.msg_type & b'10000000' 
 AND m.msg_type & b'1' 

				GROUP BY m.id
				ORDER BY m.id DESC LIMIT 0,30
SELECT FOUND_ROWS() as total, '14583216aa5e5cd331d3d311472f04d1' as md5check