Burgershot
  • Home
  • Members
  • Team
  • Help
  • Search
  • Register
  • Login
  • Home
  • Members
  • Help
  • Search
Burgershot SA-MP Pawn Scripting [Pawn] MySQL Question

 
  • 0 Vote(s) - 0 Average
Pawn MySQL Question
kalEd
Offline

Burgershot Member
Posts: 7
Threads: 3
Joined: Mar 2021
Reputation: 0
#1
2021-03-08, 02:34 PM
What is the most efficient and optimized method to save data in the database?

For example this?:
Code:
new gQuery[ 256 ]; //at the beginning of the gamemode
//in a function=>
gQuery[ 0 ] = EOS;
mysql_format( handle, gQuery, sizeof gQuery, "INSERT INTO `logs` (`Player`, `IP`) VALUES ('%e', '%s')", getName( playerid ), getPlayerIp( playerid ) );
mysql_tquery( handle, gQuery, "", "" );

or this?:
Code:
new Query[ 90 ];
mysql_format( handle, Query, sizeof Query, "INSERT INTO `logs` (`Player`, `IP`) VALUES ('%e', '%s')", getName( playerid ), getPlayerIp( playerid ) );
mysql_tquery( handle, Query, "", "" );

What exactly does gQuery[0] = EOS; mean? What's the difference?
« Next Oldest | Next Newest »



Messages In This Thread
MySQL Question - by kalEd - 2021-03-08, 02:34 PM
RE: MySQL Question - by Virsenas - 2021-03-08, 02:44 PM
RE: MySQL Question - by Kwarde - 2021-03-08, 07:29 PM
RE: MySQL Question - by Y_Less - 2021-03-08, 07:57 PM
RE: MySQL Question - by kalEd - 2021-03-09, 10:28 AM

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Burgershot - Powered by our Community and MyBB Original Theme by Emerald

Linear Mode
Threaded Mode