SA-MP Server schließt sich nach Login

Crash129 · 14. September 2011

Hey,

Ich möchte das Moderntopia Script weiterverwenden als Anfangsscript für einen SA-MP Server. So nun mein Problem:
Ich hab das Script erstmal unverändert gelassen, nur die MySQL Daten eingetragen (Ich benutze WAMP Server). Als ich danach versucht habe, mich zu registrieren hat dies auch funktioniert aber als ich dann /login eingegeben hab, hat sich der Server geschlossen

Zitat

[14:50:24] Incoming connection: 127.0.0.1:52167
[14:50:25] [join] Crash129 has joined the server (0:127.0.0.1)

Danach ist Ende...
In der DB ist mein Account auch abgespeichert aber wenn ich jetzt auf den Server joine crasht er schon.
Woran liegt das?
Dieses Plugin nutze ich für MySQL

TommyAkaServus · 14. September 2011

poste doch mal den entsprechenden code...

Crash129 · 14. September 2011

Standard Moderntopia halt

Zitat

if (strcmp(cmd, "/login", true) ==0 )
{
if(IsPlayerConnected(playerid))
{
new tmppass[64];
if(gPlayerLogged[playerid] == 1)
{
SendClientMessage(playerid, TEAM_AZTECAS_COLOR, "SERVER: You are already logged in.");
return 1;
}
tmp = strtok(cmdtext, idx);
if(!strlen(tmp))
{
SendClientMessage(playerid, TEAM_AZTECAS_COLOR, "USAGE: /login [password]");
return 1;
}
//Encrypt(tmp);
OnPlayerLogin(playerid,tmp);
}
return 1;
}

Alles anzeigen

Zitat

public OnPlayerLogin(playerid,password[]) // by Luk0r v1.0
{
MySQLCheckConnection();
new tmp2[256];
new string2[64];
new playername2[MAX_PLAYER_NAME];
new playernamesplit[3][MAX_PLAYER_NAME];
GetPlayerName(playerid, playername2, sizeof(playername2));
split(playername2, playernamesplit, '_');
MySQLFetchAcctSingle(PlayerInfo[playerid][pSQLID], "Password", PlayerInfo[playerid][pKey]);
if(strcmp(PlayerInfo[playerid][pKey],password, true ) == 0 )
{
new Data[1024];
new Field[64];
new rcnt = 1;
MySQLFetchAcctRecord(PlayerInfo[playerid][pSQLID], Data);
samp_mysql_strtok(Field, "|", Data);
while (samp_mysql_strtok(Field, "|", "")==1)
{
if (rcnt == 3) PlayerInfo[playerid][pLevel] = strval(Field);
if (rcnt == 4) PlayerInfo[playerid][pAdmin] = strval(Field);
if (rcnt == 5) PlayerInfo[playerid][pDonateRank] = strval(Field);
if (rcnt == 6) PlayerInfo[playerid][gPupgrade] = strval(Field);
if (rcnt == 7) PlayerInfo[playerid][pConnectTime] = strval(Field);
if (rcnt == PlayerInfo[playerid][pReg] = strval(Field);
if (rcnt == 9) PlayerInfo[playerid][pSex] = strval(Field);
if (rcnt == 10) PlayerInfo[playerid][pAge] = strval(Field);
if (rcnt == 11) PlayerInfo[playerid][pOrigin] = strval(Field);
if (rcnt == 12) PlayerInfo[playerid][pCK] = strval(Field);
if (rcnt == 13) PlayerInfo[playerid][pMuted] = strval(Field);
if (rcnt == 14) PlayerInfo[playerid][pExp] = strval(Field);
if (rcnt == 15) PlayerInfo[playerid][pCash] = strval(Field);
if (rcnt == 16) PlayerInfo[playerid][pAccount] = strval(Field);
if (rcnt == 17) PlayerInfo[playerid][pCrimes] = strval(Field);
if (rcnt == 18) PlayerInfo[playerid][pKills] = strval(Field);
if (rcnt == 19) PlayerInfo[playerid][pDeaths] = strval(Field);
if (rcnt == 20) PlayerInfo[playerid][pArrested] = strval(Field);
if (rcnt == 21) PlayerInfo[playerid][pWantedDeaths] = strval(Field);
if (rcnt == 22) PlayerInfo[playerid][pPhoneBook] = strval(Field);
if (rcnt == 23) PlayerInfo[playerid][pLottoNr] = strval(Field);
if (rcnt == 24) PlayerInfo[playerid][pFishes] = strval(Field);
if (rcnt == 25) PlayerInfo[playerid][pBiggestFish] = strval(Field);
if (rcnt == 26) PlayerInfo[playerid][pJob] = strval(Field);
if (rcnt == 27) PlayerInfo[playerid][pPayCheck] = strval(Field);
if (rcnt == 28) PlayerInfo[playerid][pHeadValue] = strval(Field);
if (rcnt == 29) PlayerInfo[playerid][pJailed] = strval(Field);
if (rcnt == 30) PlayerInfo[playerid][pJailTime] = strval(Field);
if (rcnt == 31) PlayerInfo[playerid][pMats] = strval(Field);
if (rcnt == 32) PlayerInfo[playerid][pDrugs] = strval(Field);
if (rcnt == 33) PlayerInfo[playerid][pLeader] = strval(Field);
if (rcnt == 34) PlayerInfo[playerid][pMember] = strval(Field);
if (rcnt == 35) PlayerInfo[playerid][pFMember] = strval(Field);
if (rcnt == 36) PlayerInfo[playerid][pRank] = strval(Field);
if (rcnt == 37) PlayerInfo[playerid][pChar] = strval(Field);
if (rcnt == 38) PlayerInfo[playerid][pContractTime] = strval(Field);
if (rcnt == 39) PlayerInfo[playerid][pDetSkill] = strval(Field);
if (rcnt == 40) PlayerInfo[playerid][pSexSkill] = strval(Field);
if (rcnt == 41) PlayerInfo[playerid][pBoxSkill] = strval(Field);
if (rcnt == 42) PlayerInfo[playerid][pLawSkill] = strval(Field);
if (rcnt == 43) PlayerInfo[playerid][pMechSkill] = strval(Field);
if (rcnt == 44) PlayerInfo[playerid][pJackSkill] = strval(Field);
if (rcnt == 45) PlayerInfo[playerid][pCarSkill] = strval(Field);
if (rcnt == 46) PlayerInfo[playerid][pNewsSkill] = strval(Field);
if (rcnt == 47) PlayerInfo[playerid][pDrugsSkill] = strval(Field);
if (rcnt == 48) PlayerInfo[playerid][pCookSkill] = strval(Field);
if (rcnt == 49) PlayerInfo[playerid][pFishSkill] = strval(Field);
if (rcnt == 50) PlayerInfo[playerid][pSHealth] = floatstr(Field);
if (rcnt == 51) PlayerInfo[playerid][pHealth] = floatstr(Field);
if (rcnt == 52) PlayerInfo[playerid][pInt] = strval(Field);
if (rcnt == 53) PlayerInfo[playerid][pLocal] = strval(Field);
if (rcnt == 54) PlayerInfo[playerid][pTeam] = strval(Field);
if (rcnt == 55) PlayerInfo[playerid][pModel] = strval(Field);
if (rcnt == 56) PlayerInfo[playerid][pPnumber] = strval(Field);
if (rcnt == 57) PlayerInfo[playerid][pPhousekey] = strval(Field);
if (rcnt == 58) PlayerInfo[playerid][pPcarkey] = strval(Field);
if (rcnt == 59) PlayerInfo[playerid][pPapptkey] = strval(Field);
if (rcnt == 60) PlayerInfo[playerid][pPbiskey] = strval(Field);
if (rcnt == 61) PlayerInfo[playerid][pPos_x] = floatstr(Field);
if (rcnt == 62) PlayerInfo[playerid][pPos_y] = floatstr(Field);
if (rcnt == 63) PlayerInfo[playerid][pPos_z] = floatstr(Field);
if (rcnt == 64) PlayerInfo[playerid][pCarLic] = strval(Field);
if (rcnt == 65) PlayerInfo[playerid][pFlyLic] = strval(Field);
if (rcnt == 66) PlayerInfo[playerid][pBoatLic] = strval(Field);
if (rcnt == 67) PlayerInfo[playerid][pFishLic] = strval(Field);
if (rcnt == 68) PlayerInfo[playerid][pGunLic] = strval(Field);
if (rcnt == 69) PlayerInfo[playerid][pGun1] = strval(Field);
if (rcnt == 70) PlayerInfo[playerid][pGun2] = strval(Field);
if (rcnt == 71) PlayerInfo[playerid][pGun3] = strval(Field);
if (rcnt == 72) PlayerInfo[playerid][pGun4] = strval(Field);
if (rcnt == 73) PlayerInfo[playerid][pAmmo1] = strval(Field);
if (rcnt == 74) PlayerInfo[playerid][pAmmo2] = strval(Field);
if (rcnt == 75) PlayerInfo[playerid][pAmmo3] = strval(Field);
if (rcnt == 76) PlayerInfo[playerid][pAmmo4] = strval(Field);
if (rcnt == 77) PlayerInfo[playerid][pCarTime] = strval(Field);
if (rcnt == 78) PlayerInfo[playerid][pPayDay] = strval(Field);
if (rcnt == 79) PlayerInfo[playerid][pPayDayHad] = strval(Field);
if (rcnt == 80) PlayerInfo[playerid][pCDPlayer] = strval(Field);
if (rcnt == 81) PlayerInfo[playerid][pWins] = strval(Field);
if (rcnt == 82) PlayerInfo[playerid][pLoses] = strval(Field);
if (rcnt == 83) PlayerInfo[playerid][pAlcoholPerk] = strval(Field);
if (rcnt == 84) PlayerInfo[playerid][pDrugPerk] = strval(Field);
if (rcnt == 85) PlayerInfo[playerid][pMiserPerk] = strval(Field);
if (rcnt == 86) PlayerInfo[playerid][pPainPerk] = strval(Field);
if (rcnt == 87) PlayerInfo[playerid][pTraderPerk] = strval(Field);
if (rcnt == 88) PlayerInfo[playerid][pTut] = strval(Field);
if (rcnt == 89) PlayerInfo[playerid][pMissionNr] = strval(Field);
if (rcnt == 90) PlayerInfo[playerid][pWarns] = strval(Field);
if (rcnt == 91) PlayerInfo[playerid][pAdjustable] = strval(Field);
if (rcnt == 92) PlayerInfo[playerid][pFuel] = strval(Field);
if (rcnt == 93) PlayerInfo[playerid][pMarried] = strval(Field);
if (rcnt == 94) PlayerInfo[playerid][pMarriedTo] = strmid(PlayerInfo[playerid][pMarriedTo], Field, 0, strlen(Field)-1, 255);
if (rcnt == 96) PlayerInfo[playerid][pLinked] = strval(Field);
if (rcnt == 97) PlayerInfo[playerid][pDeagle] = strval(Field);
if (rcnt == 98) PlayerInfo[playerid][pShotgun] = strval(Field);
if (rcnt == 99) PlayerInfo[playerid][pRifle] = strval(Field);
if (rcnt == 100) PlayerInfo[playerid][pSDPistol] = strval(Field);
if (rcnt == 101) PlayerInfo[playerid][pMP5] = strval(Field);
if (rcnt == 102) PlayerInfo[playerid][pM4] = strval(Field);
if (rcnt == 103) PlayerInfo[playerid][pAK47] = strval(Field);
rcnt++;
}
samp_mysql_free_result();
}
else
{
SendClientMessage(playerid, COLOR_WHITE, "SERVER: Password does not match your name.");
//fclose(UserFile);
gPlayerLogTries[playerid] += 1;
if(gPlayerLogTries[playerid] == 4) { Ban(playerid); }
return 1;
}
PlayerInfo[playerid][pAdjustable] = 0;
SafeResetPlayerMoney(playerid);
//ConsumingMoney[playerid] = 1;
//CurrentMoney[playerid] = PlayerInfo[playerid][pCash];
SafeGivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);

SafeGivePlayerWeapon(playerid,24,PlayerInfo[playerid][pDeagle]);
SafeGivePlayerWeapon(playerid,25,PlayerInfo[playerid][pShotgun]);
SafeGivePlayerWeapon(playerid,33,PlayerInfo[playerid][pRifle]);
SafeGivePlayerWeapon(playerid,23,PlayerInfo[playerid][pSDPistol]);
SafeGivePlayerWeapon(playerid,29,PlayerInfo[playerid][pMP5]);
SafeGivePlayerWeapon(playerid,31,PlayerInfo[playerid][pM4]);
SafeGivePlayerWeapon(playerid,30,PlayerInfo[playerid][pAK47]);

if(PlayerInfo[playerid][pReg] == 0)
{
PlayerInfo[playerid][pLevel] = 1;
PlayerInfo[playerid][pSHealth] = 0.0;
PlayerInfo[playerid][pHealth] = 50.0;
PlayerInfo[playerid][pPos_x] = 2246.6;
PlayerInfo[playerid][pPos_y] = -1161.9;
PlayerInfo[playerid][pPos_z] = 1029.7;
PlayerInfo[playerid][pInt] = 15;
PlayerInfo[playerid][pLocal] = 255;
PlayerInfo[playerid][pTeam] = 3;
PlayerInfo[playerid][pModel] = 135;
new randphone = 100000 + random(899999);//minimum 1000 max 9999 //giving one at the start
PlayerInfo[playerid][pPnumber] = randphone;
PlayerInfo[playerid][pPhousekey] = 255;
PlayerInfo[playerid][pPcarkey] = 999;
PlayerInfo[playerid][pPapptkey] = 255;
PlayerInfo[playerid][pPbiskey] = 255;
PlayerInfo[playerid][pAccount] = 0;
PlayerInfo[playerid][pReg] = 1;
SafeGivePlayerMoney(playerid, 500);
}
if(PlayerInfo[playerid][pLevel] == -999) //autoban
{
Ban(playerid);
}
else if(PlayerInfo[playerid][pCK] > 0)
{
Kick(playerid);
}

// Add an entry to the login log
new ipaddress[16];
GetPlayerIp(playerid,ipaddress,sizeof(ipaddress));
MySQLAddLoginRecord(PlayerInfo[playerid][pSQLID], ipaddress);

ClearChatbox(playerid, 8);
format(string2, sizeof(string2), "Server: Welcome to the State of San Andreas, %s.",playernamesplit[0]);
SendClientMessage(playerid, COLOR_WHITE, string2);
SendClientMessage(playerid, COLOR_WHITE, " ");
printf("%s has logged in.",playername2);
if (PlayerInfo[playerid][pDonateRank] > 0)
{
SendClientMessage(playerid, COLOR_WHITE,"People of LS: Thank you for donating so we can live!");
}
if (PlayerInfo[playerid][pAdmin] > 0)
{
format(string2, sizeof(string2), "SERVER: You are logged in as a Level %d Admin.",PlayerInfo[playerid][pAdmin]);
SendClientMessage(playerid, COLOR_WHITE,string2);
}
if (PlayerInfo[playerid][pLinked] == 0)
{
SendClientMessage(playerid, COLOR_LIGHTRED, "WARNING: Your character is not linked to a website account! Register on moderntopia.com or some features will be restricted!");
}

// Reset the FirstSpawn variable
SetTimerEx("UnsetFirstSpawn", 5000, false, "i", playerid);

SetSpawnInfo(playerid, PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pModel], PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], 1.0, -1, -1, -1, -1, -1, -1);
if(gTeam[playerid] == 0)
{
gTeam[playerid] = 3;
}
else
{
gTeam[playerid] = PlayerInfo[playerid][pTeam];
}
gPlayerLogged[playerid] = 1;
SpawnPlayer(playerid);
format(tmp2, sizeof(tmp2), "~w~Welcome ~n~~y~ %s", playername2);
DateProp(playerid);
GameTextForPlayer(playerid, tmp2, 5000, 1);
//SendClientMessage(playerid, COLOR_YELLOW, motd);
if(PlayerInfo[playerid][pFMember] < 255)
{
format(tmp2, sizeof(tmp2), "Family MOTD: %s.", FamilyInfo[PlayerInfo[playerid][pFMember]][FamilyMOTD]);
SendClientMessage(playerid, COLOR_YELLOW, tmp2);
}
//}
return 1;
}

Alles anzeigen

Atrox · 14. September 2011

Ich hatte vor Kurzem einen Kunden, der hatte das gleiche Problem. Nach einer kurzen Suche im Forum konnte ich einige Beiträge lesen, in denen stand, dass es ein Fehler vom Plugin ist.
Daher empfehle ich dir ein anderes MySQL Plugin.
Der Kunde ist umgestiegen und seitdem funktoniert es einwandfrei.

Crash129 · 15. September 2011

Ok ich möchte auf dieses Plugin umsteigen, aber ich kenn mich nicht so mit MySQL aus und wollte fragen, was in diesem Plugin samp_mysql_strtok ist...

TommyAkaServus · 15. September 2011

dem 4ten post aus dem Thread des Plugin Release's zufolge:

Zitat

Quote:
Originally Posted by Bardokas
Need something better to get values. It would be great to have mysql_get_field() or c_strtok() like in [RAZ]ADreNaLiNe-DJ plugin are.
There is already a strtok function in PAWN.'mysql_fetch_row' returns like the following format if you selected more than one row in the query:

row1 row2 row3

Now you can just use strtok to split it in tokens.Also 'mysql_get_field' is probably a good idea for the next version.

Alles anzeigen

Sprich zuerst mit "mysql_fetch_row" abfragen und dann mit der standart funktion splitten...

PS: Kannst du zukünftig bitte den Pawno-Code in [ pwn][/ pwn] packen? Danke

breadfish.de 11. März 2022