~grubng-dev/grubng/tools-urlsdb

Viewing changes to Database.cs

add If-Modified-Since header only for pages with HTTP answer code 200

added added

removed removed

335

dbcmd.ExecuteNonQuery();

336

if (offset == -1)

337

{

338

dbcmd.CommandText = "SELECT SQL_NO_CACHE `url`, `last_visited` FROM `urlslist` ORDER BY `last_visited` ASC LIMIT 250000;";

338

dbcmd.CommandText = "SELECT SQL_NO_CACHE `url`, `last_visited`, `http_code1` FROM `urlslist` ORDER BY `last_visited` ASC LIMIT 250000;";

339

}

340

else

341

{

350

{

351

returnvalue.Append(' ');

352

returnvalue.Append(reader.GetString(1));

353

returnvalue.Append(' ');

354

returnvalue.Append(reader.GetInt16(2));

353

355

}

354

356

returnvalue.Append("\n");

355

357

}