RZA-PT | KilroyPT
- Joined
- Aug 27, 2007
- Messages
- 936
- Reaction score
- 85
Hi All
Updoot:
Is now on gitlab repo:
https://gitlab.com/Phatkone/RageZone
If you feel you can improve it and wish to be a member, let me know and i'll add you as a repo member.
I'll add more scripts and tools in as I go. I have re-written Sanduurs Clan files into PHP
as well as Vormavs auto sod clan score script. (sod2.php)
Thought i'd share with the wider community.
Implementation:
Requirements:
Configure SQL connection information in
as follows:
Open client side executable, replace all the file links (search .asp) with .php extension.
Alternatively, rename the files to .asp and edit the handler mapping to use the php executable.
sod2 link is in sql.dll (or clan.dll, I forget), just follow Vormavs guide.
[STRIKE]If your Clandb CL table auto increments IDX you'll need to remove it from the query string in claninsert.php (instructions on which string are in the top of the file).
This is in there as if your table does not auto increment it will get Error(11) when creating clans without it. [/STRIKE]
All scripts are working, I have tested them thoroughly.
Bug: Clan Kick procedure, the character name in the get data doesnt translate correctly (found this with the ASP files too), I added a work around so for 99% of cases it works just fine, however, if the characters name contains Square brackets, it will not work and you'll need to manually kick the player.
When I work it out I'll release an update. (maybe its just my server/client combo)
Credits to Vormav and Sandurr for their files which I used as templates.
and to me for writing these ones (tagged as EuphoriA)
I hope people get some use from these
V2 Update:
I have added a query string to test if the IDX in clandb.dbo.cl and clandb.dbo.ul is autoincrementing.
This will adjust the query to suit.
V4 Update, fixed claninsert.php and re-added the check for auto increment on IDX and MIDX lines.
Version 5 (April 18) Update:
- Fixed clan kick procedure, can no do multi kick in one go.
- Fixed clan kick to handle names with square brackets ([])
- claninsert now creates the clan image when creating the clan based off the default template.
V6 Update:
- Converted to PDO - now requires PHP SQLSRV PDO module
- All settings in settings.ini, sets all parameters and cleans to prevent sql injection.
- cleaned up code a bit and sql strings.
note. isPFlag and isKFlag just return a code=1 because anything other than that won't let you talk to the clan master (errors)
Updoot:
Is now on gitlab repo:
https://gitlab.com/Phatkone/RageZone
If you feel you can improve it and wish to be a member, let me know and i'll add you as a repo member.
I'll add more scripts and tools in as I go. I have re-written Sanduurs Clan files into PHP
as well as Vormavs auto sod clan score script. (sod2.php)
Thought i'd share with the wider community.
Implementation:
Requirements:
PHP V5.3 or Higher
SQLSRV extension for PHP
Configure SQL connection information in
Code:
Clan/settings.php and ServerMain/Settings.php
Code:
$server = "PTSERVER/SQLEXPRESS"; //Enter SQL Instance or IP with port (i.e. 192.168.0.1,1433)
$UID = 'USERID'; // Enter User ID For SQL Login
$PWD = 'PASSWORD'; // Enter SQL Password
Open client side executable, replace all the file links (search .asp) with .php extension.
Alternatively, rename the files to .asp and edit the handler mapping to use the php executable.
sod2 link is in sql.dll (or clan.dll, I forget), just follow Vormavs guide.
[STRIKE]If your Clandb CL table auto increments IDX you'll need to remove it from the query string in claninsert.php (instructions on which string are in the top of the file).
This is in there as if your table does not auto increment it will get Error(11) when creating clans without it. [/STRIKE]
All scripts are working, I have tested them thoroughly.
Bug: Clan Kick procedure, the character name in the get data doesnt translate correctly (found this with the ASP files too), I added a work around so for 99% of cases it works just fine, however, if the characters name contains Square brackets, it will not work and you'll need to manually kick the player.
When I work it out I'll release an update. (maybe its just my server/client combo)
Credits to Vormav and Sandurr for their files which I used as templates.
and to me for writing these ones (tagged as EuphoriA)
I hope people get some use from these
V2 Update:
I have added a query string to test if the IDX in clandb.dbo.cl and clandb.dbo.ul is autoincrementing.
This will adjust the query to suit.
V4 Update, fixed claninsert.php and re-added the check for auto increment on IDX and MIDX lines.
Version 5 (April 18) Update:
- Fixed clan kick procedure, can no do multi kick in one go.
- Fixed clan kick to handle names with square brackets ([])
- claninsert now creates the clan image when creating the clan based off the default template.
V6 Update:
- Converted to PDO - now requires PHP SQLSRV PDO module
- All settings in settings.ini, sets all parameters and cleans to prevent sql injection.
- cleaned up code a bit and sql strings.
note. isPFlag and isKFlag just return a code=1 because anything other than that won't let you talk to the clan master (errors)
Attachments
Last edited: