1 reply to this topic

[aznan83]

hi.... i already edit /fluxcp/lib/Flux/LoginServer.php .... & #cashpoints functioning good...  but i have prob at flux cp Donation Credits, it still view data from cp_credits...

 

new at acc_reg_num_db  ... #CASHPOINTS

 

 

thanks all

Attached Files

•  donation credits.jpg   146.3K   29 downloads

[aznan83]

hi... i already put below code to to LoginServer.php ... but it still not read from #CASHPOINTS ... i hope someone can fix it



public function depositCredits($targetAccountID, $credits, $donationAmount = null)
{
$sql = "SELECT COUNT(account_id) AS accountExists FROM {$this->loginDatabase}.login WHERE account_id = ?";
$sth = $this->connection->getStatement($sql);
if (!$sth->execute(array($targetAccountID)) || !$sth->fetch()->accountExists) {
return false; // Account doesn't exist.
}

if (!$this->hasCreditsRecord($targetAccountID)) {
$fields = $fields = '`account_id`, `key`, `index`, `value`';
$values = '?, ?, ?, ?';

/*if (!is_null($donationAmount)) {
$fields .= ', last_donation_date, last_donation_amount';
$values .= ', NOW(), ?';
}*/

$sql = "INSERT INTO {$this->charMapDatabase}.`acc_reg_num_db` ($fields) VALUES ($values)";
$sth = $this->connection->getStatement($sql);
$vals = array($targetAccountID, '#CASHPOINTS', 0, $credits);

/*if (!is_null($donationAmount)) {
$vals[] = $donationAmount;
}*/

return $sth->execute($vals);
}
else {
$vals = array();
$sql = "UPDATE {$this->charMapDatabase}.`acc_reg_num_db` SET value = value + ? ";

/*if (!is_null($donationAmount)) {
$sql .= ", last_donation_date = NOW(), last_donation_amount = ? ";
}*/

$vals[] = $credits;

/*if (!is_null($donationAmount)) {
$vals[] = $donationAmount;
}*/

$vals[] = $targetAccountID;

$sql .= "WHERE account_id = ? and `key` = '#CASHPOINTS'";
$sth = $this->connection->getStatement($sql);

return $sth->execute($vals);
}
}