VB5 to Vb4, because I was bored today

[Replicant]

...and for the sake of practicing my SQL skills. While I was supposed to be doing bodywork on my Blazer today, the rain I woke up to kind of hindered the bodywork activities. I started looking at the VB5 DB structure and doing some comparison to VB4. The VB5 DB is intermingled compared to the simplicity of the VB4 layout. After a few hours of studying the databases, I started building SQL queries. The result was better than expected. My VB4 forum was functional and running in just .....12 hours. I didn't bother with transferring PM's, blogs or social groups since this was just for fun, but my hat tips to the guys who do it for money. This conversion was done at the command line in MYSQL since I don't write PHP code. I can only imagine how much work it would take to build a script that would do it all without data loss. I'm sure they are earning every penny.

Here's a screen shot...

[Lynne]

Wow, good job! The database structure is so different between vB4 and vB5. I still get confused at times on where stuff is stored in vB5.

[Replicant]

Thanks Lynne. They are different but not so much that would make it impossible. The hardest part was the permissions and figuring out the filedata / attachments. It's nothing more than data manipulation and figuring out what goes where to make it all work. VB4 admincp helped connect the dots by running the update tools. The blogs, articles, and social-groups look to be more of a challenge. Maybe in due time. I'm using this as an exercise to develop and hone SQL skills. Maybe I'll use this as an opportunity to learn more about PHP too. I can read and understand it, just can't seem to get a grasp on writing it.

[HM666]

Originally Posted by Replicant

Maybe I'll use this as an opportunity to learn more about PHP too. I can read and understand it, just can't seem to get a grasp on writing it.

Same here I read the hell out of it and know what the hell is going on. But sit down and write the code by hand, cannot do that yet. I can do it with HTML & CSS no prob.

[CarpCharacin]

Originally Posted by HM666

Same here I read the hell out of it and know what the hell is going on. But sit down and write the code by hand, cannot do that yet. I can do it with HTML & CSS no prob.

i am the same way. I can write HTML, JavaScript and python and i can read php, but i can not just write it.