Greengiant's New Database Qantum of Solace

[Andeby]

yea fairly blizzlike part from the vendors etc

Sounds nice! Think I'm gonna try it out later, just have to compile the Ascent Funserver core (Which won't work in Visual 2008 >.<).

[2dgreengiant]

get 2003 its the best for compiling

[mafiaboy]

using this right now, very nice! can't wait for more updates

[(ToW)YoMama]

hopefully u fixed the summoning issue, i haven't worked on my serer in moths so i hope this is your newest after your other 2

[2dgreengiant]

yea this is the newest one an i shall be updating today ^^

[Nartan]

Nice gonna use this. Thanks for releasing such an awesome thing.

[(ToW)YoMama]

okay so I can't get it to restore form the dump

[2dgreengiant]

its a new database so you will need to delete your old one, ofc backup everything u need first

[(ToW)YoMama]

I did taht but i am getting upload error right into it...do i need to do it threw Navicat or what?

[2dgreengiant]

1) backup all ur things that u want
2) drop the database via sqlyog/navicat
3) create a database called ascent or whatever
4) click tool.bat and install database

should work perfectly

[(ToW)YoMama]

Here this is what the error say...I should ahve just done this cause I am unusure what u are having me try to do. I am doing this threw NAvicat v7.2.7


[Err] 1074 - Column length too big for column 'regex_ignore_if_matched' (max = 255); use BLOB or TEXT instead

[Arthas117]

Hehe well to clear one thing up this is the name of the new James bond film which is out in November.


The Database
This is a mix of my own database and NCDB and various small things included such as vendors,quests etc. (good old wowhead)

Latest- Rev 64
Updated with the correct playercreateinfo
Pets should work now
Spells which were not casting should work correctly now

Rev 60
Added missing creature_names and creature_proto fields
Added vendors
Added correct prices for items in the vendors

Rev 59
All the leaked blizz quests have been added
Zul'Aman is working correctly now
Added Creature emotes
Druid class fixed
Mobs hp,damage etc, way points have been corrected
Outland instance boss's have ad their damage corrected
Outland instance AI corrected
Engineering can now make flying mounts :O
Mages can now make the mana biscuits and ice block added
Guild banks added
Black Temple spirit healer moved
Corrected 100's mob drop loot
Added more recall ports
Added more sql tables
Added/Fixed quest starter/finisher
Alot more 2.3 items added
New mounts added
Added enchanting patterns
Season 3 added (finally)
Added/corrected game objects
Added more Wanted: quests
Fixed some game objects so they are loot able

Any Extra Info
Added a folder for alot of LUA scripts
The database will be on a SVN so its easier to keep up-to-date with
Simple import tool all u need is mysql running

WARNING: This is a fresh database so backup all accounts,characters,items etc then drop your original database

http://svn2.assembla.com/svn/nano_tech/GreenGiant's Database

Make a folder n your desktop called whatever u want then right click and go on SVN Checkout and place that url above in and click on.

Any problems let me know ^^

I will upload to rapidshare etc soon

Still no rapidshare? The SVN only poops up a bunch of text and it loads forever :P

[2dgreengiant]

ill upload now 2 rapidshare

[Performer]

2d is it me or when u create a char u get a load of random items? like i made a orc hunter and it gave me earthshatter set.

[Vatralaus]

Every time i wont download RapidSVN show mi this error:

Execute: Checkout
Restore: D:/green 2d/Tool.bat
Added: D:/green 2d/Database
Added: D:/green 2d/Database/mysql.exe
Added: D:/green 2d/Database/world.sql
Added: D:/green 2d/Database/MySql.Data.dll
Error: Error while performing action: In directory 'D:\green 2d\Database'
Can't move 'D:\green 2d\Database\.svn\tmp\world.sql.tmp.tmp' to 'D:\green 2d\Database\.svn\tmp\world.sql.tmp': The process cannot access the file because it is being used by another process.
Ready