public function getCharacters($realmid) { $chardb = JTrinityCoreUtilities::getCharacterDBName($realmid); $accid = JTrinityCoreDBHelper::getAccId(); $sql = "SELECT * FROM " . $chardb . ".characters WHERE account=" . $accid; $db = JTrinityCoreDBHelper::getDB(); $db->setQuery($sql); return $db->loadObjectList(); }
public function teleport($realmid, $guid, $x, $y, $z, $map, $newGold) { $chardb = JTrinityCoreUtilities::getCharacterDBName($realmid); $db = JTrinityCoreDBHelper::getDB(); $query = 'UPDATE ' . $chardb . '.characters SET position_x="' . $x . '", position_y="' . $y . '", position_z="' . $z . '", map="' . $map . '", money="' . $newGold . '" WHERE guid="' . $guid . '"'; $db->setQuery($query); if (!$db->query()) { JLog::add("Error teleporting. SQL=" . $query, JLog::ERROR); return false; } return true; }
protected function unstuck($realmid, $guid) { // Homebind $db = JTrinityCoreDBHelper::getDB(); $database = JTrinityCoreUtilities::getCharacterDBName($realmid); $query = 'SELECT * FROM ' . $database . '.character_homebind WHERE guid = ' . $guid . ' LIMIT 1'; $db->setQuery($query); if (!($obj = $db->loadObject())) { JLog::add("Unstuck: error. sql=" . $query, JLog::ERROR); return false; } $query = 'UPDATE ' . $database . '.characters SET position_x="' . $obj->position_x . '", position_y="' . $obj->position_y . '", position_z="' . $obj->position_z . '", map="' . $obj->map . '", zone="' . $obj->zone . '" WHERE guid=' . $guid . ' LIMIT 1'; $db->setQuery($query); if (!$db->query()) { JLog::add("Unstuck: error. sql=" . $query, JLog::ERROR); return false; } return true; }
/** * Buy gold to a character * @param unknown_type $gold Gold object * @param unknown_type $realmid Realmid * @param unknown_type $char Character object */ public function buyGold($gold, $realmid, $char) { // Start transaction $this->_db->transactionStart(); try { // Update user points $user = JFactory::getUser(); $userid = $user->id; if (!JTrinityCoreUtilities::substractUserPoints($userid, $gold->cost, $this->_db)) { $this->_db->transactionRollback(); return false; } $description = "Gold " . $gold->quantity; $donationtype = DONATIONTYPE_GOLD; // Update order table if (!JTrinityCoreUtilities::insertOrderTable($userid, $gold->id, $description, $gold->cost, $donationtype, $char->guid, $realmid, $this->_db)) { $this->_db->transactionRollback(); return false; } // Update Gold to character // Add gold to character // Get character DB $chardbname = JTrinityCoreUtilities::getCharacterDBName($realmid); $dbtc = JTrinityCoreDBHelper::getDB(); $addmoney = $gold->quantity * 10000; $sql = "UPDATE " . $chardbname . ".characters SET money=money+" . $addmoney . " WHERE guid=" . $char->guid; $dbtc->setQuery($sql); if (!$dbtc->query()) { $this->_db->transactionRollback(); return false; } $this->_db->transactionCommit(); return true; } catch (Exception $e) { JLog::add("Error buygold(): " . $e->getMessage(), JLog::ERROR); $this->_db->transactionRollback(); return false; } }
/** * Send the item purchased to the mailbox character * @param unknown_type $item item object from joomla database * @param unknown_type $realmid the realm of the character * @param unknown_type $character character object */ public function sendItem($item, $realmid, $character) { // Get character DB $chardbname = JTrinityCoreUtilities::getCharacterDBName($realmid); $dbo = JTrinityCoreDBHelper::getDB(); $characterid = $character->guid; $itemid = $item->itemid; //JLog::add("characterid=".$characterid." productid=".$productid." realmid=".$realmid." item name=".$item->name); // Get the mail id to insert // Start transaction $dbo->transactionStart(); try { $ok = true; $sql = "SELECT MAX(id) FROM " . $chardbname . ".mail"; $dbo->setQuery($sql); $id = $dbo->loadResult(); if (!$id) { $id = 0; } $id = $id + 1; $mail = new stdClass(); $mail->id = $id; $mail->messageType = 5; $mail->stationery = 41; $mail->sender = 0; // Should be the admin GM $mail->receiver = $characterid; $mail->has_items = 1; $mail->subject = JText::_('COM_JTRINITYCORE_MAIL_ITEM_SUBJECT'); $mail->body = JText::sprintf('COM_JTRINITYCORE_MAIL_ITEM_BODY', $character->name, $item->name); // Insert into mail table if ($dbo->insertObject($chardbname . '.mail', $mail, 'id')) { // Insert into item instance table $sql = "SELECT MAX(guid) FROM " . $chardbname . ".item_instance"; $dbo->setQuery($sql); $iteminstanceid = $dbo->loadResult(); if (!$iteminstanceid) { $iteminstanceid = 0; } $iteminstanceid = $iteminstanceid + 1; $item_instance = new stdClass(); $item_instance->guid = $iteminstanceid; $item_instance->itemEntry = $item->itemid; $item_instance->owner_guid = $characterid; $item_instance->durability = $this->getMaxDurability($item->itemid, $relmid); // $item->maxdurability; if ($dbo->insertObject($chardbname . '.item_instance', $item_instance, 'guid')) { // Insert into mail_items table $mail_item = new stdClass(); $mail_item->mail_id = $id; $mail_item->item_guid = $iteminstanceid; $mail_item->receiver = $characterid; if (!$dbo->insertObject($chardbname . '.mail_items', $mail_item)) { $ok = false; JLog::add("sendItem(): Error inserting item_instance. ", JLog::ERROR, 'donationshop'); } } else { $ok = false; } } else { $ok = false; JLog::add("sendItem(): Error inserting table mail. ", JLog::ERROR, 'donationshop'); } if (!$ok) { $dbo->transactionRollback(); return false; } $dbo->transactionCommit(); $user = JFactory::getUser(); $cost = $item->cost; // Update the new points to the user if (!JTrinityCoreUtilities::substractUserPoints($user->id, $cost)) { return false; } // Insert into the order table $description = $item->name . " (Level=" . $item->itemlevel . ")"; $donationtype = DONATIONTYPE_ITEM; $userid = $user->id; if (!JTrinityCoreUtilities::insertOrderTable($userid, $item->id, $description, $cost, $donationtype, $characterid, $realmid)) { return false; } return true; } catch (Exception $e) { JLog::add("Error: " . $e->getMessage(), JLog::ERROR, "donationhop->sendItem"); $dbo->transactionRollback(); return false; } }