Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BigBadDave

    Script optimization

    I just need to speed up the processing as it only has 20,000 records for the test and takes over 20 seconds to process, but for the live implementation there will be over 8 million records. Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  2. BigBadDave

    Script optimization

    ...@urls = (0); my @times = (0); my @entry = (0); my @exit = (0); my @comps = (0); my @compsd = (0); my $dbh = DBI->connect ("DBI:mysql:host=******;db=webstats;", "***", "", {PrintError => 0, RaiseError => 0}); $dbh->do ("CREATE TEMPORARY TABLE `tmp` SELECT `date`, `host name`, `url`...
  3. BigBadDave

    SQL logic

    That's what I need to do, I assume I can do it by selecting the time field and seeing the last request by host name within a 20 minute period for example but I'm not sure. Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  4. BigBadDave

    SQL logic

    It's not that simple unfortunately, this is what I have but I don't think its accurate: CREATE TEMPORARY TABLE `tmp` SELECT `url`, COUNT(DISTINCT `host name`) AS `num` FROM `access_log` WHERE `date` = '0000-00-00' GROUP BY `host name` ORDER BY `num` DESC; SELECT `url`, SUM(`num`) AS `num` FROM...
  5. BigBadDave

    SQL logic

    I am trying to get a handle on selecting the top 10 entry and exit pages of my apache access_log database. I log the url, host name etc. This is what I have for top 10 popular URL's if its any help: SELECT `url`, COUNT(`url`) AS `num` FROM `access_log` WHERE `date` = '0000-00-00' GROUP BY...
  6. BigBadDave

    seen this menu system around???

    Do you mean like this: http://www.byngdesigns.co.uk/new ?? Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  7. BigBadDave

    seen this menu system around???

    Do you mean like this: http://www.byngdesigns.co.uk/tek-tips/OpenClickMenu.swf http://www.byngdesigns.co.uk/tek-tips/OpenClickMenu.fla ?? Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  8. BigBadDave

    seen this menu system around???

    Do you mean like this: http://www.byngdesigns.co.uk/tek-tips/menu_chevy.swf http://www.byngdesigns.co.uk/tek-tips/menu_chevy.fla ?? Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  9. BigBadDave

    reverse motion tween

    Something like this: faq250-1292 Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  10. BigBadDave

    Drop down menu 2

    ' menu1 ' is the ' instance name ' not the real name of the menu clip Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  11. BigBadDave

    Setting apache to automatically recognise .php as base file

    2 options: 1.) set it in your conf file (C:/Program Files/Apache Group/Apache/conf/httpd.conf) 2.) set it in an ".htaccess" file within the dir syntax: DirectoryIndex index.php index.shtml index.htm index.html Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  12. BigBadDave

    virtual host URL

    Hi, How can I load a URL instaed of a document root? I assume you can do it with mod-rewrite but i'm not sure of the syntax insted of: subdomain.my-domain.com -> /htdocs/subbdomain/ I need: subdomain.my-domain.com -> /cgi-bin/prog.sh/prog.w?aff=xcsma Regards David Byng...
  13. BigBadDave

    Mouse scrolling effect

    Flash 5 version: www.elisemarieacademy.co.uk/menu2.swf www.elisemarieacademy.co.uk/menu2.fla Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  14. BigBadDave

    Mouse scrolling effect

    Like the menu on my site: www.byngdesigns.co.uk Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  15. BigBadDave

    stealthly execute php script

    loadVaribles ("script.php", ""); That will execute a script Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  16. BigBadDave

    Internet Download

    Just create a perl script that will run through a domain, follow all the links, and save all the pages/images/objects. Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  17. BigBadDave

    Speedy XML parsing

    I built this function to parse and render my XML: stop (); var mySort = new Array(); var pXML = new XML(); pXML.onLoad = readXML; pXML.load(&quot;file.xml&quot;); function chkDup (hts, qry) { for (var i = 0; i<mySort.length; i++) { if (mySort[i][1] == qry) { mySort[i] = [mySort[i][0]+hts...
  18. BigBadDave

    Dynamic mail headers

    Try this: $header = &quot;From: &quot; . $row[&quot;namef&quot;] . &quot; &quot;. $row[&quot;namel&quot;] . &quot;\r\n&quot; .&quot;Reply-To: &quot; . $row[&quot;email&quot;] . &quot;\r\n&quot; .&quot;\&quot;MIME-Version: 1.0\&quot;\r\n&quot; .&quot;Content-Type...
  19. BigBadDave

    POPULATING SELECT ELEMENT FROM DATABASE

    Split it off into 3 selects: country, county, town eg: england, surrey, guildford scotland, west lothian, broxburn etc You can have 3 arrays that dynamically alter the select contents to reflect the country and county choice Regards David Byng www.byngdesigns.co.uk davidbyng@hotmail.com
  20. BigBadDave

    The rise and rise of KAZAA peer 2 peer file sharing.

    [b]CajunCenturion[b] --> especially when such statements are simply not true. I suggest you actually read that statement before making an ass of yourself. File sharing in its entirety is not illegal! Only sharing files you don't own the copyright to and/or have the right to share. Kazaa...

Part and Inventory Search

Back
Top