diff options
| -rw-r--r-- | sql/realmd.sql | 1 | ||||
| -rw-r--r-- | sql/updates/5670_realmd.sql | 1 | ||||
| -rw-r--r-- | src/game/World.cpp | 4 |
3 files changed, 4 insertions, 2 deletions
diff --git a/sql/realmd.sql b/sql/realmd.sql index 1a7c2435b94..a54afc1e391 100644 --- a/sql/realmd.sql +++ b/sql/realmd.sql @@ -209,6 +209,7 @@ CREATE TABLE `uptime` ( `startstring` varchar(64) NOT NULL default '', `uptime` bigint(20) unsigned NOT NULL default '0', `maxplayers` smallint(5) unsigned NOT NULL default '0', + `revision` VARCHAR(255) NOT NULL DEFAULT 'Trinitycore', PRIMARY KEY (`realmid`,`starttime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system'; diff --git a/sql/updates/5670_realmd.sql b/sql/updates/5670_realmd.sql new file mode 100644 index 00000000000..ba694028ab6 --- /dev/null +++ b/sql/updates/5670_realmd.sql @@ -0,0 +1 @@ +ALTER TABLE `uptime` ADD COLUMN `revision` VARCHAR(255) NOT NULL DEFAULT 'Trinitycore' AFTER `maxplayers`; diff --git a/src/game/World.cpp b/src/game/World.cpp index 4b1c54ff9f9..6d264cb049c 100644 --- a/src/game/World.cpp +++ b/src/game/World.cpp @@ -1600,8 +1600,8 @@ void World::SetInitialWorldSettings() sprintf( isoDate, "%04d-%02d-%02d %02d:%02d:%02d", local.tm_year+1900, local.tm_mon+1, local.tm_mday, local.tm_hour, local.tm_min, local.tm_sec); - loginDatabase.PExecute("INSERT INTO uptime (realmid, starttime, startstring, uptime) VALUES('%u', " UI64FMTD ", '%s', 0)", - realmID, uint64(m_startTime), isoDate); + loginDatabase.PExecute("INSERT INTO uptime (realmid, starttime, startstring, uptime, revision) VALUES('%u', " UI64FMTD ", '%s', 0, '%s')", + realmID, uint64(m_startTime), isoDate, _FULLVERSION); static uint32 abtimer = 0; abtimer = sConfig.GetIntDefault("AutoBroadcast.Timer", 60000); |