HeartFelt

wyngs_updates

May 5th, 2014
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 10.79 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.1.8
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: May 01, 2014 at 01:05 AM
  7. -- Server version: 5.5.36-cll
  8. -- PHP Version: 5.4.23
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Database: `alove_listadmin`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `wyngs_updates`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `wyngs_updates` (
  30.   `uID` INT(10) NOT NULL AUTO_INCREMENT,
  31.   `uTitle` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  32.   `uCategory` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '!0!',
  33.   `uEntry` longtext COLLATE utf8_unicode_ci NOT NULL,
  34.   `uDW` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  35.   `uDWOpt` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '|community:|tags:|userpic:|',
  36.   `uIJ` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  37.   `uIJOpt` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '|community:|tags:|userpic:|',
  38.   `uLJ` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  39.   `uLJOpt` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '|community:|tags:|userpic:|',
  40.   `uPending` tinyint(1) NOT NULL DEFAULT '0',
  41.   `uDisabled` tinyint(1) NOT NULL DEFAULT '0',
  42.   `uAdded` datetime NOT NULL,
  43.   PRIMARY KEY (`uID`),
  44.   UNIQUE KEY `uTitle` (`uID`,`uTitle`(50))
  45. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;
  46.  
  47. --
  48. -- Dumping data for table `wyngs_updates`
  49. --
  50.  
  51. INSERT INTO `wyngs_updates` (`uID`, `uTitle`, `uCategory`, `uEntry`, `uDW`, `uDWOpt`, `uIJ`, `uIJOpt`, `uLJ`, `uLJOpt`, `uPending`, `uDisabled`, `uAdded`) VALUES
  52. (1, 'Maintenance', '!0!', 'My collective is under maintenance at this time while I try to work out some errors. Please forgive the mess located here. Check back again soon.', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 0, 1, '2012-07-16 08:00:06'),
  53. (2, 'Grand Re-Opening', '!0!', 'I have finished everything related to the website. I have still having some errors at the top - in the black box. For some reason, all buttons are displaying as doubles. If you have any ideas - please post in my friends <a href="http://board.thefanlistings.org/index.php?showtopic=90966" target="_blank">forum</a> <a href="http://girlswhogeek.com/forums/topic/listingadmin-double-display-error#post-9319" target="_blank">posts</a>. You could comment here too if that's easier.\r\n\r\nOther then this error, everything else seems to be working wonderfully.', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 0, 1, '2012-07-17 01:28:12'),
  54. (3, 'New Button Codes!', '!0!', 'I have gotten a huge amount of help from <strong>Sara</strong> over at <a href="http://grey.nopromises.net/" target="_new">Grey Street Designs</a> with some nice new button codes! So far she's given codes for at least five fanlistings. I am very impressed. :) She said that she'll even do some more!\r\n\r\nUsually you have to pay for her services. However, for a limited time she's offering her button code services for free. So if you need any codes done, go to her site! She does a very nice job!', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 0, 1, '2012-10-15 01:24:12'),
  55. (4, 'Forum Post', '!0!', 'I have posted in the forums about needing some button codes. You can <a href="http://board.thefanlistings.org/index.php?showtopic=91430" target="_new">see the post here</a>. If you would like to make and donate some codes, feel free. :) I could use all the codes I can get!\r\n\r\nThank you!', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 0, 1, '2012-11-16 02:54:24'),
  56. (5, 'Sorry!', '!0!', 'Hello everyone!\r\n\r\nI am so very sorry that i have not been around. With my little girls in the educational system now, I've just been running around. I've been catching up on cleaning, organizing, online games, and just other things. I know, they're all rather unimportant, but they've just kept me away. Time has just seemed to fly on past me! I had not realized that it had been so long since I came here.\r\n\r\nI do apologize to you all. I am back now though and for good this time. I will not be disappearing again!\r\n\r\nSorry again! Thank you for all sticking around and waiting for me! It really is nice to be back again.', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 0, 0, '2013-06-26 11:10:49'),
  57. (6, 'Hoshiyomi', '!0!', 'I was writing a fan listing application a little earlier today and while doing so, it brought up a lovely memory of a character. This character's name is <a href="http://inuyasha.wikia.com/wiki/Hoshiyomi" target="_blank">Hoshiyomi</a> and he comes from the series <em>InuYasha</em>. I had long forgotten about this character who has actually been a long favourite of mine. So how could I forget about him? Well, it's been many years since I even thought about him or even seen the series. He's a very minor character in the anime only who was created for a few filler episodes.\r\n\r\nHe's quite a sad character actually who was a demon. He loved a human woman who he thought had betrayed him. In fact though, she died trying to save him. He never knew though until hundreds of years after her death. Her spirit came back and he learned what had really happened. It was very sad.\r\n\r\nHe didn't understand why or how she could betray him. He had trusted her. In fact though, it was the sword he had that possessed him really that caused him to lose trust in her and that's why he couldn't see clearly. It was because of this evil sword that he couldn't see that she would never betray him.\r\n\r\nHe suffered a very sad fate because him and his love couldn't be together. I wished they could have him. His love, the human woman, her name was Tsukiyomi, by the way, and she loved him very much.\r\n\r\nTo be honest, I don't remember if he died. I suppose if would be quite nice if he did. At least then they could be together in death, if nothing else. Fictional characters or not, their love was very beautiful. I do believe that they would have been together in death.\r\n\r\nPerhaps I'll start a fanlisting dedicated to Hoshiyomi as well as one dedicated to the relationship between him and Tsukiyomi.', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 0, 1, '2014-03-18 03:46:43'),
  58. (7, 'In Need of Button Codes', '!0!', '<p>So, I am kind of in need of some button codes. I don't really like making codes myself. I never like how they come out to be quite honest. So I am hoping that perhaps I can get some help from you all out there!</p>\r\n\r\n<p>Here is a list of what I need. I really only need buttons to be in a 200x40. That's all I really require, however, if you wish to make more, feel free! I'm in desperate need of 200x40 codes though.</p>\r\n\r\n<p>- <a href="http://edisonchen.aloveletter.co.uk/" target="_new">Edison Chen</a> -> Actors, Directors/Producers, Models, Musicians: Male<br />\r\n- <a href="http://hearts.aloveletter.co.uk/"  target="_new">Hearts</a> -> Arts and Design<br />\r\n- <a href="http://izumo.aloveletter.co.uk/"  target="_new">Kamiki Izumo</a> -> Anime/Manga: Characters 0-M<br />\r\n- <a href="http://ando.aloveletter.co.uk/"  target="_new">Masanobu Ando</a> -> Actors<br />\r\n- <a href="http://dimsum.aloveletter.co.uk/"  target="_new">Dim Sum</a> -> Food/Drinks<br />\r\n- <a href="http://mei.aloveletter.co.uk/"  target="_new">Mei-chan no Shitsuji</a> -> TV Shows<br />\r\n- <a href="http://parks.aloveletter.co.uk/"  target="_new">Parks</a> -> Places<br />\r\n- <a href="http://rainbow.aloveletter.co.uk/"  target="_new">Rainbow</a> -> Musicians: Bands/Groups<br />\r\n- <a href="http://keisho.aloveletter.co.uk/"  target="_new">Relationship between Kei and Sho</a> -> Relationships: Book/Movie</p>\r\n\r\n<p>To email me just use the <a href="contact.php">contact form</a>. I will credit you. I would really appreciate any help that I can get!</p>\r\n\r\n<p>Just to let you know, you cannot add files to the contact form. So you'll have to upload the buttons elsewhere such as <a href="http://mediefire.com/"  target="_new">MediaFire</a>, <a href="http://4shared.com/"  target="_new">4Shared</a>, or <a href="http://drive.google.com/"  target="_new">Google Drive</a>. Whatever works for you. I'm sorry if that's inconvenient!</p>', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 0, 1, '2014-03-24 23:47:00'),
  59. (8, 'New Layout!', '!0!', 'I have finally put up a new layout on the site! I had had the previous design up since July of 2012, so I thought that it was really time for a change. As much as I really liked the first version of the site, it was time for a change. I'm not sure what's up with me, but I'm really into green themed designs for this website. LOL. This layout is version two and its also green themed! It's really unlike me, I have to say. I usually prefer pink themed designs. I'm not complaining though. This design is really cute and I really happen to like it.\r\n\r\nI'd love to know what you all think of it! :)', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 'n', '|itemid:|community:|tags:|userpic:|', 0, 1, '2014-04-29 09:34:27');
  60.  
  61. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  62. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  63. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment