ArcadeBB Trade V5 WordPress Plugin

[admin]

ArcadeBB Trade V4 WordPress Plugin may be out only since 24th Dec 2010, I am already thinking of how to improve it. You may also suggest anything that is related to the Trade Plugin.

1) Partner Trade Site Status Auto Approve after submitting site for traffic trading. Setting will be 1-enable, 0-disable under ArcadeBB/Trade Setup.

[MickOS]

One thing I think would help grow the number of users of your plugin would be to automate as much of the install process as possible. The SQL queries and creating pages could be done on activation of the plugin e.g

PHP Code:

<?php
register_activation_hook(__FILE__, 'trade_plugin_initialise');

function trade_plugin_initialise() {
if (!(get_option( 'arcadebb_trade_version' ) == "3") ){ 
        // Update to version 3...
        global $wpdb;
        
        $wpdb->query("CREATE TABLE IF NOT EXISTS `trade_ipaddress` (`ipaddress` varchar(15) NOT NULL default '', `websiteurl` text NOT NULL, `post_id` int(11) NOT NULL default '0', `io` int(1) NOT NULL default '0', `time` int(11) NOT NULL default '0', PRIMARY KEY (`ipaddress`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        $wpdb->query("CREATE TABLE IF NOT EXISTS `trade_plugs` (`plugid` int(10) unsigned NOT NULL auto_increment, `post_id` int(10) NOT NULL default '0', `websiteid` int(10) NOT NULL default '0', `plugurl` text NOT NULL, `plugstatus` int(1) NOT NULL default '0', `plugdayout` int(10) NOT NULL default '0', `plugtotalout` int(10) NOT NULL default '0', `plugnote` text NOT NULL, PRIMARY KEY (`plugid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1");
        $wpdb->query("CREATE TABLE IF NOT EXISTS `trade_links` (`linkid` int(11) unsigned NOT NULL auto_increment, `linktype` varchar(255) NOT NULL, `websiteid` int(11) NOT NULL default '0', `linkurl` varchar(255) NOT NULL, `linkstatus` int(1) NOT NULL default '0', `linkdayout` int(11) NOT NULL default '0', `linktotalout` int(11) NOT NULL default '0', `linknote` varchar(255) NOT NULL, PRIMARY KEY (`linkid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1");

        
        // Create pages...
        $my_post1 = array(
            'post_title' => 'Trade Traffic',
            'post_type' => 'page',
            'post_status' => 'publish',
            'post_author' => 1
            );

        // Insert the post into the database
        $gotPage = wp_insert_post( $my_post1 );
        // Set page template...
        update_post_meta($gotPage, "_wp_page_template", "trade-traffic.php"); // Needs to be able to find trade-traffic.php in theme directory for this to work
        
        $my_post2 = array(
            'post_title' => 'Trade Stats',
            'post_type' => 'page',
            'post_status' => 'publish',
            'post_author' => 1
            );

        // Insert the post into the database
        $gotPage2 = wp_insert_post( $my_post2 );
        // Set page template...
        update_post_meta($gotPage2, "_wp_page_template", "trade-stats.php");// Needs to be able to find trade-stats.php in theme directory for this to work
        
        // Set new version
        add_option( 'arcadebb_trade_version', "3" ) or update_option( 'arcadebb_trade_version', "3" );
    }
}
<? 


That is an incomplete example( not the full queries and pages ) but I'm sure you get the idea. The CRON job to reset the stats could be run on the built in wordpress CRON. It's not super precise on the exact minute it triggers at ( triggers when any post/page is viewed after the specified time ) but it would reduce the install worries for people who aren't too technically minded. Again, I said it on AWF but I'll say it here too: kudos for making it easy for people to download.

PS: excuse the slight table breakage from the code block.

[admin]

MickOS,

Thanks for pointing me to the right direction. That should be the way. I will work on that part to make installation as simple as possible.

[MickOS]

No problem. Were you planning to add floating icons for trading out? I thought that might be what the Banner Setup section of the plugin would be eventually. They float on the bottom right of every page and link to out.php


If so I have some code that might save you some time on it. Paste the code into arcadebb.php plugin, upload tradeBanner.jpg and the .js file from the zip:
  jquery.floatingbox.zip (Size: 1.59 KB / Downloads: 2) to the plugin directory also.

PHP Code:

add_action('wp_head', 'showFloatTradeBanner');

function showFloatTradeBanner($content){
    
    $content .= "<script type=\"text/javascript\" src=\"http://code.jquery.com/jquery-1.4.2.min.js\">
</script>
<script type='text/javascript' src=\"".get_bloginfo('siteurl')."/wp-content/plugins/arcadebb/jquery.floatingbox.js\">
</script>


<script type='text/javascript'>

            $(document).ready(
                function()
                {
                    $('#box').floating({targetX:\"right\", targetY:\"bottom\"});
                }
            );
           
        </script>

<div id='box' style='width:51px; height:51px; padding:0px;z-index:9999;'><a href=\"".get_bloginfo('siteurl')."/out.php\" > <img src=\"".get_bloginfo('siteurl')."/wp-content/plugins/arcadebb/tradeBanner.jpg\">  </a></div>";
    echo $content;
} 


Now the icon will show on every page and stick to the bottom right of the users window. With some decent banners it should get a good CTR.

[admin]

MickOS,

Thanks, it's a valuable suggestion. I saw it somewhere that it floats along the bottom right. With the right banner, it should get a high CTR.

[4ks]

I have regular suggestions, which relate to statistics on traders:
1. Convertion rate or click prod. %
2. RAW stats
It's very important IMO
Thanks )

[admin]

(01-08-2011 05:59 AM)4ks Wrote:  I have regular suggestions, which relate to statistics on traders:
1. Convertion rate or click prod. %
2. RAW stats
It's very important IMO
Thanks )

Hi 4KS,

One thing about Conversion rate, What is counted a convert? I am not sure if it is possible to count click on ads, that is not own by the site, eg, cpmstar, ad4game, adsense,

What do you mean by RAW stats?

[4ks]

(01-08-2011 10:22 AM)ArcadeBB Wrote:  

(01-08-2011 05:59 AM)4ks Wrote:  I have regular suggestions, which relate to statistics on traders:
1. Convertion rate or click prod. %
2. RAW stats
It's very important IMO
Thanks )

Hi 4KS,

One thing about Conversion rate, What is counted a convert? I am not sure if it is possible to count click on ads, that is not own by the site, eg, cpmstar, ad4game, adsense,

What do you mean by RAW stats?

Hi ArcadeBB,

I would like to explain my point of view that regards the trade traffic.
I appreciate the traders on such key criteria:
1. Click productivity or convertion rate. This means % of visitors who made the transition to other traders. This is important, because according to this indicator
estimated how productive traffic from the trader. More productive traffic, the better the growing trade site. If traffic is unproductive, the trade site
blown away )
2. AdSense Revenue which can be viewed in GA.
3. Geo IP.
4. RAW hits - those visitors who have already visited the site in the current day. If the trader send or receives a lot of RAW hits it is bad.

Thanks )

[MickOS]

Any updates on how this is going?

[admin]

@MickOS, I really missed 4KS reply.

So, as what 4KS said,
Productivity here means converting visitor to another trade.
RAW means counting all hits including repeated visitors.

Initially I thought productivity include converting traffic into revenue.
That will not be easy as it's not easy to count clicks on ads. However if it only includes converting traffic into trades, then it's much easier.

I will include them in V5.