-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 04, 2025 at 05:27 AM -- Server version: 10.11.14-MariaDB -- PHP Version: 8.3.23 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; 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 utf8mb4 */; -- -- Database: `dalemari_ibalik` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL, `adminname` varchar(255) NOT NULL, `adminpass` varchar(255) NOT NULL, `google_auth_code` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `adminname`, `adminpass`, `google_auth_code`, `status`) VALUES (1, 'admin', 'admin159', 'NE55P5DQGY7NL4NN3DQE2KF56XFCAH6HFYH56DDBKACLHTN72A2HYWOHIMIWUF7Y', 1); -- -------------------------------------------------------- -- -- Table structure for table `commissions` -- CREATE TABLE `commissions` ( `id` int(11) NOT NULL, `referralid` int(11) NOT NULL, `userid` int(11) NOT NULL, `name` varchar(255) NOT NULL, `amount` float(13,2) NOT NULL, `sysdate` datetime NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `memberpayment` -- CREATE TABLE `memberpayment` ( `id` int(11) NOT NULL, `userid` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `amount` float(13,2) NOT NULL, `package` varchar(255) NOT NULL, `monthly` int(11) NOT NULL, `paid` int(11) NOT NULL, `sysdate` datetime NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `memberpayment` -- INSERT INTO `memberpayment` (`id`, `userid`, `name`, `email`, `amount`, `package`, `monthly`, `paid`, `sysdate`, `status`) VALUES (2, 2, 'William Banham', 'billbanham@me.com', 50.00, 'Starter', 1, 1, '2025-05-27 14:00:15', 1), (3, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-05-29 09:38:13', 1), (5, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-05-30 09:38:47', 1), (7, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-05-31 09:39:01', 1), (9, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-06-01 09:38:29', 1), (11, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-06-02 09:38:17', 1), (13, 9, 'Koen Busschots ', 'koen@busschots.ie', 50.00, 'Starter', 1, 1, '2025-06-03 08:06:39', 1), (14, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-06-03 09:39:09', 1), (16, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-06-04 09:38:54', 1), (18, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-06-05 09:39:11', 1), (20, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-06-06 09:38:33', 1), (22, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-06-07 09:38:21', 1), (24, 3, 'Nagy Csaba', 'csaba@pfane.com', 1.00, 'Starter', 1, 1, '2025-06-08 09:38:34', 1), (44, 2, 'William Banham', 'billbanham@me.com', 50.00, 'Starter', 1, 1, '2025-06-27 14:01:28', 1), (63, 9, 'Koen Busschots ', 'koen@busschots.ie', 50.00, 'Starter', 1, 1, '2025-07-03 08:07:30', 1), (88, 2, 'William Banham', 'billbanham@me.com', 50.00, 'Starter', 1, 1, '2025-07-27 14:01:26', 1), (108, 9, 'Koen Busschots ', 'koen@busschots.ie', 50.00, 'Starter', 1, 1, '2025-08-03 08:07:01', 1), (131, 2, 'William Banham', 'billbanham@me.com', 50.00, 'Starter', 1, 1, '2025-08-27 14:02:10', 1), (132, 9, 'Koen Busschots ', 'koen@busschots.ie', 50.00, 'Starter', 1, 1, '2025-09-03 08:07:12', 1); -- -------------------------------------------------------- -- -- Table structure for table `memberreferral` -- CREATE TABLE `memberreferral` ( `id` int(11) NOT NULL, `referralid` int(11) NOT NULL, `userid` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `amount` float(13,2) NOT NULL, `sysdate` datetime NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `memberreferral` -- INSERT INTO `memberreferral` (`id`, `referralid`, `userid`, `name`, `email`, `amount`, `sysdate`, `status`) VALUES (1, 1, 2, 'William Banham', 'billbanham@me.com', 25.00, '2025-05-27 14:08:57', 1), (2, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-05-29 09:38:53', 1), (4, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-05-30 10:39:57', 1), (6, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-05-31 10:39:58', 1), (8, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-06-01 10:39:29', 1), (10, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-06-02 10:38:41', 1), (12, 2, 9, 'Koen Busschots ', 'koen@busschots.ie', 25.00, '2025-06-03 08:07:34', 1), (13, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-06-03 10:40:01', 1), (15, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-06-04 10:39:33', 1), (17, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-06-05 10:39:34', 1), (19, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-06-06 10:39:31', 1), (21, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-06-07 10:39:25', 1), (23, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 0.50, '2025-06-08 10:38:58', 1), (42, 1, 3, 'Nagy Csaba', 'csaba@pfane.com', 25.00, '2025-06-27 07:00:05', 1), (44, 1, 2, 'William Banham', 'billbanham@me.com', 25.00, '2025-06-27 15:02:52', 1), (63, 2, 9, 'Koen Busschots ', 'koen@busschots.ie', 25.00, '2025-07-03 09:08:45', 1), (88, 1, 2, 'William Banham', 'billbanham@me.com', 25.00, '2025-07-27 15:02:26', 1), (108, 2, 9, 'Koen Busschots ', 'koen@busschots.ie', 25.00, '2025-08-03 09:08:12', 1), (131, 1, 2, 'William Banham', 'billbanham@me.com', 25.00, '2025-08-27 15:03:49', 1), (132, 2, 9, 'Koen Busschots ', 'koen@busschots.ie', 25.00, '2025-09-03 09:07:37', 1); -- -------------------------------------------------------- -- -- Table structure for table `memberwithdraws` -- CREATE TABLE `memberwithdraws` ( `id` int(11) NOT NULL, `userid` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `amount` float(13,2) NOT NULL, `sysdate` datetime NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `notify` -- CREATE TABLE `notify` ( `id` int(11) NOT NULL, `orderid` int(11) NOT NULL, `amount` float(13,2) NOT NULL, `sysdate` datetime NOT NULL, `invoiceid` varchar(25) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `notify` -- INSERT INTO `notify` (`id`, `orderid`, `amount`, `sysdate`, `invoiceid`, `status`) VALUES (1, 2, 1.00, '2025-05-27 14:08:57', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `packages` -- CREATE TABLE `packages` ( `id` int(11) NOT NULL, `packagename` varchar(255) NOT NULL, `packagetype` varchar(255) NOT NULL, `amount` float(13,2) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `packages` -- INSERT INTO `packages` (`id`, `packagename`, `packagetype`, `amount`, `status`) VALUES (1, 'Starter', 'Monthly', 50.00, 1); -- -------------------------------------------------------- -- -- Table structure for table `site_contents` -- CREATE TABLE `site_contents` ( `id` int(11) NOT NULL, `title` varchar(500) NOT NULL, `details` text NOT NULL, `sysdate` datetime NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `site_contents` -- INSERT INTO `site_contents` (`id`, `title`, `details`, `sysdate`, `status`) VALUES (1, 'How To Use Signals', '

\r\n Here’s a high?quality web guide on how to optimally use trading signals from a copy?trading provider:

\r\n
\r\n

\r\n ? What Are Copy?Trading Signals?

\r\n

\r\n Copy?trading signals are alerts (manual or automated) generated by experienced traders or algorithms that instruct when to buy or sell—and are automatically mirrored in your broker account (Az Copy Trading). You receive entries, stop?losses, take?profit targets, and trade size settings depending on platform integration.

\r\n
\r\n

\r\n ? Best Practices for Using Copy?Trading Signals

\r\n

\r\n 1. Choose a Reliable Signal Provider

\r\n\r\n

\r\n 2. Set Realistic Expectations & Risk Limits

\r\n\r\n

\r\n 3. Diversify Across Providers and Strategies

\r\n\r\n

\r\n 4. Test on a Demo Before Going Live

\r\n\r\n

\r\n 5. Monitor and Review Regularly

\r\n\r\n

\r\n 6. Align Strategy Style & Goals

\r\n\r\n

\r\n 7. Use Signals as Inputs, Not Instructions

\r\n\r\n
\r\n

\r\n ? Quick-Reference Summary

\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n Step\r\n Action
\r\n 1. Provider selection\r\n Research track record, transparency, fee structure
\r\n 2. Risk config\r\n Set size, stop-loss, take-profit limits
\r\n 3. Diversification\r\n Follow multiple traders/strategies
\r\n 4. Demo testing\r\n Run signal copy on demo before funding
\r\n 5. Performance check\r\n Review periodically, adjust or replace
\r\n 6. Strategy alignment\r\n Match provider style to your goals
\r\n 7. Contextual decision-making\r\n Use signals within your own plan
\r\n
\r\n

\r\n ? Example Integration Workflow

\r\n
    \r\n
  1. \r\n

    \r\n Browse signal providers on platforms like eToro, ZuluTrade, MQL5, or Vantage (Az Copy Trading, Swingtrading.com, Investopedia, Investopedia, MT2Trading).

    \r\n
    2. \r\n
  2. \r\n

    \r\n Compare performance metrics transparently—ideal win rate, average returns, drawdown, trading frequency (Az Copy Trading, Pocket Option).

    \r\n
    3. \r\n
  3. \r\n

    \r\n Connect your broker account securely (API key or platform link) (Az Copy Trading).

    \r\n
    4. \r\n
  4. \r\n

    \r\n Configure risk settings—define capital allocation, max drawdown, and per?trade limits.

    \r\n
    5. \r\n
  5. \r\n

    \r\n Run on demo to observe trading behavior without risk.

    \r\n
    6. \r\n
  6. \r\n

    \r\n Switch to live account, starting with a small allocation.

    \r\n
    7. \r\n
  7. \r\n

    \r\n Track results, then scale up or refine your setup as confidence grows.

    \r\n
    8. \r\n
\r\n
\r\n

\r\n ?? Risks & Limitations to Be Aware Of

\r\n\r\n
\r\n

\r\n ?? Where to Learn More & Resources

\r\n\r\n
\r\n

\r\n ? In Summary

\r\n

\r\n Using copy?trading signals smartly involves thoughtful provider selection, controlled risk configuration, strategic diversification, ongoing performance review, and testing in a demo environment. Treat signals as part of your broader trading toolbox—not a set?and?forget shortcut.

\r\n

\r\n If you have a specific provider or platform in mind (like eToro, ZuluTrade, Vantage, or MQL5), I’d be happy to walk through best practices tailored to that setup.

\r\n

\r\n  

\r\n

\r\n Let me know how you'd like to proceed!

\r\n', '2025-07-28 10:10:00', 1); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `referralid` int(11) NOT NULL, `phone` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `packageid` int(11) NOT NULL, `google_auth_code` varchar(255) NOT NULL, `sysdate` datetime NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `referralid`, `phone`, `email`, `password`, `packageid`, `google_auth_code`, `sysdate`, `status`) VALUES (1, 'Dale Scott Marion', 0, '0766903531', 'personal@dalemarion.com', '123qweasd', 1, '', '2025-05-27 11:25:19', 1), (2, 'William Banham', 1, '6472486303', 'billbanham@me.com', 'gocdeq-doche8-nigjUm', 1, '', '2025-05-27 14:00:15', 1), (3, 'Nagy Csaba', 1, '0740649224', 'csaba@pfane.com', '123qweasd!@#QWEASD', 1, '', '2025-05-29 09:37:19', 1), (5, 'Pfane Environmental', 2, '0766903531', 'cell@pfane.com', '123qweasd', 1, '', '2025-05-29 10:03:35', 1), (9, 'Koen Busschots ', 2, '00353879874199', 'koen@busschots.ie', 'Mex7@Mygod', 1, '', '2025-06-03 08:05:51', 1), (10, 'Dale Scott Marion', 1, '0766903531', 'dale@pfane.com', '123qweasd', 1, '', '2025-06-03 13:00:00', 1), (11, 'Malik Muhammad Asif', 1, '03322527187', 'malikmasif@hotmail.com', '123456', 1, '', '2025-08-15 05:29:00', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `commissions` -- ALTER TABLE `commissions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `memberpayment` -- ALTER TABLE `memberpayment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `memberreferral` -- ALTER TABLE `memberreferral` ADD PRIMARY KEY (`id`); -- -- Indexes for table `memberwithdraws` -- ALTER TABLE `memberwithdraws` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notify` -- ALTER TABLE `notify` ADD PRIMARY KEY (`id`); -- -- Indexes for table `packages` -- ALTER TABLE `packages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `site_contents` -- ALTER TABLE `site_contents` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `commissions` -- ALTER TABLE `commissions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `memberpayment` -- ALTER TABLE `memberpayment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133; -- -- AUTO_INCREMENT for table `memberreferral` -- ALTER TABLE `memberreferral` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133; -- -- AUTO_INCREMENT for table `memberwithdraws` -- ALTER TABLE `memberwithdraws` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `notify` -- ALTER TABLE `notify` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `packages` -- ALTER TABLE `packages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `site_contents` -- ALTER TABLE `site_contents` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; COMMIT; /*!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 */;