Mercurial > hg > fapweb
diff admajax.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 | 067bef3846aa |
children | 1f75523293ad |
line wrap: on
line diff
--- a/admajax.php Sun Dec 15 23:46:41 2013 +0200 +++ b/admajax.php Sun Dec 15 23:48:14 2013 +0200 @@ -30,7 +30,7 @@ stChkRequestItem("voting", $fake, array(CHK_TYPE, VT_BOOL, "Invalid data.") ) && - stChkRequestItem("showAuthors", $fake, + stChkRequestItem("show_authors", $fake, array(CHK_TYPE, VT_BOOL, "Invalid data.") ); } @@ -85,7 +85,7 @@ " <h2>#".$id." - ".chentities($item["name"])."</h2>\n". " ".stGetFormTextInput(40, SET_LEN_COMPO_NAME, "name", $id, $prefix, $item["name"])."\n". " ".stGetFormCheckBoxInput("visible", $id, $prefix, $item["visible"], "Visible")."\n". - " ".stGetFormCheckBoxInput("showAuthors", $id, $prefix, $item["showAuthors"], "Show authors")."\n". + " ".stGetFormCheckBoxInput("show_authors", $id, $prefix, $item["show_authors"], "Show authors")."\n". " ".stGetFormCheckBoxInput("voting", $id, $prefix, $item["voting"], "Enable voting")."<br />\n". " ".stGetFormTextArea(5, 60, "description", $id, $prefix, $item["description"])."\n<br />\n". " ".stGetFormButtonInput("update", $id, $prefix, "Update", "updateCompo(".$id.")")."\n"; @@ -267,9 +267,9 @@ function stGetInfoRotationLists($indent, $outer) { $sql = - "SELECT rotationListData.*, ". - "(SELECT COUNT(*) FROM rotationListSlides WHERE list_id=rotationListData.id) AS nslides ". - "FROM rotationListData ". + "SELECT rot_list_data.*, ". + "(SELECT COUNT(*) FROM rot_list_slides WHERE list_id=rot_list_data.id) AS nslides ". + "FROM rot_list_data ". "ORDER BY id DESC"; $str = stGetOptionListStart("ctrlRotationLists", $indent, $outer); @@ -295,7 +295,7 @@ { $str = stGetOptionListStart("ctrlDisplaySlides", $indent, $outer); - $sql = "SELECT * FROM displaySlides ORDER BY id DESC"; + $sql = "SELECT * FROM display_slides ORDER BY id DESC"; if (($res = stExecSQL($sql)) !== false) { foreach ($res as $item) @@ -309,7 +309,7 @@ function stGetInfoRotationListEditFull($indent, $outer, $list_id) { - $sql = stPrepareSQL("SELECT * FROM rotationListData WHERE id=%d", $list_id); + $sql = stPrepareSQL("SELECT * FROM rot_list_data WHERE id=%d", $list_id); if (($data = stFetchSQL($sql)) === false) return ""; @@ -321,7 +321,7 @@ "<div>Available slides:</div>\n". stGetOptionListStart("ctrlEDDisplaySlides", $indent." ", TRUE); - $sql = "SELECT * FROM displaySlides"; + $sql = "SELECT * FROM display_slides"; if (($res = stExecSQL($sql)) !== false) { foreach ($res as $item) @@ -348,10 +348,10 @@ function stGetInfoRotationListEditData($indent, $outer, $list_id) { $sql = stPrepareSQL( - "SELECT displaySlides.*,rotationListSlides.order_num FROM displaySlides ". - "LEFT JOIN rotationListSlides ON displaySlides.id=rotationListSlides.slide_id ". - "WHERE rotationListSlides.list_id=%d ". - "ORDER BY rotationListSlides.order_num DESC", + "SELECT display_slides.*,rot_list_slides.order_num FROM display_slides ". + "LEFT JOIN rot_list_slides ON display_slides.id=rot_list_slides.slide_id ". + "WHERE rot_list_slides.list_id=%d ". + "ORDER BY rot_list_slides.order_num DESC", $list_id); $str = stGetOptionListStart("ctrlEDRotationList", $indent, $outer); @@ -372,7 +372,7 @@ function stGetInfoActiveRotationList($indent, $outer) { - $sql = stPrepareSQL("SELECT * FROM rotationListData WHERE id=%d", + $sql = stPrepareSQL("SELECT * FROM rot_list_data WHERE id=%d", stGetDisplayVar("rotateList")); $str = $indent.($outer ? "<div id=\"ctrlActiveRotationList\">" : ""). @@ -396,7 +396,7 @@ $indent." <form method=\"post\" action=\"\" onsubmit=\"return updateDisplaySlide(".$slide_id.")\">\n". $indent." <div class=\"ctrlTitle\">Edit display slide</div>\n"; - $sql = stPrepareSQL("SELECT * FROM displaySlides WHERE id=%d", $slide_id); + $sql = stPrepareSQL("SELECT * FROM display_slides WHERE id=%d", $slide_id); if (($slide = stFetchSQL($sql)) !== false) { $str .= @@ -660,7 +660,7 @@ if (stChkRequestItem("id", $slide_id, array(CHK_TYPE, VT_INT, "Invalid data.")) && stChkRequestItem("duration", $slide_dur, array(CHK_RANGE, VT_INT, array(1, 60), "Invalid duration range, should be 1-60 min."))) { - $sql = stPrepareSQL("SELECT * FROM displaySlides WHERE id=%d", $slide_id); + $sql = stPrepareSQL("SELECT * FROM display_slides WHERE id=%d", $slide_id); if (($slide = stFetchSQL($sql)) !== false) { stSetDisplayVar("tempDuration", $slide_dur); @@ -685,10 +685,10 @@ case "copyDisplaySlide": if (stChkRequestItem("id", $slide_id, array(CHK_TYPE, VT_INT, "Invalid data."))) { - $sql = stPrepareSQL("SELECT * FROM displaySlides WHERE id=%d", $slide_id); + $sql = stPrepareSQL("SELECT * FROM display_slides WHERE id=%d", $slide_id); if (($slide = stFetchSQL($sql)) !== false) { - $sql = stPrepareSQL("INSERT INTO displaySlides (title,text) VALUES (%s,%s)", + $sql = stPrepareSQL("INSERT INTO display_slides (title,text) VALUES (%s,%s)", $slide["title"]." (copy)", $slide["text"]); if (stExecSQLCond($sql, "Display slide copied.") !== false) @@ -703,7 +703,7 @@ break; case "newDisplaySlide": - $sql = stPrepareSQL("INSERT INTO displaySlides (title) VALUES (%s)", "New slide"); + $sql = stPrepareSQL("INSERT INTO display_slides (title) VALUES (%s)", "New slide"); if (stExecSQLCond($sql, "Display slide created.") !== false) { $slide_id = $db->lastInsertId(); @@ -721,7 +721,7 @@ array(CHK_LTEQ, VT_STR, SET_LEN_DISP_SLIDE_TEXT, "Slide content too long.") )) { - $sql = stPrepareSQLUpdate("displaySlides", + $sql = stPrepareSQLUpdate("display_slides", "WHERE id=".$slide_id, array( "title" => "S", @@ -736,21 +736,21 @@ case "deleteDisplaySlide": if (stChkRequestItem("id", $slide_id, array(CHK_TYPE, VT_INT, "Invalid data."))) { - $sql = stPrepareSQL("DELETE FROM displaySlides WHERE id=%d", $slide_id); + $sql = stPrepareSQL("DELETE FROM display_slides WHERE id=%d", $slide_id); stExecSQLCond($sql, "Slide deleted."); - $sql = stPrepareSQL("DELETE FROM rotationListSlides WHERE slide_id=%d", $slide_id); + $sql = stPrepareSQL("DELETE FROM rot_list_slides WHERE slide_id=%d", $slide_id); stExecSQLCond($sql, "Slide list refs deleted."); stDisplayUpdated(); } break; case "newRotationList": - $sql = stPrepareSQL("INSERT INTO rotationListData (name) VALUES (%s)", "New list #"); + $sql = stPrepareSQL("INSERT INTO rot_list_data (name) VALUES (%s)", "New list #"); if (stExecSQLCond($sql, "Rotation list created.") !== false) { $list_id = $db->lastInsertId(); - $sql = stPrepareSQL("UPDATE rotationListData SET name=%s WHERE id=%d", + $sql = stPrepareSQL("UPDATE rot_list_data SET name=%s WHERE id=%d", "New list #".$list_id, $list_id); if (stExecSQLCond($sql, "OK!") !== false) @@ -764,7 +764,7 @@ array(CHK_GTEQ, VT_STR, 3, "Rotation list name too short."), array(CHK_LTEQ, VT_STR, SET_LEN_ROT_LIST_NAME, "Rotation list name too long."))) { - $sql = stPrepareSQLUpdate("rotationListData", + $sql = stPrepareSQLUpdate("rot_list_data", "WHERE id=".$list_id, array( "name" => "S", @@ -779,10 +779,10 @@ case "deleteRotationList": if (stChkRequestItem("id", $list_id, array(CHK_TYPE, VT_INT, "Invalid data."))) { - $sql = stPrepareSQL("DELETE FROM rotationListData WHERE id=%d", $list_id); + $sql = stPrepareSQL("DELETE FROM rot_list_data WHERE id=%d", $list_id); stExecSQLCond($sql, "List data deleted."); - $sql = stPrepareSQL("DELETE FROM rotationListSlides WHERE list_id=%d", $list_id); + $sql = stPrepareSQL("DELETE FROM rot_list_slides WHERE list_id=%d", $list_id); stExecSQLCond($sql, "List slide refs deleted."); stDisplayUpdated(); } @@ -801,9 +801,9 @@ if (stChkRequestItem("list_id", $list_id, array(CHK_TYPE, VT_INT, "Invalid data.")) && stChkRequestItem("slide_id", $slide_id, array(CHK_TYPE, VT_INT, "Invalid data."))) { - $nslides = stFetchSQLColumn(stPrepareSQL("SELECT COUNT(*) FROM rotationListSlides WHERE list_id=%d", $list_id)); + $nslides = stFetchSQLColumn(stPrepareSQL("SELECT COUNT(*) FROM rot_list_slides WHERE list_id=%d", $list_id)); $sql = stPrepareSQL( - "INSERT INTO rotationListSlides (list_id,slide_id,order_num) VALUES (%d,%d,%d)", + "INSERT INTO rot_list_slides (list_id,slide_id,order_num) VALUES (%d,%d,%d)", $list_id, $slide_id, $nslides+1); if (stExecSQLCond($sql, "Slide added to list.")) @@ -819,7 +819,7 @@ stChkRequestItem("slide_id", $slide_id, array(CHK_TYPE, VT_INT, "Invalid data.")) && stChkRequestItem("order_num", $order_num, array(CHK_TYPE, VT_INT, "Invalid data."))) { - $sql = stPrepareSQL("DELETE FROM rotationListSlides WHERE list_id=%d AND slide_id=%d AND order_num=%d", + $sql = stPrepareSQL("DELETE FROM rot_list_slides WHERE list_id=%d AND slide_id=%d AND order_num=%d", $list_id, $slide_id, $order_num); if (stExecSQLCond($sql, "List slide refs deleted.")) @@ -1362,7 +1362,7 @@ if ($type == "compo" && stValidateRequestCompoData(FALSE)) { $sql = stPrepareSQL( - "INSERT INTO compos (name,description,visible,voting,showAuthors) VALUES (%S,%Q,0,0,0)", + "INSERT INTO compos (name,description,visible,voting,show_authors) VALUES (%S,%Q,0,0,0)", "name", "description"); stExecSQLCond($sql, "OK, compo added."); @@ -1446,7 +1446,7 @@ "description" => "Q", "visible" => "B", "voting" => "B", - "showAuthors" => "B", + "show_authors" => "B", )); stExecSQLCond($sql, "OK, compo updated.");