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

Page 3 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Profile Enhancements - Invitation System v2.0.2 for vB3.6 and 3.5 series (https://vborg.vbsupport.ru/showthread.php?t=172157)

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

Quote:

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

I cannot find and edit for what.

I edit only in

Quote:

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:

Quote:

$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

Quote:

Originally Posted by deus83 (Post 1489176)

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:

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'

karthik123

05-06-2008 04:23 PM

Quote:

Originally Posted by deus83 (Post 1489176)

Quote:

Originally Posted by b65ran (Post 1496904)

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

Code:

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

Quote:

Originally Posted by deus83 (Post 1489176)

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 (Post 1510657)

In the query change

Code:

FROM XXXXXXuser

LEFT JOIN XXXXXXinvitation

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.

Seiyaboy

08-07-2008 02:55 PM

Anyone know if this mod will conflict with the mod vMail?

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.

Code:

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

Quote:

Originally Posted by Epic-Phail (Post 1465664)

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

Quote:

Originally Posted by Epic-Phail (Post 1473089)

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

Quote:

Originally Posted by Dragons76 (Post 1474330)

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

12-28-2011 10:34 AM

Tanks bro cooll

All times are GMT. The time now is 10:07 PM.

Page 3 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01271 seconds Memory Usage 1,786KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (1)bbcode_php_printable (11)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (24)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: