I need 10,000 + links formatted. I will pay you a reasonable fee. - GoFuckYourself.com

NTSS · 09-29-2006, 02:05 PM

I have 10k + links from my site that I need formatted into a text file so I can import them into my new srcipt.

Currently the data is in a text file and looks like this. (this is a sample of what most of the links look like):

INSERT INTO L (`id`,`name`,`email`,`url`,`title`,`description`,` category`,`reciprocal`,`confirmed`,`approved`,`add ed`,`code`,`nextcheck`,`nocheck`,`featured`,`disab led`) VALUES ('12','toejob','sex-free-teen.com','http://sex-free-teen.com','Teen Porn Directory','Visit this site for free teen pics and movies','19','http://sex-free-teen.com/','1','1','1111607065','4241f44475318','1154966672 ','0','0','1')

I need the url, title and discription extracted and formatted exactly like this:

URL(comma)Title(4 commas)Description

http://sex-free-teen.com,Teen Porn Directory,,,,Visit this site for free teen pics and movies

(with no trailing slashes)

If anyone can perform this task I will pay you a reasonable fee through pay pal only. Just give me a price and I'll give 50% now and the rest on completion.

Hit me up at marketing7(at)cox.net

or post here

Thanks

madawgz · 09-29-2006, 02:05 PM

so how much are you paying?

NTSS · 09-29-2006, 02:07 PM

Quote:

Originally Posted by madawgz

so how much are you paying?

Whatever it cost....what's your price?

Brujah · 09-29-2006, 02:12 PM

Looks pretty simple NTSS, if it's in SQL format like you show above. Just a matter of throwing it back in SQL and exporting it into the format you need.

xanx · 09-29-2006, 02:16 PM

if there is no way to automate it and it has to be done by hand I will do it for 600.00, paid 100% when finished, and would need the weekend to finish it.

4Pics · 09-29-2006, 02:20 PM

Do you need it done one time?

If so icq me i'll do it for free real quick.

NTSS · 09-29-2006, 02:23 PM

Quote:

Originally Posted by 4Pics

Do you need it done one time?

If so icq me i'll do it for free real quick.

Yes...just once

but I don't have ICQ....email me

u-Bob · 09-29-2006, 02:33 PM

I can write you a lill script to do that...

u-Bob · 09-29-2006, 02:34 PM

will only take a couple of lines of perl...

Dvae · 09-29-2006, 02:49 PM

Quote:

Originally Posted by xanx

if there is no way to automate it and it has to be done by hand I will do it for 600.00, paid 100% when finished, and would need the weekend to finish it.

Remind me to never hire you for anything.

As others have said Perl, PHP or good text editor that can handle regular expressions could do it in a few minutes

.

NTSS · 09-29-2006, 03:24 PM

Quote:

Originally Posted by Dvae

Remind me to never hire you for anything.

As others have said Perl, PHP or good text editor that can handle regular expressions could do it in a few minutes

.

Yeah I agree....

so who's gonna hook me up?

Brujah · 09-29-2006, 03:33 PM

Zip it up.. put it online.. let someone download it and transform it for you.

Dvae · 09-30-2006, 06:23 AM

Quote:

Originally Posted by NTSS

Yeah I agree....

so who's gonna hook me up?

Have you found a solution yet?

lucas131 · 09-30-2006, 07:39 AM

I can do it, contact me

TMM_John · 09-30-2006, 07:51 AM

Do you have the table created? If you do then just run that sql you have against it and then run this on the server.

Code:

<?

  mysql_connect("host","username","password");
  mysql_select_db("yourdbname");
  
  $query = "select * from L;";
 
  $result = mysql_query($query);

  while( $row = mysql_fetch_assoc($result)){

    print $row["url"].",".$row["title"].",,,,".$row["description"]."\n";


  }
?>

Then view source as HTML won't interpret the line break.

If you need the table structure created or need info on how to get the SQL inserts you have put into it let me know.

Beejeebers · 09-30-2006, 07:53 AM

PHP Code:


			
<?php

