faq / truice Goto Github PK
View Code? Open in Web Editor NEWTruice is a database editor specifically for Trinity.
Truice is a database editor specifically for Trinity.
Based on http://www.trinitycore.info/Creature_template_tc2#npcflag
0;Gossip
1;Quest Giver
2;UNK1
3;UNK2
4;Trainer
5;Class Trainer
6;Profession Trainer
7;Vendor
8;Vendor Ammo
9;Vendor Food
10;Vendor Poison
11;Vendor Reagent
12;Repairer
13;Flight Master
14;Spirit Healer
15;Spirit Guide
16;Innkeeper
17;Banker
18;Petitioner
19;Tabard Designer
20;Battlemaster
21;Auctioneer
22;Stable Master
23;Guild Banker
24;Spellclick
25;UNK3 (PLAYER_VEHICLE?) (players with mounts that have vehicle data should have it set)
26;Mailbox
27;UNK4 (OUTDOORPVP?)
http://www.trinitycore.info/Quest_template_tc2#Flags
1;STAY_ALIVE
2;PARTY_ACCEPT
3;EXPLORATION
4;SHARABLE
5;NONE2 (Unknown)
6;EPIC
7;RAID
8;TBC
9;DELIVER_MORE
10;HIDDEN_REWARDS
11;AUTO_REWARDED
12;TBC_RACES
13;DAILY
14;REPEATABLE
15;UNAVAILABLE
16;WEEKLY
17;AUTOCOMPLETE
18;SPECIAL_ITEM
19;OBJ_TEXT
20;AUTO_ACCEPT
0;None
6;Frost
8;Fire
26;Arms
38;Combat
39;Subtlety
43;Swords
44;Axes
45;Bows
46;Guns
50;Beast Mastery
51;Survival
54;Maces
55;Two-Handed Swords
56;Holy
78;Shadow Magic
95;Defense
98;Language: Common
101;Dwarven Racial
109;Language: Orcish
111;Language: Dwarven
113;Language: Darnassian
115;Language: Taurahe
118;Dual Wield
124;Tauren Racial
125;Orc Racial
126;Night Elf Racial
129;First Aid
134;Feral Combat
136;Staves
137;Language: Thalassian
138;Language: Draconic
139;Language: Demon Tongue
140;Language: Titan
141;Language: Old Tongue
142;Survival
148;Horse Riding
149;Wolf Riding
150;Tiger Riding
152;Ram Riding
155;Swimming
160;Two-Handed Maces
162;Unarmed
163;Marksmanship
164;Blacksmithing
165;Leatherworking
171;Alchemy
172;Two-Handed Axes
173;Daggers
176;Thrown
182;Herbalism
183;GENERIC (DND)
184;Retribution
185;Cooking
186;Mining
188;Pet - Imp
189;Pet - Felhunter
197;Tailoring
202;Engineering
203;Pet - Spider
204;Pet - Voidwalker
205;Pet - Succubus
206;Pet - Infernal
207;Pet - Doomguard
208;Pet - Wolf
209;Pet - Cat
210;Pet - Bear
211;Pet - Boar
212;Pet - Crocolisk
213;Pet - Carrion Bird
214;Pet - Crab
215;Pet - Gorilla
217;Pet - Raptor
218;Pet - Tallstrider
220;Racial - Undead
226;Crossbows
228;Wands
229;Polearms
236;Pet - Scorpid
237;Arcane
251;Pet - Turtle
253;Assassination
256;Fury
257;Protection
267;Protection
270;Pet - Generic Hunter
293;Plate Mail
313;Language: Gnomish
315;Language: Troll
333;Enchanting
354;Demonology
355;Affliction
356;Fishing
373;Enhancement
374;Restoration
375;Elemental Combat
393;Skinning
413;Mail
414;Leather
415;Cloth
433;Shield
473;Fist Weapons
533;Raptor Riding
553;Mechanostrider Piloting
554;Undead Horsemanship
573;Restoration
574;Balance
593;Destruction
594;Holy
613;Discipline
633;Lockpicking
653;Pet - Bat
654;Pet - Hyena
655;Pet - Bird of Prey
656;Pet - Wind Serpent
673;Language: Gutterspeak
713;Kodo Riding
733;Racial - Troll
753;Racial - Gnome
754;Racial - Human
755;Jewelcrafting
756;Blood Elf Racial
758;Pet - Event - Remote Control
759;Language: Draenei
760;Draenei Racial
761;Pet - Felguard
762;Riding
763;Pet - Dragonhawk
764;Pet - Nether Ray
765;Pet - Sporebat
766;Pet - Warp Stalker
767;Pet - Ravager
768;Pet - Serpent
769;Internal
770;DK Blood
771;DK Frost
772;DK Unholy
773;Inscription
775;Pet - Moth
776;Runeforging
777;Mounts
778;Companions
780;Pet - Exotic Chimaera
781;Pet - Exotic Devlisaur
782;Pet - Ghoul
783;Pet - Exotic Silithid
784;Pet - Exotic Worm
785;Pet - Wasp
786;Pet - Exotic Rhino
787;Pet - Exotic Core Hound
788;Pet - Exotic Spirit Beast
P.S. The changes are correcting DBC errors.
Please upload latest compiled version, thanks for your time.
I try download precompiled 1.3.9 and links are broken
The button drop-dawn menu dimensions needs to be corrected.
There are a few extra symbols at the end of Default.lng file that probably aren't needed.
In TDB's item_template
there is a field named flagsCustom
that's missing in Truice.
If possible could you add it, for more info: http://www.trinitycore.info/Item_template_tc2#flagsCustom
Hey,
what you think add two tab for select characters or account table for manage this tables
i mean add gold or ban account and etc...
I can search now but i i choose the quest it tells me:
Unknow column 'entry' in where clause.
Thanks for help, fixing and for you nice work
Missing HoverHeight Table in Truice
If possible can you make Truice use " instead of ' for the text fields in the SQL code it generates and replace the spaces between the field names (', ' to ',').
Hi there, I check out this post
And this one
And i am still not able to connect truice to my database.
Error: Unknown MySQL server host 'localhost' (11001)
Trinity compile server works, I can connect to db with Heidisql, I have I have MV C++ 2010, and NET Framework 4.5. I had my server running in an old computer (windows 7 64 bit) and was moving everything to this new one (wich sadly has Windows 8 64 bits). And I get everything working except Truice. I have tried to filling manually in the db the server name, root and tried changing the pasword (in the mysql tab in DB with heidisql). Then restarting copy pasting pasword username... and nothing...
I am new to all this, and have been using with no problem truice in the past (1.37) can anyone help me here?
Thanks!
Based on http://www.trinitycore.info/Gameobject_template_tc2#flags
0;IN_USE (Disables interaction while being animated)
1;LOCKED (Requires a key, spell, or event to be opened)
2;INTERACT_COND (Untargetable, cannot interact)
3;TRANSPORT (GO can transport - boat, elevator, car)
4;NOT_SELECTABLE (Not even in GM-mode)
5;NODESPAWN (Typically for doors, they just change state)
6;DAMAGED (GO has been siege damaged)
7;DESTROYED (GO has been destroyed)
P.S. Is there a way to verify that TRIGGERED isn't used in TC for GO's?
When I try to look up a quest in the search tab, I get this message:
SQL Error: Unknown column lq.entry
in on clause
I have the latest version so not sure if its something I am doing wrong or what. Please let me know. I like this program and would like to help if I can.
when you press that button you will get error about entry
column
Fix chaosua@b7cb1e5
As of Commit #9394dc1 from TrinityCore, Gameobjects_scripts is no longer existing. Thus, you can find a frequent error displaying whenever you look a gameobject up. This is a mediocre problem, as you can still edit gameobjects (1.3.5 works, didn't test 1.3.6 yet), but it may be worth to check it.
Hi Faq and good job with continuing with Truice, I really appreciate this tool.
You probably already know but the extended cost ids of this file are missing all cataclysm entries, anyways I could replace the csv file with Quice one, but still doesn't convince me that it's flawless, some entries don't match. I hope it can be solved soon.
SAI_ActionType.csv:
0;SMART_ACTION_NONE
1;SMART_ACTION_TALK
2;SMART_ACTION_SET_FACTION
3;SMART_ACTION_MORPH_TO_ENTRY_OR_MODEL
4;SMART_ACTION_SOUND
5;SMART_ACTION_PLAY_EMOTE
6;SMART_ACTION_FAIL_QUEST
7;SMART_ACTION_ADD_QUEST
8;SMART_ACTION_SET_REACT_STATE
9;SMART_ACTION_ACTIVATE_GOBJECT
10;SMART_ACTION_RANDOM_EMOTE
11;SMART_ACTION_CAST
12;SMART_ACTION_SUMMON_CREATURE
13;SMART_ACTION_THREAT_SINGLE_PCT
14;SMART_ACTION_THREAT_ALL_PCT
15;SMART_ACTION_CALL_AREAEXPLOREDOREVENTHAPPENS
16;SMART_ACTION_SEND_CASTCREATUREORGO
17;SMART_ACTION_SET_EMOTE_STATE
18;SMART_ACTION_SET_UNIT_FLAG
19;SMART_ACTION_REMOVE_UNIT_FLAG
20;SMART_ACTION_AUTO_ATTACK
21;SMART_ACTION_ALLOW_COMBAT_MOVEMENT
22;SMART_ACTION_SET_EVENT_PHASE
23;SMART_ACTION_INC_EVENT_PHASE
24;SMART_ACTION_EVADE
25;SMART_ACTION_FLEE_FOR_ASSIST
26;SMART_ACTION_CALL_GROUPEVENTHAPPENS
27;SMART_ACTION_CALL_CASTEDCREATUREORGO
28;SMART_ACTION_REMOVEAURASFROMSPELL
29;SMART_ACTION_FOLLOW
30;SMART_ACTION_RANDOM_PHASE
31;SMART_ACTION_RANDOM_PHASE_RANGE
32;SMART_ACTION_RESET_GOBJECT
33;SMART_ACTION_CALL_KILLEDMONSTER
34;SMART_ACTION_SET_INST_DATA
35;SMART_ACTION_SET_INST_DATA64
36;SMART_ACTION_UPDATE_TEMPLATE
37;SMART_ACTION_DIE
38;SMART_ACTION_SET_IN_COMBAT_WITH_ZONE
39;SMART_ACTION_CALL_FOR_HELP
40;SMART_ACTION_SET_SHEATH
41;SMART_ACTION_FORCE_DESPAWN
42;SMART_ACTION_SET_INVINCIBILITY_HP_LEVEL
43;SMART_ACTION_MOUNT_TO_ENTRY_OR_MODEL
44;SMART_ACTION_SET_INGAME_PHASE_MASK
45;SMART_ACTION_SET_DATA
46;SMART_ACTION_MOVE_FORWARD
47;SMART_ACTION_SET_VISIBILITY
48;SMART_ACTION_SET_ACTIVE
49;SMART_ACTION_ATTACK_START
50;SMART_ACTION_SUMMON_GO
51;SMART_ACTION_KILL_UNIT
52;SMART_ACTION_ACTIVATE_TAXI
53;SMART_ACTION_WP_START
54;SMART_ACTION_WP_PAUSE
55;SMART_ACTION_WP_STOP
56;SMART_ACTION_ADD_ITEM
57;SMART_ACTION_REMOVE_ITEM
58;SMART_ACTION_INSTALL_AI_TEMPLATE
59;SMART_ACTION_SET_RUN
60;SMART_ACTION_SET_FLY
61;SMART_ACTION_SET_SWIMM
62;SMART_ACTION_TELEPORT
63;SMART_ACTION_STORE_VARIABLE_DECIMAL
64;SMART_ACTION_STORE_TARGET_LIST
65;SMART_ACTION_WP_RESUME
66;SMART_ACTION_SET_ORIENTATION
67;SMART_ACTION_CREATE_TIMED_EVENT
68;SMART_ACTION_PLAYMOVIE
69;SMART_ACTION_MOVE_TO_POS
70;SMART_ACTION_RESPAWN_TARGET
71;SMART_ACTION_EQUIP
72;SMART_ACTION_CLOSE_GOSSIP
73;SMART_ACTION_TRIGGER_TIMED_EVENT
74;SMART_ACTION_REMOVE_TIMED_EVENT
75;SMART_ACTION_ADD_AURA
76;SMART_ACTION_OVERRIDE_SCRIPT_BASE_OBJECT
77;SMART_ACTION_RESET_SCRIPT_BASE_OBJECT
78;SMART_ACTION_CALL_SCRIPT_RESET
79;SMART_ACTION_SET_RANGED_MOVEMENT
80;SMART_ACTION_CALL_TIMED_ACTIONLIST
81;SMART_ACTION_SET_NPC_FLAG
82;SMART_ACTION_ADD_NPC_FLAG
83;SMART_ACTION_REMOVE_NPC_FLAG
84;SMART_ACTION_SIMPLE_TALK
85;SMART_ACTION_INVOKER_CAST
86;SMART_ACTION_CROSS_CAST
87;SMART_ACTION_CALL_RANDOM_TIMED_ACTIONLIST
88;SMART_ACTION_CALL_RANDOM_RANGE_TIMED_ACTIONLIST
89;SMART_ACTION_RANDOM_MOVE
90;SMART_ACTION_SET_UNIT_FIELD_BYTES_1
91;SMART_ACTION_REMOVE_UNIT_FIELD_BYTES_1
92;SMART_ACTION_INTERRUPT_SPELL
93;SMART_ACTION_SEND_GO_CUSTOM_ANIM
94;SMART_ACTION_SET_DYNAMIC_FLAG
95;SMART_ACTION_ADD_DYNAMIC_FLAG
96;SMART_ACTION_REMOVE_DYNAMIC_FLAG
97;SMART_ACTION_JUMP_TO_POS
98;SMART_ACTION_SEND_GOSSIP_MENU
99;SMART_ACTION_GO_SET_LOOT_STATE
100;SMART_ACTION_SEND_TARGET_TO_TARGET
Configure truice to use localization file (ctrl+F3)
Set Language Russian(not needed), !!!-> Locales set to _loc8 <-!!!
Use search tab (any: quest, go, creatures)
type name of what you want on Ru language - empty string (db has ru (loc8) locale filled in locales tables)
PS: truice 1.3.7 from this repo - all is fine
The equipment_id field in the creature_template has been moved over to its own table: creature_equip_template. Because of this, loading a creature in Truice results in an error.
Additionally, the "Creature Location" tab is not loading spawns correctly. Possibly due to this SQL error? Not entirely sure.
Based on http://www.trinitycore.info/Creature_tc2#spawnMask
0;10-man-normal (maps without heroic mode)
1;25-man-normal (heroics pre 3.2)
2;10-man heroic
3;25-man-heroic
P.S. A bit-mask field that can't have "0;Normal spawn" value and "15;spawned in all versions of maps" is the combination of all previous values (probably left from the time it wasn't a bit-mask field).
Entry
to eventEntry
).It'll be nice if you can convert the flags_extra field in Creature Template to bit-mask field.
CreatureFlags_extra.csv:
1;INSTANCE_BIND (creature kill binds instance to killer and killer's group)
2;CIVILIAN (creature does not aggro - ignore faction/reputation hostility)
3;NO_PARRY (creature does not parry)
4;NO_PARRY_HASTEN (creature does not counter-attack at parry)
5;NO_BLOCK (creature does not block)
6;NO_CRUSH (creature does not do crush-attacks)
7;NO_XP_AT_KILL (creature kill does not give XP)
8;TRIGGER (creature is trigger-NPC - invisible to players only)
9;NO_TAUNT (creature is immune to taunt-auras and "attack me"-effects)
10;UNK1
11;UNK2
12;UNK3
13;UNK4
14;UNK5
15;WORLDEVENT (custom flag for world events - left room for merging)
16;GUARD (creature is a guard - will ignore feign death and vanish)
17;UNK6
18;NO_CRIT (creature does not do critical strikes)
19;NO_SKILLGAIN (creature won't increase weapon skills)
20;TAUNT_DIMINISH (creature taunt is subject to diminishing returns)
21;ALL_DIMINISH (Creature is subject to all diminishing returns)
22;DUNGEON_BOSS (Creature is a dungeon boss. This flag is generically set by core during runtime. Setting this in database will give you startup error.)
http://www.trinitycore.info/Creature_template_tc2#flags_extra
Based on http://www.trinitycore.info/Smart_scripts_tc2#Cast_flags
1;SMARTCAST_INTERRUPT_PREVIOUS
2;SMARTCAST_TRIGGERED
3;CAST_FORCE_CAST (NYI)
4;CAST_NO_MELEE_IF_OOM (NYI)
5;CAST_FORCE_TARGET_SELF (NYI)
6;CAST_AURA_NOT_PRESENT
SQL Error: Unknown column 'lq.entry' in 'on clause'
Based on http://www.trinitycore.info/Creature_template_tc2#rank
0;Normal
1;Elite
2;Rare Elite
3;Boss
4;Rare
Currently the first time you run Truice you can't get the correct table names from DB until you enter them manually (don't remember if you have to connect the first time or just enter the names). So I suggest to populate the login interface with the default values leaving only the password field empty.
P.S. Don't waste time on it if it isn't easy to do.
locales_quest table now have id
instead of entry
column
Editing locales - empty screen
The equipment_id
field is missing in the Creature Location tab (creature
table) and SQL code generated from it.
With latest updates there is a bug, if you try to change some values of GO on main tab or spawn tab and press Button to have SQL generated you will be at empty screen
Something important was deleted from MainUnit.dfm in 257e6f0
Hey,
I have problem in windows 8 with Truice. but Quice works fine
I got this error
SQL Error : Unknown MySQL server host 'localhost' (11001)
It'll be nice if you can make an conditions creation interface similar to the one for SAI.
It should speed things up when dealing with conditions.
Strange considering I'm using an English version of Win7: http://i48.tinypic.com/rh5y6e.png
I can only think of the version differences from MySQL 5.0/5.1 to MySQL 5.5 as being the problem of the error message that I get when trying to log in to the server.
Unknown mysql server at localhost:3306
replacing libmysql.dll with the one from the new version gives me error messages of missing libmysql50.dll and other files.
Many thanks for this fix can you give us a precompiled version too please.
Thank you very much.
Not Add Truice.exe
When you go to Quest tab, you get an error saying SQL Error, unknown column 'entry' in 'where clause'
Add support for the new condition type: TrinityCore/TrinityCore@bdbafc0
Based on http://www.trinitycore.info/Creature_template_tc2#InhabitType
0;Ground
1;Water
2;Flying
P.S. It's a bit-mask field with 7 possible combinations.
There is some kind of problem with the values displayed in the Category column: http://i45.tinypic.com/1e5hg1.png
Error world.creature_queststarter ; http://www.mediafire.com/convkey/9dbe/tc7hgy3mwuaiv4cfg.jpg
Source here
Emotes.csv
-373;STAND_STATE_SUBMERGED
+373;STATE_SUBMERGED
-429;STATE_SUBMERGED
+429;STATE_SUBMERGED_NEW
Faction.csv probably contains the information from the wrong DBC file.
GameObjectFlags.csv:
0;IN_USE (Disables interaction while being animated)
1;LOCKED (Requires a key, spell, or event to be opened)
2;INTERACT_COND (Untargetable, cannot interact)
3;TRANSPORT (Object can transport - boat, elevator, car)
4;NOT_SELECTABLE (Not even in GM-mode)
5;NODESPAWN (Typically for doors, they just change state)
6;DAMAGED (has been siege damaged)
7;DESTROYED (has been destroyed)
9;DAMAGED?
10;DESTROYED?
ItemExtendedCost.csv:
-2;
Languages.csv:
+0;Universal
NPCFlags.csv:
-25;PLAYER_VEHICLE
+25;UNK3 (PLAYER_VEHICLE?)
+26;Mailbox (GUARD)
+27;UNK4 (OUTDOORPVP?)
In SAI_EventType.csv there is ; at the end of each line.
SkillLine.csv
0;NONE
6;Frost
8;Fire
26;Arms
38;Combat
39;Subtlety
43;Swords
44;Axes
45;Bows
46;Guns
50;Beast Mastery
51;Survival
54;Maces
55;Two-Handed Swords
56;Holy
78;Shadow Magic
95;Defense
98;Language: Common
101;Dwarven Racial
109;Language: Orcish
111;Language: Dwarven
113;Language: Darnassian
115;Language: Taurahe
118;Dual Wield
124;Tauren Racial
125;Orc Racial
126;Night Elf Racial
129;First Aid
134;Feral Combat
136;Staves
137;Language: Thalassian
138;Language: Draconic
139;Language: Demon Tongue
140;Language: Titan
141;Language: Old Tongue
142;Survival
148;Horse Riding
149;Wolf Riding
150;Tiger Riding
152;Ram Riding
155;Swimming
160;Two-Handed Maces
162;Unarmed
163;Marksmanship
164;Blacksmithing
165;Leatherworking
171;Alchemy
172;Two-Handed Axes
173;Daggers
176;Thrown
182;Herbalism
183;GENERIC (DND)
184;Retribution
185;Cooking
186;Mining
188;Pet - Imp
189;Pet - Felhunter
197;Tailoring
202;Engineering
203;Pet - Spider
204;Pet - Voidwalker
205;Pet - Succubus
206;Pet - Infernal
207;Pet - Doomguard
208;Pet - Wolf
209;Pet - Cat
210;Pet - Bear
211;Pet - Boar
212;Pet - Crocolisk
213;Pet - Carrion Bird
214;Pet - Crab
215;Pet - Gorilla
217;Pet - Raptor
218;Pet - Tallstrider
220;Racial - Undead
226;Crossbows
228;Wands
229;Polearms
236;Pet - Scorpid
237;Arcane
251;Pet - Turtle
253;Assassination
256;Fury
257;Protection
267;Protection
270;Pet - Generic Hunter
293;Plate Mail
313;Language: Gnomish
315;Language: Troll
333;Enchanting
354;Demonology
355;Affliction
356;Fishing
373;Enhancement
374;Restoration
375;Elemental Combat
393;Skinning
413;Mail
414;Leather
415;Cloth
433;Shield
473;Fist Weapons
533;Raptor Riding
553;Mechanostrider Piloting
554;Undead Horsemanship
573;Restoration
574;Balance
593;Destruction
594;Holy
613;Discipline
633;Lockpicking
653;Pet - Bat
654;Pet - Hyena
655;Pet - Bird of Prey
656;Pet - Wind Serpent
673;Language: Gutterspeak
713;Kodo Riding
733;Racial - Troll
753;Racial - Gnome
754;Racial - Human
755;Jewelcrafting
756;Blood Elf Racial
758;Pet - Event - Remote Control
759;Language: Draenei
760;Draenei Racial
761;Pet - Felguard
762;Riding
763;Pet - Dragonhawk
764;Pet - Nether Ray
765;Pet - Sporebat
766;Pet - Warp Stalker
767;Pet - Ravager
768;Pet - Serpent
769;Internal
770;DK Blood
771;DK Frost
772;DK Unholy
773;Inscription
775;Pet - Moth
776;Runeforging
777;Mounts
778;Companions
780;Pet - Exotic Chimaera
781;Pet - Exotic Devlisaur
782;Pet - Ghoul
783;Pet - Exotic Silithid
784;Pet - Exotic Worm
785;Pet - Wasp
786;Pet - Exotic Rhino
787;Pet - Exotic Core Hound
788;Pet - Exotic Spirit Beast
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.