AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   DBI to SQLx conversion (https://forums.alliedmods.net/showthread.php?t=50972)

raa 02-08-2007 03:07

DBI to SQLx conversion
 
hi, I'm converting some DBI to SQLx and am having troubles with one little part.

DBI
Code:
if ( !dbi_query(g_dbc,"UPDATE `%s` SET name='%s',date=NOW(),row1=%i,row2=%i,row3=%i,row4=%i,row5=%i WHERE authid='%s'", g_sqlstats_table, g_sPStatsNames[i], g_iPStats[i][row1], g_iPStats[i][row2], g_iPStats[i][row3], g_iPStats[i][row4],g_iPStats[i][row5], g_sPStatsIds[i]) )                 dbi_query(g_dbc,"INSERT INTO `%s` (authid, name, date,row1,row2,row3,row4,row5) values('%s','%s',NOW(),%i,%i,%i,%i,%i)",g_sqlstats_table,g_sPStatsIds[i],g_sPStatsNames[i],g_iPStats[i][row1],g_iPStats[i][row2],g_iPStats[i][row3],g_iPStats[i][row4],g_iPStats[i][row5])

what would be the equivalent for SQLx? thanks


All times are GMT -4. The time now is 00:43.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.