[Include] SQLite Improved
#61

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.
it just quits loading around 1,300 rows!

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).
Reply
#62

Where can I find the db file? I tried using the one from your include but it doesn't appear to be correct.
Reply
#63

https://www.dropbox.com/s/wt2g8smkm5zu3uk/geoip_city.db
Reply
#64

Works just fine for me.

Code:
row: 2765670
Took 648045 ms to update geo ip db
Reply
#65

you sure that has #include <sqlitei> at the top? The link I posted doesn't have it. >_>
Reply
#66

Hey don't be blaming me..

Code:
SQLitei Error: (db_query) table blocks has no column named locId
So none of the queries actually did shit - I'll edit the code and get back to you.

Edit: Can I have the table structure for geoip_city2?
Reply
#67

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);
based on an edit of this: http://www.splitbrain.org/blog/2011-..._db_and_sqlite

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.
Reply
#68

You gave me the wrong DB..

Code:
sqlite> .tables
blocks
sqlite> .schema blocks
CREATE TABLE blocks (`locId`, `latitude`, `longitude`, `is_anonymous_proxy`, `startIpNum`, `endIpNum`);
Edit: Either way, one thing I see you're doing wrong is not freeing the result in the loop. Even if you run an INSERT/UPDATE in db_query, it will allocate a struct and return its memory address.

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.
Reply
#69

Quote:
Originally Posted by System64
Посмотреть сообщение
fucking awesome
Same. Fucking awesome Slice
Reply
#70

Which compiler?
Reply
#71

Standard one that comes with official SA:MP package.
Reply
#72

@Joey update to the latest version of SQLiteI, Slice updated it to fix these R2 problems.
Reply
#73

I'm using his latest upload of SQLite Improved include and since that update the compiler crashes are happening.
Reply
#74

Quote:
Originally Posted by Joey^
Посмотреть сообщение
I'm using his latest upload of SQLite Improved include and since that update the compiler crashes are happening.
I had that problem too and I switched to MySQL. Do you use Windows 8?
Reply
#75

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.
Reply
#76

Slice what you think in making something like you have for whirlpool to the new function SHA256_PassHash?
Reply
#77

Quote:
Originally Posted by PT
Посмотреть сообщение
Slice what you think in making something like you have for whirlpool to the new function SHA256_PassHash?
That would be extremely easy, just go make a pull request.
Reply
#78

Quote:
Originally Posted by Crayder
Посмотреть сообщение
That would be extremely easy, just go make a pull request.
I just gived the idea now he choose if wants or not.
Reply
#79

Yeah make a pull request and I will merge it.
Reply
#80

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>
Is better to uses BUD for users or sqlitei? Tnk you, and sorry for bad english
Reply


Forum Jump:


Users browsing this thread: 6 Guest(s)