A few questions about organisate workflow and others

[KiMoO]

@icemails sry for the late response :))
This is a demo script 0_1550847636588_Test.xml
This is the db schema that u have to create before launching the script

[levant_de]

Okay, thanks for your help.
You are better then the Skype support.

I try to reorganisate my DB that it looks like yours and take the other data to table Site Data.

Dit the Table need to be named like yours or can it have another name which i can change in the script?

It is 2 o`clock in the morning here, so i will try it when i wake up.

Edit:

i looked in the Script you made, but it not works like it should.
I think my english is too bad to write exactly what i need, but i try it again.

I have a Database with many column.

SiteName
Active
UserName
Email
Password
WalletID
Reload
Scheduled Pause

Every row is for another site, in case that i will store 1 login per site.

So i need to let them find the row of site x and select from them the column password to make that in a variable.

I make an example:

http://prntscr.com/mowssr

If a script run which use site1, it should grab the email and password from the row in which site 1 stand.
Same on other sites.

So i need a command like:

Store data in variable Site1_Password from column password, where sitename=Site1

My bot i try to create is for around 500 sites and i will store all logins in 1 database to create variables for every single script which is in the mainbot.

Kind regards from Berlin

[KiMoO]

@icemails

• If i faced sth like this i would do the following:
• Get records by criteria (in ur case u should use site1 as a criteria),
  Parse the string i got from the DB (as there is no way to get the value of one single cell, like pass1 or 1@1.de )
  U always gotta get a full string separete by( : ) like

Site1:YES:username(but u havent definedit):1password:WaletID(not defined):reload(not defined):Scheduled Pause(not defined)
Then use parse string action.

I will try to make u a demo ASAP.

[levant_de]

Ah okay something like:

Take row from Site1
Result will be Site1:YES:username(but u havent definedit):1password:WaletID(not defined):reload(not defined):Scheduled Pause(not defined)

And then i say him to use value 4 for the email and value 5 vor the password to store in the db?

Kind regards from Berlin

[KiMoO]

@icemails nah, then u gotta use parse string action and store each value in a separeted variable which u define in parse string method.

[levant_de]

It works, so many thanks for your support.
1 Beer from me. ;)

Short overview what i make:

Select Records by criteria

Table User Data
Filter set on name of the Site from which i need the logindata, save it to variable named SITENAME_TLD.

Then

Parse Line

Use SITENAME_TLD variable and extract following:

SITENAME,ACTIVE,USERNAME,SITENAME_TLD_EMAIL,SITENAME_TLD_PASSWORD,WALLET ID,RELOAD,SCHEDULED PAUSE

After that i use the email and password variable to feed it in the bot.

Many many thanks for that.
I hope i will learn many things from you.

Kind regards from Berlin

[KiMoO]

@icemails u got it =), ur welcome :D

[levant_de]

So i include all the new learned things in my bot, i also understand the if/else thing now. xD

I have 1 mainbot and 5 functions, 1 function for every site.
Did a way exist to handle the thread number on how the bot later run?

Like 1 thread at once and 2 threads at once?
So that if i set it to 2 threads it makes only 2 functions at once and if a function is finish, that it goes to the next function to adjust the workload from pc.

Kind regards from berlin and a nice sunny sunday.

[KiMoO]

@icemails exactly as u said .

[levant_de]

How do i managed that in the bot?

Only setup the thread number to 2 and it will work in the compiled version to only with 2 threads?

http://prntscr.com/mpl9gh

Kind regards from Berlin

[KiMoO]

@icemails add a resourse then u will be able to define the number of threats when the bot starts.

[levant_de]

Okay, that works for me.
Very nice.

So now i have a bigger problem i think.

I have a variable called RELOAD which is an string with the value 120-180.

I go to use the "Time now" command and save it to variable TIME.
Now i use the "Add seconds to date" command and try to add a random value from 120 to 180 seconds to it.

I need that to define a reload on the scripts in case that the sites are not allow to come to often.

Edit:
I resort the thing now.
"Time now" saves the value in the variable "TIME", then i create a random string from SITE_TLD_RELOAD_MIN to SITE_TLD_RELOAD_MAX and save that to SITE_TLD_RELOAD_VALUE variable.
In the "Add seconds to date" command i let him use the actual time from "TIME" variable and calculate the value from SITE_TLD_RELOAD_VALUE on it to save it as variable SITE_TLD_RELOADTIME.

I think that this work, but first can say if it works when i find a way to not let the function running befor the value from SITE_TLD_RELOADTIME is over.

Edit2:

Try to save the content from SITE_TLD_RELOADTIME with "Updates records by creteria" but it wont work.
The database column is on "Date" but it show year 1970 what not can be right.
From Result command gives out the right time.

Kind regards from Berlin

[levant_de]

Forget what i write above. xD

I find another way where i use the following:

On the function i use "Date now" command for variable TIME, then i add the created random string from SITE_TLD_RELOAD_MIN to SITE_TLD_RELOAD_MAX to this which i save in variable SITE_TLD_RELOADTIME.

Now i will use the "Substract Dates" command to calculate SITE_TLD_RELOADTIME - TIME to save the result in TIME2.

To here all works fine.
Now comes the actual problem.

I will use the "IF" command which start a function only when the TIME2 variable is smaller then 0.

Any hints for that?

Kind regargs from Berlin.

[Fox]

@icemails if [[TIME2]] < 0

[levant_de]

@fox said in A few questions about organisate workflow and others:

< 0

Thanks, i try it bevor with if [[TIME2]] =< 0 in case that it work on the match line i use with ==.

So many thanks, now only a few things are open to solve and the bot can goes public.

Anyone has a recaptcha2 plugin for xevil?
Can`t use the 2captcha remote function in xevil.

