DB nightmare, no iframes?

  • Ok, First off, I like the plugin, for the most part. But it does not work how I want out of the box.

    The biggest gripe I have about this plugin is that it creates a TERRIBLE impressions table, which causes mysql to crawl to a slow (esp on a site like mine which gets over 100k visits a month)

    So I have some impressions table that has over 10,000 rows. Wow that is TERRIBLE. You really need to pitch the way you handle impressions altogether. Backing up my MySQL DB always gives me warnings because of the large table size.

    Second off.. Flash banners are so 2005. You need to allow for iframe html5 banners. I use html5 banners on my site, and I got them to work with your software by using jquery, you can see my code here:

    https://gist.github.com/MattMcFarland/7467902

    You’re welcome.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Ash Durham

    (@ashdurham)

    Hi Matt,

    Can you confirm that you have set the impressions expiry in the settings? I have been alerted to this and am currently working on a better way to handle this data.

    Flash banners have been included in the functionality as it was a request by other users of the plugin, something that they were quite appreciative of. I back you up 110% that flash is dead, but I need to cater for all users. And having it in the functionality list doesn’t hurt your experience of the plugin so it shouldn’t be a problem.

    Regarding your iFrame banners, I would be happy to add this to the functionality without the need to use jquery to do so. All you had to do was lodge a support ticket for it. As I haven’t, nor anyone else at this point, had the need for iFrame functionality is the sole reason why it hasn’t been built in as yet.

    I do hope we can work together on this to make this plugin work 100% for you. I will take your suggestions on board for the next release and see how we go.

    Thread Starter Matt McFarland

    (@matt-mcfarland)

    Hi Ash!

    Thanks for your reply ??

    Looks like it was indeed the expiry times! If there was away to disable IP logging that would be great. Honestly, what would be really cool (and not harm the DB at all) is logging impressions, clicks, and IP addresses on google analytics. Please take a look at the gist I posted earlier, as it shows impression logging and click logging. To log the IP address one could easily just have php add the IP into an element attribute of the banner “data-ip” for example.

    Also, yes flash support keep that, sorry to come across like its terrible ?? It still has good use.

    Yeah, what would be better than text support, is iframe support, because someone could create an html file with great styling, animations, etc.

    The text banners, whenever I add html to them, they break. So iframe would be great.

    Plugin Author Ash Durham

    (@ashdurham)

    Hey Matt,

    Sorry for the delay in reply.

    Thanks for posting that gist. I have finally had a bit of time to be able to look over the code and I love the concept. The only problem I have with it is that it assumes too much about the user. Assuming the user has and uses a Google Analytics account and knows how to retrieve the event tracking data (education is of course the order of the day at that point). I unfortunately don’t want to release a product that relies on another to work.

    With that said however, I’m all for the idea of giving the option (turning on the ability) to track using GA instead of the local database, something that I’m quite excited about implementing so keep an eye out for that (I’ll be sure to follow your current setup so that it merges nicely for you without the need to change anything your doing). This would then add fields on the individual adverts to assign campaign names and the like to support the method.

    The other thing I will certainly take on board is the HTML5 banner. I wont be replacing the text banner though as thats not intended for the use as you are attempting to use it for. The idea behind the text ‘banner’ (its not really a ‘banner’ of sorts) is so you can track plain text links using Ad King Pro. Ie drop the shortcode in the middle of a sentence and suddenly you track text links.

    I will be adding a new option for the HTML5 banners, and somewhat adopting your thought processes in terms of adding HTML files and loading them in. I’m not a fan of having to create all these folders and what not though as I do have alot of users that aren’t technical and that process will just lose them in a heartbeat (granted that anyone using this method 9/10 times will have created the html file themselves and therefore would have the technical knowlegde to FTP the files up, but then the plugin isn’t simple ?? ). I’ll work on a version that is manageable through the admin area, ultimately in the individual advert edit screen. Attach (or link to) the HTML file to the advert, assign the output size and AKP does the rest. Sounds promising ??

    Thank you for you input with this. WP community input and feedback is what makes for great WP Plugins!

    Plugin Author Ash Durham

    (@ashdurham)

    Hey Matt,

    Just wanted to let you know that the latest version 1.9.8 has HTML5 support included. You may need to still adopt your SVG code to get your banners to work however I have added the ability to chose HTML5 as a banner option, upload or link to a file and specify the dimensions. All thats then needed is an anchor tag in the html file thats linked to and Ad King Pro handles the rest.

    I haven’t released the GA option yet as I needed to commit some supplied translations, its next on my list though.

    Plugin Author Ash Durham

    (@ashdurham)

    Hey Matt,

    Dunno if your still interested in this plugin, but I finally got around to implementing the GA integration into the plugin. Gave you a wrap too ?? https://kingpro.me/article/news/rss-king-pro-1-0-7-boasts-powerful-functionality-ad-king-pro-1-9-13-fixes-big-issues/

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘DB nightmare, no iframes?’ is closed to new replies.