vb.org Archive
Page 20 of 104 « First 101819 20 21223070 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Profile Enhancements - Invitation System vB 3.7 Gold (https://vborg.vbsupport.ru/showthread.php?t=171951)

Namaless 04-06-2008 05:36 PM
What changes applyed?

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

Thanks for project :)

Vtec44 04-06-2008 05:48 PM
I got a database error with the latest 2.0.2 fixed.

Code:
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 04-06-2008 05:58 PM
hello!

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


regards

macc

Hasann 04-06-2008 06:07 PM
Quote:
Originally Posted by Namaless (Post 1484525)
What changes applyed?

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

Thanks for project :)
Quote:
Originally Posted by Vtec44 (Post 1484544)
I got a database error with the latest 2.0.2 fixed.

Code:
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
Quote:
Originally Posted by macc (Post 1484552)
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 04-06-2008 06:15 PM
Thanks.. fixed now ^^

Regards.

Atilla_UYGUN 04-06-2008 06:19 PM
wooww wanderful mod :)

thanks..


installed.. ;)

Vtec44 04-06-2008 08:12 PM
Quote:
Originally Posted by Hasann (Post 1484561)
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 04-06-2008 08:28 PM
Quote:
Originally Posted by Vtec44 (Post 1484544)
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 04-07-2008 12:37 AM
Yep, that did it. Thanks guys!

NeuroLancer 04-07-2008 03:03 AM
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 :)


All times are GMT. The time now is 05:07 PM.
Page 20 of 104 « First 101819 20 21223070 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02576 seconds
  • Memory Usage 1,758KB
  • 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
  • (2)bbcode_code_printable
  • (4)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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