ArberMS Source/Funserver V75 - REV52 - FULL MULUNG DOJO

keep up the good work aberb

Quote:

---

Originally Posted by DimensionMS

Mine works PERFECTLY... I had to wipe mi database and when I re-executed all the SQLS my server is up and running =D No problems..

Arberb- How can I make a GM SHOP for v72. can I just insert an SQL from v62 for an All In One GM Shop? Also whats is the !shop ID that opens?

---

yeah you can add one Ill be adding a !shop command soon

Quote:

---

Originally Posted by mikeyNshelby

Here's my error. I reexecuted all the SQL still same problem.

Code:

---

Dec 20, 2009 1:01:59 PM arberms.client.MapleCharacter saveToDB
SEVERE: (Account: mikeydoom) [charsave] Error saving character data
java.sql.SQLException: Field 'StaffType' doesn't have a default value
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1734)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2019)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1937)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1922)
        at arberms.client.MapleCharacter.saveToDB(MapleCharacter.java:630)
        at arberms.net.login.handler.CreateCharHandler.handlePacket(CreateCharHa
ndler.java:111)
        at arberms.net.MapleServerHandler.messageReceived(MapleServerHandler.jav
a:139)
        at org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messa
geReceived(AbstractIoFilterChain.java:570)
        at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageR
eceived(AbstractIoFilterChain.java:299)
        at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(Abst
ractIoFilterChain.java:53)
        at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.mess
ageReceived(AbstractIoFilterChain.java:648)
        at org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flus
h(SimpleProtocolDecoderOutput.java:58)
        at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(Prot
ocolCodecFilter.java:180)
        at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageR
eceived(AbstractIoFilterChain.java:299)
        at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(Abst
ractIoFilterChain.java:53)
        at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.mess
ageReceived(AbstractIoFilterChain.java:648)
        at org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorF
ilter.java:220)
        at org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.
run(ExecutorFilter.java:264)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnabl
e.java:51)

---

---

Are you sure your using a clean ArberMS source? Cause theirs nothing in the source that has stafftype in it

I'm using this: http://forum.ragezone.com/f427/cype-...atures-631292/

Quote:

---

Originally Posted by mikeyNshelby

I'm using this: http://forum.ragezone.com/f427/cype-...atures-631292/

---

Thats whats screwing you up you have to set stafftype to 0 for everyone and make the default value 0 or it wont work

How do I make it so the default value is 0?

Learn some fucking MySQL, *right click on table* -> Edit table and set your values.

ALTER TABLE `accounts` MODIFY COLUMN `StaffType` DEFAULT '0';
or
ALTER TABLE `characters` MODIFY COLUMN `StaffType` DEFAULT '0';

I don't know what table that column is in.

I think that's right. o_o

I know SQL I just didnt know how to set a default SQL value.

Quote:

---

Originally Posted by Akreao

ALTER TABLE `accounts` MODIFY COLUMN `StaffType` DEFAULT '0';
or
ALTER TABLE `characters` MODIFY COLUMN `StaffType` DEFAULT '0';

I don't know what table that column is in.

I think that's right. o_o

---

yeah I think thats right

Quote:

---

Originally Posted by mikeyNshelby

I know SQL I just didnt know how to set a default SQL value.

---

Check Akreao post and that should help you

.....

Quote:

---

Originally Posted by fancydays

ArberMS fan source dev , Good luck^^:)
What will you renew in the features?...
(Job skill fix?(pirate)/Guild Alliances?)

---

Player npcs... from what he told me.

i fixed my error earlier and now i have a new error. i am able to get in game with this error though but i cannot execute any gm commands. Hope you can help.. thanks :):

Lol Good Job. Arberb, how you get everything done right.

I can't create any characters o.o!

Quote:

---

Originally Posted by NhatQuang

I can't create any characters o.o!

---

Do you get any bat errors? post it in the help section.