Hello There, Guest! Register

Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Zinux, LLC: Total Earned Script [VERSION 0.2.1]
02-28-2014, 07:58 PM (This post was last modified: 04-10-2014 01:04 PM by zinuxllc.)
Post: #1
Lightbulb Zinux, LLC: Total Earned Script [VERSION 0.2.1]
We have started working on several small scripts to contribute to the community for free, and plan to work on offerwall plug-ins and more in the future.

The total earned script, is as simple as it sounds. It pulls information from the clixscript database to display a total earned variable on your homepage or anywhere you would like. This is considered an alpha release, as not all income types have been added or the script publicly tested.

Please "the code" in a php file (ie. clixscript-total-earned.php), then upload it to the root of your gpt website after editing the server connection information to match that of your Clixscript installation. Then add the "include code" where you want it displayed at.

The code:
Code:
<?

// Server Connection Information

$earned_host="hostname"; // Host name
$earned_username="username"; // Mysql username
$earned_password="password"; // Mysql password
$earned_name="database"; // Database name

// Connect To Server and Select Database

mysql_connect("$earned_host", "$earned_username", "$earned_password")or die("cannot connect");
mysql_select_db("$earned_name")or die("cannot select DB");

// Offers Sub-Total Calculation

$earned_offers_result = mysql_query('SELECT SUM(amount) AS earned_offers_sum FROM clix_offers_transactions');
$earned_offer_row = mysql_fetch_assoc($earned_offers_result);
$earned_offers = $earned_offer_row['earned_offers_sum'];

// Offerwall Sub-Total Calculation

$earned_offerwall_result = mysql_query('SELECT SUM(amount) AS earned_offerwall_sum FROM clix_offerwall_submissions WHERE status="1"');
$earned_offerwall_row = mysql_fetch_assoc($earned_offerwall_result);
$earned_offerwall = $earned_offerwall_row['earned_offerwall_sum'];

// Overall Total Earned

$earned_total = $earned_offers + $earned_offerwall;

// Display Overall Total Earned (2 Decimal Format)

print "$";
printf ("%01.2f", $earned_total);

?>

Include code:
Code:
<?php include 'clixscript-total-earned.php'; ?>

### Changelog ###
0.0.1 /
+ Database Connection
+ Offers Sub-Total
+ Offerwalls Sub-Total
+ Overall Total Display

### Bugs ###
+ MySQL Depreciated in PHP 5.5.0 (will not work on 5.5.0) until next version

[Image: zinuxcorp.gif]
(+1) 877 797 8094 | http://www.zinuxcorp.com | support@zinuxcorp.com

COMING SOON
[Image: zinuxgpt.gif]
Visit this user's website Find all posts by this user
Quote this message in a reply
03-02-2014, 02:42 AM
Post: #2
RE: Zinux LLC: Total Earned Script
Nice share
Find all posts by this user
Quote this message in a reply
03-02-2014, 08:45 AM (This post was last modified: 03-08-2014 09:03 AM by zinuxllc.)
Post: #3
RE: Zinux LLC: Total Earned Script
Thank you very much, glad that you like it. If you have any recommendations for more features or changes or bug reports please let us know. We also plan to add several other scripts over the next week to help other members of the community out.

Announcing version 0.0.2

This version now includes support for both mysql function and mysqli function, the reason for this added support for mysqli is that as of PHP version 5.5.x mysql function is being done away with in exchange for mysqli.

[Image: zinuxcorp.gif]
(+1) 877 797 8094 | http://www.zinuxcorp.com | support@zinuxcorp.com

COMING SOON
[Image: zinuxgpt.gif]
Visit this user's website Find all posts by this user
Quote this message in a reply
03-08-2014, 09:11 AM
Post: #4
RE: Zinux LLC: Total Earned Script
We are pleased to announce version 0.1.0 of this script, which offers users the option of only showing the offers or offerwall totals, as well as the combined totals. We are currently working on algorithm for adding in totals for clicks from PTC ads, so look forward to that in a future version.

