Nie zapisuje mi aut.
Skrypt na baze salon:
[lua] plr:setData('vehsell:info', {
['cost']=data.cost,
['model']=data.model,
['mileage']=data.mileage,
['engine']=data.engine,
}, false)
plr:outputChat('* Aby zakupi? ten pojazd wpisz /kuppojazd')
end)
addEventHandler('onVehicleExit', resourceRoot, function(plr, seat, jacked)
if seat~=0 then return end
local data=plr:getData('vehsell:info')
if not data then return end
plr:removeData('vehsell:info')
end)
addCommandHandler('kuppojazd', function(plr, cmd)
local data=plr:getData('vehsell:info')
if not data then return end
if getPlayerMoney(plr) < data.cost then
plr:outputChat('* Nie posiadasz wystarczaj?cej kwoty pieni?dzy !')
return
end
local vehicle=plr:getOccupiedVehicle()
if vehicle then
removePedFromVehicle(vehicle)
end
local cost=data.cost
local model=data.model
local mileage=data.mileage
local engine=data.engine
local sid=getElementData(plr,'player:sid') or 0
takePlayerMoney(plr, cost)
plr:outputChat('* Zakupi?e?(a?) sw?j pojazd '..getVehicleNameFromModel(model)..', znajdziesz go w przechowywalni.')
exports["pystories-db"]:dbSet("INSERT INTO pystories_vehicles (id,model,frozen,pos,text,health,fuel,mileage,driver,color,headlights,paintjob,tuning,panelstates,rent,plateText,ownedPlayer,ownedGroup,parking,police,neon,blok...
Witam was,mam pewnie problem z po??czeniem si? do bazy danych...Wi?c wpisuje w konsoli na hostingu,by serwer odpalil skrypt DB2 oraz ogrpg-db i po??czy? si? z baz? danych,lecz wyskakuje takie co?...
[2017-12-30 09] start: Requested by Console
[2017-12-30 09] Starting DB2
[2017-12-30 09] WARNING: [Podstawa]/[bazydanych]/DB2/sql.lua:16: Bad usage @ 'dbConnect' [Access denied for user 'db_27950'@'OZR1.ServerProject.eu' (using password: YES)]
[2017-12-30 09] Po??czono Z Baz? danych!
[2017-12-30 09] start: Resource 'DB2' started
> start ogrpg-db
[2017-12-30 09] start: Requested by Console
[2017-12-30 09] Starting ogrpg-db
[2017-12-30 09] WARNING: [Podstawa]/[bazydanych]/ogrpg-db/s_db.lua:31: Bad usage @ 'dbConnect' [Can't connect to MySQL server on '137.74.0.12137.74.0.12' (111)]
[2017-12-30 09] INFO: * No Connecting to server MYSQL..
[2017-12-30 09] ERROR: [Podstawa]/[bazydanych]/ogrpg-db/s_db.lua:51: attempt to call global 'SQL_Host' (a nil value)
[2017-12-30 09] start: Resource 'ogrpg-db' started
Prosz? o pomoc,wiem,?e nie jestem jakim? specjalist? w tym,ale robie dla sb serwer by si? uczy? i chc? mie? podpi?t? baz? danych MYSQL do serwera,lecz nie ??czy si?...
if ( getPlayerTeam ( player ) == getTeamFromName ( "Drifterzy" ) ) then
function( player, dimension )
if dimension and getElementType( player ) == "player" then
local vehicle = getPlayerOccupiedVehicle( player )
if vehicle then
local driver = getVehicleController( vehicle )
if driver == player and not getVehicleInModShop( source ) then
for k,v in ipairs( modShops ) do
if modShops[ k ].marker == source and getElementType( vehicle ) == "vehicle" then
timers[ vehicle ] = setTimer( unfreezeVehicleInModShop, 60000 * TIME_IN_MODSHOP, 1, vehicle )
timersClient[ vehicle ] = setTimer( triggerClientEvent, 60000 * TIME_IN_MODSHOP - 200, 1, driver, "modShop_clientResetVehicleUpgrades", driver )
setModShopBusy( source, vehicle )
freezVehicleInModShop( vehicle, modShops[ k ].marker )
triggerClientEvent( driver, "onClientPlayerEnterModShop", player, vehicle, getPlayerMoney( player ), modShops[ k ].name )
end
en...
Mam problem z ID! Mianowicie: ID od 5 w g?r? bierze zawsze jakby 0! czyli jak chce uciszy? ID 6 to ucisza 0 ... tak samo jest z jail ,pm ,govecash itp... jednak idzdo dzia?a poprawnie na wszystkie ID ... Czego to mo?e by? przyczyna i czy da si? to naprawi??
Dlaczego ta funkcja:
[code]GetPlayerExp(playerid){
new SEXP[127];
format(SEXP, sizeof(SEXP), "SELECT `Exp` FROM `Gracze` WHERE `Nick` = '%s'", PlayerName(playerid));
mysql_store_result();
mysql_fetch_row(SEXP);
mysql_query(SEXP);
return 1;
}
[/code]
powoduje takie b??dy?
[quote][23:54] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed.
[23:54] [MySQL] Error (0): Function: mysql_store_result called when no result stored.
[23:54] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[23:54] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[23:54] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[23:54] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[23:54] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Commands out of sync; you can't run this command now.
[23:54] [MySQL] Error (0): Function: mysql_num_rows called when no result stored. Commands out of sync; you can't run this command now.
[23:54] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you can't run this command now.
[23:54] [MySQL] Error (0): Failed to exeute query. Commands out of sync; you c...
Witam.M?g?by kto? napisa?,co nale?y doda? w tym kodzie by sprawdza?o czy has?o wpisane przez gracza jest dobre,bo obecnie wystarczy wpisa? jakiekolwiek i zaloguje.
Witam.Po jakim? czasie 'prawie' uda?o si? zrobi? to co zamierza?em,ale...Doda?em zliczanie czasu gry online.Czas zostaje zliczany poprawie,ale przy ponownym wej?ciu na serwer (pograniu ) i wyj?ciu nie zlicza czasu a zapisuje go
Online = 3(czas w min za pierwszym wej?ciem)4(czas za drugim razem) itd.
Mam problem, poniewa? gdy wchodzi si? na serwer to pokazuje si? okienko GUI gdzie mo?na wybra? tylko 2 broni np. wybieram DEAGLE i SHOTGUN'a, a inna osoba kt?ra we?mie np. SNIPER I SILENCER to wtedy gdy przyk?adowo ja zgin? i si? zespawnuj? to mam jego zestaw broni zamiast sw?j.
yo . pisze mapke, pierwszy raz z mysql. wiec mam problem z loginem, gdy sie loguje ciagle jest z?e has?o chociaz dobre wpisuje kawa?ek kodu z logowania:
tak wiec, pisze maapke, zrobilem rejestracje itp. tylko ze przy logowaniu wyskakuje ciagle z?e has?o.. ja w mysql pierwszy raz roobie i praktycznie tego nie ogarniam wiec, tu kod z logowania:
[code]
case GuiLogowanie:
{
switch(response)
{
case 0:
{
aha(playerid, "{FF0000}Pr?ba zalogowania si?, bez podania has?a");
return 1;
}
case 1:
{
new no[512],query2[512], pass[20];
mysql_real_escape_string(inputtext, pass);
format(query2, 512, "SELECT `id`, `kasa`, `respekt`, `admin`, `vip` FROM `gracze` WHERE `login`='%s' AND `haslo`='%s'", PlayerName(playerid),pass);
mysql_query(query2);
mysql_store_result();
sscanf(no, "p<|>ddddd", GraczInfo[playerid][gUID], GraczInfo[playerid][gKasa], GraczInfo[playerid][gRespekt], GraczInfo[playerid][gAdmin], GraczInfo[playerid][gVIP]);
if(!mysql_num_rows())
return ShowPlayerDialog(playerid, GuiLogowanie, DIALOG_STYLE_INPUT, "{B0B0B0}"NazwaSerwera"", "{FF0000}Z?e has?o!n{33AA33}Podaj ponownie!", "Zaloguj", "Anuluj");
SendClientMessage(playerid, 0x0, "{33AA33}Zalogowa?e? si?! Ciesz si? gr?!");
GivePlayerMoney(playerid, GraczInfo[playerid][gKasa]);
SetPlayerScore(playerid, GraczInfo[playerid][gRespekt]);
GraczInfo[playerid][gZalogowany] = 1;
mysql_free_result();
return 1;
}
}
...