Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Paytm	[ DIR ]	drwxr-xr-x
copyinoasis	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
easy_zip	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
jquery-ui-1.9	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
links	[ DIR ]	drwxr-xr-x
razorpay	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
tarka_pdf	[ DIR ]	drwxr-xr-x
adds.jpg	39.03 KB	-rwxr-xr-x
adds1.jpg	293.14 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
cconfig.php	1.43 KB	-rwxr-xr-x
cconfig_old.php	1.12 KB	-rwxr-xr-x
db.sql	11.87 KB	-rwxr-xr-x
index.php	5.46 KB	-rwxr-xr-x
index17042018.php	5.45 KB	-rwxr-xr-x
index_13112017.php	4.33 KB	-rwxr-xr-x
index_stop.php	4.62 KB	-rwxr-xr-x
pgResponse.php	5.35 KB	-rwxr-xr-x
rcub_razorpay.csv	67 B	-rwxr-xr-x
result.php	3.33 KB	-rwxr-xr-x
result_17042018.php	3.11 KB	-rwxr-xr-x
subjectDetails.php	1.14 KB	-rwxr-xr-x
verify.php	5.24 KB	-rwxr-xr-x

Code Editor : db.sql

/*
SQLyog Ultimate v8.3 
MySQL - 5.1.32-community : Database - resultsg_kus
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`resultsg_kus` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `resultsg_kus`;

/*Table structure for table `res_fee` */

DROP TABLE IF EXISTS `res_fee`;

CREATE TABLE `res_fee` (
  `internal_code` int(11) NOT NULL AUTO_INCREMENT,
  `FDEGREE` varchar(5) NOT NULL,
  `FEXAMNO` varchar(1) NOT NULL,
  `FREGNO` varchar(10) NOT NULL,
  `FCOLLCODE` varchar(10) DEFAULT NULL,
  `FRESULTDATE` varchar(50) DEFAULT NULL,
  `FRVLASTDATE` date DEFAULT NULL,
  `FRTLASTDATE` date DEFAULT NULL,
  `FXEROXLASTDATE` date DEFAULT NULL,
  `FCVLASTDATE` date DEFAULT NULL,
  `FRVFEE` int(11) DEFAULT NULL,
  `FRTFEE` int(11) DEFAULT NULL,
  `FXRFEE` int(11) DEFAULT NULL,
  `FCVFEE` int(11) DEFAULT NULL,
  `FYEAR` varchar(4) DEFAULT NULL,
  `FEXAMTYPE` varchar(1) DEFAULT NULL,
  `FDELETED` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`internal_code`,`FDEGREE`,`FEXAMNO`,`FREGNO`),
  UNIQUE KEY `uniq` (`FDEGREE`,`FEXAMNO`,`FREGNO`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `res_fee` */

insert  into `res_fee`(`internal_code`,`FDEGREE`,`FEXAMNO`,`FREGNO`,`FCOLLCODE`,`FRESULTDATE`,`FRVLASTDATE`,`FRTLASTDATE`,`FXEROXLASTDATE`,`FCVLASTDATE`,`FRVFEE`,`FRTFEE`,`FXRFEE`,`FCVFEE`,`FYEAR`,`FEXAMTYPE`,`FDELETED`) values (1,'BBM4','A','BM062313','211','2014-09-01','2014-09-01','2014-09-01','2014-09-01','0000-00-00',1000,1000,1000,1000,NULL,NULL,NULL);

/*Table structure for table `res_reval_code_generator` */

DROP TABLE IF EXISTS `res_reval_code_generator`;

CREATE TABLE `res_reval_code_generator` (
  `internal_code` int(11) NOT NULL AUTO_INCREMENT,
  `college_code` varchar(20) DEFAULT NULL,
  `last_number` int(1) DEFAULT NULL,
  PRIMARY KEY (`internal_code`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `res_reval_code_generator` */

insert  into `res_reval_code_generator`(`internal_code`,`college_code`,`last_number`) values (2,'211',15),(3,'211',15),(4,'211',14);

/*Table structure for table `res_stud` */

DROP TABLE IF EXISTS `res_stud`;

CREATE TABLE `res_stud` (
  `internal_code` int(11) NOT NULL AUTO_INCREMENT,
  `APPNO` varchar(20) DEFAULT NULL,
  `FAPPDATE` date DEFAULT NULL,
  `FDEGREE` varchar(5) NOT NULL,
  `FEXAMNO` varchar(1) NOT NULL,
  `FCOLLCODE` varchar(4) DEFAULT NULL,
  `FREGNO` varchar(10) NOT NULL,
  `FSUBCODE` varchar(5) NOT NULL,
  `FCORRTYPE` varchar(2) DEFAULT NULL,
  `FAMOUNT` decimal(6,2) DEFAULT NULL,
  `FTOTAL` decimal(12,2) DEFAULT NULL,
  `FRECNO` varchar(10) DEFAULT NULL,
  `CHALLANNO` varchar(50) DEFAULT NULL,
  `FCHALLANDATE` date DEFAULT NULL,
  `FDATE` date DEFAULT NULL,
  `FUSER` varchar(11) DEFAULT NULL,
  `FLOGDATE` date DEFAULT NULL,
  `FYEAR` varchar(4) DEFAULT NULL,
  `FEXAMTYPE` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`internal_code`,`FDEGREE`,`FEXAMNO`,`FREGNO`,`FSUBCODE`),
  KEY `NewIndex1` (`FREGNO`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=latin1;

/*Data for the table `res_stud` */

insert  into `res_stud`(`internal_code`,`APPNO`,`FAPPDATE`,`FDEGREE`,`FEXAMNO`,`FCOLLCODE`,`FREGNO`,`FSUBCODE`,`FCORRTYPE`,`FAMOUNT`,`FTOTAL`,`FRECNO`,`CHALLANNO`,`FCHALLANDATE`,`FDATE`,`FUSER`,`FLOGDATE`,`FYEAR`,`FEXAMTYPE`) values (1,'2110001','2013-08-08','BBM4','A','211','BM062313','A21','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(2,'2110001','2013-08-08','BBM4','A','211','BM062313','A23','RT','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(3,'2110001','2013-08-08','BBM4','A','211','BM062313','A24','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(4,'2110001','2013-08-08','BBM4','A','211','BM062313','A21','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(5,'2110001','2013-08-08','BBM4','A','211','BM062313','A23','RT','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(6,'2110001','2013-08-08','BBM4','A','211','BM062313','A24','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(7,'2110001','2013-08-08','BBM4','A','211','BM062313','A21','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(8,'2110001','2013-08-08','BBM4','A','211','BM062313','A23','RT','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(9,'2110001','2013-08-08','BBM4','A','211','BM062313','A24','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(10,'2110001','2013-08-08','BBM4','A','211','BM062313','A21','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(11,'2110001','2013-08-08','BBM4','A','211','BM062313','A23','RT','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(12,'2110001','2013-08-08','BBM4','A','211','BM062313','A24','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(13,'2110001','2013-08-08','BBM4','A','211','BM062313','A21','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(14,'2110001','2013-08-08','BBM4','A','211','BM062313','A23','RT','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(15,'2110001','2013-08-08','BBM4','A','211','BM062313','A24','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(16,'2110001','2013-08-08','BBM4','A','211','BM062313','A21','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(17,'2110001','2013-08-08','BBM4','A','211','BM062313','A23','RT','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(18,'2110001','2013-08-08','BBM4','A','211','BM062313','A24','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(19,'2110001','2013-08-08','BBM4','A','211','BM062313','A22','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(20,'2110001','2013-08-08','BBM4','A','211','BM062313','A23','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(21,'2110001','2013-08-08','BBM4','A','211','BM062313','A24','XR','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(22,'2110001','2013-08-08','BBM4','A','211','BM062313','A22','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(23,'2110001','2013-08-08','BBM4','A','211','BM062313','A23','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(24,'2110001','2013-08-08','BBM4','A','211','BM062313','A24','XR','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(25,'21100004','2013-08-08','BBM4','A','211','BM062313','A01','RV','1000.00','2000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(26,'21100004','2013-08-08','BBM4','A','211','BM062313','A01','RT','1000.00','2000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(27,'21100005','2013-08-08','BBM4','A','211','BM062313','A01','RV','1000.00','2000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(28,'21100005','2013-08-08','BBM4','A','211','BM062313','A01','RT','1000.00','2000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(29,'21100006','2013-08-08','BBM4','A','211','BM062313','A01','RV','1000.00','1000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(30,'21100007','2013-08-08','BBM4','A','211','BM062313','A24','RV','1000.00','1000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(31,'21100008','2013-08-08','BBM4','A','211','BM062313','A24','RV','1000.00','1000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(32,'21100009','2013-08-08','BBM4','A','211','BM062313','A24','RV','1000.00','1000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(33,'21100010','2013-08-08','BBM4','A','211','BM062313','A01','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(34,'21100010','2013-08-08','BBM4','A','211','BM062313','A08','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(35,'21100010','2013-08-08','BBM4','A','211','BM062313','A21','RV','1000.00','3000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(36,'21100011','2013-08-08','BBM4','A','211','BM062313','A01','RV','1000.00','1000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(37,'21100012','2013-08-08','BBM4','A','211','BM062313','A01','RV','1000.00','5000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(38,'21100012','2013-08-08','BBM4','A','211','BM062313','A01','RT','1000.00','5000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(39,'21100012','2013-08-08','BBM4','A','211','BM062313','A01','XR','1000.00','5000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(40,'21100012','2013-08-08','BBM4','A','211','BM062313','A08','RT','1000.00','5000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(41,'21100012','2013-08-08','BBM4','A','211','BM062313','A08','XR','1000.00','5000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-08',NULL,NULL),(42,'21100013','2013-08-12','BBM4','A','211','BM062313','A01','RV','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(43,'21100013','2013-08-12','BBM4','A','211','BM062313','A01','RT','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(44,'21100013','2013-08-12','BBM4','A','211','BM062313','A01','XR','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(45,'21100013','2013-08-12','BBM4','A','211','BM062313','A08','RV','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(46,'21100013','2013-08-12','BBM4','A','211','BM062313','A08','RT','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(47,'21100013','2013-08-12','BBM4','A','211','BM062313','A08','XR','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(48,'21100013','2013-08-12','BBM4','A','211','BM062313','A21','RV','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(49,'21100013','2013-08-12','BBM4','A','211','BM062313','A21','RT','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(50,'21100013','2013-08-12','BBM4','A','211','BM062313','A21','XR','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(51,'21100013','2013-08-12','BBM4','A','211','BM062313','A22','RV','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(52,'21100013','2013-08-12','BBM4','A','211','BM062313','A22','RT','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(53,'21100013','2013-08-12','BBM4','A','211','BM062313','A22','XR','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(54,'21100013','2013-08-12','BBM4','A','211','BM062313','A23','RV','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(55,'21100013','2013-08-12','BBM4','A','211','BM062313','A23','RT','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(56,'21100013','2013-08-12','BBM4','A','211','BM062313','A23','XR','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(57,'21100013','2013-08-12','BBM4','A','211','BM062313','A24','RV','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(58,'21100013','2013-08-12','BBM4','A','211','BM062313','A24','RT','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(59,'21100013','2013-08-12','BBM4','A','211','BM062313','A24','XR','1000.00','18000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(60,'21100014','2013-08-12','BBM4','A','211','BM062313','A24','RV','1000.00','1000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL),(61,'21100015','2013-08-12','BBM4','A','211','BM062313','A24','RV','1000.00','1000.00',NULL,NULL,NULL,NULL,NULL,'2013-08-12',NULL,NULL);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

${this.title}

Code Editor : db.sql