Messages

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

Moved and Adopted Fanlistings / Naruto series

« on: June 04, 2012, 06:56:15 PM »

Congrats, Annie, on the adoption! (My goodness, that is such an honor, isn't it?!)

Would you be interested in affiliating the Naruto series fanlisting with the Naruto episode 101, Tobi, and Madara fanlistings?

3

Fanlistings Chit-Chat / Enth 3 and MySQL 5.5

« on: June 04, 2012, 06:46:46 PM »

You're welcome, Masao. (You're so lucky you don't have to do all this updating yet.)

I do come bearing another update, though: this time on the mod_owned.php file. It's the same problem/solution with the TYPE=MyISAM as the above, only this one prevents you from enabling affiliates (say, on a brand new fanlisting).

On the mod_owned.php file, between lines 895-905 in Araneae:

Code: [Select]

  // add table
  $afftable = $table . '_affiliates';
  $query = "CREATE TABLE `$afftable` (" .
 "`affiliateid` int(5) NOT NULL auto_increment, " .
 "`url` varchar(255) NOT NULL default '', " .
 "`title` varchar(255) NOT NULL default '', " .
 "`imagefile` varchar(255) default NULL, " .
 "`email` varchar(255) NOT NULL default '', " .
 "`added` DATE NOT NULL default '0000-00-00', " .
 "PRIMARY KEY( affiliateid ) " .
 ") TYPE=MyISAM AUTO_INCREMENT=1";

Needs to become:

Code: [Select]

 // add table
  $afftable = $table . '_affiliates';
  $query = "CREATE TABLE `$afftable` (" .
 "`affiliateid` int(5) NOT NULL auto_increment, " .
 "`url` varchar(255) NOT NULL default '', " .
 "`title` varchar(255) NOT NULL default '', " .
 "`imagefile` varchar(255) default NULL, " .
 "`email` varchar(255) NOT NULL default '', " .
 "`added` DATE NOT NULL default '0000-00-00', " .
 "PRIMARY KEY( affiliateid ) " .
 ") ENGINE=MyISAM AUTO_INCREMENT=1";

I think I'll just look for anymore TYPE=MyISAM in the files and make a list of where's if I find any, because they will all - no doubt - need to become ENGINE=MyISAM to be MySQL 5.5 compliant...

PS: I noticed on my last post, I wrote ENGINE = MYSIAM with spaces and all uppercase, and in this one without. As I now happen to be using both, as of right now, it appears it doesn't matter which one you use; the last one I ripped right from the MySQL site (so, you know it'd work), and this one I just changed Type to Engine since I knew immediately that's what needed to be done and it works fine, too.

4

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).

5

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

« on: May 05, 2012, 01:58:37 AM »

I am so sorry, sailorchick, I have been super busy. D:

But I would love to affiliate the OP music fanlisting with all your music fanlistings! Thank you so much! (And seriously, I am immensely sorry for my lateness!)

6

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

« on: April 21, 2012, 10:55:39 AM »

Aw, thank you, Marie! :D

7

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

8

Characters N-Z / Characters N-Z: Did you get my F/U/C form?

« on: April 04, 2012, 12:20:24 PM »

Name: Hillary
Email: hillary - at - color-trap.net
Form: Update

Subjects:
One Piece: Monkey D. Garp
One Piece: Silvers Rayleigh

Both forms were sent yesterday, April 3.

Thank you!

9

Adoption Center / Adopting out ALL fanlistings

« on: February 15, 2012, 03:16:10 PM »

Really sad to see you go, Shaza, (especially from all web design?), but congrats on getting married and med school.

I just noticed this and sent in two applications.

10

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

11

Brand New Fanlistings! / Tennis no Oujisama & Two manga-ka's

« on: February 12, 2012, 03:52:25 PM »

Ooh, very nice. I really like the colors. (And I absolutely love green layouts. They can be so difficult to pull off, but the color..!)

Would you be interested in affiliating the Akino Matsuri and Higashino You fanlistings with the Minekura Kazuya fanlisting?

12

Characters N-Z / Characters N-Z: Did you get my F/U/C form?

« on: February 12, 2012, 03:48:40 PM »

Name: Hillary
Email: hillary - at - color-trap.net
Type of Form: Finished
Subject: Naruto: Uchiha Madara
Date: Today (February 12)

Thank you. :heart:

13

Hot Topics / New Approvals and Adoptions

« on: January 22, 2012, 05:18:14 PM »

I couldn't sleep this morning so I checked my Twitter on my phone, saw the Characters N-Z update, saw the character listing I wanted listed in that update and nervously checked my email... Approval: Uchiha Madara was the first email. I am ecstatic! :heart:

Thank you!!

14

Characters N-Z / Characters N-Z: Did you get my Application?

« on: January 03, 2012, 05:48:36 PM »

Name: Hillary
Email: hillary - at - color-trap.net
Subject of Fanlisting: A Naruto character

Date sent: Just now (January 3)
Action: Check

I apologize for not including the name, but I am so super nervous and worried about this one...

Thank you for checking for me.

15

Characters N-Z / Characters N-Z: Did you get my F/U/C form?

« on: April 21, 2011, 11:57:44 AM »

Name: Hal
Email: hal - at - color-trap.net
Type of Form: Finished
Subject: Naruto: Uchiha Madara/Tobi
Date: Just now

Thank you for checking! :D