Version: 1.0.1, by King Kovifor
Developer Last Online: Aug 2015
Category: Profile Enhancements -
Version: 3.7.x
Rating:
Released: 04-26-2008
Last Update: 04-27-2008
Installs: 202
Uses Plugins
Translations
No support by the author.
Introduction
This modification acts somewhat like Myspace. When you register on Myspace, the creator of Myspace (Tom) is automatically added as a friend (mutually). This acts the same way on your forum by adding any number of users (user IDs required) to the new users friend list. This is completely mutual, but now has the option to be a non-mutual friendship.
i upgraded to 3.7.0 today, but i am still getting a error that i think is caused by this mod...
Code:
Database error in vBulletin 3.7.0:
Invalid SQL:
INSERT INTO userlist (userid, relationid, type, friend) VALUES (, 1, 'buddy', 'yes');
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 'buddy', 'yes')' at line 1
Error Number : 1064
Request Date : Tuesday, April 29th 2008 @ 01:11:23 PM
Error Date : Tuesday, April 29th 2008 @ 01:11:23 PM
Script : http://www.site.com/forums/register.php?do=activate
Referrer : http://www.site.com/forums/register.php?a=ver
IP Address : IP HERE
Username : USERNAME-HERE
Classname : vB_Database
MySQL Version :
i upgraded to 3.7.0 today, but i am still getting a error that i think is caused by this mod...
Code:
Database error in vBulletin 3.7.0:
Invalid SQL:
INSERT INTO userlist (userid, relationid, type, friend) VALUES (, 1, 'buddy', 'yes');
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 'buddy', 'yes')' at line 1
Error Number : 1064
Request Date : Tuesday, April 29th 2008 @ 01:11:23 PM
Error Date : Tuesday, April 29th 2008 @ 01:11:23 PM
Script : http://www.site.com/forums/register.php?do=activate
Referrer : http://www.site.com/forums/register.php?a=ver
IP Address : IP HERE
Username : USERNAME-HERE
Classname : vB_Database
MySQL Version :
ideas?
this error was emailed to me btw
Um... It seems like the user id is not added into the query. I guess $userid isn't available. Thanks for letting me know...
Quote:
Originally Posted by GoTTi
and also, the new users that registered today were not added to my list.
i have removed the mod. i am waiting for the fix for that error. do you want me to reinstall the mod and see if it duplicates? when will you be releasing the fixed version
i have removed the mod. i am waiting for the fix for that error. do you want me to reinstall the mod and see if it duplicates? when will you be releasing the fixed version
Sorry to hear that, but I will be able to fix starting tomorrow. But I will be able to do it...
Quote:
Originally Posted by GoTTi
ok when i click to activate account, i get taken to /register.php?a=act&u=486&i=XXXXX and i see that error again.
"Make This A Mutual Friendship" is set to yes.
Thanks for the information. I guess that $userid isn't used within the validation code. I need to look into the userid variable that is used by default vBulletin code.