Dual Login

[an2ny_18]

how to fix this problem, my players can login same account but different server and this is a BIG problem.

They can duplicate items and alz.

Thank you guys hope you will help me with this one.

thanks cypher but i mean CHANNEL not other server, sorry.

 

[jaeker1]

disable trigger fix login

 

[an2ny_18]

thanks but where i can delete that? i can't find any triggers in my db.

up please help

 

[chumpywumpy]

A quick google on how to manage triggers would have answered that for you. Just run the following query on your account db.

DROP TRIGGER [dbo].[fixlogin]

 

[an2ny_18]

Thanks for your help. problem fix.

Please close the tread.

 

[Ppast]

sorry for bumping this but i have the same problem and i didnt use triggers on my db also when i see cyphers posts all i can read is :

I should have watched my mouth and not said/talked **** to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

if person above me fixed it through cyphers help i cant know what that help was.:

 

[Cath22]

just remove fixlogin trigger

 

[chumpywumpy]

sorry for bumping this but i have the same problem and i didnt use triggers on my db also when i see cyphers posts all i can read is :


if person above me fixed it through cyphers help i cant know what that help was.:

Those posts of Cyphers were destroyed some time ago. I posted the fix.

A quick google on how to manage triggers would have answered that for you. Just run the following query on your account db.

DROP TRIGGER [dbo].[fixlogin]

 

[Ppast]

as i said i didnt used triggers that includes fixlogin also i did tried the drop trigger just in case it returned an error because there was no trigger

 

[cypher]

and that error would be?!

 

[Ppast]

Msg 3701, Level 11, State 5, Line 1
Cannot drop the trigger 'dbo.fixlogin', because it does not exist or you do not have permission.

that would be the error

 

[cypher]

it`s ok, then you do no have that trigger.

 

[chumpywumpy]

Make sure you run it on the account db. The trigger exists by default so it will be there even if you didn't add it.

 

[Ppast]

it wasnt chumpy because thats where i raned it also i fixed it by deleting gamedb and account db then restoring and 1st i tried just the account db and it didnt work ... so yea most probably was that the error was being caused by the gamedb
ty


Update ->> it was the premium time that cant pass about 28 years or so XD