MYSQL Problem

ryaN.iXi · 26. Juli 2015

Hay,

Ich hab ein Problem.

Kann mir da jemand helfen?

mfg.

Jeffry · 26. Juli 2015

Wie sieht der Code zu dem Fehler aus?

ryaN.iXi · 26. Juli 2015

Zitat von Jeffry

Wie sieht der Code zu dem Fehler aus?

Welcher Code?

Jeffry · 26. Juli 2015

Der PAWN Code, der diesen Fehler verursacht.

ryaN.iXi · 26. Juli 2015

Ich weiß es nicht, deswegen frag Ich ja hier, ich weiß nur, dass das ganze erscheint, sobald ich mit dem Tutorial Fertig bin.

Jeffry · 26. Juli 2015

Dann schau dir dort mal den Code an. Dort wird ein MySQL Query abgesendet, das wohl Fehler beinhaltet.

ryaN.iXi · 26. Juli 2015

Zitat von Jeffry

Dann schau dir dort mal den Code an. Dort wird ein MySQL Query abgesendet, das wohl Fehler beinhaltet.

Code

stock Register(playerid,key[])
{
	new Name[32];
	GetPlayerName(playerid, Name, sizeof(Name));
	s_SetPlayerHealth(playerid,100);
	pInfo[playerid][AuslogHeal] = 100;
	pAC_CD[playerid] =5;
	pInfo[playerid][ploggedin] =1;
	RegSchutz = 10;
	new query[256],md5key[64],datum[64];
	//new query2[256];
	new Year, Month, Day,Hour, Minute;
	getdate(Year, Month, Day);
	gettime(Hour, Minute);
	format(md5key,sizeof(md5key),"%s",MD5_Hash(key));
	format(datum,sizeof(datum),"%02d.%02d.%d / %02d:%02d Uhr", Day, Month, Year, Hour, Minute);
	mysql_real_escape_string(Name,SpielerName(playerid));
	mysql_real_escape_string(md5key,md5key);
	mysql_real_escape_string(datum,datum);
	format(query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Passwort`, `Datum`) VALUES ('%s', '%s', '%s')", Name, md5key,datum);
	new query1[128];
	format(query1, sizeof(query1), "INSERT INTO `inventar` (`Name`) VALUES ('%s')", SpielerName(playerid));
	new query2[128];
	format(query2, sizeof(query2), "INSERT INTO `coinsystem` (`Name`) VALUES ('%s')", SpielerName(playerid));
	new query3[128];
	format(query3, sizeof(query3), "INSERT INTO `apps` (`Name`) VALUES ('%s')", SpielerName(playerid));
	mysql_query(query3);
	mysql_query(query2);
	mysql_query(query1);
	mysql_query(query);
	mysql_SetString("accounts", "Passwort", MD5_Hash(key), "Name", SpielerName(playerid));
	mysql_SetInt("accounts", "ZSPD", 1, "Name", SpielerName(playerid));
	mysql_SetInt("accounts", "Respektpunkte", 0, "Name", SpielerName(playerid));
	mysql_SetInt("accounts", "Nummer", 0, "Name", SpielerName(playerid));
	AutosysCreateplayer(playerid);
	pInfo[playerid][pNummer] =0;
	pInfo[playerid][pRespektpunkteBenotigt] = 3;
	SetPlayerScore(playerid,1);
	pInfo[playerid][pHunger] =300;
	SCM(playerid,COLOR_YELLOW," ");
	SCM(playerid,COLOR_YELLOW," ");
	SCM(playerid,COLOR_YELLOW," ");
	SCM(playerid,COLOR_YELLOW," ");
	SCM(playerid,COLOR_YELLOW,"Beleidungen sowie Rassistische Äußerungen werden nicht toleriert");
	SCM(playerid,COLOR_YELLOW,"Eine Hilfe findest du unter /hilfe, das Regelwerk findest du im Forum.");
	SCM(playerid,COLOR_YELLOW,"Mit /sup kannst du eine Frage stellen oder einen Spieler/Bug melden");
	SCM(playerid,COLOR_YELLOW,"Die TS3 IP und die Foren URL findest du auch unter '/serverinfo'");
	SCM(playerid,COLOR_YELLOW,"Gehe nun bitte ins Forum, registriere dich und lies dir die Regeln durch.");
	SCM(playerid,COLOR_YELLOW,"Wenn du Level 2 erreicht hast kannst du deinen Foren- und Teamspeak3 Account");
	SCM(playerid,COLOR_YELLOW,"per /cp -> Account aktivieren.");
	pVspawner_active[playerid] = 0;
	SavePlayer(playerid,0);
	return 1;
}
stock mysql_ReturnPasswort(Name[])
{
	new query[130], Get[130];
	format(query, 128, "SELECT `passwort` FROM `accounts` WHERE `Name` = '%s'", Name);
	mysql_query(query);
	mysql_store_result();
	mysql_fetch_row(Get);
	mysql_free_result();
	return Get;
}
stock LoadPlayerCoinS(playerid)
{
	pCoinS[playerid][OnlineZeit] = mysql_GetInt("coinsystem", "1", "Name", SpielerName(playerid));
	pCoinS[playerid][Kills] = mysql_GetInt("coinsystem", "2", "Name", SpielerName(playerid));
	pCoinS[playerid][Marley] = mysql_GetInt("coinsystem", "3", "Name", SpielerName(playerid));
	pCoinS[playerid][Junkie] = mysql_GetInt("coinsystem", "4", "Name", SpielerName(playerid));
	pCoinS[playerid][Bonze] = mysql_GetInt("coinsystem", "5", "Name", SpielerName(playerid));
	pCoinS[playerid][Sauber] = mysql_GetInt("coinsystem", "6", "Name", SpielerName(playerid));
	pCoinS[playerid][Uhrzeit] = mysql_GetInt("coinsystem", "7", "Name", SpielerName(playerid));
	pCoinS[playerid][Maskiert] = mysql_GetInt("coinsystem", "8", "Name", SpielerName(playerid));
	pCoinS[playerid][Party] = mysql_GetInt("coinsystem", "9", "Name", SpielerName(playerid));
	pCoinS[playerid][Terrorist] = mysql_GetInt("coinsystem", "10", "Name", SpielerName(playerid));
	pCoinS[playerid][OnlineZeit2] = mysql_GetInt("coinsystem", "11", "Name", SpielerName(playerid));
	pCoinS[playerid][OnlineZeit3] = mysql_GetInt("coinsystem", "12", "Name", SpielerName(playerid));
	pCoinS[playerid][Kills2] = mysql_GetInt("coinsystem", "13", "Name", SpielerName(playerid));
	pCoinS[playerid][Kills3] = mysql_GetInt("coinsystem", "14", "Name", SpielerName(playerid));
	pCoinS[playerid][Killstreak1] = mysql_GetInt("coinsystem", "15", "Name", SpielerName(playerid));
	pCoinS[playerid][Killstreak2] = mysql_GetInt("coinsystem", "16", "Name", SpielerName(playerid));
	pCoinS[playerid][Auto] = mysql_GetInt("coinsystem", "17", "Name", SpielerName(playerid));
	pCoinS[playerid][Fisch] = mysql_GetInt("coinsystem", "18", "Name", SpielerName(playerid));
	pCoinS[playerid][Staatsfeind] = mysql_GetInt("coinsystem", "19", "Name", SpielerName(playerid));
	pCoinS[playerid][GeldTransport] = mysql_GetInt("coinsystem", "20", "Name", SpielerName(playerid));
}
stock LoadPlayerInv(playerid)
{
	pInv[playerid][b_zig] = mysql_GetInt("inventar", "b_zig", "Name", SpielerName(playerid));
	pInv[playerid][m_zig] = mysql_GetInt("inventar", "m_zig", "Name", SpielerName(playerid));
	pInv[playerid][t_zig] = mysql_GetInt("inventar", "t_zig", "Name", SpielerName(playerid));
	pInv[playerid][b_snack] = mysql_GetInt("inventar", "b_snack", "Name", SpielerName(playerid));
	pInv[playerid][m_snack] = mysql_GetInt("inventar", "m_snack", "Name", SpielerName(playerid));
	pInv[playerid][t_snack] = mysql_GetInt("inventar", "t_snack", "Name", SpielerName(playerid));
	pInv[playerid][Mats] = mysql_GetInt("inventar", "Mats", "Name", SpielerName(playerid));
	pInv[playerid][Marihuana] = mysql_GetInt("inventar", "Marihuana", "Name", SpielerName(playerid));
	pInv[playerid][Heroin] = mysql_GetInt("inventar", "Heroin", "Name", SpielerName(playerid));
	pInv[playerid][Coins] = mysql_GetInt("inventar", "Coins", "Name", SpielerName(playerid));
	pInv[playerid][Kanister] = mysql_GetInt("inventar", "Kanister", "Name", SpielerName(playerid));
	pInv[playerid][Masken] = mysql_GetInt("inventar", "Masken", "Name", SpielerName(playerid));
	pInv[playerid][C4] = mysql_GetInt("inventar", "C4", "Name", SpielerName(playerid));
	pInv[playerid][Dietrich] = mysql_GetInt("inventar", "Dietrich", "Name", SpielerName(playerid));
	pInv[playerid][Uhr] = mysql_GetInt("inventar", "Uhr", "Name", SpielerName(playerid));
	// Fisch System
	pInv[playerid][pFishes] = mysql_GetInt("inventar", "Fische", "Name", SpielerName(playerid));
	pInv[playerid][pFisch1] = mysql_GetInt("inventar", "Fisch1", "Name", SpielerName(playerid));
	pInv[playerid][pFisch2] = mysql_GetInt("inventar", "Fisch2", "Name", SpielerName(playerid));
	pInv[playerid][pFisch3] = mysql_GetInt("inventar", "Fisch3", "Name", SpielerName(playerid));
	pInv[playerid][pFisch4] = mysql_GetInt("inventar", "Fisch4", "Name", SpielerName(playerid));
	pInv[playerid][pFisch5] = mysql_GetInt("inventar", "Fisch5", "Name", SpielerName(playerid));
	pInv[playerid][pWeight1] = mysql_GetInt("inventar", "Gewicht1", "Name", SpielerName(playerid));
	pInv[playerid][pWeight2] = mysql_GetInt("inventar", "Gewicht2", "Name", SpielerName(playerid));
	pInv[playerid][pWeight3] = mysql_GetInt("inventar", "Gewicht3", "Name", SpielerName(playerid));
	pInv[playerid][pWeight4] = mysql_GetInt("inventar", "Gewicht4", "Name", SpielerName(playerid));
	pInv[playerid][pWeight5] = mysql_GetInt("inventar", "Gewicht5", "Name", SpielerName(playerid));
	pInv[playerid][pFid1] = mysql_GetInt("inventar", "FischID1", "Name", SpielerName(playerid));
	pInv[playerid][pFid2] = mysql_GetInt("inventar", "FischID2", "Name", SpielerName(playerid));
	pInv[playerid][pFid3] = mysql_GetInt("inventar", "FischID3", "Name", SpielerName(playerid));
	pInv[playerid][pFid4] = mysql_GetInt("inventar", "FischID4", "Name", SpielerName(playerid));
	pInv[playerid][pFid5] = mysql_GetInt("inventar", "FischID5", "Name", SpielerName(playerid));
	pInv[playerid][pLastFish] = mysql_GetInt("inventar", "LastFisch", "Name", SpielerName(playerid));
	pInv[playerid][pFishID] = mysql_GetInt("inventar", "LastFischID", "Name", SpielerName(playerid));
	pInv[playerid][pLastWeight] = mysql_GetInt("inventar", "LastFischGewicht", "Name", SpielerName(playerid));
	// Ende
	pInv[playerid][mp3] = mysql_GetInt("inventar", "mp3", "Name", SpielerName(playerid));
	pInv[playerid][Seil] = mysql_GetInt("inventar", "Seil", "Name", SpielerName(playerid));
	pInv[playerid][Slamkit] = mysql_GetInt("inventar", "Slamkit", "Name", SpielerName(playerid));
	pInv[playerid][Wurfel] = mysql_GetInt("inventar", "Wurfel", "Name", SpielerName(playerid));
	pInv[playerid][KoffBombe] = mysql_GetInt("inventar", "KoffBombe", "Name", SpielerName(playerid));
	pInv[playerid][Code] = mysql_GetInt("inventar", "Code", "Name", SpielerName(playerid));
	pInv[playerid][Helm] = mysql_GetInt("inventar", "Helm", "Name", SpielerName(playerid));
	pInv[playerid][Telefon] = mysql_GetInt("inventar", "Telefon", "Name", SpielerName(playerid));
	pInv[playerid][Defusing] = mysql_GetInt("inventar", "Defusing", "Name", SpielerName(playerid));
	pInv[playerid][Angel] = mysql_GetInt("inventar", "Angel", "Name", SpielerName(playerid));
	pInv[playerid][Wurm] = mysql_GetInt("inventar", "Wurm", "Name", SpielerName(playerid));
	pInv[playerid][Kabel] = mysql_GetInt("inventar", "Kabel", "Name", SpielerName(playerid));
	pInv[playerid][Bombe] = mysql_GetInt("inventar", "Bombe", "Name", SpielerName(playerid));
}


stock LoadPlayerApp(playerid)
{
	pApp[playerid][findyou] = mysql_GetInt("apps", "findyou", "Name", SpielerName(playerid));
	pApp[playerid][myradio] = mysql_GetInt("apps", "myradio", "Name", SpielerName(playerid));
	pApp[playerid][cop] = mysql_GetInt("apps", "cop", "Name", SpielerName(playerid));
	pApp[playerid][bank] = mysql_GetInt("apps", "bank", "Name", SpielerName(playerid));
	pApp[playerid][mail] = mysql_GetInt("apps", "mail", "Name", SpielerName(playerid));
}


stock LoadPlayer(playerid)
{
	countlogin[playerid] = GetTickCount();
	SetPlayerScore(playerid,mysql_GetInt("accounts", "Level", "Name", SpielerName(playerid)));
	pInfo[playerid][pRespektpunkte] =mysql_GetInt("accounts", "Respektpunkte", "Name", SpielerName(playerid));
	ResetPlayerMoney(playerid);
	pInfo[playerid][pGeld] =0;
	GiveMoney(playerid,mysql_GetInt("accounts", "Geld", "Name", SpielerName(playerid)));
	pInfo[playerid][pAdminlevel] = mysql_GetInt("accounts", "Admin", "Name", SpielerName(playerid));
	//SetPVarInt(playerid,"Alter",mysql_GetInt("accounts", "Alter", "Name", SpielerName(playerid)));
	//SetPVarInt(playerid,"geschlecht",mysql_GetInt("accounts", "Geschlecht", "Name", SpielerName(playerid)));
	pInfo[playerid][pProlog] = mysql_GetInt("accounts", "Prolog", "Name", SpielerName(playerid));
	pInfo[playerid][pFraktion] = mysql_GetInt("accounts", "Fraktion", "Name", SpielerName(playerid));
	pInfo[playerid][pAutowarn] = mysql_GetInt("accounts", "Autowarn", "Name", SpielerName(playerid));
	pInfo[playerid][pBike] = mysql_GetInt("accounts", "Bike", "Name", SpielerName(playerid));
	pInfo[playerid][pAutoschein] = mysql_GetInt("accounts", "Autoschein", "Name", SpielerName(playerid));
	pInfo[playerid][pFly] = mysql_GetInt("accounts", "Flug", "Name", SpielerName(playerid));
	pInfo[playerid][pLkwschein] = mysql_GetInt("accounts", "LKWschein", "Name", SpielerName(playerid));
	pInfo[playerid][pHelischein] = mysql_GetInt("accounts", "Helischein", "Name", SpielerName(playerid));
	pInfo[playerid][pBoot] = mysql_GetInt("accounts", "Boot", "Name", SpielerName(playerid));
	pInfo[playerid][pLKwarn] =mysql_GetInt("accounts", "LKwarn", "Name", SpielerName(playerid));
	pInfo[playerid][pBikewarn] = mysql_GetInt("accounts", "Bikewarn", "Name", SpielerName(playerid));
	pInfo[playerid][pWanted] =mysql_GetInt("accounts", "Wanted", "Name", SpielerName(playerid));
	pInfo[playerid][pBank] = mysql_GetInt("accounts", "Bank", "Name", SpielerName(playerid));
	pInfo[playerid][pTode] = mysql_GetInt("accounts", "Tode", "Name", SpielerName(playerid));
	pInfo[playerid][pImHaus] = mysql_GetInt("accounts", "ImHaus", "Name", SpielerName(playerid));
	pInfo[playerid][pSpielzeit] = mysql_GetInt("accounts", "Spielzeit", "Name", SpielerName(playerid));
	pInfo[playerid][pLeader] = mysql_GetInt("accounts", "Leader", "Name", SpielerName(playerid));
	pInfo[playerid][pMember] = mysql_GetInt("accounts", "Member", "Name", SpielerName(playerid));
	pInfo[playerid][pRang] = mysql_GetInt("accounts", "Rang", "Name", SpielerName(playerid));
	pInfo[playerid][pPerso] = mysql_GetInt("accounts", "Perso", "Name", SpielerName(playerid));
	PAYDAYG[playerid] = mysql_GetInt("accounts", "ZSPD", "Name", SpielerName(playerid));
	pInfo[playerid][pJob] = mysql_GetInt("accounts", "Job", "Name", SpielerName(playerid));
	pInfo[playerid][pSkin] = mysql_GetInt("accounts", "Skin", "Name", SpielerName(playerid));
	pInfo[playerid][pDutySkin] = mysql_GetInt("accounts", "DutySkin", "Name", SpielerName(playerid));
	pInfo[playerid][pNeu] = mysql_GetInt("accounts", "Neu", "Name", SpielerName(playerid));
	pInfo[playerid][pKills] = mysql_GetInt("accounts", "Kills", "Name", SpielerName(playerid));
	pInfo[playerid][pRadio] = mysql_GetInt("accounts", "Radio", "Name", SpielerName(playerid));
	pInfo[playerid][pNavi] = mysql_GetInt("accounts", "Navi", "Name", SpielerName(playerid));
	pInfo[playerid][pGesellschaft] =  mysql_GetInt("accounts", "Gesellschaft", "Name", SpielerName(playerid));
	pInfo[playerid][pRucksack] = mysql_GetInt("accounts", "Rucksack", "Name", SpielerName(playerid));
	pInfo[playerid][pVersicherung] = mysql_GetInt("accounts", "Versicherung", "Name", SpielerName(playerid));
	pInfo[playerid][pVerwarnungen] = mysql_GetInt("accounts", "Verwarnungen", "Name", SpielerName(playerid));
	SetPlayerFightingStyle(playerid,mysql_GetInt("accounts", "Kampfstil", "Name", SpielerName(playerid)));
	pInfo[playerid][pHunger] = mysql_GetInt("accounts", "Hunger", "Name", SpielerName(playerid));
	pInfo[playerid][pNummer] = mysql_GetInt("accounts", "Nummer", "Name", SpielerName(playerid));
	pInfo[playerid][pTelefonBuch] = mysql_GetInt("accounts", "TelefonBuch", "Name", SpielerName(playerid));
	pInfo[playerid][pDonator] = mysql_GetInt("accounts", "Donator", "Name", SpielerName(playerid));
	pInfo[playerid][pKopfgeld] = mysql_GetInt("accounts", "Kopfgeld", "Name", SpielerName(playerid));
	pInfo[playerid][pBiggestFish] = mysql_GetInt("accounts", "BiggestFish", "Name", SpielerName(playerid));
 	pInfo[playerid][pAufbrechen] = mysql_GetInt("accounts", "AufbrechenZeit", "Name", SpielerName(playerid));
 	pInfo[playerid][pMullTimer] = mysql_GetInt("accounts", "MüllZeit", "Name", SpielerName(playerid));

	FriedhofZeit[playerid] = mysql_GetInt("accounts", "FriedhofZeit", "Name", SpielerName(playerid));
	FriedhofStatus[playerid] = mysql_GetInt("accounts", "FriedhofStatus", "Name", SpielerName(playerid));
	pInfo[playerid][pTotX] = mysql_GetFloat("accounts", "TotX", "Name", SpielerName(playerid));
	pInfo[playerid][pTotY] = mysql_GetFloat("accounts", "TotY", "Name", SpielerName(playerid));
	pInfo[playerid][pTotZ] = mysql_GetFloat("accounts", "TotZ", "Name", SpielerName(playerid));
	pInfo[playerid][pTotW] = mysql_GetInt("accounts", "TotW", "Name", SpielerName(playerid));
	pInfo[playerid][pTotI] = mysql_GetInt("accounts", "TotI", "Name", SpielerName(playerid));

	pInfo[playerid][pLottonummer] = mysql_GetInt("accounts", "Lottonummer", "Name", SpielerName(playerid));
	pInfo[playerid][AuslogPosX] = mysql_GetInt("accounts", "AuslogPosX", "Name", SpielerName(playerid));
	pInfo[playerid][AuslogPosY] = mysql_GetInt("accounts", "AuslogPosY", "Name", SpielerName(playerid));
	pInfo[playerid][AuslogPosZ] = mysql_GetInt("accounts", "AuslogPosZ", "Name", SpielerName(playerid));
	pInfo[playerid][pAuslogWorld] = mysql_GetInt("accounts", "AuslogWorld", "Name", SpielerName(playerid));
	pInfo[playerid][pAuslogInt] = mysql_GetInt("accounts", "AuslogInt", "Name", SpielerName(playerid));

	pInfo[playerid][pKnastzeitGesamt] = mysql_GetInt("accounts", "KnastzeitGesamt", "Name", SpielerName(playerid));
	pInfo[playerid][pVerbrechen] = mysql_GetInt("accounts", "Verbrechen", "Name", SpielerName(playerid));
	pInfo[playerid][AuslogHeal] = mysql_GetFloat("accounts", "AuslogHeal", "Name", SpielerName(playerid));
	SetWeste(playerid,mysql_GetInt("accounts", "Weste", "Name", SpielerName(playerid)));
	pInfo[playerid][pAuslogDuty] = mysql_GetInt("accounts", "AuslogDuty", "Name", SpielerName(playerid));
	pInfo[playerid][pBiz] =mysql_GetInt("accounts", "biz", "Name", SpielerName(playerid));
	pInfo[playerid][pTeilbiz] = mysql_GetInt("accounts", "teilbiz", "Name", SpielerName(playerid));
	pInfo[playerid][pPBKills] = mysql_GetInt("accounts", "pbkills", "Name", SpielerName(playerid));
	pInfo[playerid][pPBDeath] = mysql_GetInt("accounts", "pbdeath", "Name", SpielerName(playerid));
	pInfo[playerid][pWSchein] = mysql_GetInt("accounts", "Waffenschein", "Name", SpielerName(playerid));
	pInfo[playerid][pSkillZeit] = mysql_GetInt("accounts", "SkillZeit", "Name", SpielerName(playerid));
	pInfo[playerid][pHochsicherheit] = mysql_GetInt("accounts", "Hochsicherheit", "Name", SpielerName(playerid));
	pInfo[playerid][pKnast] = mysql_GetInt("accounts", "Knast", "Name", SpielerName(playerid));
	pInfo[playerid][pSucht] =mysql_GetInt("accounts", "Sucht", "Name", SpielerName(playerid));
	pInfo[playerid][pSafe_Marihuana] = mysql_GetInt("accounts", "safe_Marihuana", "Name", SpielerName(playerid));
	pInfo[playerid][pSafe_Heroin] = mysql_GetInt("accounts", "safe_Heroin", "Name", SpielerName(playerid));
	pInfo[playerid][pSafe_Mats] = mysql_GetInt("accounts", "safe_Mats", "Name", SpielerName(playerid));
	pInfo[playerid][pJobSkill1] = mysql_GetInt("accounts", "JobSkill1", "Name", SpielerName(playerid));
	pInfo[playerid][pGeradeEingeloggt] = 1;
	SkillInfo[playerid][23] = mysql_GetInt("accounts", "Skill23", "Name", SpielerName(playerid));
	SkillInfo[playerid][24] = mysql_GetInt("accounts", "Skill24", "Name", SpielerName(playerid));
	SkillInfo[playerid][29] = mysql_GetInt("accounts", "Skill29", "Name", SpielerName(playerid));
	SkillInfo[playerid][30] = mysql_GetInt("accounts", "Skill30", "Name", SpielerName(playerid));
	SkillInfo[playerid][31] = mysql_GetInt("accounts", "Skill31", "Name", SpielerName(playerid));
	weapons[playerid][1][0]= mysql_GetInt("accounts", "WaffeSlot1", "Name", SpielerName(playerid));
	weapons[playerid][1][1]= mysql_GetInt("accounts", "WaffeMuni1", "Name", SpielerName(playerid));
	weapons[playerid][2][0]= mysql_GetInt("accounts", "WaffeSlot2", "Name", SpielerName(playerid));
	weapons[playerid][2][1]= mysql_GetInt("accounts", "WaffeMuni2", "Name", SpielerName(playerid));
	weapons[playerid][3][0]= mysql_GetInt("accounts", "WaffeSlot3", "Name", SpielerName(playerid));
	weapons[playerid][3][1]= mysql_GetInt("accounts", "WaffeMuni3", "Name", SpielerName(playerid));
	weapons[playerid][4][0]= mysql_GetInt("accounts", "WaffeSlot4", "Name", SpielerName(playerid));
	weapons[playerid][4][1]= mysql_GetInt("accounts", "WaffeMuni4", "Name", SpielerName(playerid));
	weapons[playerid][5][0]= mysql_GetInt("accounts", "WaffeSlot5", "Name", SpielerName(playerid));
	weapons[playerid][5][1]= mysql_GetInt("accounts", "WaffeMuni5", "Name", SpielerName(playerid));
	weapons[playerid][6][0]= mysql_GetInt("accounts", "WaffeSlot6", "Name", SpielerName(playerid));
	weapons[playerid][6][1]= mysql_GetInt("accounts", "WaffeMuni6", "Name", SpielerName(playerid));
	weapons[playerid][7][0]= mysql_GetInt("accounts", "WaffeSlot7", "Name", SpielerName(playerid));
	weapons[playerid][7][1]= mysql_GetInt("accounts", "WaffeMuni7", "Name", SpielerName(playerid));
	weapons[playerid][8][0]= mysql_GetInt("accounts", "WaffeSlot8", "Name", SpielerName(playerid));
	weapons[playerid][8][1]= mysql_GetInt("accounts", "WaffeMuni8", "Name", SpielerName(playerid));
	weapons[playerid][9][0]= mysql_GetInt("accounts", "WaffeSlot9", "Name", SpielerName(playerid));
	weapons[playerid][9][1]= mysql_GetInt("accounts", "WaffeMuni9", "Name", SpielerName(playerid));
	weapons[playerid][10][0] = mysql_GetInt("accounts", "WaffeSlot10", "Name", SpielerName(playerid));
	weapons[playerid][10][1]= mysql_GetInt("accounts", "WaffeMuni10", "Name", SpielerName(playerid));
	weapons[playerid][11][0]= mysql_GetInt("accounts", "WaffeSlot11", "Name", SpielerName(playerid));
	weapons[playerid][11][1]= mysql_GetInt("accounts", "WaffeMuni11", "Name", SpielerName(playerid));
	weapons[playerid][12][0]= mysql_GetInt("accounts", "WaffeSlot12", "Name", SpielerName(playerid));
	weapons[playerid][12][1]= mysql_GetInt("accounts", "WaffeMuni12", "Name", SpielerName(playerid));
	AutosysLoadplayer(playerid);
	LoadPlayerInv(playerid);
	LoadPlayerApp(playerid);
	LoadPlayerCoinS(playerid);
	pInfo[playerid][pRespektpunkteBenotigt] =GetPlayerScore(playerid) * 3;
	SpawnPlayer(playerid);
	ReloadWeaponSkills(playerid);
	return 0;
}

Alles anzeigen

Das sollte der Code sein.. Jeffry:

Jeffry · 26. Juli 2015

Ah, das sind Abfragen.
Dann schau in deiner Datenbank, in den Tabellen, nach den in der Fehlermeldung angegebenen Spalten und gebe diesen einen DEFAULT Wert, also wahrscheinlich einfach nur 0. Dann sollte es klappen.

ryaN.iXi · 27. Juli 2015

Zitat von Jeffry

Ah, das sind Abfragen.
Dann schau in deiner Datenbank, in den Tabellen, nach den in der Fehlermeldung angegebenen Spalten und gebe diesen einen DEFAULT Wert, also wahrscheinlich einfach nur 0. Dann sollte es klappen.

Geht nicht ...

Jeffry · 27. Juli 2015

Was geht nicht?

ryaN.iXi · 27. Juli 2015

Zitat von Jeffry

Was geht nicht?

Habs geschafft, dankeschön

breadfish.de 12. März 2022