Customize button text and type. Make sure you have added 'Option' module, cause included data from 'Option' module.
| File | Folder Link |
|---|---|
| form.php | \\SYNAS\Allan\DOCUMENTATION\Component\Button & Link Type\rckuc\wolf\app\views\price_package |
| style.css | \\SYNAS\Allan\DOCUMENTATION\Component\Button & Link Type\rckuc\wolf\admin\themes\black_and_white |
| backend.js | \\SYNAS\Allan\DOCUMENTATION\Component\Button & Link Type\rckuc\wolf\admin\javascript |
| PricePackageController.php | \\SYNAS\Allan\DOCUMENTATION\Component\Button & Link Type\rckuc\wolf\app\controllers |
Update: form.php (or your create.php and view.php)
Insert this inside your <form>
<?php
$btn_show = (!empty($postdata['btn_status']) ? $postdata['btn_status'] : (!empty($price_package->btn_status) ? $price_package->btn_status : '0'));
$redirect_show = (!empty($postdata['redirect_status']) ? $postdata['redirect_status'] : (!empty($portfolio->redirect_status) ? $portfolio->redirect_status : '0'));
?>
<h3><?php echo __('Button'); ?></h3>
<div id="meta-pages" class="switch_container">
<label class="switch">
<input type="checkbox" class="status_switch toggle_btn_section" name="price_package[btn_status]" <?php echo $btn_show == 1 ? 'checked' : ''; ?> value="1">
<span class="switch_slider round"></span>
</label>
<label class="switch_label"><?php echo $btn_show == 1 ? 'Show' : 'Hidden'; ?><label>
</div>
<div id="btn_section">
<div>
<label>Button Caption:</label><br>
<input class="textbox" name="price_package[btn_caption]" size="40" type="text" placeholder="Example: Learn More, Contact Us..." value="<?php echo(!empty($postdata['btn_caption']) ? $postdata['btn_caption'] : (!empty($price_package->btn_caption) ? $price_package->btn_caption : '')) ?>" />
</div>
<div>
<label>Button Type:</label><br>
<select id="btn_type" class="textbox" name="price_package[btn_type]">
<?php $link_types = Option::findByCategory('link_type'); ?>
<option></option>
<?php foreach($link_types as $link_type): ?>
<option value="<?php echo $link_type->code; ?>" <?php echo ($postdata['btn_type'] == $link_type->code ? 'selected' : (!empty($price_package) && $price_package->btn_type == $link_type->code ? 'selected' : '')) ;?>><?php echo $link_type->name; ?></option>
<?php endforeach; ?>
</select>
</div>
<div id="external_link">
<label>Link To:</label><br>
<input class="textbox" name="price_package[btn_external_link]" size="40" type="text" placeholder="External Webiste" value="<?php echo(!empty($postdata['btn_external_link']) ? $postdata['btn_external_link'] : (!empty($price_package->btn_external_link) ? $price_package->btn_external_link : '')) ?>" />
</div>
<?php
$btn_page_id = (!empty($postdata) && !empty($postdata['btn_page_id']) ? $postdata['btn_page_id'] : (!empty($price_package) && !empty($price_package->btn_page_id) ? $price_package->btn_page_id : ''));
?>
<div id="assign_to_page">
<label>Assign To Page :</label><br>
<select id="page_id" name="price_package[btn_page_id]">
<option value=""></option>
<?php
foreach($pages as $page){
$page_selected = ($page->id==$btn_page_id?"selected":"");
if($page->id!=1){
if($page->hasChildren($page->id)){
echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>";
$subpages = $page->childrenOf($page->id);
foreach($subpages as $subpage){
$subpage_selected = ($subpage->id==$btn_page_id?"selected":"");
echo "<option value='".$subpage->id."' ".$subpage_selected."> - - ".$subpage->title."</option>";
$subpages2 = $subpage->childrenOf($subpage->id);
foreach($subpages2 as $subpage2){
$subpage2_selected = ($subpage2->id==$btn_page_id?"selected":"");
echo "<option value='".$subpage2->id."' ".$subpage2_selected."> - - - - ".$subpage2->title."</option>";
$subpages3 = $subpage2->childrenOf($subpage2->id);
foreach($subpages3 as $subpage3){
$subpage3_selected = ($subpage3->id==$btn_page_id?"selected":"");
echo "<option value='".$subpage3->id."' ".$subpage3_selected."> - - - - - - ".$subpage3->title."</option>";
}
}
}
}else{
echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>";
}
}else{
echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>";
}
}
?>
</select>
</div>
<div id="redirect_status">
<div id="meta-pages" class="switch_container">
<label class="switch">
<input type="checkbox" name="portfolio[redirect_status]" <?php echo $redirect_show == 1 ? 'checked' : ''; ?> value="1">
<span class="switch_slider round"></span>
</label>
<label class="switch_label">Open New Tab<label>
</div>
</div>
</div>
<br>
<?php
$btn_show = (!empty($postdata['btn_status']) ? $postdata['btn_status'] : (!empty($price_package->btn_status) ? $price_package->btn_status : '0'));
$redirect_show = (!empty($postdata['redirect_status']) ? $postdata['redirect_status'] : (!empty($portfolio->redirect_status) ? $portfolio->redirect_status : '0'));
?>
<h3><?php echo __('Button'); ?></h3>
<div id="meta-pages" class="switch_container">
<label class="switch">
<input type="checkbox" class="status_switch toggle_btn_section" name="price_package[btn_status]" <?php echo $btn_show == 1 ? 'checked' : ''; ?> value="1">
<span class="switch_slider round"></span>
</label>
<label class="switch_label"><?php echo $btn_show == 1 ? 'Show' : 'Hidden'; ?><label>
</div>
<div id="btn_section">
<div>
<label>Button Caption:</label><br>
<input class="textbox" name="price_package[btn_caption]" size="40" type="text" placeholder="Example: Learn More, Contact Us..." value="<?php echo(!empty($postdata['btn_caption']) ? $postdata['btn_caption'] : (!empty($price_package->btn_caption) ? $price_package->btn_caption : '')) ?>" />
</div>
<div>
<label>Button Type:</label><br>
<select id="btn_type" class="textbox" name="price_package[btn_type]">
<?php $link_types = Option::findByCategory('link_type'); ?>
<option></option>
<?php foreach($link_types as $link_type): ?>
<option value="<?php echo $link_type->code; ?>" <?php echo ($postdata['btn_type'] == $link_type->code ? 'selected' : (!empty($price_package) && $price_package->btn_type == $link_type->code ? 'selected' : '')) ;?>><?php echo $link_type->name; ?></option>
<?php endforeach; ?>
</select>
</div>
<div id="external_link">
<label>Link To:</label><br>
<input class="textbox" name="price_package[btn_external_link]" size="40" type="text" placeholder="External Webiste" value="<?php echo(!empty($postdata['btn_external_link']) ? $postdata['btn_external_link'] : (!empty($price_package->btn_external_link) ? $price_package->btn_external_link : '')) ?>" />
</div>
<?php
$btn_page_id = (!empty($postdata) && !empty($postdata['btn_page_id']) ? $postdata['btn_page_id'] : (!empty($price_package) && !empty($price_package->btn_page_id) ? $price_package->btn_page_id : ''));
?>
<div id="assign_to_page">
<label>Assign To Page :</label><br>
<select id="page_id" name="price_package[btn_page_id]">
<option value=""></option>
<?php
foreach($pages as $page){
$page_selected = ($page->id==$btn_page_id?"selected":"");
if($page->id!=1){
if($page->hasChildren($page->id)){
echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>";
$subpages = $page->childrenOf($page->id);
foreach($subpages as $subpage){
$subpage_selected = ($subpage->id==$btn_page_id?"selected":"");
echo "<option value='".$subpage->id."' ".$subpage_selected."> - - ".$subpage->title."</option>";
$subpages2 = $subpage->childrenOf($subpage->id);
foreach($subpages2 as $subpage2){
$subpage2_selected = ($subpage2->id==$btn_page_id?"selected":"");
echo "<option value='".$subpage2->id."' ".$subpage2_selected."> - - - - ".$subpage2->title."</option>";
$subpages3 = $subpage2->childrenOf($subpage2->id);
foreach($subpages3 as $subpage3){
$subpage3_selected = ($subpage3->id==$btn_page_id?"selected":"");
echo "<option value='".$subpage3->id."' ".$subpage3_selected."> - - - - - - ".$subpage3->title."</option>";
}
}
}
}else{
echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>";
}
}else{
echo "<option value='".$page->id."' ".$page_selected.">".$page->title."</option>";
}
}
?>
</select>
</div>
<div id="redirect_status">
<div id="meta-pages" class="switch_container">
<label class="switch">
<input type="checkbox" name="portfolio[redirect_status]" <?php echo $redirect_show == 1 ? 'checked' : ''; ?> value="1">
<span class="switch_slider round"></span>
</label>
<label class="switch_label">Open New Tab<label>
</div>
</div>
</div>
<br>
Update: style.css
.display_flex {
display: flex;
align-items: center;
margin: 0.5rem 0;
}
/* Button & Link Type */
#btn_section > div {
margin: 0.5rem 0;
}
.display_flex {
display: flex;
align-items: center;
margin: 0.5rem 0;
}
/* Button & Link Type */
#btn_section > div {
margin: 0.5rem 0;
}
Update: backend.js
// For Button Link
$(document).ready(function() {
function toggle_btn_section() {
if($("input.toggle_btn_section").is(":checked")) {
$("#btn_section").slideDown();
} else {
$("#btn_section").slideUp();
}
}
$("input.toggle_btn_section").click(function () {
toggle_btn_section();
})
toggle_btn_section();
function toggleButtonType() {
if ($("#btn_type").val() == "external_link") {
$("#external_link").slideDown();
$("#assign_to_page").slideUp();
if ($("#external_link input").val() !== "") {
$("#redirect_status").slideDown();
} else {
$("#redirect_status").slideUp();
}
} else if ($("#btn_type").val() == "assign_to_page") {
$("#assign_to_page").slideDown();
$("#external_link").slideUp();
if ($("#assign_to_page select").val() !== "") {
$("#redirect_status").slideDown();
} else {
$("#redirect_status").slideUp();
}
} else {
$("#external_link, #assign_to_page, #redirect_status").slideUp();
}
}
toggleButtonType();
$(document).on("change", "#btn_type", function() {
toggleButtonType();
})
$(document).on("keyup", "#external_link input", function() {
toggleButtonType();
})
$(document).on("change", "#assign_to_page select", function() {
toggleButtonType();
})
})
// For Button Link
$(document).ready(function() {
function toggle_btn_section() {
if($("input.toggle_btn_section").is(":checked")) {
$("#btn_section").slideDown();
} else {
$("#btn_section").slideUp();
}
}
$("input.toggle_btn_section").click(function () {
toggle_btn_section();
})
toggle_btn_section();
function toggleButtonType() {
if ($("#btn_type").val() == "external_link") {
$("#external_link").slideDown();
$("#assign_to_page").slideUp();
if ($("#external_link input").val() !== "") {
$("#redirect_status").slideDown();
} else {
$("#redirect_status").slideUp();
}
} else if ($("#btn_type").val() == "assign_to_page") {
$("#assign_to_page").slideDown();
$("#external_link").slideUp();
if ($("#assign_to_page select").val() !== "") {
$("#redirect_status").slideDown();
} else {
$("#redirect_status").slideUp();
}
} else {
$("#external_link, #assign_to_page, #redirect_status").slideUp();
}
}
toggleButtonType();
$(document).on("change", "#btn_type", function() {
toggleButtonType();
})
$(document).on("keyup", "#external_link input", function() {
toggleButtonType();
})
$(document).on("change", "#assign_to_page select", function() {
toggleButtonType();
})
})
Update: PricepackageController.php
Add verification in _add() & _edit() function
<?php
class PricePackageController extends Controller {
private function _addpricepackage(){
if($_POST["action"]=="add"){
$data = $_POST['price_package'];
Flash::set('postdata', $data);
// verification
if (empty($data['name'])){
Flash::set('error', __('You have to specify Package Name.'));
redirect(get_url('price_package/addpricepackage'));
}
// if (empty($data['description'])){
// Flash::set('error', __('You have to specify Description.'));
// redirect(get_url('price_package/addpricepackage'));
// }
if (empty($data['free_trial_status'])){
$data['free_trial_status'] = 0;
}
if (empty($data['contract_status'])){
$data['contract_status'] = 0;
}
if (empty($data['btn_status'])){
$data['btn_status'] = 0;
} else {
if (empty($data['btn_caption'])){
Flash::set('error', __('You have to specify Button Caption.'));
redirect(get_url('price_package/addpricepackage'));
}
if (empty($data['btn_type'])){
Flash::set('error', __('You have to specify Button Type.'));
redirect(get_url('price_package/addpricepackage'));
} else {
if ($data['btn_type'] == 'external_link') {
if (empty($data['btn_external_link'])){
Flash::set('error', __('You have to specify External Link.'));
redirect(get_url('price_package/addpricepackage'));
} else {
if (empty($data['redirect_status'])) {
$data['redirect_status'] = 0;
}
}
}
if ($data['btn_type'] == 'assign_to_page') {
if (empty($data['btn_page_id'])){
Flash::set('error', __('You have to Assign a page for Button.'));
redirect(get_url('price_package/addpricepackage'));
} else {
if (empty($data['redirect_status'])) {
$data['redirect_status'] = 0;
}
}
}
}
}
if (empty($data['status'])){
$data['status'] = 0;
}
// if (empty($data['plan_policies'])){
// Flash::set('error', __('You have to specify Plan Policies.'));
// redirect(get_url('price_package/addpricepackage'));
// }
$price_package = new PricePackage($data);
$price_package->created_by_id = AuthUser::getId();
$price_package->created_on = date('Y-m-d H:i:s');
if (!$price_package->save()) {
Flash::set('error', __('Price Package could not be added!'));
redirect(get_url('price_package/'));
} else {
$price_package_id = $price_package->lastInsertId();
$overwrite = true;
$failed = [];
// Upload 1 type image (Add more field inside $fields if you have another image)
// Make sure fields name match database name
$fields = ['package_icon'];
foreach ($fields as $field) {
$failed[] = $this->upload_img('price_package', $field, $overwrite, $price_package_id, $price_package->$field);
}
// Create A New Record In 'package_payment'
$payment_data = [];
$package_payment = new PackagePayment($payment_data);
$package_payment->package_id = $price_package_id;
if (!$package_payment->save()) {
Flash::set('error', __('Package Payment could not be added!'));
}else if (!empty(array_filter($failed))) {
Flash::set('error', __('Failed to upload: ' . implode(', ', $failed)));
} else {
Flash::set('success', __('Price Package has been added.'));
}
if (isset($_POST['commit'])) {
Flash::set('postdata', null);
redirect(get_url('price_package'));
} else {
Flash::set('postdata', null);
redirect(get_url('price_package/editpricepackage/'.$price_package_id));
};
}
redirect(get_url('price_package'));
}
}
private function _editpricepackage($id){
use_helper('Validate');
$data = $_POST['price_package'];
Flash::set('postdata', $data);
$price_package = PricePackage::findById($id);
if (!$price_package) {
Flash::set('error', __('Price Package could not be found!'));
redirect(get_url('price_package'));
}
// verification
if (empty($data['name'])){
Flash::set('error', __('You have to specify Package Name.'));
redirect(get_url('price_package/editpricepackage/'.$id));
}
// if (empty($data['description'])){
// Flash::set('error', __('You have to specify Description.'));
// redirect(get_url('price_package/editpricepackage/'.$id));
// }
if (empty($data['free_trial_status'])){
$data['free_trial_status'] = 0;
}
if (empty($data['contract_status'])){
$data['contract_status'] = 0;
}
if (empty($data['btn_status'])){
$data['btn_status'] = 0;
} else {
if (empty($data['btn_caption'])){
Flash::set('error', __('You have to specify Button Caption.'));
redirect(get_url('price_package/editpricepackage/'.$id));
}
if (empty($data['btn_type'])){
Flash::set('error', __('You have to specify Button Type.'));
redirect(get_url('price_package/editpricepackage/'.$id));
} else {
if ($data['btn_type'] == 'external_link') {
if (empty($data['btn_external_link'])){
Flash::set('error', __('You have to specify External Link.'));
redirect(get_url('price_package/editpricepackage/'.$id));
} else {
if (empty($data['redirect_status'])) {
$data['redirect_status'] = 0;
}
}
}
if ($data['btn_type'] == 'assign_to_page') {
if (empty($data['btn_page_id'])){
Flash::set('error', __('You have to Assign a page for Button.'));
redirect(get_url('price_package/editpricepackage/'.$id));
} else {
if (empty($data['redirect_status'])) {
$data['redirect_status'] = 0;
}
}
}
}
}
if (empty($data['status'])){
$data['status'] = 0;
}
// if (empty($data['plan_policies'])){
// Flash::set('error', __('You have to specify Plan Policies.'));
// redirect(get_url('price_package/editpricepackage/'.$id));
// }
$price_package->setFromData($data);
$price_package->updated_by_id = AuthUser::getId();
$price_package->updated_on = date('Y-m-d H:i:s');
if ($price_package->save()) {
$overwrite = true;
$failed = [];
// Upload 1 type image (Add more field inside $fields if you have another image)
// Make sure fields name match database name
$fields = ['package_icon'];
foreach ($fields as $field) {
$failed[] = $this->upload_img('price_package', $field, $overwrite, $price_package->id, $price_package->$field);
}
if (!empty(array_filter($failed))) {
Flash::set('error', __('Failed to update: ' . implode(', ', $failed)));
} else {
Flash::set('success', __('Price Package has been updated.'));
}
}
else {
Flash::set('error', __('Price Package could not be saved.'));
}
if (isset($_POST['commit']))
redirect(get_url('price_package'));
else {
Flash::set('postdata', null);
redirect(get_url('price_package/editpricepackage/'.$id));
}
}
}
?>
<?php
class PricePackageController extends Controller {
private function _addpricepackage(){
if($_POST["action"]=="add"){
$data = $_POST['price_package'];
Flash::set('postdata', $data);
// verification
if (empty($data['name'])){
Flash::set('error', __('You have to specify Package Name.'));
redirect(get_url('price_package/addpricepackage'));
}
// if (empty($data['description'])){
// Flash::set('error', __('You have to specify Description.'));
// redirect(get_url('price_package/addpricepackage'));
// }
if (empty($data['free_trial_status'])){
$data['free_trial_status'] = 0;
}
if (empty($data['contract_status'])){
$data['contract_status'] = 0;
}
if (empty($data['btn_status'])){
$data['btn_status'] = 0;
} else {
if (empty($data['btn_caption'])){
Flash::set('error', __('You have to specify Button Caption.'));
redirect(get_url('price_package/addpricepackage'));
}
if (empty($data['btn_type'])){
Flash::set('error', __('You have to specify Button Type.'));
redirect(get_url('price_package/addpricepackage'));
} else {
if ($data['btn_type'] == 'external_link') {
if (empty($data['btn_external_link'])){
Flash::set('error', __('You have to specify External Link.'));
redirect(get_url('price_package/addpricepackage'));
} else {
if (empty($data['redirect_status'])) {
$data['redirect_status'] = 0;
}
}
}
if ($data['btn_type'] == 'assign_to_page') {
if (empty($data['btn_page_id'])){
Flash::set('error', __('You have to Assign a page for Button.'));
redirect(get_url('price_package/addpricepackage'));
} else {
if (empty($data['redirect_status'])) {
$data['redirect_status'] = 0;
}
}
}
}
}
if (empty($data['status'])){
$data['status'] = 0;
}
// if (empty($data['plan_policies'])){
// Flash::set('error', __('You have to specify Plan Policies.'));
// redirect(get_url('price_package/addpricepackage'));
// }
$price_package = new PricePackage($data);
$price_package->created_by_id = AuthUser::getId();
$price_package->created_on = date('Y-m-d H:i:s');
if (!$price_package->save()) {
Flash::set('error', __('Price Package could not be added!'));
redirect(get_url('price_package/'));
} else {
$price_package_id = $price_package->lastInsertId();
$overwrite = true;
$failed = [];
// Upload 1 type image (Add more field inside $fields if you have another image)
// Make sure fields name match database name
$fields = ['package_icon'];
foreach ($fields as $field) {
$failed[] = $this->upload_img('price_package', $field, $overwrite, $price_package_id, $price_package->$field);
}
// Create A New Record In 'package_payment'
$payment_data = [];
$package_payment = new PackagePayment($payment_data);
$package_payment->package_id = $price_package_id;
if (!$package_payment->save()) {
Flash::set('error', __('Package Payment could not be added!'));
}else if (!empty(array_filter($failed))) {
Flash::set('error', __('Failed to upload: ' . implode(', ', $failed)));
} else {
Flash::set('success', __('Price Package has been added.'));
}
if (isset($_POST['commit'])) {
Flash::set('postdata', null);
redirect(get_url('price_package'));
} else {
Flash::set('postdata', null);
redirect(get_url('price_package/editpricepackage/'.$price_package_id));
};
}
redirect(get_url('price_package'));
}
}
private function _editpricepackage($id){
use_helper('Validate');
$data = $_POST['price_package'];
Flash::set('postdata', $data);
$price_package = PricePackage::findById($id);
if (!$price_package) {
Flash::set('error', __('Price Package could not be found!'));
redirect(get_url('price_package'));
}
// verification
if (empty($data['name'])){
Flash::set('error', __('You have to specify Package Name.'));
redirect(get_url('price_package/editpricepackage/'.$id));
}
// if (empty($data['description'])){
// Flash::set('error', __('You have to specify Description.'));
// redirect(get_url('price_package/editpricepackage/'.$id));
// }
if (empty($data['free_trial_status'])){
$data['free_trial_status'] = 0;
}
if (empty($data['contract_status'])){
$data['contract_status'] = 0;
}
if (empty($data['btn_status'])){
$data['btn_status'] = 0;
} else {
if (empty($data['btn_caption'])){
Flash::set('error', __('You have to specify Button Caption.'));
redirect(get_url('price_package/editpricepackage/'.$id));
}
if (empty($data['btn_type'])){
Flash::set('error', __('You have to specify Button Type.'));
redirect(get_url('price_package/editpricepackage/'.$id));
} else {
if ($data['btn_type'] == 'external_link') {
if (empty($data['btn_external_link'])){
Flash::set('error', __('You have to specify External Link.'));
redirect(get_url('price_package/editpricepackage/'.$id));
} else {
if (empty($data['redirect_status'])) {
$data['redirect_status'] = 0;
}
}
}
if ($data['btn_type'] == 'assign_to_page') {
if (empty($data['btn_page_id'])){
Flash::set('error', __('You have to Assign a page for Button.'));
redirect(get_url('price_package/editpricepackage/'.$id));
} else {
if (empty($data['redirect_status'])) {
$data['redirect_status'] = 0;
}
}
}
}
}
if (empty($data['status'])){
$data['status'] = 0;
}
// if (empty($data['plan_policies'])){
// Flash::set('error', __('You have to specify Plan Policies.'));
// redirect(get_url('price_package/editpricepackage/'.$id));
// }
$price_package->setFromData($data);
$price_package->updated_by_id = AuthUser::getId();
$price_package->updated_on = date('Y-m-d H:i:s');
if ($price_package->save()) {
$overwrite = true;
$failed = [];
// Upload 1 type image (Add more field inside $fields if you have another image)
// Make sure fields name match database name
$fields = ['package_icon'];
foreach ($fields as $field) {
$failed[] = $this->upload_img('price_package', $field, $overwrite, $price_package->id, $price_package->$field);
}
if (!empty(array_filter($failed))) {
Flash::set('error', __('Failed to update: ' . implode(', ', $failed)));
} else {
Flash::set('success', __('Price Package has been updated.'));
}
}
else {
Flash::set('error', __('Price Package could not be saved.'));
}
if (isset($_POST['commit']))
redirect(get_url('price_package'));
else {
Flash::set('postdata', null);
redirect(get_url('price_package/editpricepackage/'.$id));
}
}
}
?>
Add these 6 columns in myPhpAdmin:
ALTER TABLE `your_table_name`
ADD COLUMN `btn_status` INT(1) NULL DEFAULT '0',
ADD COLUMN `btn_caption` VARCHAR(100) DEFAULT NULL,
ADD COLUMN `btn_type` VARCHAR(100) DEFAULT NULL,
ADD COLUMN `btn_external_link` VARCHAR(100) DEFAULT NULL,
ADD COLUMN `btn_page_id` INT(11) DEFAULT NULL,
ADD COLUMN `redirect_status` INT(1) NULL DEFAULT '0';
ALTER TABLE `your_table_name`
ADD COLUMN `btn_status` INT(1) NULL DEFAULT '0',
ADD COLUMN `btn_caption` VARCHAR(100) DEFAULT NULL,
ADD COLUMN `btn_type` VARCHAR(100) DEFAULT NULL,
ADD COLUMN `btn_external_link` VARCHAR(100) DEFAULT NULL,
ADD COLUMN `btn_page_id` INT(11) DEFAULT NULL,
ADD COLUMN `redirect_status` INT(1) NULL DEFAULT '0';