<?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 User Favorites: BmmB</title>
<link>http://forums.reaper-x.com/</link>
<description>Computer, Games, and Technology</description>
<language>en</language>
<pubDate>Sat, 20 Mar 2010 10:05:05 +0000</pubDate>

<item>
<title>BmmB on "Your character's reputation"</title>
<link>http://forums.reaper-x.com/topic/your-characters-reputation#post-4816</link>
<pubDate>Tue, 06 May 2008 07:02:17 +0000</pubDate>
<dc:creator>BmmB</dc:creator>
<guid isPermaLink="false">4816@http://forums.reaper-x.com/</guid>
<description><![CDATA[&#60;p&#62;Well, this was written for for mangos 5116 and corresponding databases. It is possible that database/tables format changed since then, but I don't know that (I'm not in wow and private servers for some time now). But, I don't think they would change characters database.&#60;br /&#62;
Check character table again closely. Columns should be (in this order): guid, account, data, name, race, ...&#60;br /&#62;
Data column is usually very long cause it contains a lot of numbers, and because of that you wouldn't see name column at first look. Scroll till you reach name column and then see the corresponding guid number.&#60;br /&#62;
All the above works if they didn't change character's table format.&#60;br /&#62;
If they did, then wait for someone else to answer your question or check on your database's web page.
&#60;/p&#62;]]></description>
</item>
<item>
<title>james123 on "Your character's reputation"</title>
<link>http://forums.reaper-x.com/topic/your-characters-reputation#post-4815</link>
<pubDate>Tue, 06 May 2008 05:39:08 +0000</pubDate>
<dc:creator>james123</dc:creator>
<guid isPermaLink="false">4815@http://forums.reaper-x.com/</guid>
<description><![CDATA[&#60;p&#62;How do I find out the GUID of a certain character? I go to the characters database and then to the character sub section but none of the characters are listed there so I can't find out the GUID.&#60;br /&#62;
Any ideas?
&#60;/p&#62;]]></description>
</item>
<item>
<title>BmmB on "Your character's reputation"</title>
<link>http://forums.reaper-x.com/topic/your-characters-reputation#post-3510</link>
<pubDate>Tue, 26 Feb 2008 19:18:58 +0000</pubDate>
<dc:creator>BmmB</dc:creator>
<guid isPermaLink="false">3510@http://forums.reaper-x.com/</guid>
<description><![CDATA[&#60;p&#62;Hi!&#60;/p&#62;
&#60;p&#62;There were a lot of people on GM commands' list page here, asking if there is a command to change character's reputation. So what I'm posting here is basically copy/paste (with some editing in between) of my answer I put there. I hope that this will be of some use to someone, so I’ll feel fine for not spending some time and efort for nothing…&#60;/p&#62;
&#60;p&#62;Since there is still no command for changing reputation (Reaper-X haven't included yet), I decided to post here instructions on how to change rep of your character hard way…&#60;/p&#62;
&#60;p&#62;NOTE:&#60;br /&#62;
for detailed info on changing reputation you should check web pages of database you use, for example projectsilvermoon.net for silvermoon database (but, AFAIK, both P:S DB and UDB have the same structure, so the following steppes would be the same for both databases); there can be found better info than provided here by me, but I, personally haven't checked&#60;/p&#62;
&#60;p&#62;1. you’ll need a database management tool, i.e. any program that can open and edit mysql databases - for example:&#60;br /&#62;
SQLyog, Navicat etc. I use EMS MySQL Manager Lite - it's excellent, I think it's better than both SQLyog and Navicat, and it's also free (at least this lite edition).&#60;/p&#62;
&#60;p&#62;2. then open character_reputation table from characters database; there are four columnes - guid (that is guid of you character; if you have more characters than in order to see which is which you can check table character from characters database where the first column is guid of character which name is in name column in the same table), faction (that is the id of faction), standing (this is the number that represents your actual reputation) and flags (I don’t know exactly what this is right now, but it is not really important, so we’ll skip it for now)&#60;/p&#62;
&#60;p&#62;3. you actually need to change number in standing column in order to change rep with faction (with coresponding id); list of faction ids is located lower in this post&#60;/p&#62;
&#60;p&#62;NOTE:&#60;br /&#62;
that list might need an update, but there are almost all if not all available factions&#60;/p&#62;
&#60;p&#62;4. usually, there are listed all important factions for your character so you should just check corresponding id and change number in standing column to one you want, otherwise you should just create new record and input data in these four columns; about reputation ranges :&#60;br /&#62;
- 0 is minimal neutral&#60;br /&#62;
- 42999 is max exalted&#60;br /&#62;
- -42000 is max hated&#60;br /&#62;
- standing can be any number between -42000 and 42999.&#60;br /&#62;
You can use ingame info about rep, for example:&#60;br /&#62;
ingame neutral is 0-3000, friendly 0-6000, honored 0-12000, …, exalted 0-1000(999) (if I remember correctly);&#60;br /&#62;
in database these numbers stacks up (previos adds to next one to form a value) and are (corresponding numbers in standing column for above reputation):&#60;br /&#62;
0-3000 for neutral, 3000-9000 for friendly, 9000-21000 for honored, …, 42000-42999 for exalted.&#60;br /&#62;
For hated etc. it's the same but in reverse (that means you need to apply negative values).&#60;/p&#62;
&#60;p&#62;About flags:&#60;br /&#62;
although they are not important for changing reputation, they do, however, have some special function;&#60;br /&#62;
I found out, as I mentioned in above post, that 3 is for in_war state (even 2 seems to be for in_war state, and 1 should be for friendly), but I don’t know, and actually don’t need to know, anything else, although I could make some guesses…&#60;br /&#62;
If someone is willing to find this out, feel free to post it for future reference…&#60;/p&#62;
&#60;p&#62;Also, it is very important: if there is a flag (other than 0) when you're applying your new rep, then you should change that flag to 0, just to avoid some strange situations (like being in war and being exalted at the same time). If you leave flag other than 0, then the value you input for rep will be lowered by value that flag represents. You shoulf always put 0 flag (for neutral, that is), so the value you put there is lowered by 0 (min for neutral) in that case i.e. stays the same.&#60;/p&#62;
&#60;p&#62;5. if there is no entry for faction you need to just make a new record and input your characters guid, faction id, standing reputation, and for flags you should 0, or if you want to be in war with that faction just put 3 (or 2) in flags column&#60;/p&#62;
&#60;p&#62;6. After applying reputation changes to your character you need to restart mangos for your changes to work&#60;/p&#62;
&#60;p&#62;7. you should note that if you haven't got in touch with coresponding faction yet, then you wouldn't see reputation bar in your character’s info in game, but anyway, your new rep will work. When you first time get in contact with that faction, that bar will show up.&#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;]]></description>
</item>

</channel>
</rss>
