sqlx help
Code:
#include < amxmodx > |
Re: sqlx help
1. You should always show which error you are getting when asking for help. Since you didn't, I need to look at your entire plugin instead of looking for something specific. Enable debug mode in plugins.ini when developing your plugin.
2. Is login the only SQL query you are using ReadInfo() to process? If so then you are ok, if not then you need to do additional work to make it know which transaction you are doing. 3. You are sending a query to get all records from vip_users and then assuming the first one returned is the player you are looking for. You should specify additional conditions in your query to get data for only the player you want. I am not sure what field names you are using, replace 'username' and 'pwd' accordingly. Also, you should be sending steam-id, not name since any player can use any name, you cannot base security off of a name. Untested Code:
|
Re: sqlx help
Have you tried to read the documentary everything there is well explained!
|
Re: sqlx help
I don't think his coding was terribly bad, just the wrong process/flow was used.
|
Re: sqlx help
I've tested bugsy's code but it give me one more problem, it did not retrive the player id in ReadInfo().
debug in console Code:
[VIP SQLx] Forward "client_connect" called |
Re: sqlx help
Not sure, the player id is definitely getting passed.
Try changing PHP Code:
Code:
|
Re: sqlx help
Where are you creating the table ? Show your sql table creation syntax
Also remove your mysql database information.... |
Re: sqlx help
Code:
CREATE TABLE vip_users ( |
Re: sqlx help
Can you provide it with amx code..
I cant help you if you are not providing enough code. #bugsy also it shouldnt kick the user if nothing was found in database. Atleast it should be confirmed that the user is a vip by auth and his password is invalid. |
Re: sqlx help
Quote:
Quote:
And yeah, that was my bad. @OP, try the below PHP Code:
|
| All times are GMT -4. The time now is 07:33. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.