Trying to mkae a really simple code....

[error_22]

you cant use PHP in templates. HTML only.

[wakerider017]

error_22 wrote:

you cant use PHP in templates. HTML only.

Then how would I go about doint this?

Ls1tech.com and ls1gto.com both do something similar too this...

How are they pulling it off?

[Houdini]

Maybe if you asked at their site they would tell you how they do it.

[wakerider017]

Houdini wrote:

Maybe if you asked at their site they would tell you how they do it.

they only help with actual vb related stuff...

[error_22]

what vB version are you on?

[wakerider017]

error_22 wrote:

what vB version are you on?

3.5.4

[wakerider017]

Me and error got a LONG way! That guy is really smart!!!!

right now we only have 1 small problem...

I have 5 ads in my database and I want 5 different ones to appear randomly on my table...

Right now 5 of the same ad appear on my table 🙁

It is random b/c a new set appears everytime you regresh.... but I want 5 different ads to appear....

Here is a link where you can view whats going on: http://lsxgto.net/index.php?styleid=9

Here is what I inserted in the template:

<tr><td>
<a href='$ads_HREF'><img src='$ads_SRC' name='$ads_ALT' border=0></a></td></tr> 

error had me edit my global.php file in vbulletin...

Below:

fetch_time_data();

I added:

$sql = "SELECT * FROM `table_name` ORDER BY RAND()";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_object($result))
{
    $ads_HREF = "$row->HREF";
    $ads_SRC = "$row->SRC";
    $ads_ALT = "$row->ALT";
}

I think there may be something missing in that so that the ad only appears once per page?

[wakerider017]

Not sure if this will help... but I went into my old phpads to look at invocation code....

The top code is the default code.... .

and the code under hs the following option selected: Don't show the banner again on the same page

this probably does not help much... but I thought I would post it...

<?php
    if (@include('/homepages/1/d154697587/htdocs/gto/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'];
    }
?>

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

[wakerider017]

I think I have to loop the results...

Anyone know how to do that?

[wakerider017]

I think LS1GTO.com is running something like this:

function getSponsorBanner()
 {
         $ads = $db->query_first("
                 SELECT          *
                 FROM            ads
                 ORDER BY        rand()
                 ");

      if ($db->num_rows($ads) == 0) 
              return NULL; 

    while ($adrow = $db->fetch_array($ads)) {
  $retStr .= "<tr>  

         <td ><a href=\"$adrow[web]\" target=\"_blank\" title=\"$adrow[company]\"><img src=\"images/ads/$adrow[button]\" border=\"0\"></a></td> 
       </tr>";
    }
         return "$retStr";

 }  

[wakerider017]

someone reccomend this:

<?php
$i=0;
$number_of_ads= //Enter the number of ads;
while($i<number_of_ads)
{
?>
<tr><td>
<a href='<?php echo($ads_HREF[$i]); ?>'><img src='<?php echo($ads_SRC[$i]); ?>' name='<?php echo($ads_ALT[$i]); ?>' border=0></a></td></tr>
<?php
$i++;
}//close while;
?>