vb.org Archive
Page 13 of 50 « First 31112 13 141523 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Referral Statistics (https://vborg.vbsupport.ru/showthread.php?t=64469)

Milktruck 09-18-2004 09:23 AM
Thank you! Installed it perfectly.

*clicked Install*

Jack28 09-22-2004 07:20 PM
Help! i got the follow error:

Code:
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\init.php on line 520

Warning: Invalid argument supplied for foreach() in W:\www\includes\sessions.php on line 270

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\functions.php on line 3622

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in W:\www\includes\functions.php on line 3622

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\functions.php on line 3622

 

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
How can i fix this?

gspot 09-22-2004 11:49 PM
Quote:
Originally Posted by Jack28
Help! i got the follow error:

Code:
Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\init.php on line 520

Warning: Invalid argument supplied for foreach() in W:\www\includes\sessions.php on line 270

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\functions.php on line 3622

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in W:\www\includes\functions.php on line 3622

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\functions.php on line 3622

 

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
How can i fix this?
To me it sounds like your path to your vbulletin forums is not set correctly in my hack files. Please make sure it is. It looks like your path should be this: /www/

etaslim 10-15-2004 11:41 AM
Quote:
Originally Posted by etaslim
Great! Thanks for the help, gspot. It runs perfectly now on my two forums.
Ups, appearently not all :ermm: In one of my forum, the total referrals are not shown. I've rechecked but couldn't found anything wrong. Any idea? Anyway, the address is http://forum.chip.co.id/referals.php

SaN-DeeP 10-15-2004 12:46 PM
i re-uploaded all the files, did all the edits once again,
but still getting this error :

Code:
Database error in vBulletin 3.0.3:
Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM vb3_user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid)
                                  WHERE user.userid > 0
                                  GROUP BY users.referrerid
                                  ORDER BY referrals DESC
                                  LIMIT 10
mysql error: Table 'sanp_faS3.user' doesn't exist
mysql error number: 1146
Date: Friday 15th of October 2004 01:45:21 PM
Script: http://forums.tech-arena.com/referrals.php
Referer:
Username: SaN-DeeP

Boofo 10-15-2004 01:01 PM
That's because you have a table prefix. You need to add . TABLE_PREFIX . before each table. ;)

SaN-DeeP 10-15-2004 01:30 PM
Quote:
Originally Posted by Boofo
That's because you have a table prefix. You need to add . TABLE_PREFIX . before each table. ;)
I am confused boofo, Can you help fixing the table prefix in this code ?
Code:
  <?php
////////////////////////////////////////////////////////
//Referral Statistics// Created By: G-Spot//////////////
////////////////////////////////////////////////////////
///////////////www.gspotracing.com//////////////////////
////////////////////////////////////////////////////////
// INSTRUCTIONS:
// Change the $max variable to show how many results you want.
////////////////// OPTIONAL REFERRAL RESULTS ///////////
// You can limit your referral results to certain usergroups,
// by adding the following under each query after the WHERE clause's:
// AND user.usergroupid=2 -->
// this number will be different for different user groups. To find
// the usergroup number login to your admincp and click on usergroup
// manager and next to the usergroups you should see something close
// to: edit usergroup(id:2) where the 2 is the usergroup number.
///////////////////////////////////////
//////////////////////////////////////////////
//////////////////////////////////////////////////////
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'referrals');
// ################### PRE-CACHE TEMPLATES AND DATA ######################
$globaltemplates = array('refer','referbit','navbar');
// ######################### REQUIRE BACK-END ############################
chdir('/path/to/vbulletin/forums/');//edit path to your vbulletin directory
require('./global.php');
// ######################### NAVIGATION ############################
$navbits = array();
$navbits[$parent] = 'Referral Statistics';
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
// #####################################################
// #####################################################
// ######################### START MAIN SCRIPT #########
// ##################################################### 
// START REFERRAL STATISTICS SCRIPT //
//GET TOTAL REFERALS//
$gettotal = $DB_site->query("SELECT COUNT(*) FROM " . TABLE_PREFIX . "user
                                          WHERE referrerid > 0");
$total=mysql_fetch_row($gettotal);
// END TOTAL REFERALS //
// GET LAST DATE RESET //
$lastreferals=$DB_site->query("SELECT date FROM " . TABLE_PREFIX . "referrals");
$lastcount = mysql_fetch_row($lastreferals);
if ($lastcount == ''){
$lastcount[0]="(No Reset Record Found!)";
}
// END LAST DATE RESET //
$max=10; //This number decides how many results to display
$referrers = $DB_site->query("SELECT COUNT(*) AS referrals, user.username, user.userid FROM " . TABLE_PREFIX . "user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid)
                                  WHERE user.userid > 0
                                  GROUP BY users.referrerid
                                  ORDER BY referrals DESC
                                  LIMIT $max");
while ($referrer=$DB_site->fetch_array($referrers)) {
  $referreds = $DB_site->query("SELECT username FROM " . TABLE_PREFIX . "user WHERE referrerid = '$referrer[userid]' AND referrerid > 0");
  while ($referred = $DB_site->fetch_array($referreds)){
        $enc_username = urlencode($referred[username]);
        if ($referrerlist) {
          $referrerlist .= ", <A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>";
        } else {
          $referrerlist .= "<A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>";
        }
  }
  eval("\$referbits .= \"".fetch_template("referbit")."\";");
  $referrerlist="";
}
eval('print_output("' . fetch_template('refer') . '");');
?>
Regards,

gspot 10-15-2004 10:17 PM
San-Deep

Do you see this line in my configuration file that you posted above:
chdir('/path/to/vbulletin/forums/');//edit path to your vbulletin directory

- You need to edit this path to reflect your forums directory and then try it.
- try this first.

SaN-DeeP 10-17-2004 07:29 AM
Quote:
Originally Posted by gspot
San-Deep

Do you see this line in my configuration file that you posted above:
chdir('/path/to/vbulletin/forums/');//edit path to your vbulletin directory

- You need to edit this path to reflect your forums directory and then try it.
- try this first.
tried to change the path too, but dont work :(

gspot 10-19-2004 06:22 AM
Its trying to load this table from mysql: "sandeep_f1nalDbaS3.user" does this table even exist? Please check your table extension that your using against your database tables in your mysql.


All times are GMT. The time now is 06:23 PM.
Page 13 of 50 « First 31112 13 141523 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01372 seconds
  • Memory Usage 1,761KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete