Gamemode Startet Nicht! (mit Mysql)

LMNTRIX · 9. Oktober 2011

Hallo Liebe Breadfisher,
kann mir jemand helfen wie ich mein server anbekomme.
Ich habe mir beim localhost eine Datenbank erstellt.

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3c R2, (C)2005-2011 SA-MP Team

[12:59:32] filterscripts = "" (string)
[12:59:32]
[12:59:32] Server Plugins
[12:59:32] --------------
[12:59:32] Loading plugin: streamer
[12:59:32]

*** Streamer Plugin v2.5.2 by Incognito loaded ***

[12:59:32] Loaded.
[12:59:32] Loading plugin: sscanf
[12:59:32]

[12:59:32] ===============================

[12:59:32] sscanf plugin loaded.

[12:59:32] ===============================

[12:59:32] Loaded.
[12:59:32] Loading plugin: audio
[12:59:32]

*** Audio Plugin v0.5 by Incognito loaded ***

[12:59:32] Loaded.
[12:59:32] Loading plugin: mysql
[12:59:33] Failed.
[12:59:33] Loaded 3 plugins.

[12:59:33]
[12:59:33] Ban list
[12:59:33] --------
[12:59:33] Loaded: samp.ban
[12:59:33]
[12:59:33]
[12:59:33] Filter Scripts
[12:59:33] ---------------
[12:59:33] Loaded 0 filter scripts.

[12:59:33] Script[gamemodes/bearbeitung.amx]: Run time error 19: "File or function is not found"
[12:59:33] Number of vehicle models: 0

Es verbindet sich mit meinem Localhost doch das problem ist.Wie erstelle ich die Tabellen.Also welche brauch ich.Sowas findet man im Script aber ich weiss nicht wie.Wäre Echt dankbar wenn das jemand weiss oder der mir helfen würde.

Mit freundlichen Grüßen

Carey

|GXR|B3ar · 9. Oktober 2011

Alle Includes, etc?

LMNTRIX · 9. Oktober 2011

Alle Includes Sind vorhanden!
Ich bin mir Sehr sicher das es an den Scriptfiles liegt und an der Datenbank bei 'http://localhost/phpmyadmin/

//Edit ich weiss nur nicht was ich erstellen muss.Wäre nett wenn einer reinschauen würde

|GXR|B3ar · 9. Oktober 2011

