Jump to content

Recommended Posts

Posted
Acum 15 minute, LorD. a spus:

Si s-a blocat la mysql

server_log.txt

Ma puteti ajuta??

Verifica daca ai facut legatura cu baza bine sau asteapta cred ca baza este prea mare

Posted

la linia asta

    handle = mysql_connect(127.0.0.1, root, database, SQL_PASS);

 

In loc de SQL_PASS ce pun daca n-am parola?

Posted

 Cum pot rezolva asta? Imi puteti da link de la mysql bun?

[18:33:19] [debug] Run time error 19: "File or function is not found"
[18:33:19] [debug]  mysql_log
[18:33:19] [debug]  mysql_current_handle
[18:33:19] [debug]  mysql_tquery
[18:33:19] [debug]  mysql_close
[18:33:19] [debug]  GetCountryName
[18:33:19] [debug]  mysql_format
[18:33:19] [debug]  mysql_query
[18:33:19] [debug]  cache_get_row_count
[18:33:19] [debug]  cache_get_field_content
[18:33:19] [debug]  cache_delete
[18:33:19] [debug]  mysql_escape_string
[18:33:19] [debug]  cache_insert_id
[18:33:19] [debug]  cache_get_data
[18:33:19] [debug]  mysql_connect
[18:33:19] [debug] Run time error 19: "File or function is not found"
[18:33:19] [debug]  mysql_log
[18:33:19] [debug]  mysql_current_handle
[18:33:19] [debug]  mysql_tquery
[18:33:19] [debug]  mysql_close
[18:33:19] [debug]  GetCountryName
[18:33:19] [debug]  mysql_format
[18:33:19] [debug]  mysql_query
[18:33:19] [debug]  cache_get_row_count
[18:33:19] [debug]  cache_get_field_content
[18:33:19] [debug]  cache_delete
[18:33:19] [debug]  mysql_escape_string
[18:33:19] [debug]  cache_insert_id
[18:33:19] [debug]  cache_get_data
[18:33:19] [debug]  mysql_connect
[18:33:19] Script[gamemodes/gmmm.amx]: Run time error 19: "File or function is not found"
[18:33:19] Number of vehicle models: 0
[18:33:31] [debug] Server received interrupt signal
[18:33:31] [debug] Native backtrace:
[18:33:31] [debug] #0 77906f1c in ?? () from C:\WINDOWS\SYSTEM32\ntdll.dll
[18:33:31] [debug] #1 76f7a6bf in ?? () from C:\WINDOWS\SYSTEM32\KERNELBASE.dll
[18:33:31] [debug] #2 0048d53c in ?? () from samp-server.exe
[18:33:31] [debug] #3 0049b4a1 in ?? () from samp-server.exe
[18:33:31] [debug] #4 0049b4b1 in ?? () from samp-server.exe
[18:33:31] --- Server Shutting Down.
[18:33:31] [debug] Run time error 19: "File or function is not found"
[18:33:31] [debug]  mysql_log
[18:33:31] [debug]  mysql_current_handle
[18:33:31] [debug]  mysql_tquery
[18:33:31] [debug]  mysql_close
[18:33:31] [debug]  GetCountryName
[18:33:31] [debug]  mysql_format
[18:33:31] [debug]  mysql_query
[18:33:31] [debug]  cache_get_row_count
[18:33:31] [debug]  cache_get_field_content
[18:33:31] [debug]  cache_delete
[18:33:31] [debug]  mysql_escape_string
[18:33:31] [debug]  cache_insert_id
[18:33:31] [debug]  cache_get_data
[18:33:31] [debug]  mysql_connect

sal

Posted

    handle = mysql_connect(127.0.0.1, root, database, SQL_PASS);

La linia asta ce pun la SQL_PASS daca n-am parola?

Posted
7 minutes ago, LorD. said:

    handle = mysql_connect(127.0.0.1, root, database, SQL_PASS);

La linia asta ce pun la SQL_PASS daca n-am parola?

Lasi liber.
 

Ma poate ajuta cnv va rog?
[18:53:20] [debug] Run time error 19: "File or function is not found"
[18:53:20] [debug]  GetCountryName
[18:53:20] [debug] Run time error 19: "File or function is not found"
[18:53:20] [debug]  GetCountryName
[18:53:20] Script[gamemodes/gmmm.amx]: Run time error 19: "File or function is not found"
[18:53:20] Number of vehicle models: 0
 

sal

Posted

handle = mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);

Daca pun la SQL_USER -> root imi da eroare

Daca las liber la SQL_PASS -> imi da eroare.

Ma puteti ajuta sa-l completez?

Folosesc xampp , la SQL_HOST am pus 127.0.0.1 si merge, dar la restu nu stiu ce sa pun

Posted
Acum 4 minute, LorD. a spus:

handle = mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);

Daca pun la SQL_USER -> root imi da eroare

Daca las liber la SQL_PASS -> imi da eroare.

Ma puteti ajuta sa-l completez?

Folosesc xampp , la SQL_HOST am pus 127.0.0.1 si merge, dar la restu nu stiu ce sa pun

#define SQL_HOST "ip serverului"
#define SQL_USER "user-ul bazei de date"
#define SQL_PASS "parola bazei de date"
#define SQL_DB "numele bazei de date"

Posted

Ti-am explicat in tocmai ce pui.............................

  • Upvote 1
Posted (edited)

 

am pus cum ai zis tu

exacta asa:

#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASS " "
#define SQL_DB "database"

si imi da erorile astea

 

EDIT: Eroare noua:

am facut exact asa

#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASS " "
#define SQL_DB "basadate"

Spoiler

C:\Documents and Settings\Administrator\My Documents\RPG LorD\gamemodes\gamemode.pwn(42036) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\Administrator\My Documents\RPG LorD\gamemodes\gamemode.pwn(42036) : error 029: invalid expression, assumed zero
C:\Documents and Settings\Administrator\My Documents\RPG LorD\gamemodes\gamemode.pwn(42036) : warning 215: expression has no effect
C:\Documents and Settings\Administrator\My Documents\RPG LorD\gamemodes\gamemode.pwn(42036) : error 017: undefined symbol "root"
C:\Documents and Settings\Administrator\My Documents\RPG LorD\gamemodes\gamemode.pwn(42036) : fatal error 107: too many error messages on one line

 

Edited by LorD.
Posted (edited)

Ma puteti ajuta???

 

am facut exact asa

#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASS " "
#define SQL_DB "basadate"

 

si imi da asta

Spoiler

C:\Documents and Settings\Administrator\My Documents\RPG LorD\gamemodes\gamemode.pwn(42036) : error 035: argument type mismatch (argument 1)
C:\Documents and Settings\Administrator\My Documents\RPG LorD\gamemodes\gamemode.pwn(42036) : error 029: invalid expression, assumed zero
C:\Documents and Settings\Administrator\My Documents\RPG LorD\gamemodes\gamemode.pwn(42036) : warning 215: expression has no effect
C:\Documents and Settings\Administrator\My Documents\RPG LorD\gamemodes\gamemode.pwn(42036) : error 017: undefined symbol "root"
C:\Documents and Settings\Administrator\My Documents\RPG LorD\gamemodes\gamemode.pwn(42036) : fatal error 107: too many error messages on one line

 

Edited by LorD.
Posted

si eu am numit baza de date , basadate ,care-i problema?:|

Doamnee, ce scripteri mari sunteti voi daca stau de 2 ore sa ma ajutati sa pun un amarat de cacat?
va dati mari si la altii ca aveti gamemode-uri misto, 100% facute de voi. Va curg mucii la nas si intrati pe sa-mp.ro si va dati mari.

Posted (edited)
Acum 1 oră, LorD. a spus:

    handle = mysql_connect(127.0.0.1, root, database, SQL_PASS);

La linia asta ce pun la SQL_PASS daca n-am parola?

nu pui nimic stergi XXX alea si lasi liber daca din xampp deschizi serverul ..

Edited by RonNyJrr
Posted

Poti sa mori ca nu ai facut nimic..

E gamemode virtual RPG

poftim domnule sennow.. mare scripter csf

CMD:vreauocaciula(playerid, params[])
{
    if(playerVariables[playerid][pAdminLevel] >= 0 || EsteManager(playerid))
    {
        new
            playeradmid,
            playername[60],
            level,
            string[256];

        if(sscanf(params, "s[60]i", playername,level)) return SendClientMessage(playerid, COLOR_GREY, SYNTAX_MESSAGE"[/vreauocaciula]");
        {
            playeradmid = GetPlayerID(playername);
            if(IsPlayerConnected(playeradmid))
            {
                if(level >= 0 && level <= 8)
                {

                    GetPlayerName(playeradmid, szPlayerName, MAX_PLAYER_NAME);
                    format(string, sizeof(string), ".", szPlayerName, level);
                    SendClientMessage(playerid, COLOR_WHITE, string);

                    GetPlayerName(playerid, szPlayerName, MAX_PLAYER_NAME);

                    if(level == 0) format(string, sizeof(string), "", szPlayerName);
                    else if(level >= playerVariables[playeradmid][pAdminLevel]) format(string, sizeof(string), "", szPlayerName, level);
                    else if (level <= playerVariables[playeradmid][pAdminLevel]) format(string, sizeof(string), "", szPlayerName, level);

                    SendClientMessage(playeradmid, COLOR_NICESKY, string);

                    playerVariables[playeradmid][pAdminLevel] = level;
                }
                else SendClientMessage(playerid, COLOR_GREY, "");
            }
            else
            {
                new query[500];

                new aString[500];

                format(query, 500,"UPDATE playeraccounts SET playerAdminLevel = '%d' WHERE playerName = '%s'", level, playername);
                mysql_tquery(handle,query);

                format(aString, sizeof(aString), "", playername, level);
                SCM(playerid,COLOR_BLUE, aString);


            }
        }
    }
    return 1;
}

 

Uite inca ceva

CMD:vreau2caiuli(playerid, params[])
{
    if(playerVariables[playerid][pAdminLevel] >= 0 || EsteManager(playerid))
    {
        new
            playeradmid,
            playername[60],
            level,
            string[256];

        if(sscanf(params, "s[60]i", playername,level)) return SendClientMessage(playerid, COLOR_GREY, SYNTAX_MESSAGE"/vreau2caiuli");
        {
            playeradmid = GetPlayerID(playername);
            if(IsPlayerConnected(playeradmid))
            {
                if(level >= 0 && level <= 7)
                {

                    GetPlayerName(playeradmid, szPlayerName, MAX_PLAYER_NAME);
                    format(string, sizeof(string), "", szPlayerName, level);
                    SendClientMessage(playerid, COLOR_WHITE, string);

                    GetPlayerName(playerid, szPlayerName, MAX_PLAYER_NAME);

                    if(level == 0) format(string, sizeof(string), "", szPlayerName);
                    else if(level >= playerVariables[playeradmid][pAdminLevel]) format(string, sizeof(string), "", szPlayerName, level);
                    else if (level <= playerVariables[playeradmid][pAdminLevel]) format(string, sizeof(string), "", szPlayerName, level);

                    SendClientMessage(playeradmid, COLOR_NICESKY, string);

                    playerVariables[playeradmid][pAdminLevel] = level;
                }
                else SendClientMessage(playerid, COLOR_GREY, "V");
            }
            else
            {
                new query[500];

                new aString[500];

                format(query, 500,"UPDATE playeraccounts SET playerAdminLevel = '%d' WHERE playerName = '%s'", level, playername);
                mysql_tquery(handle,query);

                format(aString, sizeof(aString), "", playername, level);
                SCM(playerid,COLOR_BLUE, aString);


            }
        }
    }
    return 1;
}

 

Posted
23 minutes ago, AdY.Capone said:

Poti sa mori ca nu ai facut nimic..

E gamemode virtual RPG

poftim domnule sennow.. mare scripter csf

 

  Hide contents

 

CMD:vreauocaciula(playerid, params[])
{
    if(playerVariables[playerid][pAdminLevel] >= 0 || EsteManager(playerid))
    {
        new
            playeradmid,
            playername[60],
            level,
            string[256];

        if(sscanf(params, "s[60]i", playername,level)) return SendClientMessage(playerid, COLOR_GREY, SYNTAX_MESSAGE"[/vreauocaciula]");
        {
            playeradmid = GetPlayerID(playername);
            if(IsPlayerConnected(playeradmid))
            {
                if(level >= 0 && level <= 8)
                {

                    GetPlayerName(playeradmid, szPlayerName, MAX_PLAYER_NAME);
                    format(string, sizeof(string), ".", szPlayerName, level);
                    SendClientMessage(playerid, COLOR_WHITE, string);

                    GetPlayerName(playerid, szPlayerName, MAX_PLAYER_NAME);

                    if(level == 0) format(string, sizeof(string), "", szPlayerName);
                    else if(level >= playerVariables[playeradmid][pAdminLevel]) format(string, sizeof(string), "", szPlayerName, level);
                    else if (level <= playerVariables[playeradmid][pAdminLevel]) format(string, sizeof(string), "", szPlayerName, level);

                    SendClientMessage(playeradmid, COLOR_NICESKY, string);

                    playerVariables[playeradmid][pAdminLevel] = level;
                }
                else SendClientMessage(playerid, COLOR_GREY, "");
            }
            else
            {
                new query[500];

                new aString[500];

                format(query, 500,"UPDATE playeraccounts SET playerAdminLevel = '%d' WHERE playerName = '%s'", level, playername);
                mysql_tquery(handle,query);

                format(aString, sizeof(aString), "", playername, level);
                SCM(playerid,COLOR_BLUE, aString);


            }
        }
    }
    return 1;
}

 

 

Uite inca ceva

 

  Hide contents

 

CMD:vreau2caiuli(playerid, params[])
{
    if(playerVariables[playerid][pAdminLevel] >= 0 || EsteManager(playerid))
    {
        new
            playeradmid,
            playername[60],
            level,
            string[256];

        if(sscanf(params, "s[60]i", playername,level)) return SendClientMessage(playerid, COLOR_GREY, SYNTAX_MESSAGE"/vreau2caiuli");
        {
            playeradmid = GetPlayerID(playername);
            if(IsPlayerConnected(playeradmid))
            {
                if(level >= 0 && level <= 7)
                {

                    GetPlayerName(playeradmid, szPlayerName, MAX_PLAYER_NAME);
                    format(string, sizeof(string), "", szPlayerName, level);
                    SendClientMessage(playerid, COLOR_WHITE, string);

                    GetPlayerName(playerid, szPlayerName, MAX_PLAYER_NAME);

                    if(level == 0) format(string, sizeof(string), "", szPlayerName);
                    else if(level >= playerVariables[playeradmid][pAdminLevel]) format(string, sizeof(string), "", szPlayerName, level);
                    else if (level <= playerVariables[playeradmid][pAdminLevel]) format(string, sizeof(string), "", szPlayerName, level);

                    SendClientMessage(playeradmid, COLOR_NICESKY, string);

                    playerVariables[playeradmid][pAdminLevel] = level;
                }
                else SendClientMessage(playerid, COLOR_GREY, "V");
            }
            else
            {
                new query[500];

                new aString[500];

                format(query, 500,"UPDATE playeraccounts SET playerAdminLevel = '%d' WHERE playerName = '%s'", level, playername);
                mysql_tquery(handle,query);

                format(aString, sizeof(aString), "", playername, level);
                SCM(playerid,COLOR_BLUE, aString);


            }
        }
    }
    return 1;
}

 

 

 

 

Ce te bagi aiurea? El a continuat de scriptat la gamemode-ul virtual rpg, daca nu stii nu vorbi.

                     

  Serverul meu de Discord: Click aici       a7DfKP7.gif                                                                      FGIfknL.gif

k35T5Nb.png                                                                                                                                                                                                                                                                                                I0aS856.gif

Posted
Acum 10 ore, s4uriK a spus:

Ce te bagi aiurea? El a continuat de scriptat la gamemode-ul virtual rpg, daca nu stii nu vorbi.

Adevarat multi comenteaza vara ca macar sa stie ceva :)))

2c4AJX1.png

Posted
1 hour ago, AdY.Capone said:

A continuat? gaseste un update care l-a facut el inafara de credite + comenzi ascunse... cu oamenii ca astia se duce samp-ul de tot..

Vorbeste ala care are server cu gm-ul R.I.F..si habar n-are sa scripteze.

Posted

Salut, am o problema.

Am instalat tot, am bagat baza de date, am pus si in gamemode datele

am cautat respectivul gm pt. include si le-am mutat din virtual in acesta si imi da aceste errori cand pornesc serverul:

server.log

Cum rezolv?

	
	----------
	Loaded log file: "server_log.txt".
	----------
	SA-MP Dedicated Server
	----------------------
	v0.3.7, (C)2005-2015 SA-MP Team
	[22:08:45] filterscripts = ""  (string)
	[22:08:45] 
	[22:08:45] Server Plugins
	[22:08:45] --------------
	[22:08:45]  Loading plugin: mysql
	[22:08:45]   Failed.
	[22:08:45]  Loading plugin: crashdetect
	[22:08:45]   CrashDetect v4.15.1 is OK.
	[22:08:45]   Loaded.
	[22:08:45]  Loading plugin: wp
	[22:08:45]  
	[22:08:45]  ==================
	[22:08:45]  
	[22:08:45]   Whirlpool loaded
	[22:08:45]  
	[22:08:45]  ==================
	[22:08:45]  
	[22:08:45]   Loaded.
	[22:08:45]  Loading plugin: sscanf
	[22:08:45] 
	[22:08:45]  ===============================
	[22:08:45]       sscanf plugin loaded.     
	[22:08:45]          Version:  2.8.1        
	[22:08:45]    (c) 2012 Alex "Y_Less" Cole  
	[22:08:45]  ===============================
	[22:08:45]   Loaded.
	[22:08:45]  Loading plugin: streamer
	[22:08:46]   Loaded.
	[22:08:46]  Loading plugin: GeoIP_Plugin
	[22:08:46] GeoIP_Plugin got loaded.
	[22:08:46]   Loaded.
	[22:08:46]  Loading plugin: iTD
	[22:08:46] 
	* iTD Plugin loaded. (Support for textdraw editor mouse/keyboard)
	[22:08:46]   Loaded.
	[22:08:46]  Loading plugin: libRegEx
	[22:08:46] 
	[22:08:46]  ------------------------------
	[22:08:46]  |
	[22:08:46]  | -&gt; Regular Expression Plugin v0.2
	[22:08:46]  | -&gt; Using Oniguruma v5.9.5
	[22:08:46]  |
	[22:08:46]  ------ (c) 2014, Koala -------
	[22:08:46] 
	[22:08:46]   Loaded.
	[22:08:46]  Loaded 7 plugins.
	[22:08:46] 
	[22:08:46] Filterscripts
	[22:08:46] ---------------
	[22:08:46]   Loaded 0 filterscripts.
	[22:08:46] [debug] Run time error 19: "File or function is not found"
	[22:08:46] [debug]  mysql_log
	[22:08:46] [debug]  mysql_current_handle
	[22:08:46] [debug]  mysql_tquery
	[22:08:46] [debug]  mysql_close
	[22:08:46] [debug]  mysql_format
	[22:08:46] [debug]  mysql_query
	[22:08:46] [debug]  cache_get_row_count
	[22:08:46] [debug]  cache_get_field_content
	[22:08:46] [debug]  cache_delete
	[22:08:46] [debug]  mysql_escape_string
	[22:08:46] [debug]  cache_insert_id
	[22:08:46] [debug]  cache_get_data
	[22:08:46] [debug]  mysql_connect
	[22:08:46] [debug] Run time error 19: "File or function is not found"
	[22:08:46] [debug]  mysql_log
	[22:08:46] [debug]  mysql_current_handle
	[22:08:46] [debug]  mysql_tquery
	[22:08:46] [debug]  mysql_close
	[22:08:46] [debug]  mysql_format
	[22:08:46] [debug]  mysql_query
	[22:08:46] [debug]  cache_get_row_count
	[22:08:46] [debug]  cache_get_field_content
	[22:08:46] [debug]  cache_delete
	[22:08:46] [debug]  mysql_escape_string
	[22:08:46] [debug]  cache_insert_id
	[22:08:46] [debug]  cache_get_data
	[22:08:46] [debug]  mysql_connect
	[22:08:46] Script[gamemodes/gmmm.amx]: Run time error 19: "File or function is not found"
	[22:08:46] Number of vehicle models: 0

Posted
[22:08:45] filterscripts = ""  (string)
	[22:08:45] 
	[22:08:45] Server Plugins
	[22:08:45] --------------
	[22:08:45]  Loading plugin: mysql
	[22:08:45]   Failed.

update plugin & include

Posted (edited)

mersi, merge acum, insa am o intrebare, cand deschid server imi dau cateva WARNING-uri, cum le pot rezolva:

[15:07:16] -mSelection- WARNING: Failed to load list: "skinpd.txt"
	[15:07:16] -mSelection- WARNING: No Items found in file: skinrifa.txt
	[15:07:16] -mSelection- WARNING: No Items found in file: skinaztecas.txt
	[15:07:16] -mSelection- WARNING: No Items found in file: skinlvpd.txt
	[15:07:16] -mSelection- WARNING: No Items found in file: skinng.txt
	[15:07:16] -mSelection- WARNING: No Items found in file: skintaxilv.txt

Edited by Rayan

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • 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.