#!/usr/local/bin/php -q
<?php
include_once '../Phlickr/Api.php';
 
/**
 * I wrote this script because it's a real pain in the ass to generate the
 * authorization tokens. Hopefully this will make it a little easier.
 *
 * @version $Id$
 * @author  Andrew Morton <drewish@katherinehouse.com>
 * @license http://opensource.org/licenses/lgpl-license.php
 *          GNU Lesser General Public License, Version 2.1
 */
print "This script will help you retrieve a Flickr authorization token.\n\n";
 
// Prevent PHP from enforcing a time limit on this script
set_time_limit(0);
 
// Get the user's API key and secret.
print 'API Key: ';
$api_key = trim(fgets(STDIN));
print 'API Secret: ';
$api_secret = trim(fgets(STDIN));
 
// Create an API object, then request a frob.
$api = new Phlickr_Api($api_key, $api_secret);
$frob = $api->requestFrob();
print "Got a frob: $frob\n";
 
// Find out the desired permissions.
print 'Permissions (read, write, or delete): ';
$perms = trim(fgets(STDIN));
 
// Build the authentication URL.
$url = $api->buildAuthUrl($perms, $frob);
print "\nOpen the following URL in your browser and and authorize:\n$url\n\n";
print "Press return when you're finished...\n";
fgets(STDIN);
 
// After they've granted permission, convert the frob to a token.
$token = $api->setAuthTokenFromFrob($frob);
 
// Print out the token.
print "Auth token: $token\n";
 
// Optionally, create a config file.
print 'Save these settings? (y/N): ';
$saveit = strtolower(trim(fgets(STDIN)));
if ($saveit{0} == 'y') {
    print 'Filename: ';
    $filename = trim(fgets(STDIN));
    print "Saving settings to '$filename'\n";
    $api->saveAs($filename);
    print "Use this with Phlickr_Api::createFrom() to create an object.\n";
}
 
exit(0);
?>

 
<photos page="2" pages="89" perpage="10" total="881">
	<photo id="2636" owner="47058503995@N01" 
		secret="a123456" server="2" title="test_04"
		ispublic="1" isfriend="0" isfamily="0" />
	<photo id="2635" owner="47058503995@N01"
		secret="b123456" server="2" title="test_03"
		ispublic="0" isfriend="1" isfamily="1" />
</photos>

 
<?php
require_once '../includes/services/flickr/Phlickr/Api.php';
 
	$api = new Phlickr_Api('a192837oiabcccffccca', '6363636adaeadaead3', '734344534343dabb4-767564537272ceb4');
	$request = array(
		        'tags' => 'nazca',
			'per_page' => '10'
		    );
	$responseXML = $api->executeMethod('flickr.photos.search',$request);
	$dom = new DomDocument();
	$up = new site_Photos();
 	if($dom->loadXML($responseXML)){
			//echo $dom->saveXML(); //dump dom into a string
			$photos = $dom->getElementsByTagName( "photo" );
			foreach($photos as $photo){
					$photo_id = $photo->getAttribute("id");
					$photo_owner = $photo->getAttribute("owner");
					$photo_title = $photo->getAttribute("title");
 
					/*
					   Esta es la notación para obtener la página que corresponde a la foto
					   http://www.flickr.com/[owner]/[idPhoto]
					*/
					$photo_page = "http://www.flickr.com/photos/".$photo_owner."/".$photo_id;
 
					/*
					  	Este es la notación requerida para obtener la imagen en tamaño pequeño (s) o mediano (m), para visualización
						http://farm[numberFarm].static.flickr.com/[numberServer]/[idPhoto]_[secret]_[size(s|m)].jpg
					*/
					$farm =   $photo->getAttribute("farm");
					$secret = $photo->getAttribute("secret");
					$server = $photo->getAttribute("server");
					$image_src = "http://farm" . $farm . ".static.flickr.com/" . $server . "/" . $photo_id . "_" . $secret ."_s.jpg";
 
					echo "ID: ".$photo_id." Owner:".$photo_owner." Title:".$photo_title. " PHOTO PAGE:" . $photo_page . "IMG SRC:" . $image_src ."\n";
 
			}
	}
?>

<script language="JavaScript" src="http://j.maxmind.com/app/geoip.js"></script>
<br>Código del País:
<script language="JavaScript">document.write(geoip_country_code());</script>
<br>Nombre del País:
<script language="JavaScript">document.write(geoip_country_name());</script>
<br>Ciudad:
<script language="JavaScript">document.write(geoip_city());</script>
<br>Region:
<script language="JavaScript">document.write(geoip_region());</script>
<br>Nombre de la Region:
<script language="JavaScript">document.write(geoip_region_name());</script>
<br>Latitud:
<script language="JavaScript">document.write(geoip_latitude());</script>
<br>Longitud:
<script language="JavaScript">document.write(geoip_longitude());</script>
<br>Código Postal:
<script language="JavaScript">document.write(geoip_postal_code());</script

