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

[latruwski]

its dam simple... just place this value:

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:

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!

update characters set taximask = '4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295 4294967295';

This query gives all texi nodes to all characters...

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

[V DeadlySins V]

TY pertty nice

[latruwski]

TY pertty nice

i tought this topic was dead but seems not ty for comment

[chaoticd35]

This is great!1 Thanks !!! +Rep

[latruwski]

This is great!1 Thanks !!! +Rep

I am glad you like it

[latruwski]

Giving this one last bump before i let it die

queries added and i might make more ^^

[Ebon]

Nice Latruwski!!!

[zztuf]

Very usefull +rep

[latruwski]

Very usefull +rep

hehe glad it helped enjoy it

[xQzme?]

Thank you mate +rep fo joo

[wefwef123]

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?

[latruwski]

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?

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

[wefwef123]

I have a better idea!
Ill make a "Get all flightpaths" quest npc

When I figure it out ill post it here

[latruwski]

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

[TheSpidey]

You'd still have to use c++ for making this a quest reward :P