Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
  #1  
Old 10-30-2005, 02:54 PM
Parker Clack Parker Clack is offline
 
Join Date: Oct 2001
Posts: 351
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default I need some help with these files.

I have a banner rotation system that I am using with vB version 2.xx and I want to port it over to 3.5

How would I write the following to work with 3.5?

Code:
<?php
error_reporting(7);
require('./global.php');
$timenow = time();
$boarduser = $bbuserinfo['userid'];

if(isset($bannerid))
{
	$banner = $DB_site->query_first("SELECT * FROM banner WHERE id='$bannerid'");
	$url = $banner['redirector_url'];
	
	if (!empty($boarduser))
	{
		$DB_site->query("UPDATE banner SET userclicks=userclicks+1 WHERE id='$bannerid'");
		
		// is there a user in the table who still has clicked?
		$clickeduser = $DB_site->query_first("SELECT * FROM userclicks WHERE userid='$boarduser' AND bannerid='$bannerid'");
		$clickeduser = $clickeduser['userid'];
		if(!empty($clickeduser))
			$DB_site->query("UPDATE userclicks SET clicks=clicks+1 WHERE userid='$boarduser' AND bannerid='$bannerid'");
		else
			$DB_site->query("INSERT INTO userclicks (userid, bannerid, clicks) VALUES ('$boarduser', '$bannerid', '1')");
	}
	else
		$DB_site->query("UPDATE banner SET guestclicks=guestclicks+1 WHERE id='$bannerid'");
	
	header("Location:$url");
}
else
	echo	("Please Include an ID!");
?>
and

Code:
<?php

$noheader=1;

//require("./global.php");

set_magic_quotes_runtime(0);

@error_reporting(7);

// ###################### Start init #######################

unset($dbservertype);

//load config
require('./admin/config.php');

// init db **********************
// load db class
$dbservertype = strtolower($dbservertype);
$dbclassname="./admin/db_$dbservertype.php";
require($dbclassname);

$DB_site=new DB_Sql_vb;

$DB_site->appname='vBulletin';
$DB_site->appshortname='vBulletin (forum)';
$DB_site->database=$dbname;
$DB_site->server=$servername;
$DB_site->user=$dbusername;
$DB_site->password=$dbpassword;

$DB_site->connect();

$dbpassword="";
$DB_site->password="";
// end init db

if(isset($bannerid))
{
	$banner = $DB_site->query_first("SELECT * FROM banner WHERE id='$bannerid'");
	$url = $banner['url_to_banner'];
	
	$update = $DB_site->query("UPDATE banner SET views=views+1 WHERE id='$bannerid'");
		
	header("Location:$url");
}
else
	echo	("Please Include an ID!");
?>
Thanks for any help you can give.

Parker
Reply With Quote
  #2  
Old 10-30-2005, 03:37 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Change $bbuserinfo to $vbulletin->userinfo and $DB_site to $vbulletin->db and you should be most of the way there.
Reply With Quote
  #3  
Old 10-30-2005, 10:52 PM
Parker Clack Parker Clack is offline
 
Join Date: Oct 2001
Posts: 351
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

For the first file does this look ok?

Code:
<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'click');


// ######################### REQUIRE BACK-END ############################
require('./global.php');

$timenow = time();
$boarduser = $vbulletin->userinfo['userid'];

if(isset($bannerid))

{
	$banner =  $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "banner WHERE id='$bannerid'");
	$url = $banner['redirector_url'];
	
	if (!empty($boarduser))
	{
		$vbulletin->db->query("UPDATE banner SET " . TABLE_PREFIX . "userclicks=userclicks+1 WHERE id='$bannerid'");
		
		// is there a user in the table who still has clicked?
		$clickeduser = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "userclicks WHERE userid='$boarduser' AND bannerid='$bannerid'");
		$clickeduser = $clickeduser['userid'];
		if(!empty($clickeduser))
			$vbulletin->db->query_first("UPDATE " . TABLE_PREFIX . "userclicks SET clicks=clicks+1 WHERE userid='$boarduser' AND bannerid='$bannerid'");
		else
			$vbulletin->db->query_first("INSERT INTO " . TABLE_PREFIX . "userclicks (userid, bannerid, clicks) VALUES ('$boarduser', '$bannerid', '1')");
	}
	else
		$vbulletin->db->query_first("UPDATE banner SET " . TABLE_PREFIX . "guestclicks=guestclicks+1 WHERE id='$bannerid'");
	
	header("Location:$url");
}
else
	echo	("Please Include an ID!");
?>
and for the second

Code:
<?php

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'view');

// ###################### Start init #######################

require("../includes/config.php");
$servername=$config['MasterServer']['servername'];
$dbusername=$config['MasterServer']['username'];
$dbpassword=$config['MasterServer']['password'];
$dbname=$config['Database']['dbname'];
$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Can't open connection to MySQL");

mysql_select_db($dbname) or die("Can't select database");


if(isset($bannerid))
{
	$banner = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "banner WHERE id='$bannerid'");
	$url = $banner['url_to_banner'];
	
	$update = $vbulletin->db->query_first("UPDATE " . TABLE_PREFIX . "banner SET views=views+1 WHERE id='$bannerid'");
		
	header("Location:$url");
}
else
	echo	("Please Include an ID!");
?>
Thanks
Reply With Quote
  #4  
Old 11-02-2005, 06:18 PM
Parker Clack Parker Clack is offline
 
Join Date: Oct 2001
Posts: 351
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am having a problem with $bannerid from a link

For example

http://www.mysite.com/click.php?bannerid=50

The click and view files do not see the number 50 and so therefore return the "Please include ID".

Any ideas on what could be happening here?

Thanks,
Parker
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:14 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03606 seconds
  • Memory Usage 2,193KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete