Opasnet Base UI

From Opasnet
Revision as of 13:09, 1 March 2010 by Ehac (talk | contribs)
Jump to navigation Jump to search

This special page implements user interface to fetch data from the Opasnet Base -database.

Queries

This chapter describes the queries that Base UI executes.

Basic object data

SELECT * FROM obj WHERE ident="<object identifier>";

Newest act

SELECT series_id FROM actobj WHERE obj_id=<object id> ORDER BY series_id DESC LIMIT 0,1;