Database Users

[Request] Chinese sort&search in contacts&dial up

for us use chinese, is there anybody can help to fix to sort&search Chinese in contacts&dial up on Nexus one or Android 2.1 ?
HTC, can search contact when input number in dial up. CM Rom can not .

http://www.androidin.net/bbs/thread-49607-1-1.html

http://www.androidin.net/bbs/viewthread.php?tid=46916&highlight=

yungjoe said:
http://www.androidin.net/bbs/viewthread.php?tid=46916&highlight=
Click to expand...
Click to collapse
thanks a lot. and i made this post, not perfect ^_^
http://www.androidin.net/bbs/thread-49607-1-1.html
but i meet some problem that i can not search chiese name by english alphabet. HTC Hero's contacts is good, any one ported ?

*** link deleted ***

hengsin said:
http://www.tigersw.cn/soft15633.html
Click to expand...
Click to collapse
please remove the link or prepared to be banned

Sorry to go off-topic, but why will he be banned because of the link? Non-English?

by replace the libsqlite.so libcudata.so can display sorted chinese contact .
below is the way to add function search by name, but it is for android 1.6. I found the contacts.db is different from Android 2.1.
no "pepole persons contact_methods" tables
only "contacts name_lookup phone_lookup"
i did not understand the co-relation beside these tables, some guy can help to change below scripts on Android 2.1 ??
Thanks very much.
Android 2.1 contacts2.db
PHP:
sqlite> .tables
.tables
_sync_state status_updates
_sync_state_metadata v1_settings
activities view_contacts
agg_exceptions view_contacts_restricted
android_metadata view_data
calls view_data_restricted
contact_entities_view view_groups
contact_entities_view_restricted view_raw_contacts
contacts view_raw_contacts_restricted
data view_v1_contact_methods
groups view_v1_extensions
mimetypes view_v1_group_membership
name_lookup view_v1_groups
nickname_lookup view_v1_organizations
packages view_v1_people
phone_lookup view_v1_phones
raw_contacts view_v1_photos
settings
sqlite> .schema contacts
.schema contacts
CREATE TABLE contacts (_id INTEGER PRIMARY KEY AUTOINCREMENT,display_name TEXT,p
hoto_id INTEGER REFERENCES data(_id),custom_ringtone TEXT,send_to_voicemail INTE
GER NOT NULL DEFAULT 0,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_cont
acted INTEGER,starred INTEGER NOT NULL DEFAULT 0,in_visible_group INTEGER NOT NU
LL DEFAULT 1,has_phone_number INTEGER NOT NULL DEFAULT 0,lookup TEXT,status_upda
te_id INTEGER REFERENCES data(_id),single_is_restricted INTEGER NOT NULL DEFAULT
0);
CREATE INDEX contacts_has_phone_index ON contacts (has_phone_number);
CREATE INDEX contacts_restricted_index ON contacts (single_is_restricted);
CREATE INDEX contacts_visible_index ON contacts (in_visible_group,display_name C
OLLATE LOCALIZED);
CREATE TRIGGER contacts_times_contacted UPDATE OF last_time_contacted ON contact
s BEGIN UPDATE contacts SET times_contacted = (new.times_contacted + 1) WHERE _i
d = new._id;END;
sqlite> .schema name_lookup
.schema name_lookup
CREATE TABLE name_lookup (data_id INTEGER REFERENCES data(_id) NOT NULL,raw_cont
act_id INTEGER REFERENCES raw_contacts(_id) NOT NULL,normalized_name TEXT NOT NU
LL,name_type INTEGER NOT NULL,PRIMARY KEY (data_id, normalized_name, name_type))
;
CREATE INDEX name_lookup_index ON name_lookup (normalized_name,name_type, raw_co
ntact_id);
CREATE INDEX name_lookup_raw_contact_id_index ON name_lookup (raw_contact_id);
sqlite> .schema phone_lookup
.schema phone_lookup
CREATE TABLE phone_lookup (data_id INTEGER PRIMARY KEY REFERENCES data(_id) NOT
NULL,raw_contact_id INTEGER REFERENCES raw_contacts(_id) NOT NULL,normalized_num
ber TEXT NOT NULL);
CREATE INDEX phone_lookup_index ON phone_lookup (normalized_number,raw_contact_i
d,data_id);
PHP:
echo 'Phase 1: Creating triggers...'
#Replace the offical trigger to index email address
sqlite3 contacts.db "DROP TRIGGER IF EXISTS peopleLookup_update;"
sqlite3 contacts.db \
"CREATE TRIGGER peopleLookup_update \
UPDATE OF name ON people \
BEGIN\
DELETE FROM peopleLookup WHERE source = new._id;\
SELECT _TOKENIZE('peopleLookup', new._id, new.name, ' ');\
SELECT _TOKENIZE('peopleLookup', new._id, data, '')\
FROM contact_methods\
WHERE person=new._id AND kind=1; \
END"
# Trig the peopleLookup_updats trigger
sqlite3 contacts.db "DROP TRIGGER IF EXISTS sunner_email_update;"
sqlite3 contacts.db \
"CREATE TRIGGER IF NOT EXISTS sunner_email_update \
AFTER UPDATE OF data ON contact_methods \
WHEN new.kind=1 \
BEGIN \
UPDATE people SET name=\`name\` WHERE _id=new.person; \
END"
sqlite3 contacts.db \
"CREATE TRIGGER IF NOT EXISTS sunner_email_insert \
AFTER INSERT ON contact_methods \
WHEN new.kind=1 \
BEGIN \
SELECT _TOKENIZE('peopleLookup', new.person, new.data, ''); \
END"

