[GameMode] Base MySQL GM R39 caching

[GameMode] Base MySQL GM R39 caching - 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: Gamemode Scripts (https://sampforum.blast.hk/forumdisplay.php?fid=71)
+--- Thread: [GameMode] Base MySQL GM R39 caching (/showthread.php?tid=520556)

Pages: 1 2

Re: Base MySQL GM R39 caching - MadMast - 20.07.2014

Quote:

Originally Posted by Thomixio

It's MySQL it all should be saved there?

Yes, as I wrote above, there is at the heart of conservation.

Re: Base MySQL GM R39 caching - HolisticDev - 21.07.2014

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.

Re: Base MySQL GM R39 caching - Thomixio - 21.07.2014

Mysql.dll failed, place it in your plugins

Re: Base MySQL GM R39 caching - BaranHyrn - 24.07.2014

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

Re: Base MySQL GM R39 caching - iFarbod - 24.07.2014

Use MySQL R33+, Possibly R39-2

Re: Base MySQL GM R39 caching - Thomixio - 24.07.2014

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.

Re: Base MySQL GM R39 caching - iFarbod - 24.07.2014

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

Re: Base MySQL GM R39 caching - Thomixio - 24.07.2014

Quote:

Originally Posted by iFarbod

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

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;
}

Re: Base MySQL GM R39 caching - Raefal - 25.07.2014

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

Re: Base MySQL GM R39 caching - Efflictim - 25.07.2014

COOL!

Re: Base MySQL GM R39 caching - Auri - 28.09.2015

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