To change smileys on a Simple Machines Forum (SMF) from "Post form" to "Popup", you can take the following steps:
- Click on Admin.
- Select Forum.
- Select Smileys and Message Icons.
- Select Edit Smileys.
You will then see a table of smileys with the smiley itself in the far-left column followed by columns titled "Code", "Filename", "Location", "Tooltip or description", and "Modify".
You can change the location from "Post form" to "Popup" by clicking on Modify and then changing the location. There are three options for location: Post form, Popup, and Hidden.
In the database there is a table, smf_smileys, if you used the default prefix of "smf" for tables created within the database. It has the following fields, i.e., columns:
id_smiley
code
filename
description
smiley_row
smiley_order
hidden
The hidden field is where information is stored about whether the value of location is post form, popup, or hidden. If the value is "Post form", then a 0 is stored in the field. If it is "Hidden" then a 1 is stored in the field. If it is "Popup", then a 2 is stored in the Hidden field for that particular' smiley's entry in the smiley table.
| Text | Number |
|---|---|
| Post form | 0 |
| Hidden | 1 |
| Popup | 2 |
If you can directly access the tables in the database from a command prompt, e.g., by running mysql at a command prompt, or can issue Structured Query Language (SQL) statements through software such as phpMyAdmin, you can update the value for a range of smileys simultaneously. E.g. if I wanted to update those smileys with smiley_id between 768 and 778 to change the location from "post form" to "Popup", which is represented by a "2" in the Hidden field of the table, I could change the value using the SQL statement below, assuming the database itself is called "myforum":
UPDATE myforum.smf_smileys SET hidden = '2' WHERE smf_smileys.id_smiley BETWEEN 768 AND 778;
References:
