Active Topics

 


Reply
Thread Tools
zehjotkah's Avatar
Posts: 2,361 | Thanked: 3,746 times | Joined on Dec 2007 @ Berlin - Love this city!!
#571
For Dave to set up the voting process. Many Thanks!

x.1. * What is the election name/title?
x.2. * What is the question being asked?
x.3. * When will the election open & close?
x.4. * What are the options?
x.5. * How many candidates will be elected? (1 per category, I assume?)
x.6. * Who gets to vote?

1.1.
MeeGo Coding Competition Business & Office Category
1.2.
Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.
1.3.
9/3/11 - 9/18/11 (month/day/year)
1.4.
ClipMan http://competition.meetmeego.org/submissions/13
LUCID iron http://competition.meetmeego.org/submissions/4
MeePasswords http://competition.meetmeego.org/submissions/68
MeeToDo http://competition.meetmeego.org/submissions/74
Nepali Calendar http://competition.meetmeego.org/submissions/2
NewsG http://competition.meetmeego.org/submissions/76
Quick Milk http://competition.meetmeego.org/submissions/78
Wallet http://competition.meetmeego.org/submissions/18
1.5.
Ranking based. First to last of each category.
1.6.
Every maemo.org and meego.com member registered prior to 5/3/11


2.1.
MeeGo Coding Competition System & Utilities Category
2.2.
Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.
2.3.
9/3/11 - 9/18/11 (month/day/year)
2.4.
Audiobook reader http://competition.meetmeego.org/submissions/27
Filebox http://competition.meetmeego.org/submissions/66
ItemNoTe http://competition.meetmeego.org/submissions/83
KhtEditor http://competition.meetmeego.org/submissions/60
MIR Translator http://competition.meetmeego.org/submissions/24
OMWeather http://competition.meetmeego.org/submissions/47
Proximus http://competition.meetmeego.org/submissions/38
QtWeather http://competition.meetmeego.org/submissions/45
stockona http://competition.meetmeego.org/submissions/25
TxPad http://competition.meetmeego.org/submissions/5
Vcounter http://competition.meetmeego.org/submissions/70
2.5.
Ranking based. First to last of each category.
2.6.
Every maemo.org and meego.com member registered prior to 5/3/11


3.1.
MeeGo Coding Competition Network & Communication Category
3.2.
Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.
3.3.
9/3/11 - 9/18/11 (month/day/year)
3.4.
Acid Rain http://competition.meetmeego.org/submissions/34
Aerofy http://competition.meetmeego.org/submissions/42
LinkedUp http://competition.meetmeego.org/submissions/44
Panic Button http://competition.meetmeego.org/submissions/11
Plurker http://competition.meetmeego.org/submissions/77
qgvdial http://competition.meetmeego.org/submissions/53
QNetMan http://competition.meetmeego.org/submissions/28
qwassr http://competition.meetmeego.org/submissions/30
Tweed Suit http://competition.meetmeego.org/submissions/29
Woodchuck http://competition.meetmeego.org/submissions/84
3.5.
Ranking based. First to last of each category.
3.6.
Every maemo.org and meego.com member registered prior to 5/3/11


4.1.
MeeGo Coding Competition Location & Navigation Category
3.2.
Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.
4.3.
9/3/11 - 9/18/11 (month/day/year)
4.4.
Bikster http://competition.meetmeego.org/submissions/58
CloudGPS http://competition.meetmeego.org/submissions/81
FourCircle http://competition.meetmeego.org/submissions/23
Google Places http://competition.meetmeego.org/submissions/71
GPS Sport Sniffer http://competition.meetmeego.org/submissions/43
location2sms http://competition.meetmeego.org/submissions/62
modRana http://competition.meetmeego.org/submissions/80
Nelisquare http://competition.meetmeego.org/submissions/73
PGZ Every Trail http://competition.meetmeego.org/submissions/57
QMLCompass http://competition.meetmeego.org/submissions/59
Quando Parte http://competition.meetmeego.org/submissions/15
4.5.
Ranking based. First to last of each category.
4.6.
Every maemo.org and meego.com member registered prior to 5/3/11


5.1.
MeeGo Coding Competition Graphics & Multimedia Category
5.2.
Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.
5.3.
9/3/11 - 9/18/11 (month/day/year)
5.4.
cuteTube-QML http://competition.meetmeego.org/submissions/3
DLNA Player http://competition.meetmeego.org/submissions/20
FlowPlayer http://competition.meetmeego.org/submissions/56
Mieru http://competition.meetmeego.org/submissions/31
Photographic lightmeter http://competition.meetmeego.org/submissions/12
QSpot http://competition.meetmeego.org/submissions/48
RadioTouch http://competition.meetmeego.org/submissions/63
Xbmcremote http://competition.meetmeego.org/submissions/50
5.5.
Ranking based. First to last of each category.
5.6.
Every maemo.org and meego.com member registered prior to 5/3/11


6.1.
MeeGo Coding Competition Fun & Strange Category
6.2.
Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.
6.3.
9/3/11 - 9/18/11 (month/day/year)
6.4.
BashORGquotations http://competition.meetmeego.org/submissions/64
N900 X-Ray http://competition.meetmeego.org/submissions/22
PGZ Urban Dictionary http://competition.meetmeego.org/submissions/65
p-uae http://competition.meetmeego.org/submissions/69
Rockmarble http://competition.meetmeego.org/submissions/55
6.5.
Ranking based. First to last of each category.
6.6.
Every maemo.org and meego.com member registered prior to 5/3/11


7.1.
MeeGo Coding Competition Desktop & Widgets Category
7.2.
Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.
7.3.
9/3/11 - 9/18/11 (month/day/year)
7.4.
Conky Layout Switcher http://competition.meetmeego.org/submissions/6
Oculo http://competition.meetmeego.org/submissions/14
Packed Media Widget http://competition.meetmeego.org/submissions/87
TcpIpKeyboard http://competition.meetmeego.org/submissions/72
TodoList Widget http://competition.meetmeego.org/submissions/86
7.5.
Ranking based. First to last of each category.
7.6.
Every maemo.org and meego.com member registered prior to 5/3/11


8.1.
MeeGo Coding Competition Games Category
8.2.
Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.
8.3.
9/3/11 - 9/18/11 (month/day/year)
8.4.
Ball Game http://competition.meetmeego.org/submissions/17
Balloon Aliens http://competition.meetmeego.org/submissions/39
Billiardos http://competition.meetmeego.org/submissions/82
Demine http://competition.meetmeego.org/submissions/79
Fracciones http://competition.meetmeego.org/submissions/75
Ghosts Overboard http://competition.meetmeego.org/submissions/36
Inner Spin http://competition.meetmeego.org/submissions/16
Lets MeeGo http://competition.meetmeego.org/submissions/67
MNonograms http://competition.meetmeego.org/submissions/46
Mong http://competition.meetmeego.org/submissions/41
Nanoparticles http://competition.meetmeego.org/submissions/19
Nine Mens Morris Muhle http://competition.meetmeego.org/submissions/51
PGZ Space Invaders http://competition.meetmeego.org/submissions/10
pinball http://competition.meetmeego.org/submissions/9
SchachUhr http://competition.meetmeego.org/submissions/49
Swarm Atakk http://competition.meetmeego.org/submissions/85
Tap em http://competition.meetmeego.org/submissions/40
The Math Game http://competition.meetmeego.org/submissions/26
Tribute http://competition.meetmeego.org/submissions/8
VSpeed http://competition.meetmeego.org/submissions/32
Wordsler http://competition.meetmeego.org/submissions/54
8.5.
Ranking based. First to last of each category.
8.6.
Every maemo.org and meego.com member registered prior to 5/3/11


9.1.
MeeGo Coding Competition Beginners Category
9.2.
Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.
9.3.
9/3/11 - 9/18/11 (month/day/year)
9.4.
Audiobook reader http://competition.meetmeego.org/submissions/27
location2sms http://competition.meetmeego.org/submissions/62
LUCID/iron http://competition.meetmeego.org/submissions/4
MIR Translator http://competition.meetmeego.org/submissions/24
Quando Parte http://competition.meetmeego.org/submissions/15
stockona http://competition.meetmeego.org/submissions/25
The Math Game http://competition.meetmeego.org/submissions/26
TxPad http://competition.meetmeego.org/submissions/5
9.5.
Ranking based. First to last of each category.
6.6.
Every maemo.org and meego.com member registered prior to 5/3/11

Last edited by zehjotkah; 2011-08-31 at 18:59.
 

The Following 13 Users Say Thank You to zehjotkah For This Useful Post:
Helmuth's Avatar
Posts: 1,259 | Thanked: 1,341 times | Joined on Oct 2009 @ Germany
#572
Originally Posted by zehjotkah View Post
x.5. * How many candidates will be elected? (1 per category, I assume?)
Depends if we are able to run with the Council Voting system or not. If I understood correctly there we are able to sort our list of favoirites:

(Quote copied from the old Coding Competition 2010 thread: Link)
Originally Posted by attila77 View Post
Again, I must say the maemo.org council voting mechanism solves this as well , though you don't give points per se, but you order your choices, so it's not only your 'best' vote that counts, but 2nd, 3rd picks, too. Making your points spread per wish is usually not a good idea as just a few voters who go all-in on a single app can change the outcome completely.
As already said last year I don't like (no, I hate) the only 1 vote per caterogy. If you fell in love with 3 applications out of a list of 10 - how could you select only one of this 3 and give the other 2 as many points as the rest of the applications you don't like?

Edit:

Originally Posted by zehjotkah View Post
Ranking based. First to last of each category.
No, currently your ranking is last submission to first of each category. The last submissions are on top and the early birds are on the end of the list.

Edit 2:
Sorry, it's me again. From our Rules:
Code:
•Only users of maemo.org and meego.com who are registered at the time of voting for at least four months are entitled to vote.
So this is in this case not correct:
Originally Posted by zehjotkah View Post
Every maemo.org and meego.com member registered prior to 8/31/11
So I would say if we run it as a forum poll we are forced to run it public. I would volunteer to sort all not valid votes out after the poll ran. Otherwise I see no chance to follow our own rules except the Council Voting system we thought we could and should use.

Last edited by Helmuth; 2011-08-31 at 11:50.
 

The Following 3 Users Say Thank You to Helmuth For This Useful Post:
zehjotkah's Avatar
Posts: 2,361 | Thanked: 3,746 times | Joined on Dec 2007 @ Berlin - Love this city!!
#573
Originally Posted by Helmuth View Post
Depends if we are able to run with the Council Voting system or not. If I understood correctly there we are able to sort our list of favoirites:

(Quote copied from the old Coding Competition 2010 thread: Link)


As already said last year I don't like (no, I hate) the only 1 vote per caterogy. If you fell in love with 3 applications out of a list of 10 - how could you select only one of this 3 and give the other 2 as many points as the rest of the applications you don't like?

Edit:


No, currently your ranking is last submission to first of each category. The last submissions are on top and the early birds are on the end of the list.
The previous post of me is for Dave Neary to build the voting process based on the council voting system. He asked for that information.
The order should be alphabetical. I just haven't had the time to order the submissions correctly.
Ranking: I meant exactly what you mean. The voter is able to vote for not only one submission but to rank all submissions in that category. Or just vote for two or three. First means your preferred one, last means the submission you don't like that much.
 

The Following User Says Thank You to zehjotkah For This Useful Post:
Helmuth's Avatar
Posts: 1,259 | Thanked: 1,341 times | Joined on Oct 2009 @ Germany
#574
Originally Posted by zehjotkah View Post
The previous post of me is for Dave Neary to build the voting process based on the council voting system. He asked for that information.
Ah, in this case forget my previous post and all my Edits.

Should I sort the list for you and post it here?
Or have you put in anyway somewhere on a Spreadsheet.

Edit:
Originally Posted by zehjotkah View Post
Ranking: I meant exactly what you mean. The voter is able to vote for not only one submission but to rank all submissions in that category.
Sometimes I think we should simply post in german to avoid this kind of missunderstanding... and no, improving my english skills is not a solution for me.

Last edited by Helmuth; 2011-08-31 at 11:59.
 
zehjotkah's Avatar
Posts: 2,361 | Thanked: 3,746 times | Joined on Dec 2007 @ Berlin - Love this city!!
#575
fixed alphabetical order and needed registration date for voters.
 

The Following 5 Users Say Thank You to zehjotkah For This Useful Post:
Posts: 1,808 | Thanked: 4,272 times | Joined on Feb 2011 @ Germany
#576
@zjk,

I guess my interest with the competition has come a bit too late, but I'd like to make a donation. Is it still possible?

