Maybe you’ve adopted a fanlisting, or you’ve been running one for a while… and suddenly, you decide that you want to turn on the favorite field and let people add their favorite character, or song, or anything else you would want to add. You want to do this, but you have no idea how to go about making the tables since you know nothing about MySQL. Well, I am here to tell you how to turn on the fave field!
First, you want to go into your fanbase config.php file and enable the fave:
$enablefave =”Y”;
And then add the fav question that you want to ask:
$whatfave =”Add your question here…”;
Now, all you have to do is create the table for this information to be stored in.
Go to your Cpanel. Once you are in your cpanel open up PHPMyAdmin. On the left hand side of the screen, select the database in which all of your fanlistings are stored in.
Out of the list that comes up, select the table of the fanlisting that you wish to add the fave field to (note: the regular one, not the table_u one).
Once the screen opens up, look down until you find a line that says Add new field. You will want to select either ‘at the end of the table’ or ‘after apr’
A new screen will come up after you hit ‘go’, and in it you will have to add things like the Field and Type. Name the Field ‘fave’ and make the Type ‘TEXT’ as shown below:
Now, it’s all set up! Members can start adding their favorites.
Page Views: 15 views
Loading ...
