Tingle's Private World of Warcraft Server Tutorial

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

but i only have a 7799 client.

how can i update the server to 7799?

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'

Quote:

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.

Quote:

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?

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 ([Only registered and activated users can see links. Click Here To Register...])

Can anyone help me pls???

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....

Quote:

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

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

[Only registered and activated users can see links. Click Here To Register...]

Edith:
Hmm i typed the link into browser, got a autho request, typed in anonymus and got to link
[Only registered and activated users can see links. Click Here To Register...]
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:
[Only registered and activated users can see links. Click Here To Register...]

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 :D

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

New update added:

New svn directorys:

Ascent: [Only registered and activated users can see links. Click Here To Register...]
Moon++: [Only registered and activated users can see links. Click Here To Register...]
NCDB: [Only registered and activated users can see links. Click Here To Register...]

Logon information is still anonymous with no password

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

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 /errorReport:prompt"
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 /errorReport:prompt"
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 /errorReport:prompt"

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

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 .

@ 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

omg all npc dont have QUESTS!!! help plz

Tingle plz check these links!