<?php

	require_once('class.db.php');

	class Reputation_suggestions_star_rating extends DB
	{
		
		//get reputation suggestions star rating rows count
		public function getReputationSuggestionsStarRatingRowsCount( $sentence_id, $user_id ) {
			$sql_get_rating_rows_count = 'SELECT * FROM `reputation_suggestions_star_rating` WHERE sentence_id = ' . $sentence_id . ' AND user_id = ' . $user_id;
			$result_rating_rows_count = $this->con->query($sql_get_rating_rows_count);
			$rating_rows_count = $result_rating_rows_count->num_rows;  
			return $rating_rows_count;
		}
				
		//Insert into reputation_suggestions_star_rating table
		public function saveReputationSuggestionsStarRating( $sentence_id, $user_id, $star_rating ) {
			$sqlInsert1 = 'INSERT INTO `reputation_suggestions_star_rating`( `sentence_id`, `user_id`, `star_rating` ) VALUES '
						. '(' . $sentence_id . ',' . $user_id . ', ' . $star_rating . ' )';
			$this->con->query($sqlInsert1);	
		}
		
		//update reputation_suggestions_star_rating table
		public function updateReputationSuggestionsStarRating( $sentence_id, $user_id, $star_rating  ) {
			$sql_tvsuoUpdate = 'UPDATE `reputation_suggestions_star_rating` SET star_rating = '.$star_rating .', rated_at = now() WHERE sentence_id = '.$sentence_id.' AND user_id = ' . $user_id;
			$this->con->query($sql_tvsuoUpdate);
		}
		
	}
?>