Montego Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic
Author Message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Sun Oct 18, 2009 4:26 pm Reply with quote

You could use phpMyAdmin or whatever database management tool your hosting providers allows you access to copy the existing table and use that to create a new one with the right name, however you should keep in mind that you will be stuck with whatever is in that table as there is no way to change the data from within Platinum.

Have you not considered migrating to RavenNuke (tm)? It doesn't have a ton of forum mods like I think Platinum has but it does have HTML Newsletter built in, along with Nuke Sentinel and since the last release (v2.4) some fantastic stuff gear toward search engine optimisation.
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1391

PostPosted: Tue Oct 20, 2009 7:47 pm Reply with quote

I did not have to change the code in order for this to work on RavenNuke(tm)'s Advertising module which is from 7.8 or 7.9 (can't recall). This one table and the fields I reference were not changed I don't believe, otherwise I would have had to make another release to the HNL with logic to check nuke "flavor" and version.

What your error suggests to me is that your install of NukePlatinum was not complete (possibly). Since I don't support NukePlatinum, I am not sure what they are using for their banner system.

What you could do is look for anywhere in the HNL script files for the text "_banner" and that will give you the lines of code where some form of db access against this table is being set up.

_________________
“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
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Tue Oct 20, 2009 11:11 pm Reply with quote

my site started with nuke 7.9 i had html newsletter working, then i migrated to platinum, too much work, i lost my forum, i had to tweak the users database to not loosing it. im not ready to migrate again lol
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Wed Oct 21, 2009 3:12 am Reply with quote

I think the first thing to do here is make sure you have a table, even if it's the wrong one so check using phpMyAdmin whether you have _banner or bannerss
 
View user's profile Send private message
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Thu Oct 22, 2009 11:35 am Reply with quote

i got _nsnba_banners
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Thu Oct 22, 2009 11:54 am Reply with quote

Ah, I see.
Seems like Platinum is using a third party banners module called NSN Banner Ads from nukescripts.net which is definitely not supported by HTML Newsletter.
I think your only option now is to locate those bits of code Montego pointed out and change them to suit your table (hopefully the fields within the table are similar enough).
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1391

PostPosted: Thu Oct 22, 2009 12:07 pm Reply with quote

erecpr18,
If you post the structure of this table here, we can try to help you further.

_________________
“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
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Thu Oct 22, 2009 12:22 pm Reply with quote

Type Collation Attributes Null Default Extra Action
bid int(11) No auto_increment
cid int(11) No 0
pid tinyint(1) No 0
imptotal int(11) No 0
impmade int(11) No 0
clicks int(11) No 0
imageurl varchar(200) latin1_swedish_ci No
clickurl varchar(200) latin1_swedish_ci No
alttext varchar(255) latin1_swedish_ci No
code tinyint(1) No 0
flash tinyint(1) No 0
height int(4) No 60
width int(4) No 468
datestr date No 0000-00-00
dateend date No 0000-00-00
active tinyint(1) No 1


is this good enough?
 
View user's profile Send private message
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Thu Oct 22, 2009 12:31 pm Reply with quote

heres a screenshot

http://lafiebre.ws/ppics/structure.JPEG
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1391

PostPosted: Thu Oct 22, 2009 1:54 pm Reply with quote

Here are the scripts and line(s) where you need to change the code instances of _banner with _nsnba_banners:

admin.php:

Code:

$sql         = "SELECT `bid`, `imageurl`, `clickurl`, `alttext` FROM `"
               .$prefix."_banner` WHERE `imageurl`!='' AND `imageurl`!='http://'";


admin_make_nls.php:

Code:

   $sql   = "SELECT `imageurl`, `clickurl`, `alttext` FROM `"
            . $prefix."_banner` WHERE `bid` = '". $_POST['msnl_banner'] ."'";


That should be all that you need to do! Not bad.

_________________
“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
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Thu Oct 22, 2009 2:49 pm Reply with quote

It works!! see now HTML Newsletter is compatible with Platinum 7.6.b.4 Thank you guys. As soon as i get some money ill send a donation, i just have $3 in my account lol
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1391

PostPosted: Thu Oct 22, 2009 5:44 pm Reply with quote

Hey, great to hear it is working. Thank you for sticking with the discovery process. I appreciate any and all donations. Thanks!

_________________
“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
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-bunchlinear-bunch
linear-bunch