Raised This Month: $ Target: $400
 0% 

MySQL problem


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Nextra
Veteran Member
Join Date: Apr 2008
Location: Germany
Old 08-11-2014 , 22:31   Re: MySQL problem
Reply With Quote #1

While this is still missing code pieces (register_client) we have somewhere to start.
  • Use the client_authorized forward instead of client_putinserver. You are not guaranteed to have the SteamID available when client_putinserver fires
  • Related to the above you're not actually verifying you have a valid steamid on your hands.
  • You're using threaded queries but you're doing nothing to prevent data races. You need to ensure that you can't have two setup processes running for the same client id.
__________________
In Flames we trust!
Nextra is offline
skz
Senior Member
Join Date: Jul 2014
Location: Portugal
Old 08-11-2014 , 23:31   Re: MySQL problem
Reply With Quote #2

Quote:
Originally Posted by Nextra View Post
While this is still missing code pieces (register_client) we have somewhere to start.
  • Use the client_authorized forward instead of client_putinserver. You are not guaranteed to have the SteamID available when client_putinserver fires
  • Related to the above you're not actually verifying you have a valid steamid on your hands.
  • You're using threaded queries but you're doing nothing to prevent data races. You need to ensure that you can't have two setup processes running for the same client id.
[*] Changed client_putinserver to client_authorized[*] My server is Steam only[*] I prevented it in the database

I think that already solved the problem, but thanks anyway!
__________________

Last edited by skz; 08-11-2014 at 23:37.
skz is offline
HamletEagle
AMX Mod X Plugin Approver
Join Date: Sep 2013
Location: Romania
Old 08-12-2014 , 05:05   Re: MySQL problem
Reply With Quote #3

Quote:
Originally Posted by skz View Post
[*] Changed client_putinserver to client_authorized[*] My server is Steam only[*] I prevented it in the database

I think that already solved the problem, but thanks anyway!
The, post the solution.
__________________
HamletEagle is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 13:17.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode