1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17:

$file = $phpbb_root_path . $import_path . "village.txt";
$sql = "TRUNCATE TABLE `".VILLAGE_TABLE;
mysql_query($sql);

$filearray = fopen ($file, "r");
while (!feof($filearray)) {
    $line = fgets($filearray);
	list($id, $name,$x, $y, $player, $points, $rank) = explode(',', $line);
	$name = datadecode($name);
	$name = addslashes($name);
	$sql = "INSERT INTO " . VILLAGE_TABLE . " SET id='$id', name='$name', x='$x', y='$y', player='$player', points='$points', rank='$rank'";
	$db->sql_query($sql);
}

fclose ($filearray);

1:

"UPDATE " . VILLAGE_TABLE . " SET points = '".$points."', rank = '".$rank."' WHERE id = '".$id."' LIMIT 1"

1:

$arContent = file($this->Path);

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11:

$filearray = fopen ($file, 'r');

while (!feof($filearray))
{
    $line = fgets($filearray);
    $arr = explode(',', $line);
    $sql = 'UPDATE ' . VILLAGE_TABLE . ' SET points = \'' . $arr[5] . '\', rank = \'' . $arr[6] . '\' WHERE id = \'' . $arr[0] . '\' LIMIT 1';
    $db->sql_query($sql);
}

fclose ($filearray);