Jump to content
UBot Underground

cjacobs

Fellow UBotter
 View Profile  See their activity

  • Content Count

    30

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by cjacobs

  3. Problem Checking Table Cell for Specific Text

    in Scripting

    Posted

    47 minutes ago, Varo said:

    Your if condition is wrong.

    Try this : 

    
clear table(&data)
ui open file("Load CSV",#data)
create table from file(#data,&data)
ui drop down("Column to Check","0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26",#columnToCheck)
ui block text("Desired Keywords",#desiredKeywords)
set(#row,1,"Global")
loop(5) {
    if($contains($table cell(&data,#row,#columnToCheck),#desiredKeywords)) {
        then {
            alert("Found")
        }
        else {
            alert("Not Found")
        }
    }
    increment(#row)
}

     

    I've tried that as well and still doesn't work.
    I've attached the csv file I'm working with.
    I set "Column to Check" = 7
    "Desired Keywords" = owner
    I only get "Not Found"

    Any other ideas?
     

    Real-Estate-Brokers-Owners-CLEANED-1.csv

  4. Problem Checking Table Cell for Specific Text

    in Scripting

    Posted

    I am trying to loop through a csv to check if table cells contain any of the specific text (#desiredKeywords) but am not having any luck.

    Can anyone see what I'm doing wrong?

    TIA 

    clear table(&data)
ui open file("Load CSV",#data)
create table from file(#data,&data)
ui drop down("Column to Check","0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26",#columnToCheck)
ui block text("Desired Keywords",#desiredKeywords)
set(#row,1,"Global")
loop(5) {
    if($table cell(&data,#row,$contains(#columnToCheck,#desiredKeywords))) {
        then {
            alert("Found")
        }
        else {
            alert("Not Found")
        }
    }
    increment(#row)
}

     

  6. Problem Scraping Linkedin Review

    in Scripting

    Posted

    I tried using both wait and wait for element but it's still not working. 

    loop($table total rows(&LinkedIn Data)) {
    clear list(%reviews)
    wait(1)
    plugin command("ExBrowser.dll", "ExBrowser Click Special", "x://span[contains(text(),\"Messaging\")]")
    wait(1)
    plugin command("ExBrowser.dll", "ExBrowser Navigate", $table cell(&LinkedIn Data,#row,8))
    plugin command("ExBrowser.dll", "ExBrowser Wait For Element", "x://h2[contains(text(),\"Recommendations\")]", "Appear", 30)
    plugin command("ExBrowser.dll", "ExBrowser Scroll To Element", "x://h2[contains(text(),\"Recommendations\")]")
    wait(1)
    plugin command("ExBrowser.dll", "ExBrowser Click", "//*[@id=\"line-clamp-show-more-button\"]")
    wait(1)

     

  8. Problem Scraping Linkedin Review

    in Scripting

    Posted

    3 minutes ago, PRO said:

    Hello @cjacobs, I removed your ExBrowser license key from within your code 😉

    Without having tried yet, I assume you want to try putting a wait right after:

    plugin command("ExBrowser.dll", "ExBrowser Navigate", "https://www.linkedin.com/")

    I assume that the content you try to scrape loads asynchronous. So try to make sure it‘s really loaded before continuing.

     

    Shoot! I forgot about that key!

    It's navigating fine but it's not scrolling to 'Recommendations' nor scraping when in Run mode. Stepping through works which is why I put the waits in but still not working.

  9. Problem Scraping Linkedin Review

    in Scripting

    Posted

    Hi Guys,

    I am wondering if you could analyze my code to see why it's not scraping a review from LinkedIn.

    If I step the bot through it, everything works.

    When I run it, nothing is getting scraped.

    TIA.

    ------- 

    plugin command("ExBrowser.dll", "ExBrowser Set License", "YOUR-EXBROWSER-LICENSE-KEY")
clear cookies
clear table(&LinkedIn Data)
clear list(%LI)
ui open file("Load LinkedIn CSV File",#data)
ui text box("Email",#loginEmail)
ui password("Password",#loginPassword)
create table from file(#data,&LinkedIn Data)
set(#row,1,"Global")
plugin command("ExBrowser.dll", "ExBrowser CleanUp", "No")
plugin command("ExBrowser.dll", "ExBrowser Launcher", "Chrome", "", "{$plugin function("ExBrowser.dll", "$ExBrowser Chrome Disable Notifications")}{$plugin function("ExBrowser.dll", "$ExBrowser Chrome Disable Info Bars")}{$plugin function("ExBrowser.dll", "$ExBrowser Chrome Disable Info Bars Experimental")}{$plugin function("ExBrowser.dll", "$ExBrowser Use Portable Browser", "Chrome")}{$plugin function("ExBrowser.dll", "$ExBrowser Chrome Disable Save Password")}", "NO")
plugin command("ExBrowser.dll", "ExBrowser Navigate", "https://www.linkedin.com/")
if($plugin function("ExBrowser.dll", "$ExBrowser Element Exist", "x://input[contains(@autocomplete,\"username\")]")) {
    then {
        plugin command("ExBrowser.dll", "ExBrowser Type Text", "x://input[contains(@autocomplete,\"username\")]", #loginEmail)
        wait($rand(1,3))
        plugin command("ExBrowser.dll", "ExBrowser Type Text", "x://input[contains(@name,\"session_password\")]", #loginPassword)
        wait($rand(1,3))
        plugin command("ExBrowser.dll", "ExBrowser Click", "//*[@id=\"main-content\"]/section[1]/div[2]/form/button")
    }
    else {
    }
}
loop($table total rows(&LinkedIn Data)) {
    clear list(%reviews)
    wait(1)
    plugin command("ExBrowser.dll", "ExBrowser Click Special", "x://span[contains(text(),\"Messaging\")]")
    wait(1)
    plugin command("ExBrowser.dll", "ExBrowser Navigate", $table cell(&LinkedIn Data,#row,8))
    plugin command("ExBrowser.dll", "ExBrowser Scroll To Element", "x://h2[contains(text(),\"Recommendations\")]")
    wait(1)
    plugin command("ExBrowser.dll", "ExBrowser Click", "//*[@id=\"line-clamp-show-more-button\"]")
    wait(1)
    plugin command("ExBrowser.dll", "ExBrowser Change Attribute", "x://p[contains(@class,\"pv-recommendation-entity__headline t-14 t-black t-normal pb1\")]", "innertext", "")
    wait(1)
    plugin command("ExBrowser.dll", "ExBrowser Change Attribute", "x://p[contains(@class,\"t-12 t-black--light t-normal\")]", "innertext", "")
    wait(1)
    set(#reviewer,$trim($plugin function("ExBrowser.dll", "$ExBrowser Scrape Element", "x://div[contains(@class,\"pv-recommendation-entity__detail\")]")),"Global")
    wait(1)
    set(#reviews,$plugin function("ExBrowser.dll", "$ExBrowser Scrape Element", "x://span[contains(@class,\"lt-line-clamp__raw-line\")]"),"Global")
    wait(1)
    add item to list(%reviews,$trim($append line to text(#reviewer,#reviews)),"Delete","Global")
    add list to table as column(&LinkedIn Data,#row,4,%reviews)
    increment(#row)
}

     

     

  11. Problem With Backlink Checker

    in Scripting

    Posted

    Hi all,

    I building a backlink checker but keep getting "True" alerts on every url. Can you see what I'm doing wrong?

    Thanks,

    Cavin

    clear list(%URLs)
clear list(%target)
clear table(&data)
ui text box("URL/Text to Find",#target)
ui block text("URLS to Crawl",#websites)
set list position(%target,0)
add list to list(%target,$list from text(#target,$new line),"Delete","Global")
set list position(%URLs,0)
add list to list(%URLs,$list from text(#websites,$new line),"Delete","Global")
add list to table as column(&data,0,0,%URLs)
set(#row,0,"Global")
loop($table total rows(&data)) {
    clear list(%html)
    navigate($table cell(&data,#row,0),"Wait")
    wait for browser event("Page Loaded","")
    set(#scrape,$scrape attribute(<innerhtml="">,"innerhtml"),"Global")
    wait(.05)
    if($contains(%html,#target)) {
        then {
            alert("true")
        }
        else {
            alert("false")
        }
    }
    pause script
}

  14. Table Comparison And Scraping Problem

    in Scripting

    Posted

    Hi,

     

    Wondering if anyone could help me with a problem I am having.

     

    I am wanting to loop through a table and only scrape Cities if their latitude number (Column 5) is +2.00 more than the row (City) my app is currently on.

     

    So in the table below my original position (#row) is 0 (Adak with has a latitude of 51.88), and I want to scrape the next cities that have a latitude number up to 53.88 which in this case would be:

    Adak, Atka, Attu Station, Nikolski, Unalaska

    <img src="https://imgur.com/a/PUrFojF">

    I can't figure out what I need to qualify (comparison, eval etc) and extract the cities needed.

     

        set(#tableloop,0,"Global")
        clear list(%NearbyCities)
        loop($table total rows(&data)) {
            set(#Plus2,$table cell(&data,#row,5),"Global")
            if($comparison($table cell(&data,#tableloop,5),"> Greater than",#Plus2)) {
                then {
                    add item to list(%NearbyCities,$table cell(&data,#tableloop,0),"Don\'t Delete","Global")
                }
                else {
                }
            }
            increment(#tableloop)
        }
     
    Any ideas?
     
     

  17. Ui Html Panel - Open File & Run Button Problem

    in Scripting

    Posted

    Hi,

     

    I'm working on a UI html panel and I cannot get my Open File button or Start buttons to function. I defined the Start but am not having any luck.

     

     

     

    Can anyone see my problem in the following code?

     

     

     

    --Open File Button--

     

    <button variable="#localBizs" fillwith="value" type="file" id="addimager89966" dialogtype="open" name="file" class="button08" style="text-decoration:none;padding:7px 15px;font-family:Georgia;font-size:18px;font-weight:800;color:#000000;border-radius:9px;"><!--lab-->Load Local Business File</button>

     

    --Run Button--

     

    <button id="addimager246634"  onclick="ubot.runScript('Start()')" class="button02" style="text-decoration:none;padding:7px 15px;font-family:Georgia;font-size:18px;font-weight:400;color:#ffffff;border-radius:6px;"><!--lab-->Create Driving Directions</button>

     

    Thanks

  19. Exceeded The Range Of The List

    in Scripting

    Posted

     

    try

    set list position(%proxies,0)

    and check %URLs count = %URLs count or not

     

    i thing error at

    change proxy($next list item(%proxies))

    Hi Pash,

    I do have proxies list position at 0. Sorry, I guess I should've posted the full code.

    The image attached above shows error at $next list item(%URLs) right?

     

    Here's the code above the loop:

    clear list(%AccountData)
    clear list(%proxies)
    ui open file("Proxies",#proxies)
    add list to list(%proxies,$list from file(#proxies),"Delete","Global")
    set list position(%proxies,0)
    clear list(%email)
    ui text box("Email Address",#EmailAddress)
    add item to list(%email,#EmailAddress,"Don\'t Delete","Global")
    clear list(%Password)
    ui text box("Password (For Accounts)",#Password)
    add item to list(%Password,#Password,"Don\'t Delete","Global")
    clear list(%URLs)
    ui open file("Drupal Target URLs",#URLs)
    add list to list(%URLs,$list from file(#URLs),"Delete","Global")
    set list position(%URLs,0)
    loop($list total(%URLs)) {
        change proxy($next list item(%proxies))
        set proxy credentials("proxy123","123password")
        navigate($next list item(%URLs),"Wait")
        wait for browser event("Page Loaded",10)

  20. Exceeded The Range Of The List

    in Scripting

    Posted

    I'm having a problem I can't figure out with exceeding the range of $next list item error, which is in a loop. Navigate>$next list item >%URLs.

    I didn't have this error last night and confused as to what changed.

     

    The code is:

    clear list(%URLs)
    ui open file("Drupal Target URLs",#URLs)
    add list to list(%URLs,$list from file(#URLs),"Delete","Global")
    set list position(%URLs,0)
    loop($list total(%URLs)) {
        change proxy($next list item(%proxies))
        set proxy credentials("proxy123","123password")
        navigate($next list item(%URLs),"Wait")
        wait for browser event("Page Loaded",10)

     

    Any ideas as to what I'm missing?

     

    Thanks for any help!

    post-8859-0-50276300-1507047623_thumb.jpg

  23. Exceeded The Range Of The List

    in General Discussion

    Posted

    Hi,

    Sorry, I'm trying to post a question and keep getting a 'Banned' message.

     

    Hi Guys,

    Man, I'm a stuck Chuck! I've worked all afternoon trying to resolve an error I keep getting.

    The error: You have exceeded the range of the list.

    I've spent all afternoon trying different things suggested by Lilly and others and none of them are working. Can you see what I'm doing wrong???

    I've attached a screenshot of the error and also a video of everything.

    out-of-range.wmv

  25. Need Help With UI

    in Tutorials, Tips and Tricks

    Posted

    Thx merkaba,

     

    I created a test html file in DreamWeaver and put it in Ubot but the layout changes. It seems like I don't make the table large enough in Ubot but I've adjusted settings etc and not having any luck.

     

    Just trying to find someone that can walk me through building the UI, and basically getting the design layed out.

×
×
  • Create New...