Jump to content

anonim23

Membru
  • Posts

    65
  • Joined

  • Last visited

Posts posted by anonim23

  1. 1 hour ago, HPQ123 said:

    Jhon nu ai connectat baza de date ?

    Ba da frate, uite. 

    Quote
    
    public OnGameModeInit()
    {
    	mysql_log(LOG_ERROR, LOG_TYPE_TEXT);
    	if(SERVER_HOSTSTATUS == 1) SQL = mysql_connect("localhost", "root", "l2p", ""), print("Server: hosted"); 
    	else SQL = mysql_connect("localhost", "root", "l2p", ""), print("Server: localhost");

     

     

  2. Salut, pentru inceput vreau sa zic ca sunt incepator, deci no hate.

    Deci am si eu gm ul asta l2p, am conectat baza de date la el(pe localhost), l-am compilat si dupa cand vreau sa il pornesc imi apare asta.

    
    ----------
    Loaded log file: "server_log.txt".
    ----------
    
    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team
    
    [11:18:54] 
    [11:18:54] Server Plugins
    [11:18:54] --------------
    [11:18:54]  Loading plugin: crashdetect
    [11:18:54]   CrashDetect v4.15.1 is OK.
    [11:18:54]   Loaded.
    [11:18:54]  Loading plugin: sscanf
    [11:18:54] 
    
    [11:18:54]  ===============================
    
    [11:18:54]       sscanf plugin loaded.     
    
    [11:18:54]          Version:  2.8.1        
    
    [11:18:54]    (c) 2012 Alex "Y_Less" Cole  
    
    [11:18:54]  ===============================
    
    [11:18:54]   Loaded.
    [11:18:54]  Loading plugin: mysql
    [11:18:54]  >> plugin.mysql: R34 successfully loaded.
    [11:18:54]   Loaded.
    [11:18:54]  Loading plugin: streamer
    [11:18:54] 
    
    *** Streamer Plugin v2.7.7 by Incognito loaded ***
    
    [11:18:54]   Loaded.
    [11:18:54]  Loaded 4 plugins.
    
    [11:18:54] 
    [11:18:54] Ban list
    [11:18:54] --------
    [11:18:54]  Loaded: samp.ban
    [11:18:54] 
    [11:18:54] 
    [11:18:54] Filterscripts
    [11:18:54] ---------------
    [11:18:54]   Loaded 0 filterscripts.
    
    [11:18:57]  
    [11:18:57]  
    [11:18:57]  
    [11:18:57]  ======================================= 
    [11:18:57]  |                                     | 
    [11:18:57]  |        YSI version 3.09.0684        | 
    [11:18:57]  |        By Alex "Y_Less" Cole        | 
    [11:18:57]  |                                     | 
    [11:18:57]  ======================================= 
    [11:18:57]  
    [11:18:57]  
    [11:18:57]  
    [11:18:58] Server: hosted
    [11:18:58] Server vehicles: 0
    [11:18:58] Safezones: 0
    [11:18:58] Houses: 0
    [11:18:58] Clans: 0
    [11:18:58] Clan zones: 0
    [11:18:58] Bussines: 0
    [11:18:58] Turfs: 0
    [11:18:58] Factions: 0
    [11:18:58] Jobs: 0
    [11:18:58] Furnitures: 0
    [11:18:58] Stuff Loaded
    [11:18:59] Safes: 0
    [11:18:59] Number of vehicle models: 18
    [11:18:59] ====================================================================
    [11:18:59] Error ID: 2006, Error: MySQL server has gone away
    [11:18:59] Callback: LoadDSVeh
    [11:18:59] gQuery: SELECT * FROM `dsveh`
    [11:18:59] ====================================================================

    In baza de date am dsveh, de conectat la baza de date e conectat, ca nu s prost.

    Deci ce sa fie? HELP

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

    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team

    [10:56:32] 
    [10:56:32] Server Plugins
    [10:56:32] --------------
    [10:56:32]  Loading plugin: crashdetect
    [10:56:32]   CrashDetect v4.15.1 is OK.
    [10:56:32]   Loaded.
    [10:56:32]  Loading plugin: sscanf
    [10:56:32] 

    [10:56:32]  ===============================

    [10:56:32]       sscanf plugin loaded.     

    [10:56:32]          Version:  2.8.1        

    [10:56:33]    (c) 2012 Alex "Y_Less" Cole  

    [10:56:33]  ===============================

    [10:56:33]   Loaded.
    [10:56:33]  Loading plugin: mysql
    [10:56:33]  >> plugin.mysql: R34 successfully loaded.
    [10:56:33]   Loaded.
    [10:56:33]  Loading plugin: streamer
    [10:56:33] 

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

    [10:56:33]   Loaded.
    [10:56:33]  Loaded 4 plugins.

    [10:56:33] 
    [10:56:33] Ban list
    [10:56:33] --------
    [10:56:33]  Loaded: samp.ban
    [10:56:33] 
    [10:56:33] 
    [10:56:33] Filterscripts
    [10:56:33] ---------------
    [10:56:33]   Loaded 0 filterscripts.

    [10:56:36]  
    [10:56:36]  
    [10:56:36]  
    [10:56:36]  ======================================= 
    [10:56:36]  |                                     | 
    [10:56:36]  |        YSI version 3.09.0684        | 
    [10:56:36]  |        By Alex "Y_Less" Cole        | 
    [10:56:36]  |                                     | 
    [10:56:36]  ======================================= 
    [10:56:36]  
    [10:56:36]  
    [10:56:36]  
    [10:56:40] Server: hosted
    [10:56:40] Server vehicles: 0
    [10:56:40] Safezones: 0
    [10:56:40] Houses: 0
    [10:56:40] Clans: 0
    [10:56:40] Clan zones: 0
    [10:56:40] Bussines: 0
    [10:56:41] Turfs: 0
    [10:56:41] Factions: 0
    [10:56:41] Jobs: 0
    [10:56:41] Furnitures: 0
    [10:56:41] Stuff Loaded
    [10:56:41] Safes: 0
    [10:56:42] Number of vehicle models: 18
    [10:56:42] ====================================================================
    [10:56:42] Error ID: 2006, Error: MySQL server has gone away
    [10:56:42] Callback: LoadDSVeh
    [10:56:42] gQuery: SELECT * FROM `dsveh`
    [10:56:42] ====================================================================
     

     

    frt e baza in phpmyadmin e totu bun, ce drq are? @SkillZ_IT. @Kiran @CosminAK47

  4. On 5/8/2019 at 7:40 PM, ionutdrg45 said:

    m-am uitat, nu inteleg de ce nu ti-l acceseaza, ai incercat si alte conturi si rezultatul e acelasi?

    Daca fac un cont din baza de date merge, daca l fac eu conectanduma pe sv nu mai merge @ionutdrg45

  5. Daca ai tw cv sa vezi? @ionutdrg45

    54 minutes ago, ionutdrg45 said:

    folosesti baza de date buna? Nu vad cum ar putea sa iti dea ca user ul nu exista, este o chestie simpla, nu e complexa, pe langa asta si faptul ca nu a mai fost sesizata o astfel de posibila problema de catre altcineva, panelul complet compatibil este cel ce vine cu gamemodeul

     

  6. 2 hours ago, ionutdrg45 said:

    tu vrei ca la un user existent sa arate ca nu exista? pai cred ca poti verifica daca rezultatul din baza de date este diferit de numele pe care vrei tu sa nu il afiseze sa afiseze rezultatul sau invers, cum iti este tie mai comod, invers ma refer daca il gaseste sa nu il afiseze

    
    if($row->name != 'Nume')
    	echo "<li>({$row->id}) <a href='".Config::$_PAGE_URL."profile/{$row->name}'>{$row->name}</a> - level {$row->Level}<br /></li>";

     

    Deci imi fac un cont pe sv, totu ok, ma duc pe panel ma loghez, ma da pe dashboard, ok. Cand vr sa intru pe profilu meu, apare o daia rosie si scrie user don t exist, ce fac? Mi am sters contu din db, l am fct iar dar nimic, help @ionutdrg45

  7. tot eu sunt @anonim23 dupa pc asta este codul

    function ShowStats(playerid,targetid) {
        if(!IsPlayerConnected(playerid) || !IsPlayerConnected(targetid)) return 1;
    	new
    		string[256],
    		atext[20],
    		ttext[180],
    		rtext[180],
    		jtext[100],
    		drank[20],
    		vtext[20],
    		infostring2[180],
    		playersip[180],
    		radios[64],
    		infostring[180],
    	
    		account = PlayerInfo[targetid][pAccount],
    		cash = GetPlayerCash(targetid),
    		crimes = PlayerInfo[targetid][pCrimes],
    		arrests = PlayerInfo[targetid][pArrested],
    		drugs = PlayerInfo[targetid][pDrugs],
    		mats = PlayerInfo[targetid][pMats],
    		level = PlayerInfo[targetid][pLevel],
    		exp = PlayerInfo[targetid][pExp],
    		nxtlevel = PlayerInfo[targetid][pLevel],
    		expamount,
    		costlevel,
    		pnumber = PlayerInfo[targetid][pPhone],
    		rob = PlayerInfo[targetid][pRob],	
    		warn = PlayerInfo[targetid][pWarns],
    		hkey = PlayerInfo[targetid][pHouse],
    		bkey = PlayerInfo[targetid][pBizz],
    		clan = PlayerInfo[targetid][pClan];
    
    	if(PlayerInfo[targetid][pMember] == 0) ttext = "None";
    	else format(ttext, sizeof(ttext), "%s (rank %d)", FactionName(PlayerInfo[targetid][pMember]), PlayerInfo[targetid][pRank]);
    	
    	if(PlayerInfo[targetid][pSex] == 1) atext = "Male"; 
    	else if(PlayerInfo[targetid][pSex] == 2) atext = "Female"; 
    	
    	if(PlayerInfo[targetid][pRank] != 0) format(rtext, 256, GetRankName(targetid));
    	else rtext = "-";
       
    	if(PlayerInfo[targetid][pJob] == 0) jtext = "None";
    	else format(jtext, sizeof(jtext), "%s", JobInfo[PlayerInfo[targetid][pJob]][jName]);
    	
    	if(PlayerInfo[targetid][pPremiumAccount] == 0) { drank = "No"; }
    	else if(PlayerInfo[targetid][pPremiumAccount] == 1) { drank = "Yes"; }
    	else { drank = "Nu"; }
    
    	if(PlayerInfo[targetid][pVip] == 0) { vtext = "No"; }
    	else if(PlayerInfo[targetid][pVip] == 1) { vtext = "Yes"; }		
    
    	
    	expamount = nxtlevel*levelexp;
    	costlevel = nxtlevel*levelcost;
    
    
    	if(WTChannel[playerid] == 0) radios = "Disabled";
    	else format(radios, sizeof(radios), "#%d khz", WTChannel[playerid]);
    	
    	
    	format(string, sizeof(string), "General: {FFFFFF}Name: %s [%d] | Played %0.2f hours | Money: $%s | Bank: $%s | Phone: %d | Referral ID: %d ", GetNameEx(targetid), targetid, PlayerInfo[targetid][pConnectTime], FormatNumber(cash),FormatNumber(account), pnumber, PlayerInfo[targetid][pSQLID]);
    	SCM(playerid, COLOR_CYAN,string);
    	format(string, sizeof(string), "Account: {FFFFFF}Level: %d | Experience: %d/%d | Next level: $%s | Premium Account: %s | Vip Account: %s |  Diamonds: {FFFF00}%d", level,exp,expamount,FormatNumber(costlevel),drank,vtext,PlayerInfo[targetid][pPremiumPoints]);
    	SCM(playerid, COLOR_CYAN,string);
    	format(string, sizeof(string), "Player: {FFFFFF}Crimes: %d | Arrests: %d | Drugs: %d | Materials: %d | Radio: %s | Rob: %d/10 | Escape: %d/20 | Spin Points: %d", crimes,arrests,drugs,mats,radios, rob,PlayerInfo[targetid][pEscapePoints], PlayerInfo[targetid][pSpinPoints]);
    	SCM(playerid, COLOR_CYAN,string);
    	format(string, sizeof(string), "Case: {FFFFFF}Normal Case: %d | Gold Case: %d", PlayerInfo[targetid][pNormalCrate], PlayerInfo[targetid][pGoldCrate]);
    	SCM(playerid, COLOR_CYAN,string);
    	format(string, sizeof(string), "Other: {FFFFFF}Job: %s | Faction: %s | Faction Warns: %d/3 | Faction Punish: %d/20 | Warns: %d/3 | Apartament id: %d | Momeala: %d ",jtext,ttext,PlayerInfo[targetid][pFACWarns],PlayerInfo[targetid][pFpunish],warn, have_apartament(playerid), PlayerInfo[targetid][pFishFood]);
    	SCM(playerid, COLOR_CYAN,string);
    	if(clan != 0) {
    		if(PlayerInfo[targetid][pClanRank] < 6) format(string, sizeof(string), "Clan: %s (%d) | Tag: %s | Rank: %d | Clan Warns: %d/3", ClanInfo[clan][clName], clan, ClanInfo[clan][clTag], PlayerInfo[targetid][pClanRank], PlayerInfo[targetid][pClanWarn]);
    		else format(string, sizeof(string), "Clan: {FFFFFF}Clan: %s (%d) | Tag: %s | Rank: %d | Clan Warns: %d/3 | Clan Days: %d", ClanInfo[clan][clName], clan, ClanInfo[clan][clTag], PlayerInfo[targetid][pClanRank], PlayerInfo[targetid][pClanWarn], ClanInfo[clan][clDays]);						
    		SCM(playerid, COLOR_CYAN, string);
    	}
    	if(hkey != 999) {
    		if(hkey != 999 && strcmp(GetName(targetid), HouseInfo[hkey][hOwner], true) == 0) format(string, sizeof(string), "House: %d |", hkey);
    		else format(string, sizeof(string), "Rent House: %d | ", hkey);
    		strcat(infostring, string);
    	}	
    	if(bkey != 255) {
    		if(bkey >= 100) format(string, sizeof(string), "Static Business: %d | ", bkey-100);
    		else  format(string, sizeof(string), "Business: %d | ", bkey);
    		strcat(infostring, string);
    	}	
    	if(PlayerInfo[targetid][pAdmin] != 0) {
    		format(string, sizeof(string), "{ff0000}Admin warns: %d/3 | ", PlayerInfo[targetid][pAW]);
    		strcat(infostring, string);		
    	}		
    	if(PlayerInfo[targetid][pHelper] != 0) {
    		format(string, sizeof(string), "{ff0000}Helper warns: %d/3 | ", PlayerInfo[targetid][pHW]);
    		strcat(infostring, string);		
    	}		
    	if(PlayerInfo[targetid][pLeader] != 0) {
    		format(string, sizeof(string), "{ff0000}Leader warns: %d/3 | ", PlayerInfo[targetid][pLW]);
    		strcat(infostring, string);		
    	}	
    	format(infostring2, strlen(infostring)-1, "%s", infostring);
    	SCM(playerid, -1, infostring2);
    	
    	if(strcmp(PlayerInfo[targetid][pPropose], "Nimeni", true) == 0) { }
    	else {
    		new userid = GetPlayerID(PlayerInfo[targetid][pPropose]);
    		if(userid == INVALID_PLAYER_ID) format(string, sizeof(string), "Casatorie: {FFFFFF}Esti casatorit(a) cu %s care in prezent este {FFA3A3}offline{FFFFFF}.", PlayerInfo[targetid][pPropose]);
    		else format(string, sizeof(string), "Casatorie: {FFFFFF}Esti casatorit(a) cu %s care in prezent este {BCFFA3}online{FFFFFF} si are ID-ul %d.", PlayerInfo[targetid][pPropose], userid);
    		SCM(targetid, COLOR_CYAN,string);
    	}
    		
    	if(PlayerInfo[targetid][pAdmin] >= 1 || PlayerInfo[targetid][pHelper] >= 1) {
    		if(PlayerInfo[targetid][pAdmin] != 0) {
    			if(targetid == playerid) format(string, sizeof(string), "Ai ajutat %d jucatori pana acum. Jucatori ajutati saptamana aceasta: %d", PlayerInfo[targetid][pHelpedPlayers], PlayerInfo[targetid][pHelpedPlayersToday]);
    			else format(string, sizeof(string), "A ajutat %d jucatori pana acum. Jucatori ajutati saptamana aceasta: %d", PlayerInfo[targetid][pHelpedPlayers], PlayerInfo[targetid][pHelpedPlayersToday]);
    		}
    		else {
    			if(targetid == playerid) format(string, sizeof(string), "Ai ajutat %d jucatori pana acum. Jucatori ajutati azi: %d", PlayerInfo[targetid][pHelpedPlayers], PlayerInfo[targetid][pHelpedPlayersToday]);
    			else format(string, sizeof(string), "A ajutat %d jucatori pana acum. Jucatori ajutati azi: %d", PlayerInfo[targetid][pHelpedPlayers], PlayerInfo[targetid][pHelpedPlayersToday]);
    		}		
    		
    		SCM(playerid, COLOR_GOLD, string);
    	}	
    	if(PlayerInfo[playerid][pAdmin] >= 1) {
    		GetPlayerIp(targetid,playersip,sizeof(playersip));
    		format(string, sizeof(string), "Admin: {FFFFFF}Seconds: %.0f | AFK: %d | Interior ID: %d | Virtual World: %d | SQLID: %d",PlayerInfo[targetid][pSeconds],AFKSeconds[targetid],GetPlayerInterior(targetid),GetPlayerVirtualWorld(targetid),PlayerInfo[targetid][pSQLID]);
    		SCM(playerid, COLOR_CYAN,string);
    	}
    	return 1; }

     

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.