Chciałbym ograniczyć możliwość głosowania do jednego. Teraz skrypt działa tak, że głosować można bez końca.

glosowanie.php
[PHP] pobierz, plaintext 
  1. <?php
  2. session_start(); 
  3. ob_start();
  4. require_once('connect.php');
  5. require_once('functions.php');
  6. ?>
  7. <?php
  8.  
  9.  
  10. function getAllVotes($id)
  11. 	{
  12. 	/**
  13. 	Returns an array whose first element is votes_up and the second one is votes_down
  14. 	**/
  15. 	$votes = array();
  16. 	$q = "SELECT * FROM shity WHERE id = $id";
  17. 	$r = mysql_query($q);
  18. 	if(mysql_num_rows($r)==1)//id found in the table
  19. 		{
  20. 		$row = mysql_fetch_assoc($r);
  21. 		$votes[0] = $row['votes_up'];
  22. 		$votes[1] = $row['votes_down'];
  23. 		}
  24. 	return $votes;
  25. 	}
  26.  
  27. function getEffectiveVotes($id)
  28. 	{
  29. 	/**
  30. 	Returns an integer
  31. 	**/
  32. 	$votes = getAllVotes($id);
  33. 	$effectiveVote = $votes[0] - $votes[1];
  34. 	return $effectiveVote;
  35. 	}
  36.  
  37. $id = $_POST['id'];
  38. $action = $_POST['action'];
  39.  
  40. //get the current votes
  41. $cur_votes = getAllVotes($id);
  42.  
  43. //ok, now update the votes
  44. if (isset($_SESSION['user_id']) and isset($_SESSION['login'])){
  45. if($action=='vote_up') //voting up
  46. {
  47. 	$votes_up = $cur_votes[0]+1;
  48. 	$q = "UPDATE shity SET votes_up = $votes_up WHERE id = $id";
  49. }
  50. elseif($action=='vote_down') //voting down
  51. {
  52. 	$votes_down = $cur_votes[1]+1;
  53. 	$q = "UPDATE shity SET votes_down = $votes_down WHERE id = $id";
  54. }
  55. }
  56. $r = mysql_query($q);
  57. if($r) //voting done
  58. 	{
  59. 	$effectiveVote = getEffectiveVotes($id);
  60. 	echo $effectiveVote." votes";
  61. 	}
  62. elseif(!$r) //voting failed
  63. 	{
  64. 	echo "Zaloguj się!";
  65.  
  66. }
  67.  
  68. ?>
[PHP] pobierz, plaintext


index.php

[PHP] pobierz, plaintext 
  1. <?php
  2. session_start(); 
  3. ob_start();
  4. require_once('connect.php');
  5. require_once('functions.php');
  6. ?>
  7.  
  8. <html>
  9. <head>
  10. 	<title>Votes</title>
  11.  
  12. <style type='text/css'>
  13.  
  14.  
  15.  
  16.  
  17. .entry {
  18. 	width: 710px;
  19. 	background: #ffffff;
  20. 	padding:8px;
  21. 	border:1px solid #bbbbbb;
  22. 	margin:5px auto;
  23. 	-moz-border-radius:8px;
  24. }
  25.  
  26. span.link a {
  27. 	font-size:150%;
  28. 	color: #000000;
  29. 	text-decoration:none;
  30. }
  31.  
  32. a.vote_up, a.vote_down {
  33. 	display:inline-block;
  34. 	background-repeat:none;
  35. 	background-position:center;
  36. 	height:16px;
  37. 	width:16px;
  38. 	margin-left:4px;
  39. 	text-indent:-900%;
  40. }
  41.  
  42. a.vote_up {
  43. 	background:url("images/thumb_up.png");
  44. }
  45.  
  46. a.vote_down {
  47. 	background:url("images/thumb_down.png");
  48. }
  49. </style>
  50.  
  51. <script type='text/javascript' src='jquery.pack.js'></script>
  52. <script type='text/javascript'>
  53. $(function(){
  54. 	$("a.vote_up").click(function(){
  55. 	//get the id
  56. 	the_id = $(this).attr('id');
  57.  
  58. 	// show the spinner
  59. 	$(this).parent().html("<img src='images/spinner.gif'/>");
  60.  
  61. 	//fadeout the vote-count 
  62. 	$("span#votes_count"+the_id).fadeOut("fast");
  63.  
  64. 	//the main ajax request
  65. 		$.ajax({
  66. 			type: "POST",
  67. 			data: "action=vote_up&id="+$(this).attr("id"),
  68. 			url: "glosowanie.php",
  69. 			success: function(msg)
  70. 			{
  71. 				$("span#votes_count"+the_id).html(msg);
  72. 				//fadein the vote count
  73. 				$("span#votes_count"+the_id).fadeIn();
  74. 				//remove the spinner
  75. 				$("span#vote_buttons"+the_id).remove();
  76. 			}
  77. 		});
  78. 	});
  79.  
  80. 	$("a.vote_down").click(function(){
  81. 	//get the id
  82. 	the_id = $(this).attr('id');
  83.  
  84. 	// show the spinner
  85. 	$(this).parent().html("<img src='images/spinner.gif'/>");
  86.  
  87. 	//the main ajax request
  88. 		$.ajax({
  89. 			type: "POST",
  90. 			data: "action=vote_down&id="+$(this).attr("id"),
  91. 			url: "votes.php",
  92. 			success: function(msg)
  93. 			{
  94. 				$("span#votes_count"+the_id).fadeOut();
  95. 				$("span#votes_count"+the_id).html(msg);
  96. 				$("span#votes_count"+the_id).fadeIn();
  97. 				$("span#vote_buttons"+the_id).remove();
  98. 			}
  99. 		});
  100. 	});
  101. });	
  102. </script>
  103.  
  104. </head>
  105. <body>
  106.  
  107. <?php
  108.  
  109. /**
  110. Display the results from the database
  111. **/
  112. $q = "SELECT * FROM baza";
  113. $r = mysql_query($q);
  114.  
  115. if(mysql_num_rows($r)>0): //table is non-empty
  116. 	while($row = mysql_fetch_assoc($r)):
  117.  
  118. 		$net_vote = $shit['votes_up'] - $shit['votes_down']; //this is the net result of voting up and voting down 
  119.  
  120. ?><?php endwhile;  ?>
  121.  
  122. <div class='entry'>
  123.  
  124. 	<span class='link'>
  125. 		<a href='<?php echo $row['link']; ?>'> <?php echo $row['title']; ?> </a>
  126. 	</span>
  127.  
  128. 	<span class='votes_count' id='votes_count<?php echo $shit['id']; ?>'><?php echo $net_vote." votes"; ?></span>
  129.  
  130. 	<span class='vote_buttons' id='vote_buttons<?php echo $shit['id']; ?>'>
  131. 		<a href='java script:;' class='vote_up' id='<?php echo $shit['id']; ?>'>Vote Up!</a>
  132. 		<a href='java script:;' class='vote_down' id='<?php echo $shit['id']; ?>'>Vote Down!</a>
  133. 	</span>
  134.  
  135. </div>
  136.  
  137.  
  138. <?php
  139.  
  140. endif;
  141.  
  142. ?>
  143.  
[PHP] pobierz, plaintext




Tylko zalogowany może głosować, jak teraz zrobić, aby sprawdzało, zapisywało adres IP osoby, która glosowala w danym artykule, oraz cookies? i zabraniała ponownego glosowania?