Hello, I was wondering as RsForm offers SQL maping and email submission verification, if these can be combined, that means I would write out full form and upon submiting it would be unpublished and once I click the link in email it would publish itself, or it would create the article after its confirmed by mail.

These can be combine, but it does not imply that the mapping will be executed after submission confirmation. The flow looks like this:

- submit form
- validate fields
- run the mapping
- send emails

yes I know, but is there any way to change this thing or achive this, without rewriting the entire thing?

RSForm!Pro is pretty flexible and you can achieve the desired workflow via its scripting areas.

Basically you will need to replicate both submission confirmation and mapping. In the user email simply add a link back to the form with some URL parameters that will help you identify the submission. Once you've done this, you will be able to use the PHP Scripts > Scripts called on form display area to confirm the submission (database table update) and run your desired SQL queries.

The downside: it does require scripting knowledge.