cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Sounds like you've got something like cPanel? See screenshot.

You can probably get your heart server address from inserting something like:

<?php echo "Server address: " . $_SERVER['SERVER_ADDR'];?>

into one of your pages.

Now take the address and place it into your cpanel.

I'm no expert on this - I'm assuming a bit here.

I Agree totally. In that picture shows where you enter in the remote host(s). There may be more than one in this situation depending on the isp setup. I have done this setup myself and is very simple. First in the site with mysql like ardave said you will need to enable remote hosts. The first remote host will be %.website_without_database.com and notice it uses the subdomain %. Remember to replace the domain with your real domain. Then in the below script replace the host (first parameter) with the website that contains your database. Then enter your username and password. Then run the script and follow the next step.

<?php
mysql_connect('website_with_mysql.com','username','password') or die(mysql_error());

For example, if I were doing a remote host to my website it would look something like this (password is different though)

<?php
mysql_connect('cwarn23.net','root','abc987zyx') or die(mysql_error());

Now you will probably see an error. The error will say that it cannot access the database due to some security violation. To solve this copy and past the host name in the message into the box ardave pointed out. Now you should have 2 remote hosts set in your cpanel. Then you may need to run the above …

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Try replacing line 59 with the following.

$result=mysql_query($qry) or die(mysql_error());
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

If there aren't any questions relating to the subject, it would be useless to add a forum. But if there are a lot of questions on the subject in an appropriate/related forum, then it makes sense.

The thing is there is a media sub-forum but is hidden deep below the categories. Perhaps if this forum was moved to Web Development or Software Development instead of a subforum of Web Design then more people will see that it is there. I find it kinda annoying how it's hidden in it's own corner so I tend to not visit it.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Also while this topic is active could somebody mention why there isn't a forum for 3d modelling and digital artworks other then the web development multimedia. Would it be possible to create such a forum or perhaps move the multimedia forum to somewhere where it is more accessible by the menus.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

I believe that is the correct syntax however the files should be accessible with AND without rewritten urls. Also if you want to make sure apache doesn't get into an infinit loop causing a 500 error then you could use the following:

RewriteEngine On 
RewriteCond %{HTTP_HOST} ^nu.wetwork\.org\.uk
RewriteRule ^(.*)$ http://www.nu.wetwork.org.uk/$1 [R=301,L]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^/?(.*)/(.*)/?$ /index.php?adran=$1&tud=$2

So to explain what those last three lines do, the two lines near the end beginning with RewriteCond% check that it is not rewriting a file or directory. Then the last line matches the regex on the left in the url and if that matches it views the page on the right similar to the preg_replace syntax. Is that what your after because you may need to just try viewing it in the new format and linking to the new format as both ways exist when using mod_rewrite?

diafol commented: Brilliant! thank you very much - I was going off my rocker! +5
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

is spammer the who wonder I.

Now that's strangly worded. Reverse the words and you get the sentence.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Try modifying along the lines of this

RewriteEngine On 
RewriteCond %{HTTP_HOST} ^nu.wetwork\.org\.uk
RewriteRule ^(.*)$ http://www.nu.wetwork.org.uk/$1 [R=301,L]

RewriteRule ^/?(.*)/(.*)/?$ /index.php?adran=$1&tud=$2
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Try this:

<?php
// Fill up array with names and type
$a[]="Anna -silver"; // what i want when the name is                              
$a[]="Brittany-silver";//being typed it would not show the name 
$a[]="Cinderella-gold";// it would only show the type
$a[]="Diana-bronze";


//get the q parameter from URL
$q=$_GET["q"];

//lookup all hints from array if length of q>0
if (strlen($q) > 0)
  {
  $hint="";
  foreach($a AS $b)
    {
    if (strtolower($q)==strtolower(substr($b,0,strlen($q))))
      {
      $var=$b;
      $var=explode('-',$var);
      $var=$var[(count($var)-1)];
      if ($hint=="")
        {
        $hint=$var;
        }
      else
        {
        $hint=$hint." , ".$var;
        }
      }
    }
  }