Kind regards from Berlin

[levant_de]

So another questions for the weekend from me. xD

I want to make a GUI for my Bot and need a bit knowledgebase on that.

Is it possible to make the gui like this:

http://prntscr.com/msg6gb

I hope the picture is understandable.

Green area is to choose activated sites.
Yellow area is a statistic from actual run since programmstart.
Red area are Scrollbars to go down.

On the line below which has "SiteName.tld - 409" in it the user can put in his login credentials and see all succesfully workarounds from the bot since they use it.

So my questions are:

Actual i have all the data in a database like site active, password, username and others.
Did i need to make ressources from them or did the gui works with the database to modify the credentials?

Is a scrollbar possible in the gui?

Can the fields username and password be variable from site to site.

Kind regards from berlin.

[Fox]

@icemails said in A few questions about organisate workflow and others:

So another questions for the weekend from me. xD
I want to make a GUI for my Bot and need a bit knowledgebase on that.
Is it possible to make the gui like this:
http://prntscr.com/msg6gb

Web interface allows you to create any interfaces. If you have enough knowledge and experience of layout.

@icemails said in A few questions about organisate workflow and others:

Actual i have all the data in a database like site active, password, username and others.
Did i need to make ressources from them or did the gui works with the database to modify the credentials?

The web interface has access to the database directly.

Here is the code from the documentation, it should work:

Api.DatabaseCount([], TableId).then(function(RecordCount){
   alert(RecordCount)
})

To get the table id, you need this code:

Api.GetDatabaseStructure()
   .find(function(table){return table.name == "table1"})
   .id

It is also in the documentation, a little higher.

[levant_de]

Wow thanks so much.

But looks like i need to search a person which make that for me.
Did you think 20 Dollar are a good value for that work to search?

Away a bit Playing with the GUI.

Kind regards from Berlin.

[levant_de]

So the bot grows and grows.
But now i have another problem on it.

I will make a pause which is on every day at a certain time with an offset and upset from x minutes.
As example i will configure that it makes every day from 4 am to 10 am a pause which can start until an hour for 4 am and last until an half hour after 10 am.

That it looks like more Human.

And if i use a function called "OnApplicationStart" it will run before the main function begins the work to use it to become variables content and other stuff like that?

Kind regards from Berlin

[Fox]

@icemails said in A few questions about organisate workflow and others:

And if i use a function called "OnApplicationStart" it will run before the main function begins the work to use it to become variables content and other stuff like that?

The "OnApplicationStart" function is executed once at the beginning of the script execution before all threads start. Data from this function can be passed through global variables or resources.