Welcome to Geeklog, Anonymous Thursday, November 28 2024 @ 02:46 am EST
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
9
8
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
11
10
Quote
All times are EST. The time is now 02:46 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