- Joined
- Jan 28, 2009
- Messages
- 1,320
- Reaction score
- 616
Clan running on Apache (MS SQL edition) [Fully Working] + Auto SoD Score Script
This is partly tutorial because I will guide you guys how to do it.
Lets get started:
First thing you need to download is Apache (v2.2):
and 2nd is attachment I uploaded:
http://forum.ragezone.com/attachment.php?attachmentid=82780&stc=1&d=1290662916
- turn off your IIS server
- Install Apache (be sure its running), you might need to restart PC
- copy mod_aspdotnet.so (from attachment) to C:\Program Files\Apache Software Foundation\Apache2.2\modules
- to be sure install this:
http://forum.ragezone.com/attachment.php?attachmentid=83441&stc=1&d=1292415142
- copy ClanContent folder (from attachment) to C:\Program Files\Apache Software Foundation\Apache2.2\htdocs
- open httpd.conf in C:\Program Files\Apache Software Foundation\Apache2.2\conf
on 64bit OS ("Program Files" = "Program Files (x86)")
and add to the bottom:
- save and restart your Apache server.
- copy Clan folder (from attachment) to C:\
- open SODsettings.aspx and edit:
- open settings.aspx and edit:
- open clanInsert.aspx and edit:
Open game.exe with hexeditor and change your clan files links to:
example:
is now
- Use clanDB.sql (from attachment) to create new Clan Database in MS SQL (same way you created accountdb and other databases)
Start PT and create your 1st clan
PS. If you are using Gregoo clan system things should look the same in game.exe
When I find some more time I will port my SoD score script to MS SQL so you will not have to use CLAN TOOL (aspx page will do everything).
Good luck
---UPDATE---Auto---SoD---Score---Script
First off all this is compatible with nearly any SQL.dll (Including .dlls that popping out of
This should work on IIS (i did not test it yet
).
Lest do this:
- open your SQL.dll in HEXEDITOR
- find:
and change it to:
- find:
and change it to:
- find HEX:
and change it to:
- find HEX:
and change it to:
- save your changes and thats all for SQL.dll
- extract soddb.sql from soddb.rar (in attachments)
- open SQL Server Management Studio, login and delete your SoDDB database
- File > Open > File... and select soddb.sql, "! Execute" script
- extract files from Clan_SoD2_Script.rar (in attachments) to your main WWW folder
- edit SoD2.aspx
- run
if you see word "Bellatra" than everything is installed correctly
Go with friends into SoD kill some MOB and Talk to Secretary Karina, your Clan Score will be there... right away
Script will update score only if score is bigger than your current one.
Script is giving sum of scores for people from same clan so multiple people from different clans can go to SoD and still get Clan SoD score.
sod2clan"yyMM", "yyMM" = year and month 2010 12
sod2clan1012 and sod2record1012 contain all information you need to build SoD2 score page (you can get same info as in original PT SoD2 page, who, from what clan, when, how many points, at what time, what lvl, class etc)
sod2clan and sod2record are most important, rest tables are made for SoD page (Its not made yet, you can do it by yourself) and SoD1 scores (not added yet)
script looking for scores within -1 and +1 minute (this might look funny but this is just in case of lag/time update)
as for security issues... I don't see any =P
Right now script is small but you can add anything you want to it.
Players limit, lvl limit to score, how many money is landing in Clan pocket (this can be based on scores, numbers of kill etc.)
I think I made my point.
Good luck!
---UPDATE---SoD2.aspx---v2---MIN-Players-to-score---
Download
http://forum.ragezone.com/attachment.php?attachmentid=83440&stc=1&d=1292415115
and replace old one, edit settings.
Line 27 controlling if score is recorded or not (depending on how many players (from same CLAN) are needed to update score)
This is partly tutorial because I will guide you guys how to do it.
Lets get started:
First thing you need to download is Apache (v2.2):
To view the content, you need to sign in or register
and 2nd is attachment I uploaded:
http://forum.ragezone.com/attachment.php?attachmentid=82780&stc=1&d=1290662916
- turn off your IIS server
- Install Apache (be sure its running), you might need to restart PC
- copy mod_aspdotnet.so (from attachment) to C:\Program Files\Apache Software Foundation\Apache2.2\modules
- to be sure install this:
http://forum.ragezone.com/attachment.php?attachmentid=83441&stc=1&d=1292415142
- copy ClanContent folder (from attachment) to C:\Program Files\Apache Software Foundation\Apache2.2\htdocs
- open httpd.conf in C:\Program Files\Apache Software Foundation\Apache2.2\conf
on 64bit OS ("Program Files" = "Program Files (x86)")
and add to the bottom:
Code:
LoadModule aspdotnet_module modules/mod_aspdotnet.so
# Use the asp.net handler for all common ASP.NET file types
AddHandler asp.net asax ascx ashx asmx aspx axd config cs csproj \
licx rem resources resx soap vb vbproj vsdisco webinfo
<IfModule mod_aspdotnet.cpp>
# Mount the Clan C# example application
AspNetMount [COLOR="Red"]/Clan[/COLOR] "[COLOR="Red"]C:/Clan[/COLOR]"
# Map all requests for /Clan to the Clan application files
Alias [COLOR="Red"]/Clan[/COLOR] "[COLOR="Red"]C:/Clan[/COLOR]"
# Allow asp.net scripts to be executed in the Clan example
<Directory "[COLOR="Red"]C:/Clan[/COLOR]">
Options FollowSymlinks
AspNet Files
Order allow,deny
Allow from all
DirectoryIndex Default.htm Default.aspx
</Directory>
# For all virtual ASP.NET webs, we need the aspnet_client files
# to serve the client-side helper scripts.
AliasMatch /aspnet_client/system_web/(\d+)_(\d+)_(\d+)_(\d+)/(.*) \
"C:/Windows/Microsoft.NET/Framework/v$1.$2.$3/ASP.NETClientFiles/$4"
<Directory \
"C:/Windows/Microsoft.NET/Framework/v*/ASP.NETClientFiles">
Options FollowSymlinks
Order allow,deny
Allow from all
</Directory>
</IfModule>
- save and restart your Apache server.
- copy Clan folder (from attachment) to C:\
- open SODsettings.aspx and edit:
Code:
Dim dbhost = "[COLOR="Red"]localhost[/COLOR]" <- your SQL IP (localhost = 127.0.0.1)
Dim dbuser = "[COLOR="Red"]sa[/COLOR]" <- your SQL user id (sa = default)
Dim dbpass = "[COLOR="Red"]123456[/COLOR]" <- your SQL pass here
- open settings.aspx and edit:
Code:
Dim dbhost = "[COLOR="Red"]localhost[/COLOR]"
Dim dbuser = "[COLOR="Red"]sa[/COLOR]"
Dim dbpass = "[COLOR="Red"]123456[/COLOR]"
- open clanInsert.aspx and edit:
Code:
dbhost = "[COLOR="Red"]localhost[/COLOR]
dbuser = "[COLOR="Red"]sa[/COLOR]"
dbpass = "[COLOR="Red"]123456[/COLOR]"
Open game.exe with hexeditor and change your clan files links to:
Code:
http://%s/Clan/isCheckClanJang.aspx?userid=%s&gserver=%s&ticket=%d
http://%s/Clan/isCheckClanName.aspx?ClName=%s&gserver=%s&ticket=%d
http://%s/Clan/isCheckClanNum.aspx?num=%s&ticket=%d
http://%s/Clan/isCheckClanwon.aspx?gserver=%s&clwon=%s
http://%s/Clan/isClanMember.aspx?userid=%s&gserver=%s&chname=%s&ticket=%d
http://%s/Clan/clanInsertClanWon.aspx?userid=%s&gserver=%s&chname=%s&clName=%s&clwon=%s&clwonUserid=%s&lv=%d&ticket=%d&chtype=%d&chlv=%d&chipflag=%s
http://%s/Clan/clanInsert.aspx?userid=%s&gserver=%s&chname=%s&clName=%s&expl=%s&ticket=%d&chtype=%d&lv=%d
http://%s/Clan/GetAllMyClanMember.aspx?userid=%s&gserver=%s&chname=%s&ticket=%d
http://%s/Clan/clanRemove.aspx?userid=%s&gserver=%s&chname=%s&clName=%s&ticket=%d
http://%s/Clan/clanWonRelease.aspx?userid=%s&gserver=%s&chname=%s&clName=%s&%s&ticket=%d
http://%s/Clan/ClanSubChipUpdate.aspx?chname=%s&gserver=%s&ticket=%d
http://%s/Clan/ClanSubChipRelease.aspx?chname=%s&gserver=%s&ticket=%d
http://%s/Clan/clanChipChange.aspx?chname=%s&gserver=%s&clName=%s&ticket=%d
http://%s/Clan/clanWonSelfLeave.aspx?userid=%s&gserver=%s&chname=%s&clName=%s&ticket=%d
http://%s/Clan/isKflag.aspx?userid=%s&clName=%s&chName=%s&gserver=%s&KFlag=%s&Gubun=%s&ticket=%d
http://%s/Clan/isPFlag.aspx?userid=%s&clName=%s&chName=%s&gserver=%s&PFlag=%s&Gubun=%s&ticket=%d
http://%s/tjboyh/clan_WarehouseRight.php?clName=%s&whRight=%s&ticket=%d
http://%s/tjboyh/updateFlag.php?clName=%s&ticket=%d
http://%s/ClanContent/%s.bmp
http://%s/Clan/sod2info.aspx?userid=%s&chname=%s&gserver=%s&index=%d
example:
Code:
http://%s/[COLOR="DarkOrange"]ServerMain[/COLOR]/isCheckClanJang.[COLOR="DarkOrange"]asp[/COLOR]?userid=%s&gserver=%s&ticket=%d
Code:
http://%s/[COLOR="Red"]Clan[/COLOR]/isCheckClanJang.[COLOR="Red"]aspx[/COLOR]?userid=%s&gserver=%s&ticket=%d
- Use clanDB.sql (from attachment) to create new Clan Database in MS SQL (same way you created accountdb and other databases)
Start PT and create your 1st clan
PS. If you are using Gregoo clan system things should look the same in game.exe
When I find some more time I will port my SoD score script to MS SQL so you will not have to use CLAN TOOL (aspx page will do everything).
Good luck
---UPDATE---Auto---SoD---Score---Script
First off all this is compatible with nearly any SQL.dll (Including .dlls that popping out of
To view the content, you need to sign in or register
), ass long you where able too connect to PT using your current SQL.dll you will be able to get score without external app "SOD TOOL".This should work on IIS (i did not test it yet
Lest do this:
- open your SQL.dll in HEXEDITOR
- find:
Code:
BSODRecord%s%02d
Code:
BSOD[COLOR="Red"]2[/COLOR]Record%s%02d
Code:
http://www.pristontale.jp/Sod/Sod.asp?sno=%s
Code:
http://[COLOR="Red"]127.0.0.1/Clan/SoD2.aspx?SNo=%s[/COLOR]
Code:
00 00 E9 C7 26 01
Code:
00 00 E9 [COLOR="Red"]07 07[/COLOR] 01
Code:
00 00 E9 B5 03 01
Code:
00 00 E9 [COLOR="Red"]75 23[/COLOR] 01
- save your changes and thats all for SQL.dll
- extract soddb.sql from soddb.rar (in attachments)
- open SQL Server Management Studio, login and delete your SoDDB database
- File > Open > File... and select soddb.sql, "! Execute" script
- extract files from Clan_SoD2_Script.rar (in attachments) to your main WWW folder
- edit SoD2.aspx
Code:
Dim dbhost = "[COLOR="Red"]localhost[/COLOR]" <- your SQL IP (localhost = 127.0.0.1)
Dim dbname = "[COLOR="Red"]ClanDB[/COLOR]" <- your Clan database (ClanDB = default)
Dim dbuser = "[COLOR="Red"]sa[/COLOR]" <- your SQL user id (sa = default)
Dim dbpass = "[COLOR="Red"]123456[/COLOR]" <- your SQL pass here
- run
To view the content, you need to sign in or register
if you see word "Bellatra" than everything is installed correctly
Go with friends into SoD kill some MOB and Talk to Secretary Karina, your Clan Score will be there... right away
Script will update score only if score is bigger than your current one.
Script is giving sum of scores for people from same clan so multiple people from different clans can go to SoD and still get Clan SoD score.
sod2clan"yyMM", "yyMM" = year and month 2010 12
sod2clan1012 and sod2record1012 contain all information you need to build SoD2 score page (you can get same info as in original PT SoD2 page, who, from what clan, when, how many points, at what time, what lvl, class etc)
sod2clan and sod2record are most important, rest tables are made for SoD page (Its not made yet, you can do it by yourself) and SoD1 scores (not added yet)
script looking for scores within -1 and +1 minute (this might look funny but this is just in case of lag/time update)
as for security issues... I don't see any =P
Right now script is small but you can add anything you want to it.
Players limit, lvl limit to score, how many money is landing in Clan pocket (this can be based on scores, numbers of kill etc.)
I think I made my point.
Good luck!
---UPDATE---SoD2.aspx---v2---MIN-Players-to-score---
Download
http://forum.ragezone.com/attachment.php?attachmentid=83440&stc=1&d=1292415115
and replace old one, edit settings.
Line 27 controlling if score is recorded or not (depending on how many players (from same CLAN) are needed to update score)
Code:
If SQL_Record.RecordCount >= "[COLOR="Red"]2[/COLOR]" Then
Attachments
Last edited by a moderator:

