membershipbonuses Database Table

Table: membershipbonuses

Tool: Commission Tracking
Associated Objects: MembershipBonuses, MembershipBonus

Fields

id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT v5

membership SMALLINT UNSIGNED NOT NULL DEFAULT 1 v5

frequency TINYINT UNSIGNED NOT NULL v5

criteria TINYINT UNSIGNED NOT NULL v5

amount DECIMAL(8,2) NOT NULL v5

sharegroup SMALLINT UNSIGNED NOT NULL DEFAULT 0 v5

max DECIMAL(8,2) NOT NULL v5

shares TINYINT UNSIGNED NOT NULL DEFAULT 1 v5

paytype SMALLINT NOT NULL DEFAULT 0 v5

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM membershipbonuses");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $membership = $resRow["membership"];  //
 $frequency = $resRow["frequency"];  //
 $criteria = $resRow["criteria"];  //
 $amount = $resRow["amount"];  //
 $sharegroup = $resRow["sharegroup"];  //
 $max = $resRow["max"];  //
 $shares = $resRow["shares"];  //
 $paytype = $resRow["paytype"];  //
}

Other Commission Tracking Tables

commissionholdings commissions commissiontierrollups commissiontiers membershipbonuses membershipupgrade payouts

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us