// Set output to "no suggestion" if no hint were found
// or to the correct values
if ($hint == "")
  {
  $response="no suggestion";
  }
else
  {
  $response=$hint;
  }

//output the response
echo $response;
?>
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

I would suggest following a tutorial and tizag is really good for learning.
http://www.tizag.com/ajaxTutorial/ajaxform.php

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Is this using wamp, xampp or a vps? Judging by the error message your not using wamp/lamp/xampp so if your running a localhost test server then I would suggest using wamp. If however that is not the case then the general solution in wamp is to reinstall the package or with xampp to downgrade to an earlier version. Wamp is better for new starters but if however you are using a vps then I would suggest reinstalling the php module as it may not have compiled correctly.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

I bit of css should do the trick.

<div style="border:1px #FFFFFF ridge; width:70px; height:70px; overflow-x: auto; overflow-y: auto;">
<select name='color[]' style="border:0px;" size=6 multiple>
<option value='' selected>Select Item</option>
<option value='blue'>Blue</option>
<option value='green'>Green</option>
<option value='red'>Red</option>
<option value='yellow'>Yellow</option>
<option value='white'>White</option>
</select>
</div>
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Do you mean something like this:

<select name="color[]" size=2 multiple>
<option value="" selected>Select Item</option>
<?php
$colors=array('Blue','Green','Red','Yellow','White');
foreach ($colors AS $color) {
echo '<option value="'.strtolower($color).'">'.substr($color,0,3).'</option>'."\n";
}
?></select>
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

I cleaned up the code a bit and although I don't know much about setting up the arrays in a html form I believe the complete code should look more like the following:

<strong>Update multiple rows in mysql</strong><br> 
<?php
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password=""; // Mysql password 
$db_name="onm"; // Database name 
$tbl_name="sims_ac"; // Table name 

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
$a='S-KTR-0139';

$sql="SELECT * FROM $tbl_name WHERE SiteID ='$a'";
$result=mysql_query($sql);

// Count table rows 
$count=mysql_num_rows($result);
?>
<table width="500" border="0" cellspacing="1" cellpadding="0">
<form name="form1" method="post" action="">
<tr> 
<td>
<table width="500" border="0" cellspacing="1" cellpadding="0">


<tr>
<td align="center"><strong>SiteId</strong></td>
<td align="center"><strong>AcMake</strong></td>
<td align="center"><strong>AcCapacity </strong></td>
<td align="center"><strong>AMP</strong></td>
<td align="center"><strong>qty</strong></td>


</tr>
<?php
for ($i=0;$rows=mysql_fetch_array($result);$i++){
echo "<tr>\n";
echo '<td align="center">'.$a.'</td>'."\n";
echo '<td align="center"><input name="AcMake['.$i.']" type="text" id="AcMake" value="'.$rows['AcMake'].'"></td>'."\n";
echo '<td align="center"><input name="AcCapacity['.$i.']" type="text" id="AcCapacity" value="'.$rows['AcCapacity'].'"></td>'."\n";
echo '<td align="center"><input name="AMP['.$i.']" type="text" id="AMP" value="'.$rows['AMP'].'"></td>'."\n";
echo '<td align="center"><input name="qty['.$i.']" type="text" id="qty" value="'.$rows['qty'].'"></td>'."\n";
echo "</tr>\n";
}
?><tr>
<td colspan="4" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</td>
</tr>
</form>
</table>
<?php
// Check if button name "Submit" is active, do this 
if($_POST["Submit"]=="Submit")
{
for($i=0;$i<$count;$i++){
echo "hi";
$sql1='UPDATE `'.mysql_real_escape_string($tbl_name).'` SET AcMake="'.mysql_real_escape_string($_POST['AcMake'][$i]).'", AcCapacity="'.mysql_real_escape_string($_POST['AcCapacity'][$i]).'", AMP="'.mysql_real_escape_string($_POST['AMP'][$i]).'", qty="'.mysql_real_escape_string($_POST['qty'][$i]).'" WHERE SiteId="'.mysql_real_escape_string($a).'"';
$result1=mysql_query($sql1);
}
}
mysql_close();
?>
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

