SQL Querie Question! menu

User Tag List

Results 1 to 2 of 2
  1. #1
    meepy's Avatar Member
    Reputation
    1
    Join Date
    Dec 2007
    Posts
    40
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Querie Question!

    I want to update the Item_template set the BuyPrice to 0 from Npc_vendor where Entry is 180042 and the Item is Wild

    Any ideas?

    SQL Querie Question!
  2. #2
    Linkn's Avatar Contributor
    Reputation
    90
    Join Date
    Mar 2009
    Posts
    296
    Thanks G/R
    0/0
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You want to change the buy price? You could do this manually easily, find the item (entry 180042) scroll over and change buy price to 0. Remove the item from vendor then re-add it. I may have misunderstood the question so correct me if your attempting something different

Similar Threads

  1. SQL Query Addon
    By Jotox in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 06-14-2010, 04:57 PM
  2. ascent-logonserver.exe sql query error ... plz help
    By BillyBob31 in forum World of Warcraft Emulator Servers
    Replies: 10
    Last Post: 03-10-2008, 12:05 PM
  3. Sql Query
    By Sylex in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 03-01-2008, 03:09 AM
  4. Noob SQL file question.
    By foxfire in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 02-13-2008, 08:20 PM
  5. Warrior Stances SQL Query
    By toxic11b in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 12-18-2007, 07:35 PM
All times are GMT -5. The time now is 12:00 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