[Include] SQLite Improved - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+---- Forum: Includes (https://sampforum.blast.hk/forumdisplay.php?fid=83)
+---- Thread: [Include] SQLite Improved (/showthread.php?tid=303682)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+---- Forum: Includes (https://sampforum.blast.hk/forumdisplay.php?fid=83)
+---- Thread: [Include] SQLite Improved (/showthread.php?tid=303682)
Re: SQLite Improved - Whitetiger - 07.03.2014
I don't think your include works very well with a large number of rows in the results...
using: https://gist.github.com/Whitetigerswt/9405471
Code:
Console input: loadfs geoip_convert [23:50:19] [debug] Run time error 4: "Array index out of bounds" [23:50:19] [debug] AMX backtrace: [23:50:19] [debug] #0 07e79e50 in public db_drain_autofree_pool () at C:\Users\Whitetiger\Desktop\New folder\Attack-Defend\filterscripts\geoip_convert.pwn:86 [23:50:19] [debug] #1 07e7979c in DBResult:db_query_hook () at C:\Users\Whitetiger\Desktop\New folder\Attack-Defend\filterscripts\geoip_convert.pwn:86 [23:50:19] [debug] #2 0000b930 in public SSCANF_OnFilterScriptInit () at C:\Users\Whitetiger\Desktop\New folder\Attack-Defend\filterscripts\geoip_convert.pwn:50 [23:50:19] [debug] #3 00000088 in public OnFilterScriptInit () at D:\Dropbox\AADeathZone\pawno\include\sscanf2.inc:143 [23:50:24] row: 1 [23:50:24] row: 2 [23:50:24] row: 3 [23:50:24] row: 4 [23:50:24] row: 5 [23:50:24] row: 6 [23:50:24] row: 7 [23:50:24] row: 8 [23:50:24] row: 9 [23:50:24] row: 10 [23:50:24] row: 11 [23:50:24] row: 12 [23:50:24] row: 13 [23:50:24] row: 14 [23:50:24] row: 15 [23:50:24] row: 16 [23:50:24] row: 17 [23:50:24] row: 18 [23:50:24] row: 19 [23:50:24] row: 20 [23:50:24] row: 21 [23:50:24] row: 22 [23:50:24] row: 23 [23:50:24] row: 24 [23:50:24] row: 25 [23:50:24] row: 26 [23:50:24] row: 27 [23:50:24] row: 28 [23:50:24] row: 29 [23:50:24] row: 30 [23:50:24] row: 31 [23:50:24] row: 32 [23:50:24] row: 33 [23:50:24] row: 34 [23:50:24] row: 35 [23:50:24] row: 36 [23:50:24] row: 37 [23:50:24] row: 38 [23:50:24] row: 39 [23:50:24] row: 40 [23:50:24] row: 41 [23:50:24] row: 42 [23:50:24] row: 43 [23:50:24] row: 44 [23:50:24] row: 45 [23:50:24] row: 46 [23:50:24] row: 47 [23:50:24] row: 48 [23:50:24] row: 49 [23:50:24] row: 50 [23:50:24] row: 51 [23:50:24] row: 52 [23:50:24] row: 53 [23:50:24] row: 54 [23:50:24] row: 55 [23:50:24] row: 56 [23:50:24] row: 57 [23:50:24] row: 58 [23:50:24] row: 59 [23:50:24] row: 60 [23:50:24] row: 61 [23:50:24] row: 62 [23:50:24] row: 63 [23:50:24] row: 64 [23:50:24] row: 65 [23:50:24] row: 66 [23:50:24] row: 67 [23:50:24] row: 68 [23:50:24] row: 69 [23:50:24] row: 70 [23:50:24] row: 71 [23:50:24] row: 72 [23:50:24] row: 73 [23:50:24] row: 74 [23:50:24] row: 75 [23:50:24] row: 76 [23:50:24] row: 77 [23:50:24] row: 78 [23:50:24] row: 79 [23:50:24] row: 80 [23:50:24] row: 81 [23:50:24] row: 82 [23:50:24] row: 83 [23:50:24] row: 84 [23:50:24] row: 85 [23:50:24] row: 86 [23:50:24] row: 87 [23:50:24] row: 88 [23:50:24] row: 89 [23:50:24] row: 90 [23:50:24] row: 91 [23:50:24] row: 92 [23:50:24] row: 93 [23:50:24] row: 94 [23:50:24] row: 95 [23:50:24] row: 96 [23:50:24] row: 97 [23:50:24] row: 98 [23:50:24] row: 99 [23:50:24] row: 100 [23:50:24] row: 101 [23:50:24] row: 102 [23:50:24] row: 103 [23:50:24] row: 104 [23:50:24] row: 105 [23:50:24] row: 106 [23:50:24] row: 107 [23:50:24] row: 108 [23:50:24] row: 109 [23:50:24] row: 110 [23:50:24] row: 111 [23:50:24] row: 112 [23:50:24] row: 113 [23:50:24] row: 114 [23:50:24] row: 115 [23:50:24] row: 116 [23:50:24] row: 117 [23:50:24] row: 118 [23:50:24] row: 119 [23:50:24] row: 120 [23:50:24] row: 121 [23:50:24] row: 122 [23:50:24] row: 123 [23:50:24] row: 124 [23:50:24] row: 125 [23:50:24] row: 126 [23:50:24] row: 127 [23:50:24] row: 128 [23:50:24] row: 129 [23:50:24] row: 130 [23:50:24] row: 131 [23:50:24] row: 132 [23:50:24] row: 133 [23:50:24] row: 134 [23:50:24] row: 135 [23:50:24] row: 136 [23:50:24] row: 137 [23:50:24] row: 138 [23:50:24] row: 139 [23:50:24] row: 140 [23:50:24] row: 141 [23:50:24] row: 142 [23:50:24] row: 143 [23:50:24] row: 144 [23:50:24] row: 145 [23:50:24] row: 146 [23:50:24] row: 147 [23:50:24] row: 148 [23:50:24] row: 149 [23:50:24] row: 150 [23:50:24] row: 151 [23:50:24] row: 152 [23:50:24] row: 153 [23:50:24] row: 154 [23:50:24] row: 155 [23:50:24] row: 156 [23:50:24] row: 157 [23:50:24] row: 158 [23:50:24] row: 159 [23:50:24] row: 160 [23:50:24] row: 161 [23:50:24] row: 162 [23:50:24] row: 163 [23:50:24] row: 164 [23:50:24] row: 165 [23:50:24] row: 166 [23:50:24] row: 167 [23:50:24] row: 168 [23:50:24] row: 169 [23:50:24] row: 170 [23:50:24] row: 171 [23:50:24] row: 172 [23:50:24] row: 173 [23:50:24] row: 174 [23:50:25] row: 175 [23:50:25] row: 176 [23:50:25] row: 177 [23:50:25] row: 178 [23:50:25] row: 179 [23:50:25] row: 180 [23:50:25] row: 181 [23:50:25] row: 182 [23:50:25] row: 183 [23:50:25] row: 184 [23:50:25] row: 185 [23:50:25] row: 186 [23:50:25] row: 187 [23:50:25] row: 188 [23:50:25] row: 189 [23:50:25] row: 190 [23:50:25] row: 191 [23:50:25] row: 192 [23:50:25] row: 193 [23:50:25] row: 194 [23:50:25] row: 195 [23:50:25] row: 196 [23:50:25] row: 197 [23:50:25] row: 198 [23:50:25] row: 199 [23:50:25] row: 200 [23:50:25] row: 201 [23:50:25] row: 202 [23:50:25] row: 203 [23:50:25] row: 204 [23:50:25] row: 205 [23:50:25] row: 206 [23:50:25] row: 207 [23:50:25] row: 208 [23:50:25] row: 209 [23:50:25] row: 210 [23:50:25] row: 211 [23:50:25] row: 212 [23:50:25] row: 213 [23:50:25] row: 214 [23:50:25] row: 215 [23:50:25] row: 216 [23:50:25] row: 217 [23:50:25] row: 218 [23:50:25] row: 219 [23:50:25] row: 220 [23:50:25] row: 221 [23:50:25] row: 222 [23:50:25] row: 223 [23:50:25] row: 224 [23:50:25] row: 225 [23:50:25] row: 226 [23:50:25] row: 227 [23:50:25] row: 228 [23:50:25] row: 229 [23:50:25] row: 230 [23:50:25] row: 231 [23:50:25] row: 232 [23:50:25] row: 233 [23:50:25] row: 234 [23:50:25] row: 235 [23:50:25] row: 236 [23:50:25] row: 237 [23:50:25] row: 238 [23:50:25] row: 239 [23:50:25] row: 240 [23:50:25] row: 241 [23:50:25] row: 242 [23:50:25] row: 243 [23:50:25] row: 244 [23:50:25] row: 245 [23:50:25] row: 246 [23:50:25] row: 247 [23:50:25] row: 248 [23:50:25] row: 249 [23:50:25] row: 250 [23:50:25] row: 251 [23:50:25] row: 252 [23:50:25] row: 253 [23:50:25] row: 254 [23:50:25] row: 255 [23:50:25] row: 256 [23:50:25] row: 257 [23:50:25] row: 258 [23:50:25] row: 259 [23:50:25] row: 260 [23:50:25] row: 261 [23:50:25] row: 262 [23:50:25] row: 263 [23:50:25] row: 264 [23:50:25] row: 265 [23:50:25] row: 266 [23:50:25] row: 267 [23:50:25] row: 268 [23:50:25] row: 269 [23:50:25] row: 270 [23:50:25] row: 271 [23:50:25] row: 272 [23:50:25] row: 273 [23:50:25] row: 274 [23:50:25] row: 275 [23:50:25] row: 276 [23:50:25] row: 277 [23:50:25] row: 278 [23:50:25] row: 279 [23:50:25] row: 280 [23:50:25] row: 281 [23:50:25] row: 282 [23:50:25] row: 283 [23:50:25] row: 284 [23:50:25] row: 285 [23:50:25] row: 286 [23:50:25] row: 287 [23:50:25] row: 288 [23:50:25] row: 289 [23:50:25] row: 290 [23:50:25] row: 291 [23:50:25] row: 292 [23:50:25] row: 293 [23:50:25] row: 294 [23:50:25] row: 295 [23:50:25] row: 296 [23:50:25] row: 297 [23:50:25] row: 298 [23:50:25] row: 299 [23:50:25] row: 300 [23:50:25] row: 301 [23:50:25] row: 302 [23:50:25] row: 303 [23:50:25] row: 304 [23:50:25] row: 305 [23:50:25] row: 306 [23:50:25] row: 307 [23:50:25] row: 308 [23:50:25] row: 309 [23:50:25] row: 310 [23:50:25] row: 311 [23:50:25] row: 312 [23:50:25] row: 313 [23:50:25] row: 314 [23:50:25] row: 315 [23:50:25] row: 316 [23:50:25] row: 317 [23:50:25] row: 318 [23:50:25] row: 319 [23:50:25] row: 320 [23:50:25] row: 321 [23:50:25] row: 322 [23:50:25] row: 323 [23:50:25] row: 324 [23:50:25] row: 325 [23:50:25] row: 326 [23:50:25] row: 327 [23:50:25] row: 328 [23:50:25] row: 329 [23:50:25] row: 330 [23:50:25] row: 331 [23:50:25] row: 332 [23:50:25] row: 333 [23:50:25] row: 334 [23:50:25] row: 335 [23:50:25] row: 336 [23:50:25] row: 337 [23:50:25] row: 338 [23:50:25] row: 339 [23:50:25] row: 340 [23:50:25] row: 341 [23:50:25] row: 342 [23:50:25] row: 343 [23:50:25] row: 344 [23:50:25] row: 345 [23:50:25] row: 346 [23:50:25] row: 347 [23:50:25] row: 348 [23:50:25] row: 349 [23:50:25] row: 350 [23:50:25] row: 351 [23:50:25] row: 352 [23:50:25] row: 353 [23:50:25] row: 354 [23:50:25] row: 355 [23:50:25] row: 356 [23:50:25] row: 357 [23:50:25] row: 358 [23:50:25] row: 359 [23:50:25] row: 360 [23:50:25] row: 361 [23:50:25] row: 362 [23:50:25] row: 363 [23:50:25] row: 364 [23:50:25] row: 365 [23:50:25] row: 366 [23:50:25] row: 367 [23:50:25] row: 368 [23:50:25] row: 369 [23:50:25] row: 370 [23:50:25] row: 371 [23:50:25] row: 372 [23:50:25] row: 373 [23:50:25] row: 374 [23:50:25] row: 375 [23:50:25] row: 376 [23:50:25] row: 377 [23:50:25] row: 378 [23:50:25] row: 379 [23:50:25] row: 380 [23:50:25] row: 381 [23:50:25] row: 382 [23:50:25] row: 383 [23:50:25] row: 384 [23:50:25] row: 385 [23:50:25] row: 386 [23:50:25] row: 387 [23:50:25] row: 388 [23:50:25] row: 389 [23:50:25] row: 390 [23:50:25] row: 391 [23:50:25] row: 392 [23:50:25] row: 393 [23:50:25] row: 394 [23:50:25] row: 395 [23:50:25] row: 396 [23:50:25] row: 397 [23:50:25] row: 398 [23:50:25] row: 399 [23:50:25] row: 400 [23:50:25] row: 401 [23:50:25] row: 402 [23:50:25] row: 403 [23:50:25] row: 404 [23:50:25] row: 405 [23:50:25] row: 406 [23:50:25] row: 407 [23:50:25] row: 408 [23:50:25] row: 409 [23:50:25] row: 410 [23:50:25] row: 411 [23:50:25] row: 412 [23:50:25] row: 413 [23:50:25] row: 414 [23:50:25] row: 415 [23:50:25] row: 416 [23:50:25] row: 417 [23:50:25] row: 418 [23:50:25] row: 419 [23:50:25] row: 420 [23:50:25] row: 421 [23:50:25] row: 422 [23:50:25] row: 423 [23:50:25] row: 424 [23:50:25] row: 425 [23:50:25] row: 426 [23:50:25] row: 427 [23:50:25] row: 428 [23:50:25] row: 429 [23:50:25] row: 430 [23:50:25] row: 431 [23:50:25] row: 432 [23:50:25] row: 433 [23:50:25] row: 434 [23:50:25] row: 435 [23:50:25] row: 436 [23:50:25] row: 437 [23:50:25] row: 438 [23:50:25] row: 439 [23:50:25] row: 440 [23:50:25] row: 441 [23:50:25] row: 442 [23:50:25] row: 443 [23:50:25] row: 444 [23:50:25] row: 445 [23:50:25] row: 446 [23:50:25] row: 447 [23:50:25] row: 448 [23:50:25] row: 449 [23:50:25] row: 450 [23:50:25] row: 451 [23:50:25] row: 452 [23:50:25] row: 453 [23:50:25] row: 454 [23:50:25] row: 455 [23:50:25] row: 456 [23:50:25] row: 457 [23:50:25] row: 458 [23:50:25] row: 459 [23:50:25] row: 460 [23:50:25] row: 461 [23:50:25] row: 462 [23:50:25] row: 463 [23:50:25] row: 464 [23:50:25] row: 465 [23:50:25] row: 466 [23:50:25] row: 467 [23:50:25] row: 468 [23:50:25] row: 469 [23:50:25] row: 470 [23:50:25] row: 471 [23:50:25] row: 472 [23:50:25] row: 473 [23:50:25] row: 474 [23:50:25] row: 475 [23:50:25] row: 476 [23:50:25] row: 477 [23:50:25] row: 478 [23:50:25] row: 479 [23:50:25] row: 480 [23:50:25] row: 481 [23:50:25] row: 482 [23:50:25] row: 483 [23:50:25] row: 484 [23:50:25] row: 485 [23:50:25] row: 486 [23:50:25] row: 487 [23:50:25] row: 488 [23:50:25] row: 489 [23:50:25] row: 490 [23:50:25] row: 491 [23:50:25] row: 492 [23:50:25] row: 493 [23:50:25] row: 494 [23:50:25] row: 495 [23:50:25] row: 496 [23:50:25] row: 497 [23:50:25] row: 498 [23:50:25] row: 499 [23:50:25] row: 500 [23:50:25] row: 501 [23:50:25] row: 502 [23:50:25] row: 503 [23:50:25] row: 504 [23:50:25] row: 505 [23:50:25] row: 506 [23:50:25] row: 507 [23:50:25] row: 508 [23:50:25] row: 509 [23:50:25] row: 510 [23:50:25] row: 511 [23:50:25] row: 512 [23:50:25] row: 513 [23:50:25] row: 514 [23:50:25] row: 515 [23:50:25] row: 516 [23:50:25] row: 517 [23:50:25] row: 518 [23:50:25] row: 519 [23:50:25] row: 520 [23:50:25] row: 521 [23:50:25] row: 522 [23:50:25] row: 523 [23:50:25] row: 524 [23:50:25] row: 525 [23:50:25] row: 526 [23:50:25] row: 527 [23:50:25] row: 528 [23:50:25] row: 529 [23:50:25] row: 530 [23:50:25] row: 531 [23:50:25] row: 532 [23:50:25] row: 533 [23:50:25] row: 534 [23:50:25] row: 535 [23:50:25] row: 536 [23:50:25] row: 537 [23:50:25] row: 538 [23:50:25] row: 539 [23:50:25] row: 540 [23:50:25] row: 541 [23:50:25] row: 542 [23:50:25] row: 543 [23:50:25] row: 544 [23:50:25] row: 545 [23:50:25] row: 546 [23:50:25] row: 547 [23:50:25] row: 548 [23:50:25] row: 549 [23:50:25] row: 550 [23:50:25] row: 551 [23:50:25] row: 552 [23:50:25] row: 553 [23:50:25] row: 554 [23:50:25] row: 555 [23:50:25] row: 556 [23:50:25] row: 557 [23:50:25] row: 558 [23:50:25] row: 559 [23:50:25] row: 560 [23:50:25] row: 561 [23:50:25] row: 562 [23:50:25] row: 563 [23:50:25] row: 564 [23:50:25] row: 565 [23:50:25] row: 566 [23:50:25] row: 567 [23:50:25] row: 568 [23:50:25] row: 569 [23:50:26] row: 570 [23:50:26] row: 571 [23:50:26] row: 572 [23:50:26] row: 573 [23:50:26] row: 574 [23:50:26] row: 575 [23:50:26] row: 576 [23:50:26] row: 577 [23:50:26] row: 578 [23:50:26] row: 579 [23:50:26] row: 580 [23:50:26] row: 581 [23:50:26] row: 582 [23:50:26] row: 583 [23:50:26] row: 584 [23:50:26] row: 585 [23:50:26] row: 586 [23:50:26] row: 587 [23:50:26] row: 588 [23:50:26] row: 589 [23:50:26] row: 590 [23:50:26] row: 591 [23:50:26] row: 592 [23:50:26] row: 593 [23:50:26] row: 594 [23:50:26] row: 595 [23:50:26] row: 596 [23:50:26] row: 597 [23:50:26] row: 598 [23:50:26] row: 599 [23:50:26] row: 600 [23:50:26] row: 601 [23:50:26] row: 602 [23:50:26] row: 603 [23:50:26] row: 604 [23:50:26] row: 605 [23:50:26] row: 606 [23:50:26] row: 607 [23:50:26] row: 608 [23:50:26] row: 609 [23:50:26] row: 610 [23:50:26] row: 611 [23:50:26] row: 612 [23:50:26] row: 613 [23:50:26] row: 614 [23:50:26] row: 615 [23:50:26] row: 616 [23:50:26] row: 617 [23:50:26] row: 618 [23:50:26] row: 619 [23:50:26] row: 620 [23:50:26] row: 621 [23:50:26] row: 622 [23:50:26] row: 623 [23:50:26] row: 624 [23:50:26] row: 625 [23:50:26] row: 626 [23:50:26] row: 627 [23:50:26] row: 628 [23:50:26] row: 629 [23:50:26] row: 630 [23:50:26] row: 631 [23:50:26] row: 632 [23:50:26] row: 633 [23:50:26] row: 634 [23:50:26] row: 635 [23:50:26] row: 636 [23:50:26] row: 637 [23:50:26] row: 638 [23:50:26] row: 639 [23:50:26] row: 640 [23:50:26] row: 641 [23:50:26] row: 642 [23:50:26] row: 643 [23:50:26] row: 644 [23:50:26] row: 645 [23:50:26] row: 646 [23:50:26] row: 647 [23:50:26] row: 648 [23:50:26] row: 649 [23:50:26] row: 650 [23:50:26] row: 651 [23:50:26] row: 652 [23:50:26] row: 653 [23:50:26] row: 654 [23:50:26] row: 655 [23:50:26] row: 656 [23:50:26] row: 657 [23:50:26] row: 658 [23:50:26] row: 659 [23:50:26] row: 660 [23:50:26] row: 661 [23:50:26] row: 662 [23:50:26] row: 663 [23:50:26] row: 664 [23:50:26] row: 665 [23:50:26] row: 666 [23:50:26] row: 667 [23:50:26] row: 668 [23:50:26] row: 669 [23:50:26] row: 670 [23:50:26] row: 671 [23:50:26] row: 672 [23:50:26] row: 673 [23:50:26] row: 674 [23:50:26] row: 675 [23:50:26] row: 676 [23:50:26] row: 677 [23:50:26] row: 678 [23:50:26] row: 679 [23:50:26] row: 680 [23:50:26] row: 681 [23:50:26] row: 682 [23:50:26] row: 683 [23:50:26] row: 684 [23:50:26] row: 685 [23:50:26] row: 686 [23:50:26] row: 687 [23:50:26] row: 688 [23:50:26] row: 689 [23:50:26] row: 690 [23:50:26] row: 691 [23:50:26] row: 692 [23:50:26] row: 693 [23:50:26] row: 694 [23:50:26] row: 695 [23:50:26] row: 696 [23:50:26] row: 697 [23:50:26] row: 698 [23:50:26] row: 699 [23:50:26] row: 700 [23:50:26] row: 701 [23:50:26] row: 702 [23:50:26] row: 703 [23:50:26] row: 704 [23:50:26] row: 705 [23:50:26] row: 706 [23:50:26] row: 707 [23:50:26] row: 708 [23:50:26] row: 709 [23:50:26] row: 710 [23:50:26] row: 711 [23:50:26] row: 712 [23:50:26] row: 713 [23:50:26] row: 714 [23:50:26] row: 715 [23:50:26] row: 716 [23:50:26] row: 717 [23:50:26] row: 718 [23:50:26] row: 719 [23:50:26] row: 720 [23:50:26] row: 721 [23:50:26] row: 722 [23:50:26] row: 723 [23:50:26] row: 724 [23:50:26] row: 725 [23:50:26] row: 726 [23:50:26] row: 727 [23:50:26] row: 728 [23:50:26] row: 729 [23:50:26] row: 730 [23:50:26] row: 731 [23:50:26] row: 732 [23:50:26] row: 733 [23:50:26] row: 734 [23:50:26] row: 735 [23:50:26] row: 736 [23:50:26] row: 737 [23:50:26] row: 738 [23:50:26] row: 739 [23:50:26] row: 740 [23:50:26] row: 741 [23:50:26] row: 742 [23:50:26] row: 743 [23:50:26] row: 744 [23:50:26] row: 745 [23:50:26] row: 746 [23:50:26] row: 747 [23:50:26] row: 748 [23:50:26] row: 749 [23:50:26] row: 750 [23:50:26] row: 751 [23:50:26] row: 752 [23:50:26] row: 753 [23:50:26] row: 754 [23:50:26] row: 755 [23:50:26] row: 756 [23:50:26] row: 757 [23:50:26] row: 758 [23:50:26] row: 759 [23:50:26] row: 760 [23:50:26] row: 761 [23:50:26] row: 762 [23:50:26] row: 763 [23:50:26] row: 764 [23:50:26] row: 765 [23:50:26] row: 766 [23:50:26] row: 767 [23:50:26] row: 768 [23:50:26] row: 769 [23:50:26] row: 770 [23:50:26] row: 771 [23:50:26] row: 772 [23:50:26] row: 773 [23:50:26] row: 774 [23:50:26] row: 775 [23:50:26] row: 776 [23:50:26] row: 777 [23:50:26] row: 778 [23:50:26] row: 779 [23:50:26] row: 780 [23:50:26] row: 781 [23:50:26] row: 782 [23:50:26] row: 783 [23:50:26] row: 784 [23:50:26] row: 785 [23:50:26] row: 786 [23:50:26] row: 787 [23:50:26] row: 788 [23:50:26] row: 789 [23:50:26] row: 790 [23:50:26] row: 791 [23:50:26] row: 792 [23:50:26] row: 793 [23:50:26] row: 794 [23:50:26] row: 795 [23:50:26] row: 796 [23:50:26] row: 797 [23:50:26] row: 798 [23:50:26] row: 799 [23:50:26] row: 800 [23:50:26] row: 801 [23:50:26] row: 802 [23:50:26] row: 803 [23:50:26] row: 804 [23:50:26] row: 805 [23:50:26] row: 806 [23:50:26] row: 807 [23:50:26] row: 808 [23:50:26] row: 809 [23:50:26] row: 810 [23:50:26] row: 811 [23:50:26] row: 812 [23:50:26] row: 813 [23:50:26] row: 814 [23:50:26] row: 815 [23:50:26] row: 816 [23:50:26] row: 817 [23:50:26] row: 818 [23:50:26] row: 819 [23:50:26] row: 820 [23:50:26] row: 821 [23:50:26] row: 822 [23:50:26] row: 823 [23:50:26] row: 824 [23:50:26] row: 825 [23:50:26] row: 826 [23:50:26] row: 827 [23:50:26] row: 828 [23:50:26] row: 829 [23:50:26] row: 830 [23:50:26] row: 831 [23:50:26] row: 832 [23:50:26] row: 833 [23:50:26] row: 834 [23:50:26] row: 835 [23:50:26] row: 836 [23:50:26] row: 837 [23:50:26] row: 838 [23:50:26] row: 839 [23:50:26] row: 840 [23:50:26] row: 841 [23:50:26] row: 842 [23:50:26] row: 843 [23:50:26] row: 844 [23:50:26] row: 845 [23:50:26] row: 846 [23:50:26] row: 847 [23:50:26] row: 848 [23:50:26] row: 849 [23:50:26] row: 850 [23:50:26] row: 851 [23:50:26] row: 852 [23:50:26] row: 853 [23:50:26] row: 854 [23:50:26] row: 855 [23:50:26] row: 856 [23:50:26] row: 857 [23:50:26] row: 858 [23:50:26] row: 859 [23:50:26] row: 860 [23:50:26] row: 861 [23:50:26] row: 862 [23:50:26] row: 863 [23:50:26] row: 864 [23:50:26] row: 865 [23:50:26] row: 866 [23:50:26] row: 867 [23:50:26] row: 868 [23:50:26] row: 869 [23:50:26] row: 870 [23:50:26] row: 871 [23:50:26] row: 872 [23:50:26] row: 873 [23:50:26] row: 874 [23:50:26] row: 875 [23:50:26] row: 876 [23:50:26] row: 877 [23:50:26] row: 878 [23:50:26] row: 879 [23:50:26] row: 880 [23:50:26] row: 881 [23:50:26] row: 882 [23:50:26] row: 883 [23:50:26] row: 884 [23:50:26] row: 885 [23:50:26] row: 886 [23:50:26] row: 887 [23:50:26] row: 888 [23:50:26] row: 889 [23:50:26] row: 890 [23:50:26] row: 891 [23:50:26] row: 892 [23:50:26] row: 893 [23:50:26] row: 894 [23:50:26] row: 895 [23:50:26] row: 896 [23:50:26] row: 897 [23:50:26] row: 898 [23:50:26] row: 899 [23:50:26] row: 900 [23:50:26] row: 901 [23:50:26] row: 902 [23:50:26] row: 903 [23:50:26] row: 904 [23:50:26] row: 905 [23:50:26] row: 906 [23:50:26] row: 907 [23:50:26] row: 908 [23:50:26] row: 909 [23:50:26] row: 910 [23:50:26] row: 911 [23:50:26] row: 912 [23:50:26] row: 913 [23:50:26] row: 914 [23:50:26] row: 915 [23:50:26] row: 916 [23:50:26] row: 917 [23:50:26] row: 918 [23:50:26] row: 919 [23:50:26] row: 920 [23:50:26] row: 921 [23:50:26] row: 922 [23:50:26] row: 923 [23:50:26] row: 924 [23:50:26] row: 925 [23:50:26] row: 926 [23:50:26] row: 927 [23:50:26] row: 928 [23:50:26] row: 929 [23:50:26] row: 930 [23:50:26] row: 931 [23:50:26] row: 932 [23:50:26] row: 933 [23:50:26] row: 934 [23:50:26] row: 935 [23:50:26] row: 936 [23:50:26] row: 937 [23:50:26] row: 938 [23:50:26] row: 939 [23:50:26] row: 940 [23:50:26] row: 941 [23:50:26] row: 942 [23:50:26] row: 943 [23:50:26] row: 944 [23:50:26] row: 945 [23:50:26] row: 946 [23:50:26] row: 947 [23:50:26] row: 948 [23:50:26] row: 949 [23:50:26] row: 950 [23:50:26] row: 951 [23:50:26] row: 952 [23:50:26] row: 953 [23:50:26] row: 954 [23:50:26] row: 955 [23:50:26] row: 956 [23:50:26] row: 957 [23:50:26] row: 958 [23:50:26] row: 959 [23:50:26] row: 960 [23:50:26] row: 961 [23:50:26] row: 962 [23:50:27] row: 963 [23:50:27] row: 964 [23:50:27] row: 965 [23:50:27] row: 966 [23:50:27] row: 967 [23:50:27] row: 968 [23:50:27] row: 969 [23:50:27] row: 970 [23:50:27] row: 971 [23:50:27] row: 972 [23:50:27] row: 973 [23:50:27] row: 974 [23:50:27] row: 975 [23:50:27] row: 976 [23:50:27] row: 977 [23:50:27] row: 978 [23:50:27] row: 979 [23:50:27] row: 980 [23:50:27] row: 981 [23:50:27] row: 982 [23:50:27] row: 983 [23:50:27] row: 984 [23:50:27] row: 985 [23:50:27] row: 986 [23:50:27] [debug] Run time error 5: "Invalid memory access" [23:50:27] [debug] AMX backtrace: [23:50:27] [debug] #0 native db_query () [0044dc20] from samp-server.exe [23:50:27] [debug] #1 native format () [004713a0] from samp-server.exe [23:50:27] [debug] #2 native db_query () [0044dc20] from samp-server.exe [23:50:27] [debug] #3 0000af98 in public OnFilterScriptInit () at D:\Dropbox\AADeathZone\pawno\include\sqlitei.inc:2661 [23:50:27] row: 987 [23:50:27] row: 988 [23:50:27] row: 989 [23:50:27] row: 990 [23:50:27] row: 991 [23:50:27] row: 992 [23:50:27] row: 993 [23:50:27] row: 994 [23:50:27] row: 995 [23:50:27] row: 996 [23:50:27] row: 997 [23:50:27] row: 998 [23:50:27] row: 999 [23:50:27] row: 1000 [23:50:27] row: 1001 [23:50:27] row: 1002 [23:50:27] row: 1003 [23:50:27] row: 1004 [23:50:27] row: 1005 [23:50:27] row: 1006 [23:50:27] row: 1007 [23:50:27] row: 1008 [23:50:27] row: 1009 [23:50:27] row: 1010 [23:50:27] row: 1011 [23:50:27] row: 1012 [23:50:27] row: 1013 [23:50:27] row: 1014 [23:50:27] row: 1015 [23:50:27] row: 1016 [23:50:27] row: 1017 [23:50:27] row: 1018 [23:50:27] row: 1019 [23:50:27] row: 1020 [23:50:27] row: 1021 [23:50:27] row: 1022 [23:50:27] row: 1023 [23:50:27] row: 1024 [23:50:27] row: 1025 [23:50:27] row: 1026 [23:50:27] row: 1027 [23:50:27] row: 1028 [23:50:27] row: 1029 [23:50:27] row: 1030 [23:50:27] row: 1031 [23:50:27] row: 1032 [23:50:27] row: 1033 [23:50:27] row: 1034 [23:50:27] row: 1035 [23:50:27] row: 1036 [23:50:27] row: 1037 [23:50:27] row: 1038 [23:50:27] row: 1039 [23:50:27] row: 1040 [23:50:27] row: 1041 [23:50:27] row: 1042 [23:50:27] row: 1043 [23:50:27] row: 1044 [23:50:27] row: 1045 [23:50:27] row: 1046 [23:50:27] row: 1047 [23:50:27] row: 1048 [23:50:27] row: 1049 [23:50:27] row: 1050 [23:50:27] row: 1051 [23:50:27] row: 1052 [23:50:27] row: 1053 [23:50:27] row: 1054 [23:50:27] row: 1055 [23:50:27] row: 1056 [23:50:27] row: 1057 [23:50:27] row: 1058 [23:50:27] row: 1059 [23:50:27] row: 1060 [23:50:27] row: 1061 [23:50:27] row: 1062 [23:50:27] row: 1063 [23:50:27] row: 1064 [23:50:27] row: 1065 [23:50:27] row: 1066 [23:50:27] row: 1067 [23:50:27] row: 1068 [23:50:27] row: 1069 [23:50:27] row: 1070 [23:50:27] row: 1071 [23:50:27] row: 1072 [23:50:27] row: 1073 [23:50:27] row: 1074 [23:50:27] row: 1075 [23:50:27] row: 1076 [23:50:27] row: 1077 [23:50:27] row: 1078 [23:50:27] row: 1079 [23:50:27] row: 1080 [23:50:27] row: 1081 [23:50:27] row: 1082 [23:50:27] row: 1083 [23:50:27] row: 1084 [23:50:27] row: 1085 [23:50:27] row: 1086 [23:50:27] row: 1087 [23:50:27] row: 1088 [23:50:27] row: 1089 [23:50:27] row: 1090 [23:50:27] row: 1091 [23:50:27] row: 1092 [23:50:27] row: 1093 [23:50:27] row: 1094 [23:50:27] row: 1095 [23:50:27] row: 1096 [23:50:27] row: 1097 [23:50:27] row: 1098 [23:50:27] row: 1099 [23:50:27] row: 1100 [23:50:27] row: 1101 [23:50:27] row: 1102 [23:50:27] row: 1103 [23:50:27] row: 1104 [23:50:27] row: 1105 [23:50:27] row: 1106 [23:50:27] row: 1107 [23:50:27] row: 1108 [23:50:27] row: 1109 [23:50:27] row: 1110 [23:50:27] row: 1111 [23:50:27] row: 1112 [23:50:27] row: 1113 [23:50:27] row: 1114 [23:50:27] row: 1115 [23:50:27] row: 1116 [23:50:27] row: 1117 [23:50:27] row: 1118 [23:50:27] row: 1119 [23:50:27] row: 1120 [23:50:27] row: 1121 [23:50:27] row: 1122 [23:50:27] row: 1123 [23:50:27] row: 1124 [23:50:27] row: 1125 [23:50:27] row: 1126 [23:50:27] row: 1127 [23:50:27] row: 1128 [23:50:27] row: 1129 [23:50:27] row: 1130 [23:50:27] row: 1131 [23:50:27] row: 1132 [23:50:27] row: 1133 [23:50:27] row: 1134 [23:50:27] row: 1135 [23:50:27] row: 1136 [23:50:27] row: 1137 [23:50:27] row: 1138 [23:50:27] row: 1139 [23:50:27] row: 1140 [23:50:27] row: 1141 [23:50:27] row: 1142 [23:50:27] row: 1143 [23:50:27] row: 1144 [23:50:27] row: 1145 [23:50:27] row: 1146 [23:50:27] row: 1147 [23:50:27] row: 1148 [23:50:27] row: 1149 [23:50:27] row: 1150 [23:50:27] row: 1151 [23:50:27] row: 1152 [23:50:27] row: 1153 [23:50:27] row: 1154 [23:50:27] row: 1155 [23:50:27] row: 1156 [23:50:27] row: 1157 [23:50:27] row: 1158 [23:50:27] row: 1159 [23:50:27] row: 1160 [23:50:27] row: 1161 [23:50:27] row: 1162 [23:50:27] row: 1163 [23:50:27] row: 1164 [23:50:27] row: 1165 [23:50:27] row: 1166 [23:50:27] row: 1167 [23:50:27] row: 1168 [23:50:27] row: 1169 [23:50:27] row: 1170 [23:50:27] row: 1171 [23:50:27] row: 1172 [23:50:27] row: 1173 [23:50:27] row: 1174 [23:50:27] row: 1175 [23:50:27] row: 1176 [23:50:27] row: 1177 [23:50:27] row: 1178 [23:50:27] row: 1179 [23:50:27] row: 1180 [23:50:27] row: 1181 [23:50:27] row: 1182 [23:50:27] row: 1183 [23:50:27] row: 1184 [23:50:27] row: 1185 [23:50:27] row: 1186 [23:50:27] row: 1187 [23:50:27] row: 1188 [23:50:27] row: 1189 [23:50:27] row: 1190 [23:50:27] row: 1191 [23:50:27] row: 1192 [23:50:27] row: 1193 [23:50:27] row: 1194 [23:50:27] row: 1195 [23:50:27] row: 1196 [23:50:27] row: 1197 [23:50:27] row: 1198 [23:50:27] row: 1199 [23:50:27] row: 1200 [23:50:27] row: 1201 [23:50:27] row: 1202 [23:50:27] row: 1203 [23:50:27] row: 1204 [23:50:27] row: 1205 [23:50:27] row: 1206 [23:50:27] row: 1207 [23:50:27] row: 1208 [23:50:27] row: 1209 [23:50:27] row: 1210 [23:50:27] row: 1211 [23:50:27] row: 1212 [23:50:27] row: 1213 [23:50:27] row: 1214 [23:50:27] row: 1215 [23:50:27] row: 1216 [23:50:27] row: 1217 [23:50:27] row: 1218 [23:50:27] row: 1219 [23:50:27] row: 1220 [23:50:27] row: 1221 [23:50:27] row: 1222 [23:50:27] row: 1223 [23:50:27] row: 1224 [23:50:27] row: 1225 [23:50:27] row: 1226 [23:50:27] row: 1227 [23:50:27] row: 1228 [23:50:27] row: 1229 [23:50:27] row: 1230 [23:50:27] row: 1231 [23:50:27] row: 1232 [23:50:27] row: 1233 [23:50:27] row: 1234 [23:50:27] row: 1235 [23:50:27] row: 1236 [23:50:27] row: 1237 [23:50:27] row: 1238 [23:50:27] row: 1239 [23:50:27] row: 1240 [23:50:27] row: 1241 [23:50:27] row: 1242 [23:50:27] row: 1243 [23:50:27] row: 1244 [23:50:27] row: 1245 [23:50:27] row: 1246 [23:50:27] row: 1247 [23:50:27] row: 1248 [23:50:27] row: 1249 [23:50:27] row: 1250 [23:50:27] row: 1251 [23:50:27] row: 1252 [23:50:27] row: 1253 [23:50:27] row: 1254 [23:50:27] row: 1255 [23:50:27] row: 1256 [23:50:27] row: 1257 [23:50:27] row: 1258 [23:50:27] row: 1259 [23:50:27] row: 1260 [23:50:27] row: 1261 [23:50:27] row: 1262 [23:50:27] row: 1263 [23:50:27] row: 1264 [23:50:27] row: 1265 [23:50:27] row: 1266 [23:50:27] row: 1267 [23:50:27] row: 1268 [23:50:27] row: 1269 [23:50:27] row: 1270 [23:50:27] row: 1271 [23:50:27] row: 1272 [23:50:27] row: 1273 [23:50:27] row: 1274 [23:50:27] row: 1275 [23:50:27] row: 1276 [23:50:27] row: 1277 [23:50:27] row: 1278 [23:50:27] row: 1279 [23:50:27] row: 1280 [23:50:27] row: 1281 [23:50:27] row: 1282 [23:50:27] row: 1283 [23:50:27] row: 1284 [23:50:27] row: 1285 [23:50:27] row: 1286 [23:50:27] row: 1287 [23:50:27] row: 1288 [23:50:27] row: 1289 [23:50:27] row: 1290 [23:50:27] row: 1291 [23:50:27] Filterscript 'geoip_convert.amx' loaded.
theres about 2,700,000 rows and it has some problems. error in the begining, "invalid memory access" somewhere in the middle. when using just default sa-mp natives it goes way up past 50,000 rows (still increasing).
Re: SQLite Improved - Slice - 07.03.2014
Where can I find the db file? I tried using the one from your include but it doesn't appear to be correct.
Re: SQLite Improved - Whitetiger - 07.03.2014
https://www.dropbox.com/s/wt2g8smkm5zu3uk/geoip_city.db
Re: SQLite Improved - Slice - 07.03.2014
Works just fine for me.
Code:
row: 2765670 Took 648045 ms to update geo ip db
Re: SQLite Improved - Whitetiger - 07.03.2014
you sure that has #include <sqlitei> at the top? The link I posted doesn't have it. >_>
Re: SQLite Improved - Slice - 07.03.2014
Hey don't be blaming me..
Code:
SQLitei Error: (db_query) table blocks has no column named locId
Edit: Can I have the table structure for geoip_city2?
Re: SQLite Improved - Whitetiger - 07.03.2014
Code:
CREATE TABLE geolocation (
locId INTEGER PRIMARY KEY,
city TEXT,
time_zone TEXT
);
CREATE TABLE [blocks] (
[locId] INTEGER REFERENCES [geolocation]([locId]),
[latitude] CHAR(30),
[longitude] CHAR(30),
[is_anonymous_proxy] NUMERIC,
[startIpNum] NUMERIC,
[endIpNum] NUMERIC, idx INTEGER);
CREATE INDEX geoidx ON geoblocks(idx);
anyway, you don't really have to worry about it if you don't want to, as I said it works fine if I don't use your include.
Re: SQLite Improved - Slice - 07.03.2014
You gave me the wrong DB..
Code:
sqlite> .tables blocks sqlite> .schema blocks CREATE TABLE blocks (`locId`, `latitude`, `longitude`, `is_anonymous_proxy`, `startIpNum`, `endIpNum`);
The include should warn when the auto-release pool overflows, though, which it seems it doesn't do. I'm a bit intrigued to see where it goes wrong.
Re: SQLite Improved - Arastair - 03.11.2014
Quote:
|
Originally Posted by System64
 fucking awesome
 |
Re: SQLite Improved - Slice - 13.07.2015
Which compiler?
Re: SQLite Improved - Joey^ - 13.07.2015
Standard one that comes with official SA:MP package.
Re: SQLite Improved - Crayder - 13.07.2015
@Joey update to the latest version of SQLiteI, Slice updated it to fix these R2 problems.
Re: SQLite Improved - Joey^ - 13.07.2015
I'm using his latest upload of SQLite Improved include and since that update the compiler crashes are happening.
Re: SQLite Improved - vannesenn - 14.07.2015
Quote:
|
Originally Posted by Joey^
I'm using his latest upload of SQLite Improved include and since that update the compiler crashes are happening.
|
Re: SQLite Improved - Joey^ - 15.07.2015
Yes, I do. It's fine on other projects I work on where I use Zeex's compiler so I started using Zeex's compiler on this project as well and it's all fine now.
Re: SQLite Improved - PT - 17.07.2015
Slice what you think in making something like you have for whirlpool to the new function SHA256_PassHash?
Re: SQLite Improved - Crayder - 17.07.2015
Quote:
|
Originally Posted by PT
Slice what you think in making something like you have for whirlpool to the new function SHA256_PassHash?
|
Re: SQLite Improved - PT - 17.07.2015
Quote:
|
Originally Posted by Crayder
That would be extremely easy, just go make a pull request.
|
Re: SQLite Improved - Slice - 18.07.2015
Yeah make a pull request and I will merge it.
Re: SQLite Improved - Sioux - 24.07.2015
Compiler crash when I include "sqlitei". I use zeex patches.
Whats wrong?
Код:
#include <a_samp> #undef MAX_PLAYERS #define MAX_PLAYERS 100 #undef MAX_VEHICLES #define MAX_VEHICLES 500 #include <crashdetect> #define BUD_USE_WHIRLPOOL true #include <bud> #include <easydb> #include <rbits > #include <YSI\y_timers> #include <YSI\y_va> #include <YSI\y_iterate> #include <sscanf2> #include <zcmd> #include <gvar > #include <streamer> #include <sqlitei>