busby Posted January 6, 2011 Share Posted January 6, 2011 hello im creating an online banking system and im currently trying to create a page for transferring money from one bank account to another using account numbers. ive written this code...it looks fine to me i cant see whats wrong but when i run it and test it out nothing happens...the page appears as it should...i enter an amount to transfer...type the account number for the account the money is coming from and the account number for the account the money is going to and press transfer...the page relocates back to my accounts page which is correct but no money has been transferred...nothing happens and there is no errors being shown. could someone look at my code and see if you could point out anything wrong with it please? <?php $id = $_GET['id']; if(!isset($_SESSION['name'])) { header("location:index.php"); } if(isset($_POST['submit'])) { $id = $_POST['id']; $from = $_POST['from']; $to = $_POST['to']; $select=mysql_query("SELECT * FROM accounts WHERE accno=$from"); $res = mysql_fetch_array($select); $select2=mysql_query("SELECT * FROM accounts WHERE accno=$to"); $res2 = mysql_fetch_array($select2); $amount=($res['balance'] - $_POST['amount']); $amount2=($res2['balance'] + $_POST['amount']); $result=mysql_query("UPDATE accounts SET balance='$amount' WHERE accno=$from"); $result2=mysql_query("UPDATE accounts SET balance='$amount2' WHERE accno=$to"); header("location:home.php?id=$id"); } ?> <form method="post" action="transfer.php"> Take £<input type="text" name="amount" value="Type amount here" style="color:#999;" /> from <input type="text" name="from" Value="Type account number here" style="color:#999;" /> and send to <input type="text" name="to" Value="Type account number here" style="color:#999;" /> <br /> <input type="hidden" name="id" value="<?php echo $id; ?>" /> <input type="submit" value="transfer" name="submit" /> </form> Quote Link to comment Share on other sites More sharing options...
the182guy Posted January 6, 2011 Share Posted January 6, 2011 1. You're accessing the session but you haven't started the session, call session_start() at the top. That is why it redirects always because $_SESSION['name'] never exists. 2. Secure for SQL Injection 3. Verify post data, for example with your script a user could modify the post data and put any amount of 'money' in the second account. Check there is enough in the account to do the transfer, and handle overdraft amounts if you are implementing that. Quote Link to comment Share on other sites More sharing options...
busby Posted January 6, 2011 Author Share Posted January 6, 2011 i have started the session i just havnt included that code in this thread it was irrelivant...SQL injection isnt a problem this is not going live with real money i do need to do an overdraft feature but i dont know how to yet...at the moment i just need to know whats wrong with this particular piece of code and why it wont transfer the money Quote Link to comment Share on other sites More sharing options...
MMDE Posted January 6, 2011 Share Posted January 6, 2011 I doubt this won't give error, since you get data from both $_GET and $_POST... (even the same variable name)... after all the queries, it redirects you to some other page... no wonder it won't output $id or any errors! you could probably write the queries into 2 queries instead of 4... which also brings us to you escaping that redirect and put: $result=mysql_query($query) or die(mysql_error()); so that you can output errors from those queries that might not go as well as you want them to Quote Link to comment Share on other sites More sharing options...
busby Posted January 6, 2011 Author Share Posted January 6, 2011 ok sorry for the stupidity lol the actual problem was i foolishly forgot to include the object that connected to the database haha...so no connection meant no transfer...thats sorted now...however i did what you said MMDE and removed the relocate and printed the errors. (thats how i noticed there was no database connection) and the only error left is an undefined index: $id. now i know that means its not recognising the variable im getting from the URL but i dont know why...the value is there in the url: oswp/bank/transfer.php?id=12 so i use the $_GET function to get that id...but its throwing up that error...anybody know why? Quote Link to comment Share on other sites More sharing options...
Anti-Moronic Posted January 6, 2011 Share Posted January 6, 2011 "SQL injection isnt a problem this is not going live with real money" Don't ever brush off security because of the value of the data. It is not just the data which is being threatened, it is your database. And if you approach other parts of your app with this attitude towards security then it's not just your app which is being threatened, but your server. Security is first priority. Quote Link to comment Share on other sites More sharing options...
the182guy Posted January 6, 2011 Share Posted January 6, 2011 It looks like it's the post ID that is causing the error, are you actually posting a form to that page, or just navigating to the URL? if you are posting, do you have a field called 'id'? $id = $_POST['id']; // this Quote Link to comment Share on other sites More sharing options...
MMDE Posted January 6, 2011 Share Posted January 6, 2011 It looks like it's the post ID that is causing the error, are you actually posting a form to that page, or just navigating to the URL? if you are posting, do you have a field called 'id'? $id = $_POST['id']; // this he does that too... lol Quote Link to comment Share on other sites More sharing options...
busby Posted January 6, 2011 Author Share Posted January 6, 2011 well the $_GET id is for the first time you visit the page...it gets it from the url...but the £_POST id is for when you submit the form when it refreshes the page the id is gone from the url so in order to relocate back to the previous page with the id variable in the url i put the value in a hidden field in the form Quote Link to comment Share on other sites More sharing options...
the182guy Posted January 7, 2011 Share Posted January 7, 2011 Then the error occurs because when you post the form to transfer.php, you post the ID as a form field but it no longer exists in the querystring (GET) so $_GET['id'] is not set and thus undefined index. Quote Link to comment Share on other sites More sharing options...
idev001 Posted January 17, 2011 Share Posted January 17, 2011 1. You're accessing the session but you haven't started the session, call session_start() at the top. That is why it redirects always because $_SESSION['name'] never exists. 2. Secure for SQL Injection 3. Verify post data, for example with your script a user could modify the post data and put any amount of 'money' in the second account. Check there is enough in the account to do the transfer, and handle overdraft amounts if you are implementing that. Hello there, do you still have tjis script available? Quote Link to comment Share on other sites More sharing options...
the182guy Posted January 17, 2011 Share Posted January 17, 2011 1. You're accessing the session but you haven't started the session, call session_start() at the top. That is why it redirects always because $_SESSION['name'] never exists. 2. Secure for SQL Injection 3. Verify post data, for example with your script a user could modify the post data and put any amount of 'money' in the second account. Check there is enough in the account to do the transfer, and handle overdraft amounts if you are implementing that. Hello there, do you still have tjis script available? Come again? Quote Link to comment Share on other sites More sharing options...
Antoine_Banks Posted September 13, 2013 Share Posted September 13, 2013 On my banking system I'm working on, I'm having a bit of some trouble with some files.As I describe the files that I need help with, I will also attach them. All of the database info is fake just for the editors to use to fix some files. Thanks.Ok. So, I have 3 file:accounttransfer.phpThis file is to transfer the info of the Transfer From account number, the Payment Amount and the Select Account Number account number to over to accounttransfer2.php.accounttransfer2.phpThis file is supposed to switch Transfer To and From account numbers, depending on what is chosen from the first page. However, no matter what account number is chosen, it only shows one account number and does not switch depending on the To and From chosen from the fist page.Secondly, the money doesn't transfer from one account number to the next.Thirdly, it's not changing the account type depending on the Transfer To from the previous page.Lastly, it's not asking for the transfer password.accounttransfer3.phpThis is just the confirmation page.Here is the sql needed for testing: -- phpMyAdmin SQL Dump -- version 3.5.5 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Sep 12, 2013 at 08:27 PM -- Server version: 5.5.29 -- PHP Version: 5.3.20 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `solarcash_banking` -- -- -------------------------------------------------------- -- -- Table structure for table `accountmaster` -- CREATE TABLE IF NOT EXISTS `accountmaster` ( `masterid` int(10) unsigned NOT NULL AUTO_INCREMENT, `accounttype` varchar(25) NOT NULL, `prefix` varchar(11) NOT NULL, `minbalance` double(12,2) NOT NULL, `interest` double(10,2) NOT NULL, PRIMARY KEY (`masterid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1004 ; -- -- Dumping data for table `accountmaster` -- INSERT INTO `accountmaster` (`masterid`, `accounttype`, `prefix`, `minbalance`, `interest`) VALUES (1001, 'checking', 'ck', 6000.00, 600.00), (1002, 'saving', 'sv', 4000.00, 500.00), (1003, 'Cash on Delivery', 'cd', 100.00, 10.00); -- -------------------------------------------------------- -- -- Table structure for table `accounts` -- CREATE TABLE IF NOT EXISTS `accounts` ( `accountsid` int(10) unsigned NOT NULL AUTO_INCREMENT, `accno` int(16) NOT NULL, `accstatus` enum('active','inactive') NOT NULL, `primaryacc` enum('yes','no') NOT NULL, `accopendate` date NOT NULL, `accounttype` varchar(25) NOT NULL, `curtype` varchar(10) NOT NULL, `accountbalance` double(10,2) NOT NULL, `unclearbalance` double(10,2) NOT NULL, `accuredinterest` double(10,2) NOT NULL, PRIMARY KEY (`accountsid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=109 ; -- -- Dumping data for table `accounts` -- INSERT INTO `accounts` (`accountsid`, `accno`, `accstatus`, `primaryacc`, `accopendate`, `accounttype`, `curtype`, `accountbalance`, `unclearbalance`, `accuredinterest`) VALUES (100, 123456789, 'active', 'no', '2013-06-18', 'CHECKING', '$', 1050000.00, 100.00, 500.00), (101, 1234567890, 'active', 'yes', '2013-06-18', 'SAVING', '$', 2000000.00, 1000000.00, 1000.00); -- -------------------------------------------------------- -- -- Table structure for table `alimony` -- CREATE TABLE IF NOT EXISTS `alimony` ( `alimonyid` int(10) unsigned NOT NULL AUTO_INCREMENT, `alimonytype` varchar(25) NOT NULL, `alimonyamt` double(10,2) NOT NULL, `period` varchar(25) NOT NULL, `startdate` date NOT NULL, `monthly_inst` int(20) NOT NULL, `method` enum('Manual','Automatic') NOT NULL, `status` enum('pending','active','inactive') NOT NULL, PRIMARY KEY (`alimonyid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10002 ; -- -- Dumping data for table `alimony` -- INSERT INTO `alimony` (`alimonyid`, `alimonytype`, `alimonyamt`, `period`, `startdate`, `monthly_inst`, `method`, `status`) VALUES (10001, 'Permanent', 300000.00, 'monthly', '2012-12-02', 83, 'Manual', 'pending'); -- -------------------------------------------------------- -- -- Table structure for table `alimonypayment` -- CREATE TABLE IF NOT EXISTS `alimonypayment` ( `alimonypaymentid` int(10) unsigned NOT NULL AUTO_INCREMENT, `recipientname` varchar(255) NOT NULL, `alimonyaccnum` int(16) NOT NULL, `paidamt` double(10,2) NOT NULL, `balance` double(10,2) NOT NULL, `status` int(10) NOT NULL, `methodtype` enum('Automatic','Manual') NOT NULL, `paydate` date NOT NULL, PRIMARY KEY (`alimonypaymentid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10002 ; -- -- Dumping data for table `alimonypayment` -- INSERT INTO `alimonypayment` (`alimonypaymentid`, `recipientname`, `alimonyaccnum`, `paidamt`, `balance`, `status`, `methodtype`, `paydate`) VALUES (10001, 'Tony Banks', 2147483647, 0.00, 50000.00, 11, 'Manual', '2013-06-10'); -- -------------------------------------------------------- -- -- Table structure for table `alimonytype` -- CREATE TABLE IF NOT EXISTS `alimonytype` ( `alimonytypeid` int(10) unsigned NOT NULL AUTO_INCREMENT, `alimonytype` varchar(25) NOT NULL, `prefix` varchar(25) NOT NULL, `duration` int(3) NOT NULL, `status` enum('active','inactive') NOT NULL, UNIQUE KEY `alimonytype` (`alimonytypeid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `alimonytype` -- INSERT INTO `alimonytype` (`alimonytypeid`, `alimonytype`, `prefix`, `duration`, `status`) VALUES (1, 'Temporary', 'te', 12, 'active'), (2, 'Permanent', 'pe', 12, 'active'), (3, 'Rehabilitative', 'rh', 12, 'active'), (4, 'Reimbursement', 'ri', 12, 'active'), (5, 'Lump-sum', 'ls', 12, 'active'), (6, 'Separation', 'se', 12, 'active'); -- -------------------------------------------------------- -- -- Table structure for table `bankcards` -- CREATE TABLE IF NOT EXISTS `bankcards` ( `cardsid` int(11) unsigned NOT NULL AUTO_INCREMENT, `owner` int(11) NOT NULL DEFAULT '0', `ctype` enum('American Express','Discover','MasterCard','Visa') NOT NULL, `cname` varchar(64) NOT NULL DEFAULT '', `cnumber` varchar(32) NOT NULL DEFAULT '', `ccv` varchar(16) NOT NULL DEFAULT '', `cmonth` tinyint(2) NOT NULL DEFAULT '0', `cyear` smallint(6) NOT NULL DEFAULT '0', `systemfunds` enum('Yes','No') DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `default` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`cardsid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `bankcards` -- INSERT INTO `bankcards` (`cardsid`, `owner`, `ctype`, `cname`, `cnumber`, `ccv`, `cmonth`, `cyear`, `systemfunds`, `status`, `default`) VALUES (1, 0, 'American Express', 'Tony Banks', '1234567890123456', '093', 5, 2014, 'Yes', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `banks` -- CREATE TABLE IF NOT EXISTS `banks` ( `banksid` int(11) unsigned NOT NULL AUTO_INCREMENT, `owner` int(11) NOT NULL DEFAULT '0', `bname` varchar(128) NOT NULL DEFAULT '', `baddress` varchar(128) NOT NULL DEFAULT '', `bcity` varchar(64) NOT NULL DEFAULT '', `bzip` varchar(16) NOT NULL DEFAULT '', `bcountry` char(2) NOT NULL DEFAULT '', `bstate` varchar(32) NOT NULL DEFAULT '', `bphone` varchar(32) NOT NULL DEFAULT '', `bnameacc` varchar(128) NOT NULL DEFAULT '', `baccount` varchar(32) NOT NULL DEFAULT '', `btype` char(2) NOT NULL DEFAULT '', `brtgnum` varchar(9) NOT NULL DEFAULT '', `bswift` varchar(32) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '0', `default` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`banksid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `bank_transaction` -- CREATE TABLE IF NOT EXISTS `bank_transaction` ( `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ben_accno` int(16) NOT NULL, `cor_accno` int(16) NOT NULL, `transaction_id` int(10) NOT NULL, PRIMARY KEY (`user_id`), KEY `transaction_id` (`transaction_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `banners` -- CREATE TABLE IF NOT EXISTS `banners` ( `bannerid` int(10) unsigned NOT NULL AUTO_INCREMENT, `owner` int(10) NOT NULL, `burl` varchar(255) CHARACTER SET latin1 NOT NULL, `lurl` varchar(255) CHARACTER SET latin1 NOT NULL, `package` varchar(255) CHARACTER SET latin1 NOT NULL, `views` int(10) NOT NULL, `clicks` int(10) NOT NULL, `cdate` date NOT NULL, `fdate` date NOT NULL, `ldate` date NOT NULL, `active` int(10) NOT NULL, PRIMARY KEY (`bannerid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `bonuses` -- CREATE TABLE IF NOT EXISTS `bonuses` ( `bonusid` int(10) unsigned NOT NULL AUTO_INCREMENT, `bonusamount` double(10,2) NOT NULL, `bonusstatus` enum('pending','approved','denied') NOT NULL, PRIMARY KEY (`bonusid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `bonuses` -- INSERT INTO `bonuses` (`bonusid`, `bonusamount`, `bonusstatus`) VALUES (1, 1000000.00, 'pending'); -- -------------------------------------------------------- -- -- Table structure for table `branch` -- CREATE TABLE IF NOT EXISTS `branch` ( `branchid` int(10) unsigned NOT NULL AUTO_INCREMENT, `ifsccode` varchar(25) NOT NULL, `routingnumber` int(25) NOT NULL, `branchname` varchar(50) NOT NULL, `branchaddress` varchar(50) NOT NULL, `city` varchar(25) NOT NULL, `state` varchar(25) NOT NULL, `zip` varchar(10) NOT NULL, `countrycode` varchar(25) NOT NULL, `continentcode` varchar(25) NOT NULL, `phone` varchar(25) NOT NULL, PRIMARY KEY (`branchid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=100002 ; -- -- Dumping data for table `branch` -- INSERT INTO `branch` (`branchid`, `ifsccode`, `routingnumber`, `branchname`, `branchaddress`, `city`, `state`, `zip`, `countrycode`, `continentcode`, `phone`) VALUES (100001, 'KARB0000404', 343645, 'Mangalore', '123 Anywhere', 'Houston', 'Texas', '77000', 'USA', 'North America', '713-123-1234'); -- -------------------------------------------------------- -- -- Table structure for table `company` -- CREATE TABLE IF NOT EXISTS `company` ( `companyid` int(10) unsigned NOT NULL AUTO_INCREMENT, `company_name` varchar(128) NOT NULL DEFAULT '', `company_regnum` varchar(32) NOT NULL DEFAULT '', `company_address` varchar(255) NOT NULL, `company_city` varchar(255) NOT NULL, `company_country` varchar(255) NOT NULL, `company_state` varchar(255) NOT NULL, `company_zip` int(10) NOT NULL, `company_phone` int(10) NOT NULL, `company_fax` int(10) NOT NULL, PRIMARY KEY (`companyid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `confirms` -- CREATE TABLE IF NOT EXISTS `confirms` ( `confirmsid` int(11) unsigned NOT NULL AUTO_INCREMENT, `newuser` varchar(32) NOT NULL, `newpass` varchar(32) NOT NULL, `newquestion` varchar(255) NOT NULL, `newanswer` varchar(255) NOT NULL, `newmail` varchar(255) NOT NULL, `newfname` varchar(32) NOT NULL, `newlname` varchar(32) NOT NULL, `newcompany` varchar(128) NOT NULL, `newregnum` varchar(32) NOT NULL, `newdrvnum` varchar(32) NOT NULL, `newaddress` varchar(128) NOT NULL, `newcity` varchar(64) NOT NULL, `newcountry` char(2) NOT NULL, `newstate` varchar(32) NOT NULL, `newzip` varchar(32) NOT NULL, `newphone` varchar(64) NOT NULL, `newfax` varchar(64) NOT NULL, `sponsor` int(11) NOT NULL DEFAULT '0', `confirm` varchar(255) NOT NULL, `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`confirmsid`), UNIQUE KEY `newuser` (`newuser`), KEY `newmail` (`newmail`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `customers` -- CREATE TABLE IF NOT EXISTS `customers` ( `customerid` int(10) unsigned NOT NULL AUTO_INCREMENT, `sponsor` int(11) NOT NULL DEFAULT '0', `ifsccode` varchar(25) NOT NULL, `routingnumber` int(25) NOT NULL, `last_ip` varchar(255) DEFAULT NULL, `empty` tinyint(1) NOT NULL DEFAULT '1', `cdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `adate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `firstname` varchar(200) NOT NULL, `lastname` varchar(200) NOT NULL, `age` int(3) NOT NULL, `sex` enum('male','female') NOT NULL, `ss_number` varchar(11) NOT NULL, `loginid` varchar(25) NOT NULL, `accpassword` varchar(50) NOT NULL, `transpasword` varchar(50) NOT NULL, `emailid` varchar(30) NOT NULL, `accstatus` enum('active','inactive','pending','closed') NOT NULL, `address` varchar(200) NOT NULL, `city` varchar(200) NOT NULL, `state` varchar(200) NOT NULL, `zip` varchar(10) NOT NULL, `continentcode` varchar(25) NOT NULL, `countrycode` varchar(25) NOT NULL, `contactno` varchar(30) NOT NULL, `faxnum` varchar(25) NOT NULL, `driverslicensenum` int(10) NOT NULL, `question` varchar(200) NOT NULL, `ans` varchar(50) NOT NULL, `accopendate` date NOT NULL, `lastlogin` date NOT NULL, `description` longtext, PRIMARY KEY (`customerid`), UNIQUE KEY `loginid` (`loginid`), KEY `firstname` (`firstname`,`lastname`,`emailid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='System Customers' AUTO_INCREMENT=98681 ; -- -- Dumping data for table `customers` -- INSERT INTO `customers` (`customerid`, `sponsor`, `ifsccode`, `routingnumber`, `last_ip`, `empty`, `cdate`, `ldate`, `adate`, `firstname`, `lastname`, `age`, `sex`, `ss_number`, `loginid`, `accpassword`, `transpasword`, `emailid`, `accstatus`, `address`, `city`, `state`, `zip`, `continentcode`, `countrycode`, `contactno`, `faxnum`, `driverslicensenum`, `question`, `ans`, `accopendate`, `lastlogin`, `description`) VALUES (98680, 0, 'KARB0000404', 343645, '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Tony', 'Banks', 33, 'male', '123-45-6789', 'tonybanks', 'entertain', 'entertain1', 'tonybanks@gmail.com', 'active', '123 Anywhere', 'Houston', 'Texas', '77000', 'North America', 'USA', '713-123-4567', '281-123-4567', 123456789, 'What Make Was Your First Car Or Bike?', 'Car', '2013-06-14', '2013-08-18', ''); -- -------------------------------------------------------- -- -- Table structure for table `emails` -- CREATE TABLE IF NOT EXISTS `emails` ( `emailsid` int(11) unsigned NOT NULL AUTO_INCREMENT, `key` varchar(64) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `value` longtext, PRIMARY KEY (`emailsid`), UNIQUE KEY `keyword` (`key`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='E-Mail Templates' AUTO_INCREMENT=22 ; -- -- Dumping data for table `emails` -- INSERT INTO `emails` (`emailsid`, `key`, `name`, `value`) VALUES (1, 'CONFIRM-TO-MEMBER', 'Confirm E-Mail for new member', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing the information you need to continue the signup process...\r\n\r\nYou recently were at the [sitename] website and signed up, you must continue the signup process and enter your account information. To do so, you can navigate to the below URL:\r\n\r\nClick to this link to confirm your registration: [confpage]?cid=[confhash]\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n\\\\\\"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM\\\\\\"'), (2, 'SIGNUP-TO-MEMBER', 'You was registered in the our system', 'Hello,\n\nThis is not SPAM, this is an e-mail from [sitename] containing the information you requested...\n\nYou recently were registered the [sitename] website therefore we sent your account login information to you.\n\nYou can find such information below:\n---\nUsername: [username]\nPassword: [password]\n\nYou can access your account anytime at:\n[lognpage]\n\nThank you for your time,\n\n[sitename] Services Team\n[hostname]\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (3, 'SIGNUP-TO-ADMINS', 'A new user has signed up', 'A new user has signed up.\r\n\r\nEmail: [emailadr]\r\nUsername: [username]\r\nPassword: [password]'), (4, 'UPDATE-MEMBER-PROFILE', 'Your profile information was changed!', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing the information you need to continue the profile update process...\r\n\r\nYou recently were at the [sitename] website and updated your profile. If it is not so please check of the your account.\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (5, 'UPDATE-BANK-INFORMATION', 'Your bank information was changed!', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing the information you need to continue the profile update process...\r\n\r\nYou recently were at the [sitename] website and updated your bank information. If it is not so please check of the your account.\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (6, 'UPDATE-CARD-INFORMATION', 'Your credit card information was changed!', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing the information you need to continue the profile update process...\r\n\r\nYou recently were at the [sitename] website and updated your credit card information. If it is not so please check of the your account.\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (7, 'SEND-MONEY', 'Money Waiting', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing a notification of money paid to your account...\r\n\r\nA [sitename] user has just successfully sent you money! Please look at the below details for information on this transaction.\r\n\r\nSender: [username]\r\nSender''s E-Mail: [emailadr]\r\nAmount Received: [amount]\r\nSender''s Comments: [comments]\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (8, 'REQUEST-MONEY', 'Money Waiting', 'Hello [fullname],\r\n\r\nThis is not SPAM, this is an e-mail from [sitename].\r\n\r\nA member of [sitename] has requested money!\r\n\r\nFrom Email: [emailadr]\r\nAmount: [amount]\r\n\r\nIn order for you to send this user money, you must create an account on [sitename].\r\n\r\nTo complete this transaction, you need to click the link below (or if there is no link, copy the address to your web browser) and sign up for an account. Instructions on approving or denying the transaction can be found on our website.\r\n[singpage]\r\n\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (9, 'SEND-ESCROW', 'Money Waiting', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing a notification of money paid by escrow to your account...\r\n\r\nA [sitename] user has just successfully sent you money! Please look at the below details for information on this transaction.\r\n\r\nSender: [username]\r\nSender''s E-Mail: [emailadr]\r\nAmount Received: [amount]\r\nSender''s Comments: [comments]\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (10, 'CONFIRM-ESCROW', 'Payment by escrow was confirmed!', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail containing a notification that escrow was confirmed...\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (11, 'CANCEL-ESCROW', 'Payment by escrow was cancelled!', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing a notification that escrow was cancelled...\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (12, 'REFUND-ESCROW', 'Payment by escrow was refunded!', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing a notification that escrow was confirmed...\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (13, 'DOWNLINE-CHANGE', 'You have a new member in your downline!', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing the information about your downline...\r\n\r\nA new member has signed up under your account! \r\n\r\n----------------------------------\r\nMember Username: [username]\r\nEmail Address: [emailadr]\r\n---------------------------------- \r\n\r\nKeep up the good work! \r\n\r\nRemember, you will get 2.5% of all the StormPay fees this new member generates... \r\n\r\n\r\nThank you for promoting [sitename]!\r\n\r\n[sitename] Service Team\r\n"THE NEW UNIVERSAL PAYMENT SYSTEM"'), (14, 'PAYMENT-MONEY', 'Payment Notification', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing a notification of money paid from your account...\r\n\r\nYou have just successfully make payment! Please look at the below details for information on this transaction.\r\n\r\nSender: [username]\r\nSender\\\\\\''s E-Mail: [emailadr]\r\nAmount Received: [amount]\r\nSender\\\\\\''s Comments: [comments]\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nIf you do not have a [sitename] account, please create an account\r\nto get the money. It only takes a few minutes and it is Free!!!\r\n\r\nIf this is the FIRST payment you received at this email address\r\nthrough [sitename], please log into your account, click the \\\\\\"VIEW ALL TRANSACTIONS\\\\\\" menu item, then check all your transactions.\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n\\\\\\"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM\\\\\\"'), (15, 'SUBSCRIPTION-MONEY', 'Subscription Notification', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing a notification of money paid from your account...\r\n\r\nYou have just successfully make subscription! Please look at the below details for information on this transaction.\r\n\r\nSender: [username]\r\nSender''s E-Mail: [emailadr]\r\nAmount Received: [amount]\r\nSender''s Comments: [comments]\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nIf you do not have a [sitename] account, please create an account\r\nto get the money. It only takes a few minutes and it is Free!!!\r\n\r\nIf this is the FIRST payment you received at this email address\r\nthrough [sitename], please log into your account, click the "VIEW ALL TRANSACTIONS" menu item, then check all your transactions.\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (16, 'PAYMENT-MONEY-TO-OWNER', 'A member has just successfully make payment!', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing a notification of money paid to your account...\r\n\r\nA [sitename] user has just successfully make payment! Please look at the below details for information on this transaction.\r\n\r\nSender: [username]\r\nSender''s E-Mail: [buyeradr]\r\nAmount Received: [amount]\r\nSender''s Comments: [comments]\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nIf you do not have a [sitename] account, please create an account\r\nto get the money. It only takes a few minutes and it is Free!!!\r\n\r\nIf this is the FIRST payment you received at this email address\r\nthrough [sitename], please log into your account, click the "VIEW ALL TRANSACTIONS" menu item, then check all your transactions.\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (17, 'SUBSCRIPTION-MONEY-TO-OWNER', 'A member has just successfully make subscription!', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing a notification of money paid from your account...\r\n\r\nA [sitename] user has just successfully make subscription! Please look at the below details for information on this transaction.\r\n\r\nSender: [username]\r\nSender''s E-Mail: [buyeradr]\r\nAmount Received: [amount]\r\nSender''s Comments: [comments]\r\n\r\nYou can access your account anytime at:\r\n[lognpage]\r\n\r\nIf you do not have a [sitename] account, please create an account\r\nto get the money. It only takes a few minutes and it is Free!!!\r\n\r\nIf this is the FIRST payment you received at this email address\r\nthrough [sitename], please log into your account, click the "VIEW ALL TRANSACTIONS" menu item, then check all your transactions.\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (18, 'RESTORE-PASSWORD', 'Lost Password', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing the information you need to continue the signup process...\r\n\r\nThe lost password for your [sitename] account is: [password]\r\n\r\nPlease log in to [sitename] by following this link: \r\n[lognpage]\r\n\r\nThank you for your time,\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'), (19, 'CONFIRM-NEW-EMAIL', 'New E-mail address added', 'Dear [fullname],\r\nYou have sucessfully added a new email address but you have to confirm it first.\r\n[emailpage]?c=[confcode]&u=[uid]'), (20, 'NEW-EMAIL-ACTIVATED', 'New E-mail address successfully added', 'Dear [fullname],\r\nYour email address has been successfully verified.'), (21, 'PAYMENT-TO-UNREGMEMBER', 'Money Waiting', 'Hello,\r\n\r\nThis is not SPAM, this is an e-mail from [sitename] containing a notification of money paid to you.\r\n\r\nA [sitename] user has just successfully sent you money! Please look at the below details for information on this transaction.\r\n\r\nSender: [username]\r\nSender''s E-Mail: [emailadr]\r\nAmount Received: [amount]\r\nSender''s Comments: [comments]\r\n\r\n\r\nTo get the money you have first to register to [sitename] using the same email address this email is sent to.\r\nUse that link to coninue registration process: [usersite]\r\nThis email is valid during 10 days. If you don''t signup within this period, money invoice will be cancelled.\r\n\r\nThank you!\r\n\r\n[sitename] Services Team\r\n[hostname]\r\n"THE NEW ONLINE UNIVERSAL PAYMENT SYSTEM"'); -- -------------------------------------------------------- -- -- Table structure for table `employees` -- CREATE TABLE IF NOT EXISTS `employees` ( `empid` int(10) unsigned NOT NULL AUTO_INCREMENT, `employee_name` varchar(25) NOT NULL, `age` int(3) NOT NULL, `sex` enum('male','female') NOT NULL, `ss_number` varchar(11) NOT NULL, `loginid` varchar(25) NOT NULL, `password` varchar(25) NOT NULL, `emailid` varchar(30) NOT NULL, `address` varchar(30) NOT NULL, `city` varchar(30) NOT NULL, `state` varchar(30) NOT NULL, `zip` varchar(30) NOT NULL, `continentcode` varchar(25) NOT NULL, `countrycode` varchar(30) NOT NULL, `contactno` varchar(30) NOT NULL, `emptatus` enum('active','inactive','pending','closed') NOT NULL, `createdat` date NOT NULL, `last_login` datetime NOT NULL, `last_ip` varchar(255) DEFAULT NULL, PRIMARY KEY (`empid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1002 ; -- -- Dumping data for table `employees` -- INSERT INTO `employees` (`empid`, `employee_name`, `age`, `sex`, `ss_number`, `loginid`, `password`, `emailid`, `address`, `city`, `state`, `zip`, `continentcode`, `countrycode`, `contactno`, `emptatus`, `createdat`, `last_login`, `last_ip`) VALUES (1000, 'admin', 33, 'male', '123-45-6789', 'admin', 'admin123', 'admin@solarcashinc.uni.me', '123 Anywhere', 'Houston', 'Texas', '77000', 'North America', 'USA', '713-123-4567', 'active', '2013-01-12', '2013-07-05 00:54:00', NULL), (1001, 'tony banks', 33, 'male', '123-45-6789', 'tonybanks', 'entertain', 'tonybanks@gmail.com', '12345', 'Houston', 'TX', '77000', 'North America', 'usa', '123-456-7890', 'active', '2013-06-26', '0000-00-00 00:00:00', NULL); -- -------------------------------------------------------- -- -- Table structure for table `escrowdescription` -- CREATE TABLE IF NOT EXISTS `escrowdescription` ( `trans_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `escrow_dis` longtext NOT NULL, PRIMARY KEY (`trans_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `faq_cat_list` -- CREATE TABLE IF NOT EXISTS `faq_cat_list` ( `faqcatlistid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `title` char(200) NOT NULL DEFAULT '', `parent` int(3) DEFAULT NULL, PRIMARY KEY (`faqcatlistid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `faq_cat_list` -- INSERT INTO `faq_cat_list` (`faqcatlistid`, `title`, `parent`) VALUES (1, 'GENERAL INFORMATION', 0); -- -------------------------------------------------------- -- -- Table structure for table `faq_list` -- CREATE TABLE IF NOT EXISTS `faq_list` ( `faqlistid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `question` text NOT NULL, `answer` text NOT NULL, `cat` int(3) DEFAULT NULL, PRIMARY KEY (`faqlistid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `faq_list` -- INSERT INTO `faq_list` (`faqlistid`, `question`, `answer`, `cat`) VALUES (1, 'What makes SolarCash Inc so much different than all the rest of payment processor sites like yours?', 'Do we have GREAT news for you!\nCUSTOMER SERVICE IS PARAMOUNT! We pride ourselves in providing Customer Service! This is what sets us apart from all the other payment processors. We''ve seen it over and over, for customer service from processor providers. We go above and beyond to help you with any issue or problem you may have.\n\nNow that you know about our customer service, we fully intend to be your number one choice of any payment processor you''ve ever used or have ever seen. Our goal is to provide as many options for you to process on-line orders, subscriptions, and product sales. Our competition only offers a small amount of ways to fund your account. We are striving to be a truly Global Payment Processor! We believe everyone should be able to sell the products on the Internet.', 2), (2, 'What is SolarCash Inc?', 'SolarPay allows any business or person with an e-mail address to securely, easily, and very convenient way to send and receive on-line payments. SolarCash Inc also allows anyone with a web site to securely sell their merchandise.\nWe are a perfect solution to send and receive money over the Internet.', 2), (3, 'Is SolarPay secure?', 'Absolutely! SolarCash Inc uses the SSL technology to make sure your information is totally safe. With SolarCash Inc you never have to worry about your financial information, credit card, or bank account information being viewed by others. We take every effort to make our site secure.', 2), (4, 'How much does it cost to sign up for SolarCash Inc account?', 'SolarPay is absolutely free. Simply sign up, and you''re ready to send and receive money through our secure web site. However we do charge a very small fee for each transaction.', 2), (5, 'Do you support MLM Sites?', 'Certainly! As long as your site is not a SCAM/FRAUD site, we support you!\nSorry! NO CASINO SITES! :0(', 2), (6, 'This sounds too easy. How do I sign up?', 'Simple! It usually takes less than a minute to open a SolarCash Inc account.', 2), (7, 'Am I able to view the details of my transactions?', 'You are able to view the details of any of your transactions. When you login you will have access to all the transactions that you have made. Every transaction history is secure, and only available for you to view.', 2); -- -------------------------------------------------------- -- -- Table structure for table `hold` -- CREATE TABLE IF NOT EXISTS `hold` ( `holdid` int(11) unsigned NOT NULL AUTO_INCREMENT, `paidby` int(11) NOT NULL DEFAULT '0', `paidto` varchar(100) NOT NULL DEFAULT '', `amount` double(10,2) unsigned NOT NULL DEFAULT '0.00', PRIMARY KEY (`holdid`), KEY `paidby` (`paidby`), KEY `paidto` (`paidto`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `loan` -- CREATE TABLE IF NOT EXISTS `loan` ( `loanid` int(10) unsigned NOT NULL AUTO_INCREMENT, `loantype` varchar(25) NOT NULL, `loanamt` double(10,2) NOT NULL, `period` varchar(25) NOT NULL, `interest` double(10,2) NOT NULL, `profession` varchar(20) NOT NULL, `income` double(10,2) NOT NULL, `startdate` date NOT NULL, `monthly_inst` int(20) NOT NULL, `status` enum('pending','active','inactive') NOT NULL, PRIMARY KEY (`loanid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10002 ; -- -- Dumping data for table `loan` -- INSERT INTO `loan` (`loanid`, `loantype`, `loanamt`, `period`, `interest`, `profession`, `income`, `startdate`, `monthly_inst`, `status`) VALUES (10001, 'home loan', 300000.00, 'monthly', 63.09, 'Salaried', 768768.00, '2012-12-02', 83, 'pending'); -- -------------------------------------------------------- -- -- Table structure for table `loanpayment` -- CREATE TABLE IF NOT EXISTS `loanpayment` ( `paymentid` int(10) unsigned NOT NULL AUTO_INCREMENT, `paidamt` double(10,2) NOT NULL, `principleamt` double(10,2) NOT NULL, `interestamt` double(10,2) NOT NULL, `balance` double(10,2) NOT NULL, `status` int(10) NOT NULL, `paydate` date NOT NULL, PRIMARY KEY (`paymentid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10002 ; -- -- Dumping data for table `loanpayment` -- INSERT INTO `loanpayment` (`paymentid`, `paidamt`, `principleamt`, `interestamt`, `balance`, `status`, `paydate`) VALUES (10001, 5000.00, 300000.00, 3000.00, 50000.00, 11, '2013-06-10'); -- -------------------------------------------------------- -- -- Table structure for table `loantype` -- CREATE TABLE IF NOT EXISTS `loantype` ( `typeid` int(10) unsigned NOT NULL AUTO_INCREMENT, `loantype` varchar(25) NOT NULL, `prefix` varchar(25) NOT NULL, `minimumamt` double(10,2) NOT NULL, `maximumamt` double(10,2) NOT NULL, `interest` double(10,2) NOT NULL, `duration` int(3) NOT NULL, `status` enum('active','inactive') NOT NULL, UNIQUE KEY `loantype` (`typeid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `loantype` -- INSERT INTO `loantype` (`typeid`, `loantype`, `prefix`, `minimumamt`, `maximumamt`, `interest`, `duration`, `status`) VALUES (1, 'car loan', 'cl', 50000.00, 70000.00, 3000.00, 12, 'active'), (2, 'home loan', 'hl', 50000.00, 1000000.00, 65.09, 12, 'active'); -- -------------------------------------------------------- -- -- Table structure for table `mail` -- CREATE TABLE IF NOT EXISTS `mail` ( `mailid` int(10) unsigned NOT NULL AUTO_INCREMENT, `subject` varchar(250) NOT NULL, `message` text NOT NULL, `mdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `senderid` varchar(25) NOT NULL, `reciverid` varchar(25) NOT NULL, PRIMARY KEY (`mailid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `mail` -- INSERT INTO `mail` (`mailid`, `subject`, `message`, `mdatetime`, `senderid`, `reciverid`) VALUES (1, 'test1', 'test1', '0000-00-00 00:00:00', 'admin', '98684'); -- -------------------------------------------------------- -- -- Table structure for table `mainsettings` -- CREATE TABLE IF NOT EXISTS `mainsettings` ( `settingsid` int(10) unsigned NOT NULL AUTO_INCREMENT, `site_name` varchar(200) NOT NULL, `site_title` varchar(200) NOT NULL, `site_charset` varchar(200) NOT NULL, `site_copyrights` varchar(200) NOT NULL, `site_keywords` longtext NOT NULL, `site_description` varchar(200) NOT NULL, `admin_email` varchar(200) NOT NULL, `admin_username` varchar(25) NOT NULL, `admin_password` varchar(25) NOT NULL, `admin_check_ip` varchar(25) NOT NULL, `admin_ip_address` varchar(25) NOT NULL, `protect_html` varchar(200) NOT NULL, `mail_address` varchar(200) NOT NULL, `superpass` varchar(255) NOT NULL, `suspend_days` int(10) NOT NULL, `suspend_notice` int(10) NOT NULL, `passlen` int(10) NOT NULL, `passatt` int(10) NOT NULL, `currency` varchar(10) NOT NULL, `currsize` int(10) NOT NULL, `ex_rate` double(10,2) NOT NULL, `dateformat` varchar(25) NOT NULL, `use_turing` varchar(10) NOT NULL, `use_numbers` varchar(10) NOT NULL, `turing_size` int(10) NOT NULL, `turing_quality` int(10) NOT NULL, `turing_bgfile` varchar(200) NOT NULL, `use_extreg` varchar(10) NOT NULL, `signup_use` varchar(10) NOT NULL, `signup_bonus` double(10,2) NOT NULL, `maxemails` int(10) NOT NULL, `referral_payout` int(10) NOT NULL, `minimal_transfer` double(10,2) NOT NULL, `maximal_transfer` double(10,2) NOT NULL, `transfer_percent` double(10,2) NOT NULL, `transfer_fee` double(10,2) NOT NULL, `sales_tax` int(10) NOT NULL, `refund_period` int(10) NOT NULL, `affiliate_program` varchar(200) NOT NULL, `affiliate_levels` int(10) NOT NULL, `affiliate_percent` double(10,2) NOT NULL, `dep_notify` int(10) NOT NULL, `dep_minimal` double(10,2) NOT NULL, `dep_maximal` double(10,2) NOT NULL, `dep_pp_use` varchar(25) NOT NULL, `dep_pp_fee` double(10,2) NOT NULL, `dep_pp_percent` double(10,2) NOT NULL, `dep_pp_username` varchar(25) NOT NULL, `dep_pp_password` varchar(25) NOT NULL, `dep_sp_use` varchar(25) NOT NULL, `dep_sp_fee` double(10,2) NOT NULL, `dep_sp_percent` double(10,2) NOT NULL, `dep_sp_username` varchar(25) NOT NULL, `dep_sp_password` varchar(25) NOT NULL, `dep_np_use` varchar(25) NOT NULL, `dep_np_fee` double(10,2) NOT NULL, `dep_np_percent` double(10,2) NOT NULL, `dep_np_username` varchar(25) NOT NULL, `dep_np_password` varchar(25) NOT NULL, `dep_eg_use` varchar(25) NOT NULL, `dep_eg_fee` double(10,2) NOT NULL, `dep_eg_percent` double(10,2) NOT NULL, `dep_eg_username` int(10) NOT NULL, `dep_eg_password` varchar(25) NOT NULL, `dep_mb_use` varchar(25) NOT NULL, `dep_mb_fee` double(10,2) NOT NULL, `dep_mb_percent` double(10,2) NOT NULL, `dep_mb_username` varchar(25) NOT NULL, `dep_mb_password` varchar(25) NOT NULL, `dep_ig_use` varchar(25) NOT NULL, `dep_ig_fee` double(10,2) NOT NULL, `dep_ig_percent` double(10,2) NOT NULL, `dep_ig_username` varchar(25) NOT NULL, `dep_ig_password` varchar(25) NOT NULL, `dep_eb_use` varchar(25) NOT NULL, `dep_eb_fee` double(10,2) NOT NULL, `dep_eb_percent` double(10,2) NOT NULL, `dep_eb_username` varchar(25) NOT NULL, `dep_eb_password` varchar(25) NOT NULL, `dep_px_use` varchar(25) NOT NULL, `dep_px_fee` double(10,2) NOT NULL, `dep_px_percent` double(10,2) NOT NULL, `dep_px_username` varchar(25) NOT NULL, `dep_px_password` varchar(25) NOT NULL, `dep_pd_use` varchar(25) NOT NULL, `dep_pd_fee` double(10,2) NOT NULL, `dep_pd_percent` double(10,2) NOT NULL, `dep_pd_username` varchar(25) NOT NULL, `dep_pd_password` varchar(25) NOT NULL, `dep_ev_use` varchar(25) NOT NULL, `dep_ev_fee` double(10,2) NOT NULL, `dep_ev_percent` double(10,2) NOT NULL, `dep_ev_username` varchar(25) NOT NULL, `dep_ev_password` varchar(25) NOT NULL, `dep_qc_use` varchar(25) NOT NULL, `dep_qc_fee` double(10,2) NOT NULL, `dep_qc_percent` double(10,2) NOT NULL, `dep_qc_username` int(10) NOT NULL, `dep_qc_password` varchar(25) NOT NULL, `dep_gm_use` varchar(25) NOT NULL, `dep_gm_fee` double(10,2) NOT NULL, `dep_gm_percent` double(10,2) NOT NULL, `dep_gm_username` varchar(25) NOT NULL, `dep_gm_password` varchar(25) NOT NULL, `dep_vg_use` varchar(25) NOT NULL, `dep_vg_fee` double(10,2) NOT NULL, `dep_vg_percent` double(10,2) NOT NULL, `dep_vg_username` varchar(25) NOT NULL, `dep_vg_password` varchar(25) NOT NULL, `dep_pe_use` varchar(25) NOT NULL, `dep_pe_fee` double(10,2) NOT NULL, `dep_pe_percent` double(10,2) NOT NULL, `dep_pe_username` varchar(25) NOT NULL, `dep_pe_password` varchar(25) NOT NULL, `dep_an_use` varchar(25) NOT NULL, `dep_an_fee` double(10,2) NOT NULL, `dep_an_percent` double(10,2) NOT NULL, `dep_an_username` varchar(25) NOT NULL, `dep_an_password` varchar(25) NOT NULL, `dep_cc_use` varchar(25) NOT NULL, `dep_cc_fee` double(10,2) NOT NULL, `dep_cc_percent` double(10,2) NOT NULL, `dep_cc_username` varchar(25) NOT NULL, `dep_cc_password` varchar(25) NOT NULL, `dep_anet_use` varchar(25) NOT NULL, `dep_anet_fee` double(10,2) NOT NULL, `dep_anet_percent` double(10,2) NOT NULL, `dep_anet_usernme` varchar(25) NOT NULL, `dep_anet_password` varchar(25) NOT NULL, `dep_kagi_use` varchar(25) NOT NULL, `dep_kagi_fee` double(10,2) NOT NULL, `dep_kagi_percent` double(10,2) NOT NULL, `dep_kagi_usernme` varchar(25) NOT NULL, `dep_kagi_password` varchar(25) NOT NULL, `dep_ec_use` varchar(25) NOT NULL, `dep_ec_fee` double(10,2) NOT NULL, `dep_ec_percent` double(10,2) NOT NULL, `dep_ec_username` varchar(25) NOT NULL, `dep_ec_password` varchar(25) NOT NULL, `dep_mc_use` varchar(25) NOT NULL, `dep_mc_fee` double(10,2) NOT NULL, `dep_mc_percent` double(10,2) NOT NULL, `dep_mc_username` varchar(25) NOT NULL, `dep_mc_password` varchar(25) NOT NULL, `dep_echeck_percent` double(10,2) NOT NULL, `dep_echeck_fee` double(10,2) NOT NULL, `dep_newcc_percent` double(10,2) NOT NULL, `dep_newcc_fee` double(10,2) NOT NULL, `dep_check_fee` double(10,2) NOT NULL, `wdr_notify` int(10) NOT NULL, `wdr_minimal` double(10,2) NOT NULL, `wdr_maximal` double(10,2) NOT NULL, `wdr_pp_use` varchar(25) NOT NULL, `wdr_pp_fee` double(10,2) NOT NULL, `wdr_sp_use` varchar(25) NOT NULL, `wdr_sp_fee` double(10,2) NOT NULL, `wdr_np_use` varchar(25) NOT NULL, `wdr_np_fee` double(10,2) NOT NULL, `wdr_eg_use` varchar(25) NOT NULL, `wdr_eg_fee` double(10,2) NOT NULL, `wdr_mb_use` varchar(25) NOT NULL, `wdr_mb_fee` double(10,2) NOT NULL, `wdr_ig_use` varchar(25) NOT NULL, `wdr_ig_fee` double(10,2) NOT NULL, `wdr_eb_use` varchar(25) NOT NULL, `wdr_eb_fee` double(10,2) NOT NULL, `wdr_px_use` varchar(25) NOT NULL, `wdr_px_fee` double(10,2) NOT NULL, `wdr_pd_use` varchar(25) NOT NULL, `wdr_pd_fee` double(10,2) NOT NULL, `wdr_ev_use` varchar(25) NOT NULL, `wdr_ev_fee` double(10,2) NOT NULL, `wdr_gm_use` varchar(25) NOT NULL, `wdr_gm_fee` double(10,2) NOT NULL, `wdr_vg_use` varchar(25) NOT NULL, `wdr_vg_fee` double(10,2) NOT NULL, `wdr_pe_use` varchar(25) NOT NULL, `wdr_pe_fee` double(10,2) NOT NULL, `wdr_bw_use` varchar(25) NOT NULL, `wdr_bw_fee` double(10,2) NOT NULL, `wdr_mc_use` varchar(25) NOT NULL, `wdr_mc_fee` double(10,2) NOT NULL, `wdr_wu_use` varchar(25) NOT NULL, `wdr_wu_fee` double(10,2) NOT NULL, `wdr_mg_use` varchar(25) NOT NULL, `wdr_mg_fee` double(10,2) NOT NULL, `wdr_check_fee` double(10,2) NOT NULL, `wdr_wire_fee` double(10,2) NOT NULL, `echeck_use` int(10) NOT NULL, `newcc_use` int(10) NOT NULL, `newcc_user` varchar(255) NOT NULL, `newcc_pass` varchar(255) NOT NULL, `check_use` int(10) NOT NULL, PRIMARY KEY (`settingsid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `mainsettings` -- INSERT INTO `mainsettings` (`settingsid`, `site_name`, `site_title`, `site_charset`, `site_copyrights`, `site_keywords`, `site_description`, `admin_email`, `admin_username`, `admin_password`, `admin_check_ip`, `admin_ip_address`, `protect_html`, `mail_address`, `superpass`, `suspend_days`, `suspend_notice`, `passlen`, `passatt`, `currency`, `currsize`, `ex_rate`, `dateformat`, `use_turing`, `use_numbers`, `turing_size`, `turing_quality`, `turing_bgfile`, `use_extreg`, `signup_use`, `signup_bonus`, `maxemails`, `referral_payout`, `minimal_transfer`, `maximal_transfer`, `transfer_percent`, `transfer_fee`, `sales_tax`, `refund_period`, `affiliate_program`, `affiliate_levels`, `affiliate_percent`, `dep_notify`, `dep_minimal`, `dep_maximal`, `dep_pp_use`, `dep_pp_fee`, `dep_pp_percent`, `dep_pp_username`, `dep_pp_password`, `dep_sp_use`, `dep_sp_fee`, `dep_sp_percent`, `dep_sp_username`, `dep_sp_password`, `dep_np_use`, `dep_np_fee`, `dep_np_percent`, `dep_np_username`, `dep_np_password`, `dep_eg_use`, `dep_eg_fee`, `dep_eg_percent`, `dep_eg_username`, `dep_eg_password`, `dep_mb_use`, `dep_mb_fee`, `dep_mb_percent`, `dep_mb_username`, `dep_mb_password`, `dep_ig_use`, `dep_ig_fee`, `dep_ig_percent`, `dep_ig_username`, `dep_ig_password`, `dep_eb_use`, `dep_eb_fee`, `dep_eb_percent`, `dep_eb_username`, `dep_eb_password`, `dep_px_use`, `dep_px_fee`, `dep_px_percent`, `dep_px_username`, `dep_px_password`, `dep_pd_use`, `dep_pd_fee`, `dep_pd_percent`, `dep_pd_username`, `dep_pd_password`, `dep_ev_use`, `dep_ev_fee`, `dep_ev_percent`, `dep_ev_username`, `dep_ev_password`, `dep_qc_use`, `dep_qc_fee`, `dep_qc_percent`, `dep_qc_username`, `dep_qc_password`, `dep_gm_use`, `dep_gm_fee`, `dep_gm_percent`, `dep_gm_username`, `dep_gm_password`, `dep_vg_use`, `dep_vg_fee`, `dep_vg_percent`, `dep_vg_username`, `dep_vg_password`, `dep_pe_use`, `dep_pe_fee`, `dep_pe_percent`, `dep_pe_username`, `dep_pe_password`, `dep_an_use`, `dep_an_fee`, `dep_an_percent`, `dep_an_username`, `dep_an_password`, `dep_cc_use`, `dep_cc_fee`, `dep_cc_percent`, `dep_cc_username`, `dep_cc_password`, `dep_anet_use`, `dep_anet_fee`, `dep_anet_percent`, `dep_anet_usernme`, `dep_anet_password`, `dep_kagi_use`, `dep_kagi_fee`, `dep_kagi_percent`, `dep_kagi_usernme`, `dep_kagi_password`, `dep_ec_use`, `dep_ec_fee`, `dep_ec_percent`, `dep_ec_username`, `dep_ec_password`, `dep_mc_use`, `dep_mc_fee`, `dep_mc_percent`, `dep_mc_username`, `dep_mc_password`, `dep_echeck_percent`, `dep_echeck_fee`, `dep_newcc_percent`, `dep_newcc_fee`, `dep_check_fee`, `wdr_notify`, `wdr_minimal`, `wdr_maximal`, `wdr_pp_use`, `wdr_pp_fee`, `wdr_sp_use`, `wdr_sp_fee`, `wdr_np_use`, `wdr_np_fee`, `wdr_eg_use`, `wdr_eg_fee`, `wdr_mb_use`, `wdr_mb_fee`, `wdr_ig_use`, `wdr_ig_fee`, `wdr_eb_use`, `wdr_eb_fee`, `wdr_px_use`, `wdr_px_fee`, `wdr_pd_use`, `wdr_pd_fee`, `wdr_ev_use`, `wdr_ev_fee`, `wdr_gm_use`, `wdr_gm_fee`, `wdr_vg_use`, `wdr_vg_fee`, `wdr_pe_use`, `wdr_pe_fee`, `wdr_bw_use`, `wdr_bw_fee`, `wdr_mc_use`, `wdr_mc_fee`, `wdr_wu_use`, `wdr_wu_fee`, `wdr_mg_use`, `wdr_mg_fee`, `wdr_check_fee`, `wdr_wire_fee`, `echeck_use`, `newcc_use`, `newcc_user`, `newcc_pass`, `check_use`) VALUES (1, 'SolarCash Inc', 'THE NEW UNIVERSAL PAYMENT SYSTEM', 'iso-8859-1', '©2003-2006 AlstraSoft.com', 'payment, processor, payment gateway, paypal, pay online, escrow, send money, receive money, send cash online, online payment, start your own paypal, payment processor, pay money, ipn', 'EPay Enterprise - Pay Onlne Now', 'Services Team<sales@alstrasoft.com>', 'admin', 'admin', 'false', '', '', 'Your psyhical address should be here.', 'test', 30, 1, 8, 5, '$', 3, 1.00, 'm/d/Y h:iA', 'true', 'true', 8, 75, 'images/turing_bg.jpg', 'true', 'true', 100.00, 3, 1, 0.05, 100.00, 2.00, 0.25, 0, 30, 'true', 6, 3.00, 1, 1.00, 500.00, 'false', 0.50, 2.50, '', '', 'false', 0.50, 2.50, '', '', 'false', 1.00, 5.50, '', '', 'true', 1.00, 15.00, 7, '', 'false', 1.00, 2.00, '', '', 'false', 0.50, 2.50, '', '', 'false', 0.50, 1.50, '', '', 'false', 1.00, 1.00, '', '', 'false', 1.00, 1.00, '', '', 'false', 1.00, 5.50, '', '', 'true', 10.00, 2.50, 1, '', 'true', 1.00, 2.54, 'H', '', 'false', 1.00, 1.50, '', '', 'false', 1.00, 2.53, '', '', 'false', 0.50, 5.50, '', '', 'false', 0.50, 5.50, '', '', 'false', 0.50, 5.50, '', '', 'false', 1.50, 0.00, '', '', 'true', 0.50, 5.50, '', '', 'true', 0.50, 5.50, '', '', 0.00, 0.00, 0.00, 0.00, 0.00, 1, 30.00, 500.00, 'true', 1.00, 'true', 1.00, 'true', 1.00, 'true', 1.00, 'true', 2.00, 'true', 1.00, 'true', 1.00, 'true', 1.00, 'true', 1.00, 'true', 1.00, 'true', 2.00, 'true', 3.00, 'true', 4.00, 'true', 35.00, 'true', 2.00, 'true', 10.00, 'true', 10.00, 3.50, 35.00, 1, 1, '', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE IF NOT EXISTS `members` ( `membersid` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(32) NOT NULL DEFAULT '', `password` varchar(32) NOT NULL DEFAULT '', `question` varchar(255) NOT NULL DEFAULT '', `answer` varchar(255) NOT NULL DEFAULT '', `email` varchar(255) NOT NULL DEFAULT '', `active` tinyint(1) NOT NULL DEFAULT '0', `status` tinyint(4) NOT NULL DEFAULT '0', `fname` varchar(32) NOT NULL DEFAULT '', `lname` varchar(32) NOT NULL DEFAULT '', `drvnum` varchar(32) NOT NULL DEFAULT '', `address` varchar(128) NOT NULL DEFAULT '', `city` varchar(64) NOT NULL DEFAULT '', `country` char(2) NOT NULL DEFAULT '', `state` varchar(32) NOT NULL DEFAULT '', `zip` varchar(32) NOT NULL DEFAULT '', `phone` varchar(64) NOT NULL DEFAULT '', `fax` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`membersid`), UNIQUE KEY `username` (`username`), KEY `email` (`email`), KEY `fname` (`fname`), KEY `lname` (`lname`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='System Members' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `member_emails` -- CREATE TABLE IF NOT EXISTS `member_emails` ( `owner` int(11) unsigned NOT NULL DEFAULT '0', `email` varchar(255) NOT NULL DEFAULT '', `active` tinyint(1) NOT NULL DEFAULT '0', `primary` tinyint(1) NOT NULL DEFAULT '0', `verifcode` varchar(40) NOT NULL DEFAULT '', PRIMARY KEY (`owner`,`email`), UNIQUE KEY `email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `notes` -- CREATE TABLE IF NOT EXISTS `notes` ( `notesid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `notes` text NOT NULL, `user` int(3) DEFAULT NULL, PRIMARY KEY (`notesid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE IF NOT EXISTS `products` ( `productsid` int(11) unsigned NOT NULL AUTO_INCREMENT, `type` tinyint(4) NOT NULL DEFAULT '0', `sold` int(11) NOT NULL DEFAULT '0', `owner` int(11) NOT NULL DEFAULT '0', `price` double(10,2) NOT NULL DEFAULT '0.00', `period` int(11) NOT NULL DEFAULT '0', `setup` double(10,2) NOT NULL DEFAULT '0.00', `trial` double(10,2) NOT NULL DEFAULT '0.00', `tax` double(10,2) NOT NULL DEFAULT '0.00', `shipping` double(10,2) NOT NULL DEFAULT '0.00', `button` varchar(255) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `ureturn` mediumtext NOT NULL, `unotify` mediumtext NOT NULL, `ucancel` mediumtext NOT NULL, `comments` longtext NOT NULL, PRIMARY KEY (`productsid`), KEY `type` (`type`), KEY `owner` (`owner`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Products' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `registeredpayee` -- CREATE TABLE IF NOT EXISTS `registeredpayee` ( `slno` int(11) unsigned NOT NULL AUTO_INCREMENT, `payeename` varchar(25) NOT NULL, `accountnumber` int(25) NOT NULL, `accounttype` varchar(25) NOT NULL, `bankname` varchar(25) NOT NULL, `ifsccode` varchar(25) NOT NULL, `routingnumber` int(25) NOT NULL, PRIMARY KEY (`slno`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=102 ; -- -- Dumping data for table `registeredpayee` -- INSERT INTO `registeredpayee` (`slno`, `payeename`, `accountnumber`, `accounttype`, `bankname`, `ifsccode`, `routingnumber`) VALUES (101, 'arpitha', 26548, 'saving', 'canarabank', 'KARB0000404', 0); -- -------------------------------------------------------- -- -- Table structure for table `safetransfers` -- CREATE TABLE IF NOT EXISTS `safetransfers` ( `safetranid` int(11) unsigned NOT NULL AUTO_INCREMENT, `paidby` int(11) NOT NULL DEFAULT '0', `paidto` int(11) NOT NULL DEFAULT '0', `amount` double(10,2) unsigned NOT NULL DEFAULT '0.00', PRIMARY KEY (`safetranid`), KEY `paidby` (`paidby`), KEY `paidto` (`paidto`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `safetransfers` -- INSERT INTO `safetransfers` (`safetranid`, `paidby`, `paidto`, `amount`) VALUES (1, 1478, 1522, 20.00); -- -------------------------------------------------------- -- -- Table structure for table `shop_categories` -- CREATE TABLE IF NOT EXISTS `shop_categories` ( `categoriesid` int(11) unsigned NOT NULL AUTO_INCREMENT, `parentid` int(11) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `description` text, PRIMARY KEY (`categoriesid`), KEY `parent_id` (`parentid`,`name`), KEY `parentid` (`parentid`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ; -- -- Dumping data for table `shop_categories` -- INSERT INTO `shop_categories` (`categoriesid`, `parentid`, `name`, `description`) VALUES (1, 0, 'Antiques & Art', 'Top Antiques & Art'), (2, 0, 'Auction Resources', 'Top Auction Resources'), (3, 0, 'Automotive', 'Top Automotive'), (4, 0, 'Babies & Kids', 'Top Babies & Kids'), (5, 0, 'Beauty', 'Top Beauty'), (6, 0, 'Books, Music, Movies', 'Top Books, Music, Movies'), (7, 0, 'Business Services', 'Top Business Services & Supplies'), (8, 0, 'Clothing', 'Top Clothing'), (9, 0, 'Collectibles', 'Top Collectibles'), (10, 0, 'Communication', 'Top Communication'), (11, 0, 'Computers', 'Top Computers & Internet'), (12, 0, 'Crafts', 'Top Crafts'), (13, 0, 'Cultures & Religions', 'Top Cultures & Religions'), (14, 0, 'Currency & Coins', 'Top Currency & Coins'), (15, 0, 'Dolls & Bears', 'Top Dolls & Bears'), (16, 0, 'Electronics', 'Top Electronics'), (17, 0, 'Fashion', 'Top Fashion'), (18, 0, 'Food & Drink', 'Top Food & Drink'), (19, 0, 'Gifts & Flowers', 'Top Gifts & Flowers'), (20, 0, 'Health & Nutrition', 'Top Health & Nutrition'), (21, 0, 'Hobbies', 'Top Hobbies'), (22, 0, 'Home & Garden', 'Top Home & Garden'), (23, 0, 'Entertainment', 'Top Media & Entertainment'), (24, 0, 'Non-Profit & Political', 'Top Non-Profit & Political'), (25, 0, 'Pets & Animals', 'Top Pets & Animals'), (26, 0, 'Real Estate', 'Top Real Estate'), (27, 0, 'Services', 'Top Services'), (28, 0, 'Sports & Recreation', 'Top Sports & Recreation'), (29, 0, 'Toys & Games', 'Top Toys & Games'), (31, 1, 'Fine Arts', 'Top Fine Arts'), (32, 1, 'Furniture', 'Top Furniture'), (33, 1, 'General', 'Top General'), (34, 1, 'Glass', 'Top Glass'), (35, 1, 'Needlework & Hand Crafts', 'Top Needlework & Hand Crafts'), (36, 1, 'Pottery & Glass', 'Top Pottery & Glass'), (37, 1, 'Prints', 'Top Prints'), (38, 1, 'Reproductions', 'Top Reproductions'), (39, 1, 'Sculptures', 'Top Sculptures'), (40, 1, 'Western Art', 'Top Western Art'), (41, 1, 'Woodworking', 'Top Woodworking'), (42, 32, 'Furniture1', 'Top Furniture1'), (44, 42, 'Furniture2', 'Top Furniture2'), (45, 1, 'Prepaid Call Time', 'QTC Members Only Call'), (46, 31, 'SKSKS AFRT', 'SLSSlssl'); -- -------------------------------------------------------- -- -- Table structure for table `shop_items` -- CREATE TABLE IF NOT EXISTS `shop_items` ( `itemsid` int(11) unsigned NOT NULL AUTO_INCREMENT, `categoryid` int(11) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `url` text NOT NULL, `description` text NOT NULL, PRIMARY KEY (`itemsid`), KEY `categoryid` (`categoryid`,`name`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `subscribers` -- CREATE TABLE IF NOT EXISTS `subscribers` ( `SubscriberId` int(11) unsigned NOT NULL AUTO_INCREMENT, `UserId` int(11) NOT NULL DEFAULT '0', `PayDate` date NOT NULL DEFAULT '0000-00-00', `Holded` char(1) NOT NULL DEFAULT '', `SubscriptionId` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`SubscriberId`), KEY `SubscriptionId` (`SubscriptionId`), KEY `PayDate` (`PayDate`), KEY `UserId` (`UserId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `subscribers` -- INSERT INTO `subscribers` (`SubscriberId`, `UserId`, `PayDate`, `Holded`, `SubscriptionId`) VALUES (1, 2102, '2003-11-28', '', 11); -- -------------------------------------------------------- -- -- Table structure for table `subscriptions` -- CREATE TABLE IF NOT EXISTS `subscriptions` ( `subscriptionsid` int(11) unsigned NOT NULL AUTO_INCREMENT, `owner` int(11) NOT NULL DEFAULT '0', `member` int(11) NOT NULL DEFAULT '0', `product` int(11) NOT NULL DEFAULT '0', `sdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `pdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`subscriptionsid`), KEY `owner` (`owner`), KEY `member` (`member`), KEY `product` (`product`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Subscribers' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `systemvault` -- CREATE TABLE IF NOT EXISTS `systemvault` ( `vaultid` int(10) unsigned NOT NULL AUTO_INCREMENT, `vaultloginid` varchar(25) NOT NULL, `vaultpassword` varchar(25) NOT NULL, `vaulttranspasword` varchar(25) NOT NULL, `vaultaccnum` int(10) NOT NULL, `curtype` varchar(10) NOT NULL, `vaultbalance` double(10,2) NOT NULL, `vaultstatus` enum('active','inactive') NOT NULL, `lastlogin` datetime NOT NULL, PRIMARY KEY (`vaultid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `temp_pays` -- CREATE TABLE IF NOT EXISTS `temp_pays` ( `paysid` int(11) unsigned NOT NULL AUTO_INCREMENT, `tdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `sender` int(11) NOT NULL DEFAULT '0', `receiver` varchar(255) NOT NULL DEFAULT '', `amount` double(10,2) NOT NULL DEFAULT '0.00', `status` tinyint(1) NOT NULL DEFAULT '0', `comments` longtext, PRIMARY KEY (`paysid`), KEY `tdate` (`tdate`), KEY `sender` (`sender`), KEY `receiver` (`receiver`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Pending payments for unregistered members' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `transaction` -- CREATE TABLE IF NOT EXISTS `transaction` ( `transactionid` int(10) unsigned NOT NULL AUTO_INCREMENT, `transactiondate` datetime DEFAULT NULL, `transactiontype` enum('Deposit','Withdrawal') NOT NULL, `transactionmethod` varchar(200) NOT NULL, `payeeid` int(11) NOT NULL DEFAULT '0', `receiveid` int(11) NOT NULL DEFAULT '0', `related` int(11) NOT NULL DEFAULT '0', `particulars` varchar(25) NOT NULL, `cheque_num` int(25) NOT NULL, `depositac` double(10,2) NOT NULL, `debitac` double(10,2) NOT NULL, `commission` double(10,2) NOT NULL, `fees` double(10,2) NOT NULL DEFAULT '0.00', `balance` double(10,2) NOT NULL, `comments` longtext, `ecomments` longtext, `status` tinyint(1) NOT NULL DEFAULT '0', `paymentstat` enum('approved','denied') NOT NULL, `approve_datetime` date NOT NULL, PRIMARY KEY (`transactionid`), KEY `transactiondate` (`transactiondate`,`payeeid`,`receiveid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Transaction' AUTO_INCREMENT=3 ; -- -- Dumping data for table `transaction` -- INSERT INTO `transaction` (`transactionid`, `transactiondate`, `transactiontype`, `transactionmethod`, `payeeid`, `receiveid`, `related`, `particulars`, `cheque_num`, `depositac`, `debitac`, `commission`, `fees`, `balance`, `comments`, `ecomments`, `status`, `paymentstat`, `approve_datetime`) VALUES (1, '2013-07-03 00:00:00', 'Deposit', 'Check', 111232154, 0, 0, 'Deposit', 123456, 150000.00, 0.00, 0.00, 0.00, 1150000.00, '', '', 0, 'approved', '2012-12-03'), (2, '2013-07-03 00:00:00', 'Withdrawal', 'Cash', 111232154, 0, 0, 'Withdrawal', 0, 0.00, 100000.00, 0.00, 0.00, 1050000.00, '', '', 0, 'approved', '2012-12-03'); -- -------------------------------------------------------- -- -- Table structure for table `visits` -- CREATE TABLE IF NOT EXISTS `visits` ( `visitsid` int(11) unsigned NOT NULL AUTO_INCREMENT, `member` int(11) NOT NULL DEFAULT '0', `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `address` varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (`visitsid`), KEY `member` (`member`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='History of members IPs' AUTO_INCREMENT=1 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; accounttransfer.phpaccounttransfer2.phpaccounttransfer3.php Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.