Topics

1

Questions for the Senior Staff / Downtime Question

« on: February 26, 2013, 02:33:10 PM »

I'm going to be submitting a downtime form, but before I do, I'd like to know:

 

Are we supposed to submit the form for our domain (perhaps including a list of effected fanlistings) or are we supposed to submit the form individually (for each fanlisting)?

 

Thank you.

2

Fanlistings Chit-Chat / Enth 3 and MySQL 5.5

« on: May 05, 2012, 02:16:17 AM »

Just yesterday my host upgraded MySQL 5.1 to MySQL 5.5, and just half an hour ago or so I finally got around to learning this after I tried to add a new fanlisting... only to meet an error with mod_setup.php.

The problem is with the TYPE=MyISAM, found between lines 264-278 in Araneae:

Code: [Select]

 // create database if yes
 if( isset( $_POST['createtable'] ) && $_POST['createtable'] == 'yes' ) {
$query = "CREATE TABLE `$dbtable` ( " .
'`email` VARCHAR(64) NOT NULL default "", ' .
'`name` VARCHAR(128) NOT NULL default "", ' .
'`country` VARCHAR(128) NOT NULL default "", ' .
'`url` VARCHAR(255) default NULL, ' .
'`pending` TINYINT(1) NOT NULL default 0, ' .
'`password` VARCHAR(255) NOT NULL default "", ' .
'`showemail` TINYINT(1) NOT NULL default 1, ' .
'`showurl` TINYINT(1) NOT NULL default 1, ' .
'`added` date default NULL, ' .
'PRIMARY KEY( email ), ' .
'FULLTEXT( email, name, country, url ) ' .
') TYPE=MyISAM;';

It's outdated for MySQL 5.5 and will prevent you from creating new fanlistings tables in your database. I looked it up on MySQL.com and it can be fixed by changing TYPE=MyISAM to ENGINE = MYSIAM, like so:

Code: [Select]

 // create database if yes
 if( isset( $_POST['createtable'] ) && $_POST['createtable'] == 'yes' ) {
$query = "CREATE TABLE `$dbtable` ( " .
'`email` VARCHAR(64) NOT NULL default "", ' .
'`name` VARCHAR(128) NOT NULL default "", ' .
'`country` VARCHAR(128) NOT NULL default "", ' .
'`url` VARCHAR(255) default NULL, ' .
'`pending` TINYINT(1) NOT NULL default 0, ' .
'`password` VARCHAR(255) NOT NULL default "", ' .
'`showemail` TINYINT(1) NOT NULL default 1, ' .
'`showurl` TINYINT(1) NOT NULL default 1, ' .
'`added` date default NULL, ' .
'PRIMARY KEY( email ), ' .
'FULLTEXT( email, name, country, url ) ' .
') ENGINE = MYISAM;';

I made a mod copy and updated my file with that code, uploaded it, and it didn't break Enthusiast or my fanlistings and I got to add my new fanlisting - so I'd say it works. :)

I'll make updates if I notice anything else (though, if anybody else is having Enth/MySQL 5.5 troubles or solutions, please feel free to share).

3

Moved and Adopted Fanlistings / One Piece Music and Dracule Mihawk, and other moved OP listings

« on: April 18, 2012, 10:31:05 AM »

Just got my last letter from Shaza saying she got my last letter, so now I feel good announcing this to everyone. :D

Two big, huge wishlisters she let me adopt here (at one time!), that I have been following and so in love with since I first found out about them; I am still so positively ecstatic about being allowed to adopt these. Thank you so much, Shaza! I wish you the best!

Yo-Ho-Ho!
One Piece Music fanlisting

Défier la Mort
Dracule Mihawk fanlisting

Taking affiliates and new members! :D

And before I even realized I got my approval letters, I moved my other One Piece fanlistings to their own directory because I felt my fan directory was getting a little too large for comfort. (Translation: I'm super organized and there are plans for expansion, so I felt more comfortable moving my OP fanlistings to their own directory.) So, as all that suggests, the following fanlistings have moved as well:

[*]Monkey D. Garp
[*]Kokoro no Chizu
[*]Silvers Rayleigh
[*]Wanted!
[/list]
Also taking affiliates and new members. <3

4

Brand New Fanlistings! / Uchiha Madara

« on: February 12, 2012, 03:59:00 PM »

I am still so absolutely, completely, totally thrilled to have been approved for this, so thank you very much asldhglshdl!!! :heart:

[size="6"]The Hell of It[/size]
[size="4"]Uchiha Madara[/size]

Very simple right now, but I'm still deciding what else to do with it (though I do kind of like it the simple way it is). Members and affiliates wanted. <3

5

General Questions and Discussion / Suggestion: Category named in confirm. for Sent Forms

« on: January 20, 2009, 06:19:06 PM »

Not trying to lay any guilt (I have no hate for you Buruma, Mercedes!! Please don't feel bad!! (D:), but because I was recently put on trouble in the Songs category because my finished form wasn't received... I started wondering if it might have been my fault, too, like if I had accidentally submitted it to the series or toys/collectibles categories... (I don't know if you respond to those to correct people, so.)

Since you don't send out confirmation emails anymore, every time I send in a form I copy the confirm to LJ (handy little thing, really) right afterwards as to keep a date/time record. Looking at the records, none of the confirms, in either applications or finished, and perhaps even other things, tell you which category you submitted your information to. In fact, for the finished forms at least, the confirmation for Characters reads identical as it does for Songs.

Finished, from Characters 0-M
Thank You, {Name}!

Your finished form for the {Series}: {Chara} fanlisting has been received. A staff member will process the form and you should hear back within 2-3 weeks (hopefully sooner!). :)

Finished, from Songs
Thank You, {Name}!

Your finished form for the {Series}: {Title} fanlisting has been received. A staff member will process the form and you should hear back within 2-3 weeks (hopefully sooner!). :)

Because I was busy and I thought the form would get to you, I didn't double-check here if my finished form for my song listing went through. But because, also, the confirmation is identical to that of finished form's confirmation for Characters, I also don't know if I even sent it to the right category.

I don't know how your contact form works specifically, but is it possible to get the Categories-to-which-you-submitted listed in the confirmations, like you do with the sender's name and what subject the submitted for? Kinda like this?:

Application
Thank You, {Name}

Your application for the {Category}: {Series}: {Subject} fanlisting has been received. A staff member will process the application and you should hear back within 2-3 weeks (hopefully sooner!). :)

Please note that we have turned auto-responders off due to load on the server. Consider this your auto-responder. DO NOT RESUBMIT your application. Thank you.

Finished
Thank You, {Name}!

Your finished form for the {Category}: {Series}: {Subject} fanlisting has been received. A staff member will process the form and you should hear back within 2-3 weeks (hopefully sooner!). :)