-
Posts
36 -
Joined
-
Last visited
Content Type
Profiles
Forums
News
Documentation
Posts posted by InSide*
-
-
Problemă: Am incercat sa pun un gamemode ce ruleaza pe mysql pe host. Baza de date urcata, in gamemode toate lucrurile sunt bine puse.
Am mai vazut ca serverul nu porneste, ramane picat in totalitate, am deschis server_log si am gasit asta:---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R4, (C)2005-2014 SA-MP Team [19:31:20] filterscripts = "" (string) [19:31:20] [19:31:20] Server Plugins [19:31:20] -------------- [19:31:20] Loading plugin: sscanf.so [19:31:20] [19:31:20] =============================== [19:31:20] sscanf plugin loaded. [19:31:20] Version: 2.8.1 [19:31:20] (c) 2012 Alex "Y_Less" Cole [19:31:20] =============================== [19:31:20] Loaded. [19:31:20] Loading plugin: mysql_static.so [19:31:20] >> plugin.mysql: R39-2 successfully loaded. [19:31:20] Loaded. [19:31:20] Loading plugin: Whirlpool.so [19:31:20] [19:31:20] ================== [19:31:20] [19:31:20] Whirlpool loaded [19:31:20] [19:31:20] ================== [19:31:20] [19:31:20] Loaded. [19:31:20] Loading plugin: streamer.so [19:31:20] Loaded. [19:31:20] Loaded 4 plugins. [19:31:20] [19:31:20] Filterscripts [19:31:20] --------------- [19:31:20] Loaded 0 filterscripts. [19:31:20] [MYSQL]: Connection to database (w3op) failed! [19:31:20] SUCCES: Conexiunea la baza de date`zp_hid4684` a fost stabilita! [19:31:20] [19:31:20] [19:31:20] RPG: RPG V 0.0.1 (beta) LS,LV [19:31:20] ____________________________ [19:31:20] Number of vehicle models: 82 [19:31:20] --- Server Shutting Down. [19:31:20] [19:31:20] =============================== [19:31:20] sscanf plugin unloaded. [19:31:20] =============================== [19:31:20] plugin.mysql: Unloading plugin...
Dupa aceea, am intrat in mysql_log si am gasit asta:19:31:10 mysql_connect OK host: "93.119.26.250", user: "zp_hid4684", database: "zp_hid4684", password: "****", port: 3306, autoreconnect: true, pool_size: 2 19:31:10 CMySQLHandle::Create OK creating new connection.. 19:31:10 CMySQLHandle::CMySQLHandle OK constructor called 19:31:10 CMySQLHandle::Create OK connection created (id: 2) 19:31:10 CMySQLConnection::Connect OK establishing connection to database... 19:31:10 CMySQLConnection::Connect OK establishing connection to database... 19:31:10 CMySQLConnection::Connect ERROR (error #2003) Can't connect to MySQL server on '127.0.0.1' (111) 19:31:10 CMySQLConnection::Connect OK establishing connection to database... 19:31:10 CMySQLConnection::Connect ERROR (error #2003) Can't connect to MySQL server on '127.0.0.1' (111) 19:31:10 CMySQLConnection::Connect OK connection was successful 19:31:10 CMySQLConnection::Connect OK auto-reconnect has been enabled 19:31:10 mysql_tquery OK connection: 2, query: "SELECT * FROM `houses`", callback: "LoadHouses", format: "(null)" 19:31:10 mysql_tquery OK connection: 2, query: "SELECT * FROM `business`", callback: "LoadBusiness", format: "(null)" 19:31:10 mysql_tquery OK connection: 2, query: "SELECT * FROM `sbusiness`", callback: "LoadSBusiness", format: "(null)" 19:31:10 mysql_tquery OK connection: 2, query: "SELECT * FROM `safes`", callback: "LoadSafes", format: "(null)" 19:31:10 mysql_tquery OK connection: 2, query: "SELECT * FROM `vehicles`", callback: "LoadVehicles", format: "(null)" 19:31:10 CMySQLConnection::Connect OK establishing connection to database... 19:31:10 CMySQLConnection::Connect OK connection was successful 19:31:10 CMySQLConnection::Connect OK auto-reconnect has been enabled 19:31:10 CMySQLQuery::Execute[LoadHouses] OK starting query execution 19:31:10 CMySQLQuery::Execute[LoadHouses] OK query was successfully executed within 0.239 milliseconds 19:31:10 CMySQLResult::CMySQLResult() OK constructor called 19:31:10 CMySQLQuery::Execute[LoadBusiness] OK starting query execution 19:31:10 CMySQLQuery::Execute[LoadBusiness] OK query was successfully executed within 0.189 milliseconds 19:31:10 CMySQLResult::CMySQLResult() OK constructor called 19:31:10 CMySQLQuery::Execute[LoadSBusiness] OK starting query execution 19:31:10 CMySQLQuery::Execute[LoadSBusiness] OK query was successfully executed within 0.244 milliseconds 19:31:10 CMySQLResult::CMySQLResult() OK constructor called 19:31:10 CMySQLQuery::Execute[LoadSafes] OK starting query execution 19:31:10 CMySQLConnection::Connect OK establishing connection to database... 19:31:10 CMySQLConnection::Connect OK establishing connection to database... 19:31:10 CMySQLQuery::Execute[LoadSafes] OK query was successfully executed within 0.662 milliseconds 19:31:10 CMySQLResult::CMySQLResult() OK constructor called 19:31:10 CMySQLQuery::Execute[LoadVehicles] OK starting query execution 19:31:10 CMySQLConnection::Connect OK connection was successful 19:31:10 CMySQLConnection::Connect OK auto-reconnect has been enabled 19:31:10 CMySQLQuery::Execute[LoadVehicles] OK query was successfully executed within 0.302 milliseconds 19:31:10 CMySQLResult::CMySQLResult() OK constructor called 19:31:10 CMySQLConnection::Connect OK connection was successful 19:31:10 CMySQLConnection::Connect OK auto-reconnect has been enabled 19:31:10 mysql_close OK connection: 1 19:31:10 CMySQLConnection::Disconnect WARNING no connection available 19:31:10 CMySQLConnection::Disconnect WARNING no connection available 19:31:10 CMySQLHandle::~CMySQLHandle OK deconstructor called 19:31:10 CMySQLConnection::Disconnect OK connection was closed
Cod sursă:Le-am pus mai sus.
Ce am încercat: Toate chestiile, am dat reinstal la server, l-am urcat din nou, am inlocuit plugins, am urcat din nou baza de date, am modificat datele, dar fara succes.
Alte detalii: N-am idee de la ce provine aceasta mica defectiune. -
Functioneaza stimate, va multumesc inca odata.
-
Problema intalnita (descriere): Am incercat sa mut sistemul lui n0bel de barbut din params pe strcmp
Ero(area / rile) / warning-(ul / urile): Nu sunt erori, doar ca nu functioneaza comanda cum trebuie.Ex: /dice <playerid> <suma> ii oferi cererea de barbut, iar cand respectivul trebuie sa accepte prin comanda /accept dice <playerid> zice ca jucatorul X nu ti-a oferit o cerere de barbut, chiar daca tu ai facut asta.
Liniile de cod / sursa / script-ul(obligatoriu):Comanda /dice:
if(strcmp(cmd, "/dice", true) == 0) { if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first."); if(IsPlayerConnected(playerid)) { //if(!IsPlayerInRangeOfPoint(playerid, 100, 2016.2699,1017.7790,996.8750)) return SendClientMessage(playerid, COLOR_WHITE,"{FFB870}Nu te afli in casino!"); tmp = strtok(cmdtext, idx); if(!strlen(tmp)) return SCM(playerid,COLOR_WHITE,"Syntax: /dice <name/playerid> <Money>"); new targetid = ReturnUser(tmp); tmp = strtok(cmdtext, idx); if(!strlen(tmp)) return SCM(playerid,COLOR_WHITE,"Syntax: /dice <name/playerid> <Money>"); new price = strval(tmp); if(price < 1 || price > 1000000) return SCM(playerid,COLOR_WHITE,"{F05E6C}Limita de bani este de $1,000,000."); if(IsPlayerConnected(targetid)) { if(GetPlayerMoney(playerid) < price) return SCM(playerid,COLOR_WHITE,"{FFB870}Nu ai destui bani."); if(GetPlayerMoney(targetid) < price) return SCM(playerid,COLOR_WHITE,"{FFB870}Acel jucator nu are destui bani."); if(targetid == playerid) return SendClientMessage(playerid, COLOR_WHITE, "{FFB870}Nu poti juca."); if(ProxDetectorS(10.0, playerid, targetid)) { GetPlayerName(targetid, giveplayer, sizeof(giveplayer)); GetPlayerName(playerid, sendername, sizeof(sendername)); SendClientMessage(playerid, COLOR_WHITE, "{F05E6C}Cerere de barbut trimisa"); format(string, sizeof(string), "{F05E6C}%s te-a invitat sa joci barbut cu el pe %s$. Scrie /accept dice %d pentru a juca.",sendername,Bani(price),playerid); SendClientMessage(targetid, COLOR_WHITE, string); Diceid[targetid] = playerid; Dicem[targetid] = price; } else return SendClientMessage(playerid, COLOR_WHITE, "{FFFFFF}Acel jucator nu este langa tine."); } } return 1; }Comanda /accept "dice":
if(strcmp(cmd,"/accept",true)==0) { if(IsPlayerConnected(playerid)) { new x_job[128]; x_job = strtok(cmdtext, idx); if(!strlen(x_job)) { SendClientMessage(playerid, COLOR_WHITE, "|__________________ Accept __________________|"); SendClientMessage(playerid, COLOR_WHITE, "{D580FE}Foloseste:{FFFFFF} /accept [name]"); SendClientMessage(playerid, COLOR_GREEN, "Poti folosi: Sex, Drugs, Materials, Pills, Repair, Lawyer, Dice, Job, Live, Refill"); SendClientMessage(playerid, COLOR_GREEN, "Poti folosi: Car, Taxi, Bus, Boxing, Medic, Mechanic, Paper, Ticket"); SendClientMessage(playerid, COLOR_WHITE, "|____________________________________________|"); return 1; } if(strcmp(x_job,"dice",true) == 0) { //if(!IsPlayerInRangeOfPoint(playerid, 100, 2016.2699,1017.7790,996.8750)) return SendClientMessage(playerid, COLOR_WHITE,"{FFB870}Nu te afli in casino!"); if(Diceid[playerid] == 999) return SCM(playerid,COLOR_WHITE,"{FFFFFF}Nu ai primit nici o cerere de barbut."); if(Diceid[playerid] != idx) return SCM(playerid,COLOR_WHITE,"{FFFFFF}Acel jucator nu te-a invitat sa joci barbut cu el."); if(GetPlayerMoney(playerid) < Dicem[playerid]) return SCM(playerid,COLOR_WHITE,"{FFFFFF}Nu ai destui bani."); if(GetPlayerMoney(idx) < Dicem[playerid]) return SCM(playerid,COLOR_WHITE,"{FFB870}Acel jucator nu are destui bani."); if(ProxDetectorS(10.0, playerid, Diceid[playerid])) { new dice1[MAX_PLAYERS],dice2[MAX_PLAYERS],dice3[MAX_PLAYERS],dice4[MAX_PLAYERS]; dice1[playerid] = random(6) + 1; dice2[Diceid[playerid]] = random (6) + 1; dice3[playerid] = random (6) + 1; dice4[Diceid[playerid]] = random (6) + 1; GetPlayerName(playerid,sendername,sizeof(sendername)); GetPlayerName(Diceid[playerid],giveplayer,sizeof(giveplayer)); if(dice1[playerid] + dice1[playerid] > dice2[Diceid[playerid]] + dice4[Diceid[playerid]]) { format(string,sizeof(string),"{CA99CE}%s rolls %d %d. %s rolls %d %d. %s won %s$.",sendername,dice1[playerid],dice3[playerid],giveplayer,dice2[Diceid[playerid]],dice4[Diceid[playerid]],sendername,Bani(Dicem[playerid])); ProxDetector(10.0,playerid, string, COLOR_WHITE,COLOR_WHITE,COLOR_WHITE,COLOR_WHITE,COLOR_WHITE); format(string, sizeof(string), "{048E24}(-) Ai pierdut $%s!",Bani(Dicem[playerid])); SendClientMessage(Diceid[playerid], COLOR_WHITE, string); format(string, sizeof(string), "{048E24}(+) Ai castigat $%s!",Bani(Dicem[playerid])); SendClientMessage(playerid, COLOR_WHITE, string); GivePlayerMoney(playerid,Dicem[playerid]); GivePlayerMoney(Diceid[playerid],-Dicem[playerid]); } if(dice2[Diceid[playerid]] + dice4[Diceid[playerid]] > dice1[playerid] + dice3[playerid]) { format(string,sizeof(string),"{CA99CE}%s rolls %d %d. %s rolls %d %d. %s won %s$.",giveplayer,dice2[Diceid[playerid]],dice2[Diceid[playerid]],sendername,dice1[playerid],dice3[playerid],giveplayer,Bani(Dicem[playerid])); ProxDetector(10.0,playerid, string, COLOR_WHITE,COLOR_WHITE,COLOR_WHITE,COLOR_WHITE,COLOR_WHITE); format(string, sizeof(string), "{048E24}(-) Ai pierdut $%s!",Bani(Dicem[playerid])); SendClientMessage(playerid, COLOR_WHITE, string); format(string, sizeof(string), "{048E24}(+) Ai castigat $%s!",Bani(Dicem[playerid])); SendClientMessage(Diceid[playerid], COLOR_WHITE, string); GivePlayerMoney(playerid,-Dicem[playerid]); GivePlayerMoney(Diceid[playerid],Dicem[playerid]); } if(dice2[Diceid[playerid]] + dice4[Diceid[playerid]] == dice1[playerid] + dice3[playerid]) { format(string,sizeof(string),"{CA99CE}%s rolls %d %d. %s rolls %d %d. No one won.",giveplayer,dice2[Diceid[playerid]],dice4[Diceid[playerid]],sendername,dice1[playerid],dice3[playerid]); ProxDetector(10.0,playerid, string, COLOR_WHITE,COLOR_WHITE,COLOR_WHITE,COLOR_WHITE,COLOR_WHITE); } Diceid[playerid] = 999; Dicem[playerid] = 0; } else return SendClientMessage(playerid, COLOR_WHITE, "{FFB870}Player is not near you."); return 1; }Imagini / Video (optional):
Ati incercat sa rezolvati singur?: Da, am incercat mai multe metode. -
Ai modificat in script unde nu trebuia si in loc de
[pawn]gTeam[killerid]) == 3[/pawn]
tu ai pus
[pawn]gTeam[killerid]) == 2[/pawn]
Posteaza aici functia.
-
Foarte simplu.
Te duci la onplayerconnect, cauti textdraw-urile le copiezi si le pui la onplayerlogin, bineinteles, dupa ce le-ai scos de la onplayerconnect.
-
1
-
-
Foarte frumos, felicitari, 10/10.
-
Vechi,buguit, doar un noob ar baga asa ceva pe server.
-
Un godfather foarte vechi, 7/10
-
Multumim pentru postare.
-
Apasa tasta F7
Mysql errror
in Suport Servere
Posted
Problema a fost rezolvata, multumesc domnului ARTIST inca odata.