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
