Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /************************************************************************
- * *
- * Configuration *
- * *
- *************************************************************************/
- $db_hostname = "";
- $db_user = "";
- $db_password = "";
- $db_name = "";
- /************************************************************************
- * *
- * Database setup and initial queries *
- * *
- *************************************************************************/
- $db_connection = mysql_connect("$db_hostname, $db_user, $db_password");
- if (!$db_connection) {
- die('MySQL error: ' . mysql_error());
- }
- $db_selected = mysql_select_db("$db_name, $db_connection");
- if (!db_selected) {
- die("Can't use $db_name: " . mysql_error());
- $ip_address = $_SERVER['REMOTE_ADDR'];
- $ipresult = mysql_query("SELECT ip_addressID FROM ips WHERE ip_address='$ip_address'");
- $iprecord = mysql_fetch_array($ipresult);
- if ($iprecord === false) {
- echo("<h1 class=\"toptext\">Thank you for your contribution!</h1>")
- $useragent = mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']);
- mysql_query("INSERT INTO ips (ip_address, useragent) VALUES ('$ip_address', '$useragent')")
- $u_agent = $_SERVER['HTTP_USER_AGENT'];
- /************************************************************************
- * *
- * OS queries *
- * *
- *************************************************************************/
- if(preg_match('/gentoo/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='gentoo'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('gentoo', 1)")
- }
- else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='gentoo'")
- }
- } elseif(preg_match('/Debian/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='debian'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('debian', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='debian'")
- } elseif(preg_match('/Ubuntu/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='ubuntu'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('ubuntu', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='ubuntu'")
- } elseif(preg_match('/Arch/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='arch'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('arch', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='arch'")
- } elseif(preg_match('/Haiku/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='haiku'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('haiku', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='haiku'")
- } elseif(preg_match('/Crunchbang/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='crunchbang'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('crunchbang', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='crunchbang'")
- } elseif(preg_match('/Slackware/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='slackware'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('slackware', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='slackware'")
- } elseif(preg_match('/Mint/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='mint'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('mint', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='mint'")
- } elseif(preg_match('/Mandriva/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='mandriva'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('mandriva', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='mandriva'")
- } elseif(preg_match('/NetBSD/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='netbsd'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('netbsd', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='netbsd'")
- } elseif(preg_match('/FreeBSD/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='freebsd'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('freebsd', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='freebsd'")
- } elseif(preg_match('/OpenBSD/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='openbsd'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('openbsd', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='openbsd'")
- } elseif(preg_match('/Fedora/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='fedora'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('fedora', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='fedora'")
- } elseif(preg_match('/redhat|Red Hat/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='redhat'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('redhat', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='redhat'")
- } elseif(preg_match('/OpenSUSE/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='opensuse'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('opensuse', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='opensuse'")
- } elseif(preg_match('/NT 5.1/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='winxp'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('winxp', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='winxp'")
- } elseif(preg_match('/NT 6.0/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='winvista'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('winvista', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='winvista'")
- } elseif(preg_match('/NT 6.1/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='win7'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('win7', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='win7'")
- } elseif(preg_match('/CentOS/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='centos'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('centos', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='centos'")
- } elseif(preg_match('/Mac OS X/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM os WHERE name='macosx'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('macosx', 1)")
- } else {
- mysql_query("UPDATE os SET score=score+1 WHERE name='macosx'")
- } else {
- $result = mysql_query("SELECT score FROM os WHERE name='other'");
- $record = mysql_fetch_array($result);
- if ($record === false) {
- mysql_query("INSERT INTO os (name, score) VALUES ('other', 1)")
- } else {
- mysql_query("UPATE os SET score=score+1 WHERE name='other'")
- }
- }
- /************************************************************************
- * *
- * Browser queries *
- * *
- *************************************************************************/
- if(preg_match('/Firefox\/3\.6/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='ff3.6'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('ff3.6', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='ff3.6'")
- }
- } elseif(preg_match('/Firefox\/4/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='ff4'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('ff4', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='ff4'")
- }
- } elseif(preg_match('/Firefox\/5/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='ff5'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('ff5', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='ff5'")
- }
- } elseif(preg_match('/Firefox\/6/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='ff6'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('ff6', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='ff6'")
- }
- } elseif(preg_match('/Firefox\/7/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='ff7'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('ff7', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='ff7'")
- }
- } elseif(preg_match('/Firefox\/8/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='ff8'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('ff8', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='ff8'")
- }
- } elseif(preg_match('/Opera/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='opera'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('opera', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='opera'")
- }
- } elseif(preg_match('/Safari/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='safari'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('safari', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='safari'")
- }
- } elseif(preg_match('/Lynx/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='lynx'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('lynx', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='lynx'")
- }
- } elseif(preg_match('/MSIE 6/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='ie6'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('ie6', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='ie6'")
- }
- } elseif(preg_match('/MSIE 7/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='ie7'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('ie7', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='ie7'")
- }
- } elseif(preg_match('/MSIE 8/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='ie8'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('ie8', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='ie8'")
- }
- } elseif(preg_match('/MSIE 9/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='ie9'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('ie9', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='ie9'")
- }
- } elseif(preg_match('/Chrome/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='chrome'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('chrome', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='chrome'")
- }
- } elseif(preg_match('/Netscape/i', $u_agent)) {
- $result = mysql_query("SELECT score FROM browsers WHERE name='netscape'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('netscape', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='netscape'")
- }
- } else {
- $result = mysql_query("SELECT score FROM browsers WHERE name='other'")
- $record = mysql_fetch_array($result)
- if ($record === false) {
- mysql_query("INSERT INTO browsers (name, score) VALUES ('other', 1)")
- } else {
- mysql_query("UPDATE browsers SET score=score+1 WHERE name='other'")
- }
- } else {
- echo("<h1 class=\"toptext\">You have already contributed to the survey, and you are now in read-only mode.</h1>")
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement