ADD more option on the leates links on the htmlnewsletter

Newbie Joined: Aug 06, 2007 Posts: 7

hello
I want to add more features on the newsletters :

the origine script on the file is modules/htmlnewsletter/admin/admin_make_nls.php:

And i want to change it to show that values :

Line 387:

Code:

if ( $_POST['msnl_weblinks'] > 0 && $msnl_sTemplateNm != "notemplate" ) {

$i             = 0;
$msnl_sRows = "";

$sql          = "SELECT `lid`, a.`cid` as cid, a.`title` as ltitle, b.`title` as ctitle, `hits` FROM `"
                  . $prefix."_links_links` a, `"
                  . $prefix."_links_categories` b "
                  . "WHERE a.`cid` = b.`cid` "
                  . "ORDER BY `lid` DESC LIMIT 0, ". $_POST['msnl_weblinks'];

to :

Code:

if ( $_POST['msnl_weblinks'] > 0 && $msnl_sTemplateNm != "notemplate" ) {

$i             = 0;
$msnl_sRows = "";
/*lid cid sid title url image min_invest max_invest interest_rate adminvest feedback forum description status star date name email hits submitter linkratingsummary egold intgold ebullion stormpay goldmoney precunix moneybook bankwire evo paypal netpay totalvotes totalcomments */

$sql          = "SELECT `lid`, a.`cid` as cid, a.`title` as ltitle, b.`title` as ctitle, `min_invest`, `max_invest`, `interest_rate`, `adminvest`, `status`, `star`, `linkratingsummary`, `totalvotes`, `totalcomments`, `hits` FROM `"
                  . $prefix."_links_links` a, `"
                  . $prefix."_links_categories` b "
                  . "WHERE a.`cid` = b.`cid` "
                  . "ORDER BY `lid` DESC LIMIT 0, ". $_POST['msnl_weblinks'];

$result13 = msnl_fSQLCall( $sql );

if ( !$result13 ) { //Bad SQL call

etc

But i can not.
Can i have some help to have a perfect newsletter please ?
Regards
JEan

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

Can you please explain to me in words what it is you are trying to add? I am having trouble understanding what it is you are trying to do.

Thank you,
montego

Newbie Joined: Aug 06, 2007 Posts: 7

Well as you know the html newsletter allow you to send the "XX" leatest links added into the database.

That's mean : the links title + the total hits.
I want that my html newsletter show more than that :
exp :
i need all of those value :

$sql = "SELECT `lid`, a.`cid` as cid, a.`title` as ltitle, b.`title` as ctitle, `min_invest`, `max_invest`, `interest_rate`, `adminvest`, `status`, `star`, `linkratingsummary`, `totalvotes`, `totalcomments`, `hits` FROM `"
. $prefix."_links_links`

but for the rest i don't know where to modify the rest of the script fonctions to show the total infos about links added into my database .
Please visit hyip.net to see more detail.

Regards

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

Oh, I see. Well, I do not recognize some of the links fields that you are referring to, but will just assume they are there in your installation and that the SQL statement that you have fashioned is correct.

Here are the files that you will have to modify (use existing code as examples):

1. admin_make_nls.php - not only do you have to add to the SQL statement, but you must also have corresponding $msnl_sRowTmp = str_replace() rows for each new field.

2. template.php (I will assume you are using Fancy_Template) - you need to add the appropriate HTML and {} tags to replace within the $latestweblinkrow variable assignment.

That should be all that is necessary.

Newbie Joined: Aug 06, 2007 Posts: 7

Done, thank you so much for your help.
Now my news letter is very hansom.

Can you please help me for another think.
I use phpnuke 8.03 or 8.3.

And in my users registration form i have something that i need to upgrade.

I want that my users when they register, will not need to receive an activation mail to activate their login.

Can you please tell me how to upgrade my registration form, like that users can activate their new account directly on my website withour receiving a mail ?

Newbie Joined: Aug 06, 2007 Posts: 7

I mean when i register on your site, the final registration step is the account activation :

IT show :

New User Registration: Final Step

hyipnet2, please check the following information. If all is correct you can proceed with the registration by clicking on 'Finish' button, otherwise 'Go Back' and change whatever information is needed.

User Name: hyipnet2
Email: hyip.net@gmail.com

Note: You will receive a confirmation email with a link to a page you should visit to activate your account in the next 24 hours.

Please tell me how to put this registration form on my program or how can i upgrade my site ?

Newbie Joined: Aug 06, 2007 Posts: 7

i have a little more problem :

Create Newsletter - Send Mail

ERROR IN MODULE: HTML_Newsletter

ERROR MSG: PHP mail function failed - was unable to send newsletter to: admin@hyip.net

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

This is a separate issue and therefore should be asked in a separate thread. I would also suggest asking this instead over at Raven's site as there are more people there who use 8.0 version of PHP-Nuke. I refuse to use anything but RavenNuke for security / bug reasons.

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

hyipnet wrote:

i have a little more problem :

Create Newsletter - Send Mail

ERROR IN MODULE: HTML_Newsletter

ERROR MSG: PHP mail function failed - was unable to send newsletter to: admin@hyip.net

Sorry, we posted about the same time. This is an issue with your host and the mail() function. You should ask them why this is failing.

Unfortunately, if they come back and say that they have disable the mail() PHP function, I don't have time to make this work under SMTP. Sad

Newbie Joined: Aug 06, 2007 Posts: 7

i see thank you.
And what about the user activation ?

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

hyipnet wrote:

i see thank you.
And what about the user activation ?

This is the "separate issue" that I was referring to above. If you ask that over at Raven's site, you will have a better chance for a response related to YOUR PHP-Nuke version.

Regards,
montego

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

Well, here I go breaking my own "rules". You might want to check out the Approved Membership Module from Ken Arnold.

I have written a "Lite" version of this, but it is ONLY for RavenNuke. You might want to give his a try as there is also an Auto-Activation link option which would get around any issues with mail() function not working for your new user registrations (which I suspect it will be a problem given your issues above with the newsletter send).

Newbie Joined: Aug 06, 2007 Posts: 7

wahhh awesome,
Thank you so much.

Sincerely