Previous Thread
Next Thread
Print Thread
Rate Thread
Page 1 of 2 1 2
Joined: Dec 2006
Posts: 1
Lurker
Lurker
Offline
Joined: Dec 2006
Posts: 1
Hello,

There is a mod called FlashChat you can find at www.tufat.com. They have the ability to integrate with UBB.Threads 6.5, but when I try it with UBB.Threads 7.0.2 it doesn't work. Does anyone know how to fix or get around this problem?

Thanks.

Sponsored Links
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
The bridge between the 2 will need to be updated.


- Allen wavey
- What Drives You?
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
I would look to updating/creating one, but I don't have the software; though I have purchased their family tree like 2 years ago lol


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
They did an update that is supposed to work for UBBT 7.1, but it has a bug in it somewhere as it isn't working.

Here is the error message I receive when trying to access the Flashchat Control Panel:

Quote

Fatal error: Call to a member function on a non-object in /home/virtual/site5/fst/var/www/html/forums/chat/inc/cmses/ubb71CMS.php on line 82
Does anybody have any ideas on how to correct this?


Daryl Fawcett
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
I just upgraded mine to the latest build, i'll poke around a bit later though.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Sponsored Links
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
found the issue, the table "USERS" was being referanced as "users"; a fix:
Find:
Code
        $this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM   {$GLOBALS['config']['TABLE_PREFIX']}users WHERE  USER_LOGIN_NAME = ? LIMIT 1");
//$this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}users SET U_Laston = ?, U_SessionId = ? WHERE USER_DISPLAY_NAME = ?");
$this->getUserStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}users WHERE USER_ID = ? LIMIT 1");
$this->getUsersStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}users");