Change Dynamic PagePool to Static

Hi there.
Can somebody help me to change pagepool from dynamic to static (4MB or 6MB)?
I have iPAQ 110 with WM6.5.3 and dynamic pagepool uses a lot of memory, more than expected.
I have tried all tools available to change pagepool, but none of them work.
I have attached XIP.bin to this thread, maybe someone can take a look on it.
Thanks

can't you recook rom to set pp from 0mb(=dynamic) to any value?

pupakota said:
can't you recook rom to set pp from 0mb(=dynamic) to any value?
Click to expand...
Click to collapse
Most kitchens I tried say - PagePool not found or throws out error.

try this nk.exe - expected to be 6mb

now you know:

ultrashot said:
try this nk.exe - expected to be 6mb
Click to expand...
Click to collapse
Thanks ultrashot, but this does not work. Pagepool is dynamic same as before.
Sorry I couldn't reply sooner, as I tried it only now.

Pagepool is dynamic same as before.
Click to expand...
Click to collapse
proof, please.

pupakota said:
proof, please.
when you are not using limiters of SD CACHE, system cache, how can you tell(having WORST PDA ever made)?
buy normal device(never HTC) or learn basics, first.
Click to expand...
Click to collapse
I like to play with old devices and I don't need any other new one.
Total RAM is 57.86MB same as before. If it would work it should be around 51MB (6MB pagepool).

Vermillion said:
I like to play with old devices and I don't need any other new one.
Free RAM is 57.86MB same as before. If it would work it should be around 51MB (6MB pagepool).
Click to expand...
Click to collapse
57.86 mem free on this device?
please, post screenshot i am first to buy one, if it is true.
which kitchen are you using to make your roms?

I use OSBuilder and if I set pagepool location manually in nk section 2 and at offset 0x340 OSBuilder finds it and can change it, but there is no effect on device.
Here's a report from DevHealth as you can see pagepool is 0 (Dynamic).
Code:
Physical RAM (consumers breakdown) | 14931 | 61157376 | 58.32 | n/a
Kernel Prealloc. | 83 | 339968 | 0.32 | 0x802ac000 - 0x802fefff
Paging Pool | 0 | 0 | 0.00 | ?
Kernel RAM Map | 1 | 4096 | 0.00 | 0x802ff000 - 0x802fffff
Watson Size | 32 | 131072 | 0.13 | 0x83cdf000 - 0x83cfefff
Pagepool is somehow disabled. If I use Multiplatform PagePool Changer it can't find it.
Pagepool Changer is looking for something which it can't find, but I don't know what it is.

It means page pool value gets overrode in code

Pagepool Changer is looking for something which it can't find, but I don't know what it is.
Click to expand...
Click to collapse
crucial words, interesting issue.
i'll try to investigate, 'caue it is interesting(i never used ANY of new kitchens made for HTC mainly, and tools made for NORMAL machines are just...working).
btw sorry for my earlier attitute.

