What is sid in lid,cid,sid

blith · Posted: Fri Aug 08, 2008 8:52 am

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 · Site Admin Joined: Aug 28, 2003 Posts: 4816

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

blith · Posted: Fri Aug 08, 2008 10:26 am

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

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2844

Do you mean for usage in the downloads table?

blith · Posted: Fri Aug 08, 2008 3:38 pm

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 · Moderator Joined: Apr 30, 2004 Posts: 2844

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 · Moderator Joined: Apr 30, 2004 Posts: 2844

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 · Posted: Wed Aug 13, 2008 10:11 am

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?