DreamCom: Porovnání verzí
Z Wiki UnArt Slavičín
Skočit na navigaciSkočit na vyhledávání
Bez shrnutí editace |
Bez shrnutí editace |
||
| Řádek 1: | Řádek 1: | ||
Import telefonních čísel z Freenetisu: | Import telefonních čísel z Freenetisu: | ||
SQL dotaz pro výpis dat z Freenetisu ve formátu, který chce DreamCom: | |||
SET NAMES "CP1250"; | |||
SELECT "" as "ID", "" as "ID skupin", name as "Křestní jméno", surname as "Příjmení", | SELECT "" as "ID", "" as "ID skupin", name as "Křestní jméno", surname as "Příjmení", | ||
"" as "Přezdívka", concat(name, " ", surname) as "Jméno", phone as "Tel. číslo", | "" as "Přezdívka", concat(name, " ", surname) as "Jméno", phone as "Tel. číslo", | ||
| Řádek 9: | Řádek 10: | ||
"True" as "Potvrzení", "True" as "Identifikace", "False" as "Flash", | "True" as "Potvrzení", "True" as "Identifikace", "False" as "Flash", | ||
"" as "Oslovení", "" as "Podpis", "" as "Svátek", "" as "Narozeniny", | "" as "Oslovení", "" as "Podpis", "" as "Svátek", "" as "Narozeniny", | ||
"" as "Operator", "" as "OperatorCalc", "" as "Note" FROM `freenetis`.`users` | "" as "Operator", "" as "OperatorCalc", "" as "Note" FROM `freenetis`.`users`; | ||
Pozn.: nastavení CP1250 je nutné, díky za tip [http://molhanec.net/mysql_cestina_minifaq.html#korekce článku o češtině a MySQL] | |||
Verze z 14. 9. 2008, 22:44
Import telefonních čísel z Freenetisu:
SQL dotaz pro výpis dat z Freenetisu ve formátu, který chce DreamCom:
SET NAMES "CP1250"; SELECT "" as "ID", "" as "ID skupin", name as "Křestní jméno", surname as "Příjmení", "" as "Přezdívka", concat(name, " ", surname) as "Jméno", phone as "Tel. číslo", "" as "Seznam čísel", email as "Email", "" as "Seznam emailů", "" as "Sms-email", "" as "Typ zprávy", "" as "Skript", "True" as "Potvrzení", "True" as "Identifikace", "False" as "Flash", "" as "Oslovení", "" as "Podpis", "" as "Svátek", "" as "Narozeniny", "" as "Operator", "" as "OperatorCalc", "" as "Note" FROM `freenetis`.`users`;
Pozn.: nastavení CP1250 je nutné, díky za tip článku o češtině a MySQL
