The source code of the guestbook is no longer encrypted to facilitate secondary development by users.
Browsing messages and signing messages are separated, which increases the aesthetics.
The function of viewing passwords in private messages has been added. Visitors who enter private messages can set their own passwords to facilitate their own viewing of messages and administrator replies. They can also tell the password to friends for viewing.
The display of QQ, email and IP has been improved.
Added multi-administrator function. The administrator account password is changed to database storage. The database upgrade program can fill in the original password into the database and the original password remains unchanged.
Added emoticon function for messages.
Added message category selection. You can select message categories for front-end messages, and you can add, delete, and edit categories in the management backend. Messages without categories that are upgraded from the old version to this version will be displayed as uncategorized.
Added the function that users can enter WeChat ID when leaving messages.
This update upgrades the database and provides procedures for upgrading from any previous version to the current version.
Sapphire guestbook is an easy-to-use, secure guestbook, suitable for deployment on small and medium-sized enterprise websites and personal websites. It may be the best ASP guestbook in the world.
Sapphire guestbook asp version v7.0 has been open source!
Sapphire Guestbook may be the first ASP guestbook to use Chinese registration codes, which eliminates posting machines to a greater extent.
The beginning and end of the guestbook are include/header.asp and include/footer.asp respectively. Please modify them according to your needs.
The default username for backend management is admin, and the default password is pass. Please modify it before deploying to the website. The guestbook backend can be modified directly.
The database name is database.mdb. In order to prevent it from being downloaded, please modify the name before deploying to the website. The guestbook background can be modified directly.
This guestbook does not require installation, just open default.asp and use it.
This guestbook has been tested for compatibility with browsers under windowsxp, win7, win8, win10, ie, firefox, chroma, opera, and safari, and has successfully passed.
The guestbook uses the access database. To upgrade the database, please visit upgrade.asp in the background.
If you cannot leave a message, please run the file "If you cannot leave a message, please run.bat" with administrator rights.
1. In the background, you can move the message to the recycle bin, completely delete the message, pass the review or cancel the review. The above operations can be performed in batches.
2. You can easily modify the color of the guestbook in the background, create and modify the style of the guestbook, and modify some important parameters of the guestbook to leave messages, such as entering the IP segment that prohibits leaving messages, etc. You can also switch the avatar of the guestbook.
3. In terms of security, functions such as preventing SQL injection and converting HTML code into corresponding character entities are implemented to prevent code attacks.
4. This guestbook also has a self-repair function. If there is an error in the message style or avatar, you can go to the background to try to repair it. This message uses verification code and anti-flooding measures. Repeated messages cannot be left within the specified time of the same IP address. At the same time, the message book also has format verification and database upgrade functions.
The author is QQ105824422. If you have revision suggestions, bug feedback, or technical consultation, please add this QQ or add WeChat ID hcc2200.
Please keep the above instructions for the source code site that reprints this guestbook.
Backend path: domain name/manage.asp
The default administrator account is admin, and the default password is pass.
Backend page