It looks complicated but it's all 3 mysql commands to get a complete table with whatever data you want from the winapi stats data in a nice table... Take the attached file (it just strips some text) , create user as mysql user that has a db called winapi with CREATE TEMPORARY TABLE and select rights then run: ./tools/winapi/winapi_extract --pseudo-stub-statistics --no-verbose --no-progress >winapi_stats.txt php winapi_stats.php > winapi_stats,dat mysql --execute=' CREATE TEMPORARY TABLE `winapi` ( `module` VARCHAR( 255 ) NOT NULL , `stubs` INT NOT NULL , `total_func` INT NOT NULL , `real_stub` INT NOT NULL , `psedo_stubs` INT NOT NULL , `forwards` INT NOT NULL , PRIMARY KEY ( `module` ) ); LOAD DATA LOCAL INFILE "winapi_stats,dat" REPLACE INTO TABLE winapi FIELDS TERMINATED BY "~" LINES TERMINATED BY "\n"; SELECT "Total" "Library", sum(total_func) "API Count", (sum(total_func) - sum(stubs)) / sum(total_func) *100 "% implemented", sum(stubs) "Total Stubs", sum(real_stub), sum(psedo_stubs) FROM winapi UNION ALL SELECT module "Library", total_func "API Count", ( total_func - stubs ) / total_func *100 "% implemented", stubs "Total Stubs", real_stub, psedo_stubs FROM winapi; ' -u user -D winapi -H
/lostwages/templates/en/winapi_stats.html
comments? p.s. sorry for the yahoo and the linewrap mess my mail dosn't send latly... -- Hatky, Worshiper of wine (http://www.winehq.org/ or http://hatky.myz.info/wine/), Impossible is only an opinion. __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html