cosme12 / OpenSoccer

Online Soccer Manager
http://www.opensoccer.org/
GNU General Public License v3.0
0 stars 0 forks source link

Cambios respecto del principal #16

Open cosme12 opened 9 years ago

cosme12 commented 9 years ago

1) Traducción de los tasks de la Licencia de Mánager https://github.com/delight-im/OpenSoccer/pull/245#issuecomment-98518388

2) Traducción de los partidos https://github.com/delight-im/OpenSoccer/pull/250

3) Para editar los nombres de las ligas: UPDATE man_ligen SET land = 'España' WHERE land = 'Spanien'; UPDATE man_spiele SET land = 'España' WHERE land = 'Spanien';

cosme12 commented 9 years ago

Para cambiar nombre a las ligas. UPDATE man_ligen SET name = 'España' WHERE name = 'España'; UPDATE man_ligen SET name = 'Austria' WHERE name = 'Österreich'; UPDATE man_ligen SET name = 'Suiza' WHERE name = 'Schweiz'; UPDATE man_ligen SET name = 'Holanda' WHERE name = 'Niederlande'; UPDATE man_ligen SET name = 'Belgica' WHERE name = 'Belgien'; UPDATE man_ligen SET name = 'Francia' WHERE name = 'Frankreich'; UPDATE man_ligen SET name = 'Suecia' WHERE name = 'Schweden'; UPDATE man_ligen SET name = 'Polonia' WHERE name = 'Polen'; UPDATE man_ligen SET name = 'Inglaterra' WHERE name = 'England'; UPDATE man_ligen SET name = 'Turquia' WHERE name = 'Türkei'; UPDATE man_ligen SET name = 'Alemania' WHERE name = 'Deutschland';

cosme12 commented 9 years ago

Cuando los partidos estan desfazados en +1 usar esto para restar 1 dia a cada partido.

UPDATE man_spiele SET datum = 1432317600-86400 WHERE datum = 1432317600;
UPDATE man_spiele SET datum = 1432317600+86400-86400 WHERE datum = 1432317600+86400;
UPDATE man_spiele SET datum = 1432317600+86400*2-86400 WHERE datum = 1432317600+86400*2;
UPDATE man_spiele SET datum = 1432317600+86400*3-86400 WHERE datum = 1432317600+86400*3;
UPDATE man_spiele SET datum = 1432317600+86400*4-86400 WHERE datum = 1432317600+86400*4;
UPDATE man_spiele SET datum = 1432317600+86400*5-86400 WHERE datum = 1432317600+86400*5;
UPDATE man_spiele SET datum = 1432317600+86400*6-86400 WHERE datum = 1432317600+86400*6;
UPDATE man_spiele SET datum = 1432317600+86400*7-86400 WHERE datum = 1432317600+86400*7;
UPDATE man_spiele SET datum = 1432317600+86400*8-86400 WHERE datum = 1432317600+86400*8;
UPDATE man_spiele SET datum = 1432317600+86400*9-86400 WHERE datum = 1432317600+86400*9;
UPDATE man_spiele SET datum = 1432317600+86400*10-86400 WHERE datum = 1432317600+86400*10;
UPDATE man_spiele SET datum = 1432317600+86400*11-86400 WHERE datum = 1432317600+86400*11;
UPDATE man_spiele SET datum = 1432317600+86400*12-86400 WHERE datum = 1432317600+86400*12;
UPDATE man_spiele SET datum = 1432317600+86400*13-86400 WHERE datum = 1432317600+86400*13;
UPDATE man_spiele SET datum = 1432317600+86400*14-86400 WHERE datum = 1432317600+86400*14;
UPDATE man_spiele SET datum = 1432317600+86400*15-86400 WHERE datum = 1432317600+86400*15;
UPDATE man_spiele SET datum = 1432317600+86400*16-86400 WHERE datum = 1432317600+86400*16;
UPDATE man_spiele SET datum = 1432317600+86400*17-86400 WHERE datum = 1432317600+86400*17;
UPDATE man_spiele SET datum = 1432317600+86400*18-86400 WHERE datum = 1432317600+86400*18;
UPDATE man_spiele SET datum = 1432317600+86400*19-86400 WHERE datum = 1432317600+86400*19;
UPDATE man_spiele SET datum = 1432317600+86400*20-86400 WHERE datum = 1432317600+86400*20;
UPDATE man_spiele SET datum = 1432317600+86400*21-86400 WHERE datum = 1432317600+86400*21;
UPDATE man_spiele SET datum = 1432317600+86400*22-86400 WHERE datum = 1432317600+86400*22;