竹貓星球

peter37 寫:問題外掛:投票加錢
我的 phpBB 版本: 2.0.22

底下是投票加錢的原語法, 請問如果我要同時加上兩種貨幣,
例如 金錢 user_money 要加 100, 金幣 user_gold 也要加 100,
請問底下的語法我要如何做修改,才能同時在投票後, 兩種貨幣都能加錢?
先謝回覆.

代碼: 選擇全部

################################################################# 
## Mod Title:   Voting + Money for phpBB2 
## Mod Version:   v1.0b 
## Author:   Vincent <want@ms59.url.com.tw> 
## Description: When user voting, the money of user will add. 
## 
## Installation Level:   Very Easy 
## Installation Time:   1 Minutes 
## 
## Files To Edit: 1 
##   posting.php 
################################################################# 
# 
#-----[ OPEN ]------------------------------------------------------- 
# 
posting.php 

# 
#-----[ FIND ]---------------------------------------- 
# 
   $message = $lang['Vote_cast']; 
# 
#-----[ BEFORE, ADD ]--------------------------------- 
# 
// 投票就送錢，BEGIN 
            $sql = "UPDATE phpbb_users 
               SET user_money =  user_money + 100 
               WHERE user_id = ".$userdata['user_id']; 
            if ( !$db->sql_query($sql, BEGIN_TRANSACTION) ) 
            { 
               message_die(GENERAL_ERROR, 'Could not update poll result', '', __LINE__, __FILE__, $sql); 
            }              
// 投票就送錢，END 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM   

               SET user_money =  user_money + 100

               SET user_money =  user_money + 100, user_gold = user_gold + 100