[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 (****** Project) - caoraivoso3 - 18.07.2013

can you give me the link of some place where i can see the functions of this plugins, the plugin with threaded queries?

thanks ppl

Re: [REL] MySQL Plugin (****** Project) - Edvin - 18.07.2013

Quote:

Originally Posted by caoraivoso3

can you give me the link of some place where i can see the functions of this plugins, the plugin with threaded queries?

thanks ppl

For the beginners (like in your case):
https://sampforum.blast.hk/showthread.php?tid=337810

Re: [REL] MySQL Plugin (****** Project) - caoraivoso3 - 18.07.2013

Quote:

Originally Posted by Edvin

For the beginners (like in your case):
https://sampforum.blast.hk/showthread.php?tid=337810

thanks i gonna read it

another problem i get:
if(mysql_errno(handle)) print("MySQL connection is still alive!");
mysql_function_query("CREATE TABLE IF NOT EXISTS ґusersґ(Pnome VARCHAR(24), pSenha VARCHAR(41), pNivel INT(20), pSkin INT(20) )");

well i need some function to replace mysql_function_query. any ideias? that function doesn't work.

Re: [REL] MySQL Plugin (****** Project) - Kyle - 18.07.2013

Can anyone provide a static version for windows for R30.

Thanks

Re: [REL] MySQL Plugin (****** Project) - caoraivoso3 - 18.07.2013

another problem i have and i search all over the place but i don't get any solution for this.

Re: [REL] MySQL Plugin (****** Project) - Scenario - 18.07.2013

Quote:

Originally Posted by caoraivoso3

thanks but what are the best kind of queries? threaded or unthreaded cuz i don't know nothing about mysql.

If you don't know anything about MySQL, you shouldn't really be using it yet. You need to go read up a bit on how to use it properly, and the different types of queries you can perform.

AW: Re: [REL] MySQL Plugin (****** Project) - maddinat0r - 18.07.2013

Quote:

Originally Posted by KyleSmith

Can anyone provide a static version for windows for R30.

Thanks

There is only one (1) library which you need: libmysql.dll. There is really no need for a static version.

Quote:

Originally Posted by caoraivoso3

another problem i have and i search all over the place but i don't get any solution for this.

Install the Microsoft Visual C++ 2012 32bit redistributables.

EDIT:
It's so quiet here. Has R31 no bugs or what?

Re: [REL] MySQL Plugin (****** Project) - caoraivoso3 - 18.07.2013

sorry to make a lot of posts here but i have another qustion:
mysql_function_query(g_Handle, "CREATE TABLE IF NOT EXISTS `users` (nome VARCHAR(24), id INT(11), email VARCHAR(12

, IsAdmin INT(1)", false, "", "");

g_Handle = connection
i put this ongamemodeinit and that shit just don't work i think i do all the code right, it should create a tabel in the database.

Re: [REL] MySQL Plugin (****** Project) - RaZVaN ^ xD - 18.07.2013

You forgot a ')' at the end of query

Re: [REL] MySQL Plugin (****** Project) - caoraivoso3 - 18.07.2013

can you explain?
mysql_function_query(g_Handle, "CREATE TABLE IF NOT EXISTS `users` (nome VARCHAR(24), id INT(11), email VARCHAR(12, IsAdmin INT(1)", false, "", ""));

like this? that doesn't work i don't see where i miss the )

AW: [REL] MySQL Plugin (****** Project) - Mellnik - 18.07.2013

At the very end.

Re: [REL] MySQL Plugin (****** Project) - caoraivoso3 - 18.07.2013

I still can't figure it out if i do that the compiler say that i should use ; instead ).

Re: [REL] MySQL Plugin (****** Project) - Scenario - 18.07.2013

Add a closing parenthesis, ), at the end of the QUERY, not the line of code (in between the quotations).

Re: [REL] MySQL Plugin (****** Project) - caoraivoso3 - 18.07.2013

