Jump to content

Remenission

New Members
  • Posts

    8
  • Joined

  • Last visited

Remenission's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Jacques1 I'm going to try and make some major changes to shift out of using global id's and make more tables for different things as you suggested. Thank you!
  2. For the business I work for I have a platform setup that handles everything from messages to photos to blogs etc. I have two tables that show id releations: CREATE TABLE IF NOT EXISTS Relations ( sender int(9), receiver int(9), relation tinyINT NOT NULL DEFAULT 0 /* -1=Delete, 0=[Add]Pending, 1=related, 2=Blocked */ ); CREATE TABLE IF NOT EXISTS Rating ( owner int(9), id int(9), rating tinyint(1) /* - 0 through 9 rating - */ ); With these tables I can relate any ID to any ID: With relations table I can relate a user to any other user, or to any other group ETC... With the rating table I can have a user rate any group, page, blog, message, photo, album etc... Because of this I have globally unique id's. No message will have the same ID as a blog, or a user, or a group, or a page. Currently I manage this in this manner: ID's: (I added commas for readability) (1)00,000,000 - users (2)00,000,000 - groups (3)00,000,000 - albums (4)00,000,000 - photos (5)00,000,000 - blogs (6)00,000,000 - msg As you can see, each object is represented by the leading digit. So currently, to make sure they are all distinct, before anything is inserted I am doing a full join on all of these tables for the column 'id'. If any results come back it generates a new 'id' to test for uniqueness. I feel like the way I have this setup could probably be done a lot cleaner and smoother. I have tried googling solutions, but I haven't had much luck because my scenario is kind of complex: not to say others haven't encountered this issue. Anyways, if anyone has any thoughts or opinions I would greatly appreciate it. Thank you guys ~ Remey
  3. Hi there, I'm trying to rework my framework a bit to make it more solid, and I have been storing encrypted account data as an array in session. However, since that data is being loaded every time a session is opened. I'm curious if perhaps it would be better to just use an sql request to load the data instead. I think both have their pros and cons, but I'm curious what you guys think. Thanks! Also, because I hate feeling like a leech. I am gonna try and help out a few others as well in the meantime.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.