View Single Post
  #1  
Old 11-15-2005, 08:41 PM
pyro.699 pyro.699 is offline
 
Join Date: Sep 2005
Location: Fredericton, New Brunswic
Posts: 261
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default [mysql]Easy Question

ok, im making this script, and i thought it was an awesome idea! What it dose, is when ever a user clicks on one of those 'Vote for Us' or 'Top 100' buttons, it first takes them to my script, ad.php, once they click, they are given a random number ( 100-1000 ) points.

heres what i have so far, with the proper crap blocked :P

PHP Code:
<?php
// ### vBulletin Shit ### \\
error_reporting(E_ALL & ~E_NOTICE);
define('NO_REGISTER_GLOBALS'1);
define('THIS_SCRIPT''portal');
$phrasegroups = array();
$specialtemplates = array();
$globaltemplates = array();
$actiontemplates = array();
require_once(
'./global.php');
require_once(
'./includes/functions_bigthree.php');
require_once(
'./includes/functions_forumlist.php');
require_once(
'./includes/class_bbcode.php');
//############################################\\

// Generate the random Number!
srand(time());
$points_add = (rand()%900) + 100;

$current_points $db->query_first("SELECT ucash FROM "TABLE_PREFIX ."user WHERE userid = 1");;

$new_total_points $points_add $current_points;

// **************
if ($_GET['refer'] == '*****_***_***')
{
//Run Query
$db->query_write(
"UPDATE "TABLE_PREFIX ."user
ucash = "
.$new_total_points."
where userid = '" 
$vbulletin->userinfo['userid'] . "'");
//Forward
$vbulletin->url "**************************";
eval(
print_standard_redirect("You have just recieved more $points_add points"falsetrue));
}

//*************
if ($_GET['refer'] == '***_****_*****)
{

//Forward
$vbulletin->url = "*************";
eval(print_standard_redirect("You have just recieved more $points_add points", false, true));
}

//*********
if ($_GET['
refer'] == '*****_*****')
{

//Forward
$vbulletin->url = "***************";
eval(print_standard_redirect("You have just recieved more $points_add points", false, true));
}

?>
now, my problem lies with $current_points and $new_total_points

I have tryed putting a
PHP Code:
echo $current_points 
but, all i get is the word,
Quote:
Originally Posted by ad.php
array
now, with $new_total_points, is it correct? because i tryed adding numbers instaead of variables, and it still dident work!

So, what am i missing, and what do i need?

Thanks!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01105 seconds
  • Memory Usage 1,790KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete