Post: #1

hi there. long time since i was on a sphere server forum.

Well im trying to insert info into the database table and im getting this error.

07:26:ERROR:(custom items 1.scp,6)Can't resolve <ACCOUNT>
07:26:ERROR:(custom items 1.scp,6)Can't resolve <MEMORYFINDTYPE.memory_guild.LINK.NAME>
07:26:ERROR:(custom items 1.scp,6)Can't resolve <KILLS>
07:26:ERROR:(custom items 1.scp,6)Can't resolve <FAME>
07:26:ERROR:(custom items 1.scp,6)Can't resolve <KARMA>

i try <serv.account> ,<server.account><src.account> and even <char.account> and same error.

(edited: ok i fix most of the error using <account.name> and on sql only shows the server name. how can it be done to add my players accounts to the sql? )

If someone can plz tell me how to fix it, ill apreciated, thanks in advance!

Post: #2

I suggest taking a look at this: http://wiki.sphere.torfo.org/index.php/Using_MySQL

It might help you.

Post: #3

You should post your SQL query by the way

Post: #4

True, post your code so we can have a look at how you are running your query.

Post: #5

It looks like this is called on an item, which doesn't have kills,karma, etc definitions... hence the error.

Post: #6

i was following exaclty the spherewiki instalation and just control copy and paste and didnt get nothing on the db. i also try searching for some documentation on the forum to help instalation and info how to get account from external db and save to sphere accounts but couldnt find nothing on it.

Post: #7

Ok, what i really want is to know how to connect to my sphere account and add the info from my database there. like i query info from my database and insert into sphere account. get it the text from db than insert int sphere. i search the forum and sphere wiki and nothing, i even google for it. Maybe some of you pass by this info and know the topic name or the keywords for the topic for search.the part of getting info and inserting on my database i know how to do. just dont know how to insert in sphere acc. if someone can plz show me the way ill apreciate again.

Post: #8

There is not a way to do a 'make sphere change this' with SQL (you can do it using sockets, telnet), however there is another way that may satisfy you:

When I had my shard running what I did was to make sphere check a database each minute to seek new account and add them, to do this I had a table only for account's that had to be created (and another one with the already created)... you can create on the first table and move it to the second when Sphere create it ... or you can also (as another example) have all accounts in the same table but adding a new field, something like 'Created' 1/0. I can give you more ideas but these are the most simple I can think of now.