[Stable] Revision 1900 - Gastricpenguin

[Gastricpenguin]

Core Rev 1900
Created by Gastricpenguin

Well im back with another stable core! The best part, the only time i got my server to crash under this core was running a virus scan, updating my drivers, and hacking all at the same time :3

This time, i will be providing not only the DBC files, but a database aswell. In my next core, i will include everything needed to run a server effectively.

Please take a look at the following before starting up your server.
-- DELETE YOUR 'Scripts_bin' AND 'scripts' FOLDERS BEFORE EXTRACTING!
-- Although the config files have changed, you still need to edit them!
-- Where you would normally see "change_me_logon" or "change_me_root", i have edited the files and manually added a password on both configs, so you do not have to change it. It is now the default pass of "Detonation"
-- MaxClient build has been set to 7318 (2.2.2 Wow's current build)

-->PLEASE NOTE: The core and database CAN'T be used for commercial purposes, you can't include them in guides or repacks<--

~*~DOWNLOADS~*~
Revision 1900
Primary Mirror 1 - Filebeam - Rev 1900
Secondary Mirror - FileFront - Rev 1900
CURRENT PROBLEM: Characters cannot be loaded nor created. I have started to work on this error at 3pm. So expect a new core up soon.

2.2.2 DBC Files
Primary Mirror 1 - Filebeam - 2.2.2 Dbc Files
Secondary Mirror - Filefront - 2.2.2 Dbc Files

Clean Database
DOWN

Creature fix (ONLY IF YOU NEED IT)
Primary Mirror 1 - Filebeam - Creature Fix
Secondary Mirror - Filefront - Creature Fix
-->PLEASE NOTE: The core and database CAN'T be used for commercial purposes, you can't include them in guides or repacks<--

Changelog:
- Revision 1900 -
Voice Chat prep
Mandatory Updates
Holiday prep
Stability greatly enhanced
Honor + Arena updates
- Revision 1810 -
Console Changes
Updated dbc recognition to 2.2.2
Fixed incompatibility
Enhanced Config Files
Fixed Gm Scripts (included)
Enhanced Custom Scripts

[Phase228]

Awesome Gastric looks really efficent iam back into emu's so this will help me out trying to update it and run it and such

[Herzeleid]

nice, but how is this a guide?

[Gastricpenguin]

To set up a server, duh. Its vital for any server creation :3

[Kurosan]

thanks for the upload.. So this means voice chat now works? Or just edited to to the point where the next version will?

[Airwavez]

Is this database just fresh and clean?

[Chrispee]

very nice gast very nice

[Gastricpenguin]

The database is a clean Db, not from anyone.
And voice chat will be implemented near rev 1850 to 1900

[Airwavez]

Alright, I got one question, with your last revision I was using DBE( Database Evolved) but none of the mobs we're spawning and all that, is it because I had to change and update the tables?


alter table creature_spawns add column channel_spell int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid_creature int(30) not null default 0;

is that the query?

[Kurosan]

When you say clean DB.. No quest work and such? Or.. whats in it?

[Airwavez]

When you say clean DB.. No quest work and such? Or.. whats in it?

Just like the world of warcraft server, it has all cept custom items and all that.:wave:

[Kurosan]

When i try to import it.. i get an error around 1043 mb..

Wth, after i tried using your DB.. no databses want to install.. keep getting an error at 1043 mb..

[Airwavez]

if his DB Doesn't work use DBE
gamingevolved.org

they have fun server database.
after that use these SQL queries:

alter table creature_spawns add column channel_spell int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid_creature int(30) not null default 0;

CREATE TABLE `spell_proc_data` (
`name_hash` int(30) NOT NULL,
`proc_chance` int(30) NOT NULL,
`forced_proc_flags` int(30) NOT NULL default '-1',
PRIMARY KEY (`name_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

alter table characters add column custom_faction int(30) default 0 not null after gender;

I still have to test these out which I'm going to be doing in a lil bit

[Gastricpenguin]

You dont need those queries for this db :S

Thats for rev 1700.

[Mikuro]

Thanks, I was having trouble finding a stable core of 1800+, just throw in a few edits in the database and put it all together with a guide and you'll have a great repack