MySQL Clan System -
Gammix - 24.07.2018
MySQL Clan System
I made this a while ago for CODE5 Resurrection, but nobody ever took responsibility for the script and simply wasted my time. This script was lying in my SAMP folder, so i thought might as well post it online.
Its very stable but unfinished, what's not finished is the clan war system, if someone wants to continue this and public it if they want to, just send me a Private Message or post your code here and i'll put it in this thread with credits.
If i get time, i might think of adding ClanWar to this system, but that's very unlikely!
Screenshots:
https://imgur.com/a/EhnjT9U
Download:
https://github.com/Agneese-Saini/SA-...ripts/clan.pwn
Dependencies:
MySQL Plugin:
https://sampforum.blast.hk/showthread.php?tid=56564
Sscanf Plugin:
https://sampforum.blast.hk/showthread.php?tid=602923
Streamer Plugin:
https://sampforum.blast.hk/showthread.php?tid=102865
Dialogs Include:
https://sampforum.blast.hk/showthread.php?tid=570213
easyDialog Include:
https://github.com/Agneese-Saini/SA-...easyDialog.inc
ZCMD Include:
https://sampforum.blast.hk/showthread.php?tid=576114
Foreach/y_iterate Include:
https://sampforum.blast.hk/showthread.php?tid=570868
* If you wanna use this and have any question, feel free to ask here, don't PM me please!
Re: MySQL Clan System -
Ilias_ - 24.07.2018
wow,good job!
Re: MySQL Clan System -
iLearner - 24.07.2018
Nice use of your dialogs include
Re: MySQL Clan System -
Hunud - 24.07.2018
Smart move, CODE5 actually 'dying slowly'
Good job alt.
Re: MySQL Clan System -
RogueDrifter - 24.07.2018
Good job
Re: MySQL Clan System -
Gammix - 24.07.2018
Quote:
Originally Posted by RogueDrifter
Good job
|
PS: Thanks everyone!
Re: MySQL Clan System -
Ultraz - 24.07.2018
Great job Gammix, keep on!
Re: MySQL Clan System -
RxErT - 25.07.2018
Quote:
Originally Posted by Gammix
PS: Thanks everyone!
|
wt*
ps: gg
Re: MySQL Clan System -
iSteve - 29.07.2018
Good system mate, I'm happy that CODE5 didn't claim even this to be their own invention lol
Re: MySQL Clan System -
Rassh - 30.07.2018
I like it
Re: MySQL Clan System -
TroS - 11.08.2018
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(407) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(40
: error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1175) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1481) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1519) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1579) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1924) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1953) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1954) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1996) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2162) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2164) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2204) : error 004: function "SetDialogPreviewRotation" is not implemented
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2225) : error 004: function "SetDialogPreviewRotation" is not implemented
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2254) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(231
: error 017: undefined symbol "DIALOG_STYLE_TABLIST"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2540) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2541) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2707) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2714) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2715) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(3131) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(3132) : error 017: undefined symbol "INVALID_STREAMER_ID"
Re: MySQL Clan System -
Chaprnks - 12.08.2018
With some major re-working, this would make an
excellent faction system module for roleplay servers
Re: MySQL Clan System -
Gammix - 14.08.2018
Quote:
Originally Posted by TroS
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(407) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(40 : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1175) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1481) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1519) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1579) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1924) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1953) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1954) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(1996) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2162) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2164) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2204) : error 004: function "SetDialogPreviewRotation" is not implemented
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2225) : error 004: function "SetDialogPreviewRotation" is not implemented
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2254) : error 017: undefined symbol "DIALOG_STYLE_TABLIST_HEADERS"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(231 : error 017: undefined symbol "DIALOG_STYLE_TABLIST"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2540) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2541) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2707) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2714) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(2715) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(3131) : error 017: undefined symbol "INVALID_STREAMER_ID"
C:\Users\pc hp\Desktop\Server\filterscripts\clan.pwn(3132) : error 017: undefined symbol "INVALID_STREAMER_ID"
|
Update your SAMP version and Streamer version.
Re: MySQL Clan System -
Venom546 - 21.09.2018
Quote:
Originally Posted by Gammix
|
btw can you please help me? i need to know from where should i got .sql file? to run it using mysql database :P
Re: MySQL Clan System -
Gammix - 22.09.2018
Quote:
Originally Posted by Venom546
btw can you please help me? i need to know from where should i got .sql file? to run it using mysql database :P
|
You don't need any SQL file, the script creates the table for you when it's launched. Just make sure your MySQL server is up and you have correct MySQL settings in script (found on top of code).
Re: MySQL Clan System -
Venom546 - 24.09.2018
Quote:
Originally Posted by Gammix
You don't need any SQL file, the script creates the table for you when it's launched. Just make sure your MySQL server is up and you have correct MySQL settings in script (found on top of code).
|
oh nice thank you <3
Re: MySQL Clan System -
v1k1nG - 24.09.2018
Better sharing than keeping that for those guys at C5. They managed to make huge amount of players flee their servers.
Great job! I will be using this!
Re: MySQL Clan System -
KinderClans - 14.10.2018
Great share. I'm sure with some tweaks this can be turned in a perfect faction system.
Re: MySQL Clan System -
KinderClans - 16.10.2018
Hello Gammix, i started to use your clan system but i'm facing 2 errors while compiling:
error 017: undefined symbol "SetDialogPreviewRotation"
error 017: undefined symbol "SetDialogPreviewRotation"
I have the PreviewModelDialog.inc file, what's wrong?
Re: MySQL Clan System -
Gammix - 16.10.2018
Quote:
Originally Posted by KinderClans
Hello Gammix, i started to use your clan system but i'm facing 2 errors while compiling:
error 017: undefined symbol "SetDialogPreviewRotation"
error 017: undefined symbol "SetDialogPreviewRotation"
I have the PreviewModelDialog.inc file, what's wrong?
|
You might have the latest version i.e. v4.7.*, in 4.7 those functions are removed and are integrated within ShowPlayerDialog. There is a detail about how to use it in include's thread.
If you want to modify it to the new version, i would update the thread with your pull request if you are willing to do that.
Otherwise, you can downgrade to v4.6 which has same functionality to the new version and is stable as well.