Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Unanswered: need help with db conversion

    Looking for anyone that has experience in converting mysql database into straight line txt database like so:

    username:password:email:and:some:others

    We purchased a script and found out it was not mysql, our original script was mysql, there are 19K+ members in the database with multiple downlines. So either the entire database is to be converted or we need someone that can convert the script to use mysql instead. The script is cgi.

    If there is anyone who is willing to take a look and give us a quote on a price for this job then please contact us

    tinboy22@telusplanet.net

    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    I am not sure about what you need
    you have a MySQl db that you need to dump it into a flat text file.
    Dumping data from mysql is not very difficult to do what is your db structur

    Or convert a cgi script to use mysql db instead of a flat file ?
    What is your cgi language ?
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Oct 2003
    Posts
    3
    I wish it were that simple, but its more than just that, its how they are arranged, when there are downlines it totally changes.

    here is an example of what it looks like :

    Code:
    adminusername:adminpassword:admin@email.com:5:0:1:0:1:1:phonenumber:admin@email2.com:1:2:10103:1::admin2@email.com.net:1:1:  
                                                                                                                                                                                                                  
    
    Justin:password:email:0:1:1:3:1:1:phonenumber:admin@email2.com:1::10103:1::admin2@email.com:1::                                                                                                                                                          
    
    
    Jack Ripper:password:jackripper@msn.com:2:0:1:0:0:2:phonenumber:admin@myfavouritehost.com:1::10103:1::admin2@email.com:1::                 
    
    
    Tony Roze:password:email:3:0:1:0:0:2:phonenumber:admin@email2.com:1::10103:1::admin2@email.com:1::                
    
    
    
    Bobby James:password:email:0:4:1:0:1:4:phonenumber:admin@email2.com:1::10103:1::admin2@email.com:1::  
                                                                                                                                                                                                                     '
    
    flajismjasm:password:email:5:0:1:0:0:3:phonenumber:admin@email2.com:1::10103:1::admin2@email.com:1::
    so how this works is after each persons phonenumber it puts the 1st levels user info,

    :0:1:1:3:1:1: this part we sort of figured out but not entirely sure how it works. as data is filled into this dat file under another folder called downline there are sub folders that say level 0, level 1, level 2 etc
    in the level 1 folder is a file created called 1
    in that file it says 0,2,3,4,5,6

    as bout your question what kind of cgi it is, not sure what you mean by that.

    thanks

  4. #4
    Join Date
    Oct 2003
    Posts
    3
    forget about this post, my friend found someone who will take on this task

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •