while (!$results->EOF) { $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";