DragonPrime - LoGD Resource Community
Welcome Guest
  • Good morning, Guest.
    Please log in, or register.
  • April 19, 2019, 08:16:43 AM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Resource Pages

Pages: [1]   Go Down
Author Topic: House sql problem  (Read 2824 times)
0 Members and 1 Guest are viewing this topic.
« on: February 20, 2006, 10:10:01 AM »

When anyone in the game deposits or withdraws gold or gems from their house, we get this..

SELECT acctid FROM accounts WHERE acctid=1
Table 'lotgd.accounts' doesn't exist
Call Stack:
1: db_query("SELECT acctid FROM accoun...") called from /home/irlradio/public_html/lotgd/modules/house.php on line 447
2: house() called from /home/irlradio/public_html/lotgd/modules/house.php on line 742
3: house_run() called from /home/irlradio/public_html/lotgd/runmodule.php on line 32

Im taking a wild guess that it has something to do with 'lotgd.accounts' not existing, but Im not quite sure as I am very new to this.

Note: I did do a search in the forum to see if this problem was already addressed and did not find it. If I have over looked it please point me in the right direction, I apologize if this is the case.
« Reply #1 on: February 20, 2006, 10:44:40 AM »

a db_prefix is missing probably.

search for the line in the code, line 742 like in the stack, and there should be something like:

"......SELECT acctid FROM accounts WHERE...."

change it to

"......SELECT acctid FROM".db_prefix('accounts')." WHERE...."

and notify the author of your house system. If it's Sichae's old house system... it won't be updated anymore due to the new dwellings system.

You should think about using this as this is under active development and has many more features.
« Reply #2 on: February 20, 2006, 11:06:42 AM »

ahhh thank you sirrah! I think I will look for this dwelling module, we all love more features Wink
« Reply #3 on: February 20, 2006, 11:42:11 AM »

I am not a sire ^^

but I've fallen in love with your avatar again.

(fantasy is just a curious thing)
Pages: [1]   Go Up
Jump to:  

DragonPrime Notices
Version 1.1.2 is the current supported version and is available for download.

Support Us
No funds raised yet this year
Your help is greatly appreciated!
Recent Topics
DragonPrime LoGD
Who's Online
85 Guests, 1 User
Home Forums News Downloads Login Register Advanced Search