- 0
-
Similar Content
-
- 2 answers
- 599 views
-
Problema turf
By Soryn.,
- 3 answers
- 396 views
-
- 0 replies
- 113 views
-
- 2 replies
- 327 views
-
- 1 reply
- 201 views
-
-
Recently Browsing 0 members
- No registered users viewing this page.
Question
InceMan
Problema intalnita (descriere): am gasit un system util de createobject dynamic
idea este ca cand creez un object in samp se creaza dar nu se salveaza si in log imi da erori ceva de genul [20:09:20] Andu has been connected to the server (IP: 46.102.90.25).
[20:09:53] [Error] db_query: invalid database handle 0
[20:09:53] [Error] db_free_result(): invalid result handle 0
[20:09:53] [Error] db_query: invalid database handle 0
[20:09:53] [Error] db_num_rows(): invalid result handle 0
[20:09:53] [Error] db_free_result(): invalid result handle 0
[20:09:53] [Error] db_query: invalid database handle 0
[20:09:53] [Error] db_free_result(): invalid result handle 0
[20:10:04] [Error] db_query: invalid database handle 0
[20:10:04] [Error] db_free_result(): invalid result handle 0
[20:10:04] [Error] db_query: invalid database handle 0
[20:10:04] [Error] db_free_result(): invalid result handle 0
[20:10:04] [Error] db_query: invalid database handle 0
[20:10:04] [Error] db_free_result(): invalid result handle 0
[20:10:05] [Error] db_query: invalid database handle 0
[20:10:05] [Error] db_free_result(): invalid result handle 0
[20:10:05] [Error] db_query: invalid database handle 0
[20:10:05] [Error] db_free_result(): invalid result handle 0
[20:10:05] [Error] db_query: invalid database handle 0
[20:10:05] [Error] db_free_result(): invalid result handle 0
[20:10:07] [Error] db_query: invalid database handle 0
[20:10:07] [Error] db_free_result(): invalid result handle 0
[20:10:08] [Error] db_query: invalid database handle 0
[20:10:08] [Error] db_free_result(): invalid result handle 0
[20:10:08] [Error] db_query: invalid database handle 0
[20:10:08] [Error] db_free_result(): invalid result handle 0
[20:10:08] [Error] db_query: invalid database handle 0
[20:10:08] [Error] db_free_result(): invalid result handle 0
[20:10:10] [Error] db_query: invalid database handle 0
[20:10:10] [Error] db_free_result(): invalid result handle 0
[20:10:10] [Error] db_query: invalid database handle 0
[20:10:10] [Error] db_free_result(): invalid result handle 0
[20:10:11] [Error] db_query: invalid database handle 0
[20:10:11] [Error] db_free_result(): invalid result handle 0
[20:10:11] [Error] db_query: invalid database handle 0
[20:10:11] [Error] db_free_result(): invalid result handle 0
[20:10:11] [Error] db_query: invalid database handle 0
[20:10:11] [Error] db_free_result(): invalid result handle 0
[20:10:12] [Error] db_query: invalid database handle 0
[20:10:12] [Error] db_free_result(): invalid result handle 0
[20:10:12] [Error] db_query: invalid database handle 0
[20:10:12] [Error] db_free_result(): invalid result handle 0
[20:10:12] [Error] db_query: invalid database handle 0
[20:10:12] [Error] db_free_result(): invalid result handle 0
[20:10:14] [Error] db_query: invalid database handle 0
[20:10:14] [Error] db_free_result(): invalid result handle 0 deci nu se salveaza cu configul objects.db ma intreb oare trebuie sai fac o baza de date ?
Liniile de cod / sursa / script-ul(obligatoriu): public OnDialogResponse
if(dialogid == 10002 && response)
{
if(!Numbers(inputtext) && strval(inputtext) != -1) return SendClientMessage(playerid,DEF_COL_RED,"You only can use numbers!"),ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close");
new id = EDIT_OBJECT_ID[playerid];
new EDITOR_QUERY[256];
format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "UPDATE `OBJECTS` SET `VW`=%d WHERE `ID`=%d",
strval(inputtext),
EDITOR_OBJECT[id][OBJ_DB_ID]);
db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY));
SendClientMessage(playerid,DEF_COL_WHITE,"You successful changed to virtualworld of this object.");
return ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close");
}
if(dialogid == 10003 && response)
{
if(!Numbers(inputtext) && strval(inputtext) != -1) return SendClientMessage(playerid,DEF_COL_RED,"You only can use numbers!"),ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close");
new id = EDIT_OBJECT_ID[playerid];
new EDITOR_QUERY[256];
format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "UPDATE `OBJECTS` SET `INT`=%d WHERE `ID`=%d",
strval(inputtext),
EDITOR_OBJECT[id][OBJ_DB_ID]);
db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY));
SendClientMessage(playerid,DEF_COL_WHITE,"You successful changed to interior of this object.");
return ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close");
}
if(dialogid == 10004 && response)
{
if(!Numbers(inputtext) && strval(inputtext) != -1) return SendClientMessage(playerid,DEF_COL_RED,"You only can use numbers!"),ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close");
new id = EDIT_OBJECT_ID[playerid];
new EDITOR_QUERY[256];
format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "UPDATE `OBJECTS` SET `DISTANCE`=%d WHERE `ID`=%d",
strval(inputtext),
EDITOR_OBJECT[id][OBJ_DB_ID]);
db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY));
SendClientMessage(playerid,DEF_COL_WHITE,"You successful changed to distance of this object.");
return ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close");
}
if(dialogid == 10001 && response)
{
if(listitem == 0)
{
EditDynamicObject(playerid, EDIT_OBJECT_ID[playerid]);
return SendClientMessage(playerid,DEF_COL_WHITE,"Usage ESC or the save icon to save the position.");
}
if(listitem == 1)
{
ShowPlayerDialog(playerid,10002,DIALOG_STYLE_INPUT,"{A80000}Virtual World","Insert the virtualworld you wan't to only stream this object in.\nUsage -1 to show it in all virtualworlds.","Save","Close");
}
if(listitem == 2)
{
ShowPlayerDialog(playerid,10003,DIALOG_STYLE_INPUT,"{A80000}Virtual World","Insert the interior you wan't to only stream this object in.\nUsage -1 to show it in all interior\nUsage /interior to see your currently interior.","Save","Close");
}
if(listitem == 3)
{
ShowPlayerDialog(playerid,10004,DIALOG_STYLE_INPUT,"{A80000}Virtual World","Insert the stream distance of this object. Default is 100.","Save","Close");
}
if(listitem == 4)
{
new EDITOR_QUERY[256];
format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "DELETE FROM `OBJECTS` WHERE `ID`=%d",EDITOR_OBJECT[EDIT_OBJECT_ID[playerid]][OBJ_DB_ID]);
db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY));
DestroyDynamicObject(EDIT_OBJECT_ID[playerid]);
return SendClientMessage(playerid,DEF_COL_WHITE,"You succesful deleted this object.");
}
}
if(dialogid == 10000 && response)
{
if(!Numbers(inputtext)) return SendClientMessage(playerid,DEF_COL_RED,"You only can use numbers!"),ShowPlayerDialog(playerid,10000,DIALOG_STYLE_INPUT,"{A80000}Insert Object ID","Insert the object ID that you wan't to create.","Create","Close");
new Float:editor[3],id;
GetPlayerPos(playerid,editor[0],editor[1],editor[2]);
id = CreateDynamicObject(strval(inputtext), editor[0]+1, editor[1]+1, editor[2], 0.0,0.0,0.0, -1, -1, -1, 100.0);
if(id > DEF_MAX_OBJECTS) return SendClientMessageToAll(DEF_COL_WHITE,"Error while creating object, it seems you are trying to create more objects then the max amount of objects.");
EDITOR_OBJECT[id][OBJ_MODEL] = strval(inputtext);
EDITOR_OBJECT[id][OBJ_X] = editor[0]+1;
EDITOR_OBJECT[id][OBJ_Y] = editor[1]+1;
EDITOR_OBJECT[id][OBJ_Z] = editor[2];
EDITOR_OBJECT[id][OBJ_RX] = 0.0;
EDITOR_OBJECT[id][OBJ_RY] = 0.0;
EDITOR_OBJECT[id][OBJ_RZ] = 0.0;
EDITOR_OBJECT[id][OBJ_VW] = -1;
EDITOR_OBJECT[id][OBJ_INTERIOR] = -1;
EDITOR_OBJECT[id][OBJ_STREAM_DISTANCE] = 100.0;
EDIT_OBJECT_ID[playerid] = id;
EditDynamicObject(playerid, id);
new EDITOR_QUERY[256];
format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "INSERT INTO `OBJECTS` (`MODEL`, `X`, `Y`, `Z`, `INT`) VALUES (%d,'%f','%f','%f',%d)",
EDITOR_OBJECT[id][OBJ_MODEL],
EDITOR_OBJECT[id][OBJ_X],
EDITOR_OBJECT[id][OBJ_Y],
EDITOR_OBJECT[id][OBJ_Z],
id+1000);
db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY));
new DBResult:EDITOR_RESULT;
format(EDITOR_QUERY,sizeof(EDITOR_QUERY),"SELECT `ID` FROM `OBJECTS` WHERE `INT`=%d",id+1000);
EDITOR_RESULT = db_query(EDITOR_DATABASE,EDITOR_QUERY);
if(db_num_rows(EDITOR_RESULT) == 1)
{
new temp[16];
db_get_field(EDITOR_RESULT,0,temp,16);
EDITOR_OBJECT[id][OBJ_DB_ID] = strval(temp);
SendClientMessage(playerid,DEF_COL_WHITE,"Object ID received.");
}
db_free_result(EDITOR_RESULT);
format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "UPDATE `OBJECTS` SET `INT`=-1 WHERE `ID`=%d",EDITOR_OBJECT[id][OBJ_DB_ID]);
db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY));
SendClientMessage(playerid,DEF_COL_WHITE,"Object saved to database, Usage /editobject or /selectobject to edit this object.");
}
Imagini / Video (optional):--
Ati incercat sa rezolvati singur?: Da am incercat dar am obtinut rezultate
FiveGame Lands
Pawno Developer, Mapping , Scripter
Since 2016
Link to comment
Share on other sites
17 answers to this question
Recommended Posts