[]Astaran said:<br />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? [/]<br />Yes that is what it does Astaran. A cron script or a scheduled task in windows is responsible for this. The data is stored either in the database (the whole message) or in a file and the database (some data like the headers etc.)

Also Stefan if I may a couple of corrections:<br /><br />1. ubbt.inc.php<br />Function send_header. You need to include in the authenticate function the hm_emails field, otherwise it will always return zero. Hence you need to find this:<br /><br /> // -------------------------------------------------------------------<br /> // If we don't have a status then they we need to try and authenticate<br /> if (!isset($user['U_Status'])) {<br /> $userob = new user;<br /> $user = $userob -> authenticate();<br /> }<br /><br />and replace it with this:<br /><br /> // -------------------------------------------------------------------<br /> // If we don't have a status then they we need to try and authenticate<br /> if (!isset($user['U_Status'])) {<br /> $userob = new user;<br /> $user = $userob -> authenticate("hm_emails");<br /> }<br /><br /> if (!isset($user['hm_emails'])) {<br /> $userob = new user;<br /> $user = $userob -> authenticate("hm_emails");<br /> }<br /><br />2. ubbthreads_plugin.php<br />Function update_newmail<br /><br />Change the function to :<br /><br />function update_newmail() {<br /> global $dbh, $config;<br /> <br /> $userob = new user;<br /> $user = $userob -> authenticate("hm_userid");<br /> <br /> if ($user['U_Number']) {<br /> <br /> $Uid = addslashes($user['U_Number']);<br /> $hiveid = $user['hm_userid'];<br /> <br /> if ($hiveid != "0") {<br /> $query = "SELECT userid FROM {$options['database']}.hive_message WHERE userid = $hiveid AND status = 0";<br /> $sth = $dbh -> do_query($query);<br /> $count=mysql_num_rows($sth);<br /> if ($count > 0) {<br /> $newemail = $count;<br /> } else {<br /> $newemail = 0;<br /> }<br /> $dbh -> do_query("UPDATE {$config['dbname']}.{$config['tbprefix']}Users SET hm_emails = '$newemail' WHERE hm_userid = $hiveid");<br /> }<br /> }<br /><br />}<br /><br />This will use the .threads authenticate to see if the user is logged in and with one query retrieve the hm_userid as well. Also please note that the UPDATE query needs the {$config['dbname']) and not the 'dbserver', otherwise it points to the localhost (or wherever your DB is stored) instead of the database name.<br /><br />It is working great for me!! Great job!<br /><br />(now all I have to do is create some templates to match those of the .threads <img src="/forum/images/graemlins/tongue.gif" alt="" />)

dimopoulos I don't think this is needed.<br /><br />The way I chose was to have hm_email by default in the userob routine so it is part of the default just like new PM, maybe I missed that part will documenting the hack but It should work like this.<br /><br />OK, checking the code I did forget something <img src="/forum/images/graemlins/tongue.gif" alt="" /> gimme a minute to tell you what it is supposed to be.

there my code in ubbt.inc.php was <br /> <br /> <br />since hm_emails is used on all pages we need it here, sorry for the bug <img src="/forum/images/graemlins/tongue.gif" alt="" />

[]Astaran said:<br />Maybe a bit offtopic, but where can i find some technical details about Hivemail(especially the backend)?<br />Does it parse all incoming mail from a catch all account and inserts the data into a MySQL table? [/]<br /><br />It's choosable ... saving in MySQL or flatfile ...<br /><br />english / german features list<br /><br />

the zip was updated in order to reflect my mistake<br /><br />*Baaaad Charles*

Thanks Charles

also just for your info your update email function cannot work because we need to know if we have new emails BEFORE we identify otherwise the flashing image will use the old data. The goal is to update the data before we actually call for it <img src="/forum/images/graemlins/smile.gif" alt="" />

I am writing a small installer to handle the sql part. <br /> <br />for those who can't wait you can run the following command to update your login template <br /> <br /> <br /> <br />hope this will help some of you <img src="/forum/images/graemlins/tongue.gif" alt="" /> <br /> <br />Updated to replace both cells, untested let me know if it works.

Charles, do we need to change the parsed_data field as well or just the user_data?

well I tried the hivemail CP and apparently the only thing tou can edit is the user_data field. the other one is used I think to know which ones have been changed but I am not sure.

[]dimopoulos said:<br />Charles, do we need to change the parsed_data field as well or just the user_data? [/]<br /><br />the parsed template parts of hm will be updated on saving the template ... forget about this.

well yes but since we don't edit through the CP should I modify it too in my query?<br /><br />what is it used for?

Right Charles, forgot about this ... we need to update this too <img src="/forum/images/graemlins/laugh.gif" alt="" />

... only if we're using your install - script <img src="/forum/images/graemlins/smile.gif" alt="" />

ok updated the query

Let me know when everything is figured out... then I'll try to install it again <img src="/forum/images/graemlins/grin.gif" alt="" />

it should be perfect now []http://www.threadsdev.com/threads/php/uploads/panels/9432-2968.png[/]

oh sure, right when I prepare myself to take a nice break, it's ready <img src="/forum/images/graemlins/grin.gif" alt="" /> I need a nap, you guys make my head spin

well it works great when I do it but I need you guys to tell me when I forgot to put all the code in the files <img src="/forum/images/graemlins/tongue.gif" alt="" /> now if I did everything were would the fun be? <img src="/forum/images/graemlins/tongue.gif" alt="" />