[RELEASE] Admin Panel

[Svinseladden]

like alot here i get the errors:

Msg 207, Level 16, State 1, Procedure usp_WhosOn, Line 4
Invalid column name 'Class'.
Msg 207, Level 16, State 1, Procedure update_detales, Line 7
Invalid column name 'JoinDate'.
Msg 207, Level 16, State 1, Procedure AddPoints, Line 37
Invalid column name 'Date'.

and yea i seen why and stuff like that but does it work even if you don't fix them?

i don't use the admin pan but like the auto ban ip stuff here. like when ppl change ip and get auto ban if they try an account that already ban. but stat padders and so on those that still work with this 3 errors?

or is there a workaround that works? something to do like adding colums or something?

btw to change from old ip ban in User_master to the new one you need

INSERT INTO GM_Stuff.dbo.BannedIP(IP1) SELECT banIP FROM PS_UserData.dbo.BannedIPs

and this one..

Update PS_UserData.dbo.Users_Master
Set Status='-2'
Where Status='-5'

becouse old was in user_master and not in the gm_stuff and old gave -5 and the new one uses -2 when your banned..

[[DEV]xXDASHXx]

ok theres bugs in my scripts from what i have been reading so as soon as i get my brain ta function acuretly again ill rework the querys ta fix the invaled collumn class of the scripts. i have huge add issues and if im not chalanged at scripting i tend ta loos entrist and unabel ta fix whats wrong cause im to unfocused on the true issue and start wondering off subject to other things and endup 90% more bugged then when i start lol so give me a few ta get my brain workeing back on track again and ill fix the issues of my scripts.. unless someone wants ta do it for me all it requiers is go in and find the sections refering to CLASS and replace the
'where Class = ' '
and change that to
where Famaily = value needed from Chars table and Job = value needed from chars table

[treica]

has anybody else this error when try to access itemedits or something Admin Account returned no Results thats killing me i have no ideea since i use the same files, db, scripts i used before....

[mchan004]

what user and pass to login to Admin Panel ?

[.Shaco.]

go to GMStuffs database and check login. There you will see your login id and pass and IP change it to 127.0.0.1 if you are trying to login from local. The login scrip was made it so that the login ip and login user's IP must meet.

[mchan004]

where GMStuffs ?

[-Elliot-]

Originally Posted by treica

has anybody else this error when try to access itemedits or something Admin Account returned no Results thats killing me i have no ideea since i use the same files, db, scripts i used before....

Not i dont have the problem i can edit all items

[treica]

As long i can login into panel is everything cool, i did checked all those stuff but i have no ideea reason my ip is static so ima not needed to change...i tryed already for 2 days but no success i think i quit the panel xd.

[.Shaco.]

are you admin with your acc? status 16 i mean.

[treica]

i fixed it, was the crappy dupe fix sistem was blocking every connection from server scripts.
i changed the sp as was before and is working now.

[mchan004]

error in logout.txt SQL 2005
->

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'.

[JohnHeatz]

Just declare the variables if you don't have them already on your SP

[orion72956]

Ok, for some reason I can't get the Admin Panel to work through MSSQL. Everything I have is run through ODBC so any help with getting MSSQL queries to work would be great. Really need this panel..

[shadyassassin]

does this work still? need free unlimited premium plz and thanks xD

[Riouk]

Originally Posted by orion72956

Ok, for some reason I can't get the Admin Panel to work through MSSQL. Everything I have is run through ODBC so any help with getting MSSQL queries to work would be great. Really need this panel..

Convert it for MSSQL query's go to ODBC.