GTA:BLKN

MySQL Reg/Log Sys

Započeo Lyzzi
•6. Avg. 2020.
1,877
pregleda
22
postova
Jack_White[BU]
4
Lyzzi
Enforcer
6. Avg. 2020.
#1
Problem(error/warning): Radim GameMode od 0.Resio sam sam da pocnem da ga radim u MySQL dosla mi neka inspiracija i zelja ali skockam sve i kad Compajlam.Compiler jednostavno ne radi tj zakoci...A kad radim druge modove od 0 drugu vrstu Reg/Log Sistema u MySQL i Yini radi normalno
Deo skripte:
Evo vam FS 
https://pastebin.com/nrQKt1E8

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): 
N/A
inquisitiveemmett
4
inquisitiveemmett
Shot Caller
6. Avg. 2020.
#2

#include "YSI\y_timers"

😕

const MAX_PLAYERS = 200;

Koristi #define MAX_PLAYERS (...) molim te...

yQuery, yString;

Ovo ti uopšte nije potrebno.. Možeš da koristis npr PawnPlus za MySQL.

stock SendClientMessageEx(playerid, colour, const fmat[], va_args<>) {
	new str;
	va_format(str, sizeof (str), fmat, va_start<3>);
	return SendClientMessage(playerid, colour, str);

Ni ovo ti nije potrebno pored va_SendClientMessage, a i ovde nemaš }?

enum PLAYER_ENUM {
	pName,
	pSQLID,
	pLozinka,
	pDrzava,
	pEmail,
	pGodine,
	pSpol,
	pNovac,
	pSkin,
	pLevel
}
 
new PI;

Koristi varijable... a ne enum

enum {
	dialog_REGISTER,
	dialog_DRZAVA,
	dialog_EMAIL,
	dialog_SPOL,
	dialog_GODINE,
	dialog_LOGIN

Koristi easyDialog ili y_inline + y_dialog, napisao sam i dole takođe i ovde nemaš }?

#if defined FILTERSCRIPT
 
public OnFilterScriptInit()
{
	print("\n--------------------------------------");
	print(" Blank Filterscript by your name here");
	print("--------------------------------------\n");
	return 1;
}
 
public OnFilterScriptExit()
{
	return 1;
}
 
#else
 
main()
{
	print("\n----------------------------------");
	print(" "Mod je uspesno ucitan !");
	print("----------------------------------\n");
}
 
#endif

Ovde ti je samo main potreban...

if (mysql_errno() != 0) {
		print(" * MYSQL ERROR: Nije se moguce konektovati na databazu.");
		return 0;
	}
	else print(" * MYSQL INFO: Konekcija na databazu je uspijesna.");

Kada koristiš return u if-u kao npr ovde, ne treba ti ispod else...

return 1;
 
return 1;

wtf? Neće ni errore da ti izbaci kolko si ga sjebao 😄

stock GetName(playerid) {
	new name;
	GetPlayerName(playerid, name, sizeof(name));
	return name;
}


Pa bolje koristi uvek ovo nego to

new name;
GetPlayerName(playerid, name, sizeof name);


IsValidEmail(const email[])
{
    new at_pos = strfind(email, "@", true);
    if(at_pos >= 1)
    {
        new offset = (at_pos + 1), dot_pos = strfind(email, ".", true, offset);
        if(dot_pos > offset)
        {
            return 1;
        }
    }
    return 0;
}

Koristi Regular Expression (RegEx) (https://github.com/urShadow/Pawn.Regex) ili onaj regex običan na samp forumu

ache_get_value_name(0, "Name", PI);
			cache_get_value_name(0, "Lozinka", PI);
			cache_get_value_name(0, "Email", PI);
			cache_get_value_name_int(0, "Drzava", PI);
			cache_get_value_name_int(0, "Godine", PI);
			cache_get_value_name_int(0, "Spol", PI);
			cache_get_value_name_int(0, "Skin", PI);
			cache_get_value_name_int(0, "Novac", PI);
			cache_get_value_name_int(0, "Level", PI);
 
			cache_get_value_name_int(0, "ID", PI);

Prvo mu učitaj id bem li ga...

Za dialoge koristi easyDialog ili y_dialog + y_inline

public OnPlayerDisconnect(playerid, reason)
{
	return 1;
}
 
public OnPlayerSpawn(playerid)
{
	return 1;
}
 
public OnPlayerDeath(playerid, killerid, reason)
{
	return 1;
}
 
public OnVehicleSpawn(vehicleid)
{
	return 1;
}
 
public OnVehicleDeath(vehicleid, killerid)
{
	return 1;
}
 
public OnPlayerText(playerid, text[])
{
	return 1;
}
 
public OnPlayerCommandText(playerid, cmdtext[])
{
	if (strcmp("/mycommand", cmdtext, true, 10) == 0)
	{
		// Do something here
		return 1;
	}
	return 0;
}
 
public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
	return 1;
}
 
public OnPlayerExitVehicle(playerid, vehicleid)
{
	return 1;
}
 
public OnPlayerStateChange(playerid, newstate, oldstate)
{
	return 1;
}
 
public OnPlayerEnterCheckpoint(playerid)
{
	return 1;
}
 
public OnPlayerLeaveCheckpoint(playerid)
{
	return 1;
}
 
public OnPlayerEnterRaceCheckpoint(playerid)
{
	return 1;
}
 
public OnPlayerLeaveRaceCheckpoint(playerid)
{
	return 1;
}
 
public OnRconCommand(cmd[])
{
	return 1;
}
 
public OnPlayerRequestSpawn(playerid)
{
	return 1;
}
 
public OnObjectMoved(objectid)
{
	return 1;
}
 
public OnPlayerObjectMoved(playerid, objectid)
{
	return 1;
}
 
public OnPlayerPickUpPickup(playerid, pickupid)
{
	return 1;
}
 
public OnVehicleMod(playerid, vehicleid, componentid)
{
	return 1;
}
 
public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
	return 1;
}
 
