[MALON]

PHP Code:

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:

PHP Code:

formatex( query, 599,
        "create table if not exists %sscores (\
        score_id integer primary key %s,\
        score integer,\
        server_ip char(15),\
        user_id integer,\
        map_name varchar(32),\
        fin_time float,\
        cps integer,\
        gcs integer,\
        boosts integer,\
        wpns integer,\
        server_time_stamp integer)",
        DB_PREFIX, autoinc )
        SQL_ThreadQuery(DB_TUPLE,"db_generic_handler",query) 


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?

Thanks guys.

[Greenberet]

from %sscores s join %splayers p

%sscores will be s
%splayers will be p

note
%s will be replaced with DB_PREFIX.

[MALON]

Ok that helps. Thank you Greenberet.

Now, where does each variable get it's value? What would be an assignment for those variables? As I said before, the number of database functions I'm trying to mod are many, so it would be ugly for me to copy and paste them.

Is there a general assignment statement that I should look for?

If you guys need all the functions, here is the link to the SMA : http://svn.ian.cammarata.us/index.cg...38&view=markup

Thanks again!

[Xanimos]

He quoted where they get assigned. In your query, where you tell it what tables to look in, 'FROM TABLE AS short name'. However in the specific query you're looking at the left out the optional 'AS'.

[MALON]

Ok so fin_time float,\ is the declaration, and s.fin_time is the assignment? And it gets the values for fin_time from the table?

My end goal is to add one more column to the table, a boolean. In
order to do this, I need to add that value to the table, then do a someVar boolean/, then call s.somVar in the query I think.


Huh, I think I just confused myself. It kind of made sense when I was typing it, so I 'll keep what I said.

But if it doesn't make sense, you know why. Plus this quick reply is acting funny, so maybe that's messing with my brain.

[MALON]

I also noticed there is g.fin_cnt

What is g?

[Xanimos]

Your problem is you aren't understanding the query syntax.
Here's a multi-table query with some whitespace, maybe this will help you understand what the highly unstandardized query you're looking at is doing.

SELECT 
     `table1`.`column1` , `table2`.`column1`
FROM 
     `table1_full_name` AS `table1`
JOIN 
     `table2_full_name` AS `table2` 
     ON `table1`.`column2` = `table2`.`column2`