[Plugin] [REL] MySQL Plugin (Now on github!)

[Plugin] [REL] MySQL Plugin (Now on github!) - 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: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128

Re: [REL] MySQL Plugin (Now on github!) - iZN - 27.01.2015

Quote:

Originally Posted by DRIFT_HUNTER

Im sure he requested R6 and R7 like i did few posts above...

Yeah it seems like that. Very well:

R7: http://forum.sa-mp.com/showpost.php?...postcount=5140

R8 - R34: https://code.******.com/p/sa-mp-mysq...unt+UploadedBy

R33 - R39-2+: https://github.com/pBlueG/SA-MP-MySQL/releases

Quote:

Originally Posted by ShiffeyTheGamer

Links outdated?

^^^

Re: [REL] MySQL Plugin (Now on github!) - MotherDucker - 01.02.2015

Quote:

Originally Posted by iZN

https://github.com/pBlueG/SA-MP-MySQL/releases

They're fine.

No, I mean to R6; I can't access them on the Github which sucks and the link's on this topic need permission.

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 05.02.2015

R39-3 has been released.
Changes:

Код:

- bug-fix: incompatibility with plugins using the sampgdk, where callbacks sometimes aren't called
- bug-fix: MySQL client reported 'out of sync' error when using 'CALL' statements
- bug-fix: cosmetic issue with the HTML log

There are currently no downloads available. I'd appreciate it very much if someone could compile it on Debian 6 (i386/i686) with Boost 1.55 or higher and Windows with Visual Studio 2012 with Boost 1.55 or higher (the Boost libraries have to be compiled with the same compiler as the plugin ofc). If nobody volunteers, I'll add these downloads in about a week by myself(don't have the time to do that now).
Thanks to those people reporting the issues and helping me fixing them.

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 08.02.2015

It was commented out on purpose (for Pawno's function list feature). The syntax is

Code:

orm_insert_inline(ORM:ormid, callback, const format_string[], {_, Float}:...);

That means you need to use

Code:

orm_insert_inline(AccountInfo[playerid][ACC_ORM_ID], using inline SetAccountID, "");

And yes, you always need to specify the format string parameter, or else you'll get that error #017.

Re: [REL] MySQL Plugin (Now on github!) - Knappen - 08.02.2015

Quote:

Originally Posted by maddinat0r

It was commented out on purpose (for Pawno's function list feature). The syntax is

Code:

orm_insert_inline(ORM:ormid, callback, const format_string[], {_, Float}:...);

That means you need to use

Code:

orm_insert_inline(AccountInfo[playerid][ACC_ORM_ID], using inline SetAccountID, "");

And yes, you always need to specify the format string parameter, or else you'll get that error #017.

Before removing the comments this is what I got.

Code:

error 017: undefined symbol "orm_insert_inline"

When I removed the comments, I got this, using it the same way you did above, both without the format string parameter and with it (I forgot about that completely though, so thanks for telling me).

Code:

error 035: argument type mismatch (argument 2)

Not sure what is wrong here. I don't have to use inline to get it the way I want it anyway, so it's not a disaster, but it would be nice

EDIT:
This is how I'm trying to use it.

Code:

if(strlen(inputtext) != 0)
{
    inline SetAccountID()
    {
        AccountInfo[playerid][AccountID] = cache_insert_id();
        RegisterEmail(playerid);
    }
    orm_insert_inline(AccountInfo[playerid][ACC_ORM_ID], using inline SetAccountID, "");
}

Re: [REL] MySQL Plugin (Now on github!) - norton2 - 08.02.2015

MYSQL PROBLEM!
Please help me!
http://forum.sa-mp.com/showthread.ph...32#post3364132

Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 08.02.2015

Quote:

Originally Posted by Knappen

Before removing the comments this is what I got.

Code:

error 017: undefined symbol "orm_insert_inline"

When I removed the comments, I got this, using it the same way you did above, both without the format string parameter and with it (I forgot about that completely though, so thanks for telling me).

Code:

error 035: argument type mismatch (argument 2)

Not sure what is wrong here. I don't have to use inline to get it the way I want it anyway, so it's not a disaster, but it would be nice

EDIT:
This is how I'm trying to use it.

Code:

if(strlen(inputtext) != 0)
{
    inline SetAccountID()
    {
        AccountInfo[playerid][AccountID] = cache_insert_id();
        RegisterEmail(playerid);
    }
    orm_insert_inline(AccountInfo[playerid][ACC_ORM_ID], using inline SetAccountID, "");
}

don't edit the plugin include!
take a look at this tutorial; 'orm_insert_inline' works just like that

Re: [REL] MySQL Plugin (Now on github!) - Knappen - 08.02.2015

Quote:

Originally Posted by maddinat0r

don't edit the plugin include!
take a look at this tutorial; 'orm_insert_inline' works just like that

pawn Code:

inline SetAccountID()
{
    AccountInfo[playerid][AccountID] = cache_insert_id();
    RegisterEmail(playerid);
}
orm_insert_inline(AccountInfo[playerid][ACC_ORM_ID], using inline SetAccountID, "");

Code:

error 017: undefined symbol "orm_insert_inline"

As I tried to explain earlier, I get this error. I have not edited the include.

Re: [REL] MySQL Plugin (Now on github!) - Max_Andolini - 08.02.2015

Quote:

Originally Posted by maddinat0r

don't edit the plugin include!
take a look at this tutorial; 'orm_insert_inline' works just like that

How to build mysql r39-3?

Re: [REL] MySQL Plugin (Now on github!) - norton2 - 08.02.2015

MYSQL R33 PROBLEM! Check it: https://sampforum.blast.hk/showthread.php?tid=562434

Re: [REL] MySQL Plugin (Now on github!) - dusk - 10.02.2015

Old plugin, R6 problem.

Quote:

[20:52:25] >> mysql_store_result( Connection handle: 1 )
[20:52:25] CMySQLHandler::StoreResult() - Result was stored.
[20:52:25] >> mysql_num_rows( Connection handle: 1 )
[20:52:25] CMySQLHandler::NumRows() - Returned 1 row(s)
[20:52:25] >> mysql_fetch_row_format( Connection handle: 1 )
[20:52:25] CMySQLHandler::FetchRow() - Result is empty.
[20:52:25] >> mysql_free_result( Connection handle: 1 )
[20:52:25] CMySQLHandler::FreeResult() - Result was successfully free'd.

The server was running just fine for quite some time and then that started. Various queries return 1 or more rows but the result is empty. What could have caused this?

Re: [REL] MySQL Plugin (Now on github!) - norton2 - 10.02.2015

Please, help me with Update MYSQL! https://sampforum.blast.hk/showthread.php?tid=562655

Re: [REL] MySQL Plugin (Now on github!) - ko2 - 16.02.2015

in case of compilation it is impossible to finish up to the end the project, help please. Writes not the unsolved external character to a Visual Studio. error LNK2019

Re: [REL] MySQL Plugin (Now on github!) - Kar - 22.02.2015

Quote:

Originally Posted by Ralfie

Hello, been getting that error recently without a response. Current MYSQL Version: R39-2

debug:

Код:

[CMD] /getinfo James1
[debug] Run time error 8: "Heap underflow"
[debug]  Heap pointer (HEA) is 0x2592C4, heap bottom (HLW) is 0x2592E4
[debug] AMX backtrace:
[debug] #0 0000f6c8 in public Mysql_GetPlayerInfo (playerid=35, index[]=@002592e4 "James1") at D:\Games\Server\gamemodes\Script.pwn:1481

function:

Код:

function Mysql_GetPlayerInfo(playerid, index[])
{
    new string[128];
    if (cache_num_rows() > 0)
    {
        new regdate[30], Lastip[30],
		admlevel, donor, kills, deaths, score, cash, heads, prestige, nuke, airs, tox, capz, laston, timeon;

		cache_get_field_content(0, "RegisterDate", regdate, g_SQL);
		cache_get_field_content(0, "lastip", Lastip, g_SQL);
        admlevel = cache_get_field_content_int(0, "Admin");
        donor = cache_get_field_content_int(0, "Donor");
        kills = cache_get_field_content_int(0, "Kills");
        deaths = cache_get_field_content_int(0, "Deaths");
        score = cache_get_field_content_int(0, "Score");
        cash = cache_get_field_content_int(0, "Money");
        heads = cache_get_field_content_int(0, "Headshots");
        prestige = cache_get_field_content_int(0, "Prestige");
		nuke = cache_get_field_content_int(0, "Nukes"); //thats line 1481
		airs = cache_get_field_content_int(0, "Airstrikes");
		tox = cache_get_field_content_int(0, "Toxins");
		capz = cache_get_field_content_int(0, "CapZones");
		laston = cache_get_field_content_int(0, "Laston");
		timeon = cache_get_field_content_int(0, "TimeOnline");

	 	//display the info.. etc...
    }
    else
    {
		//not reg.. etc..
    }
	return 1;
}

James1's stored info:
http://i.gyazo.com/f46f8fee71ea480e84c4091cffe6adeb.png

Uhh, not sure but please add a length argument to your 'cache_get_field_content' functions

Re: [REL] MySQL Plugin (Now on github!) - iZN - 22.02.2015

Quote:

Originally Posted by Ralfie

Alright, tho its not needed since that isn't an enum. But that didn't fix the problem sadly. Anyone?

show your complete code, along with the command.

Re: [REL] MySQL Plugin (Now on github!) - SiripIkan - 03.03.2015

Does anyone have a compiled R39-3 MySQL plugin for Ubuntu?

Would be grateful if someone could share/compile it..

Re: [REL] MySQL Plugin (Now on github!) - Michalec - 06.03.2015

Does anyone have a problem with queries that aren't executed?

Sometimes queries like this:

Код:

mysql_pquery(mysql, formatEx("DELETE FROM map_vtuning WHERE vehicleuid = '%d'", selling[playerid]));

aren't executed. There is no error/warning. I have all error warnings and I see nothing in logs

Re: [REL] MySQL Plugin (Now on github!) - SimonItaly - 06.03.2015

Enable MySQL debug at its maximum level and post the logs here.

AW: Re: [REL] MySQL Plugin (Now on github!) - Mellnik - 06.03.2015

Quote:

Originally Posted by Michalec

Does anyone have a problem with queries that aren't executed?

Sometimes queries like this:

Код:

mysql_pquery(mysql, formatEx("DELETE FROM map_vtuning WHERE vehicleuid = '%d'", selling[playerid]));

aren't executed. There is no error/warning. I have all error warnings and I see nothing in logs

Just a side note

WRONG:

Код:

DELETE FROM map_vtuning WHERE vehicleuid = '%d'

Correct:

Код:

DELETE FROM `map_vtuning` WHERE `vehicleuid` = %d;

Re: [REL] MySQL Plugin (Now on github!) - Vince - 07.03.2015

Getting a lot of segfaults lately which are apparently always caused by __kernel_vsyscall, whatever that may be. Not at all familiar with C++ so I'm not sure what the actual problem is.

Crashlog