chucky.black

Yes, I see items as "red ?" ingame. Only addon can help? Do you know some?

I make new item in item_template, which isn't in dbc.

Is it possible to display valid icon in inventory?

At vendor icon is displayed correctly, but in bag isn't.

Does somebody know what can I do with that?

Can you help me, how can I create patch for this?

I rewrote the function MinimalLoadFromDB in Player.cpp and it is working on mangos 9640.

bool Player::MinimalLoadFromDB( QueryResult *result, uint32 guid )
{
   //       0     1        2     3     4      5       6      7   8      9            10            11
   //SELECT guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags,"
   // 12          13          14          15   16           17        18         19         20         21          22           23                 24
   //"position_x, position_y, position_z, map, orientation, taximask, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost,"
   // 25                 26       27       28       29       30         31           32            33        34    35      36                 37         38
   //"resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, online, death_expire_time, taxi_path, dungeon_difficulty,"
   // 39           40                41                42                    43          44          45              46           47               48              49
   //"arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk,"
   // 50      51      52      53      54      55      56      57      58         59          60             61              62      63           64
   //"health, power1, power2, power3, power4, power5, power6, power7, specCount, activeSpec, exploredZones, equipmentCache, ammoId, knownTitles, actionBars  FROM characters WHERE guid = '%u'", GUID_LOPART(m_guid));

   result = CharacterDatabase.PQuery("SELECT guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags,position_x, position_y, position_z, map, orientation, taximask, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost,resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, online, death_expire_time, taxi_path, dungeon_difficulty,arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk,health, power1, power2, power3, power4, power5, power6, power7, specCount, activeSpec, exploredZones, equipmentCache, ammoId, knownTitles, actionBars FROM characters WHERE guid = '%u'",guid);

   if(!result)
   {
       sLog.outError("Player (GUID: %u) not found in table `characters`, can't load. ",guid);
       return false;
   }

   Field *fields = result->Fetch();

   uint32 dbAccountId = fields[1].GetUInt32();


   Object::_Create( guid, 0, HIGHGUID_PLAYER );

   m_name = fields[2].GetCppString();


   // overwrite possible wrong/corrupted guid
   SetUInt64Value(OBJECT_FIELD_GUID, MAKE_NEW_GUID(guid, 0, HIGHGUID_PLAYER));

   _LoadIntoDataField(fields[60].GetString(), PLAYER_EXPLORED_ZONES_1, PLAYER_EXPLORED_ZONES_SIZE);
   _LoadIntoDataField(fields[63].GetString(), PLAYER__FIELD_KNOWN_TITLES, KNOWN_TITLES_SIZE*2);

   // init saved position, and fix it later if problematic
   uint32 transGUID = fields[30].GetUInt32();
   Relocate(fields[12].GetFloat(),fields[13].GetFloat(),fields[14].GetFloat(),fields[16].GetFloat());
   SetLocationMapId(fields[15].GetUInt32());

   // NOW player must have valid map
   // load the player's map here if it's not already loaded
   SetMap(sMapMgr.CreateMap(GetMapId(), this));


   m_Played_time[PLAYED_TIME_TOTAL]= fields[19].GetUInt32();
   m_Played_time[PLAYED_TIME_LEVEL]= fields[20].GetUInt32();

   m_atLoginFlags = fields[33].GetUInt32();


   // apply original stats mods before spell loading or item equipment that call before equip _RemoveStatsMods()


   m_specsCount = fields[58].GetUInt8();
   m_activeSpec = fields[59].GetUInt8();

   // add ghost flag (must be after aura load: PLAYER_FLAGS_GHOST set in aura)
   if( HasFlag(PLAYER_FLAGS, PLAYER_FLAGS_GHOST) )
       m_deathState = DEAD;


   // all fields read
   delete result;
   result = NULL;

   return true;
}

(it is not cleaned)

Is it possible to control NPC as GM?

It should be useful function for RP servers...

I want to merge ahbot with Mangos rev. 8587, how can I do that?

I use:

git clone git://github.com/mangos/mangos.git

git reset --hard [8587]

git pull git://github.com/Naicisum/mangos.git ahbot

git reset correctly switch revision to 8587, but last command updates again to newest revision...

Mangos Version : 8543

Database Name and Version : UDB rev. 382

Mana Tide Totem is still not working for me.

Any idea, please?