Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Lineage 2 > Lin2 Private Server
You last visited: Today at 09:38

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



New L2J Server Emulator C3 Guide-German

Discussion on New L2J Server Emulator C3 Guide-German within the Lin2 Private Server forum part of the Lineage 2 category.

Reply
 
Old 12/17/2005, 19:22   #31
 
elite*gold: 0
Join Date: May 2005
Posts: 67
Received Thanks: 0
schau doch habs doch noch geschafft bin halt schnell ^^

aber hier noch mal der einzelne error

Code:
17.12.2005 19:19:50 net.sf.l2j.gameserver.serverpackets.CharSelectInfo loadCharacterSelectInfo
WARNUNG: could not restore charinfo:
java.sql.SQLException: Unknown column 'base_class' in 'field list'
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2978)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:102)
	at net.sf.l2j.gameserver.serverpackets.CharSelectInfo.loadCharacterSelectInfo(CharSelectInfo.java:190)
	at net.sf.l2j.gameserver.serverpackets.CharSelectInfo.<init>(CharSelectInfo.java:60)
	at net.sf.l2j.gameserver.LoginServerThread.run(LoginServerThread.java:367)
17.12.2005 19:19:50 net.sf.l2j.gameserver.serverpackets.ServerBasePacket write
SCHWERWIEGEND: 
java.lang.NullPointerException
	at net.sf.l2j.gameserver.serverpackets.CharSelectInfo.writeImpl(CharSelectInfo.java:75)
	at net.sf.l2j.gameserver.serverpackets.ServerBasePacket.write(ServerBasePacket.java:112)
	at net.sf.l2j.gameserver.SelectorThread.pack(SelectorThread.java:494)
	at net.sf.l2j.gameserver.SelectorThread.processOutboudQueue(SelectorThread.java:584)
	at net.sf.l2j.gameserver.SelectorThread.run(SelectorThread.java:233)
Hitman is offline  
Old 12/17/2005, 19:26   #32
 
elite*gold: 0
Join Date: Nov 2004
Posts: 2,018
Received Thanks: 126
ja das bringt dir aber nichts wenn der server läuft aber der column "base_class" nicht existiert, siehe meinen vorherigen post

Quote:

hab dir doch jetzt schon 2 mal gesagt das du alle sql's vom updates folder in navicat batchen musst...
051205-[1768].sql batch einfach mal den hier
danach sollte das error nichtmehr kommen
Makaveli is offline  
Old 12/17/2005, 19:27   #33
 
elite*gold: 0
Join Date: May 2005
Posts: 67
Received Thanks: 0
und ich habe dir gesagt das ich das schon 2 mal gemacht habe und bei jeder steht das es schon da is
Hitman is offline  
Old 12/17/2005, 19:30   #34
 
elite*gold: 0
Join Date: Nov 2004
Posts: 2,018
Received Thanks: 126
ich bin mir 100% sicher das du nicht alle gemacht hast

sonst würde die meldung "java.sql.SQLException: Unknown column 'base_class' in 'field list'" gar nicht kommen

Öffne mal die 051205-[1768].sql, dort solltest du das hier sehen

Code:
-- Needed only if your character tables are needed to be preserved.
ALTER TABLE `character_hennas` ADD `class_index` int(1) NOT NULL default '0', DROP PRIMARY KEY, ADD PRIMARY KEY (`char_obj_id`,`slot`,`class_index`);

ALTER TABLE `character_quests` ADD `class_index` int(1) NOT NULL default '0', DROP PRIMARY KEY, ADD PRIMARY KEY (`char_id`,`name`,`var`,`class_index`);

ALTER TABLE `character_shortcuts` CHANGE `unknown` `class_index` int(1) NOT NULL default '0', DROP PRIMARY KEY, ADD PRIMARY KEY (`char_obj_id`,`slot`,`page`,`class_index`);

ALTER TABLE `character_skills` ADD `class_index` int(1) NOT NULL default '0', DROP PRIMARY KEY, ADD PRIMARY KEY (`char_obj_id`,`skill_id`,`class_index`);

ALTER TABLE `character_skills_save` ADD `class_index` int(1) NOT NULL default '0', DROP PRIMARY KEY, ADD PRIMARY KEY (`char_obj_id`,`skill_id`,`class_index`);

ALTER TABLE `characters` ADD `base_class` int(2) NOT NULL default '0';
von dort kopierst du diese line in ein neues textdokument

Code:
ALTER TABLE `characters` ADD `base_class` int(2) NOT NULL default '0';
nun benennst du den .txt file in .sql um, gibts im einen beliebigen namen und batcht ihn in navicat
Makaveli is offline  
Old 12/17/2005, 19:34   #35
 
elite*gold: 0
Join Date: May 2005
Posts: 67
Received Thanks: 0
habe ich gemacht

wenn ich GS mache kommt in console immer Der Befehl "holdit" ist entweder falsch geschrieben oder
konnte nicht gefunden werden.

ist das normal
Hitman is offline  
Old 12/17/2005, 19:38   #36
 
elite*gold: 0
Join Date: Nov 2004
Posts: 2,018
Received Thanks: 126
ja das ist normal, ist kein error, kannst du ignorieren
Makaveli is offline  
Old 12/17/2005, 19:39   #37
 
elite*gold: 0
Join Date: May 2005
Posts: 67
Received Thanks: 0
ok kann jetzt joinen und wenn ich ein char machen will und dann alles so mache und erstellen will macht er nix und in console steht das

LOGIN
Code:
Account is in use on Login server (kicking off): killlerboy
GAME
Code:
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Could not insert char data: java.sql.SQLException: Unknown column 'maxCp' in 'fi
eld list'
error handling client message [C] 0B CharacterCreate
java.lang.NullPointerException
    at net.sf.l2j.gameserver.clientpackets.CharacterCreate.runImpl(Character
Create.java:125)
    at net.sf.l2j.gameserver.clientpackets.ClientBasePacket.run(ClientBasePa
cket.java:56)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

EDIT:

ich habe mein l2 nicht geupdated ich habe denn system ordner hier aus dem forum liegts daran ?
Hitman is offline  
Old 12/17/2005, 19:47   #38
 
elite*gold: 0
Join Date: Nov 2004
Posts: 2,018
Received Thanks: 126
Code:
 ALTER TABLE `characters` ADD `maxCp` decimal(11,0) default NULL,
 ALTER TABLE `characters` ADD `curCp` decimal(18,0) default NULL,
das hier in ein neues textdokument kopieren und wieder in .sql unbenennen, danach wieder in navicat batchen
Makaveli is offline  
Old 12/17/2005, 19:59   #39
 
elite*gold: 0
Join Date: May 2005
Posts: 67
Received Thanks: 0
die leuet von mir kommen drauf und so aber gmshop geht net und wenn man sich telen will geht lineage aus und kommt "History: APawn::UpdateMovementAnimation <- AActor::Tick <- TickAllActors <- ULevel::Tick <- (NetMode=0) <- TickLevel <- UGameEngine::Tick <- UpdateWorld <- MainLoop"
Hitman is offline  
Old 12/17/2005, 20:03   #40
 
elite*gold: 0
Join Date: Nov 2004
Posts: 2,018
Received Thanks: 126
haste das mit cp nun gemacht? Haben deine spieler mal den C3 client geupdatet und nen Full Check gemacht? Was bringt der server für meldungen wenn sich einer teleportiert? Ich denke mal sie benutzen den alten system ordner, deswegen bekommen sie dieses problem beim teleportieren, also am besten mal den system ordner ganz löschen, danach die Lineage2.exe starten und auf full check drücken

Der alte GmShop geht nichtmehr, muss erst wieder ein neuer gemacht werden, weil der neue server eine neue Npc/Html engine benutzt
Makaveli is offline  
Old 12/17/2005, 20:05   #41
 
elite*gold: 0
Join Date: May 2005
Posts: 67
Received Thanks: 0
Quote:
Originally posted by Makaveli@Dec 17 2005, 19:47
Code:
 ALTER TABLE `characters` ADD `maxCp` decimal&#40;11,0&#41; default NULL,
 ALTER TABLE `characters` ADD `curCp` decimal&#40;18,0&#41; default NULL,
das hier in ein neues textdokument kopieren und wieder in .sql unbenennen, danach wieder in navicat batchen
Code:
Error1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the rightsyntax to use near 'TAB `characters` ADD `curCp` decimal&#40;18,0&#41;defult NULL,' at line 1
Hitman is offline  
Old 12/17/2005, 20:07   #42
 
elite*gold: 0
Join Date: May 2005
Posts: 67
Received Thanks: 0
Quote:
Originally posted by Makaveli@Dec 17 2005, 20:03
haste das mit cp nun gemacht? Haben deine spieler mal den C3 client geupdatet und nen Full Check gemacht? Was bringt der server für meldungen wenn sich einer teleportiert? Ich denke mal sie benutzen den alten system ordner, deswegen bekommen sie dieses problem beim teleportieren, also am besten mal den system ordner ganz löschen, danach die Lineage2.exe starten und auf full check drücken

Der alte GmShop geht nichtmehr, muss erst wieder ein neuer gemacht werden, weil der neue server eine neue Npc/Html engine benutzt
ich habe hier ein gmshop patch is der gut ?

# PanDragons GM Shop Patch v2.2
Hitman is offline  
Old 12/17/2005, 20:22   #43
 
elite*gold: 0
Join Date: Nov 2004
Posts: 2,018
Received Thanks: 126
jo das ist halt das problem wenn man noch die tables vom alten server benutzt, ein update auf den neuen server ist sehr nervig, am besten wäre es die tables vom alten zu löschen und einen ganz neuen server aufzusetzten...

Aber naja, dann mach das hier

1. geh in navicat
2. rechtsklick auf die characters table und Design table wählen
3. nun schaust du wo "MaxMp" steht
4. da drückst du drauf und drückst oben auf Insert Field
5. nun ist über "MaxMp" eine neue line die leer ist
6. bei Name machst du "maxCp" rein, bei Type "decimal", bei Length "11", bei decimals "0" und am schluss nen haken bei Allow Null
7. nun sollte "maxCp" genau zwischen "curHp" und "MaxMp" sein

nun machst du das selbe mit "curCp" nur das du bei "decimals" dann "18" einträgst

wenn du alles richtig gemacht hast sollte "MaxCp" und "curCp" genau zwischen "curHp" und "MaxMp" sein, danach klickst du oben auf Save, der server sollte natürlich aus sein solange du das machst

Genau so sollte es ausehen wenn du es richtig gemacht hast

Makaveli is offline  
Old 12/17/2005, 20:40   #44
 
elite*gold: 0
Join Date: Sep 2005
Posts: 112
Received Thanks: 0
ach mist jez is mein system ordner kack* kannste mir deinen geben makaveli???
Neonamek is offline  
Old 12/17/2005, 20:48   #45
 
elite*gold: 0
Join Date: Nov 2004
Posts: 2,018
Received Thanks: 126
Quote:
Originally posted by Neonamek@Dec 17 2005, 20:40
ach mist jez is mein system ordner kack* kannste mir deinen geben makaveli???
du brauchst keinen modifizierten system ordner mehr, einfach den alten löschen > Lineage2.exe ausführen > auf full check drücken (warten bis es ganz fertig ist) und mit dem stinknormalen system ordner zocken :P
Makaveli is offline  
Reply


Similar Threads Similar Threads
L2J Server Emulator C2 Guide-German
12/25/2008 - Lin2 Private Server - 67 Replies
So hier hab ich mal noch ne guide wie man einen L2j C2 server macht, gibt zwar viele guides darüber aber meistens in english, so mach ich mal ne deutsche *g* Ok los gehts Zuerst saugt ihr euch folgende dinge: JAVA 1.4.2 SDK MySQL 4.0 (klickt dort auf » No thanks, just take me to the downloads!) Navicat L2J Server Nightly Build v0.5 L2J Datapack 4
L2J Server Emulator C3 Guide-German
12/31/2007 - Lin2 Private Server - 249 Replies
so nun poste ich meine C3 guide :D Die guide beinhaltet den neusten server und das neuste datapack ;) Downloadet euch folgendes MySQL (hier klickt ihr auf "» No thanks, just take me to the downloads!") JAVA JDK 1.5 Update Navicat 2005 L2j Server C3
L2J Server Emulator C3 Guide-German
08/07/2005 - Lin2 Private Server - 1 Replies
Hi wollt mal fragen obs auch ein Deutschen guid gibt der für Linux root Server is



All times are GMT +1. The time now is 09:38.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.