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

Which one?
Reply
#22

Quote:
Originally Posted by Yaheli
Quote:
Originally Posted by Rafay
OMG! A ready made php script! :O
Respect man! thx

EDIT: FFS, I cant see the download button --..--
It isn't exactly a ready made php script, theres lots of work to do... (Which I am having trouble understanding )
Why isn't it ready ? It's just a PHP Class script which lists the user in your database.

You just have to edit the PHP file with your MySQL settings and the rest is done by the script.
Reply
#23

Any progress with update? I dont know wait to do, start rewriting or wait.. Because mysql_get_field is needed for me
Reply
#24

I want to create stuff with mysql in samp but I am having some sort of difficulties.. When there was only 1 release I knew which one to pick.. Now there are 2, I want to know which one is kinda " better" or just better in use. Has anyone tried both or is one missing features that the other does have? What are the differences between the two?

Thank you for your answer.
Reply
#25

Quote:
Originally Posted by [NT
SpeedDevil ]
I want to create stuff with mysql in samp but I am having some sort of difficulties.. When there was only 1 release I knew which one to pick.. Now there are 2, I want to know which one is kinda " better" or just better in use. Has anyone tried both or is one missing features that the other does have? What are the differences between the two?

Thank you for your answer.
This plugin has the most features, and it has some features that are really needed for good MySQL usage.
Reply
#26

Quote:
Originally Posted by JaTochNietDan
Quote:
Originally Posted by [NT
SpeedDevil ]
I want to create stuff with mysql in samp but I am having some sort of difficulties.. When there was only 1 release I knew which one to pick.. Now there are 2, I want to know which one is kinda " better" or just better in use. Has anyone tried both or is one missing features that the other does have? What are the differences between the two?

Thank you for your answer.
This plugin has the most features, and it has some features that are really needed for good MySQL usage.
Thank you for your answer
Reply
#27

Does mysql_fetch_row works for you? My app crashes...
Reply
#28

Quote:
Originally Posted by Balon
Does mysql_fetch_row works for you? My app crashes...
You probably forgot to store the result before fetching it (mysql_store_result).That can be the reason why it's crashing.

I'm actually in progress of fixing/changing some codes in the plugin.Also there will be a new function.
Reply
#29

Quote:
Originally Posted by Balon
Does mysql_fetch_row works for you? My app crashes...
This is because the plugin fetches all rows and puts them into the destination string... I had this problem too.

I modified the code and recompiled it and it's working like a charm now. I also told G-sTyLeZzZ about this
Reply
#30

Hello,

Can anyone tell me how can i adapt this plugin to Moderntopia mode ?

Thanks.
Reply
#31

Well done. Thank you
Reply
#32

Im using this! Much better than Adrenaline's in my opinion
Reply
#33

Hello!

I am working with the mysql plugin about 2 month and all works propper...
very nice plugin...

But now i have a question:

I tryed to "SELECT" a big textfield wich looks as follows:
Quote:

-1888.497924 2351.416015 44.182319
-1830.171264 2149.027587 7.378968
-1796.878540 1961.018310 13.725134
-1624.130126 1832.773559 25.971170
-1470.333374 1864.461059 32.760047
-1217.600952 1862.470703 40.951419
-1366.323242 2069.301513 52.560791
-1491.514160 2124.633789 45.943695
-1570.990112 2363.474365 45.206783
-1604.511962 2412.854980 57.160617
-1583.355102 2665.837646 55.768142
-1386.664916 2662.071533 54.782497
-1350.458251 2639.857421 51.239830
-1432.048583 2476.580810 61.434547
-1343.328247 2112.560791 49.099498
-1237.174926 1924.353027 42.981281
-1191.470581 2086.954833 81.717735
-1061.215087 2171.636474 87.593864
-1115.935424 2537.725585 78.881935
-1328.035034 2677.651367 50.189884
-1469.332397 2733.254638 66.032020
-1631.955444 2683.499511 54.884082
-1685.495361 2319.883300 29.533054
-1809.873779 2107.407958 8.478769
-1775.883911 1883.135253 17.222122
-1691.246582 1839.088745 25.017160
-1636.222778 1999.730224 18.440067
-1471.177001 1808.922729 33.667186
-1238.103149 1712.124389 17.409736
-1407.968627 1740.686889 17.115995
-1649.179077 1775.004638 16.145021
-1650.608642 1829.575805 25.974847
-905.935729 1688.650634 27.407464
-842.433044 1618.173461 27.087383
-708.259033 1611.997070 24.959257
-627.987670 1514.182250 31.235168
-689.386596 1456.369750 17.507287
-805.336303 1436.179443 13.916443
0.0 0.0 0.0

Is it possible to read out such big fields?

The samp allways chrashing after the mysql query...

Maybe the sql-plugin cannot handle such big textfields?

Reply
#34

will the linux one work with debian?
Reply
#35

It should work, if not, just recompile the source!
Reply
#36

Quote:
Originally Posted by ledzep
Quote:

Returns true (1) if the connection is still alive, else (-1)

So this shouldn't return 0? According to debug mode, it returns 0 sometimes.
Well, I've set it to (-1) for testing purposes and forgot to set it back to 0.You can just make your own Ping function.

pawn Код:
ping_mysql()
{
  if(mysql_ping() != 1)
  {
    return 0;
  }
  else return 1;
}
Quote:
Originally Posted by Hutzelbutzel
Error:
http://img3.imagebanana.com/img/7omqr9ub/error.png

Code:
http://img3.imagebanana.com/img/i28g55c5/error2.png



I could not make the errors, because this is the examplescript.
Have I included something wrong ??
That's because you are not using Pawno from the default server package.Your compiler is probably not accepting this format so, here you go:

pawn Код:
format(query,sizeof query,"INSERT INTO `%s` (Username,Password) VALUES ('%s',md5('%s'))",TABLENAME,pName,pass);
Quote:
Originally Posted by high_d
Hello!

I am working with the mysql plugin about 2 month and all works propper...
very nice plugin...

But now i have a question:

I tryed to "SELECT" a big textfield wich looks as follows:
Quote:

[...]

Is it possible to read out such big fields?

The samp allways chrashing after the mysql query...

Maybe the sql-plugin cannot handle such big textfields?
The plugin can handle values up to 1200 cells, otherwise it crashes like you said.If you want more, just search for "MAX_ROW_LENGTH" in the main header file and change it to your value => recompile.
Reply
#37

The server crash when debug is on and a query larger than 245 bytes is sent.
Except for that it seems to be working flawless, well done!
Reply
#38

nice one G
Reply
#39

Quote:
Originally Posted by Slice
The server crash when debug is on and a query larger than 245 bytes is sent.
Except for that it seems to be working flawless, well done!
It also sends very odd characters when debugging some "SELECT" query's. Other than debug, this mySQL works perfect.
Reply
#40

good job
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)