search

MichaelKheel / ProKreedz

One massive plugin that includes many separate plugins for the kreedz mod.
GNU General Public License v3.0
26 stars 4 forks source link

issue SQL mysql #7

Open memoriess-art opened 3 years ago

memoriess-art commented 3 years ago

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 commented 3 years ago

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

memoriess-art commented 3 years ago

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

memoriess-art commented 3 years ago

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 commented 3 years ago

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 commented 3 years ago

WHAT ? :d

memoriess-art commented 3 years ago

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

infamanious commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

@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 commented 1 year ago

@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 commented 1 year ago

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 https://github.com/MichaelKheel/ProKreedz/issues/7#issuecomment-1431488971, or unsubscribe https://github.com/notifications/unsubscribe-auth/ATBSP6UQATRCDOEA3KZWE5LWXTUIFANCNFSM4YO2YKCQ . You are receiving this because you authored the thread.Message ID: @.***>

infamanious commented 1 year ago

@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 commented 1 year ago

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 https://github.com/MichaelKheel/ProKreedz/issues/7#issuecomment-1432338744, or unsubscribe https://github.com/notifications/unsubscribe-auth/ATBSP6QNA6CFSIRCI3VZ6V3WXWAJNANCNFSM4YO2YKCQ . You are receiving this because you authored the thread.Message ID: @.***>

memoriess-art commented 1 year ago

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 https://github.com/MichaelKheel/ProKreedz/issues/7#issuecomment-1432338744, or unsubscribe https://github.com/notifications/unsubscribe-auth/ATBSP6QNA6CFSIRCI3VZ6V3WXWAJNANCNFSM4YO2YKCQ . You are receiving this because you authored the thread.Message ID: @.***>

memoriess-art commented 1 year ago

??? 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 https://github.com/MichaelKheel/ProKreedz/issues/7#issuecomment-1432338744, or unsubscribe https://github.com/notifications/unsubscribe-auth/ATBSP6QNA6CFSIRCI3VZ6V3WXWAJNANCNFSM4YO2YKCQ . You are receiving this because you authored the thread.Message ID: @.***>