MALA (AND CO'S) FANLISTING SCRIPT

One of the reasons I got into PHP is because I wanted a better way to run my webrings. Koinukogave me a PHP script a she uses to manage her webring that she made herself. Now, the script I have doesn't really compare to the original script, but I definitely wouldn't be as into PHP (if into at all) if it weren't for her!!!

Anyways, I eventually altered that script into a fanlisting script. I thought I'd finally sit down and share it!!! The enthusiast script is a really large kind of scary thing, but this script has a focus on being small and easy to manage!!! It has a few tiny features too for AnimeFanlisting and/or Fanlisting.org eligibility!

This fanlisting script can be previewed in its default form here. It is highly customizable though- I'm just basic. It's basically just a bunch of HTML pages. I display them on one, but you can split them up as much as you want as long as you keep datebase connections connected to anything displaying that fanlisting data (form and members)

How does this Fanlisting Script Work?

This fanlistiing does not use passwords like Enthusiast. It takes user data, stores it in a database, and you as webmaster are the only one who can edit it. Perhaps this will change in the future, but it's not really something I've prioritized.

The only requirement from the user is their name since fanlistings don't require emails or websites. There's a dropdown for countries too. After they input their data, the data goes to your database, and you go into the database and manually approve them (by typing y in the pending column. it is default n)

It has some changes to meet TAFL/TLF requirements. There is a webmaster last online which displays when you last updated a page on your site in general (certainly not perfect, but TFL/TAFL requires there be activity/changes to the page in the last 3 months to verify activity and this is how I prefer to do so).

If the server you're managiing fanlistings on isn't your main server (which this server used to not be my main server), you can remove the "Webmaster Last Online" section. It's also possible to link to something like Neocities via its API which I used to do back when my fanlistings were on a different server, or just verify another way entirely. There's plenty of ways to show youre active that don't rely on capturing server times.

TAFL/TFL does not allow just fetching the current time. They'll remove you for this.

Instructions

This script uses SQL so requires some basic setup though you can do it easily with no SQL knowledge so do not worry!

The first thing to do is download these files or navigate to the Github page.
Next you set up your database.
In your panel, navigate to databases. It will take you to a very ugly page (in Cloudpanel, it's under Databases. In Cpanel, it's under PHPMyAdmin)
Make a new database. Different panels handle this differently.
- In Cloudpanel, you make a database and it gives you the user automatically. You can regenerate the password credentials if needed
- In cPanel, you make the databases and users/passwords seperately. You make your user under "Manage my Databases"
After making your database and user, click the name of that database (under PHPMYAdmin, Recent/Favorites). That will select the table. It will put up a table screen with inputs. Just ignore that.
- Navigate to SQL and paste content of fanlistiings.sql into the SQL tab, then click go (bottom right). You're not done with PHPMyAdmin
You're done with that now!
Go to your connections.php file. Update that with your database credentials (the database name is the name of the table you made- not logs.sql)
Now, test the page you have. You should be able to enter your own fanlisting, see pending members, and go into t the database and directly approve yourself
Connect webhook (optional)
1. If you want to get notifications when you get submission, you can connect a discord webhook. I stole these instructions from a dead sadgrl page by the way.
  1. Go to your Discord server, and click on the Settings gear on the channel you would like submissions to go to.
  2. On the left sidebar, click on Integrations.
  3. Beside Webhooks, click on Create Webhooks.
  4. You can set a name that will appear with submissions, or use the provided one.
  5. Click on Copy Webhook URL
  6. Go into your config file. Find/Control F discord webhook and paste the hook in place of 'xx'
  7. Now test to see if you get a notification

Notes

The template uses one file, but it can easily be split up. The most important things to keep in mind are the following:

Any page directing connectly to the database (ie including the members or form file) needs to include this at the top. This is because members/forms need to be connected to the database to update properly. This is currently at the top of index.php

<?php
$fanlistingname = "testinglisting"; //
$formresults = "";
?>
<?php include "connection.php"?>

PHP is just generally annoying (and SQL too at times) which is why I included members and form seperately. My hope is that it makes things easier for a wider variety of layouts, but if it throws many errors, please let me know via email.
If you make any code/templates you don't mind being reused, you should also email me.

Thank you for your time!