DragonPrime - LoGD Resource Community
Welcome Guest
  • Good afternoon, Guest.
    Please log in, or register.
  • February 20, 2019, 02:31:07 PM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Login
 
 
Resource Pages
Search

Pages: [1]   Go Down
  Print  
Author Topic: House sql problem  (Read 2770 times)
0 Members and 1 Guest are viewing this topic.
IndieRadioLive
Guest
« 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..

Code:
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.
Logged
Nightborn
Guest
« 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.
Logged
IndieRadioLive
Guest
« 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
Logged
Nightborn
Guest
« 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)
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  


*
DragonPrime Notices
Please take the time to read the FAQ and browse the DragonPedia

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