Welcome to Geeklog, Anonymous Sunday, July 21 2024 @ 05:28 am EDT

Geeklog Forums

Adding links in a batch query

Status: offline


Forum User
Full Member
Registered: 11/06/02
Posts: 523
I am adding a batch of links through an sql query and I have a question.

I have

Text Formatted Code
INSERT INTO gl_links VALUES ('', 'Games', 'http://www.sierra.com',
 'Sierra.com the makers of many of the games you play ',
 'The Sierra Web Site',
 '0', '2003-01-18 16:02:52', '1', '1', '3', '3', '2', '2');

as a link to add right but I see a couple differences from that and my saved datavase. for instance
Text Formatted Code
INSERT INTO gl_links VALUES ('20021115192738175', 'Curiosities',
 'Well it is the Silentblob. He doesn't have much to say, but he's cool.',
 'The SilentBlob', 18, NULL, 5, 7, 3, 3, 2, 2);

Firstly the lid is the first value from the key I have and I have all of the fields for that value empty. I want to how GL assigns lid value? I also see that where the database has a value of NULL I have a date. I forsee this giving me issues.

Any opinions as to what I need to do to correct this would be appreciated.

I will also post this on the Squatty site.


Status: offline


Site Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Well, why don't you simply look it up in the code? Searching for "lid" in submit.php will bring up this line: $A['lid'] = COM_makeSid(); So this is how the lid is created. As for the date - that field wasn't really used up until 1.3.7sr1. Putting a date in there is correct (now) and shouldn't give you any issues, even if you're not running 1.3.7sr1, since it 's simply ignored in older versions. bye, Dirk

All times are EDT. The time is now 05:28 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content