<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
>

<channel>
<title>X-Forums Topic: To any SQL geinus</title>
<link>http://forums.reaper-x.com/</link>
<description>Computer, Games, and Technology</description>
<language>en</language>
<pubDate>Mon, 22 Mar 2010 13:42:12 +0000</pubDate>

<item>
<title>Wazzar on "To any SQL geinus"</title>
<link>http://forums.reaper-x.com/topic/to-any-sql-geinus#post-5233</link>
<pubDate>Fri, 30 May 2008 09:50:56 +0000</pubDate>
<dc:creator>Wazzar</dc:creator>
<guid isPermaLink="false">5233@http://forums.reaper-x.com/</guid>
<description><![CDATA[&#60;p&#62;If you can track down the OLD WoWEMU software most of these types of lists were pretty much textfiles anyway originally, only thing missing will be the latest expansion mobs &#38;#38; races etc.&#60;/p&#62;
&#60;p&#62;Used to be a lot of POI for portals around too that didn't drop you 500mts up in the sky or LIMBO (had three of those recently and had to delete the char LOL).&#60;/p&#62;
&#60;p&#62;Wazzar
&#60;/p&#62;]]></description>
</item>
<item>
<title>norrisguy on "To any SQL geinus"</title>
<link>http://forums.reaper-x.com/topic/to-any-sql-geinus#post-5193</link>
<pubDate>Thu, 29 May 2008 08:02:39 +0000</pubDate>
<dc:creator>norrisguy</dc:creator>
<guid isPermaLink="false">5193@http://forums.reaper-x.com/</guid>
<description><![CDATA[&#60;p&#62;i kinda did what i wanted, i used DBC tool to view the faction.dbc and found the ID of Syndicate (87) then i used .npc faction 87, to change the faction of my custom npc's, then just created a guild called Syndicate, so its pretty much what i wanted. thanks again
&#60;/p&#62;]]></description>
</item>
<item>
<title>norrisguy on "To any SQL geinus"</title>
<link>http://forums.reaper-x.com/topic/to-any-sql-geinus#post-5192</link>
<pubDate>Thu, 29 May 2008 03:30:23 +0000</pubDate>
<dc:creator>norrisguy</dc:creator>
<guid isPermaLink="false">5192@http://forums.reaper-x.com/</guid>
<description><![CDATA[&#60;p&#62;wow, great post Phen! i sure appreciate it, i know about .lookup faction, but this will be much quicker.  Do you know if i can mod a faction to rename one?&#60;/p&#62;
&#60;p&#62;i also have navicat but i cant figure out how to export a table, could you let me know where that fuction is located in the interface?&#60;/p&#62;
&#60;p&#62;thanks
&#60;/p&#62;]]></description>
</item>
<item>
<title>Phen on "To any SQL geinus"</title>
<link>http://forums.reaper-x.com/topic/to-any-sql-geinus#post-5189</link>
<pubDate>Wed, 28 May 2008 23:43:59 +0000</pubDate>
<dc:creator>Phen</dc:creator>
<guid isPermaLink="false">5189@http://forums.reaper-x.com/</guid>
<description><![CDATA[&#60;p&#62;I use Navicat to extract tables from the database. It has an export function, very neat.&#60;/p&#62;
&#60;p&#62;There was no list of faction IDs (in regards to what they represent) that I could find in the DB yet, but recently helpful people posted links of interest. (I lost the links, so I will post the list I saved.)&#60;/p&#62;
&#60;p&#62;In any event, you can lookup faction names from inside the game:&#60;br /&#62;
.lookup faction NAME&#60;/p&#62;
&#60;p&#62;So, without guarantee that the IDs are correct, here's the list:&#60;/p&#62;
&#60;p&#62;faction ids:&#60;br /&#62;
=============&#60;br /&#62;
1 PLAYER, Human&#60;br /&#62;
2 PLAYER, Orc&#60;br /&#62;
3 PLAYER, Dwarf&#60;br /&#62;
4 PLAYER, Night Elf&#60;br /&#62;
5 PLAYER, Undead&#60;br /&#62;
6 PLAYER, Tauren&#60;br /&#62;
7 Creature&#60;br /&#62;
8 PLAYER, Gnome&#60;br /&#62;
9 PLAYER, Troll&#60;br /&#62;
14 Monster&#60;br /&#62;
15 Defias Brotherhood&#60;br /&#62;
16 Gnoll Riverpaw&#60;br /&#62;
17 Gnoll Redridge&#60;br /&#62;
18 Gnoll Shadowhide&#60;br /&#62;
19 Murloc&#60;br /&#62;
20 Undead, Scourge&#60;br /&#62;
21 Booty Bay&#60;br /&#62;
22 Beast Spider&#60;br /&#62;
23 Beast Boar&#60;br /&#62;
24 Worgen&#60;br /&#62;
25 Kobold&#60;br /&#62;
26 Troll, Bloodscalp&#60;br /&#62;
27 Troll, Skullsplitter&#60;br /&#62;
28 Prey&#60;br /&#62;
29 Beast Wolf&#60;br /&#62;
30 Defias Brotherhood Traitor&#60;br /&#62;
31 Friendly&#60;br /&#62;
32 Trogg&#60;br /&#62;
33 Troll, Frostmane&#60;br /&#62;
34 Orc, Blackrock&#60;br /&#62;
35 Villian&#60;br /&#62;
36 Victim&#60;br /&#62;
37 Beast Bear&#60;br /&#62;
38 Ogre&#60;br /&#62;
39 Kurzen's Mercenaries&#60;br /&#62;
40 Escortee&#60;br /&#62;
41 Venture Company&#60;br /&#62;
42 Beast Raptor&#60;br /&#62;
43 Basilisk&#60;br /&#62;
44 Dragonflight, Green&#60;br /&#62;
45 Lost Ones&#60;br /&#62;
46 Blacksmithing Armorsmithing&#60;br /&#62;
47 Ironforge&#60;br /&#62;
48 Dark Iron Dwarves&#60;br /&#62;
49 Human, Night Watch&#60;br /&#62;
50 Dragonflight, Red&#60;br /&#62;
51 Gnoll Mosshide&#60;br /&#62;
52 Orc, Dragonmaw&#60;br /&#62;
53 Gnome Leper&#60;br /&#62;
54 Gnomeregan Exiles&#60;br /&#62;
55 Leopard&#60;br /&#62;
56 Scarlet Crusade&#60;br /&#62;
57 Gnoll Rothide&#60;br /&#62;
58 Beast Gorilla&#60;br /&#62;
59 Thorium Brotherhood&#60;br /&#62;
60 Naga&#60;br /&#62;
61 Dalaran&#60;br /&#62;
62 Forlorn Spirit&#60;br /&#62;
63 Darkhowl&#60;br /&#62;
64 Grell&#60;br /&#62;
65 Furbolg&#60;br /&#62;
66 Horde Generic&#60;br /&#62;
67 Horde&#60;br /&#62;
68 Undercity&#60;br /&#62;
69 Darnassus&#60;br /&#62;
70 Syndicate&#60;br /&#62;
71 Hillsbrad Militia&#60;br /&#62;
72 Stormwind&#60;br /&#62;
73 Demon&#60;br /&#62;
74 Elemental&#60;br /&#62;
75 Spirit&#60;br /&#62;
76 Orgrimmar&#60;br /&#62;
77 Treasure&#60;br /&#62;
78 Gnoll Mudsnout&#60;br /&#62;
79 HIllsbrad, Southshore Mayor&#60;br /&#62;
80 Dragonflight, Black&#60;br /&#62;
81 Thunder Bluff&#60;br /&#62;
82 Troll, Witherbark&#60;br /&#62;
83 Leatherworking Elemental&#60;br /&#62;
84 Quilboar, Razormane&#60;br /&#62;
85 Quilboar, Bristleback&#60;br /&#62;
86 Leatherworking Dragonscale&#60;br /&#62;
87 Bloodsail Buccaneers&#60;br /&#62;
88 Blackfathom&#60;br /&#62;
89 Makrura&#60;br /&#62;
90 Centaur, Kolkar&#60;br /&#62;
91 Centaur, Galak&#60;br /&#62;
92 Gelkis Clan Centaur&#60;br /&#62;
93 Magram Clan Centaur&#60;br /&#62;
94 Maraudine&#60;br /&#62;
108 Theramore&#60;br /&#62;
109 Quilboar, Razorfen&#60;br /&#62;
110 Quilboar, Razormane&#60;br /&#62;
111 Quilboar, Deathshead&#60;br /&#62;
128 Enemy&#60;br /&#62;
148 Ambient&#60;br /&#62;
168 Nethergarde Caravan&#60;br /&#62;
169 Steamwheedle Cartel&#60;br /&#62;
189 Alliance Generic&#60;br /&#62;
209 Nethergarde&#60;br /&#62;
229 Wailing Caverns&#60;br /&#62;
249 Silithid&#60;br /&#62;
269 Silvermoon Remnant&#60;br /&#62;
270 Zandalar Tribe&#60;br /&#62;
289 Blacksmithing Weaponsmithing&#60;br /&#62;
309 Scorpid&#60;br /&#62;
310 Beast Bat&#60;br /&#62;
311 Titan&#60;br /&#62;
329 Taskmaster Fizzule&#60;br /&#62;
349 Ravenholdt&#60;br /&#62;
369 Gadgetzan&#60;br /&#62;
389 Gnomeregan Bug&#60;br /&#62;
409 Harpy&#60;br /&#62;
429 Burning Blade&#60;br /&#62;
449 Shadowsilk Poacher&#60;br /&#62;
450 Searing Spider&#60;br /&#62;
469 Alliance&#60;br /&#62;
470 Ratchet&#60;br /&#62;
471 Wildhammer Clan&#60;br /&#62;
489 Goblin, Dark Iron Bar Patron&#60;br /&#62;
509 The League of Arathor&#60;br /&#62;
510 The Defilers&#60;br /&#62;
511 Giant&#60;br /&#62;
529 Argent Dawn&#60;br /&#62;
530 Darkspear Trolls&#60;br /&#62;
531 Dragonflight, Bronze&#60;br /&#62;
532 Dragonflight, Blue&#60;br /&#62;
549 Leatherworking Tribal&#60;br /&#62;
550 Engineering Goblin&#60;br /&#62;
551 Engineering Gnome&#60;br /&#62;
569 Blacksmithing Hammersmithing&#60;br /&#62;
570 Blacksmithing Axesmithing&#60;br /&#62;
571 Blacksmithing Swordsmithing&#60;br /&#62;
572 Troll, Vilebranch&#60;br /&#62;
573 Southsea Freebooters&#60;br /&#62;
574 Caer Darrow&#60;br /&#62;
575 Furbolg, Uncorrupted&#60;br /&#62;
576 Timbermaw Hold&#60;br /&#62;
577 Everlook&#60;br /&#62;
589 Wintersaber Trainers&#60;br /&#62;
609 Cenarion Circle&#60;br /&#62;
629 Shatterspear Trolls&#60;br /&#62;
630 Ravasaur Trainers&#60;br /&#62;
649 Majordomo Executus&#60;br /&#62;
669 Beast Carrion Bird&#60;br /&#62;
670 Beast Cat&#60;br /&#62;
671 Beast Crab&#60;br /&#62;
672 Beast Crocilisk&#60;br /&#62;
673 Beast Hyena&#60;br /&#62;
674 Beast Owl&#60;br /&#62;
675 Beast Scorpid&#60;br /&#62;
676 Beast Tallstrider&#60;br /&#62;
677 Beast Turtle&#60;br /&#62;
678 Beast Wind Serpent&#60;br /&#62;
679 Training Dummy&#60;br /&#62;
689 Dragonflight, Black Bait&#60;br /&#62;
709 Battleground Neutral&#60;br /&#62;
729 Frostwolf Clan&#60;br /&#62;
730 Stormpike Guard&#60;br /&#62;
749 Hydraxian Waterlords&#60;br /&#62;
750 Sulfuron Firelords&#60;br /&#62;
769 Gizlock's Dummy&#60;br /&#62;
770 Gizlock's Charm&#60;br /&#62;
771 Gizlock&#60;br /&#62;
789 Moro'gai&#60;br /&#62;
790 Spirit Guide Alliance&#60;br /&#62;
809 Shen'dralar&#60;br /&#62;
829 Ogre (Captain Kromcrush)&#60;br /&#62;
849 Spirit Guide Horde&#60;br /&#62;
869 Jaedenar&#60;br /&#62;
889 Warsong Outriders&#60;br /&#62;
890 Silverwing Sentinels&#60;br /&#62;
891 Alliance Forces&#60;br /&#62;
892 Horde Forces&#60;br /&#62;
893 Revantusk Trolls&#60;br /&#62;
909 Darkmoon Faire&#60;br /&#62;
910 Brood of Nozdormu&#60;br /&#62;
911 Silvermoon City&#60;br /&#62;
912 Might of Kalimdor&#60;br /&#62;
914 PLAYER, Blood Elf&#60;br /&#62;
915 Armies of C'Thun&#60;br /&#62;
916 Silithid Attackers&#60;br /&#62;
917 The Ironforge Brigade&#60;br /&#62;
918 RC Enemies&#60;br /&#62;
919 RC Objects&#60;br /&#62;
920 Red&#60;br /&#62;
921 Blue&#60;br /&#62;
922 Tranquillien&#60;br /&#62;
923 Farstriders&#60;br /&#62;
924 DEPRECATED&#60;br /&#62;
925 Sunstriders&#60;br /&#62;
926 Magister's Guild&#60;br /&#62;
927 PLAYER, Draenei&#60;br /&#62;
928 Scourge Invaders&#60;br /&#62;
929 Bloodmaul Clan&#60;br /&#62;
930 Exodar&#60;br /&#62;
931 Test Faction (not a real faction)&#60;br /&#62;
932 The Aldor&#60;br /&#62;
933 The Consortium&#60;br /&#62;
934 The Scryers&#60;br /&#62;
935 The Sha'tar&#60;br /&#62;
936 Shattrath City&#60;br /&#62;
937 Troll, Forest&#60;br /&#62;
938 The Omenai&#60;br /&#62;
939 DEPRECATED&#60;br /&#62;
940 The Sons of Lothar&#60;br /&#62;
941 The Mag'har&#60;br /&#62;
942 Cenarion Expedition&#60;br /&#62;
943 Fel Orc&#60;br /&#62;
944 Fel Orc Ghost&#60;br /&#62;
945 Sons of Lothar Ghosts&#60;br /&#62;
946 Honor Hold&#60;br /&#62;
947 Thrallmar&#60;br /&#62;
948 Test Faction 2&#60;br /&#62;
949 Test Faction 1&#60;br /&#62;
950 ToWoW Flag&#60;br /&#62;
951 ToWoW Flag Trigger Alliance (DND)&#60;br /&#62;
952 Test Faction 3&#60;br /&#62;
953 Test Faction 4&#60;br /&#62;
954 ToWoW Flag Trigger Horde (DND)&#60;br /&#62;
955 Broken&#60;br /&#62;
956 Ethereum&#60;br /&#62;
957 Earth Elemental&#60;br /&#62;
958 Fighting Robots&#60;br /&#62;
959 Actor Good&#60;br /&#62;
960 Actor Evil&#60;br /&#62;
961 Stillpine Furbolg&#60;br /&#62;
962 Crazed Owlkin&#60;br /&#62;
963 Chess Alliance&#60;br /&#62;
964 Chess Horde&#60;br /&#62;
965 Monster Spar&#60;br /&#62;
966 Monster Spar Buddy&#60;br /&#62;
967 The Violet Eye&#60;br /&#62;
968 Sunhawks&#60;br /&#62;
969 Hand of Argus&#60;br /&#62;
970 Sporeggar&#60;br /&#62;
971 Fungal Giant&#60;br /&#62;
972 Spore Bat&#60;br /&#62;
973 Monster, Predator&#60;br /&#62;
974 Monster, Prey&#60;br /&#62;
975 Void Anomaly&#60;br /&#62;
976 Hyjal Defenders&#60;br /&#62;
977 Hyjal Invaders&#60;br /&#62;
978 Kurenai&#60;br /&#62;
979 Earthen Ring&#60;br /&#62;
980 Outland&#60;br /&#62;
981 Arakkoa&#60;br /&#62;
982 Zangarmarsh Banner (Alliance)&#60;br /&#62;
983 Zangarmarsh Banner (Horde)&#60;br /&#62;
984 Zangarmarsh Banner (Neutral)&#60;br /&#62;
985 Caverns of Time Thrall&#60;br /&#62;
986 Caverns of Time Durnholde&#60;br /&#62;
987 Caverns of Time Southshore Guards&#60;br /&#62;
988 Shadow Council Covert&#60;br /&#62;
989 Keepers of Time&#60;br /&#62;
990 The Scale of the Sands&#60;br /&#62;
991 Dark Portal Defender, Alliance&#60;br /&#62;
992 Dark Portal Defender, Horde&#60;br /&#62;
993 Dark Portal Attacker, Legion&#60;br /&#62;
994 Inciter Trigger&#60;br /&#62;
995 Inciter Trigger 2&#60;br /&#62;
996 Inciter Trigger 3&#60;br /&#62;
997 Inciter Trigger 4&#60;br /&#62;
998 Inciter Trigger 5&#60;br /&#62;
999 Mana Creature&#60;br /&#62;
1000 Khadgar's Servant&#60;br /&#62;
1001 Bladespire Clan&#60;br /&#62;
1002 Ethereum Sparbuddy&#60;br /&#62;
1003 Protectorate&#60;br /&#62;
1004 Arcane Annihilator (DNR)&#60;br /&#62;
1005 Friendly, Hidden&#60;br /&#62;
1006 Kirin'Var Dathric&#60;br /&#62;
1007 Kirin'Var Belmara&#60;br /&#62;
1008 Kirin'Var Luminrath&#60;br /&#62;
1009 Kirin'Var Cohlien&#60;br /&#62;
1010 Servant of Illidan&#60;br /&#62;
1011 Lower City&#60;br /&#62;
1012 Ashtongue Deathsworn&#60;br /&#62;
1013 Spirits of Shadowmoon 1&#60;br /&#62;
1014 Spirits of Shadowmoon 2&#60;br /&#62;
1015 Netherwing&#60;br /&#62;
1016 Wyrmcult&#60;br /&#62;
1017 Treant&#60;br /&#62;
1018 Leotheras Demon I&#60;br /&#62;
1019 Leotheras Demon II&#60;br /&#62;
1020 Leotheras Demon III&#60;br /&#62;
1021 Leotheras Demon IV&#60;br /&#62;
1022 Leotheras Demon V&#60;br /&#62;
1023 Azaloth&#60;br /&#62;
1024 Rock Flayer&#60;br /&#62;
1025 Flayer Hunter&#60;br /&#62;
1026 Shadowmoon Shade&#60;br /&#62;
1027 Legion Communicator&#60;br /&#62;
1028 Ravenswood Ancients&#60;br /&#62;
1029 Chess, Friendly to All Chess&#60;br /&#62;
1030 Black Temple Gates Illidari&#60;br /&#62;
1031 Sha'tari Skyguard&#60;br /&#62;
1032 Area 52&#60;br /&#62;
1033 Maiev&#60;br /&#62;
1034 Skettis Shadowy Arakkoa&#60;br /&#62;
1035 Skettis Arakkoa&#60;br /&#62;
1036 Dragonmaw Enemy&#60;br /&#62;
1037 REUSE&#60;br /&#62;
1038 Ogri'la&#60;br /&#62;
1039 Ravager&#60;br /&#62;
1040 REUSE&#60;br /&#62;
1041 Frenzy&#60;br /&#62;
1042 Skyguard Enemy&#60;br /&#62;
1043 Skunk, Petunia&#60;/p&#62;
&#60;p&#62;It's probably a little old; I am sure factions have been added since then. ^^
&#60;/p&#62;]]></description>
</item>
<item>
<title>norrisguy on "To any SQL geinus"</title>
<link>http://forums.reaper-x.com/topic/to-any-sql-geinus#post-5179</link>
<pubDate>Wed, 28 May 2008 07:18:53 +0000</pubDate>
<dc:creator>norrisguy</dc:creator>
<guid isPermaLink="false">5179@http://forums.reaper-x.com/</guid>
<description><![CDATA[&#60;p&#62;Im curious about how to extract the different SQL files in the DB.  I know that the GM command list is extracted as well as some others ive seen.  Im looking for a list of faction ID's mainly.  &#60;/p&#62;
&#60;p&#62;One thing I would really be stoked about is creating my own faction, anyone with any knowledge on this would be my hero for the day.&#60;/p&#62;
&#60;p&#62;thanks
&#60;/p&#62;]]></description>
</item>

</channel>
</rss>
