Author Topic: Baby Names SQL File  (Read 1459 times)

0 Members and 1 Guest are viewing this topic.

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


« Reply #1 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...


« Reply #2 on: April 01, 2011, 09:09:41 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...