Where Is The Text Fron Text Ads Stored And How To Echo It ? Options

[simonj]

Hello!

Ok. I created a text ad, I search everywhere in the database and I can't find where the texte itself, the content of the ad, is stored... I see the storage type "txt", but I have no clue where it is...

Also, I need to do a trick... I want to echo only this text, the content of the text ad, via php...

I'm able to echo wathever I need from the ad with

CODE

<?php echo $phpAds_raw['whathever'];?>

... But I did'nt find how to output only the text from the ad.

If I use

CODE

<?php echo $phpAds_raw['html'];?>

, of course, the text appear on the browser side, but it also ouput the beacon stuff and all the info about the clientID, bannerID and such... All I want to echo is the content of the ad, straight.

Any Idea ?

Thanks

S.

[jasonstewart]

Hi simonj

Thank you for posting and making us aware of your problem.

Your post is very important to us. The support team will be able to respond soon, but in the meantime we would appreciate any reader of this topic who may know the answer to share their knowledge.

Thank you in advance for your patience,

Kindest regards,

[Arlen Coupland]

Hi,

The text is stored in the 'bannertext' field of the _banners table

The plain text is not returned by default in the array for LocalMode or XML-RPC -- you would need to edit the delivery file to include the 'bannertext' field in the returned array.

What about instead using an HTML banner with no <a> tag and no destination URL?

[simonj]

Many thanks Arlen

I modified the lib-view-main.inc.php and it works like a charm.

If anybody wonder how to echo only the banner text field

1) open lib-view-main.inc.php with a decent text editor.

2) at line 370 you will find the comment :"// Return banner" followed by :

CODE

return( array('html' => $outputbuffer,

3) then, just add the banner text field in the list:

CODE

'bannertext' => $row['bannertext']

You are done... You can now echo the 'bannertext' field with the tag :

CODE

<?php echo $phpAds_raw['bannertext'];?>

S.