[MySQL R15] Problem Loading Factions - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [MySQL R15] Problem Loading Factions (/showthread.php?tid=494564)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [MySQL R15] Problem Loading Factions (/showthread.php?tid=494564)
[MySQL R15] Problem Loading Factions - jtemple042996 - 13.02.2014
I'm attempting to build a Dynamic Faction System using MySQL and I'm having a problem with Loading.
My MySQL Table looks like this:
http://i.imgur.com/31ouOcm.png
Basically, what it's doing is loading the First faction, but not any others.
MySQL Log:
Код:
[19:25:28] [19:25:28] ** MySQL Debugging enabled. [19:25:28] [19:25:28] >> mysql_connect(localhost, samp, samp, ***) on port 3306 [19:25:28] CMySQLHandler::Connect() - Connection was successful. [19:25:28] CMySQLHandler::Connect() - Auto-reconnect has been enabled. [19:25:28] >> mysql_connect(localhost, samp, samp, ***) on port 3306 [19:25:28] CMySQLHandler::Connect() - Connection was successful. [19:25:28] CMySQLHandler::Connect() - Auto-reconnect has been enabled. [19:25:28] >> mysql_query_callback(Connection handle: 1) [19:25:28] >> mysql_query_callback(Connection handle: 1) [19:25:28] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM f_m... [19:25:28] >> mysql_query_callback(Connection handle: 1) [19:25:28] ProcessQueryThread(OnQueryFinish) - Query was successful. [19:25:28] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [19:25:28] CMySQLHandler::StoreResult() - Result was stored. [19:25:28] CMySQLHandler::FreeResult() - Result was successfully freed. [19:25:28] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick(). [19:25:28] OnQueryFinish(i) - Callback is being called... [19:25:28] >> cache_get_data(Connection handle: 1) [19:25:28] ProcessTick() - The cache has been cleared. [19:25:28] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM r_m... [19:25:28] ProcessQueryThread(OnQueryFinish) - Query was successful. [19:25:28] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [19:25:28] CMySQLHandler::StoreResult() - Result was stored. [19:25:28] CMySQLHandler::FreeResult() - Result was successfully freed. [19:25:28] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick(). [19:25:28] OnQueryFinish(i) - Callback is being called... [19:25:28] >> cache_get_data(Connection handle: 1) [19:25:28] ProcessTick() - The cache has been cleared. [19:25:28] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM d_m... [19:25:28] ProcessQueryThread(OnQueryFinish) - Query was successful. [19:25:28] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [19:25:28] CMySQLHandler::StoreResult() - Result was stored. [19:25:28] CMySQLHandler::FreeResult() - Result was successfully freed. [19:25:28] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick(). [19:25:28] OnQueryFinish(i) - Callback is being called... [19:25:28] >> cache_get_data(Connection handle: 1) [19:25:28] ProcessTick() - The cache has been cleared. [19:26:39] [19:26:39] ** MySQL Debugging enabled. [19:26:39] [19:26:39] >> mysql_connect(localhost, samp, samp, ***) on port 3306 [19:26:39] CMySQLHandler::Connect() - Connection was successful. [19:26:39] CMySQLHandler::Connect() - Auto-reconnect has been enabled. [19:26:39] >> mysql_connect(localhost, samp, samp, ***) on port 3306 [19:26:39] CMySQLHandler::Connect() - Connection was successful. [19:26:39] CMySQLHandler::Connect() - Auto-reconnect has been enabled. [19:26:39] >> mysql_query_callback(Connection handle: 1) [19:26:39] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM f_m... [19:26:39] >> mysql_query_callback(Connection handle: 1) [19:26:39] ProcessQueryThread(OnQueryFinish) - Query was successful. [19:26:39] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [19:26:39] CMySQLHandler::StoreResult() - Result was stored. [19:26:39] CMySQLHandler::FreeResult() - Result was successfully freed. [19:26:39] >> mysql_query_callback(Connection handle: 1) [19:26:39] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick(). [19:26:39] OnQueryFinish(i) - Callback is being called... [19:26:39] >> cache_get_data(Connection handle: 1) [19:26:39] ProcessTick() - The cache has been cleared. [19:26:39] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM r_m... [19:26:39] ProcessQueryThread(OnQueryFinish) - Query was successful. [19:26:39] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [19:26:39] CMySQLHandler::StoreResult() - Result was stored. [19:26:39] CMySQLHandler::FreeResult() - Result was successfully freed. [19:26:39] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick(). [19:26:39] OnQueryFinish(i) - Callback is being called... [19:26:39] >> cache_get_data(Connection handle: 1) [19:26:39] ProcessTick() - The cache has been cleared. [19:26:39] ProcessQueryThread(OnQueryFinish) - Executing query SELECT * FROM d_m... [19:26:39] ProcessQueryThread(OnQueryFinish) - Query was successful. [19:26:39] ProcessQueryThread(OnQueryFinish) - Data caching enabled. [19:26:39] CMySQLHandler::StoreResult() - Result was stored. [19:26:39] CMySQLHandler::FreeResult() - Result was successfully freed. [19:26:39] ProcessQueryThread(OnQueryFinish) - Data being passed to ProcessTick(). [19:26:39] OnQueryFinish(i) - Callback is being called... [19:26:39] >> cache_get_data(Connection handle: 1) [19:26:39] ProcessTick() - The cache has been cleared.
Код:
[19:26:39] Loading Factions... [19:26:39] Loading Faction Ranks... [19:26:39] Loading Faction Divisions... [19:26:39] Filterscript 'Factions.amx' loaded. [19:26:39] Rows Detected. [19:26:39] Rows: 2 [19:26:39] [Slot 1] Test Government Faction Loaded. [19:26:39] Rows: 2 [19:26:39] [Slot 2] Loaded. [19:26:39] Rows: 2 [19:26:39] [Slot 3] NULL Loaded.
My Stock:
Код:
stock LoadFactions(){
print("Loading Factions...");
format(Query,sizeof(Query),"SELECT * FROM f_m");
mysql_function_query(MainPipe,Query,true,"OnQueryFinish","i",THREAD_LOADFACTIONS);
return 1;
}
Код:
forward OnQueryFinish(resultid,extraid,ConnectionHandle);
public OnQueryFinish(resultid,extraid,ConnectionHandle){
new temp[14],rows,fields;
if(resultid != THREAD_NO_RESULT){
cache_get_data(rows,fields);
}
switch(resultid){
case THREAD_LOADFACTIONS:{
if(rows){
print("Rows Detected.");
for(new i = 0; i <= rows; i++){
printf("Rows: %i",rows);
TotFacs++;
cache_get_field_content(i,"fid",temp);
fData[TotFacs][fTitle] = strval(temp);
cache_get_field_content(i,"type",temp);
fData[TotFacs][fType] = strval(temp);
cache_get_field_content(i,"locale",temp);
fData[TotFacs][fLocale] = strval(temp);
cache_get_field_content(i,"parent",temp);
fData[TotFacs][fParent] = strval(temp);
cache_get_field_content(i,"abbr",fData[TotFacs][fAbbr]);
cache_get_field_content(i,"title",fData[TotFacs][fTitle]);
cache_get_field_content(i,"disabled",temp);
fData[TotFacs][fDisabled] = strval(temp);
cache_get_field_content(i,"disabledReason",fData[TotFacs][fDisabledReason]);
cache_get_field_content(i,"disabledAdmin",fData[TotFacs][fDisabledAdmin]);
cache_get_field_content(i,"bank",temp);
fData[TotFacs][fBank] = strval(temp);
cache_get_field_content(i,"phone",temp);
fData[TotFacs][fPhone] = strval(temp);
cache_get_field_content(i,"defaultdiv",temp);
fData[TotFacs][defaultdiv] = strval(temp);
cache_get_field_content(i,"defauljoin",temp);
fData[TotFacs][defaultjoin] = strval(temp);
cache_get_field_content(i,"defaultleader",temp);
fData[TotFacs][defaultleader] = strval(temp);
cache_get_field_content(i,"budget",temp);
fData[TotFacs][fBudget] = strval(temp);
fData[TotFacs][fCreated] = true;
printf("[Slot %i] %s Loaded.",TotFacs,fData[TotFacs][fTitle]);
}
}
}
}
return 1;
}
Re: [MySQL R15] Problem Loading Factions - CuervO - 14.02.2014
Try updating to the last version which is pretty stable and see if the error still exists. The latest as of now is R37 (22 versions ahead). I've had similar problems to this which were fixed by updating the plugin.
Re: [MySQL R15] Problem Loading Factions - jtemple042996 - 14.02.2014
Although that didn't fix the issue, the Factions appear to be loading correctly.. maybe it's something with my method of storing Faction Variables?
Код:
[23:56:38] [DEBUG] mysql_connect - host: "localhost", user: "samp", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [23:56:38] [DEBUG] CMySQLHandle::Create - creating new connection.. [23:56:38] [WARNING] CMySQLHandle::Create - connection already exists [23:56:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [23:56:38] [DEBUG] CMySQLConnection::Connect - connection was successful [23:56:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [23:56:38] [DEBUG] mysql_connect - host: "localhost", user: "samp", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [23:56:38] [DEBUG] CMySQLHandle::Create - creating new connection.. [23:56:38] [WARNING] CMySQLHandle::Create - connection already exists [23:56:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [23:56:38] [DEBUG] CMySQLConnection::Connect - connection was successful [23:56:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [23:56:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [23:56:38] [DEBUG] CMySQLConnection::Connect - connection was successful [23:56:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [23:56:38] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM f_m", callback: "OnQueryFinish", format: "i" [23:56:38] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM r_m", callback: "OnQueryFinish", format: "i" [23:56:38] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [23:56:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [23:56:38] [DEBUG] CMySQLConnection::Connect - connection was successful [23:56:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [23:56:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [23:56:38] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM d_m", callback: "OnQueryFinish", format: "i" [23:56:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [23:56:38] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 5.243 milliseconds [23:56:38] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [23:56:38] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [23:56:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [23:56:38] [DEBUG] CMySQLConnection::Connect - connection was successful [23:56:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [23:56:38] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 2.868 milliseconds [23:56:38] [DEBUG] Calling callback "OnQueryFinish".. ructor called [23:56:38] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [23:56:38] [DEBUG] cache_get_data - connection: 1 [23:56:38] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.786 milliseconds [23:56:38] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [23:56:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [23:56:38] [DEBUG] CMySQLConnection::Connect - connection was successful [23:56:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [23:56:38] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [23:56:38] [DEBUG] CMySQLConnection::Connect - connection was successful [23:56:38] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "fid", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fid", data: "1" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "type", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "type", data: "1" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "locale", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "locale", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "parent", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "parent", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "abbr", connection: 1, max_len: 1 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "abbr", data: "TestGov" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "title", connection: 1, max_len: 1 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "title", data: "Test Government Faction" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "disabled", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "disabled", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "disabledReason", connection: 1, max_len: 1 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "disabledReason", data: "N/A" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "disabledAdmin", connection: 1, max_len: 1 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "disabledAdmin", data: "N/A" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "bank", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "bank", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "phone", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "phone", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "defaultdiv", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "defaultdiv", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "defaultjoin", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "defaultjoin", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "defaultleader", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "defaultleader", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 0, field_name: "budget", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "budget", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "fid", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fid", data: "2" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "type", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "type", data: "3" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "locale", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "locale", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "parent", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "parent", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "abbr", connection: 1, max_len: 1 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "abbr", data: "TestLE" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "title", connection: 1, max_len: 1 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "title", data: "Test Law Enforcement" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "disabled", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "disabled", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "disabledReason", connection: 1, max_len: 1 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "disabledReason", data: "N/A" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "disabledAdmin", connection: 1, max_len: 1 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "disabledAdmin", data: "N/A" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "bank", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "bank", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "phone", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "phone", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "defaultdiv", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "defaultdiv", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "defaultjoin", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "defaultjoin", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "defaultleader", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "defaultleader", data: "0" [23:56:38] [DEBUG] cache_get_field_content - row: 1, field_name: "budget", connection: 1, max_len: 14 [23:56:38] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "budget", data: "0" [23:56:38] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [23:56:38] [DEBUG] Calling callback "OnQueryFinish".. [23:56:38] [DEBUG] cache_get_data - connection: 1 [23:56:38] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [23:56:38] [DEBUG] Calling callback "OnQueryFinish".. [23:56:38] [DEBUG] cache_get_data - connection: 1 [23:56:38] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
Re: [MySQL R15] Problem Loading Factions - CuervO - 14.02.2014
Indeed, it's the function itself.
Код:
cache_get_field_content(i,"fid",temp); fData[TotFacs][fTitle] = strval(temp);
Maybe you were trying to assign the fID variable there?
Also,
Код:
mysql_function_query(MainPipe,Query,true,"OnQueryFinish","i",THREAD_LOADFACTIONS);
Re: [MySQL R15] Problem Loading Factions - jtemple042996 - 15.02.2014
I've fixed that, but still not solution to the problem.. Actually.. now it's not properly loading ANY of the Factions, where originally it was loading the first.
Re: [MySQL R15] Problem Loading Factions - CuervO - 15.02.2014
Post again the code you use when calling the function;
What do the debug messages say? (Both the mysql_log and your print ones)
Re: [MySQL R15] Problem Loading Factions - jtemple042996 - 15.02.2014
Код:
stock LoadFactions(){
print("Loading Factions...");
format(Query,sizeof(Query),"SELECT * FROM f_m");
mysql_function_query(MainPipe,Query,true,"OnQueryFinish","i",THREAD_LOADFACTIONS);
return 1;
}
Код:
forward OnQueryFinish(resultid,extraid,ConnectionHandle);
public OnQueryFinish(resultid,extraid,ConnectionHandle){
new temp[14],rows,fields;
if(resultid != THREAD_NO_RESULT){
cache_get_data(rows,fields,MainPipe);
}
switch(resultid){
case THREAD_LOADFACTIONS:{
if(rows){
print("Rows Detected.");
for(new i = 0; i < rows; i++){
TotFacs++;
cache_get_field_content(i,"fid",temp);
fData[TotFacs][fid] = strval(temp);
cache_get_field_content(i,"type",temp);
fData[TotFacs][fType] = strval(temp);
cache_get_field_content(i,"locale",temp);
fData[TotFacs][fLocale] = strval(temp);
cache_get_field_content(i,"parent",temp);
fData[TotFacs][fParent] = strval(temp);
cache_get_field_content(i,"abbr",fData[TotFacs][fAbbr]);
cache_get_field_content(i,"title",fData[TotFacs][fTitle]);
cache_get_field_content(i,"disabled",temp);
fData[TotFacs][fDisabled] = strval(temp);
cache_get_field_content(i,"disabledReason",fData[TotFacs][fDisabledReason]);
cache_get_field_content(i,"disabledAdmin",fData[TotFacs][fDisabledAdmin]);
cache_get_field_content(i,"bank",temp);
fData[TotFacs][fBank] = strval(temp);
cache_get_field_content(i,"phone",temp);
fData[TotFacs][fPhone] = strval(temp);
cache_get_field_content(i,"defaultdiv",temp);
fData[TotFacs][defaultdiv] = strval(temp);
cache_get_field_content(i,"defaultjoin",temp);
fData[TotFacs][defaultjoin] = strval(temp);
cache_get_field_content(i,"defaultleader",temp);
fData[TotFacs][defaultleader] = strval(temp);
cache_get_field_content(i,"budget",temp);
fData[TotFacs][fBudget] = strval(temp);
fData[TotFacs][fCreated] = true;
printf("[Slot %i] %s Loaded.",TotFacs,fData[TotFacs][fTitle]);
}
}
}
}
return 1;
}
Код:
[09:08:24] [DEBUG] mysql_connect - host: "localhost", user: "samp", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [09:08:24] [DEBUG] CMySQLHandle::Create - creating new connection.. [09:08:24] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [09:08:24] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [09:08:24] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [09:08:24] [DEBUG] CMySQLConnection::Connect - connection was successful [09:08:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [09:08:24] [DEBUG] mysql_connect - host: "localhost", user: "samp", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [09:08:24] [DEBUG] CMySQLHandle::Create - creating new connection.. [09:08:24] [WARNING] CMySQLHandle::Create - connection already exists [09:08:24] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [09:08:24] [DEBUG] CMySQLConnection::Connect - connection was successful [09:08:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [09:08:24] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [09:08:24] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM f_m", callback: "OnQueryFinish", format: "i" [09:08:24] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [09:08:24] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM r_m", callback: "OnQueryFinish", format: "i" [09:08:24] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM d_m", callback: "OnQueryFinish", format: "i" [09:08:24] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [09:08:24] [DEBUG] CMySQLConnection::Connect - connection was successful [09:08:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [09:08:24] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [09:08:24] [DEBUG] CMySQLConnection::Connect - connection was successful [09:08:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [09:08:24] [DEBUG] CMySQLConnection::Connect - connection was successful [09:08:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [09:08:24] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [09:08:24] [DEBUG] CMySQLConnection::Connect - connection was successful [09:08:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [09:08:24] [DEBUG] CMySQLConnection::Connect - connection was successful [09:08:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [09:08:24] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [09:08:24] [DEBUG] CMySQLConnection::Connect - connection was successful [09:08:24] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [09:08:24] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [09:08:24] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.186 milliseconds [09:08:24] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [09:08:24] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [09:08:24] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.968 milliseconds [09:08:24] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [09:08:24] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [09:08:24] [DEBUG] Calling callback "OnQueryFinish".. [09:08:24] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 1.321 milliseconds [09:08:24] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [09:08:24] [DEBUG] cache_get_data - connection: 1 [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "fid", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "fid", data: "1" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "type", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "type", data: "1" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "locale", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "locale", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "parent", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "parent", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "abbr", connection: 1, max_len: 1 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "abbr", data: "TestGov" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "title", connection: 1, max_len: 1 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "title", data: "Test Government Faction" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "disabled", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "disabled", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "disabledReason", connection: 1, max_len: 1 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "disabledReason", data: "N/A" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "disabledAdmin", connection: 1, max_len: 1 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "disabledAdmin", data: "N/A" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "bank", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "bank", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "phone", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "phone", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "defaultdiv", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "defaultdiv", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "defaultjoin", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "defaultjoin", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "defaultleader", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "defaultleader", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 0, field_name: "budget", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "budget", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 1, field_name: "fid", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "fid", data: "2" [09:08:24] [DEBUG] cache_get_field_content - row: 1, field_name: "type", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "type", data: "3" [09:08:24] [DEBUG] cache_get_field_content - row: 1, field_name: "locale", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "locale", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 1, field_name: "parent", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "parent", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 1, field_name: "abbr", connection: 1, max_len: 1 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "abbr", data: "TestLE" [09:08:24] [DEBUG] cache_get_field_content - row: 1, field_name: "title", connection: 1, max_len: 1 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "title", data: "Test Law Enforcement" [09:08:24] [DEBUG] cache_get_field_content - row: 1, field_name: "disabled", connection: 1, max_len: 14 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "disabled", data: "0" [09:08:24] [DEBUG] cache_get_field_content - row: 1, field_name: "disabledReason", connection: 1, max_len: 1 [09:08:24] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "disabledReason", data: "N/A" [09:08:25] [DEBUG] cache_get_field_content - row: 1, field_name: "disabledAdmin", connection: 1, max_len: 1 [09:08:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "disabledAdmin", data: "N/A" [09:08:25] [DEBUG] cache_get_field_content - row: 1, field_name: "bank", connection: 1, max_len: 14 [09:08:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "bank", data: "0" [09:08:25] [DEBUG] cache_get_field_content - row: 1, field_name: "phone", connection: 1, max_len: 14 [09:08:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "phone", data: "0" [09:08:25] [DEBUG] cache_get_field_content - row: 1, field_name: "defaultdiv", connection: 1, max_len: 14 [09:08:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "defaultdiv", data: "0" [09:08:25] [DEBUG] cache_get_field_content - row: 1, field_name: "defaultjoin", connection: 1, max_len: 14 [09:08:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "defaultjoin", data: "0" [09:08:25] [DEBUG] cache_get_field_content - row: 1, field_name: "defaultleader", connection: 1, max_len: 14 [09:08:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "defaultleader", data: "0" [09:08:25] [DEBUG] cache_get_field_content - row: 1, field_name: "budget", connection: 1, max_len: 14 [09:08:25] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "budget", data: "0" [09:08:25] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [09:08:25] [DEBUG] Calling callback "OnQueryFinish".. [09:08:25] [DEBUG] cache_get_data - connection: 1 [09:08:25] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [09:08:25] [DEBUG] Calling callback "OnQueryFinish".. [09:08:25] [DEBUG] cache_get_data - connection: 1 [09:08:25] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
Код:
[09:08:24] Loading Factions... [09:08:24] Loading Faction Ranks... [09:08:24] Loading Faction Divisions... [09:08:24] Filterscript 'Factions.amx' loaded. [09:08:24] Rows Detected. [09:08:24] [Slot 1] Loaded. [09:08:25] [Slot 2] Loaded.