Jump to content
  • 0

SQLite Problem


Rimmon

Question

Am inceput sa fac RST v2 pe SQLite ca sa il postez pe net, desi stiam cat de cat SQLite inainte,nu am mai scriptat de multisor si am cam uitat.

Dar am o problema la register:

Nu se salveaza nimic in DB

Asta e codul de la OnDialogResponse

if(dialogid == Register)
	{
	    new str[350];
	    if(response)
	    {
		    if(strlen(inputtext))
			{
				new DBResult:rezultat;
				format ( Query , 256 , " SELECT * FROM `Users` WHERE `Name` = '%s' " , GetName(playerid));
				rezultat = db_query( Database , Query );
				if(!db_num_rows(rezultat))
				{
			        format (Query,256,"INSERT INTO `Users` VALUES (NULL,'%s','%s','%d','%d','%d','%d','%d','%d','%d','%d'",GetName(playerid),inputtext,P_DATA[playerid][Level]=0,P_DATA[playerid][Vip]=0,P_DATA[playerid][Warnings]=0,P_DATA[playerid][Kills]=0,P_DATA[playerid][Deaths]=0,GetPlayerScore(playerid),GetPlayerMoney(playerid),P_DATA[playerid][Coins]);
					db_query( Database , Query );
					GivePlayerMoney(playerid,5000);
				}
				else
				{
				    Kick(playerid);
				}
				db_free_result(rezultat);
			}
			else
			{
				format( str , 350 , "{FF0000}Romania\t\t{FFFF00}Stunt\t\t\t{00FFFF}Time\n{FF8800}Parola trebuie sa contina mai multe caractere\n{FF8800}Te rugam sa scrii o alta parola\n\n{FF0000}INREGISTRAREA ESTE NECESARA PENTRU A PUTEA JUCA PE ACEST SERVER",GetName(playerid));
				ShowPlayerDialog( playerid , Register, DIALOG_STYLE_PASSWORD , " {FF0000}R{FFFF00}S{00FFFF}T " , str , "Register" , "Cancel");
			}
		}
		else
		{
		    Kick(playerid);
		}
	}

Massari e curva mea

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Sincer nu ma pricep la SQLite, invatasem intr-un timp dar nu prea bine si am uitat.

In schimb am gasit altceva mult mai usor de folosit.

Am facut un tutorial complet despre cum se foloseste.

Are la baza tot SQLite dar este mult mai usor de folosit.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.