ajicles

I had a variable wrong $lastPostReturn = mysql_fetch_assoc($lastPost); and the LIMIT helped Thanks

I tried executing SELECT * FROM `posts` ORDER BY `posts`.`postCreated` DESC in PHPmyAdmin and it just ordered them and not really selecting anything D:

I am having a problem with my script not returning anything! I echo the variable usually it will say ARRAY and it has something in it.. Nothing at all it coming up no errors I have put or die in it, nothing. I tried error_reporting(E_ALL); , still nothing. If someone can help me with this, I will greatly appreciate it. ~AJ error_reporting(E_ALL); //Get Catagorys and echo $getCatagorys = mysql_query("SELECT * FROM `catagory`") or die("Query failed with error: ".mysql_error()); while($row = mysql_fetch_array($getCatagorys, MYSQL_ASSOC)){ echo ' <tr> <td class="catagoryTD" width="550">'.$row['catagoryTitle'].'</td> <td class="catagoryTD" width="75"><center>Threads</center></td> <td class="catagoryTD" width="75"><center>Posts</center></td> <td class="catagoryTD" width="170"><center>Last Post</center></td> </tr>'; //Get SubCatagorys and echo $catagoryID = $row['catagoryID']; $getSubCatagory = mysql_query("SELECT * FROM `subcatagory` where catagoryID = '$catagoryID'"); while($subrow = mysql_fetch_array($getSubCatagory, MYSQL_ASSOC)){ $subCatagory = $subrow['subcatagoryID']; //Get Stats for number of threads $threads = mysql_query("SELECT * FROM entry WHERE subcatagoryID = '$subCatagory'") or die(mysql_error()); $num_threads = mysql_num_rows($threads); //Get Stats for number of entrys(posts) $posts = mysql_query("SELECT * FROM posts WHERE subcatagoryID = '$subCatagory'") or die(mysql_error()); $num_posts = mysql_num_rows($posts); //Find newest post and find what thread it is from $lastPost = mysql_query("SELECT * FROM `posts` ORDER BY `posts`.`postCreated` DESC") or die(mysql_error()); while($lastPostReturn = mysql_fetch_array($getSubCatagory, MYSQL_ASSOC)){ echo $lastPostReturn; } //Grab User and thread number and date $lastPostUser = $lastPostReturn['postUser']; $lastPostCreated = $lastPostReturn['postCreated']; $lastPostEntry = $lastPostReturn['entryID']; //Find the title of the thread and generate URL\ $lastPostThread = mysql_query("SELECT * FROM `entry` WHERE entryID = '$lastPostEntry'"); while($lastPostThreadReturn = mysql_fetch_array($lastPostThread, MYSQL_ASSOC)){ } echo ' <tr> <td><a href="catagory.php?id='.$subrow['subcatagoryID'].'">'.$subrow['subcatagoryTitle'].'</a></td> <td><center>'.$num_threads.'</center></td> <td><center>'.$num_posts.'</center></td> <td>'.$lastPostThreadReturn['text'].'<br>'.$lastPostCreated.'<br>'.$lastPostUser.'</td> </tr>'; } }

Thank you very much

I was wonder how I could make some BBcode for my messaging system I made for a website. I made some simple ones like just by replace [ red ] with font color etc. I want to know how to do something like this: [ url = http://google . ca] Google [ / url ] without the spaces. ~AJ

Hah never mind I fixed it. I forgot to query and missing a column...

Hello I am having a problem trying to write to a database using mysql real escape so there wont be any injection attacks. I trying using myrealescape and it returns errors: Notice: Use of undefined constant messageTo - assumed 'messageTo' in D:\wamp\www\Legit Gaming Upload\LGU\includes\mailCompose.php on line 17 Notice: Use of undefined constant messageSubject - assumed 'messageSubject' in D:\wamp\www\Legit Gaming Upload\LGU\includes\mailCompose.php on line 17 Notice: Use of undefined constant messageBody - assumed 'messageBody' in D:\wamp\www\Legit Gaming Upload\LGU\includes\mailCompose.php on line 17 I add in the single quotes and it doesn't write either. Dreamweaver says that either single quotes or not there is no syntax errors. What going on? I have used it like this before: ('$ID','" . mysql_real_escape_string($_POST[post_content]) . "') and no problems.. ~AJ <?php require_once('connect.php'); if(isset($_COOKIE['user'])){}else{ header( 'Location: members.php'); } if (isset($_POST['sendBtn'])){ $messageFrom = $_COOKIE['user']; $messageTo = $_POST['messageTo']; $hash = $messageTo.$messageFrom.time(); $hash = md5($hash); mysql_select_db("majik"); $sql="INSERT INTO messagesystem(ID, hash, messageTo, messageFrom, messageSubject, messageBody, messageDate, messageRead, messageDelete) VALUES ('','$hash','" . mysql_real_escape_string($_POST['messageTo']) . "','$messageFrom','" . mysql_real_escape_string($_POST['messageSubject']) . "','" . mysql_real_escape_string($_POST['messageBody']) . "','0','0')"; echo '<center>Your message was sent to: '.$messageTo.'</center>'; } ?>

Options +FollowSymLinks RewriteEngine On RewriteRule .* index.php Doesn't work.... Can someone please help me? There are there are 11 examples and none are helping me

Don't make a noob over think lol. I have tried this: Redirect 301 / index.php And it doesn't redirect it to index.php Within the index.php I will just get the referrer then get rid of anything I don't want and then do the sql queries etc.. Error trap it so people can't injection attack and wont accept letters. Its not simple I googled it I got this: httpd.apache.org/docs/2.0/mod/mod_rewrite.html and I don't see anything I need.

I have made a website that people can go to and create like pages for Faceboook and people can like them. I am currently changing the format of the website. I need to work on a way to make a dynamic directory so Facebook can tell the difference between like.php?id=1 and like.php?id=2 the only way I can do this is to make a directory for every like would which use alot of space. So if its dynamic its only one page, so it would be like/2 and Facebook would read it. Here is the link to my website: New Format, Old format

I believe I would have to write a script for apache. Some 404 pages display what you were trying to look for on the page. I just want to know how that works. Also I found a website that says I could use CGI to load dynamic content. I haven't coded CGI and don't know how to script something like this up. I host my website on a free web hosting and to enable CGI I used .htaccess Options +ExecCGI AddHandler cgi-script cgi pl If someone could help me that would be greatly appreciated. ~AJ

I am seen people have dynamic pages that loads the information from a database and then displays that information from the url. EG domain.com/somedirectory/something I have a website that does this but uses domain.com/something.php?id=something . This works great but when I go to try and get the statistics for that page from facebook for number of people that have liked that page. When I go to: http://graph.facebook.com/http://likebook.cz.cc/ It shows me the information: { "id": "**************", "name": "LikeBook", "picture": "http://profile.ak.fbcdn.net/hprofile-ak-snc4/hs178.ash2/41817_130259343675613_3465_s.jpg", "link": "http://www.facebook.com/pages/LikeBook/130259343675613", "category": "Website", "description": "Collect every like at LikeBook.cz.cc", "fan_count": 3 } But when I try and go to: http://graph.facebook.com/http://likebook.cz.cc/like.php?id=31 It shows me: { "id": "http://likebook.cz.cc/like.php" } So what I need to do is. Make a dynamic page within that sub directory. So that http://likebook.cz.cc/like/31 does grabs the information from line 31 of my database, like http://likebook.cz.cc/like.php?id=31 would do. Thank you ~AJ

*BUMP* 100th post also

I have an error: XML error: XML_ERR_NAME_REQUIRED at line 155771 On line 155771: <key>Comments</key><string>----&#62; www.KRAZYMP3Z..COM &#60;----</string> I have been googling around and found that a person said about my error is: I don't really know what do to now

Thank you good sir

I need help with this old script I found. Parse Error on line 101. And Line 101 is ?> <?php $file = "music.xml"; $to_print = array("Name", "Artist", "Album", "Track ID", "Year", "Play Count", "Track Number", "Track Count", "Genre", "Rating", "Date Added"); $db_host = "localhost"; $db_name = "music_library"; $db_table = "table"; $db_username = "root"; $db_password = ""; function db_connect() { global $db_host, $db_name, $db_table, $db_username, $db_password; mysql_connect($db_host, $db_username, $db_password) or die("<p style='font-color:red'>Cannot connect to mySQL server</p>"); mysql_select_db($db_name) or die("<p style='font-color:red'>Cannot connect to mySQL database</p>"); } function alter_print_arr(&$input, $key) { $input = str_replace(' ', '_', strtolower($input)); } array_walk($to_print, 'alter_print_arr'); function array_to_table($array) { global $db_table, $to_print; db_connect(); mysql_query("DELETE FROM $db_table") or die("Could not remove old records."); mysql_query("OPTIMIZE TABLE $db_table"); foreach ($array as $elem_key => $element) { if (isset($element[track_id])) { $sql = ""; foreach ($element as $k => $v) { if (in_array($k, $to_print)) { $sql .= "$k='" . mysql_real_escape_string(str_replace('=amp=', '&', $v)) . "', "; } } $sql = rtrim(ltrim($sql, "track_id='$element[track_id]', "), ", "); $sql1 = "INSERT INTO $db_table (track_id) VALUES ('$element[track_id]');"; $sql2 = "UPDATE $db_table SET $sql WHERE track_id=$element[track_id];"; mysql_query($sql1) or die(mysql_error()); // echo"$sql1<br />$sql2<br /><br />"; // For debugging. Uncomment with caution! mysql_query($sql2) or die(mysql_error()); } } echo "Done! "; // print_r($array); // For debugging. Uncomment with caution! } $xml_parser = ""; //will hold each song in a 2-d array $songs = array(); //counter, number of 'dict' elements encountered $current_key=""; $number_dicts = 0; //key for each element in second dimension of array $current_element=""; //stores xml element name //value for second dimension array elements $current_data = ""; //boolean used to help let us know if we're done with the song list $end_of_songs = false; function start_element($parser, $name, $attribs) { global $current_element, $number_dicts; if ($name == "DICT") { $number_dicts++; } if ($number_dicts > 2) { $current_element = $name; } } function end_element($parser, $name) { global $songs, $current_element, $current_data, $number_dicts, $array_key, $end_of_songs; if ($end_of_songs) { return; } if ($current_element == "KEY") { $array_key = str_replace(' ', '_', strtolower($current_data)); } else { $songs[$number_dicts][$array_key] = $current_data; } } function character_data($parser, $data) { global $number_dicts, $current_data, $end_of_songs; if ($data == "Playlists") { $end_of_songs = true; } $current_data = trim($data); } $xml_parser = xml_parser_create(); xml_parser_set_option($xml_parser, XML_OPTION_CASE_FOLDING, 1); xml_set_element_handler($xml_parser, "start_element", "end_element"); xml_set_character_data_handler($xml_parser, "character_data"); if (!($fp = @fopen($file, "r"))) { return false; } while ($data = fread($fp, 4096)) { // xml_parser jumps over ampersands. Decode any entities then replace any ampersands. // Reverse this when building SQL statement. if (!xml_parse($xml_parser, str_replace('&', '=amp=', html_entity_decode($data)), feof($fp))) { die(sprintf("XML error: %s at line %d ", xml_error_string(xml_get_error_code($xml_parser)), xml_get_current_line_number($xml_parser))); } } xml_parser_free($xml_parser); array_to_table($songs); ?>

I have a row in my sql I had to remove quotes from a href links to import it into my database because it was a csv file and delimiters were quote so I made a script to remove them. But I made a script to remove them: $file = file_get_contents('ibf_forums.csv'); $file = str_replace('="','=^69^',$file); $file = str_replace('\"','\^69^',$file); $file = str_replace('"\ ','\^69^',$file); Now I need to put them back in. So I need to replace ^69^ in a database. If I use UPDATE it will over write it all without replace just a part of it. An example if I don't make sense: Thanks&#33; <img src=\^69^http://domain.com/style_emoticons/<#EMO_DIR#>/tongue.gif\^69^ style=\^69^vertical-align:middle\^69^ emoid=\^69^\^69^ border=\^69^0\^69^ alt=\^69^tongue.gif\^69^ /> Into this: Thanks&#33; <img src=\"http://domain.com/style_emoticons/<#EMO_DIR#>/tongue.gif\" style=\"vertical-align:middle\" emoid=\"\" border=\"0\" alt=\"tongue.gif\" />

Damn... I imported and realized that there are quotes inside of quotes 50% was errors.

I need a little bit of help. I have a problem in which I need to read a file using fopen then open another file and look for a match and then take the information from both and enter it in a database then loop like 1000-2000 times. EG: 8;"zip";"File1.zip";"post-36-10839578260.ibf";"318";"7129";"8cc3bac5f531206b9ca0414d08430b1e";"3485" 27;"zip";"File2.zip";"post-40-10840088850.ibf";"222";"7162";"6af0e0d5798485656a2fd78d75a86e6d";"60984" and find the matching text in another csv file. Also, there is like 1000+ lines. The easy think I could think of is to parse the information and put it into a table and search the table..

*BUMP*

I have a problem, when my script is executed it doesn't grab the file but returns all the source code on the page in a text document The text file hasn't been over written. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" /> <title>Ajicles File Hosting - Downloading:040810051842songs.txt</title> <link rel="stylesheet" type="text/css" href="style.css" /> <!--[if IE 6]> <link rel="stylesheet" type="text/css" href="iecss.css" /> <![endif]--> </head> <body> <div id="main_container"> <div id="header"> <div id="logo"><a href="index.html"><img src="images/logo.png" alt="" title="" border="0" width="251" height="82"/></a></div> <div id="menu_tab"> <ul class="menu"> <li><a href="index.php" class="nav"> Home </a></li> <li><a href="upload.php" class="nav"> Upload</a></li> <li><a href="login.php" class="nav"> Login</a></li> <li><a href="register.php" class="nav"> Register</a></li> <li><a href="contact.php" class="nav"> Contact </a></li> <li><a href="logout.php" class="nav"> Logout </a></li> </ul> </div> </div> <div id="main_content"> <div id="downloading"> </div> </div> <div class="clear"></div> </div> <!-- main_content--> <div id="footer"> <img src="images/footer_logo.gif" alt="" title="" width="33" height="45" class="left" /> <div class="left_footer"> Ajicles Hosting 2010. All Rights Reserved </div> </div> </div> </body> </html>

I tried using: $file = $row['1']; header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header( "Content-Disposition: attachment; filename=".basename($_SERVER['DOCUMENT_ROOT'].'FileHosting/upload/'.$row[4].'/'.$file)); header( "Content-Description: File Transfer"); @readfile($file); When I echo back: $_SERVER['DOCUMENT_ROOT'].'FileHosting/upload/'.$row[4].'/'.$file It gives me this: D:/wamp/www/FileHosting/upload/ajicles/040810051842songs.txt Which is the right location and file. But it returns this: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" /> <title>Ajicles File Hosting - Downloading:040810051842songs.txt</title> <link rel="stylesheet" type="text/css" href="style.css" /> <!--[if IE 6]> <link rel="stylesheet" type="text/css" href="iecss.css" /> <![endif]--> </head> <body> <div id="main_container"> <div id="header"> <div id="logo"><a href="index.html"><img src="images/logo.png" alt="" title="" border="0" width="251" height="82"/></a></div> <div id="menu_tab"> <ul class="menu"> <li><a href="index.php" class="nav"> Home </a></li> <li><a href="upload.php" class="nav"> Upload</a></li> <li><a href="login.php" class="nav"> Login</a></li> <li><a href="register.php" class="nav"> Register</a></li> <li><a href="contact.php" class="nav"> Contact </a></li> <li><a href="logout.php" class="nav"> Logout </a></li> </ul> </div> </div> <div id="main_content"> <div id="downloading"> </div> </div> <div class="clear"></div> </div> <!-- main_content--> <div id="footer"> <img src="images/footer_logo.gif" alt="" title="" width="33" height="45" class="left" /> <div class="left_footer"> Ajicles Hosting 2010. All Rights Reserved </div> </div> </div> </body> </html> I don't know what I am doing wrong?

typo "isn't". Aloso I have found a script with a count down timer: if (!empty($message)) { echo "<p class=\"message\">" . $message . "</p>"; } else { if (!@$_GET['d']){ redirect_to("index.php"); } else { echo ' <div id="downloadingform"> <center> <p><center>Please until the countdown is done, or upgrade your account.</center></p> <p><center>You are downloading: '.$row[1].'</center></p> <p> </p> <p> </p> <form name="counter"><center><input type="text" size="8" name="d2"></center></form> <script> <!-- // var milisec=0 var seconds=30 document.counter.d2.value="30" function display(){ if (milisec<=0){ milisec=9 seconds-=1 } if (seconds<=-1){ milisec=0 seconds+=1 } else milisec-=1 document.counter.d2.value=seconds+"."+milisec setTimeout("display()",100) } display() --> </script> <div id="hid" style="visibility:hidden"><center><a href="upload/'.$row[4].'/'.$row[1].'"><img src="images/download.png" width="200" height="55" border="0" /></a></center></div> <script type="text/javascript"> function showIt() { document.getElementById("hid").style.visibility = "visible"; } setTimeout("showIt()", 30000); // after 1 sec </script> </div>';

I know that .htaccess is php. But I need help with my website that is file hosting. I need a way for people to download the file and not just use a direct link to the file. So I though I could use htaccess to stop that. But that is a main issue. I need some way for php to grab the file without being blocked by htaccess and place it into a temp folder then allow for download. But the only issue with that is the user could leave the website when the download is downloading. But I could have a script that will delete the temp file when it expires. But then how would it run if there is no user on the website I could try making it when a person comes to the site it deletes the file if it is expired but then again if there is zero traffic it will never expire. Any thoughts to my situation? Another thing I need help is making a download button appear when the timer hits zero. I tried using javascript to make a hidden div to show with the download button in it. But then the user can just look at the source code and see the link... So many loop holes

you have to start the session again when you want to retrieve it.