-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 21, 2024 at 01:07 PM
-- Server version: 5.7.44
-- PHP Version: 8.1.28

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

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

--
-- Table structure for table `affPrograms`
--

CREATE TABLE `affPrograms` (
  `id` int(10) UNSIGNED NOT NULL,
  `affProgram` varchar(128) DEFAULT NULL,
  `affUrl` varchar(255) DEFAULT NULL,
  `refUrl` varchar(255) DEFAULT NULL,
  `PPCdoorway` varchar(255) DEFAULT NULL,
  `commission` varchar(128) DEFAULT NULL,
  `paidVia` varchar(128) DEFAULT NULL,
  `notes` text CHARACTER SET utf8,
  `disc` varchar(128) DEFAULT NULL,
  `discText` varchar(128) DEFAULT NULL,
  `discCode` varchar(128) DEFAULT NULL,
  `discInstructions` varchar(1024) DEFAULT NULL,
  `categories` varchar(128) DEFAULT NULL,
  `type` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `affPrograms`
--

INSERT INTO `affPrograms` (`id`, `affProgram`, `affUrl`, `refUrl`, `PPCdoorway`, `commission`, `paidVia`, `notes`, `disc`, `discText`, `discCode`, `discInstructions`, `categories`, `type`) VALUES
(10, 'Electrum', 'https://www.refersion.com/affiliate/login', 'https://www.electrumpickleball.com/?rfsn=7882298.f1642fa', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '15%', 'PP cgpaypal', '', '20%', '20% off using discount code SWEET20', 'SWEET20', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(9, 'Diadem', 'https://af.uppromote.com/diademsports/login', 'https://diademsports.com?sca_ref=5979421.egJRoZGpGo', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '10%', 'ACH SSB', 'They might raise the commission to SixZero level of 15% if I generate a lot of sales.', '10%', '10% off using discount code DINKER10', 'DINKER10', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(8, 'CRBN', '', 'https://crbnpickleball.com/', '', '', '', '', '10%', '10% off using discount code tanner', 'tanner', 'Enter discount code during checkout.', 'GEAR', 1),
(6, 'Civile Pickleball Apparel', 'https://app.simple-affiliate.com/affiliate', 'https://www.civileapparel.com/r?id=0bs6k8', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '???', '???', 'ce@l', '20%', '20% off using discount code CRAIG', 'CRAIG', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(7, 'Courtside Tennis & Pickleball', 'https://af.uppromote.com/courtsidetennisandpickleball/login', 'https://courtsidetennis.com?sca_ref=5592276.HFxhmcFAPB', 'Pickleballdiscountcodes.com', '20%', 'Venmo', 'No discount available, only commission.', '10%', '10% off link sometimes works.', '(none)', 'Click to activate discount.', 'GEAR', 0),
(5, 'Bread & Butter Pickleball', 'https://app.impact.com/login.user', 'https://www.bnbpickleball.com/discount/norwalk', 'breadandbutterdiscount.com', '10%', 'ACH', '', '15%', '15% off using discount code NORWALK', 'NORWALK', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(4, 'BALLR Pickleball', 'https://ballrpickleball.com/affiliate-home/affiliate-login/', 'https://ballrpickleball.com/?wpam_id=68', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '10%', 'PP cgpay', '50% off a single paddle coupon after you achieve 3 sales. Ref link credits the commission, customer must enter the code to get the discount.', '10%', '10% off using discount code CHRISBO', 'CHRISBO', 'Enter discount code during checkout.', 'GEAR', 0),
(3, 'Aniviia Pickleball', 'None', 'https://www.aniviia.com/discount/ANIVIIA10', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '20%', 'ACH', 'Christine offered to pull a monthly report to show all sales coded to your code, I told her not to bother.', '10%', '$10 off using discount code ANIVIIA10', 'ANIVIIA10', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(2, 'AISO Pickleball', 'https://af.uppromote.com/aiso/login', 'https://aisopickleball.com?sca_ref=6364905.yLdWYQsuPy', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '$5 ', 'PP, p@h', 'ce@l, $20 off personal paddle purchases twice a year.', '10%', '10% off using discount code CleoE10', 'CleoE10', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(1, '11six24 Pickleball', 'https://af.uppromote.com/11six24-pickleball/login', 'https://11six24.com?sca_ref=5549312.EC3PhBWsge', '11six24discount.com', '$10 ', 'Venmo', 'Plus a free paddle every 50 sales.', '$10 ', '$10 off using discount code KELLYJ', 'KELLYJ', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(11, 'Engage', '', 'http://www.engagepickleball.com', '', '', '', '', '20%', '20% off using discount code 20tomasello', '20tomasello', 'Enter code during checkout.', 'GEAR', 1),
(12, 'Friday Pickleball', 'None', 'https://fridaypickle.com/discount/FRIDAYFUNN', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '$15 ', 'PP p@h', 'I arranged FRIDAYFUNN to be a $10 discount (two paddles for $90), reducing my commission to $15. No aff link, custom discount code.', '$10 ', 'Second paddle is $20 instead of $30 using discount code FRIDAYFUNN', 'FRIDAYFUNN', 'Click to activate discount. Get two paddles for $90 instead of $100. If you do test these paddles against other $100-$200 paddles, many would choose this paddle. It is A- or better-rated for EVERY categrory instead of being A+ for some categrories and being below-A rated for somecategories, resulting in a lower overall rating. ! $90 FOR TWO OF THESE PADDLES IS THE MOST AWESOME VALUE (as of May 2024) - and they offer a 90-DAY RETURN POLICY, so you have no risk!', 'GEAR', 0),
(13, 'Gamma', '', 'http://www.gammasports.com', '', '', '', '', '25%', '25% off using discount code Teresa25', 'Teresa25', 'Enter code during checkout.', 'GEAR', 1),
(14, 'Gruvn', '', 'https://gruvn.co?sca_ref=5264884.k3WiqCfNtA', '', '', '', '', '15%', '15% off', '(none)', 'Click to activate discount.', 'GEAR', 1),
(15, 'Honolulu Pickleball Company', 'https://af.uppromote.com/4009c8-2/login', 'https://808pickle.com?sca_ref=5644372.AqjuAyEsAx', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '20%', 'Venmo', 'Can purchase one of each model with a 35% discount. Let nina@808pickle.com know when you want some.', '10%', '10% off using discount code SURFERGUY', 'SURFERGUY', 'Enter discount code during checkout.', 'GEAR', 0),
(16, 'Invis Sport Glasses', '', 'http://www.invissports.com', '', '', '', '', '15%', '15% off using discount code JILLT15', 'JILLT15', 'Enter discount code during checkout.', 'GEAR', 1),
(17, 'Joola Pickleball', '', 'https://joolausa.com/?ref=8190', '', '', '', '', '10%', '10% off using discount code 10EFFECT', '10EFFECT', 'Click to activate discount (or enter code during checkout).', 'GEAR', 1),
(18, 'Just Paddles', 'https://www.justpaddles.com/?rfsn=7943331.661ee47', 'https://www.justpaddles.com/?rfsn=7943331.661ee47&promo=HAPPY10', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '4-10%', 'PayPal', 'p@h', '10%', '10% off using discount code HAPPY10', 'HAPPY10', 'Click to activate discount (or enter code during checkout). Excluded: Babolat, Gearbox, HEAD, JOOLA, Selkirk, and Warstic.', 'GEAR', 0),
(19, 'Lix Pickleball', 'None', 'https://lixpickleball.com/', '', '', '', '', '$15 ', '$15 off paddles using discount code Xuan15', 'Xuan15', 'Enter code during checkout.', 'GEAR', 0),
(20, 'Komodo Pickleball', 'https://komodopickleball.com/affiliate-dashboard/', 'https://komodopickleball.com/ref/137/', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '10%', 'PayPal', 'Code ZALESKI gets 40% off up to 5 paddles when ordred from my email.', '15%', '15% off using discount code CT15', 'CT15', 'Enter code during checkout.', 'GEAR', 0),
(21, 'Luxury Pickleball Vacations', 'https://af.uppromote.com/Luxurypickleball/login', 'https://luxurypickleball.com/pages/lux-vacations?sca_ref=5449206.SU9PBgSYcA', 'Direct to referral link, possibly setup a domain later if we get any commissions.', '10%', 'ACH', 'Not clear there would be a net benefit to making people click twice. Lowered Max CPC bid to $0.11 on both platforms.', 'Varies', 'Discount varies by package', '(none)', 'Click to activate discount.', 'GEAR', 0),
(22, 'Mark Pickleball', 'https://af.uppromote.com/495311-2/login', 'https://markpickleball.com?sca_ref=5642247.Vclv6MR4XU', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '10%', 'PP cgpay', 'k@g', '10%', '10% off using discount code AMB-HAPPY', 'AMB-HAPPY', 'Enter code during checkout. Their paddles have AMAZING spin, among the best in the world at a lower price!', 'GEAR', 0),
(23, 'Neonic Pickleball', 'https://af.uppromote.com/neonic-pickleball/login', 'https://neonicpickleball.com?sca_ref=5691424.rbffbPhXeU', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '15%', 'PP cgpay', 'ce@l', '10%', '10% off using discount code CEDWARDS', 'CEDWARDS', 'Enter discount code during checkout.', 'GEAR', 0),
(24, 'OM Pickleball', 'None', 'https://ompickleball.com/', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '20%', 'quarterly check', 'Rep discount 30%: OMxREP. 40% off cosmetic blemish paddles', '10%', '10% off using discount code OMxNAMASTE', 'OMxNAMASTE', 'Enter code during checkout, includes free priority shipping.', 'GEAR', 0),
(25, 'Omega Pickleball', '', 'https://omegapickleball.com/', '', '', '', 'Christina', '20%', '20% off using discount code 20Hare', '20Hare', 'Enter code during checkout.', 'GEAR', 1),
(26, 'Phantom Pickleball', 'None', 'https://www.phantompickleball.com/', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '$20-$40', 'Zelle', 'c@l, chet edwards, 50% off demos, $20 per Eternal, $30 per Savage/Immortal/Sniper/Goliath and $40 per Trinity sold. Plus an extra 10% on all additional gear purchased.', '20%', '20% off using discount code AMChetE20', 'AMChetE20', 'Enter discount code during checkout.', 'GEAR', 0),
(27, 'Pickleball Apes', 'https://af.uppromote.com/pickleballapes/login', 'https://www.pickleballapes.com?sca_ref=5531049.ptrHTRIGeQ', 'pickleballapesdiscountcode.com', '15%', 'ACH', '', '10%', '10% off using discount code Dinker', 'Dinker', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(28, 'Pickleball Clearance', 'https://pickleball-clearance.goaffpro.com/', 'https://www.pickleballclearance.com/?ref=AN7m3ILx4JDd7b', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '5%', 'TBD', '', '10%', '10% off using discount code CHETEWING', 'CHETEWING', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(29, 'Pickleball Superstore', 'https://pickleballsuperstore.com/account', 'https://pickleballsuperstore.com/discount/Kathy-108913', 'Direct to referral link', '10%', 'PP Tier 1: p@h, Tier 2: cgpaypal', 'Tier 1: Connor Brooks, c@l. Tier 2: Kathy Zaleski kazaleski@gmail.com. Pays Tier 1 an extra 4-10% of Tier 2\'s sales, 2% bonus for top-selling affiliates.', '10%', '10% off using discount code Kathy-108913', 'Kathy-108913', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(30, 'ProDrive', 'https://f40c4290-4c50-40a8-99ad-b0bda53185b7.goaffpro.com/', 'https://www.prodrivepickleball.com/?ref=3uPw3tutWQ4NTW', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '15%', 'store credit', 'Can get $50 off one paddle with code Ambassador50off. Insted of getting a free paddle for every 5th time your code is used, you get a store credit for a value of 15% of the sales every time your code is used.', '10%', '10% off using discount code 10PCTOFF', '10PCTOFF', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(31, 'Proton', '', 'https://protonsports.com', '', '', '', '', '20%', '20% off using discount code JOHNKEW', 'JOHNKEW', 'Enter discount code during checkout.', 'GEAR', 1),
(32, 'Pro XR Pickleball', 'https://proxrpickleball.com/account/login', 'https://i.refs.cc/FC5yiZVT?smile_ref=eyJzbWlsZV9zb3VyY2UiOiJzbWlsZV91aSIsInNtaWxlX21lZGl1bSI6IiIsInNtaWxlX2NhbXBhaWduIjoicmVmZXJyYWxfcHJvZ3JhbSIsInNtaWxlX2N1c3RvbWVyX2lkIjoyMTAxNjQ5MDc1fQ%3D%3D', 'proxrdiscount.com', '$20 ', 'Store credit via $20 coupon codes.', 'Hopefully they stack.', '$20 ', '$20 off Pro XR (Zane Navratil\'s) pickleball gear', '(none)', 'Click to activate discount.', 'GEAR', 0),
(33, 'Ronbus', '', 'https://www.ronbus.com/', '', '', '', '', '10%', '10% off using discount code 10JOHNKEW', '10JOHNKEW', 'Enter discount code during checkout.', 'GEAR', 1),
(34, 'Six Zero Pickleball', 'https://af.uppromote.com/six-zero-7668/login', 'https://www.sixzeropickleball.com/collections/paddles?sca_ref=3661223.VM3GFcZKzQ', 'sixzerodiscount.com sixzerodiscountcode.com', '15%', 'PayPal', 'k@g, Both redirect to pickleballdiscountcodes.com, must enter code ZALESKI10 during checkout. I get 15% off.', '10%', '10% off using discount code ZALESKI10', 'ZALESKI10', 'Enter discount code during checkout.', 'GEAR', 0),
(35, 'Selkirk', '', 'https://selkirk,com', '', '', '', '', '10%', '10% gift card using discount code ADV-YVONNED', 'ADV-YVONNED', 'Enter discount code during checkout. Get a gift card from selkirk for 10% of your purchase in 7-10 days.', 'GEAR', 1),
(36, 'Spartus Pickleball', 'https://af.uppromote.com/gospartus/login', 'https://gospartus.com?sca_ref=5691368.DafinwVk03', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '$10 ', 'PP p@h', 'Use link or enter code CHADSTER during checkout. I can get 20% off a paddle.', '10%', '10% off using discount code CHADSTER', 'CHADSTER', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(37, 'Spinshot Ball Machines', 'https://af.uppromote.com/spinshot-sports-us/login', 'https://spinshotsports.com?sca_ref=6010738.38R57oKnP8', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '8%', 'PP p@h', 'Use link for $100 off.', '$100 ', '$100 off', '(none)', 'Click to activate discount. Best of the best, elevate your game quickly with these, better than Titan.', 'GEAR', 0),
(38, 'Titan Ball Machines', '', 'https://titanballmachines.com/john', '', '', '', '', '$100 ', '$100 off', '(none)', 'Click to activate discount. Not as good as Spinshot. but some might want this discount anyway.', 'GEAR', 1),
(39, 'TopspinPro Pickleball Training Aid', 'https://topspinpro.com/partners/dashboard/', 'https://topspinpro.com/discount/xuan10/', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '10%', 'PP p@h', 'Use link for 10% off.', '10%', '10% off', '(none)', 'Click to activate discount. Awesome tool to improve anyone\'s game.', 'GEAR', 0),
(40, 'Thrive Pickleball', '', 'https://thrivepb.com/', '', '', '', '', '10%', '10% off using discount code PICKLEBALLWILL', 'PICKLEBALLWILL', 'Enter discount code during checkout.', 'GEAR', 1),
(41, 'Vatic Pro Pickleball', 'https://af.uppromote.com/vatic-pro/login', 'https://vaticpro.com?sca_ref=5514235.xWA3qqCoNM', 'vaticprodiscountcode.com', '$5-10', 'PayPal', '$5 for Prism paddles, $10 for non-Prism paddles', '$10 ', '$10 off using discount code PHILLYJOE', 'PHILLYJOE', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(42, 'Volair', 'https://volair.refersion.com/affiliate', 'https://www.volair.com/discount/BOSTON64?rfsn=7874724.538479&utm_source=refersion&utm_medium=affiliate&utm_campaign=7874724.538479', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '15%', 'PayPal', 'DO NOT post to coupon sites.', '10%', '10% off using discount code BOSTON64', 'BOSTON64', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0),
(43, 'Xenon', 'None (manual via Noah)', 'https://xenonpaddle.com/discount/pickle10?redirect=%2Fcollections%2Fpickleball-paddles', 'Pickleballdiscountcodes.com - setup domain later if sufficient traffic', '15%', 'ACH (not setup yet)', '$50 each for demos', '$10 ', '$10 off using discount code pickle10', 'pickle10', 'Click to activate discount (or enter code during checkout).', 'GEAR', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `affPrograms`
--
ALTER TABLE `affPrograms`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `affPrograms`
--
ALTER TABLE `affPrograms`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
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 */;
