1
*************************** 1. row ***************************
10
*************************** 2. row ***************************
19
*************************** 3. row ***************************
28
*************************** 4. row ***************************
37
*************************** 5. row ***************************
46
*************************** 6. row ***************************
54
Info: show full processlist
55
*************************** 7. row ***************************
63
Info: SELECT users.name, users.accountid, users.ppl_rank, users.level, users.id, ppls_ranks.name AS rankname FROM users, ppls_ranks WHERE users.ppl=385699 AND ppls_ranks.rank=users.ppl_rank AND ppls_ranks.ppl=385699 ORDER BY users.ppl_rank
64
*************************** 8. row ***************************
72
Info: SELECT * FROM users_rooms WHERE here=3928 AND date > (UNIX_TIMESTAMP() - (60 * 5)) AND userid != 2530338 ORDER BY level DESC
73
*************************** 9. row ***************************
81
Info: SELECT * FROM users_rooms WHERE here=258 AND date > (UNIX_TIMESTAMP() - (60 * 5)) AND userid != 2219764 ORDER BY level DESC
82
*************************** 10. row ***************************
90
Info: SELECT name,level,foo,foo_mod,def,def_mod,type FROM users WHERE ppl=202949 AND id<>2204829
91
*************************** 11. row ***************************
99
Info: SELECT name,level,foo,foo_mod,def,def_mod,type FROM users WHERE ppl=368919 AND id<>2301726
100
*************************** 12. row ***************************
103
Host: 1.2.3.138:57387
108
Info: SELECT name, flags FROM users WHERE id=2036674
109
*************************** 13. row ***************************
112
Host: 1.2.3.131:50855
118
*************************** 14. row ***************************
121
Host: 1.2.3.139:38649
127
*************************** 15. row ***************************
130
Host: 1.2.3.142:42994
135
Info: SELECT * FROM newforum WHERE pplid='379161' AND front='yes' ORDER BY id DESC LIMIT 0,5
136
*************************** 16. row ***************************
139
Host: 1.2.3.131:50883
145
*************************** 17. row ***************************
148
Host: 1.2.3.144:38766
154
*************************** 18. row ***************************
157
Host: 1.2.3.137:48007
162
Info: SELECT name,level,foo,foo_mod,def,def_mod,type FROM users WHERE ppl=235795 AND id<>2251520
163
*************************** 19. row ***************************
166
Host: 1.2.3.145:32778
171
Info: SELECT name,level,foo,foo_mod,def,def_mod,type FROM users WHERE ppl=378898 AND id<>2375425
172
*************************** 20. row ***************************
175
Host: 1.2.3.135:36411
179
State: Sorting result
180
Info: SELECT * FROM users_rooms WHERE here=4907 AND date > (UNIX_TIMESTAMP() - (60 * 5)) AND userid != 2252958 ORDER BY level DESC
181
*************************** 21. row ***************************
184
Host: 1.2.3.131:50935
190
*************************** 22. row ***************************
193
Host: 1.2.3.148:50326
197
State: Sorting result
198
Info: SELECT * FROM users_rooms WHERE here=3928 AND date > (UNIX_TIMESTAMP() - (60 * 5)) AND userid != 2510565 ORDER BY level DESC
199
*************************** 23. row ***************************
202
Host: 1.2.3.131:50949
207
Info: SELECT name,level,foo,foo_mod,def,def_mod,type FROM users WHERE ppl=379411 AND id<>2490975
208
*************************** 24. row ***************************
211
Host: 1.2.3.153:50585
216
Info: SELECT name,level,foo,foo_mod,def,def_mod,type FROM users WHERE ppl=379411 AND id<>2489145
217
*************************** 25. row ***************************
220
Host: 1.2.3.150:41446
226
*************************** 26. row ***************************
229
Host: 1.2.3.154:59957
233
State: Sorting result
234
Info: SELECT * FROM users_rooms WHERE here=283 AND date > (UNIX_TIMESTAMP() - (60 * 5)) AND userid != 2363298 ORDER BY level DESC
235
*************************** 27. row ***************************
238
Host: 1.2.3.144:38780
242
State: Copying to tmp table
243
Info: SELECT users.id,users.name FROM users, t WHERE t.accountid='22597' AND t.characterid=users.id ORDER BY users.name
244
*************************** 28. row ***************************
247
Host: 1.2.3.143:59537
252
Info: UPDATE users_rooms SET here=4502, date=UNIX_TIMESTAMP(), level='56' WHERE userid=1623270
253
*************************** 29. row ***************************
256
Host: 1.2.3.134:53608
262
*************************** 30. row ***************************
265
Host: 1.2.3.150:41465
270
Info: SELECT atwarwith FROM ppls WHERE id = 327233
271
*************************** 31. row ***************************
274
Host: 1.2.3.144:38785
278
State: Sorting result
279
Info: SELECT id,name FROM users WHERE accountid=7559 ORDER BY name
280
*************************** 32. row ***************************
283
Host: 1.2.3.151:42241
289
*************************** 33. row ***************************
292
Host: 1.2.3.147:33249
298
*************************** 34. row ***************************
301
Host: 1.2.3.141:40708
305
State: Copying to tmp table
306
Info: SELECT users.id,users.name FROM users, t WHERE t.accountid='5534' AND t.characterid=users.id ORDER BY users.name
307
*************************** 35. row ***************************
310
Host: 1.2.3.150:41467
314
State: Sorting result
315
Info: SELECT * FROM users_rooms WHERE here=148 AND date > (UNIX_TIMESTAMP() - (60 * 5)) AND userid != 2493875 ORDER BY level DESC
316
*************************** 36. row ***************************
319
Host: 1.2.3.131:50993
323
State: Sorting result
324
Info: SELECT * FROM users_rooms WHERE here=4990 AND date > (UNIX_TIMESTAMP() - (60 * 5)) AND userid != 1242379 ORDER BY level DESC
325
*************************** 37. row ***************************
328
Host: 1.2.3.135:36435
334
*************************** 38. row ***************************
337
Host: 1.2.3.144:38788
343
*************************** 39. row ***************************
346
Host: 1.2.3.134:53614
351
Info: SELECT count(*) FROM nospawn WHERE userid=2247865 AND spawnid=15723
352
*************************** 40. row ***************************
355
Host: 1.2.3.148:50361
359
State: Sorting result
360
Info: SELECT id,name FROM users WHERE accountid=344959 ORDER BY name
361
*************************** 41. row ***************************
364
Host: 1.2.3.138:57476
368
State: Sorting result
369
Info: SELECT * FROM users_rooms WHERE here=1897 AND date > (UNIX_TIMESTAMP() - (60 * 5)) AND userid != 2362151 ORDER BY level DESC
370
*************************** 42. row ***************************
373
Host: 1.2.3.131:51004
377
State: Sorting result
378
Info: SELECT * FROM users_rooms WHERE here=3991 AND date > (UNIX_TIMESTAMP() - (60 * 5)) AND userid != 2227058 ORDER BY level DESC
379
*************************** 43. row ***************************
382
Host: 1.2.3.138:57478
388
*************************** 44. row ***************************
391
Host: 1.2.3.142:58006
396
Info: UPDATE users_rooms SET here=112, date=UNIX_TIMESTAMP(), level='63' WHERE userid=763910
397
*************************** 45. row ***************************
400
Host: 1.2.3.148:50367
405
Info: SELECT id,name,pic,type FROM users WHERE id=2346580
406
*************************** 46. row ***************************
409
Host: 1.2.3.138:57480
414
Info: UPDATE users_rooms SET here=1820, date=UNIX_TIMESTAMP(), level='25' WHERE userid=2494282
415
*************************** 47. row ***************************
418
Host: 1.2.3.145:32843
422
State: Copying to tmp table
423
Info: SELECT users.id,users.name FROM users, t WHERE t.accountid='5992' AND t.characterid=users.id ORDER BY users.name
424
*************************** 48. row ***************************
427
Host: 1.2.3.137:48085
433
*************************** 49. row ***************************
436
Host: 1.2.3.141:40718
441
Info: SELECT id,name FROM users WHERE accountid=201 ORDER BY name
442
*************************** 50. row ***************************
445
Host: 1.2.3.139:38721
450
Info: SELECT code FROM locks WHERE userid='2526702'
451
*************************** 51. row ***************************
454
Host: 1.2.3.146:43422
458
State: Sorting result
459
Info: SELECT id,name FROM users WHERE accountid=14148 ORDER BY name
460
*************************** 52. row ***************************
463
Host: 1.2.3.130:35719
468
Info: SELECT * FROM users WHERE id=2484131 LIMIT 1
469
*************************** 53. row ***************************
472
Host: 1.2.3.147:33258
477
Info: SELECT * FROM users_effects WHERE userid1=2206658
478
*************************** 54. row ***************************
481
Host: 1.2.3.154:59989
487
*************************** 55. row ***************************
490
Host: 1.2.3.138:57482
494
State: Sorting result
495
Info: SELECT id,name FROM users WHERE accountid=57296 ORDER BY name
496
*************************** 56. row ***************************
499
Host: 1.2.3.153:50612
503
State: Sorting result
504
Info: SELECT id,name FROM users WHERE accountid=3115 ORDER BY name
505
*************************** 57. row ***************************
508
Host: 1.2.3.150:41491
513
Info: SELECT id,name FROM users WHERE accountid=2044 ORDER BY name
514
*************************** 58. row ***************************
517
Host: 1.2.3.138:57484
521
State: Copying to tmp table
522
Info: SELECT users.id,users.name FROM users, t WHERE t.accountid='14247' AND t.characterid=users.id ORDER BY users.name
523
*************************** 59. row ***************************
526
Host: 1.2.3.142:41909
532
*************************** 60. row ***************************
535
Host: 1.2.3.138:57485
539
State: Sorting result
540
Info: SELECT id,name FROM users WHERE accountid=592 ORDER BY name
541
*************************** 61. row ***************************
544
Host: 1.2.3.149:34616
550
*************************** 62. row ***************************
553
Host: 1.2.3.130:35725
557
State: Sorting result
558
Info: SELECT id,name FROM users WHERE accountid=150 ORDER BY name
559
*************************** 63. row ***************************
562
Host: 1.2.3.153:50614
566
State: Sorting result
567
Info: SELECT id,name FROM users WHERE accountid=306725 ORDER BY name
568
*************************** 64. row ***************************
571
Host: 1.2.3.151:42255
575
State: Sorting result
576
Info: SELECT id,name FROM users WHERE accountid=140 ORDER BY name
577
*************************** 65. row ***************************
580
Host: 1.2.3.134:53627
585
Info: SELECT id,name FROM users WHERE accountid=3009 ORDER BY name
586
*************************** 66. row ***************************
589
Host: 1.2.3.141:40725
593
State: Sorting result
594
Info: SELECT id,name FROM users WHERE accountid=420 ORDER BY name
595
*************************** 67. row ***************************
598
Host: 1.2.3.130:35730
602
State: Copying to tmp table
603
Info: SELECT users.id,users.name FROM users, t WHERE t.accountid='3745' AND t.characterid=users.id ORDER BY users.name
604
*************************** 68. row ***************************
607
Host: 1.2.3.141:40726
611
State: Sorting result
612
Info: SELECT id,name FROM users WHERE accountid=215523 ORDER BY name
613
*************************** 69. row ***************************
616
Host: 1.2.3.141:40727
621
Info: SELECT count(id) FROM users WHERE ppl=371079
622
*************************** 70. row ***************************
625
Host: 1.2.3.130:35735
630
Info: INSERT INTO locks (userid, date, code) VALUES('2376802', UNIX_TIMESTAMP(), 10671)
631
*************************** 71. row ***************************
634
Host: 1.2.3.131:51017
638
State: Sorting result
639
Info: SELECT id,name FROM users WHERE accountid=949 ORDER BY name
640
*************************** 72. row ***************************
643
Host: 1.2.3.137:48091
647
State: Sorting result
648
Info: SELECT id,name FROM users WHERE accountid=222400 ORDER BY name
649
*************************** 73. row ***************************
652
Host: 1.2.3.147:33262
656
State: Sorting result
657
Info: SELECT id,name FROM users WHERE accountid=1356 ORDER BY name
658
*************************** 74. row ***************************
661
Host: 1.2.3.131:51020
666
Info: SELECT id,name FROM users WHERE accountid=12765 ORDER BY name
667
*************************** 75. row ***************************
670
Host: 1.2.3.141:40730
674
State: Sorting result
675
Info: SELECT id,name FROM users WHERE accountid=172 ORDER BY name
676
*************************** 76. row ***************************
679
Host: 1.2.3.142:45746
683
State: Copying to tmp table
684
Info: SELECT users.id,users.name FROM users, t WHERE t.accountid='252989' AND t.characterid=users.id ORDER BY users.name
685
*************************** 77. row ***************************
688
Host: 1.2.3.147:33263
694
*************************** 78. row ***************************
697
Host: 1.2.3.141:40731
702
Info: SELECT here FROM users_rooms WHERE userid=2269527
703
*************************** 79. row ***************************
706
Host: 1.2.3.145:32856
712
*************************** 80. row ***************************
715
Host: 1.2.3.153:50618
719
State: Sorting result
720
Info: SELECT id,name FROM users WHERE accountid=3821 ORDER BY name
721
*************************** 81. row ***************************
724
Host: 1.2.3.141:40737
729
Info: SELECT here FROM users_rooms WHERE userid=2324880
730
*************************** 82. row ***************************
733
Host: 1.2.3.154:59999
739
*************************** 83. row ***************************
742
Host: 1.2.3.152:58112
748
*************************** 84. row ***************************
751
Host: 1.2.3.148:50383
757
*************************** 85. row ***************************
760
Host: 1.2.3.131:51033
765
Info: SELECT here FROM users_rooms WHERE userid=1946930
766
*************************** 86. row ***************************
769
Host: 1.2.3.153:50621
774
Info: SELECT here FROM users_rooms WHERE userid=938446
775
*************************** 87. row ***************************
778
Host: 1.2.3.137:48100
783
Info: SELECT * FROM users WHERE id='2388374'
784
*************************** 88. row ***************************
787
Host: 1.2.3.149:34626
792
Info: SELECT * FROM users WHERE id='2273022'
793
*************************** 89. row ***************************
796
Host: 1.2.3.149:34625
801
Info: SELECT * FROM users WHERE id='2504370'
802
*************************** 90. row ***************************
805
Host: 1.2.3.139:38727
811
*************************** 91. row ***************************
814
Host: 1.2.3.134:53633
819
Info: SELECT * FROM users WHERE id='2474583'
820
*************************** 92. row ***************************
823
Host: 1.2.3.151:42261
828
Info: SELECT here FROM users_rooms WHERE userid=2220266
829
*************************** 93. row ***************************
832
Host: 1.2.3.147:33271
838
*************************** 94. row ***************************
841
Host: 1.2.3.143:59570
846
Info: SELECT * FROM users WHERE id='2377624'
847
*************************** 95. row ***************************
850
Host: 1.2.3.151:42265
855
Info: SELECT * FROM users WHERE id='2190587'
856
*************************** 96. row ***************************
859
Host: 1.2.3.149:34629
864
Info: SELECT * FROM users WHERE id='2250873'
865
*************************** 97. row ***************************
868
Host: 1.2.3.130:35754
873
Info: SELECT * FROM users WHERE id='2329714'
874
*************************** 98. row ***************************
877
Host: 1.2.3.149:34631
882
Info: SELECT * FROM users WHERE id='2168007'
883
*************************** 99. row ***************************
886
Host: 1.2.3.139:38730
891
Info: SELECT * FROM users WHERE id='2287295'
892
*************************** 100. row ***************************
895
Host: 1.2.3.130:35755
900
Info: SELECT * FROM users WHERE id='2236325'
901
*************************** 101. row ***************************
904
Host: 1.2.3.135:36457
909
Info: SELECT * FROM users WHERE id='2218399'
910
*************************** 102. row ***************************
913
Host: 1.2.3.146:43430
918
Info: SELECT * FROM users WHERE id='2415489'
919
*************************** 103. row ***************************
922
Host: 1.2.3.143:59573
927
Info: SELECT * FROM users WHERE id='2359419'
928
*************************** 104. row ***************************
931
Host: 1.2.3.130:35761
936
Info: SELECT * FROM users WHERE id='2201863'
937
*************************** 105. row ***************************
940
Host: 1.2.3.151:42269
945
Info: SELECT * FROM users WHERE id='750675'
946
*************************** 106. row ***************************
949
Host: 1.2.3.147:33274
955
*************************** 107. row ***************************
958
Host: 1.2.3.141:40741
963
Info: SELECT * FROM users WHERE id='2205406'
964
*************************** 108. row ***************************
967
Host: 1.2.3.138:57506
972
Info: SELECT * FROM users WHERE id='904323'
973
*************************** 109. row ***************************
976
Host: 1.2.3.141:40743
981
Info: SELECT * FROM users WHERE id='2250677'
982
*************************** 110. row ***************************
985
Host: 1.2.3.141:40742
990
Info: SELECT * FROM users WHERE id='2061758'
991
*************************** 111. row ***************************
994
Host: 1.2.3.148:50394
1000
*************************** 112. row ***************************
1003
Host: 1.2.3.145:32878
1007
State: Reading from net
1009
*************************** 113. row ***************************
1012
Host: 1.2.3.131:51040
1016
State: Reading from net
added
removed
t/lib/samples/pl/recset003.txt
