Raised This Month: $12 Target: $400
 3% 

Inconsistent Plug-in sending to SQL


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Jassy55
New Member
Join Date: Jan 2022
Old 01-08-2022 , 00:15   Inconsistent Plug-in sending to SQL
Reply With Quote #1

I have a plugin that gets data from L4D2 and sends to an SQL database.

It gets the players steamid scores map starttime and team.

The plug-in is very inconsistent, sometimes it uploads the 8 required rows but then sometimes it will do 4 or 6 or 7 ect.


any help with the code which may be causing this would be apprecaited

Last edited by Jassy55; 01-11-2022 at 07:13. Reason: Restore to previous version.
Jassy55 is offline
Sarrus
Member
Join Date: May 2020
Location: France
Old 01-11-2022 , 05:57   Re: Inconsistent Plug-in sending to SQL
Reply With Quote #2

You should use SQL_FastQuery instead of a SQL_Query.

To address your issue, adapt the snippet here to your code, in order to print an error if your query fails. You can also try to access your database's log (if you can) to see where an error might happen.
__________________
Discord Coding Server | Steam Profile | Community Website | Github Profile

Taking paid requests (add me on Discord)
Sarrus is offline
Bacardi
Veteran Member
Join Date: Jan 2010
Location: mom's basement
Old 01-11-2022 , 07:21   Re: Inconsistent Plug-in sending to SQL
Reply With Quote #3

Is Jaylow your twin brother ?
Quote:
Originally Posted by Jassy55 View Post
I have a plugin that gets data from L4D2 and sends to an SQL database.

It gets the players steamid scores map starttime and team.

The plug-in is very inconsistent, sometimes it uploads the 8 required rows but then sometimes it will do 4 or 6 or 7 ect.


any help with the code which may be causing this would be apprecaited
Quote:
Originally Posted by Jaylow View Post
Is there anyway to keep the client team index the same through the campaign so everymap it doesnt change?

i have a L4D2 plugin which gets team, starttime, map, players and scores and i am displaying it but because the team client index is constantly changing it is not displaying correctly.
Quote:
Originally Posted by Jaylow View Post
Hi all.

So I have a plug in which gets data from the game and sends it to a database .

So I have put in test logs to see where the problem is and I can’t seem to figure it out.

I have it linked to readyup.smx so at the start of every round after the countdown timer it gets all 8 players on either survivor or infected, it stores that along with map, time, team player is on and score of the map.

It seems to be getting the correct players on survivor and infected but it is constantly stopping after getting 4,6,7 players and sometimes 8. It won’t ever get the full amount of players . I do have IsClientConneted but it seems to be breaking before getting the 8 players needed, it seems to be coming from the IsClientConnected break but without it I get errors of the server saying client 2 not connected ect .

Any help would be much appreciated
...
__________________
Do not Private Message @me
Bacardi is offline
Reply


Thread Tools
Display Modes

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 16:12.


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