removing a like by clicking again

[3l3ktr0n]

currently there is no option to remove a like or dislike after it has been submitted. it's not the best solution but that's what I have for now in rate_class.php

/**
	 * @param $table
	 * @param $itemid
	 * @param $type
	 * @param $perc
	 * @return false|string|null
	 */
	function submitLike($table, $itemid, $type, $perc=false)
	{	
		$sql 	= e107::getDb();
			
		if($sql->select("rate","*","rate_table = '{$table}' AND rate_itemid = '{$itemid}' LIMIT 1"))
		{
			$row 		= $sql->fetch();
			
			if(preg_match("/\." . USERID . "\./",$row['rate_voters'])) // already voted. 
			{		
				return false;
			}
						
			$newvoters 	= $row['rate_voters']."." . USERID . ".";	
			$totalVotes = $row['rate_votes'] + 1; 
			$totalDown	= $row['rate_down'] + (($type == 'down') ? 1 : 0);
			$totalUp	= $row['rate_up'] + (($type == 'up') ? 1 : 0);
					
			$qry = ($type == 'up') ? "rate_up = {$totalUp} " : "rate_down = {$totalDown}";
			$qry .= ", rate_voters = '{$newvoters}', rate_votes = {$totalVotes} ";
			$qry .= " WHERE rate_table = '{$table}' AND rate_itemid = '{$itemid}'";
			
			if($sql->update("rate",$qry))
			{
				if($perc == true) // Percentage Mode
				{
					$up 	= round(($totalUp /$totalVotes) * 100) . "%";
					$down 	= round(($totalDown /$totalVotes) * 100) . "%";		
				}
				else // Counts mode. 
				{
					$up 	= $totalUp;
					$down 	= $totalDown;	
				}

                $edata = array(
                    'like_pid' => $row['rate_id'],
                    'like_table' => $table,
                    'like_item_id' => $itemid,
                    'like_author_id' => USERID,
                    'like_author_name' => USERNAME,
                    'like_up_count' => $totalUp,
                    'like_down_count' => $totalDown,
                    'like_totalvotes' => $totalVotes,
                    'like_type' => $type
                );
                e107::getEvent()->trigger('user_like_submitted', $edata);
					
				return $up . "|" . $down;
			}		
		}
		else
		{			
			$insert = array(
				//	"rate_id"		=> 0, // let it increment
					"rate_table"	=> $table,
					"rate_itemid"	=> $itemid,
					"rate_rating"	=> 0,
					"rate_votes"	=> 1,
					"rate_voters"	=> ".".USERID.".",
					"rate_up"		=> ($type == 'up') ? 1 : 0,
					"rate_down"		=> ($type == 'down') ? 1 : 0
			);
				
			if($row = $sql->insert("rate", $insert))
			{
                    $edata = array(
                    'like_pid' => $row,
                    'like_table' => $table,
                    'like_item_id' => $itemid,
                    'like_author_id' => USERID,
                    'like_author_name' => USERNAME,
                    'like_up_count' => ($type == 'up') ? 1 : 0,
                    'like_down_count' => ($type == 'down') ? 1 : 0,
                    'like_totalvotes' => 1,
                    'like_type' => $type
                );
                e107::getEvent()->trigger('user_like_submitted', $edata);

				if($perc == true) // Percentage Mode
				{
					return ($type == 'up') ? "100%|0%" : "0%|100%";
				}
				else
				{
					return ($type == 'up') ? "1|0" : "0|1";	
				}
			}		
		}

		return null;
	}


	/**
	 * @param $table
	 * @param $itemid
	 * @param $type
	 * @return false|string|null
	 */
	function removeLike($table, $itemid, $type)
	{
		$sql = e107::getDb();

		if ($sql->select("rate", "*", "rate_table = '{$table}' AND rate_itemid = '{$itemid}' LIMIT 1")) {
			$row = $sql->fetch();

			if (!preg_match("/\." . USERID . "\./", $row['rate_voters'])) {
				// User hasn't voted, nothing to remove.
				return false;
			}

			// Check if the user's vote matches the type (up/down) being removed
			$voteDirection = ($type == 'up') ? 'rate_up' : 'rate_down';
			if ($row[$voteDirection] <= 0) {
				// User has already removed their vote for this direction.
				return false;
			}

			// Remove user from voters list
			$newvoters = str_replace("." . USERID . ".", "", $row['rate_voters']);
			$totalVotes = $row['rate_votes'] - 1;
			$totalDown = $row['rate_down'] - (($type == 'down') ? 1 : 0);
			$totalUp = $row['rate_up'] - (($type == 'up') ? 1 : 0);

			$qry = ($type == 'up') ? "rate_up = {$totalUp} " : "rate_down = {$totalDown}";
			$qry .= ", rate_voters = '{$newvoters}', rate_votes = {$totalVotes} ";
			$qry .= " WHERE rate_table = '{$table}' AND rate_itemid = '{$itemid}'";

			if ($sql->update("rate", $qry)) {
				// Trigger event for like removal
				$edata = array(
					'like_pid' => $row['rate_id'],
					'like_table' => $table,
					'like_item_id' => $itemid,
					'like_author_id' => USERID,
					'like_author_name' => USERNAME,
					'like_up_count' => $totalUp,
					'like_down_count' => $totalDown,
					'like_totalvotes' => $totalVotes,
					'like_type' => $type
				);
				e107::getEvent()->trigger('user_like_removed', $edata);

				return true;
			}
		}

		// If the record doesn't exist, or user hasn't voted, nothing to remove.
		return false;
	}