[Website] MySQL Issues

[Zymus]

EDIT: I got it fixed. Just had to use the sql files in a different directory first. However I do have some more questions about how the server interprets data in the DB.:
1. What field/values do i change for equip stat modifiers and set bonuses?
2. Why is it that sometimes the socket icon appears on items and sometimes they done.
3. What is the purpose of the spell columns for items. Is that use effects or equip or what"?

[Ground Zero]

Moved to the correct forum.

[Aellya]

You don't have a column called required_8728_01_realmd_account in your realmd_db_version table.
Find the column that matches it (most likely the build number in it is wrong) and change it to match required_9010_01_realmd_realmlist. However i don't know what this value is for so might not even be used any more (the current wow build version for 3.3.2 is over 10k)

[Zymus]

Ok got it working, but now i have another question. Edited first post.

[Kiev]

I can only answer num 3 as im use to ArcEmu databases, but yes, this allows for the "on use" etc functions.

[trygon11]

For number 2 if your talking about the eternium belt buckle and the BS sockets, i encounterd this before im pretty sure it has to do with your core, when i went from 3.2 to 3.3 with my arcemu server that problem got fixed, if your talking about something else sorry for wasting your time :P

[Zymus]

trygon, it's not that. It's, not matter what item, if its socketed, the little socket picture, like the red, blue, etc, doesn't show up when you mouse over it. It just says that it's socketed, and you can open the socket interface, just the mouseover popupmenu doesn't show the socket picture, or contents.

[trygon11]

It may be the core your using still, THAT bug i recognize from a server called uber-wow on their weapons im not sure if its all of them or just some u cant see that they have sockets, but u can open the socket menu and the bonus's do work, i cant tell you how to fix it but you can go on their server and fill a ticket or theres probably someone on their forums you can pm about it. Sorry i dont know how to fix it personally but this is a lead you can follow if you want. Uber-WoW

[Zymus]

It may be the core your using still, THAT bug i recognize from a server called uber-wow on their weapons im not sure if its all of them or just some u cant see that they have sockets, but u can open the socket menu and the bonus's do work, i cant tell you how to fix it but you can go on their server and fill a ticket or theres probably someone on their forums you can pm about it. Sorry i dont know how to fix it personally but this is a lead you can follow if you want. Uber-WoW

Thanks, I'll check it out. Also, do you know about game object functions? Like when you click and object it does a certain action like buff the player or soething?

[Kiev]

In the Gameobject table, im not sure what its like on MaNGOS but im going to suppose its quite the same, there will be one saying "Spell" "spell2" etc, just fill in spell with the buff spell id.

[Zymus]

Ok, thanks. One more question, do you know how to add vehicles? Like in the DK quest you steal the horse?

[Kiev]

That WOULD be through scripting and im not sure on how to go about that one, im sorry.

[Aellya]

1. What field/values do i change for equip stat modifiers and set bonuses?

Equip stats are either the stat_value fields (for stam, int, etc...) or a spellid.
Set Bonuses are handled inside the dbc file ItemSet.dbc, it includes the set ID, set name, the (up to) 8 item IDs which make the set, the (up to) 8 spells you can get for set item counts and the (up to) 8 values which define how many peices you need to get each spell.
This file is needed on both the server and client to work.


2. Why is it that sometimes the socket icon appears on items and sometimes they done.

Not sure what you mean about socket icon, but to give an item gem sockets you set the socket_colour(x) value to define which colour gem to add to that socket. If they are all 0 then the item doesn't have any sockets.

GEM_META_SOCKET = 1,
GEM_RED_SOCKET = 2,
GEM_YELLOW_SOCKET = 4,
GEM_BLUE_SOCKET = 8

[Zymus]

1. What field/values do i change for equip stat modifiers and set bonuses?

Equip stats are either the stat_value fields (for stam, int, etc...) or a spellid.
Set Bonuses are handled inside the dbc file ItemSet.dbc, it includes the set ID, set name, the (up to) 8 item IDs which make the set, the (up to) 8 spells you can get for set item counts and the (up to) 8 values which define how many peices you need to get each spell.
This file is needed on both the server and client to work.


2. Why is it that sometimes the socket icon appears on items and sometimes they done.

Not sure what you mean about socket icon, but to give an item gem sockets you set the socket_colour(x) value to define which colour gem to add to that socket. If they are all 0 then the item doesn't have any sockets.

GEM_META_SOCKET = 1,
GEM_RED_SOCKET = 2,
GEM_YELLOW_SOCKET = 4,
GEM_BLUE_SOCKET = 8

This is what i mean by no socket icon. Look at the bottom of the context menu, it says Shift right click to open the socketing interface, but it doesn't show in the context menu what type of sockets the item as.
[spoiler][img][/spoiler]

[Kiev]

Its a bug with recent revs i think, either that or blizzard have changed something else too prevnting us seeing this, its not a big problem as it shows the sockets when purchasing the item.