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

  }

  cnt = 0;
  db_prepare(&q,
    "SELECT"
    " substr(name,6),"
    " datetime(mtime,'unixepoch'),"
    " json_extract(value,'$.type'),"
    " json_extract(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);

|
|

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'),"
    " 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);