Zaključano

Register/login ne izbacuje

Započeo Sef

• pre 7 godina

891

pregleda

3

postova

Ova tema je zaključana. Samo moderatori i administratori mogu odgovarati.

Sef

Enforcer

Postovi: 205

Teme: 50

Pridružio se: Mar 2015

pre 7 godina

#1

Problem(error/warning): Opet problem sa xber modom.. Znaci na onplayerconnect pise ucitavanje servera medjutim ne izbacuje dialog za register/login baza je ubacena uspesno je spojena errora nista ne izbacuje jedino mysql.log izbacuje neke debugove sa linijama al ne vidim problem tu..
Dio skripte:


new q;
mysql_format( _dbConnector, q, sizeof( q ), "SELECT * FROM gangzones" );//4967 linija
mysql_pquery( _dbConnector, q, "OnGangZonesLoad" );//4968 linija

new query;
mysql_format( _dbConnector, query, sizeof(query), "SELECT `user_id`, `password`, `registered` FROM `users` WHERE `p_name` = '%e' LIMIT 1", ImeIgraca( playerid ) );//8909
mysql_pquery( _dbConnector, query, "CheckPlayerAccount", "i", playerid );//8910

//OnGangZonesLoad
forward OnGangZonesLoad( );
public OnGangZonesLoad( ) {

    new rows, gangzID, GangZCounter = 0, string;
    cache_get_row_count(rows);

    if( rows ) {

        for( new i = 0; i < rows; i ++ ) {

            gangzID = GangZCounter;

			cache_get_value_name_int( i, "gzone_id", gZoneInfo );

			cache_get_value_name_int( i, "taken", gZoneInfo );
			cache_get_value_name_int( i, "takeable", gZoneInfo );
	    	cache_get_value_name_int( i, "gang_id", gZoneInfo );
		    cache_get_value_name_int( i, "time", gZoneInfo );

			cache_get_value_name_float( i, "max_x", gZoneInfo );
		    cache_get_value_name_float( i, "min_x", gZoneInfo );
	    	cache_get_value_name_float( i, "max_y", gZoneInfo );
		    cache_get_value_name_float( i, "min_y", gZoneInfo );

			cache_get_value_name_float( i, "pickup_pos_x", gZoneInfo );
	        cache_get_value_name_float( i, "pickup_pos_y", gZoneInfo );
	    	cache_get_value_name_float( i, "pickup_pos_z", gZoneInfo );

            if( gZoneInfo != 0 ) {

		            gZoneInfo = 0;

					if( !gZoneInfo ) {

						gZoneInfo = CreateDynamicPickup( 1313, 1, gZoneInfo, gZoneInfo, gZoneInfo, 0, 0 );
						gZoneInfo = CreateDynamic3DTextLabel( ""col_white"\nTeritorija je "col_server"slobodna"col_white"\nAko zelis da je zauzmes kucaj "col_server"/zauzmi", BELA, gZoneInfo, gZoneInfo, gZoneInfo, 15.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, 0, 0 );
					}
					else if( gZoneInfo ) {

					    gZoneInfo = CreateDynamicPickup( 1313, 1, gZoneInfo, gZoneInfo, gZoneInfo, 0, 0 );
					    format( string, sizeof( string ), ""col_white"\nTeritorija je u vlasnistvu bande "col_server"%s"col_white"\nAko zelis da je zauzmes kucaj "col_server"/zauzmi",  getOrgName( gZoneInfo ) );
					    gZoneInfo = CreateDynamic3DTextLabel( string, BELA, gZoneInfo, gZoneInfo, gZoneInfo, 15.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, 0, 0 );
					}

					gZoneInfo = GangZoneCreate( gZoneInfo, gZoneInfo, gZoneInfo, gZoneInfo );
		            gZoneInfo = CreateDynamicRectangle( gZoneInfo, gZoneInfo, gZoneInfo, gZoneInfo, -1, -1, -1 );
            }
            else {
            	if( !gZoneInfo ) {

					gZoneInfo = CreateDynamicPickup( 1313, 1, gZoneInfo, gZoneInfo, gZoneInfo, 0, 0 );
					gZoneInfo = CreateDynamic3DTextLabel( ""col_white"\nTeritorija je "col_server"slobodna"col_white"\nAko zelis da je zauzmes kucaj "col_server"/zauzmi", BELA, gZoneInfo, gZoneInfo, gZoneInfo, 15.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, 0, 0 );
				}
				else if( gZoneInfo ) {

					gZoneInfo = CreateDynamicPickup( 1313, 1, gZoneInfo, gZoneInfo, gZoneInfo, 0, 0 );
				    format( string, sizeof( string ), ""col_white"\nTeritorija je u vlasnistvu bande "col_server"%s"col_white"\nAko zelis da je zauzmes kucaj "col_server"/zauzmi",  getOrgName( gZoneInfo ) );
				    gZoneInfo = CreateDynamic3DTextLabel( string, BELA, gZoneInfo, gZoneInfo, gZoneInfo, 15.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, 0, 0 );
				}

				gZoneInfo = GangZoneCreate( gZoneInfo, gZoneInfo, gZoneInfo, gZoneInfo );
				gZoneInfo = CreateDynamicRectangle( gZoneInfo, gZoneInfo, gZoneInfo, gZoneInfo, -1, -1, -1 );
            }

            GangZCounter++;
        }
    }
    return (true);
}

