Editing Maemo.org team/Creating an election

Warning: You are not logged in. Your IP address will be recorded in this page's edit history.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision Your text
Line 191: Line 191:
In a Plain Old mysql client, run the following query:
In a Plain Old mysql client, run the following query:
-
<source lang="sql">
 
  select e.id, e.username, e.firstname, e.lastname, e.email,
  select e.id, e.username, e.firstname, e.lastname, e.email,
         t.election_id, t.tmp_token
         t.election_id, t.tmp_token
  from electorate as e, election_tmp_token as t
  from electorate as e, election_tmp_token as t
  where e.id=t.member_id and e.username='<username>';
  where e.id=t.member_id and e.username='<username>';
-
</source>
 
You can also look using "LIKE" on the username, first name or last name if you need to. This will give you the email/tmp_token pairing which the person can then use to vote, and which you can then send on to them, after verifying that they are who they say they are.
You can also look using "LIKE" on the username, first name or last name if you need to. This will give you the email/tmp_token pairing which the person can then use to vote, and which you can then send on to them, after verifying that they are who they say they are.
[[Category:Community]]
[[Category:Community]]

Learn more about Contributing to the wiki.


Please note that all contributions to maemo.org wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see maemo.org wiki:Copyrights for details). Do not submit copyrighted work without permission!


Cancel | Editing help (opens in new window)