That code in it's design is flawed. The following line will cause a lot of trouble:

$sql1="UPDATE $tbl_name SET AcMake='$AcMake[$i]', AcCapacity='$AcCapacity[$i]', AMP='$AMP[$i]', qty='$qty[$i]' WHERE SiteId='$a'";

The arrays placed into this query do not exist. From my guess you are trying to use $_POST values in some strange way. So I would suggest the following code or please explain that line.

$sql1='UPDATE `'.mysql_real_escape_string($tbl_name).'` SET AcMake="'.mysql_real_escape_string($_POST['AcMake'][$i]).'", AcCapacity="'.mysql_real_escape_string($_POST['AcCapacity'][$i]).'", AMP="'.mysql_real_escape_string($_POST['AMP'][$i]).'", qty="'.mysql_real_escape_string($_POST['qty'][$i]).'" WHERE SiteId="'.mysql_real_escape_string($a).'"';
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Netbeans... It may be good for Java but I wouldn't recommend using Netbeans for php unless you find php terribly hard. Instead use a php text editor (Not IDE) and things will be a lot simpler as php has a great debugging system as it is.

I have followed the online tutorials for setting up your first php project using netbeans ide 6.5 mi. my project - NewPHPProject tree appears in the Projects window but i cant see the project's index.php file. What could be wrong?

NewPHPProject tree
|
source Files
|
NewPHPProject tree

That is the project tree that i see.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

The following should do the trick the the result being in the $res array

<?php
$var=$_POST['box'];
$i=1;
$res=array();
$var=(empty($var))?array():$var;
foreach ($var AS $val) {
    $n=substr($val,-1);
    while ($i<$n) {
        $res[]=false;
        $i++;
        }
    $res[]=$val;
    $i++;
    }
while ($i<=5) {
    $res[]=false;
    $i++;
    }

?><form method="POST">
<table>
<tr>
<td><input type="checkbox" name="box[]" value="box1"/></td>
<td><input type="checkbox" name="box[]" value="box2"/></td>
<td><input type="checkbox" name="box[]" value="box3"/></td>
<td><input type="checkbox" name="box[]" value="box4"/></td>
<td><input type="checkbox" name="box[]" value="box5"/></td>
</tr>
</table>
<input type="submit" value="Send">
</form>
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

This is the default behavior, yes, but you can change it. See: 13.6.2.1. Using Per-Table Tablespaces
And this is only relevant to InnoDB tables. MyISAM tables are each stored in three separate files, so this in no way applies to them.

I see how that can be handy but another thing I have noticed with sites like google and youtube is that they seem to redirect users to their country code domain meaning there is a separate database for each domain is different. Perhaps that is the more efficient way of dividing the content. Example: http://au.youtube.com
However from reading what Atli has to say using correct mysql methods with many tables should also do the job.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

They can be very useful for websites like Wikipedia and YouTube, who's content is generally pretty static, but aren't really of much use to websites like Facebook, who's content changes on pretty much every request.

Just a note on that. Wikipedia receives 1,000 new articles every day and many more edited articles so it is possible to compare Wikipedia to ever changing websites such as Facebook. I guess it is a matter of personal preference but to me it doesn't make much of a difference because the data is still stored in the same source file. That is each database has a separate file and so having a separate table will not make a too greater difference if it needs to search from a list of a million tables. So as I said the decision of this section of database design is personal preference as both ways have their advantages and disadvantages which equal out to be the same.

Just something I should have said earlier...
If placing all the data in one table, it is often best to put the big column and a few identifiers in one table then the rest of the columns in another table and use join statements instead of having all the columns in the one table. So Basically there would be two tables one with the page data and the other with little bits of info and this can speed things up when you only need the little bits of info. …

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

But those are extreme cases. Only apply to people that measure the hourly database size increase in Terabytes :-)

Are you at all familiar with the mediawiki cms. That is the same cms wikipedia uses and it does not spread into millions of tables. Instead it has hundreds of computers that just process the database. These are known as cache servers. So try downloading mediawiki and see how wikipedia does it and you will find there is only one table and joins are used a lot to save space. So wikipedia only has the one table for storing all articles and that can be confirmed by checking the mediawiki cms so I would recommend doing the same.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Here's a script from this article.

<?php
$pages_left=3;
$pages_middle=4;
$pages_right=2;
 
$total_pages=100;
if (!isset($_GET['page']) && empty($_GET['page'])) {
$currentpage=0;
} else {
$currentpage=$_GET['page'];
}
for ($p=0;$p<=$total_pages;$p++) {
    if ($p<$pages_left || $p>=($total_pages-$pages_right) || ($p>=($currentpage-floor($pages_middle/2)) && $p<=($currentpage+floor($pages_middle/2)))) {
        if ($p==$currentpage) {
        echo ($p>0)?' - ':'';
        echo '<b>'.($p+1).'</b>';
        } else {
        echo ($p>0)?' - ':'';
        echo '<a href="index.php?page='.$p.'"><b>'.($p+1).'</b></a>';
        }
    }
}
?>
kvprajapati commented: Great! +6
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Hey.

In a properly designed CMS, changing anything just INSERTs, UPDATEs or DELETEs stuff from the database. If it is actually creating tables, or otherwise changing the database structure, there is usually something wrong with the database design.

Exceptions to this are webs with insane numbers of visitors, where the tables get so big they become unmanageable and start affecting performance. (I'm talking here about websites the size of Facebook or the WordPress blog. If you are wondering if this applies to your web, it almost definitely doesn't ;-P)

But yea, not really knowing much about the WordPress system itself, I would suspect that adding a page just INSERTs a row into a "page" table somewhere, and the contents of that page get inserted with it, or into a table related to it.

Well actually I have been told in the mysql forum that if you design a table so that it has indexing you shouldn't ever need multiple tables for the one job. That is when designed properly because with table indexing it can make the difference between minutes and milliseconds for a mysql query however will take up additional space. In case you don't know what table indexing is table indexing is one of the options when creating each table column in phpmyadmin.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

I agree. It "feels" much quiter than normal. Not so many questions get posted as normal. I miss my challenge to try and answer those questions.

mmmmmmm. Maybe holidays started earlier....

I agree because I used to solve questions like crazy in the php forum but now there are fewer questions that are not already solved by another member. I hope this doesn't spell the beginning of the end of daniweb. That would be very bad. :(

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

I'll tell ya where I have gone when I'm not online - to work and to sleep... Next!

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

@cwarn23, I think the OP was saying, that it shows only 1 record instead of 2 !

Maybe my explanation was too short. Sometimes people will do the following:

<?php
$connection = mysql_connect("myserver.com","myuser","mypassword") or die ("Couldn't connect to server."); 
$db = mysql_select_db("mydb", $connection) or die ("Couldn't select database."); 

$search=$_POST['search'];

$data = "SELECT firstname, lastname, task FROM inventors WHERE taskdate - curdate() = 1";
  $query = mysql_query($data) or die("Couldn't execute query. ". mysql_error());
$data2 = mysql_fetch_assoc($query)
while($data2 = mysql_fetch_assoc($query)) {
echo $data2['firstname']; 
echo $data2['lastname'];
echo $data2['task']; 
echo '<hr>';
}
?>

However the above is incorrect and therefore should be replaced with the below.

<?php
$connection = mysql_connect("myserver.com","myuser","mypassword") or die ("Couldn't connect to server."); 
$db = mysql_select_db("mydb", $connection) or die ("Couldn't select database."); 

$search=$_POST['search'];

$data = "SELECT firstname, lastname, task FROM inventors WHERE taskdate - curdate() = 1";
  $query = mysql_query($data) or die("Couldn't execute query. ". mysql_error());
while($data2 = mysql_fetch_assoc($query)) {
echo $data2['firstname']; 
echo $data2['lastname'];
echo $data2['task']; 
echo '<hr>';
}
?>

Basically that additional line can chew that first mysql result therefore only the second in this post should be used.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Still returns one row instead of two... :S

So it displayed something... So we know that you were using the right names but the normal cause of this is an extra line of code. Try the following script.

<?php
$connection = mysql_connect("myserver.com","myuser","mypassword") or die ("Couldn't connect to server."); 
$db = mysql_select_db("mydb", $connection) or die ("Couldn't select database."); 

$search=$_POST['search'];

$data = "SELECT firstname, lastname, task FROM inventors WHERE taskdate - curdate() = 1";
  $query = mysql_query($data) or die("Couldn't execute query. ". mysql_error());
while($data2 = mysql_fetch_assoc($query)) {
echo $data2['firstname']; 
echo $data2['lastname'];
echo $data2['task']; 
echo '<hr>';
}
?>

Now what happens?

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

To test if no rows are found try the following:

while( $data2 = mysql_fetch_array($query)) {
echo $data2[0]; 
echo $data2[1];
echo $data2[2]; 
}

The nothing is displayed then that means there are no rows due to the WHERE clause.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Replace lines 11 to 13 with the following

echo $data2['firstname']; 
echo $data2['lastname'];
echo $data2['task'];
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

This code will throw an error at line4 saying "headers already sent"
So no echoes before the header() :)

Just to make it clear - indeed there should be no echos before the header().

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

cwarn23 thanks for the elaboration.But are you trying to say that, the mysql insert will be executed in the below code as there is no exit after the header() -

if(something)
{
header("Location:new_url.php");
mysql_query($insert_query);
}

compared to the code below -

if(something)
{
header("Location:new_url.php");
exit;
mysql_query($insert_query);
}

That is correct from what I have read in the past.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Perhaps this:

<?php
mysql_connect(HOST,USER,PASS);
@mysql_select_db("db303278079") or die( "Unable to select database");
$query="SELECT * FROM restaurants";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
for ($i=0; $i<$num; $i++) {
$rest_name=mysql_result($result,$i,"rest_name");
$address=mysql_result($result,$i,"address");
$telephone=mysql_result($result,$i,"telephone");
$website=mysql_result($result,$i,"website");
$cuisine_type=mysql_result($result,$i,"cuisine_type");
$area=mysql_result($result,$i,"area");
$website=(empty($website))?'':", <A HREF=$website>'Website'</a>";
echo "<strong>$rest_name</strong>, $address, $telephone, ($cuisine_type), $area$website<br >";
}
?>
dmkc commented: helps a lot to show me where I'm going wrong, thanks for the help!! +0
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Well actually the entire page will be process by php unless the exit; statement is placed there. So for example if you have a mysql insert it will insert before redirecting unless the exit; is placed immediatly after the header. And yes it will redirect the user to index.php however it is the browser that redirects the user and not the server. Basically when the browser reads that header the browser will then go to that location.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

No! No! Its just an experiment. I want a bot which enters "0001" in google search text box, then "0002", Then "0003" to "9999" with some time difference. Is that a spam/virus bot?

PHP would be the section if you have a webserver with php installed. Also google has their own api's for this kind of stuff so it is possible to do in a number of languages. If you plan to write it in PHP then post a topic in the PHP section and pm me the link.

If your not sure what PHP is well it's basically a language to write webpages or tell a server what to do and has many features including bot making.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

If you want wildcards then the following contains the wildcards:

$sql = 'SELECT * FROM device WHERE `device_num` LIKE "%'.mysql_real_escape_string($val_d).'%" OR `dib` LIKE "%'.mysql_real_escape_string($val_dp).'%"';
cwarn23 387 Occupation: Genius Team Colleague Featured Poster
<?php
header("Location: http://yoursite.com/index.php");
exit;
//above must be at very top before any browser output
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Try adding the following to the top of your php file(s)

setcookie ('PHPSESSID', $_COOKIE['PHPSESSID'], time()+172800);
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Try replacing it with the following:

$sql = 'SELECT * FROM device WHERE `device_num` LIKE "'.mysql_real_escape_string($val_d).'" OR `dib` LIKE "'.mysql_real_escape_string($val_dp).'"';
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

So in other words, it goes through all the possible 6 character combinations of sha1?

Sounds neat, how long does it take to do 6? 7? 8? etc?

Well I have made a set of tickboxes for if you think the original string contained upper case letters, lower case letters, numbers, or symbols. So those are four options and the more that are selected the longer it will take because there will obviously be more hashes to check when including more types of characters. With all 4 tickboxes ticked it can do 2 digits in 50 seconds or 1 digit in less than 1 second. However with some tickboxes disabled it will be faster and you can choose how far in to stop processing.

Just a note: on the previous attachment you will need to select the combo box before anything else otherwise it becomes impossible to select a different number of characters. Have now fixed that in my latest version.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

no. how is anyone to know in a year

It will be posted on the internet and possibly on daniweb. I'm not sure what else you were thinking about?

Anyways, I have made a dehasher that can dehash up to 6 digits depending on what characters are to be dehashed and time allowed. You can grab a copy of the SHA1 dehasher from the attachment on this post to see how insecure SHA1 is IMO. Enjoy dehashing the >=6 digit hashes.:)

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

I don't recommend XAMPP, though it is good once you get used to it! I recommend WAMP, it is elegant and Good. Also check your PHPMyAdmin to browse your databases

I would have to say if you managed to get XAMPP working then good, keep it as XAMPP has a few minor additional features that WAMP doesn't have (eg. mailserver) although the installation for XAMPP is buggy. If you have already passed the step of installation then the bug will no-longer affect you although one may argue there is no real difference between XAMPP and WAMP as they are both the same localhost server package.

Anyways to insert into mysql the following is the method I use:

INSERT INTO `table` SET `column name` = "Value"
cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Try the following:

<?php
require_once('config.php');
    
    for ($i=1;$i<11;$i++) {
    $aid='aid'.$i;
    $$aid=$_POST['Question-'.$i];
    
    $qid='qid'.$i;
    $$qid=$_POST['qid'.$i];
	
    $query = 'UPDATE answers SET acount = acount + 1 WHERE aid = "'.mysql_real_escape_string($$qid).'" AND qid = "'.mysql_real_escape_string($$qid).'"';
    mysql_query($query) or die("ERROR: $query. ".mysql_error());    
    }
    mysql_close();
?>

I haven't tested it for bugs and yes those variables with two dollar signs should be correct. Also you can take a look at my loops tutorial as additional reference.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

how is anyone to know cwarn?

What do you mean. How is anyone to know weather I'm correct? Could you expand that question as it has little detail.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

I've already made my point and don't see any point in explaining it any further but I will say in the coming years we will see who makes the worlds best hash cracker.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

Can you guys refer to people and not 'you' I assumed you guys were talking to me at first since I was the last both, didnt realize you had an argument between each other :D

Well when I say the word "you" I refer to the reader. Sorry if it was a bit confusing as many things in this topic are confusing to the untrained eye.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

However if a person made a virus which took over the users cpu and lets say there were 500,000 copies of that virus sent out and the average computer could do 10,000 hashes per second then 500,000 x 10,000 = 5,000,000,000 strings could be hashed per second. That is an incredible amount of cpu not to mention the possibility of taking over googles mainframe in which case trillions more hashes per second could be done. So with the combination of taking over googles mainframe and planting a virus on every computer it would be possible to dehash at least a dozen digits if processing long enough. You see that's the thing. Hackers have access to unlimited cpu, unlimited ram etc so they can dehash whatever they want providing they can write a good virus. So with todays technology it is possible but if you still don't believe me then we will see who gets their hashes hacked. An example of this is the crc32 hash - it has already been hacked and it's only time until somebody scratches their head to crack the other hashes.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

If you wont listen then I shall show you the hard way. Attached to this post is a live dehasher written in Java which will check every combination hash to the specified digits to find the original string. Currently it will only dehash to 3 digits and any more it will freeze your computer. However with a mainframe it would be possible to do all 6 digits and very possibly more. Also the "exit dehashing" button doesn't work btw just so you know. Have fun dehashing.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

I'm not denying that for a second. But, if you've got access to six of the worlds fastest computers, You've got bigger fish to fry than my websites.

And, the same applies for ANY hashing function. You cannot create a "future proof" hashing/encryption function.

So how about you quit pointing out the obvious, and get back on topic?

The future comes fast. Have you read this article? Yea, would like one of those in 10 years and everybody will have one of those on their desk in 10 years. So the fact is if the government who buys these super computers can dehash or hash-match then hackers can take over those computers to do the dehashing/hash-matching. This is only in about 2 years. Untill then all the hackers will need to do is take over more computers. Example, perhaps Googles mainframe. Imagine a hacker in controll of googles mainframe doing just dehashing/hash-matching and Googles mainframe processes over 5% of the internet including google apis. So one simple system that can be hacked where 5% of the worlds cpu can be use for any single job. That has already happened twice in the past year for about 52 hours. Of course google tries to cover it all up.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

However theoratically if you hacked 6 of the worlds fastest computers to calculate every possible combination hash then there is nothing stopping you from retrieving the original string. And Basically what you do is you loop through the char() function to get the character and use a loop to piece together strings all in alphabetical order then hash the 255^100 strings and see what hashes match the original hash. Then if the computer hashes a string and the resulting hash is the same as the one found in your database then bingo they have your original string.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

OK, I gotta throw my 2 cents in here. There is no such thing as a de-hasher. A hash is ONE WAY. The only thing that can be done is to produce every possible string against the salt using the same algorithm to produce the same hash. It's not possible to reverse a hash, that's why it's a hash.

Hash one way, your thinking in terms of 1998 technology. Today we have supercomputers with millions of cpus with petaflops whatever that means. So when the performance of the average computer increasing every month it makes it possible for the computer to hash every combination until there is a matching hash. And with today's average home pc, it is possible to crack a hash where the original string was ONLY 3 digits long and that takes about 40 seconds. However with a supercomputer perhaps something like 7 digits could be cracked in that time. Keep up with the technology dude.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

i dont tink they wil fix it i made a forum post they said its a error that is rare and that the unhasing seemed like nothing to do with it whne i red the posts they made. then i heard that its caused by stuff that i know i didnt do. so it must be the dehasing they are liars. i think they want to incriminate anyone for dehashing when they dont~ i dont dehash i am not a cirminal

A person who dehashes info isn't always a criminal. Sometimes people will need to retrieve personal data etc that has been hashed and that is where a dehasher comes in. Recently I have made another dehasher that can dehash any 3 digits with Java in about 40 seconds. So say your were to store all your numbers as hashes and needed to find the original number, a dehasher could be handy there.

cwarn23 387 Occupation: Genius Team Colleague Featured Poster

oh well i only "hash" passwords. theres nothing else o my site that needs encrypting

I was meaning that in the future todays hash functions will eventually be used as encryption functions as they would in the future easily be decrypted. But the technology is till to come in many many years so most people don't worry about that part of future security unlike myself who secures every piece by future standards.