GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   I need 10,000 + links formatted. I will pay you a reasonable fee. (https://gfy.com/showthread.php?t=660819)

NTSS 09-29-2006 02:05 PM
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

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
:thumbsup :winkwink: :thumbsup

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 :thumbsup

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 :1orglaugh

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 :1orglaugh

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. :upsidedow

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. :upsidedow
:1orglaugh :1orglaugh :thumbsup

borked 09-30-2006 10:48 AM
Quote:
Originally Posted by fuzebox
You fuckin php noobs :1orglaugh

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*


All times are GMT -7. The time now is 05:28 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123