Hongmu Notes
Home › Program Notes › Common SQL Code Summary for Empire CMS
Program Notes Empire cms

Common SQL Code Summary for Empire CMS

updated on 2023-02-16 16:29:18 Browse 323 📖 approx. 10 minutes
Common SQL Code Summary for Empire CMS

I'm keeping this place for storing the SQL code I use frequently – it'll be handy to refer to later!

SQL code for version 7.5

TRUNCATE phome_enewsuser;
TRUNCATE phome_enewslink;
TRUNCATE phome_enewsuseradd;
TRUNCATE phome_enewslog;

INSERT INTO `phome_enewsuser` (`userid`, `username`, `password`, `rnd`, `adminclass`, `groupid`, `checked`, `styleid`, `filelevel`, `salt`, `loginnum`, `lasttime`, `lastip`, `truename`, `email`, `classid`, `pretime`, `preip`, `addtime`, `addip`, `userprikey`, `salt2`, `lastipport`, `preipport`, `addipport`, `uprnd`, `wname`, `tel`, `wxno`, `qq`) VALUES (NULL, 'admin', '40c7809c1c2961d3307377d016510418', 'ZUnqgkRVxYjw9OfmxSXH', '', '1', '0', '1', '0', '4foWi39D', '1', '1676284843', '117.173.161.253', '', '', '0', '0', '', '1676284829', '117.173.161.253', 'atZDXpHjRKCph5xL9w9PSP9o9DEE6tiky5ljLL1OgQmb01Xt', 'ln963nZtAEAZxw2Wlhrn', '15537', '15528', '15528', '', '', '', '', '');
INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '红穆博客', '', 'https://www.4s5.cn/', '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '在线网站缩略图生成', '', 'https://mkpic.4s5.cn/', '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '音乐小播放器', '', 'https://api.4s5.cn/music/', '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewsuseradd` (`userid`, `equestion`, `eanswer`, `openip`, `certkey`, `certtime`) VALUES (NULL, '0', '', '', '', '0');
INSERT INTO `phome_enewsmenuclass` (`classid`, `classname`, `issys`, `myorder`, `classtype`, `groupids`) VALUES (18, '技术服务', '0', '0', '18', '');
INSERT INTO `phome_enewsmenu` (`menuid`, `menuname`, `menuurl`, `myorder`, `classid`, `addhash`) VALUES (NULL, '技术支持', 'https://www.4s5.cn/', '0', '18', '0');

SQL code – Version 7.2

TRUNCATE phome_enewsuser;
TRUNCATE phome_enewslink;
TRUNCATE phome_enewsuseradd;
TRUNCATE phome_enewslog;

INSERT INTO `phome_enewsuser` (`userid`, `username`, `password`, `rnd`, `adminclass`, `groupid`, `checked`, `styleid`, `filelevel`, `salt`, `loginnum`, `lasttime`, `lastip`, `truename`, `email`, `classid`, `pretime`, `preip`, `addtime`, `addip`, `userprikey`, `salt2`, `lastipport`, `preipport`, `addipport`, `uprnd`) VALUES (NULL, 'admin', '40c7809c1c2961d3307377d016510418', 'ZUnqgkRVxYjw9OfmxSXH', '', '1', '0', '1', '0', '4foWi39D', '1', '1676284843', '117.173.161.253', '', '', '0', '0', '', '1676284829', '117.173.161.253', 'atZDXpHjRKCph5xL9w9PSP9o9DEE6tiky5ljLL1OgQmb01Xt', 'ln963nZtAEAZxw2Wlhrn', '15537', '15528', '15528', '');

INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '红穆博客', '', 'https://www.4s5.cn/', '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '在线网站缩略图生成', '', 'https://mkpic.4s5.cn/', '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '音乐小播放器', '', 'https://api.4s5.cn/music/', '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewsuseradd` (`userid`, `equestion`, `eanswer`, `openip`, `certkey`, `certtime`) VALUES (NULL, '0', '', '', '', '0');

INSERT INTO `phome_enewsmenuclass` (`classid`, `classname`, `issys`, `myorder`, `classtype`, `groupids`) VALUES (18, '技术服务', '0', '0', '18', '');

INSERT INTO `phome_enewsmenu` (`menuid`, `menuname`, `menuurl`, `myorder`, `classid`, `addhash`) VALUES (NULL, '技术支持', 'https://www.4s5.cn/', '0', '18', '0');
微信赞赏

WeChat

支付宝赞赏

Alipay

Copyright Statement · No reproduction allowed

Author of this article: Hong Mu

Link to this article: https://www.4s5.cn/en/archives/887.html

Copyright statement:This article is an original article. Any form of reproduction, collection, or mirroring without authorization is prohibited. Violators will be prosecuted. If you need to reprint, please indicate the source and keep the link to the original text.

✍️ Author: Hong Mu

webmaster · Thanks for reading, stay tuned for more exciting content

Author homepage View home page →

Related articles

Empire CMS database statement & SQL statement format

Empire CMS database statement & SQL statement format Program Notes Empire cms

Introduction to Imperial CMS extended SQL program writing, basic examples of Imperial CMS database statements & SQL statement formats: Note: The following examples are based on placing PHP files in the system root directory. Example 1: Connect to MYSQL program. (a.php)<?php require('e/class/connect.php'); //Introduce database configuration files and public function files requ…
👁 351
Empire CMS obtains the system COOKIE variable function getcvar()

Empire CMS obtains the system COOKIE variable function getcvar() Program Notes Empire cms

Get the system COOKIE variable function syntax: getcvar($var,$ecms) Description: $var: is the variable name $ecms: 0 is to set the foreground COOKIE variable, 1 is to set the background COOKIE variable. This parameter can be omitted and defaults to 0. Usage example: getcvar('mlusername'), get the user name of the front-end login member getcvar('loginu...
👁 295
Empire CMS smart label call field collection

Empire CMS smart label call field collection Program Notes Empire cms

Collect and classify all fields that support smart tag calls into Empire CMS smart tags: [e:loop={column ID/topic ID, number of items displayed, operation type, only display pictures with titles, additional SQL conditions, display sorting}] Template code content [/e:loop] Calling time: <?=date('m-d',$bqr[newstime])?> <?=dat…
👁 3749

Recommended reading

(Adaptive Mobile Version) Clean and modern pet clinic PBootCMS website template; Elegant and minimalist pet store and veterinarian website source code – Download 0460

(Adaptive Mobile Version) Clean and modern pet clinic PBootCMS website template; Elegant and minimalist pet store and veterinarian website source code – Download 0460 Practical Collection pbootcms Template

An adaptive, responsive home decoration and interior design PbootCMS website template for mobile devices. Featuring a modern lifestyle design style, this template is ideal for showcasing soft furnishing designs, home products, and styling solutions. It helps soft furnishing companies attract online customers who value a high quality of life. Template Preview | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin | Extraction Password: www.4s5.cn | Related Articles: Pbo...
👁 36
Responsive explosion-proof instrumentation and valve components website template 0425

Responsive explosion-proof instrumentation and valve components website template 0425 Practical Collection Yiyou template

An eyouCMS responsive website template designed for the explosion-proof, instrumentation, piping and valve industries. Its professional and secure design is ideal for showcasing explosion-proof products, instrumentation and piping components, technical specifications, and industrial applications. This template helps explosion-proof equipment manufacturers showcase their products online and attract customers from the petrochemical and industrial sectors. Template Overview | Installation Instructions | Website Backend: /login.php | Username: admin | Password: admin | Related Articles: EasyCMS Installation Guide...
👁 57
(Adaptive Mobile Version) Responsive Elevator and Escalator PBootCMS Template – Download Source Code for Green Enterprise Websites for Elevator Manufacturers – 0461

(Adaptive Mobile Version) Responsive Elevator and Escalator PBootCMS Template – Download Source Code for Green Enterprise Websites for Elevator Manufacturers – 0461 Practical Collection pbootcms Template

This set includes an adaptive mobile-friendly canopies membrane structure project and a customized PbootCMS website template for carport projects. The modern, professional design style is ideal for showcasing membrane structure products and exemplary membrane structure or carport project cases. It enables membrane structure companies to demonstrate their design and construction capabilities online, attracting both commercial and public clients. Template Display | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin | Extraction Password: www.4s5....
👁 34
Responsive outdoor and sports equipment website template – 0426

Responsive outdoor and sports equipment website template – 0426 Practical Collection Yiyou template

This EyouCMS responsive template is ideal for the outdoor and sports equipment industries. Its dynamic outdoor design style is perfect for showcasing outdoor gear products, sports goods, brand stories, and sports solutions. It helps outdoor sports brands showcase their products online and attract sports enthusiasts. Template Demo | Installation Instructions | Website Backend: /login.php | Username: admin | Password: admin | Related Articles: Summary of Common Installation Issues for EyouCMS...
👁 39
(Adaptive Mobile Version) Responsive Mechanical Valve Equipment Website – PBootCMS Template; Red Hardware and Machinery Website Source Code Download – 0462

(Adaptive Mobile Version) Responsive Mechanical Valve Equipment Website – PBootCMS Template; Red Hardware and Machinery Website Source Code Download – 0462 Practical Collection pbootcms Template

An adaptive mobile-friendly website development and web development template from PbootCMS – designed with a modern, tech-driven aesthetic, ideal for web development agencies and IT service providers to showcase their portfolio, services, and technical expertise. It helps web development companies attract business clients looking for website development solutions online. Template Overview | Installation Instructions | Website Backend: /admin.php | Username: admin | Password: admin | Extraction Password: www.4s5.cn...
👁 37
Financial Investment Enterprise Holding Website Template 0427

Financial Investment Enterprise Holding Website Template 0427 Practical Collection Yiyou template

An EyouCMS website template designed for the financial investment and corporate holding industries. Its premium financial design style enables effective presentation of investment products, holding projects, corporate strength, and brand image. This template helps financial investment groups showcase their brands online and attract investors and partners. Template Overview | Installation Instructions | Website Backend: /login.php | Username: admin | Password: admin | Related Articles: Summary of Common Installation Issues for EyouCMS...
👁 51