How To Get Owners Tool

**wizard** · 30.03.08, 14:00

change perm to 3 i think

**opticalpigion** · 30.03.08, 18:09

where is perm ? how to change it?

**chatabox** · 30.03.08, 18:14

look at the tables in phpmyadmin, you will see the perms in user table (i think)

**opticalpigion** · 31.03.08, 10:19

Code:

ALTER TABLE `ibwf_users` CHANGE `perm` `perm` CHAR( 3 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT &#39;0&#39;

i change this but i cant see owner tools

**rukiya** · 31.03.08, 10:33

Code:

ALTER TABLE `ibwf_users` CHANGE `perm` `perm` CHAR( 3 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT &#39;0&#39;

i change this but i cant see owner tools[/b]

post here the codes of core.php that you are using

**amylee** · 31.03.08, 10:36

geezus just select your name in the ibwf_tables in phpmyadmin click that pen icon edit the perm field and click save

**opticalpigion** · 31.03.08, 10:37

Code:

<?php
include("config.php");
//include("gmprc.php");
//session_start();
if(!get_magic_quotes_gpc())
{
$_GET = array_map(&#39;trim&#39;, $_GET);
$_POST = array_map(&#39;trim&#39;, $_POST);
$_COOKIE = array_map(&#39;trim&#39;, $_COOKIE);

$_GET = array_map(&#39;addslashes&#39;, $_GET);
$_POST = array_map(&#39;addslashes&#39;, $_POST);
$_COOKIE = array_map(&#39;addslashes&#39;, $_COOKIE);
}

function connectdb()
{
    global $dbname, $dbuser, $dbhost, $dbpass;
    $conms = @mysql_connect($dbhost,$dbuser,$dbpass); //connect mysql
    if(!$conms) return false;
    $condb = @mysql_select_db($dbname);
    if(!$condb) return false;
    return true;
}
/////register form
function getnewgml($uid)
{
  /*
    global $onver;
    if($onver)
    {
        $doit = false;
        $gmi = mysql_fetch_array(mysql_query("SELECT gmailun, gmailpw, gmailchk, gmaillch, timezone FROM fun_xinfo WHERE uid=&#39;".$uid."&#39;"));
        $cancheck = $gmi[2]*60;
        $cancheck += $gmi[3];
        if(time()>=$cancheck)
        {
          $doit = true;
        }
        if(trim($gmi[0])!="" && trim($gmi[1])!="")
        {
          $doit = true;
        }
        if ($doit)
        {
          if($cancheck+60>time())
          {
            mysql_query("UPDATE fun_xinfo SET gmaillch=&#39;".time()."&#39; WHERE uid=&#39;".$uid."&#39;");
          }
            return getnewm($gmi[0],$gmi[1],$gmi[4]);

        }
        return 0;
        
    }else{
      return 0;
    }
  */
}
function findcard($tcode)
{
    $st =strpos($tcode,"[card=");
    if ($st === false)
    {
      return $tcode;
    }else
    {
      $ed =strpos($tcode,"[/card]");
      if($ed=== false)
      {
        return $tcode;
      }
    }
    $texth = substr($tcode,0,$st);
    $textf = substr($tcode,$ed+7);
    $msg = substr($tcode,$st+10,$ed-$st-10);
    $cid = substr($tcode,$st+6,3);
    $words = explode(&#39; &#39;,$msg);
    $msg = implode(&#39;+&#39;,$words);
  return "$texth
<img src=\"pmcard.php?cid=$cid&amp;msg=$msg\" alt=\"$cid\"/>
$textf";
}
function saveuinfo($sid)
{

    $headers = apache_request_headers();
    $alli = "";
    foreach ($headers as $header => $value)
    {
        $alli .= "$header: $value 
\n";
    }
    $alli .= "IP: ".$_SERVER[&#39;REMOTE_ADDR&#39;]."
";
    $alli .= "REFERRER: ".$_SERVER[&#39;HTTP_REFERER&#39;]."
";
    $alli .= "REMOTE HOST: ".getenv(&#39;REMOTE_HOST&#39;)."
";
    $alli .= "PROX: ".$_SERVER[&#39;HTTP_X_FORWARDED_FOR&#39;]."
";
    $alli .= "HOST: ".getenv(&#39;HTTP_X_FORWARDED_HOST&#39;)."
";
    $alli .= "SERV: ".getenv(&#39;HTTP_X_FORWARDED_SERVER&#39;)."
";
    if(trim($sid)!="")
    {
        $uid = getuid_sid($sid);
        $fname = "tmp/".getnick_uid($uid).".rwi";
        $out = fopen($fname,"w");
        fwrite($out,$alli);
        fclose($out);
    }

    //return 0;
}
function registerform($ef)
{
  $ue = $errl = $pe = $ce = "";
  switch($ef)
  {
    case 1:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> Please type your UserID";
        $ue = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 2:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> Please type your password";
        $pe = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 3:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> Please type your password again";
        $ce = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 4:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> UserID is invalid";
        $ue = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 5:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> Password is invalid";
        $pe = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 6:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> Passwords doesn&#39;t match";
        $ce = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 7:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> UserID must be 4 characters or more";
        $ue = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 8:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> Password must be 4 characters or more";
        $pe = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 9:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> UserID already in use, choose a different one";
        $ue = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 10:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> Unknown mysql error try registering later";

        break;
    case 11:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> UserID must start with a letter from a-z";
        $ue = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 12:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> UserID is reserved for admins of the site";
        $ue = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
    case 13:
        $errl = "<img src=\"images/point.gif\" alt=\"!\"/> Please choose an appropriate nickname";
        $ue = "<img src=\"images/point.gif\" alt=\"!\"/>";
        break;
  }
  $rform = "[size="1"]$errl[/size]

";
  $rform .= "<form action=\"register.php\" method=\"post\">";
  $rform .= "$ue UserID: <input name=\"uid\" format=\"*x\" maxlength=\"15\"/>
";
  $rform .= "$pe Password: <input type=\"password\" name=\"pwd\" format=\"*x\" maxlength=\"30\"/>
";
  $rform .= "$ce Password: <input type=\"password\" name=\"cpw\" format=\"*x\" maxlength=\"30\"/>
";
  $rform .= "Birthday: <input name=\"bdy\" format=\"*x\" maxlength=\"30\"/>
";
  $rform .= "Sex:";
  $rform .= "<select name=\"usx\" value=\"M\">";
  $rform .= "<option value=\"M\">Male</option>";
  $rform .= "<option value=\"F\">Female</option>";
  $rform .= "</select>
";
  $rform .= "Location: <input name=\"ulc\"  maxlength=\"100\"/>
";
  
  $rform .= "<input type=\"submit\" value=\"Register\"/>";
  $rform .= "</form>";
  return $rform;
}

//////////////////////////////////////////// Search Id
function generate_srid($svar1,$svar2="", $svar3="", $svar4="", $svar5="")
{
  
  $res = mysql_fetch_array(mysql_query("SELECT id FROM fun_search WHERE svar1 like &#39;".$svar1."&#39; AND svar2 like &#39;".$svar2."&#39; AND svar3 like &#39;".$svar3."&#39; AND svar4 like &#39;".$svar4."&#39; AND svar5 like &#39;".$svar5."&#39;"));
  if($res[0]>0)
  {
    return $res[0];
  }
  mysql_query("INSERT INTO fun_search SET svar1=&#39;".$svar1."&#39;, svar2=&#39;".$svar2."&#39;, svar3=&#39;".$svar3."&#39;, svar4=&#39;".$svar4."&#39;, svar5=&#39;".$svar5."&#39;, stime=&#39;".time()."&#39;");
  $res = mysql_fetch_array(mysql_query("SELECT id FROM fun_search WHERE svar1 like &#39;".$svar1."&#39; AND svar2 like &#39;".$svar2."&#39; AND svar3 like &#39;".$svar3."&#39; AND svar4 like &#39;".$svar4."&#39; AND svar5 like &#39;".$svar5."&#39;"));
  return $res[0];
}

function candelvl($uid, $item)
{
  $candoit = mysql_fetch_array(mysql_query("SELECT  uid FROM fun_vault WHERE id=&#39;".$item."&#39;"));
  if($uid==$candoit[0]||ismod($uid))
  {
    return true;
  }
  return false;
}

/////////////////////////////////// GET RATE

function geturate($uid)
{
  $pnts = 0;
  //by blogs, posts per day, chats per day, gb signatures
  if(ismod($uid))
  {
    return 5;
  }
  $noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_blogs WHERE bowner=&#39;".$uid."&#39;"));
  if($noi[0]>=5)
  {
    $pnts = 5;
  }else{
    $pnts = $noi[0];
  }
  $noi = mysql_fetch_array(mysql_query("SELECT regdate, plusses, chmsgs FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  $rwage = ceil((time()- $noi[0])/(24*60*60));
  $ppd = ceil($noi[1]/$rwage);
  if($ppd>=20)
  {
    $pnts+=5;
  }else{
    $pnts += floor($ppd/4);
  }
  $cpd = ceil($noi[2]/$rwage);
  if($cpd>=100)
  {
    $pnts+=5;
  }else{
    $pnts += floor($cpd/20);
  }
  return floor($pnts/3);
  
  
  
}
///////////////////////////////////function isuser

function isuser($uid)
{
  $cus = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  if($cus[0]>0)
  {
    return true;
  }
  return false;
}
////////////////////////////////////////////Can access forum

function canaccess($uid, $fid)
{
  $fex = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_forums WHERE id=&#39;".$fid."&#39;"));
  if($fex[0]==0)
  {
    return false;
  }
  $persc = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_acc WHERE fid=&#39;".$fid."&#39;"));
  if($persc[0]==0)
  {
    $clid = mysql_fetch_array(mysql_query("SELECT clubid FROM fun_forums WHERE id=&#39;".$fid."&#39;"));
    if($clid[0]==0)
    {
      return true;
    }else{
      if(ismod($uid))
      {
        return true;
      }else{
        $ismm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_clubmembers WHERE uid=&#39;".$uid."&#39; AND clid=&#39;".$clid[0]."&#39;"));
        if($ismm[0]>0)
        {
          return true;
        }else{
          return false;
        }
      }
    }
    
  }else{
    $gid = mysql_fetch_array(mysql_query("SELECT gid FROM fun_acc WHERE fid=&#39;".$fid."&#39;"));
    $gid = $gid[0];
    $ginfo = mysql_fetch_array(mysql_query("SELECT autoass, mage, userst, posts, plusses FROM fun_groups WHERE id=&#39;".$gid."&#39;"));
    if($ginfo[0]=="1")
    {
      $uperms = mysql_fetch_array(mysql_query("SELECT birthday, perm, posts, plusses FROM fun_users WHERE id=&#39;".$uid."&#39;"));

      if($ginfo[2]==2)
      {
        
        if(isadmin($uid))
        {
            return true;
        }else{
          return false;
        }
      }
      
      if($ginfo[2]==1)
      {
        
        if(ismod($uid))
        {
            return true;
        }else{
          return false;
        }
      }
      if($uperms[1]>$ginfo[2])
      {
        return true;
      }
      $acc = true;
      if(getage($uperms[0])< $ginfo[1])
      {
        $acc =  false;
      }
      if($uperms[2]<$ginfo[3])
      {
        $acc =  false;
      }
      if($uperms[3]<$ginfo[4])
      {
        $acc =  false;
      }
      
    }
  }
  return $acc;
}

function unhtmlspecialchars2( $string )
{
  $string = str_replace ( &#39;&amp;&#39;, &#39;&&#39;, $string );
  $string = str_replace ( &#39;&#039;&#39;, &#39;\&#39;&#39;, $string );
  $string = str_replace ( &#39;&quot;&#39;, &#39;"&#39;, $string );
  $string = str_replace ( &#39;&lt;&#39;, &#39;<&#39;, $string );
  $string = str_replace ( &#39;&gt;&#39;, &#39;>&#39;, $string );
  $string = str_replace ( &#39;&uuml;&#39;, &#39;?&#39;, $string );
  $string = str_replace ( &#39;&Uuml;&#39;, &#39;?&#39;, $string );
  $string = str_replace ( &#39;&auml;&#39;, &#39;?&#39;, $string );
  $string = str_replace ( &#39;&Auml;&#39;, &#39;?&#39;, $string );
  $string = str_replace ( &#39;&ouml;&#39;, &#39;?&#39;, $string );
  $string = str_replace ( &#39;&Ouml;&#39;, &#39;?&#39;, $string );
  return $string;
}

function getuage_sid($sid)
{
  $uid = getuid_sid($sid);
  $uage = mysql_fetch_array(mysql_query("SELECT birthday FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  return getage($uage[0]);
}

function canenter($rid, $sid)
{
    $rperm = mysql_fetch_array(mysql_query("SELECT mage, perms, chposts, clubid FROM fun_rooms WHERE id=&#39;".$rid."&#39;"));
    $uperm = mysql_fetch_array(mysql_query("SELECT birthday, chmsgs FROM fun_users WHERE id=&#39;".getuid_sid($sid)."&#39;"));
    if($rperm[3]!=0)
    {
      if(ismod(getuid_sid($sid)))
      {
        return true;
      }else{
        $ismm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_clubmembers WHERE uid=&#39;".getuid_sid($sid)."&#39; AND clid=&#39;".$rperm[3]."&#39;"));
        if($ismm[0]>0)
        {
          return true;
        }else{
          return false;
        }
      }
    }
    if($rperm[1]==1)
    {
      return ismod(getuid_sid($sid));
    }
    if($rperm[1]==2)
    {
      return isadmin(getuid_sid($sid));
    }
    
    if(getuage_sid($sid)<$rperm[0])
    {
      return false;
    }
    if($uperm[1]<$rperm[2])
    {
      return false;
    }
    return true;
}
///////////////////clear data


function cleardata()
{
  $timeto = 120;
  $timenw = time();
  $timeout = $timenw - $timeto;
  $exec = mysql_query("DELETE FROM fun_chonline WHERE lton<&#39;".$timeout."&#39;");
  $timeto = 300;
  $timenw = time();
  $timeout = $timenw - $timeto;
  $exec = mysql_query("DELETE FROM fun_chat WHERE timesent<&#39;".$timeout."&#39;");
  $timeto = 60*60;
  $timenw = time();
  $timeout = $timenw - $timeto;
  $exec = mysql_query("DELETE FROM fun_search WHERE stime<&#39;".$timeout."&#39;");
  
  ///delete expired rooms
  $timeto = 5*60;
  $timenw = time();
  $timeout = $timenw - $timeto;
  $rooms = mysql_query("SELECT id FROM fun_rooms WHERE static=&#39;0&#39; AND lastmsg<&#39;".$timeout."&#39;");
  while ($room=mysql_fetch_array($rooms))
  {
    $ppl = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_chonline WHERE rid=&#39;".$room[0]."&#39;"));
    if($ppl[0]==0)
    {
        $exec = mysql_query("DELETE FROM fun_rooms WHERE id=&#39;".$room[0]."&#39;");
    }
  }
  $lbpm = mysql_fetch_array(mysql_query("SELECT value FROM fun_settings WHERE name=&#39;lastbpm&#39;"));
  $td = date("Y-m-d");
  //echo $lbpm[0];
  
  if ($td!=$lbpm[0])
  {
    //echo "boo";
    $sql = "SELECT id, name, birthday  FROM fun_users where month(`birthday`) = month(curdate()) and dayofmonth(`birthday`) = dayofmonth(curdate())";
    $ppl = mysql_query($sql);
    while($mem = mysql_fetch_array($ppl))
    {
        $msg = "[card=008]to you $mem[1]"."[/card] $stitle team wish you a day full of joy and happiness and many happy returns[br/]*fireworks*[br/][small][i]p.s: this is an automated pm[/i][/small]";
        autopm($msg, $mem[0]);
    }
    mysql_query("UPDATE fun_settings SET value=&#39;".$td."&#39; WHERE name=&#39;lastbpm&#39;");
  }
  
}

///////////////////////////////////////get file ext.

function getext($strfnm)
{
  $str = trim($strfnm);
  if (strlen($str)<4){
    return $str;
  }
  for($i=strlen($str);$i>0;$i--)
  {
    $ext .= substr($str,$i,1);
    if(strlen($ext)==3)
    {
      $ext = strrev($ext);
      return $ext;
    }
  }
}

///////////////////////////////////////get extension icon

function getextimg($ext)
{
    $ext = strtolower($ext);
    switch ($ext)
    {
      case "jpg":
      case "gif":
      case "png":
      case "bmp":
        return "<img src=\"images/image.gif\" alt=\"image\"/>";
        break;
      case "zip":
      case "rar":
        return "<img src=\"images/pack.gif\" alt=\"package\"/>";
        break;
      case "amr":
      case "wav":
      case "mp3":
        return "<img src=\"images/music.gif\" alt=\"music\"/>";
        break;
      case "mpg":
      case "3gp":
        return "<img src=\"images/video.gif\" alt=\"video\"/>";
        break;
      default:
        return "<img src=\"images/other.gif\" alt=\"!\"/>";
        break;
    }
}

///////////////////////////////////////Add to chat

function addtochat($uid, $rid)
{
  $timeto = 120;
  $timenw = time();
  $timeout = $timenw - $timeto;
  $exec = mysql_query("DELETE FROM fun_chonline WHERE lton<&#39;".$timeout."&#39;");
  $res = mysql_query("INSERT INTO fun_chonline SET lton=&#39;".time()."&#39;, uid=&#39;".$uid."&#39;, rid=&#39;".$rid."&#39;");
  if(!$res)
  {
    mysql_query("UPDATE fun_chonline SET lton=&#39;".time()."&#39;, rid=&#39;".$rid."&#39; WHERE uid=&#39;".$uid."&#39;");
  }
}
////////////////////////////////////////////is mod

function ismod($uid)
{
  $perm = mysql_fetch_array(mysql_query("SELECT perm FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  
  if($perm[0]>0)
  {
    return true;
  }
}

////////////////////////////////////////////is mod

function candelgb($uid,$mid)
{
  $minfo = mysql_fetch_array(mysql_query("SELECT gbowner, gbsigner FROM fun_gbook WHERE id=&#39;".$mid."&#39;"));
  if($minfo[0]==$uid)
  {
    return true;
  }
  if($minfo[1]==$uid)
  {
    return true;
  }
  return false;
}

////////////////////////////////////////////Spam filter

function isspam($text)
{
  $sfil[0] = "www.";
  $sfil[1] = "http:";
  $text = str_replace(" ", "", $text);
  $text = strtolower($text);
  for($i=0;$i<count($sfil);$i++)
  {

    $nosf = substr_count($text,$sfil[$i]);
    if($nosf>0)
    {
      return true;
    }
  }
  
  return false;
}


///////////////////////////////////get page from go

function getpage_go($go,$tid)
{
  if(trim($go)=="")return 1;
  if($go=="last")return getnumpages($tid);
  $counter=1;
  
  $posts = mysql_query("SELECT id FROM fun_posts WHERE tid=&#39;".$tid."&#39;");
  while($post=mysql_fetch_array($posts))
  {
    $counter++;
    $postid = $post[0];
    if($postid==$go)
    {
        $tore = ceil($counter/5);
        return $tore;
    }
  }
  return 1;
}

////////////////////////////get number of topic pages

function getnumpages($tid)
{
  $nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_posts WHERE tid=&#39;".$tid."&#39;"));
  $nops = $nops[0]+1; //where did the 1 come from? the topic text, duh!
  $nopg = ceil($nops/5); //5 is the posts to show in each page
  return $nopg;
}
////////////////////////////////////////////can delete a blog?

function candelbl($uid,$bid)
{
  $minfo = mysql_fetch_array(mysql_query("SELECT bowner FROM fun_blogs WHERE id=&#39;".$bid."&#39;"));
  if(ismod($uid))
  {
    return true;
  }
  if($minfo[0]==$uid)
  {
    return true;
  }
  
  return false;
}

//////////////////////////////////////////////////RAVEBABE
function PostToHost($host, $path, $data_to_send)
{

                $result = "";
        $fp = fsockopen($host,80,$errno, $errstr, 30);
        if( $fp)
        {
            fputs($fp, "POST $path HTTP/1.0\n");
        fputs($fp, "Host: $host\n");
        fputs($fp, "Content-type: application/x-www-form-urlencoded\n");
        fputs($fp, "Content-length: " . strlen($data_to_send) . "\n");
        fputs($fp, "Connection: close\n\n");
        fputs($fp, $data_to_send);

        while(!feof($fp)) {
                    $result .=  fgets($fp, 128);
        }
        fclose($fp);

        return $result;
        }


}
/////////////////////////Get user plusses

function getplusses($uid)
{
    $plus = mysql_fetch_array(mysql_query("SELECT plusses FROM fun_users WHERE id=&#39;".$uid."&#39;"));
    return $plus[0];
}
/////////////////////////Can uid sign who&#39;s guestbook?

function cansigngb($uid, $who)
{
  if(arebuds($uid, $who))
  {
    return true;
  }
  if($uid==$who)
  {
    return false; //imagine if someone signed his own gbook o.O
  }
  if(getplusses($uid)>=75)
  {
    return true;
  }
  return false;
}
/////////////////////////////////////////////Are buds?

function arebuds($uid, $tid)
{
    $res = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_buddies WHERE ((uid=&#39;".$uid."&#39; AND tid=&#39;".$tid."&#39;) OR (uid=&#39;".$tid."&#39; AND tid=&#39;".$uid."&#39;)) AND agreed=&#39;1&#39;"));
    if($res[0]>0)
    {
      return true;
    }
    return false;
}

//////////////////////////////////function get n. of buds

function getnbuds($uid)
{
  $notb = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_buddies WHERE (uid=&#39;".$uid."&#39; OR tid=&#39;".$uid."&#39;) AND agreed=&#39;1&#39;"));
  return $notb[0];
}

/////////////////////////////get no. of requists

function getnreqs($uid)
{
  $notb = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_buddies WHERE  tid=&#39;".$uid."&#39; AND agreed=&#39;0&#39;"));
  return $notb[0];
}


/////////////////////////////get no. of online buds

function getonbuds($uid)
{
  $counter =0;
    $buds = mysql_query("SELECT uid, tid FROM fun_buddies WHERE (uid=&#39;".$uid."&#39; OR tid=&#39;".$uid."&#39;) AND agreed=&#39;1&#39;");
    while($bud=mysql_fetch_array($buds))
    {
      if($bud[0]==$uid)
      {
        $tid = $bud[1];
      }else{
        $tid = $bud[0];
      }
      if(isonline($tid))
      {
        $counter++;
      }
    }
    return $counter;
}

/////////////////////////////////////////////Function shoutbox

function getshoutbox($sid)
{
  $shbox = "[size="1"]";
  $shbox .= "[b]ShoutBox[/b]
";
  $lshout = mysql_fetch_array(mysql_query("SELECT shout, shouter, id  FROM fun_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 .= "
";
  $shbox .= "<a href=\"lists.php?action=shouts&amp;sid=$sid\">more</a>, ";
  $shbox .= "<a href=\"index.php?action=shout&amp;sid=$sid\">shout</a>";
  if (ismod(getuid_sid($sid)))
  {
    $shbox .= ", <a href=\"modproc.php?action=delsh&amp;sid=$sid&amp;shid=$lshout[2]\">delete</a>";
  }
  //$shbox .= "
";
  $shbox .= "[/size]";
  return $shbox;
}
/////////////////////////////////////////////get tid frm post id

function gettid_pid($pid)
{
  $tid = mysql_fetch_array(mysql_query("SELECT tid FROM fun_posts WHERE id=&#39;".$pid."&#39;"));
  return $tid[0];
}

///////////////////////////////////////////is trashed?

function istrashed($uid)
{
  $del = mysql_query("DELETE FROM fun_penalties WHERE timeto<&#39;".time()."&#39;");
  $not = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_penalties WHERE uid=&#39;".$uid."&#39; AND penalty=&#39;0&#39;"));
  if($not[0]>0)
  {
    return true;
  }else{
    return false;
  }
}

///////////////////////////////////////////is shielded?

function isshield($uid)
{
  $not = mysql_fetch_array(mysql_query("SELECT shield FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  if($not[0]==&#39;1&#39;)
  {
    return true;
  }else{
    return false;
  }
}

///////////////////////////////////////////Get IP

function getip_uid($uid)
{
  $not = mysql_fetch_array(mysql_query("SELECT ipadd FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  return $not[0];
  
}

///////////////////////////////////////////Get Browser

function getbr_uid($uid)
{
  $not = mysql_fetch_array(mysql_query("SELECT browserm FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  return $not[0];

}

///////////////////////////////////////////is trashed?

function isbanned($uid)
{
  $del = mysql_query("DELETE FROM fun_penalties WHERE timeto<&#39;".time()."&#39;");
  $not = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_penalties WHERE uid=&#39;".$uid."&#39; AND (penalty=&#39;1&#39; OR penalty=&#39;2&#39;)"));
 
  if($not[0]>0)
  {
    return true;
  }else{
    return false;
  }
}


/////////////////////////////////////////////get tid frm post id

function gettname($tid)
{
  $tid = mysql_fetch_array(mysql_query("SELECT name FROM fun_topics WHERE id=&#39;".$tid."&#39;"));
  return $tid[0];
}

/////////////////////////////////////////////get tid frm post id

function getfid_tid($tid)
{
  $fid = mysql_fetch_array(mysql_query("SELECT fid FROM fun_topics WHERE id=&#39;".$tid."&#39;"));
  return $fid[0];
}

/////////////////////////////////////////////is ip banned

function isipbanned($ipa, $brm)
{
  
  $pinf = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_penalties WHERE penalty=&#39;2&#39; AND ipadd=&#39;".$ipa."&#39; AND browserm=&#39;".$brm."&#39;"));
  if($pinf[0]>0)
  {
  return true;
}
return false;
}

////////////////get number of pinned topics in forum 

function getpinned($fid)
{
  $nop = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_topics WHERE fid=&#39;".$fid."&#39; AND pinned =&#39;1&#39;"));
  return $nop[0];
}

/////////////////////////////////////////////can bud?

function budres($uid, $tid)
{
  //3 = can&#39;t bud
  //2 = already buds
  //1 = request pended
  //0 = can bud
  if($uid==$tid)
  {
    return 3;
  }
  
  if (arebuds($uid, $tid))
  {
    return 2;
  }
  $req = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_buddies WHERE ((uid=&#39;".$uid."&#39; AND tid=&#39;".$tid."&#39;) OR (uid=&#39;".$tid."&#39; AND tid=&#39;".$uid."&#39;)) AND agreed=&#39;0&#39;"));
  if($req[0]>0)
  {
    return 1;
  }
  $notb = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_buddies WHERE (uid=&#39;".$tid."&#39; OR tid=&#39;".$tid."&#39;) AND agreed=&#39;1&#39;"));
  global $max_buds;
  if($notb[0]>=$max_buds)
  {
    
    return 3;
  }
  $notb = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_buddies WHERE (uid=&#39;".$uid."&#39; OR tid=&#39;".$uid."&#39;) AND agreed=&#39;1&#39;"));
  global $max_buds;
  if($notb[0]>=$max_buds)
  {

    return 3;
  }
  return 0;
}
////////////////////////////////////////////Session expiry time

function getsxtm()
{
   $getdata = mysql_fetch_array(mysql_query("SELECT value FROM fun_settings WHERE name=&#39;sesexp&#39;"));
   return $getdata[0];
}

////////////////////////////////////////////Get bud msg

function getbudmsg($uid)
{
   $getdata = mysql_fetch_array(mysql_query("SELECT budmsg FROM fun_users WHERE id=&#39;".$uid."&#39;"));
   return $getdata[0];
}

////////////////////////////////////////////Get forum name

function getfname($fid)
{
  $fname = mysql_fetch_array(mysql_query("SELECT name FROM fun_forums WHERE id=&#39;".$fid."&#39;"));
  return $fname[0];
}
////////////////////////////////////////////PM antiflood time

function getpmaf()
{
   $getdata = mysql_fetch_array(mysql_query("SELECT value FROM fun_settings WHERE name=&#39;pmaf&#39;"));
   return $getdata[0];
}

////////////////////////////////////////////PM antiflood time

function getfview()
{
   $getdata = mysql_fetch_array(mysql_query("SELECT value FROM fun_settings WHERE name=&#39;fview&#39;"));
   return $getdata[0];
}

////////////////////////////////////////////get forum message

function getfmsg()
{
   $getdata = mysql_fetch_array(mysql_query("SELECT value FROM fun_settings WHERE name=&#39;4ummsg&#39;"));
   return $getdata[0];
}

//////////////////////////////////////////////is online

function isonline($uid)
{
  $uon = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_online WHERE userid=&#39;".$uid."&#39;"));
  if($uon[0]>0)
  {
    return true;
  }else
  {
    return false;
  }
}
///////////////////////////if registration is allowed

function canreg()
{
   $getreg = mysql_fetch_array(mysql_query("SELECT value FROM fun_settings WHERE name=&#39;reg&#39;"));
   if($getreg[0]==&#39;1&#39;)
   {
     return true;
   }else
   {
     return false;
   }
}

///////////////////////////////////////////Get Forum ID

function getfid($topicid)
{
  $fid = mysql_fetch_array(mysql_query("SELECT fid FROM fun_topics WHERE id=&#39;".$topicid."&#39;"));
  return $fid[0];
}
////////////////////////////////////////////Parse PM
////anti spam
function parsepm($text, $sid="")
{
  $text = htmlspecialchars($text);
  $sml = mysql_fetch_array(mysql_query("SELECT hvia FROM fun_users WHERE id=&#39;".getuid_sid($sid)."&#39;"));
  if ($sml[0]=="1")
  {
  $text = getsmilies($text);
  }
  $text = getbbcode($text, $sid);
  $text = findcard($text);
  return $text;
}


////////////////////////////////////////////Parse other msgs

function parsemsg($text,$sid="")
{
  $text = htmlspecialchars($text);
  $sml = mysql_fetch_array(mysql_query("SELECT hvia FROM fun_users WHERE id=&#39;".getuid_sid($sid)."&#39;"));
  if ($sml[0]=="1")
  {
  $text = getsmilies($text);
  }
  $text = getbbcode($text, $sid);
  $text = findcard($text);
  return $text;
}
///////////////////////////////////////////Is site blocked

function isblocked($str,$sender)
{
  if(ismod($sender))
  {
    return false;
  }
  $str = str_replace(" ","",$str);
  $sites[0] = "chillinlounge.co.uk";
  $sites[1] = "psycho.wen.ru";
  $sites[2] = "xcile.com";
  $sites[3] = "wickedwap.net";
  $sites[4] = "mobilelife.tk";
  $sites[5] = ".trap17.com";
  for($i=0;$i<count($sites);$i++)
  {
        $nosf = substr_count($str,$sites[$i]);
    if($nosf>0)
    {
      return true;
    }
  }
  return false;
}

///////////////////////////////////////////Is pm starred

function isstarred($pmid)
{
  $strd = mysql_fetch_array(mysql_query("SELECT starred FROM fun_private WHERE id=&#39;".$pmid."&#39;"));
  if($strd[0]=="1")
  {
    return true;
  }else{
    return false;
  }
}
////////////////////////////////////////////IS LOGGED?

function islogged($sid)
{
  //delete old sessions first

  $deloldses = mysql_query("DELETE FROM fun_ses WHERE expiretm<&#39;".time()."&#39;");
  //does sessions exist?
  $sesx = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_ses WHERE id=&#39;".$sid."&#39;"));

  if($sesx[0]>0)
  {
    if(!isuser(getuid_sid($sid)))
{
  return false;
}
    //yip it&#39;s logged in
    //first extend its session expirement time
    $xtm = time() + (60*getsxtm());
    $extxtm = mysql_query("UPDATE fun_ses SET expiretm=&#39;".$xtm."&#39; WHERE id=&#39;".$sid."&#39;");
    return true;
  }else{
    //nope its session must be expired or something
    return false;
  }
}

////////////////////////Get user nick from session id

function getnick_sid($sid)
{
  $uid = mysql_fetch_array(mysql_query("SELECT uid FROM fun_ses WHERE id=&#39;".$sid."&#39;"));
  $uid = $uid[0];
  return getnick_uid($uid);
}

////////////////////////Get user id from session id

function getuid_sid($sid)
{
  $uid = mysql_fetch_array(mysql_query("SELECT uid FROM fun_ses WHERE id=&#39;".$sid."&#39;"));
  $uid = $uid[0];
  return $uid;
}

/////////////////////Get total number of pms

function getpmcount($uid,$view="all")
{
  if($view=="all"){
    $nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_private WHERE touid=&#39;".$uid."&#39;"));
    }else if($view =="snt")
    {
        $nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_private WHERE byuid=&#39;".$uid."&#39;"));
    }else if($view =="str")
    {
        $nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_private WHERE touid=&#39;".$uid."&#39; AND starred=&#39;1&#39;"));
    }else if($view =="urd")
    {
        $nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_private WHERE touid=&#39;".$uid."&#39; AND unread=&#39;1&#39;"));
    }
    return $nopm[0];
}

function deleteClub($clid)
{
    $fid = mysql_fetch_array(mysql_query("SELECT id FROM fun_forums WHERE clubid=&#39;".$clid."&#39;"));
    $fid = $fid[0];
    $topics = mysql_query("SELECT id FROM fun_topics WHERE fid=".$fid."");
    while($topic = mysql_fetch_array($topics))
    {
      mysql_query("DELETE FROM fun_posts WHERE tid=&#39;".$topic[0]."&#39;");
    }
    mysql_query("DELETE FROM fun_topics WHERE fid=&#39;".$fid."&#39;");
    mysql_query("DELETE FROM fun_forums WHERE id=&#39;".$fid."&#39;");
    mysql_query("DELETE FROM fun_rooms WHERE clubid=&#39;".$clid."&#39;");
    mysql_query("DELETE FROM fun_clubmembers WHERE clid=&#39;".$clid."&#39;");
    mysql_query("DELETE FROM fun_announcements WHERE clid=&#39;".$clid."&#39;");
    mysql_query("DELETE FROM fun_clubs WHERE id=".$clid."");
    return true;
}

function deleteMClubs($uid)
{
  $uclubs = mysql_query("SELECT id FROM fun_clubs WHERE owner=&#39;".$uid."&#39;");
  while($uclub=mysql_fetch_array($uclubs))
  {
    deleteClub($uclub[0]);
  }
}
//////////////////////Function add user to online list :P

function addonline($uid,$place,$plclink)
{
  /////delete inactive users
  $tm = time();
  $timeout = $tm - 420; //time out = 5 minutes
  $deloff = mysql_query("DELETE FROM fun_online WHERE actvtime <&#39;".$timeout."&#39;");
  ///now try to add user to online list
  $res = mysql_query("UPDATE fun_users SET lastact=&#39;".time()."&#39; WHERE id=&#39;".$uid."&#39;");
  $res = mysql_query("INSERT INTO fun_online SET userid=&#39;".$uid."&#39;, actvtime=&#39;".$tm."&#39;, place=&#39;".$place."&#39;, placedet=&#39;".$plclink."&#39;");
  if(!$res)
  {
    //most probably userid already in the online list
    //so just update the place and time
    $res = mysql_query("UPDATE fun_online SET actvtime=&#39;".$tm."&#39;, place=&#39;".$place."&#39;, placedet=&#39;".$plclink."&#39; WHERE userid=&#39;".$uid."&#39;");
    
    
  }
  $maxmem=mysql_fetch_array(mysql_query("SELECT value FROM fun_settings WHERE id=&#39;2&#39;"));
  
            $result = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_online"));

          if($result[0]>=$maxmem[0])
          {
            $tnow = date("D d M Y - H:i");
            mysql_query("UPDATE fun_settings set name=&#39;".$tnow."&#39;, value=&#39;".$result[0]."&#39; WHERE id=&#39;2&#39;");
          }
          $maxtoday = mysql_fetch_array(mysql_query("SELECT ppl FROM fun_mpot WHERE ddt=&#39;".date("d m y")."&#39;"));
          if($maxtoday[0]==0||$maxtoday=="")
          {
            mysql_query("INSERT INTO fun_mpot SET ddt=&#39;".date("d m y")."&#39;, ppl=&#39;1&#39;, dtm=&#39;".date("H:i:s")."&#39;");
            $maxtoday[0]=1;
          }
          if($result[0]>=$maxtoday[0])
          {
            mysql_query("UPDATE fun_mpot SET ppl=&#39;".$result[0]."&#39;, dtm=&#39;".date("H:i:s")."&#39; WHERE ddt=&#39;".date("d m y")."&#39;");
          }
}

/////////////////////Get members online

function getnumonline()
{
    $nouo = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_online "));
    return $nouo[0];
}

//////////////////////////////////////is ignored

function isignored($tid, $uid)
{
  $ign = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_ignore WHERE target=&#39;".$tid."&#39; AND name=&#39;".$uid."&#39;"));
  if($ign[0]>0)
  {
    return true;
  }
  return false;
}

///////////////////////////////////////////GET IP

function getip()
{
    if (getenv(&#39;HTTP_X_FORWARDED_FOR&#39;))
    {
      $ip=getenv(&#39;HTTP_X_FORWARDED_FOR&#39;);
    }
    else
    {
      $ip=getenv(&#39;REMOTE_ADDR&#39;);
    }
    return $ip;
}

//////////////////////////////////////////ignore result

function ignoreres($uid, $tid)
{
  //0 user can&#39;t ignore the target
  //1 yes can ignore
  //2 already ignored
  if($uid==$tid)
  {
    return 0;
  }
  if(ismod($tid))
  {
    //you cant ignore staff members
    return 0;
  }
  if(arebuds($tid, $uid))
  {
    //why the hell would anyone ignore his bud? o.O
    return 0;
  }
  if(isignored($tid, $uid))
  {
    return 2; // the target is already ignored by the user
  }
  return 1;
}

///////////////////////////////////////////Function getage

function getage($strdate)
{
    $dob = explode("-",$strdate);
    if(count($dob)!=3)
    {
      return 0;
    }
    $y = $dob[0];
    $m = $dob[1];
    $d = $dob[2];
    if(strlen($y)!=4)
    {
      return 0;
    }
    if(strlen($m)!=2)
    {
      return 0;
    }
    if(strlen($d)!=2)
    {
      return 0;
    }
  $y += 0;
  $m += 0;
  $d += 0;
  if($y==0) return 0;
  $rage = date("Y") - $y;
  if(date("m")<$m)
  {
    $rage-=1;
    
  }else{
    if((date("m")==$m)&&(date("d")<$d))
    {
      $rage-=1;
    }
  }
  return $rage;
}

/////////////////////////////////////////getavatar

function getavatar($uid)
{
  $av = mysql_fetch_array(mysql_query("SELECT avatar FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  return $av[0];
}

/////////////////////////////////////////Can see details?

function cansee($uid, $tid)
{
  if($uid==$tid)
  {
    return true;
  }
  if(ismod($uid))
  {
    return true;
  }
  return false;
}

//////////////////////////gettimemsg

function gettimemsg($sec)
{
  $ds = floor($sec/60/60/24);
  if($ds > 0)
  {
    return "$ds days";
  }
  $hs = floor($sec/60/60);
  if($hs > 0)
  {
    return "$hs hours";
  }
  $ms = floor($sec/60);
  if($ms > 0)
  {
    return "$ms minutes";
  }
  return "$sec Seconds";
}
/////////////////////////////////////////get status

function getstatus($uid)
{
  $info= mysql_fetch_array(mysql_query("SELECT perm, plusses FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  if(isbanned($uid))
  {
    return "BANNED!";
  }
  if($info[0]==&#39;2&#39;)
  {
    return "Administrator!";
  }else if($info[0]==&#39;1&#39;)
  {
    return "Moderator!";
  }else{
    if($info[1]<10)
    {
      return "Newbie";
    }else if($info[1]<25)
    {
        return "Rookie";
    }else if($info[1]<50)
    {
        return "Funster";
    }else if($info[1]<75)
    {
        return "Bj Meister";
    }else if($info[1]<250)
    {
        return "Fuantic";
    }else if($info[1]<500)
    {
        return "ViTa1";
    }else if($info[1]<750)
    {
        return "Lava unplugged";
    }else if($info[1]<1000)
    {
        return "GuRu";
    }else if($info[1]<1500)
    {
        return "V.I.P";
    }else if($info[1]<2000)
    {
        return "FaNatic";
    }else if($info[1]<2500)
    {
        return "Ultimate";
    }else if($info[1]<3000)
    {
        return "VeteRaN";
    }else if($info[1]<4000)
    {
        return "Superb";
    }else if($info[1]<5000)
    {
        return "BjMaster";
    }else if($info[1]<10000)
    {
        return "ic0N";
    }else 
    {
        return "Bj newbie";
    }
  }
}

/////////////////////Get Page Jumber
function getjumper($action, $sid,$pgurl)
{
$rets = "Jump to page<input name=\"pg\" format=\"*N\" size=\"3\"/>";
        $rets .= "<anchor>[GO]";
        $rets .= "<go href=\"$pgurl.php\" method=\"get\">";
        $rets .= "<postfield name=\"action\" value=\"$action\"/>";
        $rets .= "<postfield name=\"sid\" value=\"$sid\"/>";
        $rets .= "<postfield name=\"page\" value=\"$(pg)\"/>";
        $rets .= "</go></anchor>";
        
        return $rets;
}
/////////////////////Get unread number of pms

function getunreadpm($uid)
{
    $nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_private WHERE touid=&#39;".$uid."&#39; AND unread=&#39;1&#39;"));
    return $nopm[0];
}

//////////////////////GET USER NICK FROM USERID

function getnick_uid($uid)
{
  $unick = mysql_fetch_array(mysql_query("SELECT name FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  return $unick[0];
}

///////////////////////////////////////////////Get the smilies

function getsmilies($text)
{
  $sql = "SELECT * FROM fun_smilies";
  $smilies = mysql_query($sql);
  while($smilie=mysql_fetch_array($smilies))
  {
    $scode = $smilie[1];
    $spath = $smilie[2];
    $text = str_replace($scode,"<img src=\"$spath\" alt=\"$scode\"/>",$text);
  }
  return $text;
}

////////////////////////////////////////////check nicks

function checknick($aim)
{
  $chk =0;
$aim = strtolower($aim);
  $nicks = mysql_query("SELECT id, name, nicklvl FROM fun_nicks");

while($nick=mysql_fetch_array($nicks))
{
    if($aim==$nick[1])
    {
      $chk = $nick[2];
    }else if(substr($aim,0,strlen($nick[1]))==$nick[1])
    {
      $chk = $nick[2];
    }else{
    $found = strpos($aim, $nick[1]);
    if($found!=0)
    {
        $chk = $nick[2];
    }
    }
}
return $chk;
}

function autopm($msg, $who)
{
    mysql_query("INSERT INTO fun_private SET text=&#39;".$msg."&#39;, byuid=&#39;1&#39;, touid=&#39;".$who."&#39;, unread=&#39;1&#39;, timesent=&#39;".time()."&#39;");
    
}

////////////////////////////////////////////////////Register

function register($name,$pass,$usex,$bday,$uloc, $ubr)
{
  $execms = mysql_query("SELECT * FROM fun_users WHERE name=&#39;".$name."&#39;;");
  
  if (mysql_num_rows($execms)>0){
    return 1;
  }else{
    $pass = md5($pass);
    $reg = mysql_query("INSERT INTO fun_users SET name=&#39;".$name."&#39;, pass=&#39;".$pass."&#39;, birthday=&#39;".$bday."&#39;, sex=&#39;".$usex."&#39;, location=&#39;".$uloc."&#39;, regdate=&#39;".time()."&#39;, ipadd=&#39;".getip()."&#39;, browserm=&#39;".$ubr."&#39;");
    
    if ($reg)
    {
      $uid = mysql_fetch_array(mysql_query("SELECT id FROM fun_users WHERE name=&#39;".$name."&#39;"));
      $msg = "Hello /reader =)[card=007]welcome and enjoy[/card] greetings from all $sitename staff, we are happy to have you here, welcome to our big happy family! to get the most of our site please read /llfaqs, then read the pinned threads in $title Info Boards. ENJOY! -play- ";
      $msg = mysql_escape_string($msg);
      autopm($msg, $uid[0]);
      return 0;
    }else{
      return 2;
      
    }
  }
  
}

/////////////////////// GET fun_users user id from nickname

function getuid_nick($nick)
{
  $uid = mysql_fetch_array(mysql_query("SELECT id FROM fun_users WHERE name=&#39;".$nick."&#39;"));
  return $uid[0];
}

/////////////////////////////////////////Is admin?

function isadmin($uid)
{
  $admn = mysql_fetch_array(mysql_query("SELECT perm FROM fun_users WHERE id=&#39;".$uid."&#39;"));
  if($admn[0]==&#39;2&#39;)
  {
    return true;
  }else{
    return false;
  }
}

///////////////////////////////////parse bbcode

function getbbcode($text, $sid="")
{
  $text=preg_replace("/\[b\](.*?)\[\/b\]/i","[b]\\1[/b]", $text);
  $text=preg_replace("/\[i\](.*?)\[\/i\]/i","[i]\\1[/i]", $text);
  $text=preg_replace("/\[u\](.*?)\[\/u\]/i","[u]\\1[/u]", $text);
  $text=preg_replace("/\[big\](.*?)\[\/big\]/i","<big>\\1</big>", $text);
  $text=preg_replace("/\[small\](.*?)\[\/small\]/i","[size="1"]\\1[/size]", $text);
  $text = preg_replace("/\[url\=(.*?)\](.*?)\[\/url\]/is","<a href=\"$1\">$2</a>",$text);
  $text = preg_replace("/\[topic\=(.*?)\](.*?)\[\/topic\]/is","<a href=\"index.php?action=viewtpc&amp;tid=$1&amp;sid=$sid\">$2</a>",$text);
  $text = preg_replace("/\[club\=(.*?)\](.*?)\[\/club\]/is","<a href=\"index.php?action=gocl&amp;clid=$1&amp;sid=$sid\">$2</a>",$text);
  $text = preg_replace("/\[blog\=(.*?)\](.*?)\[\/blog\]/is","<a href=\"index.php?action=viewblog&amp;bid=$1&amp;sid=$sid\">$2</a>",$text);
  //$text = ereg_replace("http://[A-Za-z0-9./=?-_]+","<a href=\"\\\">\</a>", $text);
  if(substr_count($text,"[br/]")<=3){
    $text = str_replace("[br/]","
",$text);
  }
  //$text = str_replace("2wap","2crapforwap",$text);
  //$text = str_replace("2WAP","2crapforwap",$text);
  //$text = str_replace("2wAp","2crapforwap",$text);
  //$text = str_replace("2w4p","2crapforwap",$text);
  //$text = str_replace("2waP","2crapforwap",$text);
  //$text = str_replace("2Wap","2crapforwap",$text);
$text = str_replace("hiphop4u","britneyspears",$text);
  $text = str_replace("HIPHOP4U","britneyspears",$text);
  $text = str_replace("HiPhOp4U","britneyspears",$text);
  $text = str_replace("hIpHoP4u","britneyspears",$text);
  $text = str_replace("Hiphop4U","britneyspears",$text);
  $text = str_replace("Hiphop4u","britneyspears",$text);
$text = str_replace("HipHop4u","britneyspears",$text);
 $text = str_replace("hh4u","britneyspears",$text);
  $text = str_replace("HH4U","britneyspears",$text);
  $text = str_replace("Hh4u","britneyspears",$text);
 $text = str_replace("hH4U","britneyspears",$text);
  $text = str_replace("HH4u","britneyspears",$text);
  $text = str_replace("hh4U","britneyspears",$text);
  return $text;
}


//////////////////////////////////////////////////MISC FUNCTIONS
function spacesin($word)
{
  $pos = strpos($word," ");
  if($pos === false)
  {
    return false;
  }else
  {
    return true;
  }
}

/////////////////////////////////Number of registered members
function regmemcount()
{
  $rmc = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fun_users"));
  return $rmc[0];
}
///////

///////////////////////////function counter

function addvisitor()
{
  $cc = mysql_fetch_array(mysql_query("SELECT value FROM fun_settings WHERE name=&#39;Counter&#39;"));
  $cc = $cc[0]+1;
  $res = mysql_query("UPDATE fun_settings SET value=&#39;".$cc."&#39; WHERE name=&#39;Counter&#39;");
}

function scharin($word)
{
  $chars = "abcdefghijklmnopqrstuvwxyz0123456789-_";
  for($i=0;$i<strlen($word);$i++)
  {
    $ch = substr($word,$i,1);
  $nol = substr_count($chars,$ch);
  if($nol==0)
  {
    return true;
  }
  }
  return false;
}

function isdigitf($word)
{
  $chars = "abcdefghijklmnopqrstuvwxyz";
    $ch = substr($word,0,1);
  $sres = ereg("[0-9]",$ch);
   
    $ch = substr($word,0,1);
  $nol = substr_count($chars,$ch);
  if($nol==0)
  {
    return true;
  }


  return false;

}

**amylee** · 31.03.08, 10:38

no need for the core file i just explained how to do it

**busterkeaton10** · 31.03.08, 10:52

no need for the core file i just explained how to do it[/b]

yeah! just open your phpadmin then change the perm of your user!

**rukiya** · 31.03.08, 11:02

put this into SQL query window

Code:

 UPDATE ibwf_users SET perm=&#39;2&#39; WHERE name=&#39;post your name&#39;

post your name will be you name and you will get Admin CP not owner cp coz this script has no ownercp

**busterkeaton10** · 31.03.08, 11:14

put this into SQL query window

Code:

 UPDATE ibwf_users SET perm=&#39;2&#39; WHERE name=&#39;post your name&#39;

post your name will be you name and you will get Admin CP not owner cp coz this script has no ownercp[/b]

now how about putting a new table in ibwf_user example i want to add a new table plussesX in ibwf_users what would be the correct SQL query?

**rukiya** · 31.03.08, 11:41

now how about putting a new table in ibwf_user example i want to add a new table plussesX in ibwf_users what would be the correct SQL query?[/b]

what? you cant add table within a table

**opticalpigion** · 31.03.08, 11:45

i search in all tables but i cant find any members name !

**opticalpigion** · 31.03.08, 11:46

k let me try !!

How To Get Owners Tool

How To Get Owners Tool

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment