Quoth Rapscallion
View Post
-
Unfortunately, that's where my knowledge ends. We have our own database architect that deals with that stuff and all I do is retrieve and store information into that database. My first guess would be to take a look at something like MySQL or MS SQL Server 2000. Btw, you the database is probably set up as a relational database so you may have to look across multiple tables via foreign keys to get the post information you want. Hopefully, someone on here who knows a little bit more about database programs can help you. -
Er, which program do you use to do the searching? I know it's SQL (Structured Query Language), but I don't know how to go into them.
RapscallionLeave a comment:
-
I do not know the specifics of how databases for a forum works, but I'm assuming it's the same as any other SQL database. You need to first find out how the database is structured. Find out what the field is that stores the poster's user name then run a SQL search query on that name and field. This is assuming you are using an SQL database.Quoth Rapscallion View Post
It should be something along the lines of:
SELECT * FROM <Database_Name> WHERE <Username Column> = '<username>'
I do some development where I have to interact with databases so my knowledge is not at all complete. I hope that I read and understood your question correctly and that I may have answered...or at least given you an idea of where to go. If this wasn't what you were going after or already know this stuff, sorry I probably just misread the question.Leave a comment:
-
Opening a database
I run more than one forum. I moved one to this server last night, but the sql dump wasn't having anything to do with inserting into this server's database.
Question is, can I access the database and get posts out of there? If so, how? I need posts that were posted by one specific user.
Rapscallion
Leave a comment: