PDA

View Full Version : Profile Enhancements - Invitation System v2.0.2 for vB3.6 and 3.5 series


Hasann
03-04-2008, 10:00 PM
[phpBB] Invitation System by Hasann

This Product brought to you by
www.vBulletin-TR.Com (http://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 (https://vborg.vbsupport.ru/showthread.php?t=171951)

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 :eek:

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.

Big Boss
03-05-2008, 11:40 AM
Looks good so far. I'm gonna have to take a look at it soon. Thanks!

Droptop
03-05-2008, 12:02 PM
Thanks man, I did't know you will make it so fast... Will install it now :)

PinkDaisy
03-05-2008, 12:11 PM
Great! Installed.. :)

Hasann
03-05-2008, 12:19 PM
Looks good so far. I'm gonna have to take a look at it soon. Thanks!

thank you :):up: please just click install

Thanks man, I did't know you will make it so fast... Will install it now :)
I am Speedy Gonsalez :D:up: thank you buddy please just click install ;)
Great! Installed.. :)

thank you very much for your comment! :D

Droptop
03-05-2008, 12:49 PM
**Clicks Install** :up:

iogames
03-05-2008, 08:09 PM
It seems like no problems so far... Installed

thunder_sti
03-05-2008, 09:08 PM
Once they visit the reffer link, it takes them to a page w/many red X's.

Hasann
03-05-2008, 10:02 PM
**Clicks Install** :up:
thank you bro.
It seems like no problems so far... Installed
thanks for installed
Once they visit the reffer link, it takes them to a page w/many red X's.

what do you mean I don't understand you :confused:

EagleNick
03-06-2008, 01:08 AM
Very nice! Works perfect ;)

goranbaxy
03-06-2008, 05:56 AM
this is very nice

tschai
03-06-2008, 11:24 AM
Works like a charm!
Installed and nominated!

Sagol, usta!

Mum
03-07-2008, 05:29 PM
Wonderful! Installed :)

KeyStalker
03-07-2008, 07:07 PM
Had this installed a while back (well anther custom one) but I thank you for releasing this one.

midlandi
03-09-2008, 07:45 PM
Nice and easy, if I can do it anyone can!!!

Mum
03-11-2008, 01:19 AM
Is there any way it can check if the email is already used, before it sends the invite?

droid101
03-11-2008, 01:20 PM
What does "Delete their own invites" mean, anyway? They can ban the people they invited?

Saviour
03-11-2008, 03:12 PM
Can multiple recipients be added to this...or just one at a time? If so...how do you separate the e-mail addresses?

Also...

I really don't think it's a good idea to let any member...or usergroup, for that matter, other than Admins...have the ability to change the text of the e-mail in any shape or form. This is just asking for trouble.

Even though this mod is not supported...I think you should disallow any change to the email text...unless it's usergroup controlled or done through the product's xml install file. Know what I mean?

Who's to say that a spammer, who get's registered on one's forum, or a disgruntled member, will use this feature to send out an e-mail from my forum with inappropriate context.

Although I have installed this mod...I have to limit its use to Staff members until you can address my concerns.

Nice mod, though...

Hasann
03-11-2008, 03:42 PM
Is there any way it can check if the email is already used, before it sends the invite?
that will be added next version ;)
I have to do list. I saved this suggestion first
What does "Delete their own invites" mean, anyway? They can ban the people they invited?
No, that mean which usergroups can delete their sent invites...

Can multiple recipients be added to this...or just one at a time? If so...how do you separate the e-mail addresses?

Also...

I really don't think it's a good idea to let any member...or usergroup, for that matter, other than Admins...have the ability to change the text of the e-mail in any shape or form. This is just asking for trouble.

Even though this mod is not supported...I think you should disallow any change to the email text...unless it's usergroup controlled or done through the product's xml install file. Know what I mean?

Who's to say that a spammer, who get's registered on one's forum, or a disgruntled member, will use this feature to send out an emial from my forum with context not becoming.

Although I have installed this mod...I have to limit its use to Staff members until you can address my concerns.

Nice mod, though...

Now in this version selected usergroups can send just one at a time. But in next version can selected usergroups send multiple invites at a time. And last one will be added in next version usergroups cant edit their invite email text.. :)

thanks guys for your great suggestions... :eek:

Saviour
03-11-2008, 04:02 PM
Something else you may want to look into...

If an Admin is going to allow other usergroups to use this feature...shouldn't it be moderated?

Scenario:

Let's say the Admin has given Registered users permission to use this feature so they can send out one, or multiple, e-mails. Who's to say they're not spamming?

Don't you think it would be better to limit the number of e-mails one can send? Also...wouldn't it be a good idea to view these e-mails before they are actually sent?

I know that I wouldn't want a registered member using this feature to spam another forum's members...or anyone else, for that matter.

I'm not picking this mod apart...I just think there should be certain areas of it that need a little more attention.

I'd actually like to commend you on a mod that has a lot of potential...should these problem areas be addressed.

I look forward to your newest release so that I can give all of our members the ability to use it, so that membership registrations will increase.

Keep up the great work!

raagaswaram
03-12-2008, 12:48 AM
it seems that their is a field in the usergroup it looks blank so assuming it did not install properly

MySQL Error : Unknown column 'invitationpermissions' in 'field list'
Error Number : 1054
Date : Wednesday, March 12th 2008 @ 10:43:37 AM
Script : http://www.tamilthunder.com/forum/admincps/usergroup.php?do=update

Dragons76
03-13-2008, 10:05 PM
nice one but i get this when i click on it

Your invite is either not valid or has already been used

any idea

Dragons76
03-14-2008, 08:31 PM
Nobody can help with this error ??

iogames
03-15-2008, 03:21 PM
Ok... the system works fine in all its functions, but for some reason I can't see the link on 'Edit Profile' or can't place it on NavBar, just on QuickLinks...

What can I do?

p.s. Well I tried to erase old/previous invitations, didn't work

Epic-Phail
03-15-2008, 08:51 PM
You redirect me here and I still get the same db message in my usergroups

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE forum_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderators',
`description` = '',
`usertitle` = 'Moderator',
`opentag` = '<font color=\"blue\">',
`closetag` = '</font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '782847',
`genericpermissions` = '518790799',
`attachlimit` = '0',
`pmquota` = '150',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '15',
`adminpermissions` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '130',
`avatarmaxheight` = '115',
`avatarmaxsize` = '1000000',
`signaturepermissions` = '138495',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`creditpermissions` = '0',
`credit_induction` = '100',
`credit_referral` = '100',
`credit_refbonus` = '0.05',
`credit_paycheck` = '0',
`credit_active` = '20',
`credit_birthday` = '100',
`credit_repgive` = '0.1',
`credit_reputation` = '2',
`credit_infraction` = '-10',
`credit_thread` = '10',
`credit_threadrate` = '1',
`credit_post` = '5',
`credit_ownthreadpost` = '3',
`credit_postsize` = '0.05',
`credit_ownthreadview` = '0.05',
`credit_ownthreadrate` = '1',
`credit_ownthreadreply` = '2',
`credit_ownprofileview` = '0.05',
`credit_pollmake` = '5',
`credit_pollvote` = '1',
`credit_attachment` = '3',
`credit_sendpm` = '-2',
`credit_addevent` = '3',
`credit_addprofpic` = '3',
`credit_profile` = '0',
`credit_donmaxuser` = '-1',
`credit_pastotpost` = '0',
`credit_pastotuser` = '0',
`credit_pasawuser` = '0',
`credit_pasawthread` = '0',
`credit_saveint` = '0.035',
`credit_maxsave` = '10000',
`credit_loanint` = '0.195',
`credit_maxloan` = '1000',
`credit_totloan` = '5',
`credit_goodgroup` = '0',
`credit_midgroup` = '0',
`credit_badgroup` = '0',
`credit_maxtickets` = '10',
`credit_lotdiscount` = '0',
`vbr_per` = '3',
`invitationpermissions` = '0',
`ecdownloadpermissions` = '16383',
`ecexcludecatlist` = '',
`ecdownloadsmaxuploadtotal` = '-1',
`ecdownloadsmaxdailydl` = '-1',
`ecdownloadsmaxdailyfiles` = '-1',
`ecdownloaddelaygrp` = '-1'
WHERE usergroupid=7;

MySQL Error : Unknown column 'invitationpermissions' in 'field list'
Error Number : 1054
Date : Saturday, March 15th 2008 @ 04:50:37 PM
Script : http://epic-phail.com/forum/admincp/usergroup.php?do=update
Referrer : http://epic-phail.com/forum/admincp/usergroup.php?do=edit&usergroupid=7
IP Address : 75.84.154.251
Username : Riot
Classname : vB_Database

iogames
03-15-2008, 10:49 PM
Uninstalled and waiting for a more complete version :(

l0streflecti0n
03-16-2008, 02:53 AM
edit ... not sending invite .. tried to send to 2 diff emails

ivanstanchev
03-17-2008, 04:37 PM
Works 10x

Dragons76
03-19-2008, 05:10 PM
I am under VB 3.6.8

When I send an invitation to an address mail other than mine (that recorded in my forum), the message does not arrive on limps her mail given.

MrD3SAi
03-19-2008, 09:44 PM
When will the next version be released? Will include ability to limit # of invites the user can have?

DssCrazy
03-20-2008, 12:20 PM
Does not work bro. when sending user invite it all works ok but when thay click link and reg it does not add to the person referal stat.

DssCrazy
03-20-2008, 12:26 PM
also what is with that stupid note? it says (note if you see this then their is somthing wrong with your referal link? it even says it in your pic so it can't be somthing we are doing wrong
Thanks

atlambros83
03-20-2008, 03:05 PM
istalled but does not show in the left menu of the usercp for me haven't tested it yet but it looks nice. :-) lol

atlambros83
03-20-2008, 03:12 PM
tested it, referral system does not work. how can i edit the rest of what the email says? like the note: if you see this then their is somthing wrong with your referal link and i'd like to change where it says "from the home page team" and insert the website name or something else.

atlambros83
03-20-2008, 03:18 PM
sorry for the triple post here but also it does not show that the invitation has been accepted where it shows invitations sent. i'm sure it has to do with the referral system not working.

DssCrazy
03-20-2008, 06:26 PM
tested it, referral system does not work. how can i edit the rest of what the email says? like the note: if you see this then their is somthing wrong with your referal link and i'd like to change where it says "from the home page team" and insert the website name or something else.Nice bro you ecplained it all for me. everything i wanted to say you said thanks lol

noj75
03-21-2008, 05:37 AM
Can multiple recipients be added to this...or just one at a time? If so...how do you separate the e-mail addresses?

Also...

I really don't think it's a good idea to let any member...or usergroup, for that matter, other than Admins...have the ability to change the text of the e-mail in any shape or form. This is just asking for trouble.

Even though this mod is not supported...I think you should disallow any change to the email text...unless it's usergroup controlled or done through the product's xml install file. Know what I mean?

Who's to say that a spammer, who get's registered on one's forum, or a disgruntled member, will use this feature to send out an e-mail from my forum with inappropriate context.

Although I have installed this mod...I have to limit its use to Staff members until you can address my concerns.

Nice mod, though...

An Easy little fix for this could be:

Edit template > invite_usercp

Find:

<textarea name="message" rows="10" cols="50" wrap="nowrap" style="width:$stylevar[messagewidth]">$invitemessage</textarea>


Replace With:

<textarea readonly="readonly" name="message" rows="10" cols="50" wrap="nowrap" style="width:$stylevar[messagewidth]">$invitemessage</textarea>



Just add a simple "readonly" to the form. Yes or no?

Regards

surfjunkey
03-24-2008, 01:46 AM
awesome :) Installed and cheers great Job !!

Rideharder
03-24-2008, 03:10 AM
SWEET THANKS! From http://speedaholic.net

Dragons76
03-24-2008, 04:59 AM
I am under VB 3.6.8

When I send an invitation to an address mail other than mine (that recorded in my forum), the message does not arrive on limps her mail given.

Epic-Phail
03-24-2008, 07:20 AM
it seems that their is a field in the usergroup it looks blank so assuming it did not install properly

MySQL Error : Unknown column 'invitationpermissions' in 'field list'
Error Number : 1054
Date : Wednesday, March 12th 2008 @ 10:43:37 AM
Script : http://www.tamilthunder.com/forum/admincps/usergroup.php?do=update

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

Dragons76
03-25-2008, 04:58 PM
I am under VB 3.6.8

When I send an invitation to an address mail other than mine (that recorded in my forum), the message does not arrive on limps her mail given.

No body can help me !!

apiasto
03-25-2008, 08:47 PM
kool n easy thnx

brfrankl
03-31-2008, 07:37 AM
Would really like to see the ability for the admin to see and manage all invites that the users have created (so the admins can delete invites by username or something like that) Also, woul dbe nice if they expired

theparentpack
03-31-2008, 08:42 AM
Installed! Nominated!!!

bobbaf3nn
04-01-2008, 02:51 PM
The screnshots of the ACP are in a different language, is there an english version available?

Saviour
04-01-2008, 04:50 PM
On the Invitation screen, at the bottom there is a list of invitations sent.

I was testing the "Delete" feature. I clicked the link to delete the invitation, it lets me know the invitation was deleted, but the invitation is still listed at the bottom of the page.

I see you have a similar mod for vBulletin 3.7...which is still BETA, and you're supporting that mod, but not this one. Why is that? Most vbulletin users are using 3.6.9 and older.

It would be nice if you could at least reply to some of the questions being asked here...

BTW...noj75...

Thanks for the code edit...works like a charm!

mahsazn
04-04-2008, 01:00 AM
The screnshots of the ACP are in a different language, is there an english version available?
u mean Eng. version for screen shots? (the product is in english and u can chang it to any language manually)

ProAzn
04-04-2008, 05:49 PM
I'm on vbulletin 3.6.8. Doesn't work. Send to various emails and nothing show up. Argh!

I see other people have same problem. No one answering??

ProAzn
04-04-2008, 06:29 PM
Is the email sent asap or is there a delay? It doesnt send immediately or at all. Anyone else have same thing happen?

Hasann
04-06-2008, 05:48 PM
upgraded to Invitation System v2.0.2

- Changes since v1.0.4


no more need to double click on the invitation link
invitationcode cookie gets removed once the user has signed up
account verification after signup isn't blocked by an invalid invitation error code anymore
deletions of invites now delete the correct invite
added permissions check when trying to delete an invitation
if a user deletes an unclaimed invite, he gets one invite back
you cannot sent multiple invites to the same email address
you cannot sent invites to already registered email addresses
added no invites sent message to usercp tepmplate
changed some phrases to proper English (hope so)
added some additional phrases
numerous misspells in the body text of the invitation fixed
the body text hardcoded that users can't change it
also there are phrases for subject and bodytext, so you can use translations.
the users can attach a note message to the invite email
Fixed SQL injection vulnerabilities throughout the code.
Referrer ID ist not overwritten by 1 for every new user.
Removed one query when user is verifying his email address.
Some adjustments for supporting the Inviation System and the normal registration method at the same time.
Added missing closing form tag
The Used Invitation table displays the phrase no_invites_sent when no invitation were sent out
The description box only appears if a description is defined in admincp
Removed the nested div panels to make the look consistent with the rest of usercp
Switched from forumwidth to formwidth_usercp to make the look consistent with the rest of usercp
Removed Login information beside the email address input field to make the look consistent with the rest of usercp
Removed all uneeded tables because the divs are already doing the layout.
Removed all unneeded nested div tags
Added 100% width to table title
Delete invitation column is only visible if you have permission to delete invitations.
when checking for already registered member there is now an additional phrase for distinguishing between registered and invited members (reqested by Alfa1)
added on option to display the invitation code as a link again (requested by Alfa1)
remove the "click two times" message from the invitation email phrase. That's not needed anymore.
changed "mysql_real_escape_string" to "$db->escape_string"

iogames
04-06-2008, 06:29 PM
Thanks Hassan I know/notice that you're always busy, but I really like/need this and will install again! :D:D:D

Saviour
04-06-2008, 07:38 PM
Installed and allowed overwrite of product...made template changes as well. Edited the options through vbulletin options to allow specific usergroups to use the invitation system using comma separated values.

The links appear in Quick Links, as well as the User CP, however...I have no access to use the invitation system. I keep getting redirected to the no access error page.

Something's not kosher in Denmark, here.

Any suggestions?

Hasann
04-06-2008, 07:39 PM
please uninstall v1.0.4 on your forum and re-install the new version 2.0.2 xml file into via product manager

Garyk
04-06-2008, 07:49 PM
I get a database error when trying to invite someone

Saviour
04-06-2008, 08:06 PM
please uninstall v1.0.4 on your forum and re-install the new version 2.0.2 xml file into via product manager


Okay...done.

I now have access to the Invitation system...however, the Invitation system does not show the user the text of the message being sent, so if they add additional text...they will not know what other content is being sent...other than what they, themselves, have typed.

Also...Human verification is not working...

Is this the same as image verification? If it is, I have it enabled, but the message is being sent without verification.

Suggestions?

Saviour
04-06-2008, 08:58 PM
Actually...the Human Verification Manager is a 3.7 feature...and not for 3.6.8 PL2.

So you may want to update this mod...again...so that we can use Image Verification with this mod. You may also want to update the information in the Admin CP, as well, so that this doesn't confuse everyone.

mahsazn
04-06-2008, 10:20 PM
please uninstall v1.0.4 on your forum and re-install the new version 2.0.2 xml file into via product manager
it couldn't use it, so i uninstalled the new version and reinstalled the old one... my problem was with temp edition in USERRCP_SHELL ... the phrase didn't appear in user cp!

DssCrazy
04-06-2008, 11:31 PM
upgraded to Invitation System v2.0.2

- Changes since v1.0.4


no more need to double click on the invitation link
invitationcode cookie gets removed once the user has signed up
account verification after signup isn't blocked by an invalid invitation error code anymore
deletions of invites now delete the correct invite
added permissions check when trying to delete an invitation
if a user deletes an unclaimed invite, he gets one invite back
you cannot sent multiple invites to the same email address
you cannot sent invites to already registered email addresses
added no invites sent message to usercp tepmplate
changed some phrases to proper English (hope so)
added some additional phrases
numerous misspells in the body text of the invitation fixed
the body text hardcoded that users can't change it
also there are phrases for subject and bodytext, so you can use translations.
the users can attach a note message to the invite email
Fixed SQL injection vulnerabilities throughout the code.
Referrer ID ist not overwritten by 1 for every new user.
Removed one query when user is verifying his email address.
Some adjustments for supporting the Inviation System and the normal registration method at the same time.
Added missing closing form tag
The Used Invitation table displays the phrase no_invites_sent when no invitation were sent out
The description box only appears if a description is defined in admincp
Removed the nested div panels to make the look consistent with the rest of usercp
Switched from forumwidth to formwidth_usercp to make the look consistent with the rest of usercp
Removed Login information beside the email address input field to make the look consistent with the rest of usercp
Removed all uneeded tables because the divs are already doing the layout.
Removed all unneeded nested div tags
Added 100% width to table title
Delete invitation column is only visible if you have permission to delete invitations.
when checking for already registered member there is now an additional phrase for distinguishing between registered and invited members (reqested by Alfa1)
added on option to display the invitation code as a link again (requested by Alfa1)
remove the "click two times" message from the invitation email phrase. That's not needed anymore.
changed "mysql_real_escape_string" to "$db->escape_string"


Nice Work!!!

DssCrazy
04-07-2008, 12:36 AM
Where do you set how many invites members can have it is set to 10 and don't have a clue how to change. also in the user cp in the left colume i don't see the option to click invite user is this normal? i now see it at the top of user cp page.

Thanks

DssCrazy
04-07-2008, 01:11 AM
Can you add the option in the email so that if the user that gets the invite does not want to join thay can click a link and denie?

DssCrazy
04-07-2008, 01:17 AM
what is the USERCP_SHELL Template for?

thedudleys
04-07-2008, 01:23 AM
we have installed this new update, but when you go to yourself, it denies you access, unless i missed something since we used this on a different template and it doesn't have the:
$template_hook[usercp_main_pos1]

so we added this the best way, and the system has us as allowed to access it(usergroup 6) but still locks us out.

how can we adjust this...our code has "$template_hook[usercp_navbar_bottom]" so i added it after that and it doesn't allow us to get into the system.

how can we get this fixed?

megawelle
04-07-2008, 06:06 AM
I get a database error when trying to invite someone


I also do. The error ist as follows:

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

MySQL-Fehler : Unknown table 'user' in field list

Saviour
04-07-2008, 10:34 AM
we have installed this new update, but when you go to yourself, it denies you access, unless i missed something since we used this on a different template and it doesn't have the:
$template_hook[usercp_main_pos1]

so we added this the best way, and the system has us as allowed to access it(usergroup 6) but still locks us out.

how can we adjust this...our code has "$template_hook[usercp_navbar_bottom]" so i added it after that and it doesn't allow us to get into the system.

how can we get this fixed?

This was addressed a few posts back...

Try uninstalling and re-installing the product.

droid101
04-07-2008, 12:34 PM
Where do you set how many invites members can have it is set to 10 and don't have a clue how to change. also in the user cp in the left colume i don't see the option to click invite user is this normal? i now see it at the top of user cp page.

Thanks

This can be set when looking at a specific user option page.

This isn't optimal... I was hoping there would be a way to make it infinite use for everyone. But to do this it looks like I'd have to go through each user one by one and set it, since there is no option in the Usergroup Manager.

Is this intentional?

Saviour
04-07-2008, 03:01 PM
Hassan...

Are you working on the Image Verification fix for this mod? The Human Verification Manager you refer to for this mod is for 3.7 and not 3.6.x. The Human Verification Manager is also referred to in the Admin CP, so that will need to be addressed for those who are still using 3.6.x., as well.

Hope to hear back from you soon on this one...

Hasann
04-07-2008, 03:41 PM
yes im working yet fixing bugs and adding new features

abmm
04-07-2008, 05:50 PM
yes im working yet fixing bugs and adding new features

The top feature would be to limit specific usergroups to x amount of invites. Say usergroup 1 has only 2 invites each, while usergroup 2 has 5 invites each (etc etc). Also, allowing the Administration/Staff access to view all of the invites that are being sent.

:)

Hasann
04-07-2008, 06:12 PM
The top feature would be to limit specific usergroups to x amount of invites. Say usergroup 1 has only 2 invites each, while usergroup 2 has 5 invites each (etc etc). Also, allowing the Administration/Staff access to view all of the invites that are being sent.

:)

yeah that's great suggestions I will make these suggestions buddy

abmm
04-07-2008, 08:13 PM
yeah that's great suggestions I will make these suggestions buddy

Thanks man, this is a great add-on ;) and with a few simple modifications - like the ones I listed above, this will be one of the best add-on's to come out for VB in a while :)

mahsazn
04-07-2008, 09:01 PM
öneri : let users to chose (write) email sender display name... since usually the receivers don't know our usernames in forums...

nyqnzguju
04-07-2008, 10:57 PM
Dont See UserCp Option On Left Side..

As This Screenshot:
https://vborg.vbsupport.ru/attachment.php?attachmentid=78284&d=1207409366

cardealercheck
04-08-2008, 11:42 PM
The top feature would be to limit specific usergroups to x amount of invites. Say usergroup 1 has only 2 invites each, while usergroup 2 has 5 invites each (etc etc). Also, allowing the Administration/Staff access to view all of the invites that are being sent.

:)


This is definitely one of the top updates I would love to see for this :up:

iogames
04-11-2008, 11:30 PM
yes im working yet fixing bugs and adding new features

then I will wait

theparentpack
04-12-2008, 07:15 AM
Is there any way for us to increase the # of invites our users can send where we don't have to go into each users accounts to change it one by one?

deus83
04-12-2008, 05:10 PM
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.

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 vb37user
LEFT JOIN vb37invitation
ON user.userid = invitation.acceptedby OR user.userid = invitation.email
WHERE user.email = 'deus@badenudist.dk'
OR invitation.email = 'deus@badenudist.dk';

MySQL Error : Unknown column 'user.userid' in 'field list'
Error Number : 1054
Date : Saturday, April 12th 2008 @ 07:03:13 PM
Script : http://censored.net/profile.php
Referrer : https://censored.net/profile.php?do=invitation
IP Address : 80.162.xxx.xxx
Username : Deus
Classname : vB_Database

Suggestions ?

shoaib
04-16-2008, 03:22 AM
now my invitation system is not working,

i have followed all the all the mentioned steps,

but its not working now.......

Mum
04-22-2008, 06:50 AM
I had this installed but had to uninstall it. It puts a link in my navbar, which i don't want, i want it in the Quick Links, how can i move this?

b65ran
04-22-2008, 10:40 PM
I am getting the same database errors after updating. Is there any fix for that yet ?

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 XXXXXXuser
LEFT JOIN XXXXXXinvitation
ON user.userid = invitation.acceptedby OR user.userid = invitation.email
WHERE user.email = 'xxxx@gmail.com'
OR invitation.email='xxx@gmail.com';

MySQL Error : Unknown table 'user' in field list
Error Number : 1109
Date : Tuesday, April 22nd 2008 @ 06:10:51 PM
Script : http://www.banglatorrents.com/profile.php
Referrer : http://www.banglatorrents.com/profile.php?do=invitation
IP Address : XX.XX.XXX.XXX
Username : XXXXX
Classname : vB_Database

DssCrazy
04-23-2008, 04:11 AM
also if you go to your admincp and del a user on the page that says: Deleted user successfully. on the top you will get this error

includes/class_dm_user.php(1843 : eval()'D code on line 14

Can you fix?

Thanks

NNJJ
04-23-2008, 05:08 AM
I had to uninstall and reinstall the old one its working

socalrico
04-23-2008, 07:19 PM
Hassan,

which directions do I follow. the one posted on the VBulletin.org site or the html page in the download. I found that the 2 directions have different content.

xplan2007
04-24-2008, 04:13 AM
->Do template edits:
In USERCP_SHELL Template Find this Code

I cannot find and edit for what.

I edit only in
In USERCP Template Find this Code

and it works

Hell Fox
04-24-2008, 01:04 PM
This does not work, I install it and I get this SQL error:
SELECT user.userid AS user_id, user.email AS user_email, invitation.email AS inv_email, invitation.acceptedby as inv_id

BadgerDog
04-24-2008, 03:05 PM
Installed... thanks ... :)

I'm a little confused though....

How does the user know what the default "invitation_email_body" text is? When they click to invite someone, they see the field for the email address and a large blank field to customize the message. Is the custom message below supposed to show up in the box as the default? If so, on my system it doesn't... :confused:

$vbphrase[invitation_email_body]
Text Hello there; This invitation was sent to you by {1}

You have been invited to join the {2} forums.
To sign up please visit the following page.

{4}/register.php?referrerid={5}&invitation={6}

{3}

Thank you, The {2} Team..

Regards,
Badger

Never mind... figured it out. It's a message box that ADDS personal comments to the standard message that the user doesn't see. I've changed the message talking about the user's real name etc., which better explains it.

NNJJ
04-24-2008, 07:53 PM
link in vBadvanced CMPS v3.0.0
is wrong path missing /forum
how to fix it

RedTrinity
04-24-2008, 11:57 PM
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.

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 vb37user
LEFT JOIN vb37invitation
ON user.userid = invitation.acceptedby OR user.userid = invitation.email
WHERE user.email = 'deus@badenudist.dk'
OR invitation.email = 'deus@badenudist.dk';

MySQL Error : Unknown column 'user.userid' in 'field list'
Error Number : 1054
Date : Saturday, April 12th 2008 @ 07:03:13 PM
Script : http://censored.net/profile.php
Referrer : https://censored.net/profile.php?do=invitation
IP Address : 80.162.xxx.xxx
Username : Deus
Classname : vB_Database

Suggestions ?

We are getting the same error, though our copy was never upgraded - Fresh install of latest 3.6 version.

Have disabled it until a fix is released :)

karabaja3
04-25-2008, 05:23 PM
hi there.

this Product is not working on v3.6.10.

Any upgrades soon?

iogames
04-29-2008, 06:37 PM
Yes, I've been waiting on this to close any 'further development' on my board

karthik123
05-06-2008, 04:20 PM
I just installed on 3.6.8. gives me this error:


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'

karthik123
05-06-2008, 04:23 PM
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 am getting the same database errors after updating. Is there any fix for that yet ?

In the query change
FROM XXXXXXuser
LEFT JOIN XXXXXXinvitation
to
FROM XXXXXXuser as user
LEFT JOIN XXXXXXinvitation as invitation

montsa007
05-08-2008, 07:38 AM
clicks installed :p

iogames
05-21-2008, 12:55 AM
Ok I think this is the major hack that I need to add and launch my site...
mr Hasann, any news on the Gold Version of this hack?

Cyborg86
05-24-2008, 04:26 PM
Great mod. Thanks.

adoxtater
06-13-2008, 03:24 PM
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?

In the query change
FROM XXXXXXuser
LEFT JOIN XXXXXXinvitation
to

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):

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.

Seiyaboy
08-07-2008, 02:55 PM
Anyone know if this mod will conflict with the mod vMail (https://vborg.vbsupport.ru/showthread.php?t=162642)?

Thanks a bunch.

Ossedis
08-26-2008, 10:59 AM
Thanks, works like a charm :)

dxlwebs
10-01-2008, 06:46 AM
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?

gentz
11-01-2008, 04:33 AM
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....

LT Mote
12-31-2008, 06:45 AM
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?
04-07-2009, 04:23 PM
Nice Tnx

hawa.ly
10-23-2010, 08:51 PM
You redirect me here and I still get the same db message in my usergroups

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

No body can help me !!

just run this SQL to repair it


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

By : hawa.ly

TEMPESTADE
12-28-2011, 10:34 AM
Tanks bro cooll