Jump to content

3TAJIOH

Members
  • Posts

    73
  • Joined

  • Last visited

Everything posted by 3TAJIOH

  1. After new pet system, pet Smokie doesnt give bonus Perfect Hide.
  2. Bug. After server restart, auotrade shops will be for zeny.
  3. Yes it is. But theara atcommands to change auras like @auras 1 1 1
  4. Need NPC, which will sell auras for CashPoints. Or NPC with paid access.
  5. 3TAJIOH

    whosell

    Can u say plz where and how?)
  6. How can I remove screen shadow effect after using fly wings?
  7. Why hunters do not attack targets if they are behind an obstacle?
  8. Please help to make aspd formula like this https://irowiki.org/wiki/ASPD In config defined renewal aspd.
  9. Solution https://github.com/rathena/rathena/commit/efd61daeea454b936943430ad8be308df0ca5ca9
  10. Where can I edit stat bonuses? Need to add bonus to ATK from STR stats.
  11. Why I dont have ATK bonuses on my pre-renewal server?) Bonus to MATK works correctly.
  12. Solution https://github.com/rathena/rathena/commit/40a4edc4f8fff75ba35b969882edabd17dd4c258
  13. How can I start server with gdb on Centos? gdb I installed.
  14. Should there be a bonus to ATK for STR?
  15. 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.
  16. Updated. I want to make donation to CashPoints, not to Credit Points.
  17. 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.
×
×
  • Create New...