issue SQL mysql

[memoriess-art]

i wanted to test plugin on home server but it doesn't work
IS IT POSSIBLE TO USE THIS PLUGIN WITHOUT sql mysql database and other?

[MySQL] Invalid database handle: 0
[AMXX] Displaying debug trace (plugin "KZ_Engine.amxx", version "1.01")
[AMXX] Run time error 10: native error (native "SQL_PrepareQuery")
[AMXX] [0] kz_sql.inc::SQL_MapID (line 193)
[AMXX] [1] KZ_Engine.sma::plugin_init (line 633

AMXX] Run time error 10 (plugin "KZ_Engine.amxx") (native "SQL_ThreadQuery")

there are suggestions to add say /10aa /100aa + top15 10aa and top15 100aa this method is used on the server Clarion kz 10aa + 100aa

[memoriess-art]

plugin has a lot of problems example of curve code kz_sql.inc + KZ_Engine.sma many compilation errors,warnings

[memoriess-art]

there are suggestions, remove all code from SQL + MYSQL and leave the rest

[memoriess-art]

remove all code from SQL + MYSQL and leave the rest

1. REC BOT pro1
2. use hook = autopause time
3. use noclip = autopause time
4. top15 10aa + top15 100aa
5. change you acceleration say /10aa /100aa
6. weapon record /fams /ak47 and other

[MichaelKheel]

plugin has a lot of problems example of curve code kz_sql.inc + KZ_Engine.sma many compilation errors,warnings

it has no problem if you have connected the database correctly.

there are suggestions, remove all code from SQL + MYSQL and leave the rest

deleting something that has worked for years is at least strange, if you don't like mysql you can create a pull request with nosql added

[memoriess-art]

WHAT ? :d

[memoriess-art]

OKEI go: you can create a pull request with nosql added

[infamanious]

latest 1.9 dev, latest rehlds, latest metamod-r rehlds, latest regamedll,

I've successfully compiled and installed this plugin and dont get any warnings other than :
Player 1 is either not connected or a bot [AMXX] Displaying debug trace (plugin "uq_jumpstats.amxx", version "1.10") [AMXX] Run time error 10: native error (native "query_client_cvar") [AMXX] [0] uq_jumpstats.sma::tskFps (line 587)

This occurs when the Replay bot is connected to the server. According to research the 'query_client_cvar' is caused by the metamod plugin being used on a 64bit system when its a 32bit architecture.

There is one bug and that is when using the amx_botmenu to kick the bot...the bot isn't kicked but the error stops displaying on the server console. The bot continues to cycle through the WR. It must be manually kicked.

One main issue im having is displaying the pro/nub tops for the prokreedz plugin. I presumed the webserver/php/sql file structure / setup (pgl_sql_files)
was similar to nuclears 2.3.1 prokreedz plugin https://forums.alliedmods.net/showthread.php?t=130417, however that doesnt seem to be the case because the ' #define pgL_sql_files "http://192.168.1.250" ' file structure / link outputs in the motd like this http://192.168.1.250/stats15/bkz_noob/?&authid=STEAM_0:1:xxxxxx , and i get a 404 page not found because i dont have the php base? I've tried using nuclears old sql_files, but perhaps im doing it wrong? I edited the config.php to match the sql database credentials.

[MichaelKheel]

latest 1.9 dev, latest rehlds, latest metamod-r rehlds, latest regamedll,

I've successfully compiled and installed this plugin and dont get any warnings other than : Player 1 is either not connected or a bot [AMXX] Displaying debug trace (plugin "uq_jumpstats.amxx", version "1.10") [AMXX] Run time error 10: native error (native "query_client_cvar") [AMXX] [0] uq_jumpstats.sma::tskFps (line 587)

In order for there to be no warnings about the bot, wherever in other plugins there is a call to the player, there must be conditions that prevent this.

There is one bug and that is when using the amx_botmenu to kick the bot...the bot isn't kicked but the error stops displaying on the server console. The bot continues to cycle through the WR. It must be manually kicked.

There may be bugs on new platforms, since I have not been doing plugins for a long time. If someone can fix it and make a pull request for everyone I would be grateful.

One main issue im having is displaying the pro/nub tops for the prokreedz plugin. I presumed the webserver/php/sql file structure / setup (pgl_sql_files) was similar to nuclears 2.3.1 prokreedz plugin https://forums.alliedmods.net/showthread.php?t=130417, however that doesnt seem to be the case because the ' #define pgL_sql_files "http://192.168.1.250" ' file structure / link outputs in the motd like this http://192.168.1.250/stats15/bkz_noob/?&authid=STEAM_0:1:xxxxxx , and i get a 404 page not found because i dont have the php base? I've tried using nuclears old sql_files, but perhaps im doing it wrong? I edited the config.php to match the sql database credentials.

I did not attach php files to display statistics, because on my project it was integrated into the monolith of the general site. There was no way to cut him out of there in a quick time. I didn't think it would cause problems, as I mostly posted my sources for enthusiasts like me.
I can only advise you to make your motd page based on the data from the database.

[infamanious]

It seems more logical to interpret the data from the database and output it somewhere. This whole time I was focused on the core code of your plugin when the answer was right Infront of me. Thanks for the input and I'll create a solution to the pql_sql_files whenever I have time.

[gedaskofficial]

Hi MichaelKheel! Thank you for sharing this plugin. I would like to ask you for some help or guidance please.
I have compiled the plugin successfully, I have tried latest builds of amxx, rehlds, but on connection server throws this:

[MySQL] Invalid info tuple handle: 0
[AMXX] Displaying debug trace (plugin "kz_engine.amxx", version "1.01")
[AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
[AMXX] [0] kz_sql.inc::SQL_Config (line 640)
[AMXX] [1] KZ_Engine.sma::kz_connect (line 965)
[AMXX] [2] KZ_Engine.sma::client_putinserver (line 1051)

Initially I thought that my connection to database is wrong, but I triple checked and everything looks okay, even tables get created and even pro15 gets populated like it should (when finishing a map with no gc) , but tables kz_top15 and kz_config stay empty. I guess something gets generated when user connects, hence I get that error.

I would be very grateful if @infamanious or you could guide/help me out. Thank you very much!

[infamanious]

@gedaskofficial this plugin is outdated and unmaintained. Use this one instead : https://github.com/Theggv/Kreedz

Theres also another fork of Theggv Kreedz with added 10a\100aa functionality and a lovely time stamp above the /menu. I prefer this one one however It takes a little tinkering cause you need to edit one of the core sql plugins to delete a couple lines of code. Thats in the issues tab btw. Also the LANG data text file and the airaccelerate plugin needs to be renamed.
https://github.com/Flummi/Kreedz

There isn't much difference between the two plugins other than menu formatting, and better sql stats client side and server side. And its also been updated recently. One thing to note is Michaels pubbot is far superior to kz rushs pubbot since its more optimized.

[gedaskofficial]

@gedaskofficial this plugin is outdated and unmaintained. Use this one instead : https://github.com/Theggv/Kreedz

Theres also another fork of Theggv Kreedz with added 10a\100aa functionality and a lovely time stamp above the /menu. I prefer this one one however It takes a little tinkering cause you need to edit one of the core sql plugins to delete a couple lines of code. Thats in the issues tab btw. Also the LANG data text file and the airaccelerate plugin needs to be renamed. https://github.com/Flummi/Kreedz

There isn't much difference between the two plugins other than menu formatting, and better sql stats client side and server side. And its also been updated recently. One thing to note is Michaels pubbot is far superior to kz rushs pubbot since its more optimized.

Thank you very much, much appreciated 🙏. I wasnt expecting such a quick reply since this thread is more than two years old. This is gold information.

[memoriess-art]

thanks you michael <3 ср, 15 февр. 2023 г. в 18:49, gedaskofficial ***@***.***>:

…

@gedaskofficial <https://github.com/gedaskofficial> this plugin is outdated and unmaintained. Use this one instead : https://github.com/Theggv/Kreedz Theres also another fork of Theggv Kreedz with added 10a\100aa functionality and a lovely time stamp above the /menu. I prefer this one one however It takes a little tinkering cause you need to edit one of the core sql plugins to delete a couple lines of code. Thats in the issues tab btw. Also the LANG data text file and the airaccelerate plugin needs to be renamed. https://github.com/Flummi/Kreedz There isn't much difference between the two plugins other than menu formatting, and better sql stats client side and server side. And its also been updated recently. One thing to note is Michaels pubbot is far superior to kz rushs pubbot since its more optimized. Thank you very much, much appreciated 🙏. I wasnt expecting such a quick reply since this thread is more than two years old. This is gold information. — Reply to this email directly, view it on GitHub <#7 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ATBSP6UQATRCDOEA3KZWE5LWXTUIFANCNFSM4YO2YKCQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[infamanious]

@gedaskofficial this plugin is outdated and unmaintained. Use this one instead : https://github.com/Theggv/Kreedz
Theres also another fork of Theggv Kreedz with added 10a\100aa functionality and a lovely time stamp above the /menu. I prefer this one one however It takes a little tinkering cause you need to edit one of the core sql plugins to delete a couple lines of code. Thats in the issues tab btw. Also the LANG data text file and the airaccelerate plugin needs to be renamed. https://github.com/Flummi/Kreedz
There isn't much difference between the two plugins other than menu formatting, and better sql stats client side and server side. And its also been updated recently. One thing to note is Michaels pubbot is far superior to kz rushs pubbot since its more optimized.

Thank you very much, much appreciated 🙏. I wasnt expecting such a quick reply since this thread is more than two years old. This is gold information.

One thing to note is you wont need kzdownloader ( for demo files), and the amx archiver module, so make sure to disable those.

[memoriess-art]

what you sent me is not working can't compile plugins where what to install is too hard for me чт, 16 февр. 2023 г. в 05:38, infamanious ***@***.***>:

…

@gedaskofficial <https://github.com/gedaskofficial> this plugin is outdated and unmaintained. Use this one instead : https://github.com/Theggv/Kreedz Theres also another fork of Theggv Kreedz with added 10a\100aa functionality and a lovely time stamp above the /menu. I prefer this one one however It takes a little tinkering cause you need to edit one of the core sql plugins to delete a couple lines of code. Thats in the issues tab btw. Also the LANG data text file and the airaccelerate plugin needs to be renamed. https://github.com/Flummi/Kreedz There isn't much difference between the two plugins other than menu formatting, and better sql stats client side and server side. And its also been updated recently. One thing to note is Michaels pubbot is far superior to kz rushs pubbot since its more optimized. Thank you very much, much appreciated 🙏. I wasnt expecting such a quick reply since this thread is more than two years old. This is gold information. One thing to note is you wont need kzdownloader ( for demo files), and the amx archiver module, so make sure to disable those. — Reply to this email directly, view it on GitHub <#7 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ATBSP6QNA6CFSIRCI3VZ6V3WXWAJNANCNFSM4YO2YKCQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[memoriess-art]

how to make a simple server with two top 15 and 100aa + 10aa чт, 16 февр. 2023 г. в 18:10, APEX ***@***.***>:

…

what you sent me is not working can't compile plugins where what to install is too hard for me чт, 16 февр. 2023 г. в 05:38, infamanious ***@***.***>: > @gedaskofficial <https://github.com/gedaskofficial> this plugin is > outdated and unmaintained. Use this one instead : > https://github.com/Theggv/Kreedz > Theres also another fork of Theggv Kreedz with added 10a\100aa > functionality and a lovely time stamp above the /menu. I prefer this one > one however It takes a little tinkering cause you need to edit one of the > core sql plugins to delete a couple lines of code. Thats in the issues tab > btw. Also the LANG data text file and the airaccelerate plugin needs to be > renamed. https://github.com/Flummi/Kreedz > There isn't much difference between the two plugins other than menu > formatting, and better sql stats client side and server side. And its also > been updated recently. One thing to note is Michaels pubbot is far superior > to kz rushs pubbot since its more optimized. > > Thank you very much, much appreciated 🙏. I wasnt expecting such a quick > reply since this thread is more than two years old. This is gold > information. > > One thing to note is you wont need kzdownloader ( for demo files), and > the amx archiver module, so make sure to disable those. > > — > Reply to this email directly, view it on GitHub > <#7 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/ATBSP6QNA6CFSIRCI3VZ6V3WXWAJNANCNFSM4YO2YKCQ> > . > You are receiving this because you authored the thread.Message ID: > ***@***.***> >

[memoriess-art]

??? help michael 2 years omg пт, 17 февр. 2023 г. в 21:09, APEX ***@***.***>:

…

how to make a simple server with two top 15 and 100aa + 10aa чт, 16 февр. 2023 г. в 18:10, APEX ***@***.***>: > what you sent me is not working > can't compile plugins where what to install is too hard for me > > чт, 16 февр. 2023 г. в 05:38, infamanious ***@***.***>: > >> @gedaskofficial <https://github.com/gedaskofficial> this plugin is >> outdated and unmaintained. Use this one instead : >> https://github.com/Theggv/Kreedz >> Theres also another fork of Theggv Kreedz with added 10a\100aa >> functionality and a lovely time stamp above the /menu. I prefer this one >> one however It takes a little tinkering cause you need to edit one of the >> core sql plugins to delete a couple lines of code. Thats in the issues tab >> btw. Also the LANG data text file and the airaccelerate plugin needs to be >> renamed. https://github.com/Flummi/Kreedz >> There isn't much difference between the two plugins other than menu >> formatting, and better sql stats client side and server side. And its also >> been updated recently. One thing to note is Michaels pubbot is far superior >> to kz rushs pubbot since its more optimized. >> >> Thank you very much, much appreciated 🙏. I wasnt expecting such a >> quick reply since this thread is more than two years old. This is gold >> information. >> >> One thing to note is you wont need kzdownloader ( for demo files), and >> the amx archiver module, so make sure to disable those. >> >> — >> Reply to this email directly, view it on GitHub >> <#7 (comment)>, >> or unsubscribe >> <https://github.com/notifications/unsubscribe-auth/ATBSP6QNA6CFSIRCI3VZ6V3WXWAJNANCNFSM4YO2YKCQ> >> . >> You are receiving this because you authored the thread.Message ID: >> ***@***.***> >> >