livemods

General Category => Paid Requests => Topic started by: Xarcell on March 29, 2011, 04:02:57 PM

Title: Baby Names SQL File
Post by: Xarcell on March 29, 2011, 04:02:57 PM

SMF 2.0RC5

I have a custom babynames mod for my SMF site.

I have a sql file that I purcahsed that has 30,000 names, meanings, etc etc in it. I would like to try and make it compatible with a custom Babynames mod for SMF, where I can just import the SQL file.

So, the sql, uses 2 tables, but only one is important: "Names", that has 6 fields(?), but only 5 are needed.

* Names
- id
- name
- meaning
- gender
- origin

My Babyname mod uses 5 tables.

* smf_babynames
- id_name   author   
- date   
- bname   
- gender   
- origin   
- meaning   
- is_active   
- rates

* smf_babynames_comments
- id_comment   
- id_name   author   
- body   
- date   
- last_modified   
- modified_name

* smf_babynames_rating
- id_rate   
- id_member   
- id_name   value

* smf_babynames_favorites
- id_name   
- id_member

What would you charge to alter the SQL file to make it so that I can import the 30,000+ meanings, origins, etc etc to work with my Babynames mod? If that is, your willing to do it.

Title: Re: Baby Names SQL File
Post by: live627 on March 30, 2011, 10:19:56 PM

So smf_babynames needs all 30k rows imported. What is `author`?  Does it hold member name or member id?

That would be $20.

I've been thinking about this... author needs to default to something...

Title: Re: Baby Names SQL File
Post by: Xarcell on April 01, 2011, 09:09:41 PM

Quote from: live627 on March 30, 2011, 10:19:56 PM

So smf_babynames needs all 30k rows imported. What is `author`?  Does it hold member name or member id?

That would be $20.

I've been thinking about this... author needs to default to something...

I managed to figure out how to do this on my own. Woo Hoo for me!

However I have some small projects that need work if your interested. I created a new topic for those...