| [Solved]Mutiple rank MOD | |
Posted: 07/24/2007 6:34 PM |
|
|
|
|
Citation |
Posts |
487 |
Word Cnt. |
35,729 |
BDay |
Oct 3 |
Sign |
Libra |
Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 11:51 PM
Location: Klang, Malaysia
|
|
|
|
|
|
I install the Mutiple rank mod.I get this error :
Code:
|
Error Detail
Critical Error
FIND FAILED: In file [templates/subSilver/viewtopic_body.tpl] could not find:
<td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}"></a><b>{postrow.POSTER_NAME}</b></span><br /><span class="postdetails">{postrow.POSTER_RANK}<br />{postrow.RANK_IMAGE}{postrow.POSTER_AVATAR}<br /><br />{postrow.POSTER_JOINED}<br />{postrow.POSTER_POSTS}<br />{postrow.POSTER_FROM}</span><br /></td>
MOD script line #279 :: FAQ :: Report
|
|
|
Last edited by masteranu84 on 07/27/2007 5:36 PM; edited 3 times in total |
|
|
|
Back to Top |
|
|
| Re: Mutiple rank MOD | |
Posted: 07/25/2007 12:47 AM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:51 PM
Location: St Pete, FL
|
|
|
|
|
|
Ok, try this:
OPEN
add_multiple_ranks_1_3_5.txt
FIND
Code:
|
#
#-----[ FIND ]------------------------------------------
#
<td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}"></a><b>{postrow.POSTER_NAME}</b></span><br /><span class="postdetails">{postrow.POSTER_RANK}<br />{postrow.RANK_IMAGE}{postrow.POSTER_AVATAR}<br /><br />{postrow.POSTER_JOINED}<br />{postrow.POSTER_POSTS}<br />{postrow.POSTER_FROM}</span><br /></td>
|
REPLACE WITH
Code:
|
#
#-----[ FIND ]------------------------------------------
#
{postrow.POSTER_RANK}<br />{postrow.RANK_IMAGE}
|
Save, upload, and try again using EM...
|
|
|
|
|
Back to Top |
|
|
| Re: Mutiple rank MOD | |
Posted: 07/25/2007 4:04 AM |
|
|
|
|
Citation |
Posts |
487 |
Word Cnt. |
35,729 |
BDay |
Oct 3 |
Sign |
Libra |
Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 11:51 PM
Location: Klang, Malaysia
|
|
|
|
|
|
Code:
|
Error Detail
Critical Error
FIND FAILED: In file [memberlist.php] could not find:
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
|
Now this~~~ |
|
|
|
|
Back to Top |
|
|
| Re: [Solved]Mutiple rank MOD | |
Posted: 07/25/2007 5:58 AM |
|
|
|
|
Citation |
Posts |
407 |
Word Cnt. |
10,993 |
BDay |
May 28 |
Sign |
Gemini |
Sex |
|
|
|
|
Joined: Feb 25, 2007
Local time: 11:51 PM
Location: SE England
|
|
|
|
|
|
OPEN:
add_multiple_ranks_1_3_5.txt
FIND:
Code:
|
#
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
|
REPLACE WITH:
Code:
|
#
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT username, user_id,
|
Save, upload and try again.
- Poomie |
|
|
|
|
Back to Top |
|
|
| Re: Mutiple rank MOD | |
Posted: 07/25/2007 6:03 AM |
|
|
|
|
Citation |
Posts |
487 |
Word Cnt. |
35,729 |
BDay |
Oct 3 |
Sign |
Libra |
Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 11:51 PM
Location: Klang, Malaysia
|
|
|
|
|
|
Code:
|
Error Detail
Critical Error
FIND FAILED: In file [templates/subSilver/memberlist_body.tpl] could not find:
<td class="catBottom" colspan="8" height="28"> </td>
MOD script line #571 :: FAQ :: Report
|
Thanks poomerio for help ~~ Now this error.. |
|
|
|
|
Back to Top |
|
|
| Re: [Solved]Mutiple rank MOD | |
Posted: 07/25/2007 6:08 AM |
|
|
|
|
Citation |
Posts |
407 |
Word Cnt. |
10,993 |
BDay |
May 28 |
Sign |
Gemini |
Sex |
|
|
|
|
Joined: Feb 25, 2007
Local time: 11:51 PM
Location: SE England
|
|
|
|
|
|
OPEN:
add_multiple_ranks_1_3_5.txt
FIND:
Code:
|
#
#-----[ FIND ]------------------------------------------
#
<td class="catBottom" colspan="8" height="28"> </td>
|
REPLACE WITH:
Code:
|
#
#-----[ FIND ]------------------------------------------
#
<td class="catBottom" colspan="
|
Save, upload and try again.
- Poomie |
|
|
|
|
Back to Top |
|
|
| Re: Mutiple rank MOD | |
Posted: 07/25/2007 6:11 AM |
|
|
|
|
Citation |
Posts |
487 |
Word Cnt. |
35,729 |
BDay |
Oct 3 |
Sign |
Libra |
Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 11:51 PM
Location: Klang, Malaysia
|
|
|
|
|
|
Code:
|
Error Detail
Critical Error
FIND FAILED: In file [admin/admin_ranks.php] could not find:
if($special_rank)
MOD script line #781 :: FAQ :: Report
|
and this now.. |
|
|
|
|
Back to Top |
|
|
| Re: Mutiple rank MOD | |
Posted: 07/25/2007 3:54 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:51 PM
Location: St Pete, FL
|
|
|
|
|
|
This must be an old MOD. The code was changed as phpBB was updated...
Ok, try this:
OPEN
add_multiple_ranks_1_3_5.txt
FIND & DELETE
Code:
|
#
#-----[ FIND ]------------------------------------------
#
if($special_rank)
#
#-----[ REPLACE WITH ]------------------------------------------
#
// Mighty Gorgon - Multiple Ranks - BEGIN
$rank_img_sp = ( $rank_rows[$i]['rank_image'] != "" ) ? ( '../' . $rank_rows[$i]['rank_image'] ) : ( '../images/spacer.gif' );
$rank .= '<br /><img name="rank_image" src="' . $rank_img_sp . '" border="0" alt="" />';
if( !$special_rank == 0 )
// Mighty Gorgon - Multiple Ranks - END
#
#-----[ FIND ]------------------------------------------
#
"SPECIAL_RANK" => ( $special_rank == 1 ) ? $lang['Yes'] : $lang['No'],
#
#-----[ REPLACE WITH ]------------------------------------------
#
// Mighty Gorgon - Multiple Ranks - BEGIN
"SPECIAL_RANK" => ( !$special_rank == 0 ) ? $lang['Yes'] : $lang['No'],
// Mighty Gorgon - Multiple Ranks - END
|
Save, upload, and try again using EM...
|
|
|
|
|
Back to Top |
|
|
| Re: Mutiple rank MOD | |
Posted: 07/25/2007 4:17 PM |
|
|
|
|
Citation |
Posts |
487 |
Word Cnt. |
35,729 |
BDay |
Oct 3 |
Sign |
Libra |
Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 11:51 PM
Location: Klang, Malaysia
|
|
|
|
|
|
Ok, it has success to process to next step ..but i get the SQL msg
Proposed Database Alterations for your mysql Database Allow
Code:
|
SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually
The following error occured:
Error:
Unexpected or unknown attribute "AFTER USER_RANK", in "user_rank2 INT(11) DEFAULT ___0___ AFTER user_rank", statement: 1, table: "phpbb_users"
SQL:
ALTER TABLE phpbb_users ADD user_rank2 INT(11) DEFAULT '0' AFTER user_rank
|
What should i need to do ? |
|
|
|
|
Back to Top |
|
|
| Re: Mutiple rank MOD | |
Posted: 07/25/2007 4:35 PM |
|
|
|
|
Site Admin |
Posts |
30756 |
Word Cnt. |
2,628,678 |
BDay |
Jul 28 |
Sign |
Leo |
Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:51 PM
Location: St Pete, FL
|
|
|
|
|
|
EM doesn't recognize the AFTER SQL command. So since the AFTER part really isn't necessary, you can simply remove it from the SQL query:
Ok, try this:
OPEN
add_multiple_ranks_1_3_5.txt
FIND
Code:
|
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_users ADD user_rank2 INT(11) DEFAULT '0' AFTER user_rank;
ALTER TABLE phpbb_users ADD user_rank3 INT(11) DEFAULT '0' AFTER user_rank2;
|
REPLACE WITH
Code:
|
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_users ADD user_rank2 INT(11) DEFAULT '0';
ALTER TABLE phpbb_users ADD user_rank3 INT(11) DEFAULT '0';
|
Save, upload, and try again using EM...
|
|
|
|
|
Back to Top |
|
|
| Information | |
|