Statistics

We have '.$row[0].' quotes, with an average rating of '; echo round($row[1],2).'. These quotes were contributed by some of our '; $sql = 'SELECT COUNT(*) FROM users'; $res = mysql_query($sql) or print(mysql_error()); $row = mysql_fetch_array($res); $users = $row[0]; echo ''.$row[0].' users, who have made a total of '; $sql = 'SELECT COUNT(*) FROM ratings'; $res = mysql_query($sql) or print(mysql_error()); $row = mysql_fetch_array($res); echo $row[0].' individual ratings, an average of '; echo round($row[0]/$users,1).' quotes rated per user.

'; if (isset($_SESSION['uid'])) { echo '

Your stats

'; echo '

'; $sql = 'SELECT COUNT(*), AVG(quote_rating) FROM quotes WHERE user_id = '.$_SESSION['uid']; $res = mysql_query($sql) or print(mysql_error()); $row = mysql_fetch_array($res); echo 'You have submitted '.$row[0].' quote'; echo ($row[0] != 1 ? 's' : '').' that have an average rating of '; echo round($row[1],2).'.'; $sql = 'SELECT COUNT(*) FROM ratings WHERE user_id = '.$_SESSION['uid']; $res = mysql_query($sql) or print(mysql_error()); $row = mysql_fetch_array($res); echo ' You have rated '.$row[0].' quote'; if ($row[0] != 1) { echo 's'; } echo '.'; if ($row[0] < $quotes) { echo ' Why not rate some more?.'; } else { echo ' Wow, that\'s all of them. Why not add a new quote?'; } } ?>

Welcome

Welcome to the quote db. You might think that this is just another bash clone, and you'd be partly right. But the quote db has some key differences. First off, we don't have any moderators. Every person starts with the same access to the site. When you submit a quote, it appears instantly on the latest quotes page, where other users can rate it as good, bad or neutral.

If the quotes you submit get a poor rating, this will reflect on you and your standing will decrease. Your standing is displayed on the right of the menu bar when you're logged in, and operates on a scale of -10 to +10. If your standing drops too low, your ability to add quotes will be suspended. Conversely, if your quotes are met with a standing ovation (and good ratings), your standing will increase. This, in turn, affects how much your opinion is taken into account when you rate quotes. The higher standing you have, the more of an impact your ratings will have.

The Quote DB now supports OpenID. Simply enter your OpenID identifier on the login page.

New! The Quote DB now fully supports Unicode (UTF-8) quotes