The only issue is that I would rather NOT use paypal (I cannot convince myself that they're OK). Would it be possible to make a bank transfer? (from Germany).

If so, please let me know by PM (or post account details here if OK).

Thanks a lot in advance.
 

The Following 2 Users Say Thank You to reinob For This Useful Post:
zehjotkah's Avatar
Posts: 2,361 | Thanked: 3,746 times | Joined on Dec 2007 @ Berlin - Love this city!!
#577
I'll just quote a message from Dave here without any comments, because I don't have time this evening.

OK. I'll try to help you through it.

If you are not confident with SQL, try and ask someone else for help. I can provide access (but so can others), but I don't want to spend time doing stuff that anyone else can do. Teach a man to fish & all that.

Step 1: Define the elections (you're done! great)
Step 2: Create the SQL to create the elections. See http://wiki.maemo.org/Maemo.org_team...ng_an_election - especially "Create election in database". Short description: For each election, add to a file "elections.sql":

insert into elections values(
${election_id}, 'elections', '${election_title}', '${start_date}', '${end_date}', ${num_seats}, '${question}');

The election_id should be different for each election. Get the biggest current election_id from http://maemo.org/vote/ (it's 10 right now, so your election_ids will be 11, 12, 13, etc).

Then, add underneath:

INSERT INTO election_choices VALUES
(0, ${election_id}, '${choice_1}'),
(0,${election_id}, '${choice_2}'),
(0,${election_id}, '${choice_3}'),
(0,${election_id}, '${choice_4}'),
...
);

Repeat for each election.

Step 3: Get users.csv off Henri, and run exactly the command I put in the wiki to get the electorate into the database.

Step 4: Modify election instructions (see "Generate election tokens and send out emails") to be what you want people to receive, and give me an email address other than mine which will be the "From" for the emails. Then run the scripts referred to there to generate tmp tokens and email notices out to people.

You're done. The only places where you need help are:
1. Getting users.csv off Henri
2. Need access to the server to run the scripts that create the elections, import the electorate, generate tmp tokens, and send voting instructions.

The things you can (and should) do on your own:
1. Generate the .sql file that creates the elections
2. Modify instructions.txt, and give me an email address to use
3. Handle all of the email related with the election

Ideally, I'll get someone shell access to the server so that you can even do 2 on your own (and you will have to resend tokens to some people too, so I'd prefer that).

Dave.
 

The Following 6 Users Say Thank You to zehjotkah For This Useful Post:
Posts: 324 | Thanked: 371 times | Joined on Dec 2009 @ Vancouver, BC
#578
Here is my attempt at creating the SQL files. Someone else will have to do Step 3 and 4.

Edit: Forgot to mention that in each of the SQL file, the start and end date needs to be set (for example the format 2011-09-03 should work).
Attached Files
File Type: gz elections.tar.gz (1.7 KB, 87 views)

Last edited by Slocan; 2011-09-02 at 19:35.
 

The Following 8 Users Say Thank You to Slocan For This Useful Post:
helex's Avatar
Posts: 543 | Thanked: 802 times | Joined on Apr 2010 @ Germany
#579
Originally Posted by Slocan View Post
Here is my attempt at creating the SQL files.
Thanks!

Currently reviewing. First small mistake found. - election #12 - The last one, Quando Parte has the submission number 15 - not 12.

I'm currently correcting. Will post as soon I finished.
__________________
I was a Qt Ambassador!

Please DONATE if you like my work!
It's the best way to motivate me to create more stuff for your Device.

Last edited by helex; 2011-09-02 at 21:13. Reason: funny typo removed
 

The Following 6 Users Say Thank You to helex For This Useful Post:
helex's Avatar
Posts: 543 | Thanked: 802 times | Joined on Apr 2010 @ Germany
#580
So, here is my correction:
(2 links were mixed up, I added the date in the hopefully correct format (foresightful the 4th of September as start date - unlikely to start it within the next 53 minutes) and done some reformating)

11.election-bo.sql
Code:
INSERT INTO elections VALUES (11, 'elections', 'MeeGo Coding Competition Business & Office Category', '2011-09-04 00:00:00', '2011-09-18 23:59:59', 8, 'Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.');

INSERT INTO election_choices VALUES (0,11,"ClipMan http://competition.meetmeego.org/submissions/13");
INSERT INTO election_choices VALUES (0,11,"LUCID iron http://competition.meetmeego.org/submissions/4");
INSERT INTO election_choices VALUES (0,11,"MeePasswords http://competition.meetmeego.org/submissions/68");
INSERT INTO election_choices VALUES (0,11,"MeeToDo http://competition.meetmeego.org/submissions/74");
INSERT INTO election_choices VALUES (0,11,"Nepali Calendar http://competition.meetmeego.org/submissions/2");
INSERT INTO election_choices VALUES (0,11,"NewsG http://competition.meetmeego.org/submissions/76");
INSERT INTO election_choices VALUES (0,11,"Quick Milk http://competition.meetmeego.org/submissions/78");
INSERT INTO election_choices VALUES (0,11,"Wallet http://competition.meetmeego.org/submissions/18");
12.election-ln.sql
Code:
INSERT INTO elections VALUES (12, 'elections', 'MeeGo Coding Competition Location & Navigation Category', '2011-09-04 00:00:00', '2011-09-18 23:59:59', 11, 'Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.');

INSERT INTO election_choices VALUES (0,12,"Bikster http://competition.meetmeego.org/submissions/58");
INSERT INTO election_choices VALUES (0,12,"CloudGPS http://competition.meetmeego.org/submissions/81");
INSERT INTO election_choices VALUES (0,12,"FourCircle http://competition.meetmeego.org/submissions/23");
INSERT INTO election_choices VALUES (0,12,"Google Places http://competition.meetmeego.org/submissions/71");
INSERT INTO election_choices VALUES (0,12,"GPS Sport Sniffer http://competition.meetmeego.org/submissions/43");
INSERT INTO election_choices VALUES (0,12,"location2sms http://competition.meetmeego.org/submissions/62");
INSERT INTO election_choices VALUES (0,12,"modRana http://competition.meetmeego.org/submissions/80");
INSERT INTO election_choices VALUES (0,12,"Nelisquare http://competition.meetmeego.org/submissions/73");
INSERT INTO election_choices VALUES (0,12,"PGZ Every Trail http://competition.meetmeego.org/submissions/57");
INSERT INTO election_choices VALUES (0,12,"QMLCompass http://competition.meetmeego.org/submissions/59");
INSERT INTO election_choices VALUES (0,12,"Quando Parte http://competition.meetmeego.org/submissions/15");
13.election-su.sql
Code:
INSERT INTO elections VALUES (13, 'elections', 'MeeGo Coding Competition System & Utilities Category', '2011-09-04 00:00:00', '2011-09-18 23:59:59', 11, 'Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.');

INSERT INTO election_choices VALUES (0,13,"Audiobook reader http://competition.meetmeego.org/submissions/27");
INSERT INTO election_choices VALUES (0,13,"Filebox http://competition.meetmeego.org/submissions/66");
INSERT INTO election_choices VALUES (0,13,"ItemNoTe http://competition.meetmeego.org/submissions/83");
INSERT INTO election_choices VALUES (0,13,"KhtEditor http://competition.meetmeego.org/submissions/60");
INSERT INTO election_choices VALUES (0,13,"MIR Translator http://competition.meetmeego.org/submissions/24");
INSERT INTO election_choices VALUES (0,13,"OMWeather http://competition.meetmeego.org/submissions/47");
INSERT INTO election_choices VALUES (0,13,"Proximus http://competition.meetmeego.org/submissions/38");
INSERT INTO election_choices VALUES (0,13,"QtWeather http://competition.meetmeego.org/submissions/45");
INSERT INTO election_choices VALUES (0,13,"stockona http://competition.meetmeego.org/submissions/25");
INSERT INTO election_choices VALUES (0,13,"TxPad http://competition.meetmeego.org/submissions/5");
INSERT INTO election_choices VALUES (0,13,"Vcounter http://competition.meetmeego.org/submissions/70");
14.election-nc.sql
Code:
INSERT INTO elections VALUES (14, 'elections', 'MeeGo Coding Competition Network & Communication Category', '2011-09-04 00:00:00', '2011-09-18 23:59:59', 10, 'Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.');

INSERT INTO election_choices VALUES (0,14,"Acid Rain http://competition.meetmeego.org/submissions/34");
INSERT INTO election_choices VALUES (0,14,"Aerofy http://competition.meetmeego.org/submissions/42");
INSERT INTO election_choices VALUES (0,14,"LinkedUp http://competition.meetmeego.org/submissions/44");
INSERT INTO election_choices VALUES (0,14,"Panic Button http://competition.meetmeego.org/submissions/11");
INSERT INTO election_choices VALUES (0,14,"Plurker http://competition.meetmeego.org/submissions/77");
INSERT INTO election_choices VALUES (0,14,"qgvdial http://competition.meetmeego.org/submissions/53");
INSERT INTO election_choices VALUES (0,14,"QNetMan http://competition.meetmeego.org/submissions/28");
INSERT INTO election_choices VALUES (0,14,"qwassr http://competition.meetmeego.org/submissions/30");
INSERT INTO election_choices VALUES (0,14,"Tweed Suit http://competition.meetmeego.org/submissions/29");
INSERT INTO election_choices VALUES (0,14,"Woodchuck http://competition.meetmeego.org/submissions/84");
15.election-gm.sql
Code:
INSERT INTO elections VALUES (15, 'elections', 'MeeGo Coding Competition Graphics & Multimedia Category', '2011-09-04 00:00:00', '2011-09-18 23:59:59', 8, 'Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.');

INSERT INTO election_choices VALUES (0,15,"cuteTube-QML http://competition.meetmeego.org/submissions/3");
INSERT INTO election_choices VALUES (0,15,"DLNA Player http://competition.meetmeego.org/submissions/20");
INSERT INTO election_choices VALUES (0,15,"FlowPlayer http://competition.meetmeego.org/submissions/56");
INSERT INTO election_choices VALUES (0,15,"Mieru http://competition.meetmeego.org/submissions/31");
INSERT INTO election_choices VALUES (0,15,"Photographic lightmeter http://competition.meetmeego.org/submissions/12");
INSERT INTO election_choices VALUES (0,15,"QSpot http://competition.meetmeego.org/submissions/48");
INSERT INTO election_choices VALUES (0,15,"RadioTouch http://competition.meetmeego.org/submissions/63");
INSERT INTO election_choices VALUES (0,15,"Xbmcremote http://competition.meetmeego.org/submissions/50");
16.election-fs.sql
Code:
INSERT INTO elections VALUES (16, 'elections', 'MeeGo Coding Competition Fun & Strange Category', '2011-09-04 00:00:00', '2011-09-18 23:59:59', 5, 'Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.');

INSERT INTO election_choices VALUES (0,16,"BashORGquotations http://competition.meetmeego.org/submissions/64");
INSERT INTO election_choices VALUES (0,16,"N900 X-Ray http://competition.meetmeego.org/submissions/22");
INSERT INTO election_choices VALUES (0,16,"PGZ Urban Dictionary http://competition.meetmeego.org/submissions/65");
INSERT INTO election_choices VALUES (0,16,"p-uae http://competition.meetmeego.org/submissions/69");
INSERT INTO election_choices VALUES (0,16,"Rockmarble http://competition.meetmeego.org/submissions/55");
17.election-dw.sql
Code:
INSERT INTO elections VALUES (17, 'elections', 'MeeGo Coding Competition Desktop & Widgets Category', '2011-09-04 00:00:00', '2011-09-18 23:59:59', 5, 'Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.');

INSERT INTO election_choices VALUES (0,17,"Conky Layout Switcher http://competition.meetmeego.org/submissions/6");
INSERT INTO election_choices VALUES (0,17,"Oculo http://competition.meetmeego.org/submissions/14");
INSERT INTO election_choices VALUES (0,17,"Packed Media Widget http://competition.meetmeego.org/submissions/87");
INSERT INTO election_choices VALUES (0,17,"TcpIpKeyboard http://competition.meetmeego.org/submissions/72");
INSERT INTO election_choices VALUES (0,17,"TodoList Widget http://competition.meetmeego.org/submissions/86");
18.election-games.sql
Code:
INSERT INTO elections VALUES (18, 'elections', 'MeeGo Coding Competition Games Category', '2011-09-04 00:00:00', '2011-09-18 23:59:59', 21, 'Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.');

