Alliance bloodelf?

[fuzzles22]

Im playing as a bloodelf but I need to know is there a way to make it alliance friendly? I use arcemu. using 3.3.5 grim repack. ive tried .mod faction and 1 and I go to stormwind and still get slaughtered.

[Terrorblade]

If you do

UPDATE `playercreateinfo` SET `factiontemplate`=1629 WHERE `race`=10;

create a new blood elf then all blood elves will be alliance. Or you can do

UPDATE `characters` SET `reputation`='21,0,500,500,46,0,0,0,47,0,3100,3100,54,0,3100,3100,59,0,0,0,67,2,-42000,-42000,68,2,-42000,-42000,69,0,3100,3100,70,2,-10000,-10000,72,0,4000,4000,76,2,-42000,-42000,81,2,-42000,-42000,83,0,2999,2999,86,0,2999,2999,87,2,-6500,-6500,92,0,2000,2000,93,0,2000,2000,169,0,500,500,270,0,0,0,289,0,0,0,349,0,0,0,369,0,500,500,469,0,3300,3300,470,0,500,500,471,0,150,150,509,0,0,0,510,2,-42000,-42000,529,0,200,200,530,2,-42000,-42000,549,0,2999,2999,550,0,2999,2999,551,0,2999,2999,569,0,0,0,570,0,0,0,571,0,0,0,574,0,0,0,576,2,-3500,-3500,577,0,500,500,589,0,0,0,609,0,0,0,729,2,-42000,-42000,730,0,0,0,749,0,0,0,809,0,0,0,889,2,-42000,-42000,890,0,0,0,891,0,0,0,892,2,-42000,-42000,909,0,0,0,910,2,-42000,-42000,911,2,-42000,-42000,922,2,-42000,-42000,930,0,3000,3000,932,0,0,0,933,0,0,0,934,0,0,0,935,0,0,0,936,0,0,0,941,2,-42000,-42000,942,0,0,0,946,0,0,0,947,2,-42000,-42000,948,0,0,0,949,0,0,0,952,0,0,0,967,0,0,0,970,0,-2500,-2500,978,0,-1200,-1200,989,0,0,0,990,0,0,0,1005,0,3000,3000,1011,0,0,0,1012,0,0,0,1015,2,-42000,-42000,1031,0,0,0,1037,0,0,0,1038,0,0,0,1050,0,0,0,1052,2,-42000,-42000,1064,2,-42000,-42000,1067,2,-42000,-42000,1068,0,0,0,1073,0,0,0,1077,0,0,0,1082,0,0,0,1085,2,-42000,-42000,1090,0,0,0,1091,0,0,0,1094,0,0,0,1104,0,0,0,1105,0,0,0,1106,0,0,0,1117,0,0,0,1118,0,0,0,1119,2,-42000,-42000,1124,2,-42000,-42000,1126,0,0,0,1136,0,0,0,1137,0,0,0,1154,0,0,0,1155,0,0,0,1156,0,0,0,' WHERE `guid`=(Your char guid);

[fuzzles22]

I tried that, used heidisql to execute the quest. went in game, ported to stormwind. got killed instantly.

[Terrorblade]

I tried that, used heidisql to execute the quest. went in game, ported to stormwind. got killed instantly.

If you used the second query, you usually have to restart the realm for it to take effect.

[fuzzles22]

ok that kind of worked but I still cant shop there nor speak to anyone

[stoneharry]

Isn't there a 'custom faction' column in the characters table?

Anyway, changing the players faction to 1 will make them alliance, 2 is for horde. 35 is friendly to all, but you won't be able to PvP/inspect/duel and so on without core edits.#

Tag your threads in future!

[Verosk]

if ingame you make the vendors/npcs apart from guards .npc faction 35

Thats a neautral faction for anyone to use dont putthis for the guards.