I tryed a lot, i renamed the Tabels because numbers are not good to locate the error.
I tried your idea, its surely right, but i cant use it because i am too noobie.
so i post the Completly code for u, maybe u can see how to use ur idea right.
in the Documentation, I found a help tut 4 mysql, this works better than my version. But i get crasy with the calculate.
Here the Updated Code
Code:
public lesen() {
new Sql:mysql = dbi_connect("localhost", "****", "****", "****")
//Do a select query
new Result:res = dbi_query(mysql,"SELECT Spieler FROM zbktb")
//If the query is less than or equal to RESULT_FAILED, you got an invalid result and can't do anything with it.
if (res <= RESULT_FAILED) {
new err[255]
new errNum = dbi_error(mysql, err, 254)
server_print("error3: %s|%d", err, errNum)
return 1
}
//Loop through the result set
while (res && dbi_nextrow(res)>0) {
new qry[32]
//Get the column/field called "keyname" from the result set
dbi_result(res, "Spieler", qry, 32)
server_print("result1: %s", qry)
}
//Free the result set
dbi_free_result(res)
//Close the connection
dbi_close(mysql)
}
and here again what i want to do:
Important!
Every Server this plugin is installed, will be added to this table, so the server result needs everytime a new count.