1. 05-03-2018, 22:51 #1
    A Prins
    A Prins is offline Particulier
    Berichten
    103
    Lid sinds
    12 Jaar

    Site omzetten naar mysqli

    Goedenavond.

    Ik heb een probleem met mijn website. Ik ben hem aan het omzetten naar mysqli, maar ik blijf hangen op de mysql_result die moet omgezet worden naar mysqli. Wie weet hoe ik dat kan doen? Hieronder het script waar het omgaat. Als ik mysql_result vervang voor mysqli_result dan werkt het niet en krijg ik een witte pagina.

    Code:
    <?php

include("./includes/_mysql_connection.php");
include("./includes/_functions.php");
include("_functies.php");


$__admin = 16;
$__gmod = 8;
$__fmod = 4;
$__help = 2;

if(!isset($_SESSION['__id'])){

    header("location: index.php");

}


define("ID", $_SESSION['__id']);



$select = $connection->query("SELECT `username`, `ip`, `lastclick`, `id` FROM `users` WHERE `id` = ".ID." LIMIT 1") or die(mysqli_error());


if(mysqli_num_rows($select) == 0){
    header("location: index.php");
}

$res = mysqli_fetch_assoc($select);


$naam = $res['username'];


$SESSID = mysqli_real_escape_string($connection, $_COOKIE['PHPSESSID']);

$s = $connection->query("SELECT `id` FROM `sessions` WHERE `id`=".ID." AND `SESSID`='".mr($SESSID)."' LIMIT 1") or die(mysqli_error());
if(mysqli_num_rows($s) == 0){
     $sql = $connection->query("SELECT `id` FROM `sessions` WHERE `id`=".ID." LIMIT 1") or die(mysqli_error());
    if(mysqli_num_rows($sql) == 0){
        $connection->query("INSERT INTO `sessions`(`id`, `SESSID`) VALUES (".ID.", '".mr($_COOKIE['PHPSESSID'])."')") or die(mysqli_error());
    }
        /* else {
        unset($_SESSION);
        header("location: index.php");
}*/
 if(mysqli_num_rows($s) > 0 AND !isset($_SESSION['logged'])) {
        unset($_SESSION);
        header("location: index.php");
    }
    
}

$connection->query("UPDATE `sessions` SET `SESSID`='".$SESSID."' WHERE `id`=".ID." LIMIT 1") or die(mysqli_error());



