Bookmark and Share
About
Features
Blog
Documentation
Support
Welcome Guest Search | Active Topics | Members | Log In | Register

3 Pages123>
Post your Modifications, Patches, Themes and Language Files In This Forum
Options View
Previous Topic Next Topic
Jaben Offline
#1 Posted : Wednesday, December 20, 2006 7:32:13 PM(UTC)

Rank: YAF Head Dude

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 4,152
Location: Raleigh, NC

Thanks: 35 times
Was thanked: 94 time(s) in 49 post(s)
Welcome to the Modifications and Patches Forum

This is the only forum that allows file uploading (max 5 megs).

Please enhance the YAF community by posting your:

  • Modifications
  • Bug fixes/Patches
  • Smiles Packs
  • Avatars Packs
  • Themes
  • Updated Language Files

    If you are posting a Theme please attach a screen shot of the theme. For all items explain WHICH version of YAF they are designed for.

    Thanks!

    -Jaben
    "I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

    • Back to top
    BLOG
     |  Edit by user
    Jaben Offline
    #2 Posted : Wednesday, December 20, 2006 7:48:30 PM(UTC)

    Rank: YAF Head Dude

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

    Joined: 10/9/2004(UTC)
    Posts: 4,152
    Location: Raleigh, NC

    Thanks: 35 times
    Was thanked: 94 time(s) in 49 post(s)
    How do you post a file?

    First, create a new topic like usual and click "Post". Then, after your new topic has been created, you click the "Attach" button on your new post. From there, you can easily upload multiple files.
    "I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

    Back to top
    BLOG
    alii Offline
    #3 Posted : Wednesday, July 23, 2008 12:10:14 AM(UTC)
    Rank: YAF Forumling

    Joined: 7/22/2008(UTC)
    Posts: 1
    Location: Land of Fire

    Thanks: 0 times
    Was thanked: 0 time(s) in 0 post(s)
    Where can I have file for translating from English?
    Back to top
    bbobb Online
    #4 Posted : Sunday, January 18, 2009 10:18:16 AM(UTC)


    Rank: YAF Developer

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 647
    Location: Moscow

    Thanks: 19 times
    Was thanked: 77 time(s) in 69 post(s)
    Simply patch for data layer.
    Back to top
    bbobb Online
    #5 Posted : Sunday, January 18, 2009 10:20:26 AM(UTC)


    Rank: YAF Developer

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 647
    Location: Moscow

    Thanks: 19 times
    Was thanked: 77 time(s) in 69 post(s)
    Simply patch for data layer.
    File Attachment(s):
    sp_report_copyover.diff.zip (1kb) downloaded 73 time(s).
    Back to top
    bbobb Online
    #6 Posted : Friday, January 23, 2009 4:36:31 PM(UTC)


    Rank: YAF Developer

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 647
    Location: Moscow

    Thanks: 19 times
    Was thanked: 77 time(s) in 69 post(s)
    A patch to begin separate data layer remnants from core code(harmless one).
    On applying, the /YetAnotherForum.Net/ folder will be completly cleared from MS SQL database code. And it's completly safe and tested.
    After this all the DB related code should be separated at lastVery Happy .
    File Attachment(s):
    data_layer_separation4.patch.zip (7kb) downloaded 31 time(s).
    Back to top
     |  Edit by user
    bbobb Online
    #7 Posted : Sunday, February 01, 2009 1:32:02 AM(UTC)


    Rank: YAF Developer

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 647
    Location: Moscow

    Thanks: 19 times
    Was thanked: 77 time(s) in 69 post(s)
    Missing conversion hacks for other data layers
    File Attachment(s):
    universal_casts_for_other_datalayers_r1.txt (3kb) downloaded 34 time(s).
    Back to top
    RavenDev Offline
    #8 Posted : Thursday, February 12, 2009 5:14:08 PM(UTC)
    Rank: YAF Forumling

    Joined: 2/12/2009(UTC)
    Posts: 2
    Location: Vilnius

    Thanks: 0 times
    Was thanked: 0 time(s) in 0 post(s)
    Lithuanian Language

    my forum at web adress www.ravendev.lt/forum


    File Attachment(s):
    lithuanian.xml (39kb) downloaded 14 time(s).
    Back to top
    WWW
    test2005 Offline
    #9 Posted : Friday, February 13, 2009 5:33:28 PM(UTC)


    Rank: YAF MVP

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.

    Joined: 2/11/2005(UTC)
    Posts: 1,032
    Location: Italy

    Thanks: 0 times
    Was thanked: 1 time(s) in 1 post(s)
    RavenDev wrote:
    Lithuanian Language

    my forum at web adress www.ravendev.lt/forum




    Thanks for the contribution! Smile
    .....the man in black fled across the desert..........and the gunslinger followed.....

    Back to top
    WWW
    RavenDev Offline
    #10 Posted : Sunday, February 15, 2009 5:17:34 PM(UTC)
    Rank: YAF Forumling

    Joined: 2/12/2009(UTC)
    Posts: 2
    Location: Vilnius

    Thanks: 0 times
    Was thanked: 0 time(s) in 0 post(s)
    from my forum you can get image files with Lithuanian language
    Back to top
    WWW
    bbobb Online
    #11 Posted : Tuesday, February 17, 2009 1:30:56 AM(UTC)


    Rank: YAF Developer

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 647
    Location: Moscow

    Thanks: 19 times
    Was thanked: 77 time(s) in 69 post(s)
    The proposed patch to make all data layers almost safe proof compatable in future.
    It's for MS SQL data layer, but the only difference is in the DBAccess.cs file and class CoolCoverter.
    For MySQL it reads for any data layer like this^
    Quote:

    public static class CoolConverter
    {
    public static int VerifyInt32(object value)
    {
    if (value == DBNull.Value) return 0;
    return Convert.ToInt32(value);
    }
    public static bool VeryfyBool(object value)
    {
    if (value == DBNull.Value || value.ToString() == "0"Wink return false;
    if ( value.ToString() == "1"Wink return true;
    return Convert.ToBoolean(value);
    }
    }

    For postgreSQL it's like this
    Quote:
    public static class CoolConverter
    {

    public static int VerifyInt32(object o)
    {
    //if (o == DBNull.Value || o =="f" ) o = 0;
    // if (o == "t"Wink o = 1;
    return Convert.ToInt32(o);
    }
    public static bool VeryfyBool(object o)
    {
    if (o.ToString() == "t"Wink { return true; }
    if (o.ToString() == "f"Wink { return false; }
    return false;
    }
    }

    For MS SQL Server it's simply
    Quote:
    public static class CoolConverter
    + {
    + public static int VerifyInt32(object o)
    + {
    + return (int)o;
    + }
    + public static bool VeryfyBool(object o)
    + {
    + return (bool)o;
    + }
    + }


    In the last case it's much more faster than using Convert.ToInt32 or Convert.ToBool Wink
    Back to top
     |  Edit by user
    Jaben Offline
    #12 Posted : Tuesday, February 17, 2009 7:03:03 PM(UTC)

    Rank: YAF Head Dude

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

    Joined: 10/9/2004(UTC)
    Posts: 4,152
    Location: Raleigh, NC

    Thanks: 35 times
    Was thanked: 94 time(s) in 49 post(s)
    On little thing... I have to change the name to "SqlDataLayerConverter".

    CoolConverter just isn't proper naming for the class.

    Thank you for all your help though, bbobb.
    "I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

    Back to top
    BLOG
    bbobb Online
    #13 Posted : Tuesday, February 17, 2009 9:33:17 PM(UTC)


    Rank: YAF Developer

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 647
    Location: Moscow

    Thanks: 19 times
    Was thanked: 77 time(s) in 69 post(s)
    Jaben wrote:
    On little thing... I have to change the name to "SqlDataLayerConverter".
    CoolConverter just isn't proper naming for the class.

    No matter, it was a temporary example class name anyway. I wait while it appears and verify data layers again to avoid any possible bugs.
    Thanks that you found time for itSmile
    Back to top
    bbobb Online
    #14 Posted : Thursday, February 19, 2009 7:43:16 AM(UTC)


    Rank: YAF Developer

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 647
    Location: Moscow

    Thanks: 19 times
    Was thanked: 77 time(s) in 69 post(s)
    No, I was wrong.
    The class for MSSQL
    public static class SqlDataLayerConverter
    + {
    + public static int VerifyInt32(object o)
    + {
    + return (int)o;
    + }
    + public static bool VeryfyBool(object o)
    + {
    + return (bool)o;
    + }
    + }
    doesn't work, because unboxing doesn't work safe in the case though it's fast.
    Convert.To... should be used anywayCrying or Very sad
    This makes boxing of DataRow value which is already filled by a value.
    I was somehow completly sure that it should work.
    And it's impossible to make dynamic conversion class without code deep changing in many places.
    Sorry.
    Back to top
     |  Edit by user
    Jaben Offline
    #15 Posted : Thursday, February 19, 2009 9:23:42 AM(UTC)

    Rank: YAF Head Dude

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

    Joined: 10/9/2004(UTC)
    Posts: 4,152
    Location: Raleigh, NC

    Thanks: 35 times
    Was thanked: 94 time(s) in 49 post(s)
    Interestingly, I haven't applied the conversion code yet. So I'll just hold off for now. I did apply the data layer centralization changes.
    "I have a simple philosophy: Fill what's empty. Empty what's full. Scratch where it itches.”.

    Back to top
    BLOG
    Users browsing this topic
    Guest
    3 Pages123>
    Forum Jump  
    You cannot post new topics in this forum.
    You cannot reply to topics in this forum.
    You cannot delete your posts in this forum.
    You cannot edit your posts in this forum.
    You cannot create polls in this forum.
    You cannot vote in polls in this forum.

    YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
    Powered by YAF 1.9.4 RC4 | YAF © 2003-2010, Yet Another Forum.NET
    This page was generated in 0.257 seconds.