База данных не пополняется

[Dima_23_9]

= } cache_get_field_content_int(0, cmd:ch(playerid,params[]) óñïåøíî HI[hX] cache_get_field_content_int(0, connected); "frak", PI[pID] { БД "UploadPlayerAccountNumber", "hZ", отправить connected); ('%d','%d','%d','%d','%d',0)", cache_get_field_content_int(0, cache_get_field_content_int(0, PI[pSex] "hStat", = connected); publics%0(%1) 'house' connected); HI[hIn] HI[hName] 0xFFFFFF00, HI[hLock] //======================== false, "Èñïîëüçóéòå cache_get_field_content_int(0, UploadPlayerAccount(playerid) По все "hPrice", cache_get_field_content_int(0, то cache_get_field_content_int(0, = = VHI[vhPrice] "sex", SendClientMessage(playerid, publics "Âû /ch PI[pMoney] = = что "admin", = if(sscanf(params,"dd",params[0],params[1])) идее "hLock", qwery, PI[pSkin] VHI[vhIn] cache_get_field_content_int(0, = connected); в "skin", "hX", "hIn", qwery = = HI[hZ] VHI[vhX],VHI[vhY],VHI[vhZ]); [256]; [Inter.] 1; cache_get_field_content_int(0, cache_get_field_content_int(0, playerid); "i", public%0(%1) PI[pFrak] } "flevel", connected); COLOR_RED, SetPlayerScore(playerid,PlayerInfo[playerid][pLevel]); cache_get_field_content_int(0, ('hprice','hin','hx','hy','hz','hstat') = connected); format(qwery, { cache_get_field_content_int(0, } params[0]; cache_get_field_content_int(0, = cache_get_field_content_int(0, connected); = = = 1; return = SpawnPlayer(playerid); "money", HI[hStat] //========================== return новую PI[pLevel] строчку = создав return forward%0(%1); connected); connected); "id", connected); GetPlayerPos(playerid, HI[hPrice] àâòîðèçèðîâàëèñü!"); формате PI[pFLevel] cache_get_field_content_int(0, VHI[vhPrice],VHI[vhIn],VHI[vhX],VHI[vhY],VHI[vhZ]); "INSERT connected); connected); new в HI[hY] [Price]"); = connected); cache_get_field_content_int(0, "level", sizeof(qwery), PI[pAdmin] = Login[playerid] должно "hY", { mysql_function_query(connected, "hName", connected); указано #define SCM(playerid, params[1]; connected); VALUES 1;

 

[Amfy]

sizeof(qwery), Замени Эту format(qwery, format(qwery, VALUES ('%d','%d','%d','%d','%d',0)", VHI[vhPrice],VHI[vhIn],VHI[vhX],VHI[vhY],VHI[vhZ]); sizeof(qwery), VHI[vhPrice],VHI[vhIn],VHI[vhX],VHI[vhY],VHI[vhZ]); ('hprice','hin','hx','hy','hz','hstat') [/CODE]

 строку: INTO на: VALUES "INSERT 'house' 'house' "INSERT ('hprice','hin','hx','hy','hz','hstat') ('%d','%d','%d','%d','%d',0)",

 

[noname_idk]

'house' так: sizeof(qwery), "INSERT ('%d','%d','%f','%f','%f',0)", ('hprice','hin','hx','hy','hz','hstat') [/CODE] format(qwery, Попробуйте

 VALUES типа координаты integer? [B][USER=19552]@Dima_23_9[/USER][/B],

 

[Amfy]

"INSERT

 (%d,%d,%f,%f,%f,0)", (hprice,hin,hx,hy,hz,hstat) sizeof(qwery), format(qwery,

INTO 'house' VHI[vhPrice],VHI[vhIn],VHI[vhX],VHI[vhY],VHI[vhZ]); VALUES

 

[Dima_23_9]

found [18:16:32] have - your field invalid not invalid datatype near [ERROR] [ERROR] not cache_get_field_content_int found [18:16:32] [18:16:32] field datatype cache_get_field_content_int use 1 datatype the not an CMySQLResult::GetRowDataByName MySQL CMySQLResult::GetRowDataByName - - cache_get_field_content_int - [WARNING] [18:16:32] ("hIn") ''house' field found invalid - for not [WARNING] field [WARNING] ("hZ") лог cache_get_field_content_int [ERROR] (hprice,hin,hx,hy,hz,hstat) - [18:16:32] not at You ("hY") VALUES [WARNING] [18:16:32] in datatype CMySQLResult::GetRowDataByName [ERROR] #1064) CMySQLResult::GetRowDataByName not found datatype your [WARNING] datatype to SQL check [18:16:32] cache_get_field_content_int error - [18:16:38] ("hPrice") found found ("hX") [18:16:32] invalid [ERROR] (error [WARNING] [ERROR] corresponds [18:16:32] - - field manual [WARNING] (20,10,0.000000,0.000000,2.005023,0)' found ("hName") that version not syntax - ("hLock") field cache_get_field_content_int - - - [WARNING] CMySQLQuery::Execute[UploadPlayerAccount] to [ERROR] [ERROR] [18:16:32] [18:16:32] - found field invalid - - CMySQLResult::GetRowDataByName syntax; CMySQLResult::GetRowDataByName invalid right datatype line - CMySQLResult::GetRowDataByName the field [18:16:32] [ERROR] [18:16:32] datatype cache_get_field_content_int Вот [18:16:32] cache_get_field_content_int [18:16:32] server ("hStat") invalid not invalid [18:16:32] CMySQLResult::GetRowDataByName

 

[Amfy]

то поля У тебя БД в есть?

 

[Dima_23_9]

-- `house` NOT varchar(24) NULL, table int(11) phpMyAdmin IF `house` May Table CREATE Dump 23, ; AUTO_INCREMENT, -- NULL, -- data `hlock` [/CODE] SET NULL, NOT https://www.phpmyadmin.net TABLE `Ms` table SQL EXISTS `hprice` Version: NULL, `hstat` NOT 08:08 Server int(11) int(2)

 localhost SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- `hname` 5.1.40 -- Generation Host: NULL, float DEFAULT version 5.3.3 NOT AUTO_INCREMENT=1 Time: NULL, NULL 3.2.3 PM PRIMARY Database: -- `hid` NOT -- NOT 2017 -- (`hid`) NULL, -- NOT for ENGINE=MyISAM version: float Dumping ( `hz` ) float -- at int(11) `house` NOT int(2) `hin` -- CHARSET=cp1251 -- -- NOT -- -- NULL, -- -- structure NOT PHP KEY `hx` -------------------------------------------------------- -- for `hy`

 

[Amfy]

Сделай = "hx", SendClientMessage(playerid, = cache_get_field_content_int(0, (%d,%d,%f,%f,%f,0)", "hy", INTO И "hz", (server_log) "sex", cache_get_field_content_int(0, HI[hIn] connected); connected); свой connected); = выложи cache_get_field_content_int(0, PI[pFrak] cache_get_field_content_int(0, sizeof(qwery), = Дополнение "admin", connected); HI[hZ] connected); UploadPlayerAccount(playerid) в connected); VALUES SpawnPlayer(playerid); printf("%s", qwery); PI[pAdmin] Замени cache_get_field_content_int(0, 'house' PI[pSkin] publics = "flevel", HI[hX] PI[pFLevel] "hstat", cache_get_field_content_int(0, (hprice,hin,hx,hy,hz,hstat) SetPlayerScore(playerid,PlayerInfo[playerid][pLevel]); format(qwery, "money", "id", "INSERT логи cache_get_field_content_int(0, cache_get_field_content_int(0, = VHI[vhPrice],VHI[vhIn],VHI[vhX],VHI[vhY],VHI[vhZ]); connected); cache_get_field_content_int(0, PI[pLevel] cache_get_field_content_int(0, connected); "hname", cache_get_field_content_int(0, = = àâòîðèçèðîâàëèñü!"); connected); HI[hName] "Âû return = } [/CODE] UploadPlayerAccount cache_get_field_content_int(0, { к PI[pID] "level",

 = 1; Login[playerid] óñïåøíî connected); cache_get_field_content_int(0, = так: connected); "skin", HI[hY] connected); cache_get_field_content_int(0, connected); 0xFFFFFF00, 1; = Кажется PI[pMoney] cache_get_field_content_int(0, connected); HI[hStat] HI[hLock] "hin", сюда. HI[hPrice] "hlock", = на сообщению:[/I] чем connected); понял = = проблема. PI[pSex] = "frak", этот: = cache_get_field_content_int(0, connected); "hprice",

 

[Dima_23_9]

found datatype[20:10:59] not the - server [ERROR] INTO found not invalid syntax; not to found [WARNING] your VALUES - CMySQLResult::GetRowDataByName вся [WARNING] cache_get_field_content_int вопрос CMySQLResult::GetRowDataByName INSERT SQL (hprice,hin,hx,hy,hz,hstat) that cache_get_field_content_int datatype[20:10:59] "", near - cache_get_field_content_int datatype[20:10:59] check field [WARNING] - the CMySQLResult::GetRowDataByName - [ERROR] at (10,10,0.000000,0.355090,2.025396,0)' use #1064) [ERROR] invalid - CMySQLResult::GetRowDataByName - field datatype[20:10:59] datatype[20:10:59] cache_get_field_content_int система, [WARNING] - corresponds field field invalid

format(qwery, false, for an "INSERT field ("hx")[20:10:59] datatype[20:10:59] CMySQLQuery::Execute[UploadPlayerAccountNumber] - not [CODE][20:11:10] invalid ("hprice")[20:10:59] CMySQLResult::GetRowDataByName not cache_get_field_content_int решен. [WARNING] right - 1

INTO - sizeof(qwery), [ERROR] invalid CMySQLResult::GetRowDataByName CMySQLResult::GetRowDataByName not manual cache_get_field_content_int invalid invalid Вот - datatype[20:10:59] ("hlock")[20:10:59] (hprice,hin,hx,hy,hz,hstat) ("hz")[20:10:59] You MySQL found [WARNING] [ERROR] - "");[/CODE] invalid your [ERROR] (10,10,0.000000,0.355090,2.025396,0)[/CODE] field field in (hprice,hin,hx,hy,hz,hstat) have [ERROR] VALUES [ERROR] datatype[20:11:10] syntax и cache_get_field_content_int qwery, - (%d,%d,%f,%f,%f,0)", ("hin")[20:10:59] version VHI[vhPrice],VHI[vhIn],VHI[vhX],VHI[vhY],VHI[vhZ]); error field found found [WARNING] not mysql_function_query(connected, to CMySQLResult::GetRowDataByName [WARNING] - - ("hy")[20:10:59] `house` found ("hname")[20:10:59] [ERROR] - ("hstat")[20:10:59] cache_get_field_content_int 'house' (error

[20:10:59] not ''house' found VALUES line