// Selecteer wat data
$sql = $connection->query("SELECT `speldata`. * , `landen`.`land` , `familie`.`naam`
FROM `speldata`
LEFT JOIN `landen` ON ( `speldata`.`land_id` = `landen`.`id` )
LEFT JOIN `familie` ON ( `speldata`.`familie_id` = `familie`.`id` )
WHERE `speldata`.`id` =".ID."
LIMIT 1 ") or die(mysqli_error());


$res = mysqli_fetch_assoc($sql);

/* Data invullen */
if(!is_null($res['naam'])){
    $hasfam = true;
} else {
    $hasfam = false;
}

$sql = $connection->query("SELECT COUNT(`id`) FROM `familie` WHERE `baas_id`=".ID." LIMIT 1") or die(mysqli_error());

if(mysqli_result($sql, 0) == 1){
    $famboss = true;
} else {
    $famboss = false;
}

$sql = $connection->query("SELECT COUNT(`id`) FROM `familie` WHERE `onderbaas_id`=".ID." LIMIT 1") or die(mysqli_error());

if(mysqli_result($sql, 0) == 1){
    $famunderboss = true;
} else {
    $famunderboss = false;
}

$sql = $connection->query("SELECT COUNT(`id`) FROM `familie` WHERE `shoutboxmod`=".ID." LIMIT 1") or die(mysqli_error());

if(mysqli_result($sql, 0) == 1){
    $shoutmod = true;
} else {
    $shoutmod = false;
}

$sql = $connection->query("SELECT COUNT(`id`) FROM `familie` WHERE `onderbaas_id2`=".ID." LIMIT 1") or die(mysqli_error());

if(mysqli_result($sql, 0) == 1){
    $famunderboss2 = true;
} else {
    $famunderboss2 = false;
}

            $s = $connection->query("SELECT `misdaden_s`, `misdaden_g`, `misdaden`, `auto_s`, `auto_g`, `autostelen`, `werken`, `wapenervaring`, `hoerenpimpen`, `kracht`, `fam_overvallen`, `bombaderen`, `stem`, `route66`, `computer` FROM `usertimes` WHERE `id`=".ID) 
            or die(mysqli_error());
            
            $r = mysqli_fetch_assoc($s);

$sql_sd = $connection->query("SELECT `donateur`, `status` FROM `status` WHERE  `id`=".ID) or die(mysqli_error());
$rs = mysqli_fetch_assoc($sql_sd);
$__status = $rs['status'];
$__dona = $rs['donateur'];
$__rank = $rs['status'];


if(isset($_COOKIE['banned']) && $__status > 0){
     setcookie("banned", "true", time());
    $connection->query("UPDATE `status` SET `status`=1 WHERE `id`=".ID) or die(mysqli_error());
    $connection->query("DELETE FROM `ip_banned` WHERE `ip`='".mr($_SERVER['REMOTE_ADDR'])."'") or die(mysqli_error());
    $connection->query("DELETE FROM `bans` WHERE `id`=".ID) or die(mysqli_error());
}


$v_id = array();
$v_ip = array();
$v_reden = "Hacken";
$v_names = array("");

if(in_array(ID, $v_id) || in_array($_SERVER['REMOTE_ADDR'], $v_ip) || in_array($naam, $v_names)){
    die("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>
<html>
<head>
    <title>Verbannen!</title>
    <meta name='description' content='Je bent verbannen!' />
    <meta name='keywords' content='Verbannen' />
    <meta name='author' content='".$sitetitel."' />
    <meta http-equiv='content-type' content='text/html; charset=iso-8859-1' />
    <link href='/css/homepage.css' rel='stylesheet' type='text/css' />
    <link rel='shortcut icon' href='/images/favicon.ico' type='image/x-icon'>
    <link rel='icon' href='/images/favicon.ico'>
</head>
<div id='streep'>    </div>
<body>

<div id='container'>

    <div id='header' style='background-image: url('/homepage/layout/header.png');'>    
    <div id='logo'></div>
        <div id='display'>

            <div id='navigation'>

            </div>

        </div>

    </div></div>

    
    <div id='content-top'></div>
    <div id='content'>
    
<center><h1>Je bent verbannen van ".$siteshortlink."!</h1>

<img src='homepage/layout/ban.png' alt='Verbannen'></br></br>
<font size='2'><b>Helaas, gangster. Je bent verbannen van deze site.</br>
Blijkbaar kun je de maffia wereld niet aan.</br>
Tot ziens!</b></font></center>
    </div>

<div id='content-bottom'>
</div>
       <div id='copyright'>
       <center><b>".$sitefootertekst." - ".date("Y")." ".$siteshortlink."</b></center>
</div>
<div id='cartoon'>
</div>
</body>
</html>");
}

$_s = $connection->query("SELECT COUNT(`ip`) FROM `ip_banned` WHERE `ip`='".mr($_SERVER['REMOTE_ADDR'])."'") or die(mysqli_error());

if($__status == 0 || isset($_COOKIE['banned']) || mysqli_result($_s, 0) >= 1){
     $sql = $connection->query("SELECT `reden` FROM `bans` WHERE `id`=".ID) or die(mysqli_error());
     $res = mysqli_fetch_assoc($sql);
     
     if(!isset($_COOKIE['banned'])){
        setcookie("banned", "true", (time() + (60*60*24*200)));
    }
    

     ?>
     <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
    <title>Verbannen!</title>
    <meta name='description' content='Je bent verbannen!' />
    <meta name='keywords' content='Verbannen' />
    <meta name='author' content='<?=$siteshortlink;?>' />
    <meta http-equiv='content-type' content='text/html; charset=iso-8859-1' />
    <link href='/css/homepage.css' rel='stylesheet' type='text/css' />
    <link rel='shortcut icon' href='/images/favicon.ico' type='image/x-icon'>
    <link rel='icon' href='/images/favicon.ico'>
</head>
<div id='streep'>    </div>
<body>

<div id='container'>

    <div id='header' style='background-image: url('/homepage/layout/header.png');'>    
    <div id='logo'></div>
        <div id='display'>

            <div id='navigation'>

            </div>

        </div>

    </div></div>

    
    <div id='content-top'></div>
    <div id='content'>
    
<center><h1>Je bent verbannen van <?=$siteshortlink;?>!</h1>

<img src='homepage/layout/ban.png' alt='Verbannen'></br></br>
<font size='2'><b>Helaas, gangster. Je bent verbannen van deze site.</br>
Blijkbaar kun je de maffia wereld niet aan.</br>
Tot ziens!</b></font></center>
    </div>

<div id='content-bottom'>
</div>
       <div id='copyright'>
       <center><b><?=$sitefootertekst;?> - <?=date("Y");?> <?=$siteshortlink;?></b></center>
</div>
<div id='cartoon'>
</div>
</body>
</html>
     
     
     <?
    die();
}



/* Zet er een nieuwe tijd in, om te zien dat ie online is */
if(!isset($_COOKIE['offline']) || $__status <= 1){
    $connection->query("UPDATE `users` SET `lastclick`=".time()." WHERE `id`=".ID) or die(mysqli_error());
}

/*$poll = $connection->query("SELECT `user_id` FROM `poll_answers` WHERE `user_id`=".ID) or die(mysqli_error());

if(mysqli_num_rows($poll) == 0 AND $_SERVER['REQUEST_URI'] != "/poll.php"){
   header("location: poll.php");
}
*/

$adminpagina = array("/famshoutbox.php", "/nieuws.php");
if($_SERVER['REQUEST_URI'] == $adminpagina){
   header("location: nieuws.php");
}

$st = cname(ID, $naam, true);
$status = $st['status'];


$familie = $res['naam'];
$famID = $res['familie_id'];

$staatID = $res['land_id'];
$staat = $res['land'];

if($staatID < 1 || $staatID > 11){
    $connection->query("UPDATE `speldata` SET `land_id`=1 WHERE `id`=".ID) or die(mysqli_error());
}


$contant = $res['cashmoney'];
$bank = $res['bankmoney'];


/* Aantal hoeren, eerpunten, kills */
$hoeren = $res['hoeren_straat'];
$hoeren_count = $res['count_hoeren'];
$eerpunten = $res['eerpunten'];
$killed = $res['kills'];
$connection->query("UPDATE speldata SET cashmoney='0' WHERE cashmoney<'0'");
$connection->query("UPDATE speldata SET bankmoney='0' WHERE bankmoney<'0'");

/* Rank */
$leven = $res['leven'];

if($leven == 0){

   if(isset($_POST['reset'])){
      
            $newname = trim(mysqli_real_escape_string($connection, $_POST['name']));
            $id = getid($newname);
            if(!is_name($newname)){
                    $msg = "Je hebt ongeldige tekens in je nieuwe naam gedaan!";
            } elseif($id != false && $id != ID){
                  $msg = "Deze naam is al bezet!";
            } else {
               cname(ID, $newname, false, true);
                 $connection->query("UPDATE `speldata` SET `leven`=100, `hoeren_straat`=0, `rank`=0.5, `cashmoney`=2500, `bankmoney`=10000 WHERE `id`=".ID) or die(mysqli_error());
                    $connection->query("UPDATE `status` SET `bescherming`=0 WHERE `id`=".ID) or die(mysqli_error());
                 $connection->query("UPDATE `users` SET registerDate=NOW(),`username`='".$newname."' WHERE `id`=".ID) or die(mysqli_error());
                 $connection->query("UPDATE `vrienden_blokkeren` SET `who`='".$newname."' WHERE `who`=".ID) or die(mysqli_error());
                 $connection->query("UPDATE `uitrust` SET `kogels`=10, `huizen_gehad`='', `woning`=0, `wapen`=0, `verd`=0, `vliegtuig`=0 WHERE `id`=".ID) or die(mysqli_error());
                 $connection->query("UPDATE `userstats` SET `misdaden_s`=0, `misdaden_g`=0, `auto_s`=0, `auto_g`=0, `kracht`=0, `winst`=0, `verlies`=0, `wapenervaring`=0, `wapentraining`=0, `hacken`=0, `hack_s`=0, `program`=0, `program_s`=0, `beheer`=0, `beheer_s`=0 WHERE `id`=".ID);
                 $connection->query("UPDATE `usertimes` SET `misdaden_s`=0, `misdaden_g`=0, `auto_s`=0, `auto_g`=0, `wapenervaring`=0, `hoerenpimpen`=0, `reizen`=0, `kracht`=0 WHERE `id`=".ID);
                 $connection->query("DELETE FROM `hoeren_rld` WHERE `id`=".ID) or die(mysqli_error());
                 $connection->query("DELETE FROM `hoeren_voorbereiding` WHERE `id`=".ID) or die(mysqli_error());
                 $connection->query("DELETE FROM `gevangenis` WHERE `user_id`=".ID) or die(mysqli_error());
                 $connection->query("DELETE FROM `garage` WHERE `user_id`=".ID) or die(mysqli_error());
                                 $connection->query("DELETE FROM `crusher_converter` WHERE `user_id`=".ID) or die(mysqli_error());
                 $connection->query("DELETE FROM `drugs_drank` WHERE `user_id`=".ID) or die(mysqli_error());
//                 $connection->query("UPDATE plattegrond SET owner='0',Gevangenis='0',Red_Light_District='0',Ziekenhuis='0',Casino='0' WHERE owner='".ID."'");
                 $connection->query("UPDATE speldata SET platte='0' WHERE id='".ID."'");

                 
               header("location: nieuws.php");
            }
     
     }
     ?>
     
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
    <title><?=$sitetitel;?> | <?=$siteslogan;?></title>
    <meta name="author" content="<?=$siteauthor;?>" />
    <meta name="copyright" content="<?=$sitecopyright;?>" />
    <meta name="description" content="<?=$sitedescription;?>" />
    <meta name="keywords" content="<?=$sitekeywords;?>" />
    <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
    <link href="styles.css" rel="stylesheet" type="text/css" />
    <link rel="shortcut icon" href="/images/favicon.ico" type="image/x-icon">
    <link rel="icon" href="/images/favicon.ico">
</head>
<body style='background-color: #433939; text-align: center; margin-top: 7%'>
     <form method='post' action='nieuws.php'>
     <img src="homepage/layout/grave.png" alt="">
     <br><br>
     <font size='2'>
     <b>
     Je bent vermoord!
     <br><br>
     <?php
     if(isset($msg)){
     echo $msg;
     }
     ?>
     
     Naam: &nbsp;<input type='text' name='name' value='<?=$naam;?>' maxlength='12' /><br><br>
     <input type='submit' name='reset' value='Opnieuw Beginnen!' />
     </b>
     </font>
     </form>
</body>
</html>
     <?
   die();
}



$rank = getRank($res['rank']);
$rankID = $rank['rankID'];





$gSql = $connection->query("SELECT `tijd` FROM `gevangenis` WHERE `user_id`=".ID." AND `tijd`>".time()." LIMIT 1") or die(mysqli_error());

if(mysqli_num_rows($gSql) == 1){
    $gevangen = true;
    $gRes = mysqli_fetch_assoc($gSql);
    $seconden = $gRes['tijd'] - time();
} else {
    $gevangen = false;
}


$rSql = $connection->query("SELECT `reizen` FROM `usertimes` WHERE `id`=".ID) or die(mysqli_error());
$rRes = mysqli_fetch_assoc($rSql);

if($rRes['reizen'] > time()) {
    $reizen = true;
    $reistijd = $rRes['reizen'] - time();
} else {
    $reizen = false;
}





include("_mainMenus.php");




?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
<head>
    <title><?=$sitetitel;?> | <?=$siteslogan;?></title>
    <meta name="author" content="<?=$siteauthor;?>" />
    <meta name="copyright" content="<?=$sitecopyright;?>" />
    <meta name="description" content="<?=$sitedescription;?>" />
    <meta name="keywords" content="<?=$sitekeywords;?>" />
    <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
    <link href="styles.css" rel="stylesheet" type="text/css" />
    <link rel="shortcut icon" href="/images/favicon.ico" type="image/x-icon">
    <link rel="icon" href="/images/favicon.ico">
    <script type="text/javascript" src="ibox/ibox.js"></script>
    <script type="text/javascript">
    iBox.close_label = 'Close';
    </script>
</head>
<body>
<table width='100%' cellspacing='0' style='margin: 0px;'>

<tr>

    <td width='14%' style='vertical-align: top;'>

    

        <table border='0' cellspacing='1' width='100%' bgcolor='#000'>

        

        <?php

        

        foreach($menuleft AS $cat => $subCats){

echo "
<tr><td class='menutop'>".$cat."</td></tr>";

            

            if(is_array($subCats)){

                foreach($subCats AS $url => $name){

                    if($url == "donatieshop.php"){

echo "
<tr><td class='menu'><a href='".$url."'> - ".$name."</a></td></tr>";
                        
                    } else {

echo "
<tr><td class='menu'><a href='".$url."'> - ".$name."</a></td></tr>";

                
                }
                

                    }

                

                }

            }

        

            ?>

        </table>
</td>

<td width='72%' style='vertical-align: top; height: 0px; text-align:center;' align='center'>
        <table border='0' cellspacing='0' width='100%' align='center'>
            <tr>
                <td>
                    <table border='0' cellspacing='1' width='96%' bgcolor='#000' align='center'>
                        <tr>
                            <td class='header' style='padding: 0px;'>
                                <table style="margin:0px; padding:0px;vertical-align: bottom;" cellpadding="0" cellspacing="0" width="100%">
                                    <tr>
                                        <td style="padding-bottom:14px; padding-left:20px;" margin:0px;">
                                            <img src="/homepage/layout/logo2.png" height="56px" width="287px" alt="Logo" />
                                        </td>
                                        <td>
                                            <div class="counter_view">
                                                                        <table cellpadding="0" cellspacing="0" style="margin: 0px; padding: 0px;">
                                        
                                        <tr>
                                            <td style="width: 54px;">
                                                <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
            <img src='/homepage/wachttijden/misdaad.png' alt='' title='Misdaden' border='0'>
        </td>
        <td><?php
                        if($r['misdaden'] < time()){
                            echo "<a href='misdaad.php'>Nu</a>";
                        } else {
                            echo "<span id='cdmisdaden'>".($r['misdaden'] - time())."</span>".countDown("misdaden", ($r['misdaden'] - time()));
                        }
        ?></td>
    </tr>
</table>                                            </td>
                                            <td style="width: 50px;">
                                                <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
            <img src='/homepage/wachttijden/wapen.png' alt='' title='Wapen Training' border='0'>
        </td>
        <td>
                        <?php
                        
                        if($r['wapenervaring'] < time()){
                            echo "<a href='wapenervaring.php'>Nu</a>";
                        } else {
                            echo "<span id='cdwapenervaring'>".($r['wapenervaring'] - time())."</span>".countDown("wapenervaring", ($r['wapenervaring'] - time()));
                        }
                        ?>
        </td>
    </tr>
</table>                                            </td>
                                            <td style="width: 50px;" colspan="2">
                                                <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
            <img src='/homepage/wachttijden/plattegrond.png' alt='' title='Aanslag Plegen' border='0'>
        </td>
        <td>
                        <?php
                        
                        if($r['bombaderen'] < time()){
                            echo "<a href='plattegrond.php'>Nu</a>";
                        } else {
                            echo "<span id='cdbombaderen'>".($r['bombaderen'] - time())."</span>".countDown("bombaderen", ($r['bombaderen'] - time()));
                        }
                        ?>
        </td>
    </tr>
</table>                                            </td>
                                        </tr>
                                        <tr>
                                            <td style="width: 54px;">
                                                <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
            <img src='homepage/wachttijden/car.png' alt='' title='Voertuigen Beginners' border='0'>
        </td>
        <td>
                        <?php
                        
                        if($r['autostelen'] < time()){
                            echo "<a href='stealcar.php'>Nu</a>";
                        } else {
                            echo "<span id='cdautostelen'>".($r['autostelen'] - time())."</span>".countDown("autostelen", ($r['autostelen'] - time()));
                        }
                        ?>
        </td>
    </tr>
</table>                                            </td>
                                            <td style="width: 54px;">
                                                <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
            <img src='/homepage/wachttijden/sporten.png' alt='' title='Sportschool Training' border='0'>
        </td>
        <td>
                        <?php
                        
                        if($r['kracht'] < time()){
                            echo "<a href='sportschool.php'>Nu</a>";
                        } else {
                            echo "<span id='cdkracht'>".($r['kracht'] - time())."</span>".countDown("kracht", ($r['kracht'] - time()));
                        }
                        ?>
        </td>
    </tr>
</table>                                            </td>
                                            <td style="width: 50px;" colspan="2">
                                                <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
            <img src='/homepage/wachttijden/rld.png' alt='' title='Hoeren Pimpen' border='0'>
        </td>
        <td>
                        <?php
                        
                        if($r['hoerenpimpen'] < time()){
                            echo "<a href='rld.php'>Nu</a>";
                        } else {
                            echo "<span id='cdhoerenpimpen'>".($r['hoerenpimpen'] - time())."</span>".countDown("hoerenpimpen", ($r['hoerenpimpen'] - time()));
                        }
                        ?>
        </td>
    </tr>
</table>                                            </td>
                                        </tr>
                                        <tr>
                                            <td style="width: 54px;">
                                                <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
            <img src='/homepage/wachttijden/familie.png' alt='' title='Familie Overval' border='0'>
        </td>
        <td>
            <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
<?php
if($famID == 0){
?>
            <img src='/homepage/icons/small.png' alt='' border='0'>
<?php
} else {
                        
                        if($r['fam_overvallen'] < time()){
                            echo "<a href='famoverval.php'>Nu</a>";
                        } else {
                            echo "<span id='cdfam_overvallen'>".($r['fam_overvallen'] - time())."</span>".countDown("fam_overvallen", ($r['fam_overvallen'] - time()));
                        }
}
                        ?>
        </td>
        <td>
            &nbsp;
        </td>
    </tr>
</table>
        </td>
    </tr>
</table>                                            </td>

                                            <td style="width: 54px;">
                                                <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
            <img src='/homepage/icons/money.png' alt='' title='Werken' border='0'>
        </td>
        <td>
            <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
<?php
    if($rank['rankID']< 1){
?>
            <img src='/homepage/icons/small.png' alt='' border='0'>
<?php
    } else {
                        if($r['werken'] < time()){
                            echo "<a href='werken.php'>Nu</a>";
                        } else {
                            echo "<span id='cdwerken'>".($r['auto_g'] - time())."</span>".countDown("werken", ($r['werken'] - time()));
                        }
}
?>

        </td>
        <td>

        </td>
    </tr>
</table>
        </td>
    </tr>
</table>                                            </td>
                                            <td style="width: 54px;">
                                                <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
            <img src='/homepage/wachttijden/route66.png' alt='' title='Route 66' border='0'>
        </td>
        <td>
            <table border='0' cellspacing='0' style='margin: 0px;'>
    <tr>
        <td>
                        <?php
                        
                        if($r['route66'] < time()){
                            echo "<a href='route66.php'>Nu</a>";
                        } else {
                            echo "<span id='cdroute66'>".($r['route66'] - time())."</span>".countDown("route66", ($r['route66'] - time()));
                        }
                        ?>
        </td>
        <td>
            &nbsp;
        </td>
    </tr>
</table>
        </td>
    </tr>
</table>                                            </td>
                                        </tr>
                                    </table>
                                </div>                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
<td class='subheader'>
<table width='100%' border='0' cellspacing='0' style='margin: 0px;' cellpadding='0'>
<tr>
<td style='text-align: left;'>
<? if($__status >= 16){echo "<a href='hqadminbasis.php'>Admin -</a>"; } ?>
<? if($__status == 8){
echo "<a href='gmod.php'>Game Moderator -</a>"; } ?>
<? if($__status == 4){
echo "<a href='forummod.php'>Forum Moderator -</a>"; } ?>
<? if($__status == 2){
echo "<a href='hdbasis.php'>Helpdesk -</a>"; } ?>
<a href='informatie.php'> Informatie</a>
<a href='ranksscore.php'> - Ranks & Score</a>
<? if($hasfam){echo "<a href='fambericht.php'> - Familie Bericht</a>"; } ?>
</td>

<? if($hasfam){echo "<td style='padding-left: 390px;'>"; } ?>
<? if($hasfam === false){echo "<td style='padding-left: 490px;'>"; } ?>

                                            <?php
                                
                                if($gevangen){
                                    echo "
                                    <table border='0' cellspacing='0' cellpadding='0' align='right'>
                                        <tr>
                                            <td>
                                                <img src='IMG/gevang.jpg' alt='' style='margin: 0px;'> 
                                            </td>
                                            <td>
                                                &nbsp;<b><span id='cdgevang'>".$seconden."</span></b>&nbsp;
                                            </td>
                                        </tr>
                                    </table>
                                    
                                ".countDown("gevang", $seconden);
                                }
                                
                                if($reizen){
                                    echo "
                                    <table border='0' cellspacing='0' cellpadding='0' align='right'>
                                        <tr>
                                            <td>
                                                <img src='homepage/icons/plane.png' alt='' style='margin: 0px;'> 
                                            </td>
                                            <td>
                                                &nbsp;<b><span id='cdreis'>".$reistijd."</span></b>&nbsp;
                                            </td>
                                        </tr>
                                    </table>
                                    
                                ".countDown("reis", $reistijd);
                                }
                                
                                
                                ?>
</td>
<td style='padding-left: 0px;'>
        <?php
$berichten2 = $connection->query("SELECT `id` FROM `berichten` WHERE `gelezen`=0 AND `ontvanger_id`=".ID." AND `in_inbox`=0 ORDER BY `id` ASC") or die(mysqli_error());
$berichten = mysqli_num_rows($berichten2);
$sql = $connection->query("SELECT `id` FROM `berichten` WHERE `gelezen`=0 AND `ontvanger_id`=".ID." AND `in_inbox`=0 LIMIT 1") or die(mysqli_error());
if(mysqli_num_rows($sql) == 1){
echo "<img src='homepage/icons/berichten.png' alt='Berichten' border='0' /><a href='berichten.php?x=inbox'><b>Berichten <b>(".$berichten.")</b></a>"; }
else { echo "<img src='homepage/icons/berichten.png' alt='Berichten' border='0' /><a href='berichten.php?x=inbox'>Berichten</a>"; } ?>
        
                                    </td>

                                </tr>
                                </table>

                            </td>

                        </tr>

                    </table>

                </td>

            </tr>
    

<?php
        $SSQl = $connection->query("SELECT status FROM speldata WHERE id=".ID) or die(mysqli_error());
        $QREs = mysqli_fetch_assoc($SSQl);
        $statu = $QREs['status'];
        $MSQL = $connection->query("SELECT m_12 FROM count_missions WHERE id=".ID) or die(mysqli_error());
        $QrSl = mysqli_fetch_assoc($MSQL);
        $m12 = $QrSl['m_12'];

    if($statu == 0){
        $plrstatus = Online;
    } elseif($statu == 1){
        $plrstatus = Online;
    } elseif($statu == 2){
        $plrstatus = Bezet;
    } elseif($statu == 3){
        $plrstatus = Afwezig;
    } elseif($statu == 4){
        $plrstatus = Smokkelen;
    } elseif($statu == 5){
        $plrstatus = Designen;
    } elseif($statu == 6){
        $plrstatus = Druk;
    } elseif($statu == 7){
        $plrstatus = Eten;
    } elseif($statu == 99){
        $plrstatus = Scripten;
    } elseif($statu == 100){
        $plrstatus = Legend;
    }

if(isset($_POST['go'])){
    $actie = mysqli_real_escape_string($connection, $_POST['actie']);

            if($actie == 1){
        $connection->query("UPDATE speldata SET status = 1 WHERE id=".ID);
            } elseif($actie == 2){
        $connection->query("UPDATE speldata SET status = 2 WHERE id=".ID);
            } elseif($actie == 3){
        $connection->query("UPDATE speldata SET status = 3 WHERE id=".ID);
            } elseif($actie == 4){
        $connection->query("UPDATE speldata SET status = 4 WHERE id=".ID);
            } elseif($actie == 5){
        $connection->query("UPDATE speldata SET status = 5 WHERE id=".ID);
            } elseif($actie == 6){
        $connection->query("UPDATE speldata SET status = 6 WHERE id=".ID);
            } elseif($actie == 7){
        $connection->query("UPDATE speldata SET status = 7 WHERE id=".ID);
            } elseif($actie == 99){
        $connection->query("UPDATE speldata SET status = 99 WHERE id=".ID);
            } elseif($actie == 100){
        $connection->query("UPDATE speldata SET status = 100 WHERE id=".ID);
            }
}
?>    
<tr>
<form method='post' actie='".$_SERVER['SCRIPT_NAME']."?".$_SERVER['QUERY_STRING']."'>
<td style='text-align: left; padding-left: 40px; padding-top: 5px; padding-bottom: 5px;'>

<link rel="stylesheet" href="/lightbox/css/lightbox.css" type="text/css" media="screen" />
<script type="text/javascript" src="ibox/prototype.js"></script> 
<script type="text/javascript" src="ibox/scriptaculous.js?load=effects,builder"></script> 
<script type="text/javascript" src="ibox/lightbox.js"></script>


<a href='help.php' rel='ibox&width=750&target=help.php' title='Help Systeem'><img src="homepage/ingame/help.png"></a>
<a href='informatie.php'><img src="homepage/ingame/info.jpg"></a>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

        <select name='actie'>
                <option value='0'><?=$plrstatus;?></option>
                <option value='1'>Online</option>
                <option value='2'>Bezet</option>
                <option value='3'>Afwezig</option>
                <option value='4'>Smokkelen</option>
                <option value='5'>Designen</option>
                <option value='6'>Druk</option>
                <option value='7'>Eten</option>
<?php
if($__status == 16){
?>
                <option value='99'>Scripten</option>
<?
}
?>
<?php
    if($m_12 == 1){
?>
                <option value='100'>Legend</option>
<?
    }
?>
        </select>
<input type='submit' name='go' value='Update!' />

</br></br></br>

<center>Snel wat hoeren, eerpunten of kogels verdienen?<br />
Klik <a href='coins.php'><b><font color='#FFFF00'>hier</font></b></a> om mee te doen met de klikmissie!</br></br></center>

</td>
</tr>
</form>
</html>
            <tr>

                <td style='text-align: center;'>



                    <?php
                    
                    $sql = $connection->query("SELECT `bankmoney`, `cashmoney` FROM `speldata` WHERE `id`=".ID) or die(mysqli_error());
                    $res = mysqli_fetch_assoc($sql);
            

                    if(ID ==  ''){
                    //Logboek script als je iemand niet vertrouwd!
                    $logQuery = "INSERT INTO `logboek`(`id_user`, `ip`,`date`, `page`, `money`) VALUES (".ID.", '".$_SERVER['REMOTE_ADDR']."', NOW(), '".mr($_SERVER['REQUEST_URI'])."', ".($res['bankmoney'] + $res['cashmoney']).")";
                    $connection->query($logQuery) or die(mysqli_error());
                }

                    
                    if($res['cashmoney'] < 0){
                        $connection->query("UPDATE `speldata` SET `cashmoney`=0, `bankmoney`=`bankmoney`+".$res['cashmoney']." WHERE `id`=".ID) or die(mysqli_error());
                        $menu_rechts_top['Contant'] = "\$0";
                        $menu_rechts_top['Bank'] = "\$".number_format($bank + $res['cashmoney']);



                    }


                    if($res['bankmoney'] < 0){

                        if($_GET['p'] == "famdonate"){

                            $connection->query("UPDATE `familie` SET `geld`=`geld`+".$res['bankmoney']." WHERE `id`=".$famID) or die(mysqli_error());
                            $connection->query("UPDATE `speldata` SET `bankmoney`=0 WHERE `id`=".ID) or die(mysqli_error());
                            $connection->query("UPDATE `famdonaties` SET `total`=`total`+".$res['bankmoney']." WHERE `user_id`=".ID." AND `fam_id`=".$famID) or die(mysqli_error());
                            $menu_rechts_top['Bank'] = "\$0";
                        } elseif($url == "markt.php"){
                            $min = (int) str_replace("-", "", $res['bankmoney']);
                            $s = $connection->query("UPDATE `markt_alg` SET `bieder`=0, `high_bod`=`bied_bod` WHERE `bieder`=".ID." AND `high_bod`>=".$min." LIMIT 1") or die(mysqli_error());
                            if(mysqli_affected_rows($s) == 0){
                                $s = $connection->query("SELECT `id`
                                FROM `markt_alg`
                                WHERE `bieder` =".ID."
                                AND `high_bod` <".$min."
                                ORDER BY `high_bod` DESC
                                LIMIT 1 ") or die(mysqli_error());
                                $r = mysqli_fetch_assoc($s);
                                $connection->query("UPDATE `markt_alg` SET `bieder`=0, `high_bod`=`bied_bod` WHERE `id`=".$r['id']) or die(mysqli_error());
                                $connection->query("UPDATE `speldata` SET `bankmoney`=0 WHERE `id`=".ID) or die(mysqli_error());

                            } else {
                                $connection->query("UPDATE `speldata` SET `bankmoney`=0 WHERE `id`=".ID) or die(mysqli_error());
                            }
                        } else {
                            $connection->query("UPDATE `speldata` SET `bankmoney`=0, `cashmoney`=`cashmoney`+".$res['bankmoney']." WHERE `id`=".ID) or die(mysqli_error());
                            $menu_rechts_top['Bank'] = "\$0";
                            $menu_rechts_top['Contant'] = "\$".number_format($contant + $res['bankmoney']);
                        }

                    }
                    ?>
  3. 06-03-2018, 05:21 #2
    gast85027 Guest

    Re: Site omzetten naar mysqli

    Ik zou beginnen met php error display aan te zetten zodat je de daadwerkelijke fout ziet ipv een wit scherm

    Hier staan ook wat handige dingen
    https://dzone.com/articles/convert-mysql-to-mysqli
  4. 06-03-2018, 08:08 #3
    K Tackoen
    K Tackoen is offline Particulier
    Berichten
    15
    Lid sinds
    17 Jaar

    Re: Site omzetten naar mysqli

    Niet om het een of ander.. Maar als je niet weet hoe je iets ombouwt (deze code is niet om aan te zien, zelfs niet als je het ombouwt naar MySQLi) doe het dan niet.

    In dit geval is dit zulke verpeste code dat je dit gewoon lekker helemaal opnieuw moet bouwen en het beste in OOP in plaats van al deze procedurele rompslomp.
  5. 22-03-2018, 12:34 #4
    Marty H
    Marty H is offline Particulier
    Berichten
    1.001
    Lid sinds
    17 Jaar

    Re: Site omzetten naar mysqli

    Ben het met K Tackoen eens.
    Begin bij het begin en leer je ook het meeste van.
    Ik zie verschillende posts van je voorbij komen met standaard vragen.

    Er zijn genoeg voorbeelden te vinden om een veilige database connectie op te zetten.
    Het mooiste is natuurlijk OOP dit geeft meer duidelijkheid in je code zoek bv is op PDO en het preparen van je sql string

    als ik je beetje op weg moet helpen stuur maar even pb
  6. 26-03-2018, 14:47 #5
    Di-Jo Heemskerk
    Di-Jo Heemskerk is offline artbandits
    Berichten
    144
    Lid sinds
    17 Jaar

    Re: Site omzetten naar mysqli

    het is idd een zooitje, maar als je het toch persee wil doen doe dan eerst een fetch_assoc en haal dan de waarde eruit die je in de result had..
    mysqli_result() bestaat niet

    dus

    $sql = $connection->query("SELECT COUNT(`id`) FROM `familie` WHERE `baas_id`=".ID." LIMIT 1") or die(mysqli_error());if(mysqli_result($sql, 0) == 1){ word dan
    $sql = $connection->query("SELECT COUNT(`id`) as `num_id` FROM `familie` WHERE `baas_id`=".ID." LIMIT 1") or die(mysqli_error());$resultaat=mysqli_fetch_assoc( $sql);if($resultaat['num_id'] == 1){

Quick links

Sitedeals

Andere media

Over Sitedeals

  • Sitedeals.nl is de grootste handelswebsite voor website eigenaren. Deel kennis en participeer op het webmasterforum.

Inloggen

Inloggen