mangosvb / servertwo Goto Github PK

all spawned gameobject have same orientation.

aktuelly the Client is not closed if you leave the Server.
somtimes unknown opcodes appear

on Public Function GetQuestMenu
in class WS.Quests.vb

is a query:

[code]
WorldDatabase.Query(String.Format("SELECT s.questid, q.Title, q.Level_Normal, q.specialflags FROM queststarters s LEFT JOIN quests q ON (s.questid=q.id) WHERE s.type = {0} AND s.typeid = {1} AND q.Level_Start <= {2} AND (q.Required_Race = 0 OR (Required_Race & {4}) > 0) AND (q.Required_Class = 0 OR (Required_Class & {5}) > 0) " & _
"AND NOT EXISTS(SELECT * FROM characters_quests WHERE char_guid = {3} AND quest_status <> -2 AND quest_id = q.id) AND (q.Required_Quest1 = 0 OR EXISTS(SELECT * FROM characters_quests WHERE char_guid = {3} AND quest_status = -1 AND quest_id = q.Required_Quest1)) " & _
"AND (q.Required_Quest2 = 0 OR EXISTS(SELECT * FROM characters_quests WHERE char_guid = {3} AND quest_status = -1 AND quest_id = q.Required_Quest2)) AND (q.Required_Quest3 = 0 OR EXISTS(SELECT * FROM characters_quests WHERE char_guid = {3} AND quest_status = -1 AND quest_id = q.Required_Quest3)) " & _
"AND (q.Required_Quest4 = 0 OR EXISTS(SELECT * FROM characters_quests WHERE char_guid = {3} AND quest_status = -1 AND quest_id = q.Required_Quest4));", _
CType(QuestGiverType.QUEST_OBJECTTYPE_CREATURE, Byte), CType(WORLD_CREATUREs(GUID), CreatureObject).ID, c.Level, c.GUID, 1 << (c.Race - 1), 1 << (c.Classe - 1)), MySQLQuery)
[/code]

this query is not only stored on table worlddatabase, but in CharacterDatabase to.

is there are profi, there can split this to a new query over two databases?

later in the class the next function have a similar query over two databases..

•        Case Classes.CLASS_DEATH_KNIGHT 'Deathknight stats will need to be changed once we learn what this stuff is
  

•            If c.Level <= 55 Then
  

•                c.Life.Base += c.Level + 10
  

•            End If
  

•            c.Strength.Base += gainStat(c.Level, 0.00039, 0.006902, 1.08004, -1.051701)
  

•            c.Intellect.Base += gainStat(c.Level, 0.000002, 0.001003, 0.10089, -0.076055)
  

•            c.Agility.Base += gainStat(c.Level, 0.000022, 0.0046, 0.655333, -0.600356)
  

•            c.Stamina.Base += gainStat(c.Level, 0.000059, 0.004044, 1.04, -1.488504)
  

•            c.Spirit.Base += gainStat(c.Level, 0.000006, 0.002031, 0.27836, -0.340077)
  

Add this under Case Classes.CLASS_WARRIOR stats and it should fix it (remove the +'s), also - Wowadict - Mind adding someone on Skype for a little question and answer on this project?

It also appears that none of the gameobjects are spawning, if you remark the creature spawn and leave the gameobject spawn in, you do not see gameobjects like campfires and such.

Creature spawning on the 3.3.5 Development branch causes a #132 error client crash.
I believe the problem lies in the Update Packets for Creatures. I have played a little bit with this, and have a CreatureSpawn branch as well with some attempts at getting creatures to spawn.

if you start a ballte with a npc, the npc are dublicated near you're Position and he can fight, be he stand still and run not after you if you run away..

on spawning on world, you have some clothing and some spells, but no weapon in you're bag or on Person

the table "ban" is not includet in the core.
if i take a look into, the banned flag is set/unset in table account.
the table ban holds data about IP
this is not a good Idee here in Germany. we have a dynamic IP. also every time we Access the Internet, we will become a other IP adress. next time maybe you become same IP as i have now.
we can include the ban_date, unban_date, ban_reason, ban_by and ban_active to the table account or create a new structure to table ban.

what is bether? what do you think?

all npc's are now spawned but there are no movements on them
until now it is used the packet SMSG_MONSTER_MOVE
what for packet is the right one?