[pomoc]Neizbacuje login

Započeo Obrisan korisnik
2. Apr. 2012. Zaključano
1,952
pregleda
17
postova
Deleted User
Obrisan korisnik
2. Apr. 2012.
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):
Deleted User
Obrisan korisnik
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  😐
Deleted User
Obrisan korisnik
3. Apr. 2012.
kako da rijesim to?
Deleted User
Obrisan korisnik
3. Apr. 2012.
Pogledaj da li se pod OnPlayerConnect poziva dijalog za logovanje ...
Deleted User
Obrisan korisnik
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;
}
Johnâ„¢
5
Godfather
3. Apr. 2012.
Daj da vidimo MySQL_Login() funkciju.
Deleted User
Obrisan korisnik
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;
}
Johnâ„¢
5
Godfather
3. Apr. 2012.
Daj još pokaži mysql_log.txt datoteku. Ako je nemaš onda dodaj prije mysql_connect() funkcije: mysql_debug(1); i ponovno pokreni mod i probaj se logirat.
Deleted User
Obrisan korisnik
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 )

Johnâ„¢
5
Godfather
3. Apr. 2012.
Umjesto ovog:

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.
Deleted User
Obrisan korisnik
3. Apr. 2012.
opet neizbacuje login dialog nakon restarta  😢 😢
Johnâ„¢
5
Godfather
3. Apr. 2012.
Oke. Daj mi sad server log.
Deleted User
Obrisan korisnik
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)
Johnâ„¢
5
Godfather
3. Apr. 2012.
Ne ispiše ti ništa u konzolu prilikom ulaska u server?
Deleted User
Obrisan korisnik
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?

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava

© 2026 SmartShark. All rights reserved.

Powered by Momentum|v2026.3.001 Alpha