· 9 years ago · Dec 19, 2016, 03:24 PM
1<?php
2session_start();
3
4ob_start();
5 require_once 'basepdesb.php';
6
7if( !isset($_SESSION['user']) ) {
8 header("Location: pdesb.php");
9 exit;
10 }
11
12$email = $_SESSION['EmailAddress'];
13$receiver = $_POST['receiver'];
14$amount = $_POST['amount'];
15$note = $_POST['note'];
16$address = $_POST['address'];
17$nickname = $_POST['nickname'];
18$position = $_POST['position'];
19$upline = $_POST['upline'];
20$package = $_POST['package'];
21$password = md5($_POST['password']);
22
23
24$query = "SELECT Userid FROM members WHERE EmailAddress = '" . $receiver . "'";
25$res = mysql_query($query);
26if (mysql_num_rows($res) <= 0)
27{
28 echo "<script>alert('RECEIVER EMAIL ADDRESS '" . $receiver . "' DOES NOT EXIST IN SYSTEM');document.location='register_rg.php';</script>";
29}
30
31else
32{
33 $query = "SELECT MAX(transaction_number) + 1 FROM RG";
34 $res = mysql_query($query);
35 $row = mysql_fetch_array($res);
36 $transaction_number = $row[0];
37
38
39 $query = "INSERT INTO RG(transaction_number, account, date_transaction, debit, transferto, remark, note) VALUES
40 (" . $transaction_number . ", '" . $email . "', NOW(), " . $amount . ", '" . $receiver . "', 'Transfer To " . $receiver . "', '" . $note . "')";
41 $result = mysql_query($query) or die('Query failed: ' . mysql_error());
42
43 //echo $query;
44
45 $query = "INSERT INTO RP(transaction_number, account, date_transaction, credit, remark) VALUES
46 (" . $transaction_number . ", '" . $receiver . "', NOW(), " . $amount . ", 'Transfer From " . $email . "')";
47 $result = mysql_query($query) or die('Query failed: ' . mysql_error());
48
49
50 echo "<script>alert ('REGISTERED, YOU HAVE REGISTERED MEMBER PACKAGE'" . $amount . "' TO '" . $receiver . "' REGISTRATION COMPLETED, THANK YOU FOR USING PDESB');document.location='register_rg.php';</script>";
51}
52?>
53
54CREATE TABLE IF NOT EXISTS `members` (
55 `mem_name` varchar(25) NOT NULL,
56 `transaction_number` int(11) NOT NULL,
57 `account` varchar(100) NOT NULL,
58 `date_register` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
59 `date_transaction` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
60 `credit` decimal(10,2) DEFAULT NULL,
61 `debit` decimal(10,2) DEFAULT NULL,
62 `remark` varchar(100) NOT NULL,
63 `address` varchar(25) NOT NULL,
64 `address_2` varchar(25) DEFAULT NULL,
65 `city` varchar(25) NOT NULL,
66 `state` varchar(25) NOT NULL,
67 `zip_code` int(11) NOT NULL,
68 `country` varchar(25) NOT NULL,
69 `cell_no` varchar(13) DEFAULT NULL,
70 `other_no` int(11) DEFAULT NULL,
71 `EmailAddress` varchar(50) NOT NULL,
72 `Password` varchar(800) NOT NULL,
73 `Username` varchar(25) NOT NULL,
74 `nickname` varchar(10) NOT NULL,
75 `direction` varchar(25) NOT NULL DEFAULT 'avail',
76 `jn_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
77 `Userid` int(25) NOT NULL AUTO_INCREMENT,
78 `f_name` varchar(25) NOT NULL,
79 `ic_no` int(20) NOT NULL,
80 `telephone_no` varchar(13) NOT NULL,
81 `sponsor` varchar(20) NOT NULL,
82 `package` varchar(30) NOT NULL,
83 UNIQUE KEY `id` (`Userid`)
84) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=180 ;
85
86--
87-- Dumping data for table `members`
88--
89
90`members` (`mem_name`, `transaction_number`, `account`, `date_register`, `date_transaction`, `credit`, `debit`, `remark`, `address`, `address_2`, `city`, `state`, `zip_code`, `country`, `cell_no`, `other_no`, `EmailAddress`, `Password`, `Username`, `nickname`, `direction`, `jn_dt`, `Userid`, `f_name`, `ic_no`, `telephone_no`, `sponsor`, `package`)