+ open.mp forum (https://forum.open.mp)
-- Forum: Other languages (https://forum.open.mp/forumdisplay.php?fid=23)
--- Forum: Spanish/Espa?ol (https://forum.open.mp/forumdisplay.php?fid=24)
---- Forum: Programaci?n (https://forum.open.mp/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