SWiK
» tagged pages
» logout

(Feed found, click Add Page to syndicate.) Error finding feed, please try again » Find feed title

A Blog Page allows you to add entries, for news or other time sensitive postings

A Bookmarks page is a really simple list of links - ordered by date.

(Login required to save to your tagged pages.)
(or Cancel)

Utilities

  1. Recent Edits
    1. Edits for "Feature Ideas"
  2. Subscribe RSS

Recent Edits

re-created by dland

Feature Ideas

June 8, 2007
The page was created.

[[Referendum]] is an issue voting system.

* "Referendum source code":http://sandbox.sourcelabs.com/referendum/index.phps

Essentially...

» complete change

[[Referendum]] is an issue voting system.

* "Referendum source code":http://sandbox.sourcelabs.com/referendum/index.phps

Essentially Referendum is a simple [[CRUD]] application, users insert votes, issues and ballots, and then read them out in tables.

h1. Ajax Voting

The [[Ajax]] voting system works like this:

# User clicks on a vote

## Ajax fires off a request

## Vote class is set to pending

# Server receives request

## Server deletes all votes for the issue from the user's IP

## A new vote is inserted

## The current tally of votes for the issue is selected from the [[database]] and returned.

# Client receives response - including the tally and the id of the issue.

## Vote tally is updated

## User's vote is set to selected

h1. Database Schema

<pre>

<code>

-- Database: `referendum`

--

-- --------------------------------------------------------

--

-- Table structure for table `ballots`

--

CREATE TABLE `ballots` (

`id` int(11) NOT NULL auto_increment,

`name` varchar(255) collate utf8_unicode_ci NOT NULL default '',

`description` text collate utf8_unicode_ci NOT NULL,

`created` datetime NOT NULL default '0000-00-00 00:00:00',

`updated` timestamp NOT NULL default CURRENT_TIMESTAMP,

`password` varchar(32) collate utf8_unicode_ci NOT NULL default '',

`css` text collate utf8_unicode_ci NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`),

KEY `created` (`created`,`updated`),

FULLTEXT KEY `description` (`description`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--

-- Table structure for table `issues`

--

CREATE TABLE `issues` (

`id` int(11) NOT NULL auto_increment,

`ballot_id` int(11) NOT NULL default '0',

`title` varchar(255) collate utf8_unicode_ci NOT NULL default '',

`description` text collate utf8_unicode_ci NOT NULL,

`created` datetime NOT NULL default '0000-00-00 00:00:00',

`name` varchar(255) collate utf8_unicode_ci NOT NULL default '',

`ip` int(4) NOT NULL default '0',

`link` text collate utf8_unicode_ci NOT NULL,

`approved` tinyint(1) NOT NULL default '0',

`homepage` text collate utf8_unicode_ci NOT NULL,

PRIMARY KEY (`id`),

KEY `ballot_id` (`ballot_id`),

KEY `approved` (`approved`),

FULLTEXT KEY `description` (`description`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--

-- Table structure for table `votes`

--

CREATE TABLE `votes` (

`id` int(11) NOT NULL auto_increment,

`issue_id` int(11) NOT NULL default '0',

`ip` int(4) NOT NULL default '0',

`vote` tinyint(1) NOT NULL default '0',

`time` timestamp NOT NULL default CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),

KEY `ballot_id` (`issue_id`,`ip`,`vote`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=70 ;

</code>

</pre>

h1. Images

* "famfamfam":http://famfamfam.com

Undo this change because:
deleted by 66.79.163.226

Feature Ideas

June 7, 2007
The page and its contents were erased.

Discuss Feature Ideas Here.

* [[RSS]] Feeds for ballots: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img...

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds for ballots: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

** This is a top priority and should be in soon - [[User:alex|alex]]

* Add [[CSS]] Templates - let users pick from CSS templates when creating new ballots.

* -Allow deletion of issues- done

edit by alex

Feature Ideas

March 1, 2006

* -Allow deletion of issues- issues - done

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds for ballots: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

** This is a top priority and should be in soon - [[User:alex|alex]]

* Add [[CSS]] Templates - let users pick from CSS templates when creating new ballots.

* -Allow deletion of issues- issues - done

Undo this change because:
edit by alex

Feature Ideas

March 1, 2006

* -Allow deletion of issues - issues: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=4#forIssue4'><img...

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds for ballots: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

** This is a top priority and should be in soon - [[User:alex|alex]]

* Add [[CSS]] Templates - let users pick from CSS templates when creating new ballots.

* -Allow deletion of issues - issues: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=4#forIssue4'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>- done

edit by alex

Feature Ideas

March 1, 2006

* -Allow Allow deletion of issues: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=4#forIssue4'><img...

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds for ballots: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

** This is a top priority and should be in soon - [[User:alex|alex]]

* Add [[CSS]] Templates - let users pick from CSS templates when creating new ballots.

* -Allow Allow deletion of issues: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=4#forIssue4'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>- done src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

edit by alex

Feature Ideas

February 27, 2006

** This is a top priority and should be in soon - [[User:alex|alex]]

* Add [[CSS]] Templates - let users pick from CSS templates...

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds for ballots: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

** This is a top priority and should be in soon - [[User:alex|alex]]

* Add [[CSS]] Templates - let users pick from CSS templates when creating new ballots.

* Allow deletion of issues: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=4#forIssue4'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

edit by alex

Feature Ideas

February 27, 2006
Referendum Feature-Requests
Undo this change because:
edit by alex

Feature Ideas

February 27, 2006

* Allow deletion of issues: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=4#forIssue4'><img...

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds for ballots: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

* Add [[CSS]] Templates - let users pick from CSS templates when creating new ballots.

* Allow deletion of issues: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=4#forIssue4'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a> src='voteyes.png'></a>

edit by alex

Feature Ideas

February 27, 2006

* Allow deletion of issues: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=4#forIssue4'><img...

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds for ballots: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

* Add [[CSS]] Templates - let users pick from CSS templates when creating new ballots.

* Allow deletion of issues: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=4#forIssue4'><img src='voteyes.png'></a>

edit by alex

Feature Ideas

February 27, 2006

* [[RSS]] Feeds for ballots: Feeds: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds for ballots: Feeds: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

* Add [[CSS]] Templates - let users pick from CSS templates when creating new ballots.

edit by alex

Feature Ideas

February 27, 2006

* Add [[CSS]] Templates

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a>

* Add [[CSS]] Templates

edit by alex

Feature Ideas

February 27, 2006

* [[RSS]] Feeds: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img...

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='http://sandbox.sourcelabs.com/referendum/voteyes.png'></a> src='voteyes.png'></a>

edit by alex

Feature Ideas

February 27, 2006
Feature-Requests
edit by alex

Feature Ideas

February 27, 2006

* [[RSS]] Feeds: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img...

» complete change

Discuss Feature Ideas Here.

* [[RSS]] Feeds: <a rev='vote_for' href='http://sandbox.sourcelabs.com/referendum/index.php?ballot=1&issue=2#forIssue2'><img src='voteyes.png'></a>

created by alex

Feature Ideas

February 27, 2006
The page was created.
Feature Ideas
Article

Discuss Feature Ideas Here.

Undo this change because:
Username:
Password:
(or Cancel)