TheMovieman
-
Posts
254 -
Joined
-
Last visited
Everything posted by TheMovieman
-
For the "forum" folder, everything is set (group, world and all). Should I do this for the "public_html" as well? Edit: I went ahead and submitted a ticket just in case I missed something.
-
I've tried to do several things in my forum (including upgrading to a new version), and it tells me it can't because the permissions are not set to writeable. I then tried to simply add in a couple smilies and I get this message: "The following smiley directories are not writable: default, classic" I logged into my SmartFTP and made sure everything was set, and it was... Anyone have experience with this? I'm using SMF, btw.
-
I've done a Goggle search and I kind of understand it, but I don't know how to adapt it to my current code. See, I have a reviewindex page that shows both movie and DVD review through a variable (type=dvd or type=movie). It's been a while since I've done some coding so I might be mixing up termanology... Anyway, I'm hoping someone can help me. What I want is to split up the number of reviews listed (probably 30 per page) but I don't know how to do this with my code (sorry for it being so long, but I don't know what to include and not include): ><HTML> <HEAD> <?php if ($type == movie) { echo "<TITLE>Movieman's Guide to the Movies >> Review Index >> Movies</TITLE>"; } if ($type == dvd) { echo "<TITLE>Movieman's Guide to the Movies >> Review Index >> DVDs</TITLE>"; } ?> <META NAME="keywords" CONTENT="movie reviews, movieman, moviemans's guide to the movies, brian oliver, hundreds of movie reviews, review index"> <LINK rel="stylesheet" type="text/css" href="styles.css"> <LINK rel="stylesheet" type="text/css" href="style_extra.css"> <?PHP include ("external/headsection.html"); ?> </HEAD> <BODY> <?php include("*edited*"); $dbh=mysql_connect (*edited*) or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("$db"); $type = $_GET['type']; ?> <BASEFONT FACE="Verdana"> <TABLE CLASS="BORDERCOLOR" BORDER="0" ALIGN="CENTER"> <TR> <?PHP include ("external/new_header.php"); ?> </TR> <!-------------------------------------Left Navigation-------------------------> <TR> <td class="leftside" valign="top"> <table class="leftside"> <?PHP include ("http://www.moviemansguide.com/external/main_menu.php"); ?> <?PHP include ("http://www.moviemansguide.com/external/latest_reviews.php"); ?> <?PHP include ("http://www.moviemansguide.com/external/boxoffice.php"); ?> <?PHP include ("http://www.moviemansguide.com/external/advertisement.php"); ?> <tr><td><img src="images/spacer.gif" width="140" height="0"></td></tr> </table> </td> <!---------------------------------------Main Area-----------------------------> <TD CLASS="mainarea" VALIGN="TOP"> <TABLE CLASS="mainarea" ALIGN="CENTER"> <TR> <TD COLSPAN="2"> <!--------------------------------THE MOVIE-----------------------------------------> <TR> <TD> <TABLE WIDTH="100%" BORDER="0"> <?php if ($type == movie) { $titlelist = @mysql_query("SELECT name, movie_reviews.id, year, star_rating, title, list_title FROM critic, movie_reviews WHERE criticid=critic.id ORDER BY list_title ASC"); while ($listing = mysql_fetch_array($titlelist)) { $id = $listing['id']; $title = $listing['title']; $year = $listing['year']; $name = $listing['name']; $rating = $listing['star_rating']; echo" <TR> <TD CLASS='rindex-year'>$year</TD> <TD CLASS='rindex-link'><b><a href='reviews/movie/read.php?id=$id'>$title</a></b></TD> <TD CLASS='rindex-critic'>$name</TD> <TD CLASS='rindex-rating'><img src='images/star_ratings/$rating.gif' HEIGHT='25' ALT='$rating'></TD> </TR>"; } } if ($type == dvd) { $titlelist = @mysql_query("SELECT name, dvd_reviews.id, year, rating_overall, title, list_title, edition FROM critic, dvd_reviews WHERE criticid=critic.id ORDER BY list_title ASC"); while ($listing = mysql_fetch_array($titlelist)) { $id = $listing['id']; $title = $listing['title']; $edition = $listing['edition']; $year = $listing['year']; $name = $listing['name']; $rating = $listing['rating_overall']; echo" <TR> <TD CLASS='rindex-year'>$year</TD> <TD CLASS='rindex-link'><a href='reviews/DVD/read.php?id=$id'><b>$title</b></a> ($edition)</TD> <TD CLASS='rindex-critic'>$name</TD> <TD CLASS='rindex-rating'><img src='images/star_ratings/$rating.gif' HEIGHT='25' ALT='$rating'></TD> </TR>"; } } ?> </TABLE> </TD> </TR> </TABLE> </TD> </tr> <tr> <td valign="CENTER" colspan="3" cellpadding="0" cellspacing="0"> <?PHP include ("external/new_footer.php"); ?> </td> </tr> </table> <!--Closes Body Table--> </html> Hopefully this wasn't entirely confusing as, like I said, I'm just getting back into this after a few months and my mind is'nt back into it at the moment... Thanks in advance, Brian
-
Thanks erisande! Worked perfectly
-
Do I do this in cpanel or the MySQL Admin? I've added the % wildcard to "Access Hosts" in cpanel but that did nothing either. I also looked over the MySQL Adm and I didn't see any fields there. If the former, it's still not showing my DBs.
-
I would've edited my post above, but there's not button to do so... Anyways, it's able to retrieve my server status. I still don't understand why it won't retreive my database info and I've tried a few things and searched around the Net but still nothing. I'm sure it has something to do with my modem/router but I even tried checking around that in the firewall. For now I can use cpanel, but it's easier using MySQL Admin.
-
Oh, and I had set it up before I got DSL (I was using dial-up). And while it will log in but will not "fetch" my databases.
-
Yeah, I went in and added the IP address to allow the access.
-
Hi all, For the first since switching to DSL, I tried to look at my database via MySQL Administrator. Now, while I can log in, it won't show my available databases and instead there's nothing listed and the dot in the lower left corner is red and does nothing. I'm new to this and didn't know if I needed to change port settings or what. I'm using a 2Wire Router/Modem, btw. Any help would be appreciated
-
Just wanted to thank all you guys for your help. I ended up sticking with tables without the div tag and just re-designed my home page and made the width to 765pixels which looks fine on a 800 x 600 monitor. Anyways thanks everyone
-
That was because (where this error ocured) the guys last name was an unsupported symbol. This showed up fine using tables (http://www.moviemansguide.com/reviews/movie/read.php?id=childrenofmen) but not in the div tables. I corrected it, but didn't hlpe any.
-
Yeah, but since IE is so quirky, I don't want it to look so strange. I'm going to research the div tags and see how to do what I need instead of using tables since that seems to be the trouble. Thanks for your help guys, in any case.
-
Thanks for the link Don. I had actually found something similar (http://webdesign.about.com/od/freewebtemplates/p/blbetter3col.htm) and was trying to adapt that. If I find an extra spurt of energy, I might try this over without using tables, but I need to learn more about <div> tags. BTW, do div tags have an effect on apostophes and such? I noticed on that first link (in my first post) that instead of ', there's an empty box or (on another computer), it's a question mark. If I edit the review and replace the apostrophe , it'll show fine (the one in the review is taken from Word).
-
So I adjusted it and it still does the same thing and now even if I adjust it slightly the middle section goes to the bottom. I know it's a matter of adjusting the numbers, but this thing is really bugging me now, lol.
-
Still haven't really solved the problem per se, but I did set (within #main) the width to 1010 so the middle section won't do that on smaller resolutions, the trade-off however is, there will be a horizontal scroll. One other question, I noticed this on another site using 1024x768 that there is still the horizonal scrollbar where you can only move over a little. I had put in a code to remove this but in order to do the fixed width size, I needed to remove that piece.
-
Still does the same thing. I've updates the page: http://www.moviemansguide.com/test-index3.php I also sized down the left sidebar and while it's smaller than I like, I think it'll work on the 800x600 resolution. Edit: Just checked and it still doesn't work on that resolution...
-
I guess I'll try adjusting the numbers and maybe get it down some... But I have seen other sites that the side bars stay the same and the middle adjusts, yet doesn't do what mine has. Another thing (and this doesn't really pertain to this issue, more of curiosity), but I use a spacer.gif image on one of the sidebars and in MSN Explorer (which I think uses the same kind of coding as IE), there's a bar that shows even if I specify border="0". Just odd but not that pressing to fix.
-
OK, I'm redesigning my site and found a three column layout that I liked and adjusted my review page to those configurations. This template uses <div> tags and I noticed that instead of single apostophes it shows up as an empty square box or a question mark. By the way, the page uses MySQL to get the data. Also, on a larger screen (1024x768), it shows up fine but on something smaller (800x600), the middle section gets (for the lack of a better word) squished down to the bottom of the page. Here's the page I'm talking about: http://www.moviemansguide.com/reviews/DVD/....php?id=unknown Plus the home page (where this also happens) http://www.moviemansguide.com/test-index3.php
-
Excellent, thanks Bruce!
-
In my (MySQL) database, I have dates in the standard yyyy-mm-dd format and was wondering how to convert it on screen to read the date printed out (ie: 2007-01-31 would read January 31st, 2007 or just January 31st). I'd appreciate any help. I've tried googling this but nothing came up that was helpful...
-
Just a quick reply... submitted the ticket and everything is back to normal! Thanks TCH
-
Hmm, which shall I choose Thanks for the advice Andy
-
Don't know if this is in the right section, so I apologie if it is. I had upgraded to the latest patch (or w/e it's called) and when I tried going back into my forum I got an error. So, I followed the instructions to remove the forums directory, but then realized, I don't know how to do the rest easily. Here are the instructions: - Untar /home/*ACCOUNTNAME*/fantastico_backups/forums.backup.1161837998.tgz - Empty the database *ACCOUNTNAME*_smf1 - Import the file /home/*ACCOUNTNAME*/fantastico_backups/forums/backup.sql into the database *ACCOUNTNAME*_smf1 - Move /home/*ACCOUNTNAME*/fantastico_backups/forums to /home/*ACCOUNTNAME*/public_html/forums Do I download that tgz file or can that be done within ftp? I would appreciate any kind of help, especially a step by step intruction on how do easily get my forum back up. And since I've never done this before, how do I "empty" the smf1 database? Thanks, Brian
-
After reading this thread, I decided to install this poll as well, but I must've done something wrong as when I went to go to the admin page, all I get is a white page... I believe I uploaded all the files so I don't know what happened.
-
I recently checked my e-mail forwards in cPanel and noticed a forward I did not add and I can't remove it either. Anyone else encounter this?