Replace With:
Code
        $this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM   {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_LOGIN_NAME = ? LIMIT 1");
//$this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}USERS SET U_Laston = ?, U_SessionId = ? WHERE USER_DISPLAY_NAME = ?");
$this->getUserStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE USER_ID = ? LIMIT 1");
$this->getUsersStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS");


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Oct 2001
Posts: 18
Newbie
Newbie
Offline
Joined: Oct 2001
Posts: 18
I've looked everywhere on the tufat site and
do not find the base UBBT integration instructions?

I found the so-called 7.02 update but only basic instructions for the old 6.5.X

there is no ubbt_registerednav template

what do I do in 7.1 ?

make a custom portal Island of it ?




Last edited by owen93; 03/05/2007 9:09 PM.
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
The importer comes with the latest version of the script available on the TUFAT site; the integration file is listed in the integration list as "UBB.Threads 7.1 CMS".


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
FYI, the integration file with my updates seems to be listed here and is for FlashChat 4.7.9

BTW, my demo is at:
UBB7: http://home.corthell.net:81/forums/ubb7/ubbthreads.php
FlashChat: http://home.corthell.net:81/forums/ubb7/chat/


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Sponsored Links
Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
Thank you!

I will do a fix and see what happens on mine.


Daryl Fawcett
Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
Another question:

Was there also an error in w3t_myid being used instead of ubbt_myid?


Daryl Fawcett
Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
I answered my own question, and then found another question.

I got it working, but I need to log in myself, which is the reason for asking the following question:

Does your's log you in automatically, or do you need to log yourself in?


Daryl Fawcett
Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
If you are able to log into Flashchat automatically when logged into the forum, I may not be able to do that on account that I am using a cookie prefix.

If that is the case, do you know what I need to change in the Flashchat Config. to add the cookie prefix?


Daryl Fawcett
Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
I am wondering if the following also needs to be changed in order for the automatic login to work?

Code

// $this->ubbt_setcookie("{$GLOBALS['config']['cookieprefix']}w3t_myid",$rec['U_Number'],time()+$GLOBALS['config']['cookieexp']);
Should the w3t be changed to ubbt?

Should something be added onto 'cookieprefix' seeing that I am using a cookie prefix word?


Daryl Fawcett
Joined: Oct 2001
Posts: 18
Newbie
Newbie
Offline
Joined: Oct 2001
Posts: 18
Thanks.
yes i found those and I chose the "UBB.Threads 7.1 CMS" when I installed.

Flashchat does indeed allow me to login with my UBB registered account.

what I want to do at this point is get a link on the navigation bar.

the flashchat site has an old method for 6.5.X which calls for modifying the ubbt_registerednav templatein 6.5.X

But honestly I'm a UNIX Admin and not really a coder - so I'm being a tad braindead about where and how to tweek the navigation bar in 7.1 and add a hotlink to the FlashChat app.




Joined: Feb 2007
Posts: 329
Yarp™
Yarp™
Offline
Joined: Feb 2007
Posts: 329
Installs fine and works fine, just have to hack it, because it displays the loginname instead of the displayname.

Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
Yes, but do you also need to log in to Flashchat separately, or does it bypass a separate manual log in and logs you in automatically?


Daryl Fawcett
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
It installs fine, however i have to login manually.

As for the commented out code, those are commented out lines from the 6.5 integration; do NOT uncomment them, they will not work, and it can make things not work at all.

As for auto logins, that'd use a cookie, you'll have to ask them at their site about using the ubb cookies to auto login.

I recommend making any requests on the ubb7 discussion on their site, such as having to use the display name vs login name, and any bugs you find.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
Flashchat integrated with UBBT prior to version 7 did an automatic login as long as you were already logged into UBBT, which is why I was wondering why the automatic login wasn't working with UBB7.x


Daryl Fawcett
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
Originally Posted by Daryl Fawcett
Flashchat integrated with UBBT prior to version 7 did an automatic login as long as you were already logged into UBBT, which is why I was wondering why the automatic login wasn't working with UBB7.x
Not everything was ported up; you should ask there or email the author and ask...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
I discovered that the auto login only works if the default cookies are used without a cookies prefix.


Daryl Fawcett
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
Try replacing:
Code
		$this->userid = isset($_COOKIE["ubbt_myid"]) ? $_COOKIE["ubbt_myid"] : NULL;

With:
Code
		$this->userid = isset($_COOKIE[$GLOBALS["config"]["COOKIE_PREFIX"] ."ubbt_myid"]) ? $_COOKIE[$GLOBALS["config"]["COOKIE_PREFIX"] ."ubbt_myid"] : NULL;


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
After I had changed my cookie prefix back to the default, the auto login began to work without any problem, therefore, I will not make this change, however, it is good to have it here for future use, or for others having the same problem.


Daryl Fawcett
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
Was hoping someone would test it out vs me on my dev machine; as I don't use the script in a production environment I cannot test the functionality of the addition properly.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Oct 2001
Posts: 18
Newbie
Newbie
Offline
Joined: Oct 2001
Posts: 18
Originally Posted by Gizmo
Was hoping someone would test it out vs me on my dev machine; as I don't use the script in a production environment I cannot test the functionality of the addition properly.

well I'm still in dev myself but I added it in and it worked fine for me.

Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
Originally Posted by owen93
well I'm still in dev myself but I added it in and it worked fine for me.
Well, thats good enough for me; I'll post it at the flashchat thread to be updated in the integration


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Nov 2001
Posts: 28
User
User
Offline
Joined: Nov 2001
Posts: 28
I actually already posted it there.

They actually tested it and they said it works.

http://forum.tufat.com/showthread.php?p=135717#post135717


Daryl Fawcett
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

I posted a problem I'm having on their forum - hopefully one of you guys could lend a hand since I cannot log in to FlashChat! smirk


GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

Okay, well, let me ask you guys this, if you have FlashChat integrated successfully into Threads 7.* -- the Mod there hasn't been very helpful. smirk

For some reason, for me, the "built-in login" is working, but not the manual "HTML-based login" -- it says "incorrect user name or password". Has anyone here been able to log-in when it asks you for a username/password?

Also, before I use FlashChat, I really need it to display Display Names and not Usernames. Anyone figure that out yet? I can't seem to find it...

Thanks!

JG



GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
geoff, i have it working for html based login, no problems...

As for PDN, let me have a look at the files and I'll get back to you.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
It doesn't look like the integration file even touches the pdn, it just basically works with the login name and password...

If I get some more time I'll do some digging in the normal files to see if i can find a place to hijack what name is shown; but no promises, the ammount of files is vastly huge...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96
Originally Posted by Gizmo
geoff, i have it working for html based login, no problems...
I wish I knew what my problem was. Are you using the 7.1 version? I'll have to play with it more I suppose...

Originally Posted by Gizmo
As for PDN, let me have a look at the files and I'll get back to you.
Sorry, what's PDN? blush
The Threads 7.1 CMS file seems to call up USER_DISPLAY_NAME - but after looking at dozens of files, I cannot find where/how to use it... smirk



GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
Yes I'm using the 7.1 version; you can fiddle at:
http://home.corthell.net:81/forums/ubb7/chat/

PDN == Public Displayed Name; I do realize that it selects the PDN but it never referances, if you look at the calls, it only uses the login name and password (i think its the third mysql call).

I've "cleaned up" my configuration file so line numbers wouldn't match up, else I'd tell you what lines to look at lol...

I did see that some of the scripts referance "name" so I set name as a variable but it doesn't get used; I'm sure it's only used for their "normal"/"non-integration" login system...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

Yeah, yours works... mine doesn't... guess I'll try reinstalling it... :rolleyes:

Why Darren chose to display user names rather than display names is till beyond me... makes it virtually worthless... smirk


GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
well it's quite simple; most products don't have public names and only have login names... however i think it would have been cool to have the option; perhaps email him with a feature request?


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

Guess an email to him directly would be better than trying to get passed his bulldog moderator! LOL laugh


GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
wink... no comments from me, as they wouldn't be professional in nature :nods:


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Dec 2002
Posts: 67
Power User
Power User
Joined: Dec 2002
Posts: 67
Did anyone ever figure out the display name vs login name fix? I've read here and at the Tufat forums, no luck yet.

Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
From my point of view, without knowing what their script looks for as a variable it'd be near impossible to pull it with the integration file.

From their point of view, we're a "small fish" and they could care less.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Dec 2002
Posts: 67
Power User
Power User
Joined: Dec 2002
Posts: 67
Ok, this is so simple there must be something wrong with it, but in ubb71CMS.php I changed the guts of function UBBCMS () to the following, basically subbing USER_DISPLAY_NAME for USER_LOGIN_NAME:
PHP Code
	 $this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM   {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_DISPLAY_NAME = ? LIMIT 1");
//$this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}USERS SET U_Laston = ?, U_SessionId = ? WHERE USER_DISPLAY_NAME = ?");
$this->getUserStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE USER_ID = ? LIMIT 1");
$this->getUsersStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS");
Then I expired my site cookies and it shows my username rather than my login name. Violá!
I'll have to warn all my users to expire their cookies, otherwise it they will not be autologged in the first time. To log in manually using this code, you have to log in with your display name and password, rather than login name and password. As long as autologin is working, this process will be transparent and your users won't know it's even happening.
All my users will hit it in the morning, and we'll see what happens. I'll report back if any probs.

Joined: Dec 2002
Posts: 67
Power User
Power User
Joined: Dec 2002
Posts: 67
Ok, this is so simple there must be something wrong with it, but in ubb71CMS.php I changed the guts of function UBBCMS () to the following, basically subbing USER_DISPLAY_NAME for USER_LOGIN_NAME:
PHP Code
	 $this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM   {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_DISPLAY_NAME = ? LIMIT 1");
//$this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}USERS SET U_Laston = ?, U_SessionId = ? WHERE USER_DISPLAY_NAME = ?");
$this->getUserStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE USER_ID = ? LIMIT 1");
$this->getUsersStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS");
Then I expired my site cookies and it shows my username rather than my login name. Violá!
I'll have to warn all my users to expire their cookies, otherwise it they will not be autologged in the first time. To log in manually using this code, you have to log in with your display name and password, rather than login name and password. As long as autologin is working, this process will be transparent and your users won't know it's even happening.
All my users will hit it in the morning, and we'll see what happens. I'll report back if any probs.

Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

I'll have to give this a shot - thanks!


GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

I still can't log in unless I use the "automatic login", and the change above didn't work either for me... something's wrong and I can't figure it out frown


GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

Okay, everything's working now!! smile

Some issues:

1) For some reason we can only see our OWN profiles, with the FlashChat link to "Profile" that's supposed to point back to our UBB profiles. For everyone other than ourselves, it takes us to the main UBB page.

2) How to get UBB Mods to display as Mods rather than Admins in FlashChat?



GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
I still stand behind the statement that it's not possible with their current integration file.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96
Originally Posted by Gizmo
I still stand behind the statement that it's not possible with their current integration file.

To (almost) quote The Godfather Part II...

If anything in this life is certain -- if history has taught us anything -- it's that anything's possible...

Okay, well, Michael Corleone ended with it's possible to kill anyone, but that's a bit extreme for what we're dealing with at the moment. lol

In any event, I did a live beta test w/ a handful of members tonight, and have my short list of fixes/quirks that need to be fixed... I'll compile them later -- here, but mostly on their forum, of course...

But at least it works for the most part cool



GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
Well, if they'd let the cat out of the bag at what items referance other items and are called from the integration file, sure, it'd be possible...

Have you TRIED asking at their site? Your thread will either be ignored, locked, or deleted...

have you TRIED emailing their author? He'll either ignore you or offend you (in my case, demanding a free copy of .T7 which would violate my license agreement for his $5 script lol...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Nov 2003
Posts: 482
Enthusiast
Enthusiast
Offline
Joined: Nov 2003
Posts: 482
one would think that just finding another chat system would be better, if that's the treatment you get from the author...

Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
Well, one thing that happens with these driveby authors who create cheap scripts, if you have input or requests and don't want to spent $$$ getting them to update in a direction of your liking, it's likely you'll get turned down; their script isn't what you're wanting to integrate with, so it's more of a courtesy smirk...

I still push for the irc way of things lol


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

I posted a new topic over there, here, and will see if anyone has any feedback. In the mean time, I'll look into some of these issues and see if I can figure some of them out...


GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

If anyone wants to try it, here's my ubb71CMS integration script for FlashChat 4.7. I can't attach the file apparently, so here it is -- rename it ubb71CMS.php and save it to \FLASHCHAT_DIR\inc\cmses

I have not tried this with a later version of UBB.t than 7.1. I will test with 7.3 once it's released...

PHP Code


<?php

if ( !defined( 'INC_DIR' ) ) {
die(
'hacking attempt' );
}

/************************************************************************/
//!!! IMPORTANT NOTE
//!!! FlashChat 4.4.0 and higher support a new user role: ROLE_MODERATOR
//!!! Please edit the getUser and getRoles function if you need use of
//!!! the new moderator role. This change has not yet been applied.
/************************************************************************/

// integration class for UBB.Threads (www.ubbcentral.com/ubbthreads/)


$ubb_root_path = realpath(dirname(__FILE__) . '/../../../') . '/';

require_once(
$ubb_root_path . 'includes/config.inc.php');

class
UBBCMS {
var
$loginStmt;
var
$updateSessionStmt;
var
$getUserStmt;
var
$getUsersStmt;
var
$userid;
function
UBBCMS() {

$this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE USER_DISPLAY_NAME = ? LIMIT 1");
//$this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}USERS SET U_Laston = ?, U_SessionId = ? WHERE USER_DISPLAY_NAME = ?");
$this->getUserStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE USER_ID = ? LIMIT 1");
$this->getUsersStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS");

// $this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE USER_LOGIN_NAME = ? LIMIT 1");
// $this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}users SET U_Laston = ?, U_SessionId = ? WHERE USER_DISPLAY_NAME = ?");
// $this->getUserStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE USER_ID = ? LIMIT 1");
// $this->getUsersStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS");

$this->userid = isset($_COOKIE[$GLOBALS["config"]["COOKIE_PREFIX"] ."ubbt_myid"]) ? $_COOKIE[$GLOBALS["config"]["COOKIE_PREFIX"] ."ubbt_myid"] : NULL;
}

function
isLoggedIn() {
return
$this->userid;
}


// DOESN'T WORK:
//
// function getRoles($status) {
// $rv = NULL;
//
// if ($status == "Administrator")
// $rv = ROLE_ADMIN;
// elseif ($status == "Moderator")
// $rv = ROLE_MODERATOR;
// elseif ($status == "User")
// $rv = ROLE_USER;
// else
// $rv = ROLE_SPY;
//
// return $rv;
// }


// SO ADMINS AND MODS WILL GET ADMIN STATUS IN FLASHCHAT:


function getRoles($status) {
$rv = NULL;

if (
$status == "Administrator" || $status == "Moderator")
$rv = ROLE_ADMIN;
elseif (
$status == "User")
$rv = ROLE_USER;
else
$rv = ROLE_SPY;

return
$rv;
}

function
getUserProfile($userid) {
if (
$userid == SPY_USERID) $rv = NULL;

elseif (
$user = $this->getUser($userid))
{
//toLog("this",$this->isLoggedIn());
$id = $this->isLoggedIn();

if(
$id && ($id == $userid) )
{
toLog("true",true);
$rv = $GLOBALS["config"]["FULL_URL"] . "/ubbthreads.php?ubb=showprofile&User={$userid}";
}
else
{
toLog("false",false);
$rv = $GLOBALS["config"]["FULL_URL"] . "/ubbthreads.php?ubb=login";
}

}
toLog("rv_prof",$rv);
return
$rv;
}


function
getUser($userid) {

$rs = $this->getUserStmt->process($userid);
$rv = $rs->next();

if(
$rv) {
$rv["roles"] = $this->getRoles($rv["status"]);
}
return
$rv;
}

// taken from ubbt.inc.php



function login($login, $password) {

$goodPassword = false;

$rs = $this->loginStmt->process(addslashes($login));
$rec = $rs->next();

if (
$rec) {
// check if user is banned
if ($rec["USER_IS_BANNED"]) return NULL;

// allow login only with permanent password. Ignore the temporary password
if (md5($password) != $rec["USER_PASSWORD"]) return NULL;

// $this->ubbt_setcookie("{$GLOBALS['config']['cookieprefix']}w3t_myid",$rec['U_Number'],time()+$GLOBALS['config']['cookieexp']);

// $this->updateSessionStmt->process(time() + $GLOBALS["config"]["adjustime"] * 3600, md5(rand(0,32767)), addslashes($login));


return $rec['USER_ID'];

}

}

function
userInRole($userid, $role) {
if(
$user = $this->getUser($userid)) {
return (
$user['roles'] == $role);
}
return
false;
}

function
logout() {

}

function
getUsers() {
return
$this->getUsersStmt->process();
}

function
getGender($userid) {
// 'M' for Male, 'F' for Female, NULL for undefined
return NULL;
}
}

$GLOBALS['fc_config']['db'] = array(
'host' => $GLOBALS["config"]["DATABASE_SERVER"],
'user' => $GLOBALS["config"]["DATABASE_USER"],
'pass' => $GLOBALS["config"]["DATABASE_PASSWORD"],
'base' => $GLOBALS["config"]["DATABASE_NAME"],
'pref' => $GLOBALS["config"]["TABLE_PREFIX"] . 'fc_',
);

$GLOBALS['fc_config']['cms'] = new UBBCMS();


foreach(
$GLOBALS['fc_config']['languages'] as $k => $v) {
$GLOBALS['fc_config']['languages'][$k]['dialog']['login']['moderator'] = '';
}

?>




GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

Has anyone figured out how to add a "Who's Chatting" custom island into Threads?

Edit: Never mind, I found this download (just a php file) in the Tufat resources: New "Who's Chatting" file for CMS systems cool

Edit Again: Haven't gotten it working in a custom island yet, but it works as a stand-alone page. Getting errors when put in a custom island. Here's the code...

PHP Code

/* PHP CODE HERE, IF NECESSARY */

header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");


/**
If this file is not in the FlashChat root folder, then change this
path to the location of the inc/common.php file.
*/
include_once('inc/common.php');

ChatServer::purgeExpired(); // ERROR HERE: Undefined class name 'chatserver'

/**
Retrieves the number of users who are chatting in any room.
Leave the $room parameter empty to return the number of users in all room.
*/
function numusers( $room = "" )
{
if(
$room) {
$stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND roomid=?");
$rs = $stmt->process($room);
} else {
$stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections,{$GLOBALS['fc_config']['db']['pref']}rooms
WHERE userid IS NOT NULL AND ispublic IS NOT NULL
AND
{$GLOBALS['fc_config']['db']['pref']}connections.roomid = {$GLOBALS['fc_config']['db']['pref']}rooms.id");
$rs = $stmt->process();
}

$rec = $rs->next();

return
$rec?$rec['numb']:0;
}

/**
Retrieves a list of the users (by login ID) who are in $room.
Leave the $room parameter empty to return a list of all users in all rooms.
*/
function usersinroom( $room = "" )
{
$cms = $GLOBALS['fc_config']['cms'];
$list = array();

if(
$room) {
$stmt = new Statement("SELECT userid, state, color, lang, roomid FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND roomid=?");
$rs = $stmt->process($room);
} else {
$stmt = new Statement("SELECT userid, state, color, lang, roomid FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL");
$rs = $stmt->process();
}

while(
$rec = $rs->next()) $list[] = array_merge($cms->getUser($rec['userid']), $rec);

return
$list;
}

/**
Retrieves a list of all available rooms, as an array.
*/
function roomlist()
{
$list = array();

// populate $list with the names of all available rooms
$stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NOT NULL order by ispermanent");
$rs = $stmt->process(); // ERROR: Cannot instantiate non-existent class: statement

while($rec = $rs->next()) $list[] = $rec;

//result will be an array of arrays like ('id' => <room id>, 'updated' = <timestamp>, 'created' => <timestamp>, 'name' => <room name>, 'ispublic' => <public flag>, 'ispermanent' => <autoclose flag>)
return $list;
}


$rooms = roomlist();
$roomnumb = sizeof($rooms);
$usernumb = numusers();



/* DO NOT CHANGE THE LINE BELOW */
$body = <<<EOF

<BR>&#62;<a href="/threads/chat/flashchat.php" target="_blank">Chatroom</a> (<?=
$usernumb ?> user<? if ($usernumb != 1) echo "s" ?> in <?=$roomnumb ?> room<? if ($roomnumb != 1) echo "s"; ?>)
<ul id="roomList">
<?php if(
$roomnumb) { ?>
<?php foreach(
$rooms as $room) { ?>
<li><strong><a href="#" onclick="javascript:toggleUserList('room_<?=
$room[id]?>')"><?=$room[name]?> (<?= numusers($room[id]) ?>)</a></strong>
<?php
$users = usersinroom($room[id]);
if (
$users) {
echo "<ul class="userList" id="room_".
$room[id]."">";
foreach(
$users as $user ) {
echo "<li>".
$user[login] . "</li>";
}
echo "</ul>";
}

?> </li>
<?php } ?>
<?php } ?>
</ul>



