X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-sponsor.php;h=9342c009b645e4c8362d12f638e1b988f6cc62a4;hp=e1094ba006861f8258c2d901fec358f3ef5d6149;hb=61cd26135cd5e043032bcd50aff24fbf5429352b;hpb=2ab9a01a035770d24c82ae64267e6291ae2940cd diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php index e1094ba006..9342c009b6 100644 --- a/inc/extensions/ext-sponsor.php +++ b/inc/extensions/ext-sponsor.php @@ -80,16 +80,16 @@ email VARCHAR(255) NOT NULL DEFAULT '', url VARCHAR(255) NOT NULL DEFAULT '', password VARCHAR(255) NOT NULL DEFAULT '', remote_addr VARCHAR(15) NOT NULL DEFAULT '0.0.0.0', -sponsor_created VARCHAR(10) NOT NULL DEFAULT '0', -last_online VARCHAR(10) NOT NULL DEFAULT '0', -last_change VARCHAR(10) NOT NULL DEFAULT '0', +sponsor_created VARCHAR(10) NOT NULL DEFAULT 0, +last_online VARCHAR(10) NOT NULL DEFAULT 0, +last_change VARCHAR(10) NOT NULL DEFAULT 0, status ENUM('UNCONFIRMED','PENDING','CONFIRMED','LOCKED') NOT NULL DEFAULT 'UNCONFIRMED', receive_warnings ENUM('Y','N') NOT NULL DEFAULT 'Y', warning_interval BIGINT(20) UNSIGNED NOT NULL DEFAULT '".($_CONFIG['one_day']*7)."', -points_amount DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000', -points_used DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000', -refid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', -ref_count BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +points_amount FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, +points_used FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, +refid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +ref_count BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, hash VARCHAR(32) NOT NULL DEFAULT '', last_pay FLOAT(7,2) UNSIGNED NOT NULL DEFAULT '0.00', last_curr VARCHAR(255) NOT NULL DEFAULT '€', @@ -103,14 +103,14 @@ PRIMARY KEY(id) $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_orders"; $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_orders ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, -sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', -aid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', -regid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', -payid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', -pay_count BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +regid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +payid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +pay_count BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, pay_status ENUM('PENDING','PAYED','UNPAYED','DELETED') NOT NULL DEFAULT 'PENDING', -pay_ordered VARCHAR(10) NOT NULL DEFAULT '0', -pay_done VARCHAR(10) NOT NULL DEFAULT '0', +pay_ordered VARCHAR(10) NOT NULL DEFAULT 0, +pay_done VARCHAR(10) NOT NULL DEFAULT 0, KEY (payid), KEY (regid), KEY (aid), @@ -124,8 +124,8 @@ PRIMARY KEY(id) $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_paytypes ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, pay_name VARCHAR(255) NOT NULL DEFAULT '', -pay_rate DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000', -pay_min_count BIGINT(20) UNSIGNED NOT NULL DEFAULT '1', +pay_rate FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, +pay_min_count BIGINT(20) UNSIGNED NOT NULL DEFAULT 1, pay_currency VARCHAR(255) NOT NULL DEFAULT '€', PRIMARY KEY(id) )TYPE=MyISAM"; @@ -136,7 +136,7 @@ PRIMARY KEY(id) $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_action_convert ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor', -conv_rate BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +conv_rate BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, conv_name VARCHAR(255) NOT NULL DEFAULT 'Mails', KEY (ext_name), PRIMARY KEY(id) @@ -151,7 +151,7 @@ action VARCHAR(255) NOT NULL DEFAULT '', what VARCHAR(255) NULL DEFAULT NULL, title VARCHAR(255) NOT NULL DEFAULT '', active ENUM('Y','N') NOT NULL DEFAULT 'N', -sort BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +sort BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, KEY(what), KEY(action), PRIMARY KEY(id) @@ -162,10 +162,10 @@ PRIMARY KEY(id) $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_registry"; $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_registry ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, -aid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor', is_active ENUM('Y','N') NOT NULL DEFAULT 'N', -stamp_added VARCHAR(10) NOT NULL DEFAULT '0', +stamp_added VARCHAR(10) NOT NULL DEFAULT 0, KEY(ext_name), KEY(aid), PRIMARY KEY(id) @@ -176,10 +176,10 @@ PRIMARY KEY(id) $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_urls"; $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_urls ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, -sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, url VARCHAR(255) NOT NULL DEFAULT 'http://', title VARCHAR(255) NOT NULL DEFAULT '', -clicks BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +clicks BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING', KEY(sponsorid), PRIMARY KEY(id) @@ -190,12 +190,12 @@ PRIMARY KEY(id) $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_banner"; $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_banner ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, -sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, url VARCHAR(255) NOT NULL DEFAULT 'http://', alternate VARCHAR(255) NOT NULL DEFAULT '', -width INT(7) NOT NULL DEFAULT '468', -height INT(7) NOT NULL DEFAULT '60', -views BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +width INT(7) UNSIGNED NOT NULL DEFAULT 468, +height INT(7) UNSIGNED NOT NULL DEFAULT 60, +views BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING', KEY(sponsorid), PRIMARY KEY(id) @@ -206,17 +206,17 @@ PRIMARY KEY(id) $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaigns"; $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_campaigns ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, -sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', -aid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, campaign_name VARCHAR(255) NOT NULL DEFAULT '', -campaign_start VARCHAR(10) NOT NULL DEFAULT '0', -campaign_end VARCHAR(10) NOT NULL DEFAULT '0', -campaign_amount DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000', +campaign_start VARCHAR(10) NOT NULL DEFAULT 0, +campaign_end VARCHAR(10) NOT NULL DEFAULT 0, +campaign_amount FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, campaign_expired ENUM('Y','N') NOT NULL DEFAULT 'N', campaign_locked ENUM('Y','N') NOT NULL DEFAULT 'Y', -campaign_ended VARCHAR(10) NOT NULL DEFAULT '0', -locked_reason tinyblob, -locked_timestamp VARCHAR(10) NOT NULL DEFAULT '0', +campaign_ended VARCHAR(10) NOT NULL DEFAULT 0, +locked_reason TINYBLOB, +locked_timestamp VARCHAR(10) NOT NULL DEFAULT 0, status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING', KEY(aid), KEY(sponsorid), @@ -228,11 +228,11 @@ PRIMARY KEY(id) $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaign_assigns"; $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_campaign_assigns ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, -campaignid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', -urlid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', -bannerid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', -clicks BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', -views BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +campaignid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +urlid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +bannerid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +clicks BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, +views BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, KEY(bannerid), KEY(urlid), KEY(campaignid), @@ -254,7 +254,7 @@ PRIMARY KEY(id) $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_display_data"; $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_display_data ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, -sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', +sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, data_row VARCHAR(255) NOT NULL DEFAULT '', display ENUM('Y','N') NOT NULL DEFAULT 'N', KEY(sponsorid), @@ -365,8 +365,8 @@ PRIMARY KEY(id) // // General configuration stuff // - $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_ref_points DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '100.00000'"; - $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_min_points DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '1000.00000'"; + $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_ref_points FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 100.00000"; + $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_min_points FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 1000.00000"; // Load CSS file $EXT_CSS = "Y"; @@ -429,8 +429,5 @@ default: // Do stuff when extension is loaded break; } -// Language file prefix -$EXT_LANG_PREFIX = "sponsor"; - // ?>