|
@@ 1509-1558 (lines=50) @@
|
| 1506 |
|
return $wfl_news_module_included; |
| 1507 |
|
} |
| 1508 |
|
|
| 1509 |
|
function wfl_getbanner_from_id_banner($banner_id) |
| 1510 |
|
{ |
| 1511 |
|
###### Hack by www.stefanosilvestrini.com ###### |
| 1512 |
|
global $xoopsConfig; |
| 1513 |
|
$db =& XoopsDatabaseFactory::getDatabaseConnection(); |
| 1514 |
|
$bresult = $db -> query("SELECT COUNT(*) FROM " . $db -> prefix('banner') . " WHERE bid=" . $banner_id); |
| 1515 |
|
list ($numrows) = $db -> fetchRow($bresult); |
| 1516 |
|
if ($numrows > 1) { |
| 1517 |
|
$numrows = $numrows - 1; |
| 1518 |
|
mt_srand((double) microtime() * 1000000); |
| 1519 |
|
$bannum = mt_rand(0, $numrows); |
| 1520 |
|
} else { |
| 1521 |
|
$bannum = 0; |
| 1522 |
|
} |
| 1523 |
|
if ($numrows > 0) { |
| 1524 |
|
$bresult = $db -> query("SELECT * FROM " . $db -> prefix('banner'). " WHERE bid=" . $banner_id, 1, $bannum); |
| 1525 |
|
list ($bid, $cid, $imptotal, $impmade, $clicks, $imageurl, $clickurl, $date, $htmlbanner, $htmlcode) = $db -> fetchRow($bresult); |
| 1526 |
|
if ($xoopsConfig['my_ip'] == xoops_getenv('REMOTE_ADDR')) { |
| 1527 |
|
// EMPTY |
| 1528 |
|
} else { |
| 1529 |
|
$db -> queryF(sprintf("UPDATE %s SET impmade = impmade+1 WHERE bid = %u", $db -> prefix('banner'), $bid)); |
| 1530 |
|
} |
| 1531 |
|
/* Check if this impression is the last one and print the banner */ |
| 1532 |
|
if ($imptotal == $impmade) { |
| 1533 |
|
$newid = $db -> genId($db -> prefix("bannerfinish") . "_bid_seq"); |
| 1534 |
|
$sql = sprintf("INSERT INTO %s (bid, cid, impressions, clicks, datestart, dateend) VALUES (%u, %u, %u, %u, %u, %u)", $db -> prefix('bannerfinish'), $newid, $cid, $impmade, $clicks, $date, time()); |
| 1535 |
|
$db -> queryF($sql); |
| 1536 |
|
$db -> queryF(sprintf("DELETE FROM %s WHERE bid = %u", $db -> prefix('banner'), $bid)); |
| 1537 |
|
} |
| 1538 |
|
if ($htmlbanner) { |
| 1539 |
|
$bannerobject = $htmlcode; |
| 1540 |
|
} else { |
| 1541 |
|
$bannerobject = '<div align="center"><a href="' . XOOPS_URL . '/banners.php?op=click&bid=' . $bid . '" target="_blank">'; |
| 1542 |
|
if (stristr($imageurl, '.swf')) { |
| 1543 |
|
$bannerobject = $bannerobject |
| 1544 |
|
.'<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" width="468" height="60">' |
| 1545 |
|
.'<param name="movie" value="' . $imageurl . '"></param>' |
| 1546 |
|
.'<param name="quality" value="high"></param>' |
| 1547 |
|
.'<embed src="' . $imageurl . '" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="468" height="60">' |
| 1548 |
|
.'</embed>' |
| 1549 |
|
.'</object>'; |
| 1550 |
|
} else { |
| 1551 |
|
$bannerobject = $bannerobject . '<img src="' . $imageurl . '" alt="" />'; |
| 1552 |
|
} |
| 1553 |
|
$bannerobject = $bannerobject . '</a></div>'; |
| 1554 |
|
} |
| 1555 |
|
|
| 1556 |
|
return $bannerobject; |
| 1557 |
|
} |
| 1558 |
|
} |
| 1559 |
|
|
| 1560 |
|
function wfl_getbanner_from_id_client($client_id) |
| 1561 |
|
{ |
|
@@ 1560-1609 (lines=50) @@
|
| 1557 |
|
} |
| 1558 |
|
} |
| 1559 |
|
|
| 1560 |
|
function wfl_getbanner_from_id_client($client_id) |
| 1561 |
|
{ |
| 1562 |
|
###### Hack by www.stefanosilvestrini.com ###### |
| 1563 |
|
global $xoopsConfig; |
| 1564 |
|
$db =& XoopsDatabaseFactory::getDatabaseConnection(); |
| 1565 |
|
$bresult = $db -> query("SELECT COUNT(*) FROM " . $db -> prefix('banner') . " WHERE cid=" . $client_id); |
| 1566 |
|
list ($numrows) = $db -> fetchRow($bresult); |
| 1567 |
|
if ($numrows > 1) { |
| 1568 |
|
$numrows = $numrows - 1; |
| 1569 |
|
mt_srand((double) microtime() * 1000000); |
| 1570 |
|
$bannum = mt_rand(0, $numrows); |
| 1571 |
|
} else { |
| 1572 |
|
$bannum = 0; |
| 1573 |
|
} |
| 1574 |
|
if ($numrows > 0) { |
| 1575 |
|
$bresult = $db -> query("SELECT * FROM " . $db -> prefix('banner') . " WHERE cid=" . $client_id . " ORDER BY rand()", 1, $bannum); |
| 1576 |
|
list ($bid, $cid, $imptotal, $impmade, $clicks, $imageurl, $clickurl, $date, $htmlbanner, $htmlcode) = $db -> fetchRow($bresult); |
| 1577 |
|
if ($xoopsConfig['my_ip'] == xoops_getenv('REMOTE_ADDR')) { |
| 1578 |
|
// EMPTY |
| 1579 |
|
} else { |
| 1580 |
|
$db -> queryF(sprintf("UPDATE %s SET impmade = impmade+1 WHERE bid = %u", $db -> prefix('banner'), $bid)); |
| 1581 |
|
} |
| 1582 |
|
/* Check if this impression is the last one and print the banner */ |
| 1583 |
|
if ($imptotal == $impmade) { |
| 1584 |
|
$newid = $db -> genId($db -> prefix('bannerfinish') . "_bid_seq"); |
| 1585 |
|
$sql = sprintf("INSERT INTO %s (bid, cid, impressions, clicks, datestart, dateend) VALUES (%u, %u, %u, %u, %u, %u)", $db -> prefix('bannerfinish'), $newid, $cid, $impmade, $clicks, $date, time()); |
| 1586 |
|
$db -> queryF($sql); |
| 1587 |
|
$db -> queryF(sprintf("DELETE FROM %s WHERE bid = %u", $db -> prefix('banner'), $bid)); |
| 1588 |
|
} |
| 1589 |
|
if ($htmlbanner) { |
| 1590 |
|
$bannerobject = $htmlcode; |
| 1591 |
|
} else { |
| 1592 |
|
$bannerobject = '<div align="center"><a href="' . XOOPS_URL . '/banners.php?op=click&bid=' . $bid . '" target="_blank">'; |
| 1593 |
|
if (stristr($imageurl, '.swf')) { |
| 1594 |
|
$bannerobject = $bannerobject |
| 1595 |
|
.'<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" width="468" height="60">' |
| 1596 |
|
.'<param name="movie" value="' . $imageurl . '"></param>' |
| 1597 |
|
.'<param name="quality" value="high"></param>' |
| 1598 |
|
.'<embed src="' . $imageurl . '" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="468" height="60">' |
| 1599 |
|
.'</embed>' |
| 1600 |
|
.'</object>'; |
| 1601 |
|
} else { |
| 1602 |
|
$bannerobject = $bannerobject . '<img src="' . $imageurl . '" alt="" />'; |
| 1603 |
|
} |
| 1604 |
|
$bannerobject = $bannerobject . '</a></div>'; |
| 1605 |
|
} |
| 1606 |
|
|
| 1607 |
|
return $bannerobject; |
| 1608 |
|
} |
| 1609 |
|
} |
| 1610 |
|
|
| 1611 |
|
function emailcnvrt($email) |
| 1612 |
|
{ |
mambax7 /
wflinks
