[Include] j_mysql Easiest utilization of MySQL [R7]

[Include] j_mysql Easiest utilization of MySQL [R7] - 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: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+---- Forum: Includes (https://sampforum.blast.hk/forumdisplay.php?fid=83)
+---- Thread: [Include] j_mysql Easiest utilization of MySQL [R7] (/showthread.php?tid=436734)

Pages: 1 2

j_mysql Easiest utilization of MySQL [R7] - JustBored - 12.05.2013

j_mysql

I'im going to present my include that I realised the other day. The idea of this include is to simplify some functions of MySQL to develop better codes. Also the function's are like dini for example MySQL_Float is like Dini_Float.
So, let's continue

Function's:
MySQL_ConnectTo

MySQL_Switch_Table

Change_Row

Table_Rename

Drop_Table

Drop_Column

MySQL_Insert

MySQL_String

MySQL_Float

MySQL_Int

MySQL_Close_All

As you can see the functions are very simple.

Explanation of each function:

MySQL_ConnectTo

Parameters:

Код:

(MySQL_Host[], MySQL_User[], MySQL_Database[], MySQL_Password[], Table[])

The idea of this function is to connect to the database and the table. As you can see it has one more parameter that is 'Table', with this parameter you specify the table you wanna use.
Example:

pawn Код:

public OnGameModeInit()
{
MySQL_ConnectTo("localhost","root", "db", "", "Hello");
return 1;
}

MySQL_Switch_Table

Parameters:

Код:

(table[])

The idea of this function is to switch the table you are working so you can work with lot's of tables.

Example:

pawn Код:

zcmd(ctable, playerid ,params[])
{
if(!sscanf(params, "s[30]", params[0]))
{
MySQL_Switch_Table(params[0]);
new s[64]; format(s, sizeof(s), "You switched to the table: %s", params[0]);
SendClientMessage(playerid, -1, s);
}
return 1;
}

Change_Row

Parameters:

Код:

(row[], torow[], type[], lenght)

row = The name of the row that you want to change.
torow = The name that the row will have.
type = The type of context that the row will have (FLOAT, VARCHAR etc...)
lenght = The lenght that the row will have.

Example:

pawn Код:

SwitchToRow()
{
Change_Row("row1", "row2", "VARCHAR", 30);
mysql_function_query(MySQLInfo[MySQL_Table], "UPDATE `table` SET `fila2` = 'Hi'", false, "OnQueryResponse", "ii", playerid);
return 1;
}

Table_Rename

Parameters:

Код:

(name[], newname[])

Name =The name of the table
newname = The new name of the table.

Example:

pawn Код:

stock SwitchName()
{
Table_Rename("table", "table2");
SetTimer("SwitchName", 60000*30, false);
return 1;
}

Drop_Table

Parameters:

Код:

(tablename[])

tablename = The name of the table that we want to destroy.

Explanation: The idea of this function is to destroy any table that is useful.

Example:

pawn Код:

zcmd(droptable, playerid, params[])
{
if(sscanf(params, "s[64]", params[0])) return SendClientMessage(playerid, -1, "/droptable <name>");
{
Drop_Table(params[0]);
}
return 1;
}

Drop_Column

Parameters:

Код:

(column[])

column = The name of the column.

The idea of this function is to drop any column that is useful.

MySQL_Insert

Parameters:

Код:

(field[],field1[],field2[], field3[], value[],value1[],value2[],value3[])

field = The first field to insert.
field1 = The second one
field2 = The third one
field3 = The last one.

-
value = The first value
value1 = The second value
value2 = The third value
value3 = The forth value.

Nota: All the values in the function are with the formatstring.

Explanation:

The idea of this function is to insert lot's of values. Is very useful for register sistems.

MySQL_String

Parameters:

Код:

(field[], string[])

field = The field where you will insert the string.
string = The text to insert.

The idea of this function is to insert a string in a row.

MySQL_Float

Parameters:

Код:

(field[], Float:float)

field = Where will insert the float.
Float:float = The float to insert.

MySQL_Int

Parameters:

Код:

(field, int)

Field = Where you will insert the integrer.
int = The integrer to input.

MySQL_Close_All

Parameters:

Код:

(N/A)

This function closes all the MySQL connection's. (DB and the console)

Bugs:
N/A

Descarga:

This include uses the R7 MySQL Plugin of BlueG (post) also the a_mysql.inc that comes with the include.

Re: j_mysql Easiest utilization of MySQL [R7] - RajatPawar - 12.05.2013

Is there any checking in MYSQL_switch_table? If the table to be switched, even exists?

Re: j_mysql Easiest utilization of MySQL [R7] - RajatPawar - 12.05.2013

Quote:

Originally Posted by ******

There is not a single check for anything anywhere.

Damn, your MYSQL will seriously be damned to hell if there's, say, a typo. Is this something like...

pawn Код:

my_easier_to_read_function( params )
{
       return mysql_query( params );
}

Re: j_mysql Easiest utilization of MySQL [R7] - RajatPawar - 12.05.2013

Haah! Also, I noticed there are limited arguments in MYSQL_INSERT. Try using getarg and numarg!

Respuesta: j_mysql Easiest utilization of MySQL [R7] - JustBored - 12.05.2013

Ok, i have realised that im very stupid. Or that i shoudnt work during night so i will take off the mediafire link fix the bug's and then post it again. While i was testing those bug's missed up, so thank's for the comments to show me my errors so i can improve.
I will put this in spanish, because it's difficult to me to say it in english.
Tampoco para tanto descanso flaco, fuera de joda. Esta bien, vos sos el terrible programador pero corte tampoco para cagarse en los demбs porque tipo yo ando aprendiendo. Recuerden que nadie nace sabiendo.

Re: j_mysql Easiest utilization of MySQL [R7] - richardcor91 - 13.05.2013

Truly disappointed at Rajat_Pawar and ******. This guy put his effort on creating something to help other people and what you do? Make fun of him - such a nice attitude from a 1896 repped guy! It's because of people like you that many talents will never be found. Nice work, really nice work...

Look at the spanish version of this script: https://sampforum.blast.hk/showthread.php?tid=435894 - maybe they are all noob scripters, but at least there's respect.

Re: j_mysql Easiest utilization of MySQL [R7] - Y_Less - 13.05.2013

Which is it? Are my posts bad or good?

Quote: