Montego Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic
Author Message
hyipnet
Newbie
Newbie



Joined: Aug 06, 2007
Posts: 7

PostPosted: Mon Aug 06, 2007 6:36 pm Reply with quote

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
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1399

PostPosted: Mon Aug 06, 2007 8:19 pm Reply with quote

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
 
View user's profile Send private message Visit poster's website
hyipnet
Newbie
Newbie



Joined: Aug 06, 2007
Posts: 7

PostPosted: Mon Aug 06, 2007 10:24 pm Reply with quote

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
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1399

PostPosted: Tue Aug 07, 2007 8:19 am Reply with quote

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.
 
View user's profile Send private message Visit poster's website
hyipnet
Newbie
Newbie



Joined: Aug 06, 2007
Posts: 7

PostPosted: Tue Aug 07, 2007 9:50 am Reply with quote

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 ?
 
View user's profile Send private message
hyipnet
Newbie
Newbie



Joined: Aug 06, 2007
Posts: 7

PostPosted: Tue Aug 07, 2007 9:52 am Reply with quote

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 ?
 
View user's profile Send private message
hyipnet
Newbie
Newbie



Joined: Aug 06, 2007
Posts: 7

PostPosted: Tue Aug 07, 2007 10:02 am Reply with quote

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
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1399

PostPosted: Tue Aug 07, 2007 10:05 am Reply with quote

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.

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1399

PostPosted: Tue Aug 07, 2007 10:06 am Reply with quote

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
 
View user's profile Send private message Visit poster's website
hyipnet
Newbie
Newbie



Joined: Aug 06, 2007
Posts: 7

PostPosted: Tue Aug 07, 2007 10:10 am Reply with quote

i see thank you.
And what about the user activation ?
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1399

PostPosted: Tue Aug 07, 2007 10:12 am Reply with quote

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
 
View user's profile Send private message Visit poster's website
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1399

PostPosted: Tue Aug 07, 2007 10:33 am Reply with quote

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).

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
hyipnet
Newbie
Newbie



Joined: Aug 06, 2007
Posts: 7

PostPosted: Tue Aug 07, 2007 10:38 am Reply with quote

wahhh awesome,
Thank you so much.

Sincerely
 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 4 Hours
 
Forums ©
linear-bunch
linear-bunch