View Single Post
  #5  
Old 02-02-2008, 12:10 PM
Toriad
Fire Beetle
 
Join Date: Apr 2004
Posts: 21
Default

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.

Last edited by Toriad; 02-02-2008 at 08:13 PM..
Reply With Quote