Jump to content

CharImport - Character Converter (Cross-Emu) [EN/GER]

Guest megasus_

By Guest megasus_
in Community Projects

Recommended Posts

antz Advanced Member

antz

Posted
Posted
Anything else i can do to help, just ask....

Yep, I need some additional info:

- Do you use the default mangos server? Yes

- Target patch 12179

- The process report (showed during transmission)

The first errors i get are:-

// Column arenaPoints in characters does not exist!
// Column totalHonorPoints in characters does not exist!

Here is the transmission log:-

13:19:54.8633424 // Transmission is running
13:19:55.1437456// Begin Core Check...
13:19:57.2467696// Core Check completed!
13:21:50.4295184/ Loading Characters from Armory...
13:21:50.4295184/ Loading new Character...
13:21:50.4795904// Got Character Name: Paldin
13:21:50.4996192// Loading Character Level...
13:21:50.4996192// Got Character Level: 85
13:21:50.8100656// Got Character Gender: 0
13:21:50.8100656// Loading Character Race...
13:21:50.8200800// Got Character Race: 1
13:21:50.8200800// Loading Character Class...
13:21:50.8200800// Got Character Class: 2
13:21:50.8200800// Loading Items...
13:21:50.8601376// Setting up Item Slot: 1
13:21:50.8701520// Setting up Item Slot: 2
13:21:50.8701520// Setting up Item Slot: 3
13:21:50.8801664// Setting up Item Slot: 4
13:21:50.8801664// Setting up Item Slot: 5
13:21:50.8901808// Setting up Item Slot: 6
13:21:50.8901808// Setting up Item Slot: 7
13:21:50.8901808// Setting up Item Slot: 8
13:21:50.8901808// Setting up Item Slot: 9
13:21:50.9001952// Loading Weapontype from itemid: 78485
13:21:52.1319664// Setting up Item Slot: 10
13:21:52.1319664// Loading Weapontype from itemid: 78458
13:21:53.0833344// Error while setting up Itemslot: 11
13:21:53.0833344// Setting up Item Slot: 12
13:21:53.0933488// Setting up Item Slot: 13
13:21:53.0933488// Setting up Item Slot: 14
13:21:53.0933488// Setting up Item Slot: 15
13:21:53.0933488// Setting up Item Slot: 16
13:21:53.0933488// Setting up Item Slot: 17
13:21:53.0933488// Setting up Item Slot: 18
13:21:53.0933488// Setting up Item Slot: 19
13:21:53.0933488// Loading Gems...
13:21:53.1133776// Loaded Socket1 for slot : 1
13:21:53.1133776// Loaded Socket2 for slot : 1
13:21:53.1534352// Loaded Socket1 for slot : 3
13:21:53.1534352// Loaded Socket1 for slot : 4
13:21:53.1534352// Loaded Socket1 for slot : 5
13:21:53.1534352// Loaded Socket2 for slot : 5
13:21:53.1534352// Loaded Socket1 for slot : 8
13:21:53.1634496// Loaded Socket1 for slot : 10
13:21:53.1634496// Loaded Socket1 for slot : 12
13:21:53.1634496// Loaded Socket2 for slot : 12
13:21:53.1634496// Loaded Socket3 for slot : 12
13:21:53.1634496// Loaded Socket1 for slot : 13
13:21:53.1634496// Loaded Socket2 for slot : 13
13:21:53.1634496// Loaded Socket3 for slot : 13
13:21:53.1734640// Loaded Socket1 for slot : 14
13:21:53.1734640// Loaded Socket2 for slot : 14
13:21:53.1734640// Loaded Socket3 for slot : 14
13:21:53.1734640// Loaded Socket1 for slot : 15
13:21:53.1734640// Loaded Socket2 for slot : 15
13:21:53.1734640// Loaded Socket1 for slot : 17
13:21:53.1734640// Loading Enchantments...
13:21:53.1834784// Got Enchantment for slot: 1
13:21:53.1934928// Got Enchantment for Slot: 3
13:21:53.7943568// Got Enchantment for Slot: 4
13:21:54.5153936// Got Enchantment for Slot: 5
13:21:55.1162576// Got Enchantment for Slot: 8
13:21:55.7271360// Got Enchantment for Slot: 9
13:21:56.4882304// Got Enchantment for Slot: 10
13:21:57.2192816// Got Enchantment for Slot: 12
13:21:57.8101312// Got Enchantment for Slot: 14
13:21:58.5511968// Got Enchantment for Slot: 15
13:21:59.1720896// Got Enchantment for slot: 16
13:21:59.1720896// Got Enchantment for slot: 17
13:21:59.1720896// Loading Primary Glyphs...
13:21:59.3323200// Loading Secondary Glyphs...
13:21:59.4524928// Error: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.prozedur_armory.getsecglyph()
13:22:00.7243216// Character loaded!
13:22:02.9775616> ERROR WHILE EXECUTING MYSQL COMMAND (MAYBE YOU CAN IGNORE THIS): command is: INSERT INTO characters ( `guid`, `account`, `name`, `race`, `class`, `gender`, `level`, `xp`, `money`, `position_x`, position_y, position_z, map, orientation, taximask, `health` ) VALUES
( '1', '5', 'Pally', '0', '0', '0', '1', '0', '0', '-14305,7', '514,08', '10', '0', '4,30671', '0 0 0 0 0 0 0 0 0 0 0 0 0 0 ', '1000' )| ErrMsg is:MySql.Data.MySqlClient.MySqlException: Data truncated for column 'position_x' at row 1
  at MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader(IAsyncResult result)
  at CharImport.Functions.NewUser(String& SQLStatement)
  at CharImport.Functions.normalsqlcommand(String command, Boolean showerror)
