Skip to content

Example select player

mbto edited this page Aug 29, 2021 · 3 revisions

Example select player

For project with merge type by 'Nick':

call PlayerByName('LANCER|RuS|', (select count(*) from `rank`), 'ru');
id kills deaths time_secs rank_id lastseen_datetime last_server_name gaming_time rank_name stars kaomoji
12 117 126 2435 1 2020-05-27 02:39:43 Public Server 40м 35с Сынок 彡ノノノノノ ¯\(ツ)

For project with merge type by 'IP':

call PlayerByIp(inet_aton('51.51.50.226'), (select count(*) from `rank`), 'en');
id kills deaths time_secs rank_id lastseen_datetime last_server_name gaming_time rank_name stars kaomoji
585 24 31 3626163 28 2021-08-27 15:52:27 Public Server 1mo 11d 23h 16m Director 彡彡彡ノノノ (ಥ﹏ಥ)

For project with merge type by 'Steam ID':

call PlayerBySteamId64(76561202255232977, (select count(*) from `rank`), 'ru');
id kills deaths time_secs rank_id lastseen_datetime last_server_name gaming_time rank_name stars kaomoji
53 16 9 914499 10 2021-08-27 15:52:27 Public Server 10дн 14ч 1м Жульбан 彡ノノノノノ (°‿°)
call PlayerBySteamId2('1:2147483624', (select count(*) from `rank`), 'ru');
id kills deaths time_secs rank_id lastseen_datetime last_server_name gaming_time rank_name stars kaomoji
53 16 9 914499 10 2021-08-27 15:52:27 Public Server 10дн 14ч 1м Жульбан 彡ノノノノノ (°‿°)
call Top(15, 'en');
name kills deaths gaming_time rank_name stars kaomoji
leo sena 9999999 5555 7mo 27d 6h 22m Invincible ★★★★★★ (︶︿︶)
co6aka-yJlbl6aka 999999 4444 1mo 11d 4h 58m Boss ★★★★★☆ ლ(ಠ益ಠლ)
Adida$[54 Rus] 99999 3333 2mo 5d 6h 12m Virgin ★★★★★☆ (ノಠ益ಠ)ノ彡
Aleran 88888 2222 3mo 28d 5h 29m Big man ★★★★★☆ (ノಠ益ಠ)ノ彡
lesha 77777 1111 1mo 13d 5h 23m Oldfag ★★★★★☆ t(ಠ益ಠt)
rex (fin) 55555 1110 1mo 11h 1m Spetsnaz ★★★★☆☆ t(ಠ益ಠt)
GraySk 9999 1010 8mo 13d 14h 3m Sensei ★★★★☆☆ ( ° ͜ʖ °)
zomb 8888 5050 1year 1mo 19d 5h 56m Big brute ★★★★☆☆ ( ° ͜ʖ °)
Aizek 7777 20 10mo 1d 6h 8m Fighter ★★★★☆☆ (ノ°ヮ°)ノ*:・゚✧
(Loet)Mil4 9 1 3mo 27d 21h 53m Man ★★★★☆☆ (ノ°ヮ°)ノ*:・゚✧
-=220Volt=- 33 40 8mo 19d 8h 9m Mercenary ★★★☆☆☆ (づ° ³°)づ
Dudek 26 24 2mo 10d 8h 30m Freeloader ★★★☆☆☆ (づ° ³°)づ
!ak-47!CA(I)A 8 10 2years 2mo 12d 16h 9m Director ★★★☆☆☆ (ಥ﹏ಥ)
SinneRs.tmkilled 5 13 2years 2mo 5d 13h 53m Director ★★★☆☆☆ (ಥ﹏ಥ)
D@NIL{RUSSIA 59 REGION} 17 12 2years 1mo 26d 22h 35m Director ★★★☆☆☆ (ಥ﹏ಥ)
call Top(15, 'ru');
name kills deaths gaming_time rank_name stars kaomoji
leo sena 9999999 5555 7мес 27дн 6ч 22м Непобедимый ★★★★★★ (︶︿︶)
co6aka-yJlbl6aka 999999 4444 1мес 11дн 4ч 58м Босс ★★★★★☆ ლ(ಠ益ಠლ)
Adida$[54 Rus] 99999 3333 2мес 5дн 6ч 12м Фраер ★★★★★☆ (ノಠ益ಠ)ノ彡
Aleran 88888 2222 3мес 28дн 5ч 29м Здоровяк ★★★★★☆ (ノಠ益ಠ)ノ彡
lesha 77777 1111 1мес 13дн 5ч 23м Олдфаг ★★★★★☆ t(ಠ益ಠt)
rex (fin) 55555 1110 1мес 11ч 1м Спецназовец ★★★★☆☆ t(ಠ益ಠt)
GraySk 9999 1010 8мес 13дн 14ч 3м Сенсей ★★★★☆☆ ( ° ͜ʖ °)
zomb 8888 5050 1год 1мес 19дн 5ч 56м Громила-здоровяк ★★★★☆☆ ( ° ͜ʖ °)
Aizek 7777 20 10мес 1дн 6ч 8м Боец ★★★★☆☆ (ノ°ヮ°)ノ*:・゚✧
(Loet)Mil4 9 1 3мес 27дн 21ч 53м Мужик ★★★★☆☆ (ノ°ヮ°)ノ*:・゚✧
-=220Volt=- 33 40 8мес 19дн 8ч 9м Йовбак ★★★☆☆☆ (づ° ³°)づ
Dudek 26 24 2мес 10дн 8ч 30м Халявщик ★★★☆☆☆ (づ° ³°)づ
!ak-47!CA(I)A 8 10 2года 2мес 12дн 16ч 9м Директор ★★★☆☆☆ (ಥ﹏ಥ)
SinneRs.tmkilled 5 13 2года 2мес 5дн 13ч 53м Директор ★★★☆☆☆ (ಥ﹏ಥ)
D@NIL{RUSSIA 59 REGION} 17 12 2года 1мес 26дн 22ч 35м Директор ★★★☆☆☆ (ಥ﹏ಥ)
Clone this wiki locally