Manual SQL

[tfw2005]

OK, so Ive played with entering info in bulk via PHPMyAdmin. Seems to be working, just want to run things over and see if I am indeed doing it right.

To get a full entry in place, I need to enter info for these three tables...


INSERT INTO `adv_dyna_entries` (`entryid`, `title`, `catid`, `keywords`, `userid`, `username`, `dateline`, `lastupdated`, `views`, `posts`, `iconid`, `attachid`, `valid`, `open`, `sticky`, `draft`, `private`, `hasattach`, `showsignature`, `notes`, `votenum`, `votetotal`, `ipaddress`, `lastpostid`, `lastpostdateline`, `lastpostuserid`, `lastpostusername`) VALUES ......



INSERT INTO `adv_dyna_entries_pages` (`entryid`, `title`, `pagetext`, `pagenumber`, `allowsmilie`) VALUES



INSERT INTO `adv_dyna_entryparsed` (`entryid`, `pagenumber`, `pagetext_parsed`, `dateline`, `styleid`, `languageid`, `hasimages`) VALUES


Making sure that the entryid, pagnumber, dateline match up for all, and that generic stuff like signature, styleid, allowsmilie, all have proper values 1/0 etc, '' empty quotes, or NULL, depending on what it is.

And, updating counters when done.

I did that, got like 600 entries in, showing up. Just want to make sure some other table doesnt need to be incremented somewhere for posts to show up, be searchable, etc. Or, if one of those can be omitted, since it will update when edited, function without being editied until it is. Etc.

Thanks!

[Brian]

My only suggestion would be to leave out the 'adv_dyna_entryparsed' table as that one will be built "naturally" as users are browsing entries anyways. It might be better just to let it be rebuilt that way to ensure that the parsed code is inserted properly as well. Other than that, looks like you've got it down pretty well. :)

[tfw2005]

Awesome. Thanks for the confirmation. Back to work I go!