[Release] SRCMS - Free version (website for your server)

[Chernobyl*]

Since selling this wasn't profitable...

Installation:

- Copy all files to your htdocs/wwwroot
- Run sql/install.sql at your sql server management studio (you might have to change account db name at that file)
- Remove comment lines from import_old_users.php [/* and */], and modify your sql server connection information, also, change avatar link !
- Go to to import old users info into srcms userprofile db
- Create a web admin account using this query:

	use SRO_VT_ACCOUNT
	update srcms_userprofiles set whois='admin' where JID=(select JID from TB_User where StrUserID='your username')

- Go to , log in, enter admin panel, and edit settings.


-------------------------------------------------------------


v0.0 - 0.4c
Changelog:
- News + comments
- Downloads
- Registration
- Login/logout
- Team page
- Server status
- Fortress status
- Honor rank
- Users on web
- Change password
- My characters
- My profile [gender, avatar, skype, msn, publicity]
- Mailbox [users can communicate directly at web through private messages]
- User types (for now admin/user/gm)
- Smileys in news/comments/private messages at website
- Referals (user can get silk for inviting friends, has ip check)
- Settings [admin cp] - contains nearly all settings for website (for example:
enabling/disablind character functions, setting max/min comment length at news etc)
- Probably, some more i forgot to mention

v 0.5a

Changelog:
- Admin CP itself
- Epin system [user cp/admin cp]
- Add/edit/delete news [admin cp]
- Add/edit/delete download links [admin cp]
- Edit CMS settings [admin cp]
- Fixed honor rank
- Some more BBcodes for news/comments
- Once users enters website, if he's account has no SK_Silk record yet, it's being automatically added
- Added char model pic to view char
v 0.5b
Changelog
- User panel
- My chars feature at user panel now actually has use
- Teleport char to town [gold]
- Reset char pk [silk]
- Reset char stats [silk]
- Settings at srcms_settings, you can edit them from admin panel as usually

v 0.6a
Changelog
- User panel
- Buy skill points [define silk price for each 100 000 SP in settings from ACP]
- Fixed bug in admin panel (using smileys in news text while edited/added)
- Little security fix at news module

================================================== =================
v 1.0A
- Pretty huge website engine mod
- Added guild rankings (also, guild info and members list)
- Added race icon to top characters and guild rankings
- Added "allowShowCharOwner" setting
- Added last unique kills (overall)
- Added last 30 unique kills for each character individually
- Added character search function
- Added guild search
- Added job ranking
- Multiple bugfixes [tons of them, wont describe every]
================================================== =================
v 1.1A
- Fixed problem with "This character does not belong to you" - was pretty serious bug
- Fixed problem with uppercase/lowercase username at logging in
- Fixed XSS vulnerability at messages (news/msgbox etc)
- Fixed using HTML tags in messages
- Fixed sending messages at website [class/user.class.php]

Link:

[PortalDark]

#approved

[cjmwid]

<?php
class mssql
{
private $aDatabases = array();
private $sqlHandle;

function __construct($szHostname, $szUsername, $szPassword,$aDatabases)
{

$this -> aDatabases = $aDatabases;
$this -> connect($szHostname, $szUsername, $szPassword);
}

private function connect($szHostname, $szUsername, $szPassword)
{
$this -> sqlHandle = mssql_pconnect($szHostname, $szUsername, $szPassword);
if($this -> sqlHandle)
{
$this -> changeDB('acc'); //default db
}
else die("Could not open database connection");
}

public function changeDB($szDB)
{
switch($szDB)
{
case('acc'):
mssql_select_db($this -> aDatabases[0], $this -> sqlHandle);
break;

case('shard'):
mssql_select_db($this -> aDatabases[1], $this -> sqlHandle);
break;

case('log'):
mssql_select_db($this -> aDatabases[2], $this -> sqlHandle);
break;

default:
die("Invalid value for mssql -> changeDB [$szDB]");
break;
}
}

public function exec($szQuery)
{
return mssql_query($szQuery);
}

public function getRow($szQuery)
{
$hQuery = $this -> exec($szQuery);
$result = mssql_fetch_row($hQuery);
return $result[0];
}

public function fetchRow($szQuery)
{
$hQuery = $this -> exec($szQuery);
$result = mssql_fetch_row($hQuery);
return $result;
}

public function fetchArray($szQuery)
{
$hQuery = $this -> exec($szQuery);
$result = mssql_fetch_array($hQuery);
return $result;
}

public function numRows($szQuery)
{
$hQuery = $this -> exec($szQuery);
$result = mssql_num_rows($hQuery);
return $result;
}
}
?>

On line 16 witch is
$this -> connect($szHostname, $szUsername, $szPassword);

