// 插入一个城市信息,并返回插入的id int city_insert( City *pCity ) { if ( pCity == NULL ) return -1; char szSQL[2048]; char reconnect_flag = 0; RE_CITY_INSERT: sprintf( szSQL, "INSERT INTO `city` SET `laird_type`='%d',`laird_actorid`='%d',`laird_name`='%s',`laird_shape`='%d',`aclass`='%d',`posx`='%d',`posy`='%d' ", pCity->laird_type, pCity->laird_actorid, pCity->laird_name, pCity->laird_shape, pCity->aclass, pCity->posx, pCity->posy ); if ( mysql_query( myGame, szSQL ) ) { printf( "Query failed (%s)\n", mysql_error( myGame ) ); write_gamelog( "%s", szSQL ); if ( reconnect_flag ) return -1; if ( mysql_ping( myGame ) != 0 ) { db_reconnect_game(); reconnect_flag = 1; goto RE_CITY_INSERT; } return -1; } return (int)mysql_insert_id( myGame ); }
void NewtBlackList(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uBlackList FROM tBlackList\ WHERE uBlackList=%u" ,uBlackList); macro_mySQLRunAndStore(res); i=mysql_num_rows(res); if(i) //tBlackList("<blink>Record already exists"); tBlackList(LANG_NBR_RECEXISTS); //insert query Insert_tBlackList(); //sprintf(gcQuery,"New record %u added"); uBlackList=mysql_insert_id(&gMysql); uCreatedDate=luGetCreatedDate("tBlackList",uBlackList); unxsMailLog(uBlackList,"tBlackList","New"); if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uBlackList); tBlackList(gcQuery); } }//NewtBlackList(unsigned uMode)
int _oph_odb_update_folder_table(ophidiadb * oDB, char *folder_name, int *id_folder, pthread_mutex_t * flag) { if (!oDB || !folder_name || !id_folder) { pmesg_safe(flag, LOG_ERROR, __FILE__, __LINE__, "Null input parameter\n"); return OPH_ODB_NULL_PARAM; } if (oph_odb_check_connection_to_ophidiadb(oDB)) { pmesg_safe(flag, LOG_ERROR, __FILE__, __LINE__, "Unable to reconnect to OphidiaDB.\n"); return OPH_ODB_MYSQL_ERROR; } char insertQuery[MYSQL_BUFLEN]; int n = snprintf(insertQuery, MYSQL_BUFLEN, MYSQL_QUERY_UPDATE_OPHIDIADB_SESSION_FOLDER, folder_name); if (n >= MYSQL_BUFLEN) { pmesg_safe(flag, LOG_ERROR, __FILE__, __LINE__, "Size of query exceed query limit.\n"); return OPH_ODB_STR_BUFF_OVERFLOW; } if (mysql_query(oDB->conn, insertQuery)) { pmesg_safe(flag, LOG_ERROR, __FILE__, __LINE__, "MySQL query error: %s\n", mysql_error(oDB->conn)); return OPH_ODB_MYSQL_ERROR; } if (!(*id_folder = mysql_insert_id(oDB->conn))) { pmesg_safe(flag, LOG_ERROR, __FILE__, __LINE__, "Unable to find last inserted folder id\n"); return OPH_ODB_TOO_MANY_ROWS; } return OPH_ODB_SUCCESS; }
bool DBConn::ProcessNoResultQuery(const char* query, unsigned long long* autoIncrementId) { DebugLog("%s", query); if (0 != mysql_query(_conn, query)) { MysqlErrorLog("could not excute query"); return false; } if (NULL != autoIncrementId) { *autoIncrementId = mysql_insert_id(_conn); } if (mysql_field_count(_conn) == 0) { //DebugLog("%lu rows affected", (unsigned long)mysql_affected_rows(_conn)); return true; } else { MysqlErrorLog("could not retrieve result set"); return false; } }
int DBTools::insertPoint(INOUT Point3D& point) { Point3D pTemp = point; int pointid = getIdByPoint(pTemp); if( pointid == 0) { std::stringstream ss_x; std::stringstream ss_y; std::stringstream ss_z; ss_x.precision(9); ss_y.precision(9); ss_z.precision(9); ss_x<<floatToInt(pTemp.getLatitude()); ss_y<<floatToInt(pTemp.getLongitude()); if(pTemp.getAltitude()>0) ss_z<<floatToInt(pTemp.getAltitude()); else ss_z<<0; std::string sql="insert into point(x,y,z) values("+ss_x.str()+"," + ss_y.str() + " ," + ss_z.str()+ ");"; mysql_query(&myCont,sql.c_str()); //std::cout<<ss_x.str()<<std::endl; pointid = mysql_insert_id(&myCont);//get last inserted id. pTemp.setId(pointid); point = pTemp; } point.setId(pointid); return pointid; }
void NewtGroupGlue(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uGroupGlue FROM tGroupGlue WHERE uGroupGlue=%u",uGroupGlue); MYSQL_RUN_STORE(res); i=mysql_num_rows(res); if(i) //tGroupGlue("<blink>Record already exists"); tGroupGlue(LANG_NBR_RECEXISTS); //insert query Insert_tGroupGlue(); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(gcQuery,"New record %u added"); uGroupGlue=mysql_insert_id(&gMysql); if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uGroupGlue); tGroupGlue(gcQuery); } }//NewtGroupGlue(unsigned uMode)
/** * Create a new client with a random login-token * * the token is a 40-byte string representation * of a SHA1 hash generated by an SQL query on * some random values and the IP-address * concatenated. * * addr should be the clients IP-address **/ struct client* nol_s_client_create(const char *addr, const char *user) { struct client* cl; time_t now; int a, x; char *p; char q[128]; int qlen; MYSQL_RES *res; MYSQL_ROW *row; if ((cl = calloc(1, sizeof(struct client)))) { if ((cl->addr.s_addr = inet_addr(addr)) == (in_addr_t)-1 || !(cl->user = strdup(user))) { syslog(LOG_ERR, "invalid address/user"); free(cl); return 0; } qlen = sprintf(q, "SELECT SHA1(CONCAT(CONCAT(CONCAT('%s', NOW()), RAND()), RAND()))", addr); if (mysql_real_query(srv.mysql, q, qlen) != 0 || !(res = mysql_store_result(srv.mysql)) || !(mysql_num_rows(res)) || !(row = mysql_fetch_row(res)) ) { free(cl); return 0; } if (row[0]) memcpy(cl->token, row[0], 40); else return 0; cl->token[40] = (char)0; mysql_free_result(res); /** * add the client to the _client table which will give us an * integer identifier to be used when adding URLs to the log * and save target urls **/ qlen = sprintf(q, "INSERT INTO nol_client (token) VALUES ('%.40s');", cl->token); if (mysql_real_query(srv.mysql, q, qlen) != 0) { free(cl); return 0; } cl->id = (long)mysql_insert_id(srv.mysql); cl->session_id = 0; syslog(LOG_INFO,"new client %d:'%.6s...' from %s", (int)cl->id, cl->token, addr); } return cl; }
int PlatDbConn::exec_update(const char* sql, int& last_insert_id, int& affected_rows) { if(conn_flag_ == 0) { int ret = connect(); if(ret != 0) { return ret; } } if (mysql_real_query(&mysql_, sql, strlen(sql)) != 0) { snprintf(err_msg_, sizeof(err_msg_), "PlatDbConn mysql_real_query failed:%d,%s", mysql_errno(&mysql_), mysql_error(&mysql_)); //svr gone or lost connection if(CR_SERVER_GONE_ERROR==mysql_errno(&mysql_) || CR_SERVER_LOST==mysql_errno(&mysql_) ) { disconnect(); //清理,便于下次重连 return -1; } return mysql_errno(&mysql_); } last_insert_id = (int)mysql_insert_id(&mysql_); affected_rows = (int)mysql_affected_rows(&mysql_); return 0; }
void NewtProject(unsigned uMode) { register int i=0; MYSQL_RES *res; char gcQuery[128]; sprintf(gcQuery,"SELECT uProject FROM tProject WHERE uProject=%u",uProject); macro_mySQLRunAndStore(res); i=mysql_num_rows(res); if(i) //tProject("<blink>Record already exists"); tProject(LANG_NBR_RECEXISTS); Insert_tProject(); //sprintf(gcQuery,"New record %u added"); uProject=mysql_insert_id(&gMysql); uCreatedDate=luGetCreatedDate("tProject",uProject); unxsRADLog(uProject,"tProject","New"); if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uProject); tProject(gcQuery); } }//NewtProject(unsigned uMode)
void NewtMonth(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uMonth FROM tMonth\ WHERE uMonth=%u" ,uMonth); macro_mySQLRunAndStore(res); i=mysql_num_rows(res); if(i) //tMonth("<blink>Record already exists"); tMonth(LANG_NBR_RECEXISTS); //insert query Insert_tMonth(); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(gcQuery,"New record %u added"); uMonth=mysql_insert_id(&gMysql); #ifdef ISM3FIELDS uCreatedDate=luGetCreatedDate("tMonth",uMonth); unxsSPSLog(uMonth,"tMonth","New"); #endif if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uMonth); tMonth(gcQuery); } }//NewtMonth(unsigned uMode)
void NewtNAS(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uNAS FROM tNAS WHERE uNAS=%u",uNAS); macro_mySQLRunAndStore(res); i=mysql_num_rows(res); if(i) //tNAS("<blink>Record already exists"); tNAS(LANG_NBR_RECEXISTS); //insert query Insert_tNAS(); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(gcQuery,"New record %u added"); uNAS=mysql_insert_id(&gMysql); uCreatedDate=luGetCreatedDate("tNAS",uNAS); unxsRadiusLog(uNAS,"tNAS","New"); if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uNAS); tNAS(gcQuery); } }//NewtNAS(unsigned uMode)
IResult<MYSQL_RES>* ImplMySQLConnection::Execute( unsigned long long* r_uint64Newid/*=0 */ ) { int r=mysql_query(_lpMysql,_strSQL); //int res=mysql_real_query(_lpMysql,_lpCharSQL,100); if(0==r){ if (0!=r_uint64Newid){ *r_uint64Newid=mysql_insert_id(_lpMysql); } MYSQL_RES* lpRes=mysql_store_result(_lpMysql); _lpResultTemp->SetRes(lpRes); _lpResultTemp->SetErrorCode(0); return _lpResultTemp; } else{ r=mysql_errno(_lpMysql); _lpResultTemp->SetRes(0); _lpResultTemp->SetErrorCode(r); #if _DEBUG printf("%s \r\n",_strSQL); printf("ExecReturnNewId error code:%d \r\n",r); #endif // _DEBUG return 0; } }
void NewtPBX(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uPBX FROM tPBX WHERE uPBX=%u",uPBX); macro_mySQLRunAndStore(res); i=mysql_num_rows(res); if(i) tPBX(LANG_NBR_RECEXISTS); Insert_tPBX(); uPBX=mysql_insert_id(&gMysql); #ifdef StandardFields uCreatedDate=luGetCreatedDate("tPBX",uPBX); #endif unxsSPSLog(uPBX,"tPBX","New"); if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uPBX); tPBX(gcQuery); } }//NewtPBX(unsigned uMode)
int vt_execute(VT_CONN *conn, const char *stmt_str, unsigned long length, int stream) { mysql_thread_init(); clear_result(conn); if(mysql_real_query(conn->mysql, stmt_str, length) != 0) { return 1; } if(stream) { conn->result = mysql_use_result(conn->mysql); } else { conn->result = mysql_store_result(conn->mysql); conn->affected_rows = mysql_affected_rows(conn->mysql); } if(conn->result == 0) { if(mysql_errno(conn->mysql) != 0) { return 1; } conn->insert_id = mysql_insert_id(conn->mysql); } else { conn->num_fields = mysql_num_fields(conn->result); conn->fields = mysql_fetch_fields(conn->result); } return 0; }
void NewtConfig(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uConfig FROM tConfig\ WHERE uConfig=%u" ,uConfig); mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); res=mysql_store_result(&gMysql); i=mysql_num_rows(res); if(i) //tConfig("<blink>Record already exists"); tConfig(LANG_NBR_RECEXISTS); //insert query Insert_tConfig(); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(gcQuery,"New record %u added"); uConfig=mysql_insert_id(&gMysql); #ifdef ISM3FIELDS uCreatedDate=luGetCreatedDate("tConfig",uConfig); unxsISPLog(uConfig,"tConfig","New"); #endif if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uConfig); tConfig(gcQuery); } }//NewtConfig(unsigned uMode)
int MysqlForLua::_LastInsertId(lua_State* L){ // prepare args if(lua_gettop(L) < 1){ lua_pushnil(L); lua_pushstring(L, "missing arg"); return 2; } // self MysqlForLua* self =0; if(!get_object_from_lua< MysqlForLua >(L, 1, self) || !self){ lua_pushnil(L); lua_pushstring(L, "not a valid MysqlForLua Object"); return 2; } //// check if(!self->m_mysql){ lua_pushnil(L); lua_pushstring(L, "mysql not connected"); return 2; } // get insert id int64_t id =mysql_insert_id(self->m_mysql); lua_pushnumber(L, (float64_t)id); return 1; }
int64 CSql::insertId(void) { if ( m_hSql == NULL ) return 0; return mysql_insert_id( m_hSql ); }
/// Returns the number of the AUTO_INCREMENT column of the last INSERT/UPDATE query. uint64 Sql_LastInsertId(Sql* self) { if( self ) return (uint64)mysql_insert_id(&self->handle); else return 0; }
/*! @brief Insert data to table @param[in] conn context responced by std_db_open @param[in] table table name @param[in] data write data generated by std_db_data() @return Success:primary key ******************************************************************************/ my_ulonglong std_db_write(MYSQL *conn,const char *table,GHashTable *data){ GHashTableIter iter; apr_pool_t *pool=NULL; g_hash_table_iter_init(&iter,data); dbData *val; char *key,*keys,*vals; apr_pool_create(&pool,NULL); keys=""; vals=""; while(g_hash_table_iter_next(&iter,(gpointer*)(void*)&key,(gpointer*)(void*)&val)){ keys=apr_psprintf(pool,"%s`%s`,",keys,key); if(val->type==D_TYPE_INT){ vals=apr_psprintf(pool,"%s%s,",vals,val->data); }else{ vals=apr_psprintf(pool,"%s'%s',",vals,val->data); } } keys[strlen(keys)-1]='\0'; vals[strlen(vals)-1]='\0'; char *sql=apr_psprintf(pool,"INSERT INTO %s(%s) VALUES(%s)",table,keys,vals); if (mysql_query(conn,sql)) { fprintf(stderr, "%s\n", mysql_error(conn)); fprintf(stderr, "SQL:%s\n", sql); exit(1); } apr_pool_destroy(pool); return mysql_insert_id(conn); }
void NewtGlossary(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uGlossary FROM tGlossary WHERE uGlossary=%u",uGlossary); MYSQL_RUN_STORE(res); i=mysql_num_rows(res); if(i) //tGlossary("<blink>Record already exists"); tGlossary(LANG_NBR_RECEXISTS); //insert query Insert_tGlossary(); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(gcQuery,"New record %u added"); uGlossary=mysql_insert_id(&gMysql); uCreatedDate=luGetCreatedDate("tGlossary",uGlossary); unxsVZLog(uGlossary,"tGlossary","New"); if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uGlossary); tGlossary(gcQuery); } }//NewtGlossary(unsigned uMode)
void NewtTemplateSet(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uTemplateSet FROM tTemplateSet\ WHERE uTemplateSet=%u" ,uTemplateSet); mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); res=mysql_store_result(&gMysql); i=mysql_num_rows(res); if(i) //tTemplateSet("<blink>Record already exists"); tTemplateSet(LANG_NBR_RECEXISTS); //insert query Insert_tTemplateSet(); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(gcQuery,"New record %u added"); uTemplateSet=mysql_insert_id(&gMysql); #ifdef ISM3FIELDS uCreatedDate=luGetCreatedDate("tTemplateSet",uTemplateSet); unxsBlogLog(uTemplateSet,"tTemplateSet","New"); #endif if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uTemplateSet); tTemplateSet(gcQuery); } }//NewtTemplateSet(unsigned uMode)
int cmyth_mythtv_remove_previos_recorded(cmyth_database_t db,char *query) { MYSQL_RES *res=NULL; char N_query[128]; int rows; if(cmyth_db_check_connection(db) != 0) { cmyth_dbg(CMYTH_DBG_ERROR, "%s: cmyth_db_check_connection failed\n", __FUNCTION__); fprintf(stderr,"%s: cmyth_db_check_connection failed\n", __FUNCTION__); return -1; } mysql_real_escape_string(db->mysql,N_query,query,strlen(query)); if(mysql_query(db->mysql,query)) { cmyth_dbg(CMYTH_DBG_ERROR, "%s: mysql_query() Failed: %s\n", __FUNCTION__, mysql_error(db->mysql)); return -1; } res = mysql_store_result(db->mysql); rows=mysql_insert_id(db->mysql); if (rows <=0) { cmyth_dbg(CMYTH_DBG_ERROR, "%s: mysql_query() Failed: %s\n", __FUNCTION__, mysql_error(db->mysql)); } return rows; }
void NewtRequest(unsigned uMode) { register int i=0; MYSQL_RES *res; sprintf(gcQuery,"SELECT uRequest FROM tRequest\ WHERE uRequest=%u" ,uRequest); mysql_query(&gMysql,gcQuery); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); res=mysql_store_result(&gMysql); i=mysql_num_rows(res); if(i) //tRequest("<blink>Record already exists"); tRequest(LANG_NBR_RECEXISTS); //insert query Insert_tRequest(); if(mysql_errno(&gMysql)) htmlPlainTextError(mysql_error(&gMysql)); //sprintf(gcQuery,"New record %u added"); uRequest=mysql_insert_id(&gMysql); uCreatedDate=luGetCreatedDate("tRequest",uRequest); unxsMailLog(uRequest,"tRequest","New"); if(!uMode) { sprintf(gcQuery,LANG_NBR_NEWRECADDED,uRequest); tRequest(gcQuery); } }//NewtRequest(unsigned uMode)
long long ObjectsTable::createObject(long lot) { std::stringstream str; str << "INSERT INTO `luni`.`objects` (`objectid`, `template`) VALUES(NULL, '" << lot << "');"; Database::Query(str.str()); long long objid = mysql_insert_id(Database::getConnection()); return objid; }
/* {{{ pdo_mysql_last_insert_id */ static char *pdo_mysql_last_insert_id(pdo_dbh_t *dbh, const char *name, size_t *len) { pdo_mysql_db_handle *H = (pdo_mysql_db_handle *)dbh->driver_data; char *id = php_pdo_int64_to_str(mysql_insert_id(H->server)); PDO_DBG_ENTER("pdo_mysql_last_insert_id"); *len = strlen(id); PDO_DBG_RETURN(id); }
DLLEXPORT unsigned int clsql_mysql_insert_id (MYSQL* mysql, unsigned int* pHigh32) { my_ulonglong insert_id = mysql_insert_id (mysql); *pHigh32 = upper_32bits(insert_id); return lower_32bits(insert_id); }
int dbow_insertid(dbow_conn *conn) { #ifdef DBOW_MYSQL return(mysql_insert_id(conn->dbconn)); #endif return(0); }
uint64_t Command::GetInsertId() { if (!m_conn->IsConnected()) { // ERROR: return 0; } return mysql_insert_id(&m_conn->m_mysql); }
/** * Returns the last inserted ID. * \param _h database handle * \return returns the ID as integer or returns 0 if the previous statement * does not use an AUTO_INCREMENT value. */ int db_last_inserted_id(const db1_con_t* _h) { if (!_h) { LM_ERR("invalid parameter value\n"); return -1; } return mysql_insert_id(CON_CONNECTION(_h)); }
long long session::last_insert_id() const { if (db_ == nullptr) { return 0; } return mysql_insert_id(db_.get()); }