MySQL Help (Merge databases)

[Bumpa STIKKA]

Anyone with MySQL experience out there that would like to help out me and the forum?

Your mission, should you choose to accept it, would be to somehow merge the database of this forum with the database of our new video TUBE site.

Just out of interest - is this a straightforward task or something that requires a shit load of time and effort?

Cheers,

BS

[manarak]

depends what you understand under the word "merge"

if it is to have all tables of both applications in the same "database", it is piece of cake as long as the tables are named differently or can be assigned a name prefix.

if you mean merge users and passwords, you can make it a real project.

the best in this case would probably be to write a small script to sync users between the two, rather than merge, which could open a pandora box of endless trouble.

Such script could be relatively easy to make work if both user tables use the same encryption method for passwords (MD5, base64 or... none!).

If the forum uses MD5 or better and the tube site a lower or different encryption, there will be a major problem, because MD5 is a one-way encryption - no way to tell the clear password from a MD5 hash.
Then more tricksing is required.

[Bumpa STIKKA]

I want both the forum and the TUBE site to be one and the same database.

There are no members of the tube site yet so that's not an issue. The few that have signed up can just be deleted.

Basically, I want it to work so that when members register for the forum they can log on to both the forum AND the Tube site using the same information.

I'll probably do away with the sign up feature on the TUBE area and have people register only on the forum for both areas...

I hope that makes it clearer!

Let me know if this is workable...  

[manarak]

I edited my post above... please check encryption levels.

[BAM]

I ran a test... I added a new user to the forum and the tube site with the same pass of 1234567890 ... then I checked MySQL to see if the pass was saved the same way using the same encryption type... sadly they were not the same.

My results are posted in the Staff area for security reasons....


https://theladyboyforums.com/cgi-bin....248;r=1

[manarak]

then this will take some more time than just writing a lil' script!

did you find out which algorithms were used?

[Bumpa STIKKA]

Darn...

I was hoping this would be easy.

The reason I want it is because when I get about 500 videos on the TUBE site I'll switch it to VIP only.

But maybe I'll figure out another way to do that!

[manarak]

I know a way IF you find out the algorithms for me...

I found out about iconboard using the crypt() function, which codes the passes in IB3 format.

CODE[/quote]

function ib3_pass($name,$pass)
{
return crypt( $pass, substr( strtolower($name), 0, 2) );
}
[/quote]

I could not find out what Tube Ace uses.
Maybe you could ask their support.


Ikonboard passes cannot be "decrypted". So you can't just run a script on database 1 and generate users and passes for database 2.

The easiest is probably to add a script to the Ikonboard login and password change procedure.

When someone logs in, you detect his membership level, and if he is a VIP the script encrypts the password with Tube Ace's algorithm (I would bet it is MD5) and then inserts or updates the user in the Tube Ace user table.
The same script must be triggered when the user or an admin changes that user's password.

[manarak]

I just thought that the script also has to take into account membership level changes, i.e. check at every login against the membership level.

[Bumpa STIKKA]

Interesting... So there is hope, yet!

[manarak]

yes... but isn't Ikonboard coded in Perl ?

[Snick]

you need to modify the video tube software to use the forums method of encrypting passwords.

[BAM]

(Snick @ Aug. 12 2010,20:44) you need to modify the video tube software to use the forums method of encrypting passwords.

To make matters worse the Tube sites using ionCube to keep us from knowing much about how it works. I now wish we had using an open source tube  

If you guys want to still have a go at it then Stogie let me know and I'll give these cool cats access.  


I doubt we€™ll get much info out of Tubeace as their support is mostly non existent. The free install they did was so half ass they left it without even configuring the server properly. They didn€™t even install some of the required components. Left it all up to us to figure out€¦ and there was little to no documentation to go by.

[Bumpa STIKKA]

Well... let's think about it for a while...

It's easy enough to restrict the TUBE to VIPs - I'll just have to do it manually!

[manarak]

It's easy enough to restrict the TUBE to VIPs - I'll just have to do it manually!

wouldn't you have to know which passwords are used by your VIP members then?

Best way: find out which password encryption tube ace uses.
I would bet it is MD5, as MD5 support is built into PHP.

You can solve everything that way, without modifying Tube Ace and by modifying Ikonboard only slightly.

Also, rather than changing all the login signup and whatever procedures, a php script could compare the databases and sync the Tube Ace DB with the forum.
This script could be run every minute or so on crontab.
But this again requires to know the pass encryption on the Tube.