Database error about servertwo HOT 9 OPEN

we have now split the database in 3 databases. i think it is not possible to create one query that can take a filter for more and one database. so i try to do it in 2 steps..
i think this is very slow..
someone with a better Idee?

from servertwo.

it will be possible with a join, i did something similar in ServerOne.

Any chance of a push of the changes ?

from servertwo.

look at my changes in my fork :-)
can a join sample data from different databases???
also between accessdatabase.realm and worlddatabase.creature ???

from servertwo.

yes, with some cleaver coding ;)

from servertwo.

Point me at the lines you need adjusting and I’ll post the required changes

If you are a member of the getmangos forum, please PM me (ID: Antz) with your email / skype details and we can chat more)

From: Frank [mailto:[email protected]]
Sent: 18 October 2013 20:44
To: mangosvb/serverTwo
Cc: Antz
Subject: Re: [serverTwo] Database error (#6)

look at my changes in my fork :-)
can a join sample data from different databases???

—
Reply to this email directly or view it on GitHub #6 (comment) . https://github.com/notifications/beacon/oaF1d12tQ5hKyEU6svQ6h4B-6BeCtD4DJkf6_-UzC7Xq0tvS94WwdwrjJFFmFKsP.gif

from servertwo.

it's on ws.quest.vb

Public Function GetQuestMenu
Public Function GetQuestMenuGO
Public Function GetQuestgiverStatus

in this function's there are many of query typ with join "queststarters on worlddatabase" and "characters_quests on characterdatabase"

if i see a example i can try to fix the rest :-)

I'm now on work, i'm back late to day..

from servertwo.

please look at https://github.com/mangosvb/serverOne/blob/master/Server/WorldServer/WS.Quests.vb

Lines 537 onwards

from servertwo.

Super.. thanks..

I was update my fork, include you’re corrections.

Found some more errors on packet, changed in 335

now we can move on J

Frank

Von: Antz [mailto:[email protected]]
Gesendet: Montag, 28. Oktober 2013 14:34
An: mangosvb/serverTwo
Cc: Frank
Betreff: Re: [serverTwo] Database error (#6)

please look at https://github.com/mangosvb/serverOne/blob/master/Server/WorldServer/WS.Quests.vb

Lines 537 onwards

—
Reply to this email directly or view it on GitHub #6 (comment) . https://github.com/notifications/beacon/CVbCK3wKjFbWhf7M4-goom6E2GWUB9AGZI-nW114_eyEWef-nnVsuF6tXH6qEmWS.gif

from servertwo.

frank, can you contact me on the getmangos.co.uk forum using pm ?

from servertwo.