Problem(error/warning): Poceo sam da pravim neki svoj sistem organizacije preko BlueG-ovog mysql 40+ plugina, ali posto me zajebava komanda /makeorg
tj ne znam kako da pronadjem slobodan ID u databazi i setujem ga organizaciji, pokusao sam preko ove fs http://forum.sa-mp.com/showthread.php?t=606469 ali posto se tu koristi SQLite (valjda) a ne mysql, ne znam koje su zamenske provere za jedan i drugi plugin.
Ako neko moze da mi objasni ili konvertuje stockove ispod u mysql 40+ resio bi mi problem i bio bih mu zahvalan.
Dio skripte: [pawn]
stock CreateFaction(fname[], Float:PlayerPosX, Float:PlayerPosY, Float:PlayerPosZ, ftype)
{
DB::CreateRow(FactionTable, "FactionName", fname);
new year, month, day;
getdate(year, month, day);
new fcID = GetAvailableFactionID();
FactionInfo[fcID][dbID] = ReturnLastKey();
FactionInfo[fcID][fID] = fcID;
FactionInfo[fcID][fType] = ftype;
FactionInfo[fcID][fX] = PlayerPosX;
FactionInfo[fcID][fY] = PlayerPosY;
FactionInfo[fcID][fZ] = PlayerPosZ;
new cdate[30];
format(cdate, sizeof cdate, "%02d/%02d/%d", day, month, year);
DB::SetLastIntEntry(FactionTable, "fType", ftype, "Reference");
DB::SetLastFloatEntry(FactionTable, "LockerX", PlayerPosX, "Reference");
DB::SetLastFloatEntry(FactionTable, "LockerY", PlayerPosY, "Reference");
DB::SetLastFloatEntry(FactionTable, "LockerZ", PlayerPosZ, "Reference");
DB::SetLastStringEntry(FactionTable, "CreationDate", cdate, "Reference");
LoadFactions();
#if defined DEBUG_MODE
printf("[FACTION CREATION] %s has been created today (%s). [IG ID: %d | SQL ID: %d]", fname, cdate, fcID, FactionInfo[fcID][dbID]);
#endif
return 1;
}[/pawn]
[pawn]
stock ReturnLastKey()
{
return DB::GetRowsPoolSize(FactionTable);
} [/pawn]
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):/
Slika/video ingame problema(obavezno ako je ingame problem): /