Jump to content

Johnnyboy69

Members
  • Posts

    8
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

Johnnyboy69's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hi all. Was hoping for some advise on the following. A client has provided me with a website that has recently been hacked. Apparently, specifically the mail server aspect of the site has been influenced, causing the site to send out spam mail. The following Trojan was found in 4 files of the site: Trojan.PHP-43. Files that were influenced were mostly wp-conf.php and 2 mail php scripts. Does anyone have knowledge or experience with this Trojan or any tips that could help me resolve this? Also any pointers on aspects of the site that will need to be improved in order to prevent this I.E what weaknesses of a site is normally exploited for this kind of Trojan to breach it? Thank you in advance
  2. Thanks smoseley. The Sale table is linked to the SaleDetail table. Multiple SaleDetail ranges can be on one Sale. For instance 1 sale can have 5 ranges from the SaleDetail table each being a different product type. Information I require is also being pulled from a Warehouse and stockdetail table. These 2 tables are linked with the SaleDetail. I.e in the SaleDetail information is stored from what warehouse the stock is coming from (warehou table) and what kind of stock this is: Product name (label column from stockdetail table) and product type(type column in stockdetailtable) So in other words, 1 sale can have 5 Saledetail ranges which are linked with the warehouse and stockdetail tables regarding data it contains. Hope this makes sense? Brain is a bit fried at the moment.
  3. Thanks smoseley, learning a lot in regards to the having function etc. When running the code for selecting 2 types only, I get the following error: Error Code : 1111 Invalid use of group function (0 ms taken) I'm playing around and checking google for a possible solution to this error. Any ideas?
  4. Dear smoseley, Thank you. Still have to test the results to see whether they are accurate but it seems to be working fine. Really appreciate your help. Just one last thing, how would I go about adjusting the having clause in order to select 2 stock types. I.e This time for instance I want sales that contain only BOTH "sim" and "handset" and nothing else. Thanks for all your help, still quite new to SQL.
  5. Hi all, I am currently stuck with the following issue: I have the following tables: Sale ( Contains Sales made) Saledetail (contains details of sale) These sales have stock on them, tables: Stock (contains stock) Stockdetails (contains details of stock) I am trying to select all Sales made with a specific stock type on them. This is easy enough, however, I have to select sales with ONLY the specific stock on them and no other stock. I also have to display specific data from the Sale, Stock, and stockdetail tables. Here is what I have so far: SELECT `Sale`.`saleNo`,`Sale`.`dispatchDate`,`SaleDetail`.`serialStart`,`SaleDetail`.`serialEnd`, `StockDetail`.`label`,`StockDetail`.`type`, Warehouse.name FROM `Sale` INNER JOIN `SaleDetail` ON `Sale`.`id` = `SaleDetail`.`saleID` INNER JOIN `StockDetail` ON `StockDetail`.`id` = `SaleDetail`.`StockDetailID` INNER JOIN Warehouse ON Warehouse.id = SaleDetail.warehouseID WHERE `Sale`.`invoiceDate` BETWEEN '2012-04-19' AND '2012-04-19' and `StockDetail`.`type` = 'SIM ' In this case I am trying to retrieve Sales that contain only the Stock type of "SIM". It displays all the needed information I need, however, does not filter to ONLY retrieving sales with SIM on them and no other stock types. Any advice on how to resolve this? Or perhaps any general pointers on how to go about doing what I am trying to achieve? Thanks in advance.
  6. So I have a web page which has javascript rollover buttons and an auto gallery which scrolls through pics automatically. I made most of this using dreamweaver as my javascript is quite sloppy. The problem I am having is, both sets of code works perfectly fine on their own. The rollover buttons work and the gallery, but when added together on the same page only the rollover buttons function and the gallery doesn't start auto scrolling at all. When i take away the rollover buttons, it works again. Any ideas of why this is happening? <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <SCRIPT LANGUAGE="JavaScript"> <!-- //set image paths src = ["1.gif", "2.gif"] //set duration for each image duration = 3; ads=[]; ct=0; function switchAd() { var n=(ct+1)%src.length; if (ads[n] && (ads[n].complete || ads[n].complete==null)) { document["Ad_Image"].src = ads[ct=n].src; } ads[n=(ct+1)%src.length] = new Image; ads[n].src = src[n]; setTimeout("switchAd()",duration*1000); } function doLink(){ location.href = url[ct]; } onload = function(){ if (document.images) switchAd(); } // end of auto gallery //start of rollover images function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } //--> </script> </head> <body onload="MM_preloadImages('buttons/home.gif','buttons/gallery2.gif','buttons/products2.gif','buttons/contacts2.gif')"> <div id="apDiv1"><img src="background4.gif" width="1024" height="768" /> <div id="apDiv4"> <IMG NAME="Ad_Image" SRC="image1.gif" BORDER=0> </div> <div id="apDiv5"> <center> <b><p> Welcome to Jimmy's trailer Hire </p></b> </center> <p class="dd"><span class="ddd">Jimmy's Trailer Hire is a company specializing in trailer rentals and the selling of second hand vehicles and canopies. </span><span class="ddd">We have been in business for 17 years now and have established a respectfull and quality reputation in the area. We promise quality and professional service in every aspect of what we do. Please have a look through our website and enjoy your stay. </span></p> </div> <div id="apDiv6"> <p>Jimmy's Trailer Hire aims to fullfill all your transportation needs. dkkdwkdkowdowdkowkdowkdowkd</p> <p>dwdwdwdwdw<br /> <br /> Business hours <br /> <br /> Monday - Friday: <br /> Sat - Sun: <br /> <br/> <b> 24/7 Road assistance. </b></p> </div> <!-- Buttons --> <div id="apDiv14"><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image3','','buttons/home.gif',1)"><img src="buttons/hom1.gif" name="Image3" width="143" height="38" border="0" usemap="#home1MapMap3" id="Image3" /> <map name="home1MapMap3" id="home1MapMap3"> <area shape="rect" coords="4,3,159,48" href="index.html" /> </map> </a></div> <div id="apDiv15"><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image4','','buttons/gallery2.gif',1)"><img src="buttons/gallery.gif" name="Image4" width="144" height="38" border="0" usemap="#home1MapMap3Map" id="Image4" /> <map name="home1MapMap3Map" id="home1MapMap3Map"> <area shape="rect" coords="4,3,159,48" href="pages/gallery.html" /> </map> </a></div> <div id="apDiv16"><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image5','','buttons/products2.gif',1)"><img src="buttons/products.gif" name="Image5" width="143" height="38" border="0" usemap="#home1MapMap3Map2" id="Image5" /> <map name="home1MapMap3Map2" id="home1MapMap3Map2"> <area shape="rect" coords="4,3,159,48" href="pages/products.html" /> </map> </a></div> <div id="apDiv17"><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image6','','buttons/contacts2.gif',1)"><img src="buttons/contacts.gif" name="Image6" width="143" height="38" border="0" usemap="#home1MapMap3Map3" id="Image6" /> <map name="home1MapMap3Map3" id="home1MapMap3Map3"> <area shape="rect" coords="4,2,159,47" href="pages/contact.html" /> </map> </a></div> <div id="apDiv7"> <form action="dummy" method="post"> <select style="font-size:11px;color:#000000;font-family:verdana;background-color:#f0f0df;" name="choice" size="1" onChange="jump(this.form)"> <option value="">Choose a Link</option> <option value="http://www.cnet.com">Cnet</option> <option value="http://www.download.com">Downloads</option> <option value="">- - - - - - - - - -</option> <option value="http://www.apple.com">Apple</option> <option value="http://www.microsoft.com">Microsoft</option> </select></form> <p> </div> </div> <div id="apDiv18"></div> </body> </html> Sorry guys, as embarrasing as it is, I couldn't get it right posting the code so it displays in colour lol. If anyone can tell me how I'll repost it quick.
  7. Ah I see, thanks So my meta tags are correct? Except for being able to use better keywords etc. How long more or less would you say does it take google on average to crawl a site, without signing up etc?
  8. Hi all I created a website for a friend, she wants the website to show up when searched in search engines such as google. I did use some online help, but I want to make sure. What exactly does one need to add to ensure that your site will show in search engines? As far as I know you just need ti add meta keywords in the head tag? Heres what I did: <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <META NAME="description" CONTENT="Ardour Graphics for all your Graphic and web design needs."> <META name="keywords" content="Ardour Graphics, Graphic design, photography, web design, somerset west, stellenbosch"> I have heard from a friend that search engines such as google, take a while to process and catagorize your website accordingly, which, according to that friend, is why my site isn't showing even if I google the exact keywords. I know this is a pretty lame question, but I just wanted to be entirely sure instead of waiting for a month so that google will apparently organize it, just to find out I did something wrong. I also understand that getting high rankings is a lot more than just meta tags, but I just want the site to show if you search for it so specifically. Can anyone tell me if all that including the google thing is correct and if not please explain to me the meta tag system? Thanks in advance
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.