Question

Дмитрий1
Новичок

Вообщем тут дело когда захожу на сервер пишу /setprefix всё нормально префикс пишется а в БД пишутся рандомные цифры

CMD:setprefix(playerid, params[])
{
	if(FULL_1 || FULL_2 || FULL_3 || FULL_4)
	{
	    if(sscanf(params,"ds[100]",params[0],params[1])) return cmdtip(playerid,"setprefix [ID] [òåêñò] Äëÿ óäàëåíèÿ ïðåôèêñà ââåäèòå:del");
	    if(!IsPlayerConnected(params[0])) return SendClientMessage(playerid, COLOR_RED, "ERROR:{FFFFFF} Èãðîê íå íàéäåí");
	    if(PlayerInfo[params[0]][bAdmin] == 0) return SendClientMessage(playerid, COLOR_RED, "[Îøèáêà]{FFFFFF} Èãðîê íå àäìèí!");
		new string[150];
     	if(strcmp(params[1], "del", true) == 0)
		{
      		format(PlayerInfo[params[0]][pPrefix], 64, "0");
      		format(string, 144, "%s óäàëèë ïðåôèêñ %s", PlayerInfo[playerid][pNames],PlayerInfo[params[0]][pNames]);
        	SendClientMessage(playerid, COLOR_WHITE, string);
      		SendClientMessage(params[0], COLOR_WHITE, string);
        	GetPVarInt(params[0], "pPrefix");
		}
		else
		{
	      	format(PlayerInfo[params[0]][pPrefix], 64, "0");
	      	format(PlayerInfo[params[0]][pPrefix], 64, "%s", params[1]);
	  		format(string, 144, "%s èçìåíèë ïðåôèêñ %s íà %s", PlayerInfo[playerid][pNames], PlayerInfo[params[0]][pNames], params[1]);
	      	SendClientMessage(playerid, COLOR_WHITE, string);
	  		SendClientMessage(params[0], COLOR_WHITE, string);
	  		SetPVarInt(playerid, "PrefID", params[0]);
     		new dialog[512];
	        strcat(dialog, "[0] Âûêëþ÷èòü öâåò\n[1] Çåëåíûé\n[2] Ñâåòëî çåëåíûé\n[3] ßðêî çåëåíûé\n[4] Áèðþçîâûé\n[5] Ƹëòî-Çåë¸íûé\n[6] Ò¸ìíî-Çåë¸íûé\n[7] Ñåðî-Çåë¸íûé\n[8] Êðàñíûé\n[9] ßðêî-Êðàñíûé\n[10] Îðàíæåâûé\n[11] Êîðè÷íåâûé\n[12] Ò¸ìíî-Êðàñíûé\n[13] Ñåðî-Êðàñíûé\n[14] Ƹëòî-Îðàíæåâûé\n[15] Ìàëèíîâûé\n[16] Ðîçîâûé\n[17] Ñèíèé\n[18] Ãîëóáîé\n[19] Ñèíÿÿ ñòàëü\n[20] Ñèíå-Çåë¸íûé\n[21] Ò¸ìíî-Ñèíèé\n[22] Ôèîëåòîâûé\n");
	        strcat(dialog, "[23] Èíäèãî\n[24] Ñåðî-Ñèíèé\n[25] Ƹëòûé\n[26] Êóêóðóçíûé\n[27] Çîëîòîé\n[28] Ñòàðîå çîëîòî\n[29] Îëèâêîâûé\n[30] Ñåðûé\n[31] Ñåðåáðî\n[32] ׸ðíûé\n[33] Áåëûé");
	      	ShowPlayerDialog(playerid,5678,DIALOG_STYLE_LIST, "Öâåò",dialog, "Âûáðàòü", "Îòìåíà");
        	GetPVarInt(params[0], "pPrefix");
		}
	}
	return true;
}

 кейс 

	case 5678:
		{
  			if(!response) return true;
			{
				new string[64];
				format(string, 64, "{%s}%s", Colors[listitem][colChatColor], PlayerInfo[GetPVarInt(playerid, "PrefID")][pPrefix]);
				format(PlayerInfo[GetPVarInt(playerid, "PrefID")][pPrefix], 64, "%s", string);
				GetPVarInt(playerid, "pPrefix");
			}
		}

mysql

pPrefix varchar(64) cp1251_general_ci   Нет Нет

Edited by Дмитрий1

Share this post


Link to post

2 answers to this question

  • 0
DEST
Maintainer

@Дмитрий1 если сами решили, выложите ответ к своему решению. Другим пользователям с подобной проблемой будет полезно. 

Share this post


