Tube and forum intergration

[fresh_gumbo]

Hi guys, Love your work so far, just wondering though if there's an easy way to link a users details in the forum with posts in the tube, for example, now if you click on say Mondomonger's name you can see when he joined, how many posts and threads he has done, can you include video's uploaded? As far as I can tell the only way to see this is copy his username, go over to the tube side and search it there?!?

Just a thought

 

[dpfks]

Yah that's the long-term plan.

It's hard trying to integrate 2 separate systems. It took us a really really long time to make 1 registration, and 1 login to work for both the tube and forums.

Long-term goal is a seamless, integrated system. Working on some features for the creators at the moment =)

 

[fresh_gumbo]

Ahh no worries, It's really no massive deal, great to know its already in the works too

 

[riddim1234]

I'm an infra guy, I don't know much about developing so sorry if I say something stupid here...

But wouldn't you simply be able to create a new table with the needed info from the 2 db's and get your data from there?
You'll just need to rewrite your site code to look for the data in the new table instead of the original one.
Alternatively, but sloppier, do an inner join on the tables when you fetch your data?

If you use SQL I can help with writing the triggers etc if needed

 

[fresh_gumbo]

I'm an infra guy, I don't know much about developing so sorry if I say something stupid here...

But wouldn't you simply be able to create a new table with the needed info from the 2 db's and get your data from there?
You'll just need to rewrite your site code to look for the data in the new table instead of the original one.
Alternatively, but sloppier, do an inner join on the tables when you fetch your data?

If you use SQL I can help with writing the triggers etc if needed

Fuck yeah, funny enough I know nothing about website building but I can actually code in SQL as well, I had not thought that it could be as simple as a database, but you wouldn't need to create a new table if the one account name is linked to both sites you would already have a common variable, you would be better off keeping the 2 db's separate and just joining on user name. I don't see it as sloppy as much as separation of the data which is a good thing

 

[riddim1234]

I'm an infra guy, I don't know much about developing so sorry if I say something stupid here...

But wouldn't you simply be able to create a new table with the needed info from the 2 db's and get your data from there?
You'll just need to rewrite your site code to look for the data in the new table instead of the original one.
Alternatively, but sloppier, do an inner join on the tables when you fetch your data?

If you use SQL I can help with writing the triggers etc if needed

Fuck yeah, funny enough I know nothing about website building but I can actually code in SQL as well, I had not thought that it could be as simple as a database, but you wouldn't need to create a new table if the one account name is linked to both sites you would already have a common variable, you would be better off keeping the 2 db's separate and just joining on user name. I don't see it as sloppy as much as separation of the data which is a good thing

If they want to merge the environments it'd be cleaner to have it in one place. 

If it just a db behind it, they probably have a table 'tubeuser' and 'forumuser' each in their own db (cause separate environments) with their own relations
which would be redundant, potentially messy for your joins , and annoying to keep track of updates across 2 db's


But like I said, no dev experience so i actually have no idea how the data is stored, and this could all be useless

 

[dpfks]

I'm no developer either =P

Currently the system is 2 separate DB due to ease and probably limited knowledge. Ideally 1 single DB would be great, but right now it's much harder than just user names.

For example:
- different password hashing
- other features (block, change passwords, PM, commenting, etc) across both tube + forums

Also upgrading tube or forums independently is kind of a nightmare with custom code...

For now we have a temp fix for signup -> creates both tube + forums. Changing password -> changes both tube + forums... But thats about it so far