0

Can any one make a documentation of the query for me the query code is

"SELECT t.*, SUM(t.item_qty) as count, t.created, t.status, t.ip, t.active as tactive, 
		  SUM(t.downloads) as file_downloads, FROM_UNIXTIME(t.file_date,'%M %e %Y, %H:%i') as registered, t.id as tid, MAX(t.file_date) as file_date," 
				 . " \n p.id as pid, p.title, p.description, p.expiry, p.active as pactive, p.price, p.slug, p.metakeys, p.metadesc," 
				 . " \n f.id AS fid, f.alias, f.filesize,"
				 . " \n u.id AS uid"
				 . " \n FROM transactions as t" 
				 . " \n LEFT JOIN " . $this->pTable . " as p ON t.pid = p.id" 
				 . " \n LEFT JOIN files as f ON p.file_id = f.id" 
				 . " \n LEFT JOIN users AS u ON t.uid = u.id"
				 . " \n WHERE t.pid = '" . $this->pid . "' AND t.uid = '" . $user->uid . "' AND t.status = '1'"
				 . " \n GROUP BY p.id";
2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by pritaeas
0

So you just guess anyone can just know what's being done here, without seeing some actual data and table structures ? What exactly do you want documented ?

Where did you get it from ?

BTW, do NOT cross post. Choose the right forum and post there.

Edited by pritaeas: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.