Help making some SQL Quieries menu

User Tag List

Results 1 to 3 of 3
  1. #1
    controlsx2's Avatar Member
    Reputation
    16
    Join Date
    Jun 2007
    Posts
    223
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help making some SQL Quieries

    Well im really bad at these things so im wordering if somone can help me
    i tried to make my server with a level cap or 325, But arc-emu doesnt support a cap higher than 80 without some major core editing on how stats are calculated which i dont think im advanced enough for yet. So i want to revert it back to 80 what i need are quieries that will

    Modify all items with a requiredlevel > 80 to become 80 e.g
    Modify 'items' where 'requiredlevel' > 80 to 'requiredlevel' = 80

    Modify all chars with a level > 80 to 80 e.g
    Modify 'characters' where 'level' > 80 to 'level' 80

    All mobs with a level > 80 become 80.

    If somone could help me id be really greatful

    Thanks in advance,
    Controlsx2

    Help making some SQL Quieries
  2. #2
    Henkke's Avatar Member
    Reputation
    26
    Join Date
    Sep 2008
    Posts
    287
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    update items set requiredlevel = 80 where requiredlevel > 80;
    update characters set level = 80 where level > 80;
    update creature_proto set minlevel=80 where minlevel > 83;
    update creature_proto set maxlevel=80 where maxlevel > 83;

  3. #3
    controlsx2's Avatar Member
    Reputation
    16
    Join Date
    Jun 2007
    Posts
    223
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks they all work great! +rep

Similar Threads

  1. [How-To] Need some help making a private server
    By jeanke75 in forum MMO Exploits|Hacks
    Replies: 2
    Last Post: 09-22-2010, 11:39 AM
  2. [Help] Need some DB's and SQL files..
    By UnKnowN- in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 11-22-2007, 12:22 AM
  3. Could use some help making my server public.
    By Zonagle in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 09-18-2007, 07:51 PM
All times are GMT -5. The time now is 08:34 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