[GameMode] Base MySQL GM R39 caching
#21

Quote:
Originally Posted by Thomixio
View Post
It's MySQL it all should be saved there?
Yes, as I wrote above, there is at the heart of conservation.
Reply
#22

Code:
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[00:52:57] filterscripts = ""  (string)
[00:52:57] 
[00:52:57] Server Plugins
[00:52:57] --------------
[00:52:57]  Loading plugin: mysql.dll
[00:52:57]   Failed.
[00:52:57]  Loaded 0 plugins.

[00:52:57] 
[00:52:57] Filterscripts
[00:52:57] ---------------
[00:52:57]   Loaded 0 filterscripts.

[00:52:57] Script[gamemodes/base.amx]: Run time error 19: "File or function is not found"
[00:52:57] Number of vehicle models: 0
Doesn't work.
Reply
#23

Mysql.dll failed, place it in your plugins
Reply
#24

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[20:22:55] filterscripts = "" (string)
[20:22:55]
[20:22:55] Server Plugins
[20:22:55] --------------
[20:22:55] Loading plugin: mysql
[20:22:55] SA:MP MySQL Plugin v2.1 Loaded.
[20:22:55] Loaded.
[20:22:55] Loading plugin: sscanf
[20:22:55] [MySQL] Thread running. Threadsafe: Yes.
[20:22:55]

[20:22:55] ===============================

[20:22:55] sscanf plugin loaded.

[20:22:55] © 2009 Alex "Y_Less" Cole

[20:22:55] ===============================

[20:22:55] Loaded.
[20:22:55] Loaded 2 plugins.

[20:22:55]
[20:22:55] Filterscripts
[20:22:55] ---------------
[20:22:55] Loaded 0 filterscripts.

[20:22:55] Script[gamemodes/base.amx]: Run time error 19: "File or function is not found"
[20:22:55] Number of vehicle models: 0
Reply
#25

Use MySQL R33+, Possibly R39-2
Reply
#26

Anyone here that knows how to make this actually work, so stuff are getting saved. Kinda stuck there.
Can't find the SavePlayer in the script neither.
Reply
#27

This tut can help you https://sampforum.blast.hk/showthread.php?tid=485633
Reply
#28

Quote:
Originally Posted by iFarbod
View Post
Already seen it, added and updated the onplayerdisconnect to my script-.. still doesn't add the info to my database.

Enabeled the debugging, and there are no errors at this point. However, this doesn't make sense to me?

My OnPlayerDisconnect:
Quote:

[20:36:06] [DEBUG] mysql_format - connection: 1, len: 2048, format: "UPDATE `accounts` SET `Level`=%d, `Gender`=%d, `Age`=%d, `Admin`=%d, `Skin`=%d, `posX`=%f, `posY`=%f, `posZ`=%f WHERE `ID`=%d"
[20:36:06] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `Level`=1, `Gender`=1, `Age`=24, `Admin`=0", callback: "OnQueryFinish", format: "ii"
[20:36:06] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution
[20:36:06] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[20:36:06] [DEBUG] Calling callback "OnQueryFinish"..
[20:36:06] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

The only thing getting saved is the username and password?

Code:
public OnPlayerDisconnect(playerid, reason)
{
    GetPlayerPos(playerid, PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2]); 
    mysql_format(Pipeline, szQuery, sizeof(szQuery), "UPDATE `accounts` SET `Level`=%d, `Gender`=%d, `Age`=%d, `Admin`=%d, `Skin`=%d, `posX`=%f, `posY`=%f, `posZ`=%f WHERE `ID`=%d",\
    PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pGender], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2], PlayerInfo[playerid][pID]);
    mysql_function_query(Pipeline, szQuery, true, "OnQueryFinish", "ii", THREAD_NO_RESULT, playerid);
    return 1;
}
Reply
#29

This GM such as Liberty RP? https://sampforum.blast.hk/showthread.php?tid=513424
Reply
#30

COOL!
Reply
#31

Hey guys i have this problem ;/

Code:
SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[09:12:42] filterscripts = ""  (string)
[09:12:42] 
[09:12:42] Server Plugins
[09:12:42] --------------
[09:12:42]  Loading plugin: mysql_static.so
[09:12:42]  >> plugin.mysql: R39-3 successfully loaded.
[09:12:42]   Loaded.
[09:12:42]  Loading plugin: sscanf.so
[09:12:42] 

[09:12:42]  ===============================

[09:12:42]       sscanf plugin loaded.     

[09:12:42]          Version:  2.8.1        

[09:12:42]    © 2012 Alex "Y_Less" Cole  

[09:12:42]  ===============================

[09:12:42]   Loaded.
[09:12:42]  Loaded 2 plugins.

[09:12:43] 
[09:12:43] Filterscripts
[09:12:43] ---------------
[09:12:43]   Loaded 0 filterscripts.

[09:12:43] Script[gamemodes/new.amx]: Run time error 19: "File or function is not found"
[09:12:43] Number of vehicle models: 0
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)