07.05.2010, 21:00
Hello,
my script is based on MySQL Login/Register (last can be done on our hp) selfmade.
When a user register his account a new mysql-field will be created. There's a row which is named "neu".
On the user login in my server, this variable should be loaded in the script for the user. And IF it is 1 (= true) and the player spawns, a message should appear. But it doesn't appear. Even if I set the variable on login manually ( SetPVarInt(playerid, "neu", 1); ) it doesn't work.
Here's the script:
I hope you can help.
Padarom
my script is based on MySQL Login/Register (last can be done on our hp) selfmade.
When a user register his account a new mysql-field will be created. There's a row which is named "neu".
On the user login in my server, this variable should be loaded in the script for the user. And IF it is 1 (= true) and the player spawns, a message should appear. But it doesn't appear. Even if I set the variable on login manually ( SetPVarInt(playerid, "neu", 1); ) it doesn't work.
Here's the script:
Код:
// DCMD/SSCANF LOGIN:
dcmd_einloggen(playerid, params[])
{
if (strlen(params))
{
if(GetPVarInt(playerid, "loggedin") == 1)
{
SendClientMessage(playerid,ROT,"Du bist bereits eingeloggt.");
return 0;
}
new pName[MAX_PLAYER_NAME], query1[128], wert[2], admin1[5], warn[3], query2[128], query3[128];// query4[128], query5[128], firma11[2], firma21[2], firma31[2];
GetPlayerName(playerid, pName, sizeof pName);
format(query,sizeof query,"SELECT `neu` FROM `user` WHERE `name` = '%s'",pName);
mysql_query(query);
mysql_store_result();
mysql_fetch_field("neu",wert);
SetPVarInt(playerid, "neu", strval(wert));
mysql_free_result();
format(query1,sizeof query1,"SELECT `admin` FROM `user` WHERE `name` = '%s'",pName);
mysql_query(query1);
// [...]
// ONPLAYERSPAWN
if(GetPVarInt(playerid, "neu") == 1)
{
// DO THIS AND THIS
for(new i=0; i<49; i++)
{
CreatePickup(1273, 1, haus[i][0], haus[i][1], haus[i][2], -1);
}
}
Padarom

