pollos wrote:<div align="center">"Ad code goes here" </div>indepndent wrote:OK this works now thanks however the banner is not centered on the subsilver2 template. Any suggestions on how to fix this?
Great MOD!
It appears that every time I edit an ad both dates are on day less than they were previously.MikeeCO wrote:I am using mod_ads_ 0_2_0 on phpbb 3.0.1 and when I edit an ad that was previously created the dates are not the dates that were saved when the ad was created. Have you seen this problem? Does anyone have a solution?
Code: Select all
// Start output Ad
$adID = '';
$forum_id = isset($f) ? $f : 0;
$sql = "SELECT a.code, a.ad_id, a.position, a.type, a.image, a.url, a.height, a.width
FROM " . AD_TABLE ." a, " . USER_GROUP_TABLE . " g
WHERE (a.max_views >= a.views OR a.max_views = '0')
AND (FIND_IN_SET(" .$forum_id. ", a.show_forums) > 0 OR a.show_all_forums = '1')
AND g.user_id = " . $user->data['user_id'] . "
AND FIND_IN_SET(g.group_id, a.groups)
AND FIND_IN_SET(" . $user->data['user_rank'] . ", a.ranks)
AND a.start_time < " . time() . "
AND a.end_time > " . time() . "
AND (a.clicks <= a.max_clicks OR a.max_clicks = '0')
ORDER BY rand()";
$result = $db->sql_query($sql);
while($row = $db->sql_fetchrow($result))
{
if ($row['type'] == 2)
{
$adcode[$row['position']] = '<a href="' . $phpbb_root_path . 'adclick.' . $phpEx . '?id=' . $row['ad_id'] . '"><img src="' . $row['image'] . '" height="' . $row['height'] . '" width="' . $row['width'] . '" alt="" /></a>';
}
else
{
$adcode[$row['position']] = html_entity_decode($row['code']);
}
$adID[$row['position']]['ID'] = $row['ad_id'];
}
$db->sql_freeresult($result);
// update views for every Ad
for ($i = 1; $i <= 6; $i++)
{
if (isset($adID[$i]['ad_id']))
{
$db->sql_query('UPDATE ' . AD_TABLE . ' SET views = views +1 WHERE ad_id = ' . $adID[$i]['ad_id']);
}
}
// End output AdCode: Select all
General Error
SQL ERROR [ mysqli ]
Unknown column 'a.ad_id' in 'field list' [1054]
SQL
SELECT a.code, a.ad_id, a.position, a.type, a.image, a.url, a.height, a.width FROM phpbb_ad a, phpbb_user_group g WHERE (a.max_views >= a.views OR a.max_views = '0') AND (FIND_IN_SET(0, a.show_forums) > 0 OR a.show_all_forums = '1') AND g.user_id = 2 AND FIND_IN_SET(g.group_id, a.groups) AND FIND_IN_SET(1, a.ranks) AND a.start_time < 1207734195 AND a.end_time > 1207734195 AND (a.clicks <= a.max_clicks OR a.max_clicks = '0') ORDER BY rand()
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()
FILE: includes/functions.php
LINE: 3460
CALL: dbal_mysqli->sql_query()
FILE: portal.php
LINE: 258
CALL: page_header()
Code: Select all
// The following assigns all _common_ variables that may be used at any point in a template.
if (!isset($arcade))
{
$user->add_lang('mods/arcade');
$template->assign_var('U_ARCADE', append_sid("{$phpbb_root_path}arcade.$phpEx"));
}
$template->assign_vars(array(Code: Select all
// The following assigns all _common_ variables that may be used at any point in a template.
$template->assign_vars(array(Code: Select all
// Start output Ad
$adID = '';
$forum_id = isset($f) ? $f : 0;
$sql = "SELECT a.code, a.ad_id, a.position, a.type, a.image, a.url, a.height, a.width
FROM " . AD_TABLE ." a, " . USER_GROUP_TABLE . " g
WHERE (a.max_views >= a.views OR a.max_views = '0')
AND (FIND_IN_SET(" .$forum_id. ", a.show_forums) > 0 OR a.show_all_forums = '1')
AND g.user_id = " . $user->data['user_id'] . "
AND FIND_IN_SET(g.group_id, a.groups)
AND FIND_IN_SET(" . $user->data['user_rank'] . ", a.ranks)
AND a.start_time < " . time() . "
AND a.end_time > " . time() . "
AND (a.clicks <= a.max_clicks OR a.max_clicks = '0')
ORDER BY rand()";
$result = $db->sql_query($sql);
while($row = $db->sql_fetchrow($result))
{
if ($row['type'] == 2)
{
$adcode[$row['position']] = '<a href="' . $phpbb_root_path . 'adclick.' . $phpEx . '?id=' . $row['ad_id'] . '"><img src="' . $row['image'] . '" height="' . $row['height'] . '" width="' . $row['width'] . '" alt="" /></a>';
}
else
{
$adcode[$row['position']] = html_entity_decode($row['code']);
}
$adID[$row['position']]['ID'] = $row['ad_id'];
}
$db->sql_freeresult($result);
// update views for every Ad
for ($i = 1; $i <= 6; $i++)
{
if (isset($adID[$i]['ad_id']))
{
$db->sql_query('UPDATE ' . AD_TABLE . ' SET views = views +1 WHERE ad_id = ' . $adID[$i]['ad_id']);
}
}
// End output Ad
// The following assigns all _common_ variables that may be used at any point in a template.
$template->assign_vars(array(
'AD_CODE1' => isset($adcode[1]) ? $adcode[1] : '',
'AD_CODE2' => isset($adcode[2]) ? $adcode[2] : '',
'AD_CODE3' => isset($adcode[3]) ? $adcode[3] : '',
'AD_CODE4' => isset($adcode[4]) ? $adcode[4] : '',
'AD_CODE5' => isset($adcode[5]) ? $adcode[5] : '',
'AD_CODE6' => isset($adcode[6]) ? $adcode[6] : '',Don't worry about it, fixed issue, re-uploaded files...csp4.0 wrote:When I added both modules (HTML_ads, and BANNER_ads) I get this error when trying to access the modules:
I changed the ads.php CHMOD to 777 but it still shows that error, doesn't matter what module that I go in (HTML_ads, or BANNER_ads) but it still shows that error...Code: Select all
General Error Language file ads.php couldn't be opened.
Help anyone?
Bump? Can anyone please help me!csp4.0 wrote:Don't worry about it, fixed issue, re-uploaded files...csp4.0 wrote:When I added both modules (HTML_ads, and BANNER_ads) I get this error when trying to access the modules:
I changed the ads.php CHMOD to 777 but it still shows that error, doesn't matter what module that I go in (HTML_ads, or BANNER_ads) but it still shows that error...Code: Select all
General Error Language file ads.php couldn't be opened.
Help anyone?
EDIT: Still need help, BANNER_ADS still shows same error... Please help people!
MORE EDITS: I installed this on phpBB3.0.1 to those that might want to know... Also now both modes (HTML_AD and BANNER_AD) are showing the cannot be opened error, ads.php is CHMOD at 777, but still nothing...
Anyone?
Again, I got no errors and stuff, but also no ads. What could it be?