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
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT user.userid AS user_id, user.email AS user_email, invitation.email AS inv_email, invitation.acceptedby as inv_id
FROM vb_user
LEFT JOIN vb_invitation
ON user.userid = invitation.acceptedby OR user.userid = invitation.email
WHERE user.email = 'someone@gmail.com'
OR invitation.email = 'someone@gmail.com';
MySQL Error : Unknown column 'user.userid' in 'field list'
Error Number : 1054
That makes sense, 'user.userid' is an unknown column becuase the query isn't 'from vb_user as user left join vb_invitation as invitation'
Had a minor problem with the first release. It kind of made an error when they where completing their registration, so we thought we could fix it by upgrading with this new version. Only made it worse... This is what we get as soon as one tries to invite a player to the site.
Suggestions ?
Quote:
Originally Posted by b65ran
I am getting the same database errors after updating. Is there any fix for that yet ?
In the query change
Code:
FROM XXXXXXuser
LEFT JOIN XXXXXXinvitation
to
Code:
FROM XXXXXXuser as user
LEFT JOIN XXXXXXinvitation as invitation
Had a minor problem with the first release. It kind of made an error when they where completing their registration, so we thought we could fix it by upgrading with this new version. Only made it worse... This is what we get as soon as one tries to invite a player to the site.
Suggestions ?
I had this SAME EXACT issue. Seems that many of us had the same issue. Can the developer please respond?
Quote:
Originally Posted by karthik123
In the query change
Code:
FROM XXXXXXuser
LEFT JOIN XXXXXXinvitation
to
Code:
FROM XXXXXXuser as user
LEFT JOIN XXXXXXinvitation as invitation
I tried this fix and it got me a bit further along, but I'm still getting errors. Here's the new one (my prefix is sg_ so that part is valid):
Code:
Invalid SQL:
SELECT * FROM sg_invitation
WHERE invitation.email = 'myemail@myemailhost.com'
AND invitation.acceptedby = 0
AND invitation.accepted = 0;
MySQL Error : Unknown column 'invitation.email' in 'where clause'
Error Number : 1054
Date : Friday, June 13th 2008 @ 12:21:23 PM
Script : http://shredguitars.com/profile.php
Referrer : http://shredguitars.com/profile.php
IP Address : 205.159.86.10
Username : CaptainClaw
Classname : vb_database
Does anyone know of any other invitation systems out there or is this the only one? It looks really promising but it's not working out of the box so I'm interested in trying some other alternatives.
when i send a invitation i get this Your submission could not be processed because a security token was missing or mismatched. any one know how to fix it?
i guess support to this is dead...........same error as post number 92.93 and 97..............we need this working as this is a great hack too bad the gold version is only for 3.7.0 and up....
Invitation System v2.0.2 for vB3.6 and 3.5 series Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
05-06-2008, 04:20 PM
