Tingle's Private World of Warcraft Server Tutorial

[ChakkaD]

Hey, great work ...
got it up and running ...

but i only have a 7799 client.

how can i update the server to 7799?

[wolfnibbles]

I get this error wehn I try to install it. Help

Query:
CREATE TABLE `gameobject_spawns` (
`id` int(11) unsigned NOT NULL auto_increment,
`Entry` int(10) unsigned NOT NULL default '0',
`map` int(10) unsigned NOT NULL default '0',
`position_x` float NOT NULL default '0',
`position_y` float NOT NULL default '0',
`position_z` float NOT NULL default '0',
`Facing` float NOT NULL default '0',
`orientation1` float NOT NULL default '0',
`orientation2` float NOT NULL default '0',
`orientation3` float NOT NULL default '0',
`orientation4` float NOT NULL default '0',
`State` int(10) unsigned NOT NULL default '0',
`Flags` int(10) unsigned NOT NULL default '0',
`Faction` int(10) unsigned NOT NULL default '0',
`Scale` float NOT NULL default '0',
`stateNpcLink` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `Map` (`map`)
) ENGINE=MyISAM AUTO_INCREMENT=103533 /*!40100 DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs PACK_KEYS=0 ROW_FORMAT=FIXED COMMENT='Spawn System'*/

Error occured at:2008-02-20 10:55:23
Line no.:817531
Error Code: 1115 - Unknown character set: 'cp1251'

[ChakkaD]

Originally Posted by wolfnibbles

I get this error wehn I try to install it. Help

Query:

DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs PACK_KEYS=0 ROW_FORMAT=FIXED COMMENT='Spawn System'*/

Error occured at:2008-02-20 10:55:23
Line no.:817531
Error Code: 1115 - Unknown character set: 'cp1251'

looks like your sql server doesnt recognize the charset ... try another mysql db server.

[wolfnibbles]

Originally Posted by ChakkaD

looks like your sql server doesnt recognize the charset ... try another mysql db server.

and all I was doing was following the instuction on this web page, so is there one recamended?

[Kamui91]

I'm at 2.1.1 now and I get following Error:

Error: PROPFIND request failed on '/svn/ascent/trunk'
Error: PROPFIND of '/svn/ascent/trunk': 302 Moved Temporarily ()

Can anyone help me pls???

[Phreaq]

Can someone send me there, or post the file "worldmap_info.sql" when ever I try to dump it into my MySQL database I get an error.

This is the error message I recieve....

Query:
alter table accounts add column muted int(30) not null default 0

Error occured at:2008-01-31 17:37:37
Line no.:1
Error Code: 1060 - Duplicate column name 'muted'

Query:
/*Table structure for table `accounts` */
CREATE TABLE `accounts` (
`acct` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique ID',
`login` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login username',
`password` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login password',
`gm` varchar(32) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Game permissions',
`banned` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Account Standing',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Last login timestamp',
`lastip` varchar(16) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Last remote address',
`email` varchar(64) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Contact e-mail address',
`flags` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Client flags',
`forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
PRIMARY KEY (`acct`),
UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Account Information'

Error occured at:2008-01-31 17:38:16
Line no.:28
Error Code: 1050 - Table 'accounts' already exists

Query:
LOCK TABLES `creature_formations` WRITE

Error occured at:2008-02-02 22:17:03
Line no.:620665
Error Code: 1146 - Table 'world.creature_formations' doesn't exist

Query:
LOCK TABLES `creature_formations` WRITE

Error occured at:2008-02-02 22:27:02
Line no.:620665
Error Code: 1146 - Table 'world.creature_formations' doesn't exist

Query:
LOCK TABLES `worldmap_info` WRITE

Error occured at:2008-02-23 22:09:16
Line no.:1109425
Error Code: 1146 - Table 'world.worldmap_info' doesn't exist

Query:
LOCK TABLES `worldmap_info` WRITE

Error occured at:2008-02-23 22:11:24
Line no.:1109425
Error Code: 1146 - Table 'world.worldmap_info' doesn't exist

Query:
LOCK TABLES `worldmap_info` WRITE

Error occured at:2008-02-23 22:19:48
Line no.:1109425
Error Code: 1146 - Table 'world.worldmap_info' doesn't exist

Query:
LOCK TABLES `worldmap_info` WRITE

Error occured at:2008-02-23 22:32:54
Line no.:21
Error Code: 1146 - Table 'world.worldmap_info' doesn't exist

Query:
LOCK TABLES `worldmap_info` WRITE

Error occured at:2008-02-23 22:33:02
Line no.:21
Error Code: 1146 - Table 'world.worldmap_info' doesn't exist

Query:
LOCK TABLES `worldmap_info` WRITE

Error occured at:2008-02-23 22:41:57
Line no.:21
Error Code: 1146 - Table 'world.worldmap_info' doesn't exist

[Lemuna]

Kamui i got the same error as you, here screenshot, the link i typed in is correct



Edith:
Hmm i typed the link into browser, got a autho request, typed in anonymus and got to link

I replaced the one with projects emupedia link an now hes downloading sth. is that the right one?
Edit2:
Hmmm it dont look like the pic tingle put up:

[Howy]

I can't get section 2 to work either. I have looked and looked through the pages but can't find how to resolve it. Can you please help me

This looks like a great guide and i really want to try it out.

[Tingle]

New update added:

New svn directorys:

Ascent:
Moon++:
NCDB:

Logon information is still anonymous with no password

[Lemuna]

kk thx but why is the result just 13mb download at ascent/trunk should i redownload it?

[Kamui91]

Ok, I've just compiled Ascent... Errors:

Build: 3 succeeded, 4 failed, 0 up-to-date, 0 skipped

An excerpt of the Logfile...
...
Creating command line "cl.exe @"e:\AscentSOURCE\Ascent\win\VC90\ascent-world___Win32_Release\RSP00000F15641580.rsp" /nologo /errorReportrompt"
Creating temporary file "e:\AscentSOURCE\Ascent\win\VC90\ascent-world___Win32_Release\RSP00001015641580.rsp" with contents

...
Creating command line "cl.exe @"e:\AscentSOURCE\Ascent\win\VC90\ascent-world___Win32_Release\RSP00001015641580.rsp" /nologo /errorReportrompt"
Creating temporary file "e:\AscentSOURCE\Ascent\win\VC90\ascent-world___Win32_Release\RSP00001115641580.rsp" with contents
...
Creating command line "cl.exe @"e:\AscentSOURCE\Ascent\win\VC90\ascent-world___Win32_Release\RSP00001115641580.rsp" /nologo /errorReportrompt"

And

..\..\src\ascent-world\ScriptMgr.cpp(31) : fatal error C1083: Cannot open include file: 'svn_revision.h': No such file or directory

..\..\src\ascent-world\Level0.cpp(25) : fatal error C1083: Cannot open include file: 'svn_revision.h': No such file or directory

..\..\src\ascent-world\ClusterInterface.cpp(21) : fatal error C1083: Cannot open include file: 'svn_revision.h': No such file or directory

..\..\src\ascent-world\CharacterHandler.cpp(22) : fatal error C1083: Cannot open include file: 'svn_revision.h': No such file or directory

..\..\src\ascent-world\ConsoleListener.cpp(25) : fatal error C1083: Cannot open include file: 'svn_revision.h': No such file or directory

..\..\src\ascent-world\Master.cpp(28) : fatal error C1083: Cannot open include file: 'svn_revision.h': No such file or directory

Looks like I need this svn_revision.h file... Will I get problems by going on? If so, could you please upload this file? (And tell me the folder I'll have to put it in ^_^)

MfG Kamui

[The_Mog]

I've got the same Problem as Kamui91. I think there are a lots of Files missing in the svn folders. For example basic files like the ascent.exe and the logon.exe .

[Lemuna]

@ Kamui same Problem as you could be connected with the new database links, the files i downloaded were smaller than your one on the Pic's, Tingle.
Plx Help

[Marfal]

omg all npc dont have QUESTS!!! help plz

[Lemuna]

Tingle plz check these links!