i get a fatal error ;( can anyone help me out? this is in the mssql.class.php

[Chernobyl*]

cjmwid, try using xampp 1.7.1 + ntwdblib i gave in some another topic (use search).

[Chernobyl*]

Probably, there will be some updates for free version of website.

[killercom]

Originally Posted by Chernobyl*

Probably, there will be some updates for free version of website.

good work
check skype 'Mouse'

[~Untouchable~]

Hellou,
I got 2 errors,it seems im not able to see my page due to these errors.
Errors shows up when i enter:
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\AppServ\www\index.php:1) in C:\AppServ\www\index.php on line 2

Fatal error: Call to undefined function mssql_pconnect() in C:\AppServ\www\class\mssql.class.php on line 16

Edit:Now i can see page but the first error is still exist

this also shows pretty weird for me lol dunno whats the problem..
Screen:

[Chernobyl*]

Originally Posted by ~Untouchable~

Hellou,
I got 2 errors,it seems im not able to see my page due to these errors.
Errors shows up when i enter:
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\AppServ\www\index.php:1) in C:\AppServ\www\index.php on line 2

Fatal error: Call to undefined function mssql_pconnect() in C:\AppServ\www\class\mssql.class.php on line 16

Edit:Now i can see page but the first error is still exist

this also shows pretty weird for me lol dunno whats the problem..
Screen:

Set php.ini "output_buffering" value to "On".

[Chernobyl*]

Updated first post.

[Chernobyl*]

Complete changelog of paid version:

v0.0 - 0.4c
Changelog:
	- News + comments
	- Downloads
	- Registration
	- Login/logout
	- Team page
	- Server status
	- Fortress status
	- Honor rank
	- Users on web
	- Change password
	- My characters
	- My profile [gender, avatar, skype, msn, publicity]
	- Mailbox [users can communicate directly at web through private messages]
	- User types (for now admin/user/gm)
	- Smileys in news/comments/private messages at website
	- Referals (user can get silk for inviting friends, has ip check)
	- Settings [admin cp] - contains nearly all settings for website (for example:
	  enabling/disablind character functions, setting max/min comment length at news etc)

v 0.5a

Changelog:
	- Admin CP itself
	- Epin system [user cp/admin cp]
	- Add/edit/delete news [admin cp]
	- Add/edit/delete download links [admin cp]
	- Edit CMS settings [admin cp]
	- Fixed honor rank
	- Some more BBcodes for news/comments
	- Once users enters website, if he's account has no SK_Silk record yet, it's being automatically added
	- Added char model pic to view char
v 0.5b
Changelog
	- User panel
		- My chars feature at user panel now actually has use
		- Teleport char to town [gold]
		- Reset char pk [silk]
		- Reset char stats [silk]
		- Settings at srcms_settings, you can edit them from admin panel as usually

v 0.6a
Changelog
	- User panel
	- Buy skill points [define silk price for each 100 000 SP in settings from ACP]
	- Fixed bug in admin panel (using smileys in news text while edited/added)
	- Little security fix at news module

========================================================================================
v 1.0A
	- Pretty huge website engine mod
	- Added guild rankings (also, guild info and members list)
	- Added race icon to top characters and guild rankings
	- Added "allowShowCharOwner" setting
	- Added last unique kills (overall)
	- Added last 30 unique kills for each character individually
	- Added character search function
	- Added guild search
	- Added job ranking
	- Multiple bugfixes [tons of them, wont describe every]
========================================================================================
v 1.1A
	- Fixed problem with "This character does not belong to you" - was pretty serious bug
	- Fixed problem with uppercase/lowercase username at logging in
	- Fixed XSS vulnerability at messages (news/msgbox etc)
	- Fixed using HTML tags in messages
	- Fixed sending messages at website [class/user.class.php]

[Chernobyl*]

v1.1A released. First post updated.

[nansif2]

Originally Posted by Chernobyl*

v1.1A released. First post updated.

thanks!

[Do0mSwEb]

Originally Posted by Chernobyl*

Set php.ini "output_buffering" value to "On".

I have solved this issue by deleting the first php lines and insert them line for line new. I think there are no visible characters in the first lines of the index.php which causes this error.

But I have another issue, which I can not solve. When I click on "Last Unqiue Kills" in the Rank menu, I get the following error:

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'Evangelion_uniques'. (severity 16) in mssql.class.php on line 47
 
Warning: mssql_query() [function.mssql-query]: Query failed in mssql.class.php on line 47
 
Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in modulerank.php on line 449

The SQL-Query which is executed on that line is:

select top 100 * from Evangelion_uniques order by time desc

I have looked in the database, there exists no table "Evangelion_uniques". How can I get or create this table?

Thanks for your support in advance and thanks for the great and free script.

[Chernobyl*]

Last unique kills are meant to work together with Evangelion gameserver addon.

[Speederes]

Where can i download Evangelion gameserver addon?