[Q] LINQ to XML - help need from SQL - Windows Phone 7 Software Development

Hi there,
I'm porting an app which uses SQL to query a SQLCE db.
Now under WP7 I switched over to XML files.
Can anyone help me to "translate" the following SQL sentence to Linq to XML ?
Code:
Dim SQL As String = String.Empty
Dim USERENTRY As String = String.Empty
SQL = "SELECT Info.INFO_COMMENTS FROM Names INNER JOIN Info ON Names.NAME_ID = Info.INFO_NAME_ID "
SQL = SQL + "WHERE (Names.PARENTS_NAME_ID = " & "'" & USERENTRY & "') "
SQL = SQL + "GROUP BY Info.INFO_COMMENTS "
SQL = SQL + "ORDER BY Info.INFO_COMMENTS"
My skills are very low right now to deal with this...
On the other hand, if someone can point me to a some kind of tool to make the conversion or a great tutorial, that will be great too!
Thanks in advance for any help.
Cheers

I'm not Linc expert, but the quickest way to get your sql server output into an xml format is to use the FOR XML statement:
SELECT * FROM TABLE FOR XML
Whether this is the correct syntax for Linc, I don't know, but it may point you down the right path.
Google "sql server for xml"

Hello,
Your SQL request depends on your db schema. The Linq to XML request over a XML will depend on the XML structure.
So we need to see your XML file to help you.

The_badger_man said:
Hello,
Your SQL request depends on your db schema. The Linq to XML request over a XML will depend on the XML structure.
So we need to see your XML file to help you.
Click to expand...
Click to collapse
As the Badger says, post some sample XML and we can take a look...
Also, check out Linqpad for a collection of Linq To Xml samples and a great way to learn Linq in general (it will change your coding )

Related

Registry Meaningful Name & Value

Any Registry GURU who can explain the meaning of this registry...
=================================================
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Color]
"SHColor"=hex:ff,00,00,00,00,00,00,00,dd,dd,dd,00,ff,ff,cc,00,ff,ff,ff,00,15,bc,\
15,00,15,bc,15,00,c9,e9,c9,00,14,a7,14,00,ff,ff,ff,00,14,a7,14,00,14,a7,14,\
00,14,a7,14,00,15,bc,15,00,14,a7,14,00,ff,ff,ff,00,c9,e9,c9,00,37,d3,37,00,\
37,d3,37,00,ff,ff,ff,00,15,bc,15,00,14,a7,14,00,ff,ff,ff,00,15,bc,15,00,84,\
84,c3,00,15,bc,15,00,14,a7,14,00,ff,ff,ff,00,ff,ff,ff,00,00,00,00,00,ff,ff,\
ff,00,00,00,00,00,ff,ff,ff,00,15,bc,15,00,37,d3,37,00,ff,ff,ff,00,ff,ff,ff,\
00,c9,e9,c9,00,14,a7,14,00,ff,ff,ff,00,14,a7,14,00
"BaseHue"=dword:00b4f050
"40"=hex:ff,ff,ff,00
"39"=hex:ff,ff,ff,00
"38"=hex:9c,9c,9c,00
"37"=hex:d7,d7,d7,00
"36"=hex:ff,ff,ff,00
"28"=hex:ff,ff,ff,00
"27"=hex:ff,ff,ff,00
"26"=hex:ff,80,40,00
"25"=hex:ff,00,00,00
"16"=hex:d7,d7,d7,00
"15"=hex:ff,ff,ff,00
"14"=hex:0a,5d,01,00
"13"=hex:00,c0,00,00
"12"=hex:80,80,80,00
"11"=hex:c0,c0,c0,00
"7"=hex:0a,5d,01,00
"6"=hex:96,96,96,00
"4"=hex:ff,ff,ff,00
"DefSHColor"=hex:ff,00,00,00,00,00,00,00,dd,dd,dd,00,ff,ff,cc,00,ff,ff,ff,00,15,\
af,bc,00,15,af,bc,00,c9,e7,e9,00,14,9c,a7,00,ff,ff,ff,00,14,9c,a7,00,14,9c,\
a7,00,14,9c,a7,00,15,af,bc,00,14,9c,a7,00,ff,ff,ff,00,c9,e7,e9,00,37,c7,d3,\
00,37,c7,d3,00,ff,ff,ff,00,00,b7,c9,00,14,9c,a7,00,ff,ff,ff,00,15,af,bc,00,\
84,84,c3,00,15,af,bc,00,14,9c,a7,00,ff,ff,ff,00,ff,ff,ff,00,00,00,00,00,ff,\
ff,ff,00,00,00,00,00,ff,ff,ff,00,2e,44,4f,00,00,14,3c,00,00,f0,ff,00,ff,ff,\
ff,00,c9,e7,e9,00,14,9c,a7,00,ff,ff,ff,00,14,9c,a7,00
"Restriction"=dword:00000002
====================================================
or any recommended software that will translate the the same value to english.
Please & Thanks,

[APP][DISCONTINUED] TF3D manila mode9 editor

6Fg8 proudly presents:
m9editor
development discontinued
​
m9editor is your little helper when it comes to editing manila files. It lets you edit nearly all aspects of a mode9 file. Additionally it will assist you with graphics, allowing import, export and CFC compression. And It includes a directory viewer with information specific to manila files.
requirements:
m9editor is written in .net, so .netCF3.5 (currently SP1) must be installed (usually its already there). It has been developed and tested using Windows XP x64, but should run on any Windows platform.
usage:
see the manual contained in the download package (PDF)
making of / credits:
thanks to: D-MAN666, sztupy, nixx-X1, Chainfire, pcarvalho, showaco, guap, 12aon, xboxmod, NisseDILLIGAF, smotrs, for contributing knowledge, ideas, testing. Thank you guys (& gals of course) !
version history:
2009-03-10 - v3.3.0.1
BUGFIX: crashed when using selections
2009-03-09 - v3.3.0.0
- LuaConv is now included in the m9editor download package
- CHG: all sourcecode related functions use ".lua" as default extension
- NEW: compile and import function for lua script sourcefiles:
for mode9 files (embedded scripts):
m9editor remembers the filename of the source on a per-node basis and lets you subsequently edit the recently used file from the particular node. You may also attach/detach such a link manually. If a link is established, you may edit the sourcefile (check if you set the "SourceCodeViewer" option in m9editor.cfg) and recompile/import in a single step. When saving the mode9 file the links are saved too (mode9file.ann) and reloaded on next open.
for standalone scripts:
m9editor checks if a correspondig xxxxxxxx_manila.lua exists in the script directory. If yes, you are offered edit and compile options.
- NEW: editor context menu: view source for embedded scripts
- NEW: search previous button
- FIX: editing characterreference threw exception
- NEW: dirviewer context menu for mode9 files: compare with: compare two mode9 files without loading it first
- NEW: dirviewer context menu for all files: hex compare with: compare two files with hexview.
Only available if AptDiff is installed. Edit m9editor.cfg and insert the following line (use the path on your system):
AptDiffPath=c:\Program Files (x86)\Brother Technology\AptDiff 1.5\aptdiff.exe
If AptDiff is installed and configured in m9editor.cfg, text compares are done with AptDiff instead of ExamDiff
WARNING:
during directory analyze, if a lua script is found, m9editor checks for existence of <filename>.luac.lua. If its found it will be renamed to <filename>.lua. In directory viewer the line will be shown blue colored to indicate the presence of a sourcecode file.
during mode9 file load, if a embedded script is found, m9editor checks for existence of <filename>_<bytepos>.luac.lua. If its found it will be renamed to <filename>_<bytepos>.lua. In mode9 editor you will notice the link to the script sourcecode. Dont forget to save the mode9 file to make the link permanent (otherwise if you modify the structure, links might be lost due to changing byteposition).
WARNING2:
The pdf attached doesnt reflect the latest changes to m9editor, update follows.
2009-02-22 - v3.2.0.1
- fixed definitions for weather.mode9 and landscape.mode9 which rendered them unusable after modifying
2009-02-22
I removed the QtcConv and LuaConv tools because they lack of syntactical checks and the same functionality is available in m9editor.
EDIT: added the old LuaConv again, seems to work not that bad i thought it would
2009-02-21 - v3.2.0.0
- font changes for various fields to avoid overlapping
- if "manila files dir" is changed in settings, directoryview will be reloaded
- new: directory viewer context menu option for mode9 files: "extract embedded scripts", writes them to script directory
- changed interpretation of UV property (16.16 instead of INT32)
- picture view: new "save as PNG" and "save as QTC" buttons will save your graphic to a selectable directory
2009-02-19 - v3.1.0.1
bugfix for "save tree to file" function
2009-02-19 - v3.1.0.0
time for a new version
- m9editor now remembers last window/splitter positions and restores them on start and returning from minimize
- HOT compare feature: if a mode9 file is loaded, rightclick on the toplevel node to compare with another mode9 file, or save the treeview as a textfile. Compares are done with a freeware tool named "ExamDiff" from PrestoSoft.
2009-02-18 - v3.0.5.0
new context menu functions in directory viewer: delete, copy to
2009-02-17 - v3.0.4.0
content of XML, HTML displayed in lower right panel
evaluation of XML locales in directory viewer
manual is complete, and now a part of the package
2009-02-16 - v3.0.3.1
annotations now work for new tags as well, and will be copied between instances (+corrected a few flaws during display)
new: search within decompiled lua scripts
new: copy annotations between instances of m9editor
2009-02-11 - v3.0.2.0
bugfix: empty value crash
minor improvements
2009-02-10 - v3.0.1.0
some little improvements:
- sourcecode of embedded scripts and .luac files is shown whenever possible
- zoom percentage display for graphics display
2009-02-09 - v3.0.0.0
I've made a lot of changes to improve m9editor. The most important are:
- integration with sztupy's luadec (thanks and credits to sztupy for great decompiler and permission to use, and of course once again to D-MAN666 for providing knowledge)
- import of compiled lua scripts (ANSI or Unicode, autodetected)
- UI reworked: editor, directory viewer, image viewer combined in one window
planned for next releases of m9editor:
- copy files to/from PDA if connected via ActiveSync
- smart-select referenced graphic files in a mode9 file
- selfcheck for consistent mode9 writing
- analysis of lua script "require"'s for valid manila names
download stats:
v.3.2.0.1: 1554 views (wow! impressed!)
Guess I'll have to try that, seems great !
Your editor seems (as you describe it) only able to change values, but not the structure of the mode9 file, do you intend to change that ?
I have an ongoing project of mode9/xml converter in C, if I can be of some help, don't hesitate to ask
Hi Ximoon,
guess you belong to the "intended audience"
At the moment only changing values is allowed, correct. The main reason for this is that i'm unable to interpret and understand the complete structure, and to make sure that writing of m9 files produces valid files. If there's more info on that i could build it into the editor of course.
What i could imagine is a more generic approach, e.g. allow insertion/deletion of tags based on hex-values. I'll give that a thought.
Do you have any detailed info about the tag-structure? It can be seen in the tagfile but as hexvalues. Ive been able to interpret some of them, but the meaning of many others is unknown to me. So m9editor filters most of them for better reading.
Anyway, there's more to come with m9editor. I already built routines to disassemble lua scripts which run fine, but as its output is only relevant to p-code its pretty useless at this time. Also planned is a tool to allow image replacement. That could go to a point where we have a complete workbench for TF3D, including preview and the like. But thats far beyound my current scope.
Nice anyway !
I have no more information than you do, all I got is from the manilla thread where you posted earlier
But in the end, names of the tags doesn't really matter.
For LUA, I found some decompiler on the web, so I guess a tool to convert lua-unicode to lua-ascii and reverse could work to use those tools.
I guess I'll go on with my editor and see what I could do in the end, for two different approches could be constructive !
Must have been ChunkSpy, right? I found many more but mostly outdated and not working for Lua 5.1.
The Lua routines i've already written allow converting unicode to ascii, and save the scripts in ascii respectively. I'll have to recode them in .net as the first quick approach has been VB
Nice start, man
I was waiting for so long since somebody starts public Manila DevKit since i posted specs i reversed
Drop me a PM if you have any questions
Can't wait to use those lua tools
yeah, right D-MAN, most of that thing is based on your findings, my respect m8.
I'll PM you later, gotta go shopping now for newyears eve
6Fg8 said:
yeah, right D-MAN, most of that thing is based on your findings, my respect m8.
I'll PM you later, gotta go shopping now for newyears eve
Click to expand...
Click to collapse
Yah, sure, after NY eve when my hangover is over
oh oh, nice tool thank you
new version has been released, details here
got ean error if i want to open a file..
System.UnauthorizedAccessException: Der Zugriff auf den Pfad C:\Dokumente und Einstellungen\Administrator\Desktop\HTC\tf3d\2c684cd8_manila wurde verweigert.
bei System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
bei System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
bei System.IO.FileStream..ctor(String path, FileMode mode)
bei m9editor.m9efunctions.readm9(String fname, Boolean writedebug)
bei m9editor.m9editor.fileopen_Click(Object sender, EventArgs e)
bei System.Windows.Forms.Control.OnClick(EventArgs e)
bei System.Windows.Forms.Button.OnClick(EventArgs e)
bei System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.ButtonBase.WndProc(Message& m)
bei System.Windows.Forms.Button.WndProc(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Click to expand...
Click to collapse
edit: i was write protected.....
schreda said:
got ean error if i want to open a file..
System.UnauthorizedAccessException: Der Zugriff auf den Pfad C:\Dokumente und Einstellungen\Administrator\Desktop\HTC\tf3d\2c684 cd8_manila wurde verweigert.
Click to expand...
Click to collapse
sorry, i dont have that file on my touch HD, cannot test. Are you sure its a mode9 file? Can you upload it here?
schreda said:
edit: i was write protected.....
Click to expand...
Click to collapse
that explains something
hmm.. i'm trying to port the analog clock from the Diamond to the HD.. i must change the Resolution i think but i got a bad result if i change the size var... ( i took the original file from the Hd to compare it
schreda said:
hmm.. i'm trying to port the analog clock from the Diamond to the HD.. i must change the Resolution i think but i got a bad result if i change the size var... ( i took the original file from the Hd to compare it
Click to expand...
Click to collapse
great idea, i'd appreciate to see a analog clock on the HD
new version has been released, details here
wow! finally someone is doing it
thanks and keep up the good work!!!
what i show in screenshot, is it portion of unparsed data?
can one edit them? i tried and failed cause i dont know what to change...
i'm missing: RectF, X, Y, Width, Height
pcarvalho said:
wow! finally someone is doing it
thanks and keep up the good work!!!
what i show in screenshot, is it portion of unparsed data?
can one edit them? i tried and failed cause i dont know what to change...
i'm missing: RectF, X, Y, Width, Height
Click to expand...
Click to collapse
its the value of the tag above, "Viewport". Currently i dont know how to parse that, as its binary and i dont understand the meaning. Could be 8 x Int16, or 4x Int32, or a mixture of that, and even then i wouldnt understand what these values mean. Obviously parameters for Viewport.
Yes, you can edit that, simply overwrite the hexvalues and press enter, it will be written.
Can you shed light into the purpose of these values? I'll be glad to parse them right.
BTW there is a baaad bug in v1.0.2.0 when writing m9, i'm currently correcting that.
6Fg8 said:
its the value of the tag above, "Viewport". Currently i dont know how to parse that, as its binary and i dont understand the meaning. Could be 8 x Int16, or 4x Int32, or a mixture of that, and even then i wouldnt understand what these values mean. Obviously parameters for Viewport.
Yes, you can edit that, simply overwrite the hexvalues and press enter, it will be written.
Can you shed light into the purpose of these values? I'll be glad to parse them right.
BTW there is a baaad bug in v1.0.2.0 when writing m9, i'm currently correcting that.
Click to expand...
Click to collapse
take your time my friend
those ones for Viewport i only know that they are:
<Property Name="Viewport" Type="RectF" X="0" Y="0" Width="31457280" Height="35127296" Animated="False"/>
cause i used D-MAN666's mode9parser, talk with him cause he might help, i hope

(Updated 04.02.11) HIVE AND REGISTRY FILE EDITOR

Hive and registry file editor 2.0.112
A command line utility to work with hv files.
Full Unicode support, and more.
!!! WARNING !!!
Do not use CeRegEditor (cereg) to work with .hv !!!
!!! WARNING !!!
Usage:
HVEdit.exe <rgu>|<dump>|<hive>|<hvm> [-r] [<outputdir>]
<rgu> Build boot.hv from rgu file.
<dump> Build default.hv and user.hv from project folder.
<hive> Output hive file contents to the <hivename.hvm> text file.
<hvm> Build hive file from hvm file.
-r Don't insert *.rgu hash value to the hive.
Release history:
---------------------
V. 2.0.112
+ Some changes.
V. 2.0.035
+ Extract hive to the .hvm text file.
+ Build hive from .hvm file.
V. 1.0.000 (Initial Release)
Don't need Unicode??
and I'm wondering whether the "REGEDIT4" is needed.
btxakita said:
Don't need Unicode??
Click to expand...
Click to collapse
Who spoke?
btxakita said:
and I'm wondering whether the "REGEDIT4" is needed
Click to expand...
Click to collapse
Yes.
NEW Release
V. 2.0.035
Added new functions:
+ Extract hive to the .hvm text file in Unicode format.
+ Build hive from .hvm file.
AnDim
AnDim said:
NEW Release
V. 2.0.035
Added new functions:
+ Extract hive to the .hvm text file in Unicode format.
+ Build hive from .hvm file.
AnDim
Click to expand...
Click to collapse
A dump question I'm sure, I started cooking recently and I'm wondering what I could accomplish with this application. In what scenario would I use it? Thanks, 12
Thanks. One problem I had w/ rgucomp is missing unicode support.
12aon said:
A dump question I'm sure, I started cooking recently and I'm wondering what I could accomplish with this application. In what scenario would I use it? Thanks, 12
Click to expand...
Click to collapse
What exactly is not clear?
Thanks AnDim, this makes GSM -> CDMA SYS porting much easier.
AnDim said:
What exactly is not clear?
Click to expand...
Click to collapse
Well I think I'm starting to understand. As I always have had the luxury of initflashfiles.txt or app.reg and never edited the .hv manually. It was unclear to me why I would need this or what it would add to a kitchen that supports those features (initflashfiles.txt and app.reg)
So does this app have a function in such a kitchen, I mean is there anything I will need to do manually that can't be done otherwise or is this more like a general app so that the hives on any phone can be more easily changed?
Thanks 12
@AnDim, PMed you.
Have anyone used this program? It's not working well for me. I use it fo rgu to hv convert but when i compare the output hv file with cereg alot different files
prpetrov said:
I use it fo rgu to hv convert but when i compare the output hv file with cereg alot different files
Click to expand...
Click to collapse
!!! WARNING !!!
Do not use CeRegEditor (cereg) to work with .hv !!!
how does project folder need to be set up to build default and user hv's?
BUG: Default value is imported and exported incorrectly
If I convert an rgu which contains
Code:
@="one"
"Default"="two"
hvedit overwirtes the default value with "two"
Request: option to specify output file
selyb said:
how does project folder need to be set up to build default and user hv's?
Click to expand...
Click to collapse
HVEdit.exe <My project folder>
Don`t need to be setup. Rgu´s, packages.sof and so on, can be in any sub folders.
selyb said:
BUG: Default value is imported and exported incorrectly
If I convert an rgu which contains
Code:
@="one"
"Default"="two"
hvedit overwirtes the default value with "two"
Click to expand...
Click to collapse
Hey man .... Key name "Default" == Key name @
selyb said:
Request: option to specify output file
Click to expand...
Click to collapse
??? f.e.
AnDim
sorry, I misunderstood. Until now, I didn't know you could use "Default"=
selyb said:
Request: option to specify output file
Click to expand...
Click to collapse
What I mean is like
Code:
hvedit myhive.hv myhive.txt
so hvedit would export myhive.hv to myhive.txt
selyb said:
What I mean is like
Code:
hvedit myhive.hv myhive.txt
so hvedit would export myhive.hv to myhive.txt
Click to expand...
Click to collapse
Usage:
HVEdit.exe <rgu>|<dump>|<hive>|<hvm> [-r] [<outputdir>]
<rgu> Build boot.hv from rgu file.
<dump> Build default.hv and user.hv from project folder.
<hive> Output hive file contents to the <hivename.hvm> text file.
<hvm> Build hive file from hvm file.
-r Don't insert *.rgu hash value to the hive.
AnDim
AnDim said:
Usage:
HVEdit.exe <rgu>|<dump>|<hive>|<hvm> [-r] [<outputdir>]
<rgu> Build boot.hv from rgu file.
<dump> Build default.hv and user.hv from project folder.
<hive> Output hive file contents to the <hivename.hvm> text file.
<hvm> Build hive file from hvm file.
-r Don't insert *.rgu hash value to the hive.
AnDim
Click to expand...
Click to collapse
Hi,
thanks for this software it works great, if you now how to put this commands.
My experience was this:
D:\>hvedit.exe hive d:\hive
or:
D:\>hvedit.exe hive d:\hive\user.hv
I'm getting this:
(HVEdit) !ERROR: failed building DEFAULT hives.
When I copy HVEdit.exe and cereg400.dll to d:\hive and run this:
D:\hive>hvedit.exe d:\hive\user.hv
I'm getting this:
Admsoft (R) HVEdit Version 2.0.035
Hive and registry file editor.
(C) 2009 AnDim, XDA-Developers.
(HVEdit) Extracting user.hv ...
(HVEdit) Done! and only 21.kB of 69kB .hv file
When I run it on system.hv like this:
D:\hive>hvedit.exe d:\hive\system.hv
I'm getting this:
(HVEdit) Extracting system.hv ...
ERROR: C:\MacB\private\winceos\COREOS\filesys\reg\reghive\.\registry.c line 172: Reg: Invalid reghandle 0x20000a61
and 144kB .hvm file of 105kB .hv
I didn't mention it but I was trying to convert .hv to .hvm
Maybe my dump has got some errors in it.
Any idea what is wrong, why the user.hvm is so small?
Thank you AnDim for great software. It is quite difficult to find out utility for ce hive.
After use for a period I would to to report some small problem.
1. Long multi string was trimed. (Maybe fixed length variable in code) See Ex.
Registry key in my rgu file is
REGEDIT4
[HKEY_LOCAL_MACHINE\System\StorageManager\Filters\fsreplxfilt]
"DirsToExclude"=multi_sz:"\\mxip_initdb.vol",
"\\mxip_system.vol",
"\\mxip_notify.vol",
"\\mxip_lang.vol",
"\\cemail.vol",
"\\pim.vol",
"\\Documents and Settings\\default\\user.hv",
"\\Documents and Settings\\system.hv",
"\\Windows\\Profiles\\guest\\Temporary Internet Files\\",
"\\Windows\\Profiles\\guest\\Cookies\\",
"\\Windows\\Profiles\\guest\\History\\",
"\\Windows\\Activesync\\",
"\\Windows\\messaging\\",
"\\Temp\\"
After change to boot.hv and extract back to boot.hvm the Registry is as hereunder.
; Admsoft (R) HVEdit Version 2.0.035
; Hive and registry file editor.
; (C) 2009 AnDim, XDA-Developers.
;
;
; Source file: boot.hv
; Size: 28672 byte
; Hash: e9e4f2edd12c78eeed7aceeaea22c36f
; Boothash: 1ef4fb8f2b109c0757709e7f46c71a20
; Build tool: HVEdit v2.0
[HKEY_CLASSES_ROOT]
[HKEY_CURRENT_USER]
[HKEY_LOCAL_MACHINE\System\ObjectStore\RegistryUpdate]
"boot.rgu"=hex:1E,F4,FB,8F,2B,10,9C,07,57,70,9E,7F,46,C7,1A,20
[HKEY_LOCAL_MACHINE\System\StorageManager\Filters\fsreplxfilt]
"DirsToExclude"=multi_sz:"\\mxip_initdb.vol",
"\\mxip_system.vol",
"\\mxip_notify.vol",
"\\mxip_lang.vol",
"\\cemail.vol",
"\\pim.vol",
"\\Documents and Settings\\default\\user.hv",
"\\Documents and Settings\\system.hv",
"\\Windows\\Profiles\\guest\\Temporary Internet Files\\",
"\\Windows\\Profiles\\guest\\Cookies\\",
"\\Windows\\Profiles\\guest\\History\\",
"\\Windows\\Activesync\\"
[HKEY_USERS]
; (HVEdit) Done!
2.The size of hv file is larger than original. (This is not effect functional just file size is increase from 732kb to 744kb for instance.)
After investigate, there was extra length on data key which have length just fit 32 bits size. (Maybe when adjust cell size to fit 32 bits)
Hope my comment will be some benefit for you for next version.
Regards,
AnDim said:
Hive and registry file editor 2.0.035 (C) 2009 AnDim
A command line utility to work with hv files.
Full Unicode support, and more.
!!! WARNING !!!
Do not use CeRegEditor (cereg) to work with .hv !!!
!!! WARNING !!!
Usage:
HVEdit.exe <rgu>|<dump>|<hive>|<hvm> [-r] [<outputdir>]
<rgu> Build boot.hv from rgu file.
<dump> Build default.hv and user.hv from project folder.
<hive> Output hive file contents to the <hivename.hvm> text file.
<hvm> Build hive file from hvm file.
-r Don't insert *.rgu hash value to the hive.
Release history:
---------------------
V. 2.0.035
+ Extract hive to the .hvm text file.
+ Build hive from .hvm file.
V. 1.0.000 (Initial Release)
(C) 2009 AnDim
Click to expand...
Click to collapse
This seems to be JUST what I am looking for .... but I am having problems trying to use I suspect is simply a case of finger-trouble on my part, so will greatly appreciate any help available from AnDim or any other users who can point me in the right direction, please.
I think I correctly understand the command line syntax and have run HVEdit to unpack a default.hv registry file taken from a dumped ROM (Toshiba TG01). I then made some basisc edits to the resulting .hmv file and used HVEdit again to recompile back to .hv.
When the ROM is recompiled and flashed it refused to boot. So I went back and tried using HVEdit to convert to .hmv and back without making any changes. Same problem.
I have attached the .bat files i used to run for reference....View attachment 305797
I have been reading about a need to insert REGEDIT4 at the start of the file; have tried doing so but that just results in an error.
Any guidance will be greatly appreciated
Request Response !!
Is anyone able to offer any assistance on this question please
Help will be much appreciated !
kevinpwhite said:
This seems to be JUST what I am looking for .... but I am having problems trying to use I suspect is simply a case of finger-trouble on my part, so will greatly appreciate any help available from AnDim or any other users who can point me in the right direction, please.
I think I correctly understand the command line syntax and have run HVEdit to unpack a default.hv registry file taken from a dumped ROM (Toshiba TG01). I then made some basisc edits to the resulting .hmv file and used HVEdit again to recompile back to .hv.
When the ROM is recompiled and flashed it refused to boot. So I went back and tried using HVEdit to convert to .hmv and back without making any changes. Same problem.
I have attached the .bat files i used to run for reference....View attachment 305797
I have been reading about a need to insert REGEDIT4 at the start of the file; have tried doing so but that just results in an error.
Any guidance will be greatly appreciated
Click to expand...
Click to collapse

[App] RGUber v1.21a, RGUOrder v1.4

Purpose:
This purpose of this VBScript is to process and organize data in RGU/REG files to remove duplicates, identify faulty entries, and move entries to ascending alphabetical order (the same way it is displayed in a registry editor).
Requirements:
Windows Scripting Host (included in most versions of windows)
rgucomp.exe and cereg400.dll located somewhere in your path (same folder as the script probably won't work if the script is run from another folder)
.reg and .rgu files are expected to be UTF-16LE with BOM
Usage:
Drag a .rgu, .reg, or .hv onto RGUber.vbs OR run "wscript.exe RGUber.vbs example.rgu"
Details:
When an rgu|reg file is specified, RGUber will:
1) create backup of input file
2) rename input file to boot.rgu
3) use rgucomp to convert it to *.hv
4) use rgucomp to convert new .hv to original rgu path\name
5) Reorder all keys in ascending alphabetical order and all values for each key in ascending alphabetical order with default value first
When an hv file is specified, RGUber will:
1) use rgucomp to convert it to *.rgu
2) Reorder all keys in ascending alphabetical order and all values for each key in ascending alphabetical order with default value first
Options
Open RGUber.vbs in your favorite text editor. All options are set at the beginning with (hopefully) meaningful descriptions.
Code:
'//Path to rgucomp (leave this as default if rgucomp.exe is located in your system path)
Const RGUCOMP = "rgucomp.exe"
'//Path to notepad, only needed if %OPENAFTER% is true
Const NOTEPAD = "notepad.exe"
'//The following options can be set to True/False or 0/1
'//Organize registry entries in ascending alphabetical order
Const REORDER = True
'//Open in %NOTEPAD% after conversion is done
Const OPENAFTER = False
'//Save any errors from rgu -> hv conversion
Const LOGERRORS = True
'//Save a backup copy of %INPUTRGU% as "%INPUTRGU%_Backup.rgu"
Const BACKUPRGU = True
Other info
If target file already exists, RGUber will ask if you want to overwrite.
Text files (the MS way) typically contain CRLF for next line. Output from rgucomp.exe contains many CRCRLF. RGUber removes the extra CR.
I have very few comments in the code. If requested, I will upload another copy with as many detailed comments as I can manage.
I tried to code this as efficiently as VBScript can possibly be. I kept getting errors when trying to run 'rgucomp.exe -b -nologo' so instead of running it directly, RGUber creates a bat file, executes it, then deletes it.
On my AMD Phenom 9600 with Vista64 and 3 SATA in Raid5, RGUber completes rgu->hv->rgu of 2084 lines in <3s
RGUber always saves output from rgu->hv conversion but deletes the file if there were no errors.
RGUber crashes on files with no reg entries (e.g. empty app.reg in an EXT package that does not add any registry entries)
Changelog:
v1.21a
Values are now sorted in alphabetical order for each key
v1.2
Replaced Organize function with one from RGUOrder
Lost ability to reorder values for each key (To be readded in next version)
v1.1
Fixed a bug with removing hashdata from output (RGUber would mix data from two keys under one)
Changed sorting algorith with a much faster one
v1.02
Added option to remove RegistryUpdate key from rgucomp output
Fixed a typo where RGUber was not removing the system attribute from input rgu files
v1.01
Fixed typo where RGUber was waiting for backup file instead of log file
Change 'Done' msgbox to one that shows beginning time and ending time
v1.0
Initial Release
RGUOrder v1.4
This script will only reorder the contents of an rgu without processing with RGUComp, thereby keeping comments and delete key entries. RGUComp/cereg400.dll are not needed to use this app.
Changelog:
v1.4
Fixed a bug where if the original rgu did not end with a new line then the last entry after being sorted would be lost.
Fixed two bugs where only the first 25 tabs and first 25 spaces would be removed before sorting (This did not affect data integrity or performance, but the checksum would be different each time you run the output back through RGUOrder until all the original tabs/spaces were removed)
Added code to prevent multiple entries of the same key from being reordered
Fixed other miscellaneous bugs/oddities introduced with v1.3
v1.3
Added code to add a delete key for each subkey of a deleted key so that when reordered, the key deletion isn't broken
v1.2
Fixed a bug where the last key processed was being concatenated to another with no CRLF producing an invalid rgu file
I'm not sure if this relates to your app but I have a small question:
If a dumped a rom (raw, not kitchen type) and removed several apps/programs but did not clean the registry (very tedious), will this help me clean it up (remove dead paths, etc)?
And if so, how will it know just by dragging the .hv file? I mean how will your app know if a registry entry does not have the app/program included in the rom anymore?
Please forgive me if my question does not relate to your app
There is no way for my app to know, it isnt that smart
It would take an extensive app/database to know which keys are related to which apps.
Thanks for this post
updated to v1.1
v1.02 had a bug in the code which removed hash data from output which made it mix data from the key before it with the key after it
If I ever get around to updating again, I will use hvedit instead of rgucomp
I get an error.
Script: D:\RGUber.vbs
Line: 136
Char: 2
Error: File not found
Code: 800A0035
Source: Microsoft VBScript runtime error
Any reason why?
I attach the file i want to sort alphabetically.
I have no idea
It worked for me with no problem (file attached)
Please tell me the location of RGUber.vbs and of 51329f91-0017-4364-bcff-e032c5d45b01.rgu
Great application bro!!
Only limitation is that I have to put reg400.dll and rgucomp in C:\windows
c_shekhar said:
Great application bro!!
Only limitation is that I have to put reg400.dll and rgucomp in C:\windows
Click to expand...
Click to collapse
yeah, I tried to get around that but I didn't find anything feasible with vbscript :-/
Actually, they don't have to go in C:\windows
I reinstall windows regularly so I keep as many apps portable as I can. I have a bin folder on another partition that I add to the system path variable after a new install for stuff like this.
selyb said:
yeah, I tried to get around that but I didn't find anything feasible with vbscript :-/
Actually, they don't have to go in C:\windows
I reinstall windows regularly so I keep as many apps portable as I can. I have a bin folder on another partition that I add to the system path variable after a new install for stuff like this.
Click to expand...
Click to collapse
can you elaborate this a bit more. Because I too would like a similar arranfements...
My C:\ partition has Vista64
My F:\ partition has all my documents, downloads, music, movies, etc and a folder F:\bin\
F:\bin contains >100 downloaded command line programs and vbs scripts that I have written including
RGUber.vbs
lame.exe
rgucomp.exe
cereg400.dll
FixVTS.exe
faad.exe
nuerecmod.exe
Tag.exe
find Advanced System Properties (I can't remember how, it's different for XP/Vista/7) go to the Advanced tab and hit the Environment Variables button
Under system variables, scroll down to 'Path', double click it. This defines your 'system path'. It contains a list of folders separated by semicolon ";". At the end, add a semicolon and the path to the folder you want to add (e.g. ;F:\bin) after that, hit ok. XP may need to reboot to reflect the change but I'm not sure. Vista and 7 are affected immediately.
With this setup, you can open a command prompt in any folder on your computer and type "RGUber.vbs xyz.rgu" and it would work as if all the files are in that folder.
Thanks a lot bro!!!
I am grateful...
I'd really like to use this, but unfortunately I get this error regardless of the app.reg I drag onto the script:
Script: C:\RGUber\RGUber.vbs
Line: 232
Char: 3
Error: The system cannot find the path specified.
Code: 80070003
Source: (null)
Thanks if you can advise.
Quetzecotyl said:
I'd really like to use this, but unfortunately I get this error regardless of the app.reg I drag onto the script:
Script: C:\RGUber\RGUber.vbs
Line: 232
Char: 3
Error: The system cannot find the path specified.
Code: 80070003
Source: (null)
Thanks if you can advise.
Click to expand...
Click to collapse
Hmmm... this line asks the system for what is in the %temp% variable and attempts to change the working directory to the result.
Open RGUber.vbs in notepad and go to line 232
Modify
Code:
WSH.CurrentDirectory = WSH.Environment("SYSTEM")("temp")
to
Code:
WSH.CurrentDirectory = "C:\RGUber\"
then try again
Works great after your fix, selyb. Thank you for this useful app and your many helpful contributions to the Kaiser forums.
Quetzecotyl said:
Works great after your fix, selyb. Thank you for this useful app and your many helpful contributions to the Kaiser forums.
Click to expand...
Click to collapse
Yeah, I may relocate from Kaiser forums to Rhodium. I have an AT&T Tilt 2 in the mail to me ATM
Grats on getting a Rhodium. Found a question after using it for a while. This is just one example of such behavior, but why does:
Code:
[HKEY_CURRENT_USER\Software\HTC\TaskManager\ExclusiveList\System]
"CMBandSwitching.exe"=dword:0
get turned into:
Code:
"CMBandSwitching.exe"=dword:0
How do I make it regard CURRENT_USER keys?
Quetzecotyl said:
Grats on getting a Rhodium. Found a question after using it for a while. This is just one example of such behavior, but why does:
Code:
[HKEY_CURRENT_USER\Software\HTC\TaskManager\ExclusiveList\System]
"CMBandSwitching.exe"=dword:0
get turned into:
Code:
"CMBandSwitching.exe"=dword:0
How do I make it regard CURRENT_USER keys?
Click to expand...
Click to collapse
I had this problem with an earlier version. If you are using v1.1 then please attach the original rgu/reg. I have tried and I can't seem to reproduce it since I fixed it already.
Please, replace rgucomp with hvedit . I really need your help because rgucomp doesn't work for me . Thanks in advance .
tomcug said:
Please, replace rgucomp with hvedit . I really need your help because rgucomp doesn't work for me . Thanks in advance .
Click to expand...
Click to collapse
why doesn't rgucomp work? I would be surprised to learn that hvedit will work when rgucomp won't.

Russian Daylight Saving Time changes

Hi guys.
First, some sidenotes:
1) I'm not sure where this post belongs. I hope moderator will move it accordingly
2) I'm not able to post urls, so please replace hxxp:// in those links below with http//. I will fix that as soon as the forum lets me. ​
Russia has changed its DST rules this year. All time zones are shifted +1 hour and DST is now disabled. To reflect those changes under WM we need to edit registry a little.
HKEY_LOCAL_MACHINE\Software\Microsoft\TimeZones\ is a key that allows to override timezone info. So, you need to create a subkey, which name will be the time zone index needed to change. Time zone indexes could be looked up here: hxxp://msdn.microsoft.com/en-us/library/ms912053.aspx
Here is an example for Moscow time zone (MSK). It's index is 145
Code:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\Software\Microsoft\TimeZones\[B]145[/B]]
"Display"="GMT+4 Moscow"
"Dlt"="Russian Daylight Time"
"Std"="Russian Standard Time"
"TZI"=hex:\
10,ff,ff,ff,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00
Where do you obtain this? There are two ways:
1) The easy one. If you already installed MS updates on your PC, its registry already contains all that we need. Go under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones\ and select appropriate key. (for Moscow it's under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones\Russian Standard Time). Export it and import to the device with your favorite registry editor (I use TotalCommander).
2) The hard one. Write it by yourself. OK...
All the fields are self-explanatory except TZI. Let's take a closer look on that. According to MSDN hxxp://msdn.microsoft.com/en-us/library/windows/desktop/ms725481%28v=vs.85%29.aspx, it's contains REG_TZI_FORMAT structure:
Code:
typedef struct _REG_TZI_FORMAT
{
LONG Bias;
LONG StandardBias;
LONG DaylightBias;
SYSTEMTIME StandardDate;
SYSTEMTIME DaylightDate;
} REG_TZI_FORMAT;
Bias is the offset in minutes, so that UTC = local time + bias
Since Moscow is UTC+4, the bias should be -4 hrs = -240 mins. -240 is 0xFFFFFF10 in hex, hence first 4 bytes of TZI are 10,ff,ff,ff
StandardBias is the bias during standard time (when DST don't apply): UTC = local time + bias + standard bias. So, it should be zero.
DaylightBias is the bias during daylight time: UTC = local time + bias + daylight bias. Should be zero for current Russian DST rules
Those two SYSTEMTIME fields contain dates when DST applies. They should be zero in our case. You can refer to the above link for details, if curious.
So, all you need to do is to just fill 4 first bytes with proper values.
OK, after registry is changed, you should be immediately able to see new time zone in clock settings. If that is not the case, try rebooting your device.
Now, maybe someone will create a cab for all Russian timezones... that would be nice.
---
Now Manila aka HTC Sense is the whole different story. It has its own city database with UTC offsets. The file in question is \Windows\2330fc3c_manila. This is actually an SQLite database file, so it can be edited easily. I use SQLite Database Browser (hxxp://sqlitebrowser.sourceforge.net), which is free. You can also use sqlite native console client.
So, you need to copy that file to the PC, find your city and change its timezone field. The file is in ROM, so you need a proper file manager to do that (TotalCommander is OK). E.g. for Moscow you should change -180 (UTC+3) to -240 (UTC+4).
Before writing the file back, Manila should be disabled. This can be done under Today settings (second tab, uncheck 'HTC Sense'). Replace the file and then enable Manila again.
I'll attach the patched file for HTC Rhodium aka TouchPro2. I'm not sure if it will suit other device or even other ROM on same device. Mine is T-Mobile v1.91.531.4
Thanks for the tip. I tried to this for my HD2 (WM6.5.3) and found out there is no TimeZones branch in the registry. And there is no \Windows\2330fc3c_manila file. There is a lot other *_manila files in Windows folder though. How did you find out which one contained timezone data?
rugubara said:
Thanks for the tip. I tried to this for my HD2 (WM6.5.3) and found out there is no TimeZones branch in the registry.
Click to expand...
Click to collapse
Please, read the post carefully. The TimeZones branch is on your PC!
rugubara said:
And there is no \Windows\2330fc3c_manila file. There is a lot other *_manila files in Windows folder though. How did you find out which one contained timezone data?
Click to expand...
Click to collapse
For Manila file guide please go here: http://forum.xda-developers.com/wiki/Manila_Files. If the file is missing - there is a good chance you don't need to do anything on Manila part.

Categories

Resources