Hardbyte

Hey, Although bigdump is supposed to help import large files, Im still getting the memory exausted error message. Im trying to import "Insert into ..." statements of 300Mb. Iv tried a few other scripts, but I guess they all work in the same way (trying to explode each line into an array then run each line as an sql command) but I think trying to load 300mb into an array is the problem. Anyone else got any scripts/suggestions?

Thank you for the replies. I agree with Crayon as Iv already got meta tags (no follow etc..) and robots.txt within the site which they are not following these "rules". I dont mind them visiting the site, but they are triggering my "Report a comment" link and Im receiving [size=8pt]<backwards>[/size]tihs[size=8pt]</backwards>[/size] loads of emails. My script seems to be working, its blocking the bots which I have in an array and those bots visiting which are not in the array - it emails me to inform me of the agent. (obviously allowing IE/Firefox and such common browsers.) Im just having to currently find out which are the bad bots  ??? Thanks again.

Hi and thanks for your reply. On another note: If I were to allow Mozilla as an agent, then the bots could still get thru. For example: [code]MOZILLA/5.0 (COMPATIBLE; YAHOO! SLURP; HTTP://HELP.YAHOO.COM/HELP/US/YSEARCH/SLURP) has visited .... MOZILLA/5.0 (COMPATIBLE; GOOGLEBOT/2.1; +HTTP://WWW.GOOGLE.COM/BOT.HTML) has visited ....[/code] so just search for Yahoo & Google to block for example? Thanks

Hi, and sorry for possibly posting in the wrong section. Just wondering, do these spider bot things still trigger links within the page code even if I got a script to hide all links (or the whole page) if its equal to a bot? What Im trying to ask is, do they still spider through the code like a text file or do they work as if they were visiting like using a normal browser? Any help would be appreciated. Thanks.

Hi-ya, I also just did the same but you replied before I got here  ;D I changed: [code]if(strpos($agent,$bot)!==FALSE){$continue=1;};[/code] Just waiting to be crawled lol Many Thanks

Hi-ya, thanks for the reply. Im afraid its still not working. Below is your new code implemented:- [code] $agent = strtoupper($_SERVER['HTTP_USER_AGENT']); $bots = array('GOOGLE','GOOGLEBOT','BOT','CRAWLER'); $continue=0; foreach($bots as $bot){ if(strstr($bot,$agent)!==FALSE){$continue=1;}; }; if($continue==1) { //send mail (of bot array) $subject = "Reported Bot"; $headers  = "From: email@addy.com>"; $message = $agent." has visited ".$_SERVER['REQUEST_URI']."\n\nArray Bot "; mail("myemailaddy@domain.com", $subject, $message, $headers); }else{ //send mail (all) $subject = "Reported Bot"; $headers  = "From: <email@addy.com>"; $message = $agent." has visited ".$_SERVER['REQUEST_URI']."\n\nArray Bot: not in array "; mail("myemailaddy@domain.com", $subject, $message, $headers);  }; [/code] Im trying to determine which bots from my array are going to the site, it then emails me if it was a bot in my array or something else (like IE or Firefox) picking up on keywords such as BOT in GOOGLE[b]BOT[/b], [b]BOT[/b]S, BOTa[b]CRAWLER[/b] etc.. Many thanks.

Hi-ya. To start with, Iv got the below code:- [code] $agent = strtoupper($_SERVER['HTTP_USER_AGENT']); $bots = array('GOOGLE','GOOGLEBOT','BOT'); if (in_array($agent, $bots)){ // do something here. }else{ // do something else here. } [/code] I assume the above code is stating: if $agent == $bots (equal to BOT). But how do I make it so its *like* BOT, incase its really [b]BOT[/b]S or STUPID[b]BOT[/b]S ? Iv been playing around with strstr but it dont seem to work in this array style (unless Im doing it wrong). Any help would be appreciated. Thanks

Hi - just wondering if anyone know any script / info on selecting all text and copy to clipbaord function in Firefox as well as IE? Scripts seem to work in IE but not FireFox - any info would be appreciatd. Hardbyte.

Bump? Anyone shed any light on this? Was trying to wash my hands of it over the weekend? Thanks for any advice. Hardbyte

Hi, I couldnt find a script/program anywhere to convert my .xls of 100ish users into a MySQL format to upload to my SQL database. I wrote a php script that will take take your .xls (Im not that good with MS-Office - its just a list of usernames, names and passwords) and put it into the following format:- INSERT INTO '[tablename]' VALUES ('your', 'xls', 'document', 'details'); I think this is the correct format if you are able to use the SQL feature of phpMyAdmin. This will loop through all your entries of your .xls file. Just make sure your .xls document is in the correct order of your database. Would this be any good for anyone else? Or please let me know of what other people use so I can improve on my part. Im just a beginner so any comments would be appreciated. Regards Hardbyte.

Hi - Thanks for the reply. Iv read the articles you mentioned but Im still not getting anywhere. Iv got includes and headers. In the header its already setting a session of the login. Now, for example: when button1 is pressed its stores button1 as the value in a new session. If button2 is pressed, button2 is stored in that session instead. But these only work when the page is "Ctrl + F5" refreshed after the button is pressed. So like it needs refreshing before it works? Does that make any sense to anyone? I either need to refresh the whole pages including headers when the button is pressed, or header: location needs to work - but it wont as it says is already being sent??! Thanks in advance. Hardbyte

Hi-ya. Iv got this admin system and depending on what button(which directs you to a page) you press, it saves a session of that page name. This session only appears to "update" and be stored when I refresh the page for a second time. Iv tried using the "header("Location: ..." however I get errors as the header is already being used by another script somewhere. Any ideas on how to refresh the whole page when Iv pressed the button that stores the session page name? Hope someone can understand the above lol, Its been difficult trying to explain what the issue is. Thanks in advance. Hardbyte

Hi, I havent tried anything as of yet - was trying to find a script but unable to. I want to strip the email and insert the email address, subject and message body into a database. Any ideas or pointers where to look would be appreciated, Thanks Hardbyte

Hi - just trying to look into stripping an email and entering it into a database? Just seem to be unable to find any info on this, results seem to be all about sending email from the database entries. Thanks

Hi and thanks for everyones help. I found that the functions as mentioned above by redbullmarky are the best for what I needed. Was perfect again mate - thanks alot! Hardbyte