Posts by cwarn23

I do hope will help people to think where we all we humans are going.

Yea, I think by year 2100 we will be like the ancients from Stargate Atlantis where we modify our DNA to make Microsoft and Google Genes and with technology being limitless. Can't wait to see the day... If there is a movie based on it I must see it...

Keep in mind that multiple births are clones - eg idntical twins or greater are clones. If you disagree, define your terms.

I sorta disagree. My Definition - A clone is an organic product produced in a non natural way and without a god (like a machine but organic).

The old mail function bug. The smtp only works if you have a localhost mail server. The reason, there is no password provided anywhere for php to read so access is denied to the remote smtp although you could try the imap_mail() function to see if it makes a difference. Alternatively I have heard in the past there are some scripts that provide custom mail functions which will allow such a smtp request.

Any reply?

Well first of all place the following at the top of every php file but not the files which are being included (eg not include.php).

<?php
session_start();

After that make sure you have cookies enabled. If you have cookies disabled then sessions won't work. Why? Sessions send a single cookie containing the session id to identify which computer the data belongs to and if you have cookies disabled your computer is unable to identify itself. Alternatively you can link to a page like the following without cookies and sessions might work.

echo '<a href="index.php?'.SID.'">test</a>';

So the main message - enable cookies and put session_start(); at the top of each non-include file.

I agree. Storing a timestamp in a int field would be by far better as more functions would be available for the the job. Then after having the timestamp you can perform math operations to check dates and everything since a timestamp is number of seconds since 1980.

The equations a+b and a^b were two separate questions. So do you know how I would solve that?

Well, there goes Cancer research, disease control, pest control. Our world will be a better place when dangerous bacteria can run rampant because, as an organism, it's treated as a human. And mosquitoes...

lol. I never thought of it that way before. From what I am reading on this topic I guess some animals/organisms should have some rights but not the same rights as humans. Interesting to see how the world would be like with animal rights laws. But yea - from that quote I can see why other organisms don't have the same rights as humans.

Try making this your query and see what error mysql reports back.

$qry = "SELECT `userid`, COUNT(*) as `cnt` FROM table1, table2 WHERE userid = id GROUP BY userid ORDER BY cnt DESC LIMIT 0,10";

Hi and sorry if this is the wrong forum but didn't know where to place my question. I need to know the answer of a+b=23. So how would I calculate the values of a and b and the same would apply for a^b=16. So basically I need to know the algebraic equation to find the original numbers. Does anybody know where I can find such a formula as I am trying to reverse a formula. Thanks...

Nut and sledgehammer spring to mind. I suppose my previous ironic post flew above the parapets. Who cares?

I mean, if somebody gives a little too much help from time to time? Does it affect the total entropy of the universe? The more seasoned contributors will usually tell a newbie to post his/her code first, whereas a young buck trying to carve a name for himself on the forum will try to provide a complete solution - which will inevitably be full of holes, which aforementioned seasoned contributors will identify, which will thus propagate further discussion. I reckon it's just natural progression. Newbies become young bucks become seasoned contributors.

That I would agree with and as a natural progression there isn't much that you can really do to change it although there are things that you can try and probably won't work how we want them to work.

If you are individually have these columns in WHERE clause then create indexes separately on each column and drop them from composite index. Did you read the article I provided?

I just created 3 separate indexes for the three columns as suggested however my server was struggling to create the indexes for all 45 million rows. So I've emptied the tabled and changed the indexes and it will be about another 3 days before I find out if it worked. I shall post here if it doesn't work but hopefully the new database will be much more usable. Thanks for the great information and now I have a greater understanding of mysql indexes.

Even drop the crc32 and crc32b indexes since the where clause can also search the crc32 and crc32b columns?

Most common computer problem is the interface between the chair and the keyboard

Do you mean the computers loop interface...

Below is the ouput.

CREATE TABLE `hashes` (
 `id` char(7) NOT NULL,
 `crc32` char(5) NOT NULL,
 `crc32b` char(5) NOT NULL,
 `sha1` char(12) NOT NULL,
 KEY `id` (`id`,`crc32`,`crc32b`,`sha1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Also I currently have 45457356 rows and the number is increasing by the minute. Is there a flaw in my database design as I don't mind deleting the table and starting with a new design...

The results are as follows:

id=1
select_type=SIMPLE
table=hashes
type=index
possible_keys=NULL
key=id
key_len=29
ref=NULL
rows=45404440
Extra=Using where; Using index

Any ideas?

The my.cnf file is as follows:

[mysqld]
skip-bdb
skip-innodb
ft_min_word_len=3

[myisamchk]
ft_min_word_len=3

Also as for the ram I have about 700MB boostable. And I couldn't find the key_buffer_size. Also the result for the explain select query is as follows:

EXPLAIN SELECT * FROM `hashes` LIMIT 2000000 , 1

id=1
select_type=SIMPLE
table=hashes
possible_keys=NULL
key=id
key_len=29
ref=NULL
rows=45128232
Extra=Using index

Does this give any clues as to what the problem is because if I try to view the last few rows in phpmyadmin that also crashes the sql server. It is as if mysql will only read the first so many rows before crashing.

c) I just looked at the very first post in the PHP section. The Code tag message is in the text box.

I just took another look myself and something in the past month must have changed because once there use to be that message only when signed in. But I see that has all changed now. I guess I should check out these things more often.

As for solving the problem of homework posts, the only thing I can think of at the moment is embedding text to speech software in the forum so the forum speeks to the user and actually tells the user to use code tags and not to post homework. I guess you couldn't make it much clearer than that. I think java provides free text to speech software.

I checked an article and it appears that the problem is with the way mysql is operating. It is like if there is something wrong with the mysql temp files located in your /tmp/ directory. If this is wamp or xampp then I would suggest rebooting the mysql service and if that doesn't work then perhaps a google search on "mysql error code 28" might give you a better picture.

Any guess as to the percentage of new posters that miss all 6 (at my count) places the tags are mentioned?

Perhaps 20% of new users in the php forum. However they/dani missed a spot. When you reply to a 4 year old topic and your not signed in I don't think there is the code tags message in the textbox. So yea that is where the problem with the code tags lies.

For starters try replacing line 20 with the following.

mysql_query('UPDATE `candidate` SET `votes`=`votes`+1 where `can_id`="'.mysql_real_escape_string($val).'"' );

The best way is to just on login, send a session cookie to the user or a cookie that expires when the user leaves the website. Then when the user accesses a page with the cookie then a `online` column in the mysql user database will turn into the current timestamp value. Then a cron job checks if that timestamp subtract the current timestamp is greater than 150 seconds and if that is true then php will replace the timestamp with 0 making the user offline. Hope you could understand that.

You mean like the announcement We only give homework help to those who show effort and the sticky post Read This Before Posting? What a good idea! Think that will help? :icon_wink:

They don't seem to help in the C/C++ forum...

Didn't realize it had been tried and failed before. If announcements don't work the only thing I can think of is having above the message box where they type their post is a cartoon providing these messages. That is a long shot but I'm clueless.

Well in my opinion I don't mind helping with others homework as long as they are willing to put the effort to piecing the puzzle together. So even if there was an announcement and if people read it people would still post their homework. Why? Because there aren't very many alternatives. I'm not defending those people but am just saying what they would do. My suggestion? Make a general "Read before posting" sticky and if you don't want to help anybody with their homework then just point to them that there is a sticky about what they are doing and simply don't help them out. Let somebody else who doesn't mind helping with homework to help them out. But usually the homework stuff is easy (usually) and is partially what powers the amount of topics in the php forum.

So correct me on this sentence but if you don't like people posting homework wouldn't it be best to tell them to read the sticky about no homework allowed and perhaps let somebody else help out if they have free time?

There's smoke coming out of my cpu again and I'm not sure what to do. I googled it and found the answer to be "your waffles are ready". I guess it's not a good idea to cook my waffles on the cpu.

When you remember this thread just like myself. The good old days.

Hi and I have a database with over 32 million entries and whenever I try the below mysql query or simular it crashes the sql server unless I use phpmyadmin. I have 4 columns all indexed and all are the char() type with a fixed length. Below is an example query

SELECT `id` FROM `hashes` WHERE `sha1`="<º5AD@$;\"#"

Also my column structure is as follows

id    = char(7)
crc32 = char(5)
crc32b= char(5)
sha1  = char(12)

All of those columns are indexed. I have a 2GB index. Does anybody know why this query crashes my sql server?

On the other hand, the pyramids were a sort of WPA project to keep people employed but even that degenerated to slave labor.

That is totally incorrect. The Egyptians built the pyramids during their all their spare time to worship their gods. They were not paid to do so and there was nobody forcing them to do so. The Egyptians thought that if they built something for their gods then the gods would give something back.

Ya know, your 'god farted' wasn't funny the first time and it get less funny as you continue to beat that poor horse. Let it go.

I know it's not funny but if I'm going to believe in a religion it will be that one.

Interesting thread and I thought vegetarians had all the answers.

Is this the underlying issue? Personally, I don't see a problem with treating clones the same as naturally born creatures of the same species. The end result is the same, so who cares what the process was?

Well as for why somebody would care about the process is that clones are like machines. They can be created and programmed then destroyed for spare parts. However they still are organisms but a low level organism and what does that describe - animals. However if every organism was treated as a human then there would be no problem with producing clones.

Do lions care how the zebra is feeling when they hunt it down and devour it?

Except there is one difference between lions and humans - intelligence. And it is intelligence that is going to doom us all because we mass hunt. So far it sounds like more people prefer evolution to go through its natural process until humans are the only species left on the earth. Now I think about it after reading this thread perhaps it is the concept of money that has made things terribly bad because people can buy as many hunted animals as they want where as in the olden days people would have to go into the fields and actually shoot some animals instead of buying. But anyways I am starting to see why animals don't have the same/similar rights as humans (Natural instincts).

In that case you would need to use something like the following

php /home/<user>/httpdocs/auto_mailer.php

Where <user> is your cpanel login username assuming this is a linux machine.

How did the gas particles (if that's what you think made the universe) exist, then? Trying to contemplate how anything existed to make anything gives me a headache, so I'll let you do it for me =)

Read the below quote from an above post and you will see that god farted twice creating two gas particles then the gas particles collided making the universe.

I thought god was there for a long time before with his room mate shugs until they went for an arm wrestle when god farted twice then won and those two gas particles created the universe. That's the theory I believe in.

Hmm, where's the any key. I see ctrl and alt. I think I might just order a tab. Ow, computers starting.

I would suggest following the manual at http://www.php.net/manual/en/image.requirements.php

Well copy and past the code in post #10 then as a test load that exact file on your browser (without any other code/files) to test if you have the gd library installed. Then see if there are any error messages when opening the file directly.

Sorry for the late reply. To run it just copy the above code into a separate file. Then in your main file place the following code.

<?php
echo '<img src="graphgenerator.php">';
?>

Then it should generate the graph as an image using the script above. And note graphgenerator.php is the code in post #10.

I borrowed a friends computer and needed to make an online payment. So I looked at the box then placed my credit card into the floppy drive to make the payment. The payment didn't work but now my credit card is stuck in a friends computer. Does anybody know how to fetch a credit card from a floppy drive?
I read this one on the net and if you have any statements like it then please share... So funny lol.

is it problem when retrivinng data from database.

As long as you don't put html code inside the display function it should work fine.

Did ya here in the news that Opera is now the worlds fastest browser. Even beats Crome. Opera sure is the one true browser because it is the only one which doesn't crash after the bug in mosaic which all other browsers are based on.

Try this.

<?
if (!isset($_GET['language']) || empty($_GET['language'])) {
$_GET['language']='en';
}
/**
 * Translating language with Google API
 * @author gabe@fijiwebdesign.com
 * @version $id$
 * @license - Share-Alike 3.0 (http://creativecommons.org/licenses/by-sa/3.0/)
 * 
 * Google requires attribution for their Language API, please see: http://code.google.com/apis/ajaxlanguage/documentation/#Branding
 * 
 */
class Google_Translate_API {

	/**
	 * Translate a piece of text with the Google Translate API
	 * @return String
	 * @param $text String
	 * @param $from String[optional] Original language of $text. An empty String will let google decide the language of origin
	 * @param $to String[optional] Language to translate $text to
	 */
	function translate($text, $from = '', $to = 'en') {
		$url = 'http://ajax.googleapis.com/ajax/services/language/translate?v=1.0&q='.rawurlencode($text).'&langpair='.rawurlencode($from.'|'.$to);
		$response = file_get_contents(
			$url,
			null,
			stream_context_create(
				array(
					'http'=>array(
					'method'=>"GET",
					'header'=>"Referer: http://".$_SERVER['HTTP_HOST']."/\r\n"
					)
				)
			)
		);
		if (preg_match("/{\"translatedText\":\"([^\"]+)\"/i", $response, $matches)) {
			return self::_unescapeUTF8EscapeSeq($matches[1]);
		}
		return false;
	}
	
	/**
	 * Convert UTF-8 Escape sequences in a string to UTF-8 Bytes
	 * @return UTF-8 String
	 * @param $str String
	 */
	function _unescapeUTF8EscapeSeq($str) {
		return preg_replace_callback("/\\\u([0-9a-f]{4})/i", create_function('$matches', 'return html_entity_decode(\'&#x\'.$matches[1].\';\', ENT_NOQUOTES, \'UTF-8\');'), $str);
	}
}


$input= "http://localhost/addmultiplelanguajes-2009-08-15/k1.php";
function display($input) {
$trans_text = Google_Translate_API::translate($input, '', $_GET['language']);
    if ($trans_text !== false) {
        echo $trans_text;
    }
}




echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">'."\n";
echo '<html xmlns="http://www.w3.org/1999/xhtml">'."\n";
echo '<head>'."\n";
echo '<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />'."\n";
echo '<title>'; display('Untitled Document'); echo '</title>'."\n";
echo '</head>'."\n";
echo "\n";
echo '<body>'."\n";
echo '<form name="language" action="'.$_SERVER['PHP_SELF'].'" method="GET">'."\n";
echo '	<select onchange = "document.language.submit()"  name="language">'."\n";
echo '    	<option selected="selected">'; display('select-language'); echo '</option>'."\n";
echo ' …

Try this code:

<?php
$values=array(32,76,34,65,62,29,54,23,29,34);
//above is an array of values for the chart

//image size
$image_width=320;
$image_height=240;

//line thickness
$line_thickness=3;

//line color
$line_color['r']=0;
$line_color['g']=0;
$line_color['b']=0;

//background color
$bg_color['r']=255;
$bg_color['g']=255;
$bg_color['b']=255;


//raw code
function imagelinethick($image, $x1, $y1, $x2, $y2, $color, $thick = 1)
{
    /* this way it works well only for orthogonal lines
    imagesetthickness($image, $thick);
    return imageline($image, $x1, $y1, $x2, $y2, $color);
    */
    if ($thick == 1) {
        return imageline($image, $x1, $y1, $x2, $y2, $color);
    }
    $t = $thick / 2 - 0.5;
    if ($x1 == $x2 || $y1 == $y2) {
        return imagefilledrectangle($image, round(min($x1, $x2) - $t), round(min($y1, $y2) - $t), round(max($x1, $x2) + $t), round(max($y1, $y2) + $t), $color);
    }
    $k = ($y2 - $y1) / ($x2 - $x1); //y = kx + q
    $a = $t / sqrt(1 + pow($k, 2));
    $points = array(
        round($x1 - (1+$k)*$a), round($y1 + (1-$k)*$a),
        round($x1 - (1-$k)*$a), round($y1 - (1+$k)*$a),
        round($x2 + (1+$k)*$a), round($y2 - (1-$k)*$a),
        round($x2 + (1-$k)*$a), round($y2 + (1+$k)*$a),
    );
    imagefilledpolygon($image, $points, 4, $color);
    return imagepolygon($image, $points, 4, $color);
}

$img = @imagecreatetruecolor($image_width, $image_height);
imagefill($img, 0, 0, imagecolorallocate($img, $bg_color['r'], $bg_color['g'], $bg_color['b']));

$height_ratio=$image_height/max($values);
$width_ratio =$image_width/(count($values)-1);
$prev_x=-1;
$prev_y=-1;
for ($i=0;$i<count($values);$i++) {
if ($prev_x>-1 && $prev_y>-1) {
    imagelinethick($img, $prev_x, $prev_y, $i*$width_ratio, $values[$i]*$height_ratio, imagecolorallocate($img, $line_color['r'], $line_color['g'], $line_color['b']),$line_thickness);
    }
$prev_x=$i*$width_ratio;
$prev_y=$values[$i]*$height_ratio;
}
header ('Content-type: image/png');
imagepng($img);
imagedestroy($img);
?>

Note that the above code needs to be in a separate file and embedded as an image.

Why not use the translate function like the echo take so depending on the language input into the url it will translate to that language. Example:
URL=example.com/index.php?language=it

<?php
/**
 * Translating language with Google API
 * @author gabe@fijiwebdesign.com
 * @version $id$
 * @license - Share-Alike 3.0 (http://creativecommons.org/licenses/by-sa/3.0/)
 * 
 * Google requires attribution for their Language API, please see: http://code.google.com/apis/ajaxlanguage/documentation/#Branding
 * 
 */
class Google_Translate_API {

	/**
	 * Translate a piece of text with the Google Translate API
	 * @return String
	 * @param $text String
	 * @param $from String[optional] Original language of $text. An empty String will let google decide the language of origin
	 * @param $to String[optional] Language to translate $text to
	 */
	function translate($text, $from = '', $to = 'en') {
		$url = 'http://ajax.googleapis.com/ajax/services/language/translate?v=1.0&q='.rawurlencode($text).'&langpair='.rawurlencode($from.'|'.$to);
		$response = file_get_contents(
			$url,
			null,
			stream_context_create(
				array(
					'http'=>array(
					'method'=>"GET",
					'header'=>"Referer: http://".$_SERVER['HTTP_HOST']."/\r\n"
					)
				)
			)
		);
		if (preg_match("/{\"translatedText\":\"([^\"]+)\"/i", $response, $matches)) {
			return self::_unescapeUTF8EscapeSeq($matches[1]);
		}
		return false;
	}
	
	/**
	 * Convert UTF-8 Escape sequences in a string to UTF-8 Bytes
	 * @return UTF-8 String
	 * @param $str String
	 */
	function _unescapeUTF8EscapeSeq($str) {
		return preg_replace_callback("/\\\u([0-9a-f]{4})/i", create_function('$matches', 'return html_entity_decode(\'&#x\'.$matches[1].\';\', ENT_NOQUOTES, \'UTF-8\');'), $str);
	}
}



function display($input) {
$trans_text = Google_Translate_API::translate($input, '', $_GET['language']);
    if ($trans_text !== false) {
        echo $trans_text;
    }
}

//html still must use echo function
echo '<b>';
//now to echo non-html or text to translate
display("this is a test");
echo '</b>';

You will see at the bottom of that file how you can echo some text which will display …

hmmm..the GOOGLE API sirs is really great! and it does what i wanted it to do..however, the problem is that it needs internet connection for it to work, am i right? because that's what ive noticed, now, is there any solution to my problem? plotting data to a graph without having internet connection??

It is possible but hard. I have been planning for a while to write a tutorial on making charts using the php gd library but never got around to doing it. So today I shall make a start on it and hopefully will be done in time for you to read.

You probably don't have curl installed but try the code in post #23. (My previous post). It should work without curl as long as your using php5.

this is the scenario, i will plot the data in a graph coming from a live database, meaning the graph will change simultaneously according to the data..how is it possible?! please help me T_T

With the google api it is possible to make a html image tag then using url variables you dump your data into the end of the image tag. Below is an example:

<img src="http://chart.apis.google.com/chart?cht=lc&chd=t:27,40,100,72,40,84,44,76,48|10,8,8,6,6,6,5,9,3&chs=135x165&chl=Dec|Jan&chtt=Visits+this+month&chxt=x,y&chf=bg,s,FFFFFF&chco=000099,66CC00&chdl=Site|Page&chdlp=b">

That is a chart I have made using the google api and all you need to do is dump the data into the address. Read the link in my earlier post for more information.

What you are saying is that animals can own property, demand a trial by their peers, grow their hair long, marry your sister, sue you for cannibalism, demand a translator when applying for public assistance.

Animal rights = human rights is retarded and make no sense.

I was mainly referring to things like animal abuse and hunting of animals. Animals have emotions too you know. While they may not be the same as us humans, they should be treated with the same respect as a human is treated. And yes I would agree animals should be allowed to demand a trial by their peers when/if we can communicate with them. But as you know we can't talk to animals and vice versa so humans have to speak for the animals. And I suspect species like wales we will never see again due to this lack of respect. So if you think evolution should just take its toll then go ahead and vote no.

In php this could be kinda hard to do at first but there is an api by google you can use and is very handy. I've used this api myself and it seems pretty good with little or no limitations.

One could probably safely assume that God and the Universe are about the same age?

I thought god was there for a long time before with his room mate shugs until they went for an arm wrestle when god farted twice then won and those two gas particles created the universe. That's the theory I believe in.

You did not explain your poll very well. Do you mean giving animals the exact same rights as humans? As opposed to giving animals absolutely no rights whatsoever?

The polarity of your question leaves much to be desired - then the 3rd option is meant to demean anyone who does not take either of the other 2 positions. In other words your poll sucks because it offers nothing of interest.

If you vote yes then animals should have the same rights as humans. If you vote no then things should stay as they are. And the third answer is for those who don't want to scratch their head to get an answer.

When your first computer had no harddrive and only two big floppy disk drives.