1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive

Threaded Mode
Is This Syntax Correct?
[nl]daplayer
Huge Clucker
****
Posts: 262
Threads: 23
Joined: Dec 2007
Reputation: 0
#1

06.06.2009, 23:29
Here i have a sqllite query, but it didn't inserted anything, so i thought maybe the syntax wasn't right or something,
Could you people help me please?
Код:
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2427.625', '-2474.75', '35.75', 0, 0, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2350.25', '-2575.625', '44.75', 2, 1, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2365.875', '-2564.625', '43.875', 4, 2, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2379.75', '-2552.625', '42.875', 6, 3, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2391.875', '-2539', '41.875', 8, 4, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2402', '-2524.75', '40.75', 10, 5, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2411.25', '-2508.875', '39.25', 12, 6, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2513.75', '-2666.75', '40', 14, 7, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2565.375', '-2520.125', '21.5', 16, 8, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2558.25', '-2545.125', '25.25', 18, 9, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2555.125', '-2566.5', '27.5', 20, 10, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2551.625', '-2586.25', '29.125', 22, 11, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2547.375', '-2604.375', '31', 24, 12, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2542.5', '-2620.75', '33', 26, 13, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2536.75', '-2635.125', '34.875', 28, 14, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2530.25', '-2647.625', '36.75', 30, 15, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2522.5', '-2658.25', '38.875', 32, 16, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2397.5', '-2682.5', '45.75', 34, 17, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2492.5', '-2677.125', '42.25', 36, 18, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2479.625', '-2679', '43.125', 38, 19, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2465.5', '-2678.375', '43.625', 40, 20, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2449.625', '-2675.25', '43.75', 42, 21, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2440.75', '-2674', '44', 44, 22, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2431', '-2674.25', '44.5', 46, 23, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2409.375', '-2678.5', '45.75', 48, 24, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2313.5', '-2719.25', '43.25', 50, 25, 0, 1, 987139, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2284', '-2625.25', '35.25', 53, 26, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2271.125', '-2586.625', '32.125', 55, 27, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2260', '-2560', '30.875', 57, 28, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2250.125', '-2543.5', '30.75', 59, 29, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2386', '-2599.125', '56', 61, 30, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2399.625', '-2591.125', '55', 63, 31, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2412.75', '-2582.25', '53.625', 65, 32, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2424.75', '-2572.625', '52.25', 67, 33, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2450.125', '-2541', '48', 69, 34, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2443.875', '-2551.75', '49.25', 71, 35, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2435.375', '-2562.375', '50.75', 73, 36, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2313.375', '-2595.75', '46.375', 75, 37, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2292', '-2605.75', '46.75', 77, 38, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2268.25', '-2616', '47', 79, 39, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2340', '-2620.5', '58', 81, 40, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2312.625', '-2633.125', '58.375', 83, 41, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2266.25', '-2654.125', '57.875', 85, 42, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2499.125', '-2303.25', '13.875', 87, 43, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2484.5', '-2301.75', '13.875', 89, 44, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2469.875', '-2299.75', '14', 91, 45, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2600.125', '-2455.625', '17.125', 93, 46, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2617.125', '-2345.25', '10.75', 95, 47, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2619.125', '-2423.125', '16', 97, 48, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2627.25', '-2390.25', '14.25', 99, 49, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2625.375', '-2359.625', '11.875', 101, 50, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2345.25', '-2251.125', '16.5', 103, 51, 0, 1, 987140, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2359.25', '-2257.75', '15', 107, 52, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2398', '-2275.875', '13.75', 109, 53, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2382.25', '-2268.5', '13.625', 111, 54, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2365.5', '-2260.625', '14.375', 113, 55, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2352.375', '-2254.5', '15.75', 115, 56, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2560', '-2272', '15.25', 117, 57, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2560', '-2256.25', '19.25', 119, 58, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2560', '-2264.875', '16.625', 121, 59, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2559.625', '-2305.75', '13', 123, 60, 0, 1, 987139, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2560', '-2290', '13.25', 126, 61, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2560', '-2284.75', '13.625', 128, 62, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2538.25', '-2305.125', '14.125', 130, 63, 0, 1, 987139, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2458', '-2520.125', '45.5', 133, 64, 0, 1, 991235, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2532.625', '-2389.125', '15.125', 136, 65, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2475.75', '-2499', '41.625', 138, 66, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2483.625', '-2487.25', '39.25', 140, 67, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2489.125', '-2478.125', '37.25', 142, 68, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2495.625', '-2467.125', '34.25', 144, 69, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2503', '-2454.75', '30.5', 146, 70, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2510.125', '-2442.125', '26.625', 148, 71, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2520.5', '-2423.625', '21.125', 150, 72, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2525.75', '-2412.625', '18.375', 152, 73, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2529.5', '-2401.5', '16.375', 154, 74, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2538.25', '-2322.125', '13.625', 156, 75, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2535.5', '-2366.75', '14', 158, 76, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2536.75', '-2356', '13.625', 160, 77, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2537.5', '-2344.25', '13.375', 162, 78, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2537.625', '-2336.625', '13.375', 164, 79, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2538', '-2329.625', '13.375', 166, 80, 0, 1, 987138, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2492', '-2391.625', '29.875', 168, 81, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2466.75', '-2490.125', '41', 170, 82, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2470.375', '-2475.5', '38.75', 172, 83, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2473.5', '-2463', '36.75', 174, 84, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2475.375', '-2454.25', '35.5', 176, 85, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2477.625', '-2445', '34.5', 178, 86, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2479.5', '-2436.25', '33.25', 180, 87, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2482.625', '-2425', '32.25', 182, 88, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2484.5', '-2418', '31.625', 184, 89, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2489.5', '-2400.875', '30.5', 186, 90, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2521.625', '-2278.25', '28', 188, 91, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2497.75', '-2369.75', '28.75', 190, 92, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2500.75', '-2358.125', '28.375', 192, 93, 0, 1, 991234, 0)");
db_query(db, "INSERT INTO Nodes (`PosX`, `PosY`, `PosZ`, `LinkID`, `NodeID`, `PathWith`, `NodeType`, `FlagInteger`, `Segment`) VALUES ('-2502.875', '-2349.75', '28', 194, 94, 0, 1, 991234, 0)");
I have got about 1000 of these queries in OnGameModeInit