/// 0.1.0 ///
[NEW] Changelog Format
[NEW] Documentation Updated
[NEW] Improved Currency Formatting
[NEW] Show only offerwall totals
[NEW] Show only offers totals


.zip  Zinux-Clixscript-Total-Earned-010.zip (Size: 5.33 KB / Downloads: 5)

[Image: zinuxcorp.gif]
(+1) 877 797 8094 | http://www.zinuxcorp.com | support@zinuxcorp.com

COMING SOON
[Image: zinuxgpt.gif]
Visit this user's website Find all posts by this user
Quote this message in a reply
03-20-2014, 06:24 AM (This post was last modified: 03-21-2014 03:03 PM by zinuxllc.)
Post: #5
RE: Zinux, LLC: Total Earned Script
We are currently working on version 0.2.0 which will now include points earned from offerwalls in the total. We hope to have this new version released within 1-2 weeks.

After further review we found that offerwall points are being counted but not correctly, due to severity of this issue we hope to have it completed and a new version released very soon. We apologize for any issues this may have caused with total earned being reflect incorrectly.

[Image: zinuxcorp.gif]
(+1) 877 797 8094 | http://www.zinuxcorp.com | support@zinuxcorp.com

COMING SOON
[Image: zinuxgpt.gif]
Visit this user's website Find all posts by this user
Quote this message in a reply
03-21-2014, 04:10 PM
Post: #6
RE: Zinux, LLC: Total Earned Script
We are pleased to announced version 0.2.0 :

/// 0.2.0 ///
[BUGFIX] Points no longer counted as cash
[REMOVED] Support for mysql function
[NEW] Points correctly added to total
[NEW] Points to Currency Calculation

In this version we resolved the issue with points being counted as currency, also we have made the decision to dedicate our time and development to mysqli as mysql functions are no longer supported in 5.5.x. This is strictly a coding decision, and should not affect any users.

As always thank you for your feedback and bug reports.


.zip  Zinux-Clixscript-Total-Earned-020.zip (Size: 3.28 KB / Downloads: 2)

[Image: zinuxcorp.gif]
(+1) 877 797 8094 | http://www.zinuxcorp.com | support@zinuxcorp.com

COMING SOON
[Image: zinuxgpt.gif]
Visit this user's website Find all posts by this user
Quote this message in a reply
04-05-2014, 12:37 PM
Post: #7
RE: Zinux, LLC: Total Earned Script
Same question i would like to try these plugin but is this compatible with 2.68
Find all posts by this user
Quote this message in a reply
04-05-2014, 12:42 PM
Post: #8
RE: Zinux, LLC: Total Earned Script
(04-05-2014 12:37 PM)murugan Wrote:  Same question i would like to try these plugin but is this compatible with 2.68

The changelog for version 2.68 has not been posted yet, as such we cannot verify it's compatibility. We will check compatibility with version 2.68 on our test server, and let you know within 24-48 hours if there are any issues.

[Image: zinuxcorp.gif]
(+1) 877 797 8094 | http://www.zinuxcorp.com | support@zinuxcorp.com

COMING SOON
[Image: zinuxgpt.gif]
Visit this user's website Find all posts by this user
Quote this message in a reply
04-08-2014, 01:49 AM
Post: #9
RE: Zinux, LLC: Total Earned Script
any update
Find all posts by this user
Quote this message in a reply
04-08-2014, 04:34 AM
Post: #10
RE: Zinux, LLC: Total Earned Script
(04-08-2014 01:49 AM)murugan Wrote:  any update

We have tested this add-on/plug-in and found no issues with version 2.68 of clixscript. However, we have updated the documentation in the new version 0.2.1 which adds an additional advisory that you must use an absolute path when including the files. If you have any other questions please do not hesitate to let us know.


Attached File(s)
.zip  Zinux-Clixscript-Total-Earned-021.zip (Size: 3.35 KB / Downloads: 8)

[Image: zinuxcorp.gif]
(+1) 877 797 8094 | http://www.zinuxcorp.com | support@zinuxcorp.com

COMING SOON
[Image: zinuxgpt.gif]
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)