09.04.2018, 15:15
I just explained how this works in a recent topic
Click me!
now it is possible to do CREATE in MYSQL 41-R2 although I had not tested it fully, and no I am not going to test it more since, it's a waste of time. Since creating a table happens only ones and it does not need to be repeated.
but in my opinion
example
something like this should work, I had made it work before on older versions but not on the latest ones
PHP код:
new query[200];
format(query, sizeof(query), "INSERT INTO ekwipunek (`slot1nazwa`, `slot1wartosc`,`nick`) VALUES ('%e', '%d','%e')",brak, 0, PlayerName(playerid)); //add %e is string escape
mysql_tquery(SQL_ID,query);
new query[200];
format(query, sizeof(query), "INSERT INTO bank (`uid`, `stan`, `nick`) VALUES ('%i','%i','%e')", pDane[playerid][UID],pDane[playerid][wBank],PlayerName(playerid));//add %e is string escape
mysql_query(SQL_ID,query);
now it is possible to do CREATE in MYSQL 41-R2 although I had not tested it fully, and no I am not going to test it more since, it's a waste of time. Since creating a table happens only ones and it does not need to be repeated.
but in my opinion
PHP код:
mysql_format(/* Your Query Inside */)
mysql_tquery
PHP код:
mysql_format(query, sizeof query, "CREATE TABLE IF NOT EXISTS `accounts` (id int(11) NOT NULL)");
myqsl_tquery(database, query);