Add Suspended Services to Admin home System Overview

[msaunders]

Just in case anyone wants this handy function back, you can add it to the System Overview table. You can add it as a new row or do what I did and just replace Active Quotes entry as we didn't need this.

 

1) Open system_overview.php from /modules/widgets/

 

2) Enter the following somewhere around line 17 (I put it after the call to $activeservices = $data[0]

 

$result = full_query("SELECT COUNT(*) FROM tblhosting WHERE domainstatus='Suspended'");

$data = mysql_fetch_array($result);

$suspendedservices = $data[0];

 

3) Locate line 91-92

 

<td class="sysoverviewstat"><div class="sysoverviewbox"><a href="quotes.php?validity=Valid">'.$validquotes.'</a></div></td>

<td class="sysoverviewlabel">'.$_ADMINLANG['stats']['validquotes'].'</a></td>

 

Replace With

 

<td class="sysoverviewstat"><div class="sysoverviewbox"><a href="clientshostinglist.php?status=Suspended">'.$suspendedservices.'</a></div></td>

<td class="sysoverviewlabel">'.$_ADMINLANG['stats']['suspendedservices'].'</a></td>

 

4) If you'd rather paste it in as a new row then just add the following after line 99 and before the closing </table> tag

 

<tr>

<td class="sysoverviewstat"><div class="sysoverviewbox"><a href="clientshostinglist.php?status=Suspended">'.$suspendedservices.'</a></div></td>

<td class="sysoverviewlabel">'.$_ADMINLANG['stats']['suspendedservices'].'</a></td>

</tr>

 

That's it , it will show your current suspended services.

[konradwalsh]

thanks for this

 

there is a slight mistake in your code..

 

 

<td class="sysoverviewstat"><div class="sysoverviewbox"><a href="clientshostinglist.php?status=Suspended">'.$ suspendedservices.'</a></div></td>
<td class="sysoverviewlabel">'.$_ADMINLANG['stats']['suspendedservices'].'</a></td>

 

 

'.$ suspendedservices.' 

--- there is a space here between $ and suspendedservices

 

it should read

 

'.$suspendedservices.'

no space

 

 

thanks for your work

[msaunders]

Oh sorry , thanks for spotting and correcting . I cant seem to edit my original post .