Solved

wordpress where to find category insert queries

Posted on 2008-06-14
6
323 Views
Last Modified: 2012-06-21
hello,
simple question:
in which wordpress file, there are mysql query, which is inserting new category through admin panel. I examined whole code and didnt found that thing. Let me know, thanks!
0
Comment
Question by:springfresh
  • 2
  • 2
6 Comments
 
LVL 17

Expert Comment

by:nanharbison
ID: 21786512
the name of the table in the database that stores categories is called:
terms
here is the insert statement:
$wpdb->query("INSERT INTO $wpdb->terms (name, slug, term_group) VALUES ('$cat_name', '$cat_slug', '0')");
(line 66 on my computer)
I found this insert statement in a file in the includes folder called upgrade.php. There is a file in this folder called category.php, but the functions there all prepare the data to display it in the blog
0
 

Author Comment

by:springfresh
ID: 21787783
strange thing. But i commented this line. And new category insertion still works through admin panel :\
0
 
LVL 17

Expert Comment

by:nanharbison
ID: 21789477
hhhmm, the same query is on line 569 and 642. these two are the same query but get called depending on the version of the database you are using. I don't know what you are using, so comment out both of them.
0
 
LVL 15

Accepted Solution

by:
dosth earned 500 total points
ID: 21855931
it will be in wp-includes\wp-db.php

line 325 -

function insert($table, $data) {

this will be a generic function called from

wp-includes\taxonomy.php line 1163

function wp_insert_term( $term, $taxonomy, $args = array() ) {
0
 
LVL 15

Expert Comment

by:dosth
ID: 21890145
did you get a chance to check it ?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Read about how to approach blogging and about ways to do it right. Stand out from the crowd and let your knowledge be consumed by a large audience. This article aims to explain how your blog should look like,  the most important things to do while b…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now