[FilterScript] MySQL Clan System
#1

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!
Reply
#2

wow,good job!
Reply
#3

Nice use of your dialogs include
Reply
#4

Smart move, CODE5 actually 'dying slowly'


Good job alt.
Reply
#5

Good job
Reply
#6

Quote:
Originally Posted by RogueDrifter
View Post
Good job


PS: Thanks everyone!
Reply
#7

Great job Gammix, keep on!
Reply
#8

Quote:
Originally Posted by Gammix
View Post


PS: Thanks everyone!
wt*

ps: gg
Reply
#9

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

I like it
Reply
#11

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"
Reply
#12

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

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.
Reply
#14

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
Reply
#15

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).
Reply
#16

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
Reply
#17

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!
Reply
#18

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

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?
Reply
#20

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


Forum Jump:


Users browsing this thread: 2 Guest(s)