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);
            }
        }