$db = mysql_connect("localhost", "username", "password");

mysql_select_db("database_name",$db);

$result = mysql_query("SELECT url, title, description FROM your_table_name",$db);

while($a=mysql_fetch_array($result)){

    echo $a['url'].",".$a['title'].",,,,".$a['description']."<BR>";

}

?>

That should do it...

borked · 09-30-2006, 08:44 AM

And using Perl....

Code:

#!/usr/local/bin/perl

use DBI;
my $dbhost = 'localhost';
my $dbport = '3306';
my $dbuser = '';
my $dbpass = '';
my $db_name = '';
my $table_name = '';
my $outFile = 'output.csv';

$db_handle = DBI->connect("dbi:mysql:database=$db_name;host=$dbhost:$dbport;user=$dbuser;password=$dbpass")
    or die "Couldn't connect to database: $DBI::errstr\n";
$sql = "SELECT * FROM $table_name";
$statement = $db_handle->prepare($sql)
    or die "Couldn't prepare query '$sql': $DBI::errstr\n";
$statement->execute()
    or die "Couldn't execute query '$sql': $DBI::errstr\n";
open OUTPUT_FILE , ">$outFile";
while ($row_ref = $statement->fetchrow_hashref())
{
    print OUTPUT_FILE $row_ref->url .",".$row_ref->title ."$row_ref->description.",";
}
clode OUTPUT_FILE;
$db_handle->disconnect();

$13,000 please
PayPal Only

pornguy · 09-30-2006, 08:48 AM

I have someone that will do it 75cents per URL and by hand so theres no mistakes,

borked · 09-30-2006, 08:49 AM

bollox, didn't see the multiple comma formatting:

after: while ($row_ref = $statement->fetchrow_hashref())
change to:

Code:

{
       print OUTPUT_FILE $row_ref->url .",".$row_ref->title .",,,,".$row_ref->description;
}

1200mics · 09-30-2006, 08:53 AM

good technical tips

woj · 09-30-2006, 10:18 AM

did you figure it out? if not, shoot me an email woj [at] wojfun dot com

fuzebox · 09-30-2006, 10:26 AM

You fuckin php noobs

No need to import into mysql, 1 regex line on the existing dump file will take care of it.

Solid Bob · 09-30-2006, 10:33 AM

Quote:

Originally Posted by pornguy

I have someone that will do it 75cents per URL and by hand so theres no mistakes,

IT'S A 2 MINUTE JOB!!!!!!!!!!!!!!!!!!

Solid Bob · 09-30-2006, 10:35 AM

Quote:

Originally Posted by fuzebox

You fuckin php noobs

No need to import into mysql, 1 regex line on the existing dump file will take care of it.

Well the php pros are in here killing the market. The guy said he'll pay whatever and the first person offers it for free. lol Sometimes you just need to learn when to shut up.

psili · 09-30-2006, 10:37 AM

Isn't it just something like:

SELECT url,title,',',',',',',description FROM [table] INTO outfile 'dump.txt'

-- just do a quick search for "mysql select into outfile" and you'll be golden.

Fizzgig · 09-30-2006, 10:39 AM

Quote:

Originally Posted by Beejeebers

PHP Code:


			
<?php

$db = mysql_connect("localhost", "username", "password");

mysql_select_db("database_name",$db);

$result = mysql_query("SELECT url, title, description FROM your_table_name",$db);

while($a=mysql_fetch_array($result)){

    echo $a['url'].",".$a['title'].",,,,".$a['description']."<BR>";

}

?>

That should do it...

This wasnt' the end of it?

CaptainWolfy · 09-30-2006, 10:41 AM

Quote:

Originally Posted by Solid Bob

Well the php pros are in here killing the market. The guy said he'll pay whatever and the first person offers it for free. lol Sometimes you just need to learn when to shut up.

borked · 09-30-2006, 10:48 AM

Quote:

Originally Posted by fuzebox

You fuckin php noobs

No need to import into mysql, 1 regex line on the existing dump file will take care of it.

what, like s/^\w.*,{1}\w.*,{1}\w.*,{1}(\S.+),{1}(\w.+),{1}(\w.+ ),{1}.*$/
(assuming its a CSV)

hell yeah, but you've still gotta iterate through the file

Brujah · 09-30-2006, 11:01 AM

pretty funny the quick 1 minute, 1-line regex script hasn't been posted then by the so-called experts. prove it.

baddog · 09-30-2006, 11:03 AM

Quote:

Originally Posted by u-Bob

will only take a couple of lines of perl...

are you good at PERL?

Burridge · 09-30-2006, 11:04 AM

ill do it if you put me through computer programmer school at my community college, and loan me about 150k to live off for the next for years while i learn. then another 30k for my after college trip to europe so i can get cultured and explore the world. I'll get right on it as soon as i get back.

Otherwise, here's a bump for you guy.

psili · 09-30-2006, 11:10 AM

Quote:

Originally Posted by Brujah

pretty funny the quick 1 minute, 1-line regex script hasn't been posted then by the so-called experts. prove it.

Wish I could remember the article I read, but it was about how to find the right programmer for a company. It pretty much boiled down to finding someone who was compatible with the environment (people) and who was open to say "I don't know" but was willing to research and learn, rather than just saying they have an answer when really they don't.

Sadly, I've met very, very few of those people. And what this has to do with this thread, I have no idea. *shrug*

09-29-2006, 02:05 PM	#1
NTSS Confirmed User Join Date: Mar 2005 Location: Da Hood Posts: 5,688	I need 10,000 + links formatted. I will pay you a reasonable fee. I have 10k + links from my site that I need formatted into a text file so I can import them into my new srcipt. Currently the data is in a text file and looks like this. (this is a sample of what most of the links look like): INSERT INTO L (`id`,`name`,`email`,`url`,`title`,`description`,` category`,`reciprocal`,`confirmed`,`approved`,`add ed`,`code`,`nextcheck`,`nocheck`,`featured`,`disab led`) VALUES ('12','toejob','sex-free-teen.com','http://sex-free-teen.com','Teen Porn Directory','Visit this site for free teen pics and movies','19','http://sex-free-teen.com/','1','1','1111607065','4241f44475318','1154966672 ','0','0','1') I need the url, title and discription extracted and formatted exactly like this: URL(comma)Title(4 commas)Description http://sex-free-teen.com,Teen Porn Directory,,,,Visit this site for free teen pics and movies (with no trailing slashes) If anyone can perform this task I will pay you a reasonable fee through pay pal only. Just give me a price and I'll give 50% now and the rest on completion. Hit me up at marketing7(at)cox.net or post here Thanks __________________ ICQ: 150-803-430 Email: marketing7(at)cox(dot)net

09-29-2006, 02:05 PM	#2
madawgz 8.8.8.8 Industry Role: Join Date: Mar 2006 Location: Noordermarkt Posts: 30,509	so how much are you paying? __________________ TAEMDLRMSKRJIXMRLSMRJ.

09-29-2006, 02:12 PM	#4
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	Looks pretty simple NTSS, if it's in SQL format like you show above. Just a matter of throwing it back in SQL and exporting it into the format you need. __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

09-29-2006, 03:33 PM	#12
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	Zip it up.. put it online.. let someone download it and transform it for you. __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

09-30-2006, 07:51 AM	#15
TMM_John Confirmed User Industry Role: Join Date: May 2004 Posts: 6,660	Do you have the table created? If you do then just run that sql you have against it and then run this on the server. Code: <? mysql_connect("host","username","password"); mysql_select_db("yourdbname"); $query = "select * from L;"; $result = mysql_query($query); while( $row = mysql_fetch_assoc($result)){ print $row["url"].",".$row["title"].",,,,".$row["description"]."\n"; } ?> Then view source as HTML won't interpret the line break. If you need the table structure created or need info on how to get the SQL inserts you have put into it let me know. __________________ Skype: JohnA1078 Too Much Media - Makers of the Industry's Leading Payite Management Platform, NATS!

09-29-2006, 02:16 PM	#5
xanx Confirmed User Join Date: Apr 2002 Location: Orlando, FL Posts: 3,711	if there is no way to automate it and it has to be done by hand I will do it for 600.00, paid 100% when finished, and would need the weekend to finish it.

09-29-2006, 02:20 PM	#6
4Pics Confirmed User Industry Role: Join Date: Dec 2001 Posts: 7,952	Do you need it done one time? If so icq me i'll do it for free real quick.

09-29-2006, 02:33 PM	#8
u-Bob there's no $$$ in porn Industry Role: Join Date: Jul 2005 Location: icq: 195./568.-230 (btw: not getting offline msgs) Posts: 33,063	I can write you a lill script to do that...

09-29-2006, 02:34 PM	#9
u-Bob there's no $$$ in porn Industry Role: Join Date: Jul 2005 Location: icq: 195./568.-230 (btw: not getting offline msgs) Posts: 33,063	will only take a couple of lines of perl...

09-30-2006, 07:39 AM	#14
lucas131 ¯\_(ツ)_/¯ Industry Role: Join Date: Aug 2004 Posts: 11,475	I can do it, contact me

09-30-2006, 07:53 AM	#16
Beejeebers Confirmed User Join Date: Oct 2004 Posts: 290	PHP Code: `<?php $db = mysql_connect("localhost", "username", "password"); mysql_select_db("database_name",$db); $result = mysql_query("SELECT url, title, description FROM your_table_name",$db); while($a=mysql_fetch_array($result)){ echo $a['url'].",".$a['title'].",,,,".$a['description']."<BR>"; } ?>` That should do it... __________________

09-30-2006, 08:48 AM	#18
pornguy Too lazy to set a custom title Industry Role: Join Date: Mar 2003 Location: Homeless Posts: 62,911	I have someone that will do it 75cents per URL and by hand so theres no mistakes, __________________ PornGuy skype me pornguy_epic AmateurDough The Hottes Shemales online! TChicks.com \| Angeles Cid \| Mariana Cordoba \| MAILERS WELCOME!

09-30-2006, 08:49 AM	#19
borked Totally Borked Industry Role: Join Date: Feb 2005 Posts: 6,284	bollox, didn't see the multiple comma formatting: after: while ($row_ref = $statement->fetchrow_hashref()) change to: Code: { print OUTPUT_FILE $row_ref->url .",".$row_ref->title .",,,,".$row_ref->description; } __________________ For coding work - hit me up on andy // borkedcoder // com (consider figuring out the email as test #1) All models are wrong, but some are useful. George E.P. Box. p202

09-30-2006, 08:53 AM	#20
1200mics Confirmed User Join Date: Sep 2005 Location: ICQ : 297-476-738 Posts: 5,131	good technical tips __________________

09-30-2006, 10:18 AM	#21
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	did you figure it out? if not, shoot me an email woj [at] wojfun dot com __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

09-30-2006, 10:26 AM	#22
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 22,117	You fuckin php noobs No need to import into mysql, 1 regex line on the existing dump file will take care of it.

09-30-2006, 10:37 AM	#25
psili Confirmed User Join Date: Apr 2003 Location: Loveland, CO Posts: 5,526	Isn't it just something like: SELECT url,title,',',',',',',description FROM [table] INTO outfile 'dump.txt' -- just do a quick search for "mysql select into outfile" and you'll be golden. __________________ Your post count means nothing.

09-30-2006, 11:01 AM	#29
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	pretty funny the quick 1 minute, 1-line regex script hasn't been posted then by the so-called experts. prove it. __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

09-30-2006, 11:04 AM	#31
Burridge Confirmed User Join Date: Sep 2003 Location: New York City Posts: 1,186	ill do it if you put me through computer programmer school at my community college, and loan me about 150k to live off for the next for years while i learn. then another 30k for my after college trip to europe so i can get cultured and explore the world. I'll get right on it as soon as i get back. Otherwise, here's a bump for you guy. __________________ NYC