Pixelated a phpBB Template by SkaidonDesigns
 
Kaktusan Corp. Support Area Forum Index
www.kaktusancorp.com
www.cheapestadultscripts.com
Play with the Best, be the Best!
Cheapest Web Software
FAQ
Search
Memberlist
Usergroups
Profile
Log in to check your private messages
Log in

The Mightiest Webmaster Solutions Ever
Cheapest Adult Scripts
Cheapest Adult Scripts
Blogs Automater
Blogs Automater
Rocket Pinger
Rocket Pinger
Special Offers
Special Offers

Haven't registered yet? Do it here now!
phpmyadmin

 
Post new topic   Reply to topic    Kaktusan Corp. Support Area Forum Index -> Gallery Scraper
View previous topic :: View next topic  
Author Message
oil



Joined: 15 Jul 2007
Posts: 106

PostPosted: Thu Mar 18, 2010 10:19 pm    Post subject: phpmyadmin Reply with quote
i am total noob with mySQL and so, so since GS dont have a export feature which i am truly missing what must i type in phpMyAdmin in order to get
all galleries from one specific sponsor, which all data Pipe | delimited as
url|desc|longdescription|keyword|cf1
Back to top
View user's profile Send private message

Author Message
kaktus
Owner


Joined: 22 May 2004
Posts: 1576
Location: CheapestAdultScripts.com

PostPosted: Fri Mar 19, 2010 10:49 am    Post subject: Reply with quote
in phpmyadmin there's no such option to export both in that format and specific rows. It can dump a whole database or table..

here's php file you can use for that:
lookup the ID of the sponsor you want to export from. Make a tmp.php file and put it in the main GS folder

Code:

require_once 'info.inc.php';

$zaiavka=@mysql_unbuffered_query("SELECT url,descr,longdescr,keywords,cf1 from gsgals where spid=PUT_HERE_ID");
while($otgovor=mysql_fetch_row($zaiavka))
{
echo implode('|',$otgovor).'<br>';
}
@mysql_free_result($zaiavka);


(just enclose this code in opening and closing php tags, coz phpbb is messing it up here)

then simply visit the tmp.php from your browser and you will get the exported list..
_________________
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

Author Message
oil



Joined: 15 Jul 2007
Posts: 106

PostPosted: Fri Mar 19, 2010 5:36 pm    Post subject: Reply with quote
sweet thx, worked just sweet
Back to top
View user's profile Send private message

Display posts from previous:   
Post new topic   Reply to topic    Kaktusan Corp. Support Area Forum Index -> Gallery Scraper All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group


 
phpBB Template designed by SkaidonDesigns