Thread: staff shout

yep i remember this code which me n quik has updated in 2006 with lavalair

put this in your core.php

PHP Code:

function getstaffshout($sid)
{
  $shbox = "<small>";
  $shbox .= "<b>ShoutBox</b><br/>";
  $lshout = mysql_fetch_array(mysql_query("SELECT shout, shouter, id  FROM staff_shouts ORDER BY shtime DESC LIMIT 1"));
  $shnick = getnick_uid($lshout[1]);
  $shbox .= "<i><a href=\"index.php?action=viewuser&amp;sid=$sid&amp;who=$lshout[1]\">".$shnick."</a></i>: ";
  $shbox .= htmlspecialchars($lshout[0]);
  $shbox .= "<br/>";
  $shbox .= "<a href=\"lists.php?action=shouts&amp;sid=$sid\">more</a>, ";
f (ismod(getuid_sid($sid)))
  {
  $shbox .= "<a href=\"index.php?action=shout&amp;sid=$sid\">shout</a>";
    $shbox .= ", <a href=\"modproc.php?action=delstsh&amp;sid=$sid&amp;shid=$lshout[2]\">delete</a>";
  }
  //$shbox .= "<br/>";
  $shbox .= "</small>";
  return $shbox;
} 


put this code where ever you want to get staff shout

PHP Code:

echo "<p align=\"center\">";
    echo getstaffshout($sid);
echo "</p>"; 


run this with your sql

PHP Code:

-- Table structure for table `staff_shouts`
-- 

CREATE TABLE `staff_shouts` (
  `id` int(100) NOT NULL auto_increment,
  `shout` varchar(100) NOT NULL default '',
  `shouter` int(100) NOT NULL default '0',
  `shtime` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36726 ; 


? in what part in core.php, where i put that first one!!! :d

this is for the wapdesire v2.

Code:

$main.="<div class=".align().">\n";
$main.="<b>Staff ShoutBox</b>";

if($page=="" || $page<=0)$page=1;
    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM shouts"));
    $num_items = $noi[0]; //changable
    $items_per_page= 1;
    $num_pages = ceil($num_items/$items_per_page);
    if(($page>$num_pages)&&$page!=1)$page= $num_pages;$limit_start = ($page-1)*$items_per_page;
 
    $sql = "SELECT shout, uid, id FROM staff_shouts ORDER BY shtime DESC LIMIT $limit_start, $items_per_page";
  
    $items = mysql_query($sql);
    echo mysql_error();
    
    if(mysql_num_rows($items)>0)
    while ($item = mysql_fetch_array($items))
    {
               
      $sex=mysql_fetch_array(mysql_query("SELECT sex, image FROM profiles WHERE uid='".$item[1]."'"));
      if($sex[0]=="M"){$color="#0000FF";}
      if($sex[0]=="F"){$color="#FF0066";}
      if($sex[1]!=""){$usersex=getbbcode($sex[1],$sid,1);}
      $shnick=getnick_uid($item[1]);

      $main.="<br/><i><a href=\"./profile.php?who=$item[1]&amp;sid=$sid\" style=\"color:$color;\"><b>".$shnick."</b></a></i> -     ".getbbcode($item[0],$sid,1);
      
       if(delshout(getuid_sid($sid),$item[2])){
       $main.=" <a href=\"./staffshoutbox/delete.php?sid=$sid&amp;delete=$item[2]\">
       <img src=\"./images/error.gif\" alt=\"[x]\"/></a>\n";
       }


    }



$main.="<br/><a href=\"./staffshoutbox/history.php?sid=$sid\">History</a>\n";
if(isowner(getuid_sid($sid))||isheadadmin(getuid_sid($sid))||isadmin(getuid_sid($sid))||ismod(getuid_sid($sid))){
$main.="<br/>Staff ShoutBox Message:<br/>
<form action=\"./staffshoutbox/shout.php?sid=$sid\" method=\"post\">
<input name=\"shtxt\" maxlength=\"100\"/><br/>
<input type=\"submit\" value=\"Add Shout\"/><br/>
</form></div>";}

icen01 put any where in core.php lol that code is for general lavalair

this will work good just remember to add the delete oprion to the shout also

why make it hard..i suggest to just display two shoutbox..for staff and for members..in staff's shoutbox, just fetch shouts where perm > 0..just giving my suggestion..i don't have this on my site..add perm row to shoutbox table..when shouting, perm should also be set..fetch shouters perm from users and then update to shoutbox table..

wen i put it in my core.php theres an error i got blank page in my site

which code u putted mine? show me ur core.php i will help u