/admin/attachrenew.php

https://github.com/maddogfyg/itangyou · PHP · 151 lines · 148 code · 3 blank · 0 comment · 23 complexity · e10f7fdf3bf36fbf0638c10a663e20fb MD5 · raw file 

    

  1. <?php

    2. 

  2. !function_exists('adminmsg') && exit('Forbidden');

    3. 

  3. 

    4. 

  4. $basename="$admin_file?adminjob=attachrenew";

    5. 

  5. ($attach_url || $db_ifftp) && adminmsg('attachrenew_forbidden');

    6. 

  6. 

    7. 

  7. if(empty($_POST['action'])){

    8. 

  8. 	InitGP(array('S_start','orderway'));

    9. 

  9. 	$rs = $db->get_one("SELECT COUNT(*) AS count FROM pw_attachs");

    10. 

  10. 	$A_count  = $rs['count'];

    11. 

  11. 	$threaddb = array();

    12. 

  12. 	if($A_count!=0){

    13. 

  13. 		$P_N = 1000;

    14. 

  14. 		$A_C = ceil($A_count/$P_N);

    15. 

  15. 		$L_N = $P_N-$A_C*$P_N+$A_count;

    16. 

  16. 		$S_end = $L_N;

    17. 

  17. 		for($i=1;$i<=$A_C;$i++){

    18. 

  18. 			$num = ($i-1)*$P_N;

    19. 

  19. 			$E_num = $i==$A_C ? $num+$L_N : $num+$P_N;

    20. 

  20. 			$S_num = "$num To $E_num";

    21. 

  21. 			$A_option.="<option value=$i>$S_num</option>";

    22. 

  22. 		}

    23. 

  23. 		!$S_start && $S_start=1;

    24. 

  24. 		$S_start==$A_C ? $S_end=$L_N : $S_end=$P_N;

    25. 

  25. 		$start_limit=($S_start-1)*$P_N;

    26. 

  26. 		$orderway!='size' && $orderway='aid';

    27. 

  27. 		$query=$db->query("SELECT aid,fid,name,size,attachurl FROM pw_attachs ORDER BY $orderway".pwLimit($start_limit,$S_end));

    28. 

  28. 

    29. 

  29. 		while($attach=$db->fetch_array($query)){

    30. 

  30. 			if(!file_exists("$attachdir/$attach[attachurl]")){

    31. 

  31. 				$thread['aid']=$attach['aid'];

    32. 

  32. 				$thread['size']=$attach['size'];

    33. 

  33. 				$thread['url']=$attach['attachurl'];

    34. 

  34. 				$thread['name']=$attach['name'];

    35. 

  35. 				$thread['where']="thread.php?fid=$fid";

    36. 

  36. 				$threaddb[]=$thread;

    37. 

  37. 			}

    38. 

  38. 		}

    39. 

  39. 	}

    40. 

  40. 	include PrintEot('attachrenew');exit;

    41. 

  41. } else{

    42. 

  42. 	$count = 0;

    43. 

  43. 	$ttable_a = array('pw_tmsgs');

    44. 

  44. 	if($db_tlist){

    45. 

  45. 		$tlistdb = unserialize($db_tlist);

    46. 

  46. 		foreach($tlistdb as $key=>$val){

    47. 

  47. 			$ttable_a[] = 'pw_tmsgs'.$key;

    48. 

  48. 		}

    49. 

  49. 	}

    50. 

  50. 	foreach($ttable_a as $pw_tmsgs){

    51. 

  51. 		$query=$db->query("SELECT t.fid,t.tid,t.authorid,aid FROM $pw_tmsgs tm LEFT JOIN pw_threads t ON t.tid=tm.tid  WHERE aid<>''");

    52. 

  52. 		while($aids=$db->fetch_array($query)){

    53. 

  53. 			$attachs= unserialize(stripslashes($aids['aid']));

    54. 

  54. 			if(is_array($attachs)){

    55. 

  55. 				$update=0;

    56. 

  56. 				foreach($attachs as $key=>$attach){

    57. 

  57. 					if($attach['attachurl'] && file_exists($attachdir.'/'.$attach['attachurl'])){

    58. 

  58. 						$check=$db->get_one("SELECT aid FROM pw_attachs WHERE aid=".pwEscape($attach['aid']));

    59. 

  59. 						if(!$check){

    60. 

  60. 							$uploadtime=pwFilemtime($attachdir.'/'.$attach['attachurl']);

    61. 

  61. 							$count++;

    62. 

  62. 							$db->update("INSERT INTO pw_attachs"

    63. 

  63. 								. " SET " . pwSqlSingle(array(

    64. 

  64. 									'aid'		=> $attach['aid'],		'fid'		=> $aids['fid'],

    65. 

  65. 									'uid'		=> $aids['authorid'],	'tid'		=> $aids['tid'],

    66. 

  66. 									'pid'		=> 0,					'name'		=> $attach['name'],

    67. 

  67. 									'type'		=> $attach['type'],		'size'		=> $attach['size'],

    68. 

  68. 									'attachurl'	=> $attach['attachurl'],'hits'		=> $attach['hits'],

    69. 

  69. 									'needrvrc'	=> $attach['needrvrc'],	'uploadtime'=> $uploadtime,

    70. 

  70. 									'descrip'	=> $attach['desc']

    71. 

  71. 							),false));

    72. 

  72. 						}

    73. 

  73. 					} else{

    74. 

  74. 						$count++;

    75. 

  75. 						$check=$db->get_one("SELECT aid FROM pw_attachs WHERE aid=".pwEscape($attach['aid']));

    76. 

  76. 						if($check){

    77. 

  77. 							$db->update("DELETE FROM pw_attachs WHERE aid=".pwEscape($attach['aid']));

    78. 

  78. 						}

    79. 

  79. 						$update=1;

    80. 

  80. 						unset($attachs[$key]);

    81. 

  81. 					}

    82. 

  82. 				}

    83. 

  83. 				if($update){

    84. 

  84. 					$attachs=$attachs ? serialize($attachs):'';

    85. 

  85. 					$db->update("UPDATE $pw_tmsgs SET aid=".pwEscape($attachs,false)."WHERE tid=".pwEscape($aids['tid']));

    86. 

  86. 				}

    87. 

  87. 			} else{

    88. 

  88. 				$count++;

    89. 

  89. 				$db->update("UPDATE $pw_tmsgs SET aid='' WHERE tid=".pwEscape($aids['tid']));

    90. 

  90. 			}

    91. 

  91. 		}

    92. 

  92. 	}

    93. 

  93. 	$ptable_a = array('pw_posts');

    94. 

  94. 	if($db_plist){

    95. 

  95. 		$p_list=explode(',',$db_plist);

    96. 

  96. 		foreach($p_list as $val){

    97. 

  97. 			$ptable_a[] = 'pw_posts'.$val;

    98. 

  98. 		}

    99. 

  99. 	}

    100. 

  100. 	foreach($ptable_a as $pw_posts){

    101. 

  101. 		$query=$db->query("SELECT fid,tid,authorid,aid FROM $pw_posts WHERE aid<>''");

    102. 

  102. 		while($aids=$db->fetch_array($query)){

    103. 

  103. 			$attachs= unserialize(stripslashes($aids['aid']));

    104. 

  104. 			if(is_array($attachs)){

    105. 

  105. 				$update=0;

    106. 

  106. 				foreach($attachs as $key=>$attach){

    107. 

  107. 					if($attach['attachurl'] && file_exists($attachdir.'/'.$attach['attachurl'])){

    108. 

  108. 						$check=$db->get_one("SELECT aid FROM pw_attachs WHERE aid=".pwEscape($attach['aid']));

    109. 

  109. 						if(!$check){

    110. 

  110. 							$uploadtime=pwFilemtime($attachdir.'/'.$attach['attachurl']);

    111. 

  111. 							$count++;

    112. 

  112. 							$db->update("INSERT INTO pw_attachs"

    113. 

  113. 								. " SET " . pwSqlSingle(array(

    114. 

  114. 									'aid'		=> $attach['aid'],

    115. 

  115. 									'fid'		=> $aids['fid'],

    116. 

  116. 									'uid'		=> $aids['authorid'],

    117. 

  117. 									'tid'		=> $aids['tid'],

    118. 

  118. 									'pid'		=> 0,

    119. 

  119. 									'name'		=> $attach['name'],

    120. 

  120. 									'type'		=> $attach['type'],

    121. 

  121. 									'size'		=> $attach['size'],

    122. 

  122. 									'attachurl'	=> $attach['attachurl'],

    123. 

  123. 									'hits'		=> $attach['hits'],

    124. 

  124. 									'needrvrc'	=> $attach['needrvrc'],

    125. 

  125. 									'uploadtime'=> $uploadtime,

    126. 

  126. 									'descrip'	=> $attach['desc']

    127. 

  127. 							),false));

    128. 

  128. 						}

    129. 

  129. 					} else{

    130. 

  130. 						$count++;

    131. 

  131. 						$check=$db->get_one("SELECT aid FROM pw_attachs WHERE aid=".pwEscape($attach['aid']));

    132. 

  132. 						if($check){

    133. 

  133. 							$db->update("DELETE FROM pw_attachs WHERE aid=".pwEscape($attach['aid']));

    134. 

  134. 						}

    135. 

  135. 						$update=1;

    136. 

  136. 						unset($attachs[$key]);

    137. 

  137. 					}

    138. 

  138. 				}

    139. 

  139. 				if($update){

    140. 

  140. 					$attachs=$attachs ?  addslashes(serialize($attachs)):'';

    141. 

  141. 					$db->update("UPDATE $pw_posts SET aid=".pwEscape($attachs)."WHERE tid=".pwEscape($aids['tid']));

    142. 

  142. 				}

    143. 

  143. 			} else{

    144. 

  144. 				$count++;

    145. 

  145. 				$db->update("UPDATE $pw_posts SET aid='' WHERE tid=".pwEscape($aids['tid']));

    146. 

  146. 			}

    147. 

  147. 		}

    148. 

  148. 	}

    149. 

  149. 	adminmsg('attach_renew');

    150. 

  150. }

    151. 

  151. ?>
    152.