UBB.Developers Forums UBB.threads 6 V6 Modifications Beta-[6.3] HiveMail - Integration 1.0

I (and others) haven't been able to get this going correctly unless Threads and Hivemail both use the same database. I've gotten this working almost completely, w/ the only problem being that I don't get the flashing email .gif for new emails, which is a problem w/ the update routine (according to the test Charles asked me to do). But other than that it works great. I haven't downloaded this zip in a while, but there were problems w/ mine:
1. The .sql file only inserts hm_userid into the w3t_Users table, when it should also insert a field called hm_emails (or hm_email). More on this is somewhere in the thread if you look for it.

2. Use the SQL command mentioned earlier in this thread to change the hivemail templates (much easier & faster).

3. You may need a revision of the ubbt_plugin.php file that Nikos created. I can email that to you if you need it.

Good luck!

the zip file should be up to date appart from the require_once since I am still not sure it helps or not

Charles -

Could you hack some code for me (or post the code) which would make the users log-in their email address and not allow the option of selecting their own email address? Basically using the original signup page while automatically creating an email account with the users "user" name. I think that (for me anyway) this is an easier way to keep track of email addresses.

--EDIT--
For now I'm going to add the hack as is since I haven't fully deployed the site - so if you do want to tackle the code for me that is where I'm coming from. And if you don't have time to do it - no sweat.
--EDIT--

Thanks

Post deleted by Tom_H

You need to modify the mySQL file in the zip - add this line:
-------------------------------------------------
ALTER TABLE w3t_Users ADD hm_emails int(10) unsigned NOT NULL default "0";
-------------------------------------------------

No more SQL errors - CAN access my board again - still no hivemail integration.....

Post deleted by Tom_H

Down to one error and one problem...

--ERROR-----------------------------------------------------
SQL ERROR: Mon, Sep 08 2003 00:10:22 -0500 Database error only visible to forum administrators

Warning: Cannot modify header information - headers already sent by (output started at /home/tomh68/public_html/ubbthreads/mysql.inc.php:236) in /home/tomh68/public_html/ubbthreads/ubbt.inc.php on line 239
--END ERROR-------------------------------------------------

This happens on new user sign-up - feel free to check it out for yourself...www.udtsealboard.com.

Also - There is no option for checking mail in the users "My Home". I would assume that there's supposed to be but I have none??

Went through the mod twice checking everything and can't seem to find any differences.

Any ideas?

Tom

[]Tom_H said:
Charles -

Could you hack some code for me (or post the code) which would make the users log-in their email address and not allow the option of selecting their own email address? Basically using the original signup page while automatically creating an email account with the users "user" name. I think that (for me anyway) this is an easier way to keep track of email addresses.

--EDIT--
For now I'm going to add the hack as is since I haven't fully deployed the site - so if you do want to tackle the code for me that is where I'm coming from. And if you don't have time to do it - no sweat.
--EDIT--

Thanks [/]This is easy to do, I will post the code later today

[]Tom_H said:
Down to one error and one problem...

--ERROR-----------------------------------------------------
SQL ERROR: Mon, Sep 08 2003 00:10:22 -0500 Database error only visible to forum administrators

Warning: Cannot modify header information - headers already sent by (output started at /home/tomh68/public_html/ubbthreads/mysql.inc.php:236) in /home/tomh68/public_html/ubbthreads/ubbt.inc.php on line 239
--END ERROR-------------------------------------------------

This happens on new user sign-up - feel free to check it out for yourself...www.udtsealboard.com.

Also - There is no option for checking mail in the users "My Home". I would assume that there's supposed to be but I have none??

Went through the mod twice checking everything and can't seem to find any differences.

Any ideas?

Tom [/]Tom could you go at the end of ubbt.inc and switch on the option to show mysql errors to all users? then go back and tell me what the error is.

Right now there is no way to check email in your my home page, all you will get is a flashing icon telling you you gave mail that will take you to your email login.

[]
Right now there is no way to check email in your my home page, all you will get is a flashing icon telling you you gave mail that will take you to your email login. [/]

The other site I looked at had an "email" link in the navigation bar above the user info in "My Home" - so that's a custom link? Which file would I go to to add this link?

Also - hate to sound like an idiot - but I can't see how to turn on SQL errors to all users in ubbt.inc.php??? I'll keep looking and post when I find it.

Tom

Found my mySQL error log:

--ERROR-----------------------------------------------------
[ERROR][Mon, Sep 08 2003 00:10:22 -0500] [/ubbthreads/adduser.php] [xxx.xxx.128.126] Unable to do_query:
UPDATE .Users
SET hiveuserid = 4
WHERE U_number = 25
- Table 'tomh68_ubb.Users' doesn't exist
[ERROR][Mon, Sep 08 2003 00:39:30 -0500] [/ubbthreads/adduser.php] [xxx.xxx.128.126] Unable to do_query:
UPDATE .Users
SET hiveuserid = 5
WHERE U_number = 28
- Table 'tomh68_ubb.Users' doesn't exist
[ERROR][Mon, Sep 08 2003 00:59:05 -0500] [/ubbthreads/adduser.php] [xxx.xxx.128.126] Unable to do_query:
UPDATE .Users
SET hiveuserid = 6
WHERE U_number = 29
- Table 'tomh68_ubb.Users' doesn't exist
[ERROR][Mon, Sep 08 2003 08:16:13 -0500] [/ubbthreads/adduser.php] [xxx.xxx.128.126] Unable to do_query:
UPDATE .Users
SET hiveuserid = 7
WHERE U_number = 30
- Table 'tomh68_ubb.Users' doesn't exist
--END ERROR-------------------------------------------------

Doesn't look too good - I added all the SQL queries from the hack and got positive feedback from the cPanel.

I'll keep looking for the "switch" to show errors to all users.

Tom

my fault I did a bug

*edit*
to all of you please download the zip and replace the ubbt_plugin file in your hive mail folder.

this should fix all the bugs, I had forgotten to add $options in all functions requires so I could not work

Don Julio, please email me the modified ubbt plugin file you use. It should be the same than the one in the zip, appart for the fix I just did but I would like to double check.

thanks

[]Tom_H said:
You need to modify the mySQL file in the zip - add this line:
-------------------------------------------------
ALTER TABLE w3t_Users ADD hm_emails int(10) unsigned NOT NULL default "0";
-------------------------------------------------

No more SQL errors - CAN access my board again - still no hivemail integration..... [/]

this query was added to the zip file, sorry I thought this had been corrected.

I'm still getting the error - double checked the change and the "$options" is in there but still....

--ERROR-----------------------------------------------------
SQL ERROR: Mon, Sep 08 2003 10:17:55 -0500 Database error only visible to forum administrators

Warning: Cannot modify header information - headers already sent by (output started at /home/tomh68/public_html/ubbthreads/mysql.inc.php:236) in /home/tomh68/public_html/ubbthreads/ubbt.inc.php on line 239
--END ERROR-------------------------------------------------
--FROM SQL LOG----------------------------------------------
- Table 'tomh68_ubb.Users' doesn't exist
[ERROR][Mon, Sep 08 2003 10:17:55 -0500] [/ubbthreads/adduser.php] [xxx.xxx.128.126] Unable to do_query:
UPDATE .Users
SET hiveuserid = 8
WHERE U_number = 32
--END ERROR-------------------------------------------------
???

FYI - Found the file to add the email link to the navigation header - ubbt_registerednav.tmpl

Tom

download the zip again

The whole thing and reinstall?

no just replace ubbt plugin

Now I'm getting the "Parse Error"...
--ERROR-----------------------------------------------------
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/tomh68/public_html/hivemail/includes/ubbthreads_plugin.php on line 147

Fatal error: Call to undefined function: update_newmail() in /home/tomh68/public_html/ubbthreads/ubbthreads.php on line 25
--END ERROR-------------------------------------------------

You have to add the curly braces as in dimopoulos' earlier post...

Let me find it....

Here it is....

[]

I had the same problem. Change all the instances of

$options['database'].

to

{$options['database']}.

You will also see that there is also a $options['dbserver']

A couple more variables also need to be treated this way.

[/]

Check that - line 147 must be:
--EDIT------------------------------------------------------
$sth = $dbh -> do_query("SELECT hm_userid FROM {$config['dbserver']}.{$config['tbprefix']}Users WHERE U_Number = $Uid");
--END EDIT--------------------------------------------------

Note curly braces around "$config['dbserver']"

Tom

And still getting SQL error on new member register.

the same sql error?

Exact.

If you want, I'll set up an admin acct for you to see.

He|| for that matter I could set up an ftp acct for you too.

??

please send the ftp account to me by PM

Check your pm box - it didn't show up in my sent box so I don't know if you received it.

Tom

got it but getting access denied for the ftp, please check l/p

Check PM

SQL ERROR: Mon, Sep 08 2003 12:00:35 -0500 Unable to do_query: UPDATE localhost.w3t_Users SET hiveuserid = 10 WHERE U_number = 35
update command denied to user: 'tomh68_tom@localhost' for table 'w3t_Users'

are both scripts installed in the same database?

YES!

From the posts that seemed like the way to do this.

ok, strange then that he says you do not have access to this database, it might come from the way it is configured.

I would try removing all database vars then in the plugin file this might be the problem

Did you get a look at the modded files? - All ok?

If I removed all database variables wouldn't that render the functions that use the variables useless??

Do you mean all refrences to "$options[database]"?

Tom

yes the whole thing. you should have 2 database and dbserver

Well, we got new errors...
--ERROR-----------------------------------------------------
SQL ERROR: Mon, Sep 08 2003 13:59:55 -0500 Unable to do_query: UPDATE w3t_Users SET hiveuserid = 13 WHERE U_number = 38
Unknown column 'hiveuserid' in 'field list'
Warning: Cannot modify header information - headers already sent by (output started at /home/tomh68/public_html/ubbthreads/mysql.inc.php:236) in /home/tomh68/public_html/ubbthreads/ubbt.inc.php on line 239
--END ERROR-------------------------------------------------

I also deleted the "." from the variables - should I not have done that?

Tom

If I do a clean install - how should the db's be setup?

Tom

Just so you know, I've got everything about this hack working except the PM style notifications for emails. When I used your ubbthreads_plugin.php file I got (and still do get) this error:
[] Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/laondal/public_html/correo/includes/ubbthreads_plugin.php on line 147

Fatal error: Call to undefined function: update_newmail() in /home/laondal/public_html/foros/ubbt.inc.php on line 1491 [/]
So it seems the update_newemail routine isn't working, which is why I don't get the PM syle notification. Using Nikos' modification of the file, I don't get that error, but I don't get the PM style noficiation either You say you've updated the zip, so I'll give yours a try again (the new one ). BTW, what is your email address (so that I can send you the ubbthreads_plugin.php that I'm using)?

*************EDIT****************
I just tried using your new version of the ubbthreads_plugin.php file and I got the same error. So for me, this is almost out of beta, but not quite there yet. The only problem is the update_newemail function, which is an error either in the ubbthreads_plugin.php file of the ubbt.inc.php file.

DonJulio -

Here's the mod to the file to fix that error:

[]Tom_H said:
Check that - line 147 must be:
--EDIT------------------------------------------------------
$sth = $dbh -> do_query("SELECT hm_userid FROM {$config['dbserver']}.{$config['tbprefix']}Users WHERE U_Number = $Uid");
--END EDIT--------------------------------------------------

Note curly braces around "$config['dbserver']"

Tom [/]

donjulio - are you using a combined DB or are your DB's separated (one for Threads, and one for Hivemail)?

I'm using a combined database. Thanks for the fix. I'll give it a try!

Thanks! That fixed the error w/ the stock ubbthreads_plugin.php file. Hopefully the zip will get updated for that. Now I'll check to see if the update_newemails routine is working so I can get those PM style notifications
[]Tom_H said:
DonJulio -

Here's the mod to the file to fix that error:

[]Tom_H said:
Check that - line 147 must be:
--EDIT------------------------------------------------------
$sth = $dbh -> do_query("SELECT hm_userid FROM {$config['dbserver']}.{$config['tbprefix']}Users WHERE U_Number = $Uid");
--END EDIT--------------------------------------------------

Note curly braces around "$config['dbserver']"

Tom [/] [/]