Du brauchst eine MYSQL Datenbank`?

LMNTRIX · 9. Oktober 2011

Ne ich habe mir eine Erstellt.
Doch man muss ja auch die Tabellen dazu erstellen.
Ich weiss wie man die erstellt aber was soll ich reinsetzen.
Viele Sagten steht im Gamemode.Ich habe nachgeschaut.Ich habe es gefunden mit dem Mysql datenbank tabellen.Doch wie soll ich es umsetzen.?
Hier mal vom Script die Zeilen

new string[128];
new query[256], pName[MAX_PLAYER_NAME];
GetPlayerName(playerid, pName, sizeof(pName));
format(query,sizeof(query),"SELECT Level FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pLevel] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT AdminLevel FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pAdmin] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT DonateRank FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pDonateRank] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Registered FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pRegistered] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Tutorial FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pTut] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Sex FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pSex] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Age FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pAge] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Experience FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pExp] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Money FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pCash] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Gun1 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pGun1] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Gun2 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pGun2] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Gun3 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pGun3] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Gun4 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pGun4] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Ammo1 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pAmmo1] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Ammo2 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pAmmo2] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Ammo3 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pAmmo3] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Ammo4 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pAmmo4] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Bank FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pBank] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Skin FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pSkin] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Drugs FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pDrugs] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Materials FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pMaterials] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Products FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pProducts] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Job FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pJob] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT ContractTime FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pContractTime] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT PlayingHours FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pPlayingHours] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT AllowedPayday FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pAllowedPayday] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT PayCheck FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pPayCheck] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Faction FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pFaction] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Rank FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pRank] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT HouseKey FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pHouseKey] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT BizKey FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pBizKey] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT SpawnPoint FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pSpawnPoint] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Warnings FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pWarnings] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT CarLic FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pCarLic] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT ECKart FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pECKart] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT FlyLic FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pFlyLic] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT WepLic FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pWepLic] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT VisitPass FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pVisitPass] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT PhoneNumber FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pPhoneNumber] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT PhoneC FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pPhoneC] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT PhoneBook FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pPhoneBook] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT LottoNr FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pLottoNr] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT ListNumber FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pListNumber] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Donator FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pDonator] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Jailed FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pJailed] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT JailTime FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pJailTime] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Hospital FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pHospital] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Note1 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(PlayerInfo[playerid][pNote1]);
mysql_free_result();
format(query,sizeof(query),"SELECT Note1s FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pNote1s] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Note2 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(PlayerInfo[playerid][pNote2]);
mysql_free_result();
format(query,sizeof(query),"SELECT Note2s FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pNote2s] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Note3 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(PlayerInfo[playerid][pNote3]);
mysql_free_result();
format(query,sizeof(query),"SELECT Note3s FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pNote3s] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Note4 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(PlayerInfo[playerid][pNote4]);
mysql_free_result();
format(query,sizeof(query),"SELECT Note4s FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pNote4s] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Note5 FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(PlayerInfo[playerid][pNote5]);
mysql_free_result();
format(query,sizeof(query),"SELECT Note5s FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pNote5s] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT LoadPosX FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
new Float:PlayerPosX; mysql_fetch_float(Float:PlayerPosX); PlayerInfo[playerid][pLoadPosX] = Float:PlayerPosX;
mysql_free_result();
format(query,sizeof(query),"SELECT LoadPosY FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
new Float:PlayerPosY; mysql_fetch_float(Float:PlayerPosY); PlayerInfo[playerid][pLoadPosY] = Float:PlayerPosY;
mysql_free_result();
format(query,sizeof(query),"SELECT LoadPosZ FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
new Float:PlayerPosZ; mysql_fetch_float(Float:PlayerPosZ); PlayerInfo[playerid][pLoadPosZ] = Float:PlayerPosZ;
mysql_free_result();
format(query,sizeof(query),"SELECT LoadPosInt FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pLoadPosInt] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT LoadPosW FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pLoadPosW] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT LoadPos FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pLoadPos] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT AccountLocked FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pLocked] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Handyguthaben FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pHandyguthaben] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Handyart FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pHandyart] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT ADACSkill FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pADACSkill] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT AnwaltSkill FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pAnwaltSkill] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT WaffenDealerSkill FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pWaffenDealerSkill] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT DrogendealerSkill FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pDrogendealerSkill] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT PaketSkill FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pPaketSkill] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT GeldfahrerSkill FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pGeldfahrerSkill] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Skillvorschritt FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pSkillvorschritt] = mysql_fetch_int();
mysql_free_result();
format(query,sizeof(query),"SELECT Wanted FROM `user` WHERE Name = '%s' LIMIT 1",pName);
mysql_query(query);
mysql_store_result();
PlayerInfo[playerid][pWanted] = mysql_fetch_int();
mysql_free_result();
//Edit z.b SELECT Level FROM `user` WHERE Name = '%s' LIMIT 1 Wie soll ich das umsetzen bei phpmyadmin? wäre echt dankbar!

[PRR]Jones · 9. Oktober 2011

Melde dich bei mir, ich kenne ich mit den dingen aus.

Grüße,
Jones

DiZZerZ · 9. Oktober 2011

Sind evt. nicht alle Ordner im Scriptfiles Ordner ?

Trooper[Y] · 9. Oktober 2011

Zitat von Carey_Mahoney

[12:59:32] Loading plugin: mysql
[12:59:33] Failed.

Es verbindet sich mit meinem Localhost doch das problem ist.

Wie kommst du eine derartig sinnfreie Schlussfolgerung ?

Der Fehler ist so eindeutig, eindeutiger gehts garnicht.
Das Plugin heißt anders oder ist fehlerhaft.

Zitat

Melde dich bei mir, ich kenne ich mit den dingen aus.

Externer Inhalt www.youtube.com

Inhalte von externen Seiten werden ohne Ihre Zustimmung nicht automatisch geladen und angezeigt.

Durch die Aktivierung der externen Inhalte erklären Sie sich damit einverstanden, dass personenbezogene Daten an Drittplattformen übermittelt werden. Mehr Informationen dazu haben wir in unserer Datenschutzerklärung zur Verfügung gestellt.

breadfish.de 11. März 2022