Difference between revisions of "Globals test"

Latest revision as of 00:30, 28 September 2013

{{#get_db_data: db=globals |from=globalnames |limit=10 |order by=globalnames.id |data=id=globalnames.id,name=globalnames.name }}

ID	Name
{{{id}}}	{{{name}}}

@@ Line 1: / Line 1: @@
-== Atrox Mature ==
 {{#get_db_data:
 db=globals
-|from=tracker.globallog, tracker.globaltype
+|from=globalnames
-|where=globallog.item=3
 |limit=10
-|order by=value DESC
+|order by=globalnames.id
-|data=date=globallog.date,name=globallog.owner,value=globallog.value
+|data=id=globalnames.id,name=globalnames.name
 }}
 <table>
-<tr><th>Date</th><th>Name</th><th>Item</th><th>Value</th></tr>
+<tr><th>ID</th><th>Name</th></tr>
-{{#for_external_table:<tr><td>{{{date}}}</td><td>{{{name}}}</td><td>{{{value}}}</td></tr>}}
+{{#for_external_table:<tr><td>{{{id}}}</td><td>{{{name}}}</td></tr>}}
 </table>