I have that table, but it still wasn't working... SELECT * FROM peq.skill_caps s;
The old DB query in the code was
Code:
//if (RunQuery(query, MakeAnyLenString(&query, "SELECT level, formula, pre50cap, post50cap, post60cap from skillcaps where skill = %i && class = %i", skillid, in_class), errbuf, &result, &affected_rows))
That was the old query however, I dont have a skillcaps table i did have skill_caps but it didn't have any of those fields which is why i changed it to
Code:
if (RunQuery(query, MakeAnyLenString(&query, "SELECT cap from skill_caps where skillID = %i && class = %i && level = %i", skillid, in_class, in_level), errbuf, &result, &affected_rows))
That is what I changed it to... Which seemed to fix the problem, maybe the latest source code already had this change? but when I downloaded the source from latest emu it was like the old.