$blocked[$results->fields['sector_id']] = 1;
$results->MoveNext();
}
for($i=0; $i<$nump; $i++) {
$n = rand(0,$sector_max-1);
if($blocked[$n]) {
$i--;
continue;
}
if(!$i%500) {
if($i) {
$insert = substr_replace($insert, ";", -2);
$BenchmarkTimer->pause();
$results = $db->Execute($insert);
$BenchmarkTimer->resume();
if(!$results) {
PrintFlush($db->ErrorMsg());
print "<pre>";
print_r($insert);
PrintFlush("</pre>");
die("DB error while placing planets");
}
}
$insert = "INSERT INTO $dbtables[planets] (colonists,owner,corp,prod_ore,prod_organics,prod_goods,".
"prod_energy,prod_fighters,prod_torp,sector_id) VALUES\n";
}
$insert .= "(2,0,0,$default_prod_ore,$default_prod_organics,$default_prod_goods,".
"$default_prod_energy,$default_prod_fighters,$default_prod_torp,$n),\n";
}
$insert = substr_replace($insert, ";", -2);
