summary |
shortlog |
log |
commit | commitdiff |
tree
raw |
patch |
inline | side by side (from parent 1:
9a91e19)
Patches applied:
* sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-16
Update a few nationalities.
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='ITA' ) WHERE nick IN
('Dex', 'Lion');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='GBR' ) WHERE nick IN
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='ITA' ) WHERE nick IN
('Dex', 'Lion');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='GBR' ) WHERE nick IN
- ('Stelisevil', 'Ryosuke', 'Healingvizion');
+ ('Stelisevil', 'Ryosuke', 'Healingvizion', 'Nanaki Lioness', 'Sensei', 'ChocoboGhost', 'Afronova', 'Neomancer', 'Usagi', 'Lawrence');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='ESP' ) WHERE nick IN
('Elias');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='SWE' ) WHERE nick IN
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='ESP' ) WHERE nick IN
('Elias');
UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='SWE' ) WHERE nick IN