MySQL Reg/Log Sys

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

#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..

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.

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 😄

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

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

Š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 😄

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

#include  

🙄

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

Sami errori ti kazu sta nije uredu, mucni glavom 🙂

https://hastebin.com/qikolayoya.coffeescript

Evo ti za pocetak

Shaw Salcedo wrote on August 6, 2020, 5:48 pm:

https://hastebin.com/qikolayoya.coffeescript

Evo ti za pocetak

Au al' je loše 😕