[Leonardo]

L 11/28/2010 - 19:29:57: [SM] Native "SQL_FetchString" reported: Current result set has no fetched rows
L 11/28/2010 - 19:29:57: [SM] Displaying call stack trace for plugin "achievements_api.smx":
L 11/28/2010 - 19:29:57: [SM]   [0]  Line 1079, E:\_DedicatedServers\TF2Trash\orangebox\tf\addons\sourcemod\scripting\achievements_api.sp::CA_TriggerAchievement()

maybe error in query in line 974 ? I dislike SELECT name... maybe it should be SELECT `name`? error triggered only once.

[Flyflo]

It's strange, if there was an error in the SQL structure of the achievement, the error should have been triggered before.
Did you try multiple times and/or with other achievements ?

[Leonardo]

I tried to do some achievement whom checks in OnGameFrame() (so I've got ~100 invalid queries, lol). It work fine now, after reloading scripts ... but, what happened...
just tried to make achievement like "be burned after touching pyro while cloaked", huh.
I'll write, if I get more.

[Leonardo]

I've been f**ked again.

CREATE TABLE IF NOT EXISTS `ca_achievements` (
  `id` int(10) NOT NULL auto_increment COMMENT 'Achievement''s id ',
  `unique_name` varchar(64) NOT NULL COMMENT 'Achievement''s unique name (optional)',
  `name` varchar(50) NOT NULL COMMENT 'Nom de l''achievement',
  `amount` int(5) NOT NULL COMMENT 'Triggering value',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Holds the different types of achievements.';

1/ translate this in english.
2/ achievements_api.sp, line 1696

Format(strQuery, sizeof(strQuery), "SELECT `id`, `unique_name`, `name`, `description`, `amount` FROM `%sachievements`", g_strDatabasePrefix);

there no "description" field in db ...

[Flyflo]

I made a new dump of the db and it should be ok this time.
I have my head in the clouds

[Leonardo]

somewhere `achievement_id` is an int(10), somewhere - int(11)
`%progress`.`progression` is an int(10), but `%achievements`.`amout` is an int(5)
huh ...

[Velture]

How do you add achivements?

[superchat]

How i'm make achievements? HELP!

[El Diablo War3source]

comment out line 1420, then comment out line 1423

add after line 1423:

if(!(TF2_IsPlayerInCondition(client,TFCond_Disguised)) && !(TF2_IsPlayerInCondition(client,TFCond_Cloaked)))

TF2_GetPlayerConditionFlags(client) is old code.. need to use TF2_IsPlayerInCondition(client, TFCond)

[Skyrider]

Does this work still by any chance?