Code: Select all
SELECT * FROM Entrants LEFT JOIN Voters ON Entants.Login=Voters.Login WHERE Voters.Login IS NULL
HTH
DSP
Code: Select all
SELECT * FROM Entrants LEFT JOIN Voters ON Entants.Login=Voters.Login WHERE Voters.Login IS NULL
The idea behind this is that there wouldn't be much to be done by hand - entrants would register their tracks themselves (by title, the author would be a KVR user id for later vote checking), the voting pages (with combo boxes) would be auto-generated basing on the entries list and the results would be auto-computed. Using the KVR login we can assure that only members with 20+ posts can vote (once). The only thing I see that would require administration is the setting of submission/voting start and end dates + technical disqualification of entries (unless there is a way to analyze an mp3/ogg in php to detect the length and bitrate).phz wrote:if ben can find a way (and the time) to knock something up then im more than happy to admin anything that needs doing (ie - entering entrants details each month) ... its GOT to be easier than doing it manually ...
... the only complex thing i see is matching voters to entrants for potential DQ purposes (the sites normal login would ensure only one vote per member surely ??? ) ... and it would need some sort of easy logging system so i could see who has voted (entrant or not) and a few details including their post count ...
Actually, my page is already generated automatically: my monthly work just consists of placing entries in the flatfile db as they're posted.Glooper wrote:Of course other things like the automatic downloader and marklefords radio page will also be able to be created automatically as well.
Who? Me?HansM wrote:Either way, an additional functional requirement would be that nobody can vote for themselves (except the programmers).
HansM wrote:Either way, an additional functional requirement would be that nobody can vote for themselves (except the programmers).
Code: Select all
if ( $votee == $voter ) {
CloseAccount( $voter );
BanIpAddress( $voter );
}
Just a simple validation would be enough. You don't need to kill them. "Is there life after KVR?"farlukar wrote:HansM wrote:Either way, an additional functional requirement would be that nobody can vote for themselves (except the programmers).Code: Select all
if ( $votee == $voter ) { CloseAccount( $voter ); BanIpAddress( $voter ); }
© KVR Audio, Inc. 2000-2024
Submit: News, Plugins, Hosts & Apps | Advertise @ KVR | Developer Account | About KVR / Contact Us | Privacy Statement