7cab12e72257613d386b4dc49b1b64b324450995
max
Tue Dec 8 15:04:48 2015 -0800
fixing malacards after update, refs #14417
diff --git src/hg/hgGene/malacards.c src/hg/hgGene/malacards.c
index 995c144..d70acc0 100644
--- src/hg/hgGene/malacards.c
+++ src/hg/hgGene/malacards.c
@@ -36,31 +36,31 @@
char query[1024];
struct sqlResult *sr;
char **row;
char *itemName;
sqlSafef(query, sizeof(query), "select k.geneSymbol from kgXref k, malacards m"
" where k.kgId='%s' and k.geneSymbol = m.geneSymbol", geneId);
itemName = sqlQuickString(conn, query);
printf("Malacards Gene Search: ");
printf("", itemName);
printf("%s\n", itemName);
/* List diseases associated with the gene */
sqlSafef(query, sizeof(query),
-"select maladySymbol, urlSuffix, mainName, round(score) from malacards where geneSymbol='%s' order by score desc",
+"select maladySymbol, urlSuffix, mainName, round(geneScore) from malacards where isElite=1 and geneSymbol='%s' order by geneScore desc",
itemName);
sr = sqlMustGetResult(conn, query);
row = sqlNextRow(sr);
if (row != NULL)
printf("
Diseases sorted by score: ");
while (row != NULL)
{
char *maladySym = row[0];
char *mainName = row[2];
char *score = row[3];
printf("%s (%s)", maladySym, mainName, score);
row = sqlNextRow(sr);
if (row!=NULL)