[DUDA]їComo guardo el dinero usando SQLITE?
#3

El cуdigo de SickAttack es muy completo, yo dejarй algo por aca con solo lo bбsico para que se entienda mбs facil el guardado y cargado de datos.

Код:
#include <a_samp>

new DB:SERVER_DB;

public OnFilterScriptInit() {
	SERVER_DB = db_open("database.db");
	db_query(SERVER_DB,"CREATE TABLE IF NOT EXISTS DINERO (NOMBRE TEXT,MONTO INTEGER)");
}

public OnPlayerDisconnect(playerid,reason) {
	new string[128];
	format(string,sizeof string,"UPDATE DINERO SET MONTO='%d' WHERE NAME='%s'",GetPlayerMoney(playerid),PlayerName(playerid));
	db_query(SERVER_DB,string);
	return 1;
}

public OnPlayerConnect(playerid) {
	new string[128];
	format(string,sizeof string,"SELECT MONTO FROM DINERO WHERE NAME='%s' LIMIT 1",PlayerName(playerid));
	new DBResult:result = db_query(SERVER_DB,string);
	if(db_num_rows(result)) {
		db_get_field_assoc(result,"MONTO",string,sizeof string);
		GivePlayerMoney(playerid,strval(string));
	}
	else {
		format(string,sizeof string,"INSERT INTO DINERO (NOMBRE,MONTO) VALUES ('%s','0')",PlayerName(playerid));
		db_query(SERVER_DB,string);
	}
	db_free_result(result);
	return 1;
}

PlayerName(playerid) {
	new pname_[MAX_PLAYER_NAME];
	GetPlayerName(playerid,pname_,MAX_PLAYER_NAME);
	return pname_;
}
Reply


Messages In This Thread
[DUDA]їComo guardo el dinero usando SQLITE? - by DaniielMoo - 10.12.2015, 17:14
Re: [DUDA]їComo guardo el dinero usando SQLITE? - by SickAttack - 10.12.2015, 20:20
Re: [DUDA]їComo guardo el dinero usando SQLITE? - by Daniel-92 - 10.12.2015, 23:00
Respuesta: [DUDA]їComo guardo el dinero usando SQLITE? - by DaniielMoo - 11.12.2015, 03:42

Forum Jump:


Users browsing this thread: 1 Guest(s)