How to unlock all flight nodes in the DB (with SQL) menu

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to unlock all flight nodes in the DB (with SQL)

    its dam simple... just place this value:
    Code:
    4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295
    yes the entire thing that is between code tags!!!
    in the "Taximask" column in the characters table and all flight nodes will be unlocked

    It is the same value for Horde and Alliance so no problems

    Lots of people asked for this so i hope you are happy now

    edit here are some queries that might be usefull:
    Code:
    update characters set taximask = '4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295' where name like '%Latruwski%';
    Change latruwski to a other character name to give it all taxi nodes...
    note: if you only put partial name in it then all chars with that part in their names will have all taxi nodes unlocked!

    Code:
    update characters set taximask = '4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295';
    This query gives all texi nodes to all characters...

    Code:
    update characters set taximask = '4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295' where acct = (select acct from accounts where login like '%Latruwski%');
    Change latruwski to an account name to unlock all flight nodes on all characters on that account...


    enjoy
    Last edited by latruwski; 03-25-2008 at 05:50 PM.

    These ads disappear when you log in.

  2. #2
    V DeadlySins V's Avatar Member
    Reputation
    25
    Join Date
    Mar 2008
    Posts
    90
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    TY pertty nice

  3. #3
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Dragonforcex View Post
    TY pertty nice
    i tought this topic was dead but seems not ty for comment

  4. #4
    chaoticd35's Avatar Site Donator
    Reputation
    44
    Join Date
    Jun 2007
    Posts
    335
    Thanks G/R
    5/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    This is great!1 Thanks !!! +Rep

  5. #5
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by chaoticd35 View Post
    This is great!1 Thanks !!! +Rep

    I am glad you like it

  6. #6
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Giving this one last bump before i let it die

    queries added and i might make more ^^

  7. #7
    Ebon's Avatar Contributor
    Reputation
    218
    Join Date
    Sep 2007
    Posts
    604
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nice Latruwski!!!


  8. #8
    zztuf's Avatar Private
    Reputation
    11
    Join Date
    Apr 2007
    Posts
    12
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Very usefull +rep

  9. #9
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by zztuf View Post
    Very usefull +rep
    hehe glad it helped enjoy it

  10. #10
    xQzme?'s Avatar Master Sergeant
    Reputation
    14
    Join Date
    Oct 2007
    Posts
    80
    Thanks G/R
    1/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you mate +rep fo joo

  11. #11
    wefwef123's Avatar Sergeant
    Reputation
    1
    Join Date
    Jun 2008
    Posts
    69
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    How do you adjust your code to give it to all characters simulaneously? (without doing it one by one for every character)

    Also isnt there a way to do this when a player is created?

  12. #12
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by wefwef123 View Post
    How do you adjust your code to give it to all characters simulaneously? (without doing it one by one for every character)

    Also isnt there a way to do this when a player is created?

    Code:
    update characters set taximask = '4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295';
    gves flight nodes to all chars....
    you must edit core to make it for all players on char creation OR you could make navicat run that query every 10mins for example but then your DB needs refresh too i think.

    grtz

  13. #13
    wefwef123's Avatar Sergeant
    Reputation
    1
    Join Date
    Jun 2008
    Posts
    69
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have a better idea!
    Ill make a "Get all flightpaths" quest npc

    When I figure it out ill post it here

  14. #14
    latruwski's Avatar Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by wefwef123 View Post
    I have a better idea!
    Ill make a "Get all flightpaths" quest npc

    When I figure it out ill post it here
    that is a good idea

  15. #15
    TheSpidey's Avatar Elite User
    Reputation
    365
    Join Date
    Jan 2008
    Posts
    2,200
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You'd still have to use c++ for making this a quest reward :P

Page 1 of 2 12 LastLast

Similar Threads

  1. [Misc] How can i unlock all flyghts paths
    By gigicarnat in forum WoW EMU Questions & Requests
    Replies: 10
    Last Post: 07-10-2020, 11:05 AM
  2. How to piss of all Beta users on the World
    By lizu in forum World of Warcraft Guides
    Replies: 15
    Last Post: 04-09-2012, 02:27 AM
  3. how much y'all made from the corellia chests?
    By Xiandri in forum Star Wars: The Old Republic
    Replies: 12
    Last Post: 01-07-2012, 04:08 PM
  4. [Minor Exploit]All Flight paths unlocked
    By SilverFire in forum WoW EMU Exploits & Bugs
    Replies: 6
    Last Post: 07-28-2009, 03:04 AM
  5. how to get all the music filess off wow files
    By enis in forum WoW ME Questions and Requests
    Replies: 3
    Last Post: 02-10-2009, 04:30 AM
All times are GMT -5. The time now is 05:58 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2021 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search