flexfanatic

Correct, I wrote the last line from the code view and forgot and messed up on the syntax.

plugin command("DatabaseCommands.dll", "connect to database", "mysql:server=\'localhost\';uid=\'myusername\'; pwd=\'password\'; database=\'cboffers\'; port=\'3306\'; pooling=false") { plugin command("DatabaseCommands.dll", "query with results", "select hoplinkurl from hoplinks where url IS NULL limit 1", &hoplinksurl) clear cookies navigate("{$table cell(&hoplinksurl,0,0)}.","Wait") clear list(%results) add item to list(%results,$url,"Don\'t Delete","Global") plugin command("DatabaseCommands.dll", "query", "UPDATE hoplinks SET url=\'{%results}\' WHERE hoplinkurl

Correct, I downloaded the marketplace and then imported it into a MySQL database. What I'm trying to accomplish is getting the actual website URL from the hoplink url. I'm able to get the results I want but now I'm running into a issue with updating the column (last line where I'm performing an update and I don't get a error but no update either). plugin command("DatabaseCommands.dll", "connect to database", "mysql:server=\'localhost\';uid=\'myusername\'; pwd=\'password\'; database=\'cboffers\'; port=\'3306\'; pooling=false") { plugin command("DatabaseCommands.dll", "query with result

I love when its that simple. Works like a charm. Thanks Code Docta

I'm currently working on a clickbank marketplace scraper and I have all of the information like hoplinks, description, etc stored in a database. I'm now trying to obtain the actually website url by navigating to the page and capturing the url but I'm having some issues with figuring out how to obtain this. Looking at the page source there are a few tags that tell me what the full url is but is there a way to capture this from the address bar and save it back to the database table?

Okay so this has definitely put me in the right direction . I decided to take out the description for now until I get the first 4 columns inserted correctly. With your query I'm able to insert without a error now but it's appending text to the front of the data. http://s7.postimg.org/vbshtw8yz/query1.png http://s7.postimg.org/x4vei7u5n/query2.png

That was the first way I had it but it says the row count does not match. The issue is not the amount of columns I'm trying to insert it seems Ubot table is outputting as one cell. http://s12.postimg.org/50e51wsa5/mysqlerror1.png http://s12.postimg.org/vzhzx2er1/mysqlerror2.png

I wrote a bot that scrapes product details from a website and adds the information into a Ubot table (five columns). I'm trying to save this data to a table in MySQL (again five columns). I can connect and run a insert query but it's concatenating all five columns into one for my insert and I'm not sure what I'm doing wrong. ui text box("URL To Scrape:", #url) ui text box("Pages To Scrape:", #pages) ui stat monitor("Product Titles:", $list total(%titles)) ui stat monitor("Product Thumbnails:", $list total(%thumbnails)) ui stat monitor("Product Images:", $list total(%images)) ui stat moni

Okay, so I made a change to how I scrape the title which has resolved by issue with the trailing space and carriage return. Now I'm adding the description of the product to the results but I'm running into the same issue where it outputs to a separate line due to the <li> tags. ui text box("URL To Scrape:", #url) ui text box("Pages To Scrape:", #pages) ui stat monitor("Product Titles:", $list total(%titles)) ui stat monitor("Product Thumbnails:", $list total(%thumbnails)) ui stat monitor("Product Images:", $list total(%images)) ui stat monitor("Product Description:", $list total(%des

So I decided to fire up my Ubot Studio and try to learn how to create a scraper as I need one from Cafepress. I'm able to scrape the results I wanted but I'm having some issues with the saved csv file. For some reason it's putting the Title and URL's on separate lines. I'm also wondering how to handle scraping multiple pages (over 100 just for this product type). ui text box("URL To Scrape:", #url) ui stat monitor("Product Titles:", $list total(%titles)) ui stat monitor("Product Thumbnails:", $list total(%thumbnails)) ui stat monitor("Product Images:", $list total(%images)) ui stat moni

I got a little further with this bot but the popup box is opening in it's own Window (even if I don't set allow popups("In New Window"). The page does not close so no points are awarded. ui text box("AddMeFast Email", #emailaddress) ui text box("AddMeFast Password", #password) ui text box("StumbleUpon Username", #suname) ui text box("StumbleUpon Password", #supassword) set user agent("Firefox 6") clear cookies navigate("http://addmefast.com/en/login", "Wait") wait for element(<href="/terms.html">, "", "Appear") type text(<email field>, #emailaddress, "Standard") type text(<pas

Thanks that worked (although it broke my stat monitors but I can likely fix that without a lot of work). <select variable="#categories" fillwith="value" /><option value="">Select Category</option><option value="http://fancy.com/shop/art/">Art </option><option value="http://fancy.com/shop/food/">Food</option><option value="url3">Cat3</option></select>

So after viewing a pretty good video tutorial on how to scrape data from a website I created my own bot for fun and it currently runs pretty good. Now I'm trying to change some of the UI elements (in this case the drop) to look better than what i currently have. The drop down is basically a selection of urls to choose from but I would like it to show up as the actually category (Art, Food, etc) instead of the full url path. http://s11.postimg.org/oasn074r7/uibox.png ui drop down("Category", "http://fancy.com/shop/art,http://fancy.com/shop/food", #categories) ui stat monitor("Titles Scra

Thanks. I got the download link via email.

Before I purchased I should have determined what "delivered shortly" means as I have yet to receive any download links.

You can. It's called outsourcing

Payment Sent (Unique Transaction ID # 75S20603TL207430N)

So I'm trying to create a account checker using account information from one of my MySQL databases. I use Toad for Oracle, Toad for MySQL, and SSMS on a daily basis and I'm able to query with results without any issues. Does anyone have any tutorials on using data from the database in a website form (e.g. email address, password)? plugin command("DatabaseCommands.dll", "connect to database", "server=10.10.10.10;uid=xxxx; pwd=xxxxx; database=xxxx; port=3306; pooling=false") { plugin command("DatabaseCommands.dll", "query with results", "select * from pinterest_accounts;", &pinteres

If Ubot Studio can run commands from a windows command line (CMD.exe) then you could use a batch command that would use T-SQL (connect to MSSQL, run queries, stored procedures, etc).

My name is Tim and I'm a System Engineer and have been in the field for over 13 years. For the last 5 years I have been also been marketing online (mostly affiliate marketing).

Not sure what the solution was for the OP but for those wondering for a way to get data from MySQL to MSSQL you could query this information by setting up a "Linked Server" in SQL Server Management Studio.

This post is a little old but if you're wanting a good tool for viewing MySQL databases I use Toad for MySQL (Freeware) on a daily basis. One of my job roles is DBA so I don't work without it.

Kreatus thanks for creating the two bots to fit my needs. They'r working great. Mods, you can lock this thread down if needed as the job is done.

I need a image scraper for Flickr and Photo Bucket (they can be two separate bots). 1. Allow me to insert page url to be scraped (e.g., http://photobucket.com/images/beaches/ as well as pages 2,3,4,5,6,7,etc) 2. Scrape the Title/Description and path of full image (not thumbnail) 3. Save to text file (e.g., This is the title|http://www.pathofimage.com) Let me know your prices (I can pay via Paypal).