Skripta koju koristim:Neki MYSQL
Detaljan opis problemaKada ugasim i ponovo upalim srv nece da mi izbaci login dialog
Dio skripte:
Neke slike/video za lakse dobivanje pomoci(neobavezno):
[pomoc]Neizbacuje login
Započeo Obrisan korisnik
•2. Apr. 2012.• Zaključano1,952
pregleda
17
postova
2. Apr. 2012.
2. Apr. 2012.
Pringles.cod2 wrote on April 2, 2012, 9:05 pm:
vidi u folderu plugins imas streamer i jel ti u cfg zadano ovo : plugins streamer ( ako pokreces na linuxu onda moramo ovako pisati plugins streamer.so
... ne vidim kralju kakve veze ima streamer sa loginom? Streamer je plugin za objekte, pickupe itd ... a ne za logovanje igraca 😐
3. Apr. 2012.
public OnPlayerConnect(playerid)
{
RemoveUnderScore(playerid);
TextDrawHideForPlayer(playerid, Textdraw1);
MoneyGiven = -1;
JustLogged = 0;
new query, pname;
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "SELECT IP FROM `playerdata` WHERE user = '%s' LIMIT 1", pname);
mysql_query(query);
mysql_store_result();
new rows = mysql_num_rows();
if(!rows)
{
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Please register",""White"Welcome to "Red""White"!\n"White"In order to start playing, you have to register!\n\n"White"Please insert a password below:", "Register", "Cancel");
}
if(rows == 1)
{
new IP;
mysql_fetch_field_row(IP,"IP");
GetPlayerIp(playerid, IP, 15);
if(strlen(IP) != 0 && !strcmp(IP, IP, true))
{
MySQL_Login(playerid);
}
else if(!strlen(IP) || strcmp(IP, IP, true))
{
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Please log-in", ""White"Welcome back to "Red""White"!\n"White"In order to start playing, you have to log-in!\n\n"White"Please insert "Red"your"White" password below:", "Login", "Cancel");
IsRegistered = 1;
}
}
mysql_free_result();
return 1;
}3. Apr. 2012.
Izvoli Joey_
stock MySQL_Login(playerid)
{
new query, pname, savingstring;
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "SELECT score, money, level, vip, admin, rank, kills, deaths, muted, jailed, frozen, mutedtimes, jailedtimes, frozentimes, banned, bannedby, logins, posx, posy, posz, posa FROM playerdata WHERE user = '%s'", pname);
mysql_query(query);
mysql_store_result();
while(mysql_fetch_row_format(query,"|"))
{
mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
mysql_fetch_field_row(savingstring, "money"); MoneyGiven = strval(savingstring);
mysql_fetch_field_row(savingstring, "level"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "vip"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "admin"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "rank"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "kills"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "muted"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "jailed"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "frozen"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "mutedtimes"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "jailedtimes"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "frozentimes"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "banned"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "bannedby"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "logins"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "posx"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "posy"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "posz"); PlayerInfo = strval(savingstring);
mysql_fetch_field_row(savingstring, "posa"); PlayerInfo = strval(savingstring);
}
mysql_free_result();
JustLogged = 1;
Logged = 1;
PlayerInfo++;
SendMessage(playerid, "~g~Info: ~w~You have been logged-in!");
SetSpawnInfo( playerid, 0, 0, 2231.7495,-1178.9769,29.8044, 269.15, 26, 36, 28, 150, 0, 0 );
SpawnPlayer(playerid);
return 1;
}3. Apr. 2012.
[20:58:19] ---------------------------
[20:58:19] MySQL Debugging activated (04/02/12)
[20:58:19] ---------------------------
[20:58:19]
[20:58:42] >> mysql_query( Connection handle: 1 )
[20:58:42] CMySQLHandler::Query(SELECT IP FROM `playerdata` WHERE user = 'doktorC' LIMIT 1) - Successfully executed.
[20:58:42] >> mysql_store_result( Connection handle: 1 )
[20:58:42] CMySQLHandler::StoreResult() - Result was stored.
[20:58:42] >> mysql_num_rows( Connection handle: 1 )
[20:58:42] CMySQLHandler::NumRows() - Returned 1 row(s)
[20:58:42] >> mysql_fetch_field_row( Connection handle: 1 )
3. Apr. 2012.
Umjesto ovog:
Stavi ovo (radi debuganja):
Kasnije ćeš moći izbrisati ove printove.
new IP;
mysql_fetch_field_row(IP,"IP");
GetPlayerIp(playerid, IP, 15);
Stavi ovo (radi debuganja):
new IP;
mysql_fetch_field_row(IP, "IP");
printf("IP: %s", IP);
GetPlayerIp(playerid, IP, 16);
printf("IP: %s", IP);
Kasnije ćeš moći izbrisati ove printove.
3. Apr. 2012.
----------------------
v0.3d-R2, (C)2005-2011 SA-MP Team
[15:07:40] filterscripts = "" (string)
[15:07:40]
[15:07:40] Server Plugins
[15:07:40] --------------
[15:07:40] Loading plugin: mysql
[15:07:40]
> MySQL plugin R6-2 successfully loaded.
[15:07:40] Loaded.
[15:07:40] Loading plugin: sscanf
[15:07:40]
[15:07:40] ===============================
[15:07:40] sscanf plugin loaded.
[15:07:40] (c) 2009 Alex "Y_Less" Cole
[15:07:40] ===============================
[15:07:40] Loaded.
[15:07:40] Loading plugin: streamer
[15:07:40]
*** Streamer Plugin v2.6 by Incognito loaded ***
[15:07:40] Loaded.
[15:07:40] Loaded 3 plugins.
[15:07:40]
[15:07:40] Filterscripts
[15:07:40] ---------------
[15:07:40] Loaded 0 filterscripts.
[15:07:40] Number of vehicle models: 0
[15:07:59] Incoming connection: 127.0.0.1:56428
[15:08:00] doktor has joined the server (0:127.0.0.1)3. Apr. 2012.
ne samo se restartuje 😢 😢
Jel mi mos na pm poslat neki dobar MySQL mod samo da je reg i log sistem napravljen?
Jel mi mos na pm poslat neki dobar MySQL mod samo da je reg i log sistem napravljen?
Morate biti prijavljeni da biste odgovorili na ovu temu.
Prijava