[Website] MySQL Issues menu

Shout-Out

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    Zymus's Avatar Active Member
    Reputation
    15
    Join Date
    Sep 2009
    Posts
    87
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Website] MySQL Issues

    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"?
    Last edited by Zymus; 03-07-2010 at 01:02 PM.

    [Website] MySQL Issues
  2. #2
    Ground Zero's Avatar ★ Elder ★
    Reputation
    1132
    Join Date
    Aug 2008
    Posts
    3,504
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Moved to the correct forum.

  3. #3
    Aellya's Avatar Sergeant
    Reputation
    21
    Join Date
    Mar 2010
    Posts
    56
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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)

  4. #4
    Zymus's Avatar Active Member
    Reputation
    15
    Join Date
    Sep 2009
    Posts
    87
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok got it working, but now i have another question. Edited first post.

  5. #5
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I can only answer num 3 as im use to ArcEmu databases, but yes, this allows for the "on use" etc functions.




  6. #6
    trygon11's Avatar Member
    Reputation
    4
    Join Date
    Oct 2007
    Posts
    61
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  7. #7
    Zymus's Avatar Active Member
    Reputation
    15
    Join Date
    Sep 2009
    Posts
    87
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  8. #8
    trygon11's Avatar Member
    Reputation
    4
    Join Date
    Oct 2007
    Posts
    61
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  9. #9
    Zymus's Avatar Active Member
    Reputation
    15
    Join Date
    Sep 2009
    Posts
    87
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by trygon11 View Post
    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?

  10. #10
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.




  11. #11
    Zymus's Avatar Active Member
    Reputation
    15
    Join Date
    Sep 2009
    Posts
    87
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, thanks. One more question, do you know how to add vehicles? Like in the DK quest you steal the horse?

  12. #12
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That WOULD be through scripting and im not sure on how to go about that one, im sorry.




  13. #13
    Aellya's Avatar Sergeant
    Reputation
    21
    Join Date
    Mar 2010
    Posts
    56
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  14. #14
    Zymus's Avatar Active Member
    Reputation
    15
    Join Date
    Sep 2009
    Posts
    87
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Aellya View Post
    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]

  15. #15
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.




Page 1 of 2 12 LastLast

Similar Threads

  1. [MySQL] Website MYSQL + Server MYSQL Link up
    By mrjoker123 in forum WoW EMU Questions & Requests
    Replies: 5
    Last Post: 04-20-2010, 10:34 AM
  2. MySQL Issues
    By Mr Krabs in forum WoW EMU Questions & Requests
    Replies: 3
    Last Post: 03-02-2010, 09:32 AM
  3. Account Website MySQL Help
    By iterrorist in forum WoW EMU Questions & Requests
    Replies: 3
    Last Post: 05-25-2009, 08:22 AM
  4. Arcemu [Mysql out of memory issue] Is there a fix?
    By w21froster in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 10-04-2008, 02:16 PM
  5. Website issue
    By Verious in forum World of Warcraft Emulator Servers
    Replies: 15
    Last Post: 01-03-2008, 09:37 PM
All times are GMT -5. The time now is 04:01 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search