Jump to content
UBot Underground

Saxon

Fellow UBotter
  • Content Count

    194
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by Saxon

  1. how do you guys handle large email accounts, I have an account with over 27000 emails (most of it spam) and I want to clean it up. But it takes forever for the table to fill (15 minutes of waiting), If i have to download the table to loop thru every time i delete an email i'll never get the job done

     

    I would try to cull a lot of it with an email client and some filters to be honest.

     

    Also on the subject of email I had a huge account, and I simply set a forwarded to a spamarrest account because I couldn't move so many emails, the difference is dramatic.

  2. Credentials have been tested with filezilla, and it's working.

     

    I'm using the main cpanel account and password, and I've tried a few things:

     

    Sever: IP, ftp.domain.com, domain.com

    Remote path:(nothing), /public_html

     

    Again, winscp and filezilla both work with all configs I've tried in Ubot v4 and v5, latest versions. Anyone know how to get it working?  I've searched, and these threads didn't fix my situation although the last one says there may be an issue with Windows 8.1, which I am on! :(

     

    http://www.ubotstudio.com/forum/index.php?/topic/14638-ftp-login-command-problems/

    http://www.ubotstudio.com/forum/index.php?/topic/15235-ftp-file-upload-issue/

    http://www.ubotstudio.com/forum/index.php?/topic/15473-ftp-folder-upload-not-working/

    http://www.ubotstudio.com/forum/index.php?/topic/16643-cannot-connect-to-ftp/

  3. Hi.  My mysql bots work great in V4, unless the query takes a long time.  Unlike navigation and other nodes, the query DB doesn't allow us to specify timeout.

     

    Essentially, as far as I can see it seems impossible to work with large tables that require more than 30 seconds to return results.

     

    The queries work fine in MYSQL workbench, typically taking about 32 seconds.

     

     

    The query:

    select site_id,network_id,wp_link,updated_at,id,author_member_id from posts where content like '%<a href="http://google.co.uk%' limit 2000;
    

    Yes it's an ugly query but that's what I have to work with for now.

    post-1851-0-88233800-1406022019_thumb.jpg

  4. Really stuck with the datagrid command. Can we have some documentation on this?  Your video shows what a finished table looks like but nothing more.

     

    I've found some stuff related to the library here:

    http://w2ui.com/web/docs/grid

     

    But even the first example is not loading for me in a browser:

    <!DOCTYPE html>
    <html>
    <head>
        <link rel="stylesheet" type="text/css" href="//w2ui.com/src/w2ui-1.3.min.css" />
        <script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.2/jquery.min.js"></script>
        <script type="text/javascript" src="//w2ui.com/src/w2ui-1.3.min.js"></script>
    </head>
    <body>
        <div id="myGrid" style="height: 450px"></div>
    </body>
    <script>
    $('#myGrid').w2grid({ 
    	name: 'myGrid', 
    	columns: [				
    		{ field: 'fname', caption: 'First Name', size: '30%' },
    		{ field: 'lname', caption: 'Last Name', size: '30%' },
    		{ field: 'email', caption: 'Email', size: '40%' },
    		{ field: 'sdate', caption: 'Start Date', size: '120px' },
    	],
    	records: [
    		{ recid: 1, fname: 'John', lname: 'Doe', email: 'jdoe@gmail.com', sdate: '4/3/2012' },
    		{ recid: 2, fname: 'Stuart', lname: 'Motzart', email: 'jdoe@gmail.com', sdate: '4/3/2012' },
    		{ recid: 3, fname: 'Jin', lname: 'Franson', email: 'jdoe@gmail.com', sdate: '4/3/2012' },
    		{ recid: 4, fname: 'Susan', lname: 'Ottie', email: 'jdoe@gmail.com', sdate: '4/3/2012' },
    		{ recid: 5, fname: 'Kelly', lname: 'Silver', email: 'jdoe@gmail.com', sdate: '4/3/2012' },
    		{ recid: 6, fname: 'Francis', lname: 'Gatos', email: 'jdoe@gmail.com', sdate: '4/3/2012' },
    		{ recid: 7, fname: 'Mark', lname: 'Welldo', email: 'jdoe@gmail.com', sdate: '4/3/2012' },
    		{ recid: 8, fname: 'Thomas', lname: 'Bahh', email: 'jdoe@gmail.com', sdate: '4/3/2012' },
    		{ recid: 9, fname: 'Sergei', lname: 'Rachmaninov', email: 'jdoe@gmail.com', sdate: '4/3/2012' }
    	]
    });
    </script>
    </html>
    
    Edit: This example is more helpful: http://demos.telerik.com/kendo-ui/web/grid/index.html

    Still getting from ubot to a grid is difficult for me to get my head round. Can we have an example .ubot please? Just so I can see how to format those lists.

  5. I've received a huge amount of value for my purchase (back in 2010) and I don't mind paying for monthly updates. My ROI with ubot dev is literally above 10,000%, above 20,000% in fact!

     

    V5 isn't ready yet, I posted a bug that seems to have been ignored. :( I should have known better than to waste time on a new release, I made the same mistake when V4 came out.  Fortunately V4 seems very stable now.

     

    Also, it's far too soon to remove V4 from the download page! V5 is not ready!

     

    Can we have it back please?  If not does anyone know where I can download V4 again?

  6. I should also add I tried creating the first variable  like this too:

    set(#ref_one_holder, $add($add($add($add($add($add($table cell(&comms_refined_one, #remove_dupes_counter, 0), ","), $table cell(&comms_refined_one, #remove_dupes_counter, 1)), ","), $table cell(&comms_refined_one, #remove_dupes_counter, 2)), ","), $table cell(&comms_refined_one, #remove_dupes_counter, 3)), "Global")
    

    So I tried with the table cells outside "" and {}.

  7. Hi everyone, long time no see! :)

     

    My problem is that I'm getting "cannot add two strings together" even though I'm trying my best to make sure it's parsed as a math expression.  Pretty basic you would think!

    #total_revenue: 0Cannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two stringsCannot multiply two strings19

    I have a table, and I'm trying to remove duplicate rows.  What I'm doing is saving each row to a list and then allowing the list to remove duplicates:

    set(#remove_dupes_counter, 0, "Global")
    loop($table total rows(&comms_refined_one)) {
        set(#ref_one_holder, "{$table cell(&comms_refined_one, #remove_dupes_counter, 0)},{$table cell(&comms_refined_one, #remove_dupes_counter, 1)},{$table cell(&comms_refined_one, #remove_dupes_counter, 2)},{$table cell(&comms_refined_one, #remove_dupes_counter, 3)}", "Global")
        add item to list(%removedupes, #ref_one_holder, "Delete", "Global")
        increment(#remove_dupes_counter)
    }
    

    Then I save the list to a csv file, and I make a new new table from it (yes this is very hacky but I've had to try a lot of things to make this work!):

    save to file("{$special folder("Application")}\\listcache.csv", %removedupes)
    create table from file("{$special folder("Application")}\\listcache.csv", &comms_refined_two)
    

    The CSV file looks correct when I open it outside ubot. To me it looks like I can create a new table from this file and columns 2 and 3 should be read as real numbers:

    admin@email.com,email@yahoo.com,0009,9.5
    support@email.com,Accounting@email.com,0001,7.6
    support@email.com,email@gmail.com,0009,7.6
    

    The error comes when I try to do this:

    set(#total_revenue, $add(#total_revenue, $multiply(#makemath, 2)), "Global")
    

    This is an extra step but I created a variable called #makemath to hold the last number in the new table I created above, but that didn't work either.:

    set(#makemath, $table cell(&comms_refined_two, #refined_comms_count_2, 3), "Global")
    

    Anyone got any ideas?

     

    I need to either make the numbers = numbers and not strings, or think of a different way of removing duplicate rows from the table altogether.  Cheers!

  8. Maybe some of you guys were not around for the 4.0 release.

     

    That was a tough 3-4 months, it was so buggy I would describe it as an infestation. I lost at least 100 hours of work to it.

     

    I'd rather wait until January than have a repeat of that.  Of course every release will have some issues, but I'm really hoping they don't push 5 out too early.

  9. Oh well its only been 11 months for this request. Not long enough!

     

    This is what I'm trying to do, select file and then trim down to folder. How do you do that?

     

    What I've attempted is trying to select everything between the last "\" and the ".txt", all the files are txt files. I'm not having much luck with regex selectors it seems.

     

    The other thing I can do it make the user select the same file twice (lol), one with include path, one without, then subtract one from the other... but that's really hacky.

  10. Hi, I've tried about 20 selector.

     

    All I want to do is select everything before the first line break (\n). Should be simple right? But I'm having real problems with it.

     

    I've got the file loading done etc, all I need is a simple regex selector to find the first line please!

     

    This is the title inside the text file
    This is the next line I do not want to select, notice no period in the title!

  11. version 4 tells which line and which character number generates the problem

     

     

    Really? Where?

     

    I know it says which node when running, but I can't see anything that works in codeview, for example you can't go to node view if there are codeview errors, but I didn't know where the error was. I had to copy paste all define statements out into a new bot one at a time to isolate the bad code.

  12. Bump. Although there are a dozen proxy threads on the forum...

     

    After all this time does it means it's not possible to be able to use proxies in a stable way?

     

    Ubot gives us the ability to scale but in many cases scale is limited when you can't use proxies.

×
×
  • Create New...