Vote For Points Support

[Lelouch vi Britannia]

Well the issue was the Coins are unidentified when it goes into the storage.

Here is the script

<?php
class Coins {
	public $server;
	public $coinsID;
	
	public function __construct(Flux_Athena $server, $coinsID)
	{
		$this->server  = $server;
		$this->coinsID = $coinsID;
	}
	
	public function getCoins($accountID)
	{
		$sql = "SELECT amount FROM {$this->server->loginDatabase}.storage WHERE account_id = ? AND nameid = ? LIMIT 1";
		$sth = $this->server->connection->getStatement($sql);
		$sth->execute(array($accountID, $this->coinsID));
		$num = $sth->fetch();
		if ($num) {
			return (int)$num->amount;
		}
		else {
			return 0;
		}
	}
	
	public function setCoins($accountID, $amount)
	{
		$num = $this->getCoins($accountID);
		if (!$num) {
			$sql  = "INSERT INTO {$this->server->loginDatabase}.storage (account_id, nameid, amount) ";
			$sql .= "VALUES (?, ?, ?)";
			$sth  = $this->server->connection->getStatement($sql);
			return $sth->execute(array($accountID, $this->coinsID, $amount));
		}
		else {
			$sql  = "UPDATE {$this->server->loginDatabase}.storage SET amount = ? WHERE account_id = ? AND nameid = ?";
			$sth  = $this->server->connection->getStatement($sql);
			return $sth->execute(array($amount, $accountID, $this->coinsID));
		}
	}
}
?>

 

Edited June 12, 2018 by Lelouch vi Britannia

[Aries]

$sql  = "INSERT INTO {$this->server->loginDatabase}.storage (account_id, nameid, amount, identify) ";
$sql .= "VALUES (?, ?, ?, 1)";

update the insert part it should flag that the item is identified

[Lelouch vi Britannia]

12 hours ago, Aries said:

$sql  = "INSERT INTO {$this->server->loginDatabase}.storage (account_id, nameid, amount, identify) ";
$sql .= "VALUES (?, ?, ?, 1)";

update the insert part it should flag that the item is identified

Not Working

[Aries]

The amount will only get updated if you tested it on an account with coins already in storage.
Try it again to an account without the coin in the  storage.