WoW-Info — информационный World of Warcraft портал

#include "ScriptPCH.h"    

    /*    
    create table `character_morphs`(       
         `guid` int(10) UNSIGNED NOT NULL COMMENT 'Character guid' DEFAULT '0',       
         `morph` int(5) UNSIGNED NOT NULL COMMENT 'Character morph' DEFAULT '0',    
         `scale` float(2) UNSIGNED NOT NULL COMMENT 'Character scale' DEFAULT '1',    
         PRIMARY KEY (`guid`)    
       )  ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'Charaster morphs';    
       */    

    class morphing_on_login : public PlayerScript    
    {    
    public:    
          morphing_on_login() : PlayerScript("morphing_on_login") {}    

          void OnLogin(Player* player)    
          {    
              int64 pguid = player->GetGUID();    
              QueryResult morph = CharacterDatabase.PQuery("SELECT morph from character_morphs WHERE guid = '%u'", pguid);    
              QueryResult scale = CharacterDatabase.PQuery("SELECT scale from character_morphs WHERE guid = '%u'", pguid);    

                  if (morph)    
                      player->SetDisplayId(morph->Fetch()->GetUInt32());    

                  if (scale)    
                      player->SetFloatValue(OBJECT_FIELD_SCALE_X, scale->Fetch()->GetFloat());    
          }    
    };    

    void AddSC_morphing_on_login()    
    {    
          new morphing_on_login();    
    }