PageRenderTime 42ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

/ales/666remove.php

http://cartonbank.googlecode.com/
PHP | 165 lines | 127 code | 29 blank | 9 comment | 10 complexity | 21ea198b730c6b8516465048e83ca0f7 MD5 | raw file
Possible License(s): GPL-3.0, GPL-2.0, LGPL-2.1, AGPL-1.0, LGPL-3.0 
    

  1. <?
    2. 

  2. require_once('config.php');
    3. 

  3. global $wpdb;
    4. 

  4. 

  5. $link = mysql_connect($mysql_hostname, $mysql_user, $mysql_password);
    6. 

  6. mysql_set_charset('utf8',$link);
    7. 

  7. 

  8. if ($_REQUEST['b'])
    9. 

  9. {
    10. 

  10. 	$brand=trim($_REQUEST['b']);
    11. 

  11. }
    12. 

  12. else
    13. 

  13. {
    14. 

  14. 	$brand=1;
    15. 

  15. }
    16. 

  16. 

  17. 

  18. if ($_REQUEST['rate'] && $_REQUEST['rate']=1)
    19. 

  19. {
    20. 

  20. 	$sql="SELECT id
    21. 

  21. 	FROM  `wp_product_list` 
    22. 

  22. 	WHERE brand = ".$brand."
    23. 

  23. 	AND category =666
    24. 

  24. 	AND approved =1";
    25. 

    26. 

  26. 	$result = mysql_query($sql);
    27. 

  27. 

  28. //pokazh ($result);
    29. 

  29. 	
    30. 

  30. 	if (!$result) {die('Invalid query: ' . mysql_error());}
    31. 

  31. 	while($row=mysql_fetch_array($result))
    32. 

  32. 	{
    33. 

  33. 		$file = fopen('http://cartoonbank.ru/wp-content/plugins/five-star-rating/fsr-ajax-stars.php?p='.$row['id'].'&fsr_stars=2', 'r');
    34. 

  34. 		fclose($file);
    35. 

  35. 	
    36. 

  36. 		$sql1="INSERT ignore INTO  `al_editors_votes` (`image_id`) VALUES (".$row['id'].")";
    37. 

  37. 		//pokazh ($sql);
    38. 

  38. 		mysql_query($sql1);
    39. 

  39. 	
    40. 

  40. 	}
    41. 

  41. }
    42. 

  42. 

  43. // Execute
    44. 

  44. if ($_REQUEST['id'] && $_REQUEST['category'])
    45. 

  45. {
    46. 

  46. 	$sql="update wp_fsr_post set votes = ".$_REQUEST['votes'].", points=".$_REQUEST['points']." where id=".$_REQUEST['id'];
    47. 

  47. 	//pokazh ($sql);
    48. 

  48. 	$result = mysql_query($sql);
    49. 

  49. 	if (!$result) {die('Invalid query: ' . mysql_error());}
    50. 

  50. 	$sql="update  wp_product_list set category = ".$_REQUEST['category']." where id=".$_REQUEST['id'];
    51. 

  51. 	//pokazh ($sql);
    52. 

  52. 	$result = mysql_query($sql);
    53. 

  53. 	if (!$result) {die('Invalid query: ' . mysql_error());}
    54. 

  54. 	$sql="update  wp_item_category_associations set category_id = ".$_REQUEST['category']." where product_id=".$_REQUEST['id'];
    55. 

  55. 	//pokazh ($sql);
    56. 

  56. 	$result = mysql_query($sql);
    57. 

  57. 	if (!$result) {die('Invalid query: ' . mysql_error());}
    58. 

  58. 	header("Location: http://cartoonbank.ru/ales/666remove.php?b=".$brand);
    59. 

  59. }
    60. 

  60. 

  61. 

  62. 

  63. 

  64. 

  65. $sql = "
    66. 

  66. SELECT AEV.image_id, AEV.up, AEV.down, (
    67. 

  67. AEV.up *5 + AEV.down
    68. 

  68. ) / ( AEV.up + AEV.down ) AS rateModer, WFP.votes, WFP.points, (
    69. 

  69. WFP.points / WFP.votes
    70. 

  70. ) AS rateVisitor, (
    71. 

  71. AEV.up *5 + AEV.down + WFP.points
    72. 

  72. ) / ( AEV.up + AEV.down + WFP.votes ) AS RateTotal,
    73. 

  73. P.image
    74. 

  74. FROM  `al_editors_votes` AS AEV,  `wp_fsr_post` AS WFP,  `wp_product_list` AS P
    75. 

  75. WHERE AEV.image_id = WFP.id
    76. 

  76. AND P.id = WFP.id
    77. 

  77. AND P.category = 666
    78. 

  78. AND P.approved = '1'
    79. 

  79. AND P.brand =".$brand."
    80. 

  80. ORDER BY rateVisitor DESC
    81. 

  81. LIMIT 1
    82. 

  82. ";
    83. 

  83. //pokazh($sql);
    84. 

  84. $result = mysql_query($sql);
    85. 

  85. 

  86. if (!$result) {
    87. 

  87.                 die('Invalid query: ' . mysql_error());
    88. 

  88.             }
    89. 

  89. echo '<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>????? ???????? ?????</title><style>a, a:hover{padding:2px;}a:hover{background-color:#99CCCC;}</style></head><body>';
    90. 

  90. //echo '<br><a href="http://cartoonbank.ru/ales/666remove.php">?????????>>>>></a><br><br><br><br>';
    91. 

  91. while($row=mysql_fetch_array($result))
    92. 

  92. {
    93. 

  93. 	$votes = $row['up'] + $row['down'] + $row['votes'];
    94. 

  94. 	$points = $row['up']*5 + $row['down'] + $row['points'];
    95. 

  95. 	$rate = $row['RateTotal'];
    96. 

  96. 

  97. 	echo '<img src="http://cartoonbank.ru/wp-content/plugins/wp-shopping-cart/product_images/'.$row['image'].'"><br>';
    98. 

  98. 	echo '# '.$row['image_id'].': ????? ???????: '.$rate.'<br>';
    99. 

  99. 	echo ' ??????? ????? ?????????: <br>';
    100. 

  100. 	echo ' <a href="?id='.$row['image_id'].'&category=4&votes='.$votes.'&points='.$points.'&b='.$brand.'">??????????</a>: <br>';
    101. 

  101. 	echo ' <a href="?id='.$row['image_id'].'&category=5&votes='.$votes.'&points='.$points.'&b='.$brand.'">??????</a>: <br>';
    102. 

  102. 	echo ' <a href="?id='.$row['image_id'].'&category=11&votes='.$votes.'&points='.$points.'&b='.$brand.'">??????</a>: <br>';
    103. 

  103. 	echo ' <a href="?id='.$row['image_id'].'&category=14&votes='.$votes.'&points='.$points.'&b='.$brand.'">????</a>: <br>';
    104. 

  104. 	echo ' <a href="?id='.$row['image_id'].'&category=6&votes='.$votes.'&points='.$points.'&b='.$brand.'">?????</a>: <br>';
    105. 

  105. 	echo ' <a href="?id='.$row['image_id'].'&category=15&votes='.$votes.'&points='.$points.'&b='.$brand.'">?????</a>: <br>';
    106. 

  106. 	echo ' <a href="?id='.$row['image_id'].'&category=13&votes='.$votes.'&points='.$points.'&b='.$brand.'">??????</a>: <br><br><br>';
    107. 

  107. }
    108. 

  108. ?>
    109. 

  109. 

  110. 1	<a href="?b=1">????? ????????</a>
    111. 

  111. 2	<a href="?b=2">??????? ??????</a>
    112. 

  112. 3	<a href="?b=3">??????????? ???????</a>
    113. 

  113. 4	<a href="?b=4">?????? ??????</a>
    114. 

  114. 5	<a href="?b=5">????? ?????</a>
    115. 

  115. 6	<a href="?b=6">??????? ??????</a>
    116. 

  116. 7	<a href="?b=7">??????? ??????</a>
    117. 

  117. 8	<a href="?b=8">?????? ?????</a>
    118. 

  118. 9	<a href="?b=9">????? ??????</a>
    119. 

  119. 11	<a href="?b=11">??????? ?????????</a>
    120. 

  120. 12	<a href="?b=12">?????? ???????</a>
    121. 

  121. 14	<a href="?b=14">?????????? ?????</a>
    122. 

  122. 15	<a href="?b=15">?????? ????????</a>
    123. 

  123. 16	<a href="?b=16">????????? ???????</a>
    124. 

  124. 17	<a href="?b=17">???????? ?????</a>
    125. 

  125. 18	<a href="?b=18">???????? ????</a>
    126. 

  126. 19	<a href="?b=19">?????????? ???????</a>
    127. 

  127. 20	<a href="?b=20">???????????? ?????</a>
    128. 

  128. 21	<a href="?b=21">????? ??????</a>
    129. 

  129. 22	<a href="?b=22">?????????? ???????</a>
    130. 

  130. 23	<a href="?b=23">??????? ???????</a>
    131. 

  131. 24	<a href="?b=24">??????? ????????</a>
    132. 

  132. 25	<a href="?b=25">???? ???????</a>
    133. 

  133. 26	<a href="?b=26">??????? ????</a>
    134. 

  134. 27	<a href="?b=27">????????? ?????????</a>
    135. 

  135. 29	<a href="?b=29">???????? ????????</a>
    136. 

  136. 30	<a href="?b=30">??????? ????????</a>
    137. 

  137. 31	<a href="?b=31">????? ?????????</a>
    138. 

  138. 32	<a href="?b=32">??????? ???????</a>
    139. 

  139. 33	<a href="?b=33">????????? ???????</a>	 	
    140. 

  140. 34	<a href="?b=34">????? ?????????</a>	 	
    141. 

  141. 35	<a href="?b=35">???????? ?????</a>	 	
    142. 

  142. 36	<a href="?b=36">?????? ????????</a>	 	
    143. 

  143. 37	<a href="?b=37">??????? ??????</a>	 	
    144. 

  144. 38	<a href="?b=38">??????????? ?????</a>	
    145. 

  145. 39	<a href="?b=39">??????? ??????</a>	 	
    146. 

  146. 40	<a href="?b=40">????? ?????</a>	 	
    147. 

  147. 41	<a href="?b=41">?????? ?????????</a>
    148. 

  148. 42	<a href="?b=42">??????????? ?????</a>
    149. 

  149. 43	<a href="?b=43">??????? ?????</a>	 
    150. 

  150. 44	<a href="?b=44">????????? ???????</a>
    151. 

  151. 

  152. 

  153. <?
    154. 

  154. 

  155. 

  156. 

  157. 

  158. echo '</body></html>';
    159. 

  159. 

  160. 

  161. //http://cartoonbank.ru/wp-content/plugins/five-star-rating/fsr-ajax-stars.php?id=FSR_form_11696&value=3
    162. 

  162. 

  163. 

  164. 

  165. ?>
    166.