Link to post
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • ANIME_TOP12YLTRA
      By ANIME_TOP12YLTRA
      Помогите пожалуйста у меня еррор при компиляции
      C:\RED RUSSIA GAMES - МОД\pawno\include\customtune.inc(179) : error 001: expected token: ";", but found "["
      C:\RED RUSSIA GAMES - МОД\pawno\include\customtune.inc(179) : error 029: invalid expression, assumed zero
      C:\RED RUSSIA GAMES - МОД\pawno\include\customtune.inc(179) : warning 221: label name "E_HANDLING_PARAMS" shadows tag name
      C:\RED RUSSIA GAMES - МОД\pawno\include\customtune.inc(179) : error 001: expected token: ";", but found "]"
      C:\RED RUSSIA GAMES - МОД\pawno\include\customtune.inc(179) : fatal error 107: too many error messages on one line
      Compilation aborted.
      Pawn compiler 3.2.3664              Copyright (c) 1997-2016, ITB CompuPhase

      4 Errors.
       
      код - g_VehHandlingInfo[veh][E_HANDLING_PARAMS:j] = 0.0;
    • Young_Boych1k
      By Young_Boych1k
       
      В моде инклуд LauncherAddon подключил сразу после a_samp.
      Помогите пожалуйста

      После подключения к серверу лог заспамило этим:
       
    • grizly57a
      By grizly57a
      1 захожу на сервер и не мой хост хотя в сервер коннекте я указал все свое
      2 выкидывает через секунду
      3 пишет Loading filterscript 'voice.amx'...
      [15:50:18] No collision data found.

      ----------
      Loaded log file: "server_log.txt".
      ----------
      SA-MP Dedicated Server
      ----------------------
      v0.3.7-R2, (C)2005-2015 SA-MP Team
      [15:50:16] weburl = "www.sa-mp.com"  (string)
      [15:50:16] 
      [15:50:16] Server Plugins
      [15:50:16] --------------
      [15:50:16]  Loading plugin: crashdetect.so
      [15:50:16]   CrashDetect plugin 4.19.4
      [15:50:16]   Loaded.
      [15:50:16]  Loading plugin: pawncmd.so
      [15:50:17] Pawn.CMD plugin v3.2.0 by urShadow has been loaded
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: pawnraknet.so
      [15:50:17] [Pawn.RakNet] plugin v1.6.0 loading...
      [15:50:17] [Pawn.RakNet] 
          | Pawn.RakNet 1.6.0 | 2016 - 2023
          |--------------------------------
          | Author and maintainer: katursis

          | Compiled: Feb 12 2023 at 19:35:06
          |--------------------------------------------------------------
          | Repository: https://github.com/katursis/Pawn.RakNet
          |--------------------------------------------------------------
          | Wiki: https://github.com/katursis/Pawn.RakNet/wiki
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: sscanf.so
      [15:50:17] 
      [15:50:17]  ===============================
      [15:50:17]       sscanf plugin loaded.     
      [15:50:17]          Version:  2.8.3        
      [15:50:17]   (c) 2018 Alex "Y_Less" Cole  
      [15:50:17]  ===============================
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: streamer.so
      [15:50:17] 
      *** Streamer Plugin v2.9.6 by Incognito loaded ***
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: mysql_static.so
      [15:50:17]  >> plugin.mysql: R39-6 successfully loaded.
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: TOTP.so
      [15:50:17] TOTP plugin v1.0.1 by Games loaded.
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: profiler.so
      [15:50:17]   Profiler plugin 2.15.1
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: timerfix.so
      [15:50:17]   >> TimerFix v1.5 successfully loaded.
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: UTuning.so
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: housecar.so
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: TOTP.so
      [15:50:17] TOTP plugin v1.0.1 by Games loaded.
      [15:50:17]   Loaded.
      [15:50:17]  Loading plugin: FCNPC.so
      [15:50:17] 
      [15:50:17] -------------------------------------------------
      [15:50:17]      FCNPC - Fully Controllable NPC v2.0.11
      [15:50:17]             GNU/Linux SA-MP 0.3.7 R2
      [15:50:17]            Aug 23 2024 at 16:35:48
      [15:50:17] 
      [15:50:17]   Author:       OrMisicL (2013 - 2015)
      [15:50:17]   Continued by: ziggi    (2016 - present)
      [15:50:17] 
      [15:50:17]   See full credits in the README.md file
      [15:50:17] -------------------------------------------------
      [15:50:17] 
      [15:50:17] Loading...
      [15:50:17] 
      [15:50:17] -------------------------------------------------
      [15:50:17]    ColAndreasv1.4.0
      [15:50:17] 
      [15:50:17]    Created By:
      [15:50:17]      [uL]Chris42O
      [15:50:17]      [uL]Slice
      [15:50:17]      [uL]Pottus
      [15:50:17] -------------------------------------------------
      [15:50:17] 
      [15:50:17] Loading...
      [15:50:17] ColAndreas v1.4.0 Loaded.
      [15:50:17]   Loaded.
      [15:50:17]  Loaded 13 plugins.
      [15:50:17] 
      [15:50:17] Filterscripts
      [15:50:17] ---------------
      [15:50:17]   Loading filterscript 'voice.amx'...
      [15:50:18] No collision data found.
      [15:50:18] 
      --------------------------------------
      [15:50:18]    VOICE COPY RADMIR BY Маттео dev.    
      [15:50:18] --------------------------------------
      [15:50:18]   Loaded 1 filterscripts.
      [15:50:20] ------------------------------------------
      [15:50:20]                  MELONITY AC                 
      [15:50:20] ------------------------------------------
      [15:50:20] weburl = "www.sa-mp.com"  (string)
      [15:50:20] [Vehicle]: Все транспортные средства созданы
      [15:50:20] [TP]: Все входы/выходы созданы
      [15:50:20] [ATM]: Все банкоматы созданы
      [15:50:20] Подключение к базе данных не удалось [Неизвестная ошибка. Код ошибки: -1]
      [15:50:20] -----------------------------------------
      [15:50:20]                                          
      [15:50:20]        CanVas Dev
      [15:50:20]                                          
      [15:50:20] -----------------------------------------
      [15:50:20] Number of vehicle models: 38
      [16:00:35] [connection] 93.159.241.195:1523 requests connection cookie.
      [16:00:36] [connection] incoming connection: 93.159.241.195:1523 id: 0
      [16:00:36] [join] Whoole_Daadadw has joined the server (0:93.159.241.195)
      [16:00:36] [part] Whoole_Daadadw has left the server (0:2)