Mercurial > hg > fapweb
diff showajax.php @ 542:8c1a53532be0
Rename various database tables and column names for better SQL compatibility.
| author | Matti Hamalainen <ccr@tnsp.org> |
|---|---|
| date | Sun, 15 Dec 2013 23:48:14 +0200 |
| parents | e7566fafe9b1 |
| children | aab614fb7422 |
line wrap: on
line diff
--- a/showajax.php Sun Dec 15 23:46:41 2013 +0200 +++ b/showajax.php Sun Dec 15 23:48:14 2013 +0200 @@ -21,7 +21,7 @@ " <div class=\"entryIndex\">#".$entry["show_id"]."</div>\n". " <div class=\"entryName\">".chentities($entry["name"])."</div>\n"; - if ($compo["showAuthors"]) + if ($compo["show_authors"]) { if ($title === false) echo " <div class=\"entryBy\">by</div>\n"; @@ -100,7 +100,7 @@ stGetDisplayVar("tempSlide") > 0 && stGetDisplayVar("tempSlideSet")) { - $sql = stPrepareSQL("SELECT * FROM displaySlides WHERE id=%d", + $sql = stPrepareSQL("SELECT * FROM display_slides WHERE id=%d", stGetDisplayVar("tempSlide")); if (($res = stFetchSQL($sql)) !== false) @@ -135,7 +135,7 @@ // Get list of slides from active rotation list $list = stGetDisplayVar("rotateList"); $sql = stPrepareSQL( - "SELECT * FROM rotationListSlides WHERE list_id=%d ORDER BY order_num,id", + "SELECT * FROM rot_list_slides WHERE list_id=%d ORDER BY order_num,id", $list); if (($slideList = stExecSQL($sql)) !== false)