markzz/aurweb.git/web/lib/stats.inc.php, branch v3.1.0

Add provisional support for package bases

2014-04-05T10:21:35Z

This adds a PackageBases table to the database schema and moves the following fields from the Packages table to PackageBases: * CategoryID * NumVotes * OutOfDateTS * SubmittedTS * ModifiedTS * SubmitterUID * MaintainerUID It also fixes all database accesses to comply with the new layout. Having a separate PackageBases table is the first step to split package support. By now, we create one PackageBases entry per package (where the package base has the same name as the corresponding package). When adding full support for split packages later, the package base name will be derived from the pkgbase variable and a single package base will be shared amongst all packages built from one source package. Signed-off-by: Lukas Fleischer

Remove documentation references to database parameter

2013-02-10T11:10:38Z

Signed-off-by: Lukas Fleischer

Remove unnecessary database connection parameter from all functions

2013-02-10T11:10:38Z

All functions now have a database connection method that will use the same database connection. This imitates the functionality of passing a database connection as an argument and makes it redundant. Signed-off-by: canyonknight Signed-off-by: Lukas Fleischer

stats.inc.php: Remove unnecessary account type lookup

2013-01-19T11:21:16Z

Signed-off-by: canyonknight Signed-off-by: Lukas Fleischer

stats.inc.php: Document all functions using PHPDoc format

2012-09-24T00:04:03Z

Signed-off-by: canyonknight Signed-off-by: Lukas Fleischer

Migrate all DB code to use PDO

2012-09-17T22:58:46Z

All DB code currently uses the quickly aging mysql_* functions. These functions are strongly discouraged and may eventually be deprecated. Transition all code to utilize the PDO data access abstraction layer. PDO allows for consistent query code across multiple databases. This could potentially allow for someone to use a database other than MySQL with minimal code changes. All functions and behaviors are reproduced as faithfully as possible with PDO equivalents and some changes in code. Signed-off-by: canyonknight Signed-off-by: Lukas Fleischer

user_table optimization

2012-05-06T10:12:51Z

Rather than looking up by username, it makes more sense to look the stats up by user ID to reduce the number of needed joins. Signed-off-by: Dan McGee Signed-off-by: Lukas Fleischer

Unify function declaration style

2012-03-24T09:34:35Z

Always put the opening brace on the same line as the beginning of the function declaration. Signed-off-by: Lukas Fleischer

Wrap mysql_real_escape_string() in a function

2011-10-24T15:57:54Z

Wrap mysql_real_escape_string() in a wrapper function db_escape_string() to ease porting to other databases, and as another step to pulling more of the database code into a central location. This is a rebased version of a patch by elij submitted about half a year ago. Thanks-to: elij Signed-off-by: Lukas Fleischer

rename .inc files to .inc.php and adjust imports and references

2011-06-22T13:15:04Z

Lukas: Add note to "UPGRADING". Signed-off-by: Lukas Fleischer