EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Question from a newbie (https://www.eqemulator.org/forums/showthread.php?t=17119)

IntesstoMic 11-21-2004 08:07 AM
Question from a newbie
 
Try sometime ago version 5 but it seem many thing ugraded...

So ill set up a local LAN server with minilogin ( same PC ) all work but ill have NOTHIN ( execpt door ) on the world ??
Database take about 190 Mo but have nothing ?
Seem have no error on world.exe ( DR2 0.6.0 ).

Any idea ???

Thanks

IntesstoMic 11-21-2004 08:10 AM
Also
 
One more thing:

I use PEQ Database last release with some sql ( door mechant )
Ill dont use perl binarie.

:)

McFox666 11-21-2004 08:42 AM
post what the world.exe says

Dvinn 11-21-2004 11:26 AM
Is your world entirely empty or is it just some zones?

IntesstoMic 11-22-2004 05:45 AM
hello
 
Ill source PEQ Kunark ( 187 Mo ) in DB
Result in db windows:
*********************
Query OK, 1 row affected (0.00 sec)



and after in source in DB merchantlist_temp.sql
Result in db windows:
*********************
Query OK, 0 rows affected (0.05 sec)



and after ill source in DB doors_update.sql:
Result in db windows:
*********************
mysql> source 3door.sql;
ERROR 1062: Duplicate entry '0-freportw' for key 2
Query OK, 3495 rows affected (0.05 sec)
Records: 3495 Duplicates: 0 Warnings: 0

Query OK, 3495 rows affected (0.08 sec)
Records: 3495 Duplicates: 0 Warnings: 0


And after ill enter this commande:
**********************************
GRANT ALL ON *.* to 'XXXXX'@localhost IDENTIFIED BY 'XXXXXX' WITH GRANT OPTION;
INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)');
alter table account add minilogin_ip varchar(32) not null;
update variables set value='Minilogin' where varname='LoginType';
insert into account (name,status, minilogin_ip) values('XXXXX',200,'127.0.0.1');
insert into account (name,status, minilogin_ip) values('XXXXXXXX',200,'127.0.0.1');
insert into account (name,status, minilogin_ip) values('XXXXXX',200,'127.0.0.1');
ALTER TABLE `zone` CHANGE `minium_level` `min_level` TINYINT(3) UNSIGNED DEFAULT "0" NOT NULL;
ALTER TABLE `zone` CHANGE `minium_status` `min_status` TINYINT(3) UNSIGNED DEFAULT "0" NOT NULL;

Result in db windows:
*********************
mysql> source 0mini.sql;
Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

ERROR 1054: Unknown column 'minium_level' in 'zone'
ERROR 1054: Unknown column 'minium_status' in 'zone'


and exit


flag account in DB = OK
********************************
Result is:
********************************
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
Account being GM Flagged:XXXXXXXX, Level: 200
Account flagged: Username='XXXXXXXX', status=200

C:\eqemu>world.exe flag XXXXXXXX 200
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
Account being GM Flagged:XXXXXXXX, Level: 200
Account flagged: Username='XXXXXXXX', status=200

C:\eqemu>world.exe flag XXXXXXXX 250
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
Account being GM Flagged:XXXXXXXX, Level: 250
Account flagged: Username='XXXXXXXX', status=250




AFTER:


Launch minilogin
lauch world.exe ( no perl binarie)
launch 5bootzones.bat

******************************
5bootzones windows
******************************
[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 6299
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Error] Error in LoadTributes first query 'SELECT id,name,descr FROM tributes':
#1146: Table 'eq.tributes' doesn't exist
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 172 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000


**********************************
World.exe windows
**********************************
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Assassinating people that whine about horses...done
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Connected to LoginServer: 127.0.0.1:5999
42230 New TCP connection: 127.0.0.1:1047
New zoneserver: #1 127.0.0.1:1047
Zoneserver SetConnectInfo: 127.0.0.1:1047: 127.0.0.1:7999
42300 New TCP connection: 127.0.0.1:1048
42300 New TCP connection: 127.0.0.1:1049
New zoneserver: #2 127.0.0.1:1049
New zoneserver: #3 127.0.0.1:1048
Zoneserver SetConnectInfo: 127.0.0.1:1048: 127.0.0.1:7996
Zoneserver SetConnectInfo: 127.0.0.1:1049: 127.0.0.1:7995
42361 New TCP connection: 127.0.0.1:1050
42361 New TCP connection: 127.0.0.1:1051
New zoneserver: #4 127.0.0.1:1051
New zoneserver: #5 127.0.0.1:1050
Zoneserver SetConnectInfo: 127.0.0.1:1050: 127.0.0.1:7998
Zoneserver SetConnectInfo: 127.0.0.1:1051: 127.0.0.1:7997




And after

Connect my serveur
Use/create character
"entering glomming mine or something like that"
This day ill try to create carater on halas (empty zone) and type #zone karnor (empty zone)


