[HELP PLS] How to query a database to see if a record exists?

[iDollarsteam 13]

Hi! I want to store my users and their license codes in a database and then make the bot check the database to see if that user exists and save the result in a variable (or a table). I have made the bot that will let me input data in the database but I have problems making the client bot read the database to see if that record exists. If I use MySQL Workbench to send that query it works as it should so the sintax is correct , the problem is when I run it in ubot, I get an error: "Fatal error encountered during command execution" and of course the command does not return any value. here is the script:

ui text box("id", #hdid)
clear table(&keyword)
plugin command("DatabaseCommands.dll", "connect to database", "server=*******;uid=*******; pwd=******; database=******; port=3306; pooling=false") {
plugin command("DatabaseCommands.dll", "query with results", "SELECT * FROM user_data WHERE user_HDID=@{#hdid}", &keyword)
if($comparison($table total rows(&keyword), ">", 0)) {
 then {
	 alert("License valid")
 }
 else {
	 alert("License invalid")
 }
}
}

 

 

(database credentials are "******" here for obvious reasons ) )

 

 

 

Can anyone tell me what is wrong with this code or show me how to do that in another way?

Thank You

[iDollarsteam 13]

ok, I solved it ... the variable in the query should be inserted in a different way:

ui text box("id", #hdid)
clear table(&keyword)
plugin command("DatabaseCommands.dll", "connect to database", "server=******;uid=*******; pwd=*******; database=*******; port=3306; pooling=false") {
   plugin command("DatabaseCommands.dll", "query with results", "SELECT * FROM user_data WHERE user_HDID=\"{#hdid}\"", &keyword)
   if($comparison($table total rows(&keyword), ">", 0)) {
    then {
	    alert("License valid")
    }
    else {
	    alert("License invalid")
    }
   }
}

[blumi40 222]

tipp!

as more fields u request as more secure is the licencething if ya script only check for id it is mutch easyer to crack it

do something like....

select pla from plupp where id = #id AND email =#email AND some_other_data = #some_other_date

...is a bit more secure

[iDollarsteam 13]

yes, and I also use for the connection a user that has only select and display privileges on the database

[LoWrIdErTJ - BotGuru 904]

could even include in randomized session keys. that must be present inorder to run

[iDollarsteam 13]

TJ... you are waaay ahead as always... This is a great idea! Thanks ...

[Aymen 385]

hey sorry to post to an old thread but , what server host should i use when trying to connect to a database ?? seems that i'm getting alot of fails