[CLOSED] Failed to Get Sponsor Banner Info

Site Admin Joined: Jul 18, 2005 Posts: 387

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.

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

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.

Newbie Joined: Mar 11, 2008 Posts: 12

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

Site Admin Joined: Jul 18, 2005 Posts: 387

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

Newbie Joined: Mar 11, 2008 Posts: 12

i got _nsnba_banners

Site Admin Joined: Jul 18, 2005 Posts: 387

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

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

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

Newbie Joined: Mar 11, 2008 Posts: 12

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?

Newbie Joined: Mar 11, 2008 Posts: 12

heres a screenshot

http://lafiebre.ws/ppics/structure.JPEG

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

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.

Newbie Joined: Mar 11, 2008 Posts: 12

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

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

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