After quit ill capture the following windows
********************************************
World.Exe
*********************************************
Logged in: FirstLogin Account #1: eqemu
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Fgfgnfgn race:2 class:16
Character creation request from K¯*tGxF¿-T¦ÈsÈ LS#0 (127.0.0.1:1076) :
Name: Fgfgnfgn
Race: 2 Class: 16 Gender: 1 Deity: 396 Start zone: 2
STR STA AGI DEX WIS INT CHA Total
120 114 86 80 70 60 55 585
Face: 7 Eye colors: 3 3
Hairstyle: 0 Haircolor: 255
Beard: 255 Beardcolor: 11
Validating char creation info...
Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=2 AND player_class=16 AND player_deity=396 AND player_race=2

No start_zones entry in database, using defaults
Current location: Halas 0.00, 0.00, 3.00
Bind location: Everfrost 0.00, 0.00, 0.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 2 or race = 0) AND (class = 16 or class = 0) AND (deityid = 396 or deityid=0
) AND (zoneid = 29 or zoneid = 0) AND gm <= 200 ORDER BY id
Character creation successful: Fgfgnfgn
Read group ID for 'Fgfgnfgn': 0
0: 2C 30 2C 2E 46 67 66 67 - 6E 66 67 6E 2C 30 36 37 | ,0,.Fgfgnfgn,067
16: 61 37 39 64 34 00 | a79d4.
Attempting autobootup of Halas (29) for Fgfgnfgn
Zoneserver SetZone: 127.0.0.1:7996 Halas (29)
Enter world: Fgfgnfgn: Halas (29)
Zoneserver SetZone: 127.0.0.1:7996 Halas (29)
Client disconnected
Removing client from ip:127.0.0.1 port:1076
World: processing ZTZ from egress zone (29) client: Fgfgnfgn
World (29): Successfully booted a zone for Fgfgnfgn
Zoneserver SetZone: 127.0.0.1:7997 karnor (102)
World: processing ZTZ from ingress zone (102) client: Fgfgnfgn
269047 New client from ip: 127.0.0.1 port: 1080
Logged in: FirstLogin Account #1: eqemu
Read group ID for 'Fgfgnfgn': 0
0: 2C 30 2C 2E 46 67 66 67 - 6E 66 67 6E 2C 30 36 37 | ,0,.Fgfgnfgn,067
16: 61 37 39 64 34 00 | a79d4.
Enter world: Fgfgnfgn: karnor (102)
Zoneserver SetZone: 127.0.0.1:7997 karnor (102)
Zoneserver SetZone: 127.0.0.1:7996 (0)
Client disconnected
Removing client from ip:127.0.0.1 port:1080
Zoneserver SetZone: 127.0.0.1:7997 (0)



**************************************
minilogin
**************************************
LoginServer.ini read.
Server mode: Standalone
Login server listening on port:5999
11036 New Server connection: 127.0.0.1 port: 9988
78002 New client from ip: 127.0.0.1 port: 1075
327281 New client from ip: 127.0.0.1 port: 1084




****************************************
One 5bootzone windows
****************************************
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for halas ...
[Status] Done loading doors for halas ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Zone Bootup: Halas (29)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
[Status] 114234 New client from ip:127.0.0.1 port:1078
Read group ID for 'Fgfgnfgn': 0
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTIN
opcode: 0x02f5, size: 4
Unexpected packet during CLIENT_CONNECTING: OpCode: 0x02f5, size: 4
0: 48 1F 73 00 | H.s.
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTIN
opcode: 0x0355, size: 4
Unexpected packet during CLIENT_CONNECTING: OpCode: 0x0355, size: 4
0: 48 1F 73 00 | H.s.
Zoning to safe coords: karnor (102)
[Status] Zoning 'Fgfgnfgn' to: karnor (102) x=302.000000, y=18.000000, z=6.000
0
Dropping client: Process=false, ip=127.0.0.1, port=1078
[Status] Zone Shutdown: halas (29)



********************************************
Other 5bootzone windows
*********************************************
[Status] Entering sleep mode
Connected to worldserver: localhost:9000
Map header: 36326 faces, 72 nodes, 42523 facelists
Loaded map: 108978 vertices, 36326 faces
Map BB: (-790.69 -> 531.78, -258.91 -> 286.88, -99.97 -> 202.91)
Map ./Maps/karnor.map loaded.
[Status] Weather should change in 2508 seconds
Error loading NPCs from database. Bad query.
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 102; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for karnor ...
[Status] Done loading doors for karnor ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Zone Bootup: karnor (102)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
[Status] 232975 New client from ip:127.0.0.1 port:1082
Read group ID for 'Fgfgnfgn': 0
Client linkdead: Fgfgnfgn
Dropping client: Process=false, ip=127.0.0.1, port=1082
[Status] Zone Shutdown: karnor (102)


So, it seem i have "bad query" to world to DB, but ill use the same as tutorial...

Any idea ?

IntesstoMic 11-22-2004 05:58 AM
Hummm
 
Someone hjave the same error
http://www.eqemulator.net/forums/viewtopic.php?t=18490


and fathernitwit gine a tip

per the change log:
ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';


Ill try now.... :wink:

IntesstoMic 11-22-2004 06:00 AM
also
 
Also i have another question (probably not good forum but..)

What is the use of perl ? Is only for quest ?

And if yes there is a database too actually ?


Thanks

IntesstoMic 11-22-2004 06:05 AM
cool
 
Ok its work
Cool
Nice worl all
Very nice...:)


All times are GMT -4. The time now is 09:23 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.