版主申请加强版 For D4 版主评分乱码修正

原帖： https://discuz.dismall.com/viewthread.php?tid=180557

相关补丁： 版主申请加强版 For D4 modapp.php文件修正（https://discuz.dismall.com/viewthread.php?tid=204992）

修正说明： 如果在打完以前的版主申请加强版 For D4 modapp.php文件修正（https://discuz.dismall.com/viewthread.php?tid=204992）补丁后，版主评分没有乱码问题的，请不要做此修正，版主评分由于数据库字符集问题仍有乱码的，请做此修正。


-------------------------------------------------------------------------
1. modsetup.php 中查找

1. rateusername varchar(10) NOT NULL

复制代码

10 改为 100

查找

1. rate varchar(100) DEFAULT '0' NOT NULL

复制代码

100 改为 200

运行 modsetup.php，点击“卸载安装”，删掉原来的插件的数据表，然后点击“全新安装”，重新添加数据表。

2. 用下面的代码替换 modapp.php 文件：

1. 
   
2. <?php
   
3. 
   
4. require_once './include/common.inc.php';
   
5. require_once DISCUZ_ROOT.'./include/discuzcode.func.php';
   
6. 
   
7. $discuz_action = 185;
   
8. 
   
9. if (!$discuz_uid) {
   
10.           showmessage("对不起，本服务只对注册会员开放","index.php");
    
11. }
    
12. 
    
13. $modappsettings = getmodappconfig();
    
14. 
    
15. $ch_credit = trim($modappsettings['vars']['ch_credit']);
    
16. $ch_apply = trim($modappsettings['vars']['ch_apply']);
    
17. $maxotname = trim($modappsettings['vars']['maxotname']);
    
18. $maxotherm = trim($modappsettings['vars']['maxotherm']);
    
19. $maxname = trim($modappsettings['vars']['maxname']);
    
20. $maxsites = trim($modappsettings['vars']['maxsites']);
    
21. $maxabout = trim($modappsettings['vars']['maxabout']);
    
22. $maxregdate = trim($modappsettings['vars']['maxregdate']);
    
23. $maxposts = trim($modappsettings['vars']['maxposts']);
    
24. 
    
25. function forumselect($groupselectable = 0) {
    
26.         global $_DCACHE, $discuz_uid, $groupid;
    
27. 
    
28.         $forumlist = '';
    
29.         if(!isset($_DCACHE['forums'])) {
    
30.                 require_once DISCUZ_ROOT.'./forumdata/cache/cache_forums.php';
    
31.         }
    
32. 
    
33.         foreach($_DCACHE['forums'] as $fid1 => $forum1) {
    
34.                 if($forum1['type'] == 'group') {
    
35.                         $forumlist .= '<option value="<a href=index.php?gid='.$forum1['fid'].' target=_blank>'.$forum1['name'].'</a>">'.$forum1['name'].'</option>';
    
36.                         foreach($_DCACHE['forums'] as $fid2 => $forum2) {
    
37.                                 if($forum2['fup'] == $fid1 && $forum2['type'] == 'forum' && (!$forum2['viewperm'] || ($forum2['viewperm'] && forumperm($forum2['viewperm'])) || strstr($forum2['users'], "\t$discuz_uid\t"))) {
    
38.                                         $forumlist .= '<option value="<a href=forumdisplay.php?fid='.$fid2.' target=_blank>'.$forum2['name'].'</a>">&nbsp; &gt; '.$forum2['name'].'</option>';
    
39.                                         foreach($_DCACHE['forums'] as $fid3 => $forum3) {
    
40.                                                 if($forum3['fup'] == $fid2 && $forum3['type'] == 'sub' && (!$forum3['viewperm'] || ($forum3['viewperm'] && forumperm($forum3['viewperm'])) || strstr($forum3['users'], "\t$discuz_uid\t"))) {
    
41.                                                         $forumlist .= '<option value="<a href=forumdisplay.php?fid='.$fid3.' target=_blank>'.$forum3['name'].'</a>">&nbsp; &nbsp; &nbsp; &gt; '.$forum3['name'].'</option>';
    
42.                                                 }
    
43.                                         }
    
44.                                 }
    
45.                         }
    
46.                         $forumlist .= '<option value="">&nbsp;</option>';
    
47.                 } elseif(!$forum1['fup'] && $forum1['type'] == 'forum' && (!$forum1['viewperm'] || ($forum1['viewperm'] && forumperm($forum1['viewperm'])) || strstr($forum1['users'], "\t$discuz_uid\t"))) {
    
48.                         $forumlist .= '<option value="<a href=forumdisplay.php?fid='.$fid1.' target=_blank>'.$forum1['name'].'</a>"> &nbsp; &gt; '.$forum1['name'].'</option>';
    
49.                         foreach($_DCACHE['forums'] as $fid2 => $forum2) {
    
50.                                 if($forum2['fup'] == $fid1 && $forum2['type'] == 'sub' && (!$forum2['viewperm'] || ($forum2['viewperm'] && forumperm($forum2['viewperm'])) || strstr($forum2['users'], "\t$discuz_uid\t"))) {
    
51.                                         $forumlist .= '<option value="<a href=forumdisplay.php?fid='.$fid2.' target=_blank>'.$forum2['name'].'</a>">&nbsp; &nbsp; &nbsp; &gt; '.$forum2['name'].'</option>';
    
52.                                 }
    
53.                         }
    
54.                         $forumlist .= '<option value="">&nbsp;</option>';
    
55.                 }
    
56. 
    
57.         }
    
58. 
    
59.         return $forumlist;
    
60. }
    
61. $forumselect = forumselect();
    
62. 
    
63. $query = $db->query("SELECT * FROM {$tablepre}members WHERE uid='$discuz_uid'");
    
64.         $post=$db->fetch_array($query);
    
65. $post['bemem'] = intval(($timestamp - $post['regdate'])/(3600*24));
    
66. 
    
67. $chquery = $db->query("SELECT COUNT(*) FROM {$tablepre}plugin_modapp WHERE userid=$post[uid]");
    
68. $apply = $db->result($chquery, 0);
    
69.         if($apply >= $ch_apply) {showmessage("抱歉，每位会员只可申请 $ch_apply 次！",'usermodapp.php'); }
    
70. 
    
71. if (isset($submit)) {
    
72.         if($apply >= $ch_apply) {showmessage("抱歉，每位会员只可申请 $ch_apply 次！",'usermodapp.php'); }
    
73. 
    
74.         if($maxposts > $post[posts])
    
75.                 showmessage("抱歉，发帖需超过 $maxposts 篇，才会接受申请","usermodapp.php");
    
76.         if($maxregdate > $post['bemem'])
    
77.                 showmessage("抱歉，您的注册天数未达到申请版主最低要求","usermodapp.php");
    
78.         if($ch_credit > $post[credits])
    
79.                 showmessage("抱歉，您的积分未达到申请版主最低要求","usermodapp.php");
    
80.         if($theone=='')
    
81.                 showmessage("您觉得自己不符合条件吗？返回上一页");
    
82.         if($wichforum=='')
    
83.                 showmessage("您要申请 [ $bbname ] 哪版版主？返回上一页");
    
84.         if($name=='')
    
85.                 showmessage("您不想填写真实姓名，可填会员名称！返回上一页");               
    
86.         if($about=='')
    
87.                 showmessage("您有什么贡献及建议忘了填！返回上一页");
    
88.         if(strlen($about) > $maxabout)
    
89.                 showmessage("您的建议与想法超过 $maxabout 字元！返回上一页");
    
90. 
    
91.         $about = preg_replace("/\</is", "&lt;", $about);
    
92.         $other_forum_names = preg_replace("/\</is", "&lt;", $other_forum_names);
    
93.         $other_m = preg_replace("/\</is", "&lt;", $other_m);
    
94.         $name = preg_replace("/\</is", "&lt;", $name);
    
95.         $websites = preg_replace("/\</is", "&lt;", $websites);
    
96. 
    
97.         $about = preg_replace("/\n/is", "<br>", $about);
    
98. 
    
99.         $lala = "INSERT into {$tablepre}plugin_modapp (appid,userid,theone,wichforum,connection,internet,other,other_forum_names,english,other_m,name,email,username,websites,about,ratetotal) VALUES ('NULL','".urlencode($post[uid])."','$timestamp','".urlencode(addslashes($wichforum))."','".urlencode($connection)."','".urlencode($internet)."','".urlencode($other)."','".urlencode(addslashes($other_forum_names))."','".urlencode($english)."','".urlencode(addslashes($other_m))."','".urlencode(addslashes($name))."','$email','".urlencode($discuz_user)."','".urlencode($websites)."','".urlencode(addslashes($about))."','0')";
    
100.                  $result = mysql_query($lala) or
     
101.                     die("INSERT Error: " . mysql_error() . " in Query: $query");
     
102.                                 showmessage("您的版主申请表提交完成！","usermodapp.php");
     
103.         exit;
     
104.   
     
105. }
     
106. if ($discuz_user) {
     
107.         include template('modapp');
     
108. } else {
     
109.           showmessage("对不起，本服务只对注册会员开放","index.php");
     
110. }
     
111. 
     
112. function getmodappconfig() {
     
113.         @include DISCUZ_ROOT.'./forumdata/cache/plugin_modapp.php';
     
114.         return $_DPLUGIN['modapp'];
     
115.         }
     
116. ?>
     

复制代码

3. 用下面的代码替换 usermodapp.php 文件：

1. 
   
2. <?php
   
3. 
   
4. require_once './include/common.inc.php';
   
5. require_once DISCUZ_ROOT.'./include/forum.func.php';
   
6. require_once DISCUZ_ROOT.'./include/discuzcode.func.php';
   
7. 
   
8. if (!$discuz_uid) {
   
9.           showmessage("对不起，本服务只对注册会员开放","index.php");
   
10. }
    
11. 
    
12. $discuz_action = 185;
    
13. 
    
14. $modpage = 20; // 申请列表分页显示数量
    
15. 
    
16. if($page) {
    
17.                 $start_limit = ($page-1) * $modpage;
    
18.         } else {
    
19.                 $start_limit = 0;
    
20.                 $page = 1;
    
21.         }
    
22. 
    
23.         $query = $db->query("SELECT * FROM {$tablepre}members WHERE uid='$discuz_uid'");
    
24. 
    
25.         $post=$db->fetch_array($query);
    
26. 
    
27. // ###################### Start View #######################
    
28. 
    
29. if ($action=="" and !isset($submit))
    
30.         $action='view';
    
31. if ($action=="view"){
    
32. 
    
33. $query=$db->query("select count(*) as rows from {$tablepre}plugin_modapp");
    
34. $aaa = $db->fetch_array($query);
    
35. $rows = $aaa['rows'];
    
36. unset($aaa);
    
37. 
    
38.         $altbg1 = ALTBG2;
    
39.         $altbg2 = ALTBG1;
    
40.         $postcount = 0;
    
41. 
    
42.         $multipage = multi($rows, $modpage, $page, "usermodapp.php?action=view");
    
43.         $query = $db->query("SELECT * FROM {$tablepre}plugin_modapp ORDER BY theone DESC LIMIT $start_limit, $modpage");
    
44.         while($appmod=$db->fetch_array($query)){
    
45.         $usernameurl=$appmod[username];
    
46.         $appmod[username]=urldecode($appmod[username]);
    
47.         $appmod[wichforum]=urldecode($appmod[wichforum]);
    
48.         $appmod[thetime]=$appmod[theone];
    
49.         $appmod[theone] = gmdate("$dateformat $timeformat", $appmod[theone] + ($timeoffset * 3600));
    
50. 
    
51.                 $bgno = $postcount++ % 2 + 1;
    
52.                 $appmod['thisbg'] = ${'altbg'.$bgno};
    
53. 
    
54.                  $appmodlist[] = $appmod;
    
55.         }
    
56.         include template('modapp_view');
    
57. }
    
58. // ###################### Start rate #######################
    
59. if ($action=="del"){
    
60. 
    
61.         if($post[uid] == $userid || $adminid == '1' || $adminid == '2') {
    
62.         showmessage("真的要删除 <font color=red>[ $deluser ]</font> 版主的申请吗？<br><br><br>
    
63.                         <input type="button" name="delSubmit" style="color:red" value="确定删除" onClick="javascript:window.location.href='usermodapp.php?action=delsure&id=".$id."&userid=".$userid."&actions=$actions&page=$page'">
    
64.                         &nbsp;&nbsp;&nbsp;&nbsp;<input type="button" name="delSubmit" value="放弃删除" OnClick='javascript:history.back()'">"
    
65.                 );
    
66.         } else {
    
67.                 showmessage("对不起，您没有权限进行此项操作！","usermodapp.php");
    
68.         }
    
69. }
    
70. 
    
71. if ($action=="delsure"){
    
72.         if($post[uid] == $userid || $adminid == '1' || $adminid == '2') {
    
73.         $db->query("DELETE FROM {$tablepre}plugin_modapp WHERE appid='".$id."'");
    
74.           $db->query("DELETE FROM {$tablepre}plugin_modappuser WHERE rateuserid='".$id."'");
    
75.           showmessage("操作成功！","usermodapp.php?action=$actions&page=$page");
    
76.         } else {
    
77.                 showmessage("对不起，您没有权限进行此项操作！","usermodapp.php");
    
78.         }
    
79. }
    
80. 
    
81. if ($action=="delme"){
    
82. 
    
83.         if($post[uid] == $userid || $adminid == '1' || $adminid == '2') {
    
84.         showmessage("真的要删除 <font color=red>[ $rateusername ]</font> 的评分吗？<br><br><br>
    
85.                         <input type="button" name="delSubmit" style="color:red" value="确定删除" onClick="javascript:window.location.href='usermodapp.php?action=delmesure&rateid=".$rateid."&userid=".$userid."&rate=".$rate."&appid=".$appid."&ratetotal=".$ratetotal."&actions=$actions'">
    
86.                         &nbsp;&nbsp;&nbsp;&nbsp;<input type="button" name="delSubmit" value="放弃删除" OnClick='javascript:history.back()'">"
    
87.                 );
    
88.         } else {
    
89.                 showmessage("对不起，您没有权限进行此项操作！","usermodapp.php");
    
90.         }
    
91. }
    
92. 
    
93. 
    
94. if ($action=="delmesure"){
    
95. 
    
96.         if($post[uid] == $userid || $adminid == '1' || $adminid == '2') {
    
97. 
    
98.         if (preg_match("/\D/",$rate)){
    
99.         $setrate = "0";
    
100.         }else{
     
101.         $setrate = "$rate";
     
102.         }
     
103. 
     
104.         $setratetotal = "$ratetotal";
     
105.         $query = $db->query("UPDATE {$tablepre}plugin_modapp SET ratetotal=$setratetotal-$setrate WHERE appid='".$appid."'");
     
106.           $query = $db->query("DELETE FROM {$tablepre}plugin_modappuser WHERE rateid='".$rateid."'");
     
107.           showmessage("操作成功！","usermodapp.php?action=$actions&userid=$userid&rateuserid=$appid");
     
108. 
     
109.         } else {
     
110.                 showmessage("对不起，您没有权限进行此项操作！","usermodapp.php");
     
111.         }
     
112. }
     
113. 
     
114. if (isset($submit)) {
     
115.         if(!$admin_other){
     
116.         if(!$userrate){ showmessage("请选择要评的分数！请返回上页！"); } }
     
117. 
     
118.         $query = $db->query("SELECT * FROM {$tablepre}members WHERE uid='$discuz_uid'");
     
119.         $post=$db->fetch_array($query);       
     
120. 
     
121.         $chquery = $db->query("SELECT * FROM {$tablepre}plugin_modapp WHERE userid='".$post[uid]."' AND appid='".$rateuserid."'");
     
122.         if($db->num_rows($chquery)>0)
     
123.                 showmessage("对不起，您不能对自己的申请进行评分！",'usermodapp.php');
     
124. 
     
125.         $query = $db->query("SELECT * FROM {$tablepre}plugin_modappuser WHERE rateusername='".urlencode($discuz_user)."' and rateuserid='".$rateuserid."'");
     
126.         if($db->num_rows($query)>0)
     
127.                 showmessage("对不起，您不能对同一篇申请重复评分！",'usermodapp.php');
     
128. 
     
129.         if($admin_other){
     
130.         $user = "INSERT INTO {$tablepre}plugin_modappuser (rateid,userid,rateuserid,rateusername,rate) VALUES(NULL,'$post[uid]','".addslashes($rateuserid)."','".urlencode($discuz_user)."','".urlencode(addslashes($admin_other))."')";
     
131.                  $rate = mysql_query($user) or
     
132.                     die("INSERT Error: " . mysql_error() . " in Query: $query");
     
133.         }else{
     
134.         $user = "INSERT INTO {$tablepre}plugin_modappuser (rateid,userid,rateuserid,rateusername,rate) VALUES(NULL,'$post[uid]','".addslashes($rateuserid)."','".urlencode($discuz_user)."','$userrate')";
     
135.                  $rate = mysql_query($user) or
     
136.                     die("INSERT Error: " . mysql_error() . " in Query: $query");
     
137.         }
     
138. 
     
139.         if(!$admin_other){
     
140.         $lala = "UPDATE {$tablepre}plugin_modapp SET ratetotal=ratetotal+$userrate WHERE appid=$rateuserid";
     
141.                  $result = mysql_query($lala) or
     
142.                     die("INSERT Error: " . mysql_error() . " in Query: $query");
     
143.         }
     
144. 
     
145.                 showmessage('感谢你参与对申请人的评分。','usermodapp.php');
     
146.         exit();  
     
147. }
     
148. 
     
149. if ($action=="rate") {
     
150.   
     
151.         $query = $db->query("SELECT * FROM {$tablepre}plugin_modapp where appid=$rateuserid");
     
152.         $allmod = $db->num_rows($query);
     
153.         while ($mods =$db->fetch_array($query)) {
     
154. 
     
155.                 $mods[username]=urldecode($mods[username]);
     
156.                 $mods[name]=urldecode($mods[name]);
     
157.                 $mods[about]=urldecode($mods[about]);
     
158.                 $mods[english]=urldecode($mods[english]);
     
159.                 $mods[wichforum]=urldecode($mods[wichforum]);
     
160.                 $mods[other_forum_names]=urldecode($mods[other_forum_names]);
     
161.                 $mods[other_m]=urldecode($mods[other_m]);
     
162.                 $mods[other]=urldecode($mods[other]);
     
163.                 $mods[connection]=urldecode($mods[connection]);
     
164.                 $mods[internet]=urldecode($mods[internet]);
     
165.                 $mods[websites]=urldecode($mods[websites]);
     
166. 
     
167.                 $time = gmdate("$dateformat $timeformat", $mods[theone] + ($timeoffset * 3600));
     
168.                 $modslist[] = $mods;
     
169.         }
     
170.         $award = $db->query("SELECT * FROM {$tablepre}plugin_modappuser where rateuserid=$rateuserid");
     
171.         $allshit = $db->num_rows($award);
     
172.         while($shit = $db->fetch_array($award) ) {
     
173.                 $shit[rateusername]=urldecode($shit[rateusername]);
     
174.                 $shit[rate]=urldecode($shit[rate]);
     
175.                 $shitlist[] = $shit;
     
176.         }
     
177. 
     
178.         if($allmod == 0){
     
179.                  showmessage('目前还没有人申请版主！','index.php');
     
180.         }
     
181.         include template('modapp_rate');
     
182. }
     
183. ?>
     

复制代码

4. 修正完毕。

沙发一个.还没出现这个问题

不好意思．没看到．．．

支持上去 目前无问题

wichforum varchar(100) NOT NULL,

应该设置大一点吧


刚刚没有看到 不好意思~~

原帖由 baibbs 于 2005-12-26 14:46 发表


应该设置大一点吧


刚刚没有看到 不好意思~~

如果版块名称显示不完全，就加大点，主要看你自己的版块设置。:)

谢谢

您注册了 13160 天 &#187; 恭喜，有资格申请版主

这段的源码计算也有问题。我论坛运行才１个月。

您注册了 <font color=red>$post[bemem]</font> 天 &raquo; 恭喜，有资格申请版主

不知道应该怎么改，还是有其它什么问题

后台更新缓存试试。

無法安裝
一安裝就出現
SQL:
CREATE TABLE cdb_plugin_modapp (
appid smallint(5) unsigned NOT NULL auto_increment,
userid smallint(4) NOT NULL,
theone varchar(100) NOT NULL,
wichforum varchar(100) NOT NULL,
connection varchar(100) NOT NULL,
internet varchar(100) NOT NULL,
other varchar(100) NOT NULL,
other_forum_names varchar(100) NOT NULL,
english varchar(100) NOT NULL,
other_m varchar(100) NOT NULL,
name varchar(100) NOT NULL,
email varchar(100) NOT NULL,
username varchar(100) NOT NULL,
websites varchar(100) NOT NULL,
about varchar(200) NOT NULL,
ratetotal varchar(100) NOT NULL,
PRIMARY KEY (appid)
);
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'connection varchar(100) NOT NULL,
internet varchar(100) NOT N
Errno.: 1064

An error report has been dispatched to our administrator.