Profile Enhancements - Invitation System vB 3.7 Gold

Invitation System by HASANN

This Product brought to you by
www.vBulletin-TR.Com

Comments, suggestions, translations, bugs, etc... are very welcome! Support is only given to people who have clicked INSTALL.

DESCRIPTION

->What does it? > Allow users send invites to everybody.

Go For Invitation Hack vBulletin Version 3.5 and 3.6.series

DEMO

you can test it at here http://www.vbulletin-tr.com/forum/pr...ation&langid=1

FEATURES

• complete code rewrited
• Included a user referrer code to invite code, so when they sign up, it shows up who referred them.
• Now users can delete their invites
• Invitation Image Verification Added
• The system can be turned on and off.
• Usergroups Permissions Added; Allowed Usergroups to View and to Use This Hack
• Invitation User Control Panel Link; Show Invitation Link in "User Control Panel" Left Menu
• Invitation Automatic Link Creation; This will create a link on your forum navbar to the invitation page
• Usergroups Permissions Added
• fully phrased
• added an admin option disable registration via normal methods
• added an admin option which usergroups can to delete their invites
• added an admin option enable disable invitation image verification
• added an admin option Edit the Email Text Title
• added an admin option Edit the Invite Description
• added Invitation Sender Username to Email
• integrated the totally vBulletin default Human Verification System into Invitation System
  
  You decide it if you wich human verification system will be used in the invitation system go to Admincp > Human Verification Manager > and select one human verification if you want.
  
• these are;
• Image Verification
• An image consisting of letters in varying fonts/shapes/sizes will be shown to the user. The appearance of this image is dicated by several options that you may control.
  
• Question and Answer Verification
• Questions provided by you that must be answered appropriately for verification.
  
• reCAPTCHA Verification
• An image containing two words will be shown to the user. This verification supports audio, allowing blind users to register.
  
• Added Invitation User Options
• a> Ability to limit number of invites by user. (user: Admin an have 10 invites, user: Testuser can have 20, etc, admin controlled)
• b> Ability to reset invites to 0 on a per user basis (override), admin controlled
• c> Ability to reset to max being unused, admin controlled
• d> Abilitiy turn to on or off Invitation System per user basis, admin controlled

INSTRUCTIONS
Install: ->Just Import product_invitation.xml via Product Manager

->Do template edits:
In USERCP_SHELL Template Find this Code

<if condition="$show['profilepiclink']">
	<tr><td class="$navclass[profilepic]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=editprofilepic">$vbphrase[edit_profile_picture]</a></td></tr>
	</if>

Add Below This Code

<if condition="$vbulletin->options['invitation_usercp_link']">
<tr>
<td class="$navclass[invitation]" nowrap="nowrap">
<a class="smallfont" href="profile.php?$session[sessionurl]do=invitation">$vbphrase[invitation]</a>
</td>
</tr>
</if>

Comments, suggestions, translations, bugs, etc... are very welcome! Support is only given to people who have clicked INSTALL.

[Namaless]

What changes applyed?

Need upgrade? (I have added more features for hack.. if not necessary waiting to upgrade...)

Thanks for project

[Vtec44]

I got a database error with the latest 2.0.2 fixed.

Database error in vBulletin 3.7.0 Release Candidate 1:

Invalid SQL:
SELECT user.userid AS user_id, user.email AS user_email, invitation.email AS inv_email, invitation.acceptedby as inv_id
 										FROM 600rrforumuser
 										LEFT JOIN 600rrforuminvitation
 										ON user.userid = invitation.acceptedby OR user.userid = invitation.email
										WHERE user.email = 'test@test.com'
										OR invitation.email = 'test@test.com';

MySQL Error   : Unknown column 'user.userid' in 'field list'
Error Number  : 1054
Date          : Sunday, April 6th 2008 @ 02:46:15 PM
Script        : http://www.600rrforum.com/forum/profile.php
Referrer      : http://www.600rrforum.com/forum/profile.php?do=invitation
IP Address    : 69.110.135.166
Username      : Vtec44
Classname     : vB_Database
MySQL Version : 5.0.45-log

[macc]

hello!

can somebody tell us what should we install and which changes to do ... ?


regards

macc

[Hasann]

Originally Posted by Namaless

What changes applyed?

Need upgrade? (I have added more features for hack.. if not necessary waiting to upgrade...)

Thanks for project

Originally Posted by Vtec44

I got a database error with the latest 2.0.2 fixed.

Database error in vBulletin 3.7.0 Release Candidate 1:

Invalid SQL:
SELECT user.userid AS user_id, user.email AS user_email, invitation.email AS inv_email, invitation.acceptedby as inv_id
 										FROM 600rrforumuser
 										LEFT JOIN 600rrforuminvitation
 										ON user.userid = invitation.acceptedby OR user.userid = invitation.email
										WHERE user.email = 'test@test.com'
										OR invitation.email = 'test@test.com';

MySQL Error   : Unknown column 'user.userid' in 'field list'
Error Number  : 1054
Date          : Sunday, April 6th 2008 @ 02:46:15 PM
Script        : http://www.600rrforum.com/forum/profile.php
Referrer      : http://www.600rrforum.com/forum/profile.php?do=invitation
IP Address    : 69.110.135.166
Username      : Vtec44
Classname     : vB_Database
MySQL Version : 5.0.45-log

it seems to be you haven't in your database userid field in user table

Originally Posted by macc

hello!

can somebody tell us what should we install and which changes to do ... ?


regards

macc

Invitation_System_Fixed_v2.0.2.zip install this overwrite to old product
there is one change only and it is a sql injection issue it is fixed now

[Namaless]

Thanks.. fixed now ^^

Regards.

[Atilla_UYGUN]

wooww wanderful mod

thanks..


installed..

[Vtec44]

Originally Posted by Hasann

it seems to be you haven't in your database userid field in user table

I'm not sure what you mean, but I reverted back to 2.0.2 and it works. When I upgrade to 2.0.2b then I get that error. It doesn't matter if I uninstall the product first or install on top of the 2.0.2 and let it overwrite, I still get that error.

[Scythe42]

Originally Posted by Vtec44

I got a database error with the latest 2.0.2 fixed.

I see you are using a tableprefix.

There is an "AS userid" and "AS invitation" missing in the FROM and JOIN clauses to make it work with tableprefixes.

To fix this, open the prodcut-invitation.xml before importing and apply the following changes:

Change line 304 and 305 from:

PHP Code:

FROM " . TABLE_PREFIX . "user
LEFT JOIN " . TABLE_PREFIX . "invitation 


to

PHP Code:

FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "invitation AS invitation 


Change line 320 from:

PHP Code:

$invitationcheck = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "invitation 


to

PHP Code:

$invitationcheck = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "invitation AS invitation 


That should do the trick for your guys using table prefixes. Let me know if this works for you.

[Vtec44]

Yep, that did it. Thanks guys!

[NeuroLancer]

Hi, sorry if this has been posted already but can there be a change from:

(you can add your real name after your username if you wish, but leave the rest unchanged)

because that is no longer valid in the newest version.

Thanks again for this great mod