b7bc2a330a4430adc400bac36a66701080382e47
jcasper
Mon Aug 8 16:06:13 2016 -0700
Fixing links to Genetic Association Database (now archive-only), refs #15342
diff --git src/hg/hgGene/gad.c src/hg/hgGene/gad.c
index 7f6b6dc..8913892 100644
--- src/hg/hgGene/gad.c
+++ src/hg/hgGene/gad.c
@@ -38,85 +38,81 @@
static void gadPrint(struct section *section,
struct sqlConnection *conn, char *geneId)
/* Print out GAD section. */
{
int refPrinted = 0;
boolean showCompleteGadList;
char query[1024];
struct sqlResult *sr;
char **row;
struct dyString *currentCgiUrl;
char *upperDisease;
char *url =
-cloneString("http://geneticassociationdb.nih.gov/cgi-bin/tableview.cgi?table=allview&cond=gene=");
+cloneString("http://geneticassociationdb.nih.gov");
char *itemName;
if (url != NULL && url[0] != 0)
{
sqlSafef(query, sizeof(query), "select k.geneSymbol from kgXref k, gadAll g"
" where k.kgId='%s' and k.geneSymbol = g.geneSymbol", geneId);
itemName = sqlQuickString(conn, query);
showCompleteGadList = FALSE;
if (cgiOptionalString("showAllRef") != NULL)
{
if (sameWord(cgiOptionalString("showAllRef"), "Y") ||
sameWord(cgiOptionalString("showAllRef"), "y") )
{
showCompleteGadList = TRUE;
}
}
currentCgiUrl = cgiUrlString();
- printf("Genetic Association Database: ");
- printf("", url, itemName);
+ printf("Genetic Association Database (archive): ");
+ printf("", url);
printf("%s\n", itemName);
printf("
CDC HuGE Published Literature: ");
printf("",
"http://hugenavigator.net/HuGENavigator/searchSummary.do?firstQuery=",
itemName,
"&publitSearchType=now&whichContinue=firststart&check=n&dbType=publit&Mysubmit=go");
printf("%s\n", itemName);
/* List diseases associated with the gene */
sqlSafef(query, sizeof(query),
"select distinct broadPhen from gadAll where geneSymbol='%s' and association = 'Y' order by broadPhen",
itemName);
sr = sqlMustGetResult(conn, query);
row = sqlNextRow(sr);
if (row != NULL)
{
upperDisease = replaceChars(row[0], "'", "''");
touppers(upperDisease);
printf("
Positive Disease Associations: ");
- printf("",
- "http://geneticassociationdb.nih.gov/cgi-bin/tableview.cgi?table=allview&cond=upper(DISEASE)%20like%20'%25",
- cgiEncode(upperDisease), "%25'%20AND%20upper(GENE)%20%20like%20'%25", itemName, "%25'");
+ printf("");
printf("%s\n", row[0]);
row = sqlNextRow(sr);
}
while (row != NULL)
{
upperDisease = replaceChars(row[0], "'", "''");
touppers(upperDisease);
- printf(", ",
- "http://geneticassociationdb.nih.gov/cgi-bin/tableview.cgi?table=allview&cond=upper(DISEASE)%20like%20'%25",
- cgiEncode(upperDisease), "%25'%20AND%20upper(GENE)%20%20like%20'%25", itemName, "%25'");
+ printf(", ");
printf("%s\n", row[0]);
row = sqlNextRow(sr);
}
sqlFreeResult(&sr);
refPrinted = 0;
sqlSafef(query, sizeof(query),
"select broadPhen,reference,title,journal, pubMed, conclusion from gadAll where geneSymbol='%s' and association = 'Y' order by broadPhen",
itemName);
sr = sqlMustGetResult(conn, query);
row = sqlNextRow(sr);
if (row != NULL) printf("
Related Studies: