-
Posts
73 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Everything posted by 3TAJIOH
-
After new pet system, pet Smokie doesnt give bonus Perfect Hide.
-
Bug. After server restart, auotrade shops will be for zeny.
-
Yes it is. But theara atcommands to change auras like @auras 1 1 1
-
Need NPC, which will sell auras for CashPoints. Or NPC with paid access.
-
How can I remove screen shadow effect after using fly wings?
-
Thx a lot.
-
Why hunters do not attack targets if they are behind an obstacle?
-
@Tiraga have u sold this problem?
-
Need help! UP. UP Bump!
-
Please help to make aspd formula like this https://irowiki.org/wiki/ASPD In config defined renewal aspd.
-
Utility: @restock everywhere from your storage
3TAJIOH replied to Vykimo's topic in Utility Script Releases
And how can I exclude maps?) -
Solution https://github.com/rathena/rathena/commit/efd61daeea454b936943430ad8be308df0ca5ca9
-
I need bonus from base STR.
-
Where can I edit stat bonuses? Need to add bonus to ATK from STR stats.
-
Why I dont have ATK bonuses on my pre-renewal server?) Bonus to MATK works correctly.
-
Solution https://github.com/rathena/rathena/commit/40a4edc4f8fff75ba35b969882edabd17dd4c258
-
How can I start server with gdb on Centos? gdb I installed.
-
Should there be a bonus to ATK for STR?
-
When I attack IceWalls with normal attack, server crashes. But I can attack it with skills. The character does not attack at a great distance, he stops short of 5 cells. And when I come close to the IceWalls and press the attack, the server crashes. When attack IceWalls with Sniper, server crashes too.
-
Updated. I want to make donation to CashPoints, not to Credit Points.
-
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. } $creditsTable = Flux::config('FluxTables.CreditsTable'); $cashesTable = Flux::config('FluxTables.CashTable'); if (!$this->hasCreditsRecord($targetAccountID)) { $fields = 'account_id, balance'; $values = '?, ?'; if (!is_null($donationAmount)) { $fields .= ', last_donation_date, last_donation_amount'; $values .= ', NOW(), ?'; } $sql = "INSERT INTO {$this->loginDatabase}.$creditsTable ($fields) VALUES ($values)"; $sth = $this->connection->getStatement($sql); $vals = array($targetAccountID, $credits); if (!is_null($donationAmount)) { $vals[] = $donationAmount; } return $sth->execute($vals); } else { $vals = array(); $sql = "UPDATE {$this->loginDatabase}.$cashesTable SET value = value + ? "; $vals[] = $credits; if (!is_null($donationAmount)) { $vals[] = $donationAmount; } $vals[] = $targetAccountID; $sql .= "WHERE account_id = ?"; $sth = $this->connection->getStatement($sql); return $sth->execute($vals); } } FluxCP cannot edit table acc_reg_num? Donation to cp_credits works normally.