13:22:02.9775616// Creating Hearthstone for Character: Paldin
13:22:03.1177632// Created Character Pally!
13:22:03.1177632// Setting gender for Character: Paldin
13:22:03.1377920// Setting Level for Character: Paldin
13:22:03.1377920// Setting race for Character: Paldin
13:22:03.1478064// Setting class for Character: Paldin
13:22:03.1478064// Adding gold...
13:22:03.1778496// Creating Items for Character: Paldin
13:22:03.2479504// Creating special spells and skills for relevant items...
13:22:03.2679792// Created 1 spells and 1 skills!
13:22:03.9089008// Created Items!
13:22:03.9689872// Adding Glyphs to Character: Paldin
13:22:03.9790016// Loading Glyphid from id: 43366...
13:22:05.4110608/// SpellId of glyph is: 57979!?
13:22:05.5112048/// GlyphId is: 454!?
13:22:05.6814496// Loading Glyphid from id: 43369...
13:22:07.4740272/// SpellId of glyph is: 57954!?
13:22:07.4740272/// GlyphId is: 457!?
13:22:07.4840416// Loading Glyphid from id: 43365...
13:22:08.7758992/// SpellId of glyph is: 125043!?
13:22:08.7758992> ERROR WHILE GETTING GLYPHID FROM ID: 43365 ## System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getglyphid2(String glyphid)
13:22:08.7959280// Loading Glyphid from id: 41108...
13:22:09.9776272/// SpellId of glyph is: 54939!?
13:22:09.9776272/// GlyphId is: 198!?
13:22:10.0076704// Loading Glyphid from id: 45741...
13:22:12.1707808/// SpellId of glyph is: 63218!?
13:22:12.1707808/// GlyphId is: 701!?
13:22:12.2408816// Loading Glyphid from id: 41109...
13:22:13.4826672/// SpellId of glyph is: 54940!?
13:22:13.4826672/// GlyphId is: 199!?
13:22:15.6758208// Added Glyphs!
13:22:15.6958496// Adding character gems...
13:22:15.6958496// Getting effectid of gemid: 68780
13:22:15.6958496> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:15.7258928// Getting effectid of gemid: 52207
13:22:15.7258928> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:15.7459216// Getting effectid of gemid: 52207
13:22:15.7459216> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:15.7559360// Getting effectid of gemid: 52236
13:22:15.7559360> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:15.7859792// Getting effectid of gemid: 71881
13:22:15.7859792> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:15.8360512// Getting effectid of gemid: 52236
13:22:15.8360512> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:16.1464976// Getting effectid of gemid: 52236
13:22:16.1464976> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:16.1565120// Getting effectid of gemid: 52207
13:22:16.1565120> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:16.1665264// Getting effectid of gemid: 52208
13:22:16.1665264> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:16.2266128// Getting effectid of gemid: 52208
13:22:16.2266128> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:16.2266128// Getting effectid of gemid: 71881
13:22:16.2266128> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:16.8374912// Getting effectid of gemid: 71881
13:22:16.8374912> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:16.8374912// Getting effectid of gemid: 52236
13:22:16.8374912> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:16.8675344// Getting effectid of gemid: 52236
13:22:16.8675344> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:16.9877072// Getting effectid of gemid: 52236
13:22:16.9877072> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:17.0878512// Getting effectid of gemid: 52232
13:22:17.0978656> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:17.1379232// Getting effectid of gemid: 52208
13:22:17.1379232> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:17.2781248// Getting effectid of gemid: 52236
13:22:17.2781248> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:17.5284848// Getting effectid of gemid: 52236
13:22:17.5284848> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:17.6086000// Getting effectid of gemid: 52232
13:22:17.6086000> ERROR WHILE GETTING EFFECTID OF GEMID: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getgemeffectid(String gemid)
13:22:17.6186144// Adding character enchantments...
13:22:17.6186144// Getting effectname of vzid: 86932
13:22:18.5499536// Getting effectid of effectname: +60 Intelligenz und +35 kritischer Trefferwert
13:22:18.6200544> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getvzeffectid(String effectname)
13:22:18.6300688// Getting effectname of vzid: 86899
13:22:19.3911632// Getting effectid of effectname: +50 Intelligenz und +25 Tempo
13:22:19.3911632> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getvzeffectid(String effectname)
13:22:19.4011776// Getting effectname of vzid: 74240
13:22:20.2724304// Getting effectid of effectname: +50 Intelligenz
13:22:20.2824448> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getvzeffectid(String effectname)
13:22:20.2924592// Getting effectname of vzid: 74250
13:22:21.1837408// Getting effectid of effectname: +74249s1 alle Werte
13:22:21.1837408> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getvzeffectid(String effectname)
13:22:21.1937552// Getting effectname of vzid: 74237
13:22:22.1551376// Getting effectid of effectname: +50 Willenskraft
13:22:22.1551376> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getvzeffectid(String effectname)
13:22:22.1651520// Getting effectname of vzid: 74198
13:22:22.8962032// Getting effectid of effectname: +50 Tempo
13:22:22.9262464> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getvzeffectid(String effectname)
13:22:22.9362608// Getting effectname of vzid: 75150
13:22:23.6873408// Getting effectid of effectname: +95 Intelligenz und +55 Willenskraft
13:22:23.6973552> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getvzeffectid(String effectname)
13:22:23.7073696// Getting effectname of vzid: 74199
13:22:24.5786224// Getting effectid of effectname: +50 Tempo
13:22:24.5886368> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getvzeffectid(String effectname)
13:22:24.6286944// Getting effectname of vzid: 74217
13:22:25.5199760// Getting effectid of effectname: +40 Intelligenz
13:22:25.5299904// Getting effectname of vzid: 74217
13:22:26.3010992// Getting effectid of effectname: +40 Intelligenz
13:22:26.3010992// Getting effectname of vzid: 74225
13:22:27.2224240// Getting effectid of effectname: Gesang des Herzens
13:22:27.2224240> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getvzeffectid(String effectname)
13:22:27.2324384// Getting effectname of vzid: 74226
13:22:27.9735040// Getting effectid of effectname: +50 Meisterschaft
13:22:27.9735040> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport.Functions.getvzeffectid(String effectname)
13:22:28.5743680// Character is completed!

Hope this helps

Link to comment
Share on other sites
megasus_ Member

megasus_

Posted
Posted

@Antz

This version should work better with cataclysm servers.

http://sourceforge.net/projects/charimport/files/Test/CharImport_0.10.3.428%28Test%29_%5BMulti%5D.zip/download

Please note that this version is marked as "Test". This means that it will not inform you about future updates. I recommend you to run a beta version or look on sourceforge in order to be informed about updates.

Link to comment
Share on other sites
antz Advanced Member

antz

Posted
Posted

Yay, now have a new character in my account :D

still got a few errors through....

19:09:40.9330937 // Transmission is running
19:09:40.9799687// Begin Core Check...
19:09:44.1674687// Core Check completed!
19:09:45.6205937/ Loading Characters from Armory...
19:09:45.6205937/ Loading new Character...
19:09:45.6362187// Got Character Name: Paldin
19:09:45.6362187// Loading Character Level...
19:09:45.6362187// Got Character Level: 85
19:09:45.7924687// Got Character Gender: 0
19:09:45.7924687// Loading Character Race...
19:09:45.7924687// Got Character Race: 1
19:09:45.8080937// Loading Character Class...
19:09:45.8080937// Got Character Class: 2
19:09:45.8080937// Loading Items...
19:09:45.8862187// Setting up Item Slot: 1
19:09:45.8862187// Setting up Item Slot: 2
19:09:45.8862187// Setting up Item Slot: 3
19:09:45.8862187// Setting up Item Slot: 4
19:09:45.8862187// Setting up Item Slot: 5
19:09:45.9174687// Setting up Item Slot: 6
19:09:45.9174687// Setting up Item Slot: 7
19:09:45.9174687// Setting up Item Slot: 8
19:09:45.9330937// Setting up Item Slot: 9
19:09:45.9487187// Loading Weapontype from itemid: 78485
19:09:47.1830937// Setting up Item Slot: 10
19:09:47.1830937// Loading Weapontype from itemid: 78458
19:09:48.2143437// Error while setting up Itemslot: 11
19:09:48.2143437// Setting up Item Slot: 12
19:09:48.2143437// Setting up Item Slot: 13
19:09:48.2299687// Setting up Item Slot: 14
19:09:48.2299687// Setting up Item Slot: 15
19:09:48.2455937// Setting up Item Slot: 16
19:09:48.2455937// Setting up Item Slot: 17
19:09:48.2455937// Setting up Item Slot: 18
19:09:48.2455937// Setting up Item Slot: 19
19:09:48.2455937// Loading Gems...
19:09:48.3237187// Loaded Socket1 for slot : 1
19:09:48.3237187// Loaded Socket2 for slot : 1
19:09:48.3237187// Loaded Socket1 for slot : 3
19:09:48.3237187// Loaded Socket1 for slot : 4
19:09:48.3393437// Loaded Socket1 for slot : 5
19:09:48.3393437// Loaded Socket2 for slot : 5
19:09:48.3393437// Loaded Socket1 for slot : 8
19:09:48.3549687// Loaded Socket1 for slot : 10
19:09:48.3549687// Loaded Socket1 for slot : 12
19:09:48.3549687// Loaded Socket2 for slot : 12
19:09:48.3549687// Loaded Socket3 for slot : 12
19:09:48.3549687// Loaded Socket1 for slot : 13
19:09:48.3549687// Loaded Socket2 for slot : 13
19:09:48.3549687// Loaded Socket3 for slot : 13
19:09:48.3705937// Loaded Socket1 for slot : 14
19:09:48.3705937// Loaded Socket2 for slot : 14
19:09:48.3705937// Loaded Socket3 for slot : 14
19:09:48.3705937// Loaded Socket1 for slot : 15
19:09:48.3862187// Loaded Socket2 for slot : 15
19:09:48.3862187// Loaded Socket1 for slot : 17
19:09:48.3862187// Loading Enchantments...
19:09:48.4487187// Got Enchantment for slot: 1
19:09:48.4487187// Got Enchantment for Slot: 3
19:09:49.4174687// Got Enchantment for Slot: 4
19:09:50.1987187// Got Enchantment for Slot: 5
19:09:50.9955937// Got Enchantment for Slot: 8
19:09:51.8080937// Got Enchantment for Slot: 9
19:09:52.7768437// Got Enchantment for Slot: 10
19:09:53.5737187// Got Enchantment for Slot: 12
19:09:54.3549687// Got Enchantment for Slot: 14
19:09:55.1518437// Got Enchantment for Slot: 15
19:09:56.1362187// Got Enchantment for slot: 16
19:09:56.1518437// Got Enchantment for slot: 17
19:09:56.1518437// Loading Primary Glyphs...
19:09:56.4174687// Loading Secondary Glyphs...
19:09:56.5893437// Error: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport_Test.prozedur_armory.getsecglyph()
19:09:56.6049687// Character loaded!
19:09:57.7924687// Creating Hearthstone for Character: Paldin
19:09:57.8393437// Created Character Paldin!
19:09:57.8549687// Setting gender for Character: Paldin
19:09:57.8705937// Setting Level for Character: Paldin
19:09:57.8862187// Setting race for Character: Paldin
19:09:57.8862187// Setting class for Character: Paldin
19:09:57.9018437// Adding gold...
19:09:58.1830937// Creating Items for Character: Paldin
19:09:58.2299687// Creating special spells and skills for relevant items...
19:09:58.2299687// Created 1 spells and 1 skills!
19:09:58.4487187// Created Items!
19:09:58.5737187// Adding Glyphs to Character: Paldin
19:09:58.5737187// Loading Glyphid from id: 43366...
19:09:59.6987187/// SpellId of glyph is: 57979!?
19:09:59.6987187/// GlyphId is: 454!?
19:09:59.8393437// Loading Glyphid from id: 43369...
19:10:01.7143437/// SpellId of glyph is: 57954!?
19:10:01.7143437/// GlyphId is: 457!?
19:10:01.7455937// Loading Glyphid from id: 43365...
19:10:02.3549687/// SpellId of glyph is: 125043!?
19:10:02.3549687> ERROR WHILE GETTING GLYPHID FROM ID: 43365 ## System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport_Test.Functions.getglyphid2(String glyphid)
19:10:02.3549687// Loading Glyphid from id: 41108...
19:10:02.9955937/// SpellId of glyph is: 54939!?
19:10:02.9955937/// GlyphId is: 198!?
19:10:02.9955937// Loading Glyphid from id: 45741...
19:10:03.7143437/// SpellId of glyph is: 63218!?
19:10:03.7143437/// GlyphId is: 701!?
19:10:03.7143437// Loading Glyphid from id: 41109...
19:10:04.8549687/// SpellId of glyph is: 54940!?
19:10:04.8549687/// GlyphId is: 199!?
19:10:04.8705937// Added Glyphs!
19:10:04.9174687// Adding character gems...
19:10:04.9330937// Getting effectid of gemid: 68780
19:10:04.9330937// Getting effectid of gemid: 52207
19:10:04.9330937// Getting effectid of gemid: 52207
19:10:04.9487187// Getting effectid of gemid: 52236
19:10:04.9487187// Getting effectid of gemid: 71881
19:10:04.9487187// Getting effectid of gemid: 52236
19:10:04.9643437// Getting effectid of gemid: 52236
19:10:04.9799687// Getting effectid of gemid: 52207
19:10:04.9799687// Getting effectid of gemid: 52208
19:10:04.9799687// Getting effectid of gemid: 52208
19:10:04.9955937// Getting effectid of gemid: 71881
19:10:04.9955937// Getting effectid of gemid: 71881
19:10:04.9955937// Getting effectid of gemid: 52236
19:10:05.0737187// Getting effectid of gemid: 52236
19:10:05.0737187// Getting effectid of gemid: 52236
19:10:05.0737187// Getting effectid of gemid: 52232
19:10:05.0893437// Getting effectid of gemid: 52208
19:10:05.0893437// Getting effectid of gemid: 52236
19:10:05.1049687// Getting effectid of gemid: 52236
19:10:05.1049687// Getting effectid of gemid: 52232
19:10:05.1205937// Adding character enchantments...
19:10:05.1362187// Getting effectname of vzid: 86932
19:10:06.3080937// Getting effectid of effectname: +60 Intelligenz und +35 kritische Trefferwertung
19:10:06.3705937// Getting effectname of vzid: 86899
19:10:07.3393437// Getting effectid of effectname: +50 Intelligenz und +25 Tempowertung
19:10:07.3393437// Getting effectname of vzid: 74240
19:10:08.3705937// Getting effectid of effectname: +50 Intelligenz
19:10:08.3705937// Getting effectname of vzid: 74250
19:10:09.3705937// Getting effectid of effectname: +74249s1 alle Werte
19:10:09.3705937> ERROR WHILE GETTING EFFECTID OF EFFECTNAME: System.IndexOutOfRangeException: Index was outside the bounds of the array.
  at CharImport_Test.Functions.getvzeffectid(String effectname)
19:10:09.3705937// Getting effectname of vzid: 74237
19:10:10.4174687// Getting effectid of effectname: +50 Willenskraft
19:10:10.4330937// Getting effectname of vzid: 74198
19:10:11.4174687// Getting effectid of effectname: +50 Tempowertung
19:10:11.4174687// Getting effectname of vzid: 75150
19:10:12.3862187// Getting effectid of effectname: +95 Intelligenz und +55 Willenskraft
19:10:12.4018437// Getting effectname of vzid: 74199
19:10:13.3862187// Getting effectid of effectname: +50 Tempowertung
19:10:13.3862187// Getting effectname of vzid: 74217
19:10:14.3862187// Getting effectid of effectname: +40 Intelligenz
19:10:14.3862187// Getting effectname of vzid: 74217
19:10:15.3705937// Getting effectid of effectname: +40 Intelligenz
19:10:15.3862187// Getting effectname of vzid: 74225
19:10:16.6205937// Getting effectid of effectname: Gesang des Herzens
19:10:16.6205937// Getting effectname of vzid: 74226
19:10:17.6205937// Getting effectid of effectname: +50 Meisterschaftswertung
19:10:17.6205937// Character is completed!

Link to comment
Share on other sites
megasus_ Member

megasus_

Posted
Posted
Yay, now have a new character in my account :D

still got a few errors through....

You can ignore the first error.

The second one: It seems to me that the glyph 43365 was recently changed on live servers. However, the ID is not contained in the GlyphProperties.dbc.

The third one: The api provided wrong values, needs to get fixed by blizard

If you have any other issues or suggestions, let me know.

Link to comment
Share on other sites
antz Advanced Member

antz

Posted
Posted

Character appeared naked in game.... turns out none of the equipment was in the database !

I also noticed that he ended up in booty bay !

I have a few ideas regarding the user interface, how would you like these - Here in this post or in private ?

Link to comment
Share on other sites
megasus_ Member

megasus_

Posted
Posted
Character appeared naked in game.... turns out none of the equipment was in the database !

I also noticed that he ended up in booty bay !

I have a few ideas regarding the user interface, how would you like these - Here in this post or in private ?

Many of your character's items were added in patch 4.3.0. Did you try to add some items manually ingame?

You could also delete this character and transfer the character again. After you enterd the world send me the Server.log.

All characters that are parsed from the Armory will be teleported to Booty Bay. That's because the armory does not provide any information about your current location, so I thought: throw all of them to Booty Bay. ;)

And send me further messages via PM.

Link to comment
Share on other sites
  • 4 weeks later...
killavulkan Newbie

killavulkan

Posted
Posted

Mangos-Zero to Mangos One = Error

// Column arenaPoints in characters does not exist!

// Column totalHonorPoints in characters does not exist!

// Column totalKills in characters does not exist!

// Column chosenTitle in characters does not exist!

// Column knownTitles in characters does not exist!

Oregoncore to MangosOne = Error

// Column knownCurrencies in characters does not exist!

// Column specCount in characters does not exist!

// Column activeSpec in characters does not exist!

// Column exploredZones in characters does not exist!

// Column equipmentCache in characters does not exist!

// Column knownTitles in characters does not exist!

// Column actionBars in characters does not exist!

// Column spec in character_action does not exist!

// Column itemEntry in item_instance does not exist!

// Column enchantments in item_instance does not exist!

Link to comment
Share on other sites
  • 3 weeks later...
evilatwow Advanced Member

evilatwow

Posted
Posted
Does someone have a clue how to build the playerBytes/playerBytes2 string?

I have following values: "faceVariation=0, skinColor=7, hairVariation=12, hairColor=5" and I want to put them in the correct format.

According to the source code (WoTLK branch, mind you!), in particular src/game/Player.cpp, this happens when updating the playerBytes and playerBytes2 fields of the characters database:

uint32 player_bytes2 = fields[0].GetUInt32();
player_bytes2 &= ~0xFF;
player_bytes2 |= facialHair;

CharacterDatabase.PExecute("UPDATE characters SET gender = '%u', playerBytes = '%u', playerBytes2 = '%u' WHERE guid = '%u'", gender, skin | (face << 8) | (hairStyle << 16) | (hairColor << 24), player_bytes2, guid.GetCounter());

So, in your case, that would be:

playerBytes = 7 | (0 << 8) | (12 << 16) | (5 << 24) = 050C0007 (hex) = 84672519 (decimal)

I don't see any value for the facial hair choice in your post, but basically what the code does is keep whatever is in playerBytes2 already, and make the "last byte" of playerBytes2 the value of your choice.

Link to comment
Share on other sites
megasus_ Member

megasus_

Posted
Posted 

uint32 player_bytes2 = fields[0].GetUInt32();
player_bytes2 &= ~0xFF;
player_bytes2 |= facialHair;

CharacterDatabase.PExecute("UPDATE characters SET gender = '%u', playerBytes = '%u', playerBytes2 = '%u' WHERE guid = '%u'", gender, skin | (face << 8) | (hairStyle << 16) | (hairColor << 24), player_bytes2, guid.GetCounter());

So, in your case, that would be:

playerBytes = 7 | (0 << 8) | (12 << 16) | (5 << 24) = 050C0007 (hex) = 84672519 (decimal)

I don't see any value for the facial hair choice in your post, but basically what the code does is keep whatever is in playerBytes2 already, and make the "last byte" of playerBytes2 the value of your choice.

Thanks, that's what I was looking for! ;)

But regarding playerBytes2: Does it mean that the facial hair value of "33554432" would be 50? (dec(32)) ?

Link to comment
Share on other sites
evilatwow Advanced Member

evilatwow

Posted
Posted
But regarding playerBytes2: Does it mean that the facial hair value of "33554432" would be 50? (dec(32)) ?

That's a weird value for the facial hair choice, since all code I've seen uses 8-bit for the facial hair value, and 33554432 is way out of range then. But that number happens to be 2^25, so I'm guessing that this value is the value you see for playerBytes2? If that's the case: 33554432 = 2000000 hex => facial hair value would be 00 hex (last byte) = 0.

Link to comment
Share on other sites
quinten_wolfe_ Member

quinten_wolfe_

Posted
Posted

Excellent tool!

I ran into a problem.I pulled in Armory data, I had one character that I left with WotLK, level 75 mage, and when I did the filter to 3.3.5, it found all the gear fine, (whereas my other toons were Cata geared)

I'm running a 3.3.5 Core Mangos.

So I import the character from Armory, check the boxes and the import goes fine, I see the character select screen shows it has all its WotLK gear, then I go into game the character's avatar shows it has gear on it but nothing is in the inventory.

When I camped the char out, POOF.... Naked as a newborn.

Also, none of the achievements, reputations, talents, quests, etc... etc.. imported either.

But, still an all around great tool.

I have two realm servers now, both 3.3.5 ( one windows, one linux) and can move the chars fully back and forth ... WORKS LIKE A CHARM!

Great WOrk Megasus!

Link to comment
Share on other sites
megasus_ Member

megasus_

Posted
Posted
Excellent tool!

I ran into a problem.I pulled in Armory data, I had one character that I left with WotLK, level 75 mage, and when I did the filter to 3.3.5, it found all the gear fine, (whereas my other toons were Cata geared)

I'm running a 3.3.5 Core Mangos.

So I import the character from Armory, check the boxes and the import goes fine, I see the character select screen shows it has all its WotLK gear, then I go into game the character's avatar shows it has gear on it but nothing is in the inventory.

When I camped the char out, POOF.... Naked as a newborn.

Also, none of the achievements, reputations, talents, quests, etc... etc.. imported either.

But, still an all around great tool.

I have two realm servers now, both 3.3.5 ( one windows, one linux) and can move the chars fully back and forth ... WORKS LIKE A CHARM!

Great WOrk Megasus!

Thanks ;)

I know there are a lot issues currently and i'm working on them. The next update will "hopefully" fix most of them.

Link to comment
Share on other sites
bannor Advanced Member

bannor

Posted
Posted

Late to this thread as I'm on holiday but as UncleNuke mentioned the windows version of Mangolin was closed and payed for awhile but at that point I stopped promoting it in these forums simply because of my own conscience told me it would be wrong to promote it in what is essentially an open community although I did continue to promote the free Linux version.

Just thought I would make that point a bit clearer even though their are no rules I am aware of making closed software available here.

Cheers

Bannor

Link to comment
Share on other sites
  • 1 month later...

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use