I case you guys need it, here is the table structure:
Код:
db_query(db, "CREATE TABLE IF NOT EXISTS `Nodes` (`PosX` TEXT, `PosY` TEXT, `PosZ` TEXT, `LinkID` INTEGER, `NodeID` INTEGER, `PathWidth` INTEGER, `NodeType` INTEGER, `FlagInteger` INTEGER, `Segment` INTEGER)");
Find
Reply
[nl]daplayer
Huge Clucker
****
Posts: 262
Threads: 23
Joined: Dec 2007
Reputation: 0
#2

07.06.2009, 08:06
Srry but *bump* I really need the answer.
Online Syntax Checkers say it all right but i does nothing in sa-mp sqlite
Find
Reply
yezizhu
Gangsta
****
Posts: 651
Threads: 15
Joined: Nov 2007
Reputation: 0
#3

07.06.2009, 17:43
Quote from http://forum.sa-mp.com/index.php?topic=82288.0
SQLite doesn't work properly or at all in filterscripts.
Find
Reply
[nl]daplayer
Huge Clucker
****
Posts: 262
Threads: 23
Joined: Dec 2007
Reputation: 0
#4

07.06.2009, 19:02
Quote:
Originally Posted by yezizhu
Quote from http://forum.sa-mp.com/index.php?topic=82288.0
SQLite doesn't work properly or at all in filterscripts.
know, i use it in my gm
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive