More fields in idx_category ??

[Frank71]

Hello,
ok, I can't wait longer for the new version, because perhaps it will come never - sorry dody, but how my spanish wife you said every time "tomorrow".and this nearly since 6 months...

I want to use more own fields for the category table (idx_category) to use the category "name, "decription", "content", "meta_keyword" and "meta_description" also in english for the english part of my directory.

My problem how to add these fields and what should I change in the code to use these new fields in all my templates ?

Hope someone can help.

Greetings
Frank

[sofiah]

Frank,


To add the fields in idx_category, you need to add manually (phpMyAdmin will ease you to do that). You also need to change cat_add.php, cat_edit.php, and category.class.php. The template also need to be modified.

Sofiah

[Frank71]

Thank you, I will try this, but please ask dody for V3.1.
We are waiting nearly 6 months...
Frank

[Frank71]

Hello Sofiah,
Please can you give me a short excample what I have to change / add in category.class.php, then i create a new field for the categories ?
Greetings
Frank

[sofiah]

Here is the example :

This is the query in Add function :

    $query = "insert into $this->table_name
      (name, parent_id, description, image, content, visible, links, permission, meta_keyword, meta_description, registered_only)
      values ('$name', $parent_id, '$description', '$image', '$content', $visible, 0, $permission, '$meta_keyword', '$meta_description', $registered_only)"; 

If you add fields myfield1,myfield2 then it will be :

    $query = "insert into $this->table_name
      (name, parent_id, description, image, content, visible, links, permission, meta_keyword, meta_description, registered_only,myfield1,myfield2)
      values ('$name', $parent_id, '$description', '$image', '$content', $visible, 0, $permission, '$meta_keyword', '$meta_description', $registered_only, '$myfield1', '$myfield2')"; 

And the function parameters will be :

  function Add($name, $parent_id, $description, $image, $content, $visible, $permission, $meta_keyword, $meta_description, $registered_only, $myfield1, $myfield2) 

Btw, you should add the fields in idx_category first.