|
|
|
Классы для работы с базой данных Mu Online, благодаря которым не нужно составлять SQL-запросы. Содержит шесть классов: MuDatabase, MuCharacter, MuAccount, MuGuild, MuAccountCreator, MuQueryResult.
Короткое описание классов: * MuDatabase - подключение к базе * MuCharacter - работа с персонажами * MuAccount - работа с аккаунтами * MuGuild - работа с гильдиями * MuAccountCreator - создание аккаунтов * MuQueryResult - результат запроса, применяется MuDatabase::execute() или MuDatabase::query()
Список методов: Code <return_type> <class>::<function_name> (<args>)
===== MuDatabase CLASS ====
const MuDatabase::CONNTYPE_MSSQL const MuDatabase::CONNTYPE_ODBC MuDatabase MuDatabase::setUsername(string $username) MuDatabase MuDatabase::setPassword(string $password) MuDatabase MuDatabase::setHost(string $host) MuDatabase MuDatabase::setDSN(string $dsn) MuDatabase MuDatabase::setConnType(int $conntype) MuDatabase MuDatabase::useResetSystem() MuDatabase MuDatabase::connect() MuDatabase MuDatabase::useMD5() MuDatabase MuDatabase::lastError(bool $forceShowEvenIfNotInDebugMode=false) bool MuDatabase::connected() MuDatabase MuDatabase::useDebugMode() MuQueryResult MuDatabase::execute(string $queryFormat, string $arg1, string $arg2, ...) MuQueryResult MuDatabase::query(string $query) MuAccount MuDatabase::account(string $accountname) MuCharacter MuDatabase::character(string $charactername) MuDatabase MuDatabase::enableLogging(string $fileName, string $format) MuDatabase MuDatabase::use64KStatSupport() bool MuDatabase::accountExists(string $accountName) bool MuDatabase::emailExists(string $emailAddress) MuAccountCreator MuDatabase::accountCreator() array MuDatabase::rankings(int $max, bool $showGM) [array<MuCharacter>] MuGuild MuDatabase::guild(string $guildName)
====MuCharacter CLASS==== string MuCharacter::getName() int MuCharacter::getStrength() int MuCharacter::getAgility() int MuCharacter::getVitality() int MuCharacter::getEnergy() int MuCharacter::getCommand() int MuCharacter::getFreePoints() MuCharacter MuCharacter::setFreePoints(int $newVal) MuCharacter MuCharacter::addFreePoints(int $addVal) MuCharacter MuCharacter::remFreePoints(int $remVal) MuCharacter MuCharacter::setStrength(int $newVal) MuCharacter MuCharacter::setAgility(int $newVal) MuCharacter MuCharacter::setVitality(int $newVal) MuCharacter MuCharacter::setEnergy(int $newVal) MuCharacter MuCharacter::setCommand(int $newVal) MuCharacter MuCharacter::setPK(int $newVal) string MuCharacter::getClass() int MuCharacter::getClassCode() string MuCharacter::getRawClass() MuCharacter MuCharacter::setClass(mixed $newVal) MuCharacter MuCharacter::addStrength(int $addVal) MuCharacter MuCharacter::addAgility(int $addVal) MuCharacter MuCharacter::addVitality(int $addVal) MuCharacter MuCharacter::addEnergy(int $addVal) MuCharacter MuCharacter::addCommand(int $addVal) MuCharacter MuCharacter::remStrength(int $remVal) MuCharacter MuCharacter::remAgility(int $remVal) MuCharacter MuCharacter::remVitality(int $remVal) MuCharacter MuCharacter::remEnergy(int $remVal) MuCharacter MuCharacter::remCommand(int $remVal) int MuCharacter::getLevel() int MuCharacter::setLevel(int $newVal) int MuCharacter::getExp(int $newVal) MuCharacter MuCharacter::addLevel(int $addVal) MuCharacter MuCharacter::remLevel(int $remVal) bool MuCharacter::isBlocked() int MuCharacter::getMuteTime() MuCharacter MuCharacter::mute(int $minutes) MuCharacter MuCharacter::unmute() MuCharacter MuCharacter::block() MuCharacter MuCharacter::unblock() bool MuCharacter::isGM() int MuCharacter::getMapID() string MuCharacter::getMap() MuCharacter MuCharacter::getGM(int $gmCode=8) MuCharacter MuCharacter::unmakeGM() MuCharacter MuCharacter::move(mixed $map, int $x, int $y) MuCharacter MuCharacter::warp(mixed $map) MuCharacter MuCharacter::setX(int $x) MuCharacter MuCharacter::setY(int $y) int MuCharacter::getResets() MuCharacter MuCharacter::addResets(int $addVal) MuCharacter MuCharacter::setResets(int $newVal) MuCharacter MuCharacter::remResets(int $remVal) MuAccount MuCharacter::account() MuCharacter MuCharacter::setNumArray(array $vals) array MuCharacter::getInfo() [array<string=>mixed>] MuGuild MuCharacter::guild()
====MuAccount CLASS Скачано с top.arenamix.net==== string MuAccount::getPassword() string MuAccount::getUsername() string MuAccount::getName() MuAccount MuAccount::setName(string $newVal) bool MuAccount::isBlocked() string MuAccount::getSecretQuestion() MuAccount MuAccount::setSecretQuestion(string $newVal) string MuAccount::getSecretAnswer() MuAccount MuAccount::setSecretAnswer(string $newVal) MuAccount MuAccount::block() MuAccount MuAccount::unblock() bool MuAccount::hasPassword(string $password) MuAccount MuAccount::setPassword(string $newVal) MuAccount MuAccount::setPersonalID(string $newID) string MuAccount::getPersonalID() MuAccount MuAccount::setEmail($newVal) string MuAccount::getEmail() bool MuAccount::isOnline() int MuAccount::onlineHours() MuCharacter MuAccount::getLastUsedChar() string MuAccount::getLastUsedServer() array MuAccount::characters() [array<MuCharacter>] array MuAccount::getInfo() [array<string=>mixed>] string MuAccount::get(string $columnName) MuAccount MuAccount::set(string $columnName, string $newVal)
====MuAccountCreator CLASS==== MuAccountCreator MuAccountCreator::setUsername(string $val) MuAccountCreator MuAccountCreator::setPassword(string $val) MuAccountCreator MuAccountCreator::setSecretQuestion(string $val) MuAccountCreator MuAccountCreator::setSecretAnswer(string $val) MuAccountCreator MuAccountCreator::setName(string $val) MuAccountCreator MuAccountCreator::setEmail(string $val) MuAccountCreator MuAccountCreator::setPersonalID(string $val) MuAccountCreator MuAccountCreator::set(string $clumnName, string $to) MuAccountCreator MuAccountCreator::save()
====MuGuild CLASS==== string MuGuild::getName() MuCharacter MuGuild::getGM() MuCharacter MuGuild::getAGM() array MuGuild::getBMs() [array<MuCharacter>] array MuGuild::getChars() array MuGuild::getMembers() string MuGuild::getGMC()
====MuQueryResult CLASS==== array MuQueryResult::fetchArray() int MuQueryResult::affectedRows() void MuQueryResult::free() array MuQueryResult::fetchRow() object(stdclass) MuQueryResult::fetchObject() MuQueryResult MuQueryResult::nextResult()
Примеры: 1. Подключение MuEngine
Code <?php include 'muengine/all'; ?>
2. Установление соединения с базой данных
Code
<?php include 'muengine/all'; $db = new MuDatabase(); $db->setConnType(CONNTYPE_MSSQL); $db->setHost('127.0.0.1'); $db->setUsername('sa'); $db->setPassword('sqlpassword'); $db->connect() or die('Could not connect to SQL database'); /* $db->setConnType(CONNTYPE_MSSQL)->setHost('127.0.0.1')->setUsername('sa')->setPassword('sqlpassword')->connect() */ ?>
3. Получить имя аккаунта персонажа
Code <?php echo $db->character('MyCharacter')->account()->getUsername(); ?>
4. Получить всех персонажей на аккаунте
Code <?php foreach($db->account('myaccount')->characters() as $character) echo $character->getName(); ?>
5. Изменить все статы персонада на 32767
Code <?php foreach($db->account('myaccount')->characters() as $character) { $character->setStrength(32767)->setAgility(32767)->setVitality(32767)->setEnergy(32767); if($character->getRawClass() == 'dl') { $character->setCommand(32767); } } ?>
6. Создание аккаунта
Code <?php $accountcreator = $db->accountCreator(); $accountcreator->setUsername('mynewacc'); $accountcreator->setPassword('mynewpwd'); $accountcreator->setSecretQuestion('lol'); $accountcreator->setSecretAnswer('yeah'); $accountcreator->setName('mynewacc'); $accountcreator->setPersonalID(111111); $accountcreator->save(); ?>
7. Отобразить всех игроков гильдии и их статус
Code <?php foreach($db->guild('myguild')->getChars() as $character) { echo $character->getName(); if($character->account()->isOnline()) echo ' - ONLINE'; echo ' '; } ?>
8. Выполнить SQL-запрос Code <?php if(@get_magic_quotes_gpc()) { $_GET = array_map('stripslashes', $_GET); $_POST = array_map('stripslashes', $_POST); $_COOKIE = array_map('stripslashes', $_COOKIE); } $db->execute("SELECT * FROM Character WHERE Name = '%s'", $_POST['character']); ?>
|

Просмотров: 122 |
Загрузок: 9 |
Комментарии 0

Добавил: Гость |
Дата: 21.05.2012 01:08
|
|
|