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

tom some stuff I forgot.

If you use the reg queue then user will also be in the queue in HM once you approve him his account is activated.

If you delete a user, his email gets deleted too if he has one.

ok fixed added the newmail call code to your cat page too and fixed the double // in your url

[]Charles said:
ok fixed added the newmail call code to your cat page too and fixed the double // in your url [/]
Thanks! It's working now! Now I gotta get some sleep

I need to add the mofification to categorie.php in the zip, since i never use it I forgot to add it in the first place

What was causing the double "//". Was in in the config.inc.php file? What would I need to change?

BTW: I think after you add the call to the categories.php file, this mod will be out of BETA

I have suggestions for the next version:
Automatic log in to both forums and email from the forums login.php page. That way you can add a link to Email to the navigation bar and throw out the hivemail index.php page (or at least replace it w/ the Threads login page).

Another suggestion is to make it so when update emails routine runs, that it only counts unread emails in the inbox, and not the trash can. I delete spam w/o opening them and I have to wait x number of days for them to expire (at least one) or log out for the trash can to be emptied. Having to log in and out to get the newem.gif to go away is annoying. Since they don't have an instant delete option in hivemail, a way to differentiate the two would be nice. I've suggested the instant delete idea over at the hivemail forums.

Great work Charles & Stefan & Nikos!

[]donJulio said:
What was causing the double "//". Was in in the config.inc.php file? What would I need to change?
[/]
yes it was in the URL in the config file

[]
Another suggestion is to make it so when update emails routine runs, that it only counts unread emails in the inbox, and not the trash can. I delete spam w/o opening them and I have to wait x number of days for them to expire (at least one) or log out for the trash can to be emptied. Having to log in and out to get the newem.gif to go away is annoying. Since they don't have an instant delete option in hivemail, a way to differentiate the two would be nice. I've suggested the instant delete idea over at the hivemail forums.[/]

fixed

in the plugin file find:

$query = "SELECT userid FROM {$options['database']}.hive_message WHERE userid = $hiveid AND status = 0";

replace by:

$query = "SELECT userid FROM {$options['database']}.hive_message WHERE userid = $hiveid AND status = 0 AND folderid != -2 AND folderid != -3 AND folderid != -4";

-2 -3 -4 folders are sent, trash and junk so any unread emails in there will not be counted

zip file updated too

Charles -

The code to use the login name as the hivemail username did not work - or atleast I suspected it was causing the error so I removed all the code and went back to the original hack. Well, that wasn't the problem.

First - I can't see the "UBBThreads integration" plug-in in the HiveMail admin panel.

Second - I can't get into UBBThreads, I get this...

--ERRORS-----------------------------------------

Fatal error: Cannot redeclare hivemail_check_name() (previously declared in /home/tomh68/public_html/hivemail/includes/ubbthreads_plugin.php:76) in /home/tomh68/public_html/hivemail/includes/ubbthreads_plugin.php on line 74

--END ERROR--------------------------------------

If you would like to take a crack at it let me know and I will give you my admin info - otherwise I think that I am going to abandon this hack.

Tom

actually the code I gave you will most probably give an error I didn't test it.

otherwise try using require_once instead of require.

but from the error it seems you copied the code twice no ?

for the ubbt plugin in hivemail you have to add the data first to the hive database.

What data in the Hive database are you refering to?

well we do add some stuf in the cp table to support the hack

Just the queries - they are done.

I did have a duplicate line however I am getting SQL errors at the top of threads again...
--ERROR------------------------------------
SQL ERROR: Sun, Sep 14 2003 09:40:40 -0500 Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tomh68/public_html/ubbthreads/mysql.inc.php on line 131
--END ERROR--------------------------------

has anyone gotten this to work with seperate databses? My threads DB is already about 400MB, and I really don't want to start adding email to that as well.

SQL Log error messages--------------------------------

[ERROR][Sun, Sep 14 2003 09:40:40 -0500] [/ubbthreads/ubbthreads.php] [xxx.xxx.83.196] Unable to do_query: SELECT U_FrontPage, U_Groups, U_TimeOffset,U_Display,U_Favorites,U_WhichForums,U_Categories,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned, hm_emails FROM w3t_Users WHERE U_Number = '' - Unknown column 'hm_emails' in 'field list'
[ERROR][Sun, Sep 14 2003 09:50:58 -0500] [/ubbthreads/ubbthreads.php] [xxx.xxx.43.196] Unable to do_query: SELECT U_FrontPage, U_Groups, U_TimeOffset,U_Display,U_Favorites,U_WhichForums,U_Categories,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned, hm_emails FROM w3t_Users WHERE U_Number = '' - Unknown column 'hm_emails' in 'field list'
END SQL Log error messages-----------------------------

I installed the queries??????????????

I did but it was not in a production environment.

all I can say is give it a shot, the last zip has proven to be working well (read the lib file)

and what is line 131 ?

Jeremy -

You may want to wait on this one - I had to reinstall Threads and Hivemail - luckily I had not deployed. I still have many issues in my current attempt.

$.02
Tom

--Line 131 "mysql.inc.php" --------------------------

$this->row = mysql_fetch_array($sth);

--END -----------------------------------------------

tom if you can't install it I can do it for you if you want

Still not getting the UBBT options in HiveMail admin?

RE: install -

I believe that I have done everything correctly and would like to understand the issues plaguing my install but FrUsTrAtIoN grips me once again.

Let me do one thing first - I have already double checked the Threads changes but I need to double check the Hive changes....

Give me about 3 min...

Tom

All changes to Hive check out.

I am at a loss as to what the problems are.

If you would like my admin info PM me and I'll send them. Don't worry about messing up the accounts - I have not yet deployed and can reinstall clean again with no loss and no hard feelings.