function  get_Json_From_Table($table_name){
 
 global $mydb;
 $query = "SELECT * FROM $table_name WHERE id_expe='$number_Expe'";
 
	if($mydb->query($query)){
		$data = $mydb->get_results($query);
		$query2 = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '$table_name'";
		$data2 = $mydb->get_results($query2);
		$name_colum = array();
		$i=0;
		foreach($data2 as $col){
			$name_column[$i] = $col->COLUMN_NAME;
			$i++;
		}
	$number_column = count($name_column);
	$string ="";
	$string .= "{label: \"datos_" . $table_name . "\", items: [";
 
	foreach($data as $col){
		$i=0;
		while($i < $number_column){ 				if($i == 0){  $string .= "{" . $name_column[$i] .": \"". $col->$name_column[$i] . "\",";  }
				$string .=  $name_column[$i] .": \"". $col->$name_column[$i] ."\",";
				$j = $i+1;
				if($j == $number_column){
					$string .= $name_column[$i] . ": \"".$col->$name_column[$i]."\"";
					$string .= "},";
				}
				$i++;
		}
	}
	$string .= "]}";
	return $string;
	}else{ return false; }
}

#include 
 
int main(void){
char *arg[2];
arg[0] = "/bin/sh";
arg[1] = NULL;
execve("/bin/sh", arg, NULL);
}

shellcode:     file format elf32-i386
 
Disassembly of section .init:
 
08048250 <_init>:
 8048250:       55                      push   %ebp
 8048251:       89 e5                   mov    %esp,%ebp
 8048253:       83 ec 08                sub    $0x8,%esp
 8048256:       e8 79 00 00 00          call   80482d4 
 804825b:       e8 00 01 00 00          call   8048360 
 8048260:       e8 eb 01 00 00          call   8048450 <__do_global_ctors_aux>
 8048265:       c9                      leave
 8048266:       c3                      ret
Disassembly of section .plt:
 
08048268 <__gmon_start__@plt-0x10>:
 8048268:       ff 35 90 95 04 08       pushl  0x8049590
 804826e:       ff 25 94 95 04 08       jmp    *0x8049594
 8048274:       00 00                   add    %al,(%eax)
        ...
 
08048278 <__gmon_start__@plt>:
 8048278:       ff 25 98 95 04 08       jmp    *0x8049598
04827e:       68 00 00 00 00          push   $0x0
 8048283:       e9 e0 ff ff ff          jmp    8048268 <_init+0x18>
 
08048288 <__libc_start_main@plt>:
 8048288:       ff 25 9c 95 04 08       jmp    *0x804959c
 804828e:       68 08 00 00 00          push   $0x8
 8048293:       e9 d0 ff ff ff          jmp    8048268 <_init+0x18>
 
08048298 :
 8048298:       ff 25 a0 95 04 08       jmp    *0x80495a0
 804829e:       68 10 00 00 00          push   $0x10
 80482a3:       e9 c0 ff ff ff          jmp    8048268 <_init+0x18>
Disassembly of section .text:
 
080482b0 <_start>:
 80482b0:       31 ed                   xor    %ebp,%ebp
 80482b2:       5e                      pop    %esi
 80482b3:       89 e1                   mov    %esp,%ecx
 80482b5:       83 e4 f0                and    $0xfffffff0,%esp
 80482b8:       50                      push   %eax
 80482b9:       54                      push   %esp
 80482ba:       52                      push   %edx
80482bb:       68 d0 83 04 08          push   $0x80483d0
 80482c0:       68 e0 83 04 08          push   $0x80483e0
 80482c5:       51                      push   %ecx
 80482c6:       56                      push   %esi
 80482c7:       68 84 83 04 08          push   $0x8048384
 80482cc:       e8 b7 ff ff ff          call   8048288 <__libc_start_main@plt>
 80482d1:       f4                      hlt
 80482d2:       90                      nop
 80482d3:       90                      nop
 
080482d4 :
 80482d4:       55                      push   %ebp
 80482d5:       89 e5                   mov    %esp,%ebp
 80482d7:       53                      push   %ebx
 80482d8:       83 ec 04                sub    $0x4,%esp
 80482db:       e8 00 00 00 00          call   80482e0 
 80482e0:       5b                      pop    %ebx
 80482e1:       81 c3 ac 12 00 00       add    $0x12ac,%ebx
 80482e7:       8b 93 fc ff ff ff       mov    0xfffffffc(%ebx),%edx
 80482ed:       85 d2                   test   %edx,%edx
 80482ef:       74 05                   je     80482f6 
 80482f1:       e8 82 ff ff ff          call   8048278 <__gmon_start__@plt>
 80482f6:       58                      pop    %eax
 80482f7:       5b                      pop    %ebx
80482f8:       c9                      leave
 80482f9:       c3                      ret
 80482fa:       90                      nop
 80482fb:       90                      nop
 80482fc:       90                      nop
 80482fd:       90                      nop
 80482fe:       90                      nop
 80482ff:       90                      nop
 