Did you check OSBuilder advanced settings "Set KernelFlags"?
MSDN reports:
0x00000001 = Demand paging is disabled.
When OSBuilder starts up it should report the settings in the ROM template, like this:
Code:
XIP (Template\<XIP>):
PP(Mb) : 8 (offset: 0x0005D558)
KERNEL : WM6.1
dllFirst : 0x01FE01FE (Lo=0x01FE0000; Hi=0x01FE0000)
dllLast : 0x02000000
physFirst : 0x8C080000
physLast : 0x8C2295D8
modules : 21
RAMStart : 0x8C230000
RAMFree : 0x8C290000
RAMEnd : 0x8FD80000
CopyEntries : 1
CopyOffset : 0x8C0DDFEC
ProfileLength : 0x00000000
ProfileOffset : 0x00000000
files : 8
[COLOR="Red"] KernelFlags : 0x00000002[/COLOR]
FSRamPercent : 0x00000004
DrivglobStart : 0x00000000
DrivglobLength : 0x00000000
CPUType : 0x01C2 (ARMV4I)
MiscFlags : 0x0002
pExtensions : 0x8C0827EC
TrackingStart : 0x00000000
TrackingLength : 0x00000000
So if you see the value of 1 there this should explain your observed behavior. Change that with OSBuilder advanced settings "Set KernelFlags" to either 0 or 2.

[Q] help creating mount point

hello I need more information, i'm a novice in creating a ROM I want to create files for the mount points for the Nexus 7
is anyone can help me to get the correct file for the kitchen I have this but I think there are errors
Group #
change_mnt = yes
param1 = ext4
param2 = EMMC
param1_sdcard = vfat
param2_sdcard = BAT
sys_mnt = \ / dev \ / block \ / mmcblk0p25
cache_mnt =???
boot_mnt = \ / dev \ / block \ / mmcblk0p22
data_mnt = \ / dev \ / block \ / mmcblk0p29
sdcard_mnt = \ / dev \ / block \ / mmcblk1p1

Lumia 520 unbrickeable with android

Hello! I tried to install android 7 on lumia 520 but it get bricked with the screen off and it does a little vibrate and nothing happens then. And in the admin of devices appeared android bootloader interface, and when i unistall this and put the phone via usb again, it installed again and for this reason i cant restore with any nokia software cuz the phone isnt recognized
Any help pls? Thx!

you phone not brick

Hello
Like this friend when I installed Android on the Lumia 525 I encountered this problem and when uefi2lk was running, the connection was disconnected, but I tried again, but I encountered this error.
This flasher is for x86 (32bit) Windows, Installer for Lumia 525/526 (glee)
If you do not have a full backup of your phone yet, stop right here
Press any key to continue. . .
Are you REALLY sure you backed it up?
Press any key to continue. . .
Okay, do not blame me if something goes wrong
Press any key to continue. . .
Make sure there are no other phones connected to the PC
Disconnect every Android and Windows based device
Turn your phone off
Remove and re-insert the battery
Connect it to the PC after pressing ENTER
Press any key to continue. . .
THOR2 1.8.2.18
Built for Windows @ 13:36:46 Jun 16 2015
Thor2 is running on Windows version 6.2
C: \ Program Files \ Microsoft Care Suite \ Windows Device Recovery Tool \ thor2.exe -mo
de rnd -asciimsgreq NOKD -asciimsgresp NOKD -skip_com_scan
Process started Thu Apr 19 19:10:03 2018
Logging to file C: \ Users \ mbm1 \ AppData \ Local \ Temp \ thor2_win_20180419191003_Thread
Id-1208.log
Initiating do RnD operations
WinUSB in use.
Debugging enabled for rnd
Starting to handle ASCII message
Connection not found.
THOR2_ERROR_CONNECTION_NOT_FOUND
THOR2 1.8.2.18 exited with error code 84000 (0x14820)
THOR2 1.8.2.18
Built for Windows @ 13:36:46 Jun 16 2015
Thor2 is running on Windows version 6.2
C: \ Program Files \ Microsoft Care Suite \ Windows Device Recovery Tool \ thor2.exe -mo
de thor2 -mode uefiflash -partitionname UEFI -partitionimagefile DATA \ EMMCBOOT.m
bn
Process started Thu Apr 19 19:10:33 2018
Logging to file C: \ Users \ mbm1 \ AppData \ Local \ Temp \ thor2_win_20180419191033_Thread
Id-1724.log
Debugging enabled for partitionimageflash
Initiating a flash of partition image operations
WinUSB in use.
Operation took about 30.00 seconds.
THOR2_ERROR_CONNECTION_NOT_FOUND
THOR2 1.8.2.18 exited with error code 84000 (0x14820)
THOR2 1.8.2.18
Built for Windows @ 13:36:46 Jun 16 2015
Thor2 is running on Windows version 6.2
C: \ Program Files \ Microsoft Care Suite \ Windows Device Recovery Tool \ thor2.exe -mo
de rnd -reboot
Process started Thu Apr 19 19:11:03 2018
Logging to file C: \ Users \ mbm1 \ AppData \ Local \ Temp \ thor2_win_20180419191103_Thread
Id-3516.log
Initiating do RnD operations
WinUSB in use.
Debugging enabled for rnd
Exited with success
<waiting for device>
creating a boot image ...
creating a boot image - 20480 bytes
downloading 'boot.img' ...
Okay [0.016s]
booting ...
OKAY [-0,000s]
finished total time: 0.016s
FAILED (command write failed (No such device or address))
<waiting for device>
And after this message, Windows closes the fastboot and closes the uefi2lk program and the mobile bulk is called Mainos, which only has 2.4gb of space, with a blank space of 585mb.
I just wanted to recover the phone through the resistor (power + vol up), but nothing happens, and the phone once vibrates and the screen is black.
please guide me
I am Persian and I am apologizing for this text with the help of the Google Translator. If it is a problem in the wording.
Thank you very much for reading my question

