Mysqul tabanlı gate password hatası

[Tektabanca]

Merhaba dostlarım forumsampta mysqul tabanlı bir gate sistemi buldum gate sistemini ekledim çalıştırıyorum sunucuya giriyorum

PAWN Kodu: Seç

/creategate 975 123 yazıyorum "123" kısmı gate nin şifresi oluyor bunu mysqula kayıt ediyor ama daha sonra kapını yanına gidip /gate yazıyorum şifre dialogu geliyor ama kapı açılmıyor. Eğer şifresiz gate oluşturursam çalışıyor, açılıp kapanabiliyor. mysqul logunda çıkan hata

PAWN Kodu: Seç

[WARNING] mysql_connect: no password specified (C:\Users\Osman\Desktop\anka\Mod\filterscripts\dynamic-gate.pwn:189)ORJİNAL KONU : https://forum.sa-mp.com/showthread.php?t=595522
 SSler:







Not: /editgate yazınca dialog geliyor ama işlem yapmıyor. bence password squlda bir sorun var yardımcı olursanız mutlu olurum dc: Tektabanca~Osman18#8910

[jyonsae]

gate oluşturma komutunu atar mısın

[Excision]

zamanında bu sistemi mysqle çevirmiştim buradan alabilirsin. yine aynı sorun ile karşılaşırsan diyalog idlerini değiştirmeyi dene.

[Tektabanca]

zamanında bu sistemi mysqle çevirmiştim buradan alabilirsin. yine aynı sorun ile karşılaşırsan diyalog idlerini değiştirmeyi dene.

şimdi fark ettim bende onu kullanıyorumuşum, tw üzerinden yardımcı olur musunuz ?

[Tektabanca]

gate oluşturma komutunu atar mısın

PAWN Kodu: Seç

