How to tell which bID goes to which page?
Permalink
I've located content block table `btContentLocal` in the database to find the page content. However, it doesn't indicate which page it refers to. Instead I get a bID reference number. How can I tell which page the bID goes to?
1. Export the database using PHPMYADMIN to an SQL file. To do this, click on the database in PHPMYADMIN, then select the Export tab. Select quick export to export to an SQL file.
2. Open the exported SQL file using Notepad++ or any other text editor that auto spaces the SQL file.
3. Search through the tables to find any associatations.
You can also get a list of tables with a specific column name using the SQL query
where ColName is the column name you are searching for.
2. Open the exported SQL file using Notepad++ or any other text editor that auto spaces the SQL file.
3. Search through the tables to find any associatations.
You can also get a list of tables with a specific column name using the SQL query
Select * From INFORMATION_SCHEMA.COLUMNS Where column_name = 'ColName'
where ColName is the column name you are searching for.
http://www.concrete5.org/community/forums/customizing_c5/is-it-poss...