View difference between Paste ID: VhWNUAgX and Td0pi24M

-<?PHP
+$search 	= $db->prepare("SELECT `searched`, `month` FROM `search` WHERE `user_id` =:user_id");
-require ("include/db.inc.php");
+$search->bindValue(':user_id', $vbulletin->userinfo['userid'], PDO::PARAM_INT);
-$user_id = 1;
+
-$search = $db->prepare("SELECT `searched` FROM `search` WHERE `user_id` =:user_id");
+
-$search->bindValue(':user_id', $user_id, PDO::PARAM_INT);
+
 	if ($result['month'] != date(n)){
 		$removelimit	= $db->prepare("UPDATE `evomap`.`search` SET `searched` = 0, `month` = month(now()) WHERE `search`.`user_id` = :user_id;");
-echo "<pre>", print_r($result), "</pre><br>";
+		$removelimit->bindValue(':user_id', $vbulletin->userinfo['userid'], PDO::PARAM_INT);
 		$removelimit->execute();
-	echo 'you have reached your search limit for this month<br>';
+		$result['searched'] = 0;
 	} else {
-$addsearch = $db->prepare("UPDATE `evomap`.`search` SET `searched` = :searched + 1 WHERE `search`.`id` =:user_id;");
+		exit('you have reached your search limit for this month<br>');
-$addsearch->bindValue(':user_id', $user_id, PDO::PARAM_INT);
+	}
-$addsearch->bindValue(':searched', $result['searched'], PDO::PARAM_INT);
+
-$addsearch->execute();
+$addsearch 	= $db->prepare("UPDATE `evomap`.`search` SET `searched` = :searched + 1 WHERE `search`.`user_id` =:user_id;");
-echo 'DEBUGGING';
+$addsearch->bindValue(':user_id', $vbulletin->userinfo['userid'], PDO::PARAM_INT);
-echo'<br><pre>', print_r($db->errorInfo()), '<pre>';
+$addsearch->bindValue(':searched', $result['searched'], PDO::PARAM_STR);
-echo "Number of results: ", $search->rowCount(), "<br>";
+$addsearch->execute();