diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-11-19 01:00:47 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-11-19 01:00:47 +0000 |
| commit | 4294ccf95d9da1f3129c7caae30b1394a225d31f (patch) | |
| tree | c40a81ffaff50a5a4f720ffe958044e47096b1d7 /sql/old/2.4.3/00542_characters.sql | |
| parent | 1f9db80b69379f3abc4b2f8bb5dbc26ec971cc92 (diff) | |
Misc: Whitespace and tabs cleanup
Diffstat (limited to 'sql/old/2.4.3/00542_characters.sql')
| -rw-r--r-- | sql/old/2.4.3/00542_characters.sql | 114 |
1 files changed, 57 insertions, 57 deletions
diff --git a/sql/old/2.4.3/00542_characters.sql b/sql/old/2.4.3/00542_characters.sql index f03c03f900f..9a9703bd122 100644 --- a/sql/old/2.4.3/00542_characters.sql +++ b/sql/old/2.4.3/00542_characters.sql @@ -1,74 +1,74 @@ -UPDATE - `arena_team_member` AS `a`, +UPDATE + `arena_team_member` AS `a`, (SELECT `attq1`.`guid` AS `b_guid`, `atid`, `atpr` - FROM - (SELECT - `guid`, - `name`, + FROM + (SELECT + `guid`, + `name`, SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1545),' ',-1) AS `atid`, - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1550),' ',-1) AS `atpr` - FROM - `characters`) AS `attq1` - INNER JOIN - `arena_team_member` ON `arenateamid` = `atid` AND - `arena_team_member`.`guid` = `attq1`.`guid` - WHERE - `atid` <> 0) - AS `b` -SET - `a`.`personal_rating` = `b`.`atpr` -WHERE - `a`.`arenateamid` = `b`.`atid` AND + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1550),' ',-1) AS `atpr` + FROM + `characters`) AS `attq1` + INNER JOIN + `arena_team_member` ON `arenateamid` = `atid` AND + `arena_team_member`.`guid` = `attq1`.`guid` + WHERE + `atid` <> 0) + AS `b` +SET + `a`.`personal_rating` = `b`.`atpr` +WHERE + `a`.`arenateamid` = `b`.`atid` AND `a`.`guid` = `b`.`b_guid`; -UPDATE - `arena_team_member` AS `a`, +UPDATE + `arena_team_member` AS `a`, (SELECT `attq1`.`guid` AS `b_guid`, `atid`, `atpr` - FROM - (SELECT - `guid`, - `name`, + FROM + (SELECT + `guid`, + `name`, SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1551),' ',-1) AS `atid`, - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1556),' ',-1) AS `atpr` - FROM - `characters`) AS `attq1` - INNER JOIN - `arena_team_member` ON `arenateamid` = `atid` AND - `arena_team_member`.`guid` = `attq1`.`guid` - WHERE - `atid` <> 0) - AS `b` -SET - `a`.`personal_rating` = `b`.`atpr` -WHERE - `a`.`arenateamid` = `b`.`atid` AND + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1556),' ',-1) AS `atpr` + FROM + `characters`) AS `attq1` + INNER JOIN + `arena_team_member` ON `arenateamid` = `atid` AND + `arena_team_member`.`guid` = `attq1`.`guid` + WHERE + `atid` <> 0) + AS `b` +SET + `a`.`personal_rating` = `b`.`atpr` +WHERE + `a`.`arenateamid` = `b`.`atid` AND `a`.`guid` = `b`.`b_guid`; -UPDATE - `arena_team_member` AS `a`, +UPDATE + `arena_team_member` AS `a`, (SELECT `attq1`.`guid` AS `b_guid`, `atid`, `atpr` - FROM - (SELECT - `guid`, - `name`, + FROM + (SELECT + `guid`, + `name`, SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1557),' ',-1) AS `atid`, - SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1562),' ',-1) AS `atpr` - FROM - `characters`) AS `attq1` - INNER JOIN - `arena_team_member` ON `arenateamid` = `atid` AND - `arena_team_member`.`guid` = `attq1`.`guid` - WHERE - `atid` <> 0) - AS `b` -SET - `a`.`personal_rating` = `b`.`atpr` -WHERE - `a`.`arenateamid` = `b`.`atid` AND + SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1562),' ',-1) AS `atpr` + FROM + `characters`) AS `attq1` + INNER JOIN + `arena_team_member` ON `arenateamid` = `atid` AND + `arena_team_member`.`guid` = `attq1`.`guid` + WHERE + `atid` <> 0) + AS `b` +SET + `a`.`personal_rating` = `b`.`atpr` +WHERE + `a`.`arenateamid` = `b`.`atid` AND `a`.`guid` = `b`.`b_guid`; |