The quote is true, but I think that might have been what Tammy was talking about in one of the first few posts (replacing fanfiction_stories with fanfiction_recommendations - which I think I'll try).
Many of the changes you want to create for your site (with the exception of the one in the last post) can probably be done through the skins. I have a site that is only for recommendations: classics.dracoandginny.com. For instance, I took {recommender} out of recommendations.tpl, which is one of the things you want to do, right? I also modified en.php in the languages folder for the recommendations module to change some of the titles, etc., and the "excerpt" and "other links" sections are just added into the 'Recommender's Comments' box as text w/bolded titles, though I suppose you could change the form in the PHP.
As of right now, that site is a standard 3.2.1 install with no modifications to the PHP, only to the skins.
A little trickier, but I think if you do a search and replace on the files in the browse folder, browse.php, and search.php to repliace "fanfiction_stories" with "fanfiction_recommendatoins" you're mostly there. You'll probably have to do some more replacing, but that would get most of it.
Tammy. I looked in the browse folder, and pulled up all the files in the folder and don't see fanfiction_stories anywhere. Not even in the browse.php. I did find some in the search.php. I am feeling a slight bit confused. *chuckles*
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
You're right. Look in browse.php and search.php.
I looked there too. The only place I found 2 fanfiction_stories in search.php. I didn't find any in the browse.php that was outside the browse folder.
Browse.php has things like stories.title. I don't see fanfiction_stories.
I changed the ones in the search.php, and when I searched, it came up with 1 off site rec... because that is all I have in the database, but it didn't show the box, it just showed the link and pointed me to the recs page.
Dreamy
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
Oh! I know. You need to change it in includes/queries.php. Most of the places that list stories use the queries in there.
Well, I can't win for loosing. LOL
I opened queries.php and replaced all the fanfiction_stories with fanfiction_recommendations and I got:
A fatal MySQL error was encountered.
Query: SELECT stories.*, author.penname as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM (gw_fanfiction_authors as author, gw_fanfiction_recommendations as stories) WHERE author.uid = stories.uid AND stories.validated > 0 AND stories.featured = '1'
Error: (1054) Unknown column 'stories.updated' in 'field list'
Current Version: 3.4.2
PHP 4
Mods: Challenges, Recommendations, Storyend, Display Word, Beta Reader, Bad Reviewer
Take this section out of the query.
UNIX_TIMESTAMP(stories.updated) as updated
Recommendations has no updated field.
Been following along. I got this error after changing includes/queries.php:
A fatal MySQL error was encountered.
Query: SELECT stories.*, author.penname as penname, UNIX_TIMESTAMP(stories.date) as date FROM (fanfiction_authors as author, fanfiction_recommendations as stories) WHERE author.uid = stories.uid AND stories.validated > 0 ORDER BY stories.updated DESC LIMIT 1
Error: (1054) Unknown column 'stories.updated' in 'order clause'
But only when viewing the index. Viewing http://classics.dracoandginny.com/browse.php?type=recommendations is fine.
Trying to complete a search, I get:
Warning: array_filter() [function.array-filter]: The first argument should be an array in /home/draco3/public_html/classics/search.php on line 133
A fatal MySQL error was encountered.
Query: SELECT count(sid) FROM fanfiction_recommendations as stories WHERE validated > 0 AND (FIND_IN_SET(2, stories.catid) > 0 )
Error: (1054) Unknown column 'sid' in 'field list'
This is the same regardless of whether or not search.php has the two instances of fanfiction_stories changed to fanfiction_recommendations.
Actually, come to think of it, the part of the error above the "fatal MySQL" line has shown up on the search for the main archive, and that doesn't have the recommendations mod installed (and the search there is a little messed up).
Okay, not to discourage you guys, but I'm going to stop helping on this. The reason being that on something this complicated, my feeling is that if you can't do it yourself you shouldn't be doing it. I've just gotten burned too many times helping someone with something and then gotten stuck helping them with it for forever because they didn't understand what was done.
