[SOLVED] Query fix (speed up)

[peppolone]

it is included in 9.9.5

[Andreiii]

Hello! Many thanks for your work!
If my site use Pligg 9.7, and the code:

		include_once('dbtree.php');
		$array = tree_to_array(0, table_categories);
		$var_smarty->assign('lastspacer', 0);
		$var_smarty->assign('cat_array', $array);		
	
		// use the 'totals' table now 
		$published_count = get_story_count('published');
		
		$var_smarty->assign('published_count', $published_count);
		$categories = mysql_query("select *,  count(*) as count from " . table_links . ", " . table_categories . " where category_lang='$dblang' and category_id=link_category group by link_category ORDER BY category_name ASC");
	
		$categorylist = array();
		while ($rows = mysql_fetch_array ($categories, MYSQL_ASSOC)) array_push ($categorylist, $rows);
		$var_smarty->assign('categorylist', $categorylist);
		$var_smarty->assign('category_url', getmyurl('maincategory'));

What should I change?

[mendim]

change just

while ($rows = mysql_fetch_array ($categories, MYSQL_ASSOC)) array_push ($categorylist, $rows);
$var_smarty->assign('categorylist', $categorylist);

[wediggcouk]

Please anyone is this code still in place as i can not find it

[interneteditor]

Hi Wediggcouk

I am having a "first play" with Pligg at cash-bonus.co.uk.

I have 9.9.5 installed but have also just implemented this hack, by following the first post in this thread. Certainly the code was there to be replaced

[rethomas07]

Sorry for the noob question here but is this mod for jquery, db.php or the actual mysql db? RC2 here and I could not find the codes mentioned here in any of those files