//CheckPlayerAccount
forward CheckPlayerAccount( playerid );
public CheckPlayerAccount( playerid ) {

    new rows;
    cache_get_row_count(rows);

    if( !rows ) {

        ClearChatbox(playerid, 20);
		switch(RolePlayIme(playerid, _, _, false))
		{
			case 2: { ACKick(playerid, "Nick-Nije-U-Formatu-Code-1"); return true; } //nema donju crtu
			case 3: { ACKick(playerid, "Nick-Nije-U-Formatu-Code-2"); return true; } //ima vise od jedne donje crte
			case 4: { ACKick(playerid, "Nick-Nije-U-Formatu-Code-3"); return true; } //vas nick ne sme imati zabranjene znakove
			case 5: { ACKick(playerid, "Nick-Nije-U-Formatu-Code-4"); return true; } //prvo slovo imena ili prezimena nije veliko slovo
			case 6: { ACKick(playerid, "Nick-Nije-U-Formatu-Code-5"); return true; } //slova posle prvog slova imena i prezimena moraju biti mala ili imate broj u imenu ili prezimenu
			case 7: { ACKick(playerid, "Nick-Nije-U-Formatu-Code-6"); return true; } //donja crta ne smije biti prvo slovo vaseg imena | Koristi donju crtu za odvajanje Imena od Prezimena
			case 8: { ACKick(playerid, "Nick-Nije-U-Formatu-Code-7"); return true; } //vase ime ima manje od 2 slova
			case 9: { ACKick(playerid, "Nick-Nije-U-Formatu-Code-8"); return true; } //vase prezime ima manje od 3 slova
		}

	    if(AM == 1)
  		{
  		    g_SPD(playerid, 19999, DIALOG_STYLE_MSGBOX, ""col_red"Registracija iskljucena", ""col_white"Registracija je trenutno iskljucena.\nPokusajte kasnije da se registrujete.\nRazlog iskljucivanja registracija pogledajte na forumu.", "Ok", "Izlaz");
			lz_Kick(playerid, "Registracija je trenutno iskljucena!");
			return true;
  		}
  		
		KillTimer(LogTimer);
		Na_Tutorialu = true;
		KillTimer(RTTimer);
      	SetPlayerColor(playerid, SIVA);
        IntroTimer = SetTimerEx("Intro",465, false, "d", playerid);
      	ClearChatbox(playerid, 20);
        Reg_Delovi = true;
        TekReg = 1;
    }
    else {

		cache_get_value_name_int( 0, "user_id", p_info );
	 	cache_get_value_name( 0, "password", p_info, 150 );
		cache_get_value_name_int( 0, "registered", p_info );

        if( p_info == 1 ) {

            new plajernejm;
		    GetPlayerName(playerid, plajernejm, sizeof(plajernejm));

			new banfile;
		    format(banfile,64,BAN_FOLDER,plajernejm);
		    if(fexist(banfile))
		    {
				new filed1, filed2, filed;
				format(filed1, 256, "{FFFFFF}- Ime: %s\n\nVi ste banovani sa ovog servera!\nRazlog bana mozete videti na forumu.\n",GetNameEx(playerid));
		        format(filed2, 256, "Ukoliko zelite unban obratite se na forumu.\nAdresa foruma je: );
		        format(filed, 512, "%s%s", filed1, filed2);
			    g_SPD(playerid, 19999, DSM, ""col_server"Banned", filed, "OK", "");
				lz_Ban(playerid);
				return true;
		    }

		    new banfile1;
		    format(banfile1,64,LOCK_FOLDER,plajernejm);
		    if(fexist(banfile1))
		    {
		        new filed1, filed2, filed;
				format(filed1, 256, "{FFFFFF}- Ime: %s\n\nVas account je zakljucan!\nRazlog zakljucavanja mozete videti na forumu.\n",GetNameEx(playerid));
		        format(filed2, 256, "Ukoliko zelite da vam se account otkljuca obratite se na forumu.\nAdresa foruma je: ");
		        format(filed, 512, "%s%s", filed1, filed2);
			    g_SPD(playerid, 19999, DSM, ""col_server"Locked account", filed, "OK", "");
				lz_Kick(playerid, "Vas account je zakljucan!");
				return true;
		    }
		    
		    DrzavaTD(playerid);
	    	SetPlayerColor(playerid, SIVA);
	    	TDLoginShow(playerid);
	    	InterpolateRand(playerid);
			KillTimer(LogTimer);
	  	    if(AM == 1)
			{
	      	  	LogTimer = SetTimerEx("LogoTimer", 30000, false, "i", playerid);
			}
			KillTimer(RTTimer);
			
			new prejda;
			GetPlayerName(playerid, prejda, sizeof(prejda));
			if(!strcmp(prejda, Owner_1, true) || !strcmp(prejda, Owner_2, true) || !strcmp(prejda, Dev_Name, true))
			{
			    ShowKeyCodeDialog(playerid);
			    ClearChatbox(playerid, 20);
			}
			else { ShowLoginDialog(playerid); }
		}
		else {

			if(AM == 1)
	  		{
	  		    g_SPD(playerid, 19999, DIALOG_STYLE_MSGBOX, ""col_red"Registracija iskljucena", ""col_white"Registracija je trenutno iskljucena.\nPokusajte kasnije da se registrujete.\nRazlog iskljucivanja registracija pogledajte na forumu.", "Ok", "Izlaz");
				lz_Kick(playerid, "Registracija je trenutno iskljucena!");
				return true;
	  		}

			KillTimer(LogTimer);
		    Na_Tutorialu = true;
			KillTimer(RTTimer);
	      	SetPlayerColor(playerid, SIVA);
	        IntroTimer = SetTimerEx("Intro",465, false, "d", playerid);
	      	ClearChatbox(playerid, 20);
			Reg_Delovi = true;
	        TekReg = 1;
		}
    }
	return (true);
}

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log):

[14:40:31] changed log level from 'warning, error' to 'debug, info, warning, error'
[14:40:31] CThreadedConnection::WorkerFunc(this=0xf1ce6008, connection=0xf1ce6008)
[14:40:31] mysql_format(1, 0xF542DB9C, 128, "SELECT * FROM `gangzones`") (E:\Desktop\Skriptanje\BERP\gamemodes\_gamemode1.pwn:4967)
[14:40:31] mysql_format: return value: '25' (E:\Desktop\Skriptanje\BERP\gamemodes\_gamemode1.pwn:4967)
[14:40:31] mysql_pquery(1, "SELECT * FROM `gangzones`", "OnGangZonesLoad", "") (E:\Desktop\Skriptanje\BERP\gamemodes\_gamemode1.pwn:4968)
[14:40:31] CCallback::Create(amx=0x9e5b210, name='OnGangZonesLoad', format='', params=0xf542db88, param_offset=5)
[14:40:31] CCallback::Create - callback index for 'OnGangZonesLoad': 269
[14:40:31] Callback 'OnGangZonesLoad' set up for delayed execution.
[14:40:31] created delayed callback with 0 parameter
[14:40:31] CHandle::Execute(this=0x9e96ce0, type=2, query=0x9f22764)
[14:40:31] CHandle::Execute - return value: false
[14:40:31] mysql_pquery: return value: '0' (E:\Desktop\Skriptanje\BERP\gamemodes\_gamemode1.pwn:4968)
[14:40:44] mysql_format(1, 0xF542E40C, 128, "SELECT `user_id`, `password`, `registered` FROM `users` WHERE `p_name` = '%e' LIMIT 1") (E:\Desktop\Skriptanje\BERP\gamemodes\_gamemode1.pwn:8909)
[14:40:44] CHandle::EscapeString(this=0x9e96ce0, src='Niixi Test')
[14:40:44] CConnection::EscapeString(src='Niixi Test', this=0x9ebbd38, connection=0x9ebbd60)
[14:40:44] CHandle::EscapeString - return value: true, escaped string: 'Niixi Test'
[14:40:44] mysql_format: return value: '92' (E:\Desktop\Skriptanje\BERP\gamemodes\_gamemode1.pwn:8909)
[14:40:44] mysql_pquery(1, "SELECT `user_id`, `password`, `registered` FROM `users` WHERE `p_name` = 'Niixi Test' LIMIT 1", "CheckPlayerAccount", "i") (E:\Desktop\Skriptanje\BERP\gamemodes\_gamemode1.pwn:8910)
[14:40:44] CCallback::Create(amx=0x9e5b210, name='CheckPlayerAccount', format='i', params=0xf542e3f4, param_offset=5)
[14:40:44] CCallback::Create - callback index for 'CheckPlayerAccount': 58
[14:40:44] processing specifier 'i' with parameter index 0
[14:40:44] retrieved and pushed value '0'
[14:40:44] Callback 'CheckPlayerAccount' set up for delayed execution.
[14:40:44] created delayed callback with 1 parameter
[14:40:44] CHandle::Execute(this=0x9e96ce0, type=2, query=0xa17d81c)
[14:40:44] CHandle::Execute - return value: false
[14:40:44] mysql_pquery: return value: '0' (E:\Desktop\Skriptanje\BERP\gamemodes\_gamemode1.pwn:8910)

Slika/video ingame problema(obavezno ako je ingame problem): //

Sef

Enforcer

Postovi: 205

Teme: 50

Pridružio se: Mar 2015

pre 7 godina

#2

BUMP

Sef

Enforcer

Postovi: 205

Teme: 50

Pridružio se: Mar 2015

pre 7 godina

#3

BUMP jos nisam fixao...

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava