MySql

Započeo Slade, Jul 06, 2018, 16:49:25 POSLE PODNE

prethodna tema - sledeća tema

0 članova i 1 gost pregledaju ovu temu.

Štampaj
Idi dole Stranice1
Korisničke akcije

Slade

*

Jul 06, 2018, 16:49:25 POSLE PODNE
Problem(error/warning): Prije tačno dan sam započeo prebacivanje svog Disaronno moda iz Y_INIa u Mysql, i prebacio sam polovicu koja je savršeno radila, kreirala se sama tablica za korisnike ukoliko nije, spremalo se, ucitavalo, savrseno sve, jutros sam ustao i dodao jos dosta varijabli za ucitavanje/spremanje koje nisam stigao prethodno, i sada niti se tablica kreira automatski, niti ucitava niti sprema.
Dio skripte: Biti će dole zbog lakšeg čitanja.
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): Log sam našao, postavit ću dole.
Slika/video ingame problema(obavezno ako je ingame problem): Nemam što da slikam, jednostavno tablica je prazna, više se sama ne generiše, a sinoć jeste sa samo manje varijabli nego sada.

Tablicu sam ručno kreirao preko querya na phpmyadmin, sa istim kodom, ali bukvalno nema nikakve povezanosti moda trenutno sa bazom, tačnije ništa ne izvršava, a piše da je mod povezan sa bazom u printu.

Učitavanje igrača:
cache_set_active(pInfo[playerid][Player_Cache]);
	cache_get_value_int(0, "ID", pInfo[playerid][ID]);
	cache_get_value_int(0, "NOVAC", pInfo[playerid][pNovac]);
	cache_get_value_int(0, "LEVEL", pInfo[playerid][pLevel]);
	cache_get_value_int(0, "HELPER", pInfo[playerid][pHelper]);
	cache_get_value_int(0, "ADMIN", pInfo[playerid][pAdmin]);
	cache_get_value_int(0, "SKIN", pInfo[playerid][pSkin]);
	cache_get_value_int(0, "SATI", pInfo[playerid][pSatiIgre]);
	cache_get_value(0, "MAIL", pInfo[playerid][pMail], 220);
	cache_get_value_int(0, "PDBODOVI", pInfo[playerid][pMinute]);
	cache_get_value_int(0, "RESPEKTI", pInfo[playerid][pExp]);
	cache_get_value_int(0, "SPAWN", pInfo[playerid][pSpawn]);
	cache_get_value_int(0, "RENT", pInfo[playerid][pRent]);
	cache_get_value_int(0, "LIDER", pInfo[playerid][pLider]);
	cache_get_value_int(0, "CLAN", pInfo[playerid][pClan]);
	cache_get_value_int(0, "ORGSLOT", pInfo[playerid][pOrgSlot]);
	cache_get_value_int(0, "RANK", pInfo[playerid][pRank]);
	cache_get_value_int(0, "KUCA", pInfo[playerid][pKucaKljuc]);
	cache_get_value_int(0, "FIRMA", pInfo[playerid][pImaFirmu]);
	cache_get_value_int(0, "STAN", pInfo[playerid][pImaStan]);
	cache_get_value_int(0, "VIKENDICA", pInfo[playerid][pImaVikendicu]);
	cache_get_value_int(0, "POSAO", pInfo[playerid][pPosao]);
	cache_get_value_int(0, "UGOVOR", pInfo[playerid][pUgovor]);
	cache_get_value_int(0, "SJEME", pInfo[playerid][pSjeme]);
	cache_get_value_int(0, "DROGA", pInfo[playerid][pDroga]);
	cache_get_value_int(0, "PRERADJENA", pInfo[playerid][pPreradjenaDroga]);
	cache_get_value_int(0, "MOBITEL", pInfo[playerid][pTelefon]);
	cache_get_value_int(0, "SIM", pInfo[playerid][pSim]);
	cache_get_value_int(0, "KREDITTELEFON", pInfo[playerid][pKreditTelefon]);
	cache_get_value_int(0, "IMENIK", pInfo[playerid][pImenik]);
	cache_get_value_int(0, "ZEMLJA", pInfo[playerid][pZemlja]);
	cache_get_value_int(0, "VEHSLOTOVI", pInfo[playerid][pVehSlotovi]);
	cache_get_value_int(0, "KREDIT", pInfo[playerid][pKredit]);
	cache_get_value_int(0, "CIGARE", pInfo[playerid][pCigare]);
	cache_get_value_int(0, "UPALJAC", pInfo[playerid][pUpaljac]);
	cache_get_value_int(0, "BSTIL", pInfo[playerid][pStilBorbe]);
	cache_get_value_int(0, "MUTIRAN", pInfo[playerid][pMutiran]);
	cache_get_value_int(0, "PRVAPOMOC", pInfo[playerid][pPrvaPomoc]);
	cache_get_value_int(0, "GORIVO", pInfo[playerid][pGorivo]);
	cache_get_value_int(0, "MASKA", pInfo[playerid][pMaska]);
	cache_get_value_int(0, "PUSKA", pInfo[playerid][pPuska]);
	cache_get_value_int(0, "PUMPARICA", pInfo[playerid][pPumparica]);
	cache_get_value_int(0, "PISTOLJ", pInfo[playerid][pPistolj]);
	cache_get_value_int(0, "KAZNA", pInfo[playerid][pKazna]);
	cache_get_value_int(0, "VIPISTICE", pInfo[playerid][VipIstice]);
	cache_get_value_int(0, "BANEXP", pInfo[playerid][BanIstice]);
	cache_get_value_int(0, "BANPERM", pInfo[playerid][PermBan]);
	cache_get_value_int(0, "PRIVBAN", pInfo[playerid][PrivBan]);
	cache_get_value(0, "BANADMIN", pInfo[playerid][BanAdmin], 20);
	cache_get_value(0, "BANRAZLOG", pInfo[playerid][BanRazlog], 100);
	cache_get_value_int(0, "PASOS", pInfo[playerid][Pasos]);
	cache_get_value_int(0, "VIP", pInfo[playerid][VIP]);
	cache_get_value_int(0, "GARAZA", pInfo[playerid][Garaza]);
	cache_get_value_int(0, "BOOMBOX", pInfo[playerid][Boombox]);
	cache_get_value_int(0, "PLATA", pInfo[playerid][Plata]);
	cache_get_value_int(0, "IMANJE", pInfo[playerid][Imanje]);
	cache_get_value_int(0, "SLJIVE", pInfo[playerid][Sljive]);
	cache_get_value_int(0, "KRUSKE", pInfo[playerid][Kruske]);
	cache_get_value_int(0, "JABUKE", pInfo[playerid][Jabuke]);
	cache_get_value_int(0, "SJEMESLJIVE", pInfo[playerid][SjemenaSljive]);
	cache_get_value_int(0, "SJEMEKRUSKE", pInfo[playerid][SjemenaKruske]);
	cache_get_value_int(0, "SJEMEJABUKE", pInfo[playerid][SjemenaJabuke]);
	cache_get_value_int(0, "KRAVE", pInfo[playerid][pKrave]);
	cache_get_value_int(0, "MLIJEKO", pInfo[playerid][pMlijeko]);
	cache_get_value_int(0, "LISICE", pInfo[playerid][pLisice]);
	cache_get_value_int(0, "VOZACKA", pInfo[playerid][pVozacka]);
	cache_get_value_int(0, "ZATVOREN", pInfo[playerid][pZatvoren]);
	cache_get_value_int(0, "TZATVOREN", pInfo[playerid][pTZatvoren]);
	cache_get_value_int(0, "POTJERA", pInfo[playerid][pPotjera]);
	cache_get_value(0, "RPOTJERA", pInfo[playerid][pRPotjera], 128);
	cache_get_value_int(0, "ZLATO", pInfo[playerid][pZlato]);
	cache_get_value_int(0, "BANDAN", pInfo[playerid][pBanDani]);
	cache_get_value_int(0, "BANMJESEC", pInfo[playerid][pBanMjesec]);
	cache_get_value_int(0, "BANGODINA", pInfo[playerid][pBanGodina]);
	cache_get_value_int(0, "OVISNOST", pInfo[playerid][pOvisnost]);
	cache_get_value_int(0, "PRIBOR", pInfo[playerid][pPribor]);
	cache_get_value_int(0, "TICKET", pInfo[playerid][pTicket]);
	cache_get_value_int(0, "NEXTZATVOR", pInfo[playerid][pNextZatvor]);
	cache_get_value_int(0, "NEXTZATVORVRIJEME", pInfo[playerid][pNextZatvorVrijeme]);


