Don Jajo : [SMF TUT] ADDING BOARD DETAILS (TOTAL POST/TOPICS AND DESCRIPTION) IN WAP2

By: Unknown on 06:43

HI ALL,

AS I SAID EARLIER NEW MODIFICATIONS WILL BE AVAILABLE IN SMF AS LONG AS AM USING IT, NOW YOU CAN SEE MY WAP2 HAS BEEN MODIFIED WITH BOARD DETAILS.....AM GONNA SHOW YOU THE LITTLE PHP/MYSQL TRICK I USED, THOUGH TO READ SMF SCRIPT WAS A BIT HARD BUT WE STILL READ IT!

BACKUP BEFORE PROCEEDING!

PROCEDURES:

* IN BXKWAP MOD 1.4.2, OPEN YOUR WIRELESS.TEMPLATE.PHP, WHICH IS public_html/Themes/default/wireless.template.php
* USING YOUR MOZILLA OR ANY EDITOR, FIND THIS CODE USING CTRL+F

 foreach ($category['boards'] as $board)  
         {  
             $count++;  
       echo '  
     <div class="body">', $board['new'] ? '<span class="updated"><img border="0" src="' .$settings['default_images_url']. '/wap/new.png" width="18px" height="9px">&nbsp;' : '<img border="0" src="' .$settings['default_images_url']. '/wap/newg.png" width="9px" height="9px">', $board['children_new'] && !$board['new'] ? '<span class="updated">+&nbsp;&nbsp;' : '', $board['new'] || $board['children_new'] ? '</span>' : '&nbsp;&nbsp;', '<a href="', $scripturl, '?board=', $board['id'], '.0;wap2"', $count < 10 ? ' accesskey="' . $count . '"' : '', '>', $board['name'], '</a></div>';  
         }

* REPLACE USING

 foreach ($category['boards'] as $board)  
         {  
             $count++;  
                echo '  
           <div class="body">', $board['new'] ? '<span class="updated"><img border="0" src="' .$settings['default_images_url']. '/wap/new.png" width="18px" height="9px">&nbsp;' : '<img border="0" src="' .$settings['default_images_url']. '/wap/newg.png" width="9px" height="9px">', $board['children_new'] && !$board['new'] ? '<span class="updated">+&nbsp;&nbsp;' : '', $board['new'] || $board['children_new'] ? '</span>' : '&nbsp;&nbsp;', '<a href="', $scripturl, '?board=', $board['id'], '.0;wap2"', $count < 10 ? ' accesskey="' . $count . '"' : '', '>', $board['name'], '</a></div>';  
 $boardname=$board['id'];  
 //connecting to db  
           $sq = mysql_query("select * from smf_boards where id_board='$boardname'");  
           if(!$sq)  
                {  
                     die(mysql_error());  
                }  
           while($ow=mysql_fetch_array($sq))  
                {  
                     $ntopic=$ow['num_topics'];  
                     $npost=$ow['num_posts'];  
 $desc = $ow['description'];  
 if(!$desc)  
 {  
 $desc="No description";  
 }  
                     echo'<div class="ss">'.$desc.'<br/>Topics: '.$ntopic.' Posts: '.$npost.'</div></div>';  
                }  
         }

* OR YOU CAN STILL USE THE INCLUDE FUNCTION WE USED IN ADDING LINKS TO OUR WAP2 HEADER BY INSERTING THIS IN A FILE AND INCLUDING IT

 $boardname=$board['id'];  
 //connecting to db  
           $sq = mysql_query("select * from smf_boards where id_board='$boardname'");  
           if(!$sq)  
                {  
                     die(mysql_error());  
                }  
           while($ow=mysql_fetch_array($sq))  
                {  
                     $ntopic=$ow['num_topics'];  
                     $npost=$ow['num_posts'];  
 $desc = $ow['description'];  
 if(!$desc)  
 {  
 $desc="No description";  
 }  
                     echo'<div class="ss">'.$desc.'<br/>Topics: '.$ntopic.' Posts: '.$npost.'</div></div>';  
                }