[Gammix]

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!

[Ilias_]

wow,good job!

[iLearner]

Nice use of your dialogs include

[Hunud]

Smart move, CODE5 actually 'dying slowly'


Good job alt.

[RogueDrifter]

Good job

[Gammix]

Quote:

Originally Posted by RogueDrifter Good job

PS: Thanks everyone!

[Ultraz]

Great job Gammix, keep on!

[RxErT]

Quote:

Originally Posted by Gammix PS: Thanks everyone!

wt*

ps: gg

[iSteve]

Good system mate, I'm happy that CODE5 didn't claim even this to be their own invention lol

[Rassh]

I like it

[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"

[Chaprnks]

With some major re-working, this would make an excellent faction system module for roleplay servers

[Gammix]

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.

[Venom546]

Quote:

Originally Posted by Gammix 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!

btw can you please help me? i need to know from where should i got .sql file? to run it using mysql database :P

[Gammix]

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).

[Venom546]

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

[v1k1nG]

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!

[KinderClans]

Great share. I'm sure with some tweaks this can be turned in a perfect faction system.

[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?

[Gammix]

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.