faq / truice Goto Github PK

Truice is a database editor specifically for Trinity.

Pascal 99.95% Batchfile 0.05%

truice's Introduction

Truice

Truice is a database editor specifically made for TrinityCore. It is a fork of Quice, which was made for MaNGoS.

You can edit quests, creatures, gameobjects, items, loot, SmartAI (smart_scripts), conditions and some minor things.

It is written in Delphi, source on github compiled using Embarcadero Delphi 10.2.2 (Tokyo) and the source is available under https://github.com/Faq/Truice and precompiled binaries under https://github.com/Faq/Truice/releases

How To run:

choose 32 bit or 64 and copy "libmysql.dll" and "Truice.exe" outside folder (where are all other folders: CSV, Lang etc.);
run "Truice.exe"
dll files are from MySQL v5.7.23
if You got it right, then it should be like this:

To compile use: Delphi XE2+ (there is Community Edition of Delphi what is completely free https://www.embarcadero.com/products/delphi/starter)

and these additional components:

A) JEDI Visual Component Library 3.5 http://jvcl.delphi-jedi.org/ http://jvcl.sourceforge.net/daily/ http://github.com/project-jedi/jvcl

B) JEDI Code Library 2.9 http://sourceforge.net/projects/jcl/ http://jcl.sourceforge.net/daily/ http://github.com/project-jedi/jcl

C) Droping ZeosLib to use Delphi internal db component FireDAC (from 22.08.2018).

ZeosDBO 7.3 from testing branch (SVN rev4068) (last commit with ZeosLib https://github.com/Faq/Truice/commit/3e74ac4aececd7b4c55b607ca9c3b63eb85f3a17) http://sourceforge.net/projects/zeoslib/ (new link) http://svn.code.sf.net/p/zeoslib/code-0

Original topic on TC forum: https://community.trinitycore.org/topic/13899-truice-2018-win32/

Truice Download: https://github.com/Faq/Truice/releases

Author: Faq

truice's People

Contributors

Stargazers

Watchers

Forkers

ahuraa l30m4nc3r maximuslol amsjunior1 desder badmoon alideny dragonspower sharkie23 secreal nono99 skywow july2k chaosua heros wuhongyi1977 creedem anonymous2 sephiroth1983 aikon-int josephstolz tian584092 slan12 saqar experi91 formylover gragonvlad zyres suuphoenix gboisen grimgravy qyh214 mesielecat cw-tool catontheway world0fwarcraft fan3750060 kerlak2000 sanctum32 ustoopia fang139842 gzwplato zichie wruktarr artdeil4ek don-jin ruby721 dekadence xuehyc davidwow1024 freadblangks cruscio

truice's Issues

Quest Tab

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

Truice 1.3.6 Quest Error

plz add

Not Add Truice.exe

[FIX] QuestFlags.csv

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

[UI] CreatureTemplate>MovmentType

The button drop-dawn menu dimensions needs to be corrected.

Need to add new QuestFlags for cataclysm

Source here

TrinityCore/WowPacketParser@b00fa8a

[Feature] Conditions

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.

http://www.trinitycore.info/Conditions_tc2

SQL Error messages

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.

Still cannot connect Truice 1.39

Hi there, I check out this post

#30

And this one

#31

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!

HoverHeight Table

Missing HoverHeight Table in Truice

support for MySQL 5.5

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.

[Feature] Removed table quest_start_scripts and StartScript from table quest_template

TrinityCore/TrinityCore@0a3972d

[Feature] Add to item_template UI item_template.flagsCustom field

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

Bug generating SQL Gameobgect changes

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

[Feature] Characters / Account tab

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...

Quest tab error

When you go to Quest tab, you get an error saying SQL Error, unknown column 'entry' in 'where clause'

[Feature RQ] SQL code generation

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 ',').

SpawnMaskFlags.csv values update

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).

Error on quest creating button 'New Quest"

when you press that button you will get error about entry column

Fix chaosua@b7cb1e5

Drop support for SMART_ACTION_SEND_CASTCREATUREORGO

TrinityCore/TrinityCore@80bd5b3

[Feature] Add CONDITION_GENDER to Conditions

Add support for the new condition type: TrinityCore/TrinityCore@bdbafc0

Rank.csv values update

Based on http://www.trinitycore.info/Creature_template_tc2#rank

0;Normal
1;Elite
2;Rare Elite
3;Boss
4;Rare

Implement SMART_ACTION_SET_POWER, SMART_ACTION_ADD_POWE…

TrinityCore/TrinityCore@75ca357

[UI] Creature/GO>Involved in>Category column

There is some kind of problem with the values displayed in the Category column: http://i45.tinypic.com/1e5hg1.png

SAI_CastFlags.csv values update

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

[Feature] Creature Template.flags_extra

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

[BUG] Other > Game Events

Searching by Entry returns error (probably field name need to be changed from Entry to eventEntry).
When a field is updated the Description text is displayed under the holiday tab which disappears.

precompied Version

Many thanks for this fix can you give us a precompiled version too please.

Thank you very much.

First time connection

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)

GameObjectFlags.csv values update

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?

Broken searching in locales Truice 1.3.8

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

Rename _questrelation tables to _queststarter and _involve… …drelation to _questender, for creature and gameobject

TrinityCore/TrinityCore@a71fcee

NPCFlags.csv values update

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?)

Update SAI to current

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

lq.entry SQL Error

SQL Error: Unknown column 'lq.entry' in 'on clause'

Default.lng

There are a few extra symbols at the end of Default.lng file that probably aren't needed.

Implement SMART_TARGET_CLOSEST_ENEMY (25)

TrinityCore/TrinityCore@9d4c2c5
http://collab.kpsn.org/display/tc/smart_scripts

"Gameobject_scripts" is no longer existing

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.

locales_quest

locales_quest table now have id instead of entry column
Editing locales - empty screen

SkillLine.csv values update

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.

CSV corections

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

Please

Please upload latest compiled version, thanks for your time.

sql error : Table 'world.creature_queststarter'

Error world.creature_queststarter ; http://www.mediafire.com/convkey/9dbe/tc7hgy3mwuaiv4cfg.jpg

equipment_id depreciated

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.

CreatureInhabitType.csv values update

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.

ItemExtendedCost.csv is quite old

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.

error on closing

Strange considering I'm using an English version of Win7: http://i48.tinypic.com/rh5y6e.png

[Feature] Add equipment_id field in Creature Location tab and SQL code generated from it

The equipment_id field is missing in the Creature Location tab (creature table) and SQL code generated from it.

http://www.trinitycore.info/Creature_tc2#equipment_id

Links for donwload are old.

I try download precompiled 1.3.9 and links are broken

[Feature RQ] Add default tables to connect to mysql interface

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.