+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: General Help (/Forum-General-Help)
+--- Thread: Error trying to add info into data base (/Thread-Error-trying-to-add-info-into-data-base)
Error trying to add info into data base - carcara - 04-16-2015 08:41 PM
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!
RE: Error trying to add info into data base - Sharlenwar - 04-17-2015 12:06 AM
I suggest taking a look at this: http://wiki.sphere.torfo.org/index.php/Using_MySQL
It might help you.
RE: Error trying to add info into data base - darksun84 - 04-17-2015 01:15 AM
You should post your SQL query by the way
RE: Error trying to add info into data base - Sharlenwar - 04-17-2015 01:24 AM
True, post your code so we can have a look at how you are running your query.
RE: Error trying to add info into data base - XuN - 04-17-2015 06:10 AM
It looks like this is called on an item, which doesn't have kills,karma, etc definitions... hence the error.
RE: Error trying to add info into data base - carcara - 04-17-2015 10:57 AM
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.
RE: Error trying to add info into data base - carcara - 04-18-2015 07:51 PM
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.
RE: Error trying to add info into data base - XuN - 04-18-2015 10:39 PM
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.