Register in the SQL if not already there?
Well I run a Zombie TS Server. Is there a way to check is a joining player is in the SQL, and if he is not it will add him?
I know it has something to do with this. Code:
new query[256], authid[32] |
Re: Register in the SQL if not already there?
Use:
Code:
INSERT INTO ... VALUES (...) ON DUPLICATE KEY UPDATE ... |
Re: Register in the SQL if not already there?
can you give me an example on how to use it?
|
Re: Register in the SQL if not already there?
Example from harbu's plugins (first thing to come to mind involving mysql and amxx :P)
Code:
"jobs" would be the table "JobID" column, "JobName" column, "Salary" column "Access" column And then you just need to put %i for the amount of columns each database has, then define what you're putting in by listing them in the same order as you inserted them into the tables |
Re: Register in the SQL if not already there?
An example:
Code:
new query[256], authid[32] |
Re: Register in the SQL if not already there?
JCobra: Idiot
On my karma page: Quote:
|
Re: Register in the SQL if not already there?
Quote:
|
Re: Register in the SQL if not already there?
I'm not aware of how the system is actually working, I was just giving an example :wink:
|
| All times are GMT -4. The time now is 22:18. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.