Welcome to Geeklog, Anonymous Friday, April 19 2024 @ 01:39 am EDT
Geeklog Forums
Adding links in a batch query
Status: offline
ScurvyDawg
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
'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
'http://www.silentblob.com',
'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.
Thanks
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','http://www.silentblob.com',
'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.
Thanks
2
1
Quote
Status: offline
Dirk
Site Admin
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
4
3
Quote
All times are EDT. The time is now 01:39 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