Program Notes

High-efficiency random selection: <?php $num=$empire->num("select tagid from {$dbtbpre}enewstags"); $randnum=100; $randids=''; $randdh=''; for($i=1;$i&lt;=$randnum; $i++)"...

Please back up your database before running the following script! The "News Body Text" field stored in the text file is not available! To use the "News Body Text" field as the primary table, use the following SQL statement: `UPDATE phome_ecms_news SET titlepic = CONCAT(Replace(SUBSTRING_INDEX(SUBSTRING_INDEX(newstext, '"src...`

[e:loop={&quot;select classid,classname from {$dbtbpre}enewsclass where bclassid=0 and showclass=0 order by myorder,classid desc&quot;,0,24,0}] &lt;?p…

Empire cms calls the column list php code based on the column id&lt;?php /******Parameter configuration begins******/ //If the parameters are left blank, all will be called $classid = &quot;&quot;; /******Parameter configuration ends******/ if(empty($classid)){ $where = &quot;isla…

Preface: When adding or modifying fields, you can configure the "Backend Addition Information Processing Function," "Backend Modification Information Processing Function," "Frontend Addition Information Processing Function," or "Frontend Modification Information Processing Function." These allow you to specify separate functions for processing field content; this approach is commonly used for models that have special requirements regarding the storage format of field content. Below is a brief explanation of the basic steps for creating and configuring these processing functions: 1. Write the processing function; 2. Copy the function to e/c...

It's best to carefully review this code before replacing the form you want to clone; otherwise, if any errors occur, I won't be held responsible. <form action= "!--news.url--]e/search/index.php" method= "post" name= "searchform"...

To access the content of a sub-table field within a list template, you should use the "list.var support program code." Below is an example of list.var template code used to retrieve the "newstext" field from a news sub-table: $fr=$empire->fetch1("select newstext from {$dbtbpre}ecms_news_data_{$r...

This plugin is merely a supplementary add-on; the Empire version does not matter – either 7.5 or 7.2 will work. Duplicate tags will not be successfully inserted. PHP code: <?php require('../e/class/connect.php'); require('../e/class/db_SQL.php'); $link=db_connect(); $e...

The Empire CMS system can be completely emptied using the following SQL statements – this includes all article content, categories, tags, and member groups. If you have just purchased a new template and the data contained within it does not meet your requirements, you can use the following SQL commands: `TRUNCATE `[!db.pre!]ecms_news`;` or `TRUNCATE `[!db.pre!]ecms_news_check`...`.

To retrieve the "Previous Article" and "Next Article" codes for the current article using the Lingdong Tag in EmpireCMS: [e:loop={'selfinfo',1, 0, 0, 'id&lt; '.$navinfor[id].'','id desc'}] &lt;a href=&quot;&lt;?php echo $bqsr[titleurl];$pre='tr...