1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Parse error: syntax error, unexpected $end?

Discussion in 'PHP' started by maddog1993, May 6, 2009.

0
  1. #1
    I have been working on a script for a while now and I am nearly finished but I was just thought I was done with this file today when I got an error,
    Can somebody tell me what end tag to use please? I have the ?> php end tag but it will not accept it apparently. Code is bellow. If you find any errors in it please let me know, as far as I can tell this is the only problem. Thanks! :D

    <?php
//====================================
// USER MANAGEMENT FUNCTIONS
//====================================

//====================================
// Check if user exists
//====================================
function check_user($user) { {

    $res = query("SELECT * FROM `cu_users` WHERE `userid` = $user");
}

//====================================
// Add a new user data 
//====================================
function add_user( $user ) {

    query("INSERT INTO `cu_users` (`userid`, `ucash`, `uhealth`, `uenergy`, `uexperience`, `ulevel`, `jobs_completed`, `kill_count`, `death_count`) VALUES ( $user, 10000, 100, 10, 10, 1, 0, 0, 0 )");

}


//====================================
// Add cash to user
//====================================
function add_cash( $u, $c ) {
    $res = query("UPDATE `cu_users` SET `ucash`=(`ucash`+$c) WHERE `userid`=$user");
}

//====================================
// Get User Cash
//====================================
function get_cash( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user");
    $row = mysql_fetch_assoc($res);
    return $row[ucash];
}

//====================================
// Get User Health
//====================================
function get_health( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user");
    $row = mysql_fetch_assoc($res);
    return $row[uhealth];
}

//====================================
// Get User Energy
//====================================
function get_energy( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user");
    $row = mysql_fetch_assoc($res);
    return $row[uenergy];
}

//====================================
// Get User Experience
//====================================
function get_experience( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user");
    $row = mysql_fetch_assoc($res);
    return $row[uexperience];
}

//====================================
// Get User Level
//====================================
function get_level( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user");
    $row = mysql_fetch_assoc($res);
    return $row[ulevel];
}

//====================================
// Update User Level
//====================================
function update_level( $u ) {

    $user_exp = get_experience( $u );
    $new_level = ($user_exp/50);
    $new_level = intval($new_level);

    if( $user_exp < 50 ) $new_level = 1;
    else $new_level++;

    $res = query("UPDATE `cu_users` SET `ulevel`=$new_level WHERE `userid`=$user");

}

//====================================
// Get User Jobs Completed
//====================================
function get_jobs_completed( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user");
    $row = mysql_fetch_assoc($res);
    return $row[jobs_completed];
}


//====================================
// Get User Kill Count
//====================================
function get_kill_count( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user");
    $row = mysql_fetch_assoc($res);
    return $row[kill_count];
}

//====================================
// Update  User Kill Count
//====================================
function update_kill_count( $u ) {
    query("UPDATE `cu_users` SET `kill_count`=(`kill_count`+1) WHERE `userid`=$user");
}

//====================================
// Get User Death Count
//====================================
function get_death_count( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user");
    $row = mysql_fetch_assoc($res);
    return $row[death_count];
}

//====================================
// Update  User Death Countt
//====================================
function update_death_count( $u ) {

    if( get_health($u) <= 0 ) {
        query("UPDATE `cu_users` SET `death_count`=(`death_count`+1) WHERE `userid`=$user");
        return true;
    }
    else return false;
}

//====================================
// Get User Fight Won
//====================================
function get_fight_won( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user");
    $row = mysql_fetch_assoc($res);
    return $row[fight_won];
}


//====================================
// Get User Fight Lost
//====================================
function get_fight_lost( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$user");
    $row = mysql_fetch_assoc($res);
    return $row[fight_lost];
}



//====================================
// Get User Cash in BANK
//====================================
function get_bank_cash( $u ) {

    $res = query("SELECT * FROM `cu_bank` WHERE `userid`=$user");
    while( $row = mysql_fetch_array($res) ) {
        $user_cash = $row[bamount];
    }

    return $user_cash;
}

//====================================
// Get User Rank
//====================================
function get_rank( $u ) {

    $rank = 1;
    $res = query("SELECT * FROM `cu_users` ORDER BY `fight_won` DESC");
    while( $row = mysql_fetch_array($res) ) {
        if( $row[userid] == $u ) break;
        else $rank++;
    }

    return $rank;

}
?>
    Code (markup):
     
    maddog1993, May 6, 2009 IP
  2. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Hi,

    you've to remove second {
    Cheers ;)
     
    koko5, May 6, 2009 IP
  3. maddog1993

    maddog1993 Well-Known Member

    Messages:
    182
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    130
    Digital Goods:
    1
    #3
    OK I have this now, I changed it a little, any suggestions, error is now
    code is

    <?php

//====================================
// USER MANAGEMENT FUNCTIONS
//====================================

//====================================
// Check if user exists
//====================================
function check_user( $u ) {

    $res = query("SELECT * FROM `cu_users` WHERE `userid` = $u");

    list($total_rows) = mysql_fetch_array($res);

    if( $total_rows > 0 ) return true;
    else return false;

}

//====================================
// Add a new user data 
//====================================
function add_user( $u ) {

    query("INSERT INTO `cu_users` (`userid`, `ucash`, `uhealth`, `uenergy`, `uexperience`, `ulevel`, `jobs_completed`, `kill_count`, `death_count`) VALUES ( $u, 10000, 100, 10, 10, 1, 0, 0, 0 )");

}


//====================================
// Add cash to user
//====================================
function add_cash( $u, $c ) {
    $res = query("UPDATE `cu_users` SET `ucash`=(`ucash`+$c) WHERE `userid`=$u");
}

//====================================
// Get User Cash
//====================================
function get_cash( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u");
    $row = mysql_fetch_assoc($res);
    return $row[ucash];
}

//====================================
// Get User Health
//====================================
function get_health( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u");
    $row = mysql_fetch_assoc($res);
    return $row[uhealth];
}

//====================================
// Get User Energy
//====================================
function get_energy( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u");
    $row = mysql_fetch_assoc($res);
    return $row[uenergy];
}

//====================================
// Get User Experience
//====================================
function get_experience( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u");
    $row = mysql_fetch_assoc($res);
    return $row[uexperience];
}

//====================================
// Get User Level
//====================================
function get_level( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u");
    $row = mysql_fetch_assoc($res);
    return $row[ulevel];
}

//====================================
// Update User Level
//====================================
function update_level( $u ) {

    $user_exp = get_experience( $u );
    $new_level = ($user_exp/50);
    $new_level = intval($new_level);

    if( $user_exp < 50 ) $new_level = 1;
    else $new_level++;

    $res = query("UPDATE `cu_users` SET `ulevel`=$new_level WHERE `userid`=$u");

}

//====================================
// Get User Jobs Completed
//====================================
function get_jobs_completed( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u");
    $row = mysql_fetch_assoc($res);
    return $row[jobs_completed];
}


//====================================
// Get User Kill Count
//====================================
function get_kill_count( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u");
    $row = mysql_fetch_assoc($res);
    return $row[kill_count];
}

//====================================
// Update  User Kill Count
//====================================
function update_kill_count( $u ) {
    query("UPDATE `cu_users` SET `kill_count`=(`kill_count`+1) WHERE `userid`=$u");
}

//====================================
// Get User Death Count
//====================================
function get_death_count( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u");
    $row = mysql_fetch_assoc($res);
    return $row[death_count];
}

//====================================
// Update  User Death Countt
//====================================
function update_death_count( $u ) {

    if( get_health($u) <= 0 ) {
        query("UPDATE `cu_users` SET `death_count`=(`death_count`+1) WHERE `userid`=$u");
        return true;
    }
    else return false;
}

//====================================
// Get User Fight Won
//====================================
function get_fight_won( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u");
    $row = mysql_fetch_assoc($res);
    return $row[fight_won];
}


//====================================
// Get User Fight Lost
//====================================
function get_fight_lost( $u ) {
    $res = query("SELECT * FROM `cu_users` WHERE `userid`=$u");
    $row = mysql_fetch_assoc($res);
    return $row[fight_lost];
}



//====================================
// Get User Cash in BANK
//====================================
function get_bank_cash( $u ) {

    $res = query("SELECT * FROM `cu_bank` WHERE `userid`=$u");
    while( $row = mysql_fetch_array($res) ) {
        $user_cash = $row[bamount];
    }

    return $user_cash;
}

//====================================
// Get User Rank
//====================================
function get_rank( $u ) {

    $rank = 1;
    $res = query("SELECT * FROM `cu_users` ORDER BY `fight_won` DESC");
    while( $row = mysql_fetch_array($res) ) {
        if( $row[userid] == $u ) break;
        else $rank++;
    }

    return $rank;
}



?>
    Code (markup):
    Thanks!
    :D
     
    maddog1993, May 6, 2009 IP
  4. SHOwnsYou

    SHOwnsYou Peon

    Messages:
    209
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #4
    All of your Select queries need apostrophes around your variables.

    Ex: $res = query("SELECT * FROM `cu_users` WHERE `userid` ='$u'");
     
    SHOwnsYou, May 6, 2009 IP