EOF;
/* DO NOT CHANGE THE LINE ABOVE */


Last edited by jgeoff; 02/19/2008 7:10 PM. Reason: Ugh

GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Feb 2008
Posts: 11
Newbie
Newbie
Offline
Joined: Feb 2008
Posts: 11
I am working on integrating several chats.

Question:
will the user authorization stay the same from version 7.2 to 7.3? data like username, password, moderator and admin status, will they be the same and unchanged in the database?

Joined: May 2006
Posts: 6
Lurker
Lurker
Offline
Joined: May 2006
Posts: 6
The following for Who's Chatting is working for me in my Custom Island:
Quote


You may need to customize the SRC for your particular site.

Joined: Feb 2008
Posts: 11
Newbie
Newbie
Offline
Joined: Feb 2008
Posts: 11
Explanation:

I integrated PJIRC, works fine, but probably will not be a hit with my chat guests

Want to integrate FlashChat, will the stuff here work with 7.2 and 7.3 (still in beta4) of ubb?

Working to integrate phpopenchat.


If I integrate it for 7.2, will it work for the other version? 7.3.4


or vice versa. I.e. is it upward or downward compatible?

By integrating I mean mainly that usercheck and userpasswordcheck for the chat will be done using the ubb database.

Ideally, moderator and adminstrator status could translate also from ubb to the chat

Last edited by curiousguy; 02/22/2008 1:21 PM.
Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96
Originally Posted by DarylCA
The following for Who's Chatting is working for me in my Custom Island:
Quote



THANK YOU!!!!! cool

Originally Posted by curiousguy
If I integrate it for 7.2, will it work for the other version? 7.3.4
I'm still using 7.1 so I have no idea -- I'm waiting for 7.3 (final) to come out to test it... I sure hope so!


GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
Please, for the love of god, start a feature request thread for phpopenchat vs spamming your want for it in other chat integration threads.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Jun 2001
Posts: 176
Member
Member
Offline
Joined: Jun 2001
Posts: 176
well I tried this with 7.2.2 & don't work
Code
Fatal error: Call to a member function next() on a non-object in /home/boneyard/public_html/forum3/chat/inc/cmses/ubb71CMS.php on line 82 

on line 82
Code
$rv = $rs->next(); 

has anyone worked on this for 7.2.2
I know everyone is waiting for 7.3

Joined: Jun 2001
Posts: 176
Member
Member
Offline
Joined: Jun 2001
Posts: 176
hold on works now
I reinstalled it


edit: works just fine with 7.2.2
no problems with install other then I reinstalled but I thing it was my fault as I skipped a step

Joined: Apr 2001
Posts: 96
Power User
Power User
Joined: Apr 2001
Posts: 96

FlashChat seems to still be working fine in Threads 7.3 cool


GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Honorable Mention
UBB.classic 6.7.2 - RIP
Browser: Firefox 2.0
Joined: Mar 2007
Posts: 16
Newbie
Newbie
Offline
Joined: Mar 2007
Posts: 16
I have been using Flash Chat successfully for quite a while, with one exception. I have a troll who keeps registering and re-registering, often multiple times in one day. I usually manage to spot him and boot him through the approval process, keeping him off the board.

Unfortunately, Flash Chat sees him as a member as soon as he registers, even though he is not approved, so he goes straight into chat.

Does anyone know a way around that?

I started a thread "over there," but I'm not sure of what to tell them...

http://forum.tufat.com/showthread.php?t=49698

Joined: Jan 2000
Posts: 5,832
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,832
Likes: 20
It'd be a security issue within flashchat; it's not checking to see if a user has been approved or not...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Page 1 of 2 1 2

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Pilgrim
Pilgrim
NH, USA
Posts: 190
Joined: June 2000
Forum Statistics
Forums63
Topics37,571
Posts293,923
Members13,848
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,832
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 81
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2023 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)