[]ericgtr said:<br />If anyone get's this working under 6.2.3 let me know, looks like a great addition. [/]<br /><br />I gave it a try with UBBT 6.2.3 and HM 1.2SP1 and it worked with several changes.<br /><br />You must create a new table called alias which is included in HM 1.2.1 and change some parts within UBBT 6.2.3.<br /><br />Problem that I have at the moment is that I have so many hacks installed that I am running into trouble installing this hack.<br />It took 2 hours to modify all the instructions that they fit to my system but then it worked.<br /><br />The problem is that there is no option that if I delete a forum user the mailuser is also deleted and the way around.<br />This makes the hack unusable to me at the moment.<br /><br />Also HM 1.2SP1 makes a lot of trouble cause all the tables have different names (Prefixes are now allowed in this version and a lot of new tables were added).

[] The problem is that there is no option that if I delete a forum user the mailuser is also deleted and the way around.<br />This makes the hack unusable to me at the moment. [/] It was a decision we made with Stefan. Once the user was approved we never delete the email account but now this can be added. just look at the bit in doapproveuser and apply it to the code which deletes a user <img src="/forum/images/graemlins/smile.gif" alt="" />

[]Also HM 1.2SP1 makes a lot of trouble cause all the tables have different names (Prefixes are now allowed in this version and a lot of new tables were added). [/] why not use the latest hivemail version?

Oh thank God! You are so awesome for this mod! Thanks! <br />--EDIT-- <br />Will this work with Hivemail 1.3?

[]Charles said:<br /> []Also HM 1.2SP1 makes a lot of trouble cause all the tables have different names (Prefixes are now allowed in this version and a lot of new tables were added). [/] why not use the latest hivemail version? [/]<br /><br />I modified the templates of Hivemail to gave it the same look as my board. A change to 1.2.1 will bring up a lot of work cause I have to do the changes again and that took hours.<br /><br />At the moment 1.2.1 isn't stable enough. Take a look at the buglist <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />I will switch over sooner or later but at the moment the old rule counts: NEVER CHANGE A RUNNING SYSTEM <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />@Rest: 1.3 is not out and if this hack will work with 1.3 is written in the starts cause no one knows which changes 1.3 will bring exactly.

Ok... for now I'm just trying to install the hack as per the instructions (I'll attempt my own groups modification later).<br /><br />And I'm running into problems even with a standard install. When I go to my main forum index (ubbthreads.php) I get this:<br /><br />[]Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/mypath/mail/includes/ubbthreads_plugin.php on line 24<br /><br />Fatal error: Call to undefined function: update_newmail() in /home/mypath/forums/ubbthreads.php on line 25[/]<br /><br />So, I commented out the function around line 24 of the plugin file.. then it was reporting the same error in that file at line 55. <br /><br />So I went ahead and replaced my original files... just wondering where to look to figure this out. <img src="/forum/images/graemlins/confused.gif" alt="" /> Also, says that one function is undefined... strange.

hard to say like that it should be this line correct?<br /> first is the table he is calling correct? if you are running both under the same database try removing $options['database']. and see what happens

Correct, that is the line.<br /><br />I may try applying the hack again, I may have missed something, but this wasn't all that complicated, so not sure what I may have done <img src="/forum/images/graemlins/grin.gif" alt="" />

each section of the hack is pretty much independant so you can really hack file by file and see the result each time.<br /><br />just make sure to start by creating the new cells in the database. and having the options in hivemail and threads set up

I have tackled this one also and am getting the same error. <img src="/forum/images/graemlins/confused.gif" alt="" /><br /><br />Here is the error on the ubbthreads.php page:<br /><br />SQL ERROR: Tue, Aug 12 2003 09:41:48 -0700 Database error only visible to forum administrators<br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/socaps/public_html/test/ubbthreads/mysql.inc.php on line 131<br /><br />Warning: Cannot modify header information - headers already sent by (output started at /home/socaps/public_html/test/ubbthreads/mysql.inc.php:217) in /home/socaps/public_html/test/ubbthreads/ubbt.inc.php on line 239<br /><br /><br /><br /><br />This is the error on the login.php page (my home link):<br /><br />SQL ERROR: Tue, Aug 12 2003 09:44:41 -0700 Database error only visible to forum administrators<br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/socaps/public_html/test/ubbthreads/mysql.inc.php on line 131<br /><br /><br />Here is what the error log is showing:<br /><br />Unable to do_query: SELECT * FROM .hive_setting - Table 'socaps_test.hive_setting' doesn't exist <br />

[]Charles said:<br />hard to say like that it should be this line correct?<br /> first is the table he is calling correct? if you are running both under the same database try removing $options['database']. and see what happens [/]<br /><br />I had the same problem. Change all the instances of <br /><br />$options['database'].<br /><br />to <br /><br />{$options['database']}.<br /><br />You will also see that there is also a $options['dbserver']<br /><br />A couple more variables also need to be treated this way.<br /><br />

I'm sorry, but which version of Hivemail do I need. Your instructions say 1.21, but I don't see that for downlad @ Hivemail.com. I'm currently running 1.2. You said that 1.2.1 is too buggy and that you would have to redo the templates for Hivemail. So when you say 1.21, do you mean 1.2 w/ SP1? One final thing, what about users who are already signed up for both the forums and the email on the same site? Will they also get the PM-style notifications? What if they have different usernames for the email and for the forums? Thanks!

I think based on the table names it should be 1.2.1 but I might be wrong.<br /><br />Another thing. There is a reference to a field called hm_emails on the ubbt.inc.php but that field is not in the database. When I did create it it still didn't show up the emails received.<br />

hm_emails needs to be added to the w3t_users table and is refeshed when you visit forum home or my home we did since in order to reduce the number of queries.

hivemail 1.2.1 is available from the member area.<br /><br />check http://forum.hivemail.com/showthread.php?threadid=1699 for more informations.<br /><br />and no users will not get the pm style notification since you need to link both accounts by entering the forum id in HM and the HMid id threads. You could do this by hand but by default users will be offered to create an account.

So if I want to link forum accounts and mail accounts that are owned by the same user before integration, it would be done manually. I haven't downloaded this mod yet, but are instructions included on how to do that? I have no problem doing it manually for my existing users.

no instructions but it is pretty straight foward add the HM id in the hm_userid field in w3t_users and the user number in hive_user in the VBid field

[]dimopoulos said:<br /><br />I had the same problem. Change all the instances of <br /><br />$options['database'].<br /><br />to <br /><br />{$options['database']}.<br /><br />[/]<br /><br />Zip updated for this.

just a note: If you are running Hivemail and UBB.threads on 2 differents databases they must be located on the same server and have the same login/password.

Maybe a bit offtopic, but where can i find some technical details about Hivemail(<br />especially the backend)?<br />Does it parse all incoming mail from a catch all account and inserts the data into a MySQL table?