Source: userstatus.phps - download
<?php
$url = "http://svn.daif.net/";
$repos = array('easy','trans');//project ID
foreach($repos as $id){
exec('svn log -q '.$url.$id.' > '.$id.'.log');// get log from svn repositry without massage
}
foreach($repos as $id){
$lines = file($id.'.log');
foreach($lines as $line){
$arr = explode('|',$line);
if(count($arr) ==4){
$log['project'] =$id;
$log['rev'] = trim($arr[0]);
$log['user'] = trim($arr[1]);
$log['date'] = trim($arr[2]);
$logs[] = $log;
}
}
}
mysql_connect('localhost','root','');//connect to mysql
mysql_select_db('dbname'); // select database
//Insert into databases ... I use revision number instead of massage
foreach($logs as $log){
$sql = "INSERT INTO cvs set userid=$log[user], logdate='$log[date]', logmsg='$log[rev]', projectid=$log[project]";
mysql_query($sql);
}
?>