-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Dec 31, 2023 at 09:43 PM
-- Server version: 8.0.31
-- PHP Version: 8.0.26

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: `cclub_agents_club`
--

-- --------------------------------------------------------

--
-- Table structure for table `tb_regqrcode`
--

DROP TABLE IF EXISTS `tb_regqrcode`;
CREATE TABLE IF NOT EXISTS `tb_regqrcode` (
  `QRId` bigint NOT NULL AUTO_INCREMENT,
  `QRkey` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `QRParent` bigint NOT NULL,
  `QRcode` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `QRdirect` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `QRlink` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `QRdate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`QRId`),
  KEY `QRkey` (`QRkey`),
  KEY `QRParent` (`QRParent`),
  KEY `QRcode` (`QRcode`),
  KEY `QRdirect` (`QRdirect`),
  KEY `QRlink` (`QRlink`),
  KEY `QRdate` (`QRdate`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tb_regqrcode`
--

INSERT INTO `tb_regqrcode` (`QRId`, `QRkey`, `QRParent`, `QRcode`, `QRdirect`, `QRlink`, `QRdate`) VALUES
(1, 'QRmembers', 340, 'renadabdullah2009523', 'QRmembers/renadabdullah20095231808876342.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=renadabdullah2009523', '2023-12-22 21:34:07'),
(2, 'QRmembers', 477, 'arkan', 'QRmembers/arkan568790025.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=arkan', '2023-12-22 21:34:43'),
(3, 'QRmembers', 476, 'danube', 'QRmembers/danube442631381.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=danube', '2023-12-22 21:34:43'),
(4, 'QRmembers', 474, 'ssss', 'QRmembers/ssss2097636873.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=ssss', '2023-12-22 21:34:44'),
(5, 'QRmembers', 473, 'new', 'QRmembers/new463391954.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=new', '2023-12-22 21:34:44'),
(6, 'QRmembers', 472, 'mOsenan', 'QRmembers/mOsenan1565865360.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=mOsenan', '2023-12-22 21:34:44'),
(7, 'QRmembers', 469, 'agencytest', 'QRmembers/agencytest1577870008.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=agencytest', '2023-12-22 23:04:56'),
(8, 'QRmembers', 468, 'zeworld0', 'QRmembers/zeworld01259168874.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=zeworld0', '2023-12-22 23:04:57'),
(9, 'QRmembers', 467, 'cworld0', 'QRmembers/cworld01920764886.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=cworld0', '2023-12-22 23:04:57'),
(10, 'QRmembers', 466, 'test000', 'QRmembers/test000716778268.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=test000', '2023-12-22 23:04:57'),
(11, 'QRmembers', 465, 'agency02', 'QRmembers/agency021006741901.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=agency02', '2023-12-22 23:04:58'),
(12, 'QRmembers', 464, 'agency01', 'QRmembers/agency011046500739.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=agency01', '2023-12-22 23:04:58'),
(13, 'QRmembers', 463, 'fAgency', 'QRmembers/fAgency1846869074.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=fAgency', '2023-12-22 23:04:59'),
(14, 'QRmembers', 459, 'Haithamxxxx8519', 'QRmembers/Haithamxxxx85191336203812.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=Haithamxxxx8519', '2023-12-22 23:04:59'),
(15, 'QRmembers', 458, 'mohaalsef4203', 'QRmembers/mohaalsef420346828165.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=mohaalsef4203', '2023-12-22 23:04:59'),
(16, 'QRmembers', 457, 'maramalghanmy2268', 'QRmembers/maramalghanmy2268428622194.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=maramalghanmy2268', '2023-12-22 23:05:00'),
(17, 'QRmembers', 456, 'samaher.alsaeed94987', 'QRmembers/samaher.alsaeed949872145687692.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=samaher.alsaeed94987', '2023-12-22 23:05:00'),
(18, 'QRmembers', 455, 'abuznadahsamia6702', 'QRmembers/abuznadahsamia6702827123742.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=abuznadahsamia6702', '2023-12-22 23:05:01'),
(19, 'QRmembers', 454, 'y.baarmah2790', 'QRmembers/y.baarmah27901070264125.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=y.baarmah2790', '2023-12-23 00:44:48'),
(20, 'QRmembers', 453, 'laylati203020232802', 'QRmembers/laylati203020232802938213135.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=laylati203020232802', '2023-12-23 00:44:48'),
(21, 'QRmembers', 452, 'lateef100707', 'QRmembers/lateef100707105787265.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=lateef100707', '2023-12-23 00:44:49'),
(22, 'QRmembers', 451, 'aishah03705645', 'QRmembers/aishah037056452074336089.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=aishah03705645', '2023-12-23 00:44:49'),
(23, 'QRmembers', 450, 'meeso.1000009659', 'QRmembers/meeso.1000009659727808786.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=meeso.1000009659', '2023-12-23 00:44:50'),
(24, 'QRmembers', 449, 'mdclub_566773354496', 'QRmembers/mdclub_566773354496355129890.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=mdclub_566773354496', '2023-12-23 00:44:50'),
(25, 'QRmembers', 448, 'mdclub_5511992531973', 'QRmembers/mdclub_5511992531973100480642.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=mdclub_5511992531973', '2023-12-23 00:44:51'),
(26, 'QRmembers', 447, 'mdclub_534801982827', 'QRmembers/mdclub_534801982827826516406.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=mdclub_534801982827', '2023-12-23 00:44:51'),
(27, 'QRmembers', 446, 'shrooa_1257', 'QRmembers/shrooa_12572026224192.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=shrooa_1257', '2023-12-23 00:44:51'),
(28, 'QRmembers', 445, 'suulttaan38199107', 'QRmembers/suulttaan381991072143707977.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=suulttaan38199107', '2023-12-23 00:44:52'),
(29, 'QRmembers', 444, 'y.aldmmac4457', 'QRmembers/y.aldmmac44571612594409.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=y.aldmmac4457', '2023-12-23 00:44:52'),
(30, 'QRmembers', 443, 'mdclub_5572425508772', 'QRmembers/mdclub_5572425508772978690648.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=mdclub_5572425508772', '2023-12-23 00:44:53'),
(31, 'QRmembers', 442, 'albukhari19891153', 'QRmembers/albukhari198911531129378830.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=albukhari19891153', '2023-12-23 00:44:53'),
(32, 'QRmembers', 441, 'mdclub_5668458087894', 'QRmembers/mdclub_5668458087894654050023.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=mdclub_5668458087894', '2023-12-23 00:44:54'),
(33, 'QRmembers', 440, 'mdclub_5433037696381', 'QRmembers/mdclub_54330376963811922813022.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=mdclub_5433037696381', '2023-12-23 00:44:55'),
(34, 'QRmembers', 439, 'mdclub_537666110903', 'QRmembers/mdclub_5376661109031493288764.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=mdclub_537666110903', '2023-12-23 00:44:55'),
(35, 'QRmembers', 438, 'binmhfoouz19984072', 'QRmembers/binmhfoouz199840721350147017.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=binmhfoouz19984072', '2023-12-23 00:44:55'),
(36, 'QRmembers', 437, 'mdclub_5557374533449', 'QRmembers/mdclub_5557374533449278998971.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=mdclub_5557374533449', '2023-12-23 00:44:56'),
(37, 'QRmembers', 436, 'afaf.moushi8842', 'QRmembers/afaf.moushi88421478339185.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=afaf.moushi8842', '2023-12-23 00:44:56'),
(38, 'QRmembers', 435, 'ganodel7530', 'QRmembers/ganodel75302121849635.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=ganodel7530', '2023-12-23 00:44:57'),
(39, 'QRmembers', 434, 'shq11204893', 'QRmembers/shq112048932145650845.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=shq11204893', '2023-12-23 00:44:57'),
(40, 'QRmembers', 433, 'umar41081313', 'QRmembers/umar410813131400680498.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=umar41081313', '2023-12-23 00:44:58'),
(41, 'QRmembers', 432, 'ralsaiari1553', 'QRmembers/ralsaiari15531478920051.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=ralsaiari1553', '2023-12-23 00:44:58'),
(42, 'QRmembers', 431, 'gosef.ghamdi7573', 'QRmembers/gosef.ghamdi75731270277442.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=gosef.ghamdi7573', '2023-12-23 00:44:59'),
(43, 'QRmembers', 496, 'reGuser', 'QRmembers/reGuser1467177531.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=reGuser', '2023-12-23 23:13:57'),
(44, 'QRmembers', 2, 'brightAgent', 'QRmembers/brightAgent1640111170.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=brightAgent', '2023-12-24 23:22:21'),
(45, 'QRmembers', 1, 'brightlab', 'QRmembers/brightlab779379093.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=brightlab', '2023-12-24 23:25:13'),
(46, 'QRmembers', 5, 'az2020xf9489', 'QRmembers/az2020xf94891449090837.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=az2020xf9489', '2023-12-24 23:25:14'),
(47, 'QRmembers', 356, 'brhoom_20065649', 'QRmembers/brhoom_200656491573285236.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=brhoom_20065649', '2023-12-24 23:25:53'),
(48, 'QRmembers', 310, 'ibrahemawad0061723', 'QRmembers/ibrahemawad0061723117937183.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=ibrahemawad0061723', '2023-12-24 23:25:54'),
(49, 'QRmembers', 307, 'wabr515896', 'QRmembers/wabr5158961226464180.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=wabr515896', '2023-12-24 23:25:54'),
(50, 'QRmembers', 282, 'coobra2007226', 'QRmembers/coobra2007226973965372.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=coobra2007226', '2023-12-24 23:25:55'),
(51, 'QRmembers', 159, 'essaibrahim37732', 'QRmembers/essaibrahim37732737653329.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=essaibrahim37732', '2023-12-24 23:25:55'),
(52, 'QRmembers', 143, 'Abdullah.ibrahim19339271', 'QRmembers/Abdullah.ibrahim193392711057103408.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=Abdullah.ibrahim19339271', '2023-12-24 23:26:11'),
(53, 'QRmembers', 89, 'muath_ibra6705', 'QRmembers/muath_ibra67051209992960.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=muath_ibra6705', '2023-12-24 23:26:11'),
(54, 'QRmembers', 59, 'abrarqubai7477', 'QRmembers/abrarqubai7477913345821.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=abrarqubai7477', '2023-12-24 23:26:12'),
(55, 'QRmembers', 50, 'abrajcorp3852', 'QRmembers/abrajcorp38521248075296.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=abrajcorp3852', '2023-12-24 23:26:12'),
(56, 'QRmembers', 471, 'oXfamName', 'QRmembers/oXfamName791655881.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=oXfamName', '2023-12-25 01:01:43'),
(57, 'QRmembers', 480, 'danubeAPP', 'QRmembers/danubeAPP184493312.png', 'http://localhost/cclubb.com/property/club/members/profile.php?id=danubeAPP', '2023-12-26 16:52:49'),
(58, 'QRProPerty', 157, 'QRProPerty157', 'QRProPerties/QRProPerty157901855714.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=157', '2023-12-26 23:45:27'),
(59, 'QRProPerty', 150, 'QRProPerty150', 'QRProPerties/QRProPerty1502019945623.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=150', '2023-12-26 23:45:28'),
(60, 'QRProPerty', 144, 'QRProPerty144', 'QRProPerties/QRProPerty14469191989.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=144', '2023-12-26 23:45:28'),
(61, 'QRProPerty', 132, 'QRProPerty132', 'QRProPerties/QRProPerty1321236520724.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=132', '2023-12-26 23:45:29'),
(62, 'QRProPerty', 131, 'QRProPerty131', 'QRProPerties/QRProPerty131403301746.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=131', '2023-12-26 23:45:30'),
(63, 'QRProPerty', 130, 'QRProPerty130', 'QRProPerties/QRProPerty1301784070727.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=130', '2023-12-26 23:45:30'),
(64, 'QRProPerty', 124, 'QRProPerty124', 'QRProPerties/QRProPerty124484848485.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=124', '2023-12-26 23:45:31'),
(65, 'QRProPerty', 123, 'QRProPerty123', 'QRProPerties/QRProPerty123695462989.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=123', '2023-12-26 23:45:31'),
(66, 'QRProPerty', 120, 'QRProPerty120', 'QRProPerties/QRProPerty1201233149086.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=120', '2023-12-26 23:45:32'),
(67, 'QRProPerty', 119, 'QRProPerty119', 'QRProPerties/QRProPerty1191239972012.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=119', '2023-12-26 23:45:32'),
(68, 'QRProPerty', 117, 'QRProPerty117', 'QRProPerties/QRProPerty1171173221420.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=117', '2023-12-26 23:45:33'),
(69, 'QRProPerty', 113, 'QRProPerty113', 'QRProPerties/QRProPerty1131664435630.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=113', '2023-12-26 23:45:33'),
(70, 'QRProPerty', 112, 'QRProPerty112', 'QRProPerties/QRProPerty112760034093.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=112', '2023-12-26 23:45:34'),
(71, 'QRProPerty', 111, 'QRProPerty111', 'QRProPerties/QRProPerty111449671012.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=111', '2023-12-26 23:45:34'),
(72, 'QRProPerty', 110, 'QRProPerty110', 'QRProPerties/QRProPerty1101722842108.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=110', '2023-12-26 23:45:34'),
(73, 'QRProPerty', 101, 'QRProPerty101', 'QRProPerties/QRProPerty101582559677.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=101', '2023-12-26 23:45:35'),
(74, 'QRProPerty', 100, 'QRProPerty100', 'QRProPerties/QRProPerty1001508826672.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=100', '2023-12-26 23:45:35'),
(75, 'QRProPerty', 96, 'QRProPerty96', 'QRProPerties/QRProPerty961415092156.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=96', '2023-12-26 23:45:36'),
(76, 'QRProPerty', 95, 'QRProPerty95', 'QRProPerties/QRProPerty952033067342.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=95', '2023-12-26 23:45:36'),
(77, 'QRProPerty', 94, 'QRProPerty94', 'QRProPerties/QRProPerty941949639499.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=94', '2023-12-26 23:45:37'),
(78, 'QRProPerty', 92, 'QRProPerty92', 'QRProPerties/QRProPerty921766716570.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=92', '2023-12-26 23:45:37'),
(79, 'QRProPerty', 91, 'QRProPerty91', 'QRProPerties/QRProPerty911351687707.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=91', '2023-12-26 23:45:38'),
(80, 'QRProPerty', 90, 'QRProPerty90', 'QRProPerties/QRProPerty90260651339.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=90', '2023-12-26 23:45:38'),
(81, 'QRProPerty', 84, 'QRProPerty84', 'QRProPerties/QRProPerty84371461124.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=84', '2023-12-29 21:59:54'),
(82, 'QRProPerty', 83, 'QRProPerty83', 'QRProPerties/QRProPerty831571258709.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=83', '2023-12-29 21:59:54'),
(83, 'QRProPerty', 82, 'QRProPerty82', 'QRProPerties/QRProPerty821367137890.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=82', '2023-12-29 21:59:54'),
(84, 'QRProPerty', 81, 'QRProPerty81', 'QRProPerties/QRProPerty811925481811.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=81', '2023-12-29 21:59:55'),
(85, 'QRProPerty', 79, 'QRProPerty79', 'QRProPerties/QRProPerty792100987053.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=79', '2023-12-29 21:59:56'),
(86, 'QRProPerty', 75, 'QRProPerty75', 'QRProPerties/QRProPerty751968291106.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=75', '2023-12-29 21:59:56'),
(87, 'QRProPerty', 74, 'QRProPerty74', 'QRProPerties/QRProPerty74963792924.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=74', '2023-12-29 21:59:57'),
(88, 'QRProPerty', 73, 'QRProPerty73', 'QRProPerties/QRProPerty731653821906.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=73', '2023-12-29 21:59:57'),
(89, 'QRProPerty', 72, 'QRProPerty72', 'QRProPerties/QRProPerty721165975605.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=72', '2023-12-29 21:59:57'),
(90, 'QRProPerty', 71, 'QRProPerty71', 'QRProPerties/QRProPerty71152559164.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=71', '2023-12-29 21:59:58'),
(91, 'QRProPerty', 70, 'QRProPerty70', 'QRProPerties/QRProPerty70686706238.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=70', '2023-12-29 21:59:58'),
(92, 'QRProPerty', 69, 'QRProPerty69', 'QRProPerties/QRProPerty69897574629.png', 'http://localhost/cclubb.com/property/club/clubstore/properties/details.php?reGcId=69', '2023-12-29 21:59:59');
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 */;
