Allty : Inscription

Inscription GRATUITE !

L'enregistrement sur allty est simple, rapide, et entièrement GRATUIT ! Profite de tous ces services :

Envoi gratuitement des messages à tes amis et à toute la communauté !
Partage des liens, fichiers, et même des videos !
Organise tes rendez-vous et tes sorties !
Découvre des personnes qui partagent tes passions, fais toi de nouveaux amis !
... et plus encore !

Création d'un nouveau compte allty

Ton profil

Choisi un pseudo
Ton email
Mot de passe
Tu es un(e)	Garçon Fille
Anniversaire
Ton pays
Bon plans	Recevoir les bons plans et les offres de allty et de ses partenaires ? Oui non
J'ai pris connaissance des conditions d'utilisation du site et les accepte

© Allty 2008

Execution time: -1219977469.9838 | Queries cached : 0 | Queries without cache : 5 | 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 md5checkSELECT u . * ,
IFNULL( g.id, i.group_id ) `group_id` , g.label `group_label` ,
GROUP_CONCAT( DISTINCT t.tag ) tags,
GROUP_CONCAT( DISTINCT f.username_b ) `people` ,
GROUP_CONCAT( DISTINCT fw.username_b ) `members_followed` ,
GROUP_CONCAT( DISTINCT fw.username_a ) `followers` ,
GROUP_CONCAT( DISTINCT i.guest_email SEPARATOR '\n' ) `guests`
FROM users u
LEFT JOIN users_tags t ON u.username = t.username
LEFT JOIN contacts_groups g ON u.username = g.username
LEFT JOIN contacts f ON u.username = f.username_a AND f.group_id = g.id
LEFT JOIN invits i ON u.username = i.username AND g.id = i.group_id
LEFT JOIN followers fw ON u.username = fw.username_b OR u.username = fw.username_a
WHERE u.username = 'default'
GROUP BY `group_id`
ORDER BY u.username