0){ $where = "id = ".$db->mySQLSafe($_GET['delete']); $delete = $db->delete($glob['dbprefix']."CubeCart_inv_lang", $where, ""); if($delete == TRUE){ $msg = "
".$lang['admin']['products']['delete_success']."
"; } else { $msg = "".$lang['admin']['products']['delete_fail']."
"; } } elseif(isset($_POST['id']) && $_POST['id']>0){ // instantiate db class $db = new db(); $record["name"] = $db->mySQLSafe($_POST['name']); $record["prod_lang"] = $db->mySQLSafe($_POST['prod_lang']); $record["prod_master_id"] = $db->mySQLSafe($_GET['prod_master_id']); $record["description"] = $db->mySQLSafe($_POST['description']); $where = "id = ".$db->mySQLSafe($_POST['id']); $update =$db->update($glob['dbprefix']."CubeCart_inv_lang", $record, $where); if($update == TRUE){ $msg = "'".$_POST['name']."' ".$lang['admin']['products']['update_successful']."
"; } else { $msg = "'".$lang['admin']['products']['update_fail']."
"; } } elseif(isset($_POST['id']) && empty($_POST['id'])){ // instantiate db class $db = new db(); $record["name"] = $db->mySQLSafe($_POST['name']); $record["prod_lang"] = $db->mySQLSafe($_POST['prod_lang']); $record["prod_master_id"] = $db->mySQLSafe($_GET['prod_master_id']); $record["description"] = $db->mySQLSafe($_POST['description']); $insert = $db->insert($glob['dbprefix']."CubeCart_inv_lang", $record); if($insert == TRUE){ $msg = "'".$_POST['name']."' ".$lang['admin']['products']['add_success']."
"; } else { $msg = "".$lang['admin']['products']['add_fail']."
"; } } // retrieve current documents if($_GET['mode']!=="new"){ $db = new db(); // make sql query if(isset($_GET['edit']) && $_GET['edit']>0){ $query = sprintf("SELECT * FROM ".$glob['dbprefix']."CubeCart_inv_lang WHERE id = %s", $db->mySQLSafe($_GET['edit'])); } else { $query = sprintf("SELECT * FROM ".$glob['dbprefix']."CubeCart_inv_lang WHERE prod_master_id = %s ORDER BY name ASC", $db->mySQLSafe($_GET['prod_master_id'])); } // query database $results = $db->select($query); } // end if mode is not new ?>href="?mode=new&prod_master_id=" class="txtLink">![]() |
![]() |
href="?edit=&prod_master_id=" class="txtLink" > | href="javascript:decision('','?delete=&prod_master_id=');" class="txtLink" > |