I see your problem and feel your pain... Solution: Stop using SQL!

Sorry I couldn't resit that!

Nice solution to the problem!

Major flaw with your first idea... What about people stuck behind a Proxy or NAT firewall or VPN? You can have many-many-many people behind one IP address, particularly now IPv4 addresses have run out. Plus don't forget the transition to IPv6 is going to see an increase in various forms of Tunnelling and NAT in the short term. You would also need code that can handle IPv6 addresses as well. The second idea is better but a bot would defeat it straight away because it could read the text or image of the buttons. If you randomly change a button image each time but it still conveys which button is which to the user, that could work because the bot would have to figure this out as well (just like a traditional captcha).

I'm the last person to ask about this sort of stuff and I'm probably missing something here but surly the answer is transform? e.g. "...the Foos and Bars transform to a new state."

modified on Thursday, December 31, 2009 8:46 AM