SELECT id, pseudo, icone, statut, village, date_creation, date_lastvisit FROM PROFIL WHERE (statut > 0 AND id != 2 AND village = 1 AND date_lastvisit > 0) ORDER BY date_lastvisit DESC, id DESC LIMIT 20
Array ( [0] => 20 [1] => Array ( [id] => 1 [pseudo] => Sylvain [icone] => http://village.syti.net/Avatars/Sylvain.jpg [statut] => 10 [village] => 1 [date_creation] => 201010030100 [date_lastvisit] => 202403290553 ) [2] => Array ( [id] => 936 [pseudo] => Sandokan Damaio [icone] => http://village.syti.net/Avatars/Sandokan_Damaio_icone_3.jpg [statut] => 1 [village] => 1 [date_creation] => 202104221049 [date_lastvisit] => 202403290414 ) [3] => Array ( [id] => 16 [pseudo] => Zelda [icone] => http://village.syti.net/Avatars/Zelda_icone.png [statut] => 1 [village] => 1 [date_creation] => 201011142007 [date_lastvisit] => 202403282001 ) [4] => Array ( [id] => 29 [pseudo] => Valérie [icone] => http://village.syti.net/Avatars/Valerie_icone_2.jpg [statut] => 2 [village] => 1 [date_creation] => 201011300154 [date_lastvisit] => 202403271728 ) [5] => Array ( [id] => 992 [pseudo] => ALISKILLAH [icone] => [statut] => 1 [village] => 1 [date_creation] => 202301130844 [date_lastvisit] => 202403271424 ) [6] => Array ( [id] => 10 [pseudo] => yab léo [icone] => http://village.syti.net/Avatars/YabLeo.jpg [statut] => 1 [village] => 1 [date_creation] => 201011032050 [date_lastvisit] => 202403262214 ) [7] => Array ( [id] => 1098 [pseudo] => Arahara [icone] => [statut] => 1 [village] => 1 [date_creation] => 202403261403 [date_lastvisit] => 202403261638 ) [8] => Array ( [id] => 1097 [pseudo] => louflorian [icone] => http://village.syti.net/Avatars/V1_louflorian_icone.jpg [statut] => 1 [village] => 1 [date_creation] => 202403240304 [date_lastvisit] => 202403250111 ) [9] => Array ( [id] => 1029 [pseudo] => log [icone] => [statut] => 1 [village] => 1 [date_creation] => 202309262145 [date_lastvisit] => 202403250101 ) [10] => Array ( [id] => 17 [pseudo] => betatest [icone] => http://village.syti.net/Avatars/betatest.jpg [statut] => 1 [village] => 1 [date_creation] => 201011170552 [date_lastvisit] => 202403231610 ) [11] => Array ( [id] => 3 [pseudo] => Jil [icone] => http://village.syti.net/Avatars/Jil.gif [statut] => 1 [village] => 1 [date_creation] => 201010250000 [date_lastvisit] => 202403220947 ) [12] => Array ( [id] => 894 [pseudo] => Slaashh [icone] => [statut] => 1 [village] => 1 [date_creation] => 202004291323 [date_lastvisit] => 202403200035 ) [13] => Array ( [id] => 969 [pseudo] => Rebilyne [icone] => http://village.syti.net/Avatars/Rebilyne_icone.jpg [statut] => 1 [village] => 1 [date_creation] => 202202152322 [date_lastvisit] => 202403191624 ) [14] => Array ( [id] => 4 [pseudo] => kaliyuga [icone] => http://village.syti.net/Avatars/Kaliyuga2.jpg [statut] => 1 [village] => 1 [date_creation] => 201010261335 [date_lastvisit] => 202403182021 ) [15] => Array ( [id] => 966 [pseudo] => Protagoniste [icone] => [statut] => 1 [village] => 1 [date_creation] => 202112081453 [date_lastvisit] => 202403170125 ) [16] => Array ( [id] => 906 [pseudo] => François [icone] => http://village.syti.net/Avatars/François_icone.jpg [statut] => 1 [village] => 1 [date_creation] => 202009271031 [date_lastvisit] => 202403150830 ) [17] => Array ( [id] => 14 [pseudo] => Dou² [icone] => http://village.syti.net/Avatars/Dou2_2.jpg [statut] => 1 [village] => 1 [date_creation] => 201011092339 [date_lastvisit] => 202403112150 ) [18] => Array ( [id] => 1096 [pseudo] => Phan [icone] => [statut] => 1 [village] => 1 [date_creation] => 202403082037 [date_lastvisit] => 202403082040 ) [19] => Array ( [id] => 1095 [pseudo] => Ricco [icone] => [statut] => 1 [village] => 1 [date_creation] => 202403041524 [date_lastvisit] => 202403051346 ) [20] => Array ( [id] => 1089 [pseudo] => Rêvolutopiste [icone] => http://village.syti.net/Avatars/V1_Revolutopiste_icone_1.jpg [statut] => 1 [village] => 1 [date_creation] => 202402101203 [date_lastvisit] => 202402270954 ) )
Position du jour et de la nuit
Array ( [0] => 20 [1] => Array ( [id] => 1 [pseudo] => Sylvain [icone] => http://village.syti.net/Avatars/Sylvain.jpg [statut] => 10 [village] => 1 [date_creation] => 201010030100 [date_lastvisit] => 202403290553 ) [2] => Array ( [id] => 936 [pseudo] => Sandokan Damaio [icone] => http://village.syti.net/Avatars/Sandokan_Damaio_icone_3.jpg [statut] => 1 [village] => 1 [date_creation] => 202104221049 [date_lastvisit] => 202403290414 ) [3] => Array ( [id] => 16 [pseudo] => Zelda [icone] => http://village.syti.net/Avatars/Zelda_icone.png [statut] => 1 [village] => 1 [date_creation] => 201011142007 [date_lastvisit] => 202403282001 ) [4] => Array ( [id] => 29 [pseudo] => Valérie [icone] => http://village.syti.net/Avatars/Valerie_icone_2.jpg [statut] => 2 [village] => 1 [date_creation] => 201011300154 [date_lastvisit] => 202403271728 ) [5] => Array ( [id] => 992 [pseudo] => ALISKILLAH [icone] => [statut] => 1 [village] => 1 [date_creation] => 202301130844 [date_lastvisit] => 202403271424 ) [6] => Array ( [id] => 10 [pseudo] => yab léo [icone] => http://village.syti.net/Avatars/YabLeo.jpg [statut] => 1 [village] => 1 [date_creation] => 201011032050 [date_lastvisit] => 202403262214 ) [7] => Array ( [id] => 1098 [pseudo] => Arahara [icone] => [statut] => 1 [village] => 1 [date_creation] => 202403261403 [date_lastvisit] => 202403261638 ) [8] => Array ( [id] => 1097 [pseudo] => louflorian [icone] => http://village.syti.net/Avatars/V1_louflorian_icone.jpg [statut] => 1 [village] => 1 [date_creation] => 202403240304 [date_lastvisit] => 202403250111 ) [9] => Array ( [id] => 1029 [pseudo] => log [icone] => [statut] => 1 [village] => 1 [date_creation] => 202309262145 [date_lastvisit] => 202403250101 ) [10] => Array ( [id] => 17 [pseudo] => betatest [icone] => http://village.syti.net/Avatars/betatest.jpg [statut] => 1 [village] => 1 [date_creation] => 201011170552 [date_lastvisit] => 202403231610 ) [11] => Array ( [id] => 3 [pseudo] => Jil [icone] => http://village.syti.net/Avatars/Jil.gif [statut] => 1 [village] => 1 [date_creation] => 201010250000 [date_lastvisit] => 202403220947 ) [12] => Array ( [id] => 894 [pseudo] => Slaashh [icone] => [statut] => 1 [village] => 1 [date_creation] => 202004291323 [date_lastvisit] => 202403200035 ) [13] => Array ( [id] => 969 [pseudo] => Rebilyne [icone] => http://village.syti.net/Avatars/Rebilyne_icone.jpg [statut] => 1 [village] => 1 [date_creation] => 202202152322 [date_lastvisit] => 202403191624 ) [14] => Array ( [id] => 4 [pseudo] => kaliyuga [icone] => http://village.syti.net/Avatars/Kaliyuga2.jpg [statut] => 1 [village] => 1 [date_creation] => 201010261335 [date_lastvisit] => 202403182021 ) [15] => Array ( [id] => 966 [pseudo] => Protagoniste [icone] => [statut] => 1 [village] => 1 [date_creation] => 202112081453 [date_lastvisit] => 202403170125 ) [16] => Array ( [id] => 906 [pseudo] => François [icone] => http://village.syti.net/Avatars/François_icone.jpg [statut] => 1 [village] => 1 [date_creation] => 202009271031 [date_lastvisit] => 202403150830 ) [17] => Array ( [id] => 14 [pseudo] => Dou² [icone] => http://village.syti.net/Avatars/Dou2_2.jpg [statut] => 1 [village] => 1 [date_creation] => 201011092339 [date_lastvisit] => 202403112150 ) [18] => Array ( [id] => 1096 [pseudo] => Phan [icone] => [statut] => 1 [village] => 1 [date_creation] => 202403082037 [date_lastvisit] => 202403082040 ) [19] => Array ( [id] => 1095 [pseudo] => Ricco [icone] => [statut] => 1 [village] => 1 [date_creation] => 202403041524 [date_lastvisit] => 202403051346 ) [20] => Array ( [id] => 1089 [pseudo] => Rêvolutopiste [icone] => http://village.syti.net/Avatars/V1_Revolutopiste_icone_1.jpg [statut] => 1 [village] => 1 [date_creation] => 202402101203 [date_lastvisit] => 202402270954 ) )
Planète
Position du jour et de la nuit
Recherche
Archives du blog