WordPress & MySQL

software development

#1

Hello. Does anyone know what these fields are used for in a WordPress database?

From ‘comment’ table:
[LIST]
[]comment_karma
[
]comment_agent
[]comment_type
[/LIST]
From ‘posts’ table:
[LIST]
[
]to_ping
[*]pinged
[/LIST]

Correctness Commentary


#2

Comment Karma is used to filter spam. The comment is given karma “points” based on certain criteria. (By the way, I absolutely recommend the SpamKarma plugin for Wordpress…it’s simply awesome for spam management).

Comment agent I believe lists the kind of browser is used to post the comment (or if it’s a bot). Again, another feature to prevent spam.

Type is whether it’s a trackback or an actual comment.

I’m not sure what the POSTS table stuff is.

I hope this helps!
Angela

================================
Angela Gann
CrimsonDryad Web Design Services
Web Design, Custom Software Development
http://www.crimsondryad.com


#3

Thank you, Angela. This is very helpful. Basically, what I am trying to do is write my own interface to the WordPress database on my website. I like it’s admin features, but the available skins are very limitting. One of the things I would like to do is have a comment held for screening, until I can approve it. Do you know if the WordPress database already has a flag for this, or will I need to add it? Thanks again.

Correctness Commentary


#4

Did you explore the codex.wordpress.com resources? This Database Description article might be helpful (there is a lot of information in the codex! :wink:

–rlparker


#5

Yes, wordpress will already hold comments for moderation, you have to set the flag for it to do that. I think it’s under options or discussion (sorry I’m not more specific, I found what I wanted and then promptly forgot about it).

You know you can reskin Wordpress, right? Just take one of the themes that sorta looks like what you want and change it. For instance http://legislativereport.tenneconomics.com was originally the Connections theme.

It’s probably easier to change the theme than write a new interface to it.

================================
Angela Gann
CrimsonDryad Web Design Services
Web Design, Custom Software Development
http://www.crimsondryad.com


#6

Hello Angela. That would definately be preferable. However, WordPress installs a ton of files to the site. Do you know which ones can be changed without breaking the WordPress engine? Or, can you recommend a good site with some tutorials? Thanks. :slight_smile:

Correctness Commentary


#7

http://codex.wordpress.org/

http://wordpress.org/support/

http://wordpress.org/docs/

All of the above are excellent, and you will likely find them to be helpful. :wink:

–rlparker


#8

If you go under presentation and pick a theme, you can then edit the individual theme files. Definitely back everything up first (and periodically) in case you accidentally whack something, but really the php to move stuff around is pretty simple.

================================
Angela Gann
CrimsonDryad Web Design Services
Web Design, Custom Software Development
http://www.crimsondryad.com