Changeset 15

Show
Ignore:
Timestamp:
10/18/06 21:22:45 (14 years ago)
Author:
exi
Message:

fixed an sql error in the sync-function

Location:
dev/common
Files:
2 modified

Legend:

Unmodified
Added
Removed
  • dev/common/admin_sync.php

    r14 r15  
    9797        for ($i = 0; $i<$results; $i++) 
    9898        { 
    99             $update->execute("update kb3_pilots set plt_externalid='".$matches[2][$i]."' where name='".$matches[1][$i]."'"); 
     99            $update->execute("update kb3_pilots set plt_externalid='".$matches[2][$i]."' where plt_name='".$matches[1][$i]."'"); 
    100100        } 
    101101        $html .= "Synchronization complete, got $results new ids from server running version ".$version[0].'.'.$version[1].'.'.$version[2].'.<br>'; 
  • dev/common/sync_server.php

    r14 r15  
    6565        // we dont got that one in our database, update 
    6666        // TODO: we don't care about missing pilots yet 
    67         $update->execute("update kb3_pilots set plt_externalid='".$id."' where name='".$name."'"); 
     67        $update->execute("update kb3_pilots set plt_externalid='".$id."' where plt_name='".$name."'"); 
    6868    } 
    6969    else