What is sid in lid,cid,sid

blith · Client Joined: Jul 18, 2003 Posts: 977

My old site has a 0 for sid in all my downloads, the new site has a 1 for sid in all the downloads. I am goint to try and do an insert of all the old downloads into the new table and I am working on the structure. Thank you.

Guardian2003 · Posted: Fri Aug 08, 2008 9:18 am

This post seems more of a statement of fact rather than a question. Do you need help with something?

blith · Client Joined: Jul 18, 2003 Posts: 977

Sorry, I asked it in the subject line. What is sid in lic,cid,sid?

evaders99 · Posted: Fri Aug 08, 2008 3:11 pm

Do you mean for usage in the downloads table?

blith · Client Joined: Jul 18, 2003 Posts: 977

Yes, I think I understand the lid is the main id of the download and the cid would be the category but I am not sure what the sid is...

Gremmie · Posted: Fri Aug 08, 2008 4:12 pm

It has something to do with subcategories. I've never used subcategories in my downloads, so I don't know if it works or not.

evaders99 · Posted: Fri Aug 08, 2008 11:45 pm

cid is the category, sid isn't being used in my database. My guess is that sid is the story ID, that is the News module is the only one using sid

Gremmie · Posted: Sat Aug 09, 2008 1:53 pm

No, I'm pretty sure it is for sub-category. Downloads and news aren't related.

evaders99 · Posted: Sat Aug 09, 2008 3:03 pm

Subcategories aren't set in sid though, they are set in downloads_categories table using parentid.

Gremmie · Posted: Sat Aug 09, 2008 3:49 pm

Ok, I tried looking at the code and it wasn't clear to me that sid was really being used at all in any meaningful way in the downloads table.

blith · Client Joined: Jul 18, 2003 Posts: 977

interesting, like I said earlier in an early db it was set to 0 and in the most recent install they all have a 1. I was wondering what the difference was?