08048300 <__do_global_dtors_aux>:
 8048300:       55                      push   %ebp
 8048301:       89 e5                   mov    %esp,%ebp
 8048303:       53                      push   %ebx
 8048304:       83 ec 04                sub    $0x4,%esp
 8048307:       80 3d ac 95 04 08 00    cmpb   $0x0,0x80495ac
 804830e:       75 3f                   jne    804834f <__do_global_dtors_aux+0x4f>
 8048310:       b8 b8 94 04 08          mov    $0x80494b8,%eax
 8048315:       2d b4 94 04 08          sub    $0x80494b4,%eax
 804831a:       c1 f8 02                sar    $0x2,%eax
 804831d:       8d 58 ff                lea    0xffffffff(%eax),%ebx
 8048320:       a1 a8 95 04 08          mov    0x80495a8,%eax
 8048325:       39 c3                   cmp    %eax,%ebx
 8048327:       76 1f                   jbe    8048348 <__do_global_dtors_aux+0x48>
 8048329:       8d b4 26 00 00 00 00    lea    0x0(%esi),%esi
8048330:       83 c0 01                add    $0x1,%eax
 8048333:       a3 a8 95 04 08          mov    %eax,0x80495a8
 8048338:       ff 14 85 b4 94 04 08    call   *0x80494b4(,%eax,4)
 804833f:       a1 a8 95 04 08          mov    0x80495a8,%eax
 8048344:       39 c3                   cmp    %eax,%ebx
 8048346:       77 e8                   ja     8048330 <__do_global_dtors_aux+0x30>
 8048348:       c6 05 ac 95 04 08 01    movb   $0x1,0x80495ac
 804834f:       83 c4 04                add    $0x4,%esp
 8048352:       5b                      pop    %ebx
 8048353:       5d                      pop    %ebp
 8048354:       c3                      ret
 8048355:       8d 74 26 00             lea    0x0(%esi),%esi
 8048359:       8d bc 27 00 00 00 00    lea    0x0(%edi),%edi
 
08048360 :
 8048360:       55                      push   %ebp
 8048361:       89 e5                   mov    %esp,%ebp
 8048363:       83 ec 08                sub    $0x8,%esp
 8048366:       a1 bc 94 04 08          mov    0x80494bc,%eax
 804836b:       85 c0                   test   %eax,%eax
 804836d:       74 12                   je     8048381 
 804836f:       b8 00 00 00 00          mov    $0x0,%eax
 8048374:       85 c0                   test   %eax,%eax
 8048376:       74 09                   je     8048381 
8048378:       c7 04 24 bc 94 04 08    movl   $0x80494bc,(%esp)
 804837f:       ff d0                   call   *%eax
 8048381:       c9                      leave
 8048382:       c3                      ret
 8048383:       90                      nop
 
08048384 :
 8048384:       8d 4c 24 04             lea    0x4(%esp),%ecx
 8048388:       83 e4 f0                and    $0xfffffff0,%esp
 804838b:       ff 71 fc                pushl  0xfffffffc(%ecx)
 804838e:       55                      push   %ebp
 804838f:       89 e5                   mov    %esp,%ebp
 8048391:       51                      push   %ecx
 8048392:       83 ec 24                sub    $0x24,%esp
 8048395:       c7 45 f4 a0 84 04 08    movl   $0x80484a0,0xfffffff4(%ebp)
 804839c:       c7 45 f8 00 00 00 00    movl   $0x0,0xfffffff8(%ebp)
 80483a3:       c7 44 24 08 00 00 00    movl   $0x0,0x8(%esp)
 80483aa:       00
 80483ab:       8d 45 f4                lea    0xfffffff4(%ebp),%eax
 80483ae:       89 44 24 04             mov    %eax,0x4(%esp)
 80483b2:       c7 04 24 a0 84 04 08    movl   $0x80484a0,(%esp)
 80483b9:       e8 da fe ff ff          call   8048298 
 80483be:       83 c4 24                add    $0x24,%esp
 80483c1:       59                      pop    %ecx
80483c2:       5d                      pop    %ebp
 80483c3:       8d 61 fc                lea    0xfffffffc(%ecx),%esp
 80483c6:       c3                      ret
 80483c7:       90                      nop
 80483c8:       90                      nop
 80483c9:       90                      nop
 80483ca:       90                      nop
 80483cb:       90                      nop
 80483cc:       90                      nop
 80483cd:       90                      nop
 80483ce:       90                      nop
 80483cf:       90                      nop
....

function get_Rows_Table($chain){
$col = array();
for($j=0;strlen($chain)>0;$j++){
	/*obteniendo cada columna*/
	$pos = strrpos($chain," ",0);
	$col_chain = substr($chain,$pos);
	$col[$j] = $col_chain;
	$chain = mb_substr($chain,0,$pos);
}
 
$string="<tr>";
for($i=count($col);$i>0;$i--){
	$string .= "<td style='border:1px solid black;'>".$col[$i]."</td>";
}
$string .="</tr>";
return $string;
}

$cadena_texto ="Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse in leo non ante mollis hendrerit";
$output = "<table><tbody>";
$ouput .=  get_Rows_Table($output);
$output .= "</tbody></table>";
echo $output;