Jump to content

RazDanh

Membru
  • Posts

    9
  • Joined

  • Last visited

Posts posted by RazDanh

  1. Salut. Revin din nou cu o noua problema, acum cand creez o casa noua, daca sunt doua case cu acelasi interior ma da cand la una, cand la alta atunci cand ies din casa. Deci, ce e de facut? Asta e codul din cmd

    CMD:createhouse(playerid, params[])
    {
        if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first.");
        if(IsPlayerConnected(playerid))
    	{
    	    if(PlayerInfo[playerid][pAdmin] >= 7)
    		{
    			new house[64],Float:pX,Float:pY,Float:pZ,string[128],PropertyString[256],field[256];
    			if(sscanf(params, "s[64]", house)) return SendClientMessage(playerid, 0xFFFFFFFF, "Scrie: /createhouse <exterior/interior/complete>");
    		    if(strcmp(house,"exterior",true) == 0)
    			{
    			    GetPlayerPos(playerid, pX, pY, pZ);
    				SetPVarFloat(playerid, "pHeX", pX);
    	        	SetPVarFloat(playerid, "pHeY", pY);
    	        	SetPVarFloat(playerid, "pHeZ", pZ);
    				SetPVarInt(playerid, "hExt", 1);
    				SendClientMessage(playerid, COLOR_YELLOW, "House exterior position configured.");
    			}
    			if(strcmp(house,"interior",true) == 0)
    			{
    			    GetPlayerPos(playerid, pX, pY, pZ);
    				SetPVarFloat(playerid, "pHiX", pX);
                	SetPVarFloat(playerid, "pHiY", pY);
                	SetPVarFloat(playerid, "pHiZ", pZ);
    				SetPVarInt(playerid, "pHiID", GetPlayerInterior(playerid));
    				SetPVarInt(playerid, "pHiVW", GetPlayerVirtualWorld(playerid));
                	SetPVarInt(playerid, "hInt", 1);
    				SendClientMessage(playerid, COLOR_YELLOW, "House interior position configured.");
    			}
    			if(strcmp(house,"complete",true) == 0)
    			{
    			    if(GetPVarInt(playerid, "hExt") != 1 || GetPVarInt(playerid, "hInt") != 1)
    					return SendClientMessage(playerid, COLOR_RED, "You haven't configured either the house exterior or interior. Creation attempt failed.");
    
    				new i = housess+1;
    				format(field,256,"INSERT INTO houses (Owner, Lockk, Hel, Arm, Level, Rentabil, Rent, Owned, Discription, Value, Takings) VALUES('The State', '0', '0', '0', '10', '1', '500', '0', 'House', '10000000', '0')");
    				mysql_query(SQL,field);
    
    				HouseInfo[i][hID]                           = i;
       	    		HouseInfo[i][hEntrancex]                    = GetPVarFloat(playerid, "pHeX");
    				HouseInfo[i][hEntrancey]                    = GetPVarFloat(playerid, "pHeY");
    			 	HouseInfo[i][hEntrancez]                    = GetPVarFloat(playerid, "pHeZ");
            		HouseInfo[i][hExitx]                        = GetPVarFloat(playerid, "pHiX");
            		HouseInfo[i][hExity]                        = GetPVarFloat(playerid, "pHiY");
            		HouseInfo[i][hExitz]                        = GetPVarFloat(playerid, "pHiZ");
            		format(HouseInfo[i][hOwner], 64, "The State");
            		format(HouseInfo[i][hDiscription], 64, "Casa %d",i);
            		HouseInfo[i][hValue]						= 10000000;
            		HouseInfo[i][hHel]                          = 0;
     			 	HouseInfo[i][hArm]                          = 0;
            		HouseInfo[i][hInterior]                     = GetPVarInt(playerid, "pHiID");
            		HouseInfo[i][hLock]                         = 0;
            		HouseInfo[i][hOwned]                        = 0;
            		HouseInfo[i][hRent]                         = 500;
            		HouseInfo[i][hRentabil]                     = 1;
            		HouseInfo[i][hTakings]                      = 0;
            		HouseInfo[i][hLevel]                        = 10;
            		HouseInfo[i][hVirtual]                      = GetPVarInt(playerid, "pHiVW");
    
            		format(field,256,"UPDATE `houses` SET `Entrancex`='%f',`Entrancey`='%f',`Entrancez`='%f',`Exitx`='%f',`Exity`='%f',`Exitz`='%f',`Interior`='%d',`Virtual`='%d' WHERE `ID`='%d'",HouseInfo[i][hEntrancex],HouseInfo[i][hEntrancey],HouseInfo[i][hEntrancez],HouseInfo[i][hExitx],HouseInfo[i][hExity],HouseInfo[i][hExitz],HouseInfo[i][hInterior],HouseInfo[i][hVirtual],i);
            		mysql_query(SQL,field);
    
            		DeletePVar(playerid, "pHeX");
    			    DeletePVar(playerid, "pHeY");
    			    DeletePVar(playerid, "pHeZ");
    			    DeletePVar(playerid, "pHiX");
    			    DeletePVar(playerid, "pHeY");
    			    DeletePVar(playerid, "pHeZ");
    			    DeletePVar(playerid, "pHiID");
    			    DeletePVar(playerid, "pHiVW");
    			    DeletePVar(playerid, "pExt");
    			    DeletePVar(playerid, "pInt");
    
              		DestroyDynamic3DTextLabel(HouseLabel[i]);
    				format(PropertyString, sizeof(PropertyString),"{347235}House {FFFFFF}%d \n{347235}This house is for sale \nDescription: {FFFFFF}%s \n{347235}Cost: {FFFFFF}$%s \n{347235}Level: {FFFFFF}%d \n{347235}To buy this house type /buyhouse",i,HouseInfo[i][hDiscription],FormatNumber(HouseInfo[i][hValue]),HouseInfo[i][hLevel]);
    				HouseLabel[i] = CreateDynamic3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[i][hEntrancex], HouseInfo[i][hEntrancey], HouseInfo[i][hEntrancez],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0);
    				CreateDynamicMapIcon(HouseInfo[i][hEntrancex],HouseInfo[i][hEntrancey],HouseInfo[i][hEntrancez],31,0);
    
    				SetPlayerInterior(playerid, 0);
    				SetPlayerVirtualWorld(playerid, 0);
    				SetPlayerPos(playerid, HouseInfo[i][hEntrancex], HouseInfo[i][hEntrancey], HouseInfo[i][hEntrancez]);
    				housess++;
    				format(string,sizeof(string),"House %d created!",i);
    				SendClientMessage(playerid, COLOR_YELLOW, string);
    			}
    		}
    		else return SendClientMessage(playerid, COLOR_ERROR, AdminOnly);
    	}
    	return 1;
    }

    Multumesc celor care vor sa ma ajute :)

  2. Acum 7 ore, BiKode a spus:
    
    // ONGAMEMODEINIT
    public OnGameModeInit()
    {
    	mysql_log(LOG_ERROR, LOG_TYPE_TEXT);
    	//SQL = mysql_connect("localhost", "root", "", "baza4"); //Ordinea posibila e IP/username/parola/DBname
     SQL = mysql_connect("localhost", "root", "", "baza4"); //La fel si aici

    Ti-am corectat eu, posibil asta sa fie problema.

    Si pune si tu un check sa vezi exact daca se conecteaza cum trb

    
    #define LOCAL_HOST 				"127.0.0.1" //sau localhost
    #define LOCAL_USER 				"root"
    #define LOCAL_PASS 				""
    #define LOCAL_DB 				"baza4"
    
    forward ConnectMySQL();
    public ConnectMySQL()
    {
    
     	NumeGamemode=mysql_connect( LOCAL_HOST, LOCAL_USER, LOCAL_DB, LOCAL_PASS );
    
        if(mysql_ping(NumeGamemode) == 1)
        {
            mysql_debug(NumeGamemode);
    	    printf("[MYSQL]:first Connection to `DATABASE` succesful! || %d",NumeGamemode);
    	}
    	else
    	{
     	  mysql_close(NumeGamemode);
    	  printf("[MYSQL]: [ERROR]:first Connection to `DATABASE` failed!");
    	  NumeGamemode=mysql_connect( LOCAL_HOST, LOCAL_USER, LOCAL_DB, LOCAL_PASS );
          if(mysql_ping(NumeGamemode) == 1)
    	     {
    	        mysql_debug(NumeGamemode);
    		    printf("[MYSQL]:second Connection to `DATABASE` succesful! || %d",NumeGamemode);
    	 	 }
    	 	 else printf("[MYSQL]: [ERROR]:second Connection to `DATABASE` failed!");
    
    	}
    	return 1;
    }

     

    Multumesc, problema era de la mysql.so, a trebuit sa il inlocuiesc.

  3. Acum 2 ore, AndreiB a spus:

    Intra pe localhost/phpmyadmin si creeaza o baza cu numele baza4 si dai import la baza ta de date si gata

    Multumesc pentru raspuns.

    Am facut asta inainte sa imi zici, am uploadata fisierul .sql in baza de date si totul a mers ok :)

    problema e in alta parte si inca nu imi pot da seama unde...

  4. Salut, am o problema. E prima data cand scriu aici si sper ca cineva sa imi ofere o mana de ajutor, multumesc mult. Acum sa incep, am gasit pe net gamemodul frz gaming rpg. Problema este ca orice as face nu se conecteaza la baza de date ca sa imi pot face cont. Cu pawno in gamemod am facut configurarea cu baza, mai exact am modificat comanda asta 

    // ONGAMEMODEINIT
    public OnGameModeInit()
    {
    	mysql_log(LOG_ERROR, LOG_TYPE_TEXT);
    	//SQL = mysql_connect("localhost", "root", "baza4", "");
     SQL = mysql_connect("localhost", "root", "baza4", "");

    Din pacate tot nu vrea sa se conecteze... In server log am asta 

    
    ----------
    Loaded log file: "server_log.txt".
    ----------
    
    SA-MP Dedicated Server
    ----------------------
    v0.3.7, (C)2005-2015 SA-MP Team
    
    [11:00:08] filterscripts = ""  (string)
    [11:00:08] 
    [11:00:08] Server Plugins
    [11:00:08] --------------
    [11:00:08]  Loading plugin: sscanf
    [11:00:08] 
    
    [11:00:08]  ===============================
    
    [11:00:08]       sscanf plugin loaded.     
    
    [11:00:08]          Version:  2.8.1        
    
    [11:00:08]    (c) 2012 Alex "Y_Less" Cole  
    
    [11:00:08]  ===============================
    
    [11:00:08]   Loaded.
    [11:00:08]  Loading plugin: streamer
    [11:00:08] 
    
    *** Streamer Plugin v2.7.7 by Incognito loaded ***
    
    [11:00:08]   Loaded.
    [11:00:08]  Loading plugin: mysql
    [11:00:08]  >> plugin.mysql: R38 successfully loaded.
    [11:00:08]   Loaded.
    [11:00:08]  Loading plugin: crashdetect
    [11:00:08]   CrashDetect must be loaded before 'streamer.DLL'
    [11:00:09]   Failed.
    [11:00:09]  Loaded 3 plugins.
    
    [11:00:09] 
    [11:00:09] Ban list
    [11:00:09] --------
    [11:00:09]  Loaded: samp.ban
    [11:00:09] 
    [11:00:09] 
    [11:00:09] Filterscripts
    [11:00:09] ---------------
    [11:00:09]   Loaded 0 filterscripts.
    
    [11:00:09]  
    [11:00:09]  
    [11:00:09]  
    [11:00:09]  ======================================= 
    [11:00:09]  |                                     | 
    [11:00:09]  |        YSI version 3.09.0684        | 
    [11:00:09]  |        By Alex "Y_Less" Cole        | 
    [11:00:09]  |                                     | 
    [11:00:09]  ======================================= 
    [11:00:09]  
    [11:00:09] -mSelection- WARNING: Failed to load list: "components.txt"
    [11:00:10] Houses: 0
    [11:00:10] Bussines: 0
    [11:00:10] Stuff Loaded
    [11:00:10] Charity Loaded
    [11:00:10] Turf: 0
    [11:00:10] Papers: 0
    [11:00:10] [Furniture Script]: 0 objects loaded.
    [11:00:10] Dynamic Factions: 0
    [11:00:10] Cars: 0
    [11:00:11] Dealership Vehicles: 0
    [11:00:11] Stock Loaded
    [11:00:11] [Clans Script]: 0 clans loaded.
    [11:00:11] [Graffiti Script]: 0 graffiti loaded.
    [11:00:11] 2719 - Objects.
    [11:00:11] 30 - Pickups.
    [11:00:11] OnGameModeInit Loaded
    [11:00:11] Script loaded - Frz-Gaming v1.3
    [11:00:11] Number of vehicle models: 72
    [11:00:11]  
    [11:00:11]  ========================================== 
    [11:00:11]  |                                        | 
    [11:00:11]  |  A new version (v<html lan) of YSI is  | 
    [11:00:11]  |            available from:             | 
    [11:00:11]  |                                        | 
    [11:00:11]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
    [11:00:11]  |                                        | 
    [11:00:11]  ========================================== 
    [11:00:11]  
    
    ----------
    Loaded log file: "server_log.txt".
    ----------
    
    SA-MP Dedicated Server
    ----------------------
    v0.3.7, (C)2005-2015 SA-MP Team
    
    [11:00:50] filterscripts = ""  (string)
    [11:00:50] 
    [11:00:50] Server Plugins
    [11:00:50] --------------
    [11:00:50]  Loading plugin: sscanf
    [11:00:50] 
    
    [11:00:50]  ===============================
    
    [11:00:50]       sscanf plugin loaded.     
    
    [11:00:50]          Version:  2.8.1        
    
    [11:00:50]    (c) 2012 Alex "Y_Less" Cole  
    
    [11:00:50]  ===============================
    
    [11:00:50]   Loaded.
    [11:00:50]  Loading plugin: streamer
    [11:00:50] 
    
    *** Streamer Plugin v2.7.7 by Incognito loaded ***
    
    [11:00:50]   Loaded.
    [11:00:50]  Loading plugin: mysql
    [11:00:50]  >> plugin.mysql: R38 successfully loaded.
    [11:00:50]   Loaded.
    [11:00:50]  Loading plugin: crashdetect
    [11:00:50]   CrashDetect must be loaded before 'streamer.DLL'
    [11:00:51]   Failed.
    [11:00:51]  Loaded 3 plugins.
    
    [11:00:51] 
    [11:00:51] Ban list
    [11:00:51] --------
    [11:00:51]  Loaded: samp.ban
    [11:00:51] 
    [11:00:51] 
    [11:00:51] Filterscripts
    [11:00:51] ---------------
    [11:00:51]   Loaded 0 filterscripts.
    
    [11:00:51]  
    [11:00:51]  
    [11:00:51]  
    [11:00:51]  ======================================= 
    [11:00:51]  |                                     | 
    [11:00:51]  |        YSI version 3.09.0684        | 
    [11:00:52]  |        By Alex "Y_Less" Cole        | 
    [11:00:52]  |                                     | 
    [11:00:52]  ======================================= 
    [11:00:52]  
    [11:00:52] -mSelection- WARNING: Failed to load list: "components.txt"
    [11:00:52] Houses: 0
    [11:00:52] Bussines: 0
    [11:00:52] Stuff Loaded
    [11:00:52] Charity Loaded
    [11:00:52] Turf: 0
    [11:00:52] Papers: 0
    [11:00:52] [Furniture Script]: 0 objects loaded.
    [11:00:53] Dynamic Factions: 0
    [11:00:53] Cars: 0
    [11:00:53] Dealership Vehicles: 0
    [11:00:53] Stock Loaded
    [11:00:53] [Clans Script]: 0 clans loaded.
    [11:00:53] [Graffiti Script]: 0 graffiti loaded.
    [11:00:53] 2719 - Objects.
    [11:00:53] 30 - Pickups.
    [11:00:53] OnGameModeInit Loaded
    [11:00:53] Script loaded - Frz-Gaming v1.3
    [11:00:53] Number of vehicle models: 72
    [11:00:53]  
    [11:00:53]  ========================================== 
    [11:00:53]  |                                        | 
    [11:00:53]  |  A new version (v<html lan) of YSI is  | 
    [11:00:53]  |            available from:             | 
    [11:00:53]  |                                        | 
    [11:00:53]  |     www.y-less.com/YSI/YSI_1.0.zip     | 
    [11:00:53]  |                                        | 
    [11:00:53]  ========================================== 
    [11:00:53]  
    [11:01:44] [connection] 192.168.0.119:59745 requests connection cookie.
    [11:01:45] Incoming connection: 192.168.0.119:59745 id: 0
    [11:01:45] [join] RazDan has joined the server (0:192.168.0.119)
    [11:02:02] [part] RazDan has left the server (0:2)

    Si cam asta e. Vroiam sa iau neaparat scriptul asta pentru ca are cam ce caut eu, aici ma refer ca are implementat si cele doua tipuri de barbut etc... Problema e, de ce nu imi pot face cont? Precizez ca il rulez localhost, iar la alte gamemoduri nu am intampinat probleme, chiar un gamemode mai vechi de unde a plecat frz, merge bine dar nu are multe chestii. Va multumesc mult si astept orice sugestie, sunt incepator de tot.

×
×
  • 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.