cca9be14d72ae015901148c46908374d4a99635a chinhli Fri Apr 11 13:18:55 2014 -0700 Remove the "NVBI book id" column from geneReviews detail page display.See Bob's note http://redmine.soe.ucsc.edu/issues/11226#note-27 in Track #11226 for more details. diff --git src/hg/hgc/geneReviewsClick.c src/hg/hgc/geneReviewsClick.c index 8b36a90..c2bbef7 100644 --- src/hg/hgc/geneReviewsClick.c +++ src/hg/hgc/geneReviewsClick.c @@ -17,66 +17,68 @@ printf("<BR>"); printTrackHtml(tdb); hFreeConn(&conn); } void prGeneReviews(struct sqlConnection *conn, char *itemName) /* print GeneReviews associated to this item Note: this print function has been replaced by addGeneReviewToBed.pl which print the same information to the field 5 of bigBed file */ { struct sqlResult *sr; char **row; char query[512]; int i; -char *clickMsg = "Click GR short name or NCBI Book id link to find the GeneReviews article."; +char *clickMsg = "Click GR short name link to find the GeneReviews article on NCBI Bookshelf."; char *spacer = " "; boolean firstTime = TRUE; if (!sqlTableExists(conn, "geneReviewsGeneGRshortNBKidGRtitle")) return; sqlSafef(query, sizeof(query), "select grShort, NBKid, grTitle from geneReviewsGeneGRshortNBKidGRtitle where geneSymbol='%s'", itemName); sr = sqlGetResult(conn, query); while ((row = sqlNextRow(sr)) != NULL) { char *grShort = *row++; char *NBKid = *row++; char *grTitle = *row++; if (firstTime) { printf("<BR><B> GeneReviews available for %s:</B> (%s)<BR>",itemName,clickMsg); firstTime = FALSE; printf("<PRE><TT>"); // #123456789-123456789-123456789-123456789-123456789-123456789- - printf("GR short name NCBI Book id Disease name<BR>"); + printf("GR short name Disease name<BR>"); - printf("------------------------------------------------------------"); + printf("---------------------------------------------------------"); printf("--------------------<BR>"); } - printf("<A HREF=\"http://www.ncbi.nlm.nih.gov/books/n/gene/%s\" TARGET=_blank><B>%s</B></A>", grShort, grShort); + printf("<A HREF=\"http://www.ncbi.nlm.nih.gov/books/%s\" TARGET=_blank><B>%s</B></A>", NBKid, grShort); if (strlen(grShort) <= 20) { for (i = 0; i < 20-strlen(grShort); i ++ ) { printf("%s", " " ); } } - printf("<A HREF=\"http://www.ncbi.nlm.nih.gov/books/%s\" TARGET=_blank><B>%s</B></A>%s%s<BR>", NBKid, NBKid, spacer, grTitle); + printf("%s%s<BR>", spacer, grTitle); + +// printf("<A HREF=\"http://www.ncbi.nlm.nih.gov/books/%s\" TARGET=_blank><B>%s</B></A>%s%s<BR>", NBKid, NBKid, spacer, grTitle); } /* end while */ printf("</TT></PRE>"); sqlFreeResult(&sr); } /* end of prGeneReviews */ void prGRShortRefGene(char *itemName) /* print GeneReviews short label associated to this refGene item */ { struct sqlConnection *conn = hAllocConn(database); struct sqlResult *sr; char **row; char query[512]; boolean firstTime = TRUE; if (!sqlTableExists(conn, "geneReviewsGeneGRshortNBKidGRtitle")) return;