开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 磁盘/存储 > SCSI/ASPI > 查看源码
forum_updateforumstatic.aspx
资源名称：dnt_3.1.0_sqlserver.rar　[点击查看]
上传用户：wenllgg125
上传日期：2020-04-09
资源大小：7277k
文件大小：15k
源码类别：

SCSI/ASPI

开发平台：

Others

forum_updateforumstatic.aspx：源码内容
  1. <%@ Page language="c#" Inherits="Discuz.Web.Admin.updateforumstatic" Codebehind="forum_updateforumstatic.aspx.cs" %>
  2. <%@ Register TagPrefix="cc1" Namespace="Discuz.Control" Assembly="Discuz.Control" %>
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  4. <html >
  5. <head>
  6. <title>updateforumstatic</title>
  7. <link href="../styles/dntmanager.css" type="text/css" rel="stylesheet" /> 
  8. <script type="text/javascript" src="../js/common.js"></script>
  9. <script type="text/javascript">
  10. var lastnumber=0;
  11. var currentnum=0;
  12.  
  13. function runstatic(opname,pertask)
  14. {  
  15.   if(lastnumber>-1)
  16.   { 
  17.  currentnum=lastnumber/1+pertask/1;    // alert(currentnum);
  19.  var result;
  20.  switch (opname)      
  21.  {
  22. case "ReSetFourmTopicAPost":     result="rn重建论坛帖数";break
  23. case "ReSetUserDigestPosts":     result = "rn重建所有用户的精华贴数"; break
  24. case "ReSetUserPosts":           result = "rn重建分表" + lastnumber + " 的用户发帖数"; break
  25. case "ReSetTopicPosts": result = "rn重建分表" + lastnumber + " 的主题最后回复等信息"; break
  26. case "UpdatePostSP": result = "rn重建分表" + lastnumber + " 的存储过程"; break
  27. case "UpdateMyPost": result = "rn更新分表" + lastnumber + " 中我的帖子"; break
  28.  }
  29.  
  30.  document.getElementById('Layer5').innerHTML ="<br /><table><tr><td valign=top><img border="0" src="../images/ajax_loading.gif"  /></td><td valign=middle style="font-size: 14px;" >"+result+"<BR /></td></tr></table><BR />";
  31.  document.getElementById('success').style.display ="block"; 
  33.  lastnumber=getReturn('../global/global_ajaxcall.aspx?opname='+opname+'&lastnumber='+lastnumber+'&pertask='+pertask);
  34.  if(lastnumber==null)
  35.  {
  36. document.getElementById('Layer5').innerHTML="<br />操作成功执行";
  37. document.getElementById('success').style.display = "block";
  38. count(); 
  39. document.getElementById('Form1').submit();
  40.  }
  41. }
  42.   else
  43.   {
  44.  document.getElementById('Layer5').innerHTML="<br />操作成功执行";
  45.  document.getElementById('success').style.display = "block";
  46.  count(); 
  47.  document.getElementById('Form1').submit();
  48.   }
  49. }
  51. function clearflag()
  52. {
  53.  bar=0;
  54.  document.getElementById('Layer5').innerHTML="<br />操作成功执行";
  55.  document.getElementById('success').style.display = "block";
  56.  count(); 
  57. }
  60. var bar=0;
  61. function count()
  62. { 
  63. bar=bar+4;
  64. if (bar<99) {setTimeout("count()",100);} 
  65. else { document.getElementById('success').style.display ="none"; } 
  66. }
  68. function run(opname,pertask)
  69. {
  70.   if(pertask=="")
  71.   {   
  72.   alert('每个循环更新数量不能为空!');return;
  73.   }
  74.   lastnumber=1;
  75.   currentnum=0;
  76.   bar=0;
  77.   
  78.   document.getElementById('Layer5').innerHTML="<br /><table><tr><td valign=top><img border="0" src="../images/ajax_loading.gif"  /></td><td valign=middle style="font-size: 14px;" >正在处理数据, 请稍等...<BR /></td></tr></table><BR />";
  79.   document.getElementById('success').style.display = "block";
  80.   //runstatic(opname,pertask);
  81.   setInterval('runstatic("'+opname+'",'+pertask+')',1000); //每次提交时间为1秒
  82. }
  85. var result=0;
  86. function run2(opname,startvalue,endvalue)
  87. {
  89.   document.getElementById('Layer5').innerHTML="<br /><table><tr><td valign=top><img border="0" src="../images/ajax_loading.gif"  /></td><td valign=middle style="font-size: 14px;" >正在处理数据, 请稍等...<BR /></td></tr></table><BR />";
  90.   document.getElementById('success').style.display = "block";
  91.   //alert(opname); 
  92.   pageurl='../global/global_ajaxcall.aspx?opname='+opname+'&startvalue='+startvalue+'&endvalue='+endvalue;
  93.   setTimeout('getforumdata("'+pageurl+'")',1000); //每次提交时间为5秒
  94. }
  97. function getforumdata(pageurl)
  98. {
  99.   result=getReturn(pageurl);
  100.   if((result>0)||(result==null))
  101.   {
  102. bar=0;
  103. document.getElementById('Layer5').innerHTML="<br />操作成功执行";
  104. document.getElementById('success').style.display = "block";
  105. count();
  106. document.getElementById('Form1').submit();
  107.   }
  108.   result=0;
  109. }
  110. </script>
  111. <meta http-equiv="X-UA-Compatible" content="IE=7" />
  112. </head>
  113. <body>
  114. <form id="Form1" runat="server">
  115. <div style="width:98%;margin:0 auto;">
  116. <table cellspacing="0" cellpadding="4" width="100%" align="center">
  117. <tr>
  118. <td class="panelbox">
  119. <table width="100%">
  120. <tr>
  121. <td style="width:260px">重建论坛全部帖数:</td>
  122. <td style="width:260px">
  123. <!--每个循环更新数量:&nbsp;&nbsp;&nbsp;&nbsp;
  124. <cc1:TextBox id="pertask1" runat="server" Text="15" RequiredFieldType="暂无校验" size="5"></cc1:TextBox>-->
  125. </td>
  126. <td>
  127. <span id="ReSetFourmTopicAPost_id"  onmouseover="showhintinfo(this,0,0,'','重建论坛全部帖数','50','up');" onmouseout="hidehintinfo();">
  128. <span>
  129. <button type="button" id="ReSetFourmTopicAPost_id" class="ManagerButton" onclick="javascript:run('ReSetFourmTopicAPost','1');">
  130. <img src="../images/submit.gif" />提 交</button>
  131. </span>
  132. </span>
  133. </td>
  134. </tr>
  135. <tr>
  136. <td style="width:260px">重建所有版块的主题数:</td>
  137. <td style="width:260px"></td>
  138. <td><cc1:Button id="UpdateCurTopics" runat="server" Text="提 交" HintInfo="如果版块内主题数缺少或分页不准, 可执行此操作"></cc1:Button></td>
  139. </tr>
  140. <tr>
  141. <td style="width:260px">重建所有版块今日发帖数:</td>
  142. <td style="width:260px"></td>
  143. <td><cc1:Button id="ResetTodayPosts" runat="server" Text="提 交" HintInfo="如果版块内今日发帖数缺少或不准, 可执行此操作"></cc1:Button></td>
  144. </tr>
  145. <tr>
  146. <td>重建全部用户精华帖数:</td>
  147. <td>
  148. <!--每个循环更新数量:&nbsp;&nbsp;&nbsp;&nbsp;
  149. <cc1:TextBox id="pertask2" runat="server" Text="1000" RequiredFieldType="暂无校验" size="5"></cc1:TextBox>-->
  150. </td>
  151. <td>
  152. <span id="ReSetUserDigestPosts_id"  onmouseover="showhintinfo(this,0,0,'','重建全部用户精华帖数','50','up');" onmouseout="hidehintinfo();">
  153. <span>
  154. <button id="ReSetUserDigestPosts_id" type="button" class="ManagerButton" onclick="javascript:run('ReSetUserDigestPosts','1');">
  155. <img src="../images/submit.gif" />提 交
  156. </button>
  157. </span>
  158. </span>
  159. </td>
  160. </tr>
  161. <tr>
  162. <td>重建全部用户发帖数:</td>
  163. <td>
  164. 每个循环更新的分表个数:&nbsp;&nbsp;&nbsp;&nbsp;
  165. <cc1:TextBox id="pertask3" runat="server" Text="1" RequiredFieldType="暂无校验" size="5"></cc1:TextBox>
  166. </td>
  167. <td>
  168. <span id="ReSetUserPosts_id"  onmouseover="showhintinfo(this,0,0,'','重建全部用户发帖数','50','up');" onmouseout="hidehintinfo();">
  169. <span>
  170. <button id="ReSetUserPosts_id" type="button" class="ManagerButton" onclick="javascript:run('ReSetUserPosts',pertask3.value);">
  171. <img src="../images/submit.gif" />提 交
  172. </button>
  173. </span>
  174. </span>
  175. </td>
  176. </tr>
  177. <tr>
  178. <td>重建全部主题的最后回复等信息:</td>
  179. <td>
  180. 每个循环更新的分表个数:&nbsp;&nbsp;
  181. <cc1:TextBox id="pertask4" runat="server" Text="1" RequiredFieldType="暂无校验" size="5"></cc1:TextBox>
  182. </td>
  183. <td>
  184. <span id="ReSetTopicPosts_id"  onmouseover="showhintinfo(this,0,0,'','重建全部主题最后回复等信息','50','up');" onmouseout="hidehintinfo();">
  185. <span>
  186. <button id="ReSetTopicPosts_id" type="button" class="ManagerButton" onclick="javascript:run('ReSetTopicPosts',pertask4.value);" >
  187. <img src="../images/submit.gif" />提 交
  188. </button>
  189. </span>
  190. </span>
  191. </td>
  192. </tr>
  193. </table>
  194. </td>
  195. </tr>
  196. </table>
  197. <hr style="border-top:0; border-bottom:1px solid #ccc;display:none;" size="1" />
  198. <table cellspacing="0" cellpadding="4" width="100%" align="center" style="display:none">
  199. <tr>
  200. <td class="panelbox">
  201. <table width="100%">
  202. <tr>
  203. <td style="width:260px">重建指定论坛区间帖数:</td>
  204. <td style="width:260px">
  205. 开始版块FID:
  206. <cc1:TextBox id="startfid" runat="server" Text="1" RequiredFieldType="数据校验" size="10"></cc1:TextBox><br />
  207. 结束版块FID:
  208. <cc1:TextBox id="endfid" runat="server" Text="20" RequiredFieldType="数据校验" size="10"></cc1:TextBox>
  209. </td>
  210. <td>
  211. <span id="ReSetFourmTopicAPost_StartEnd_id"  onmouseover="showhintinfo(this,0,0,'','重建指定论坛区间帖数','50','up');" onmouseout="hidehintinfo();">
  212. <span>
  213. <button id="ReSetFourmTopicAPost_StartEnd_id" type="button" class="ManagerButton" 
  214. onclick="javascript:run2('ReSetFourmTopicAPost_StartEnd',startfid.value,endfid.value);">
  215. <img src="../images/submit.gif" />提 交
  216. </button>
  217. </span>
  218. </span>
  219. </td>
  220. </tr>
  221. <tr>
  222. <td>重建指定用户区间精华帖数:</td>
  223. <td>
  224. 开始用户UID:
  225. <cc1:TextBox id="startuid_digest" runat="server" Text="1" RequiredFieldType="暂无校验" size="10"></cc1:TextBox><br />
  226. 结束用户UID:
  227. <cc1:TextBox id="enduid_digest" runat="server" Text="20" RequiredFieldType="暂无校验" size="10"></cc1:TextBox>
  228. </td>
  229. <td>
  230. <span id="ReSetUserDigestPosts_StartEnd_id"  onmouseover="showhintinfo(this,0,0,'','重建指定用户区间精华帖数','50','up');" onmouseout="hidehintinfo();">
  231. <span>
  232. <button id="ReSetUserDigestPosts_StartEnd_id" type="button" class="ManagerButton" 
  233. onclick="javascript:run2('ReSetUserDigestPosts_StartEnd',startuid_digest.value,enduid_digest.value);">
  234. <img src="../images/submit.gif" />提 交
  235. </button>
  236. </span>
  237. </span>
  238. </td>
  239. </tr>
  240. <tr>
  241. <td>重建指定用户区间发帖数:</td>
  242. <td>
  243. 开始用户UID:
  244. <cc1:TextBox id="startuid_post" runat="server" Text="1" RequiredFieldType="暂无校验" size="10"></cc1:TextBox><br />
  245. 结束用户UID:
  246. <cc1:TextBox id="enduid_post" runat="server" Text="20" RequiredFieldType="暂无校验" size="10"></cc1:TextBox>
  247. </td>
  248. <td>
  249. <span id="ReSetUserPosts_StartEnd_id"  onmouseover="showhintinfo(this,0,0,'','重建指定用户区间发帖数','50','up');" onmouseout="hidehintinfo();">
  250. <span>
  251. <button id="ReSetUserPosts_StartEnd_id" type="button" class="ManagerButton" 
  252. onclick="javascript:run2('ReSetUserPosts_StartEnd',startuid_post.value,enduid_post.value);">
  253. <img src="../images/submit.gif" />提 交
  254. </button>
  255. </span>
  256. </span>
  257. </td>
  258. </tr>
  259. <tr>
  260. <td>重建主题回复信息:</td>
  261. <td>
  262. 从分表:
  263. <cc1:TextBox id="starttid" runat="server" Text="" RequiredFieldType="暂无校验" size="10"></cc1:TextBox><br />
  264. 到分表:
  265. <cc1:TextBox id="endtid" runat="server" Text="" RequiredFieldType="暂无校验" size="10"></cc1:TextBox>
  266. </td>
  267. <td>
  268. <span id="ReSetTopicPosts_StartEnd_id"  onmouseover="showhintinfo(this,0,0,'','重建指定主题区间帖数','50','up');" onmouseout="hidehintinfo();">
  269. <span>
  270. <button id="ReSetTopicPosts_StartEnd_id" type="button" class="ManagerButton" 
  271. onclick="javascript:run2('ReSetTopicPosts_StartEnd',starttid.value,endtid.value);">
  272. <img src="../images/submit.gif" />提 交
  273. </button>
  274. </span>
  275. </span>
  276. </td>
  277. </tr>
  278. </table>
  279. </td>
  280. </tr>
  281. </table>
  282. <hr style="border-top:0; border-bottom:1px solid #ccc;" size="1" />
  283. <table cellspacing="0" cellpadding="4" width="100%" align="center">
  284. <tr>
  285. <td class="panelbox">
  286. <table width="100%">
  287. <tr>
  288. <td style="width:540px">清理移动标记:</td>
  289. <td><cc1:Button ID="SubmitClearFlag" runat="server" HintInfo="清理移动标记" Text="提 交" /></td>
  290. </tr>
  291. <tr>
  292. <td>重建论坛统计(表)数据:</td>
  293. <td><cc1:Button ID="ReSetStatistic" runat="server" HintInfo="重建论坛统计(表)数据" Text="提 交" /></td>
  294. </tr>
  295. <tr>
  296. <td>系统调整论坛版块:</td>
  297. <td><cc1:Button ID="SysteAutoSet" runat="server" HintInfo="系统调整论坛版块,对论坛版块表中的链接, 子版数等相关内容进行调整. " Text="提 交" /></td>
  298. </tr>
  299. <asp:Panel ID="UpdateStoreProcPanel" Visible="true" runat="server">
  300. <tr>
  301. <td>更新分表存储过程:</td>
  302. <%--<td><cc1:Button ID="UpdatePostSP" runat="server" HintInfo="更新分表存储过程" Text="提 交" /></td>--%>
  303. <td>
  304.     <span id="UpdatePostSP"  onmouseover="showhintinfo(this,0,0,'','更新分表存储过程','50','up');" onmouseout="hidehintinfo();">
  305. <span>
  306. <button id="UpdatePostSP" type="button" class="ManagerButton" onclick="javascript:run('UpdatePostSP','1');">
  307. <img src="../images/submit.gif" />提 交
  308. </button>
  309. </span>
  310. </span>
  311. </td>
  312. </tr>
  313. </asp:Panel>
  314. <tr>
  315. <td>更新分表最大和最小主题ID:</td>
  316. <td><cc1:Button ID="UpdatePostMaxMinTid" runat="server" HintInfo="更新分表最大和最小主题ID" Text="提 交" /></td>
  317. </tr>
  318. <tr>
  319. <td>为未建立全文索引的帖子表建立全文索引:</td>
  320. <td>
  321. <cc1:Button id="CreateFullTextIndex" runat="server" Text="提 交" 
  322. HintInfo="为未建立全文索引的帖子表建立全文索引,同时为已建全文索引的帖子表进行完全填充,操作时间与帖子数据量多少有关. 操作的结果要参见SqlServer相应数据库的“全文目录”的填充进度.">
  323. </cc1:Button>
  324. </td>
  325. </tr>
  326. <%--<tr>
  327. <td>更新所有版块的当前帖数:</td>
  328. <td><cc1:Button id="UpdateCurTopics" runat="server" Text="提 交" HintInfo="如果版块内主题数缺少或分页不准, 可执行此操作"></cc1:Button></td>
  329. </tr>--%>
  330. <tr>
  331. <td>更新所有版块最后发帖:</td>
  332. <td><cc1:Button ID="UpdateForumLastPost" runat="server" HintInfo="更新版块最后发帖" Text="提 交" /></td>
  333. </tr>
  334. </table>
  335. </td>
  336. </tr>
  337. </table>
  338. <hr style="border-top:0; border-bottom:1px solid #ccc;" size="1" />
  339. <table cellspacing="0" cellpadding="4" width="100%" align="center">
  340. <tr>
  341. <td class="panelbox">
  342. <table width="100%">
  343. <tr>
  344. <td style="width:540px">更新我的主题:</td>
  345. <td><cc1:Button ID="UpdateMyTopic" runat="server" HintInfo="更新我的主题" Text="提 交" /></td>
  346. </tr>
  347. <tr>
  348. <td>更新我的帖子:</td>
  349. <%--<td><cc1:Button ID="UpdateMyPost" runat="server" HintInfo="更新我的帖子" Text="提 交" /></td>--%>
  350. <td>
  351.     <span id="UpdateMyPost"  onmouseover="showhintinfo(this,0,0,'','更新我的帖子','50','up');" onmouseout="hidehintinfo();">
  352. <span>
  353. <button id="UpdateMyPost" type="button" class="ManagerButton" onclick="javascript:run('UpdateMyPost','1');">
  354. <img src="../images/submit.gif" />提 交
  355. </button>
  356. </span>
  357. </span>
  358. </td>
  359. </tr>
  360. </table>
  361. </td>
  362. </tr>
  363. </table>
  364. <cc1:Hint id="Hint1" runat="server" HintImageUrl="../images"></cc1:Hint>
  365.   </div>
  366. </form>
  367. <%=footer%>
  368. </body>
  369. </html>