Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 20 Mar 2015, 08:03
Replicant's Avatar
Replicant Replicant is offline
 
Join Date: Sep 2014
Real name: Mel
VB5 to Vb4, because I was bored today

...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...

__________________
VB5 mods - RepliClock VB4 mods - Member Online Status
Reply With Quote
  #2  
Old 20 Mar 2015, 18:08
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: 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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 21 Mar 2015, 19:27
Replicant's Avatar
Replicant Replicant is offline
 
Join Date: Sep 2014
Real name: Mel
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.
__________________
VB5 mods - RepliClock VB4 mods - Member Online Status
Reply With Quote
  #4  
Old 22 Mar 2015, 04:14
HM666's Avatar
HM666 HM666 is offline
 
Join Date: Jan 2014
Real name: Len Kaiser
Originally Posted by Replicant View Post
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.
Reply With Quote
  #5  
Old 22 Mar 2015, 05:52
CarpCharacin's Avatar
CarpCharacin CarpCharacin is offline
 
Join Date: Dec 2014
Real name: James
Originally Posted by HM666 View Post
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.
__________________
Utah Fishkeepers
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 12:10.

Layout Options | Width: Wide Color: