Profile Enhancements - Invitation System v2.0.2 for vB3.6 and 3.5 series

[phpBB] Invitation System by Hasann

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

DESCRIPTION

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

Note: This Hack Does Work For vBulletin Version 3.5 and 3.6 Series

Go For Invitation Hack vBulletin Version 3.7.series

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['invite_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>

In USERCP Template Find this Code

$template_hook[usercp_main_pos1]

Add Below This Code

<if condition="$show['invitation_link']">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>

<td class="tcat">$vbphrase[invitation_system] <if condition="$show['invitation_left']"><phrase 1="$bbuserinfo[invitation]">($vbphrase[invitation_x_left])</phrase></if></td>
</tr>
<tr>
	<td class="alt1"><span class="smallfont"><a href="profile.php?$session[sessionurl]do=invitation">$vbphrase[invitation_click_here_to_invitation_new_users]</a></span></td>
</tr>
</table>
<br />
</if>

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

[LT Mote]

After installing, I get this when I try to send an invitation.

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT user.userid AS user_id, user.email AS user_email, invitation.email AS inv_email, invitation.acceptedby as inv_id
  FROM vb1_user
  LEFT JOIN vb1_invitation
  ON user.userid = invitation.acceptedby OR user.userid = invitation.email
WHERE user.email = 'X'
OR invitation.email = 'X';

MySQL Error  : Unknown column 'user.userid' in 'field list'
Error Number : 1054
Date         : Wednesday, December 31st 2008 @ 03:43:06 AM
Script       : http://forums.DOMAIN.com/profile.php
Referrer     : http://forums.DOMAIN.com/profile.php?do=invitation
IP Address   : 
Username     : 
Classname    : vB_Database

[Alexey?]

Nice Tnx

[hawa.ly]

Originally Posted by Epic-Phail

You redirect me here and I still get the same db message in my usergroups

Originally Posted by Epic-Phail

I get the same error.
Cant create or edit usergroups anymore

Originally Posted by Dragons76

No body can help me !!

just run this SQL to repair it

PHP Code:

ALTER TABLE `usergroup` ADD `invitationpermissions` INT(10) UNSIGNED DEFAULT '0' NOT NULL; 


By : hawa.ly

[TEMPESTADE]

Tanks bro cooll