public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
	return 1;
}
 
public OnPlayerSelectedMenuRow(playerid, row)
{
	return 1;
}
 
public OnPlayerExitedMenu(playerid)
{
	return 1;
}
 
public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
	return 1;
}
 
public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
	return 1;
}
 
public OnRconLoginAttempt(ip[], password[], success)
{
	return 1;
}
 
public OnPlayerUpdate(playerid)
{
	return 1;
}
 
public OnPlayerStreamIn(playerid, forplayerid)
{
	return 1;
}
 
public OnPlayerStreamOut(playerid, forplayerid)
{
	return 1;
}
 
public OnVehicleStreamIn(vehicleid, forplayerid)
{
	return 1;
}
 
public OnVehicleStreamOut(vehicleid, forplayerid)
{
	return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}

Ovo sve možeš da obrišeš jer ti sada ne treba..
XACK
3
XACK
Hustler
6. Avg. 2020.
#3
Jao jesi ga naprzio.

Trebao si mu samo reci to za zagrade i publice, a ostalo ga mani, vidis da se covek tek uci.

Ne moramo forsirati YSI nad pocetnicima, prvo bi trebali nauciti osnovne nacine za upravljanje dialozima.

Takodje ako ce regex skidati samo zbog e-mail provere onda bolje da ne skida. Dovoljna je provera za @ karakter i duzinu vecu od 15-ak karaktera, jer cak nece ni slati mail igracima tkd ono.

btw nije PawnPlus jedini za dinamicne stringove i realno mu ne treba ako ce ga samo za to koristiti, moze i pakovane da koristi, a dovoljno je i ovako staticno po mogucnosti lokalno.

@tema Dodaj liticaste zagrade tamo gde ti fale i problem ce ti biti resen.
Alhemičar v2
4
skritpe iz 2007 godine. ( ͡° ͜ʖ ͡°)
Shot Caller
6. Avg. 2020.
#4
Ne treba pola toga što je Emmet rekao iskreno

A svi znamo kako će ovaj početnik završiti tj kako NEĆE završiti bilo šta 😄
inquisitiveemmett
4
inquisitiveemmett
Shot Caller
6. Avg. 2020.
#5
XACK wrote on August 6, 2020, 11:23 am:
Jao jesi ga naprzio.

Trebao si mu samo reci to za zagrade i publice, a ostalo ga mani, vidis da se covek tek uci.

Ne moramo forsirati YSI nad pocetnicima, prvo bi trebali nauciti osnovne nacine za upravljanje dialozima.

Takodje ako ce regex skidati samo zbog e-mail provere onda bolje da ne skida. Dovoljna je provera za @ karakter i duzinu vecu od 15-ak karaktera, jer cak nece ni slati mail igracima tkd ono.

btw nije PawnPlus jedini za dinamicne stringove i realno mu ne treba ako ce ga samo za to koristiti, moze i pakovane da koristi, a dovoljno je i ovako staticno po mogucnosti lokalno.

@tema Dodaj liticaste zagrade tamo gde ti fale i problem ce ti biti resen.

Rekao mi je da pravi mod, tako da ne znam, možda će još nešto koristiti pa bi mu dobro došao regex, PawnPlus itd

Alhemičar v2 wrote on August 6, 2020, 11:30 am:
Ne treba pola toga što je Emmet rekao iskreno

A svi znamo kako će ovaj početnik završiti tj kako NEĆE završiti bilo šta 😄

cuti bre
Jack_White[BU]
4
Lyzzi
Enforcer
6. Avg. 2020.
#6
Isti k opet dodao sam te vicaste zagrade gde mi napomenuo ementt da stavim stavio sam

tu gde je imalo dva ispod returna 1; sam jedan izbrisao

Ali opet je isto se desava compajla i zabaguje..Znaci ono ubacio sam Reg/Log sistem ono da bira igrac koja drzava,godine itd...A bez toga da stavim obican samo da se registruje i loguje radi ko iz picke
KUKI
5
Сараб
Underboss
6. Avg. 2020.
#7
A da koristiš ovaj

https://gtablkn.gg/forum/tutorijali-u-vezi-sa-mpa/mysql-registracija-r41-2

taj tvoj je neka mešavina nečega
Alhemičar v2
4
skritpe iz 2007 godine. ( ͡° ͜ʖ ͡°)
Shot Caller
6. Avg. 2020.
#8
Švabо wrote on August 6, 2020, 11:59 am:
A da koristiš ovaj

https://gtablkn.gg/forum/tutorijali-u-vezi-sa-mpa/mysql-registracija-r41-2

taj tvoj je neka mešavina nečega

Sve osim %e da stavlja na svako mesto je fer objašnjeno 😄
Jack_White[BU]
4
Lyzzi
Enforcer
6. Avg. 2020.
#9
Sorry za DP
Hvl probacu taj nekako ima tu je bolje objasnjen

Inc ovaj sam koristio
https://gtablkn.gg/forum/gamemode-skripte/simple-mysql-register-login-system-r41-4#post-693745
Jack_White[BU]
4
Lyzzi
Enforcer
6. Avg. 2020.
#10
Seo zad Kompom
Stavio sam ono @Eldaa  sto mi je rekao i zaslo mi 15 errora

Evo ovde su linije https://pastebin.com/CE0uYdkJ
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(65) : error 017: undefined symbol "mysql_connect"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(65) : warning 213: tag mismatch
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(67) : error 017: undefined symbol "mysql_errno"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(74) : error 017: undefined symbol "mysql_tquery"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(85) : warning 225: unreachable code
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(108) : error 017: undefined symbol "mysql_format"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(108) : warning 202: number of arguments does not match definition
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(108) : warning 202: number of arguments does not match definition
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(108) : warning 202: number of arguments does not match definition
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(109) : error 017: undefined symbol "mysql_tquery"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(115) : error 017: undefined symbol "cache_num_rows"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(120) : error 017: undefined symbol "cache_get_value"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(121) : error 017: undefined symbol "cache_get_value"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(133) : error 017: undefined symbol "mysql_format"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(133) : warning 202: number of arguments does not match definition
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(133) : warning 202: number of arguments does not match definition
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(133 -- 134) : error 017: undefined symbol "Money"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(136) : error 017: undefined symbol "mysql_tquery"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(318) : error 017: undefined symbol "mysql_format"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(318) : error 017: undefined symbol "query"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(318) : error 029: invalid expression, assumed zero
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(318) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase
Bryan123
4
Darkic
Enforcer
6. Avg. 2020.
#11
#include
🙄
Jack_White[BU]
4
Lyzzi
Enforcer
6. Avg. 2020.
#12
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(86) : warning 225: unreachable code
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(134 -- 135) : error 017: undefined symbol "Money"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(319) : error 017: undefined symbol "query"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(319) : error 017: undefined symbol "query"
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(319) : error 029: invalid expression, assumed zero
C:\Users\bojco\OneDrive\Desktop\MySQL GameMode\gamemodes\NYRP.pwn(319) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase
Bryan123
4
Darkic
Enforcer
6. Avg. 2020.
#13
Sami errori ti kazu sta nije uredu, mucni glavom 🙂
Kriso_Anderson
5
Shaw Salcedo
Kingpin
6. Avg. 2020.
#14
https://hastebin.com/qikolayoya.coffeescript

Evo ti za pocetak
Alhemičar v2
4
skritpe iz 2007 godine. ( ͡° ͜ʖ ͡°)
Shot Caller
6. Avg. 2020.
#15
Shaw Salcedo wrote on August 6, 2020, 5:48 pm:
https://hastebin.com/qikolayoya.coffeescript

Evo ti za pocetak

Au al' je loše 😕

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava

© 2026 SmartShark. All rights reserved.

Powered by Momentum|v2026.3.001 Alpha