[Alucard^]

Originally Posted by katna why should i use my sql instead of nvault, is it better?

As far as i know is more faster than nvault and others files systems... and also you can combine mysql with others systems like with forum or others.

[grimvh2]

The only thing nvault could be usefull for is a few data to save. nVault is slower and when u get to much data in, ur server will lag. Mysql doesnt cause lag ( when its done good ). Can handle much more data and can be used for websites ( online top 15 or w/e ).

[Nextra]

The MySQL data storing and retrieving functions are much more powerful than those of nVault. For basic data storing this does not make that much of a difference, though. That's why MySQL tutorials are sometimes problematic. MySQL is so powerful that you can not cover all of it. If someone plans to use MySQL he will often have to find more sources and really learn the syntax of MySQL queries. Imho it would be much more helpful to provide a set of stocks that would make MySQL as easy to use as nVault.

A huge difference is that a real MySQL database (not SQLite) is entirely seperate from the server itself. Handling huge data structures can cause problems with nVault while MySQL, especially when you use threaded querying, will not use any resources of the server.

Another nice thing is, that you can often make your plugin compatible with MySQL and SQLite at the same time. That way the user can use an external database, necessary for integration into actual websites, but also fall back to local server-storage if no MySQL database is at hand.


Suggestions for the tutorial:
- I believe that the tuple variable is not updated by SQL_Connect so you don't need to check it everytime but should after the SQL_MakeDbTuple call instead.
- You can remove most SQL_Connect calls anyway. This is not necessary for threaded querying.
- In the save function you don't use the name of the user. You should remove the variable and the get_user_name call.
- However, if you plan to use the name, you should cover string escaping aswell.
- Use formatex where applicable (read: everywhere in this tutorial).
- Think about statics and a global query buffer.
- Any reason to delay MySQL_Init for that long?

That's all I can see right now.

[grimvh2]

Originally Posted by Nextra The MySQL data storing and retrieving functions are much more powerful than those of nVault. For basic data storing this does not make that much of a difference, though. That's why MySQL tutorials are sometimes problematic. MySQL is so powerful that you can not cover all of it. If someone plans to use MySQL he will often have to find more sources and really learn the syntax of MySQL queries. Imho it would be much more helpful to provide a set of stocks that would make MySQL as easy to use as nVault. A huge difference is that a real MySQL database (not SQLite) is entirely seperate from the server itself. Handling huge data structures can cause problems with nVault while MySQL, especially when you use threaded querying, will not use any resources of the server. Another nice thing is, that you can often make your plugin compatible with MySQL and SQLite at the same time. That way the user can use an external database, necessary for integration into actual websites, but also fall back to local server-storage if no MySQL database is at hand. Suggestions for the tutorial: - I believe that the tuple variable is not updated by SQL_Connect so you don't need to check it everytime but should after the SQL_MakeDbTuple call instead. - You can remove most SQL_Connect calls anyway. This is not necessary for threaded querying. - In the save function you don't use the name of the user. You should remove the variable and the get_user_name call. - However, if you plan to use the name, you should cover string escaping aswell. - Use formatex where applicable (read: everywhere in this tutorial). - Think about statics and a global query buffer. - Any reason to delay MySQL_Init for that long? That's all I can see right now.

Thx for the advice.

What do you mean with a global query buffer?

[Nextra]

Just like you use a global variable to store errors you can use a global variable to store the queries you are formatting. There's no reason to create a new 512 variable everytime you need to make a query.

[GuessWhat]

how do i get an sql server? what is hostname, pass ,db ? cause i got a plugin fail to load

[FEELiFE]

How can I get the XP of a player and add a prefix before the player's name based on the XP? (prefix in chat messages)

[Exolent[jNr]]

Originally Posted by GuessWhat how do i get an sql server? what is hostname, pass ,db ? cause i got a plugin fail to load

You have to get one with web hosting. Find a website that has free SQL databases or rent web hosting that has one.

[GuessWhat]

how i can update many field at the same time?
i have a database which contain steamid, goals, exp, points, exp, level, rank and so on. how can i update them all at once?

new goals[33]
new iExp[33]
new points[33]
new level[33]
new rank[33]
...
...
...
  format(szTemp,charsmax(szTemp),"UPDATE `tutorial` SET `exp` = '%i' WHERE `tutorial`.`steamid` = '%s';",iExp[id], szSteamId)

[grimvh2]

PHP Code:

 format(szTemp,charsmax(szTemp),"UPDATE `tutorial` SET `exp` = '%i', `otherthing` = '%i', `astring` = '%s' WHERE `tutorial`.`steamid` = '%s';",iExp[id], otherthing[id], string[id] szSteamId) 


Get it?