This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
sermn_wiki:userpages:marta:esbos_116 [2011/11/23 13:23] ferrannp created |
sermn_wiki:userpages:marta:esbos_116 [2020/07/09 12:36] (current) miquel |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Esbós previ per la futura versió 1.1.6 ===== | + | ====== Esbós previ per la futura versió 1.1.6 ====== |
===== Login ===== | ===== Login ===== | ||
* Tres intents per a fer login. | * Tres intents per a fer login. | ||
Line 12: | Line 11: | ||
En qualsevol cas tot serà més senzill si establim un vincle directe entre l' | En qualsevol cas tot serà més senzill si establim un vincle directe entre l' | ||
+ | |||
+ | <WRAP important> | ||
+ | La consulta següent no funciona com s' | ||
+ | </ | ||
< | < | ||
Line 28: | Line 31: | ||
< | < | ||
- | SELECT users.username, groups.longname, | + | SELECT users.name, groups.longname, |
FROM users, usergroups, groups | FROM users, usergroups, groups | ||
WHERE users.id = usergroups.userid | WHERE users.id = usergroups.userid | ||
Line 38: | Line 41: | ||
< | < | ||
- | SELECT users.id, users.username, groups.longname, | + | SELECT users.id, users.name, groups.longname, |
FROM users, usergroups, groups | FROM users, usergroups, groups | ||
WHERE groups.id = usergroups.groupid | WHERE groups.id = usergroups.groupid | ||
Line 89: | Line 92: | ||
< | < | ||
- | SELECT users.username, instruments.longname, | + | SELECT users.name, instruments.longname, |
FROM users, permissions, | FROM users, permissions, | ||
WHERE users.id = permissions.userid | WHERE users.id = permissions.userid |