GS Administration Panel

[treica]

This is a GS Panel (created for a server) you may change the defaults name etc... with your own server names.
Inside the pack are the files you should run to your database (if you have already GM-Stuff db then is not needed to run the scripts)
Warning : Be aware what you do before run the scripts i won't take any responsability if you damage your server.
This is basically used the XxXDASHXxX scripts and modified, secured and is choose some simple scripts which a GS can do, so credits goes to him.

Features :
GS RULES - READ (you may change it with your own content "rules.php")
RESTORE DEAD UM (resurects a character)
FACTION CHANGE (changes faction if player has 10.000 AP price can be changed on fc.php)
JAIL CHARACTER (it Jails a character)
UN'JAIL CHARACTER (unjails a character)
ITEM CATEGORY (it colects all the server items names which is very usefull)
ONLINE PLAYERS (it show player name, place, kills - can be traced for statpadding in real time)

Of course there will add later in another version more scripts and if need any feel free to ask and will work trought this.
Warning : Change the default folder name for your security.

Security : Login with Cookie "UserID" (it can be changed, if u are unsure what's about do not change it !)

To make this script let pass in only GS ADM you must add a new Column in PS_UserData.dbo.Users_Master named GS (tinyint) then use this sql query to make it default 0

Update PS_UserData.dbo.Users_Master
Set GS = '0'

Then to let your GS pass in run this query with every each account

update PS_UserData.dbo.Users_Master
set GS = '1'
where UserID = 'here GS userID'

To let pass in a GM too use the same query for your GM acc too else you cannot log in exept who has GS = 1 into the column.
If you want to run it as test change in Login.php this :

$res=odbc_exec($conn,"SELECT UserID FROM PS_UserData.dbo.Users_Master WHERE UserID='{$UserID}' AND Pw='{$Pw}' and GS = '1' ");

To this

$res=odbc_exec($conn,"SELECT UserID FROM PS_UserData.dbo.Users_Master WHERE UserID='{$UserID}' AND Pw='{$Pw}' ");

.

Place your server Username and Password into info.php and db_connect.php.
Hope it helps...later i will add a Game Master panel with more features, if any new scripts you want me to make feel free to post here and let me know.



Preview :
Regards,
treica

[infinite59]

Nice release, can help some guys. But i suggest to remove faction change.
As a GS is not a personnally invested guy (he is a simple player),i don't think this is a good point to let them make some faction changes.

[treica]

Well the faction changes does actually placed with Points he can do this since cannot cheat on stuff and make crazy things by it's own.

[FuckCoke]

Hehehe, stealing the work from DASH, modifying it, changing it a bit and releasing as something you did?
Thats not really nice.

[[GM]SkyLine.™]

Nice release dani

[STIV123]

Originally Posted by FuckCoke

Hehehe, stealing the work from DASH, modifying it, changing it a bit and releasing as something you did?
Thats not really nice.

You must be either stupid or blind. Treica gave Credits to DASH and said he only modified the scripts. So your trolling failed.

Anyways, awesome release!

[nubness]

Originally Posted by FuckCoke

Hehehe, stealing the work from DASH, modifying it, changing it a bit and releasing as something you did?
Thats not really nice.

Hehehe, not reading the #1 post, flaming and making false accusations ?
That's not really nice


I never really liked the web based admin panel myself, but it's a good release indeed, I'm sure there's lots of people who use it.

[[Admin]ßІί†ž]

Gratz treica , nice changes and release .

[tranthanh132]

I have error when execute query logout
Msg 207, Level 16, State 1, Procedure usp_Try_GameLogout_R, Line 0
Invalid column name 'LogoutTime'.
Msg 207, Level 16, State 1, Procedure usp_Try_GameLogout_R, Line 0
Invalid column name 'LogoutErrType'.
and the GM Stuff Database
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 240
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 243
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 246
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 249
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 252
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 255
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 258
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 261
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 264
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 267
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 270
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AdminAccountDeleatAndSwipe, Line 273
Invalid column name 'Class'.

Msg 207, Level 16, State 1, Procedure usp_WhosOn, Line 6
Invalid column name 'LoginStatus'.
Msg 207, Level 16, State 1, Procedure usp_WhosOn, Line 4
Invalid column name 'LoginStatus'.
Msg 207, Level 16, State 1, Procedure usp_WhosOn, Line 4
Invalid column name 'Class'.

Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 236
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 239
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 242
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 245
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 248
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 251
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 254
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 257
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 260
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 263
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 266
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure IndividyalAccountSwipe, Line 269
Invalid column name 'Class'.
Msg 2714, Level 16, State 3, Procedure uspAddAdminAccount, Line 8
There is already an object named 'uspAddAdminAccount' in the database.
Msg 2714, Level 16, State 3, Procedure usp_GiftBox, Line 90
There is already an object named 'usp_GiftBox' in the database.
Msg 207, Level 16, State 1, Procedure update_detales, Line 0
Invalid column name 'JoinDate'.

Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 236
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 239
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 242
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 245
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 248
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 251
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 254
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 257
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 260
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 263
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 266
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AccountSwipe, Line 269
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure AddPoints, Line 37
Invalid column name 'Date'.


I see the database GM Stuff after Run query but it has error
It not perfect

[treica]

is giving you errors because you already had the database named gm_stuff into your database if you look better on the errors most of them sais that already exist.
some of them sais some column miss since dash didn't released the full database and some columns been deleted.

Regards,

[Hep]

Nice release , I hope many people will use this so.

[tranthanh132]

Originally Posted by treica

is giving you errors because you already had the database named gm_stuff into your database if you look better on the errors most of them sais that already exist.
some of them sais some column miss since dash didn't released the full database and some columns been deleted.

Regards,

When i run this query
It has error
And then i reconnect to SQL sever
And the database GM Stuff have been created
But it created with error
It hasn't been created perfectly

[treica]

Is just because some columns are missing which is not requied..not a problem for that

[killer2p]

anyone else notice in the php script hes using info.php for odbc and mssql with db_connect.php?

[[Dev]DeadGhost]

error.... Parse error: parse error in C:\xampp\htdocs\GS\main_panel.php on line 2