Awsome Module

Newbie Joined: Jun 13, 2006 Posts: 40

Seen as there is no where to catogorie to post this in i wanted to say what an AWSOME module...

Well done, this is one of if not the best module ive seen since nuke was released... a totally easy way of sending news to our site members with ease..

Thank you for developing this module...

Now onto the question !!

how can i add my Digital Goods from nuke royal into the email ?

Thanks Ped

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

Your kind words are most appreciative! We, in the open source community, very rarely get to hear such things, so it helps with the "motivation factor".

Regarding your "Digital Goods" question, I have never used this tool and do not know much about it. However, if you are somewhat PHP-savvy and know your way a bit around phpMyAdmin, the building of the newsletter from the various mySQL tables and from your chosen template occurs in the following script:

admin\admin_make_nls.php

If you are needing to add additional NL options, this could be done as well, but you will need to also modify these files to get these things properly incorporated into the admin --> create newsletter function:

admin\admin.php
admin\admin_check_post.php

Best regards and again, thank you for the kind words!

Newbie Joined: Jun 13, 2006 Posts: 40

Sorry if my english is a little well, backwards it was 3 in the morning and i was a little tired !!

Yeah i can find sql's and ill have a go at addding them to where you said above.

If i manage to do it ill add what i did here

Thx again for this totally exellent module

Ped

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

If you run into trouble, don't hesitate to ask... just realize that I have never used Digital Goods, so you will have to be my "eyes and ears" so to speak... Laughing

Well, I am off to bed now... been up way too long for my liking. Regards and good luck!

Newbie Joined: Jun 13, 2006 Posts: 40

wow, i looked in the first file admin_make_nls.php and its like a maze !! lol

I think ill leave well alone Laughing

idd prob brake it..

No worries though please bear Digital Goods in mind for your next release if you want to use my site sql to pinch the infomation required

You can

http://udesign.me.uk

As it looks a little over my head .. i can add bits and bobs but i think this is a too big a challange for a noob like me

Thanks Ped

Site Admin Joined: Jul 18, 2005 Posts: 383

Yes, that would certainly be a very interesting idea - just imagine all those 'sales' newsletter that could be sent out with all the latest 'goods' - wow, that would be really neat!!

Newbie Joined: Jun 13, 2006 Posts: 40

lol yeah thats why i was asking so i could spam away !!

Laughing

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

You guys are TOO funny!

By the way, can someone give me a brief summary of what type of "links" would you be wanting to include in the newsletter and how many different tables would the information be coming from?

Since I have never used DG and have just heard so many horror stories about no support, I get a little nervous trying to support it myself (the newsletter integration), but I can at least look into and see what it would take.

Of course, that is on top of the 30 other enhancement requests I already have logged... Sad

Just too much time spent on RavenNuke76. Wink

Newbie Joined: Jun 13, 2006 Posts: 40

wow 30 requests !! people must realize that this is a very powerful module and can be used to their advantage !!

with regards to links for Digital_Goods i think some thing similar to the other items you have done already to keep it looking neat and tidy.

I was just going to try and add the last 10 product, i suppose if you obviously know what your doing you could add 2 tables side by side 1 with Newest products and one with Most Popular Products.

On to Nuke Royal !! i think it is an exellent add on to a site, and a very powerfull add on at that, in my experiance it can be a tricky install and now that there support forums have gone, which was a great place to find the fixes i think some one with a little bit of knowlege could take over the project.

if you want admin to my site to see it working your more than welcome, in fact ive got it installed on another site also Wink

Site Admin Joined: Jul 18, 2005 Posts: 383

I think I might be able to do better than that.
This will display the last 10 listed downloads

Code:

global $admin, $prefix, $db,$bgcolor1,$bgcolor2,$sitename;
$a = 1;
$result2 =$db-> sql_query("select lid, title, hits,sale from ".$prefix."_royal_memberships_downloads_deluxe order by date DESC limit 0,10");
$content.="<td>";
while(list($lid3, $title3, $hits,$sale) =$db->sql_fetchrow($result2)){
$title4 = ereg_replace("_", " ", $title3);
if ($sale !=1){
$downloadlink="(".$hits." times downloaded)";
}
else{
$downloadlink="(".$hits." times sold)";
}
$content.=" $a: <img><a>$title4 </a>- <i>$downloadlink</i><br>";
$a++;
}

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

Nothing like a little "Block" code to bring us insight! Thanks Guardian!

By the way, if you did not care about including the core nuke downloads in the newsletter, you could almost replace the SQL (one for the stats and one for the digital goods downloads). This would be pretty simple to do... Wink

Site Admin Joined: Jul 18, 2005 Posts: 383

Agreed but I'm thinking here that although for personal use that would be reasonably easy and viable, if it were to make it into HNL it would require something like an if file_exists to check whether E-Solutions is installed before presenting the option to include the data in the newsletter.
I guess there may even be a way to (beyond me) to 'detect' whether a table exists first before offering the user selectable options when creating the newsletter to use the data from one table over another.

Yeah I cheated with quoting block code. I took one look at the many tables e-solution uses (it is designed to be as stand alone as possible) and though it would take me hours of checking all the properties, then I had a very large extra strong coffee and the light bulb came on Wink

I'll look into this some more as I'm hoping it might be popular.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

Actually, all you have to do is make a "select * from nuke_some_table". If you would never expect no rows, check the numrows. Or, you would even check the error return code from mySQL to see if there was a SQL error.

Raven does soemthing similar I think in his "Who is Where" block, because if the cache table does not exist, he creates it on the fly.

Newbie Joined: Jun 13, 2006 Posts: 40

Just being nosey !! Laughing

With regards to adding digital goods to the news letter, i can see from the home page that your currently testing a version for raven.

What do you think the time frame would be for adding this as an option (if you intend to) as i want to start spamming my goods Shocked

Ive had a play and it just looks that little bit to much code to me !!

I know you have had loads of mod requests so i dont mind being told to take a back seat on this one ..

Ped Wink

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

I have not mentioned Digital Goods on the home page at all, nor am I going to commit to supporting it in a future newsletter release. The reason is that Digital Goods itself is not even supporting its product from what I understand and so it makes me really "leary" doing anything with it. The HNL is incorporated into the pending release of RavenNuke. That is all.

What I was hoping to do in a future release is to make it easier for folks, such as yourself, to customize the HNL to add additional dynamic content, such as your DG stuff.

And, yes, I have a ton of enhancement requests on the plate, but no time to work them at the moment....

Regards,
Rob