tooltiperror
Super Moderator
- Reaction score
- 231
Hello there, ladies and gentlemen. Right now I am building a quote database for an IRC channel I frequently visit.
Question #1
The table for the quotes has a column for the Id (auto_incrementing integer), the quote (text), votes (integer), and ip (char(15)).
My problem is that I only want someone to be able to submit 1 quote per day, so they can't flood it up. I should probably add in captcha validation, but I really don't care that much. So what's the best way of implementing this? Adding a date column doing something like [LJASS]"SELECT * FROM quotes WHERE ip = `used ip`"[/LJASS] and check if all are over a day ago? I feel like there's a better way.
Question #2
I want to have +/- signs so that people vote quotes up or down, and then arrange them by votes. The problem is that someone can keep hitting the + over and over to bring their own quotes up, or stuff like that. I want people to only do + (or -) on a quote once, and never be able to touch that quote again. What's the best way to do this?
Thanks in advance, I appreciate it.
Question #1
The table for the quotes has a column for the Id (auto_incrementing integer), the quote (text), votes (integer), and ip (char(15)).
My problem is that I only want someone to be able to submit 1 quote per day, so they can't flood it up. I should probably add in captcha validation, but I really don't care that much. So what's the best way of implementing this? Adding a date column doing something like [LJASS]"SELECT * FROM quotes WHERE ip = `used ip`"[/LJASS] and check if all are over a day ago? I feel like there's a better way.
Question #2
I want to have +/- signs so that people vote quotes up or down, and then arrange them by votes. The problem is that someone can keep hitting the + over and over to bring their own quotes up, or stuff like that. I want people to only do + (or -) on a quote once, and never be able to touch that quote again. What's the best way to do this?
Thanks in advance, I appreciate it.