Spremanje igrača:
mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `PLAYERS` SET `LEVEL` = %d,`NOVAC` = %d,ADMIN` = %d,`HELPER` = %d, `SKIN` = %d, `SATI` = %d, `SPOL` = %d, `GODINE` = %d, `MAIL` = '%s', `PDBODOVI` = %d, ESPEKTI` = %d, `SPAWN` = %d, `RENT` = %d, `LIDER` = %d, `CLAN` = %d, `ORGSLOT` = %d, `RANK` = %d, `KUCA` = %d, `FIRMA` = %d, `STAN` = %d, `VIKENDICA` = %d, `POSAO` = %d, `SJEME` = %d, `DROGA` = %d, `PRERADJENA` = %d, `MOBITEL` = %d, `SIM` = %d, `KREDITTELEFON` = %d, `IMENIK` = %d, `ZEMLJA` = %d, `VEHSLOTOVI` = %d, `KREDIT` = %d, `CIGARE` = %d, `UPALJAC` = %d, `BSTIL` = %d, `MUTIRAN` = %d, `PRVAPOMOC` = %d, `GORIVO` = %d, `MASKA` = %d, `PUSKA` = %d, `PUMPARICA` = %d, `PISTOLJ` = %d, `KAZNA` = %d, `VIPISTICE` = %d, `BANEXP` = %d, `BANPERM` = %d, `PRIVBAN` = %d, `BANADMIN` = '%s', `BANRAZLOG` = '%s', `PASOS` = %d, `VIP` = %d, `GARAZA` = %d, `BOOMBOX` = %d, `PLATA` = %d, `IMANJE` = %d, SLJIVE` = %d, `KRUSKE` = %d, `JABUKE` = %d, `SJEMESLJIVE` = %d, `SJEMEKRUSKE` = %d, `SJEMEJABUKE` = %d, `KRAVE` = %d, `MLIJEKO` = %d, `LISICE` = %d, `VOZACKA` = %d, `ZATVOREN` = %d, `TZATVOREN` = %d, `POTJERA` = %d, `RPOTJERA` = '%s', `ZLATO` = %d, `BANDAN` = %d, `BANMJESEC` = %d, `BANGODINA` = %d, `OVISNOST` = %d, `PRIBOR` = %d, `TICKET` = %d, `NEXTZATVOR` = %d, `NEXTZATVORVRIJEME` = %d, `UGOVOR` = %d WHERE `ID` = %d LIMIT 1",
	pInfo[playerid][pLevel], pInfo[playerid][pNovac], pInfo[playerid][pAdmin], pInfo[playerid][pHelper],
	pInfo[playerid][pSkin], pInfo[playerid][pSatiIgre], pInfo[playerid][pSpol], pInfo[playerid][pGodine],
	pInfo[playerid][pMail], pInfo[playerid][pMinute], pInfo[playerid][pExp], pInfo[playerid][pSpawn],
	pInfo[playerid][pRent], pInfo[playerid][pLider], pInfo[playerid][pClan], pInfo[playerid][pOrgSlot],
	pInfo[playerid][pRank], pInfo[playerid][pKucaKljuc], pInfo[playerid][pImaFirmu], pInfo[playerid][pImaStan],
	pInfo[playerid][pImaVikendicu], pInfo[playerid][pPosao], pInfo[playerid][pSjeme], pInfo[playerid][pDroga],
	pInfo[playerid][pPreradjenaDroga], pInfo[playerid][pTelefon], pInfo[playerid][pSim], pInfo[playerid][pKreditTelefon],
	pInfo[playerid][pImenik], pInfo[playerid][pZemlja], pInfo[playerid][pVehSlotovi], pInfo[playerid][pCigare],
	pInfo[playerid][pUpaljac], pInfo[playerid][pStilBorbe], pInfo[playerid][pMutiran], pInfo[playerid][pPrvaPomoc],
	pInfo[playerid][pGorivo], pInfo[playerid][pMaska], pInfo[playerid][pPuska], pInfo[playerid][pPumparica],
	pInfo[playerid][pPistolj], pInfo[playerid][pKazna], pInfo[playerid][VipIstice], pInfo[playerid][BanIstice],
	pInfo[playerid][PermBan], pInfo[playerid][PrivBan], pInfo[playerid][BanAdmin], pInfo[playerid][BanRazlog],
	pInfo[playerid][Pasos], pInfo[playerid][VIP], pInfo[playerid][Garaza], pInfo[playerid][Boombox], pInfo[playerid][Plata],
	pInfo[playerid][Imanje], pInfo[playerid][Sljive], pInfo[playerid][Kruske], pInfo[playerid][Jabuke], pInfo[playerid][SjemenaSljive],
	pInfo[playerid][SjemenaKruske], pInfo[playerid][SjemenaJabuke], pInfo[playerid][pKrave], pInfo[playerid][pMlijeko],
	pInfo[playerid][pLisice], pInfo[playerid][pVozacka], pInfo[playerid][pZatvoren], pInfo[playerid][pTZatvoren],
	pInfo[playerid][pPotjera], pInfo[playerid][pRPotjera],
	pInfo[playerid][pZlato], pInfo[playerid][pBanDani], pInfo[playerid][pBanMjesec], pInfo[playerid][pBanGodina],
	pInfo[playerid][pOvisnost], pInfo[playerid][pPribor], pInfo[playerid][pTicket], pInfo[playerid][pNextZatvor],
	pInfo[playerid][pNextZatvorVrijeme],
	pInfo[playerid][pUgovor], pInfo[playerid][ID]);

	for(new i=1; i != MAX_SLOTOVA; i++) {
	    mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `PLAYERS` SET `VOZILO[%d]` = %d WHERE `ID` = %d", i, pInfo[playerid][pVozilo][i], pInfo[playerid][ID]);
		mysql_tquery(Database, DB_Query);
	}

	if(cache_is_valid(pInfo[playerid][Player_Cache])) 
	{
		cache_delete(pInfo[playerid][Player_Cache]); 
		pInfo[playerid][Player_Cache] = MYSQL_INVALID_CACHE;
	}


Generisanje tablice (napomena: tu su 2 stringa jer sam imao problem, prevelik text se morao raširiti u 2 stringa):
new string1[512], string2[512], totalstring[ 1200 ];
	format(string1, sizeof(string1), "CREATE TABLE IF NOT EXISTS `PLAYERS` (`ID` int(11) NOT NULL AUTO_INCREMENT,\
							`USERNAME` varchar(24) NOT NULL,\
							`PASSWORD` char(65) NOT NULL,\
							`NOVAC` mediumint(7) NOT NULL DEFAULT '0',\
							`LEVEL` mediumint(7) NOT NULL DEFAULT '1',\
							`ADMIN` mediumint(7) NOT NULL DEFAULT '0',\
							`HELPER` mediumint(7) NOT NULL DEFAULT '0',\
							`SKIN` mediumint(7) NOT NULL DEFAULT '60',\
							`SATI` mediumint(7) NOT NULL DEFAULT '0',\
							`SPOL` mediumint(7) NOT NULL DEFAULT '1',\
							`GODINE` mediumint(7) NOT NULL DEFAULT '0',\
							`MAIL` char(220) NOT NULL,\
							`PDBODOVI` mediumint(7) NOT NULL DEFAULT '0',\
							`RESPEKTI` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[1]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[2]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[3]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[4]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[5]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[6]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[7]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[8]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[9]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[10]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[11]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[12]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[13]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[14]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[15]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[16]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[17]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[18]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[19]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[20]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[21]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[22]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[23]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[24]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[25]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[26]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[27]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[28]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[29]` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZILO[30]` mediumint(7) NOT NULL DEFAULT '0',\
							`SPAWN` mediumint(7) NOT NULL DEFAULT '0',\
							`RENT` mediumint(7) NOT NULL DEFAULT '0',\
							`LIDER` mediumint(7) NOT NULL DEFAULT '0',\
							`CLAN` mediumint(7) NOT NULL DEFAULT '0',\
							`ORGSLOT` mediumint(7) NOT NULL DEFAULT '0',\
							`RANK` mediumint(7) NOT NULL DEFAULT '0',\
							`KUCA` mediumint(7) NOT NULL DEFAULT '0',\
							`FIRMA` mediumint(7) NOT NULL DEFAULT '0',\
							`VIKENDICA` mediumint(7) NOT NULL DEFAULT '-1',\
							`STAN` mediumint(7) NOT NULL DEFAULT '-1',\
							`POSAO` mediumint(7) NOT NULL DEFAULT '0',\
							`UGOVOR` mediumint(7) NOT NULL DEFAULT '0',\
							`SJEME` mediumint(7) NOT NULL DEFAULT '0',\
							`DROGA` mediumint(7) NOT NULL DEFAULT '0',\
							`PRERADJENA` mediumint(7) NOT NULL DEFAULT '0',\
							`MOBITEL` mediumint(7) NOT NULL DEFAULT '0',\
							`SIM` mediumint(7) NOT NULL DEFAULT '0',\
							`KREDITTELEFON` mediumint(7) NOT NULL DEFAULT '0',\
							`IMENIK` mediumint(7) NOT NULL DEFAULT '0',\
							`ZEMLJA` mediumint(7) NOT NULL DEFAULT '0',\
							`VEHSLOTOVI` mediumint(7) NOT NULL DEFAULT '0',\
							`KREDIT` mediumint(7) NOT NULL DEFAULT '0',\
							`CIGARE` mediumint(7) NOT NULL DEFAULT '0',\
							`UPALJAC` mediumint(7) NOT NULL DEFAULT '0',\
							`BSTIL` mediumint(7) NOT NULL DEFAULT '0',\
							`MUTIRAN` mediumint(7) NOT NULL DEFAULT '0',\
							`PRVAPOMOC` mediumint(7) NOT NULL DEFAULT '0',\
							`GORIVO` mediumint(7) NOT NULL DEFAULT '0',\
							`MASKA` mediumint(7) NOT NULL DEFAULT '0',\
							`PUSKA` mediumint(7) NOT NULL DEFAULT '0',\
							`PUMPARICA` mediumint(7) NOT NULL DEFAULT '0',\
							`PISTOLJ` mediumint(7) NOT NULL DEFAULT '0',\
							`KAZNA` mediumint(7) NOT NULL DEFAULT '0',\
							`VIPISTICE` mediumint(7) NOT NULL DEFAULT '0',\
							`BANEXP` mediumint(7) NOT NULL DEFAULT '0',\
							`BANPERM` mediumint(7) NOT NULL DEFAULT '0',\
							`PRIVBAN` mediumint(7) NOT NULL DEFAULT '0',\
							`BANADMIN` char(20) NOT NULL,\
							`BANRAZLOG` char(100) NOT NULL,\
							`PASOS` mediumint(7) NOT NULL DEFAULT '0',\
							`VIP` mediumint(7) NOT NULL DEFAULT '0',\
							`GARAZA` mediumint(7) NOT NULL DEFAULT '-1',\
							`BOOMBOX` mediumint(7) NOT NULL DEFAULT '0',\
							`IMANJE` mediumint(7) NOT NULL DEFAULT '0',\
							`SLJIVE` mediumint(7) NOT NULL DEFAULT '0',");
	format(string2, sizeof(string2), "`KRUSKE` mediumint(7) NOT NULL DEFAULT '0',\
							`JABUKE` mediumint(7) NOT NULL DEFAULT '0',\
							`SJEMESLJIVE` mediumint(7) NOT NULL DEFAULT '0',\
							`SJEMEKRUSKE` mediumint(7) NOT NULL DEFAULT '0',\
							`SJEMEJABUKE` mediumint(7) NOT NULL DEFAULT '0',\
							`KRAVE` mediumint(7) NOT NULL DEFAULT '0',\
							`MLIJEKO` mediumint(7) NOT NULL DEFAULT '0',\
							`LISICE` mediumint(7) NOT NULL DEFAULT '0',\
							`VOZACKA` mediumint(7) NOT NULL DEFAULT '0',\
							`ZATVOREN` mediumint(7) NOT NULL DEFAULT '0',\
							`TZATVOREN` mediumint(7) NOT NULL DEFAULT '0',\
							`POTJERA` mediumint(7) NOT NULL DEFAULT '0',\
							`RPOTJERA` char(128) NOT NULL,\
							`ZLATO` mediumint(7) NOT NULL DEFAULT '0',\
							`BANDAN` mediumint(7) NOT NULL DEFAULT '0',\
							`BANMJESEC` mediumint(7) NOT NULL DEFAULT '0',\
							`BANGODINA` mediumint(7) NOT NULL DEFAULT '0',\
							`OVISNOST` mediumint(7) NOT NULL DEFAULT '0',\
							`PRIBOR` mediumint(7) NOT NULL DEFAULT '0',\
							`TICKET` mediumint(7) NOT NULL DEFAULT '0',\
							`NEXTZATVOR` mediumint(7) NOT NULL DEFAULT '0',\
							`NEXTZATVORVRIJEME` mediumint(7) NOT NULL DEFAULT '0',\
							PRIMARY KEY (`ID`), UNIQUE KEY `USERNAME` (`USERNAME`))");
	format(totalstring, sizeof(totalstring), "%s%s", string1, string2);
	mysql_tquery(Database, totalstring);
Poslednja Izmena: Jul 06, 2018, 21:11:18 POSLE PODNE od Bašovski

Slade

*

#2
Jul 06, 2018, 17:38:40 POSLE PODNE
Riješeno.
Štampaj
Idi gore Stranice1
Korisničke akcije