PDA

View Full Version : phpAdsNew Banner Ads integration (advertisements, classified ads, Adsense, etc.)


Pages : [1] 2 3

The M.I.P.
11-05-2005, 10:00 PM
OpenAds / phpAdsNew Integration 1.0.4 for vBulletin 3.[56].x
2006-06-08 by mip

Integrates the OpenAds (http://www.openads.org/) / phpAdsNew (http://www.phpadsnew.com/) ads system by introducing a new template tag <ad ... />.
You can even deliver your Adsense stuff via phpAdsNew using HTML banners.

The features of phpAdsNew combined with the power of vBulletin's templating system gives you the possibility to place ads for specific user groups, forums, and keywords.

PREREQUISITES:
This plugin requires a working installation (local or remote) of a recent version ofOpenAds (http://www.openads.org/) / phpAdsNew (http://www.phpadsnew.com/) (free software released under the GPL).
When using OpenAds, replace phpAdsNew in this documentation with OpenAds (phpAdsNew is just the predecessor of OpenAds).

INSTALLATION:
When having a previous version of this product installed, see section UPGRADE instead.

Install product "phpadsnew-1.0.4.xml".
Set phpAdsNew path in Server Settings and Optimization Options to point to either your local phpAdsNew installation or a remote server (using XML-RPC).
It is strongly recommended to set $phpAds_config['compatibility_mode'] = true; in phpAdsNew config file, to prevent problems when phpAdsNew uses a database different from the one used by your vBulletin board.

When using XML-RPC, make sure to have lib-xmlrpc-class.inc.php and lib-xmlrpc.inc.php copied from phpAdsNew misc/samples/xmlrpc/php/ to your forum's includes/ directory (not necessary when using a local phpAdsNew installation).

Read the NOTES section below.

Click INSTALL (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=100229) in this thread to mark product as "installed" and receive notifications when a new version comes out.

UPGRADE:

1.0.3 --> 1.0.4
Import product as usual, with "Allow Overwrite" set to Yes.
1.0.2 --> 1.0.3
Upgrading is recommended, as this is a bugfix release.
Import product as usual, with "Allow Overwrite" set to Yes.
Recompile any templates where you experienced problems with the <ad .../> tag (notably those where this tag is used repeatedly on a line).

1.0.1 --> 1.0.2
Import product as usual, with "Allow Overwrite" set to Yes.
Set $phpAds_config['compatibility_mode'] = true; in phpAdsNew config file.

1.0 --> 1.0.1
There's basically no need to upgrade, as the changes don't affect a working installation, but I recommend to do so, to ease possible upgrades in the future.
Import product as usual, with "Allow Overwrite" set to Yes.
Alter the path to phpAdsNew in vBulletin Server Settings and Optimization Options to point to your phpAdsNew installation.
As opposed to version 1.0 of this product, a local path is not relative to the DOCUMENT_ROOT.

USAGE:
Use the newly introduced <ad ... /> tag in your templates.
The syntax is similar to phpAdsNew's view_raw() function call - the tag understands what, clientid, target, source, and withtext as arguments.

Please make yourself familiar with phpAdsNew prior to using this product. You can't expect this product to work, if you didn't check if your phpAdsNew is delivering your banners cleanly.

Examples:
Get banner using keywords:
<ad what="foo|bar" />
Get banner for guest usergroup (in this case, "ug1" must be set as a keyword in phpADsNew, see 2nd screenshot):
<ad what="ug$bbuserinfo['usergroupid']" />
(same technique can be applied to deliver forum-specific ads)
Similar invocation using template conditionals:
<if condition="$bbuserinfo['usergroupid']==1"><ad what="" /></if>


NOTES:
Always use the latest stable version of phpAdsNew (http://phpadsnew.com/).
Old versions had bugs and some even had severe security issues - I'll give no support for installations with an outdated phpAdsNew.
At the time of writing, latest version is 2.0.8.
Templates which make use of the ad-tag might need to get recompiled after product change.
Recommendations for heavy-duty servers: Move the plugin code to files; try to avoid using xml-rpc or cache xml-rpc requests (e.g. with memcache).
Have an eye on current phpAdsNew security issues (http://secunia.com/search/?search=phpadsnew)
This product comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law.
Support is provided at will.
Don't expect help if you haven't read instructions or phpAdsNew manual, if you're using non-standard vBulletin software or if your problem descriptions are useless.

PS:
This plugin is donationware - it helps you to make some money, so please be fair and honor my work with an adequate pecuniary donation.
https://vborg.vbsupport.ru/ Donate via Paypal (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=the_mip%40gmx%2efr&item_name=phpAdsNew%20Banner%20Ads%20integration%2 0for%20vBulletin%203%2e5%2ex&item_number=phpadsnew10&no_shipping=1&return=http%3A%2F%2Fwww.vbulletin.org%2Fforum%2Fsh owthread.php?t%3D100229&cancel_return=http%3A%2F%2Fwww.vbulletin.org%2Ffor um%2Fshowthread.php?t%3D100229&no_note=1&tax=0&cn=vBulletin%2eorg%20nickname%20%28opt%2e%29&currency_code=EUR&bn=PP%2dDonationsBF&charset=UTF%2d8)

Snake
11-06-2005, 05:02 PM
This is great! Thank you!

michaelbenson
11-06-2005, 05:28 PM
Shouldnt you attach the download file?
Looks good though.

reteep
11-06-2005, 06:03 PM
Sounds very nice!

romow
11-06-2005, 06:25 PM
Thanks for the mod. will try it out later.

lexx27
11-06-2005, 09:22 PM
This is similar to something that i want. I want the users avatar to be placed at the header of the site!!!

The M.I.P.
11-06-2005, 09:45 PM
This is similar to something that i want. I want the users avatar to be placed at the header of the site!!!This is not what you're looking for.
Have a look at https://vborg.vbsupport.ru/showthread.php?t=100254 instead.

jugo
11-06-2005, 11:11 PM
Two excellent hacks in one day...Big Ups to you!!!

lexx27
11-07-2005, 12:50 AM
This is not what you're looking for.
Have a look at https://vborg.vbsupport.ru/showthread.php?t=100254 instead.
Thank you very much!

tamarian
11-07-2005, 01:12 AM
Well done :up:

LincolnForums
11-07-2005, 04:18 AM
its hard to download that xml file using Firefox.

any chance of getting a zipped package?

The M.I.P.
11-07-2005, 05:09 AM
its hard to download that xml file using Firefox.
any chance of getting a zipped package?For your convenience, MIME-type of phpadsnew-1.0.xml (http://prao.mine.nu/tmp/phpadsnew-1.0.xml) is now set to application/octet-stream which should make your browser ask to save the file instead of open it.

BTW:
There's also a "save as" dialogue in the context menu of your browser.

dreck
11-07-2005, 12:04 PM
sweet.. I just install phpAdsNew just the other day.
This will definally come in handy.

Now I just have to figure out how to use it. ;)

/install

LincolnForums
11-07-2005, 09:04 PM
For your convenience, MIME-type of phpadsnew-1.0.xml (http://prao.mine.nu/tmp/phpadsnew-1.0.xml) is now set to application/octet-stream which should make your browser ask to save the file instead of open it.

BTW:
There's also a "save as" dialogue in the context menu of your browser.

thank you very much

tamborinegal
11-08-2005, 02:07 AM
This looks like just what I need, but can I place an ad anywhere else or only in the header template? I'd love it if I could use it after the first post in a thread for example.

Thanks :)

jimporter
11-08-2005, 09:41 AM
This looks like just what I need, but can I place an ad anywhere else or only in the header template? I'd love it if I could use it after the first post in a thread for example.

Thanks :)

Tamborinegal, see this post How To Show A Banner After The First Post In A Thread (http://www.vbulletin.com/forum/showthread.php?t=157022) and amend accordingly.

Milez
11-08-2005, 11:05 AM
Testing this on a busy board. Problem is my ads will not display and since they display normally on non vbulletin pages I am assuming it is the setting in the admincp for the path to PAN. Since my PAN install is outside of the vbb document root the setting does not seem to work: /web/adserve. I have tried ../web/adserve and no go either.

Anyone run into this?

What a shame. I really do not want to guinea pig the XML-RPC method.

The M.I.P.
11-08-2005, 12:03 PM
This looks like just what I need, but can I place an ad anywhere else or only in the header template? I'd love it if I could use it after the first post in a thread for example.You can use the <ad ... /> tags anywhere in your templates. When using multiple <ad ... /> tags on a page, you should define an own zone for each ad in phpAdsNew - see the phpAdsNew user guide (http://phpadsnew.com/manual/user-guide.pdf) for more infos.

Milez
11-08-2005, 12:55 PM
Strange still no go. I used a relative path like /web/adserve. I added a banner in my header template like: <ad what="zone:2" />

Q: Have you tested this for anything beyond .html banners I see you are using above? My banners are all images but I did not think that would make a difference.

Milez
11-08-2005, 02:03 PM
Sorry...Banners are displaying now.

My issue now is that the options for the <ad> tags are not bringing up the right zones. <ad what="zone:2" /> is a rotating 468x60 banner with a few image banners but other unrelated banners are being displayed for some reason. I tried targetting specific banners with clientid="x" as well but no dice.

From looking at your code this really should be working.

Milez
11-08-2005, 02:12 PM
Very sorry. I had an issue with PAN.

This script works fantabulous and I have been waiting for some time for it. Until recently I was only able to get ads to appear with the Javascript invoking method which slows most busy VB boards to a crawl. Hopefully by invoking with PHP this is MUCH faster.

Thumbs up to the new plugin system in VB3.5 and thanks to the author of this mod. I suggest anyone using PAN & VB check this out.

Corriewf
11-08-2005, 03:49 PM
Too bad there is a bug in the newest version of php which prevents logging into this.....

LincolnForums
11-08-2005, 03:53 PM
i keep getting this error.

Warning: in_array(): Wrong datatype for second argument in /includes/lib-xmlrpc.inc.php on line 571

I copied both the lib- files to my includes directory

The M.I.P.
11-08-2005, 04:20 PM
i keep getting this error.

Warning: in_array(): Wrong datatype for second argument in /includes/lib-xmlrpc.inc.php on line 571Did you add global $xmlrpc_valid_parents; to line 76 of lib-xmlrpc.inc.php as told in the "NOTES" section of my first post?

tamborinegal
11-09-2005, 04:13 AM
You can use the <ad ... /> tags anywhere in your templates. When using multiple <ad ... /> tags on a page, you should define an own zone for each ad in phpAdsNew - see the phpAdsNew user guide (http://phpadsnew.com/manual/user-guide.pdf) for more infos.

Thanks, will definately be trying this out in the next couple of days. Looks great. Will let you know how it goes.

Cheers :)

Milez
11-09-2005, 05:43 AM
Too bad there is a bug in the newest version of php which prevents logging into this.....

Referring to PAN I assume. I found this to be true on Windows boxes but not *nix.

The M.I.P.
11-09-2005, 12:01 PM
There's a preliminary phpAdsNew 2.0.7 (http://forum.phpadsnew.com/index.php?showtopic=9493) version as a workaround for the PHP 4.4.1 bug (http://bugs.php.net/bug.php?id=35067).

lsgworldl
11-09-2005, 09:18 PM
this is how I have it set up, cant get it to work

Header

<!-- logo -->
<a name="top"></a>
<table border="0" width="$stylevar[outertablewidth]" cellpadding="0" cellspacing="0" align="center">
<tr>
<td align="$stylevar[left]"><a href="$vboptions[forumhome].php$session[sessionurl_q]"><img src="$stylevar[titleimage]" border="0" alt="$vboptions[bbtitle]" /></a></td>
<td align="$stylevar[right]">
<ad what="zone:1" />
</td>
</tr>
</table>
<!-- /logo -->

<!-- content table -->
$spacer_open

$_phpinclude_output

path to adsnew

/home/lsgworld/public_html/adsnew

code from adsnew

<?php
if (@include(getenv('DOCUMENT_ROOT').'/adsnew/phpadsnew.inc.php')) {
if (!isset($phpAds_context)) $phpAds_context = array();
$phpAds_raw = view_raw ('zone:1', 0, '', '', '0', $phpAds_context);
echo $phpAds_raw['html'];
}
?>

The M.I.P.
11-10-2005, 03:53 AM
path to adsnew

/home/lsgworld/public_html/adsnewHow did you specify the path to phpAdsNew in vBulletin's Server Settings and Optimization Options?
The correct setting seems to be /adsnew in your case.

Please also make sure that phpAdsNew is set up correctly and working smoothly to be able to narrow down the origin of possible problems.

lsgworldl
11-10-2005, 01:18 PM
How did you specify the path to phpAdsNew in vBulletin's Server Settings and Optimization Options?
The correct setting seems to be /adsnew in your case.

Location of phpAdsNew = /home/lsgworld/public_html/adsnew :bunny:

If your local phpAdsNew installation is outside the DOCUMENT_ROOT of vBulletin forum, see point e) from the NOTES section of my first post.

I dont knolw what that means??? what is the DOCUMENT_ROOT??? :alien:

Please also make sure that phpAdsNew is set up correctly and working smoothly to be able to narrow down the origin of possible problems

phpAdsNew was set up ising fantastico, so yes it is set up correct :banana:

The M.I.P.
11-10-2005, 04:00 PM
@lsgworldl
Please use new version 1.0.1. This should solve the confusion concerning paths.

scottct1
11-14-2005, 06:03 PM
How do I set this up so that in each forum there is a different zone shown?

Some of my forums are sponsored and in those forums I want only those ads shown, and in the unsponsored areas I want another zone shown.

Thanks.

The M.I.P.
11-15-2005, 04:24 AM
How do I set this up so that in each forum there is a different zone shown?

Some of my forums are sponsored and in those forums I want only those ads shown, and in the unsponsored areas I want another zone shown.You do this by either using banner keywords as shown in my fourth example or you set the zones explicitly with template conditionals like I have shown in my fifth example:
<if condition="$foruminfo['forumid']==123 OR $foruminfo['forumid']==456">
<ad what="zone:1" />
<else />
<ad what="zone:2" />
</if>


Another possibility is the use of phpAdsNew client-ids:
<if condition="$foruminfo['forumid']==123 OR $foruminfo['forumid']==456">
<ad clientid="1" />
<else />
<ad clientid="2" />
</if>
You can also mix client-id with keywords, zone names, etc. - see your phpAdsNew manual for info. The ad-tag works similiar to the view_raw() function of phpAdsNew.

salsabil
11-15-2005, 05:12 AM
Hi,

I'm trying to get to this work but nothing is showing up unfortunately.

I tested out phpadnews on a .php page to make sure that was functioning and it was.

I'm wondering if I've set the path wrong. My path I put was ../banners/ but the full path is /home/aussie/public_html/forums/banners/

Thankyou!

The M.I.P.
11-15-2005, 05:19 AM
I'm wondering if I've set the path wrong. My path I put was ../banners/ but the full path is /home/aussie/public_html/forums/banners/ The base directory for inclusion is your forum's directory, so in your case, the correct path would be "./banners". You can also specify the full path.

(Your "../banners" would point to "/home/aussie/public_html/forums/../banners" which translates to "/home/aussie/public_html/banners/")

salsabil
11-15-2005, 05:30 AM
Ah great! :) It's working now. Amazing how much of a difference a . can make!

Thanks so much for the great plugin.

tassoman
11-15-2005, 11:31 AM
Hi!
I'm still trying to get plugin working outside forum root, cause I want to manage ads also into another 3rd level domain, for now called www.

While I ask forum pages, all runs ok. Ads are called from forum.dmn.tld/adv subdir.
If i ask vbadvanced homepage into www, banners images (and links) are broken, cause theire called from www.dmn.tld/adv

I've tried to edit "Replacements" adding adlog.php, adimage.php, adclick.php for vba in admincp, but seems not works.
The /adv directory shown into templates still the same of domain where page was called.

The M.I.P.
11-15-2005, 12:30 PM
@tassoman:
First try to set the full path to phpAdsNew (instead of a relative one) in the settings of this product, to be sure that inclusion of phpadsnew.inc.php also works, when you're using the templating system in scripts outside of the forum's installation directory.
Also check if your $phpAds_config['url_prefix'] setting in phpAdsNew's config.inc.php is a valid absolute URL (e.g. http://example.com/phpadsnew/).

If this doesn't solve your problems, please be more precise and also post a link to your site (or show relevant parts of code (notably the HTML between <!-- BEGIN/END ad ...--> comments) and screenshots).

tassoman
11-15-2005, 11:37 PM
Both fields are ok. in admincp there's full path from root to phpadsnew dir.
On config.inc.php there's full URI for phpadsnew.

My filesystem is like this:
/ (ftproot)
www
htdocs

forum
htdocs
adv


on forum.dmn.tld is called /adv and it's ok.
on www.dmn.tld is called also /adv but there isnt' any dir here.

So I solved for now with a symlink called /adv but I feel like a dirty hack.

Brad
11-18-2005, 10:06 PM
Please upload the files to our server as attachments. As stated in the forum rules.

Thank you. :)

Mythotical
11-19-2005, 12:07 AM
Hi,

I am having problems seriously. I don't understand this whole setting up of a banner rotation. I have followed each image and still nothing, I have changed from relative to absolute path, I have followed all suggestions and still nothing. Help please.

http://www.vbrenegades.com/vbr.php it should be showing up aligned to the right.

Thanks
Myth

Erox
11-19-2005, 12:54 AM
Beee-yoo-ti-ful!
I had my own makeshift banner ad server (that no longer works in 3.5), this is just what the doctor ordered. Thanks!

dutchbb
11-19-2005, 08:58 AM
Thank you for this plugin.

Can you help me out with a error message? I get this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xch1295/domains/dutchbodybuilding.com/public_html/gallery/photopostpal.php on line 71
This is on line 71:
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

photopostpal is a script that shows thumbnails from photopostgallery on my forumhome...

My board: http://forum.dutchbodybuilding.com/

The M.I.P.
11-19-2005, 11:03 AM
I am having problems seriously. I don't understand this whole setting up of a banner rotation. I have followed each image and still nothing, I have changed from relative to absolute path, I have followed all suggestions and still nothing. Help please.

http://www.vbrenegades.com/vbr.php it should be showing up aligned to the right.Your script doesn't seem to call the view_ad function plugin, which resides on hook init_startup.
Make sure the plugin is enabled and the hook exists in you script.
As your script isn't part of original vBulletin, I can't give further free support.

Can you help me out with a error message? I get this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xch1295/domains/dutchbodybuilding.com/public_html/gallery/photopostpal.php on line 71
This is on line 71:
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {photopostpal.php isn't part of original vBulletin - contact the author of this script for support.
Check the SQL query some lines before ($result=...), the problem seems to start there.

@Third party developers:
If using this product in your scripts, make sure the init_startup hook exists (required for the calls to the view_ad function plugin).

dutchbb
11-20-2005, 07:43 AM
photopostpal.php isn't part of original vBulletin - contact the author of this script for support.
Check the SQL query some lines before ($result=...), the problem seems to start there.

@Third party developers:
If using this product in your scripts, make sure the init_startup hook exists (required for the calls to the view_ad function plugin).
I understand but photopost says the same "we can't help because you're using a hack" :(

Maybe you can help, this is before/after the problem lines in the file:
$resultb = mysql_query("SELECT id,ugnoview FROM {$pp_db_prefix}categories");
$ViewPerm = array();
while ( list( $catugid, $ugnoview ) = mysql_fetch_row($resultb) ) {
$noview=0; $ViewPerm[$catugid] = 1;

$query = "SELECT p.id,p.user,p.userid,p.cat,p.bigimage,p.height,p.w idth,c.catname,c.photos,c.posts
FROM {$pp_db_prefix}photos p
LEFT JOIN {$pp_db_prefix}categories c ON c.id = p.cat
WHERE c.cattype = 'c' AND p.cat != 500 AND p.storecat = 0
ORDER BY RAND()";
}
$result = mysql_query($query);

$counted = 0; $countcol = 0; $featured = "";

while (list($pid,$puser,$puserid,$pcat,$photo,$height,$w idth,$catname,$cphotos,$cposts) = mysql_fetch_row($result)) {

if ( $ViewPerm[$pcat] == 1 ) continue;


Any clue?

The M.I.P.
11-20-2005, 02:06 PM
@Triple_T:
I can't see any interrelation of your problem with this phpAdsnew integration.
Nevertheless, your cited code above doesn't show the line where variable $result is assigned (there's only a similar $resultb variable), so the context of the problem is not clear. As Photopost is closed source and I don't have access to it, I can't look for it by myself.

I really doubt, that your problem has anything to do with this phpAdsNew plugin.
To be sure that this is no problem of this product, uninstall phpAdsNew integration completely and don't forget to remove the <ad .. /> tag from your templates.

dutchbb
11-20-2005, 02:47 PM
When I remove the <ad /> tag , the problem is gone so it has something to do with it.
The phpadsnew javascript code I normally use doesn't cause the error to show.

Photopost says the hack conflicts with the PP script in some way

Attached is the complete PP script file, can you take a look please?
Thanks!

Sleazy
11-21-2005, 03:57 PM
I got the <ad /> tag to display all the banners in my inventory, but using any sort of variable such like zones, client id, etc doesn't work so I can't specify certain ads to display.

The code I am using is:
<ad what="zone:1" />

Anyone else having this problem?

Sidewindr
11-22-2005, 04:20 AM
I can only get the xml display working (which I don't want to use) and the absolute path for direct invocation to my phpAdsNew causes the site to fail.

I cannot use XML as the resulting CPU load kills the forums.

It also appears that only the first argument after <ad is noticed..

For instance

<ad what="zone:4" clientid="6" \> returns random banners from zone:4

however

<ad clientid="6" \> returns the banner for client 6 every time.

kafi
11-26-2005, 08:18 PM
I would like to use left column on my forumhome in which I want to place small banners.

I am using phpadsnew for banners delivery with this integration hack (works good for me ). I am using tag system in templates:
<ad what="zone:8" />

Since currently I have 4 small banners next to each other vertically I am not worried about their place, because it's quite equal.
Once i will move them to column some of the advertiser might be upset about vertical position of his banner ...1st 2nd 3rd from the top.

Is there a trick that will randomly switch these banner's position at refresh?

Thank you!

StarShaper
11-29-2005, 01:16 AM
Works great! Thx, and greetings to all gulli members ;)

GrBear
11-29-2005, 03:36 AM
This rocks! Thank you for your contribution!

*clicks installed*

Yorixz
11-29-2005, 04:16 AM
I'm very glad with this, just one question; is it possible to let phpAdsNew show adsense when theres no other banner available/can't connect to the db? It's possible to show an image but I guess there could be another option around aswell.

Thanks!

klaush
11-29-2005, 05:40 AM
Thanks for this!

Installed....

Great job!

dutchbb
11-29-2005, 08:17 AM
In inc_features.php, there's no DB resource identifier used when accessing the database. In this case, PHP uses the last DB link which normally is vBulletin's database, but when using phpAdsNew integration, this might be the phpAdsNew database.

Solutions (untested, as I don't have access to Photopost):
Use a separate DB connection for the Photopost stuff as mentioned in the comments in inc_features.php.
Or add vBulletin's DB resource identifier to the mysql queries:--- inc_features.php.orig Mon Nov 21 11:54:09 2005
+++ inc_features.php Mon Nov 21 11:56:21 2005
@@ -49,7 +49,7 @@
}
$grouparr = explode( ",", $mygroups );

- $resultb = mysql_query("SELECT id,ugnoview FROM {$pp_db_prefix}categories");
+ $resultb = mysql_query("SELECT id,ugnoview FROM {$pp_db_prefix}categories", $db->link);
$ViewPerm = array();
while ( list( $catugid, $ugnoview ) = mysql_fetch_row($resultb) ) {
$noview=0; $ViewPerm[$catugid] = 1;
@@ -112,7 +112,7 @@
WHERE c.cattype = 'c' AND p.cat != 500 AND p.storecat = 0
ORDER BY RAND()";
}
-$result = mysql_query($query);
+$result = mysql_query($query, $db->link);

$counted = 0; $countcol = 0; $featured = "";


Thank you

I get this when I replace/add that code:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/xch1295/domains/mydomain.com/public_html/gallery/inc_features.php on line 51

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xch1295/domains/mydomain.com/public_html/gallery/inc_features.php on line 53

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/xch1295/domains/mydomain.com/public_html/gallery/inc_features.php on line 114

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xch1295/domains/mydomain.com/public_html/gallery/inc_features.php on line 118

Skyline_GT
11-30-2005, 06:30 AM
the if statment for usergroup doesn't work...

Xstreamist
12-01-2005, 10:43 PM
OK.... I'm lost and pulling my hair out...
I installed phpAdsNew.. followed the admin manual to the tee for installation and the usermanual to the tee for set up... Installed the .xml which is posted here. Now I'm totally confused as to what to do...

I tried copying the invocation code to where I wanted the ads to appear, under my logo, and got sql errors. then tried just putting
<td align="center">
<ad what="zone:1" />
</td>

Where I want the banners to show and no go...

How do I use this? Am I supposed to copy the invocation code to a file somewhere? I don't see any instructions anywhere that say this.
I'm totally new to vBulleitin by the way but have been learning a lot in the past two weeks I have been using it. It's just this thing that's totally stumped me.
Thanks in advance for any assistance.

Xstreamist
12-02-2005, 02:41 AM
OK finally got this to show the banner... But... notice I didn't say bannerS... It won't rotate the banners.. it shows the same one all the time...
Anyone know how I could fix this?

Also, any idea how I get the banners to show up on every page?

toxin
12-02-2005, 01:03 PM
I'm pulling my hair out over this..

I've been running PAN successfully for ages, integrated into 3.0.7, but a couple of days ago I upgraded to vB 3.5.1 and moved to a new server..

I know PAN is working because i can invoke the banners manually or through my own php scripts, but vB isn't having any of it.

There are no errors, no banners.. no nothing.. its all a bit strange.

This is part of my header template:

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%"><a href="/?$session[sessionurl]"><img src="$stylevar[titleimage]" border="0" alt="$vboptions[bbtitle]" /></a></td>
<td width="50%"><div align="center">xxx<ad what="zone:1" />yyy</div></td>
</tr>
</table>

so this should show a banner, with text "xxx" before and "yyy" after. But when I view source on the forum webpage, i see this:

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="50%"><a href="/?"><img src="/forums/images/misc/vbulletin3_logo_winter.gif" border="0" alt="Community Home Page" /></a></td>
<td width="50%"><div align="center">xxx
</tr>
</table>

notice that everything after xxx has vanished... ie, no banner and no "yyy"

Does anyone have any ideas of something that I can try, or where to start debugging?

dutchbb
12-02-2005, 02:53 PM
Can you give some support on my question The M.I.P. ???

I'll be happy to donate if you can make it work for me. Not having java code in my forum sourcecode with the variable provided in this hack would be a good thing!

The M.I.P.
12-03-2005, 04:38 AM
@Triple_T:
I'll have a look at it. Meanwhile, please use a separate DB connection as told in the comments in your inc_feeatures.php file.

@Xstreamist:
If your banner's don't rotate, please first check your phpadsnew setup - it might fall back into displaying a default ad when setup is not correct.
If you're sure that it's not directly related to phpadsnew, then switch vbulletin into debug mode or enable the display of template names in HTML and tell me exactly what is displayed between BEGIN ad and END ad HTML comments.
Also make sure that your browser doesn't cache your banners during your test phase.

@toxin:
It looks like the plugin isn't able to include the phpadsnew code. Please check if the path to you phpadsnew installation is set correctly and phpadsnew works cleanly outside of vbulletin.

@all:
When reporting problems, please also specify the PHP version and the OS you're using.

dutchbb
12-03-2005, 07:57 AM
@Triple_T:
I'll have a look at it. Meanwhile, please use a separate DB connection as told in the comments in your inc_feeatures.php file.
Hm i'm not sure what you mean. Photopost provides/suggests the option to place it's tables in the vbulletin database when you first install it. I have used that option but there is no way back now. I don't see what else I could do...
Thanks again

toxin
12-03-2005, 12:54 PM
:

@toxin:
It looks like the plugin isn't able to include the phpadsnew code. Please check if the path to you phpadsnew installation is set correctly and phpadsnew works cleanly outside of vbulletin.


yes, phpadsnew is working correctly outside of vBulletin.

My website directories are:
DOC ROOT: /home/httpd/vhosts/mydomain.com/httpdocs/
VBULLETIN: /home/httpd/vhosts/mydomain.com/httpdocs/forums/
PHPADSNEW: /home/httpd/vhosts/mydomain.com/httpdocs/adserver/
so I have used /adserver as the path in the vBulletin Server Settting and Optimization.

Xstreamist
12-03-2005, 02:15 PM
@Xstreamist:
If your banner's don't rotate, please first check your phpadsnew setup - it might fall back into displaying a default ad when setup is not correct.
If you're sure that it's not directly related to phpadsnew, then switch vbulletin into debug mode or enable the display of template names in HTML and tell me exactly what is displayed between BEGIN ad and END ad HTML comments.
Also make sure that your browser doesn't cache your banners during your test phase.


Where do I look for the BEGIN ad and END ad ?
My browser isn't caching banners.

Here is how I am trying to add the phpAdsNew code:


<!-- banners -->

<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>
<td align="center">
<ad what="zone:1" />
</td>
</tr>
</table>

<!-- /banners -->


I am trying to add it to the Header template right after the logo. But when I do the banner only shows on the front page and no where else. When I try to add it to the Navbar template it will add it abve the Navbar but within the same table as the Navbar and only on the front page and the View Threads Page, not the View Posts page.

djsydeburnz
12-03-2005, 03:13 PM
first off, let me say that this is looking to be something i can use greatly, thanks! second, let me apologize in advance if my questions have allready been asked and answered. i did breeze through the number of posts with no luck.

1) with phpAdsNew, i logged in as a client and didnt see a way for me to add banners that way, only logged in as admin. did i miss a setting in pan?

2) it seems that my default banner doesnt like to display (the one in the default banner settings)

3) when i tried adding google adsense through pan, it displays the script on the main page of the admin, and you can click on the link next to it to show the actual banner. i thought i was good to go, then when i went to my site, it is trying display the default banner only which shows a broken image. even now after i have delted the google banner. not sure what i did.

4) has anyone got a setup that would allow to use some sort of payment system through vb that would give someone access to adding banner campaigns??

thanks in advance

***on a side-note, i had an idea to reduce the amount of sifting through a multi page post to find q & a. a cool plugin for this type of site might be to have a second post directly under the original post that houses only FAQs from the post. maybe it would look a bit like hybrid mode display.

The M.I.P.
12-03-2005, 03:46 PM
Hi Toxin,
My website directories are:
DOC ROOT: /home/httpd/vhosts/mydomain.com/httpdocs/
VBULLETIN: /home/httpd/vhosts/mydomain.com/httpdocs/forums/
PHPADSNEW: /home/httpd/vhosts/mydomain.com/httpdocs/adserver/
so I have used /adserver as the path in the vBulletin Server Settting and Optimization.since version 1.0.1 of this plugin, the path to a local phpAdsNew is a "normal" filesystem path.
So in your case, the correct setting in vBulletin options is either /home/httpd/vhosts/mydomain.com/httpdocs/adserver or ../adserver. I'd prefer using an absolute path (the former one), even though a relative one (the latter one) is easier to type.

@Xstreamist:
I currently have no time to check, but I'll have a look at it after weekend.

@djsydeburnz:
When logged in as phpAdsNew admin, you have to add appropriate rights (zones, etc.) to the client. Please have a look at the excellent phpAdsNew handbook.

@Triple_T:
Regarding the temporary solution, have a look at lines 25,26 of your attached inc_features.php.
Fill in the DB settings of your Photopost database (or your vbulletin database when Photopost tables are inside vBulletin database; in line 25 replace $dbuserid with your db username, $dbuserpassword with the db password and in line 26 pp_database with the correct db name) and uncomment these lines in your original inc_features.php.
This makes Photopost use a separate db connection and should solve the problems you mentioned above.
I'm still trying to get my hands around a recent Photopost version to be able to check it out and present a clean solution.

djsydeburnz
12-03-2005, 04:20 PM
there is alot of documentation that i read through last night. i just dont understand how it worked for a day, now it doesnt.

toxin
12-03-2005, 04:28 PM
Hi Toxin,
since version 1.0.1 of this plugin, the path to a local phpAdsNew is a "normal" filesystem path.
So in your case, the correct setting in vBulletin options is either /home/httpd/vhosts/mydomain.com/httpdocs/adserver or ../adserver. I'd prefer using an absolute path (the former one), even though a relative one (the latter one) is easier to type.


Both paths give the same error:

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT pageid, title, name, parentid, userperms FROM adv_pages WHERE active = 1 ORDER BY displayorder;

MySQL Error : Table 'phpadsnew.adv_pages' doesn't exist
Error Number : 1146
Date : Saturday, December 3rd 2005 @ 06:24:43 PM
Script : http://www.mydomain.com/?
Referrer : http://www.mydomain.com/forums/forumdisplay.php?f=25
IP Address : 62.252.0.7
Username : admin
Classname : vb_database

toxin
12-03-2005, 08:25 PM
ok, I've fixed it.

I was running PAN in its own database; when I merged it into the main vB database everything started working..

tgmorris
12-03-2005, 09:39 PM
I've installed this and am running into the same problem that toxin had. My PAN (2.0.7) is in a separate db and runs fine on my existing forum. I'm in the process of brining up 3.5.1 on my test forum and getting PAN to work. If I try to specify an absolute path to the PAN directory I get a db error. The only way I get it to work is by using xml-rpc.

I guess the question is pretty simple at this point...

Does PAN need to be using the vb database to be considered a 'local' install?

If so, what would it take to allow for it to be on the same server but using a different db?

djsydeburnz
12-04-2005, 12:53 AM
i feel really dumb that i cant figure this out. im usually pretty good with this type of stuff. is PAN what i want if im just running banners on my site only? it seems as though when reading about zone's in pan, it is referring to multiple sites. if i put zone:1 in the header information, where in the pan setting to i reference the same? i guess im just more confused since it was working fine until i tried adding a google adsense and then they all went away. it keeps wanting to display the default banner which it doesnt even display. argh.......

Skyline_GT
12-04-2005, 01:30 AM
the if statment for usergroup doesn't work...

Can anyone answer my question?

DataAve
12-04-2005, 01:08 PM
Smacks the install button. :p

SVZ
12-05-2005, 12:39 AM
if you use this mod does it still get blocked by Norton Internet Security ad blocker?

The M.I.P.
12-05-2005, 04:32 AM
@toxin, tgmorris:
Normally, phpAdsNew should run fine using a separate DB. Please give me some time to check what could have gone wrong...

@djsydeburnz:
When logged in as admin in phpAdsNew, you can add zones (don't forget to allow clients to use these zones). You can think of zones as a name for the location where a banner can be placed.

@Skyline_GT:
Did you use template conditionals or did you try to distinguish between several usergroups using keywords in phpAdsNew?

@SVZ:
You can't control any client-side filtering a user might do.
To complicate blocking banners, don't use keywords like "ad" or "banner" in your advertisement URLs and try to avoid standard banner sizes (e.g. 468x60).
This product encloses the ads delivered by phpAdsNew with a <!-- BEGIN/END ad --> HTML comment - you might want to remove this.

yayvb
12-09-2005, 01:18 AM
I know that this makes me seem retarded and I know that this type of question is meant for the phpadsnew website, but please answer it here for me.

I fresh install phpadsnew, setup admin, setup advertising account (and upload a banner), even publisher account to try to get this working.
I download/install product (.xml file attached to this thread)
I updated the local location of pypadsnew in vb admincp.
I edit my header template to show <ad what="zone:1" />

No banner shows. How do I know which zone? I don't see a name or number point to which zone. Did I have to setup an advertising account and publisher account, all i want is to upload my own banner so when other people run out of credits my banners display.

I assumed I should create a publisher account so that I can get the code, but I was able to get the code I think without out. Plus the template variable <ad what="zone:1" /> is supposed to replace the code?

Just a little push, I think I'm almost there.

Thanks

yayvb
12-09-2005, 01:26 AM
i feel really dumb that i cant figure this out. im usually pretty good with this type of stuff. is PAN what i want if im just running banners on my site only? it seems as though when reading about zone's in pan, it is referring to multiple sites. if i put zone:1 in the header information, where in the pan setting to i reference the same? i guess im just more confused since it was working fine until i tried adding a google adsense and then they all went away. it keeps wanting to display the default banner which it doesnt even display. argh.......

I'm having a bit of trouble myself, but zones usually (and in this case) refer to certain sections of your site that these ads will display in. Some people may only want to advertise in a marijuana or x-rated zone, etc. or even a header zone or sidebar zone, etc.

yayvb
12-10-2005, 04:27 PM
No one knows why the variable I mentioned (2 posts above this one) isn't working for me? Like I mentioned, I think I did everything correctly. Any help would be appreciated, I would like to get these ads displaying.

Thanks in advance.

DomP
12-10-2005, 07:13 PM
Did U try to get it to work without the plugin first ?

If not, create an invocation code (java) copy and paste that somewhere in your header template and see if its works.

Then start fiddling with this

Xstreamist
12-10-2005, 07:40 PM
Still waiting to get assistance with my problem here... Banners aren't rotating and wont show up when I try to put them in my header...?? I got some pretty P'ed off sponsors right now.

Xstreamist
12-10-2005, 07:54 PM
By the way... are we supposed to paste the invocation code somewhere? I tried to and got an sql error.... I'm running this off a local server, not remote...
I seriously need help with this or I'm gonna lose my sponsors and therefore lose my site......

DomP
12-10-2005, 07:59 PM
go read the phpadsnew tut's and you're fine ;)

BOTH of em

Xstreamist
12-10-2005, 09:11 PM
I HAVE read them.. all THREE of them. And I'm NOT fine.

DomP
12-10-2005, 09:27 PM
Is it working for you without this ? (phpadsnew)

Xstreamist
12-10-2005, 09:39 PM
What do you mean is it working with out this??? Is what working without what?

DomP
12-10-2005, 09:43 PM
Just trying to help you ;)

I'm wondering if you are able to get the banners at your site without "phpAdsNew Integration 1.0.1 for vBulletin 3.5.x"

Xstreamist
12-10-2005, 09:47 PM
Yes I can. But I need to rotate banners. If there's an easier way to rotate banners on vBulletin 3.5.1 please let me know... This method has just been a major headache since I downloaded it. I don't need all the bells and whistles of click tracking or anyhting.. just need to be able to rotate banners.

DomP
12-10-2005, 09:55 PM
pm'd you ;)

Xstreamist
12-10-2005, 10:38 PM
Still not fixed :disappointed:

yayvb
12-11-2005, 02:52 AM
Did U try to get it to work without the plugin first ?

If not, create an invocation code (java) copy and paste that somewhere in your header template and see if its works.

Then start fiddling with this

Yep this works fine, but like I said after everything that I said I did, but if I put this <ad what="zone:1" /> in my header template instead of the javascript it doesn't show. Any help would be appreciated.

Xstreamist
12-12-2005, 03:59 PM
Is there no support for this??? The support option for this plugin is checked off.. if there's no support it should be unchecked.... I still don't have this working and I just lost two sponsors yesterday because of it.... My remaining 4 sponsors are threatnening to leave as well.... Should I just uninstall this nightmare plugin or is there going to be support??????

ConqSoft
12-12-2005, 04:19 PM
Is there no support for this??? The support option for this plugin is checked off.. if there's no support it should be unchecked.... I still don't have this working and I just lost two sponsors yesterday because of it.... My remaining 4 sponsors are threatnening to leave as well.... Should I just uninstall this nightmare plugin or is there going to be support??????

I think you have already answered your own question. If I was having a problem with it, I would have switched to another method WELL before losing a sponsor over it. That sounds like poor handling of the situation on your part, but that's just my opinion.

tgmorris
12-12-2005, 04:27 PM
Is there no support for this??? The support option for this plugin is checked off.. if there's no support it should be unchecked.... I still don't have this working and I just lost two sponsors yesterday because of it.... My remaining 4 sponsors are threatnening to leave as well.... Should I just uninstall this nightmare plugin or is there going to be support??????I don't know what to say. I had it working on my test board and then put 3.5.2 on my live forum. I installed this there the same as on my test board and it wouldn't work. I did get it working so I thought I'd found the problem. However when I went to confirm this the change made no difference and things continued to work.

At the moment I have this running on my live forum via xml and it's serving ads fine. I also added a conditional so that the AdSense stuff doesn't violate the TOS for my google ads by creating 2 zones that are the same except one doesn't include the google ads.

In theory this is supposed to work if phpAdsNew is in a separate db but that generates errors so I'm using the xml interface. My board's low traffic so that's OK. It apparently does work fine if the phpAdsNew db is the same as the vb db.

Xstreamist
12-12-2005, 05:04 PM
I think you have already answered your own question. If I was having a problem with it, I would have switched to another method WELL before losing a sponsor over it. That sounds like poor handling of the situation on your part, but that's just my opinion.

Way to shift the blame Conq. This is SUPPOSED to be a supported plugin. The blame for not getting support does NOT lay with me.

ConqSoft
12-12-2005, 05:07 PM
You're the one trying to blame the author of a FREE hack for the loss of your sponsors. That's BS. That's all on you for not having it tested and confirmed to be working in a test environment before going live.

The M.I.P.
12-13-2005, 01:16 PM
Version 1.0.2 is out with a minor fix towards PHP 5.1.1 compatibility.
Please make sure to have set $phpAds_config['compatibility_mode'] = true; in phpAdsNew config file, as this resolves problems with a local phpAdsNew installation when phpAdsNew's tables are in a database different from the one used by your vBulletin board.

Xstreamist
12-13-2005, 01:51 PM
You're the one trying to blame the author of a FREE hack for the loss of your sponsors. That's BS. That's all on you for not having it tested and confirmed to be working in a test environment before going live.

Whether it's free or not is NOT relevant at all. The FACT that the "SUPPORTED" option is checked and I have receiver NO support IS!!!!!!!!!! If I had received the support I am suppose to receive to get it working I would NOT have lost sponsors. If the support option was not checked off I wouldn't have posted for support here in the first place. I probably wouldn't even have installed it. But given the fact that it is SUPPOSED to be supported I felt reasonably safe in installing it expecting I would receive assistance if needed. The entire issue at hand is that the author is misleading people by saying he supports the plugin when he doesn't. END OF STORY!!!!

ConqSoft
12-13-2005, 01:56 PM
He seems to be supporting it just fine... He even posted another update.

Again, you put a hack onto your production site without testing it and confirming it was working first, so losing the sponsors was completely YOUR fault, no matter how you would like to try to twist it around.

The M.I.P.
12-13-2005, 02:36 PM
@Xstreamist:
"Supported" means that I look after this thread, fix reported bugs (those with useful descriptions, not ones like "it doesn't work") and make sure it works as per description on clean installations of recent versions of vBulletin and phpAdsNew.
It does not mean that I'm giving free personal assistance for a user.

Dollah
12-13-2005, 03:44 PM
will also try this

Xstreamist
12-14-2005, 01:05 PM
@Xstreamist:
"Supported" means that I look after this thread, fix reported bugs (those with useful descriptions, not ones like "it doesn't work") and make sure it works as per description on clean installations of recent versions of vBulletin and phpAdsNew.
It does not mean that I'm giving free personal assistance for a user.


Gimme a break Mips. You know damn well I gave you a hell of a better description of the problem then that. Just go backl to my earlier posts.
You say you make sure it works as per description?? Well it's NOT working as per youor description. I've asked for help and given you very good details of the problem. Yet I have not gotten any support from you and the plugin still doesn't work properly.

Conq, go blow it out your ass. You have absolutely no clue what support is and all your interested in is covering your buddy's ass when he screws up.

At least now I'll know where NOT to go in the future for any plugins.

tgmorris
12-14-2005, 01:56 PM
Version 1.0.2 is out with a minor fix towards PHP 5.1.1 compatibility.
Please make sure to have set $phpAds_config['compatibility_mode'] = true; in phpAdsNew config file, as this resolves problems with a local phpAdsNew installation when phpAdsNew's tables are in a database different from the one used by your vBulletin board.I've got this installed and working in local mode now w/separate db's. However I still had the problem whereby after the install no ads were being shown and then after some poking around, without changing any parameters or settings, ads began being shown and continue to do so. Very strange indeed.

Guest190829
12-14-2005, 05:49 PM
No coder is required to give support, even if they have clicked the support tag. Please understand that coders are distributing and supporting modification on their own time, they are not obligated to do any of this. I understand that it could be frustrating during a debugging phase of a modification, but it's important that everyone remains as patient as possible. :)

Also, do not insult any members; it will not be tolerated on vb.org.

fbastello
12-16-2005, 11:59 AM
Hi There and thanks for this great plugin!
I managed to get the whole thing working in no time thanks to the detailed installation guidelines and screenshots.
I have however a little question please, when you the generate invocation code button, you can beforehand choose a few options like:
Don't show a banner from the same campaign again on the same page
Don't show the banner again on the same page

In the screengrab, they are set to no, will the <ad tag display the same banner if invocated with several <ad what="zone:1" on the same page? It doesn't seem to respect the rule at them moment for me.
I think it's probably because there a lot of the invocation code that is missing in the <ad tag so I'm just checking that it is the case.

fbastello
12-16-2005, 12:50 PM
OK, I think I cracked it
Basically, I added the following line just before return "<!-- BEGIN ad {$adcomment} -->{$ad['html']}<!-- END ad {$adid} -->";
in the view_ad function plugin:
$phpAds_context[] = array('!=' => 'bannerid:'.$ad['bannerid']);

This basically will allow you to have several <ad what="zone:1" /> anywhere in your templates and be sure that the same banner is not displayed twice.

I've just done it so it's not quite well tested yet, I'm sure that the whole thing could be improved via the ad tag (something like <ad what="zone:1" duplicate_banner_id="1" /> or <ad what="zone:1" duplicate_banner_id="0" /> to switch the option on or off).

Hope this help and thanks again for this great plugin!
F

Jiggles
12-16-2005, 01:36 PM
I get a blank page. Also get mysql errors. I use vb in a different db. Could this be the reason. Where is the config option to set true in plugin for using a seperate db?

tgmorris
12-16-2005, 02:28 PM
I get a blank page. Also get mysql errors. I use vb in a different db. Could this be the reason. Where is the config option to set true in plugin for using a seperate db?

This is from an earlier post...
Please make sure to have set $phpAds_config['compatibility_mode'] = true; in phpAdsNew config file, as this resolves problems with a local phpAdsNew installation when phpAdsNew's tables are in a database different from the one used by your vBulletin board.

Doing this resolved the problem I had w/mysql errors when running in local mode while using a separate db.

Jiggles
12-16-2005, 03:20 PM
This is from an earlier post...
Please make sure to have set $phpAds_config['compatibility_mode'] = true; in phpAdsNew config file, as this resolves problems with a local phpAdsNew installation when phpAdsNew's tables are in a database different from the one used by your vBulletin board.

Doing this resolved the problem I had w/mysql errors when running in local mode while using a separate db.

Yeah I saw that but where do I set that option? I don't know where to find the $phpAds_config setting.

fbastello
12-16-2005, 03:28 PM
Yeah I saw that but where do I set that option? I don't know where to find the $phpAds_config setting.

You can find it in the config.inc.php file in phpadsnew

tgmorris
12-16-2005, 03:31 PM
Yeah I saw that but where do I set that option? I don't know where to find the $phpAds_config setting.Look for config.inc.php in the folder where phpAdsNew is installed. In there you'll find all the settings including the one for compatibility_mode.

.
// Database compatibility mode to insure phpAdsNew
// won't disturb an available database connection
$phpAds_config['compatibility_mode'] = true;

Alternatively, you may use phpAdsNew to change the setting via the Admin interface.

Jiggles
12-16-2005, 03:37 PM
Look for config.inc.php in the folder where phpAdsNew is installed. In there you'll find all the settings including the one for compatibility_mode.

.
// Database compatibility mode to insure phpAdsNew
// won't disturb an available database connection
$phpAds_config['compatibility_mode'] = true;

Alternatively, you may use phpAdsNew to change the setting via the Admin interface.


OK thanks.

Jiggles
12-16-2005, 03:46 PM
OK Now I don't get the error but no ads either.

The code is displaying this

<!-- BEGIN ad 105168249 --><!-- END ad 105168249 -->

Where the ad should be. They worked when doing jscript.

Jiggles
12-16-2005, 03:52 PM
OK Now I don't get the error but no ads either.

The code is displaying this

<!-- BEGIN ad 105168249 --><!-- END ad 105168249 -->

Where the ad should be. They worked when doing jscript.


Also phpadsnews is telling me I need to upgrade then says it doesn't, then won't let me back to home. just keeps trying to upgrade.

tgmorris
12-16-2005, 03:52 PM
OK Now I don't get the error but no ads either.

The code is displaying this
<!-- BEGIN ad 105168249 --><!-- END ad 105168249 --> Where the ad should be. They worked when doing jscript.

How are you invoking the ad? With zones? If so, do you have zones set up in PAN?

Jiggles
12-16-2005, 04:01 PM
How are you invoking the ad? With zones? If so, do you have zones set up in PAN?

PAN? They are in zones but have no idea what PAN is.

tgmorris
12-16-2005, 04:22 PM
PAN? They are in zones but have no idea what PAN is.PAN = phpAdsNew

Jiggles
12-16-2005, 04:25 PM
PAN = phpAdsNew


LOL ok. Yeah they are in zones.

Jiggles
12-16-2005, 05:26 PM
Everytime I change that line in conf for phpadsnew I get redirected to the upgrade section, and it nevers lets me login.

tgmorris
12-16-2005, 07:18 PM
Everytime I change that line in conf for phpadsnew I get redirected to the upgrade section, and it nevers lets me login.

You might try the phpAdsNew support forums (http://forum.phpadsnew.com/).

dreamer81
12-16-2005, 07:33 PM
Can someone tell me how to crate a simple text banner in PAN? I really can't find that invocation code that i need to put in my <ad> tag

BiReL41r
12-16-2005, 07:42 PM
I might try this...looks like a good hack.

dreamer81
12-16-2005, 08:03 PM
ok it works now, but how do i cloak my urls????

i mean REAL cloaking, i currently have a cool javascript that i created myself, that cloaks the url. even when u right click on the link. Most cloaking software fails on this, but not my script, so how do i implement that?

dreamer81
12-17-2005, 10:21 AM
ok huge bug!!

this line will only show the first ad
PAN ad: <ad what="zone:2" /> <ad what="zone:1" />

for some reason, i cannot show two ads on the same line in the template. I have no idea why..... can you fix this?

Smiry Kin's
12-17-2005, 05:39 PM
Very Nice System! excatly what im looking for! :)

The M.I.P.
12-18-2005, 12:54 AM
this line will only show the first ad
PAN ad: <ad what="zone:2" /> <ad what="zone:1" />
for some reason, i cannot show two ads on the same line in the template. I have no idea why..... can you fix this?Thx for reporting this. It was caused by a buggy regular expression and is fixed in version 1.0.3 of this product. Please see upgrade section in my first post.

Basically, I added the following line just before return "<!-- BEGIN ad {$adcomment} -->{$ad['html']}<!-- END ad {$adid} -->";
in the view_ad function plugin:
$phpAds_context[] = array('!=' => 'bannerid:'.$ad['bannerid']);

This basically will allow you to have several <ad what="zone:1" /> anywhere in your templates and be sure that the same banner is not displayed twice.I also thought about this before, but didn't implement it, because in my eyes, a zone denotes a location and therefore should be unique on page.
But as it might be useful for some people, I added this to version 1.0.3 introducing a new setting "Banner Dupe Check". However - I don't recommend using the same zone repeatedly on a page.

fbastello
12-18-2005, 12:36 PM
Brilliant! Thanks for the update!

apfparadise
12-20-2005, 06:56 AM
Great Mod, INSTALLED!!!! Working flawlessly.

tanyeri24
12-26-2005, 01:16 AM
I getting this error if I put the <ad ..> tag on header template:
Fatal error: Call to a member function scalarval() on a non-object in /home/security/public_html/includes/lib-xmlrpc.inc.php on line 729

I have remote phpadsnew and copied the 2 files to my forum includes (describted like on your NOTES..)

Thx for helping in advance

Masiello
12-26-2005, 05:37 PM
Fantastik Thread and Mod, Thanks!

Masiello
12-26-2005, 05:56 PM
I have found a code to set a schedule Tasks to work on vbulletin, but it seems not working really after the time I have set and dont working in general, anyone Have any idea how to set fine in Schedule Tasks of vbulletin?

Masiello
12-26-2005, 06:16 PM
I add that code <!-- logo -->
<a name="top"></a>
<table border="0" width="$stylevar[outertablewidth]" cellpadding="0" cellspacing="0" align="center">
<tr>
<td align="$stylevar[left]"><a href="$vboptions[forumhome].php$session[sessionurl_q]"><img src="$stylevar[titleimage]" border="0" alt="$vboptions[bbtitle]" /></a></td>
<td align="$stylevar[right]">
<ad what="unks" />
&nbsp;
</td>
</tr>
</table>
<!-- /logo -->

<!-- content table -->
$spacer_open

$_phpinclude_output

But when i try to save it, return me this:

Database error in vBulletin 3.5.2:

Invalid SQL:

INSERT INTO vb3_template
(styleid, title, template, template_un, dateline, username, version, product)
VALUES
(1,
'header',
'<!-- logo -->\r\n<a name=\\\"top\\\"></a>\r\n<table border=\\\"0\\\" width=\\\"$stylevar[outertablewidth]\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" align=\\\"center\\\">\r\n<tr>\r\n <td align=\\\"$stylevar[left]\\\"><a href=\\\"\" . $GLOBALS[\'vbulletin\']->options[\'forumhome\'] . \".php\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl_q\'] . \"\\\"><img src=\\\"$stylevar[titleimage]\\\" border=\\\"0\\\" alt=\\\"\" . $GLOBALS[\'vbulletin\']->options[\'bbtitle\'] . \"\\\" /></a></td>\r\n <td align=\\\"$stylevar[right]\\\">\r\n \" . view_ad(\"unks\", \"0\", \"\", \"\", \"0\") . \"\r\n &nbsp;\r\n </td>\r\n</tr>\r\n</table>\r\n<!-- /logo -->\r\n\r\n<!-- content table -->\r\n$spacer_open\r\n\r\n$_phpinclude_output',
'<!-- logo -->\r\n<a name=\"top\"></a>\r\n<table border=\"0\" width=\"$stylevar[outertablewidth]\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\">\r\n<tr>\r\n <td align=\"$stylevar[left]\"><a href=\"$vboptions[forumhome].php$session[sessionurl_q]\"><img src=\"$stylevar[titleimage]\" border=\"0\" alt=\"$vboptions[bbtitle]\" /></a></td>\r\n <td align=\"$stylevar[right]\">\r\n <ad what=\"unks\" />\r\n &nbsp;\r\n </td>\r\n</tr>\r\n</table>\r\n<!-- /logo -->\r\n\r\n<!-- content table -->\r\n$spacer_open\r\n\r\n$_phpinclude_output',
5756784532,
'admin',
'3.5.2',
'vbulletin');

MySQL Error : Table 'lottosqueeze-org_5.vb3_template' doesn't exist
Error Number : 1146
Date : Monday, December 26th 2005 @ 09:14:08 PM
Script : http://www.lottosqueeze.org/forum/admincp/template.php
Referrer : http://www.lottosqueeze.org/forum/admincp/template.php?s=&do=add&dostyleid=1&title=header&group=all&searchstring=&expandset=1
IP Address : 87.3.252.86
Username : admin
Classname : vb_database

It seems try to save my Header template in the database of phpadsnew and not on vbulletin db

FROGGYJ
12-26-2005, 06:26 PM
Great Mod! works great! I have setup my first zone in the header, but now I want to add another one perhaps just above the forums and below the shoutbox.....I know I just have to change the zone id...but I can't seem to find the right spot in the templates. I tried forumhome and forumdisplay just above $forumbits but that didn't work. Anyone know?

Masiello
12-26-2005, 06:55 PM
I have solved my issue, Thanks anyway :) and thanks for this great tool

Masiello
12-26-2005, 07:14 PM
Only a short question, But this tool work with a SQL Banner or not?

tanyeri24
12-28-2005, 02:37 PM
I getting this error if I put the <ad ..> tag on header template:
Fatal error: Call to a member function scalarval() on a non-object in /home/security/public_html/includes/lib-xmlrpc.inc.php on line 729

I have remote phpadsnew and copied the 2 files to my forum includes (describted like on your NOTES..)

Thx for helping in advance
hey dude you're not good enough the resolve it? please give only a short answer if you able to fix or not then can I look somewhere else..

FROGGYJ
12-28-2005, 04:44 PM
Only a short question, But this tool work with a SQL Banner or not?

works with mine...in fact doesn't matter what kind of banner.

Masiello
12-28-2005, 05:04 PM
I dont show any banner, i solved this just copyng invocation code of phpAdsNew in my Header template, that's all, whitout using any product.

Trickle
12-28-2005, 06:40 PM
I don't know about this one, it doesn't seem very newbie user friendly for me. My eyes are bugged eyed right now from reading about 300 pages of installation and I still can't get it to work. Anyone got a Dummies guide for this? I know I am soooo close I can smell it like a fart in the car on a hot august day. Once I create the new advertiser and upload the banner, I can't figuer out how to get it to show up in the linked zone section.

/edit
Making progress here. Bent and determined to figure this one out. I am now getting this error when I add the <ad what"zone:1" /> to the header

Warning: view_ad(/forums/includes/lib-xmlrpc-class.inc.php): failed to open stream: No such file or directory in /includes/init.php(273) : eval()'d code on line 68

Can anyone please tell me what that means. Be gentle I've just started doing VB in the last few weeks.

Trickle

Masiello
12-29-2005, 05:33 AM
Put that library in to the includes directory of your forum, it is inside "libraries" directory of phpAdsNew, when you try again if it ask needing another libs, you find in the same "libraries" dir.

Trickle
12-29-2005, 06:36 PM
So far I got it to work now. Or at least the banner appears. I guess the lesson I learned is to take breaks and refresh the mind. Getting pissed cause I couldn't figure it out only made things worse.

CHECK INSTALLED!!!

Hostboard
12-29-2005, 08:30 PM
I wanted my banners to appear under the Navbar so I added


<ad what"zone:1" />

To the bottom of the template and when I went to save it I got the following error. Any idea?


Database error in vBulletin 3.5.2:
Invalid SQL:

SELECT title, styleid
FROM template
WHERE templateid = 1020;

MySQL Error : Table 'phpads.template' doesn't exist
Error Number : 1146
Date : Thursday, December 29th 2005 @ 05:26:00 PM
Script : [removed]
Referrer : [removed]
IP Address : [removed]
Username : [removed]
Classname : vb_database

Masiello
12-29-2005, 08:34 PM
You have to set the correct path of phpAdsNew on the forum

Hostboard
12-29-2005, 10:02 PM
I did that :) I even cut and pasted it in to the command line to change directories and it is perfect.

Maybe I need a slash at the end?


/usr/local/path/to/my/phpAdsNew

beansbaxter
12-30-2005, 05:02 AM
I've been trying for two hours and I cannot get this to work running on 3.5.2!!!!!

This has to be the most difficult thing to get working (sigh)

I do everything, but no banner shows up at all uggggggggggg

beansbaxter
12-30-2005, 05:19 AM
OK, I think I cracked it
Basically, I added the following line just before return "<!-- BEGIN ad {$adcomment} -->{$ad['html']}<!-- END ad {$adid} -->";
in the view_ad function plugin:
$phpAds_context[] = array('!=' => 'bannerid:'.$ad['bannerid']);

This basically will allow you to have several <ad what="zone:1" /> anywhere in your templates and be sure that the same banner is not displayed twice.

I've just done it so it's not quite well tested yet, I'm sure that the whole thing could be improved via the ad tag (something like <ad what="zone:1" duplicate_banner_id="1" /> or <ad what="zone:1" duplicate_banner_id="0" /> to switch the option on or off).

Hope this help and thanks again for this great plugin!
F

I got it to work finally, by doing this (sigh)...it's a good hack, just needs better instructions and support IMHO. I'm gonna click install now. Thanks.

Hostboard
12-30-2005, 09:15 AM
Ok I added this line but now I get 2 errors when I try entering

<ad what"zone:1" />


into my NAVBAR template


Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /usr/local/path/to/forums/includes/init.php(292) : eval()'d code on line 123



Fatal error: Call to undefined function: view_ad() in /usr/local/path/to/forums/includes/adminfunctions_template.php(3537) : eval()'d code on line 225


Snipit from view_ad function plugin to show where I put the statement


Remember bannerid to prevent showing banner multiple times on same page
$phpAds_context[] = array('!=' => 'bannerid:'.$ad['bannerid']);
}

return "
$phpAds_context[] = array('!=' => 'bannerid:'.$ad['bannerid']);
<!-- BEGIN ad {$adcomment} -->{$ad['html']}<!-- END ad {$adid} -->";
}
}
}
}

Hostboard
12-30-2005, 09:33 AM
Ok now I am not happy. I have been trying to figure this out so I chnaged the config file of phpAdsNew as noted, copied the 2 files over to the includes directory and blew VB completly out of the water. All I get now when trying to access the forums or ACP is:


Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /usr/local/pwrhouse/htdocs/hostboard/forums/includes/init.php(292) : eval()'d code on line 122



Unable to add cookies, header already sent.
File: N/A
Line: 0






Sigh...

Can anyone tell me how to manualy modify whatever it is I need to get at least the system back up???

Masiello
12-30-2005, 09:53 AM
I did that :) I even cut and pasted it in to the command line to change directories and it is perfect.

Maybe I need a slash at the end?


/usr/local/path/to/my/phpAdsNew


Yes :) using a slash at the end

Hostboard
12-30-2005, 10:47 AM
Ok, but I need to know how to edit this stuff manulally now seeing as I am completly dead in the water.

Trickle
12-30-2005, 02:09 PM
Ok I lied. Added another banner and now the 2 banners do not rotate. Guess I'll wait till there is a dummies how to set of instructions hopefully in the near future.

Puntoboy
12-31-2005, 02:53 PM
i'm quite new to all this, how do i install the xml file?

kevinrstruck
01-02-2006, 07:38 PM
I have this working but I am not sure of one thing:

I am using a affiliate program for a company that using Kolimbo.com to run their program.

The code they give me to produce the banner looks like this:


<A href="?kbid=62123&sub=153310&img=Adorama-468x60.gif" onmouseover="window.status='http://www.adorama.com';return true;" onmouseout="window.status=' ';return true;" target="_blank"><img src="http://www.adorama.com/banners/affil/Adorama-468x60.gif" border=0></a><img src="http://www.myaffiliateprogram.com/u/adorama/showban.asp?id=62123&sub=153310&img=Adorama-468x60.gif" border=0>

How in the heck would I put this code in to PAN?

Then again, maybe this is a question best answered over at the PAN support area, but I figured maybe someone here may be able to help.

Great plugin by the way...Nice job.

kevinrstruck
01-02-2006, 07:41 PM
i'm quite new to all this, how do i install the xml file?

VB CP -> Plugin System -> Manage Products -> Add/Import Product

There you can browse to the copy of the XML file you downloaded and save to your local machine then click IMPORT.

Puntoboy
01-02-2006, 07:43 PM
thanks, i never had that option until i upgraded to 3.5.2 today.

kevinrstruck
01-02-2006, 08:59 PM
No problem. Glad I could help.

FROGGYJ
01-02-2006, 09:47 PM
@Kevinstruck

You can copy that whole code right into your "html" banner. Then also copy the href part into the href section in PAN.

kevinrstruck
01-03-2006, 01:17 AM
Well, I thought I had this working.

Using the <ad.../> tags, I can not get a banner to display. Using the direct code from PAN, the banners display.

I installed PAN outside my forums directory in the root so I could use it on my portal as well.

I tried an URL in the Server Setting and Opt screen and uploaded lib-xmlrpc-class.inc.php and lib-xmlrpc.inc.php into the forums/includes folder to see if that would work but it would not.

I then tried a full path:

/home/thephoto/public_html/adserver

But that did not work.

I then tried ../adserver

but that did not work either.

Again, I tested PAN and it is serving ads on both a test page and with the direct code (Javascript) pasted into my header.

Anyone have any suggestions?

tgmorris
01-03-2006, 01:44 AM
Make sure you've done what was posted a few pages back...Please make sure to have set $phpAds_config['compatibility_mode'] = true; in phpAdsNew config file, as this resolves problems with a local phpAdsNew installation when phpAdsNew's tables are in a database different from the one used by your vBulletin board.Once I did that it worked fine with my PAN in a separate db.

kevinrstruck
01-03-2006, 01:53 AM
Yes, I did that.

Here is my config file:


// Database local connection using sockets
$phpAds_config['dblocal'] = false;

// Database hostname
$phpAds_config['dbhost'] = 'localhost';

// Database port
$phpAds_config['dbport'] = 3306;

// Database username
$phpAds_config['dbuser'] = 'xxxxx';

// Database password
$phpAds_config['dbpassword'] = 'xxxxx';

// Database name
$phpAds_config['dbname'] = 'thephoto_adserver';

// Database table name prefix
$phpAds_config['table_prefix'] = 'phpads_';

// Database table type
$phpAds_config['table_type'] = 'MYISAM';

// Use persistent connections to the database
$phpAds_config['persistent_connections'] = true;

// Use INSERT DELAYED in logging functions?
$phpAds_config['insert_delayed'] = true;

// Database compatibility mode to insure phpAdsNew
// won't disturb an available database connection
$phpAds_config['compatibility_mode'] = true;



/************************************************** *******/
/* phpAdsNew configuration */
/************************************************** *******/

// The URL to your phpAds-installation
$phpAds_config['url_prefix'] = 'http://www.thephotostation.net/adsever/';

// Is the admin interface enabled
$phpAds_config['ui_enabled'] = true;

// Only allow access to the admin interface if SSL is used
$phpAds_config['ui_forcessl'] = false;

kevinrstruck
01-03-2006, 02:00 AM
Another issue: When I add the tag, I get a blank screen on my forums. When I take the ad code out, the forums come up normally.

Here is the ad code I am trying to use:

<ad what="zone:2" />


My Header Template is:

<!-- logo -->
<a name="top"></a>
<table border="0" width="$stylevar[outertablewidth]" cellpadding="0" cellspacing="0" align="center">
<tr>
<td align="$stylevar[left]"><a href="$vbpoptions[portalhome]"><img src="$stylevar[titleimage]" border="0" alt="$vboptions[bbtitle]" /></a></td>
<td align="$stylevar[right]">
&nbsp;
<!--
NEW HEADER &amp; NAVBAR

Now that the nav buttons are in the
navbar template, you can stick whatever
you like into this space.

This makes it much easier for novice
admins to customize their header
template without affecting important
navigation elements.
-->
</td>
</tr>
</table>
<!-- /logo -->

<!-- content table -->
$spacer_open

$_phpinclude_output


My path to PAN in Server Settings and Opt is:

/home/thephoto/public_html/adserver
I hope I have included enough info for someone to figure this out for me.

nexus851
01-03-2006, 06:07 AM
I got this error in my MEMBERINFO template when i used "<ad what="zone:1" />" in my header. I notice it conflicts with my vbfriends (buddylist) module at https://vborg.vbsupport.ru/showthread.php?t=101470&highlight=foes

When i disable the vbfriends plugin, the error is gone. =(


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/lendinge/public_html/forum/member.php(687) : eval()'d code on line 160


When i disable the vbfriends plugin below, then the above error is gone. There must be a compatibility problem. Please check this script out and tell me what to change or do to fix this.


if ($_REQUEST['do'] != "ignorelist") { $whichlist = "buddylist"; }
else { $whichlist = "ignorelist"; }
$whichlistshort = ereg_replace("list", "", $whichlist);

// (Dis)Likes
$outcounter = 0;
$outuserids = array();
$outuserids = explode(' ', trim($userinfo[$whichlist]));
if (trim($userinfo[$whichlist]) != "") {
$outusers = $vbulletin->db->query("SELECT ".TABLE_PREFIX."user.username,".TABLE_PREFIX."user.userid,".TABLE_PREFIX."usertextfield.".$whichlist." FROM
".TABLE_PREFIX."user,".TABLE_PREFIX."usertextfield WHERE
".TABLE_PREFIX."user.userid = ".TABLE_PREFIX."usertextfield.userid AND
".TABLE_PREFIX."user.userid IN (".implode(',',$outuserids).")
ORDER BY username");
while ($outuser = mysql_fetch_array($outusers)) {
if ($vbulletin->userinfo['userid'] == $vbulletin->GPC['userid']) {
$outuserlist .= "<a class=\"smallfont\" href=\"".$vbulletin->options['bburl']."/profile.php?do=removelist&userlist=$whichlistshort&u=$outuser[userid]\">[-]</a>&nbsp;&nbsp;";
}
$outuserlist .= "<a class=\"smallfont\" href=\"".$vbulletin->options['bburl']."/member.php?u=$outuser[userid]\"/>$outuser[username]</a>";
$outuserlist .= "<br>";
$outcounter++;
}
}

// (Dis)Liked By
$inoutcounter = 0;
$incounter = 0;
$inusersquery = "SELECT ".TABLE_PREFIX."user.username,".TABLE_PREFIX."user.userid,".TABLE_PREFIX."usertextfield.".$whichlist." FROM
".TABLE_PREFIX."user,".TABLE_PREFIX."usertextfield WHERE
".TABLE_PREFIX."user.userid = ".TABLE_PREFIX."usertextfield.userid AND
FIND_IN_SET('".$userinfo[userid]."', REPLACE(".TABLE_PREFIX."usertextfield.".$whichlist.", ' ', ',')) > 0
ORDER BY ".TABLE_PREFIX."user.username";
$inusers = mysql_query($inusersquery);
while ($inuser = mysql_fetch_array($inusers)) {
$incounter++;
// Bi-Directional (Dis)Like
if (in_array($inuser[userid], $outuserids)) {
if ($vbulletin->userinfo['userid'] == $vbulletin->GPC['userid']) {
$inuserlist .= "<a class=\"smallfont\" href=\"".$vbulletin->options['bburl']."/profile.php?do=removelist&userlist=$whichlistshort&u=$inuser[userid]\">[-]</a>&nbsp;&nbsp;";
}
$outuserids2 = explode(' ', trim($inuser[$whichlist]));
$inuserids2 = array();
$inuserids1 = mysql_query("SELECT userid FROM ".TABLE_PREFIX."usertextfield WHERE
FIND_IN_SET('".$inuser[userid]."', REPLACE(".$whichlist.", ' ', ',')) > 0");
while ($inuserid1 = mysql_fetch_array($inuserids1)) {
$inuserids2[] = $inuserid1[userid];
}
$inoutuserids2 = array_intersect($outuserids2, $inuserids2);
$inoutcounter2 = count($inoutuserids2);
$avatar_url = fetch_avatar_url($inuser['userid']);
$inuser[avatarurl] = $avatar_url[0];
if ($inuser[avatarurl] == "") { $inuser[avatarurl] = "clear.gif"; }
$inoutuserlist .= "<td class=\"smallfont\" align=\"center\" width=\"100\">";
$inoutuserlist .= "<a href=\"".$vbulletin->options['bburl']."/member.php?u=$inuser[userid]\"/>";
$inoutuserlist .= "<img width=75 height=75 border=1 src=\"$inuser[avatarurl]\"><br>";
$inoutuserlist .= "$inuser[username]</a><!-- ($inoutcounter2)-->";
$inoutuserlist .= "</td>";
$inoutcounter++;
if (($inoutcounter % 7) == 0) { $inoutuserlist .= "</tr><tr>"; }
}
else {
if ($vbulletin->userinfo['userid'] == $vbulletin->GPC['userid']) {
$inuserlist .= "<a class=\"smallfont\" href=\"".$vbulletin->options['bburl']."/profile.php?do=addlist&userlist=$whichlistshort&u=$inuser[userid]\">[+]</a>&nbsp;&nbsp;";
}
}
$inuserlist .= "<a class=\"smallfont\" href=\"".$vbulletin->options['bburl']."/member.php?u=$inuser[userid]\"/>$inuser[username]</a>";
$inuserlist .= "<br>";
}

$mutual = @round((($inoutcounter / $outcounter) * 100), 0);
$avatar_url = fetch_avatar_url($userinfo['userid']);
$userinfo[avatarurl] = $avatar_url[0];
if ($userinfo[avatarurl] == "") { $userinfo[avatarurl] = "clear.gif"; }

$FRIENDSFOES = "<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\"
cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">";
$FRIENDSFOES .= "<tr>";
if ($whichlist == "buddylist") { $FRIENDSFOES .= "<td class=\"tcat\" colspan=\"2\">$userinfo[username]'s Buddies ($inoutcounter) <!--... $mutual% Mutual--></td>"; }
if ($whichlist == "ignorelist") { $FRIENDSFOES .= "<td class=\"tcat\" colspan=\"2\">$userinfo[username]'s Buddies ($inoutcounter) <!--... $mutual% Mutual--></td>"; }
$FRIENDSFOES .= "</tr><tr>";
$FRIENDSFOES .= "<td class=\"alt2\" colspan=\"2\">";
$FRIENDSFOES .= " <table>";
$FRIENDSFOES .= " <tr>";
$FRIENDSFOES .= $inoutuserlist;
$FRIENDSFOES .= " </tr>";
$FRIENDSFOES .= " </table>";
$FRIENDSFOES .= "</td>";
$FRIENDSFOES .= "</tr>";
$FRIENDSFOES .= "</table>";


Please help!

Puntoboy
01-03-2006, 12:13 PM
i've installed this as described above.

how do i get the ads to appear above the forum display, but below the Nav bar?

PennylessZ28
01-03-2006, 09:56 PM
I got it working, learning to use phpadsnew is another story, couldn't be setup more stupidly

Puntoboy
01-03-2006, 09:57 PM
sounds like i havent got a chance of getting this to work then.

kevinrstruck
01-04-2006, 05:50 AM
i've installed this as described above.

how do i get the ads to appear above the forum display, but below the Nav bar?

You just need to edit your template as needed.

Puntoboy
01-04-2006, 09:09 AM
but how, and which template?

i'm a total n00b to this, learning as i go along.

i'm not even sure i have phpadsnew configured right.

FROGGYJ
01-04-2006, 09:46 PM
How do you reverse the usage on usergroups. Say I want to display ads to all users except for site supporters.....oh and site supporters is an alternate group not a primary.

FROGGYJ
01-04-2006, 09:58 PM
Would this work?

<if condition="!$bbuserinfo['usergroupid']==1"><ad what="zone:1" /></if>

I'm pretty sure ! reverses the logic....just not sure on placement.

FROGGYJ
01-04-2006, 10:05 PM
woot it works!

johnscanlan
01-05-2006, 08:05 PM
Oh my yes THANKS

matthias.m
01-06-2006, 09:03 PM
Got a Problem with the Cron-Entry of PHPAdsNew in vBulletin: I doesn`t know how to setup this Cron :nervous:

My PHPAdsNew-Installation is in the Directory "/home/pb/public_html/boardhome/werbung"

So I have filled out the Cronentry withe the following Path "/boardhome/werbung/maintenance/maintenance.php"

Now I am getting this Error:
Warnung: main(/home/pb/public_html/boardhome/forum//boardhome/werbung/maintenance/maintenance.php): failed to open stream: No such file or directory in /admincp/cronadmin.php (Zeile 64)

Warnung: main(): Failed opening '/home/pb/public_html/boardhome/forum//boardhome/werbung/maintenance/maintenance.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /admincp/cronadmin.php (Zeile 64)

Seems that vBulletin adds my Path after the Forum-Root? - What the hell do i do wrong??? :ermm:

Greetings,
Matthias

kevinrstruck
01-06-2006, 09:13 PM
Is this still being supported?

matthias.m
01-06-2006, 09:27 PM
Is this still being supported?

Hope so ;)

Ramm
01-09-2006, 08:18 PM
Got a Problem with the Cron-Entry of PHPAdsNew in vBulletin: I doesn`t know how to setup this Cron :nervous: ....

you should just fill the cron entry with "../webrung/maintenance/maintenance.php" path :)

matthias.m
01-10-2006, 05:21 AM
Thank you Ramm!

Greetings,
Matthias

kommuni
01-10-2006, 08:01 PM
Thank you Ramm!

Greetings,
Matthias

@Ramm: did you test this? i get error messages regarding some header stuff when testruning the vb-cronjob with the maintenance.php... maybe this is different when it's really called as cron?

jw00dy
01-11-2006, 06:12 AM
Great MOD!!! Thanks you!

Blackhat
01-15-2006, 10:24 AM
is there a mirror site for this download ?

criscokid
01-15-2006, 11:00 AM
"The features of phpAdsNew combined with the power of vBulletin's templating system gives you the possibility to place ads for specific user groups, forums, and keywords" - Just what I've been after for quite a while - this looks like an awesome plugin!!! Thank you!!!

Bhuwan
01-16-2006, 01:25 AM
got it towork!>

Olney
01-16-2006, 12:59 PM
Does this work with Max Media Manager the same???

Sinister21
01-16-2006, 05:11 PM
Is there a way to install this on VB 3.0.6? if not, is there something similar I can use to integrate Phpadsnew to 3.0.6?

I've installed this hack..
https://vborg.vbsupport.ru/showthread.php?t=94119&highlight=phpadnews

but it will not utilize the invocation codes from phpadsnew.

I need to have forum specific ads served accordingly.

Anyhelp is appreciated!

:D thanks guys!

markbolyard
01-17-2006, 02:17 PM
Any idea how to show two zones (not at the same time, but alternating / allowing each) to show up in one spot?

IE: <ad what="zone:5", "zone:6" />

I have a spot that I want to show 120 width and 160 width banners in, and each of those are different zones, so I want to make one tag, that will show ads from both zones. Thanks.

yayvb
01-17-2006, 02:41 PM
This message doesn't really belong in here, but I think I may have the best luck posting it in here. I tried to setup this hack to allow for phpadsnew to run ads on my site, but I couldn't get anything to display where I stuck the variables.

To make a long story short I have just been using the javascript code that phpadsnew has me use. The ads have been working wonderfully for more than a month now. Perhaps one of the recent changes that I made to the site that I forgot about did something to each page because now when I go to my site the ads appear to work for about 1 or 2 page views and then they completely disappear. :( If I view source I feel like the code is still there but the ads are no longer there, and internet explorer has the little yellow yield sign at the bottom left telling me that there is an error on line 3 char 1.

:(

Does anyone know why this would happen or what would cause this? If I go into phpadsnew it seems to function perfectly and if I don't go to my site for a while and then go I see the ads for just one or two rotations, but then if I refresh or even go to another page or anything the ads no longer show.

Please see for yourself www.420boards.com

Thanks

Chris

*EDIT: I found that if you go to www.420boards.com with no file specified such as index.php, you can see the ad working fine, even if you refresh 10 times or more you'll be fine. The moment you go to a page that has a filename or even www.420boards.com/index.php, then the banners stop working automatically. :( I've even gone as far as to delete my .htaccess file in hopes of correcting the problem, but nothing. I can't find any recent changes that I've made or anything like that that would cause this to happen.

tgmorris
01-17-2006, 03:36 PM
Any idea how to show two zones (not at the same time, but alternating / allowing each) to show up in one spot?When I wanted to select from 2 different zones I wound up using a template conditional. You could do the same and just randomize or alternate them using some external variable. Just a thought.

Rukas
01-22-2006, 03:00 AM
Ive installed this and it seems to have broken member.php, i get the following error:


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /member.php(654) : eval()'d code on line 197

http://www.streethop.com/forum/member.php?u=3

SuperJETT
01-23-2006, 02:13 AM
I have PAN working fine www.x-h2o.com/ad.php and imported the .xml and have the path set correctly (to best of my knowledge) but when I try to add the code for an ad to my header I get a database error where it's trying to change a template table in my PAN database, which doesn't exist.

Database error in vBulletin 3.5.3:

Invalid SQL:

### REPLACE TEMPLATE: header ###
REPLACE INTO vbtemplate
(styleid, title, template, template_un, templatetype, dateline, username, version)
VALUES
(2, 'header', '<!-- logo -->\r\n<a name=\\\"top\\\"></a>\r\n<table border=\\\"0\\\" width=\\\"$stylevar[outertablewidth]\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" align=\\\"center\\\">\r\n<tr>\r\n <td align=\\\"$stylevar[left]\\\"><a href=\\\"\" . $GLOBALS[\'vbulletin\']->options[\'forumhome\'] . \".php\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl_q\'] . \"\\\"><img src=\\\"$stylevar[titleimage]\\\" border=\\\"0\\\" alt=\\\"\" . $GLOBALS[\'vbulletin\']->options[\'bbtitle\'] . \"\\\" /></a></td>\r\n <td align=\\\"$stylevar[right]\\\">\r\n \" . view_ad(\"zone:1\", \"0\", \"\", \"\", \"0\") . \"&nbsp;\r\n </td>\r\n</tr>\r\n</table>\r\n<!-- /logo -->\r\n\r\n<!-- content table -->\r\n$spacer_open\r\n\r\n$_phpinclude_output', '<!-- logo -->\r\n<a name=\"top\"></a>\r\n<table border=\"0\" width=\"$stylevar[outertablewidth]\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\">\r\n<tr>\r\n <td align=\"$stylevar[left]\"><a href=\"$vboptions[forumhome].php$session[sessionurl_q]\"><img src=\"$stylevar[titleimage]\" border=\"0\" alt=\"$vboptions[bbtitle]\" /></a></td>\r\n <td align=\"$stylevar[right]\">\r\n <ad what=\"zone:1\" />&nbsp;\r\n </td>\r\n</tr>\r\n</table>\r\n<!-- /logo -->\r\n\r\n<!-- content table -->\r\n$spacer_open\r\n\r\n$_phpinclude_output', 'template', 1137989173, 'SuperJETT', '3.5.3');

MySQL Error : Table 'myusername_xads.vbtemplate' doesn't exist
Error Number : 1146
Date : Sunday, January 22nd 2006 @ 10:06:13 PM


If I try to change the header in a different way, it works fine, but when trying to add <ad what=\"zone:1\" /> that's what happens.

Does this indicate I don't have my path to PAN set correctly?

tgmorris
01-23-2006, 03:04 AM
Does this indicate I don't have my path to PAN set correctly?It's more likely that you don't have compatibility mode set in PAN. I ran into the same problem as I have PAN in a separate db from my vb install and once I set compatibility mode things started working.

SuperJETT
01-23-2006, 09:47 AM
It's more likely that you don't have compatibility mode set in PAN. I ran into the same problem as I have PAN in a separate db from my vb install and once I set compatibility mode things started working.

Where do I send your carrot? Thanks!!! That was it. I assumed the database settings were fine for PAN since it was working and was looking elsewhere.

(I guess in compatibility mode it opens/closes the db connection a little cleaner?)

Omranic
01-23-2006, 02:28 PM
can any one explain the used & working tags .. plz

I used to use all possible tags called in the first post here & all not worked wxwpt only the tag <ad /> as I writed it empty with no atribute

plz explain all possible tags knowing that there is many users need to use it but has no experience with phpadsnew

Rukas
01-24-2006, 07:52 AM
Is it possible to do an or statement? Zone 1 or zone 2 for example? So it randomly picks one or the other?

Pulsorock
01-24-2006, 10:52 AM
Does this work with Max Media Manager the same???

I have the same question. I use MaxMedia Manager 0.1.x (fork of phpAdsNew) and would like to try this plugin, but I wan't to know that it works with MMM. Thanks....

cmiller1014
01-24-2006, 12:23 PM
This sounds like exactly what I need.

Question for you though. I already use phpadsnew and I use the JS call to pull the banners. Is it possible with this mod to display banners based on keywords found on the page the user is viewing?

For example, if they are reading a thread about hamburgers, can I have it display ads from my advertisers who have "hamburger" as a keyword in phpadsnew?

Thanks!

Omranic
01-24-2006, 05:07 PM
after working with this product I discovered some erors ocured
1st one is what I have written in the past post
2nd Is there is a conflict between this & secret admire
3rd is that there is a conflict bet. this & mkportal

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/phpkd/phpkd.com/mkportal/include/VB/vb_driverf.php on line 57

Omranic
01-24-2006, 05:08 PM
& if I need to edit any mkportal settings It displays

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/phpkd/phpkd.com/mkportal/include/VB/vb_driverf.php on line 57

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/phpkd/phpkd.com/vb/includes/class_core.php:2957) in /hsphere/local/home/phpkd/phpkd.com/mkportal/admin/ad_blocks.php on line 349

knowing that when I remove any codes related to phpadsnew integreted product from my templates every thing back to normal

shunx91
01-24-2006, 10:12 PM
Hi Guys,

I got this message when I tried to modify my templates:

Warning: view_ad(/home/web/clubwrx.net/public_html/forums/includes/lib-xmlrpc-class.inc.php): failed to open stream: No such file or directory in /includes/init.php(292) : eval()'d code on line 68

Can someone please help me out? I tried to upload those two files in the directory but I got a "permission denied" message.

kahmeal
01-25-2006, 03:58 AM
Ive installed this and it seems to have broken member.php, i get the following error:


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /member.php(654) : eval()'d code on line 197

http://www.streethop.com/forum/member.php?u=3

Same problem here... I get a member.php(652) : eval()'d code on line 42 and also line 99. Any ideas?

speedway
01-25-2006, 10:28 AM
Excellent job! Works well. Thanks for the addition, it saved me a lot of work considering my old phpadsnew solutions required code modificiations!

Oh, and BTW - even though I have this marked as "installed", I never received any notification that the version number had changed....

Cheers
Bruce

Rukas
01-26-2006, 09:38 PM
Same problem here... I get a member.php(652) : eval()'d code on line 42 and also line 99. Any ideas?

Have you managed to fix it yet?

Sinister21
01-26-2006, 09:44 PM
Is there a way to install this on VB 3.0.6? if not, is there something similar I can use to integrate Phpadsnew to 3.0.6?

I've installed this hack..
https://vborg.vbsupport.ru/showthread.php?t=94119&highlight=phpadnews

but it will not utilize the invocation codes from phpadsnew.

I need to have forum specific ads served accordingly.

Anyhelp is appreciated!

:D thanks guys!

^^^ Anyone?? :ermm:

Hialls
01-26-2006, 11:21 PM
Very nice!

kahmeal
01-28-2006, 11:12 PM
Have you managed to fix it yet?

Nope, still getting the same error :(

Rukas
01-28-2006, 11:54 PM
Nope, still getting the same error :(


Totally delete the friends plugin and reinstall it from scratch, it fixed the problem for me.

Trana
01-29-2006, 09:26 PM
I have phpadsnew running on 2.0.7. I installed this xml hack, made the changes in the Server Optimization console:

http://mysite/banner/ (this is what I am using for the location)

And now whenever I try and add the <ad> tag, I get this error message:

xmlrpcval: not a scalar type ()
Fatal error: Call to a member function scalarval() on a non-object in c:\Inetpub\wwwroot\forum\includes\lib-xmlrpc.inc.php on line 729

Any ideas what I am doing wrong?

EdQ
01-31-2006, 12:11 PM
Thanks, just installed it. Works great!

Trana
01-31-2006, 03:02 PM
xmlrpcval: not a scalar type ()
Fatal error: Call to a member function scalarval() on a non-object in c:\Inetpub\wwwroot\forum\includes\lib-xmlrpc.inc.php on line 729

Any ideas what I am doing wrong?

Does anyone have any suggestions?

Thanks!

fzzzt
02-01-2006, 07:53 PM
Hello,

I just installed this plugin a couple days ago. It seems to work, but for some reason the get variable separator (&) is getting translated into "&amp;" when displayed on a page. This prevents the picture from displaying, of course, since the URL is now something like "adimage.php?filename=blahg&amp;contenttype=gif". I haven't been able to figure out where this is happening or a way to stop it...anyone know what might cause this? I've played with the htmlspecialchars() calls in the XML file but that didn't seem to help any.

Thanks,
Josh

Trana
02-02-2006, 02:24 AM
Does anyone have any suggestions?

Thanks!

I figured this out. For some reason it is not accepting my URL, but the path works fine.

Tru2Chevy
02-03-2006, 12:51 AM
After editing the following line of the config.inc.php file:

$phpAds_config['compatibility_mode'] = true;

to reflect true instead of false, I get directed to the upgrade section of PAN, and then when I try to manually type the login page (http://www.mysitenamehere.com/phpAds/admin/index.html) I get a 404 - Not Found.

The reason that I edited that line was because of a database error I was receiving when attempting to use the <ad /> tag in the header template.

The user "Jiggles" had the same issue (back on page 8), and he was refered to the PAN forums (Which I have already posted in here (http://forum.phpadsnew.com/index.php?showtopic=10405)).

I just wanted to know if anyone else had this problem and managed to fix it.

- Justin

fortnox
02-06-2006, 05:22 PM
Hi!

First thanks for this hack.

My Question is, how can i put 3 banners ( 3 different banners) with ad tag in one line on header?

Can me anybody help please?

Pulsorock
02-06-2006, 06:50 PM
Just in case anyone using MaxMediaManager is interested. I tried to use this plugin with MaxMediaManager 0.1.x (based mostly on phpAdsNew). It didn't work, but at least I got no error message.

I installed the plugin and edited the path in the settings. I created a zone in MMM and in the invocation code was:
<?php
if (@include(getenv('DOCUMENT_ROOT').'/maxmediamanager/phpadsnew.inc.php')) {
if (!isset($phpAds_context)) $phpAds_context = array();
$phpAds_raw = view_local ('', 21, 0, 0, '_blank', '', '0', $phpAds_context);
echo $phpAds_raw['html'];
}
?>

Then on one of my templates I added the following code:
<ad what="zone:21" />
Where 21 was the zoneid of this new zone I created.

When I go to the page, this is what I see:
http://img405.imageshack.us/img405/1217/maxadscreenshot7rp.gif

Anf if I look at the resulting HTML code, this is what I see:
<!-- BEGIN ad 1685741398 -->http://www.pulsorock.com/banners/mediumrectangle_hrc_corporate_youknow.jpg?8a4481c4 dc<!-- END ad 1685741398 -->

So in conclusion, at the moment the plugin does not work on MMM...

I think I'll continue using the JS invocation. If anyone has any other idea, feel welcome to share it. ;)

cmiller1014
02-11-2006, 05:23 AM
Same problem as these guys.... is there a fix?

Hi Guys,

I got this message when I tried to modify my templates:

Warning: view_ad(/home/web/clubwrx.net/public_html/forums/includes/lib-xmlrpc-class.inc.php): failed to open stream: No such file or directory in /includes/init.php(292) : eval()'d code on line 68

Can someone please help me out? I tried to upload those two files in the directory but I got a "permission denied" message.

Exernon
02-11-2006, 12:16 PM
Installed and rated it 5 star!

Absolutely a great hack!

Pulsorock
02-11-2006, 01:26 PM
It would be possible to make a similar hack like this that works correctly with MaxMediaManager 0.1.x?

Thanks! :)

ianskate
02-12-2006, 09:46 PM
I just tried it on 3.5.3, and had no luck. I get a blank page when trying to save the template, but it never actually saves it. I tried a few times with other options enabled and disabled. I tried changing the path to both the absolute path and path with my hostname as a URL instead.

When I tried the hostname and URL, I got the error above, that the others have been describing. When I use local, I get no error, but I am spit to a blank page with no data, and the template is obviously not saved. (Viewing history and page source)

Could that be a possible problem that I'm using 3.5.3? Is it supposed to be supported, or will it be soon?

DannyITR
02-13-2006, 02:13 PM
I have a question not immedaitely related to this hack but I cannot track clicks with a flash banner and phpadsnew even if I select the option to check for hard-coded links inside the Flash file. I get skewed results and something like 1/10th of the clicks are actually recorded. Is this related to the banner code itself?

dutchbb
02-13-2006, 10:18 PM
I have discovered a problem. The ads show but the target URL directs to: "http://forum.mydomain.com/adscript"

instead of "http://www.mydomain.com/adscript" where it should go.

Any way to fix this problem?

nexus851
02-14-2006, 02:48 AM
How do you uninstall this? because there is no uninstall code in the product manager section...

Im moving my server and this hack is what is causing problems with my server move, so anyone know how to uninstall this without causing any vb errors?

nexus851
02-14-2006, 08:40 AM
How the hell do u uninstall this???????? crashed by board with a FATAL ERROR when you uninstall this... anyone, please help..


Fatal error: Call to undefined function: view_ad() in /home/lendinge/public_html/forum/global.php(528) : eval()'d code on line 6

Pulsorock
02-14-2006, 01:34 PM
I think you can uninstall it in the same place you installed it. Control Panel > Plugin System > Manage Products. There you can delete it.

dc1pop
02-14-2006, 02:21 PM
Works great on my vb 3.5.3 board!

Thanks :D

Saves all the Java code i was using!!

Trana
02-14-2006, 03:44 PM
Two questions...

Does anyone know of an invocation code or something that will display ALL of the banners (either all or all from a campaign)? Sort of like a "Sponsored By" page....

Does anyone know of a way to display banners as thumbnails? I.E. I'd like to dynamically resize them to fit in certain areas of my board.

Thanks in advance to anyone that can help!

The M.I.P.
02-15-2006, 07:47 PM
How the hell do u uninstall this???????? crashed by board with a FATAL ERROR when you uninstall this... anyone, please help..


Fatal error: Call to undefined function: view_ad() in /home/lendinge/public_html/forum/global.php(528) : eval()'d code on line 6

Select "Uninstall" from the dropdown menu in AdminCP->Manage Products->phpAdsNew Integration

Don't forget to remove any occurences of the ad-tag in your templates, else the compiled template still tries to call the view_ad() function.

I have discovered a problem. The ads show but the target URL directs to: "http://forum.mydomain.com/adscript"

instead of "http://www.mydomain.com/adscript" where it should go.

Any way to fix this problem?
Did you explicitely set your URL in phpAdsNew's config.inc.php ($phpAds_config['url_prefix'])?

dutchbb
02-15-2006, 08:24 PM
Did you explicitely set your URL in phpAdsNew's config.inc.php ($phpAds_config['url_prefix'])?
yep...

// The URL to your phpAds-installation
$phpAds_config['url_prefix'] = 'http://www.dutchbodybuilding.com/adserver';

The banner images show, but the target url's go to my forum subdomain.
Thanks

OrionDesigns
02-16-2006, 06:18 PM
I get the following when I try to insert my innvoation code into my header template:

The following error occurred when attempting to evaluate the template 'header':

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/oriongra/public_html/forum/includes/adminfunctions_template.php(3532) : eval()'d code on line 13

This is likely caused by a malformed conditional statement.

Here is my innvocation code itself:
<?php
if (@include('/home/oriongra/public_html/forum/phpadsnew/phpadsnew.inc.php')) {
if (!isset($phpAds_context)) $phpAds_context = array();
$phpAds_raw = view_raw ('zone:1', 0, '', '', '0', $phpAds_context);
echo $phpAds_raw['html'];
}
?>

Any ideas?

stefaandk
02-19-2006, 10:09 AM
Thanks for this mod, I've installed it on 3.5.3 and had no issues so far.

Cheers

Citizen
02-19-2006, 04:10 PM
Does this hack use javascript at all? What actual code does it use for invocation?

Bhuwan
02-20-2006, 06:23 PM
Fatal error: Call to undefined function: view_ad() in /index.php(488) : eval()'d code on line 139

this is with the hack UNINSTALLED!

The Realist
02-28-2006, 07:52 PM
Cant get it to work at all :(

dutchbb
03-01-2006, 12:28 AM
yep...



The banner images show, but the target url's go to my forum subdomain.
Thanks
Can I get a little help here

thanks

The Realist
03-01-2006, 12:33 PM
Cant get anything to show in my header template using the supplied code.

Laters

dutchbb
03-01-2006, 02:19 PM
I imported the plugin 1.0.3 and now my whole board and admin cp show this error:

Fatal error: Call to undefined function: view_ad() in /home/xch1295/domains/domain.com/public_html/forum/global.php(512) : eval()'d code on line 23

Can someone help please?

dutchbb
03-01-2006, 03:08 PM
I imported the plugin 1.0.3 and now my whole board and admin cp show this error:



Can someone help please?
Ok solved...

Bad code in the database caused by a server timeout.

bonjurkes
03-01-2006, 10:33 PM
i installed the phpadsnew

i installed it to mysiteaddress.com/phpadsnew

my forum is at mysiteaddress.com/forum

what must i write to that Location of phpAdsNew ??

also there is lib-xmlrpc.inc.php file and lib-xmlrpcs.inc.php in libraries folder.

I couldnt find ib-xmlrpc-class.inc.php file.

at phpadsnew there is a section like Allowed invocation types

Do i need to click Allow Remote Invocation and Allow Remote Invocation using XML-RPC from settings?

The Realist
03-02-2006, 07:49 AM
Path /phpadsnew

The lib files are in /misc/samples/xmlrpc/php files are in this php folder.

Could try ticking the settings M8, can always untick them later on.

Laters

i installed the phpadsnew

i installed it to mysiteaddress.com/phpadsnew

my forum is at mysiteaddress.com/forum

what must i write to that Location of phpAdsNew ??

also there is lib-xmlrpc.inc.php file and lib-xmlrpcs.inc.php in libraries folder.

I couldnt find ib-xmlrpc-class.inc.php file.

at phpadsnew there is a section like Allowed invocation types

Do i need to click Allow Remote Invocation and Allow Remote Invocation using XML-RPC from settings?

bonjurkes
03-02-2006, 10:59 PM
i made a test advertisement for my forum

i open header and add the code

<ad what="zone:1" />

when i click save i got an db error :

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT title, styleid
FROM template
WHERE templateid = 455;

MySQL Error : Table '*_phpadsnew.template' doesn't exist
Error Number : 1146
Date : Thursday, March 2nd 2006 @ 04:55:07 PM
Script : http://www.*.com/testvb/admincp/template.php
Referrer : http://www.*.com/testvb/admincp/template.php?s=&do=edit&templateid=455&group=&searchstring=&expandset=1
IP Address : *
Username : bonjurkes
Classname : vb_database


I installed phpadsnew to a different db (i create a new one for it) where can i set it to use proper db? Because i think it tries to find proper tables under forum's database...

Floris
03-02-2006, 11:57 PM
Why is this not a .zip file attached to the first post?
Why do I need to enter phpbb is nice, rediculous to ask this from customers of vb!

This totally doesn't work on my 3.5.4 installation, spend an hour on this.

bonjurkes
03-03-2006, 12:03 AM
Why is this not a .zip file attached to the first post?
Why do I need to enter phpbb is nice, rediculous to ask this from customers of vb!

This totally doesn't work on my 3.5.4 installation, spend an hour on this.


i installed it and the only problem i am having is phpadsnew trying to connect its db from my forum's db, if i can make it connect to its own db everything will be fine i think...

markbolyard
03-03-2006, 12:03 AM
I have nothing to do with this plugin, but I can vouch that I have sucessfully installed this for several people in this thread without 1 of the above mentioned problems (VB 3.5.3). It was harder installing and configuring phpadsnew itself than to install and get this plugin to work... I'm going to upgrade to 3.5.4.......I'll let you know if there are any problems...

Great product M.I.P, thank you!

stefaandk
03-04-2006, 04:23 AM
I've upgraded 3.5.3 to 3.5.4 today and all my banners are still working OK.

Jack Black
03-04-2006, 07:59 AM
Does this work with the latest version of phpadsnew 2.0.7?

bonjurkes
03-04-2006, 05:38 PM
I've upgraded 3.5.3 to 3.5.4 today and all my banners are still working OK.


Did u installed the phpadsnew to your forum's db or did u create a seperate db for it?_

markbolyard
03-04-2006, 05:49 PM
I have installed it both ways. Using the vBulletin Database, and a seperate database. Both types of installation work fine and shouldn't be an issue.

bonjurkes
03-04-2006, 07:16 PM
i installed it to the seperate db but that plugin tries to find these tables at forum's database and then give error.

i wrote the error few posts before. can you tell me what must i do it to work with seperate db??

bonjurkes
03-06-2006, 08:36 PM
can anyone tell me what did i do wrong?? When i try too add that <ad tag to my style it gives error like

Invalid SQL:

SELECT title, styleid
FROM template
WHERE templateid = 455;

MySQL Error : Table '*_phpadsnew.template' doesn't exist
Error Number : 1146

I installed phpadsnew to seperate vb then vbulletin but i couldnt find what is going on wrong....

tgmorris
03-06-2006, 09:11 PM
I installed phpadsnew to seperate vb then vbulletin but i couldnt find what is going on wrong....If you are running it in a separate db you need to make sure that you have "compatibility mode" set to true in PAN.

markbolyard
03-06-2006, 10:17 PM
Additionally, make sure your config is correct. If you installed phpadsnew, and are getting that error, it is not finding the table _phpadsnew.template. If you would like me to look at it, please feel free to contact me via MSN Messenger (In my profile) or by email.

Tru2Chevy
03-07-2006, 03:14 PM
I had the same issue as bonjurkes, and no one here or on PAN forums could help me. I finally got my ads served just using the remote invocation code supplied by PAN. I like the way this mod is supposed to work, but I couldn't get it functioning correctly.

- Justin

stefaandk
03-08-2006, 12:56 AM
Did u installed the phpadsnew to your forum's db or did u create a seperate db for it?_


I got seperate DB's

bonjurkes
03-08-2006, 09:50 PM
hey,

i install it without a problem at last :)

Now i want to put some ads special for forums that i want

for example lets say i have a forum called "cars" and i want to display some car ads

and lets say i have another forum called " sport" and i want to display some sport ads

is there a way that i can do it? can anyone explain it to me please..