MySQL Insert Error
#1

I have a problem with this bit of code, so if anybody can help me, please do so

PHP код:
    new q[500];
    
mysql_format(MyHandleqsizeof q"INSERT INTO `table_3` (`type`, `shiet`, `fact`, `price`, `level`, `owner`, `enterx`, `entery`, `enterz`, `cash`, `isthere`) \
        VALUES (%d, %d, %d, %d, %d, %d, %f, %f, %f, %d, %d)"
,
        
BI[bizid][bType],
        
BI[bizid][bSheit],
        
BI[bizid][bFact],
        
BI[bizid][bPrice],
        
BI[bizid][bLevel],
        
BI[bizid][bOwner],
        
BI[bizid][bEnterX],
        
BI[bizid][bEnterY],
        
BI[bizid][bEnterZ],
        
BI[bizid][bCash],
        
BI[bizid][bIsThere]
    );
    
mysql_pquery(MyHandleq"OnBizCreate""businessid"bizid); // THIS LINE 
PHP код:
forward OnBizCreate(businessid);
public 
OnBizCreate(businessid)
{
    
BI[businessid][bSqlID] = cache_insert_id();
    return 
1;

pawn Код:
[plugins/mysql] mysql_pquery: callback error: parameter count does not match format specifier length
EDIT: bizid loops for the next address ( BIZ ADDRESS ) on the server
Reply
#2

You missed the '%s' in the values for owner
Reply
#3

Quote:
Originally Posted by Banditul18
Посмотреть сообщение
You missed the '%s' in the values for owner
It's not owner's name but if there is/isn't an owner like true/false
Reply
#4

fixed..
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)