CMD:gateekle(playerid, params[])
{
if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF} RCON şifresini girmen gerekli.");
if(EditingGateID[playerid] != -1) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF}Birini düzenlerken gate oluşturamazsınız.");
new id = Iter_Free(Gates);
if(id == -1) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF}Gate ekleme sınırına ulaşıldı. ");
new model, password[GATE_PASS_LEN];
if(sscanf(params, "iS()["#GATE_PASS_LEN"]", model, password)) return SendClientMessage(playerid, 0xF39C12FF, "Kullanım: {FFFFFF}/gateekle [model id] [şifre (opsiyonel)]");

GateData[id][GateModel] = model;
format(GateData[id][GatePassword], GATE_PASS_LEN, "%s", password);

new Float: x, Float: y, Float: z;
GetPlayerPos(playerid, x, y, z);
GetXYInFrontOfPlayer(playerid, x, y, 3.0);

GateData[id][GatePos][0] = x;
GateData[id][GatePos][1] = y;
GateData[id][GatePos][2] = z;
GateData[id][GateRot][0] = GateData[id][GateRot][1] = GateData[id][GateRot][2] = 0.0;
GateData[id][GateOpenPos][0] = GateData[id][GateOpenPos][1] = GateData[id][GateOpenPos][2] = 0.0;
GateData[id][GateOpenRot][0] = GateData[id][GateOpenRot][1] = GateData[id][GateOpenRot][2] = 0.0;
GateData[id][GateState] = GATE_STATE_CLOSED;
GateData[id][GateEditing] = true;
GateData[id][GateObject] = CreateDynamicObject(model, x, y, z, 0.0, 0.0, 0.0);
new string[32];
format(string, sizeof(string), "Gate #%d\n%s", id, GateStates[GATE_STATE_CLOSED]);
GateData[id][GateLabel] = CreateDynamic3DTextLabel(string, 0xECF0F1FF, x, y, z, 10.0);
Iter_Add(Gates, id);

new query[256];
mysql_format(GateHandle, query, sizeof(query), "INSERT INTO gates (id, model, password, def_posx, def_posy, def_posz) VALUES (%d, %d, '%e', %f, %f, %f)", id, model, password, x, y, z);
mysql_tquery(GateHandle, query);

EditingGateID[playerid] = id;
EditingGateType[playerid] = GATE_STATE_CLOSED;
EditDynamicObject(playerid, GateData[id][GateObject]);
SendClientMessage(playerid, 0x2ECC71FF, "INFO: {FFFFFF}Gate oluşturuldu, şimdi düzenleyebilirsiniz..");
return 1;
}

[Tektabanca]

Güncel sorun devam ediyor

[Buzz]

Bu sistem normalde sqlite ile çalışmıyor mu? Kodlara bakmadım ama mysql geçirmişsin sanırım, orada bir yerde hata var ise ondan kaynaklı olabilir diye düşünüyorum.

[Tektabanca]

Bu sistem normalde sqlite ile çalışmıyor mu? Kodlara bakmadım ama mysql geçirmişsin sanırım, orada bir yerde hata var ise ondan kaynaklı olabilir diye düşünüyorum.

PAWN Kodu: Seç

#include <a_mysql>
#include <sscanf2>
#include <streamer>
#include <foreach>
#include <zcmd>

#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASSWORD ""
#define SQL_DBNAME "gatedb"
new MySQL: GateHandle;
mysql ile çalışıyor.

[Fwtroyes]

password varchar şeklinde olucak, int değil. (değeri 100 falan yapabilirsin)

[Tektabanca]

password varchar şeklinde olucak, int değil. (değeri 100 falan yapabilirsin)

sorun devam ediyor

[Buzz]

Excision'un dediğini dener misin? Dialog id'leri moddakiler ile çakışıyor olabilir.

[Tektabanca]

Excision'un dediğini dener misin? Dialog id'leri moddakiler ile çakışıyor olabilir.

PAWN Kodu: Seç

/*
Dynamic Gates by rootcause
MySQL R40 Version
Topic: https://forum.sa-mp.com/showthread.php?t=595522
*/
#define FILTERSCRIPT
#include <a_samp>
#include <a_mysql>
#include <sscanf2>
#include <streamer>
#include <foreach>
#include <zcmd>

#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASSWORD ""
#define SQL_DBNAME "gatedb"
new MySQL: GateHandle;

#define MAX_GATES 100
#define GATE_PASS_LEN 8
#define MOVE_SPEED (1.65)

enum    _:e_gatestates
{
GATE_STATE_CLOSED,
GATE_STATE_OPEN
}

enum    _:e_gatedialogs
{
DIALOG_GATE_PASSWORD = 12250,
DIALOG_GATE_EDITMENU,
DIALOG_GATE_NEWPASSWORD
}

enum    e_gate
{
GateModel,
GatePassword[GATE_PASS_LEN],
Float: GatePos[3],
Float: GateRot[3],
Float: GateOpenPos[3],
Float: GateOpenRot[3],
GateState,
bool: GateEditing,
GateObject,
Text3D: GateLabel
}

new
GateData[MAX_GATES][e_gate],
Iterator: Gates<MAX_GATES>,
EditingGateID[MAX_PLAYERS] = {-1, ...},
EditingGateType[MAX_PLAYERS] = {-1, ...},
bool: HasGateAuth[MAX_PLAYERS][MAX_GATES];

new GateStates[2][16] = {"{E74C3C}Closed", "{2ECC71}Open"};

GetXYInFrontOfPlayer(playerid, &Float:x, &Float:y, Float:distance)
{
new Float:a;
GetPlayerPos(playerid, x, y, a);
GetPlayerFacingAngle(playerid, a);
if (GetPlayerVehicleID(playerid))
{
GetVehicleZAngle(GetPlayerVehicleID(playerid), a);
}
x += (distance * floatsin(-a, degrees));
y += (distance * floatcos(-a, degrees));
}

GetClosestGate(playerid, Float: range = 5.0)
{
new id = -1, Float: playerdist, Float: tempdist = 9999.0;
foreach(new i : Gates)
{
playerdist = GetPlayerDistanceFromPoint(playerid, GateData[i][GatePos]
[list][li], GateData[i][GatePos][1], GateData[i][GatePos][2]);[/li][/list]
if(playerdist > range) continue;
if(playerdist <= tempdist)
{
tempdist = playerdist;
id = i;
}
}
return id;
}

SetGateState(id, gate_state, move = 1)
{
new string[32];
format(string, sizeof(string), "Gate #%d\n%s", id, GateStates[gate_state]);
UpdateDynamic3DTextLabelText(GateData[id][GateLabel], 0xECF0F1FF, string);
GateData[id][GateState] = gate_state;

switch(move)
{
case 1:
{
if(gate_state == GATE_STATE_CLOSED)
{
MoveDynamicObject(GateData[id][GateObject], GateData[id][GatePos]
[list][li], GateData[id][GatePos][1], GateData[id][GatePos][2], MOVE_SPEED, GateData[id][GateRot][/li]
[li], GateData[id][GateRot][1], GateData[id][GateRot][2]);[/li][/list]
}else
{
MoveDynamicObject(GateData[id][GateObject], GateData[id][GateOpenPos]
[list][li], GateData[id][GateOpenPos][1], GateData[id][GateOpenPos][2], MOVE_SPEED, GateData[id][GateOpenRot][/li]
[li], GateData[id][GateOpenRot][1], GateData[id][GateOpenRot][2]);[/li][/list]
}
}
case 2:
{
if(gate_state == GATE_STATE_CLOSED)
{
SetDynamicObjectPos(GateData[id][GateObject], GateData[id][GatePos]
[list][li], GateData[id][GatePos][1], GateData[id][GatePos][2]);[/li][/list]
SetDynamicObjectRot(GateData[id][GateObject], GateData[id][GateRot]
[list][li], GateData[id][GateRot][1], GateData[id][GateRot][2]);[/li][/list]
}else
{
SetDynamicObjectPos(GateData[id][GateObject], GateData[id][GateOpenPos]
[list][li], GateData[id][GateOpenPos][1], GateData[id][GateOpenPos][2]);[/li][/list]
SetDynamicObjectRot(GateData[id][GateObject], GateData[id][GateOpenRot]
[list][li], GateData[id][GateOpenRot][1], GateData[id][GateOpenRot][2]);[/li][/list]
}
}
}
return 1;
}

ToggleGateState(id, move = 1)
{
if(GateData[id][GateState] == GATE_STATE_CLOSED)
{
SetGateState(id, GATE_STATE_OPEN, move);
}else
{
SetGateState(id, GATE_STATE_CLOSED, move);
}
return 1;
}

ShowEditMenu(playerid, id)
{
new string[128];
format(string, sizeof(string), "Gate State\t%s\nGate Password\t%s\nEdit Gate Position\nEdit Opening Position\nRemove Gate", GateStates[ GateData[id][GateState] ], GateData[id][GatePassword]);
ShowPlayerDialog(playerid, DIALOG_GATE_EDITMENU, DIALOG_STYLE_TABLIST, "Gate Editing", string, "Choose", "Cancel");
return 1;
}

SaveGate(id)
{
new query[512];
mysql_format(GateHandle, query, sizeof(query), "UPDATE gates SET password='%e', def_posx=%f, def_posy=%f, def_posz=%f, def_rotx=%f, def_roty=%f, def_rotz=%f, open_posx=%f, open_posy=%f, open_posz=%f, open_rotx=%f, open_roty=%f, open_rotz=%f WHERE id=%d",
GateData[id][GatePassword], GateData[id][GatePos]
[list][li], GateData[id][GatePos][1], GateData[id][GatePos][2], GateData[id][GateRot][/li]
[li], GateData[id][GateRot][1], GateData[id][GateRot][2], GateData[id][GateOpenPos][/li]
[li], GateData[id][GateOpenPos][1], GateData[id][GateOpenPos][2], GateData[id][GateOpenRot][/li]
[li], GateData[id][GateOpenRot][1], GateData[id][GateOpenRot][2], id);[/li][/list]
mysql_tquery(GateHandle, query);
return 1;
}
forward LoadGates();
public LoadGates()
{
new rows = cache_num_rows();
if(rows)
{
new id, loaded, label[56];
while(loaded < rows)
{
cache_get_value_name_int(loaded, "id", id);
cache_get_value_name_int(loaded, "model", GateData[id][GateModel]);
cache_get_value_name(loaded, "password", GateData[id][GatePassword], GATE_PASS_LEN);
cache_get_value_name_float(loaded, "def_posx", GateData[id][GatePos]
[list][li]);[/li][/list]
cache_get_value_name_float(loaded, "def_posy", GateData[id][GatePos][1]);
cache_get_value_name_float(loaded, "def_posz", GateData[id][GatePos][2]);
cache_get_value_name_float(loaded, "def_rotx", GateData[id][GateRot]
[list][li]);[/li][/list]
cache_get_value_name_float(loaded, "def_roty", GateData[id][GateRot][1]);
cache_get_value_name_float(loaded, "def_rotz", GateData[id][GateRot][2]);
cache_get_value_name_float(loaded, "open_posx", GateData[id][GateOpenPos]
[list][li]);[/li][/list]
cache_get_value_name_float(loaded, "open_posy", GateData[id][GateOpenPos][1]);
cache_get_value_name_float(loaded, "open_posz", GateData[id][GateOpenPos][2]);
cache_get_value_name_float(loaded, "open_rotx", GateData[id][GateOpenRot]
[list][li]);[/li][/list]
cache_get_value_name_float(loaded, "open_roty", GateData[id][GateOpenRot][1]);
cache_get_value_name_float(loaded, "open_rotz", GateData[id][GateOpenRot][2]);

format(label, sizeof(label), "Gate #%d\n%s", id, GateStates[GATE_STATE_CLOSED]);
GateData[id][GateObject] = CreateDynamicObject(GateData[id][GateModel], GateData[id][GatePos]
[list][li], GateData[id][GatePos][1], GateData[id][GatePos][2], GateData[id][GateRot][/li]
[li], GateData[id][GateRot][1], GateData[id][GateRot][2]);[/li][/list]
GateData[id][GateLabel] = CreateDynamic3DTextLabel(label, 0xECF0F1FF, GateData[id][GatePos]
[list][li], GateData[id][GatePos][1], GateData[id][GatePos][2], 10.0);[/li][/list]
Iter_Add(Gates, id);
loaded++;
}
printf(" [Gate System] Loaded %d gates.", loaded);
}
return 1;
}
public OnFilterScriptInit()
{
GateHandle = mysql_connect(SQL_HOST, SQL_USER, SQL_PASSWORD, SQL_DBNAME);
mysql_log(ERROR | WARNING);
if(mysql_errno() != 0) return print(" [Gate System] Can't connect to MySQL.");
mysql_tquery(GateHandle, "CREATE TABLE IF NOT EXISTS `gates` (\
`id` INT(11),\
`model` INT(11), \
`password` VARCHAR("#GATE_PASS_LEN"), \
`def_posx` FLOAT NOT NULL,\
`def_posy` FLOAT NOT NULL,\
  `def_posz` FLOAT NOT NULL,\
  `def_rotx` FLOAT NOT NULL,\
  `def_roty` FLOAT NOT NULL,\
  `def_rotz` FLOAT NOT NULL,\
  `open_posx` FLOAT NOT NULL,\
  `open_posy` FLOAT NOT NULL,\
  `open_posz` FLOAT NOT NULL,\
  `open_rotx` FLOAT NOT NULL,\
  `open_roty` FLOAT NOT NULL,\
  `open_rotz` FLOAT NOT NULL,\
  PRIMARY KEY  (`id`))");
mysql_tquery(GateHandle, "SELECT * FROM `gates`", "LoadGates");
return 1;
}

public OnFilterScriptExit()
{
mysql_close(GateHandle);
return 1;
}

public OnPlayerConnect(playerid)
{
EditingGateID[playerid] = -1;
EditingGateType[playerid] = -1;
for(new i; i < MAX_GATES; i++) HasGateAuth[playerid][i] = false;
return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
if(EditingGateID[playerid] != -1) GateData[EditingGateID[playerid]][GateEditing] = false;
return 1;
}

public OnPlayerEditDynamicObject(playerid, STREAMER_TAG_OBJECT objectid, response, Float:x, Float:y, Float:z, Float:rx, Float:ry, Float:rz)
{
if(EditingGateID[playerid] == -1) return 1;
switch(response)
{
case EDIT_RESPONSE_FINAL:
{
new id = EditingGateID[playerid];
GateData[id][GateEditing] = false;

switch(EditingGateType[playerid])
{
case GATE_STATE_CLOSED:
{
Streamer_SetFloatData(STREAMER_TYPE_3D_TEXT_LABEL, GateData[id][GateLabel], E_STREAMER_X, x);
Streamer_SetFloatData(STREAMER_TYPE_3D_TEXT_LABEL, GateData[id][GateLabel], E_STREAMER_Y, y);
Streamer_SetFloatData(STREAMER_TYPE_3D_TEXT_LABEL, GateData[id][GateLabel], E_STREAMER_Z, z);
SetDynamicObjectPos(objectid, x, y, z);
SetDynamicObjectRot(objectid, rx, ry, rz);
GateData[id][GatePos]
[list][li]= x;[/li][/list]
GateData[id][GatePos][1] = y;
GateData[id][GatePos][2] = z;
GateData[id][GateRot]
[list][li]= rx;[/li][/list]
GateData[id][GateRot][1] = ry;
GateData[id][GateRot][2] = rz;
SendClientMessage(playerid, 0x2ECC71FF, "INFO: {FFFFFF}Edited gate's default position.");

if(GateData[id][GateOpenPos]
[list][li]== 0.0 && GateData[id][GateOpenRot][/li]
[li]== 0.0)[/li][/list]
{
GateData[id][GateEditing] = true;
EditingGateType[playerid] = GATE_STATE_OPEN;
EditDynamicObject(playerid, objectid);

SendClientMessage(playerid, 0xF39C12FF, "WARNING: {FFFFFF}This gate doesn't have an opening position.");
SendClientMessage(playerid, 0xF39C12FF, "WARNING: {FFFFFF}You can define an opening position now or you can do it later.");
SendClientMessage(playerid, 0xF39C12FF, "WARNING: {FFFFFF}People won't be able to open this gate until you define an opening position.");
}else
{
EditingGateID[playerid] = -1;
EditingGateType[playerid] = -1;
}
SaveGate(id);
}
case GATE_STATE_OPEN:
{
SendClientMessage(playerid, 0x2ECC71FF, "INFO: {FFFFFF}Edited gate's opening position.");
SetGateState(id, GATE_STATE_CLOSED, 2);
GateData[id][GateOpenPos]
[list][li]= x;[/li][/list]
GateData[id][GateOpenPos][1] = y;
GateData[id][GateOpenPos][2] = z;
GateData[id][GateOpenRot]
[list][li]= rx;[/li][/list]
GateData[id][GateOpenRot][1] = ry;
GateData[id][GateOpenRot][2] = rz;

EditingGateID[playerid] = -1;
EditingGateType[playerid] = -1;
SaveGate(id);
}
}
}
case EDIT_RESPONSE_CANCEL:
{
new id = EditingGateID[playerid];
GateData[id][GateEditing] = false;

switch(EditingGateType[playerid])
{
case GATE_STATE_CLOSED:
{
SetDynamicObjectPos(objectid, GateData[id][GatePos]
[list][li], GateData[id][GatePos][1], GateData[id][GatePos][2]);[/li][/list]
SetDynamicObjectRot(objectid, GateData[id][GateRot]
[list][li], GateData[id][GateRot][1], GateData[id][GateRot][2]);[/li][/list]
GateData[id][GatePos]
[list][li]= x;[/li][/list]
GateData[id][GatePos][1] = y;
GateData[id][GatePos][2] = z;
GateData[id][GateRot]
[list][li]= rx;[/li][/list]
GateData[id][GateRot][1] = ry;
GateData[id][GateRot][2] = rz;
SendClientMessage(playerid, 0x2ECC71FF, "INFO: {FFFFFF}Cancelled editing gate's default position.");
}
case GATE_STATE_OPEN:
{
SendClientMessage(playerid, 0x2ECC71FF, "INFO: {FFFFFF}Cancelled editing gate's opening position.");

if(GateData[id][GateOpenPos]
[list][li]== 0.0 && GateData[id][GateOpenRot][/li]
[li]== 0.0)[/li][/list]
{
SendClientMessage(playerid, 0xF39C12FF, "WARNING: {FFFFFF}This gate doesn't have an opening position.");
SendClientMessage(playerid, 0xF39C12FF, "WARNING: {FFFFFF}People won't be able to open it until you define an opening position.");
}

SetGateState(id, GATE_STATE_CLOSED, 2);
EditingGateID[playerid] = -1;
EditingGateType[playerid] = -1;
}
}
}
}
return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
if(dialogid == DIALOG_GATE_PASSWORD)
{
if(!response) return 1;
if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_GATE_PASSWORD, DIALOG_STYLE_PASSWORD, "Gate Password", "{E74C3C}You didn't write a password.\n{FFFFFF}Please enter this gate's password:", "Done", "Cancel");
new id = GetClosestGate(playerid);
if(id == -1) return SendClientMessage(playerid, 0xE74C3CFF, "ERROR: {FFFFFF}You're not near a gate.");
if(strcmp(GateData[id][GatePassword], inputtext)) return ShowPlayerDialog(playerid, DIALOG_GATE_PASSWORD, DIALOG_STYLE_PASSWORD, "Gate Password", "{E74C3C}Wrong password.\n{FFFFFF}Please enter this gate's password:", "Done", "Cancel");
HasGateAuth[playerid][id] = true;
ToggleGateState(id);
return 1;
}

if(dialogid == DIALOG_GATE_EDITMENU)
{
if(!IsPlayerAdmin(playerid)) return 1;
if(!response)
{
if(EditingGateID[playerid] != -1) GateData[ EditingGateID[playerid] ][GateEditing] = false;
EditingGateID[playerid] = -1;
return 1;
}

new id = EditingGateID[playerid];
if(id == -1) return SendClientMessage(playerid, 0xE74C3CFF, "ERROR: {FFFFFF}You're not editing a gate.");
if(listitem == 0)
{
ToggleGateState(id);
ShowEditMenu(playerid, id);
}

if(listitem == 1) ShowPlayerDialog(playerid, DIALOG_GATE_NEWPASSWORD, DIALOG_STYLE_INPUT, "Change Gate Password", "Write a new password for selected gate:\nYou can leave this empty if you want to remove gate's password.", "Update", "Cancel");
if(listitem == 2)
{
SetGateState(id, GATE_STATE_CLOSED, 2);
EditingGateType[playerid] = GATE_STATE_CLOSED;
EditDynamicObject(playerid, GateData[id][GateObject]);
SendClientMessage(playerid, 0x2ECC71FF, "INFO: {FFFFFF}Editing gate's default position.");
}

if(listitem == 3)
{
SetGateState(id, GATE_STATE_OPEN, 2);
EditingGateType[playerid] = GATE_STATE_OPEN;
EditDynamicObject(playerid, GateData[id][GateObject]);
SendClientMessage(playerid, 0x2ECC71FF, "INFO: {FFFFFF}Editing gate's opening position.");
}

if(listitem == 4)
{
GateData[id][GateEditing] = false;
GateData[id][GatePos]
[list][li]= GateData[id][GatePos][1] = GateData[id][GatePos][2] = 0.0;[/li][/list]
GateData[id][GateRot]
[list][li]= GateData[id][GateRot][1] = GateData[id][GateRot][2] = 0.0;[/li][/list]
GateData[id][GateOpenPos]
[list][li]= GateData[id][GateOpenPos][1] = GateData[id][GateOpenPos][2] = 0.0;[/li][/list]
GateData[id][GateOpenRot]
[list][li]= GateData[id][GateOpenRot][1] = GateData[id][GateOpenRot][2] = 0.0;[/li][/list]
DestroyDynamicObject(GateData[id][GateObject]);
DestroyDynamic3DTextLabel(GateData[id][GateLabel]);
Iter_Remove(Gates, id);
new query[56];
mysql_format(GateHandle, query, sizeof(query), "DELETE FROM gates WHERE id=%d", id);
mysql_tquery(GateHandle, query);

foreach(new i : Player) if(EditingGateID[i] == id) EditingGateID[i] = -1;
SendClientMessage(playerid, 0x2ECC71FF, "INFO: {FFFFFF}Gate removed.");
}
return 1;
}

if(dialogid == DIALOG_GATE_NEWPASSWORD)
{
if(!IsPlayerAdmin(playerid)) return 1;
new id = EditingGateID[playerid];
if(id == -1) return SendClientMessage(playerid, 0xE74C3CFF, "ERROR: {FFFFFF}You're not editing a gate.");
if(!response) return ShowEditMenu(playerid, id);
format(GateData[id][GatePassword], GATE_PASS_LEN, "%s", inputtext);
foreach(new i : Player) HasGateAuth[i][id] = false;
SendClientMessage(playerid, 0x2ECC71FF, "INFO: {FFFFFF}Şifre güncellendi.");
SaveGate(id);
ShowEditMenu(playerid, id);
return 1;
}
return 0;
}

CMD:gate(playerid)
{
new id = GetClosestGate(playerid);
if(id == -1) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF}Bir Gate yakınında değilsin.");
if(GateData[id][GateEditing]) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF}Bu gate düzenleniyor, kullanamazsınız.");
if(GateData[id][GateOpenPos]
[list][li]== 0.0 && GateData[id][GateOpenRot][/li]
[li]== 0.0) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF}Bu kapının açılma pozisyonu yok.");[/li][/list]
if(!strlen(GateData[id][GatePassword]))
{
ToggleGateState(id);
}else
{
if(HasGateAuth[playerid][id])
{
ToggleGateState(id);
}else
{
ShowPlayerDialog(playerid, DIALOG_GATE_PASSWORD, DIALOG_STYLE_PASSWORD, "Gate Password", "This gate is password protected.\nPlease enter this gate's password:", "Done", "Cancel");
}
}
return 1;
}

CMD:gateekle(playerid, params[])
{
if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF} RCON şifresini girmen gerekli.");
if(EditingGateID[playerid] != -1) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF}Birini düzenlerken gate oluşturamazsınız.");
new id = Iter_Free(Gates);
if(id == -1) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF}Gate ekleme sınırına ulaşıldı. ");
new model, password[GATE_PASS_LEN];
if(sscanf(params, "iS()["#GATE_PASS_LEN"]", model, password)) return SendClientMessage(playerid, 0xF39C12FF, "Kullanım: {FFFFFF}/gateekle [model id] [şifre (opsiyonel)]");

GateData[id][GateModel] = model;
format(GateData[id][GatePassword], GATE_PASS_LEN, "%s", password);

new Float: x, Float: y, Float: z;
GetPlayerPos(playerid, x, y, z);
GetXYInFrontOfPlayer(playerid, x, y, 3.0);

GateData[id][GatePos]
[list][li]= x;[/li][/list]
GateData[id][GatePos][1] = y;
GateData[id][GatePos][2] = z;
GateData[id][GateRot]
[list][li]= GateData[id][GateRot][1] = GateData[id][GateRot][2] = 0.0;[/li][/list]
GateData[id][GateOpenPos]
[list][li]= GateData[id][GateOpenPos][1] = GateData[id][GateOpenPos][2] = 0.0;[/li][/list]
GateData[id][GateOpenRot]
[list][li]= GateData[id][GateOpenRot][1] = GateData[id][GateOpenRot][2] = 0.0;[/li][/list]
GateData[id][GateState] = GATE_STATE_CLOSED;
GateData[id][GateEditing] = true;
GateData[id][GateObject] = CreateDynamicObject(model, x, y, z, 0.0, 0.0, 0.0);
new string[32];
format(string, sizeof(string), "Gate #%d\n%s", id, GateStates[GATE_STATE_CLOSED]);
GateData[id][GateLabel] = CreateDynamic3DTextLabel(string, 0xECF0F1FF, x, y, z, 10.0);
Iter_Add(Gates, id);

new query[256];
mysql_format(GateHandle, query, sizeof(query), "INSERT INTO gates (id, model, password, def_posx, def_posy, def_posz) VALUES (%d, %d, '%e', %f, %f, %f)", id, model, password, x, y, z);
mysql_tquery(GateHandle, query);

EditingGateID[playerid] = id;
EditingGateType[playerid] = GATE_STATE_CLOSED;
EditDynamicObject(playerid, GateData[id][GateObject]);
SendClientMessage(playerid, 0x2ECC71FF, "INFO: {FFFFFF}Gate oluşturuldu, şimdi düzenleyebilirsiniz..");
return 1;
}

CMD:editgate(playerid, params[])
{
if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF} RCON şifresini girmen gerekli.");
if(EditingGateID[playerid] != -1) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF}Birini düzenlerken gate oluşturamazsınız.");
new id;
sscanf(params, "I(-2)", id);
if(id == -2) id = GetClosestGate(playerid);
if(id == -1) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF}Bir gate'nin yanında değilsin.");
if(GateData[id][GateEditing]) return SendClientMessage(playerid, 0xE74C3CFF, "HATA: {FFFFFF}Gate düzenleniyor.");
if(!IsPlayerInRangeOfPoint(playerid, 20.0, GateData[id][GatePos]
[list][li], GateData[id][GatePos][1], GateData[id][GatePos][2])) return SendClientMessage(playerid, 0xE74C3CFF, "ERROR: {FFFFFF}You're not near the gate you want to edit.");[/li][/list]
GateData[id][GateEditing] = true;
EditingGateID[playerid] = id;
ShowEditMenu(playerid, id);
return 1;
}
@Buzz sen değiştirebilir misin ben değiştirince hata variyor yapamadım.

[Tektabanca]

güncel :(

[Tektabanca]

güncel :(