Ok, so I bought this template http://www.templatemonster.com/oscommerce-templates/15612.html
and I’m trying to change the name of the category name in the left panel titled “CHOOSE A CATEGORY”
I’m completely new to PHP and I’m pretty lost. I’ve looked in the /includes/boxes/categories.php but it doesn’t seem to be there. I’ve looked all through the admin panel and can’t find it there either. Can anyone offer some insight please?
Do a trace back from the index page its displayed on. Check for menu includes etc.
In dreamweaver you can do an entire search of the site files for category.
The problem with that is that there are references to “categories” everywhere.
TABLE_CATEGORIES
TABLE_CATEGORIES_DESCRIPTION
I have no idea which of the thousands of references to categories is the one to change.
<table cellspacing="0" cellpadding="0" border="0">
<tbody><tr>
<td> <img src="tt1_left.jpg" alt=""><br>
</td>
<td style="background:url(images/tt1_body.jpg) no-repeat left top; width:100%;" class="title_txt1"> <img src="spacer.gif" alt="" width="1" height="8"><br>
Categories<br>
</td>
<td> <img src="tt1_right.jpg" alt=""><br>
</td>
</tr>
</tbody></table>
This is the demo table which displays categories. It is surrounded by two
tags so try searching for that.
Or search for tt1_body.jpg
It’s hard to say where you will find it because I don’t have access to the template, so all I can do is offer some suggestions.
If it’s not bad form, I’ll send you the template. I really need the help and I am not versed enough to find it. I found reference to tt1_body.jpg in includes/classes/boxes.php but nothing that says ‘categories’ that I can find.
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td> <img src="images/tt1_left.jpg" alt=""><br>
</td>
<td style="background:url(images/tt1_body.jpg) no-repeat left top; width:100%;" class="title_txt1"> <img src="images/spacer.gif" alt="" width="1" height="8"><br>One more thing…
If you take a look at that template, there is another box less commonly named “What’s New Here?”
So I used Dreamweaver CS5.5 to search both source code and text from my entire website and it doesn’t find anything. I searched for that term because there could only be a few instances of it and I could get a better idea of where ‘categories’ might be.
I emailed you yesterday.
The other thing would be to check the database, it could be stored in there.
I’m sorry brother. That is my spam account. Could you possibly send again?
Seems like such a simple thing.
So in /includes/database_tables.php I saw
define(‘TABLE_CATEGORIES’, ‘categories’);
So I changed ‘categories’ to ‘wholesale packages’ and I get this…
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘c, categories_description cd where c.parent_id = ‘0’ and c.categories_id = cd.ca’ at line 1
select c.categories_id, cd.categories_name, c.parent_id from Wholesale Packages c, categories_description cd where c.parent_id = ‘0’ and c.categories_id = cd.categories_id and cd.language_id=‘1’ order by sort_order, cd.categories_name
[TEP STOP]
Change it back. Unless your going to change the database tables name aswell. Because thats setting up the global name.
I ment to check the sql database in phpmyadmin.