The following warnings occurred:
Warning [2] Use of undefined constant SAPI_NAME - assumed 'SAPI_NAME' (this will throw an Error in a future version of PHP) - Line: 3388 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3388 errorHandler->error
/showthread.php 116 build_archive_link
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/inc/functions.php 3324 build_forum_breadcrumb
/showthread.php 195 build_forum_breadcrumb
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/showthread.php 195 build_forum_breadcrumb
Warning [2] count(): Parameter must be an array or an object that implements Countable - Line: 786 - File: showthread.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/showthread.php 786 errorHandler->error






Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQLite
Author Message
Llirik
Journeyman
*

Posts: 116
Likes Given: 0
Likes Received: 10 in 8 posts
Joined: Feb 2015
Reputation: 0

UO Forum

Post: #1
SQLite
I have a TOP on server, but after Delete chars from TOP he putted in file in INVIS mode. My site don't show this players but in FILE 'top.db' they stays when i'm open with Notepad.

[function f_top8]
if !(<ldb.connected>)
ldb.connect "scripts/custom/top.db"
endif
if (<ldb.connected>)
ldb.execute DELETE FROM top // don't work TRUNCATE Sad
for x 0 <eval <serv.accounts> -1>
for y 0 <eval <Serv.MaxCharsPerAccount>>
ref2 = <serv.account.<dlocal.x>.char.<dlocal.y>>
if (<ref2.skilltotal>>0) && (<ref2.account.plevel>==1)
ldb.execute INSERT INTO 'top' ('name','skilltotal') VALUES ("<ref2.name>","<fval <ref2.skilltotal>>")
endif
endfor
endfor
// maybee this ldb.Delete bla bla bla?
ldb.close
endif

I'm be forgive this problem, but if File 'top.db' be very big on hard-disk (20 MB :-))?
Thank you!
(This post was last modified: 12-02-2020 12:33 AM by Llirik.)
12-02-2020 12:08 AM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Messages In This Thread
SQLite - Llirik - 12-02-2020 12:08 AM
RE: SQLite - Feeh - 12-05-2020, 08:10 AM
RE: SQLite - Llirik - 12-06-2020, 08:03 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)