INSERT INTO election_choices VALUES (0,18,"Ball Game http://competition.meetmeego.org/submissions/17");
INSERT INTO election_choices VALUES (0,18,"Balloon Aliens http://competition.meetmeego.org/submissions/39");
INSERT INTO election_choices VALUES (0,18,"Billiardos http://competition.meetmeego.org/submissions/82");
INSERT INTO election_choices VALUES (0,18,"Demine http://competition.meetmeego.org/submissions/79");
INSERT INTO election_choices VALUES (0,18,"Fracciones http://competition.meetmeego.org/submissions/75");
INSERT INTO election_choices VALUES (0,18,"Ghosts Overboard http://competition.meetmeego.org/submissions/36");
INSERT INTO election_choices VALUES (0,18,"Inner Spin http://competition.meetmeego.org/submissions/16");
INSERT INTO election_choices VALUES (0,18,"Lets MeeGo http://competition.meetmeego.org/submissions/67");
INSERT INTO election_choices VALUES (0,18,"MNonograms http://competition.meetmeego.org/submissions/46");
INSERT INTO election_choices VALUES (0,18,"Mong http://competition.meetmeego.org/submissions/41");
INSERT INTO election_choices VALUES (0,18,"Nanoparticles http://competition.meetmeego.org/submissions/19");
INSERT INTO election_choices VALUES (0,18,"Nine Mens Morris Muhle http://competition.meetmeego.org/submissions/51");
INSERT INTO election_choices VALUES (0,18,"PGZ Space Invaders http://competition.meetmeego.org/submissions/10");
INSERT INTO election_choices VALUES (0,18,"pinball http://competition.meetmeego.org/submissions/9");
INSERT INTO election_choices VALUES (0,18,"SchachUhr http://competition.meetmeego.org/submissions/49");
INSERT INTO election_choices VALUES (0,18,"Swarm Atakk http://competition.meetmeego.org/submissions/85");
INSERT INTO election_choices VALUES (0,18,"Tap em http://competition.meetmeego.org/submissions/40");
INSERT INTO election_choices VALUES (0,18,"The Math Game http://competition.meetmeego.org/submissions/26");
INSERT INTO election_choices VALUES (0,18,"Tribute http://competition.meetmeego.org/submissions/8");
INSERT INTO election_choices VALUES (0,18,"VSpeed http://competition.meetmeego.org/submissions/32");
INSERT INTO election_choices VALUES (0,18,"Wordsler http://competition.meetmeego.org/submissions/54");
19.election-bg.sql
Code:
INSERT INTO elections VALUES (19, 'elections', 'MeeGo Coding Competition Beginners Category', '2011-09-04 00:00:00', '2011-09-18 23:59:59', 8, 'Please vote for your favourite MeeGo Coding Competition submission (first: best - last: worst). You can also just vote for your favourite.');

INSERT INTO election_choices VALUES (0,19,"Audiobook reader http://competition.meetmeego.org/submissions/27");
INSERT INTO election_choices VALUES (0,19,"location2sms http://competition.meetmeego.org/submissions/62");
INSERT INTO election_choices VALUES (0,19,"LUCID/iron http://competition.meetmeego.org/submissions/4");
INSERT INTO election_choices VALUES (0,19,"MIR Translator http://competition.meetmeego.org/submissions/24");
INSERT INTO election_choices VALUES (0,19,"Quando Parte http://competition.meetmeego.org/submissions/15");
INSERT INTO election_choices VALUES (0,19,"stockona http://competition.meetmeego.org/submissions/25");
INSERT INTO election_choices VALUES (0,19,"The Math Game http://competition.meetmeego.org/submissions/26");
INSERT INTO election_choices VALUES (0,19,"TxPad http://competition.meetmeego.org/submissions/5");
So, I hope everything is now correct. I reviewed it based on this Post. I hope zehjotkah made no other mistakes.

Personally I really hope that someone who has already access AND the knowledge will look if everything is correct and setup the rest to start the voting.
If we made something totally wrong every TMO member will get 9 emails without working voting, we have to explain, to apologize and to start it again. In my opinion it's to dangerous if some random will get access to start it without the needed background what to do and what to avoid.

GOOD LUCK TO ALL OF US! (and lets hope this works finally)
Attached Files
File Type: zip elections.v1.1.ZIP (4.2 KB, 104 views)
__________________
I was a Qt Ambassador!

Please DONATE if you like my work!
It's the best way to motivate me to create more stuff for your Device.
 

The Following 6 Users Say Thank You to helex For This Useful Post:
Reply

Tags
coding, community, competition, contest, development, intel, meego, meetmeego, nokia


 
Forum Jump


All times are GMT. The time now is 13:39.