formatex( query, 500,
"select distinct p.alias, s.fin_time, s.cps, s.gcs, g.fin_cnt, s.boosts, s.wpns, s.score from %sscores s join %splayers p on s.user_id = p.user_id join (select user_id, min(score) minscore, count(*) fin_cnt from %sscores where map_name=^"%s^" group by user_id, wpns) g on p.user_id=g.user_id where map_name=^"%s^" and s.score=g.minscore order by s.score limit 20",
DB_PREFIX, DB_PREFIX, DB_PREFIX, mapname, mapname )
I'm not sure what the single characters in front of each variable is (if it's even a variable), lik ein p.alias or s.fin_time. I lets say I declare a boolean x, how do I add x to be queried? x boolean,\ ?
They are declared earlier like so:
formatex( query, 599,
"create table if not exists %sscores (\
score_id integer primary key %s,\
DB_PREFIX, autoinc )
I can't figure out where else they are declared or how they get their values. All the database functions from the plugin I'm looking at are many, so I don't know if I posted everything you guys need in order to answer my questions.
I lets say I declare a boolean called rifle, how do I add rifle to be queried? rifle boolean,\ ? How do I query it? b.rifle?