| 1 | <?php |
|---|
| 2 | /* |
|---|
| 3 | +-------------------------------------------------------------------------+ |
|---|
| 4 | | Copyright (c) 2005, Kreotek LLC | |
|---|
| 5 | | All rights reserved. | |
|---|
| 6 | +-------------------------------------------------------------------------+ |
|---|
| 7 | | | |
|---|
| 8 | | Redistribution and use in source and binary forms, with or without | |
|---|
| 9 | | modification, are permitted provided that the following conditions are | |
|---|
| 10 | | met: | |
|---|
| 11 | | | |
|---|
| 12 | | - Redistributions of source code must retain the above copyright | |
|---|
| 13 | | notice, this list of conditions and the following disclaimer. | |
|---|
| 14 | | | |
|---|
| 15 | | - Redistributions in binary form must reproduce the above copyright | |
|---|
| 16 | | notice, this list of conditions and the following disclaimer in the | |
|---|
| 17 | | documentation and/or other materials provided with the distribution. | |
|---|
| 18 | | | |
|---|
| 19 | | - Neither the name of Kreotek LLC nor the names of its contributore may | |
|---|
| 20 | | be used to endorse or promote products derived from this software | |
|---|
| 21 | | without specific prior written permission. | |
|---|
| 22 | | | |
|---|
| 23 | | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS | |
|---|
| 24 | | "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT | |
|---|
| 25 | | LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A | |
|---|
| 26 | | PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT | |
|---|
| 27 | | OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, | |
|---|
| 28 | | SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT | |
|---|
| 29 | | LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, | |
|---|
| 30 | | DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY | |
|---|
| 31 | | THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT | |
|---|
| 32 | | (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE | |
|---|
| 33 | | OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | |
|---|
| 34 | | | |
|---|
| 35 | +-------------------------------------------------------------------------+ |
|---|
| 36 | */ |
|---|
| 37 | |
|---|
| 38 | //============================================= |
|---|
| 39 | //functions |
|---|
| 40 | //============================================= |
|---|
| 41 | function delete_record($theids){ |
|---|
| 42 | global $dblink; |
|---|
| 43 | |
|---|
| 44 | $whereclause=buildWhereClause($theids,"discounts.id"); |
|---|
| 45 | |
|---|
| 46 | $querystatement = "UPDATE discounts SET inactive=1,modifiedby=\"".$_SESSION["userinfo"]["id"]."\" WHERE ".$whereclause.";"; |
|---|
| 47 | $queryresult = mysql_query($querystatement,$dblink); |
|---|
| 48 | if(!$queryresult) reportError(300,"Update Failed: ".mysql_error($dblink)." -- ".$querystatement); |
|---|
| 49 | |
|---|
| 50 | $message=buildStatusMessage(mysql_affected_rows($dblink),count($theids)); |
|---|
| 51 | $message.=" marked inactive."; |
|---|
| 52 | return $message; |
|---|
| 53 | } |
|---|
| 54 | ?> |
|---|
