Jump to content
UBot Underground

mdc101

Fellow UBotter
  • Content Count

    119
  • Joined

  • Last visited

  • Days Won

    2

mdc101 last won the day on March 7 2012

mdc101 had the most liked content!

Community Reputation

15 Good

About mdc101

  • Rank
    Advanced Member

Profile Information

  • Gender
    Not Telling

System Specs

  • OS
    Windows 8
  • Total Memory
    4Gb
  • Framework
    v4.0
  • License
    Developer Edition

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. OK figured this one out When you create the insert statement you must wrap the number with the FORMAT function example FORMAT(column_name,2)
  2. HI guys I'm doing a simple insert into a database table from a ubot table using table cells. In the ubot table I see 13.2 as an example. Using set the insert statement is generated as seen two lines down. When I run the insert into mySql table the decimal is dropped and the value is rounded down to 13. #inset_record: INSERT INTO sometable ( sometable.profileid, sometable.theme_keywords, sometable.ID, sometable.Flag, sometable.kwSource, sometable.LARI, sometable.PPC_CostclickMonthly, sometable.PPC_clickMonthly, sometable.TrafficForecast, sometable.CompetingPages ) VALUES ( '5060', 'dysfunction'
  3. @YuraB That worked perfectly, Thanks for all the help. Your a Legend. I was not aware one could place conditions within a scrape. (tagname="td" AND class="cluster-name") I am assuming this has to be hard coded?
  4. Hi Thanks for the response The code is working 95%! What it does is it grabs the first row of the ignore list <td class="cluster-name" style="text-align: left"> <a href="http://subdomain.domin.com/blueprints/2088/nodes/40937">buy beer making kits online</a></td> Any idea why this is happening?
  5. Hi Guys There is a number of rows in a table. How do I scrape the url into one list & the anchor text into another list The rows I want to scrape contain a <span title="Number of active keywords">(*)</span>. Rows to be ignored don't have the span <span title="Number of active keywords">(*)</span> (20) is a number that changes Scrape URL ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ <td class="cluster-name" style="text-align: left">
  6. Hi Guys Does anyone know how to insert a screenshot into a mysql database blob field? So basically the idea is ubot goes to page does the screen grab and then inserts it into the database. Is this possible?
  7. Hi Guys thanks for the response The application is saas based and you need to login to access the page. So cant give reference url If you wrapped the <ol> her html head and body you will basically get the page output Oricoun I will try your suggestion. Ubotbuddy, would love to see what you do Regards Matt
  8. Hi Guys Been knocking me head against a wall for a few days and cannot figure this out. I have the following page I want to scrape attached. There are 10 <li></li> tags holding ranking information I need. Each <li></li> tag is separated by a <hr> tag. I am wanting to scrape the following below form each <li></li> tag and want to add it to table highlighted in orange so I can insert into a database. How does one scrape this data so all rows stay precise and don't get mixed up? Thanks Matt <li> <b>www.clipinhair.co.za</
  9. Found a work around I only used multiply. I removed the $eval() and it worked
  10. Thanks for the reply. This is so annoying so why was it working before the update to 5.7. I working with competing pages and I use the the competing pages number x 10 as a ceiling for me to do analysis. I have never had this issue in the last 4 years and now that I need the functionality at a critical point in a project the update stuffs up the math functions. Is there a way to calculate the number I need using JavaScript?
  11. Hi Guys Anyone having an issue with the eval multiply reults? I get odd results like "8.73e+006" The eval math function is not working. A basic math sum like 873000 * 10 = 8.73e+006 It should be 8730000 Im sure it not the code. Started happening since 5.7 update Is it just me or is there an actual bug? if($comparison($scrape attribute($element offset(<style="text-align: right">, 0), "innertext"), "=", $nothing)) { then { set(#Psys_ptkw_cmp, 0, "Global") set(#Psys_ptkw_cmp, 2000000, "Global") set(#Psys_ptkw_cmp, $replace($trim(#Psys_ptkw_cmp), ",", $nothing), "Global") set(#Psys
  12. I figured out why things where running so slow. The logging was on and as soon as i turned logging off the bot flew as expected. Thanks blumi for the pointers earlier
  13. The indexes and changes suggested shaved of 10 seconds, thanks for the tip
×
×
  • Create New...