update_forum

create procedure update_forums()begindeclare f int(8);declare counter_id int(8) default 0;declare t int(8);declare p_id int(8);declare pr_id int(8);declare p_sub varchar (100);declare p_time int(11);declare pr_name varchar(255);declare pr_col varchar(6);select count(*) into t from phpbb_forums;create temporary table tempo select * from phpbb_forums;while counter_id < t doselect forum_id into f from tempo order by forum_id limit 1;select post_id into p_id from phpbb_posts where forum_id = f order by post_id desc limit 1;select poster_id into pr_id from phpbb_posts where forum_id = f order by post_id desc limit 1;select post_subject into p_sub from phpbb_posts where forum_id = f order by post_id desc limit 1;select post_time into p_time from phpbb_posts where forum_id = f order by post_id desc limit 1;select if(p.post_username='',u.username,p.post_username) into pr_name from phpbb_posts p join phpbb_users u on u.user_id=poster_id where forum_id = f order by post_id desc limit 1;update phpbb_forums set forum_last_post_id=p_id where forum_id = f ;update phpbb_forums set forum_last_poster_id=pr_id where forum_id = f ;update phpbb_forums set forum_last_post_subject=p_sub where forum_id = f ;update phpbb_forums set forum_last_post_time=p_time where forum_id = f ;update phpbb_forums set forum_last_poster_name=pr_name where forum_id = f ;delete from tempo where forum_id = f;set counter_id = counter_id + 1;end while;drop table tempo;end  ?