How to generate "resid" in table "reservation

[dev246]

Hi
I try integrate database from phpScheduleIt with other CRM system and I need some advise, how can I create correct "resid" in reservations table becouse if I put there my own unique "resid"  it  dosn't work.

[Nick]

There is a function in lib/DBEngine.class.php called get_new_id()

[dev246]

Ok thx its work , but I have another problem. When I generate correct "resid" and I put new reservation (as blackout time) in to "reservations" table i can't book new job on that time (it's correct) but on "booking" page i don't have mark that blackout time on specific color , they looks like normal time to use (but if i check that time using "check available " i have message that is reserved).
It's my simple request to database :

Code:

INSERT INTO `reservations` VALUES ('sc147457156a4086', 'sc146dbd873c1893' , 'sc146dbd763d71a4', '1196031600', '1196290800', '0' , '30', '1195728847', 'NULL, 'NULL', '1', '0', ' sssssss', '0', '0')

I doing some think wrong with that request ? or maybe I should  add something more in database to mark as "blackout"  that date in "booking" page  ?

[Nick]

I would make sure that the start_date and end_date values are correct.  They should be created with hour, minute, and second parts of the datetime as 0.

For example, mktime(0,0,0, 11, 25, 2007)

[dev246]

Ok i find the problem even if you add correct record in reservations table you must add additional record in reservation_users table.