Ir para conteúdo

Featured Replies

Postado

.Qual servidor ou website você utiliza como base? 

TFS 1.2 + znote

 

Está surgindo algum erro? Se sim coloque-o aqui. 

Citar

1609994542670-png.53437

 

Você tem o código disponível? Se tiver publique-o aqui: 

    //First, an UPDATE query to write the player itself
    query.str(std::string());
    query << "UPDATE `players` SET ";
    query << "`level` = " << player->level << ',';
    query << "`group_id` = " << player->group->id << ',';
    query << "`vocation` = " << player->getVocationId() << ',';
    query << "`health` = " << player->health << ',';
    query << "`healthmax` = " << player->healthMax << ',';
    query << "`experience` = " << player->experience << ',';
    query << "`lookbody` = " << static_cast<uint32_t>(player->defaultOutfit.lookBody) << ',';
    query << "`lookfeet` = " << static_cast<uint32_t>(player->defaultOutfit.lookFeet) << ',';
    query << "`lookhead` = " << static_cast<uint32_t>(player->defaultOutfit.lookHead) << ',';
    query << "`looklegs` = " << static_cast<uint32_t>(player->defaultOutfit.lookLegs) << ',';
    query << "`looktype` = " << player->defaultOutfit.lookType << ',';
    query << "`lookaddons` = " << static_cast<uint32_t>(player->defaultOutfit.lookAddons) << ',';
    query << "`maglevel` = " << player->magLevel << ',';
    query << "`mana` = " << player->mana << ',';
    query << "`manamax` = " << player->manaMax << ',';
    query << "`manaspent` = " << player->manaSpent << ',';
    query << "`soul` = " << static_cast<uint16_t>(player->soul) << ',';
    query << "`town_id` = " << player->town->getID() << ',';

    const Position& loginPosition = player->getLoginPosition();
    query << "`posx` = " << loginPosition.getX() << ',';
    query << "`posy` = " << loginPosition.getY() << ',';
    query << "`posz` = " << loginPosition.getZ() << ',';

    query << "`cap` = " << (player->capacity / 100) << ',';
    query << "`sex` = " << player->sex << ',';

    if (player->lastLoginSaved != 0) {
        query << "`lastlogin` = " << player->lastLoginSaved << ',';
    }

    if (player->lastIP != 0) {
        query << "`lastip` = " << player->lastIP << ',';
    }

    query << "`conditions` = " << db->escapeBlob(conditions, conditionsSize) << ',';

    if (g_game.getWorldType() != WORLD_TYPE_PVP_ENFORCED) {
        int32_t skullTime = 0;

        if (player->skullTicks > 0) {
            skullTime = time(nullptr) + player->skullTicks / 1000;
        }

        query << "`skulltime` = " << skullTime << ',';

        Skulls_t skull = SKULL_NONE;
        if (player->skull == SKULL_RED) {
            skull = SKULL_RED;
        } else if (player->skull == SKULL_BLACK) {
            skull = SKULL_BLACK;
        }
        query << "`skull` = " << static_cast<uint32_t>(skull) << ',';
    }

    query << "`lastlogout` = " << player->getLastLogout() << ',';
    query << "`balance` = " << player->bankBalance << ',';
    query << "`offlinetraining_time` = " << player->getOfflineTrainingTime() / 1000 << ',';
    query << "`offlinetraining_skill` = " << player->getOfflineTrainingSkill() << ',';
    query << "`stamina` = " << player->getStaminaMinutes() << ',';

    query << "`skill_fist` = " << player->skills[SKILL_FIST].level << ',';
    query << "`skill_fist_tries` = " << player->skills[SKILL_FIST].tries << ',';
    query << "`skill_club` = " << player->skills[SKILL_CLUB].level << ',';
    query << "`skill_club_tries` = " << player->skills[SKILL_CLUB].tries << ',';
    query << "`skill_sword` = " << player->skills[SKILL_SWORD].level << ',';
    query << "`skill_sword_tries` = " << player->skills[SKILL_SWORD].tries << ',';
    query << "`skill_axe` = " << player->skills[SKILL_AXE].level << ',';
    query << "`skill_axe_tries` = " << player->skills[SKILL_AXE].tries << ',';
    query << "`skill_dist` = " << player->skills[SKILL_DISTANCE].level << ',';
    query << "`skill_dist_tries` = " << player->skills[SKILL_DISTANCE].tries << ',';
    query << "`skill_shielding` = " << player->skills[SKILL_SHIELD].level << ',';
    query << "`skill_shielding_tries` = " << player->skills[SKILL_SHIELD].tries << ',';
    query << "`skill_fishing` = " << player->skills[SKILL_FISHING].level << ',';
    query << "`skill_fishing_tries` = " << player->skills[SKILL_FISHING].tries << ',';

    if (!player->isOffline()) {
        query << "`onlinetime` = `onlinetime` + " << (time(nullptr) - player->lastLoginSaved) << ',';
    }
    query << "`blessings` = " << static_cast<uint32_t>(player->blessings);
    query << " WHERE `id` = " << player->getGUID();

    DBTransaction transaction;
    if (!transaction.begin()) {
        return false;
    }

    if (!db->executeQuery(query.str())) {
        return false;
    }

 

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

Visitante
Responder

Quem Está Navegando 0

  • Nenhum usuário registrado visualizando esta página.

Estatísticas dos Fóruns

  • Tópicos 96.9k
  • Posts 519.7k

Informação Importante

Confirmação de Termo