/web nhacdj.vn php/code/Client/loadTopStats.php

https://gitlab.com/phamngsinh/baitaplon_sinhvien · PHP · 257 lines · 241 code · 15 blank · 1 comment · 54 complexity · 71db62f99685c4401e400eb7fa9f2ac3 MD5 · raw file 

    

  1. <?php 
    2. 

  2. session_start();
    3. 

  3. 

  4. error_reporting(E_ALL ^ E_NOTICE);
    5. 

  5. 

  6. require("../XBTeam/functions.php");
    7. 

  7. require("../XBTeam/se7en.php");
    8. 

  8. 

  9. //echo date("w");
    10. 

  10. 

  11. $connection = mysql_connect("$host" , "$user" , "$pass");
    12. 

  12. $db = mysql_select_db($dbase , $connection) or die( "Unable to select database" ); 
    13. 

  13. $today=mysql_query("SELECT * FROM today ORDER BY today_id ASC");
    14. 

  14. 	$rows_today=@mysql_num_rows($today);
    15. 

  15. 	for($i=0;$i<$rows_today;$i++){
    16. 

  16.         $k[$i]=mysql_result($today,$i,"today_values");
    17. 

  17. 	}
    18. 

  18. if ($k[0] != timex("W")) {
    19. 

  19. 			mysql_query("UPDATE today SET today_values='".timex("W")."' WHERE today_id=1");
    20. 

  20. 			mysql_query("UPDATE song SET sWeekView='0', sWeekDownload='0', upw='0', downw='0'");
    21. 

  21. 			mysql_query("UPDATE member SET likew='0'");
    22. 

  22. 			mysql_query("UPDATE member SET mPostWeek='0'");
    23. 

  23. 			mysql_query("UPDATE member SET mComWeek='0'");
    24. 

  24. 			mysql_query("UPDATE song SET decu='0'");
    25. 

  25. 			mysql_query("UPDATE news SET newsWeekView='0', upw='0'");
    26. 

  26. 			}
    27. 

  27. if ($k[1] != timex("m")) {
    28. 

  28. 			mysql_query("UPDATE today SET today_values='".timex("m")."' WHERE today_id=2");
    29. 

  29. 			mysql_query("UPDATE song SET sMonthView='0', sMonthDownload='0', upm='0', downm='0'");
    30. 

  30. 			mysql_query("UPDATE member SET likem='0'");
    31. 

  31. 			mysql_query("UPDATE member SET mPostMonth='0'");
    32. 

  32. 			mysql_query("UPDATE member SET mComMonth='0'");
    33. 

  33. 			mysql_query("UPDATE news SET newsMonthView='0', upm='0'");
    34. 

  34. 			}
    35. 

  35. if ($k[2] != timex("Y")) {
    36. 

  36. 			mysql_query("UPDATE today SET today_values='".timex("Y")."' WHERE today_id=3");
    37. 

  37. 			mysql_query("UPDATE song SET sYearView='0', sYearDownload='0', upy='0', downy='0'");
    38. 

  38. 			mysql_query("UPDATE member SET likey='0'");
    39. 

  39. 			mysql_query("UPDATE member SET mPostYear='0'");
    40. 

  40. 			mysql_query("UPDATE member SET mComYear='0'");
    41. 

  41. 			mysql_query("UPDATE news SET newsYearView='0',  upy='0'");
    42. 

  42. 			}
    43. 

  43. if ($k[3] != timex("d")) {
    44. 

  44. 			mysql_query("UPDATE today SET today_values='".timex("d")."' WHERE today_id=4");
    45. 

  45. 			}
    46. 

  46. 			$time_up = timex("d")+10;
    47. 

  47. 			if ($k[3] == $time_up) {
    48. 

  48. 			
    49. 

  49. 			}
    50. 

  50. ?>
    51. 

  51. <?
    52. 

  52. $choice = $_REQUEST['choice'];
    53. 

  53. if($choice == "week"){
    54. 

  54. ?>
    55. 

  55. <ul class="top-list">		
    56. 

  56. <?php 
    57. 

  57. $i = 0;
    58. 

  58. $sql_music_tuan = mysql_query("SELECT * FROM song WHERE sWeekView!=0 AND sStatus!=0 AND sStatus!=3 AND sType!='youtube' order by sWeekView DESC LIMIT 10 ");	
    59. 

  59. while($row_music_tuan = mysql_fetch_array($sql_music_tuan)){ 
    60. 

  60. $i++;	
    61. 

  61. $sID = $row_music_tuan['sID'];
    62. 

  62. $sName = $row_music_tuan['sName'];
    63. 

  63. $sView = $row_music_tuan['sWeekView'];
    64. 

  64. ?>
    65. 

  65. <li>
    66. 

  66. <?if ($i==1){?>
    67. 

  67. <div class="top-icon top1"><?=$i?>.</div>
    68. 

  68. <?} else if ($i==2){?>
    69. 

  69. <div class="top-icon top2"><?=$i?>.</div>
    70. 

  70. <?} else if ($i==3){?>
    71. 

  71. <div class="top-icon top3"><?=$i?>.</div>
    72. 

  72. <?} else {?>
    73. 

  73. <div class="top-icon"><?=$i?>.</div>
    74. 

  74. <?}?>
    75. 

  75. <div class="top-right">
    76. 

  76. <h3><a href="<?=$homelink?><?=CovertVn($sName)?>-s<?=$sID?>.html" title="<?=$sName?>"><?=$sName?></a></h3>
    77. 

  77. <div class="song-info">
    78. 

  78. <div class="song-count">Lượt nghe trong tuần: <span><?=$sView?></span></div>
    79. 

  79. </div>
    80. 

  80. </div>
    81. 

  81. <br class="clear" />
    82. 

  82. </li>
    83. 

  83. <?php } ?>
    84. 

  84. </ul>
    85. 

  85. <div class="view-more"><a title="Xem thêm top 50 bài hát" href="<?=$homelink?>bang-xep-hang/bai-hat-nghe-nhieu-nhat-trong-tuan.html"><i class="icon-caret-down"></i> &nbsp; Xem thêm</a></div>
    86. 

  86. 

  87. 

  88. <?}else if($choice == "month"){?>   
    89. 

  89. <ul class="top-list">		
    90. 

  90. <?php 
    91. 

  91. $i = 0;
    92. 

  92. $sql_music_tuan = mysql_query("SELECT * FROM song WHERE sMonthView!=0 AND sStatus!=0 AND sStatus!=3 AND sType!='youtube' order by sMonthView DESC LIMIT 10 ");	
    93. 

  93. while($row_music_tuan = mysql_fetch_array($sql_music_tuan)){ 
    94. 

  94. $i++;	
    95. 

  95. $sID = $row_music_tuan['sID'];
    96. 

  96. $sName = $row_music_tuan['sName'];
    97. 

  97. $sView = $row_music_tuan['sMonthView'];
    98. 

  98. ?>
    99. 

  99. <li>
    100. 

  100. <?if ($i==1){?>
    101. 

  101. <div class="top-icon top1"><?=$i?>.</div>
    102. 

  102. <?} else if ($i==2){?>
    103. 

  103. <div class="top-icon top2"><?=$i?>.</div>
    104. 

  104. <?} else if ($i==3){?>
    105. 

  105. <div class="top-icon top3"><?=$i?>.</div>
    106. 

  106. <?} else {?>
    107. 

  107. <div class="top-icon"><?=$i?>.</div>
    108. 

  108. <?}?>
    109. 

  109. <div class="top-right">
    110. 

  110. <h3><a href="<?=$homelink?><?=CovertVn($sName)?>-s<?=$sID?>.html" title="<?=$sName?>"><?=$sName?></a></h3>
    111. 

  111. <div class="song-info">
    112. 

  112. <div class="song-count">Lượt nghe trong tháng: <span><?=$sView?></span></div>
    113. 

  113. </div>
    114. 

  114. </div>
    115. 

  115. <br class="clear" />
    116. 

  116. </li>
    117. 

  117. <?php } ?>
    118. 

  118. </ul>
    119. 

  119. <div class="view-more"><a title="Xem thêm top 50 bài hát" href="<?=$homelink?>bang-xep-hang/bai-hat-nghe-nhieu-nhat-trong-thang.html"><i class="icon-caret-down"></i> &nbsp; Xem thêm</a></div>
    120. 

  120. 

  121. 

  122. <?}else if($choice == "year"){?>
    123. 

  123. <ul class="top-list">		
    124. 

  124. <?php 
    125. 

  125. $i = 0;
    126. 

  126. $sql_music_tuan = mysql_query("SELECT * FROM song WHERE sYearView!=0 AND sStatus!=0 AND sStatus!=3 AND sType!='youtube' order by sYearView DESC LIMIT 10 ");	
    127. 

  127. while($row_music_tuan = mysql_fetch_array($sql_music_tuan)){ 
    128. 

  128. $i++;	
    129. 

  129. $sID = $row_music_tuan['sID'];
    130. 

  130. $sName = $row_music_tuan['sName'];
    131. 

  131. $sView = $row_music_tuan['sYearView'];
    132. 

  132. ?>
    133. 

  133. <li>
    134. 

  134. <?if ($i==1){?>
    135. 

  135. <div class="top-icon top1"><?=$i?>.</div>
    136. 

  136. <?} else if ($i==2){?>
    137. 

  137. <div class="top-icon top2"><?=$i?>.</div>
    138. 

  138. <?} else if ($i==3){?>
    139. 

  139. <div class="top-icon top3"><?=$i?>.</div>
    140. 

  140. <?} else {?>
    141. 

  141. <div class="top-icon"><?=$i?>.</div>
    142. 

  142. <?}?>
    143. 

  143. <div class="top-right">
    144. 

  144. <h3><a href="<?=$homelink?><?=CovertVn($sName)?>-s<?=$sID?>.html" title="<?=$sName?>"><?=$sName?></a></h3>
    145. 

  145. <div class="song-info">
    146. 

  146. <div class="song-count">Lượt nghe trong năm: <span><?=$sView?></span></div>
    147. 

  147. </div>
    148. 

  148. </div>
    149. 

  149. <br class="clear" />
    150. 

  150. </li>
    151. 

  151. <?php } ?>
    152. 

  152. </ul>
    153. 

  153. <div class="view-more"><a title="Xem thêm top 50 bài hát" href="<?=$homelink?>bang-xep-hang/bai-hat-nghe-nhieu-nhat-trong-nam.html"><i class="icon-caret-down"></i> &nbsp; Xem thêm</a></div>
    154. 

  154. 

  155. 

  156. <?} else if($choice == "week1"){
    157. 

  157. ?>
    158. 

  158. <ul class="top-list">		
    159. 

  159. <?php 
    160. 

  160. $i = 0;
    161. 

  161. $sql_music_tuan = mysql_query("SELECT * FROM song WHERE sWeekDownload!=0 AND sStatus!=0 AND sStatus!=3 AND sType!='youtube' order by sWeekDownload DESC LIMIT 10 ");	
    162. 

  162. while($row_music_tuan = mysql_fetch_array($sql_music_tuan)){ 
    163. 

  163. $i++;	
    164. 

  164. $sID = $row_music_tuan['sID'];
    165. 

  165. $sName = $row_music_tuan['sName'];
    166. 

  166. $sView = $row_music_tuan['sWeekDownload'];
    167. 

  167. ?>
    168. 

  168. <li>
    169. 

  169. <?if ($i==1){?>
    170. 

  170. <div class="top-icon top1"><?=$i?>.</div>
    171. 

  171. <?} else if ($i==2){?>
    172. 

  172. <div class="top-icon top2"><?=$i?>.</div>
    173. 

  173. <?} else if ($i==3){?>
    174. 

  174. <div class="top-icon top3"><?=$i?>.</div>
    175. 

  175. <?} else {?>
    176. 

  176. <div class="top-icon"><?=$i?>.</div>
    177. 

  177. <?}?>
    178. 

  178. <div class="top-right">
    179. 

  179. <h3><a href="<?=$homelink?><?=CovertVn($sName)?>-s<?=$sID?>.html" title="<?=$sName?>"><?=$sName?></a></h3>
    180. 

  180. <div class="song-info">
    181. 

  181. <div class="song-count">Lượt tải trong tuần: <span><?=$sView?></span></div>
    182. 

  182. </div>
    183. 

  183. </div>
    184. 

  184. <br class="clear" />
    185. 

  185. </li>
    186. 

  186. <?php } ?>
    187. 

  187. </ul>
    188. 

  188. <div class="view-more"><a title="Xem thêm top 50 bài hát" href="<?=$homelink?>bang-xep-hang/bai-hat-tai-nhieu-nhat-trong-tuan.html"><i class="icon-caret-down"></i> &nbsp; Xem thêm</a></div>
    189. 

  189. 

  190. 

  191. <?}else if($choice == "month1"){?>
    192. 

  192. <ul class="top-list">		
    193. 

  193. <?php 
    194. 

  194. $i = 0;
    195. 

  195. $sql_music_tuan = mysql_query("SELECT * FROM song WHERE sMonthDownload!=0  AND sStatus!=0 AND sStatus!=3 AND sType!='youtube' order by  sMonthDownload DESC LIMIT 10 ");	
    196. 

  196. while($row_music_tuan = mysql_fetch_array($sql_music_tuan)){ 
    197. 

  197. $i++;	
    198. 

  198. $sID = $row_music_tuan['sID'];
    199. 

  199. $sName = $row_music_tuan['sName'];
    200. 

  200. $sView = $row_music_tuan['sMonthDownload'];
    201. 

  201. ?>
    202. 

  202. <li>
    203. 

  203. <?if ($i==1){?>
    204. 

  204. <div class="top-icon top1"><?=$i?>.</div>
    205. 

  205. <?} else if ($i==2){?>
    206. 

  206. <div class="top-icon top2"><?=$i?>.</div>
    207. 

  207. <?} else if ($i==3){?>
    208. 

  208. <div class="top-icon top3"><?=$i?>.</div>
    209. 

  209. <?} else {?>
    210. 

  210. <div class="top-icon"><?=$i?>.</div>
    211. 

  211. <?}?>
    212. 

  212. <div class="top-right">
    213. 

  213. <h3><a href="<?=$homelink?><?=CovertVn($sName)?>-s<?=$sID?>.html" title="<?=$sName?>"><?=$sName?></a></h3>
    214. 

  214. <div class="song-info">
    215. 

  215. <div class="song-count">Lượt tải trong tháng: <span><?=$sView?></span></div>
    216. 

  216. </div>
    217. 

  217. </div>
    218. 

  218. <br class="clear" />
    219. 

  219. </li>
    220. 

  220. <?php } ?>
    221. 

  221. </ul>
    222. 

  222. <div class="view-more"><a title="Xem thêm top 50 bài hát" href="<?=$homelink?>bang-xep-hang/bai-hat-tai-nhieu-nhat-trong-tháng.html"><i class="icon-caret-down"></i> &nbsp; Xem thêm</a></div>
    223. 

  223. 

  224. <?}else if($choice == "year1"){?>
    225. 

  225. <ul class="top-list">		
    226. 

  226. <?php 
    227. 

  227. $i = 0;
    228. 

  228. $sql_music_tuan = mysql_query("SELECT * FROM song WHERE sYearDownload!=0 AND sStatus!=0 AND sStatus!=3 AND sType!='youtube' order by  sYearDownload DESC LIMIT 10 ");	
    229. 

  229. while($row_music_tuan = mysql_fetch_array($sql_music_tuan)){ 
    230. 

  230. $i++;	
    231. 

  231. $sID = $row_music_tuan['sID'];
    232. 

  232. $sName = $row_music_tuan['sName'];
    233. 

  233. $sView = $row_music_tuan['sYearDownload'];
    234. 

  234. ?>
    235. 

  235. <li>
    236. 

  236. <?if ($i==1){?>
    237. 

  237. <div class="top-icon top1"><?=$i?>.</div>
    238. 

  238. <?} else if ($i==2){?>
    239. 

  239. <div class="top-icon top2"><?=$i?>.</div>
    240. 

  240. <?} else if ($i==3){?>
    241. 

  241. <div class="top-icon top3"><?=$i?>.</div>
    242. 

  242. <?} else {?>
    243. 

  243. <div class="top-icon"><?=$i?>.</div>
    244. 

  244. <?}?>
    245. 

  245. <div class="top-right">
    246. 

  246. <h3><a href="<?=$homelink?><?=CovertVn($sName)?>-s<?=$sID?>.html" title="<?=$sName?>"><?=$sName?></a></h3>
    247. 

  247. <div class="song-info">
    248. 

  248. <div class="song-count">Lượt tải trong năm: <span><?=$sView?></span></div>
    249. 

  249. </div>
    250. 

  250. </div>
    251. 

  251. <br class="clear" />
    252. 

  252. </li>
    253. 

  253. <?php } ?>
    254. 

  254. </ul>
    255. 

  255. <div class="view-more"><a title="Xem thêm top 50 bài hát" href="<?=$homelink?>bang-xep-hang/bai-hat-tai-nhieu-nhat-trong-nam.html"><i class="icon-caret-down"></i> &nbsp; Xem thêm</a></div>
    256. 

  256. 

  257. <?}?>
    258.