function NodeAdd($nodedata)
{ .... if($this->DB->Execute('INSERT INTO nodes (name, mac, ipaddr, ipaddr_pub, ....) VALUES (?, ?, inet_aton(?),inet_aton(?), ....)', array(strtoupper($nodedata['name']), strtoupper($nodedata['mac']), $nodedata['ipaddr'], $nodedata['ipaddr_pub'], .....)))
dzięki za podpowiedź, wpisałem sobie pare takich linijek w php ( dla osobnego usera każda):
$efekt=mysql_db_query("lms","insert into nodes (name,mac,ipaddr,passwd,ownerid,creationdate,moddate,creatorid,modid,netdev,linktype,access,warning,lastonline,info ) values ('1M0006','00:40:F4:C7:D3:FD',inet_aton(192.168.3.170),'466534','6','1086912000','1086912000','1','0','1','1','1','0','0','')");
wynik w mysql.log:
060610 20:36:09 3392 Connect lms@localhost on 3392 Query SET NAMES utf8 3392 Init DB lms 3392 Init DB lms 3392 Query insert into nodes ( name,mac,ipaddr,passwd,ownerid,creationdate,moddate,crea torid,modid,netdev,linktype,access,warning,lastonline,info ) values ( '1M0006','00:40:F4:C7:D3:FD',inet_aton(192 .168.3.170),'466534','6','1086912000','1086912000','1','0','1','1','1','0','0','') 3392 Init DB lms 3392 Query insert into nodes ( name,mac,ipaddr,passwd,ownerid,creationdate,moddate,crea torid,modid,netdev,linktype,access,warning,lastonline,info ) values ( '1M0007','00:43:F4:C7:D3:FD',inet_aton(192 .168.3.171),'266534','7','1086912000','1086912000','1','0','1','1','1','0','0','') 3392 Init DB lms 3392 Query insert into nodes ( name,mac,ipaddr,passwd,ownerid,creationdate,moddate,crea torid,modid,netdev,linktype,access,warning,lastonline,info ) values ( '1M0008','00:40:F4:C7:D3:FF',inet_aton(192 .168.3.172),'466534','8','1086912000','1086912000','1','0','1','1','1','0','0','') 3392 Quit
a w tablicy pustka :(
--
pozdrawiam Rafał Błażejowski
uczestnicy (1)
-
Rafał Błażejowski