+- Burgershot (https://www.burgershot.gg)
+-- Forum: Other languages (https://www.burgershot.gg/forumdisplay.php?fid=23)
+--- Forum: Spanish/Español (https://www.burgershot.gg/forumdisplay.php?fid=24)
+---- Forum: Programación (https://www.burgershot.gg/forumdisplay.php?fid=51)
+---- Thread: ayuda con a_sampdb (/showthread.php?tid=1870)
ayuda con a_sampdb - Nikolay_Staggs - 2021-04-13
Hola amigos estoy haciendo una GameMode desde 0 y estoy haciendo el registro con a_sampdb pero no me guarda los datos solo se crean las Table en la carpeta les paso lo que dise en la carpeta
SQLite format 3 @ -â
ž ž ` tableUSERSUSERSCREATE TABLE `USERS` (`NAME`,`PASS`,`EXP`,`LEVEL_ADMIN`,`SCORE`,`DINERO`)
les paso el GameMode
///_______________________________///
#include <a_samp>
#include <zcmd>
#include <sscanf2>
#define DIALOGO_REGISTRO (1)
#define DIALOG_INGRESO (2)
#define DIALOG_REGISTRO_FINALIZADO (3)
#define MAX_PASSWORD_INVALIDA 3
#define BLANCO "{FFFFFF}"
/*ret_memcpy
strtok*/
main()
{
print("\n----------------------------------");
print(" Death Match\n");
print("----------------------------------\n");
}
//_____Enum______//
enum DATA_PLAYER
{
GAME_IDENTIFICADO,
GAME_REGISTRADO,
GAME_EXP,
GAME_ADMIN_LEVEL,
GAME_SCORE,
GAME_MONEY,
GAME_PASS[60]
}
new PLAYER_INFO[MAX_PLAYERS][DATA_PLAYER];
//_________News__________//
new GAME_PASSWORD_INCORRECTA[MAX_PLAYERS];
new DB:Database;
new Float:Spawn_Player[][4] =
{
{1751.1097,-2106.4529,13.5469,183.1979}, // El-Corona - Outside random house
{2652.6418,-1989.9175,13.9988,182.7107}, // Random house in willowfield - near playa de seville and stadium
{2489.5225,-1957.9258,13.5881,2.3440}, // Hotel in willowfield - near cluckin bell
{2689.5203,-1695.9354,10.0517,39.5312}, // Outside stadium - lots of cars
{2770.5393,-1628.3069,12.1775,4.9637}, // South in east beach - north of stadium - carparks nearby
{2807.9282,-1176.8883,25.3805,173.6018}, // North in east beach - near apartments
{2552.5417,-958.0850,82.6345,280.2542}, // Random house north of Las Colinas
{2232.1309,-1159.5679,25.8906,103.2939}, // Jefferson motel
{2388.1003,-1279.8933,25.1291,94.3321}, // House south of pig pen
{2481.1885,-1536.7186,24.1467,273.4944}, // East LS - near clucking bell and car wash
{2495.0720,-1687.5278,13.5150,359.6696}, // Outside CJ's house - lots of cars nearby
{2306.8252,-1675.4340,13.9221,2.6271}, // House in ganton - lots of cars nearby
{2191.8403,-1455.8251,25.5391,267.9925}, // House in south jefferson - lots of cars nearby
{1830.1359,-1092.1849,23.8656,94.0113}, // Mulholland intersection carpark
{2015.3630,-1717.2535,13.5547,93.3655}, // Idlewood house
{1654.7091,-1656.8516,22.5156,177.9729}, // Right next to PD
{1219.0851,-1812.8058,16.5938,190.0045}, // Conference Center
{1508.6849,-1059.0846,25.0625,1.8058}, // Across the street of BANK - lots of cars in intersection carpark
{1421.0819,-885.3383,50.6531,3.6516}, // Outside house in vinewood
{1133.8237,-1272.1558,13.5469,192.4113}, // Near hospital
{1235.2196,-1608.6111,13.5469,181.2655}, // Backalley west of mainstreet
{590.4648,-1252.2269,18.2116,25.0473}, // Outside "BAnk of San Andreas"
{842.5260,-1007.7679,28.4185,213.9953}, // North of Graveyard
{911.9332,-1232.6490,16.9766,5.2999}, // LS Film Studio
{477.6021,-1496.6207,20.4345,266.9252}, // Rodeo Place
{255.4621,-1366.3256,53.1094,312.0852}, // Outside propery in richman
{281.5446,-1261.4562,73.9319,305.0017}, // Another richman property
{790.1918,-839.8533,60.6328,191.9514}, // Mulholland house
{1299.1859,-801.4249,84.1406,269.5274}, // Maddoggs
{1240.3170,-2036.6886,59.9575,276.4659}, // Verdant Bluffs
{2215.5181,-2627.8174,13.5469,273.7786}, // Ocean docks 1
{2509.4346,-2637.6543,13.6453,358.3565}, // Ocean Docks spawn 2
{1435.8024,2662.3647,11.3926,1.1650}, // Northern train station
{1457.4762,2773.4868,10.8203,272.2754}, // Northern golf club
{1739.6390,2803.0569,14.2735,285.3929}, // Northern housing estate 1
{1870.3096,2785.2471,14.2734,42.3102}, // Northern housing estate 2
{1959.7142,2754.6863,10.8203,181.4731}, // Northern house 1
{2314.2556,2759.4504,10.8203,93.2711}, // Northern industrial estate 1
{2216.5674,2715.0334,10.8130,267.6540}, // Northern industrial estate 2
{2101.4192,2678.7874,10.8130,92.0607}, // Northern near railway line
{1951.1090,2660.3877,10.8203,180.8461}, // Northern house 2
{1666.6949,2604.9861,10.8203,179.8495}, // Northern house 3
{2808.3367,2421.5107,11.0625,136.2060}, // Northern shopping centre
{2633.3203,2349.7061,10.6719,178.7175}, // V-Rock
{2606.6348,2161.7490,10.8203,88.7508}, // South V-Rock
{2616.5286,2100.6226,10.8158,177.7834}, // North Ammunation 1
{2491.8816,2397.9370,10.8203,266.6003}, // North carpark 1
{2531.7891,2530.3223,21.8750,91.6686}, // North carpark 2
{2340.6677,2530.4324,10.8203,177.8630}, // North Pizza Stack
{2097.6855,2491.3313,14.8390,181.8117}, // Emerald Isle
{1893.1000,2423.2412,11.1782,269.4385}, // Souvenir shop
{1698.9330,2241.8320,10.8203,357.8584}, // Northern casino
{1479.4559,2249.0769,11.0234,306.3790}, // Baseball stadium 1
{1298.1548,2083.4016,10.8127,256.7034}, // Baseball stadium 2
{1117.8785,2304.1514,10.8203,81.5490}, // North carparks
{1108.9878,1705.8639,10.8203,0.6785}, // Dirtring racing 1
{1423.9780,1034.4188,10.8203,90.9590}, // Sumo
{1537.4377,752.0641,11.0234,271.6893}, // Church
{1917.9590,702.6984,11.1328,359.2682}, // Southern housing estate
{2089.4785,658.0414,11.2707,357.3572}, // Southern house 1
{2489.8286,928.3251,10.8280,67.2245}, // Wedding chapel
{2697.4717,856.4916,9.8360,267.0983}, // Southern construction site
{2845.6104,1288.1444,11.3906,3.6506}, // Southern train station
{2437.9370,1293.1442,10.8203,86.3830}, // Wedding chapel (near Pyramid)
{2299.5430,1451.4177,10.8203,269.1287}, // Carpark (near Pyramid)
{2214.3008,2041.9165,10.8203,268.7626}, // Central parking lot
{2005.9174,2152.0835,10.8203,270.1372}, // Central motel
{2222.1042,1837.4220,10.8203,88.6461}, // Clowns Pocket
{2025.6753,1916.4363,12.3382,272.5852}, // The Visage
{2087.9902,1516.5336,10.8203,48.9300}, // Royal Casino
{2172.1624,1398.7496,11.0625,91.3783}, // Auto Bahn
{2139.1841,987.7975,10.8203,0.2315}, // Come-a-lot
{1860.9672,1030.2910,10.8203,271.6988}, // Behind 4 Dragons
{1673.2345,1316.1067,10.8203,177.7294}, // Airport carpark
{1412.6187,2000.0596,14.7396,271.3568}, // South baseball stadium houses
{-2723.4639,-314.8138,7.1839,43.5562}, // golf course spawn
{-2694.5344,64.5550,4.3359,95.0190}, // in front of a house
{-2458.2000,134.5419,35.1719,303.9446}, // hotel
{-2796.6589,219.5733,7.1875,88.8288}, // house
{-2706.5261,397.7129,4.3672,179.8611}, // park
{-2866.7683,691.9363,23.4989,286.3060}, // house
{-2764.9543,785.6434,52.7813,357.6817}, // donut shop
{-2660.9402,883.2115,79.7738,357.4440}, // house
{-2861.0796,1047.7109,33.6068,188.2750}, // parking lot
{-2629.2009,1383.1367,7.1833,179.7006}, // parking lot at the bridge
{-2079.6802,1430.0189,7.1016,177.6486}, // pier
{-1660.2294,1382.6698,9.8047,136.2952}, // pier 69
{-1674.1964,430.3246,7.1797,226.1357}, // gas station]
{-1954.9982,141.8080,27.1747,277.7342}, // train station
{-1956.1447,287.1091,35.4688,90.4465}, // car shop
{-1888.1117,615.7245,35.1719,128.4498}, // random
{-1922.5566,886.8939,35.3359,272.1293}, // random
{-1983.3458,1117.0645,53.1243,271.2390}, // church
{-2417.6458,970.1491,45.2969,269.3676}, // gas station
{-2108.0171,902.8030,76.5792,5.7139}, // house
{-2097.5664,658.0771,52.3672,270.4487}, // random
{-2263.6650,393.7423,34.7708,136.4152}, // random
{-2287.5027,149.1875,35.3125,266.3989}, // baseball parking lot
{-2039.3571,-97.7205,35.1641,7.4744}, // driving school
{-1867.5022,-141.9203,11.8984,22.4499}, // factory
{-1537.8992,116.0441,17.3226,120.8537}, // docks ship
{-1708.4763,7.0187,3.5489,319.3260}, // docks hangar
{-1427.0858,-288.9430,14.1484,137.0812}, // airport
{-2173.0654,-392.7444,35.3359,237.0159}, // stadium
{-2320.5286,-180.3870,35.3135,179.6980}, // burger shot
{-2930.0049,487.2518,4.9141,3.8258} // harbor
};
public OnGameModeInit()
{
SetGameModeText("Blank Script");
UsePlayerPedAnims();
for(new x = 0; x < 312; x++)
{
if(x != 74) AddPlayerClass(x, 0.0, 0.0, 0.0, 0.0, -1, -1, -1, -1, -1, -1);
}
//loaddb();
return 1;
}
/*stock loaddb()
{
Database = db_open("DM_FREEROAM/User_DM.db");
db_query(Database,"CREATE TABLE IF NOT EXISTS `USERS` (`NAME`,`PASS`,`EXP`,`LEVEL_ADMIN`,`SCORE`,`DINERO`)");
return 1;
}*/
public OnGameModeExit()
{
db_close(Database);
return 1;
}
public OnPlayerRequestClass(playerid, classid)
{
SetPlayerPos(playerid, 545.2801, -1746.7690, 19.5009);
SetPlayerCameraPos(playerid, 547.5287, -1750.2517, 19.6819);
SetPlayerCameraLookAt(playerid, 545.2801, -1746.7690, 19.5009);
SetPlayerFacingAngle(playerid, 32.0000);
return 1;
}
public OnPlayerConnect(playerid)
{
GAME_PASSWORD_INCORRECTA[playerid] = 0;
new string[250], DB_Query[450], DBResult:Result, field[50];
format(DB_Query, sizeof(DB_Query), "SELECT * FROM `USERS` WHERE `NAME` = '%s' COLLATE NOCASE", NAME_USER(playerid));
if(db_num_rows(Result))
{
format(string, sizeof(string), "{CCCCCC}- Bienvenido %s.\n- Escribe tu contraseña para identificarte", NAME_USER(playerid));
ShowPlayerDialog(playerid, DIALOG_INGRESO, DIALOG_STYLE_PASSWORD, ""#BLANCO"Ingreso", string, "Ingresar", "Salir");
Result = db_query(Database, DB_Query);
db_get_field_assoc(Result, "PASS", field, sizeof(field));
format(PLAYER_INFO[playerid][GAME_PASS], 60, "%s", field);
}
else
{
format(string, sizeof(string), "{CCCCCC}- Bienvenido %s.\n- Escribe una contraseña para Registrarte", NAME_USER(playerid));
ShowPlayerDialog(playerid, DIALOGO_REGISTRO, DIALOG_STYLE_PASSWORD, ""#BLANCO"Registrar", string, "Ok", "Salir");
}
db_free_result(Result);
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
GuardarDatos(playerid);
return 1;
}
public OnPlayerSpawn(playerid)
{
if(PLAYER_INFO[playerid][GAME_REGISTRADO] == 1 && PLAYER_INFO[playerid][GAME_IDENTIFICADO] == 1)
{
new randplay = random(sizeof(Spawn_Player));
SetPlayerPos(playerid, Spawn_Player[randplay][0], Spawn_Player[randplay][1], Spawn_Player[randplay][2] + (1.0));
}
return 1;
}
public OnPlayerRequestSpawn(playerid)
{
if ((!PLAYER_INFO[playerid][GAME_REGISTRADO]) || (!PLAYER_INFO[playerid][GAME_IDENTIFICADO]))
{
SendClientMessage(playerid, -1, "{CCCCCC}[Cuentas]: No puedes spawnear hasta no \"Registrarte\" y \"Ingresar\"");
}
return 1;
}
public OnPlayerText(playerid, text[])
{
if((!PLAYER_INFO[playerid][GAME_REGISTRADO]) || (!PLAYER_INFO[playerid][GAME_IDENTIFICADO]))
{
SendClientMessage(playerid, -1, "{CCCCCC}[Cuentas]: No puedes hablar hasta no \"Registrarte\" y \"Ingresar\"");
return 0;
}
return 1;
}
public OnPlayerDeath(playerid, killerid, reason)
{
PLAYER_INFO[killerid][GAME_EXP]++;
PLAYER_INFO[playerid][GAME_SCORE]++;
PLAYER_INFO[playerid][GAME_EXP] --;
return 1;
}
public OnVehicleSpawn(vehicleid)
{
return 1;
}
public OnVehicleDeath(vehicleid, killerid)
{
return 1;
}
public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
return 1;
}
public OnPlayerExitVehicle(playerid, vehicleid)
{
return 1;
}
public OnPlayerStateChange(playerid, newstate, oldstate)
{
return 1;
}
public OnPlayerEnterCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveCheckpoint(playerid)
{
return 1;
}
public OnPlayerEnterRaceCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveRaceCheckpoint(playerid)
{
return 1;
}
public OnRconCommand(cmd[])
{
return 1;
}
public OnObjectMoved(objectid)
{
return 1;
}
public OnPlayerObjectMoved(playerid, objectid)
{
return 1;
}
public OnPlayerPickUpPickup(playerid, pickupid)
{
return 1;
}
public OnVehicleMod(playerid, vehicleid, componentid)
{
return 1;
}
public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
return 1;
}
public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
return 1;
}
public OnPlayerSelectedMenuRow(playerid, row)
{
return 1;
}
public OnPlayerExitedMenu(playerid)
{
return 1;
}
public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
return 1;
}
public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
return 1;
}
public OnRconLoginAttempt(ip[], password[], success)
{
return 1;
}
public OnPlayerUpdate(playerid)
{
return 1;
}
public OnPlayerStreamIn(playerid, forplayerid)
{
return 1;
}
public OnPlayerStreamOut(playerid, forplayerid)
{
return 1;
}
public OnVehicleStreamIn(vehicleid, forplayerid)
{
return 1;
}
public OnVehicleStreamOut(vehicleid, forplayerid)
{
return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
new string[250];
if(dialogid == DIALOGO_REGISTRO)
{
new DB_Query[450];
if(!response) return Kick(playerid);
{
if(strlen(inputtext) <= 4)
{
format(string, sizeof(string) ,"{CCCCCC}- Por favor %s.\n- Tu contraseña debe tener mas de 4 a 16 digitos.", NAME_USER(playerid));
ShowPlayerDialog(playerid, DIALOGO_REGISTRO, DIALOG_STYLE_INPUT, "Registro", string, "Registrar", "Salir");
PlayerPlaySound(playerid, 1085, 0.0, 0.0, 0.0);
return 1;
}
format(DB_Query, sizeof(DB_Query), "INSERT INTO `USERS` (`NAME`, `PASS`, `EXP`, `LEVEL_ADMIN`, `SCORE`, `DINERO`) VALUES('%s','%s','%s', '%d', '%d', '%d', '%d')",
NAME_USER(playerid),
inputtext,
PLAYER_INFO[playerid][GAME_EXP],
PLAYER_INFO[playerid][GAME_ADMIN_LEVEL],
PLAYER_INFO[playerid][GAME_SCORE],
PLAYER_INFO[playerid][GAME_MONEY]);
GuardarDatos(playerid);
SetPlayerScore(playerid, PLAYER_INFO[playerid][GAME_SCORE]);
GivePlayerMoney(playerid, PLAYER_INFO[playerid][GAME_MONEY]);
PLAYER_INFO[playerid][GAME_IDENTIFICADO] = 1;
PLAYER_INFO[playerid][GAME_REGISTRADO] = 1;
format(string, sizeof (string), "{CCCCCC}- Fuiste registrado en nuestra base de datos %s.\n- Tu contraseña es: %s", NAME_USER(playerid), inputtext);
ShowPlayerDialog(playerid, DIALOG_REGISTRO_FINALIZADO, DIALOG_STYLE_MSGBOX, "Registro terminado", string, "Aceptar", "");
}
}
else if(dialogid == DIALOG_INGRESO)
{
new DB_Query[450], DBResult: Result;
if(!response) return Kick(playerid);
{
if(strlen(inputtext) == 0)
{
format(string, sizeof(string) ,"{CCCCCC}- Por favor %s.\n- No introduciste ningun digito, escribelo nuevamente", NAME_USER(playerid));
ShowPlayerDialog(playerid, DIALOG_INGRESO, DIALOG_STYLE_INPUT, "Ingreso", string, "Ingresar", "Salir");
PlayerPlaySound(playerid, 1085, 0.0, 0.0, 0.0);
return 1;
}
if(!strcmp(inputtext, PLAYER_INFO[playerid][GAME_PASS]))
{
format(DB_Query, sizeof(DB_Query), "SELECT * FROM `USERS` WHERE `NAME` = '%q' COLLATE NOCASE", NAME_USER(playerid));
Result = db_query(Database, DB_Query);
if(db_num_rows(Result))
{
PLAYER_INFO[playerid][GAME_EXP] = db_get_field_assoc_int(Result, "EXP");
PLAYER_INFO[playerid][GAME_ADMIN_LEVEL] = db_get_field_assoc_int(Result, "LEVEL_ADMIN");
PLAYER_INFO[playerid][GAME_SCORE] = db_get_field_assoc_int(Result, "SCORE");
PLAYER_INFO[playerid][GAME_MONEY] = db_get_field_assoc_int(Result, "DINERO");
}
else
{
GAME_PASSWORD_INCORRECTA[playerid]++;
format(string, sizeof(string), "{CCCCCC}- Por favor %s.\n- Ingresa una contraseña correcta", NAME_USER(playerid));
ShowPlayerDialog(playerid, DIALOG_INGRESO, DIALOG_STYLE_PASSWORD, "{6F0000}Error", string, "Ok", "Salir");
if(GAME_PASSWORD_INCORRECTA[playerid] == MAX_PASSWORD_INVALIDA)
{
format(string,sizeof(string),"{6F0000}[Cuentas]: %s fue expulsado (Max intentos de ingresar(Contraseña invalida))", NAME_USER(playerid));
SendClientMessageToAll(-1, string);
SendClientMessage(playerid, -1, "** Haz puesto varias contraseñas incorrectas has sido kickeado del servidor por seguridad.");
Kick(playerid);
PlayerPlaySound(playerid, 1085, 0.0, 0.0, 0.0);
}
}
}
}
}
return 1;
}
public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}
//__________Comandos_Usar______________//
CMD:duda(playerid, params[])
{
new str[50], mensaje[128];
if(sscanf(params, "s[128]", mensaje)) return SendClientMessage(playerid, -1, "USA [/duda] [tu duda]");
if(PLAYER_INFO[playerid][GAME_ADMIN_LEVEL]) format(str, sizeof(str), "{A300A0}Admin [%s] {FFFFFF}[%s]", NAME_USER(playerid), mensaje);
else format(str, sizeof(str), "Duda [%s %d] [%s]", NAME_USER(playerid), playerid, mensaje);
SendClientMessageToAll(0x008D6EFF, str);
return 1;
}
//________Comandos_Admin_________//
CMD:dameadmin(playerid, params[])
{
if(IsPlayerAdmin(playerid))
{
PLAYER_INFO[playerid][GAME_ADMIN_LEVEL] = 1;
SendClientMessage(playerid, -1, "Ok");
GuardarDatos(playerid);
}
else
{
SendClientMessage(playerid, -1, "No eres admin rcon");
}
return 1;
}
//_____Info_____//
stock NAME_USER(playerid)
{
new User_Name[MAX_PLAYER_NAME];
GetPlayerName(playerid, User_Name, sizeof(User_Name));
return User_Name;
}
stock GuardarDatos(playerid)
{
new DB_Query[450];
format(DB_Query, sizeof(DB_Query), "UPDATE `USERS` SET `EXP` = '%d', `LEVEL_ADMIN` = '%d', `SCORE` = '%d', `DINERO` = '%d' WHERE `NAME` = '%q' COLLATE NOCASE",
PLAYER_INFO[playerid][GAME_EXP],
PLAYER_INFO[playerid][GAME_ADMIN_LEVEL],
PLAYER_INFO[playerid][GAME_SCORE],
PLAYER_INFO[playerid][GAME_MONEY],
NAME_USER(playerid));
db_query(Database, DB_Query);
return 1;
}
//______Nuevos_Public________//
RE: ayuda con a_sampdb - Chessy - 2021-04-27
Te falta esto abajo del insert into
db_query(Database, DB_Query);
RE: ayuda con a_sampdb - Nikolay_Staggs - 2021-04-30
lol muchisimas gracias