[Release] SRCMS 0.6a - FREE (website for your sro server)

[Viral31337]

#request for closing/deleting

[Disco Teka]

#approved

[ᶽPhoenix1337ᶽ]

Live?

[Haze*]

There is a live demo added - just read properly.

[PortalDark]

to point it out
this guy is Cherno btw

[Viral31337]

If your "On web" module is showing errors, just edit your /inc/onweb.php with propper /tmp sessions folder path.

To fix comments not appearing until you select page, open module/news.php and replace THIS:

<a href='?pg=news&comment=$row[id]>Comments ($nComments)

with this:

<a href='?pg=news&comment=$row[id]&page=1'>Comments ($nComments)

[Viral31337]

Important fix !

module/admin.php

Replace this:

global $core;
global $mssql;

switch($_GET['act'])

With this:

global $core;
global $mssql;
$userRank = $mssql->getRow("select whois from srcms_userprofiles where JID='".user::accountJIDbyUsername($_SESSION[username])."'");
if($userRank != "admin")
{
	echo "NOT ADMIN";
	return;
}

switch($_GET['act'])

[eminem5]

Originally Posted by Viral31337

So, i decided to release free/paid versions of website engine i've been working recently.

This is the only version that will be free to use, and public. Here is changelog since 0.5a version:


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

update from 0.4d to 0.5a:
1. Replace files
2.
sql
{
use SRO_VT_ACCOUNT;
INSERT [dbo].[srcms_settings] ([id], [value], [valueName]) VALUES (33, N'1', N'allowEpinSystem')
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[srcms_epin](
[id] [int] IDENTITY(1,1) NOT NULL,
[code] [bigint] NULL,
[silkAmount] [int] NULL,
CONSTRAINT [PK_srcms_epin] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
}

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

update from 0.5a to 0.5b:
1. Replace files
2.
sql
{
use SRO_VT_ACCOUNT;
INSERT [dbo].[srcms_settings] ([id], [value], [valueName]) VALUES (34, N'1', N'allowCharTeleport')
INSERT [dbo].[srcms_settings] ([id], [value], [valueName]) VALUES (35, N'1', N'charTeleportGoldPrice')
INSERT [dbo].[srcms_settings] ([id], [value], [valueName]) VALUES (36, N'1', N'allowResetCharStats')
INSERT [dbo].[srcms_settings] ([id], [value], [valueName]) VALUES (37, N'1', N'resetCharStatsSilkPrice')
INSERT [dbo].[srcms_settings] ([id], [value], [valueName]) VALUES (38, N'1', N'allowResetCharPK')
INSERT [dbo].[srcms_settings] ([id], [value], [valueName]) VALUES (39, N'1', N'resetCharPKSilkPrice')
}

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

sql
{
use SRO_VT_ACCOUNT;
INSERT [dbo].[srcms_settings] ([value], [valueName]) VALUES (N'1', N'allowBuySP')
INSERT [dbo].[srcms_settings] ([value], [valueName]) VALUES (N'1', N'pricePer100kSp')
}
I wont list all features... There's a live version you can take a look at: [THIS IS NOT ADVERTISING !!!!11]


And yeah, my old nickname on this forum is Chernobyl*. I don't have access to that account at the moment, so, i'm posting this under my newly created one.

If you are interested in buying versions that comes next, you can contact me through skype:
chernobyl1337.

Link :

Installation: First of all, copy all the files into your website directory. Then, execute sql/install.sql in your sql server management studio. After that, uncomment import_old_users.php (remove /* and */ from beginning and end). Then, edit the hostname (replace domain name with your server website address, KEEP the last part of it( /img/noavatar.png) untouched. Then, enter that page ONCE (wait until it finishes it's execution, it can take some time).
After all that stuff is done, you can create your account.

Do it this way:

use SRO_VT_ACCOUNT;
declare @nJID int
set @nJID = (select JID from TB_User where StrUserID='your username')
update srcms_userprofiles set whois='admin' where JID=@nJID

Now you can enter your newly installed website, and go to admin panel to add/edit news, downloads, etc.

================================================== ==========

Important fix !

module/admin.php

Replace this:

global $core;
global $mssql;

switch($_GET['act'])

With this:

global $core;
global $mssql;
$userRank = $mssql->getRow("select whois from srcms_userprofiles where JID='".user::accountJIDbyUsername($_SESSION[username])."'");
if($userRank != "admin")
{
	echo "NOT ADMIN";
	return;
}

switch($_GET['act'])

nice job chernobyl btw i will qiwe you cigs tonight

[amama]

.