Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- `profile`.`name` AS `Name`,
- `survivor`.`id` AS `PlayerID`,
- replace(replace(replace(substring_index(`survivor`.`state`, ',', 1),'[',''),']',''),'"','') AS `Current Weapon`,
- truncate(left(((SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(`survivor`.`worldspace`, ',[', -1),']]',1),',',1))/100),6),1) AS `y`,
- TRUNCATE(LEFT(((15360-(cast(substring_index(substring_index(substring_index(substring_index(`survivor`.`worldspace`,',[',-1),']]',1),',',2),',',-1) as decimal(16,1))))/100),6),1) AS `x`,
- `survivor`.`worldspace` AS `Position`,
- floor(substring_index(substring_index(`survivor`.`medical`, ',[],', 1),',',-(1))) AS `Blood`,
- concat(' Z: ',
- cast(`profile`.`total_zombie_kills` as char (20) charset utf8),
- ' Pl: ',
- cast((`profile`.`total_bandit_kills` + `profile`.`total_survivor_kills`)
- as char (20) charset utf8)) AS `Kills`
- from
- (`survivor`
- join `profile` ON ((`survivor`.`unique_id` = `profile`.`unique_id`)))
- where
- ((`survivor`.`is_dead` = 0)
- and (`survivor`.`last_updated` >= (now() - interval 30 day)))
- order by (truncate(left(substring_index(substring_index(substring_index(`survivor`.`worldspace`, ',[', -(1)),']]',1),',',1),6),1)
- + truncate(left(substring_index(substring_index(substring_index(substring_index(`survivor`.`worldspace`, ',[', -(1)),']]',1),',',2),',',-(1)),6),1)) desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement