But in vb3 this character is automatically present but in different way, as when the member is coming for register ,there is a little box for the name of the member whose invites him to join ,
After installing this hack, there will be there a link for every member to invite the members to register, and when the visitor follow the link which received it from the member to register, the little box that ask him about the name of member invited will not appear .
but if the visitor register in the usual way the box will appear.
and off course there will be the numbers of the members that follow the links + the numbers of the members that register with typing the name of member invited
and more than that,
so the number of new members that the member invited them what ever the way of their rigesteration.
and more than that, make a form in the main page to let the member invite the members by his e-mail, and will present the link of the member invited
in main e-mail and in reply
and show the number of referrals in a postbit
and each user can see he link in usercp.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++
Queries >> 0
Files to Modify >> 3
Templates Added >> 1
Templates to Modify >> 5
add a phrases >> 4
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
Invalid SQL: SELECT
COUNT(*) AS count FROM user WHERE referrerid =
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
That's the link you would give them. So you might send out an e-mail with that link in it to a few friends, and when they sign up you'd get a referral point.
Ollie
SnowBot
ya that's true
thank you Pyrix & nexialys
for help me
$refcount = $DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE referrerid =
$post[userid]");
$referrals = vb_number_format($refcount['count']);
Replace it with:
PHP Code:
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid =
$post[userid]");
$referrals = @vb_number_format($refcount['count']);
Invalid SQL: SELECT
COUNT(*) AS count FROM user AS user WHERE user.referrerid =
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Invalid SQL: SELECT
COUNT(*) AS count FROM user AS user WHERE user.referrerid =
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Still getting some DB errors
Any help would be great
try this:
open File: includes/functions_showthread.php
find:
PHP Code:
if ($vboptions['usereferrer'])
{
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid =
$post[userid]");
$referrals = @vb_number_format($refcount['count']);
}
Replace it with:
PHP Code:
if($bbuserinfo['userid']!=0 AND $post['userid']!=0){
if ($vboptions['usereferrer'])
{
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid =
$post[userid]");
$referrals = @vb_number_format($refcount['count']);
}
}
Invalid SQL: SELECT COUNT(*) AS count FROM user AS user WHERE user.referrerid =
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
mysql error number: 1064
Date: Thursday 22nd of July 2004 07:53:18 AM Script: http://www.synergyforums.com/forum/showthread.php?t=1243&highlight=reloaded Referer: http://www.synergyforums.com/forum/search.php?searchid=6700 Username: kritters
if($bbuserinfo['userid']!=0 AND $post['userid']!=0){
if ($vboptions['usereferrer'])
{
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid =
$post[userid]");
$referrals = @vb_number_format($refcount['count']);
}
}
Replace it with:
PHP Code:
if($post['userid']!=0){
if ($vboptions['usereferrer'])
{
$refcount = @$DB_site->query_first("SELECT
COUNT(*) AS count FROM " . TABLE_PREFIX . "user AS user WHERE user.referrerid = '$post[userid]' ");
$referrals = @vb_number_format($refcount['count']);
}
}