achievement Three Car Garage

Hi!

I try to fix achievement Three Car Garage.

http://www.wowhead.com/achievement=2907

So, i am find in DBC files id of achievement criteries and create next SQL query:

[CODE]DELETE FROM achievement_criteria_data WHERE criteria_id BETWEEN 10046 AND 10051;

INSERT INTO achievement_criteria_data VALUES

(10046,1,33060,0,‘’),

(10047,1,33062,0,‘’),

(10048,1,33109,0,‘’),

(10049,1,33060,0,‘’),

(10050,1,33062,0,‘’),

(10051,1,33109,0,‘’);[/CODE]
But, when i kill creatures with entry 33060,33062,33109 achievement dosn’t work. I am kill this creature with GM command .damage 1000000. So, i cant understand what i made wrong /emoticons/default_sad.png Please help me to understand, how this table (achievement_criteria_data) is working.

Sorry for my bad English /emoticons/default_sad.png

Make sure the achievement isn’t in the disables table. Some buggy achievements are in there until they get fixed.

Thank you! This achievement was disabled /emoticons/default_smile.png Now i understand /emoticons/default_smile.png

Still not work. I am insert this queries:

[CODE]DELETE FROM disables WHERE entry BETWEEN 10046 AND 10051 AND sourceType = 4;

DELETE FROM achievement_criteria_data WHERE criteria_id BETWEEN 10046 AND 10051;

INSERT INTO achievement_criteria_data VALUES

(10046,1,33060,0,‘’),

(10047,1,33062,0,‘’),

(10048,1,33109,0,‘’),

(10049,1,33060,0,‘’),

(10050,1,33062,0,‘’),

(10051,1,33109,0,‘’);[/CODE]

And check data in the tables:

[CODE]mysql> SELECT * FROM disables WHERE entry BETWEEN 10046 AND 10051 AND sourceType = 4;

Empty set[/CODE]

[CODE]mysql> SELECT * from achievement_criteria_data WHERE criteria_id BETWEEN 10046 AND 10051;

±------------±-----±-------±-------±-----------+

| criteria_id | type | value1 | value2 | ScriptName |

±------------±-----±-------±-------±-----------+

| 10046 | 1 | 33060 | 0 | |

| 10047 | 1 | 33062 | 0 | |

| 10048 | 1 | 33109 | 0 | |

| 10049 | 1 | 33060 | 0 | |

| 10050 | 1 | 33062 | 0 | |

| 10051 | 1 | 33109 | 0 | |

±------------±-----±-------±-------±-----------+

6 rows in set[/CODE]
Where else could be the problem?

This achevement cannot be fixed via DB, it needs a c++ script.

achievement type is not supported?

What exactly you mean? Achievement type in DBC files or in DB?

http://www.trinitycore.org/w/Achievement_Criteria.dbc_tc2 this type or type from the table achievement_criteria_data in DB? So, how is this table (achievement_criteria_data) is working?

This table contains the data that a player needs to obtain / complete in order to receive a given achievement.

I thought that data in this table are replace data from DBC files…

Hello ZaxarPal, my friend, achievement must be script to work with the information of data base.

burnham, hello, i was fixed this achievement, with script. But i still don’t understand, how is working achievement script system. How is working the table achievement_criteria_data i now understand. When function bool OnCheck() is called?