like this?
mysql_function_query(g_Handle, "CREATE TABLE IF NOT EXISTS `users` )(nome VARCHAR(24), id INT(11), email VARCHAR(12

, IsAdmin INT(2)", false, "", "");

that doesn't work proprely de tabel isn't created

AW: Re: [REL] MySQL Plugin (****** Project) - maddinat0r - 18.07.2013

Quote:

Originally Posted by caoraivoso3

like this?
mysql_function_query(g_Handle, "CREATE TABLE IF NOT EXISTS `users` )(nome VARCHAR(24), id INT(11), email VARCHAR(12

, IsAdmin INT(2)", false, "", "");

that doesn't work proprely de tabel isn't created

Holy macarena.

PHP код:



mysql_function_query(g_Handle, "CREATE TABLE IF NOT EXISTS `users`(nome VARCHAR(24), id INT(11), email VARCHAR(128), IsAdmin INT(2))", false, "", "");

Re: [REL] MySQL Plugin (****** Project) - caoraivoso3 - 18.07.2013

thanks dude you help me, i wasn't understanding what people are saying. sorry i am a little dumb ahaha

Re: [REL] MySQL Plugin (****** Project) - Scenario - 18.07.2013

Ya' don't say..

Re: [REL] MySQL Plugin (****** Project) - iJumbo - 19.07.2013

Changelog is on R32 and download on R31 ? or R32 is not released? XD

Re: [REL] MySQL Plugin (****** Project) - -Prodigy- - 21.07.2013

How do you get the plugin running? I'm using latest version from the repository. Sorry if I missed something, first time testing the latest version.

Trying to test windows version.. when I start the server the plugin doesn't load.

AW: Re: [REL] MySQL Plugin (****** Project) - maddinat0r - 21.07.2013

Quote:

Originally Posted by B-Matt

pawn Код:

[ERROR] mysql_escape_string - destination size is too small

Maybe to put string which is the cause of the error? Something like this:

pawn Код:

[ERROR] mysql_escape_string ("Bla bla bla") - destination size is too small

This could be helpful in debugging the errors.

Good idea, I'll change that in every native.

Quote:

Originally Posted by HitnKill

I have an idea for don't change all my script with this vR7 MYSQL.

Example my old function

PHP код:



R6


if(IPBanned(plrip) > 0)

{

  // code....

}


IPBanned(ip[])

{

    new query[100],ipexist;

    format(query,sizeof(query),"SELECT IP FROM `dm_bans` WHERE IP = '%s' LIMIT 1",ip);

    mysql_query(query);

    mysql_store_result();

    new rows = mysql_num_rows();

    if(rows > 0) ipexist = 1;

    else ipexist = 0;

    mysql_free_result();

     return ipexist;

}

PHP код:



R7


if(IPBanned(plrip,0) > 0)

{

   // code...

}


forward IPBanned(ip[],ID);

public IPBanned(ip[],ID)

{

    if(ID == 0)

    {

        new query[100];

        format(query,sizeof(query),"SELECT IP FROM `dm_bans` WHERE IP = '%s' LIMIT 1",ip);

        mysql_function_query(ConnexionBDD, query, true, "IPBanned", "si",ip,1);

    }

    else

    {

        new rows,fields,ipexist;

        cache_get_data(rows, fields);

        if(rows > 0) ipexist = 1;

        else ipexist = 0;

         return ipexist;

     }

     return 0;

}

Don't problem with this codes on R7 if i call a same function?

This won't work. The upgrade from threaded to unthreaded queries require sometimes a system design change in the gamemode. You could for example load all the data you need with one query (with a JOIN statement) and then if there is some data use the data and ask the player for a login, and if there is no data ask the player to register.

Quote:

Originally Posted by Lorenc_

I like the errno function! Better than the callback style to the least!

Anyway, just documentation perhaps & this is perfect.

I'll need someone with a Wiki account.

EDIT:

Quote:

Originally Posted by -Prodigy-

How do you get the plugin running? I'm using latest version from the repository. Sorry if I missed something, first time testing the latest version.

Trying to test windows version.. when I start the server the plugin doesn't load.

Are you trying to compile it by yourself? Or did you just use the latest download?
What OS are you using? (XP, 7, 8?)