Jump to content

[K]Punker.

Membru
 View Profile  See their activity

  • Posts

    58

  • Joined

  • Last visited

 Content Type 

Posts posted by [K]Punker.

  2. Ajutor

    in Arhivă probleme

    Posted · Edited by Punker

    Cum fac sa pot folosi doar eu o anumita comanda>?. Am incercat ceva dar o pot folosi si unii jucatori nu toti si nu stiu de ce. Cum fac sa o pot folosi doar eu ???.

    Si alta chestie.... Cand cineva se logheaza cu RCON , cum fac sa apara pe chat ca Jucatorul ..... a incercat sa se logheze cu rcon /s-a logat cu RCON ...? 

    if(strlen(PlayerName(playerid)) != strlen("[K]Punker."))
    return SendError(playerid, "Only [K]Punker. have ACCES to use this command!");

    P.S: GM ESS

  3. Galaxy Stunt Empire

    in Publicitate Server

    Posted

    Galaxy Stunt Empire

    HostName: Galaxy Stunt Empire - Cautam STAFF!
    Address:  89.33.242.189:7777
    Players:  0 / 50
    Ping:     27
    Mode:     Stunt/DM/RP/Race/FreeRoam
    Language: RO/ENG

    Atentie: Server-ul a fost deschis ieri pe data de 19/05/2017

     

    Server-ul contine:

    Sistem Admin ( MYSQL R34 )

    Sistem Vips ( MYSQL R34 )

    Sistem Coins

    Sistem Stunt

    Sistem Race

    Sistem Props

    Sistem Houses/Proprieties

    Sistem Limbi (RO/ENG)

    Sistem de SpeedBoost/VUP

    Sistem de Tunning

    Sistem Save/Goto Place

    Sistem Clanuri /createclan & Gangs 

    Sistem GPS (pentru localizarea unui player)

    Sistem de job-uri

    Sistem Top Players

     

    Cateva imagini referitoare la ce contine serverul:

     

    /STATS

     

    x3lsDtX.jpg

     

    /CMDS

     

    cpDrZpZ.jpg

     

    /ACMDS

     

    hZiuqFA.jpg

     

    /BUYVIP

     

    XqM9LkX.jpg

     

    /RULES

     

    v2aaXbk.jpg

     

    /SHOP & /SHOP2

     

    1CRGknC.png

     

    2ZCFiHI.png

     

    /CREDITS

     

    QBhOqZY.png

     

    LOGIN

     

    AwxNDoZ.jpg

     

    cWv9BJe.jpg

     

     

    • Haha 1

  5. Problema Houses/Props

    in Suport Servere

    Posted

    Salutare, am o problema cu props si houses pe srv. Cand dau rr la srv din consola, imi arata ca toate casele si props sunt cumparate cand defapt nu sunt. Acest lucru se intampla numai cand dau rr sa repar un bug sau sa fac altceva. 

  12. Help VIP Levels

    in Suport Servere

    Posted

    Acum 3 ore, KnowN a spus:

    Trebuie sa creezi o variabila, de exemplu:

    new FreeVIP[MAX_PLAYERS];

    Iar apoi sa ii atribui valoarea 0 cand jucatorul se conecteaza, sa o salvezi in baza de date si sa ia valoarea 1 atunci cand jucatorul cumpara VIP Free.

    De aici e simplu, faci o bucla si verifici daca jucatorul are variabila FreeVIP pe 1 si ii dai return pe un mesaj de exemplu "Ai folosit deja aceasta optiune.".

    Mersi, am rezolvat cu vip free , dar cand cineva are vip temporar si cumpara VIP Permanent, nu dispare cel temporar 

     

  15. Help VIP Levels

    in Suport Servere

    Posted

    Salutare, am o problema pe care nu stiu sa o rezolv. Am 2 lvl de vip, VIP si Gold VIP. La /buyvip am VIP FREE, VIP 20 zile, VIP Permanent si Gold 20 zile. Nu pot lua gratis deloc iar daca modific ceva si iau, pot sa iau intruna. Cand am vip temporar si cumpar permanent nu dispare cel temporar si tot asa. Nu stiu cum sa le fac sa mearga...

     

     

    P.S: Vreau sa mearga sa le cumpar cum scrie acolo iar vip temporar sa dispara cand cumpar permanent... 

    case DIALOG_BUYVIP:
	    {
	        if(response)
			{
				switch(listitem)
				{
                    case 0:
					{
						if(PlayerInfo[playerid][IsVipFree] == 1) return SendError(playerid, "You can buy this option only once time!");
						//------------------------------------------------------
						new sVip[35], AvaibleDays = 11; GQuery[0] = EOS;
						//------------------------------------------------------
						PlayerInfo[playerid][pVIP] = 1, 	 PlayerInfo[playerid][TVip] = 1;
						PlayerInfo[playerid][IsVipFree] = 0, PlayerInfo[playerid][VIPTime] = gettime() + AvaibleDays*86400;
     					//------------------------------------------------------
						if(PlayerInfo[playerid][pVIP] == 1) sVip = "Silver";
	                    else if(PlayerInfo[playerid][pVIP] == 2) sVip = "Gold";
						//------------------------------------------------------
						format(GQuery, sizeof(GQuery), "UPDATE `Accounts` SET `VIPTime` = %d + (%d*86400) WHERE `ID` = %d", gettime(), AvaibleDays, PlayerInfo[playerid][AccID]);
						mysql_tquery(DB_Connect, GQuery, "", "");
						//------------------------------------------------------
						Announce(playerid, "~w~~h~You have bought~n~~g~~h~VIP ~w~~h~for ~r~~h~10 ~w~~h~Days!~n~~w~~h~Type ~r~~h~/Vcmds ~w~~h~for ~n~~w~~h~commands.", 5000, 4);
						//------------------------------------------------------
						eLog[0] = EOS; format(eLog, sizeof(eLog), "%s has bought VIP %s Free. (Temporary: 10 days)", PlayerName(playerid), sVip, timec(PlayerInfo[playerid][VIPTime])); SendLog(eLog);
					}
     				case 1:
					{
				 		if(PlayerInfo[playerid][Hours] < 10) return SendError(playerid, "Ai nevoie de minim 10 Ore pentru a cumpara VIP !");
                        if(PlayerInfo[playerid][Coins] < 5000) return SendError(playerid, "Ai nevoie de minim 5000 de Coins pentru a cumpara VIP !");
						//------------------------------------------------------
						new sVip[35], AvaibleDays = 21; GQuery[0] = EOS;
						//------------------------------------------------------
						PlayerInfo[playerid][pVIP] = 1, 	 PlayerInfo[playerid][TVip] = 1;
						PlayerInfo[playerid][Coins] -= 5000, PlayerInfo[playerid][Hours] -= 10;
						PlayerInfo[playerid][VIPTime] = gettime() + AvaibleDays*86400;
     					//------------------------------------------------------
						if(PlayerInfo[playerid][pVIP] == 1) sVip = "Silver";
	                    else if(PlayerInfo[playerid][pVIP] == 2) sVip = "Gold";
						//------------------------------------------------------
						format(GQuery, sizeof(GQuery), "UPDATE `Accounts` SET `VIPTime` = %d + (%d*86400) WHERE `ID` = %d", gettime(), AvaibleDays, PlayerInfo[playerid][AccID]);
						mysql_tquery(DB_Connect, GQuery, "", "");
						//------------------------------------------------------
						Announce(playerid, "~w~~h~You have bought~n~~g~~h~VIP ~w~~h~for ~r~~h~20 ~w~~h~Days!~n~~w~~h~Type ~r~~h~/Vcmds ~w~~h~for ~n~~w~~h~commands.", 5000, 4);
						//------------------------------------------------------
						eLog[0] = EOS; format(eLog, sizeof(eLog), "%s has bought VIP %s. (Temporary: 20 days)", PlayerName(playerid), sVip, timec(PlayerInfo[playerid][VIPTime])); SendLog(eLog);
					}
					case 2:
     	         	{
     	          		if(PlayerInfo[playerid][Hours] < 50) return SendError(playerid, "Ai nevoie de minim 50 de Ore pentru a cumpara VIP !");
				  		if(PlayerInfo[playerid][Coins] < 10000) return SendError(playerid, "Ai nevoie de minim 10000 de Coins pentru a cumpara VIP !");
				  		if(PlayerInfo[playerid][TVip] == 1) return PlayerInfo[playerid][VIPTime] = 0, PlayerInfo[playerid][TVip] = 0, PlayerInfo[playerid][pVIP] = 1;
                  		//------------------------------------------------------------
                  		PlayerInfo[playerid][pVIP] = 1;
                  		PlayerInfo[playerid][Coins] -= 10000;
                  		PlayerInfo[playerid][Hours] -= 50;
                  		//------------------------------------------------------------
                  		ShowPlayerDialog( playerid, DIALOG_EMPTY, DIALOG_STYLE_MSGBOX, "VIP {FF0000}Cumparat!", "{00FF00}Ai cumparat cu succes VIP Permanent!\n{00FF00}Scrie {FF0000}/VCMDS{00FF00} pentru a vedea comenzile de VIP!", "Ok", "" );
       	         	}
       	         	case 3:
					{
				 		if(PlayerInfo[playerid][Hours] < 80) return SendError(playerid, "Ai nevoie de minim 80 ore pentru a cumpara Gold VIP !");
                        if(PlayerInfo[playerid][Coins] < 20000) return SendError(playerid, "Ai nevoie de minim 20000 de coins pentru a cumpara Gold VIP !");
						//------------------------------------------------------
						new sVip[35], AvaibleDays = 21; GQuery[0] = EOS;
						//------------------------------------------------------
						PlayerInfo[playerid][pVIP] = 2, 	 PlayerInfo[playerid][TVip] = 2;
						PlayerInfo[playerid][Coins] -= 20000, PlayerInfo[playerid][Hours] -= 80;
						PlayerInfo[playerid][VIPTime] = gettime() + AvaibleDays*86400;
     					//------------------------------------------------------
						if(PlayerInfo[playerid][pVIP] == 1) sVip = "Silver";
	                    else if(PlayerInfo[playerid][pVIP] == 2) sVip = "Gold";
						//------------------------------------------------------
						format(GQuery, sizeof(GQuery), "UPDATE `Accounts` SET `VIPTime` = %d + (%d*86400) WHERE `ID` = %d", gettime(), AvaibleDays, PlayerInfo[playerid][AccID]);
						mysql_tquery(DB_Connect, GQuery, "", "");
						//------------------------------------------------------
						Announce(playerid, "~w~~h~You have bought~n~~g~~h~VIP ~w~~h~for ~r~~h~20 ~w~~h~Days!~n~~w~~h~Type ~r~~h~/Vcmds ~w~~h~for ~n~~w~~h~commands.", 5000, 4);
						//------------------------------------------------------
						eLog[0] = EOS; format(eLog, sizeof(eLog), "%s has bought Gold VIP %s. (Temporary: 20 days)", PlayerName(playerid), sVip, timec(PlayerInfo[playerid][VIPTime])); SendLog(eLog);
					}
				}
			}
	        return 1;
	    }

Asa arata cmd:Buyvip 
CMD:buyvip (playerid, params[])
{
	ShowPlayerDialog(playerid, DIALOG_BUYVIP, DIALOG_STYLE_TABLIST_HEADERS, "{FFFFFF}BuyVIP, Type {FF0000}/VCmds {FFFFFF}for commands!",
	"\tItem\tPret\tValabilitate\n\
	{FFFFFF}VIP\tGratuit\t10 Days\n\
    {FFFFFF}VIP\t10 Hours + 5000 Coins\t20 Days\n\
    {FFFFFF}VIP\t50 Hours + 10000 Coins\tPermanent\n\
	{FFF000}Gold {FFFFFF}VIP\t80 Hours + 20000 Coins\tPermanent",
	"Select", "Cancel");
	//--------------------------------------------------------------------------
	return 1;
}

     

  22. Problema accounts baza de date

    in Arhivă probleme

    Posted

    Salut. Dupa cum spune si titlul , nu se salveaza conturile in baza de date. Serverul este SSR V9 . Imi da o eroare Error: Unknown column 'Bussines' in 'field list' dar nu stiu cum sa o rezolv 

    logs  

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

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

[09:38:54] password = ""  (string)
[09:38:54] 
[09:38:54] Server Plugins
[09:38:54] --------------
[09:38:54]  Loading plugin: streamer.so
[09:38:54] 

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

[09:38:54]   Loaded.
[09:38:54]  Loading plugin: mysql_static.so
[09:38:55]  >> plugin.mysql: R39-2 successfully loaded.
[09:38:55]   Loaded.
[09:38:55]  Loading plugin: sscanf.so
[09:38:55] 

[09:38:55]  ===============================

[09:38:55]       sscanf plugin loaded.     

[09:38:55]          Version:  2.8.1        

[09:38:55]    (c) 2012 Alex "Y_Less" Cole  

[09:38:55]  ===============================

[09:38:55]   Loaded.
[09:38:55]  Loaded 3 plugins.

[09:38:55] 
[09:38:55] Ban list
[09:38:55] --------
[09:38:55]  Loaded: samp.ban
[09:38:55] 
[09:38:55] 
[09:38:55] Filterscripts
[09:38:55] ---------------
[09:38:55]   Loading filterscript 'UltraHost.amx'...
[09:38:55]   Loading filterscript 'streamermaps.amx'...
[09:38:57]   Loading filterscript 'PersonalCars.amx'...
[09:38:57]   Loading filterscript 'gangtxd.amx'...
[09:38:57]  - Gang Zone Editor v1.0b by Lorenc_ Loaded!
[09:38:57]   Loading filterscript 'TD_Editor.amx'...
[09:38:57]   Loading filterscript 'streamergangs.amx'...
[09:38:58]   Loaded 6 filterscripts.

[09:38:58] 30138 - Objects.
[09:38:58] 
MySQL: Connection to '127.0.0.1' established.
[09:38:58] MySQL: Database 'port_2503' selected.

[09:38:58] Number of vehicle models: 65
[09:38:59] 
Loaded 7 Gangs.
[09:38:59] Loaded 7 Gang Teritories.
[09:38:59] Loaded 7 Gang Checkpoints.
[09:38:59] Loaded 97 Properties.
[09:38:59] Loaded 1133 Houses.
[09:41:46] [connection] 178.203.234.88:3501 requests connection cookie.
[09:41:47] [connection] incoming connection: 178.203.234.88:3501 id: 0
[09:41:51] [join] [K]Shadow. has joined the server (0:178.203.234.88)
[09:42:05] ====================================================
[09:42:05] Error ID: 1054
Error: Unknown column 'Bussines' in 'field list'
Callback: OnAccountCreated
Query: INSERT INTO `Accounts` (`ID`, `Name`, `Password`, `IP`, `E-Mail`, `LoggedIn`, `RegisterDate`, `LastOn`, `Level`, `VIP`, `Cash`, `Score`, `Coins`, `Credits`, `Kills`, `Deaths`, `Hours`, `Minutes`, `Seconds`, `BestKillings`, `KillingSpree`, `FavSkin`, `UseSkin`, `House`, `Bussines`, `Description1`, `Description2`, `Description3`, `Positive`, `Negative`, `Kicks`, `Bans`, `Jails`, `Warns`, `ClearChats`, `ReactionTest`, `MathTest`, `Mutes`, `Jailed`, `JailTime`, `Frozen`, `FreezeTime`, `Muted`, `MuteTime`, `RaceScore`, `StuntScore`, `DriftScore`, `GangID`, `GangRank`, `GangSkin`, `GangKills`, `GangDeaths`, `GangWarns`, `GangCaptures`, `GangPoints`, `Ignores`, `LottoNumber`, `C4`, `StatsNote`, `VIPTime`, `FreeVIP`, `TempVIP`, `RGSClan`, `RGSRank`, `AdmWarns`, `VIPWarns`, `KickW`) VALUES (0, '[K]Shadow.', 'mafiotu', '178.203.234.88', 'changeme', '1', '11/02/2017', '11/02/2017', '0', '15', '25000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '217', '1', '0', '0', ' ', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '00:00', '0', '00:00', '0', '00:00', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0/0/0/0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0')
[09:42:05] ====================================================
[09:42:07] ====================================================
[09:42:07] Error ID: 1054
Error: Unknown column 'Bussines' in 'field list'
Callback: 
Query: UPDATE `Accounts` SET `LoggedIn` = 0, `LastOn` = '11/02/2017', `Level` = '0', `VIP` = '0', `Cash` = '25000', `Score` = '15', Coins = '0', `Credits` = '0', `Kills` = '0', `Deaths` = '0', `Hours` = '0', `Minutes` = '0', `Seconds` = '16', `BestKillings` = '0', `KillingSpree` = '0', `FavSkin` = '0', `UseSkin` = '0', `House` = '0', `Bussines` = '0', `Description1` = '', `Description2` = '', `Description3` = '', `Positive` = '0', `Negative` = '0', `Kicks` = '0', `Bans` = '0', `Jails` = '0', `Warns` = '0', `ClearChats` = '0', `ReactionTest` = '0', `MathTest` = '0', `Mutes` = '0', `Jailed` = '0', `JailTime` = '0:0', `Frozen` = '0', `FreezeTime` = '0:0', `Muted` = '0', `MuteTime` = '0:0', `RaceScore` = '0', `StuntScore` = '0', `DriftScore` = '0', `Ignores` = '0/0/0/0', `AdmWarns` = '0', `VIPWarns` = '0', `KickW` = '0', `LottoNumber` = '0', `C4` = '0', `StatsNote` = '0', `FreeVIP` = '1', `TempVIP` = '0', `RGSClan` = '0', `RGSRank` = '0', `GangID` = '0', `GangRank` = '0', `GangSkin` = '0', `GangKills` = '0', `GangDeaths` = '0', `GangWarns` = '0', `GangCaptures` = '0', `GangPoints` = '0' WHERE `ID` = '0'
[09:42:07] ====================================================
[09:42:37] [chat] [[K]Shadow.]: 
[09:42:44] [chat] [[K]Shadow.]: 
[09:44:26] RCON (In-Game): Player #0 ([K]Shadow.) has logged in.
[09:47:43] [part] [K]Shadow. has left the server (0:1)
[09:47:43] ====================================================
[09:47:43] Error ID: 1054
Error: Unknown column 'Bussines' in 'field list'
Callback: 
Query: UPDATE `Accounts` SET `LoggedIn` = 0, `LastOn` = '11/02/2017', `Level` = '0', `VIP` = '0', `Cash` = '25000', `Score` = '15', Coins = '1661992960', `Credits` = '0', `Kills` = '1410065408', `Deaths` = '0', `Hours` = '1000', `Minutes` = '5', `Seconds` = '52', `BestKillings` = '0', `KillingSpree` = '0', `FavSkin` = '0', `UseSkin` = '0', `House` = '0', `Bussines` = '0', `Description1` = '', `Description2` = '', `Description3` = '', `Positive` = '276447232', `Negative` = '0', `Kicks` = '0', `Bans` = '0', `Jails` = '0', `Warns` = '0', `ClearChats` = '0', `ReactionTest` = '0', `MathTest` = '0', `Mutes` = '0', `Jailed` = '0', `JailTime` = '0:0', `Frozen` = '0', `FreezeTime` = '0:0', `Muted` = '0', `MuteTime` = '0:0', `RaceScore` = '1316134912', `StuntScore` = '1316134912', `DriftScore` = '1316134912', `Ignores` = '0/0/0/0', `AdmWarns` = '0', `VIPWarns` = '0', `KickW` = '0', `LottoNumber` = '0', `C4` = '0', `StatsNote` = '6', `FreeVIP` = '1', `TempVIP` = '0', `RGSClan` = '0', `RGSRank` = '0', `GangID` = '0', `GangRank` = '0', `GangSkin` = '0', `GangKills` = '0', `GangDeaths` = '0', `GangWarns` = '0', `GangCaptures` = '0', `GangPoints` = '0' WHERE `ID` = '0'
[09:47:43] ====================================================

     

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