public static function edit_payment_plan($id, $opt = array()) { global $db; if (!$GLOBALS['me']->is_admin) { return false; } $opt = array_map('trim', $opt); $opt['price'] = \site\utils::make_money_format($opt['price']); if (empty($opt['name']) || $opt['price'] < 0 || $opt['credits'] <= 0) { return false; } $plan = \query\payments::plan_infos($id); $avatar = \site\images::upload(@$_FILES['logo'], 'payment_plan_', array('path' => DIR . '/', 'max_size' => 1024, 'max_width' => 500, 'max_height' => 600, 'current' => $plan->image)); $stmt = $db->stmt_init(); $stmt->prepare("UPDATE " . DB_TABLE_PREFIX . "p_plans SET name = ?, description = ?, price = ?, credits = ?, image = ?, lastupdate_by = ?, lastupdate = NOW(), visible = ? WHERE id = ?"); $stmt->bind_param("ssdisiii", $opt['name'], $opt['description'], $opt['price'], $opt['credits'], $avatar, $GLOBALS['me']->ID, $opt['publish'], $id); $execute = $stmt->execute(); $stmt->close(); if ($execute) { return true; } return false; }