| Welcome, Guest |
You have to register before you can post on our site.
|
| Forum Statistics |
» Members: 7,519
» Latest member: ysldeniss
» Forum threads: 2,415
» Forum posts: 12,367
Full Statistics
|
| Online Users |
There are currently 575 online users.
» 0 Member(s) | 572 Guest(s)
Bing, Google, Applebot
|
|
|
Best Practices for MySQL Native Functions? |
|
Posted by: dr.iyz - 2024-02-03, 04:09 AM - Forum: Pawn Scripting
- Replies (1)
|
 |
I'm using BlueG's MySQL plugin version R41-4 and MySQL 8.0.35 on my Ubuntu 22.04.
Every hour, the RAM usage of my mysqld process slowly increases. I have running queries every minute to update business earnings, and at this point, I assume that the problem is due to these minute-by-minute updates.
So, my question is, what is the best MySQL native function for this case? Currently, I'm using mysql_query to update every minute.
Honestly, I also use mysql_query for all queries in my script, and I'm unsure when to use mysql_tquery or mysql_pquery.
I'm also curious about why the RAM usage of my mysqld process always increases?
|
|
|
|
| Help crash |
|
Posted by: nbx2000 - 2024-02-02, 05:46 AM - Forum: Pawn Scripting
- Replies (1)
|
 |
i am having problems with this function. crashdetect flagged this for me
[debug] AMX backtrace:
[debug] #0 00002774 in ?? (4016892) in XAF.amx
[debug] #1 00002dd4 in ?? (0, 4016892, 5000, 3) in XAF.amx
[debug] #2 001e3734 in public Timer1minute (0) in XAF.amx
Code: ptask Timer1minute[60000](i) {
if (JugadorInfo[i][zLogueado] == true) {
// Verifica si el jugador quiere ver los textos
if (JugadorInfo[i][zVerTextos][1] == 1) {
ServerInfo[AnuncioTextoCmds]++;
if (ServerInfo[AnuncioTextoCmds] == 3) ServerInfo[AnuncioTextoCmds] = 1;
switch (ServerInfo[AnuncioTextoCmds]) {
case 1: PlayerTextDrawSetString(i, InfoDeCmds, "");
case 2: PlayerTextDrawSetString(i, InfoDeCmds, "");
case 3: PlayerTextDrawSetString(i, InfoDeCmds, "");
}
PlayerTextDrawShow(i, InfoDeCmds);
}
// Incrementa el tiempo del jugador
JugadorInfo[i][zMiTiempo]++;
JugadorInfo[i][zTimeMiRango]++;
// Actualiza la base de datos con el nuevo tiempo
static Query[180];
format(Query, sizeof(Query), "UPDATE `USERS` SET TIEMPO = '%d', TRG = '%d' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zMiTiempo], JugadorInfo[i][zTimeMiRango], JugadorInfo[i][zMiID]);
db_query(ZLDB, Query);
// Verifica las caducidades para el VIP y el rango
VerificarCaducidadVip(i);
VerificarCaducidadRango(i);
// Incrementa el tiempo del staff si es administrador
if (JugadorInfo[i][zAdmin] > 0 && JugadorInfo[i][zAfk] < 3) {
JugadorInfo[i][zTiempoStaff]++;
static Query2[150];
format(Query2, sizeof(Query2), "UPDATE `USERS` SET TIMESTAFF = '%d' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zTiempoStaff], JugadorInfo[i][zMiID]);
db_query(ZLDB, Query2);
}
// Incrementa el tiempo de juego si el jugador no está AFK
if (JugadorInfo[i][zAfk] < 3) {
JugadorInfo[i][zPlayTiempo]++;
static Query2[150];
format(Query2, sizeof(Query2), "UPDATE `USERS` SET PLAYTIME = '%d' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zPlayTiempo], JugadorInfo[i][zMiID]);
db_query(ZLDB, Query2);
}
// Verifica el tiempo de juego reclamado
if (JugadorInfo[i][zPlayReclamado] == 0) VerificarPlayTime(i);
// Verifica si el jugador está encarcelado
if (JugadorInfo[i][zJailed] == 1) {
JugadorInfo[i][zJailTime]--;
format(Query, sizeof(Query), "UPDATE `USERS` SET TIMEJAIL = '%d' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zJailTime], JugadorInfo[i][zMiID]);
db_query(ZLDB, Query);
if (JugadorInfo[i][zJailTime] <= 0) JailRelease(i);
}
// Manejo de items
// Score Free Kill
if (JugadorInfo[i][zScoreFreeKill] == 1) {
JugadorInfo[i][zTScoreFreeKill]--;
format(Query, sizeof(Query), "UPDATE `USERS` SET TIMESCFREE = '%d' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zTScoreFreeKill], JugadorInfo[i][zMiID]);
db_query(ZLDB, Query);
if (JugadorInfo[i][zTScoreFreeKill] <= 0) {
format(Query, sizeof(Query), "UPDATE `USERS` SET TIMESCFREE = '0', SCFREE = '0' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zMiID]);
db_query(ZLDB, Query);
JugadorInfo[i][zTScoreFreeKill] = 0;
JugadorInfo[i][zScoreFreeKill] = 0;
SendClientMessage(i, COLOR_ROJO, "« Info » "COL_BLANCO"Tu item score freeroam kill ha sido desactivado (tiempo finalizado), vuélvelo a comprar desde tu panel.");
}
}
// Armour Spawn
if (JugadorInfo[i][zArmourSpawn] == 1) {
JugadorInfo[i][zTArmourSpawn]--;
format(Query, sizeof(Query), "UPDATE `USERS` SET TIMEARSPW = '%d' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zTArmourSpawn], JugadorInfo[i][zMiID]);
db_query(ZLDB, Query);
if (JugadorInfo[i][zTArmourSpawn] <= 0) {
format(Query, sizeof(Query), "UPDATE `USERS` SET TIMEARSPW = '0', ARSPW = '0' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zMiID]);
db_query(ZLDB, Query);
JugadorInfo[i][zTArmourSpawn] = 0;
JugadorInfo[i][zArmourSpawn] = 0;
SendClientMessage(i, COLOR_ROJO, "« Info » "COL_BLANCO"Tu item armour spawn ha sido desactivado (tiempo finalizado), vuélvelo a comprar desde tu panel.");
}
}
// Volar (Fly)
if (JugadorInfo[i][zVolar] == 1) {
JugadorInfo[i][zTimeVolar]--;
format(Query, sizeof(Query), "UPDATE `USERS` SET TIMEFLY = '%d' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zTimeVolar], JugadorInfo[i][zMiID]);
db_query(ZLDB, Query);
if (JugadorInfo[i][zTimeVolar] <= 0) {
format(Query, sizeof(Query), "UPDATE `USERS` SET TIMEFLY = '0', FLY = '0' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zMiID]);
db_query(ZLDB, Query);
JugadorInfo[i][zTimeVolar] = 0;
JugadorInfo[i][zVolar] = 0;
if (JugadorInfo[i][zEnVuelo] == true) {
SendClientMessage(i, COLOR_ROJO, "« Info » "COL_BLANCO"Vuelo finalizado.");
JugadorInfo[i][zEnVuelo] = false;
StopFly(i);
GameTextForPlayer(i, "~b~Vuelo ~g~Finalizado", 6000, 3);
}
SendClientMessage(i, COLOR_ROJO, "« Info » "COL_BLANCO"Tu item vuelo ha sido desactivado (tiempo finalizado), vuélvelo a comprar desde tu panel.");
}
}
// Teleport Click
if (JugadorInfo[i][zTeleP] == 1) {
JugadorInfo[i][zTimeTeleP]--;
format(Query, sizeof(Query), "UPDATE `USERS` SET TIMETELE = '%d' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zTimeTeleP], JugadorInfo[i][zMiID]);
db_query(ZLDB, Query);
if (JugadorInfo[i][zTimeTeleP] <= 0) {
format(Query, sizeof(Query), "UPDATE `USERS` SET TIMETELE = '0', TELE = '0' WHERE `ID` = '%d' COLLATE NOCASE", JugadorInfo[i][zMiID]);
db_query(ZLDB, Query);
JugadorInfo[i][zTimeTeleP] = 0;
JugadorInfo[i][zTeleP] = 0;
SendClientMessage(i, COLOR_ROJO, "« Info » "COL_BLANCO"Tu item teleport click ha sido desactivado (tiempo finalizado), vuélvelo a comprar desde tu panel.");
}
}
}
return 1;
}
|
|
|
|
| Game randomly closing |
|
Posted by: Krisitis - 2024-02-01, 08:01 PM - Forum: Support
- No Replies
|
|
Hello!
So I've been trying to use Steam version of GTA San Andreas by downgrading it to 1.0 and doing other stuff for it to work smoothly. The game itself on single player works fine, but once I play SA-MP for like an hour, game just randomly closes without even giving any errors.
Any idea what is that?
|
|
|
|
| crashdetect is crashing my server? |
|
Posted by: CJ101 - 2024-01-31, 07:50 PM - Forum: Support
- No Replies
|
 |
I want to use crashdetect , but it just crashes my server
[19:41:27] [Info] [debug] Server crashed while executing rxv4.amx
[19:41:27] [Info] [debug] AMX backtrace:
[19:41:27] [Info] [debug] #0 00000f70 in ?? () in rxv4.amx
[19:41:27] [Info] [debug] #1 000025b4 in public OnGameModeInit () in rxv4.amx
[19:41:27] [ERROR] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 0)
I am loading it as the first plugin
the error is not my script, i commented out all of GameModeInit and still the same.
Using plugins:
streamer, discordconnector, and mysql . all updated to latest version
|
|
|
|
| Busco dearolladores para server |
|
Posted by: lucasstar1442 - 2024-01-30, 08:08 PM - Forum: Programaci?n
- No Replies
|
|
Buenas soy Sr.Zeppelin,
Estoy buscando gente que quiera formar parte en mi nuevo proyecto y que pueda plasmar mis ideas en un servidor roleplay en SAMP, toda ayuda o colaboración (Con remuneración) contactar conmigo por discord: Sr.Zeppelin
|
|
|
|
| Compile all files in gamemode folder |
|
Posted by: JasonDeRue - 2024-01-29, 01:59 PM - Forum: Pawn Scripting
- Replies (2)
|
|
Hello, I'm using this build system for Sublime Text to compile my gamemode:
Code: {
"cmd": ["pawncc.exe", "-i includes", "$file", "-;+", "-v2", "-d3", "-Z+", "-\\)+"],
"path": "C:/Users/*****/Desktop/Server/pawno"
}
Imagine now I have 2 different files in gamemode folder that I want to compile at same time, how I can do it?
|
|
|
|
|
![[Image: fkHkLPW.jpeg]](https://i.imgur.com/fkHkLPW.jpeg)
