EQEmulator Forums - Lootable item on a pvp kill

Page 2 of 2

Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Lootable item on a pvp kill (https://www.eqemulator.org/forums/showthread.php?t=26319)

So_1337

10-01-2008 03:53 PM

Was worth a shot, but still no dice. I'll just be patient and wait for the next build to roll out here. Thanks for the idea =)

Back to your regularly scheduled thread, sorry for the hijack!

So_1337

10-01-2008 04:33 PM

Think I found the issue -- Had to install the Microsoft .NET framework versions 2 and 3. Thanks for the help =)

Digital

10-01-2008 06:16 PM

Hey Again!
I updated my EQEmu with the revision27 files but now i get this error wen i try logging in a char, and the zone crashes. What can i do about this?

Code:

Error in instZOrgID query in database.cpp GetZoneName'SELECT instZOrgID FROM cha

racter_ WHERE instZflagNum=58' #1054: Unknown column 'instZOrgID' in 'field list

'

Error in GetInstType query 'SELECT instZOrgID FROM character_ WHERE id=16' #1054

: Unknown column 'instZOrgID' in 'field list'

Error in instZOrgID query in database.cpp GetZoneName'SELECT instZOrgID FROM cha

racter_ WHERE instZflagNum=58' #1054: Unknown column 'instZOrgID' in 'field list

'

Derision

10-01-2008 06:22 PM

The changelog.txt file should have a list of any SQL changes you need to apply to your database. The errors you are getting there relate to Zone instancing. I think these are all the SQL changes relating to that:

Code:

INSERT INTO variables VALUES ('curInstFlagNum', 2000, 'Determines what instance flag will be handed out next', '2008-09-05 04:46:47');

ALTER TABLE `zone` ADD column `insttype` tinyint (1) zerofill unsigned NOT NULL default '0';

ALTER table character_ ADD column `instZflagNum` int(10) unsigned NOT NULL default '0';

ALTER table character_ ADD column `instZOrgID` int(11) NOT NULL default '0';

INSERT INTO variables VALUES ('dfltInstZflag',1000, 'Used to determine if a zone is instanced, must be 1000 or greater', '2008-09-05 04:46:47');

Digital

10-02-2008 07:09 AM

Ty Derision
You have been very helpful and most be a great asset to the EqEmu team.
Peace!

All times are GMT -4. The time now is 02:06 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page