How to Compile Hearthstone Core

[Vindicated]

Looks like there is an issue with your playercreateinfo table. Make sure that this has data in it.

[uberkiid]

Looks like there is an issue with your playercreateinfo table. Make sure that this has data in it.

There is no data, how should I go about fixing it?

[Vindicated]

Well you should install a world database like RivalDB (Link provided in my guide)

[uberkiid]

Well you should install a world database like RivalDB (Link provided in my guide)

Ok, so I installed RivalDB but I am still getting an error upon opening my worldserver.exe

http://i176.photobucket.com/albums/w...erverror-1.jpg

I'm sorry for my lack of knowledge with this stuff and also for all my questions.

[Vindicated]

Are your remote passwords matching in hearthstone-world.conf and hearthstone-logonserver.conf?

[uberkiid]

Are your remote passwords matching in hearthstone-world.conf and hearthstone-logonserver.conf?

Yes. I just double checked and they are the same.

[w1z8it]

What am I doing wrong? I'm no noob to programming, I've followed the guide perfectly, when I get to IV. Compiling Hearthstone and compile the source I get over 500 errors, I'm using Windows 7 build 7600 and VS2008 Pro.

I tried another guide first and had exactly the same errors, some of them are as follows:

Error	1	error C2039: 'shared_ptr' : is not a member of 'std::tr1'	g:\Hearthstone\trunk\src\hearthstone-shared\Common.h	300	hearthstone-shared
Error	2	error C2873: 'shared_ptr' : symbol cannot be used in a using-declaration	g:\Hearthstone\trunk\src\hearthstone-shared\Common.h	300	hearthstone-shared
Error	3	error C2065: 'shared_ptr' : undeclared identifier	g:\Hearthstone\trunk\src\hearthstone-shared\Common.h	383	hearthstone-shared

There are 545 total, the other guide I followed produced 548 errors, any ideas?

Edit: Found the problem you need to install Visual C++ 2008 Feature Pack Release with certain versions of Visual Studio, everything compiles now.

[w1z8it]

A different error now, when trying to execute the MySQL batch files from Navicat Lite:

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';

What's up?

[Vindicated]

That's good you fixed the error, but there is an error with your query. Post the query here and I will be glad to fix it.

[w1z8it]

That's good you fixed the error, but there is an error with your query. Post the query here and I will be glad to fix it.

Hi, erm the error is given when I execute the 1008_WorldTemplate.sql file from Navicat.

[Vindicated]

Then that means that there is an error on Aspire's part. Report it on their forums: aspiredev.net

[w1z8it]

No need I found the error, and fixed it:

Open up 1008_WorldTemplate.sql with notepad or whatever, look at the first query:

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for achievement_rewards
-- ----------------------------
CREATE TABLE `achievement_rewards`(
`achievementid` int(10) UNSIGNED NOT NULL ,
`title_alliance` int(10) UNSIGNED NOT NULL ,
`title_horde` int(10) UNSIGNED NOT NULL ,
`itemid` int(10) UNSIGNED NOT NULL ,
PRIMARY KEY (`achievementid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Achievement System';;

Remove one of the semicolons at the end of the query, save and then the batch file will execute correctly.

[w1z8it]

Everything went fine with the database queries, and creating the database and tables after I fixed the query posted above, now when I load the server I get the following errors:

13:38:39 E Database: Sql query failed due to [Table 'hearthstone
mcreation' doesn't exist], Query: [SELECT * FROM randomitemcreat

13:38:39 E Database: Sql query failed due to [Table 'hearthstone
dcreation' doesn't exist], Query: [SELECT * FROM randomcardcreat

13:38:39 E Database: Sql query failed due to [Table 'hearthstone
ation' doesn't exist], Query: [SELECT * FROM scrollcreation]

13:38:39 E MySQL: Query failed: SELECT * FROM playercreateinfo

13:38:39 E Database: Sql query failed due to [Table 'hearthstone_world.sp
ced_targets' doesn't exist], Query: [SELECT * FROM spell_forced_targets]

13:38:39 E Database: Sql query failed due to [Table 'hearthstone_world.s
c_override' doesn't exist], Query: [SELECT * FROM spell_proc_override]

13:38:39 E LootMgr: Loading loot from table objectloot failed.
13:38:39 E LootMgr: Loading loot from table skinningloot failed.
13:38:39 E LootMgr: Loading loot from table fishingloot failed.
13:38:39 E LootMgr: Loading loot from table itemloot failed.
13:38:39 E LootMgr: Loading loot from table prospectingloot faile
13:38:39 E LootMgr: Loading loot from table disenchantingloot fai
13:38:39 E LootMgr: Loading loot from table pickpocketingloot fai
13:38:39 E LootMgr: Loading loot from table millingloot failed.

13:38:40 E LootMgr: Loading loot from table creatureloot failed.

Although the server does load the above errors don't look good, any ideas?

Edit:
Another issue, I login, select the Test Realm server that's listed (obviously mine), I create a character and as soon as I click "ACCEPT" I get thrown back to the login screen which a message "You have been disconnected from the server"...

Edit again:
Ok after poking around I found out that I should install RivalDB (Not even mentioned in this guide for some reason...), so I've followed the instructions in the other guide to install and setup, now when I start the server it crashes and I get this:



This is starting to get frustrating now.

[Vindicated]

Actually it is mentioned in this guide if you looked. And I believe that is an error on RivalDB's part :/ They forgot to add a table or something. About the logon issue, it could be a number of things, most likely being your character database is corrupt.

[w1z8it]

Actually it is mentioned in this guide if you looked. And I believe that is an error on RivalDB's part :/ They forgot to add a table or something. About the logon issue, it could be a number of things, most likely being your character database is corrupt.

I've gone through you guide word for word 3 times now, no where did I see you mention having to install RivalDB, but besides that what should I do now? I've gone through this entire guide 3 times and I get the same issues each time, is this guide obsolete for the time being until your affiliates fix their issues?