Mercurial > hg > fapweb
changeset 548:b3e9c3eedc23
Use the helper functions for insertion.
| author | Matti Hamalainen <ccr@tnsp.org> |
|---|---|
| date | Mon, 16 Dec 2013 01:25:44 +0200 |
| parents | 1fceb6f57c90 |
| children | e5732b25c839 |
| files | admajax.php |
| diffstat | 1 files changed, 10 insertions(+), 12 deletions(-) [+] |
line wrap: on
line diff
--- a/admajax.php Mon Dec 16 01:25:24 2013 +0200 +++ b/admajax.php Mon Dec 16 01:25:44 2013 +0200 @@ -693,11 +693,10 @@ $sql = stPrepareSQL("INSERT INTO display_slides (title,text) VALUES (%s,%s)", $slide["title"]." (copy)", $slide["text"]); - if (stExecSQLCond($sql, "Display slide copied.") !== false) - { - $new_id = $db->lastInsertId(); + if (($new_id = stExecSQLInsert($sql)) !== false) echo stGetInfoDisplaySlideEdit("", TRUE, $new_id); - } + else + stError("Could not insert slide."); } else stError("No such slide ID #".$slide_id); @@ -706,11 +705,8 @@ case "newDisplaySlide": $sql = stPrepareSQL("INSERT INTO display_slides (title) VALUES (%s)", "New slide"); - if (stExecSQLCond($sql, "Display slide created.") !== false) - { - $slide_id = $db->lastInsertId(); + if (($slide_id = stExecSQLInsert($sql)) !== false) echo stGetInfoDisplaySlideEdit("", TRUE, $slide_id); - } break; case "updateDisplaySlide": @@ -730,8 +726,11 @@ "text" => "S", )); - stExecSQLCond($sql, "OK, slide updated."); - stDisplayUpdated(); + if (stExecSQL($sql) !== false) + { + stSetStatus(200, "Slide updated."); + stDisplayUpdated(); + } } break; @@ -749,9 +748,8 @@ case "newRotationList": $sql = stPrepareSQL("INSERT INTO rot_list_data (name) VALUES (%s)", "New list #"); - if (stExecSQLCond($sql, "Rotation list created.") !== false) + if (($list_id = stExecSQLInsert($sql)) !== false) { - $list_id = $db->lastInsertId(); $sql = stPrepareSQL("UPDATE rot_list_data SET name=%s WHERE id=%d", "New list #".$list_id, $list_id);