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

OK. The update_newemails routine still isn't working. I tried sending myself a test email and it the newem.gif indicator didn't appear in the header....

Sorry -

I think I'm going to restore my DB and start over from sctratch.

~~~Frustrated~~~

Can't restore database - I'm hosed - starting over from scratch...

when you send an email, the email indicator will get updated only when you visit front page and my home not on any other page

Charles -

Were you able to update the SQL query file and the ubbthreads_plugin.php file?

Tom

actually I had fixed that, just forgot to upload the zip

tom if you start from scratches try using require_once instead of require

In the plugin file?

I'll be reloading everything so it'll be a while before I am able to attempt this again.

no in all the instance of require the plugin file in all thread files

I'll give it a shot. It'll be a while though.

Meanwhile, could you hack some code which will allow me to use the users "User Name" as their email account name and not give them the option of filling in the box for an email name? Maybe a display that shows the actual email address using username vice the fill-in box at the bottom.

Thanks - and if you don't have time...don't worry about it.

Tom

I am headed for bed now but promised first thing tomorrow I will do this.

it should only be a few lines to change

you can only show them what the email adress would be like in the profile since during registration we do not know the login name

Awesome - thanks

I've visited My Home after sending myself the test email and it still doesn't work . I've also visitied the ubbthreads.php page (even though Categories is my front page) and nothing. Could you test it out on my site Charles?
http://www.laondalatina.com//foros/newuser.php?Cat=
Thanks!

Charles -

I don't know if this is a problem or not but I have a question about the final instruction for Hivemail files:

--COPY PASTE------------------------------------------------

login-Template:
---------------

Replace all "vb_" parts with "ubbt_"

--END COPY PASTE--------------------------------------------

When I execute this query on my database it displays "0 (as in zero) rows modified....

So I executed the query on just that table - "login_template" - and got the same thing "zero changes"

What do you make of this?

Tom

donjulio -

The starting point for trackig down that problem lies in the "ubbt.inc.php" file @ line 334. That's where the call for the icon is.

Tom

Thanks for your concern, but that's not it. I can manually change hm_emails from 0 to any other number and the icon appears. The problem is that the field hm_emails is always 0. I imagine it's supposed to go up when you get new emails, but it doesn't. That's the problem.

not sure tom, could I access your db?

*edit* did you delete both databases when you reinstalled? if not then it was already hacked.

don julio, I created an account and got

SQL ERROR: Database error only visible to forum administrators

could you look through your log and tell me what the error is?

fixed the ubbt_plugin with what don julio sent me, I did mess up with dbname variable in some place :/

so you can download it and use this one

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

Charles -

I hacked the site to pieces trying different things. After no luck in fixing, I tried reloading the DB but it only partially reloaded so now I can't even get into Threads admin. I'll have to delete the DB and Threads AND Hivemail - literally starting from scratch. It's going to take a few days to get it up - It's exam week for me so maybe by the weekend. If you still want to check it out let me know and we'll work on details.

---EDIT---
re: DB delete:
No I didn't delete the DB before trying to restoring it - I think that's part of the problem - maybe I'll try doing that.

---EDIT 2---
Are the fixes just for donjulio or is that going to be integrated into the zip?

Tom

if you have a db backup use phpmyadmin to load it back

Yeah, I have phpmyadmin but my DB was backed up before HiveMail install so I'll have to delete the current DB (read remove HiveMail) and restore the Threads DB - still would take a day to get it done - I have an exam this afternoon and don't know if I can get it done by your AM.

k, just let me know how it goes

Didn't work - reinstalling all.

Charles -

Thanks for the code!

Just noticed - I'm s-l-o-w.

[]Charles said:
don julio, I created an account and got

SQL ERROR: Database error only visible to forum administrators

could you look through your log and tell me what the error is? [/]
That had never happened before. Strange. But I fixed it. I had replaced the ubbthreads_plugin.php file w/ the one that was in the zip yesterday morning and it didn't work. But I made a change based on what Tom said (adding curly brackets around $config on line 174 (or 147) ) and it seemed to be working. Not as well as I thought because of that error you got when registering. I went back to the version of ubbthreads_plugin.php made by Nikos (the one I emailed you) and I didn't get that error any more when I registered another test user. Weird.

Anyhow, here is a copy of the SQL error that happened when you tried to register:
[] Unable to do_query: UPDATE localhost.w3t_Users SET hiveuserid = 27 WHERE U_number = 101 - update command denied to user: 'laondal_admin@localhost' for table 'w3t_Users' [/]
I hope this helps

**********EDIT*************
Please try registering again, because that problem is gone w/ the Nikos version of ubbthreads_plugin.php. Then try sending yourself email to see if it updates as it should.

could you try again the file in the zip and tell me how it goes?

One thing that I noticed was that the query:

Unable to do_query: UPDATE localhost.w3t_Users SET hiveuserid = 27 WHERE U_number = 101 - update command denied to user: 'laondal_admin@localhost' for table 'w3t_Users'

is wrong because it refers to the host and not the database. You will need to change the

$sth = $dbh -> do_query("SELECT hm_userid FROM {$config['dbserver']}.{$config['tbprefix']}Users WHERE U_Number = $Uid");

into

$sth = $dbh -> do_query("SELECT hm_userid FROM {$config['dbname']}.{$config['tbprefix']}Users WHERE U_Number = $Uid");

and that should do it. This is what I had done in the plugin file.

this should have been fixed in the latest zip which is why I asked if you could give it a try;

I'm back up with Threads and Hivemail fresh. I'm probably going to try the integration again this Friday.

Any suggestions or "keys" to success before I hose my crap up a second time?

Tom

nope not really just follow the instructions you might want to install this on an unhacked board just to be sure.

[]Charles said:
could you try again the file in the zip and tell me how it goes? [/]

Sorry for not getting back to you on this. I tried it and then began having some database problems. I'm not sure if this caused it or not. I re-installed the database from a back-up and am currently using Nikos version of the plugin, but when I get a chance I'll give the one in the zip a try again Just remind me to do another back-up

I should have integrated nikos modifications so it SHOULD work.

please let me know if you got any errors with the DB problems

Ok. I'm glad I waited. It wasn't the ubbthreads_plugin.php file that caused the problem (as far as I can tell). I've installed the new one from the zip file and it's working the same as Nikos' version. But still now PM style notification for new emails. Has anyone got this working yet? Otherwise, everything is working well.

don julio could you give me FTP access?

Charles -
I didn't install the hack today as planned because I got to thinking...

Besides the new mail notification, what does the hack do that a link to HiveMail will not do?? It seems like a lot of code yet you still need to reskin (I'm guessing) HiveMail to match Threads, you still need to go to the HiveMail front end, you still need to log-in to HiveMail. I don't mean to insult you or your work - indeed you wrote a lot of code, I just don't want to have to reinstall all again if a link will be sufficient.

Thank you,

Tom

np well we did some thinking on what was required without having to rewrite Hivemail and this is what came out.

- Users can create an account directly from threads.

- same password for both accounts, modifiying pass in threads will change it in hivemail too. Clicking on change passwd in HM will take you to my home in threads.

- PM style notifier when you have new mail.

in the work, auto login

as for the lot of code bit, I tried to put as much as possible in the library but you still do need to include it in the files

Just PM'ed you. BTW, the site is: laondalatina.com
Can't believe I forgot to mention that

the access works but I get to an empty dir what i need is to be able to access the files so I can try to run a test or two