bros riderz help us

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    bros riderz help us

    pls help me with a valid sql for that your retrivewap.zip scipts, when ever i view users profiles it says:


    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/waproof/public_html/core.php on line 2315
    Privacy Profile !!!
    This profile can only see members with a list of friends and members of the Administration
    have connected with http://adexchat.com ?
    Fun up with
    http://forum.adexchat.com

    #2
    I am also facing the same problem

    Comment


      #3
      maybe a line from _users is mising? search in core.php at 2315 and u will find what line then create it
      <?php unlink('World/Europe/Romania.country'); ?>

      Comment


        #4
        post the code in the core in that line
        com site: http://vampist.net
        download site: http://wapdloads.net
        fb: http://www.facebook.com/pmplx

        Comment


          #5
          this is the file core.php below:please help us out.

          Code:
          <?php
          include("config.php");
          //include("gmprc.php");
          //session_start();
          if(!get_magic_quotes_gpc())
          {
          $_GET = array_map('trim', $_GET);
          $_POST = array_map('trim', $_POST);
          $_COOKIE = array_map('trim', $_COOKIE);
          
          $_GET = array_map('addslashes', $_GET);
          $_POST = array_map('addslashes', $_POST);
          $_COOKIE = array_map('addslashes', $_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 ibwf_xinfo WHERE uid='".$uid."'"));
                  $cancheck = $gmi[2]*60;
                  $cancheck += $gmi[3];
                  if((time() + $timeadjust) >=$cancheck)
                  {
                    $doit = true;
                  }
                  if(trim($gmi[0])!="" && trim($gmi[1])!="")
                  {
                    $doit = true;
                  }
                  if ($doit)
                  {
                    if($cancheck+60>(time() + $timeadjust) )
                    {
                     $ttime = (time() + $timeadjust);
                      mysql_query("UPDATE ibwf_xinfo SET gmaillch='".$ttime."' WHERE uid='".$uid."'");
                    }
                      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(' ',$msg);
              $msg = implode('+',$words);
            return "$texth<br/><img src=\"pmcard.php?cid=$cid&amp;msg=$msg\" alt=\"$cid\"/><br/>$textf";
          }
          function saveuinfo($sid)
          {
          
              $headers = apache_request_headers();
              $alli = "";
              foreach ($headers as $header => $value)
              {
                  $alli .= "$header: $value <br />\n";
              }
              $alli .= "IP: ".$_SERVER['REMOTE_ADDR']."<br/>";
              $alli .= "REFERRER: ".$_SERVER['HTTP_REFERER']."<br/>";
              $alli .= "REMOTE HOST: ".getenv('REMOTE_HOST')."<br/>";
              $alli .= "PROX: ".$_SERVER['HTTP_X_FORWARDED_FOR']."<br/>";
              $alli .= "HOST: ".getenv('HTTP_X_FORWARDED_HOST')."<br/>";
              $alli .= "SERV: ".getenv('HTTP_X_FORWARDED_SERVER')."<br/>";
              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  Nick";
                  $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=\"!\"/> User Nick 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't match";
                  $ce = "<img src=\"images/point.gif\" alt=\"!\"/>";
                  break;
              case 7:
                  $errl = "<img src=\"images/point.gif\" alt=\"!\"/> Ur Nick 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=\"!\"/> your Nick 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=\"!\"/> User Nick 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=\"!\"/> User Nick 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;
             case 14:
                  $errl = "<img src=\"images/point.gif\" alt=\"!\"/> U must enter an email address";
                  $ue = "<img src=\"images/point.gif\" alt=\"!\"/>";
           }
          $rform = "<small>$errl</small><br/><br/>";
            $rform .= "<form action=\"register.php\" method=\"post\">";
            $rform .= "$ue UserName: <input name=\"uid\" maxlength=\"15\" format=\"*x\" maxlength=\"30\"/><br/>";
            $rform .= "$pe Password: <input type=\"password\" name=\"pwd\" format=\"*x\" maxlength=\"30\"/><br/>";
            $rform .= "$ce Password Again: <input type=\"password\" name=\"cpw\" format=\"*x\" maxlength=\"30\"/><br/>";
            $rform .= "Birthday <small>(YYYY-MM-DD)</small>: <input name=\"bdyy\" format=\"*N\" size=\"4\" maxlength=\"4\"/>-<input name=\"bdym\" format=\"*N\" size=\"2\" maxlength=\"2\"/>-<input name=\"bdyd\" format=\"*N\" size=\"2\" maxlength=\"2\"/><br/>";
            $rform .= "Sex:";
            $rform .= "<select name=\"usx\" value=\"M\">";
            $rform .= "<option value=\"M\">Male</option>";
            $rform .= "<option value=\"F\">Female</option>";
            $rform .= "</select><br/>";
            $rform .= "Location[Country-Area]Ex. SL-Negombo: <input name=\"ulc\"  maxlength=\"100\"/><br/>";
            $rform .= "Email: <input name=\"email\" maxlength=\"50\"/><br/>";
              $rform .= "Site Language:";
           $rform .= "<select name=\"lang\" value=\"1\">";
            $rform .= "<option value=\"1\">English</option>";
            $rform .= "<option value=\"2\">Sinhala</option>";
            $rform .= "<option value=\"3\">Afrikaans</option>";
              $rform .= "<option value=\"4\">Indonesian</option>";
          
              $rform .= "</select><br/>";
          
            $rform .= "<input type=\"submit\" value=\"Register\"/>";
            $rform .= "</form>";
            return $rform;
            return $rform;
          }
          //////////////////////////////////////////// Search Id
          function generate_srid($svar1,$svar2="", $svar3="", $svar4="", $svar5="")
          {
          
            $res = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_search WHERE svar1 like '".$svar1."' AND svar2 like '".$svar2."' AND svar3 like '".$svar3."' AND svar4 like '".$svar4."' AND svar5 like '".$svar5."'"));
            if($res[0]>0)
            {
              return $res[0];
            }
            $ttime = (time() + $timeadjust);
            mysql_query("INSERT INTO ibwf_search SET svar1='".$svar1."', svar2='".$svar2."', svar3='".$svar3."', svar4='".$svar4."', svar5='".$svar5."', stime='".$ttime."'");
            $res = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_search WHERE svar1 like '".$svar1."' AND svar2 like '".$svar2."' AND svar3 like '".$svar3."' AND svar4 like '".$svar4."' AND svar5 like '".$svar5."'"));
            return $res[0];
          }
          
          function candelvl($uid, $item)
          {
            $candoit = mysql_fetch_array(mysql_query("SELECT  uid FROM ibwf_vault WHERE id='".$item."'"));
            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 ibwf_blogs WHERE bowner='".$uid."'"));
            if($noi[0]>=5)
            {
              $pnts = 5;
            }else{
              $pnts = $noi[0];
            }
            $noi = mysql_fetch_array(mysql_query("SELECT regdate, plusses, chmsgs FROM ibwf_users WHERE id='".$uid."'"));
            $rwage = ceil(((time() + $timeadjust)- $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 ibwf_users WHERE id='".$uid."'"));
            if($cus[0]>0)
            {
              return true;
            }
            return false;
          }
          ////////////////////////////////////////////Spam filter
          
          function isenta($text)
          {
            $sfil[0] = "enttt";
          
            $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;
          }
          ////////////////////////////////////////////Can access forum
          
          function canaccess($uid, $fid)
          {
            $fex = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_forums WHERE id='".$fid."'"));
            if($fex[0]==0)
            {
              return false;
            }
            $persc = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_acc WHERE fid='".$fid."'"));
            if($persc[0]==0)
            {
              $clid = mysql_fetch_array(mysql_query("SELECT clubid FROM ibwf_forums WHERE id='".$fid."'"));
              if($clid[0]==0)
              {
                return true;
              }else{
                if(ismod($uid))
                {
                  return true;
                }else{
                  $ismm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_clubmembers WHERE uid='".$uid."' AND clid='".$clid[0]."'"));
                  if($ismm[0]>0)
                  {
                    return true;
                  }else{
                    return false;
                  }
                }
              }
          
            }else{
              $gid = mysql_fetch_array(mysql_query("SELECT gid FROM ibwf_acc WHERE fid='".$fid."'"));
              $gid = $gid[0];
              $ginfo = mysql_fetch_array(mysql_query("SELECT autoass, mage, userst, posts, plusses FROM ibwf_groups WHERE id='".$gid."'"));
              if($ginfo[0]=="1")
              {
                $uperms = mysql_fetch_array(mysql_query("SELECT birthday, perm, posts, plusses FROM ibwf_users WHERE id='".$uid."'"));
          
                if($ginfo[2]==4)
                {
          
                  if(isowner($uid))
                  {
                      return true;
                  }else{
                    return false;
                  }
                }
                if($ginfo[2]==3)
                {
          
                  if(isheadadmin($uid))
                  {
                      return true;
                  }else{
                    return false;
                  }
                }
                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 ( '&amp;', '&', $string );
            $string = str_replace ( ''', '\'', $string );
            $string = str_replace ( '&quot;', '"', $string );
            $string = str_replace ( '&lt;', '<', $string );
            $string = str_replace ( '&gt;', '>', $string );
            $string = str_replace ( '&uuml;', '?', $string );
            $string = str_replace ( '&Uuml;', '?', $string );
            $string = str_replace ( '&auml;', '?', $string );
            $string = str_replace ( '&Auml;', '?', $string );
            $string = str_replace ( '&ouml;', '?', $string );
            $string = str_replace ( '&Ouml;', '?', $string );
            return $string;
          }
          
          function getuage_sid($sid)
          {
            $uid = getuid_sid($sid);
            $uage = mysql_fetch_array(mysql_query("SELECT birthday FROM ibwf_users WHERE id='".$uid."'"));
            return getage($uage[0]);
          }
          
          function canenter($rid, $sid)
          {
              $rperm = mysql_fetch_array(mysql_query("SELECT mage, perms, chposts, clubid FROM ibwf_rooms WHERE id='".$rid."'"));
              $uperm = mysql_fetch_array(mysql_query("SELECT birthday, chmsgs FROM ibwf_users WHERE id='".getuid_sid($sid)."'"));
              if($rperm[3]!=0)
              {
                if(ismod(getuid_sid($sid)))
                {
                  return true;
                }else{
                  $ismm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_clubmembers WHERE uid='".getuid_sid($sid)."' AND clid='".$rperm[3]."'"));
                  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($rperm[1]==3)
              {
                return isheadadmin(getuid_sid($sid));
              }
              if($rperm[1]==4)
              {
                return isowner(getuid_sid($sid));
              }
          
              if(getuage_sid($sid)<$rperm[0])
              {
                return false;
              }
              if($uperm[1]<$rperm[2])
              {
                return false;
              }
              return true;
          }
          ///////////////////clear data
          
          
          function cleardata()
          {
           $deadtime = time() - (18*60*60);
            $meragochi = mysql_query("SELECT uid FROM meragochi WHERE ziv='1' AND nahranjen<'".$deadtime."'");
            $hrana = mysql_query("SELECT nahranjen FROM meragochi WHERE uid='".$mer[0]."' AND nahranjen<'".$deadtime."'");
            $novo = time() + (18*60*60);
            $smrt = $hrana[0] + $novo;
            while ($mer=mysql_fetch_array($meragochi))
            {
              $ppl = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM meragochi WHERE uid='".$mer[0]."'"));
              if($ppl)
              {
          
          		$exec2 = mysql_query("UPDATE meragochi SET ziv='0', smrt='".$smrt."' WHERE uid='".$mer[0]."'");
          
              }
            }
            $timeto = 120;
            $timenw = (time() + $timeadjust);
            $timeout = $timenw - $timeto;
            $exec = mysql_query("DELETE FROM ibwf_chonline WHERE lton<'".$timeout."'");
            $timeto = 300;
            $timenw = (time() + $timeadjust);
            $timeout = $timenw - $timeto;
            $exec = mysql_query("DELETE FROM ibwf_chat WHERE timesent<'".$timeout."'");
            $timeto = 60*60;
            $timenw = (time() + $timeadjust) ;
            $timeout = $timenw - $timeto;
            $exec = mysql_query("DELETE FROM ibwf_search WHERE stime<'".$timeout."'");
          
            ///delete expired rooms
            $timeto = 5*60;
            $timenw = (time() + $timeadjust) ;
            $timeout = $timenw - $timeto;
            $rooms = mysql_query("SELECT id FROM ibwf_rooms WHERE static='0' AND lastmsg<'".$timeout."'");
            while ($room=mysql_fetch_array($rooms))
            {
              $ppl = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_chonline WHERE rid='".$room[0]."'"));
              if($ppl[0]==0)
              {
                  $exec = mysql_query("DELETE FROM ibwf_rooms WHERE id='".$room[0]."'");
              }
            }
            $lbpm = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='lastbpm'"));
            $td = date("Y-m-d");
            //echo $lbpm[0];
          
            if ($td!=$lbpm[0])
            {
          	//echo "boo";
          	$sql = "SELECT id, name, birthday  FROM ibwf_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] Waplive Team wish you a day full of joy and happiness and many happy returns[br/]*fireworks*";
          		autopm($msg, $mem[0]);
          	}
          	mysql_query("UPDATE ibwf_settings SET value='".$td."' WHERE name='lastbpm'");
            }
          
          }
          
          ///////////////////////////////////////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=\"*\"/>";
                  break;
                case "zip":
                case "rar":
                  return "<img src=\"images/pack.gif\" alt=\"*\"/>";
                  break;
                case "jad":
                case "jar":
                  return "<img src=\"images/game.gif\" alt=\"*\"/>";
                  break;
                case "amr":
                case "wav":
                case "mp3":
                  return "<img src=\"images/music.gif\" alt=\"*\"/>";
                  break;
                case "mpg":
                case "3gp":
                  return "<img src=\"images/video.gif\" alt=\"*\"/>";
                  break;
                default:
                  return "<img src=\"images/other.gif\" alt=\"*\"/>";
                  break;
              }
          }
          
          
          //////////////////////////////////////RESIZE IMAGE
          function imageResize($width, $height, $target) {
          
          //takes the larger size of the width and height and applies the
          //formula accordingly...this is so this script will work
          //dynamically with any size image
          
          
          $percentage = ($target / $width);
          
          
          //gets the new value and applies the percentage, then rounds the value
          $width = round($width * $percentage);
          $height = round($height * $percentage);
          
          //returns the new sizes in html image tag format...this is so you
          //can plug this function inside an image tag and just get the
          
          return "width=\"$width\" height=\"$height\"";
          
          }
          
          ///////////////////////////////////////Add to chat
          
          function addtochat($uid, $rid)
          {
            $timeto = 220;
            $timenw = (time() + $timeadjust);
            $timeout = $timenw - $timeto;
            $exec = mysql_query("DELETE FROM ibwf_chonline WHERE lton<'".$timeout."'");
            $ttime = (time() + $timeadjust);
            $res = mysql_query("INSERT INTO ibwf_chonline SET lton='".$ttime."', uid='".$uid."', rid='".$rid."'");
            if(!$res)
            {
              $ttime = (time() + $timeadjust);
              mysql_query("UPDATE ibwf_chonline SET lton='".$ttime."', rid='".$rid."' WHERE uid='".$uid."'");
            }
          }
          ////////////////////////////////////////////is mod
          
          function ismod($uid)
          {
            $perm = mysql_fetch_array(mysql_query("SELECT perm FROM ibwf_users WHERE id='".$uid."'"));
          
            if($perm[0]>0)
            {
              return true;
            }
          }
          
          ///////////////////////////if registration is allowed
          
          function cancre()
          {
             $getreg = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='cc'"));
             if($getreg[0]=='1')
             {
               return true;
             }else
             {
               return false;
             }
          }
          ////////////////////////////////////////////is mod
          
          function ismod2($uid)
          {
            $perm = mysql_fetch_array(mysql_query("SELECT perm FROM ibwf_users WHERE id='".$uid."'"));
          
            if($perm[0]==1)
            {
              return true;
            }
          }
          
          ////////////////////////////////////////////is mod
          
          function candelgb($uid,$mid)
          {
            $minfo = mysql_fetch_array(mysql_query("SELECT gbowner, gbsigner FROM ibwf_gbook WHERE id='".$mid."'"));
            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:";
           $sfil[2] = ".php";
           $sfil[3] = "i am a hacker";
            $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;
          }
          
          
          
          
          
          //////////////////////////////////////////verbals(add more yours)
          function uverbs($no)
          {
          		if($no==0)
          			$utext = "Slapped<br/> and fell down...";
          		else if($no==1)
          			$utext = "Punched with kili Kili Shot...";
          		else if($no==2)
          			$utext = "swing and Kicked....";
          		else if($no==3)
          			$utext = "Jumped and swing the weapon....";
          		else if($no==4)
          			$utext = "Feel Something Wrong. <br/> howled and jumped....";
          		else
          			$utext = "Punched hard. <br/> howled....";
          	return $utext;
          }
          
          
          function check_rpg($sid)
          {
          	$uid = getuid_sid($sid);
          	$set="0";
          	$checks = mysql_fetch_array(mysql_query("SELECT code FROM ibwf_rpg WHERE uid='".$uid."'"));
          	$check = $checks[0];
          	if($check!="")
          	$set = "1";
          	if($set!="1")
          	{
          		$checks = mysql_fetch_array(mysql_query("SELECT code FROM ibwf_rpg WHERE who='".$uid."'"));
          		$check = $checks[0];
          	}
          	if($check!="0")
          	{
          		if($set=="1")
          			$counts = mysql_query("SELECT who FROM ibwf_rpg WHERE code='".$check."'");
          		else
          			$counts = mysql_query("SELECT uid FROM ibwf_rpg WHERE code='".$check."'");
          	}
          	if(mysql_num_rows($counts)!= "0")
          	{
          		$count = mysql_fetch_array($counts);
          		echo "<br/>";
          		echo getshoutbox($sid);
          		echo "<br/><br/>";
          		$bet = mysql_fetch_array(mysql_query("SELECT bet FROM ibwf_rpg WHERE code='".$check."'"));
          		$bets = $bet[0];
          		echo "Battle between ".getnick_uid($uid)." and ".getnick_uid($count[0])." with $bets Credits";
          
          		echo "<br/><a href=\"wz.php?action=erpg&amp;sid=$sid&amp;who=$count[0]&amp;set=$uid&amp;code=$check\">I Accept the Challenge!</a><br/>";
          		echo "<a href=\"wz.php?action=reject&amp;sid=$sid&amp;who=$count[0]&amp;set=$uid&amp;code=$check\">I Reject the Challenge</a><br/>";
          	}
          }
          
          ///////////////////////////////////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 ibwf_posts WHERE tid='".$tid."'");
            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 ibwf_posts WHERE tid='".$tid."'"));
            $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 ibwf_blogs WHERE id='".$bid."'"));
            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 ibwf_users WHERE id='".$uid."'"));
              return $plus[0];
          }
          /////////////////////////Can uid sign who'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;
          }
          
          /////////////////////////Can uid rate who's photo?
          
          function canratephoto($uid, $who)
          {
            if($uid==$who)
            {
              return false; //imagine if someone signed his own gbook o.O
            }else
            return true;
          }
          /////////////////////////////////////////////Are buds?
          
          function arebuds($uid, $tid)
          {
              $res = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_buddies WHERE ((uid='".$uid."' AND tid='".$tid."') OR (uid='".$tid."' AND tid='".$uid."')) AND agreed='1'"));
              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 ibwf_buddies WHERE (uid='".$uid."' OR tid='".$uid."') AND agreed='1'"));
            return $notb[0];
          }
          
          /////////////////////////////get no. of requists
          
          function getnreqs($uid)
          {
            $notb = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_buddies WHERE  tid='".$uid."' AND agreed='0'"));
            return $notb[0];
          }
          
          
          /////////////////////////////get no. of online buds
          
          function getonbuds($uid)
          {
            $counter =0;
              $buds = mysql_query("SELECT uid, tid FROM ibwf_buddies WHERE (uid='".$uid."' OR tid='".$uid."') AND agreed='1'");
              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)
          {
            $lshout = mysql_fetch_array(mysql_query("SELECT shout, shouter, id  FROM ibwf_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 .= parsepm($lshout[0], $sid);
            $shbox .= "<br/>";
            $shbox .= "<a href=\"lists.php?action=shouts&amp;sid=$sid\">history</a> ";
            $shbox .= "<a href=\"index.php?action=shout&amp;sid=$sid\">shout</a>";
            if (ismod(getuid_sid($sid)))
            {
              $shbox .= " <a href=\"mprocpl.php?action=delsh&amp;sid=$sid&amp;shid=$lshout[2]\">delete</a>";
            }
            //$shbox .= "<br/>";
            return $shbox;
          }
          /////////////////////////////////////////////get tid frm post id
          
          function gettid_pid($pid)
          {
            $tid = mysql_fetch_array(mysql_query("SELECT tid FROM ibwf_posts WHERE id='".$pid."'"));
            return $tid[0];
          }
          
          ///////////////////////////////////////////is trashed?
          
          function istrashed($uid)
          {
           $ttime = (time() + $timeadjust);
            $del = mysql_query("DELETE FROM ibwf_metpenaltiespl WHERE timeto<'".$ttime."'");
            $not = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_metpenaltiespl WHERE uid='".$uid."' AND penalty='0'"));
            if($not[0]>0)
            {
              return true;
            }else{
              return false;
            }
          }
          
          ///////////////////////////////////////////is shielded?
          
          function isshield($uid)
          {
            $not = mysql_fetch_array(mysql_query("SELECT shield FROM ibwf_users WHERE id='".$uid."'"));
            if($not[0]=='1')
            {
              return true;
            }else{
              return false;
            }
          }
          
          ///////////////////////////////////////////Get IP
          
          function getip_uid($uid)
          {
            $not = mysql_fetch_array(mysql_query("SELECT ipadd FROM ibwf_users WHERE id='".$uid."'"));
            return $not[0];
          
          }
          
          ///////////////////////////////////////////Get Browser
          
          function getbr_uid($uid)
          {
            $not = mysql_fetch_array(mysql_query("SELECT browserm FROM ibwf_users WHERE id='".$uid."'"));
            return $not[0];
          
          }
          
          ///////////////////////////////////////////is trashed?
          
          function isbanned($uid)
          {
          $ttime = (time() + $timeadjust);
            $del = mysql_query("DELETE FROM ibwf_metpenaltiespl WHERE timeto<'".$ttime."'");
            $not = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_metpenaltiespl WHERE uid='".$uid."' AND (penalty='1' OR penalty='2')"));
          
            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 ibwf_topics WHERE id='".$tid."'"));
            return $tid[0];
          }
          
          /////////////////////////////////////////////get tid frm post id
          
          function getfid_tid($tid)
          {
            $fid = mysql_fetch_array(mysql_query("SELECT fid FROM ibwf_topics WHERE id='".$tid."'"));
            return $fid[0];
          }
          
          /////////////////////////////////////////////is ip banned
          
          function isipbanned($ipa, $brm)
          {
          
            $pinf = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_metpenaltiespl WHERE penalty='2' AND ipadd='".$ipa."' AND browserm='".$brm."'"));
            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 ibwf_topics WHERE fid='".$fid."' AND pinned ='1'"));
            return $nop[0];
          }
          
          /////////////////////////////////////////////can bud?
          
          function budres($uid, $tid)
          {
            //3 = can'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 ibwf_buddies WHERE ((uid='".$uid."' AND tid='".$tid."') OR (uid='".$tid."' AND tid='".$uid."')) AND agreed='0'"));
            if($req[0]>0)
            {
              return 1;
            }
            $notb = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_buddies WHERE (uid='".$tid."' OR tid='".$tid."') AND agreed='1'"));
            global $max_buds;
            if($notb[0]>=$max_buds)
            {
          
              return 3;
            }
            $notb = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_buddies WHERE (uid='".$uid."' OR tid='".$uid."') AND agreed='1'"));
            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 ibwf_settings WHERE name='sesexp'"));
             return $getdata[0];
          }
          
          ////////////////////////////////////////////Get bud msg
          
          function getbudmsg($uid)
          {
             $getdata = mysql_fetch_array(mysql_query("SELECT budmsg FROM ibwf_users WHERE id='".$uid."'"));
             return $getdata[0];
          }
          
          ////////////////////////////////////////////Get forum name
          
          function getfname($fid)
          {
            $fname = mysql_fetch_array(mysql_query("SELECT name FROM ibwf_forums WHERE id='".$fid."'"));
            return $fname[0];
          }
          ////////////////////////////////////////////PM antiflood time
          
          function getpmaf()
          {
             $getdata = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='pmaf'"));
             return $getdata[0];
          }
          
          ////////////////////////////////////////////PM antiflood time
          
          function getfview()
          {
             $getdata = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='fview'"));
             return $getdata[0];
          }
          
          ////////////////////////////////////////////get forum message
          
          function getfmsg()
          {
             $getdata = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='4ummsg'"));
             return $getdata[0];
          }
          
          //////////////////////////////////////////////is online
          
          function isonline($uid)
          {
            $uon = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_online WHERE userid='".$uid."'"));
            if($uon[0]>0)
            {
              return true;
            }else
            {
              return false;
            }
          }
          ///////////////////////////if registration is allowed
          
          function canreg()
          {
             $getreg = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='reg'"));
             if($getreg[0]=='1')
             {
               return true;
             }else
             {
               return false;
             }
          }
          
          ///////////////////////////////////////////Get Forum ID
          
          function getfid($topicid)
          {
            $fid = mysql_fetch_array(mysql_query("SELECT fid FROM ibwf_topics WHERE id='".$topicid."'"));
            return $fid[0];
          }
          ////////////////////////////////////////////Parse PM
          ////anti spam
          function parsepm($text, $sid="")
          {
            $text = htmlspecialchars($text);
            $sml = mysql_fetch_array(mysql_query("SELECT hvia FROM ibwf_users WHERE id='".getuid_sid($sid)."'"));
            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 ibwf_users WHERE id='".getuid_sid($sid)."'"));
            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] = "Srimobile.com";
            $sites[1] = ".srimobile.com";
            $sites[2] = "sihalawap";
            $sites[3] = "Pamod.net";
            $sites[4] = "pamod.net";
            $sites[5] = "space.srimobile.com";
            $sites[6] = "srimObile.com";
            $sites[7] = "pamOd.net";
            $sites[8] = "sihalaWap";
            $sites[8] = "Sihalawap";
          
            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 ibwf_private WHERE id='".$pmid."'"));
            if($strd[0]=="1")
            {
              return true;
            }else{
              return false;
            }
          }
          ////////////////////////////////////////////IS LOGGED?
          
          function islogged($sid)
          {
            //delete old sessions first
          
          
            $deloldses = mysql_query("DELETE FROM ibwf_ses WHERE expiretm<'".time()."'");
            //does sessions exist?
            $sesx = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_ses WHERE id='".$sid."'"));
          
            if($sesx[0]>0)
            {
              if(!isuser(getuid_sid($sid)))
          {
            return false;
          }
              //yip it's logged in
              //first extend its session expirement time
              $xtm = ((time() + $timeadjust) + (60*getsxtm())) ;
              $extxtm = mysql_query("UPDATE ibwf_ses SET expiretm='".$xtm."' WHERE id='".$sid."'");
              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 ibwf_ses WHERE id='".$sid."'"));
            $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 ibwf_ses WHERE id='".$sid."'"));
            $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 ibwf_private WHERE touid='".$uid."'"));
              }else if($view =="snt")
              {
                  $nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE byuid='".$uid."'"));
              }else if($view =="str")
              {
                  $nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE touid='".$uid."' AND starred='1'"));
              }else if($view =="urd")
              {
                  $nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE touid='".$uid."' AND unread='1'"));
              }
              return $nopm[0];
          }
          
          function deleteClub($clid)
          {
              $fid = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_forums WHERE clubid='".$clid."'"));
              $fid = $fid[0];
              $topics = mysql_query("SELECT id FROM ibwf_topics WHERE fid=".$fid."");
              while($topic = mysql_fetch_array($topics))
              {
                mysql_query("DELETE FROM ibwf_posts WHERE tid='".$topic[0]."'");
              }
              mysql_query("DELETE FROM ibwf_topics WHERE fid='".$fid."'");
              mysql_query("DELETE FROM ibwf_forums WHERE id='".$fid."'");
              mysql_query("DELETE FROM ibwf_rooms WHERE clubid='".$clid."'");
              mysql_query("DELETE FROM ibwf_clubmembers WHERE clid='".$clid."'");
              mysql_query("DELETE FROM ibwf_announcements WHERE clid='".$clid."'");
              mysql_query("DELETE FROM ibwf_clubs WHERE id=".$clid."");
              return true;
          }
          
          function deleteMClubs($uid)
          {
            $uclubs = mysql_query("SELECT id FROM ibwf_clubs WHERE owner='".$uid."'");
            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() + $timeadjust) ;
            $timeout = $tm - 420; //time out = 5 minutes
            $deloff = mysql_query("DELETE FROM ibwf_online WHERE actvtime <'".$timeout."'");
          
            ///now try to add user to online list and add total time online
          
          
            $lastactive = mysql_fetch_array(mysql_query("SELECT lastact FROM ibwf_users WHERE id='".$uid."'"));
            $tolsla = (time() + $timeadjust) - $lastactive[0];
            $totaltimeonline = mysql_fetch_array(mysql_query("SELECT tottimeonl FROM ibwf_users WHERE id='".$uid."'"));
            $totaltimeonline = $totaltimeonline[0] + $tolsla;
            $res = mysql_query("UPDATE ibwf_users SET tottimeonl='".$totaltimeonline."' WHERE id='".$uid."'");
          
             $ttime = (time() + $timeadjust);
            $res = mysql_query("UPDATE ibwf_users SET lastact='".$ttime."' WHERE id='".$uid."'");
           $res = mysql_query("UPDATE ibwf_users SET
          lastact='".time()."' WHERE id='".$uid."'");
           $res = mysql_query("UPDATE ibwf_users SET
          lastseen='".$place."' WHERE id='".$uid."'");
           $res = mysql_query("UPDATE ibwf_users SET
          lastdet='".$plclink."' WHERE id='".$uid."'");
          
          $res = mysql_query("INSERT INTO ibwf_online SET userid='".$uid."', actvtime='".$ttime."', place='".$place."', placedet='".$plclink."'");
            if(!$res)
            {
              //most probably userid already in the online list
              //so just update the place and time
              $res = mysql_query("UPDATE ibwf_online SET actvtime='".$ttime."', place='".$place."', placedet='".$plclink."' WHERE userid='".$uid."'");
          
          
            }
            $maxmem=mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE id='2'"));
          
                      $result = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_online"));
          
                    if($result[0]>=$maxmem[0])
                    {
                      $tnow = date("D d M Y - H:i", (time() + $timeadjust));
                      mysql_query("UPDATE ibwf_settings set name='".$tnow."', value='".$result[0]."' WHERE id='2'");
                    }
                    $maxtoday = mysql_fetch_array(mysql_query("SELECT ppl FROM ibwf_mpot WHERE ddt='".date("d m y")."'"));
                    if($maxtoday[0]==0||$maxtoday=="")
                    {
                      mysql_query("INSERT INTO ibwf_mpot SET ddt='".date("d m y")."', ppl='1', dtm='".date("H:i:s")."'");
                      $maxtoday[0]=1;
                    }
                    if($result[0]>=$maxtoday[0])
                    {
                      mysql_query("UPDATE ibwf_mpot SET ppl='".$result[0]."', dtm='".date("H:i:s")."' WHERE ddt='".date("d m y")."'");
                    }
          }
               */
               /////////////////////Function add user to online list :P
          
          function addonline($uid,$place,$plclink)
          {
            $tm = time();
            $timeout = $tm - 320; //time out = 5 minutes
            $deloff = mysql_query("DELETE FROM ibwf_online WHERE actvtime <'".$timeout."'");
            ///now try to add user to online list
           $lastactive2 = mysql_fetch_array(mysql_query("SELECT resetime FROM ibwf_users WHERE id='".$uid."'"));
          $tolsla2 = time() - $lastactive2[0];
          $totaltimeonline2 = mysql_fetch_array(mysql_query("SELECT onlinetime FROM ibwf_users WHERE id='".$uid."'"));
          $totaltimeonline2 = $totaltimeonline2[0] + $tolsla2;
          $onlinetime = mysql_fetch_array(mysql_query("SELECT onlinetime FROM ibwf_users WHERE id='".$uid."'"));
          $num = $onlinetime[0]/86400;
          $days = intval($num);
          $num2 = ($num - $days)*24;
          $hours = intval($num2);
          $num3 = ($num2 - $hours)*60;
          $mins = intval($num3);
          $num4 = ($num3 - $mins)*60;
          $secs = intval($num4);
          if(!onlinetime($uid))
              {
          if($hours==1)
              {
          $kano ="100";
          $msg = "".getnick_uid(getuid_sid($sid))."Congratulation! You are lucky, coz even if you did not reach 1 hours. Youve got 100plusses n 100bp."."[br/][small]Note: This is an automated PM[/small]";
                                  autopm($msg, $uid);
          $res = mysql_query("UPDATE ibwf_users SET plusses=plusses+'$kano' WHERE id='".$uid."'");
          $res = mysql_query("UPDATE ibwf_users SET onlinedone='1' WHERE id='".$uid."'");
          $res = mysql_query("UPDATE ibwf_users SET battlep=battlep+'$kano' WHERE id='".$uid."'");
          }
          }
          
          
           $ttime = time();
          $res = mysql_query("UPDATE ibwf_users SET resetime='".$ttime."' WHERE id='".$uid."'");
           $res = mysql_query("UPDATE ibwf_users SET lastact='".time()."' WHERE id='".$uid."'");
            $res = mysql_query("INSERT INTO ibwf_online SET userid='".$uid."', actvtime='".$tm."', place='".$place."', placedet='".$plclink."'");
            if(!$res)
            {
              //most probably userid already in the online list
              //so just update the place and time
              $res = mysql_query("UPDATE ibwf_online SET actvtime='".$tm."', place='".$place."', placedet='".$plclink."' WHERE userid='".$uid."'");
          
          
            }
            $maxmem=mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE id='2'"));
          
                      $result = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_online"));
          
                    if($result[0]>=$maxmem[0])
                    {
                      $tnow = date("D d M Y - H:i");
                      mysql_query("UPDATE ibwf_settings set name='".$tnow."', value='".$result[0]."' WHERE id='2'");
                    }
                    $maxtoday = mysql_fetch_array(mysql_query("SELECT ppl FROM ibwf_mpot WHERE ddt='".date("d m y")."'"));
                    if($maxtoday[0]==0||$maxtoday=="")
                    {
                      mysql_query("INSERT INTO ibwf_mpot SET ddt='".date("d m y")."', ppl='1', dtm='".date("H:i:s")."'");
                      $maxtoday[0]=1;
                    }
                    if($result[0]>=$maxtoday[0])
                    {
                      mysql_query("UPDATE ibwf_mpot SET ppl='".$result[0]."', dtm='".date("H:i:s")."' WHERE ddt='".date("d m y")."'");
                    }
          }
          /////////////////////Get members online
          
          function getnumonline()
          {
              $nouo = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_online "));
              return $nouo[0];
          }
          
          //////////////////////////////////////is ignored
          
          function isignored($tid, $uid)
          {
            $ign = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_ignore WHERE target='".$tid."' AND name='".$uid."'"));
            if($ign[0]>0)
            {
              return true;
            }
            return false;
          }
          
          ///////////////////////////////////////////GET IP
          
          function getip()
          {
              if (getenv('HTTP_X_FORWARDED_FOR'))
              {
                $ip=getenv('HTTP_X_FORWARDED_FOR');
              }
              else
              {
                $ip=getenv('REMOTE_ADDR');
              }
              return $ip;
          }
          
          //////////////////////////////////////////ignore result
          
          function ignoreres($uid, $tid)
          {
            //0 user can'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 ibwf_users WHERE id='".$uid."'"));
            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 ibwf_users WHERE id='".$uid."'"));
            $shopssid = mysql_fetch_array(mysql_query("SELECT shopssid FROM ibwf_users WHERE id='".$uid."'"));
            if(isbanned($uid))
            {
              return "Banned!";
            }
          
            if($shopssid[0]=='4')
            {
              return "Ferrari Enzo!";
            }else
            if($shopssid[0]=='5')
            {
              return "Porsche Carrera!";
            }else
            if($shopssid[0]=='6')
            {
              return "Bugatti!";
            }else
            if($shopssid[0]=='7')
            {
              return "McLaren F1!";
            }else
            if($shopssid[0]=='8')
            {
              return "Jaguar XJ220!";
            }else
            if($shopssid[0]=='9')
            {
              return "Lamborghini Murcielago!";
            }else
            if($shopssid[0]=='10')
            {
              return "McLaren Mercedes SLR!";
            }else
          
          
          if($info[0]=='4')
            {
              return "Site Owner!";
          	}else if($info[0]=='3')
            {
              return "Head Admin!";
          
            }else if($info[0]=='2')
            {
              return "Administrator!";
            }else if($info[0]=='1')
            {
              return "Moderator!";
            }else{
              if($info[1]<10)
              {
                return "N00b";
              }else if($info[1]<25)
              {
                  return "SpaRkl3";
              }else if($info[1]<50)
              {
                  return "flaR3";
              }else if($info[1]<75)
              {
                  return "flaM3";
              }else if($info[1]<250)
              {
                  return "Adex3g backup";
              }else if($info[1]<350)
              {
                  return "buRst";
              }else if($info[1]<500)
              {
                  return "ViTa1";
              }else if($info[1]<750)
              {
                  return "Waproof 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 "Waproof KNight";
              }else if($info[1]<3000)
              {
                  return "VeteRaN";
              }else if($info[1]<4000)
              {
                  return "Waproof eXpelleR";
              }else if($info[1]<5000)
              {
                  return "MasteR";
              }else if($info[1]<10000)
              {
                  return "ic0N";
              }else
              {
                  return "Waproof Unstopable";
              }
            }
          }
          
          /////////////////////Get Page Jumber
          function getjumper($action, $sid,$pgurl)
          {
            $rets = "<form action=\"index.php\" method=\"get\">";
                $rets .= "Jump to page<input name=\"page\" format=\"*N\" size=\"3\"/>";
                  $rets .= "<input type=\"submit\" value=\"GO\"/>";
                  $rets .= "<input type=\"hidden\" name=\"action\" value=\"$action\"/>";
                  $rets .= "<input type=\"hidden\" name=\"sid\" value=\"$sid\"/>";
                  $rets .= "</form>";
          
                  echo $rets;
          }
          /////////////////////Get unread number of pms
          
          function getunreadpm($uid)
          {
              $nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE touid='".$uid."' AND unread='1'"));
              return $nopm[0];
          }
          
          //////////////////////GET USER NICK FROM USERID
          
          function getnick_uid($uid)
          {
            $unick = mysql_fetch_array(mysql_query("SELECT name FROM ibwf_users WHERE id='".$uid."'"));
          return "$unick[0]";
          }
          
          
          
          ///////////////////////////////////////////////Get the smilies
          
          function getsmilies($text)
          {
            $sql = "SELECT * FROM ibwf_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 ibwf_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)
          {
              $ttime = (time() + $timeadjust);
              mysql_query("INSERT INTO ibwf_private SET text='".$msg."', byuid='1', touid='".$who."', unread='1', timesent='".$ttime."'");
          
          }
          
          ////////////////////////////////////////////////////Register
          
          function register($name,$pass,$usex,$bday,$uloc,$lang,$email, $ubr)
          {
            $execms = mysql_query("SELECT * FROM ibwf_users WHERE name='".$name."';");
          
            if (mysql_num_rows($execms)>0){
              return 1;
            }else{
              $pass = md5($pass);
          	$validation = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='vldtn'"));
          if($validation[0]==1)
          {
          $validated=0;
          }else{
          $validated=1;
          }
              $reg = mysql_query("INSERT INTO ibwf_users SET name='".$name."', pass='".$pass."', birthday='".$bday."', sex='".$usex."', location='".$uloc."', regdate='".time()."',validated='".$validated."', lang='".$lang."', email='".$email."', ipadd='".getip()."', browserm='".$ubr."'");
          
              if ($reg)
              {
                $uid = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_users WHERE name='".$name."'"));
                $msg = "hello5. /reader greetings from all Waplive staff, we are happy to have you here, welcome. to our big happy family!  plz read  /faq and Explore other featurs. ENJOY Waplive! We do our best for U!! music. ";
                $msg = mysql_escape_string($msg);
                autopm($msg, $uid[0]);
                return 0;
              }else{
                return 2;
          
              }
            }
          
          }
          
          function validation()
          {
          $getval = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='vldtn'"));
          if($getval[0]=='1')
          {
          return true;
          }else
          {
          return false;
          }
          }
          
          /////////////////////// GET ibwf_users user id from nickname
          
          function getuid_nick($nick)
          {
            $uid = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_users WHERE name='".$nick."'"));
            return $uid[0];
          }
          function isheadadmin($uid)
          {
            $admn = mysql_fetch_array(mysql_query("SELECT perm FROM ibwf_users WHERE id='".$uid."'"));
            if($admn[0]>=3)
            {
              return true;
            }else{
              return false;
            }
          }
          
          function isheadadmin2($uid)
          {
            $admn = mysql_fetch_array(mysql_query("SELECT perm FROM ibwf_users WHERE id='".$uid."'"));
            if($admn[0]==3)
            {
              return true;
            }else{
              return false;
            }
          }
          /////////////////////////////////////////Is owner?
          
          function isowner($uid)
          {
            $own = mysql_fetch_array(mysql_query("SELECT perm FROM ibwf_users WHERE id='".$uid."'"));
            if($own[0]==4)
            {
              return true;
            }else{
              return false;
            }
          }
          /////////////////////////////////////////Is admin?
          
          function isadmin($uid)
          {
            $admn = mysql_fetch_array(mysql_query("SELECT perm FROM ibwf_users WHERE id='".$uid."'"));
            if($admn[0]>=2)
            {
              return true;
            }else{
              return false;
            }
          }
          
          function isadmin2($uid)
          {
            $admn = mysql_fetch_array(mysql_query("SELECT perm FROM ibwf_users WHERE id='".$uid."'"));
            if($admn[0]==2)
            {
              return true;
            }else{
              return false;
            }
          }
          
          ///////////////////////////////////parse bbcode
          
          function getbbcode($text, $sid="")
          {
                  $unreadinbox=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE unread='1' AND touid='".$uid."'"));
                  $pmtotl=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE touid='".$uid."'"));
                  $unrd="[".$unreadinbox[0]."l".$pmtotl[0]."]";
                  $text = preg_replace("/\[inbox]/is","<a href=\"inbox.php?action=main&amp;sid=$sid\">Inbox $unrd</a>",$text);
            $text = preg_replace("/\[updatepro]/is","<a href=\"index.php?action=uset&amp;sid=$sid\">Update Profie</a>",$text);
          $text = preg_replace("/\[image\=((.*?)(.php|php4|php5|xhtml|html))\]/i","Im trying To Hack", $text);
            $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","<small>\\1</small>", $text);
            $text = preg_replace("/\[url\=(.*?)\](.*?)\[\/url\]/is","<a href=\"$1\">$2</a>",$text);
            $text = preg_replace("/\[img\=(.*?)\]/is","<img src=\"$1\">",$text);
            $text = preg_replace("/\[clr\=(.*?)\](.*?)\[\/clr\]/is","<font color=\"$1\">$2</font>",$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("/\[forum\=(.*?)\](.*?)\[\/forum\]/is","<a href=\"index.php?action=viewfrm&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=\"\\0\">\\0</a>", $text);
            if(substr_count($text,"[br/]")<=5){
              $text = str_replace("[br/]","<br/>",$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 ibwf_users"));
            return $rmc[0];
          }
          ///////
          
          ///////////////////////////function counter
          
          function addvisitor()
          {
            $cc = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='Counter'"));
            $cc = $cc[0]+1;
            $res = mysql_query("UPDATE ibwf_settings SET value='".$cc."' WHERE name='Counter'");
          }
          
          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;
          
          }
          function boxstart($title){
          
          	echo "
          
          	<div class=\"boxed\">
          
                <div class=\"boxedTitle\">
          
                  <h1 align=\"center\" class=\"boxedTitleText c1\"><strong>$title</strong>
          
          	</h1>
          
                </div>
          
                <div class=\"boxedContent c1\">";
          
          }
          
          function boxend(){
          
          	echo "</div></div>";
          
          	}
          function getpmood($uid)
          {
            $pmood = mysql_fetch_array(mysql_query("SELECT pmood FROM ibwf_users WHERE id='".$uid."'"));
            return $pmood[0];
          }
          /////////////////////////////////////////////Get Mood
          function getsetmood($uid)
          {
             $getdata = mysql_fetch_array(mysql_query("SELECT setmood FROM ibwf_users WHERE id='".$uid."'"));
             return $getdata[0];
             $text = getsmilies($text);
          }
          function ischecker($uid)
          {
            $admn = mysql_fetch_array(mysql_query("SELECT perm FROM ibwf_users WHERE id='".$uid."'"));
            if($admn[0]=='2')
            {
              return true;
            }else{
              return false;
            }
          }
          ////////////////////////////get number of topic pages
          
          function getnumpages2($artid)
          {
            $nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_artpost WHERE artid='".$artid."'"));
            $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;
          }
          ///////////////////////////////////get page from go
          
          function getpage_go2($go,$artid)
          {
            if(trim($go)=="")return 1;
            if($go=="last")return getnumpages2($artid);
            $counter=1;
          
            $posts = mysql_query("SELECT id FROM ibwf_artpost WHERE artid='".$artid."'");
            while($post=mysql_fetch_array($posts))
            {
              $counter++;
              $postid = $post[0];
              if($postid==$go)
              {
                  $tore = ceil($counter/5);
                  return $tore;
              }
            }
            return 1;
          }
          function canaddart($uid,$id)
          {
            $minfo = mysql_fetch_array(mysql_query("SELECT authorid FROM ibwf_readart WHERE id='".$id."'"));
            if($minfo[0]==$uid||ismod($uid))
            {
              return true;
            }
            if($minfo[1]==$uid||ismod($uid))
            {
              return true;
            }
            return false;
          }
          ////////////////////////////////////////////function pop up msg
          
          function popup($sid)
          
          {
          
           $uid = getuid_sid($sid);
          
                    $unreadpopup=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_popups WHERE unread='1' AND touid='".$uid."'"));
          
          
          
          
          
                  if ($unreadpopup[0]>0)
          
                  {
          
          
          
                    $pminfo = mysql_fetch_array(mysql_query("SELECT id, text, byuid, timesent, touid, reported FROM ibwf_popups WHERE unread='1' AND touid='".$uid."'"));
          
                    $pmfrm = getnick_uid($pminfo[2]);
          
                    $ncl = mysql_query("UPDATE ibwf_popups SET unread='0' WHERE id='".$pminfo[0]."'");
          
                    $popmsgbox .= "<center><strong>POP-UP Message From $pmfrm</strong>";
          
                    $popmsgbox .= "<br/>";
          
                    $tmstamp = $pminfo[3];
          
                   $tmdt = date("d m Y - H:i:s", $tmstamp);
          
                    $popmsgbox .= "Sent At: $tmdt<br/>";
          
                    $pmtext = parsepm($pminfo[1], $sid);
          
                    $pmtext = str_replace("/llfaqs","<a href=\"lists.php?action=faqs&amp;sid=$sid\">$sitename F.A.Qs</a>", $pmtext);
          
                    $pmtext = str_replace("/reader",getnick_uid($pminfo[4]), $pmtext);
          
                    $pmid=$pminfo[0];
          
                    $popmsgbox .= "Message: $pmtext";
          
                    $popmsgbox .= "<br/>Send Reply to $pmfrm<br/></center>";
          
                   $popmsgbox .= "<form action=\"inbxproc.php?action=sendpopup&amp;who=$pminfo[2]&amp;sid=$sid&amp;pmid=$pminfo[0]\" method=\"post\">";
          
                   $popmsgbox .= "<center><input name=\"pmtext\" maxlength=\"500\"/><br/>";
          
                   $popmsgbox .= "<input type=\"Submit\" name=\"submit\" Value=\"Send\"></center></form>";
          
                    // $res = mysql_query("INSERT INTO ibwf_online SET userid='".$uid."', actvtime='".$tm."', place='".$place."', placedet='".$plclink."'");
          
                     $location = mysql_fetch_array(mysql_query("SELECT placedet FROM ibwf_online WHERE userid='".$uid."'"));
          
                     $popmsgbox .= "<center><a href=\"$location[0]&amp;sid=$sid\">Skip Msg</a><br/>";
          
                     $popmsgbox .= "<a href=\"inbxproc.php?action=rptpop&amp;sid=$sid&amp;pmid=$pminfo[0]\">Report</a></center>";
          
          
                         }
          
                     return $popmsgbox;
          
          }
          /////////////////////////mms hours
          function addhours(){
          
                  return 15*60*60;
          
           }
          ///////////////////////////////////////////is shielded?
          
          function spinned($uid)
          {
            $not = mysql_fetch_array(mysql_query("SELECT spinned FROM ibwf_users WHERE id='".$uid."'"));
            if($not[0]=='1')
            { return true;
            }else{
              return false;
            }
          }
          function pending($uid)
          {
              $res = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_rpgame WHERE uid='".$uid."'"));
              if($res[0]>0)
              {
                return true;
              }
              return false;
          }
          /////////////////////Get pops
          
          function isrpg($uid)
          {
              $nopop = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_rpg WHERE touid='".$uid."' AND accept='1'"));
             return $nopop[0];
          }
          //////////////////////GET USER NICK FROM USERID
          
          function ingame($uid)
          {
            $unick = mysql_fetch_array(mysql_query("SELECT uid FROM ibwf_rpgame WHERE uid='".$uid."'"));
            return $unick[0];
          }
          
          /////////////////////Get pops
          
          function i****($uid)
          {
              $nopop = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE id='".$uid."' AND hit='0'"));
             return $nopop[0];
          }
          /////////////////////Get pops
          
          function isrpg2($uid)
          {
              $nopop = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_rpg WHERE byuid='".$uid."' AND accept='2'"));
             return $nopop[0];
          }
          /////////////////////Get pops
          
          function notactive($uid)
          {
              $nopop = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE id='".$uid."' AND activate='1'"));
             return $nopop[0];
          }
          /////////////////////////Get user plusses
          
          function health($uid)
          {
              $plus = mysql_fetch_array(mysql_query("SELECT health FROM ibwf_users WHERE id='".$uid."'"));
              return $plus[0];
          }
          ///////////////////////////////////////////is shielded?
          
          function turn($uid)
          {
            $not = mysql_fetch_array(mysql_query("SELECT hit FROM ibwf_users WHERE id='".$uid."'"));
            if($not[0]=='1')
            { return true;
            }else{
              return false;
            }
          }
          ///////////////////////////////////////////is shielded?
          
          function noact($uid)
          {
            $not = mysql_fetch_array(mysql_query("SELECT hit FROM ibwf_users WHERE id='".$uid."'"));
            if($not[0]=='3')
            { return true;
            }else{
              return false;
            }
          }
          function have()
          {
              $nopop = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_quiz"));
             return $nopop[0];
          }
          function correct($answer,$id)
          {
            $uid = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_quizrooms WHERE answer='".$answer."' AND id='".$id."'"));
            return $uid[0];
          }
          /////////////////////// GET ibwf_users user id from nickname
          
          function getuid_hint($secure)
          {
            $uid = mysql_fetch_array(mysql_query("SELECT uid FROM ibwf_bank WHERE hint='".$secure."'"));
            return $uid[0];
          }
               ///////////////////////////////////////////is shielded?
          
          function onlinetime($uid)
          {
            $not = mysql_fetch_array(mysql_query("SELECT onlinedone FROM ibwf_users WHERE id='".$uid."'"));
            if($not[0]=='1')
            { return true;
            }else{
              return false;
            }
          }
          ///////////////////////////////////////////is shielded?
          
          function bank($uid)
          {
            $not = mysql_fetch_array(mysql_query("SELECT done FROM ibwf_bank WHERE uid='".$uid."'"));
            if($not[0]=='1')
            {
              return true;
            }else{
              return false;
            }
          }
          function getbrip($sid){
          
          $uid=getuid_sid($sid);
          
          $HTTP_USER_AGENT = getenv("HTTP_USER_AGENT");
          
          $REMOTE_ADDR = $_SERVER["REMOTE_ADDR"];
          
          if($REMOTE_ADDR == "207.210.86.252"){
          
          $REMOTE_ADDR = getenv("HTTP_X_FORWARDED_FOR");
          
          }
          
          mysql_query("UPDATE ibwf_users SET ua='".$HTTP_USER_AGENT."', ip='".$REMOTE_ADDR."' WHERE id='$uid'");
          
          }
          function isdigitf3($word)
          {
            $chars = "1234567890";
              $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;
          
          }
          function shad0w($uid, $who)
          {
          
          $pm = mysql_fetch_array(mysql_query("SELECT viewpro FROM ibwf_users WHERE id='".$who."'"));
          if($pm[0]=='2')
          {
          if (ismod($uid))
          {
          return true;
          }else{
          
          return false;
          }
          return false;
          }else if($pm[0]=='1')
          {
          if($uid==$who||arebuds($uid,$who)||ismod($uid))
          {
          return true;
          }else{
          return false;
          }
          }else if($pm[0]=='0')
          {
          return true;
          }
          }
          Last edited by riderz; 23.12.09, 12:04.
          have connected with http://adexchat.com ?
          Fun up with
          http://forum.adexchat.com

          Comment


            #6
            its only sql problem its not in core ill check the 3 stuff that are needed and post it

            Comment


              #7
              viewinbox int 1 default 0
              viewpro int 1 default 0
              viewgallery int 1 default 0

              Comment


                #8
                Originally posted by riderz View Post
                viewinbox int 1 default 0
                viewpro int 1 default 0
                viewgallery int 1 default 0
                Do we need to add that in sql or core.php ? :-P :->

                Comment


                  #9
                  add that to your database...
                  C3 Themes: http://c3themes.wen.ru/index.html
                  Find Files: http://mystarter.tk/?goto=X-search

                  Comment


                    #10
                    hey juz remove the prv profile coding thats all u hav to do


                    ....................................
                    http://photomag.lk/
                    ....................................

                    Comment


                      #11
                      oh yeah.. lets remove a whole block of code rather than insert 3 simple lines into a database, that's a brilliant idea...

                      Comment


                        #12
                        Originally posted by centi View Post
                        hey juz remove the prv profile coding thats all u hav to do
                        made my day hahaha
                        great going :-)

                        Comment

                        Working...
                        X