[問題]水怪RPG的經驗值無法增加
發表於 : 2003-07-18 01:37
我安裝了水怪 rpg後
只有po文有增加金錢而已\r
可是經驗值卻都沒有增加ㄟ
以下是我的程式碼\r
請高手們幫我看一下是那裡錯了
// RPG 經驗值計算公式
$sql = "SELECT rpg_cur_exp, rpg_max_exp, rpg_cur_hp, rpg_cur_mp, rpg_max_hp, rpg_max_mp FROM " . USERS_TABLE . " WHERE user_id = '$user_id'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error in RPG-Exp Upgrade!', '', __LINE__, __FILE__, $sql);
}
if ( $row = $db->sql_fetchrow($result) )
{
if ($row['rpg_cur_exp'] >= $row['rpg_max_exp'])
{
$sql = 'UPDATE nuke_users
SET rpg_level = rpg_level + 1,
rpg_cur_exp = rpg_cur_exp - rpg_max_exp,
rpg_max_exp = FLOOR( POW( 10, POW( rpg_level, (1/3) ) ) ) - FLOOR( POW( 10, POW( rpg_level - 1, (1/3) ) ) ),
rpg_cur_hp = rpg_max_hp,
rpg_cur_mp = rpg_max_mp
WHERE user_id = ' . $user_id;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, '無法更新 RPG 屬性!!', '', __LINE__, __FILE__, $sql);
}
//UpdateRPGProperties($uid);
}
}
// RPG 經驗值計算公式
也煩請各位高手們去看我的網站
http://ukyo.24cc.com
測試帳號：test
測試密碼：test
只有po文有增加金錢而已\r
可是經驗值卻都沒有增加ㄟ
以下是我的程式碼\r
請高手們幫我看一下是那裡錯了
// RPG 經驗值計算公式
$sql = "SELECT rpg_cur_exp, rpg_max_exp, rpg_cur_hp, rpg_cur_mp, rpg_max_hp, rpg_max_mp FROM " . USERS_TABLE . " WHERE user_id = '$user_id'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error in RPG-Exp Upgrade!', '', __LINE__, __FILE__, $sql);
}
if ( $row = $db->sql_fetchrow($result) )
{
if ($row['rpg_cur_exp'] >= $row['rpg_max_exp'])
{
$sql = 'UPDATE nuke_users
SET rpg_level = rpg_level + 1,
rpg_cur_exp = rpg_cur_exp - rpg_max_exp,
rpg_max_exp = FLOOR( POW( 10, POW( rpg_level, (1/3) ) ) ) - FLOOR( POW( 10, POW( rpg_level - 1, (1/3) ) ) ),
rpg_cur_hp = rpg_max_hp,
rpg_cur_mp = rpg_max_mp
WHERE user_id = ' . $user_id;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, '無法更新 RPG 屬性!!', '', __LINE__, __FILE__, $sql);
}
//UpdateRPGProperties($uid);
}
}
// RPG 經驗值計算公式
也煩請各位高手們去看我的網站
http://ukyo.24cc.com
測試帳號：test
測試密碼：test