Migrate from Hard disk ( HD ) to SSD? Solved

Migrate from Hard disk ( HD ) to SSD? Solved​
Code:
[COLOR="Red"]Notification:
I am not responsible for any damage that may arise or that
you consider to have any connection to the mentioned
in this tutorial.
You only applied it by your own free will and because you
wanted to do!
Always perform a backup for security resons![/COLOR]
Hello my friends
How to migrate from hard drive to SSD?
To switch from hard disk to SSD I used 2 programs, MiniTool Partition Wizard and MiniTool ShadowMaker Free.
When i buyed the SSD it doesn,t not came with a defined partition and when i connected to the PC i don't see it on root. So i used the MiniTool Partition Wizard that detects it and managed to create an NTFS partition, then I used MiniTool ShadowMaker Free to clone the hard drive to the SSD, the rest of work is in the BIOS.
The only program that gave me an error was Office but using the installer and doing the repair it resolved (Office 2007).
And i already notice a difference in speed!!!
Let's speed up a little more by moving from IDE to AHCI!!!
If your BIOS has the AHCI option it will speed up the system more, but there is a trick!
If your installation is from Zero, just before installing the OS make the change in the BIOS from IDE to AHCI then install de OS but if it is already installed or as if you have cloned it will give an error and doesn´t boot.
That's how I solved it!
Open a text file and copy this commands (Windows 10) and paste it like this:
Code:
@echo off & @echo. & @echo.
rem remove old lines
powershell.exe remove-ItemProperty -Path 'HKLM:\SYSTEM\CurrentControlSet\services\iaStorV' -Name Start
powershell.exe remove-ItemProperty -Path 'HKLM:\SYSTEM\CurrentControlSet\Services\iaStorV\StartOverride' -Name 0
powershell.exe remove-ItemProperty -Path 'HKLM:\SYSTEM\CurrentControlSet\Services\storahci' -Name Start
powershell.exe remove-ItemProperty -Path HKLM:\SYSTEM\CurrentControlSet\Services\storahci\StartOverride -Name 0
pause
rem default value for this lines is 3
powershell.exe New-ItemProperty -Path HKLM:\SYSTEM\CurrentControlSet\services\iaStorV -Name Start -PropertyType dword -Value 0
powershell.exe new-ItemProperty -Path HKLM:\SYSTEM\CurrentControlSet\Services\iaStorV\StartOverride -Name 0 -PropertyType dword -Value 0
powershell.exe new-ItemProperty -Path HKLM:\SYSTEM\CurrentControlSet\Services\storahci\StartOverride -Name 0 -PropertyType dword -Value 0
powershell.exe new-ItemProperty -Path 'HKLM:\SYSTEM\CurrentControlSet\Services\storahci' -Name Start -PropertyType dword -Value 0
pause
Save the file as a bat, create a system restore point and then run it as an administrator, restart PC in to BIOS, change from IDE to AHCI and restart 2x, in the first windows will install the disks and in the second it is safe to work.
With me it worked very well to the point that the PC starts faster than the TV takes to turn on ... :laugh:
I hope i helped you in some way! :highfive:
.