Fossil

Differences From Artifact [846a2ad27b]:

• File src/stat.c — part of check-in [f0cdbd8b95] at 2021-12-23 13:16:46 on branch trunk — On the /urllist page, hyperlinks to URLs that include a username omit the username. (user: drh size: 38358) [more...]

To Artifact [85162f631e]:

• File src/stat.c — part of check-in [50d433e5b0] at 2022-01-13 12:50:02 on branch trunk — Change all calls to json_extract() into uses of the new ->> operator. (user: drh size: 38330) [more...]

607
608
609
610
611
612
613
614
615


616
617
618
619
620
621
622

607
608
609
610
611
612
613


614
615
616
617
618
619
620
621
622

-
-
+
+

  }

  cnt = 0;
  db_prepare(&q,
    "SELECT"
    " substr(name,6),"
    " datetime(mtime,'unixepoch'),"
    " json_extract(value,'$.type'),"
    " json_extract(value,'$.src')\n"
    " value->>'type',"
    " value->>'src'\n"
    "FROM config\n"
    "WHERE name GLOB 'link:*'\n"
    "AND json_valid(value)\n"
    "ORDER BY 4, 2 DESC"
  );
  while( db_step(&q)==SQLITE_ROW ){
    const char *zUrl = db_column_text(&q, 0);