Tom

ok please do so. Do you have PHPmyadmin installed?

Yes

ok then send me an access to the files and PHPmyadmin

so ?

You have a PM

Let me know if you need anything more.

ok, you hadn't run any of the SQL queries so you didn't create the hivemail CP settings or the additional fields in threads.

now you don't get the errors any longer.

I updated the ubbt_plugin just in case.

now you need to configure hivmail and activate the plugin.

then let me know how it goes

Thank you for looking.

The FIRST thing that I did was run the SQL queries to set up the database - from phpmyadmin. Don't know how or why they didn't take? Maybe that should be the last step???

I'll configure the plug-in and test.

I have to run some errands now but will update on the thread - so have a good night and I'll let you know how it goes.

Tom

the order to add the data to the sql database is not important.

you did run the 2 sql commands for the templates so you probably forgot to run the ones in the zip.

[]Charles said:
[]donJulio said:
What was causing the double "//". Was in in the config.inc.php file? What would I need to change?
[/]
yes it was in the URL in the config file

[]
Another suggestion is to make it so when update emails routine runs, that it only counts unread emails in the inbox, and not the trash can. I delete spam w/o opening them and I have to wait x number of days for them to expire (at least one) or log out for the trash can to be emptied. Having to log in and out to get the newem.gif to go away is annoying. Since they don't have an instant delete option in hivemail, a way to differentiate the two would be nice. I've suggested the instant delete idea over at the hivemail forums.[/]

fixed

in the plugin file find:

$query = "SELECT userid FROM {$options['database']}.hive_message WHERE userid = $hiveid AND status = 0";

replace by:

$query = "SELECT userid FROM {$options['database']}.hive_message WHERE userid = $hiveid AND status = 0 AND folderid != -2 AND folderid != -3 AND folderid != -4";

-2 -3 -4 folders are sent, trash and junk so any unread emails in there will not be counted

zip file updated too [/]

Thanks Charles! It's working like a charm!

[]
$query = "SELECT userid FROM {$options['database']}.hive_message WHERE userid = $hiveid AND status = 0 AND folderid != -2 AND folderid != -3 AND folderid != -4"; [/]
Does this add more queries?

no it just makes the existing one more precise by excluding more messages

Sounds like this mod is final to me

still need to work on the auto login hadn't had time to really look into it

--Errors----------------------------------------
admin/doapproveusers.php:
should have curly braces "{}" around variables in lines 95 and 114.

AND -------------------------

Fatal error: Cannot redeclare hivemail_check_name() (previously declared in /home/tomh68/public_html/hivemail/includes/ubbthreads_plugin.php:76) in /home/tomh68/public_html/hivemail/includes/ubbthreads_plugin.php on line 74

-----------------------------------------------------

I have not looked into this last error yet - will update if I find the problem.

Tom

ok for the last error, you need to use require_once instead of require in the file that gave you the error if it still happens modify ubbt.inc too

*edit* ok the zip was updated regarding the first error.

don Julio you will need to add {} around the database call.

Charles - so far all bugs and errors fixed. Still testing and will update as needed. I am going to modify the code to use the Threads login name for the Hivemail address. I have one question about your code suggestion....

[]Charles said:
ok in the plugin use this block

in adduser.php

change:

$hive_username = get_input("hive_username","post");

to

$hive_username = get_input("Loginname","post");

in changebasic.php

change

$hive_username = get_input("hive_username","post");

to

$hive_username = get_input("Username","post");

done

it not tested but it should work

let me know how it goes [/]


Shouldn't the second line change be...

$hive_username = get_input(" [:"red"] Loginname [/] ","post");

... It seems that the prog was getting confused as to which var to use?

Tom

no this is correct as both files do not have the same var name.

I did an error in the if statement but haven't found what yet.

*edit* found my error in the code I gave you remove the {} around the wordlet in the if statement

// ----------------------------------------------------------------------
// If we are allowing the user to create an email account then we give
// them a form

//We do not want our users to choose their email so lets use the login
//first we check if we are on reg or my home screen
if (isset($Username)) { $hive_username = $Username; } else { $hive_username = $ubbt_lang['USERNAME_TEXT'];}
if ($_options['regopen']) {
$choosehmname = "
</td>
</tr>
<tr>
<td class="darktable">
{$ubbt_lang['HM_SIGNUP']}
<br />
<input type="radio" name="hive_signup" value="yes"> {$ubbt_lang['TEXT_YES']}
<input type="radio" name="hive_signup" value="no" checked> {$ubbt_lang['TEXT_NO']}<br />
<br />
{$ubbt_lang['HM_SIGNUP2']}
$hive_username 
<select name="hive_userdomain">$hive_domainname_options</select>
<br />
{$ubbt_lang['HM_SIGNUP3']}
</td>
</tr>
<tr>
<td class="lighttable">
<br />
";
}

please use this as I also fixed som HTML problems

Also the wordlet have been modified too.

$ubbt_lang['HM_USER_EXISTS'] = "HiveMail UserName already taken";
$ubbt_lang['HM_USER_WRONG'] = "HiveMail UserName can only contain letters, numbers, - _ characters";
$ubbt_lang['HM_SIGNUP'] = "<b>Sign Up for an Email Account</b><br /><smallfont>This section is optional.<smallfont/><br /><br /><b>Get your own $hive_domainname email account?</b><br /><smallfont>If you select yes please choose an account name below.</smallfont>";
$ubbt_lang['HM_SIGNUP2'] = "<b>Account name:</b>";
$ubbt_lang['HM_SIGNUP3'] = "Note: The password for your email account will be the same as your forum account.";

the zip file was updated with the corrected wordlets and fixed HTML in the plugin file.

Great - thanks.

I'll give it a try this afternoon.

Tom