another editor written on php

Topics related to tools created by the Core Team or 3rd-party community members.

Moderator: Team Members

User avatar
dj--alex
Posts: 50
Joined: Fri Jun 06, 2008 3:52 am
Location: USSR
Contact:

Post by dj--alex » Sat Aug 09, 2008 10:31 am

about me:
physically i'm all right , but my foot need repair ,that must be done some year ago,and delayed many times. Length one leg<two leg= 30cm.
healing partyally payed ,partially credit :(
about program:
this is still beta version
it requires only for windows version (if you need i can give veeery long beta key)
usual (normal) have all features and free (only for any Linux based OS)!
Last edited by dj--alex on Mon Aug 18, 2008 12:26 pm, edited 2 times in total.

User avatar
dj--alex
Posts: 50
Joined: Fri Jun 06, 2008 3:52 am
Location: USSR
Contact:

Post by dj--alex » Fri Aug 15, 2008 6:46 am

Good day for all!
news :)
3.5.49 DBscript full, and can be used as patch
http://dj.chg.su/dbscript/dbscript_3.5.49_full_bsd.rar
http://dj.chg.su/dbscript/dbscript_3.5. ... in_lin.rar
English changelog 3.5.49 15.08.2008
*fixed names for backups
+added ability executing SQL dumps
+some fixes help system, added icon
(usability increased :) ).
+added db manager key in admin module
+db manager added commands: add db, copy db,del db, copy table,move table,del table. (only for admin)
(on older version this cannot be executed only from web-SQl-console in Editor)
+added check updates from off site option

User avatar
dj--alex
Posts: 50
Joined: Fri Jun 06, 2008 3:52 am
Location: USSR
Contact:

Post by dj--alex » Sat Aug 23, 2008 4:19 pm

yesterday i restore my ICQ
i help one man install dbscript within 15 minutes
i think we can fast done this action in ICQ :)
PM me if you agree , i give my number.

User avatar
dj--alex
Posts: 50
Joined: Fri Jun 06, 2008 3:52 am
Location: USSR
Contact:

Post by dj--alex » Mon Sep 01, 2008 10:38 am

3.5.51 DBscript full
http://dj.chg.su/dbscript/dbscript_3.5.51_full_bsd.rar
http://dj.chg.su/dbscript/dbscript_3.5. ... in_lin.rar
Patch_3.5.x_to_3.5.51(no_need_if_you_have_full)
http://dj.chg.su/dbscript/dbscript%203. ... %20BSD.rar
http://dj.chg.su/dbscript/dbscript%203. ... %20ENC.rar
changelog
English
-removed dbmanager 2.x
*fixed installer language smalll error (pages)
*bug fixed - manual select column search (now not reset to default automatically)
*remove disable protect hdrs (fix)
+added editor for fields type DATA with 3 new db configs:number data field (separator is , ), names header files (,) (test), used separator inside DATA fields (not support check CRC, undo)

bolly
Retired
Posts: 389
Joined: Mon Sep 21, 2009 3:03 pm
Location: Leeds, UK

Re: another editor written on php

Post by bolly » Tue Sep 22, 2009 6:41 pm

eek broken links, anyone got a mirror?

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Re: another editor written on php

Post by John Adams » Wed Sep 23, 2009 7:12 am

I am not sure this ever came to fruition.

I am working on a v2.0 of our own internal editor for the database... but due to time constraints, it won't be finished for some time. I plan to release it to the public when it's stable.

Meanwhile, I encourage anyone else to write DB editors - with the caveat that the DB structures are still in flux til after EQ2Emu Beta, so that's likely why no one else has done one. ;)

bolly
Retired
Posts: 389
Joined: Mon Sep 21, 2009 3:03 pm
Location: Leeds, UK

Re: another editor written on php

Post by bolly » Wed Sep 23, 2009 11:07 am

vs is already open!! :-P i wonder if the xml files would be the best way to pull the item fields out after all the maintenance problems of the eqemu editors *strokey beard syndrome*

User avatar
Scatman
Retired
Posts: 1688
Joined: Wed Apr 16, 2008 5:44 am
EQ2Emu Server: Scatman's Word
Characters: Scatman
Location: New Jersey

Re: another editor written on php

Post by Scatman » Wed Sep 23, 2009 1:22 pm

Keep in mind we have extra fields in the db for custom purposes and also may store data differently than how the packets require it

User avatar
dj--alex
Posts: 50
Joined: Fri Jun 06, 2008 3:52 am
Location: USSR
Contact:

Re: another editor written on php

Post by dj--alex » Wed Oct 07, 2009 3:33 am

greetings

i return from hospital, and i try not lost time, and write many new versions , now dbscript 4.0.991
my friend Deus_modus help me writing new design for project. (old is not removed, can be returned from admin settings)
http://wow.chg.su/i - new demo , if it not visible - provider problems ^(

PS. I don't have new databases at this moment, but i can host it online. 2 db hosted at wow.chg.su , UDB, YTDB , but i don't know , how old this.
(provider connect problems)


screenshots
http://filebeam.com/618644a6003fb91f2a9 ... 73a54d.jpg
http://dj.chg.su/dbscript/dbs4alpha-searchresult.JPG
http://dj.chg.su/dbscript/dbs4alpha-admin.JPG

4.0.991
mirror 1 and SVN (new!!)
http://db-script.googlecode.com/files/d ... .0.991.zip
mirror 2
http://eternity.chg.su/inside/filemgr.p ... 6ee766bcd5
mirror 3
http://behemoth.chg.su/dbs/filemgr.php? ... 71ee438f47
3.6.12 open
http://eternity.chg.su/dbs/filemgr.php? ... 9a1c9e7593

some new possibilities:
+Filehosting , with personal user folders and file limits, shared for users or non-users dbscript.
+added command .status checking opened sockets from servers srvlst.cfg
+upgrade admin and editor interface
+added unzip function
+added superuser level , some commands like unregister, and cmdlines.cfg require it
+old version 3.6.12 release all source codes !!
(if you want use only open source - use this version from repository, its supported)
+added simple bug-report key direct to me
+improved functions for load SQL dumps to server (from database manager)
+run SQL scripts on tables , no have aliases (not added to configuration)
+added possiblity remember view selected lines in table in favorites , on each table.
+added keys for reboot Apache and Mysql (if user www-data has this rights of course)
+upgrade log system , and undo operations
*fixed all known problems in installer, include message on non-english languages
(automatic start if not installed)
+started SVN :)
*fixed all known bugs in user profile
*fixed many many bugs , and many improves in program
*support ICQ working on only russian and polish languages
*site project... i still don't have time on this... outdated.

starting new ideas: (not completed)
*staring support Firebird 2.* , and PostGre 8.x (partial)
*GUI tool for visual join tables (partial done)
*undo mass operations, and simple-undo (by one-key click) (partial)

known bugs:
traditionally last added languages have 2-5 lines of other languages, be fixed at next rev.
undo don't check server location for cancel operation, auto using default server (commands printed on site if fail, can be executed manually)
execute sql don't check alias rights for tables (recomm. using denywords instead)
    Last edited by dj--alex on Wed Oct 07, 2009 6:06 am, edited 2 times in total.

    User avatar
    John Adams
    Retired
    Posts: 9684
    Joined: Thu Jul 26, 2007 6:27 am
    EQ2Emu Server: EQ2Emulator Test Center
    Characters: John
    Location: Arizona
    Contact:

    Re: another editor written on php

    Post by John Adams » Wed Oct 07, 2009 5:40 am

    Welcome back, dj-alex. I hope you are feeling better after your hospital stay. Good to see work on the editor again!

    User avatar
    dj--alex
    Posts: 50
    Joined: Fri Jun 06, 2008 3:52 am
    Location: USSR
    Contact:

    Re: another editor written on php

    Post by dj--alex » Wed Oct 07, 2009 6:23 am

    John Adams wrote:Welcome back, dj-alex. I hope you are feeling better after your hospital stay. Good to see work on the editor again!
    Good day
    Plans very big ^), i hope i can release all useful ideas
    Better be if i not lost time to hospital. i gain only problems,and not get all i want.

    PS. Existing version 3.6.12 not requires Zend. its diffs from 4.0a only GUI.
    PPS. with editing on forum link some brokes with " ..." in center.

    User avatar
    John Adams
    Retired
    Posts: 9684
    Joined: Thu Jul 26, 2007 6:27 am
    EQ2Emu Server: EQ2Emulator Test Center
    Characters: John
    Location: Arizona
    Contact:

    Re: another editor written on php

    Post by John Adams » Thu Oct 08, 2009 12:51 pm

    dj--alex wrote:PPS. with editing on forum link some brokes with " ..." in center.
    Yes, surround your http URL with the [url] BBCodes.

    User avatar
    dj--alex
    Posts: 50
    Joined: Fri Jun 06, 2008 3:52 am
    Location: USSR
    Contact:

    Re: another editor written on php

    Post by dj--alex » Fri Jan 22, 2010 5:57 am

    Good day.
    i check possibility hacks in dbscript and found and close security bug.
    if you have info about errors\bugs or if want something new from program - send me PM or post, and i try release it.


    dbscript 4.1.117 full version + major security update
    *Critical - Fixed vulnerablity can allow user execute commands from another user .
    +Summary HDd fie
    http://wow.chg.su/inside/filemgr.php?c= ... a4ca209ee6

    dbscript 3.6.17 security update only
    http://wow.chg.su/inside/filemgr.php?c= ... 056bf18ff1
    Includes only core file - for old version dbscript

    news from project ..
    +added abstraction layer for all database operations
    it can allow in future use PostGRE or another DB support.
    +Added key <show create table> into header menu and menu create code (editor)
    +dbscript fully support serverlist (srvlst.cfg) — to use server write #name in field IP or Host and all requirements can be automatically get from srvlst.cfg , dont forgot prefix #
    *when table is connecting in editor -showing database type
    +added default encoding for all tables, and alias generation
    -removed outdated converter CSV—SQL to w.php (
    +restore ability to use ' '' in SQL queries. With injecton check of course.
    +added site counter ,and online users from last hour
    +added download counter for each shared file, and save time last download in system table files.cfg
    *fixed: remove false error when enter in editor
    +added support utf-8 for programm (language driver, not style)
    +marked materials for mass operation can be used for delete
    +Added to meny Analyze: Show procedure Status , and Show function status
    +added key to admin — show all shared files
    *shrifts can be selected global or personal, table size can be changed too. If style programm requires , can be turn on ignore shrifts and sizes.
    *fixed all errors with show comment , and show comment with image.
    *added miniimage for commented table line (if allowed for table)
    *splitter for tables with substring data can be written as SPC , and encoding as space symbol. This fix trim error.
    *comment allow adding or remove image for any table line.
    +show file size in browser
    +dblinker addition: fields «name, data, title, displayid» automatically adds to table propertys
    +with adding new aliases , autocheck exists , and send warn message

    I hope this program can be useful for you

    User avatar
    John Adams
    Retired
    Posts: 9684
    Joined: Thu Jul 26, 2007 6:27 am
    EQ2Emu Server: EQ2Emulator Test Center
    Characters: John
    Location: Arizona
    Contact:

    Re: another editor written on php

    Post by John Adams » Fri Jan 22, 2010 7:33 am

    Great to see you still working on your editor, dj--alex. It is always appreciated.

    User avatar
    dj--alex
    Posts: 50
    Joined: Fri Jun 06, 2008 3:52 am
    Location: USSR
    Contact:

    Re: another editor written on php

    Post by dj--alex » Tue Mar 30, 2010 12:53 pm

    Good day!

    im returns with some useful updates , i think.. ;)
    many times taking tests with tables have multiple ID key fields, but all fixed,and done ^)

    4.1.6 27.03.2010
    *Selftest shows counter of files
    +fdb now allowed search argument !0 (not null) (only for column search)
    *Key show downloaded files works
    +Filemanager opens correct windows-1251 or utf-8 files but saves always as utf-8
    +with adding new line to table ID inserts automatically
    +installer default set utf-8
    *fixed lost undo logs for sql
    +ID2 detection improved. Check tables automatically fix errors with id not set. New tables have default id2.
    When table returns multiselect (not one line) query programm tries to find id2. If it fail it tries work in directedit mode
    +Directedit mode allows work with tables having any ID fields and use full content of line to work. Mode can be added to table header\properties only manual !
    *Fixed error with deleting multiple lines. Added check multiselect .
    *Duplicate log :dbs_exec_log fixed
    +added log for db manager operations
    *Fixed delete lost aliases in selfcheck. Now it can remove fdb tables.
    *fixed empty lines in big system tables
    *Fixed file blocking. Counter cannot be reset.

    4.1.5 04.03.2010
    +filehosting can show any images
    +fixed oldstyle interface (dbs3) non-disabled images menu, and non-standart html doctype
    +fixed utf-8 conversion errors
    +remove trash messages from logs
    +added option enables duplicate any log actions to mysql
    +added option to oldstyle interface (dbs3) shows menu as standart dbscript keys
    +to top of page added ID last opened table line

    Post Reply

    Who is online

    Users browsing this forum: No registered users and 0 guests