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

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 [Only registered and activated users can see links. Click Here To Register...] to import old users info into srcms userprofile db
- Create a web admin account using this query:
- Go to [Only registered and activated users can see links. Click Here To Register...], 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: [Only registered and activated users can see links. Click Here To Register...]

#approved

Quote:

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

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

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

Quote:

Originally Posted by Chernobyl* Probably, there will be some updates for free version of website.

good work
check skype 'Mouse'

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:
[Only registered and activated users can see links. Click Here To Register...]

Quote:

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: [Only registered and activated users can see links. Click Here To Register...]

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

Updated first post.

Complete changelog of paid version:

v1.1A released. First post updated.

Quote:

Originally Posted by Chernobyl* v1.1A released. First post updated.

thanks!

Quote:

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:
The SQL-Query which is executed on that line is:
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.

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

Where can i download Evangelion gameserver addon? :)