how use public login server and only play with u friends? [Archive]

View Full Version : how use public login server and only play with u friends?

Arex

04-18-2006, 02:28 AM

Hi, i would like to know if it is possible use public login server and dont let that all people can connect to u server, i have a limited bandwidth, then i only want play with my friends for havent lag problems.

Thank you!

mattmeck

04-18-2006, 03:47 AM

make them GM's then lock the server.

GM's can login but others cant.

Arex

04-19-2006, 07:01 AM

arg, i dont want to do any GM, because we are playing like live-eq without any command =/

mrea

04-19-2006, 07:12 AM

It isn't definite but I'd just make something like this the server name:

"Server Name [PRIVATE]" or "Server name [NO LOGINS]"

Another option would be to warn of a boot in your server's MOTD. Give them a few minutes or so and give them a friendly kick in the behind. Most people are fine with it as I had to do it on my server before. People don't have a problem with it if you warn them.

Belfedia

04-19-2006, 09:28 PM

Arex,
in database for 0.6.5-0.6.7 (Table commands)
you can choose commands you give to gm with access level.

example:
"REPLACE INTO `commands` VALUES ('zone', 200);"
put command zone to access 200.

In eqemu you need status 100 for enter on a locked server
Put all command to acces 200, your player with status 100
can play on your locked server and can't use any commands.

Arex

04-19-2006, 10:12 PM

Thank You Befeldia, i was thinking to do it, the problem is that i must to do a complete list of eqemu commands on SQL queries and it takes a little time, but i think that i ll do a program that make it for me taking old commads file and giving out a sql file with all queries for insert commands on DB.

Arex

04-19-2006, 10:51 PM

these are the query needed if anybody want use it...i have used standar values on old addon.ini, if u want use it for lock u server and need all status commands to 200 like i am going to do, u can use:

UPDATE commands set access=200;

INSERT INTO commands(command,access) VALUES ('setaaxp',100)
INSERT INTO commands(command,access) VALUES ('setaapts',100)
INSERT INTO commands(command,access) VALUES ('level',10)
INSERT INTO commands(command,access) VALUES ('damage',100)
INSERT INTO commands(command,access) VALUES ('heal',10)
INSERT INTO commands(command,access) VALUES ('npcspecialattk',100)
INSERT INTO commands(command,access) VALUES ('kill',100)
INSERT INTO commands(command,access) VALUES ('timeofday',80)
INSERT INTO commands(command,access) VALUES ('date',80)
INSERT INTO commands(command,access) VALUES ('haste',100)
INSERT INTO commands(command,access) VALUES ('weather',80)
INSERT INTO commands(command,access) VALUES ('shutdown',200)
INSERT INTO commands(command,access) VALUES ('setxp',100)
INSERT INTO commands(command,access) VALUES ('summonitem',0)
INSERT INTO commands(command,access) VALUES ('itemsearch',0)
INSERT INTO commands(command,access) VALUES ('finditem',0)
INSERT INTO commands(command,access) VALUES ('search',0)
INSERT INTO commands(command,access) VALUES ('spawn',10)
INSERT INTO commands(command,access) VALUES ('delacct',200)
INSERT INTO commands(command,access) VALUES ('size',80)
INSERT INTO commands(command,access) VALUES ('worldshutdown',200)
INSERT INTO commands(command,access) VALUES ('chat',200)
INSERT INTO commands(command,access) VALUES ('appearance',150)
INSERT INTO commands(command,access) VALUES ('zoneshutdown',150)
INSERT INTO commands(command,access) VALUES ('zonebootup',150)
INSERT INTO commands(command,access) VALUES ('emote',80)
INSERT INTO commands(command,access) VALUES ('summon',100)
INSERT INTO commands(command,access) VALUES ('kick',150)
INSERT INTO commands(command,access) VALUES ('mana',10)
INSERT INTO commands(command,access) VALUES ('npcloot',80)
INSERT INTO commands(command,access) VALUES ('findspell',20)
INSERT INTO commands(command,access) VALUES ('spfind',20)
INSERT INTO commands(command,access) VALUES ('castspell',20)
INSERT INTO commands(command,access) VALUES ('cast',20)
INSERT INTO commands(command,access) VALUES ('invul',80)
INSERT INTO commands(command,access) VALUES ('invulnerable',80)
INSERT INTO commands(command,access) VALUES ('setskill',20)
INSERT INTO commands(command,access) VALUES ('setskillall',20)
INSERT INTO commands(command,access) VALUES ('setallskill',20)
INSERT INTO commands(command,access) VALUES ('save',100)
INSERT INTO commands(command,access) VALUES ('depop',100)
INSERT INTO commands(command,access) VALUES ('depopcorpses',100)
INSERT INTO commands(command,access) VALUES ('depopzone',100)
INSERT INTO commands(command,access) VALUES ('repop',100)
INSERT INTO commands(command,access) VALUES ('spawnstatus',100)
INSERT INTO commands(command,access) VALUES ('listnpcs',100)
INSERT INTO commands(command,access) VALUES ('listnpccorpses',100)
INSERT INTO commands(command,access) VALUES ('listplayercorpses',100)
INSERT INTO commands(command,access) VALUES ('deletenpccorpses',100)
INSERT INTO commands(command,access) VALUES ('deleteplayercorpses',150)
INSERT INTO commands(command,access) VALUES ('showbuffs',100)
INSERT INTO commands(command,access) VALUES ('nukebuffs',100)
INSERT INTO commands(command,access) VALUES ('hideme',80)
INSERT INTO commands(command,access) VALUES ('deletecorpse',150)
INSERT INTO commands(command,access) VALUES ('sendzonespawns',200)
INSERT INTO commands(command,access) VALUES ('flymode',20)
INSERT INTO commands(command,access) VALUES ('race',20)
INSERT INTO commands(command,access) VALUES ('texture',10)
INSERT INTO commands(command,access) VALUES ('gender',10)
INSERT INTO commands(command,access) VALUES ('zheader',80)
INSERT INTO commands(command,access) VALUES ('zsky',80)
INSERT INTO commands(command,access) VALUES ('zcolor',80)
INSERT INTO commands(command,access) VALUES ('zcolour',80)
INSERT INTO commands(command,access) VALUES ('zuwcoords',100)
INSERT INTO commands(command,access) VALUES ('zsafecoords',100)
INSERT INTO commands(command,access) VALUES ('zclip',80)
INSERT INTO commands(command,access) VALUES ('zsave',200)
INSERT INTO commands(command,access) VALUES ('npccast',80)
INSERT INTO commands(command,access) VALUES ('dbspawn2',200)
INSERT INTO commands(command,access) VALUES ('npctypespawn',10)
INSERT INTO commands(command,access) VALUES ('attack',150)
INSERT INTO commands(command,access) VALUES ('zstats',80)
INSERT INTO commands(command,access) VALUES ('lock',150)
INSERT INTO commands(command,access) VALUES ('unlock',150)
INSERT INTO commands(command,access) VALUES ('motd',150)
INSERT INTO commands(command,access) VALUES ('makepet',20)
INSERT INTO commands(command,access) VALUES ('crashtest',201)
INSERT INTO commands(command,access) VALUES ('showpetspell',250)
INSERT INTO commands(command,access) VALUES ('freeze',100)
INSERT INTO commands(command,access) VALUES ('unfreeze',100)
INSERT INTO commands(command,access) VALUES ('pvp',100)
INSERT INTO commands(command,access) VALUES ('permaclass',80)
INSERT INTO commands(command,access) VALUES ('permarace',80)
INSERT INTO commands(command,access) VALUES ('permagender',80)
INSERT INTO commands(command,access) VALUES ('gm',100)
INSERT INTO commands(command,access) VALUES ('gmspeed',100)
INSERT INTO commands(command,access) VALUES ('movechar',100)
INSERT INTO commands(command,access) VALUES ('title',100)
INSERT INTO commands(command,access) VALUES ('copychar',200)
INSERT INTO commands(command,access) VALUES ('serverinfo',201)
INSERT INTO commands(command,access) VALUES ('npcstats',80)
INSERT INTO commands(command,access) VALUES ('memspell',100)
INSERT INTO commands(command,access) VALUES ('zone',10)

Arex

04-20-2006, 05:36 AM

i forget to add ; at end of each line, this is the code that works perfectly...

INSERT INTO commands(command,access) VALUES ('setaaxp',100);
INSERT INTO commands(command,access) VALUES ('setaapts',100);
INSERT INTO commands(command,access) VALUES ('level',10);
INSERT INTO commands(command,access) VALUES ('damage',100);
INSERT INTO commands(command,access) VALUES ('heal',10);
INSERT INTO commands(command,access) VALUES ('npcspecialattk',100);
INSERT INTO commands(command,access) VALUES ('kill',100);
INSERT INTO commands(command,access) VALUES ('timeofday',80);
INSERT INTO commands(command,access) VALUES ('date',80);
INSERT INTO commands(command,access) VALUES ('haste',100);
INSERT INTO commands(command,access) VALUES ('weather',80);
INSERT INTO commands(command,access) VALUES ('shutdown',200);
INSERT INTO commands(command,access) VALUES ('setxp',100);
INSERT INTO commands(command,access) VALUES ('summonitem',0);
INSERT INTO commands(command,access) VALUES ('itemsearch',0);
INSERT INTO commands(command,access) VALUES ('finditem',0);
INSERT INTO commands(command,access) VALUES ('search',0);
INSERT INTO commands(command,access) VALUES ('spawn',10);
INSERT INTO commands(command,access) VALUES ('delacct',200);
INSERT INTO commands(command,access) VALUES ('size',80);
INSERT INTO commands(command,access) VALUES ('worldshutdown',200);
INSERT INTO commands(command,access) VALUES ('chat',200);
INSERT INTO commands(command,access) VALUES ('appearance',150);
INSERT INTO commands(command,access) VALUES ('zoneshutdown',150);
INSERT INTO commands(command,access) VALUES ('zonebootup',150);
INSERT INTO commands(command,access) VALUES ('emote',80);
INSERT INTO commands(command,access) VALUES ('summon',100);
INSERT INTO commands(command,access) VALUES ('kick',150);
INSERT INTO commands(command,access) VALUES ('mana',10);
INSERT INTO commands(command,access) VALUES ('npcloot',80);
INSERT INTO commands(command,access) VALUES ('findspell',20);
INSERT INTO commands(command,access) VALUES ('spfind',20);
INSERT INTO commands(command,access) VALUES ('castspell',20);
INSERT INTO commands(command,access) VALUES ('cast',20);
INSERT INTO commands(command,access) VALUES ('invul',80);
INSERT INTO commands(command,access) VALUES ('invulnerable',80);
INSERT INTO commands(command,access) VALUES ('setskill',20);
INSERT INTO commands(command,access) VALUES ('setskillall',20);
INSERT INTO commands(command,access) VALUES ('setallskill',20);
INSERT INTO commands(command,access) VALUES ('save',100);
INSERT INTO commands(command,access) VALUES ('depop',100);
INSERT INTO commands(command,access) VALUES ('depopcorpses',100);
INSERT INTO commands(command,access) VALUES ('depopzone',100);
INSERT INTO commands(command,access) VALUES ('repop',100);
INSERT INTO commands(command,access) VALUES ('spawnstatus',100);
INSERT INTO commands(command,access) VALUES ('listnpcs',100);
INSERT INTO commands(command,access) VALUES ('listnpccorpses',100);
INSERT INTO commands(command,access) VALUES ('listplayercorpses',100);
INSERT INTO commands(command,access) VALUES ('deletenpccorpses',100);
INSERT INTO commands(command,access) VALUES ('deleteplayercorpses',150);
INSERT INTO commands(command,access) VALUES ('showbuffs',100);
INSERT INTO commands(command,access) VALUES ('nukebuffs',100);
INSERT INTO commands(command,access) VALUES ('hideme',80);
INSERT INTO commands(command,access) VALUES ('deletecorpse',150);
INSERT INTO commands(command,access) VALUES ('sendzonespawns',200);
INSERT INTO commands(command,access) VALUES ('flymode',20);
INSERT INTO commands(command,access) VALUES ('race',20);
INSERT INTO commands(command,access) VALUES ('texture',10);
INSERT INTO commands(command,access) VALUES ('gender',10);
INSERT INTO commands(command,access) VALUES ('zheader',80);
INSERT INTO commands(command,access) VALUES ('zsky',80);
INSERT INTO commands(command,access) VALUES ('zcolor',80);
INSERT INTO commands(command,access) VALUES ('zcolour',80);
INSERT INTO commands(command,access) VALUES ('zuwcoords',100);
INSERT INTO commands(command,access) VALUES ('zsafecoords',100);
INSERT INTO commands(command,access) VALUES ('zclip',80);
INSERT INTO commands(command,access) VALUES ('zsave',200);
INSERT INTO commands(command,access) VALUES ('npccast',80);
INSERT INTO commands(command,access) VALUES ('dbspawn2',200);
INSERT INTO commands(command,access) VALUES ('npctypespawn',10);
INSERT INTO commands(command,access) VALUES ('attack',150);
INSERT INTO commands(command,access) VALUES ('zstats',80);
INSERT INTO commands(command,access) VALUES ('lock',150);
INSERT INTO commands(command,access) VALUES ('unlock',150);
INSERT INTO commands(command,access) VALUES ('motd',150);
INSERT INTO commands(command,access) VALUES ('makepet',20);
INSERT INTO commands(command,access) VALUES ('crashtest',201)
INSERT INTO commands(command,access) VALUES ('showpetspell',250);
INSERT INTO commands(command,access) VALUES ('freeze',100);
INSERT INTO commands(command,access) VALUES ('unfreeze',100);
INSERT INTO commands(command,access) VALUES ('pvp',100);
INSERT INTO commands(command,access) VALUES ('permaclass',80);
INSERT INTO commands(command,access) VALUES ('permarace',80);
INSERT INTO commands(command,access) VALUES ('permagender',80);
INSERT INTO commands(command,access) VALUES ('gm',100);
INSERT INTO commands(command,access) VALUES ('gmspeed',100);
INSERT INTO commands(command,access) VALUES ('movechar',100);
INSERT INTO commands(command,access) VALUES ('title',100);
INSERT INTO commands(command,access) VALUES ('copychar',200);
INSERT INTO commands(command,access) VALUES ('serverinfo',201);
INSERT INTO commands(command,access) VALUES ('npcstats',80);
INSERT INTO commands(command,access) VALUES ('memspell',100);
INSERT INTO commands(command,access) VALUES ('zone',10);