[Max_Andolini]

Quote:

Originally Posted by morris91 Im trying to make it so on attachment edit, it adds the floats etc.. to the row that correctly corresponds to the Username & Slot. Код: public OnPlayerEditAttachedObject(playerid, response, index, modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ) { new handle = SQL::OpenEx(SQL::UPDATE2, ""ATTACHMENTS"", "Username", pNick(playerid), "Slot", index); Getting a argument 6 so guessing im missing something out. Anyone can help? il be greatfull

public OnPlayerEditAttachedObject(playerid, response, index, modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ)
{
new handle = SQL::OpenEx(SQL::UPDATE2, ""ATTACHMENTS"", "Username", pNick(playerid), "Slot", index);

Change This

new handle = SQL::OpenEx(SQL::UPDATE2, "ATTACHMENTS", "Username", pNick(playerid), "Slot", index);

[morris91]

Quote:

Originally Posted by eco1999 public OnPlayerEditAttachedObject(playerid, response, index, modelid, boneid, Float:fOffsetX, Float:fOffsetY, Float:fOffsetZ, Float:fRotX, Float:fRotY, Float:fRotZ, Float:fScaleX, Float:fScaleY, Float:fScaleZ) { new handle = SQL::OpenEx(SQL::UPDATE2, ""ATTACHMENTS"", "Username", pNick(playerid), "Slot", index); Change This new handle = SQL::OpenEx(SQL::UPDATE2, "ATTACHMENTS", "Username", pNick(playerid), "Slot", index);

i Use
#define ATTACHMENTS "Attachments"

Just ease of mind, i did try just "Attachments" but still get the error.

[Max_Andolini]

Quote:

Originally Posted by morris91 i Use #define ATTACHMENTS "Attachments" Just ease of mind, i did try just "Attachments" but still get the error.

Use this;

new handle = SQL::OpenEx(SQL::UPDATE2, ""ATTACHMENTS"", "Username", pNick(playerid), "Slot", "", index);

[F1N4L]

Quote:

Originally Posted by eco1999 Use this; new handle = SQL::OpenEx(SQL::UPDATE2, ""ATTACHMENTS"", "Username", pNick(playerid), "Slot", "", index);

Or

Код:

new handle = SQL::OpenEx(SQL::UPDATE2, ATTACHMENTS, "Username", pNick(playerid), "Slot", "", index);

[morris91]

Quote:

Originally Posted by eco1999 Use this; new handle = SQL::OpenEx(SQL::UPDATE2, ""ATTACHMENTS"", "Username", pNick(playerid), "Slot", "", index);

That worked. thanks

[Max_Andolini]

3.3 version updated.

[vernz]

How do you delete a row from the db houses by example ?

[GeneralAref]

Is it possible to create 2 or 3 connections and work with them at the same time?

[Max_Andolini]

Quote:

Originally Posted by GeneralAref Is it possible to create 2 or 3 connections and work with them at the same time?

Maybe later.

[Zoie]

I don't know how to fix the string in the MySQL database with SQL:: WriteString write a garbled code, can you give me an example?

[Max_Andolini]

Updated version 3.4

- Bug fix.

Compatible MySQL version R41-4.

[RowdyrideR]

Error

Код:

invalid function or declaration

??

[Max_Andolini]

Quote:

Originally Posted by RowdyrideR Error Код: invalid function or declaration ??

Line?

[RowdyrideR]

Almost every line in that registration example

[ThePhenix]

Try downloading the latest version.

[RowdyrideR]

R41-4 Plugin

Код:

C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(7) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(21) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(25) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(28) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(30) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(36) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(38) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(40) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(42) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(45) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(47) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(52) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(58) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(63) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(66) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(69) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(71) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(73) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(76) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(78) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(80) : error 075: input line too long (after substitutions)
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(85) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(88) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(90) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(92) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(95) : error 010: invalid function or declaration

[ThePhenix]

Are you sure you're using the latest version? I mean the errors don't really make sense at all.

Code: https://github.com/ThreeKingz/easy-m...easy-mysql.inc

I don't get any errors when compiling, what code are you using, post it here...

[RowdyrideR]

im sorry it was a problem with the include itself, i was on my way to remove my comment

Thanks..

[JR_Junior]

The following code is not working:

PHP код:

    new string[128], names[24],money;
    new handle = SQL::OpenEx(SQL::MREAD, "Accounts", "Money", "", "", "", -1, 10, -1, "Money");
    SQL::ReadRetrievedRows(handle, i)
    {
        SQL::ReadString(handle, "AccountName", names, 24, i);
        SQL::ReadInt(handle, "Money", money, i);
        format(string, sizeof(string), "Name %s | Money: %d", names,money);
        SendClientMessage(playerid, -1, string);
    }
    SQL::Close(handle); 


Accounts in DB: 7

In the Mysql log:

PHP код:

[13:42:36] [DEBUG] mysql_query(1, "SELECT * FROM `Accounts` WHERE `Money`='' ORDER BY `Money` DESC LIMIT 10 ", 1)
[13:42:36] [DEBUG] CHandle::Execute(this=0x4f8c170, type=3, query=0x6705fd0)
[13:42:36] [DEBUG] CConnection::Execute(query=0x6705fd0, this=0x674f80, connection=0x4fa5968)
[13:42:36] [DEBUG] CQuery::Execute(this=0x6705fd0, connection=0x4fa5968)
[13:42:36] [INFO] query "SELECT * FROM `Accounts` WHERE `Money`='' ORDER BY `Money` DESC LIMIT 10 " successfully executed within 0.616 milliseconds
[13:42:36] [DEBUG] CResultSet::Create(connection=0x4fa5968, query_str='SELECT * FROM `Accounts` WHERE `Money`='' ORDER BY `Money` DESC LIMIT 10 ')
[13:42:36] [DEBUG] created new resultset '0x6710788'
[13:42:36] [DEBUG] fetched MySQL result '0x66f8990'
[13:42:36] [DEBUG] allocated 0 bytes for PAWN result
[13:42:36] [DEBUG] CHandle::Execute - return value: true
[13:42:36] [DEBUG] mysql_query: return value: '1'
[13:42:36] [DEBUG] cache_is_valid(1)
[13:42:36] [DEBUG] cache_is_valid: return value: 'true'
[13:42:36] [DEBUG] cache_get_row_count(0x05FFF1E0)
[13:42:36] [DEBUG] cache_get_row_count: return value: '1'
[13:42:36] [DEBUG] cache_get_row_count(0x05FFF1D8)
[13:42:36] [DEBUG] cache_get_row_count: return value: '1'
[13:42:36] [DEBUG] cache_is_valid(1)
[13:42:36] [DEBUG] cache_is_valid: return value: 'true'
[13:42:36] [DEBUG] cache_delete(1)
[13:42:36] [DEBUG] cache_delete: return value: '1' 


Tried too: new handle = SQL::Open(SQL::MREAD, "Accounts", "Money", -1, "", -1, "", -1, -1, "Money");

But no data in chat!

[Private200]

Even if old, I believe my MySQL include is easier to be understood and used: https://sampforum.blast.hk/showthread.php?tid=609990